The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
sql error
Ey,
Im trying to input a valua into a table field. I added 3 colums to the user table called type,points and dateline. I want to make it edit the values of a user. So lets say we have a user called testuser with userid1. I want to make it write values into the fields of userid1. I tried this code: Code:
$vbulletin->db->query_write(" INSERT INTO ".TABLE_PREFIX."user WHERE userid = ".$userid.",, SET type = 1, points = '".$points."', dateline = ".TIMENOW." "); Then it will edit the fields of userid1 and add the values of the script. When i run the script i get this error: Error Number : 1064 Could you guys tell me whats wrong with this code and show the fix. I tried to google it but could not find a solution. I dont know much about sql im only editing a existing mod. Thx for the help |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|