View Single Post
  #467  
Old 05-13-2010, 06:24 PM
ThorstenA's Avatar
ThorstenA ThorstenA is offline
 
Join Date: Nov 2004
Posts: 669
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ThorstenA View Post
Bugs:
  • After I delete my entry (have no entries any more), I can not vote again because "I exceeded the limit"
Temporary, not really working solution
(This messes lots of things up in your database as userid 123 will have an effect on userid 12345). It is better to get the userids from a simple SELECT query of forumresults table.

Replace in plugin Easy Forms Part 2
Code:
if ($_REQUEST['do'] == 'deleteformresult')
{
	$caneditform = unserialize($vbulletin->options['caneditform']);
	if ($caneditform && !is_member_of($vbulletin->userinfo, $caneditform))
	{
		print_no_permission();
	}
	$id = $vbulletin->input->clean_gpc('g', 'id', TYPE_UINT);
	$fid = $vbulletin->input->clean_gpc('g', 'fid', TYPE_UINT);
	$db->query_write("DELETE FROM " . TABLE_PREFIX . "formresults WHERE id=$id");
	$db->query_write("UPDATE " . TABLE_PREFIX . "forms SET userids = REPLACE(userids,\"," . $vbulletin->userinfo[userid] . "\",\"\")  WHERE fid=$fid");
	$vbulletin->url = "misc.php?do=forms";	
	eval(print_standard_redirect('redirect_deleteq'));
}
to
Code:
if ($_REQUEST['do'] == 'deleteformresult')
{
	$caneditform = unserialize($vbulletin->options['caneditform']);
	if ($caneditform && !is_member_of($vbulletin->userinfo, $caneditform))
	{
		print_no_permission();
	}
	$id = $vbulletin->input->clean_gpc('g', 'id', TYPE_UINT);
	$fid = $vbulletin->input->clean_gpc('g', 'fid', TYPE_UINT);
	$db->query_write("DELETE FROM " . TABLE_PREFIX . "formresults WHERE id=$id");
	$db->query_write("UPDATE " . TABLE_PREFIX . "forms SET userids = REPLACE(userids,\"," . $vbulletin->userinfo[userid] . "\",\"\")  WHERE fid=$fid");
	$vbulletin->url = "misc.php?do=forms";	
	eval(print_standard_redirect('redirect_deleteq'));
}
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01842 seconds
  • Memory Usage 1,776KB
  • 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
  • (2)bbcode_code
  • (1)bbcode_quote
  • (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