Quote:
Originally Posted by ThorstenA
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'));
}