Codezwiz >> Forums >> General PHP Nuke Help >> Auto update nsngr group table. Help please..

Hi, here is the problem I am having. I have the bbgroups table that has groupname, description and id. What i would like to do is have a page that when people visit a couple queries will execute updating the nsngr groups table with those info. So i would like it to take information from the bbgroups table and update the nsngr groups table. It would be great if it could check first if those group exist and if not it would then create the new group but if it already exist it would then update the member count if there are new members in that group. Hope you can help,,

Thanks...

Here are some bits of codes i am working with..this code adds groups and users but it also duplicates it every time someone visits the page...I would like it to update instead..

$change3 = $db->sql_query("SELECT group_id, group_name, group_description FROM ".$prefix."_bbgroups WHERE group_single_user=0");
while(list($phpBB, $gname, $gdesc) = $db->sql_fetchrow($change3)) {
$result = $db->sql_query("INSERT INTO ".$prefix."_nsngr_groups VALUES (NULL, '$gname', '$gdesc', '0', '0', '$phpBB', '0')");
if (!$result) { echo "- Insert into ".$prefix."_nsngr_groups failed \n"; } else { echo "- Insert into ".$prefix."_nsngr_groups succeeded \n"; }
list($gid) = $db->sql_fetchrow($db->sql_query("SELECT gid FROM ".$prefix."_nsngr_groups WHERE phpBB='$phpBB'"));
$change4 = $db->sql_query("SELECT user_id FROM ".$prefix."_bbuser_group WHERE group_id='$phpBB'");
while(list($guid) = $db->sql_fetchrow($change4)) {
list($guname) = $db->sql_fetchrow($db->sql_query("SELECT username FROM ".$user_prefix."_users WHERE user_id='$guid'"));
$result = $db->sql_query("INSERT INTO ".$prefix."_nsngr_users VALUES ('$gid', '$guid', '$guname', '0', '0', now(), '0')");
if (!$result) { echo "- Insert into ".$prefix."_nsngr_users failed \n"; } else { echo "- Insert into ".$prefix."_nsngr_users succeeded \n"; }
}
}
$change1 = $db->sql_query("SELECT group_id, group_moderator FROM ".$prefix."_bbgroups WHERE group_moderator>0");
while(list($pgid, $muid) = $db->sql_fetchrow($change1)) {
$result = $db->sql_query("UPDATE ".$prefix."_nsngr_groups SET muid='$muid' WHERE phpBB='$pgid'");
if (!$result) { echo "- Update ".$prefix."_nsngr_groups failed \n"; } else { echo "- Update ".$prefix."_nsngr_groups succeeded \n"; }
list($gid) = $db->sql_fetchrow($db->sql_query("SELECT gid FROM ".$prefix."_nsngr_groups WHERE phpBB='$pgid'"));
$nnum = $db->sql_numrows($db->sql_query("SELECT uid FROM ".$prefix."_nsngr_users WHERE gid='$gid' AND uid='$muid'"));
$bnum = $db->sql_numrows($db->sql_query("SELECT user_id FROM ".$prefix."_bbgroups WHERE group_id='$pgid' AND user_id='$muid'"));
if(!$nnum || $nnum == 0) {
list($guname) = $db->sql_fetchrow($db->sql_query("SELECT username FROM ".$user_prefix."_users WHERE user_id='$muid'"));
$sdate = time();
$result = $db->sql_query("INSERT INTO ".$prefix."_nsngr_users VALUES ('$gid', '$muid', '$guname', '0', '0', $sdate, '0')");
if (!$result) { echo "- Insert into ".$prefix."_nsngr_users failed \n"; } else { echo "- Insert into ".$prefix."_nsngr_users succeeded \n"; }
}
if(!$bnum || $bnum == 0) {
$result = $db->sql_query("INSERT INTO ".$prefix."_bbuser_group VALUES ('$pgid', '$muid', '0')");
if (!$result) { echo "- Insert into ".$prefix."_bbuser_group failed \n"; } else { echo "- Insert into ".$prefix."_bbuser_group succeeded \n"; }
}
}

Use the same method you use to check these:

$bnum = $db->sql_numrows($db->sql_query("SELECT user_id FROM ".$prefix."_bbgroups WHERE group_id='$pgid' AND user_id='$muid'"));
if(!$nnum || $nnum == 0) {

Thanks for your prompt reply

. I have decided to use the code below because it would just about do what i want except for one thing. How would I display only new records from the _bbgroups table. I would like it to compare group id from _bbforums and phpBB data from nsngr_groups. Here is the query..

$bnum = $db->sql_query("SELECT group_id, group_name, group_description FROM ".$prefix."_bbgroups WHERE group_single_user=0 ");
while(list($phpBB, $gname, $gdesc) = $db->sql_fetchrow($bnum)) {

$result = $db->sql_query("INSERT INTO ".$prefix."_nsngr_groups VALUES ('0', '$gname', '$gdesc', '0', '0', '$phpBB', '0')");
}

That code inserts the data and created duplicates. Could i list only data from the _bbforums that are not inside the nsngr_forums table then use the insert at the bottom to add those data..Maybe something like the following..

$bnum = $db->sql_query("SELECT group_id, group_name, group_description FROM ".$prefix."_bbgroups WHERE group_id !=='phpBB' ");

I tried that and it didn't work so anything like that would be great..Thanks again

...

Your trying to see if something already exists?

WHERE group_id !='phpBB' ");