function docleanup($data)
{
global $INSTALLER09, $queries, $bdir;
set_time_limit(0);
ignore_user_abort(1);
$mysql_host = $INSTALLER09['mysql_host'];
$mysql_user = $INSTALLER09['mysql_user'];
$mysql_pass = $INSTALLER09['mysql_pass'];
$mysql_db = $INSTALLER09['mysql_db'];
$bdir = $_SERVER["DOCUMENT_ROOT"] . "/include/backup";
$c1 = "mysqldump -h " . $mysql_host . " -u " . $mysql_user . " -p" . $mysql_pass . " " . $mysql_db . " -d > " . $bdir . "/db_structure.sql";
$c = "mysqldump -h " . $mysql_host . " -u " . $mysql_user . " -p" . $mysql_pass . " " . $mysql_db . " " . tables("peers|messages|sitelog") . " | bzip2 -cq9 > " . $bdir . "/db_" . date("m_d_y", TIME_NOW) . ".sql.bz2";
system($c1);
system($c);
$files = glob($bdir . "/db_*");
foreach ($files as $file) {
if (TIME_NOW - filemtime($file) > 3 * 86400) {
unlink($file);
}
}
$ext = "db_" . date("m_d_y", TIME_NOW) . ".sql.bz2";
sql_query("INSERT INTO dbbackup (name, added, userid) VALUES (" . sqlesc($ext) . ", " . TIME_NOW . ", " . $INSTALLER09['site']['owner'] . ")") or sqlerr(__FILE__, __LINE__);
if ($queries > 0) {
write_log("Auto-dbbackup----------------------Auto Back Up Complete using {$queries} queries---------------------");
}
if (false !== mysqli_affected_rows($GLOBALS["___mysqli_ston"])) {
$data['clean_desc'] = mysqli_affected_rows($GLOBALS["___mysqli_ston"]) . " items deleted/updated";
}
if ($data['clean_log']) {
cleanup_log($data);
}
}
function all_news($news)
{
tables();
foreach ($news as $keys => $param) {
echo "<tr align=center>\n <td>", $keys + 1, "</td>\n <td>", $param, "</td></tr>";
}
}
if ($newsearch) {
$db->addsearch($_SERVER["REMOTE_ADDR"], $name, $desc, $file, $repo, time(), $nres, $duration);
}
if (!($name or $desc or $file)) {
echo "<br><table width=100% style='border-top:1px dotted #000000;border-bottom:1px dotted #000000;'>";
echo "<tr>";
echo "<td width='50%'>";
$gb = new guestbook();
echo "<a href='gb.php'>Guest Book</a>: you can <a href='gb.php'>post comments</a>, suggests, bug/repository reports, or just your signature.<br><br>";
$mm = 5;
echo tables(array("", "", ""), 1, " class='gb' ");
echo tables(array("Date", "Nick", "Message"), 1, " class='gb' ");
while ($message = $gb->fetch() and $mm-- > 0) {
echo tables(array("<sup>{$message['date']}</sup>", "<font color='red'>" . $message['nick'] . "</font> ", "" . $message['message']));
}
echo tables();
echo "<a href='gb.php'>show all</a>";
echo "<nobr><form action='gb.php' method='post'><br>Nick: ";
echo "<input name=nick size=10 maxlenght=15 ";
if (isset($_SESSION['slakhomelinuxguestbooknick'])) {
echo "value='{$_SESSION['slakhomelinuxguestbooknick']}'";
}
echo "> -message: <br>";
echo "<textarea name=message cols=30 rows=3></textarea><br>";
echo "<input type=submit value='go'><br></form></nobr>";
echo "<br>";
echo "</td>";
echo "<td width='50%' valign=top style='border-left:1px dotted #000000'>";
echo "<b>NEWS:</b><br><br>\n\n";
include "news.php";
echo "</td>";
return $html->find('table[@class!="stationdetails"]');
}
function trs($table)
{
return $table->find('tr');
}
function tds($tr)
{
return $tr->find('td');
}
$html = file_get_html($url);
$uniques = array();
//Previous table's name, needed because of a bug in the webpage
$table_name_prev = "t1";
//Table contents
foreach (tables($html) as $table) {
$table_name = $table->id;
foreach (trs($table) as $tr) {
if ($tr->find('th')) {
//Skip the header rows. (There are two per table, and they are formatted differently.)
//Later, we can add something to rename the columns based on headers
continue;
} else {
$row = array();
foreach (tds($tr) as $td) {
$key_raw = $td->headers;
//If the previous table's name is used in the attribute, replace it with the current name
$key = str_replace($table_name_prev, $table_name, $key_raw);
unset($key_raw);
$value = $td->plaintext;
if ($key != '') {
function writereposcompact($reposelected, $righttxt = "")
{
global $classes;
global $defrepo;
redefrepo($reposelected);
$cells = array();
$tab = array();
$versions = array();
$show = false;
$jsarrclass = "'" . implode("','", array_keys($classes)) . "'";
foreach ($classes as $class) {
$hide = true;
$versions[$class['version']] = "";
$archs[$class['arch']] = "";
$cell = array();
$cell['arch'] = "<code>{$class['arch']}</code>";
$cell['version'] = "<code>{$class['version']}</code>";
//$cell['use']="<input type='radio' name='repo' value={$class['class']} ".($class['selected']?"checked='checked'":"").">";
$cell['content'] = "";
foreach ($class['repo'] as $repoid) {
$repo = $defrepo[$repoid];
if ($cell['content']) {
$cell['content'] .= " - ";
}
$cell['content'] .= "<code><nobr>\n\t<input type='radio' name='repo' value={$repo['id']} " . ($repo['selected'] ? "checked='checked'" : "") . ">\n\t<a title='" . str_replace(array("'", "\n"), array(" ", " "), $repo['description']) . "' href='showrepo.php?repo={$repo['id']}'>{$repo['brief']}</a>" . "<sup>({$repo['npkgs']}" . ($repo['manifest'] ? "F" : "") . ($repo['deps'] ? "D" : "") . ")</sup>" . "</nobr></code>";
if ($repo['selected']) {
$hide = false;
}
}
if ($class['selected']) {
$hide = false;
}
$cell['tr'] = " id='{$class['class']}' " . ($hide ? "style='display:none'" : "");
$cells[$class['class']] = $cell;
$tab[$class['version']][$class['arch']] = $class['class'];
if (!$hide) {
$show = true;
}
}
$versions = array_keys($versions);
rsort($versions);
$out = "";
$repo1 = tables(array_merge(array("<input type='radio' name='repo' value=0" . (!$reposelected ? " checked='checked'" : "") . ">All"), array_keys($archs)), 1, " class='repository' width='100%'");
foreach ($versions as $version) {
$tmparr = array_merge(array("<b>" . $version . "</b>"), $archs);
foreach (array_keys($archs) as $arch) {
if (isset($tab[$version][$arch])) {
$class = $classes[$tab[$version][$arch]];
$tmparr[$arch] = "<input type='radio' name='repo' onclick='showclass(\"{$class['class']}\")' value={$class['class']} " . ($class['selected'] ? "checked='checked'" : "") . ">";
}
}
$repo1 .= tables($tmparr);
}
$repo1 .= tables();
$link = "<a href='javascript:void(0)' onclick='javascript:showclass(\"0\");' id='showlink'>show all repositories</a>";
$repo2 = "<div id='reposlist' " . (!$show ? "style='display:none'" : "") . ">";
$repo2 .= tables(array("arch", "distro", "Repository"), 1, " class='repository' ");
foreach ($cells as $cell) {
$repo2 .= tables(array($cell['arch'], $cell['version'], $cell['content']), 2, "", $cell['tr']);
}
$repo2 .= tables();
$repo2 .= "<code>(F) File search support enabled ; (D) View dependencies enabled</code><br><br>";
$repo2 .= "</div>\n";
?>
<script>
function showclass(cls){
document.getElementById('reposlist').style.display='';
var c;
var classes=new Array(<?php
echo $jsarrclass;
?>
);
if(cls=='0'){
document.getElementById("showlink").style.display="none";
for (c in classes){ document.getElementById(classes[c]).style.display=''; }
}else{
document.getElementById("showlink").style.display="";
for (c in classes){ document.getElementById(classes[c]).style.display='none'; }
document.getElementById(cls).style.display='';
}
}
</script>
<?php
$out .= "<table width=100%><tr><td colspan=2>{$repo2}</td></tr><tr><td>{$repo1}</td><td valign=top width=100%>{$link}<br>{$righttxt}</td></tr></table>";
return $out;
}
function msql_boot($msql)
{
$auth = $_SESSION['auth'];
$ath = 6;
$root = 'msql/';
//sesm('root')
$_SESSION['murl'] = murl_read($msql);
list($base, $dir, $prefix, $table, $version, $def) = $_SESSION['murl'];
if ($def) {
$_GET['def'] = $def;
}
$folder = $base . '/' . ($dir ? $dir . '/' : '');
//echo $base.'-d:'.$dir.'-p:'.$prefix.'-t:'.$table.'-v:'.$version.'-d:'.$def.br();
if ($_GET['def']) {
$def = $_GET['def'];
} elseif (is_file(sesm('root') . $folder . $prefix . '_' . $table . '_' . $version . '.php')) {
$_GET['def'] = $def;
} elseif (is_file(sesm('root') . $folder . $prefix . '_' . $table . '.php') && $version) {
$_GET['def'] = ajx($version, 1);
$version = '';
} elseif (is_file(sesm('root') . $folder . $prefix . '.php') && $table) {
$_GET['def'] = $table;
$table = '';
$version = '';
}
if ($dir && !is_dir($root . $folder)) {
$folder = $base . '/';
$dir = '';
}
$files = tables($root . $folder);
//pr($files);
$ra[0] = explore($root, 'dirs', 1);
//bases
if ($auth < 6) {
$rdel = array('lang', 'server', 'clients', 'radio', 'stats', 'gallery', 'db', 'system');
//'system',
foreach ($rdel as $v) {
unset($ra[0][$v]);
}
}
$ra[1] = $base;
//base
if ($dir) {
$ra[2] = explore($root . $base . '/', 'dirs', 1);
}
//dirs
$ra[3] = $dir;
//dir
if ($files && $base) {
$ra[4] = array_keys($files);
//prefixes
foreach ($ra[4] as $k => $v) {
if ($base == 'users' && $v != 'public' && $v != ses('qb') or $auth < 6 && $v != 'public') {
unset($ra[4][$k]);
}
}
}
$ra[5] = $prefix;
$ra[6] = $files;
if ($files && $auth <= $ath) {
foreach ($files as $k => $v) {
if ($k == $_SESSION['USE'] && $k == $_SESSION['qb']) {
$filb[$k] = $v;
} elseif ($k == $_SESSION['USE']) {
$filb[$k] = array('public');
} elseif ($k == 'public') {
$filb[$k] = $v;
}
}
$files = $filb;
}
$ra[7] = $table;
$ra[8] = ajx($version, 1);
$ra[9] = $folder;
$ra[10] = mnod($ra[5], $ra[7], $ra[8]);
return $ra;
}
