## Little PHP Assistance ##

[Mr Chad]

Ok well i have this when a special link is clicked it runs a php file that has this

PHP Code:

$sql = "UPDATE " . TABLE_PREFIX . "user SET `vote_status`=1 WHERE `userid`=".$db->sql_prepare($vbulletin->userinfo['userid']);
$sqlr = $db->query_write($sql); 


I also have a cron job that sets vote_status to 0 every 12 hours
all i need is somthing that will temp promote any user with vote_status=1 to a special user group, and it checks this every 12 hours to.

[Chris M]

In the php file that is clicked on add:

PHP Code:

//check the user isn't an admin, supermod or mod! (add more groups if necessary)
if (!(is_member_of($vbulletin->userinfo, array(5,6,7)))) {
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 'y' WHERE userid = ' . $vbulletin->userinfo['userid'] . '");
} 


In your cron file:

PHP Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 'z' WHERE usergroupid = 'y'"); 


Chris

[Mr Chad]

how can i make it for just registered members as the default group.

[Chris M]

PHP Code:

if ($vbulletin->userinfo['vote_status'] == "1") {
// do stuff
} 


Chris

[Mr Chad]

Chris your code make my vote_status not needed.

PHP Code:

//check the user isn't an admin, supermod or mod! (add more groups if necessary)
if (!(is_member_of($vbulletin->userinfo, array(5,6,7)))) {
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 'y' WHERE userid = ' . $vbulletin->userinfo['userid'] . '");
} 


How do i just make it do it to the people that are just registered users (ID = 2)

[Chris M]

Change:

PHP Code:

if (!(is_member_of($vbulletin->userinfo, array(5,6,7)))) { 


to:

PHP Code:

if ((is_member_of($vbulletin->userinfo, 2)) && (!(is_member_of($vbulletin->userinfo, array(5,6,7))))) { 


Chris

[Mr Chad]

Thanks that did the trick.

[Mr Chad]

Ok i need help on another thing:

ok i can pull the total amount of members like this

PHP Code:

// get forum members
$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . $TABLE_PREFIX . "user WHERE usergroupid!=4";
$numa = mysql_query_eval($querya,$link);
$numb = mysql_fetch_array($numa);
$numbermembers=number_format($numb['users']);
mysql_free_result($numa); 


Anyone know how to pull the member with the highist userid and grab their user name?

[Marco van Herwaarden]

You would need a seperate query for that.

[Mr Chad]

Originally Posted by MarcoH64

You would need a seperate query for that.

how would i set it up tho? to get text i do SELECT what?