you should be able to use $bbuserinfo[points] I THINK :)

I was so excited as I have been having this same problem. But when I made the changes you specified, I still have the same issue. Did you maybe fix any other issues with it?

Is it possible to change the name "points" to "cash" ? make it read as "cash" throughout the site

Hi Guys,

A couple of my users (not very many at all) are having problems accessing the bank for some reason.

This is the email I get:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-75,70 WHERE userid='186'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '70 WHERE userid='186'' at line 1

mysql error number: 1064

Date: Monday 14th of June 2004 07:38:07 AM
Script: http://www.probetreff.com/forum/usho...shortname=bank



It works for 99% of the people but for some reason they get an error...they are using internet explorer and 1 user is betting this error on 4 different computers :o


Any Ideas?

Ok I solved the problem, not 100% sure why though.

The users couldn't access the bank so I deleted what was in the bank_query in my phpmyadmin and they got access...

Then I noticed that some users used a , (comma) instead of a . (period) for decimal places and that somehow screwed up they're points.

Zachery - I've just checked the functions.php and the code is there. Funny thing is in AdminCP | Usergroups, when you can add HTML start and end tags, putting anything in there such as <i> and </i> doesn't do anything either. This is clearly related.

Any further ideas?

Ok How do I edit the postbit file to show the colors/ italics etc? Cause they are no longer working?

Did you run the standalone or HTL installer?
Standalone

What is the exact error you recieve?
Warning: Invalid argument supplied for foreach() in /... (vb3 root path) .../global.php on line 701

Unable to add cookies, header already sent.
File: /... (vb3 root path) .../global.php
Line: 701

Where does the supposed error happen?
When trying to run ushop_install.php


What vB version are you running?
3.0.1

I hit the BACK button on my browser, which reloaded the ushop_install.php script and I got the install page!?! I went ahead and installed the script and I got no error messages.

Why would it work upon reloading ushop_install.php, even though I did not make any changes like removing the second global.php edit and running the ushop rebuild script?

I installed it and it seems to be working great. I did get the array error and the no points thing, but I fixed it with the initial instructions. Now, what I was wondering is, if I decide at some point to uninstall this, what tables were altered, and what fields were added to them.

The following are obvious :
Restore all files and style templates that were edited
Delete all files and style templates that were added
Delete all phrases that were added
Delete all tables that were added

Now, what I need to know is, which existing table were altered and what fields were added to them? Is there anything else?

NOTE: I did backup the DB and files prior to this, however, IF I have to do this, I don't want o have to backtrack if possible.

Ok, I was looking through the install script and found this section.

if ($_REQUEST['do'] == 'uninstall')

I assume if I was to do this, I'd still have to revert my basic templates.

Has this uninstall code been tested?