File: /home/mckernan/public_html/iJournal/includes/journal/cats.php
<?php
// income categories
// init database name
$database = DB_PREFIX;
// process request
if ($sid != '')
{
// sid check
require "includes/session/sidck.php";
// init return value
$rv = '<root>' . PHP_EOL;
$rv .= '<cats>' . PHP_EOL;
// fetch database name / open db
if ( isset($_POST['db']) ) $dbn = $_POST['db'];
if ( isset($_GET['db']) ) $dbn = $_GET['db'];
if ($dbn == '') die();
$database .= $dbn;
require "includes/db.php";
// fetch categories
$query = "SELECT * FROM categories";
if ($result = $db->query($query))
{
if ($db->affected_rows == 1)
{
$row = $result->fetch_assoc();
$rv .= '<gross>' . $row['in_gross'] . '</gross>' . PHP_EOL;
$rv .= '<hascogs>' . $row['in_hascogs'] . '</hascogs>' . PHP_EOL;
$rv .= '<cogs>' . $row['in_cogs'] . '</cogs>' . PHP_EOL;
$rv .= '<other0>' . $row['in_0'] . '</other0>' . PHP_EOL;
$rv .= '<other1>' . $row['in_1'] . '</other1>' . PHP_EOL;
$rv .= '<other2>' . $row['in_2'] . '</other2>' . PHP_EOL;
$rv .= '<other3>' . $row['in_3'] . '</other3>' . PHP_EOL;
$rv .= '<oh0>' . $row['oh_0'] . '</oh0>' . PHP_EOL;
$rv .= '<oh1>' . $row['oh_1'] . '</oh1>' . PHP_EOL;
$rv .= '<oh2>' . $row['oh_2'] . '</oh2>' . PHP_EOL;
$rv .= '<oh3>' . $row['oh_3'] . '</oh3>' . PHP_EOL;
$rv .= '<oh4>' . $row['oh_4'] . '</oh4>' . PHP_EOL;
$rv .= '<oh5>' . $row['oh_5'] . '</oh5>' . PHP_EOL;
$rv .= '<oh6>' . $row['oh_6'] . '</oh6>' . PHP_EOL;
$rv .= '<oh7>' . $row['oh_7'] . '</oh7>' . PHP_EOL;
$rv .= '<oh8>' . $row['oh_8'] . '</oh8>' . PHP_EOL;
$rv .= '<la0>' . $row['la_0'] . '</la0>' . PHP_EOL;
$rv .= '<la1>' . $row['la_1'] . '</la1>' . PHP_EOL;
$rv .= '<la2>' . $row['la_2'] . '</la2>' . PHP_EOL;
$rv .= '<la3>' . $row['la_3'] . '</la3>' . PHP_EOL;
$rv .= '<la4>' . $row['la_4'] . '</la4>' . PHP_EOL;
$rv .= '<la5>' . $row['la_5'] . '</la5>' . PHP_EOL;
$rv .= '<la6>' . $row['la_6'] . '</la6>' . PHP_EOL;
$rv .= '<la7>' . $row['la_7'] . '</la7>' . PHP_EOL;
$rv .= '<op0>' . $row['op_0'] . '</op0>' . PHP_EOL;
$rv .= '<op1>' . $row['op_1'] . '</op1>' . PHP_EOL;
$rv .= '<op2>' . $row['op_2'] . '</op2>' . PHP_EOL;
$rv .= '<op3>' . $row['op_3'] . '</op3>' . PHP_EOL;
$rv .= '<op4>' . $row['op_4'] . '</op4>' . PHP_EOL;
$rv .= '<op5>' . $row['op_5'] . '</op5>' . PHP_EOL;
$rv .= '<op6>' . $row['op_6'] . '</op6>' . PHP_EOL;
$rv .= '<op7>' . $row['op_7'] . '</op7>' . PHP_EOL;
$rv .= '<op8>' . $row['op_8'] . '</op8>' . PHP_EOL;
$rv .= '<op9>' . $row['op_9'] . '</op9>' . PHP_EOL;
$rv .= '<op10>' . $row['op_10'] . '</op10>' . PHP_EOL;
$rv .= '<op11>' . $row['op_11'] . '</op11>' . PHP_EOL;
$rv .= '<op12>' . $row['op_12'] . '</op12>' . PHP_EOL;
$rv .= '<op13>' . $row['op_13'] . '</op13>' . PHP_EOL;
$rv .= '<op14>' . $row['op_14'] . '</op14>' . PHP_EOL;
$rv .= '<op15>' . $row['op_15'] . '</op15>' . PHP_EOL;
$rv .= '<op16>' . $row['op_16'] . '</op16>' . PHP_EOL;
$rv .= '<op17>' . $row['op_17'] . '</op17>' . PHP_EOL;
$rv .= '<op18>' . $row['op_18'] . '</op18>' . PHP_EOL;
$rv .= '<op19>' . $row['op_19'] . '</op19>' . PHP_EOL;
}
else
{
$rv .= '<gross>0</gross>' . PHP_EOL;
$rv .= '<hascogs>0</hascogs>' . PHP_EOL;
$rv .= '<cogs>0</cogs>' . PHP_EOL;
$rv .= '<other0>0</other0>' . PHP_EOL;
$rv .= '<other1>0</other1>' . PHP_EOL;
$rv .= '<other2>0</other2>' . PHP_EOL;
$rv .= '<other3>0</other3>' . PHP_EOL;
$rv .= '<oh0>0</oh0>' . PHP_EOL;
$rv .= '<oh1>0</oh1>' . PHP_EOL;
$rv .= '<oh2>0</oh2>' . PHP_EOL;
$rv .= '<oh3>0</oh3>' . PHP_EOL;
$rv .= '<oh4>0</oh4>' . PHP_EOL;
$rv .= '<oh5>0</oh5>' . PHP_EOL;
$rv .= '<oh6>0</oh6>' . PHP_EOL;
$rv .= '<oh7>0</oh7>' . PHP_EOL;
$rv .= '<oh8>0</oh8>' . PHP_EOL;
$rv .= '<la0>0</la0>' . PHP_EOL;
$rv .= '<la1>0</la1>' . PHP_EOL;
$rv .= '<la2>0</la2>' . PHP_EOL;
$rv .= '<la3>0</la3>' . PHP_EOL;
$rv .= '<la4>0</la4>' . PHP_EOL;
$rv .= '<la5>0</la5>' . PHP_EOL;
$rv .= '<la6>0</la6>' . PHP_EOL;
$rv .= '<la7>0</la7>' . PHP_EOL;
$rv .= '<op0>0</op0>' . PHP_EOL;
$rv .= '<op1>0</op1>' . PHP_EOL;
$rv .= '<op2>0</op2>' . PHP_EOL;
$rv .= '<op3>0</op3>' . PHP_EOL;
$rv .= '<op4>0</op4>' . PHP_EOL;
$rv .= '<op5>0</op5>' . PHP_EOL;
$rv .= '<op6>0</op6>' . PHP_EOL;
$rv .= '<op7>0</op7>' . PHP_EOL;
$rv .= '<op8>0</op8>' . PHP_EOL;
$rv .= '<op9>0</op9>' . PHP_EOL;
$rv .= '<op10>0</op10>' . PHP_EOL;
$rv .= '<op11>0</op11>' . PHP_EOL;
$rv .= '<op12>0</op12>' . PHP_EOL;
$rv .= '<op13>0</op13>' . PHP_EOL;
$rv .= '<op14>0</op14>' . PHP_EOL;
$rv .= '<op15>0</op15>' . PHP_EOL;
$rv .= '<op16>0</op16>' . PHP_EOL;
$rv .= '<op17>0</op17>' . PHP_EOL;
$rv .= '<op18>0</op18>' . PHP_EOL;
$rv .= '<op19>0</op19>' . PHP_EOL;
}
}
else
{
$rv .= '<gross>0</gross>' . PHP_EOL;
$rv .= '<hascogs>0</hascogs>' . PHP_EOL;
$rv .= '<cogs>0</cogs>' . PHP_EOL;
$rv .= '<other0>0</other0>' . PHP_EOL;
$rv .= '<other1>0</other1>' . PHP_EOL;
$rv .= '<other2>0</other2>' . PHP_EOL;
$rv .= '<other3>0</other3>' . PHP_EOL;
$rv .= '<oh0>0</oh0>' . PHP_EOL;
$rv .= '<oh1>0</oh1>' . PHP_EOL;
$rv .= '<oh2>0</oh2>' . PHP_EOL;
$rv .= '<oh3>0</oh3>' . PHP_EOL;
$rv .= '<oh4>0</oh4>' . PHP_EOL;
$rv .= '<oh5>0</oh5>' . PHP_EOL;
$rv .= '<oh6>0</oh6>' . PHP_EOL;
$rv .= '<oh7>0</oh7>' . PHP_EOL;
$rv .= '<oh8>0</oh8>' . PHP_EOL;
$rv .= '<la0>0</la0>' . PHP_EOL;
$rv .= '<la1>0</la1>' . PHP_EOL;
$rv .= '<la2>0</la2>' . PHP_EOL;
$rv .= '<la3>0</la3>' . PHP_EOL;
$rv .= '<la4>0</la4>' . PHP_EOL;
$rv .= '<la5>0</la5>' . PHP_EOL;
$rv .= '<la6>0</la6>' . PHP_EOL;
$rv .= '<la7>0</la7>' . PHP_EOL;
$rv .= '<op0>0</op0>' . PHP_EOL;
$rv .= '<op1>0</op1>' . PHP_EOL;
$rv .= '<op2>0</op2>' . PHP_EOL;
$rv .= '<op3>0</op3>' . PHP_EOL;
$rv .= '<op4>0</op4>' . PHP_EOL;
$rv .= '<op5>0</op5>' . PHP_EOL;
$rv .= '<op6>0</op6>' . PHP_EOL;
$rv .= '<op7>0</op7>' . PHP_EOL;
$rv .= '<op8>0</op8>' . PHP_EOL;
$rv .= '<op9>0</op9>' . PHP_EOL;
$rv .= '<op10>0</op10>' . PHP_EOL;
$rv .= '<op11>0</op11>' . PHP_EOL;
$rv .= '<op12>0</op12>' . PHP_EOL;
$rv .= '<op13>0</op13>' . PHP_EOL;
$rv .= '<op14>0</op14>' . PHP_EOL;
$rv .= '<op15>0</op15>' . PHP_EOL;
$rv .= '<op16>0</op16>' . PHP_EOL;
$rv .= '<op17>0</op17>' . PHP_EOL;
$rv .= '<op18>0</op18>' . PHP_EOL;
$rv .= '<op19>0</op19>' . PHP_EOL;
}
// finish output
$rv .= '</cats>' . PHP_EOL;
$rv .= '</root>' . PHP_EOL;
// return data
echo $rv;
die;
}
else
{
header('Server: ');
header('X-Powered-By: ');
header("HTTP/1.0 404 Not Found");
}
?>