Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2005, 06:18 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default will this bring the server to it's knees?

PHP Code:
    foreach ($moderatememberaction AS $userid => $action)
    {
        if (
$action == 0)
        { 
// no point in checking the permission if they dont want to do anything to the group
            
continue;
        }

        if (
$action == 1)
        { 
// validate

            
$validateinfo $DB_site->query_first("
                SELECT user.*
                FROM user
            "
);

            
$DB_site->query("
                UPDATE grps_user
                SET approved = 1
                WHERE groupid = 
$groupid
                AND userid = 
$userid
            "
);

            
// add data to their usertable row
            
            // send pm to user to let them know their accounts been validated
            
$message ="Hey $user, you're request to join $groupname has been accepted! :)";
            
$user['userid'] = $userid['leaderid'];
            
$user['username'] = $userid['username'];
            
$sendto["$username"] = true;
            
$tostring["$user[userid]"] = $user['username'];
            
$newpmtitle "RE: Request To Join" $validateinfo['title'];
        
            
$DB_site->query("
               INSERT INTO " 
TABLE_PREFIX "pmtext(fromuserid,fromusername, title, message, touserarray, iconid, dateline,showsignature)
               VALUES(
$bbuserinfo[userid], '" .addslashes($bbuserinfo['username']) . "', '" addslashes($newpmtitle). "', '".addslashes($message)."', '" addslashes(serialize($tostring)). "', 0, '" TIMENOW "', 1)
            "
); 

            
$pmtextid $DB_site->insert_id(); 
    
            
$DB_site->query("
               INSERT INTO " 
TABLE_PREFIX "pm (pmtextid,userid, messageread)
                VALUES (
$pmtextid$validateinfo[userid], 0)
            "
); 

            
$DB_site->shutdown_query("
               UPDATE " 
TABLE_PREFIX "user SETpmtotal=pmtotal+1, pmunread=pmunread+1 WHERE userid = $userid
            "
); 
        }
        else if (
$action == -1)
        { 
// delete

            
$validateinfo $DB_site->query_first("
                SELECT user.*
                FROM user
            "
);

            
$DB_site->query("
                DELETE 
                FROM grps_user
                WHERE groupid = 
$groupid
                AND userid = 
$userid
            "
);
            
            
// send pm to let em down gently.
            
$message ="Sorry $user, you're request to join $groupname has been denied! :(";
            
$user['userid'] = $validateinfo['userid'];
            
$user['username'] = $validateinfo['username'];
            
$sendto["$username"] = true;
            
$tostring["$user[userid]"] = $user['username'];
            
$newpmtitle "RE: Request To Join" $validateinfo['title'];
        
            
$DB_site->query("
               INSERT INTO " 
TABLE_PREFIX "pmtext(fromuserid,fromusername, title, message, touserarray, iconid, dateline,showsignature)
               VALUES(
$bbuserinfo[userid], '" .addslashes($bbuserinfo['username']) . "', '" addslashes($newpmtitle). "', '".addslashes($message)."', '" addslashes(serialize($tostring)). "', 0, '" TIMENOW "', 1)
            "
); 

            
$pmtextid $DB_site->insert_id(); 
    
            
$DB_site->query("
               INSERT INTO " 
TABLE_PREFIX "pm (pmtextid,userid, messageread)
                VALUES (
$pmtextid$userid, 0)
            "
); 

            
$DB_site->shutdown_query("
               UPDATE " 
TABLE_PREFIX "user SETpmtotal=pmtotal+1, pmunread=pmunread+1 WHERE userid = $userid
            "
); 

        }
    } 
admittedly not all the codes right, but you get th eidea of how many queries it's gonna do per record it validates
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05159 seconds
  • Memory Usage 2,267KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete