function ResetVote($postids, $action)
{
/*
Testing stuff...
echo 'Posts: '.implode(', ',$_POST['post']);
echo '<br />';
echo "Action: ".$action;
*/
global $wpdb;
//$wpdb->show_errors();
switch ($action) {
case 'none':
//do nothing
break;
case 'delete':
//reset all votes for the post
$i = 0;
while ($i < count($postids)) {
$wpdb->query("UPDATE " . $wpdb->prefix . "votes SET votes = '',guests = '',usersinks = '', guestsinks = '' WHERE `post`=" . $postids[$i] . " LIMIT 1 ;");
$i++;
}
EditVoteSuccess();
break;
case 'deleteuser':
//reset all votes for users
$i = 0;
while ($i < count($postids)) {
$wpdb->query("UPDATE " . $wpdb->prefix . "votes SET votes = '',usersinks = '' WHERE post=" . $postids[$i] . " LIMIT 1 ;");
$i++;
}
EditVoteSuccess();
break;
case 'deleteguest':
//reset all votes for guests
$i = 0;
while ($i < count($postids)) {
$wpdb->query("UPDATE " . $wpdb->prefix . "votes SET guests = '',guestsinks = '' WHERE post=" . $postids[$i] . " LIMIT 1 ;");
$i++;
}
EditVoteSuccess();
break;
}
}
function ResetVote($postids, $action)
{
global $wpdb, $voteiu_databasetable;
switch ($action) {
case 'delete':
//reset all votes for the post
$i = 0;
while ($i < count($postids)) {
$wpdb->query("DELETE FROM " . $voteiu_databasetable . " WHERE `post`=" . $wpdb->escape($postids[$i]) . " ;");
$i++;
}
EditVoteSuccess();
break;
case 'deleteuser':
//reset all votes for users
$i = 0;
while ($i < count($postids)) {
$wpdb->query("DELETE FROM " . $voteiu_databasetable . " WHERE type = 'vote' post=" . $wpdb->escape($postids[$i]) . " ;");
$wpdb->query("DELETE FROM " . $voteiu_databasetable . " WHERE type = 'sink' post=" . $wpdb->escape($postids[$i]) . " ;");
$i++;
}
EditVoteSuccess();
break;
case 'deleteguest':
//reset all votes for guests
$i = 0;
while ($i < count($postids)) {
$wpdb->query("DELETE FROM " . $voteiu_databasetable . " WHERE type = 'guestvote' post=" . $wpdb->escape($postids[$i]) . " ;");
$wpdb->query("DELETE FROM " . $voteiu_databasetable . " WHERE type = 'guestsink' post=" . $wpdb->escape($postids[$i]) . " ;");
$i++;
}
EditVoteSuccess();
break;
}
}
