Thread: MultiQuote
View Single Post
  #15  
Old 01-05-2004, 10:03 PM
Chroder's Avatar
Chroder Chroder is offline
 
Join Date: Sep 2003
Location: Toronto, Ontario
Posts: 112
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Another update that deals with these things more cleanly. I'm working on an addition that'll allow the "go advance" in the QR to also have all the quotes.

Change the newreply.php code to the following:

PHP Code:
//############################################################################
 //# START MULTI QUOTE                                                     #
  //############################################################################
  
if(isset($_COOKIE[COOKIE_PREFIX 'mq']))
  {
      
$pids $_COOKIE[COOKIE_PREFIX 'mq'];
      
$pids urldecode($pids);
  
      if(!empty(
$pids) && preg_match("/^[0-9,]+$/"$pids))
      {
         
$mq_postid = (empty($_REQUEST['noquote']) ? "AND postid <> {$postinfo['postid']}'');
          
         
$q $DB_site->query("SELECT postid, username, pagetext FROM ".TABLE_PREFIX."post WHERE postid IN($pids$mq_postid ORDER BY postid ASC LIMIT 20");
          while(
$row $DB_site->fetch_array($q))
          {
             
$originalposter fetch_quote_username($row['username']);
              
$pagetext htmlspecialchars_uni($row['pagetext']);
              
$pagetext trim(strip_quotes($pagetext));
          eval(
'$newpost[\'message\'] .= "' fetch_template('newpost_quote'10) . '\n";');
          }
      }
  
     
setcookie(COOKIE_PREFIX 'mq'''time() - 3600$vboptions['cookiepath'], $vboptions['cookiedomain']);
  }
  
//############################################################################
 //# END MULTI QUOTE                                                         #
  //############################################################################ 
This should fix all mysql errors recieved above, on my test board it seemed to do fine It also now checks that the $pids is only numbers/commas so there are no tricky users trying to screw up the board.

[Updated file uploaded in first post]
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01291 seconds
  • Memory Usage 1,793KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete