What is wrong with my query?

[josiespencer]

I am not a php coder - I am just trying to do a simple update query:

PHP Code:

$db->query_write("UPDATE " . TABLE_PREFIX . "forum 
SET password="'george' + $vbulletin->options['dateformat']" WHERE forumid = '757';"); 


Could anyone please help? I am trying to set a password to george20061022.

[Paul M]

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 ?

[josiespencer]

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?

[Paul M]

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:

$pwdate = vbdate('Ymd',TIMENOW);
$db->query_write("UPDATE " .TABLE_PREFIX. "forum SET password = george{$pwdate} WHERE forumid = 757"); 


[josiespencer]

Originally Posted by Paul M

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:

$pwdate = vbdate('Ymd',TIMENOW);
$db->query_write("UPDATE " .TABLE_PREFIX. "forum SET password = george{$pwdate} WHERE forumid = 757"); 


Since the update was against the forum table to set the password column, how could you not know it was a forum password?

Anyway, thanks for the help, I will try it out.

[Paul M]

Originally Posted by josiespencer

Since the update was against the forum table to set the password column, how could you not know it was a forum password?

I believe I mentioned the reason.

and I didn't notice the table name in the SQL

:smoke:

[josiespencer]

Sorry, but your code generated an database error:

[Paul M]

Ah, forgot the single quotes around the password.

PHP Code:

$pwdate = vbdate('Ymd',TIMENOW);
$db->query_write("UPDATE " .TABLE_PREFIX. "forum SET password = 'george{$pwdate}' WHERE forumid = 757"); 


[josiespencer]

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:

$pwdate = vbdate('Ymd',TIMENOW);
$db->query_write("UPDATE " .TABLE_PREFIX. "forum SET password = 'george{$pwdate}' WHERE forumid = 757");
build_forum_permissions($forum['757']);
vbflush();
unset($forum['757'], $vbulletin->forumcache);