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; } }