function createShittalkRow($text) { $text_escaped = mysql_escape_mimic(strip_double_quotes($text)); $today = mysql_escape_mimic(date("Y-m-d H:i:s")); $sql = "INSERT INTO `shittalkDB`\n (`text`, `date_created`, `custom`)\n VALUES ('{$text_escaped}', '{$today}', 0);"; $result = mySqlQuery($sql); return $result; }
function timestampDownload() { date_default_timezone_set('America/New_York'); $timestamp = date('Y-m-d G:i:s'); $sql = "UPDATE `timestamps`\n SET uses = uses + 1,\n last_use = '{$timestamp}'\n WHERE `action` = 'download';"; mySqlQuery($sql); }
function timestampDeletion($count = 0, $downvotes = 0, $upvotes = 0) { date_default_timezone_set('America/New_York'); $timestamp = date('Y-m-d G:i:s'); $count_escaped = mysql_escape_mimic($count); $downvotes_escaped = mysql_escape_mimic($downvotes); $upvotes_escaped = mysql_escape_mimic($upvotes); $sql = "UPDATE `timestamps`\n SET uses = uses + 1,\n last_use = '{$timestamp}',\n num_deleted = num_deleted + '{$count_escaped}',\n downvotes_deleted = downvotes_deleted + '{$downvotes_escaped}',\n upvotes_deleted = upvotes_deleted + '{$upvotes_escaped}'\n WHERE `action` = 'delete_Downvoted';"; $result = mySqlQuery($sql); if ($result === true) { echo 'Updated timestamp<br />'; } else { var_dump($result); } }
function createShittalkDB() { $sql = "CREATE TABLE `shittalk_generator`.`shittalkDB` (\n `id` INT NOT NULL AUTO_INCREMENT,\n `text` TEXT NULL,\n `category` TEXT NULL,\n `downloads` INT NULL,\n `views` INT NULL,\n `upvotes` INT NULL,\n `downvotes` INT NULL,\n `highlight` TINYINT NULL,\n `date_created` DATETIME NULL,\n `custom` TINYINT NULL,\n PRIMARY KEY (`id`),\n UNIQUE INDEX `id_UNIQUE` (`id` ASC));"; $result = mySqlQuery($sql); return $result; }
function getTotalBindCount() { $response = ''; $sql = "SELECT COUNT(*) AS `count` FROM shittalkDB;"; $result = mySqlQuery($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $response = $row['count']; } } return $response; }
function downvoteRow($id) { $id_escaped = mysql_escape_mimic($id); $sql = "UPDATE shittalkDB SET downvotes = downvotes + 1 WHERE `id` = {$id_escaped};"; $result = mySqlQuery($sql); return $result; }