File: /home/mckernan/public_html/iJournal/includes/notes/newinternal.php
<?php
// add new internal note
// init database name
$database = DB_PREFIX;
// process request
if ($sid != '')
{
// sid check
require "includes/session/sidck.php";
// init return value
$rv = '<root>' . PHP_EOL;
// fetch database name / open db
$dbname = '';
if ( isset($_POST['db']) ) $dbname = $_POST['db'];
if ( isset($_GET['db']) ) $dbname = $_GET['db'];
if ($dbname == '') die();
$database .= $dbname;
require "includes/db.php";
// fetch / validate params
$valid = true;
$note = getvar($db, 'note', 'string');
if (strlen($note) < 4) $valid = false;
if ($valid)
{
$query = "INSERT INTO notes_internal (inot_note, inot_active) VALUES ('" . $note . "', 1)";
if ($result = $db->query($query))
{
if ($db->affected_rows == 1)
{
$rv .= "<success>true</success>" . PHP_EOL;
}
else
{
$rv .= "<success></success>" . PHP_EOL;
}
}
else
{
$rv .= "<success></success>" . PHP_EOL;
}
}
else
{
$rv .= "<success></success>" . PHP_EOL;
}
// finish output
$rv .= '</root>' . PHP_EOL;
// return data
echo $rv;
die;
}
else
{
header('Server: ');
header('X-Powered-By: ');
header("HTTP/1.0 404 Not Found");
}
?>