<?php
error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);
if (isset($_GET['viewsource']))
{
echo("<table><tr><td nowrap>");
show_source("newquests.php");
die("</td></tr></table>");
}
$chkdate = $_POST['lastcheckdate'];
if (strtotime($chkdate) == -1)
die('<error reason="Invalid date specified" />');
// Connection to mysql is done in sql_config.php, which is included before this file
if (defined('MYSQL_CONNECTED'))
{
if ($result = mysql_query("SELECT * FROM QuestTimer_AvailableQuests WHERE DateAdded > '$chkdate' AND Approved ORDER BY DateAdded ASC, QuestName DESC"))
{ //The sort order is reverse of what it should be, because the plugin reverses it back
echo('<NewQuests>');
while($data = mysql_fetch_array($result))
{
foreach($data as $key => $value)
$data[$key] = htmlentities($value);
echo("<Quest QuestName=\"$data[QuestName]\" Days=\"$data[Days]\" Hours=\"$data[Hours]\" Minutes=\"$data[Minutes]\" Text=\"$data[Text]\" " .
"Item=\"$data[Item]\" Chest=\"$data[Chest]\" Droppable=\"$data[Droppable]\" DateAdded=\"$data[DateAdded]\" SubmittedBy=\"$data[SubmittedBy]\" />");
}
echo('</NewQuests>');
}
else echo('<error reason="SQL Query error: ' . mysql_error() . '" />');
}
else echo('<error reason="Failed to connect to database" />');
/* Create Table:
mysql_query("CREATE TABLE QuestTimer_AvailableQuests (
QuestID int NOT NULL auto_increment,
QuestName varchar(75) NOT NULL default '',
Days int NOT NULL default '0',
Hours int NOT NULL default '0',
Minutes int NOT NULL default '0',
Text varchar(255) default '',
Item varchar(100) default '',
Chest varchar(100) default '',
Droppable bool NOT NULL default '0',
SubmittedBy varchar(50) default '',
DateAdded datetime NOT NULL default '0000-00-00 00:00:00',
Approved bool NOT NULL default '0',
PRIMARY KEY (QuestID) )"); */
?>
|