Promoting user issue

Hangin' Around Joined: Apr 09, 2005 Posts: 31

Hi guys,

I have a problem, When I try to promote a user to a super user. I get the message User has been promoted to Admin. Thats good but when I go back to the main page, it does not add the little admin icon next to my name. I check the nuke_author table and it has added my name. So I went into phpmyadmin checked out nuke_users table, check out my name and it still has my user_level set to 1.

I am running platinum 7.6 ( latest version )with MySQL 4.0.27 running and CNB 4.4.2. I believe it has to do with this last lines of code. Since I am not getting an email telling me I have been promoted nor is it changing my user_level. Any suggestions would be appreciated or if there is something I am missing here.

Code:

if (!$result) {


            $pagetitle = ": "._USERADMIN." - "._PROMOTEUSER;


            include("header.php");


            title(_USERADMIN." - "._PROMOTEUSER);


            amain();


            echo "<br>\n";


            OpenTable();


            echo "<center><b>"._ADDERROR."<b></center><br>";


            CloseTable();


            include("footer.php");


        } else {


            $pagetitle = ": "._USERADMIN." - "._PROMOTEUSER;


            include("header.php");


            title(_USERADMIN." - "._PROMOTEUSER);


            amain();


            echo "<br>\n";


            OpenTable();


            echo "<center><b>"._USERPROMOTED."<b></center>";


            CloseTable();


            include("footer.php");


            if ($ya_config['servermail'] == 0) {


                $message = _SORRYTO." $sitename "._HASPROMOTE;


                $subject = _ACCTPROMOTE;


                $from  = "From: $adminmail\r\n";


                $from .= "Reply-To: $adminmail\r\n";


                $from .= "Return-Path: $adminmail\r\n";


                mail($add_email, $subject, $message, $from);


            }


        }


        if ($add_radminforum == "1") { $db->sql_query("UPDATE ".$user_prefix."_users SET user_level='2' WHERE user_id='$chng_uid'"); }


    }





}else{


header("Location: ../../../index.php");


    die ();


}

I honestly believe it has to do with the statement refering to if $add_radminforum == 1 since there is not such a reference in any of the database tables. I have changed this line about 60 times to try and get it to change my user level with no luck. It adds me as an author all 60 times but will not update my user_level. So any help would be appreciated or ideas off the top of your head.

Thanks
Eck

Posted: Sat Aug 05, 2006 9:28 am

Promoting users does not add them to the nuke_authors table which is where that block grabs its info from.

