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