What is wrong with my query?

[josiespencer]

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

$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 :p

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.

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

[josiespencer]

Nice reply :p

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.

$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]

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:

http://sapsuperusers.com/myPictures/dberror.png

[Paul M]

Ah, forgot the single quotes around the password.

$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!

$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);