private static function validateaddVote($input) { if (CookiesManager::GetUserState() != 'closed') { foreach ($input as $key => $value) { switch ($key) { case "stance": if (is_bool($input[$key])) { $validity['stance'] = 'valid'; break; } else { $validity['stance'] = 'invalid'; break; } case "comment": if (is_string($input[$key])) { $input[$key] = trim($input[$key]); if (strlen($input[$key]) <= 350) { $validity['comment'] = 'valid'; break; } else { $validity['comment'] = 'invalid'; break; } } else { $validity['comment'] = 'invalid'; break; } default: return false; } } return $validity; } else { echo CookiesManager::GetUserState(); return false; } }
public static function insertRegVote($pID, $uID, $vStance, $vComment) { mysqli_real_escape_string(dbConnect::dbGetLink(), $vComment); if (CookiesManager::GetUserState() != 'closed') { if (CookiesManager::GetUserState() == 'only_voted') { $vID = CookiesManager::vGetCookie(); $q = "UPDATE votes SET stance={$vStance}, user_id={$uID}, comment='{$vComment}', commenttime=NOW() WHERE vote_id = {$vID}"; $r = mysqli_query(dbConnect::dbGetLink(), $q); if ($r) { $outcome[] = mysqli_affected_rows(dbConnect::dbGetLink()) == 1 ? true : false; $outcome[] = $vID; return $outcome; } else { return $outcome[] = false; } } else { $q = "INSERT INTO votes (poll_id, stance, votetime, user_id, comment, commenttime) VALUES ({$pID}, {$vStance}, NOW(), {$uID}, '{$vComment}', NOW())"; $r = mysqli_query(dbConnect::dbGetLink(), $q); if ($r) { if (mysqli_affected_rows(dbConnect::dbGetLink()) == 1) { $outcome[] = true; $outcome[] = mysqli_insert_id(dbConnect::dbGetLink()); return $outcome; } else { return $outcome[] = false; } } else { return $outcome[] = false; } } } }