PDA

View Full Version : another problem with item shop v5

Pesto
08-23-2002, 08:01 AM
I guess this must be my fault but..
I get this error when i try to do anything points related
-------------------------
Database error in vBulletin 2.2.6:

Invalid SQL: SELECT money FROM userfield WHERE userid=1
mysql error: Unknown column 'money' in 'field list'

mysql error number: 1054
--------------------------

im sure that i set the user field correctly please give me some ideas of what i did wrong
--------------------------
addition: this error is on newthread and newreply (and other "point" related things)
g-force2k2
08-23-2002, 01:56 PM
sorry ;)
Xenon
08-23-2002, 05:40 PM
Pesto, please go to this (http://www.vbulletin.com/members/vbulletin.org.php) page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.
Pesto
08-23-2002, 05:47 PM
sorry bout that, my name was erased, now does anyone have the answer?
Xenon
08-23-2002, 05:58 PM
thank you :)

g-force said "money" is not the column name of the profilefield name called money.
you shoud use field5 (replace 5 with fieldid of your profilefield called money ;))
Pesto
08-23-2002, 07:11 PM
OHHHHHHHH thanks alot
Pesto
08-23-2002, 07:19 PM
another thing, how do show the points in my postbit, i must have missed that somewhere.
Xenon
08-23-2002, 07:27 PM
$post[field5]?

i dont use the hack but it should be something like $post[fieldx] or $post[points] (field if it's saved in userfield (i think so) points if it is saved in user-table)
Pesto
08-23-2002, 10:56 PM
yup it worked, thanks alot xenon BIG help ~ you tha man
Xenon
08-24-2002, 12:15 AM
you're welcome :)
g-force2k2
08-24-2002, 01:17 AM
Originally posted by g-force2k2
sorry ;)

its all cool i understand :) just giving fellow hackers some support ;)

g-force2k2