if ($add_radminforum == "1") { $db->sql_query("UPDATE ".$user_prefix."_users SET user_level='2' WHERE user_id='$chng_uid'")

Now to do this, youll need to grab username, password from the users table and insert those into the authors table or tell the block to call from this table.

The block edit would be a lot safer.
I'd sudjest you tell us which block your using and I'll post the edit for you to make to make it show the admin icon.

Posted: Sat Aug 05, 2006 9:52 am

Quote:

Promoting users does not add them to the nuke_authors table which is where that block grabs its info from

Ok I was under the assumption is did since you are promoting a user to Superuser in the promoteusrconf.php from the your account admin. The opening lines look as such, since it is inserting the information into the Database. I could be reading this wrong, or the understanding of it, which is quite possible. Here is the entire promoteuserconf.php I have. The credits are intact I just did not post them to save room.

Code:

if (!defined('YA_ADMIN')) { echo "CNBYA admin protection"; exit; }


if (!eregi("modules.php", $_SERVER['SCRIPT_NAME'])) {


    header("Location: ../../../index.php");


    die ();


}


if (!defined('CNBYA')) { echo "CNBYA protection"; exit; }


if ($radminsuper == 1) { 





    $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_authors WHERE aid='$add_aid'"));


    if ($num > 0) {


        $pagetitle = ": "._USERADMIN." - "._PROMOTEUSER;


        include("header.php");


        title(_USERADMIN." - "._PROMOTEUSER);


        amain();


        echo "<br>\n";


        OpenTable();


        echo "<center><b>"._NAMEERROR."<b></center><br>";


        CloseTable();


        include("footer.php");


    } else {


   //[vecino398(curt)]  www.vecino398.com -Modification- 


   if   ($Version_Num >= 7.5)  { 


       $add_pwd = md5($add_pwd); 


        for ($i=0; $i < sizeof($auth_modules); $i++) { 


            $row = $db->sql_fetchrow($db->sql_query("SELECT admins FROM ".$prefix."_modules WHERE mid='$auth_modules[$i]'")); 


            $adm = "$row[admins]$add_name"; 


            $db->sql_query("UPDATE ".$prefix."_modules SET admins='$adm,' WHERE mid='$auth_modules[$i]'"); 


        } 


         $add_password = check_html($add_password, 'nohtml');


         $add_aid = check_html($add_aid, 'nohtml');


         $add_name = check_html($add_name, 'nohtml');


         $add_url = check_html($add_url, 'nohtml');


         $add_email = check_html($add_email, 'nohtml');


         $add_password = check_html($add_password, 'nohtml');


         $add_radminsuper = intval($add_radminsuper);


         $add_admlanguage = check_html($add_admlanguage, 'nohtml');


     $result = $db->sql_query("insert into " . $prefix . "_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_password', '0', '$add_radminsuper', '$add_admlanguage', '0')");  } 


    elseif ($Version_Num >= 7.4){ 


    


    $add_aid = check_html($add_aid, 'nohtml');


    $add_name = check_html($add_name, 'nohtml');


    $add_url = check_html($add_url, 'nohtml');


    $add_email = check_html($add_email, 'nohtml');


    $add_password = check_html($add_password, 'nohtml');


    $add_radminarticle = intval($add_radminarticle);


    $add_radmintopic = intval($add_radmintopic);


    $add_radminuser = intval($add_radminuser);


    $add_radminsurvey = intval($add_radminsurvey);


    $add_radminlink = intval($add_radminlink);


    $add_radminfaq = intval($add_radminfaq);


    $add_radmindownload = intval($add_radmindownload);


    $add_radminreviews = intval($add_radminreviews);


    $add_radminnewsletter = intval($add_radminnewsletter);


    $add_radminforum = intval($add_radminforum);


    $add_radmincontent = intval($add_radmincontent);


    $add_radminency = intval($add_radminency);


    $add_radminsuper = intval($add_radminsuper);


    $add_admlanguage = check_html($add_admlanguage, 'nohtml');


    $result = $db->sql_query("insert into " . $prefix . "_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_password', '0', '$add_radminarticle','$add_radmintopic','$add_radminuser','$add_radminsurvey','$add_radminlink','$add_radminfaq','$add_radmindownload','$add_radminreviews','$add_radminnewsletter','$add_radminforum','$add_radmincontent','$add_radminency','$add_radminsuper','$add_admlanguage')");


    } 


    else { 


    


    $add_aid = check_html($add_aid, 'nohtml');


    $add_name = check_html($add_name, 'nohtml');


    $add_url = check_html($add_url, 'nohtml');


    $add_email = check_html($add_email, 'nohtml');


    $add_password = check_html($add_password, 'nohtml');


    $add_radminarticle = intval($add_radminarticle);


    $add_radmintopic = intval($add_radmintopic);


    $add_radminuser = intval($add_radminuser);


    $add_radminsurvey = intval($add_radminsurvey);


    $add_radminlink = intval($add_radminlink);


    $add_radminfaq = intval($add_radminfaq);


    $add_radmindownload = intval($add_radmindownload);


    $add_radminreviews = intval($add_radminreviews);


    $add_radminnewsletter = intval($add_radminnewsletter);


    $add_radminforum = intval($add_radminforum);


    $add_radmincontent = intval($add_radmincontent);


    $add_radminency = intval($add_radminency);


    $add_radminsuper = intval($add_radminsuper);


    $add_admlanguage = check_html($add_admlanguage, 'nohtml');


    $result = $db->sql_query("insert into " . $prefix . "_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_password', '0', '$add_radminarticle','$add_radmintopic','$add_radminuser','$add_radminsurvey','$add_radminsection','$add_radminlink','$add_radminephem','$add_radminfaq','$add_radmindownload','$add_radminreviews','$add_radminnewsletter','$add_radminforum','$add_radmincontent','$add_radminency','$add_radminsuper','$add_admlanguage')");


        }


      /////////////////////END/////////////////////////////    


        if (!$result) {


            $pagetitle = ": "._USERADMIN." - "._PROMOTEUSER;


            include("header.php");


            title(_USERADMIN." - "._PROMOTEUSER);


            amain();


            echo "<br>\n";


            OpenTable();


            echo "<center><b>"._ADDERROR."<b></center><br>";


            CloseTable();


            include("footer.php");


        } else {


            $pagetitle = ": "._USERADMIN." - "._PROMOTEUSER;


            include("header.php");


            title(_USERADMIN." - "._PROMOTEUSER);


            amain();


            echo "<br>\n";


            OpenTable();


            echo "<center><b>"._USERPROMOTED."<b></center>";


            CloseTable();


            include("footer.php");


            if ($ya_config['servermail'] == 0) {


                $message = _SORRYTO." $sitename "._HASPROMOTE;


                $subject = _ACCTPROMOTE;


                $from  = "From: $adminmail\r\n";


                $from .= "Reply-To: $adminmail\r\n";


                $from .= "Return-Path: $adminmail\r\n";


                mail($add_email, $subject, $message, $from);


            }


        }


        if ($add_radminforum == "1") { $db->sql_query("UPDATE ".$user_prefix."_users SET user_level='2' WHERE user_id='$chng_uid'"); }


    }





}else{


header("Location: ../../../index.php");


    die ();


}

If I go in manually and change the user_level to 2, I do get the admin icon next to my name. But accordning to the above file, it should do it for me and change the user_level. I am running the CZuser-info block.

Posted: Sat Aug 05, 2006 11:06 am

Actually it looks like it does,I think my previous post was incorrect.

Whats the block code?

Posted: Sat Aug 05, 2006 1:39 pm

Having issues posting the entire block code. I will keep trying though, here is part of it where I found the ulevel

Code:

if ($ulevel == 2) {


                 $who_online_now .= "<br />$where<A HREF=\"modules.php?name=Your_Account&amp;op=userinfo&amp;username=$uname\"  title=\""._CZ_VIEW." $uname's "._CZ_VIEWPP."\">$uname</a>&nbsp;<img src=\"images/CZUser/admin.gif\">\n"; 


                 } 


                 elseif ($ulevel == 3) {


                 $who_online_now .= "<br />$where<A HREF=\"modules.php?name=Your_Account&amp;op=userinfo&amp;username=$uname\"  title=\""._CZ_VIEW." $uname's "._CZ_VIEWPP."\">$uname</a></font>&nbsp;<img src=\"images/CZUser/staff.gif\">\n"; 


                 }


                 else {


           $who_online_now .= "<br />$where<A HREF=\"modules.php?name=Your_Account&amp;op=userinfo&amp;username=$uname\" title=\""._CZ_VIEW." $uname's "._CZ_VIEWPP."\">$uname</a></font>\n"; 


          } 


      $who_online_now .= ( $i != $online_num[0] ? "" : "" ); 


      $i++; 


   


      } else {


      $hidden++;

Posted: Sat Aug 05, 2006 1:46 pm

ok is $ulevel gloabalized?

Posted: Sat Aug 05, 2006 2:39 pm

Thank you for your time on looking at this too. I appreciate it very much.

$ulevel is not globalized

Posted: Sat Aug 05, 2006 2:57 pm

Here is a link to the text file I have of it, if you want to see it, I know everyone hates looking at files, but I can promise you there is nothing funky with it.

Only registered users can see links on this board! Get registered or login!

Posted: Sat Aug 05, 2006 4:02 pm

Ok this is definatley out of my league.

I have some ideas on a jerry rigged way to do this but would prefer to make this work OR figure out exactly whats wrong, I believe others would have a much better shot at figuring this out.

I was thinking to globalize the $uid variable and if not empty grab the userlevel fromt he database then apply the if statement but that would be a fix for just the admins.

From the look of it, you may have other problems with that code that you are not aware of because it uses the same layout to do other things.

Posted: Sat Aug 05, 2006 4:20 pm

Thanks for trying. All other functions work great just that one little detail. Its driving me mad. I can go set user level to 2 myself but like with anything if its there to be easy, I want the easy way. I guess thats why my girlfriend said I need counseling..HAHA!!