How to use Postnuke & VB with one UserDB

[bamaster]

Originally Posted by alfaowner

would this still work with vb3? anyone know?

Yes, I would like to know too.

All I need is for vB to use the same user table as PN. I just installed vB3 and am running PN .721.

Would this cron job still work?

[gothicuser]

I have experimented with vB 3.0.6 and pn .750 to no avail, but having said that I must admit that my knowledge of php is rather limited

[TruthElixirX]

Anyone tell me if this works with 3.0.7?

[syrus.xl]

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.

<?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: