hi, could anyone help me write a sql code to do the following:
Every hour, I wish to ask cron to run my /forum/admincp/includes/cron/postnuke.php Inside theis file I put:
PHP Code:
<?php //connect to database mysql_connect("localhost", "my db username", "myPW"); mysql_select_db("my db name"); //empty pn userdb and fill it with fresh userdata $query=mysql_query("delete from nuke_users"); $query=mysql_query("INSERT INTO nuke_users (uid,uname,email,url,user_sig,pass,user_icq) select userid,username,email,homepage,signature,password,icq from user"); $query=mysql_query("update nuke_users set umode='nested', theme='ExtraLite',timezone_offset='14.0'");
mysql_close(); ?>
It connects every hour and updates my post nuke with all the current users and edited passwords etc... However, i cannot quite get it to work with VB3, what if anythink do i need to change? ANy ideas welcomed!
It connects to the DB and deletes all my post nuke users, but nothing else.