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

i'm having problems executing the query from the adminCP

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

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'satsfge_.user' doesn't exist

what would be causing this please

The period ( or whatever you call it) before user might be the problem - shows how much I know about coding.

lordofgun

02-14-2006 12:48 AM

Quote:

Originally Posted by Rickie3

i'm a little confused here,i have vbookie installed but am using the built in vcash,i dont have ucash installed,so what you are saying if i edit functions_vbookie.php i can integrate this to work with ebux?,if this is so would you care to give some more details please

Just do exactly what I said and then change vbookie to use ucash in the vbookie settings in your admincp(it will actually be using ebux).

It DOES work and is working flawlessly on my forums.

lordofgun

02-14-2006 12:49 AM

Quote:

Originally Posted by Frugal

See section 1 of this post

https://vborg.vbsupport.ru/showpost....postcount=1389

This will integrate vbookie and eBux far with less hassle than editing your vbookie files. Editing the vbookie files is only part of it, you still have to follow all of the steps in the post I linked to except the sql query. The main difference between the sql query method and the editing the functions_vbookie method is that the sql method you do once and it is done for good, the file editing method has to be done every time vbookie is updated.

Well the other difference is that the sql method is tried tested and confirmed, the file editing works in theory but hasn't worked in practice (likely due to the person changing too many instances of ucash).

Frugal

There is only one vbookie file to change and it's only 3 or 4 intances. No queries or screwing around the the database. Works flawlessly.

EDIT: In function_vbookie.php, do NOT change "vbookieucash" to "vbookieebux". Only change all instances of "ucash" to "ebux".

caimakale

02-14-2006 12:53 AM

Quote:

Originally Posted by lordofgun

There is only one vbookie file to change and it's only 3 or 4 intances. No queries or screwing around the the database. Works flawlessly.

If this works then it is definately the method I would recommend and use myself. Who knows what other hacks may come out in the future for eBux and if you are altering your table name it could cause some problems. I can't say 100% that it will, because at this point I don't know that it will.

shaynehammy

02-14-2006 12:55 AM

Quick question. I want my users to be able to able to change any admins custom titles if the users can afford it. However, admins seemed to be protected ...??

lordofgun

02-14-2006 12:57 AM

Quote:

Originally Posted by caimakale

Exactly. And it DOES work as long as you only change "ucash" and not "vbookieucash".

You can trust me, I'm a Bills fan. :D

kylek

02-14-2006 01:04 AM

Quote:

Originally Posted by lordofgun

Exactly. And it DOES work as long as you only change "ucash" and not "vbookieucash".

You can trust me, I'm a Bills fan. :D

Dumb question but here goes.

Does it matter which one you have installed first? I have ebux running but would need to install vbookie. I tried your method before but changed the vbookiecash so maybe thats why it didn't work. Will re upload vboolie and try again.

Rickie3

02-14-2006 01:11 AM

Quote:

Originally Posted by lordofgun

i was wondering could you please put the edits in for me the last thing i want to do is stuff things up lol

Ohiosweetheart

02-14-2006 01:14 AM

even tho she has PLENTY of points, and the usergroup permissions are set...
if she tries to purchase a gift, she gets this "You are not allowed to purchase this item" message.
She can't even bank any points.

Any idea what the problem could be?

lordofgun

02-14-2006 01:18 AM

Quote:

Originally Posted by Rickie3

i was wondering could you please put the edits in for me the last thing i want to do is stuff things up lol

here's mine:

All times are GMT. The time now is 04:03 AM.

Page 141 of 401

141

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04313 seconds Memory Usage 1,746KB 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 (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: