I placed the following code into ./includes/cron/pn_user.php file and scheduled a task. I have replaced the uname, password and database with my own, just renamed it on here for security.
Code:
<?php
//connect to database
mysql_connect("localhost", "uname", "password"); //localhost username password
mysql_select_db("database"); //main database
//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 vb3_user");
$query=mysql_query("update nuke_users set umode='nested', theme='ExtraLite',timezone_offset='14.0'");
mysql_close();
?>
I pressed
'Run now' which in theory should empty the postnuke user table and enter the vb users. But all I ended up with was a empty table! Looking at this code, it doesn't actually look at the vb users table to collect the data to fill the postnuke user table.
I'm puzzled how some people have managed to get this actually working, since all I'm getting is a zero'd user table.
I merged Postnuke 0.75 with vBulletin 3.07 so the database would be fine with different prefixes. Can someone please explain how this code is supposed to work? :ermm:
12-13-2004, 03:12 PM
Linear Mode
