View Full Version : Store hack question
tarantulas
07-14-2005, 06:44 PM
Hi people,
I've installed store hack with vB2. Now, I upgraded to vB3 and store hack is no longer working.
Can I use your script to so-called upgrade the store hack? Will this script use the point from database of the old store hack?
Please give me some advice if anyone has it. I'd be really appreciate it.
tarantulas
Link14716
07-14-2005, 06:49 PM
Once installed, run these two queries:
ALTER TABLE user DROP uttpoints;
ALTER TABLE user CHANGE `storep` `uttpoints` DECIMAL(20, 2) NOT NULL;
tarantulas
07-14-2005, 07:35 PM
Hi Links, thanks for the reply.
um, I just installed the uShop and found out that I can specify the field used for point. so I change the field from uttponts to storep. :) easier than expected.
Link14716
07-14-2005, 07:45 PM
Hi Links, thanks for the reply.
um, I just installed the uShop and found out that I can specify the field used for point. so I change the field from uttponts to storep. :) easier than expected.
The only problem to that is the storep field doesn't support decimal numbers. Any amount that isn't an integer (like 0.25) is rounded to the nearest integer (same example means it rounds down to 0).
tarantulas
07-14-2005, 08:17 PM
The only problem to that is the storep field doesn't support decimal numbers. Any amount that isn't an integer (like 0.25) is rounded to the nearest integer (same example means it rounds down to 0).
ic. now, i changed to what you said.
well, another question.. how do I change the word "Points" to my own currency?
store hack allowed user to set it in admin panel..
bigcurt
07-14-2005, 09:00 PM
I could be very wrong so dont 100% take it from me..just try and see if it works :P I think it is these 2 phrases
I know its a phrase that does it, but I couldnt remember which..but then found these
ucs_points
ucs_points_lower
Link14716
07-14-2005, 09:09 PM
I could be very wrong so dont 100% take it from me..just try and see if it works :P I think it is these 2 phrases
I know its a phrase that does it, but I couldnt remember which..but then found these
ucs_points
ucs_points_lower
Those are the correct phrases. :)
bigcurt
07-14-2005, 09:17 PM
Nice, there is a first..I love being rite :)
tarantulas
07-14-2005, 10:14 PM
Those are the correct phrases. :)
i changed the phrases in "phrase" table of MySQL database, but it didn't change the display in the forum.
weird..
:speechless: it works now after I edited it in the admin..
it's weird that when I used SQL to edit it directly to the table, it didn't show up correctly..
bigcurt
07-14-2005, 11:06 PM
Try in admin CP? Its working fine for me.
Link14716
07-14-2005, 11:58 PM
i changed the phrases in "phrase" table of MySQL database, but it didn't change the display in the forum.
weird..
:speechless: it works now after I edited it in the admin..
it's weird that when I used SQL to edit it directly to the table, it didn't show up correctly..
Phrases are cached in a different location, so directly editing it by SQL won't work until the cache is updated.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.