The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
What is wrong with my query?
I am not a php coder - I am just trying to do a simple update query:
PHP Code:
|
#2
|
||||
|
||||
There are a number of errors in that, but first of all it's not going to work even when you correct the syntax as vb does not store passwords directly like that, they are an MD5 hash. Why are you trying to do this ?
|
#3
|
|||
|
|||
vBulletin does save the forum passwords like this. I need a password that changes on a specific forum every day. I want to cron it as a task. Could you please offer assistance and not criticism of a feature you obviously have not checked out yourself?
|
#4
|
||||
|
||||
Nice reply
You didn't actually mention this was a forum password in your post and I didn't notice the table name in the SQL - since password questions generally relate to user passwords I mistakenly assumed your request did. Anyway, you are best splitting this into two lines, something like this. PHP Code:
|
#5
|
|||
|
|||
Quote:
Anyway, thanks for the help, I will try it out. |
#6
|
||||
|
||||
Quote:
Quote:
|
#7
|
|||
|
|||
Sorry, but your code generated an database error:
|
#8
|
||||
|
||||
Ah, forgot the single quotes around the password.
PHP Code:
|
#9
|
|||
|
|||
Excellent! Thanks! That code plus my code makes a perfect sniplet to change the forum's password and then rebuild the forum so the new password will take effect. Croning it for 12:01 at night will force my forum to have a new password everyday!
PHP Code:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|