vb.org Archive - ## Little PHP Assistance ##

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - ## Little PHP Assistance ## (https://vborg.vbsupport.ru/showthread.php?t=103491)

Mr Chad

12-21-2005 11:02 PM

## Little PHP Assistance ##

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

12-21-2005 11:10 PM

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

12-21-2005 11:11 PM

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

Chris M

12-21-2005 11:12 PM

PHP Code:


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

// do stuff

}

Chris

Mr Chad

12-21-2005 11:30 PM

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

12-21-2005 11:31 PM

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

12-21-2005 11:35 PM

Thanks that did the trick.

Mr Chad

12-23-2005 04:08 AM

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

12-23-2005 05:50 AM

You would need a seperate query for that.

Mr Chad

12-23-2005 07:51 AM

Quote:

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?

All times are GMT. The time now is 03:51 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01089 seconds Memory Usage 1,753KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: