Running more than one php-nuke site

New Member Joined: Nov 15, 2005 Posts: 14

I would like to have a php-nuke site for each game we support. These sites would have their own forums and mods.

I would like to also have a main site for users to register and have its on forum and mods. I would like all these site to use the same user part of the main sites database only.

Can this be done and how.

Thanks
IronMan

Sells PC To Pay For Divorce Joined: Posts: 5661

yes and no,...yes because some people replied on the same earlier topic as to how it could be done.

And no because others who tried it never posted back here that it worked.

But in all honesty ,no.. Sad

Not yet anyway..

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Unless I'm misunderstanding, yes, it can be done and it's not too difficult. See these posts for additional details.
http://www.ravenphpscripts.com/postx4988-0-0.html
http://www.ravenphpscripts.com/postx6887-0-0.html

Posted: Tue Nov 15, 2005 8:48 pm

Just follow the instructions in the posts Raven listed, the first one should do.

Posted: Tue Jan 10, 2006 12:32 pm

I am running phpnuke 7.6patched 3.0 on two sites using the same user database. I am having a problem with the view post since last visit. It will not show the last post when a user clicks the link. Can someone tell me how to fix this?

Also when a user get a pm form one of the two sites the popup link takes them to the message part of the site they are on and not the site the pm is at. Is there a way to fix this also.

Thanks

registered · Posted: Tue Jan 10, 2006 12:55 pm

Not really, because they are both using the data from the same users table. You'd have to split the users.. and then you'd have two sets of users again.

Posted: Tue Jan 10, 2006 7:55 pm

I made a new table in my database called user_lastvisit2 and changed the user_lastvisit in the search.php file for the forums. The new post now show up but they always show up.

Now all I have to do is find out how to update the new table user_lastvisit I made it my database. Looks like this is the coding that updates user_lastvisit tabel in my database.

Code:




$uinfo      = getusrinfo($user);


$ulevel  = $uinfo['user_level'];


$uactive = $uinfo['user_active'];


if ( ($ulevel < 1) OR ($uactive < 1) ) {


    unset($user);


    unset($cookie);


}





if ( ($_GET['name']=='Forums') && ($_GET['file']=='profile') && ($_GET['mode']=='register') ) Header("Location: account-new_user.html");





// CNB Mod


// WARNING THIS SECTION OF CODE PREVENTS NEW POSTS REGISTERING AS UNREAD


if (is_user($user)) {


    //$uinfo   = getusrinfo($user);


    $lv   = time();


    //$db->sql_query("UPDATE ".$user_prefix."_users SET user_lastvisit='$lv' WHERE user_id='".$uinfo['user_id']."'");


    list($sessiontime) = $db->sql_fetchrow($db->sql_query("SELECT time FROM ".$prefix."_session WHERE uname='$uinfo[username]'"));





// modified by menelaos dot hetnet dot nl to reduce amount of sql-queries


    $configresult = $db->sql_query("SELECT config_name, config_value FROM ".$prefix."_cnbya_config");


    while (list($config_name, $config_value) = $db->sql_fetchrow($configresult)) {


    $config[$config_name] = $config_value;


    }


    $ya_config = $config;


    $cookieinactivity   = $ya_config['cookieinactivity'];


    $cookiepath      = $ya_config['cookiepath'];


    $autosuspend      = $ya_config['autosuspend'];


    $autosuspendmain   = $ya_config['autosuspendmain'];


// modified by menelaos dot hetnet dot nl to reduce amount of sql-queries





    if (($cookieinactivity != '-') AND ( ($sessiontime + $cookieinactivity < $lv ) ) ) {


        cookiedecode($user);


        $r_uid = $uinfo['user_id'];


        $r_username = $uinfo['username'];


        setcookie("user");


        if (trim($cookiepath) != '') setcookie("user","","","$ya_config[cookiepath]");


        $db->sql_query("DELETE FROM ".$prefix."_session WHERE uname='$r_username'");


        $db->sql_query("OPTIMIZE TABLE ".$prefix."_session");


        //$db->sql_query("DELETE FROM ".$prefix."_bbsessions WHERE session_user_id='$r_uid'");


        //$db->sql_query("OPTIMIZE TABLE ".$prefix."_bbsessions");


        unset($user); 


        unset($cookie);


     header("Location: modules.php?name=Your_Account");


     die();


   };





    // WARNING THIS SECTION OF CODE CAN SLOW SITE LOAD TIME DOWN!!!!!!!!!!!!!


    // IF YOU DO NOT WANT TO USE THIS CODE YOU DO NOT HAVE TO.


    // THIS FUCTION IS IN USER ADMIN AND CAN BE TRIGGERED ONLY


    // WHEN THE ADMIN WANTS IT RUN.


    if (($autosuspend > 0) AND ($autosuspendmain==1)) {


        $st = time() - $autosuspend;


        $susresult = $db->sql_query("SELECT user_id FROM ".$user_prefix."_users WHERE user_lastvisit <= $st AND user_level > 0");


            while(list($sus_uid) = $db->sql_fetchrow($susresult)) {


            $db->sql_query("UPDATE ".$user_prefix."_users SET user_level='0', user_active='0' WHERE user_id='$sus_uid'");


    }


  }





}





else { 


setcookie("CNB_test1","value1"); 


setcookie("CNB_test2","value2",time()+3600); 


setcookie("CNB_test3","value3",time()+3600,"/"); 


setcookie("CNB_test4","value4",time()+3600,"$ya_config[cookiepath]"); 


} 





// CNB Mod


?>

Do you think this would work and if so how can I get the new table updated.