View Single Post
  #201  
Old 02-01-2006, 01:07 AM
PalmNut PalmNut is offline
 
Join Date: Dec 2003
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Seems to be a bug with the moderation system. Even with the moderation option set to "Yes," all bugs submitted via vbugs.php are live for all users to see. I found a couple of issues in the code that address this. The vbugs.php is looking for the wrong option setting and bug moderation value, cleaning some global variables unnecessarily in the process.

Details for editing:

Starting at line 650 in
PHP Code:
  $vbulletin->input->clean_array_gpc('p', array(
      
'title' => TYPE_STR,
      
'vbug_typeid' => TYPE_UINT,
      
'vbug_versionid' => TYPE_UINT,
      
'vbug_severityid' => TYPE_UINT,
      
'vbug_statusid' => TYPE_UINT,
      
'description' => TYPE_STR,
      
'moderate' => TYPE_UINT,
      
'subscribe' => TYPE_UINT
      
)); 
remove
PHP Code:
      'vbug_statusid' => TYPE_UINT
and
PHP Code:
      'moderate' => TYPE_UINT
Then immediately below find
PHP Code:
if($vbulletin->options['vbug_moderated']) 
and change the line to
PHP Code:
if($vbulletin->options['vbug_bug_moderate']) 
Below that find
PHP Code:
    $db->query_write("
    INSERT INTO " 
TABLE_PREFIX "vbug (userid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid)
    VALUES (" 
$vbulletin->userinfo['userid'] . ", '" $db->escape_string($vbulletin->GPC['title']) . "', '" $db->escape_string($vbulletin->GPC['description']) . "', " $vbug_statusid ", '" TIMENOW "', " $vbulletin->GPC['vbug_severityid'] . ", " $vbulletin->GPC['vbug_typeid'] . ", " $vbulletin->GPC['vbug_versionid'] . ", " $vbulletin->GPC['moderate'] . ", " TIMENOW ", " $vbulletin->userinfo['userid'] . ")
    "
); 
and replace with
PHP Code:
    $db->query_write("
    INSERT INTO " 
TABLE_PREFIX "vbug (userid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid)
    VALUES (" 
$vbulletin->userinfo['userid'] . ", '" $db->escape_string($vbulletin->GPC['title']) . "', '" $db->escape_string($vbulletin->GPC['description']) . "', " $vbug_statusid ", '" TIMENOW "', " $vbulletin->GPC['vbug_severityid'] . ", " $vbulletin->GPC['vbug_typeid'] . ", " $vbulletin->GPC['vbug_versionid'] . ", " $moderate ", " TIMENOW ", " $vbulletin->userinfo['userid'] . ")
    "
); 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01211 seconds
  • Memory Usage 1,809KB
  • 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
  • (7)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