The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
How Do I Set New Password For Group of User
Hello , I`m looked for query to set new password for group of user , i do query but it`s gave me error message
this is the query i make : Code:
UPDATE user, userfield SET user.password = MD5( MD5('password') . user.salt ) WHERE user.usergroupid = "2" and userfield.field7 = "KUW" Code:
There was an error when trying to implement your query. Have been restored following information. Error Number: 1064 Error description: 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 '. user.salt) WHERE user.usergroupid = "2" and userfield.field7 = "KUW" 'at line 1 thanks Hamad Mubarak --------------- Added [DATE]1227650522[/DATE] at [TIME]1227650522[/TIME] --------------- jump , any one help me plz --------------- Added [DATE]1227697030[/DATE] at [TIME]1227697030[/TIME] --------------- jump , any one help me plz |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|