function dbQuery($query)
{
$db = dbInit();
$q = $db->query($query);
$db->num_queries++;
return $q;
}
function dbExec($sql)
{
dbInit();
$res = mysql_query($sql);
// обработка ошибок
if (false === $res) {
return false;
}
return true;
}
<?php
session_start();
$displayLoginMsg = false;
$displayLogoutMsg = false;
$error = false;
if (!isset($_SESSION['connected']) && isset($_POST['pseudo']) && $_POST['pseudo'] && isset($_POST['pwd']) && $_POST['pwd']) {
$pseudo = htmlentities($_POST['pseudo']);
$pwd = $_POST['pwd'];
include '../db.php';
$db = dbInit();
$answer = $db->prepare("SELECT id, pseudo, password, rank FROM members WHERE pseudo = ?");
$answer->execute(array($pseudo));
$error = ($line = $answer->fetch()) ? false : true;
if (!$error) {
$error = password_verify($pwd, $line['password']) ? false : true;
if (!$error) {
$_SESSION['connected'] = true;
$_SESSION['id'] = $line['id'];
$_SESSION['pseudo'] = $line['pseudo'];
$_SESSION['rank'] = $line['rank'];
$displayLoginMsg = true;
}
}
} else {
if (isset($_POST['action']) && $_POST['action'] == 'logout' && isset($_SESSION['connected'])) {
unset($_SESSION['connected']);
unset($_SESSION['id']);
$displayLogoutMsg = true;
}
}
/**
* run a database query
*
* @param string $query the query to run
*
* @return mixed false if it failed, or the database resource if successful
*/
function dbQuery($query)
{
$db = dbInit();
$q = $db->query($query);
if ($q === false) {
// failed
return false;
}
$db->num_queries++;
return $q;
}
function dbSingleValue(&$session, $query)
{
$session->trace(TC_Db3 + TC_Query, "dbSingleValue: {$query}");
dbInit($session);
$value = "";
$result = mysql_query($query, $session->fDbInfo);
if (!$result) {
protoc(mysql_error());
} else {
$row = mysql_fetch_row($result);
if ($row) {
$value = $row[0];
mysql_free_result($result);
}
// $row
}
$session->trace(TC_Query, "dbSingleValue Wert: {$value}");
return $value;
}
$siteAuthor = htmlspecialchars($instd['siteAuthor'], ENT_QUOTES, 'UTF-8');
$siteKey = sha1($instd['siteKey']);
$infoConfContent = "<?php\n\$conf=array (\n 'siteName' => '{$l['data.sitename']}',\n 'siteURL' => '{$siteURL}',\n 'authorName' => '{$siteAuthor}',\n 'authorIntro' => '{$l['data.siteintro']}',\n 'siteKey' => '{$siteKey}',\n 'timeZone' => 'Asia/Shanghai',\n 'pageCache' => '0',\n 'commentOpt' => '0',\n 'comFrequency' => '10',\n 'comPerLoad' => '20',\n 'siteTheme' => 'default',\n 'siteLang' => '{$l['data.lang']}',\n 'perPage' => '3',\n 'linkPrefixIndex' => 'index.php',\n 'linkPrefixCategory' => 'category.php',\n 'linkPrefixArticle' => 'read.php',\n 'linkPrefixTag' => 'tag.php',\n 'social-sina-weibo' => '',\n 'social-weixin' => '',\n 'social-twitter' => '',\n 'social-facebook' => '',\n 'social-douban' => '',\n 'social-instagram' => '',\n 'social-renren' => '',\n 'social-linkedin' => '',\n 'externalLinks' => 'http://bw.bo-blog.com=bW Home',\n);";
$writeResult = $writeResult && @file_put_contents('./conf/info.php', $infoConfContent);
$servicesConfContent = "<?php\n\$conf+=array (\n 'duoshuoID' => '',\n 'disqusID' => '',\n 'sinaAKey' => '',\n 'sinaSKey' => '',\n 'qiniuAKey' => '',\n 'qiniuSKey' => '',\n 'qiniuBucket' => '',\n 'qiniuSync' => '',\n 'qiniuUpload' => '0',\n 'qiniuDomain' => '',\n);";
$writeResult = $writeResult && @file_put_contents('./conf/services.php', $servicesConfContent);
if (!$writeResult) {
$rslt7 = $rslt8 = $rslt9 = 0;
$rslt10 = $l['data.error'];
} else {
$rslt7 = 1;
define('P', './');
include P . 'inc/database.inc.php';
$db = new bwDatabase();
$dbInitBind = dbInitBind();
foreach (dbInit($instd['dbType']) as $i => $dbInit) {
if ($dbInitBind[$i]) {
$db->dbExec($dbInit, $dbInitBind[$i]);
} else {
$db->dbExec($dbInit);
}
}
$rslt8 = $rslt9 = 1;
$rslt10 = $l['data.success'];
}
$errorStatus = $rslt7 * $rslt8 * $rslt9 ? 0 : 1;
die(json_encode(array('error' => $errorStatus, 'rslt7' => $rslt7, 'rslt8' => $rslt8, 'rslt9' => $rslt9, 'rslt10' => $rslt10)));
}
}
function dataFilter($reservedKeys, $submitData)
{
<?php
include "XMLTools.php";
dbInit();
dbClean();
/*
$fn = "../../data/stock/stock_onto.xml";
$res = Web_Common_XMLTools::XMLFileToArray($fn, true);
foreach($res['node']['class'] as $id=>$v)
{
$ov = $v;
unset($v['_attr_label']);
unset($v['_attr_report_type']);
unset($v['prop']);
unset($v['alias']);
unset($v['description']);
unset($v['__xml_array__items__']);
if(count($v) == 0)
continue;
print_r($v);
print_r($ov);
sleep(10);
continue;
die();
}
die();
print_r($res);
*/
$fn = "../../data/stock/stock_phrase_semantic.xml";
$res = Web_Common_XMLTools::XMLFileToArray($fn, true);
//print_r($res);
<?php
include '../db.php';
$conn = dbInit();
function param($name, $defaultValue)
{
$p = isset($_GET[$name]) ? $_GET[$name] : null;
if (!$p || empty($p)) {
$p = $defaultValue;
}
return $p;
}
// Read query params.
$company = param('c', "");
$group = param('g', "");
$driver = param('d', "");
$slice = param('s', "");
$t0 = param('t0', "");
$t1 = param('t1', "");
$df = param('df', "");
$ds = param('ds', "");
// Set default source.
if (!$ds) {
$ds = "fleet_moving_daily_score";
}
// Test values.
//$t0 = " DATE_SUB(NOW(), INTERVAL 1 MONTH) ";
//$company = "29";
//$group = "*";
//$group = "49";
//$driver = "*";
<?php require '../model.php'; assert(true === dbInit()); ?> TEST PASSED
