vb.org Archive - Major Additions - vbBux / vbPlaza v1.5.8 (Points + Store System)

ut oh.... a member is trying to buy a gift for another member. I have the cost set at 1000 points. It's telling her that she doesn't have enough points to perform this action. But she has over 5,000 points....

what can I do?

bashy

02-13-2006 08:44 PM

Hi..

I have just tried this and got this error...

Code:

Error



SQL-query :  



ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000' 



MySQL said: 





#1054 - Unknown column 'ebux' in 'user'

Any ideas please?
Is it cause its already been done?
If so... My Vbookie cash is still a seperate cash system, I was expecting it to
add all the vbookie cash to the ebux, no?

Quote:

Originally Posted by Ignignokt

Change the eBux field to ucash and then run the following SQL code:

Code:

 

ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'

Frugal

02-13-2006 08:57 PM

Quote:

Originally Posted by bashy

Hi..

I have just tried this and got this error...

Code:

Error

 

SQL-query : 

 

ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000' 

 

MySQL said: 

 

 

#1054 - Unknown column 'ebux' in 'user'

Any ideas please?
Is it cause its already been done?

Yes if you run the query a second time you will get that error because there is no longer an ebux field.

Quote:

If so... My Vbookie cash is still a seperate cash system, I was expecting it to add all the vbookie cash to the ebux, no?

You also need to go into the vbookie settings and enable ucash.

Frugal

bashy

02-13-2006 09:01 PM

It already is m8 :(
Should there still be Vbookie cash and ebux showing in the postbit?

Skyline_GT

02-13-2006 09:08 PM

I wonder are you planning to integrate paypal with this system?
buy points using real money??

Sooner95

02-13-2006 09:13 PM

Quote:

Originally Posted by Skyline_GT

everything in seconds.

oh.. lol

Request:

Can this be set up another way then? hehe.

I am having no luck with settign this..

Its based on seconds, like how many seconds till the end of the lotto?

I put in 302400, which is 1 week. But i get this date

Lottery Ends Approximately: 01-04-70, 07:00 AM

In the time active box, it has 604800, I assume means the lotto is up for 1 week?

Maybe i am just doing it wrong.

Ohiosweetheart

02-13-2006 09:28 PM

Quote:

Originally Posted by Ohiosweetheart

Never mind, I found the answer. She banked so many points she didn't have enough to do anything with, LOL.

Frugal

02-13-2006 09:33 PM

Quote:

Originally Posted by bashy

It already is m8 :(
Should there still be Vbookie cash and ebux showing in the postbit?

You also need to make sure your template edit is for ebux not vbookie, the vbookie postbit template edit only shows vbookies own money vCash.

In the postbit after

Code:

$vbphrase[posts]: $post[posts]

You should have

Code:

<br />

<a href="estore.php?do=donate&amp;userid=$post[userid]">$vbphrase[ebux_points]</a>: $post[points]<br />

$vbphrase[ebux_bank]: $post[bank]<br />

$vbphrase[ebux_total_points]: $post[totalpoints]<br />

You should not have

Code:

<if condition="$vboptions['vbookiecashon']">

                                                <br />vCash: $post[vbookie_cash]

                                                </if>

Providing ebux is set to use the field ucash, the query has been run to change the ebux field to ucash, vbookie has been set to use ucash, and the postbit has the ebux changes and not the vbookie changes, all should work.

Frugal

JsnakeJ

02-13-2006 09:52 PM

Quote:

Originally Posted by caimakale

I don't follow you. When you integrate with uShop, you are only copying he points in the uShop column to the eBux column. There is no actual integration that occurs. After you have done it once, all of your users points from uShop should now be in eStore and you can just leave that setting alone. I even went as far as going in my database after that and deleting all of the utt, ucash, ushop fields I could find. Did you change the table name to conform with vbookie or something?

Well there must be some error with my eBux then. When I don't use uCash it gives out no points to my users yet the forums settings are set to multiply 1 times x for replys yet it gives them no points.

caimakale

02-13-2006 09:52 PM

Quote:

Originally Posted by Sooner95

Its the unix time stamp. Basically in a nutshell it's the amount of seconds since 1/1/1970 and is a standard that is used when coding.

There is a simple conversion utility here. http://www.onlineconversion.com/unix_time.htm Just punch in the date and time you want and it will spit out the unix time stamp.

All times are GMT. The time now is 03:41 PM.

Page 138 of 401

138

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04518 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: