Database fields

[Marco van Herwaarden]

change it to:

PHP Code:

$query1 = "UPDATE datastore SET data=REPLACE(data,'\"bbactive\";i:0;','\"bbactive\";i:1;') WHERE title='options'"; 


Or even better:

PHP Code:

$query1 = "UPDATE " . TABLE_PREFIX . "datastore SET data=REPLACE(data,'\"bbactive\";i:0;','\"bbactive\";i:1;') WHERE title='options'"; 


[CooganA]

I'm now getting this error... with both suggestions.

Warning: main(DIR/includes/adminfunctions_misc.php) [function.main]: failed to open stream: No such file or directory in /home/chat/public_html/forums/turnon.php on line 2

Fatal error: main() [function.require]: Failed opening required 'DIR/includes/adminfunctions_misc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/chat/public_html/forums/turnon.php on line 2

[Marco van Herwaarden]

You must include ./global.php before you can use any of the other vBulletin includes/functions.

[CooganA]

When including ./global.php I seem to get an error when running these as scheduled tasks. But seems to work ok without them. Tho the scheduled task only runs if I click "run now" and doesn't work when a time is set.

Thanks
Adam

[Marco van Herwaarden]

If run as a Scheduled Task, you do not need to include global.php, this is done automatic.