function main($conn, $cmd) { if ($cmd == 'quit') { @setcookie(@siduMD5('SIDUCONN'), '', -1); @setcookie('SIDUSQL', '', -1); } elseif ($cmd == 'close') { $goto = @close_sidu_conn($_GET['id']); if ($goto) { return @header("Location: ./?id={$goto}"); } } elseif ($cmd == @lang(1101)) { if (@substr($_FILES['fconn']['type'], 0, 4) == 'text' && $_FILES['fconn']['size'] && !$_FILES['fconn']['error']) { $err = @init_conn($conn, @file_get_contents($_FILES['fconn']['tmp_name']), $arrConn, $cmd); } else { $err = @lang(1102, 1); } } elseif ($cmd == @lang(1103) || $cmd == @lang(1104)) { $err = @test_conn($conn); if ($cmd == @lang(1104) && !$err) { return @main_conn($conn); } elseif (!$err) { $err = "OK"; } } if ($cmd != "Open" && $conn['txt']) { $err .= @init_conn($conn, @dec65($conn['txt'], 1), $arrConn, $cmd); } elseif ((!$cmd || $cmd == 'quit' || $cmd == 'close') && !$conn['txt'] && $_COOKIE[@siduMD5('SIDUconnS')]) { $err .= @init_conn($conn, @dec65($_COOKIE[@siduMD5('SIDUconnS')], 1), $arrConn, @lang(1101)); } @uppe(); @main_form($conn, $arrConn, $err, $cmd); @down(); }
function main($exp, $cmd) { global $SIDU; if ($_GET['sql']) { $cook = $SIDU['cook'][$SIDU[0]]; @tm_use_db($cook[1], $cook[2]); $mode = "SQL"; $_GET['sql'] = @stripslashes($_GET['sql']); } else { $mode = "DB = {$SIDU['1']}" . ($SIDU[2] ? ".{$SIDU['2']}" : ""); } @valid_data($SIDU, $exp, $cmd); if ($cmd) { @main_cout($SIDU, $exp, $mode); } else { @main_form($SIDU, $exp, $mode); } }
LEFT JOIN cash ON (c.id = cash.customerid) LEFT JOIN divisions d ON (d.id = c.divisionid) WHERE deleted = 0' . ($customer ? ' AND c.id = ' . $customer : '') . ($group ? ' AND ' . ($exclgroup ? 'NOT' : '') . ' EXISTS (SELECT 1 FROM customerassignments a WHERE a.customergroupid = ' . $group . ' AND a.customerid = c.id)' : '') . ' GROUP BY c.id, c.lastname, c.name, c.address, c.zip, c.city, d.account, d.name, d.address, d.zip, d.city HAVING COALESCE(SUM(cash.value), 0.00) < ? ORDER BY c.id', array(str_replace(',', '.', $balance))); if (!$list) { $SESSION->close(); die; } $_TITLE = ConfigHelper::getConfig('finances.pay_title', trans('Not set')); $_LMARGIN = ConfigHelper::getConfig('finances.leftmargin', 0); $_BMARGIN = ConfigHelper::getConfig('finances.bottommargin', 0); require_once LIB_DIR . '/ezpdf.php'; $pdf = init_pdf('A4', 'landscape', trans('Form of Cash Transfer')); $pdf->setLineStyle(2); //$id = $pdf->getFirstPageId(); $count = sizeof($list); $i = 0; foreach ($list as $row) { main_form(0, 0, $row); main_form(0, 310, $row); main_form(440, 0, $row); main_form(440, 310, $row); $i++; //if($i < $count) $id = $pdf->newPage(1, $id, 'after'); if ($i < $count) { $pdf->newPage(); } } close_pdf($pdf);
exit; } if (isset($_POST["SaveConf1"])) { SaveConf1(); exit; } if (isset($_POST["restart-dnsmasq"])) { restart_service(); exit; } if (isset($_GET["interfaces"])) { interfaces(); exit; } if (isset($_GET["ffm1"])) { main_form(); exit; } if (isset($_GET["addressesReload"])) { echo Loadaddresses(); exit; } if (isset($_GET["DnsmasqDeleteInterface"])) { DnsmasqDeleteInterface(); exit; } if (isset($_GET["listen_addresses"])) { SaveListenAddress(); exit; } if (isset($_GET["DnsmasqDeleteListenAddress"])) {
function get_sape_links() { $lnk = dbConnect("", "", ""); $cat = 2665; $top = 300; $start = 0; $ar1 = array('Купить ', 'Продажа ', ''); $ar2 = array(' в интернет-магазине', ' на ychebniki.ru', ' в интернет-магазине ychebniki.ru', ''); $query = "SELECT name as pname,translit as trans FROM ln_product_my ORDER BY id limit {$start},{$top}"; $res = exec_query($query); $str = ""; $file = fopen('links.txt', 'w+'); $schet = 0; while ($rows = fetch_array($res)) { $ii = rand(0, 2); $jj = rand(0, 3); if ($ii == 2 && $jj == 3) { $ii = $ii - 1; } $len = strlen($ar1[$ii]) + strlen($ar2[$jj]) + strlen($rows['pname']) + 7; $str = $ar1[$ii] . "<a href=\"http://ychebniki.ru/products/getdetails/item/" . $rows['trans'] . "\">" . $rows['pname'] . "</a>" . $ar2[$jj] . "\r\n"; if ($len <= 100) { fwrite($file, $str); $schet++; } } fclose($file); dbDisconnect($lnk); return main_form() . "<div>Обработано {$schet} строк</div>"; }