function db_query($q)
{
global $DB_NAME, $DB_USEOLDLIB;
$conn = db_connect();
if (!$conn) {
return false;
}
if ($DB_USEOLDLIB) {
mysql_select_db($DB_NAME);
$retval = mysql_query($q, $conn);
} else {
$retval = $conn->query($q);
}
if (!$retval) {
return false;
}
$res = array();
// this may not be needed, since $retval already is an array
$row = null;
if ($DB_USEOLDLIB) {
while ($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
array_push($res, $row);
}
} else {
while ($row = mysqli_fetch_array($retval, MYSQL_ASSOC)) {
array_push($res, $row);
}
}
db_close($conn);
return $res;
}
function main()
{
// создаем сессию
session_start();
if (is_current_user()) {
// если пользователь уже залогинен, то отправляем его на глапную
redirect('./');
}
if (is_postback()) {
// обрабатываем отправленную форму
$dbh = db_connect();
$post_result = register_user($dbh, $user, $errors);
db_close($dbh);
if ($post_result) {
// перенаправляем на главную
redirect('./');
} else {
// информация о пользователе заполнена неправильно, выведем страницу с ошибками
render('register_form', array('form' => $_POST, 'errors' => $errors));
}
} else {
// отправляем пользователю чистую форму для регистрации
render('register_form', array('form' => array(), 'errors' => array()));
}
}
/**
* return array of the courses associated to a netid
*
* @param string $netid
* @return array key: course code; value: course description
*/
function courses_list($netid)
{
// prepared requests
$statements = array('course_all_get' => 'SELECT DISTINCT ' . db_gettable('courses') . '.course_code AS mnemonic, ' . db_gettable('courses') . '.course_name AS label ' . 'FROM ' . db_gettable('courses') . ' ' . 'ORDER BY mnemonic ASC', 'user_courses_get' => 'SELECT DISTINCT ' . db_gettable('users_courses') . '.ID, ' . db_gettable('courses') . '.course_code, ' . db_gettable('courses') . '.shortname, ' . db_gettable('courses') . '.course_name, ' . db_gettable('courses') . '.in_recorders, ' . db_gettable('users_courses') . '.origin ' . 'FROM ' . db_gettable('courses') . ' ' . 'INNER JOIN ' . db_gettable('users_courses') . ' ON ' . db_gettable('courses') . '.course_code = ' . db_gettable('users_courses') . '.course_code ' . 'WHERE user_ID = :user_ID');
$db = db_prepare($statements);
if (!$db) {
debuglog("could not connect to sgbd:" . mysql_error());
die;
}
$result = array();
if ($netid == "") {
// retrieves all courses in the database
$course_list = db_courses_all_get();
$result = array();
foreach ($course_list as $value) {
$result[$value['mnemonic']] = $value['mnemonic'] . '|' . $value['label'];
}
} else {
// retrieves all courses for a given netid
$course_list = db_user_courses_get($netid);
$result = array();
foreach ($course_list as $value) {
$result[$value['course_code']] = $value['course_code'] . '|' . $value['course_name'];
}
}
db_close();
return $result;
}
function Bod_Ver($opcion) {
/* El OPTION es para saber si queremos ver el LISTADO de bodegas o SOLO UNA bodega.
* true = SOLO UNA
* false = LISTADO
*/
if ($opcion == false) {
$queryBodegaVer = "SELECT Bodega_ID, Ubicacion, Descripcion_Bod FROM bodega ORDER BY Bodega_ID;";
} else {
$queryBodegaVer = "SELECT Bodega_ID, Ubicacion, Descripcion_Bod FROM bodega WHERE Bodega_ID = $this->bodega_id;";
}
db_connect();
$resultset = mysql_query($queryBodegaVer);
if ($resultset == false) {
$return = false;
} else {
$contador_array = 0;
while ($row = mysql_fetch_array($resultset)) {
$bodega[$contador_array][0] = $row["Bodega_ID"];
$bodega[$contador_array][1] = $row["Ubicacion"];
$bodega[$contador_array][2] = $row["Descripcion_Bod"];
$contador_array++;
}
$return = $bodega;
}
db_close();
return $return;
}
/**
* Return all booking headers for the supplied date
* @param $bdate [in] the date
* @param $rs [in/out] The result array of headers
*
* @return Number of elements added to RS $rs
* $rs[idx]['Id'] = Booking Id
* $rs[idx]['Date'] = Booking date
* $rs[idx]['Time'] = Booking time
* $rs[idx]['Name'] = Guest Name
*/
function GetBookingDataForDate($bdate, &$rs)
{
$conn = connect_Hotel_db(HOST, USER, PASS, DB, PORT);
if (!$conn) {
print "Cannot connect to database<br>\n";
}
$rs = array();
$sql = "SELECT g.lastname,g.firstname,g.middlename,b.booking_type,b.checkout_date AS CODate, TIME(b.codatetime) AS COTime, b.book_id\n\t\tFROM guests g RIGHT OUTER JOIN booking b ON g.guestid=b.guestid\n\t\tWHERE b.checkout_date='" . $bdate . "'\n\t\tORDER BY COTime ASC ";
if (DEBUG) {
print "Debug BOOKING QRY " . $sql . "<br>\n";
}
$result = mysql_query($sql, $conn);
$i = 0;
while ($row = mysql_fetch_assoc($result)) {
if (DEBUG) {
print "DEBUG Booking " . $row['CODate'] . $row['COTime'] . "<br>\n";
}
$rs[$i]['Id'] = $row['book_id'];
$rs[$i]['Date'] = $row['CODate'];
$rs[$i]['Time'] = $row['COTime'];
$rs[$i]['Name'] = $row['lastname'] . "," . $row['firstname'] . " " . $row['middlename'];
$i++;
}
db_close($conn);
return sizeof($rs);
}
function main()
{
session_start();
// обрабатываем отправленную форму
//Если передан гет запрос, то открыть запрашиваемую страницу,
//иначе открыть категорию catgory_id=1
$dbh = db_connect();
if (is_current_user()) {
$count_in_car = product_count_in_car($dbh);
} else {
$count_in_car = array();
}
if (is_postbuy()) {
if (is_current_user()) {
$product = array('count' => 1, 'user_id' => $_SESSION['user_id'], 'product_id' => $_POST['buy_product_id']);
db_product_incar_insert($dbh, $product);
} else {
redirect('login.php');
}
}
/*Если передан поисковой запрос и он не пустой, то находим товар по введенному поисковому запросу */
if (is_getfind()) {
$items_result = db_product_find_like_title($dbh, $_GET['search_text']);
$search_text = $_GET['search_text'];
if ($items_result == null) {
$items_result = 'products_not_found';
}
} else {
$items_result = null;
$search_text = null;
}
$category_items = db_product_find_category_all($dbh);
db_close($dbh);
render('Find_Template', array('items' => $items_result, 'category' => $category_items, 'count_in_car' => $count_in_car, 'search_text' => $search_text));
}
function url_change($redirect = "")
{
global $_josh, $_POST;
if ($redirect === false) {
//if redirect is really set to FALSE, send to site home
$redirect = "/";
} elseif (empty($redirect)) {
//if redirect is an empty string, refresh the page by sending back to same URL
$redirect = $_josh["request"]["path_query"];
}
if ($_josh["slow"]) {
error_debug("<b>url_change</b> (slow) to " . $redirect);
if ($_josh["debug"]) {
db_close();
}
echo "<html><head>\n\t\t\t\t<script language='javascript'>\n\t\t\t\t\t<!--\n\t\t\t\t\tlocation.href='" . $redirect . "';\n\t\t\t\t\t//-->\n\t\t\t\t</script>\n\t\t\t</head><body></body></html>";
} else {
error_debug("<b>url_change</b> (fast) to " . $redirect);
if ($_josh["debug"]) {
db_close();
}
header("Location: " . $redirect);
}
db_close();
}
function DoWapShowMsg($error, $returnurl = 'index.php', $ecms = 0)
{
global $empire, $public_r;
$gotourl = str_replace('&', '&', $returnurl);
if (strstr($gotourl, "(") || empty($gotourl)) {
if (strstr($gotourl, "(-2")) {
$gotourl_js = "history.go(-2)";
$gotourl = "javascript:history.go(-2)";
} else {
$gotourl_js = "history.go(-1)";
$gotourl = "javascript:history.go(-1)";
}
} else {
$gotourl_js = "self.location.href='{$gotourl}';";
}
if ($ecms == 9) {
echo "<script>alert('" . $error . "');" . $gotourl_js . "</script>";
} elseif ($ecms == 7) {
echo "<script>alert('" . $error . "');window.close();</script>";
} else {
@(include ECMS_PATH . DASHBOARD . '/wap/message.php');
}
db_close();
$empire = null;
exit;
}
function execQuery($query)
{
$conn = db_open();
$rs = mysql_query($query, $conn);
// or die (mysql_error());
db_close($conn);
return $rs;
}
function ReNewsHtml($start, $classid, $from, $retype, $startday, $endday, $startid, $endid, $tbname, $havehtml)
{
global $empire, $public_r, $class_r, $fun_r, $dbtbpre, $etable_r;
$tbname = RepPostVar($tbname);
if (empty($tbname)) {
printerror("ErrorUrl", "history.go(-1)");
}
$start = (int) $start;
//按ID
if ($retype) {
$startid = (int) $startid;
$endid = (int) $endid;
$add1 = $endid ? ' and id>=' . $startid . ' and id<=' . $endid : '';
} else {
$startday = RepPostVar($startday);
$endday = RepPostVar($endday);
$add1 = $startday && $endday ? ' and truetime>=' . to_time($startday . ' 00:00:00') . ' and truetime<=' . to_time($endday . ' 23:59:59') : '';
}
//按栏目
$classid = (int) $classid;
if ($classid) {
$where = empty($class_r[$classid][islast]) ? ReturnClass($class_r[$classid][sonclass]) : "classid='{$classid}'";
$add1 .= ' and ' . $where;
}
//不生成
$add1 .= ReturnNreInfoWhere();
//是否重复生成
if ($havehtml != 1) {
$add1 .= ' and havehtml=0';
}
//优化
$yhadd = '';
$yhid = $etable_r[$tbname][yhid];
$yhvar = 'rehtml';
if ($yhid) {
$yhadd = ReturnYhSql($yhid, $yhvar);
}
$b = 0;
$sql = $empire->query("select * from {$dbtbpre}ecms_" . $tbname . " where " . $yhadd . "id>{$start}" . $add1 . " and checked=1 order by id limit " . $public_r[renewsnum]);
while ($r = $empire->fetch($sql)) {
if (!empty($r['titleurl']) || $class_r[$r[classid]][showdt] == 2) {
continue;
}
$b = 1;
GetHtml($r, '', 1);
//生成信息文件
$new_start = $r[id];
}
if (empty($b)) {
echo "<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><center><b>" . $tbname . $fun_r[ReTableIsOK] . "!</b></center>";
db_close();
$empire = null;
exit;
}
echo "<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><meta http-equiv=\"refresh\" content=\"" . $public_r['realltime'] . ";url=ecmschtml.php?enews=ReNewsHtml&tbname={$tbname}&classid={$classid}&start={$new_start}&from={$from}&retype={$retype}&startday={$startday}&endday={$endday}&startid={$startid}&endid={$endid}&havehtml={$havehtml}&reallinfotime=" . $_GET['reallinfotime'] . "\">" . $fun_r[OneReNewsHtmlSuccess] . "(ID:<font color=red><b>" . $new_start . "</b></font>)";
exit;
}
/**
* Print the footer <div> for the bottom of all admin pages.
*
* @param string $addl additional text to output on the footer.
* @author Todd Papaioannou (lucky@luckyspin.org)
* @since 1.0.0
*/
function printAdminFooter($addl = '')
{
?>
<div id="footer">
<?php
printf(gettext('<a href="http://www.zenphoto.org" title="The simpler media website CMS">Zen<strong>photo</strong></a> version %1$s [%2$s]'), ZENPHOTO_VERSION, ZENPHOTO_RELEASE);
if (!empty($addl)) {
echo ' | ' . $addl;
}
?>
| <a href="<?php
echo FULLWEBPATH . '/' . ZENFOLDER . '/license.php';
?>
" title="<?php
echo gettext('Zenphoto licence');
?>
"><?php
echo gettext('License');
?>
</a>
| <a href="http://www.zenphoto.org/news/category/user-guide" title="<?php
echo gettext('User guide');
?>
"><?php
echo gettext('User guide');
?>
</a>
| <a href="http://www.zenphoto.org/support/" title="<?php
echo gettext('Forum');
?>
"><?php
echo gettext('Forum');
?>
</a>
| <a href="https://github.com/zenphoto/zenphoto/issues" title="<?php
echo gettext('Bugtracker');
?>
"><?php
echo gettext('Bugtracker');
?>
</a>
| <a href="http://www.zenphoto.org/news/category/changelog" title="<?php
echo gettext('View Change log');
?>
"><?php
echo gettext('Change log');
?>
</a>
| <?php
printf(gettext('Server date: %s'), date('Y-m-d H:i:s'));
?>
</div>
<?php
db_close();
// close the database as we are done
}
/**
* Print the footer <div> for the bottom of all admin pages.
*
* @param string $addl additional text to output on the footer.
* @author Todd Papaioannou (lucky@luckyspin.org)
* @since 1.0.0
*/
function printAdminFooter($addl = '')
{
?>
<div id="footer">
<?php
printf(gettext('<a href="http://www.zenphoto.org" title="A simpler web album">Zen<strong>photo</strong></a> version %1$s [%2$s]'), ZENPHOTO_VERSION, ZENPHOTO_RELEASE);
if (!empty($addl)) {
echo ' | ' . $addl;
}
?>
| <a href="http://www.gnu.org/licenses/old-licenses/gpl-2.0.html" title="<?php
echo gettext('GPLv2');
?>
"><?php
echo gettext('License:GPLv2');
?>
</a>
| <a href="http://www.zenphoto.org/news/category/user-guide" title="<?php
echo gettext('User guide');
?>
"><?php
echo gettext('User guide');
?>
</a>
| <a href="http://www.zenphoto.org/support/" title="<?php
echo gettext('Forum');
?>
"><?php
echo gettext('Forum');
?>
</a>
| <a href="http://www.zenphoto.org/trac/report/10" title="<?php
echo gettext('Bugtracker');
?>
"><?php
echo gettext('Bugtracker');
?>
</a>
| <a href="http://www.zenphoto.org/news/categorychangelog" title="<?php
echo gettext('View Change log');
?>
"><?php
echo gettext('Change log');
?>
</a>
<br />
<?php
printf(gettext('Server date: %s'), date('Y-m-d H:i:s'));
?>
</div>
<?php
db_close();
// close the database as we are done
}
function delete_student($id)
{
$connection = db_connect();
$query = "DELETE FROM `student` WHERE `student`.`id` = '{$id}'";
$result = mysqli_query($connection, $query);
if ($result) {
//check if query ran
} else {
}
db_close($connection);
}
function get_db_results()
{
$db = db_connect();
$res = $db->query("SELECT choice FROM ballot_box");
$out = array();
while ($obj = $res->fetch_object()) {
$out[] = $obj->choice;
}
$res->close();
db_close($db);
return $out;
}
function getCategories()
{
$categories = array();
$dbhandle = db_connect();
$query = "SELECT CategoryID as id, CategoryName as title FROM Categories";
$result = $dbhandle->query($query);
while ($row = $result->fetch_array()) {
$newcategory = new category($row);
array_push($categories, $newcategory);
}
db_close($dbhandle);
return $categories;
}
function get_post($postid)
{
validate_post_id($postid);
$con = db_connect();
$sql = "SELECT * FROM posts WHERE id={$postid}";
$result = mysql_query($sql);
$post = null;
if (mysql_num_rows($result) > 0) {
$post = mysql_fetch_array($result);
}
db_close($con);
return $post;
}
function sigint_handler()
{
global $sock, $argv, $fp, $mch;
curl_multi_close($mch);
fclose($fp);
socket_close($sock);
unlink("/private/tmp/classmate{$argv['1']}");
db_close();
Error::showSeparator();
Error::setBgColour('#B66');
Error::generate('debug', "Finished running classmated {$argv['1']} normally");
Error::setBgColour('#555');
Error::showSeparator();
}
function file_download($content, $filename, $extension)
{
//header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
//header("Cache-Control: public");
//for IE over SSL
header("Cache-Control: maxage=1");
//In seconds
header("Pragma: public");
header("Content-Description: File Transfer");
header("Content-Type: application/octet-stream");
header("Content-Length: " . strlen($content));
header("Content-Disposition: attachment; filename=" . format_file_name($filename, $extension));
echo $content;
db_close();
}
/**
* Print the footer <div> for the bottom of all admin pages.
*
* @param string $addl additional text to output on the footer.
* @author Todd Papaioannou (lucky@luckyspin.org)
* @since 1.0.0
*/
function printAdminFooter($addl = '')
{
?>
<div id="footer">
<?php
echo gettext('<span class="zenlogo"><a href="https://' . GITHUB . '" title="' . gettext('A simpler media content management system') . '"><img src="' . WEBPATH . '/' . ZENFOLDER . '/images/zen-logo-light.png" /></a></span> ') . sprintf(gettext('version %1$s'), ZENPHOTO_VERSION);
if (!empty($addl)) {
echo ' | ' . $addl;
}
?>
| <a href="<?php
echo FULLWEBPATH . '/' . ZENFOLDER . '/license.php';
?>
" title="<?php
echo gettext('ZenPhoto20 licence');
?>
"><?php
echo gettext('License');
?>
</a>
| <a href="https://<?php
echo GITHUB;
?>
/issues" title="<?php
echo gettext('Support');
?>
"><?php
echo gettext('Support');
?>
</a>
| <a href="https://<?php
echo GITHUB;
?>
/commits/master" title="<?php
echo gettext('View Change log');
?>
"><?php
echo gettext('Change log');
?>
</a>
| <?php
printf(gettext('Server date: %s'), date('Y-m-d H:i:s'));
?>
</div>
<?php
db_close();
// close the database as we are done
}
function db_query_return($query)
{
$valid_query = mysql_real_escape_string($query);
$resultado = false;
if ($valid_query = false) {
$resultado = false;
} else {
db_connect();
$resultado = @mysql_query($valid_query);
if ($resultado != false) {
$resultado_array = mysql_fetch_assoc($resultado);
}
db_close();
}
return $resultado;
}
function main()
{
session_start();
/* Если была выполнена отправка формы, то открыть запрашиваемую страницу,
* иначе открыть главную страницу
*/
$dbh = db_connect();
if (is_postbuy()) {
if (is_current_user()) {
$product = array('count' => 1, 'user_id' => $_SESSION['user_id'], 'product_id' => $_POST['buy_product_id']);
db_product_incar_insert($dbh, $product);
} else {
redirect('login.php');
}
}
if (is_postback() || is_postbuy()) {
// обрабатываем отправленную форму
if (is_current_user()) {
$count_in_car = product_count_in_car($dbh);
$car_items = db_get_product_in_car_by_user($dbh);
/*Добавлен ли продукт в корзин пользователя? */
/* Если корзина пустая, то в массиве хранится значение
Array ( [0] => Array ( [total] => 0 ) ), отсюда получается следующий оператор) исправлю потом */
if ($car_items[0]['total'] !== 0) {
foreach ($car_items as $car_item) {
$car_productid[] = $car_item[0]['id'];
}
} else {
$car_productid[] = null;
}
} else {
$count_in_car = array();
$car_productid[] = null;
}
/*Вывести на страницу товар id которго передан либо гетом(Когда нажали на ссылку товара из других страниц), либо постом(Когда товар купили) */
if (is_postback()) {
$items_result = db_product_find_by_product_id($dbh, $_GET['product_id']);
} elseif (is_postbuy()) {
$items_result = db_product_find_by_product_id($dbh, $_POST['buy_product_id']);
}
$category_items = db_product_find_category_all($dbh);
db_close($dbh);
render('Product_Page_Template', array('items' => $items_result, 'category' => $category_items, 'count_in_car' => $count_in_car, 'car_productid' => $car_productid));
} else {
redirect('index.php');
}
}
function main()
{
session_start();
// обрабатываем отправленную форму
//Если передан гет запрос, то открыть запрашиваемую страницу,
//иначе открыть категорию catgory_id=1
$dbh = db_connect();
if (is_postbuy()) {
if (is_current_user()) {
$product = array('count' => 1, 'user_id' => $_SESSION['user_id'], 'product_id' => $_POST['buy_product_id']);
db_product_incar_insert($dbh, $product);
} else {
redirect('login.php');
}
}
if (is_current_user()) {
$count_in_car = product_count_in_car($dbh);
$car_items = db_get_product_in_car_by_user($dbh);
/*Добавлен ли продукт в корзин пользователя? */
/* Если корзина пустая, то в массиве хранится значение
Array ( [0] => Array ( [total] => 0 ) ), отсюда получается следующий оператор) исправлю потом */
if ($car_items[0]['total'] !== 0) {
foreach ($car_items as $car_item) {
$car_productid[] = $car_item[0]['id'];
}
} else {
$car_productid[] = null;
}
} else {
$count_in_car = array();
$car_productid[] = null;
}
/* показать выбранную категорию*/
if (is_postback() || is_postbuy()) {
if (is_postback()) {
$items_result = db_product_find_by_category_id($dbh, $_GET['catgory_id']);
} else {
$items_result = db_product_find_by_category_id($dbh, $_POST['get_category_id']);
$_GET['catgory_id'] = $_POST['get_category_id'];
}
} else {
$items_result = db_product_find_by_category_id($dbh, 1);
}
$category_items = db_product_find_category_all($dbh);
db_close($dbh);
render('Category_Page_Template', array('items' => $items_result, 'category' => $category_items, 'count_in_car' => $count_in_car, 'car_productid' => $car_productid));
}
function getDbTime()
{
$dbase = db_open($dbase);
if (!$dbase) {
echo "<font class='error'>ERROR</font> : cannot open DB<br>";
exit;
}
$sql = "SELECT UNIX_TIMESTAMP( CONVERT_TZ(now(),@@time_zone,'+0:00') )";
$res = mysqli_query($dbase, $sql);
if (!@$res) {
writelog("error.log", "Wrong query : \" {$sql} \"");
echo "<font class='error'>ERROR</font> : Wrong query : {$sql}<br><br>";
exit;
}
list($date) = mysqli_fetch_row($res);
db_close($dbase);
return $date;
}
function main()
{
// создаем сессию
session_start();
/**************************************************************************
* Вывод "Популярное" на страницу и меню
*/
$dbh = db_connect();
if (is_postbuy()) {
if (is_current_user()) {
$product = array('count' => 1, 'user_id' => $_SESSION['user_id'], 'product_id' => $_POST['buy_product_id']);
db_product_incar_insert($dbh, $product);
} else {
redirect('login.php');
}
}
$items_result = get_popular_products($dbh);
$category_items = db_product_find_category_all($dbh);
db_close($dbh);
/**************************************************************************
* Регистрация
*/
if (is_current_user()) {
// если пользователь уже залогинен, то отправляем его на глапную
redirect('./');
}
if (is_postback()) {
// обрабатываем отправленную форму
$dbh = db_connect();
$post_result = register_user($dbh, $user, $errors);
db_close($dbh);
if ($post_result) {
// перенаправляем на главную
render('sucsess_register', array());
} else {
// информация о пользователе заполнена неправильно, выведем страницу с ошибками
render('register_form', array('form' => $_POST, 'errors' => $errors, 'items' => $items_result, 'category' => $category_items));
}
} else {
// отправляем пользователю чистую форму для регистрации
render('register_form', array('form' => array(), 'errors' => array(), 'items' => $items_result, 'category' => $category_items));
}
}
function main()
{
// создаем сессию
session_start();
if (!is_current_user()) {
// отправляем пользователя на страницу входа в систему
redirect('login.php');
}
// у нас есть пользователь, считываем список пользователей из БД, и отображаем его
// подключаемся к базе данных
$dbh = db_connect();
// считываем список пользователей и текущего пользователя
$user_list = db_user_find_all($dbh);
$current_user = db_user_find_by_id($dbh, get_current_user_id());
// выводим результирующую страницу
render('user_list', array('user_list' => $user_list, 'current_user' => $current_user));
// закрываем соединение с базой данных
db_close($dbh);
}
function LineaVta_Nueva() {
$registro = new StockBodega($this->lineaVtaObra_cantidad, 0, $this->lineaVtaObra_rut_empleado, $this->lineaVtaObra_material_id, $this->lineaVtaObra_bodega_id);
$registro->Stock_Quitar();
if ($registro) {
$queryLineaVta = "INSERT INTO egreso_material_obra (Bodega_ID, Material_ID, Obra_ID, Rut_Emp, Fecha, Cantidad)
VALUES ($this->lineaVtaObra_bodega_id, $this->lineaVtaObra_material_id, $this->lineaVtaObra_ID, '$this->lineaVtaObra_rut_empleado', CURRENT_TIMESTAMP, $this->lineaVtaObra_cantidad)";
db_connect();
$validar = mysql_query($queryLineaVta);
if ($validar) {
$return = true;
} else {
$return = false;
}
db_close();
}
return $return;
}
function main()
{
$product = array();
$errors = empty_errors();
if (is_postback()) {
// подключаемся к базе данных
$dbh = db_connect();
$post_result = add_product($dbh, $product, $errors);
db_close($dbh);
if ($post_result) {
// перенаправляем на список товаров
render('sucsess_register', array());
} else {
render('BD_ProductInsert_T', array('form' => $_POST, 'file' => $_FILES, 'errors' => $errors));
}
} else {
// отправляем пользователю чистую форму для входа
render('BD_ProductInsert_T', array('form' => array(), 'errors' => array()));
}
}
function db_query($q)
{
global $DB_NAME;
$conn = db_connect();
if (!$conn) {
return false;
}
mysql_select_db($DB_NAME);
$retval = mysql_query($q, $conn);
if (!$retval) {
return false;
}
$res = array();
// this may not be needed, since $retval already is an array
while ($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
array_push($res, $row);
}
db_close($conn);
return $res;
}
function login_user($email, $pass)
{
$pass = sha1($pass);
$connection = db_connect();
$query = 'SELECT * FROM `project`.`teacher` WHERE `email` = "' . $email . '" AND pass = "******"';
//create login query
$result = mysqli_query($connection, $query);
//perform login query
if ($result) {
//check if query ran
if (mysqli_num_rows($result) > 0) {
//if any logins are found
//session_clear(); //clear current session variables
//username details
$resultset = mysqli_fetch_assoc($result);
//get array of values from database
$_SESSION['email'] = $resultset['email'];
//Set details as session variables
$_SESSION['id'] = $resultset['id'];
$_SESSION['firstname'] = $resultset['firstname'];
$_SESSION['lastname'] = $resultset['lastname'];
$_SESSION['school'] = $resultset['school'];
add_success($resultset['firstname'] . " " . $resultset['lastname'] . " Logged in Successfully");
db_close($connection);
header('location: dashboard/classview.php');
die;
} else {
add_error("Login Incorrect");
//add error message
db_close($connection);
header('location: index.php');
die;
}
} else {
add_error("Login Mysql didnt work.");
db_close($connection);
header('location: index.php');
die;
}
}
function rss_getItems($local = '')
{
$xml = '';
srand(time());
db_connect();
if (!db_isConnected()) {
return xml;
}
$mails = db_getMailsOf($local . '@pookmail.com', $false);
while ($e = array_pop($mails)) {
$xml .= "<item>\n";
$xml .= "<title>" . $e['subject'] . "</title>\n";
$xml .= "<guid>" . $e['subject'] . "</guid>\n";
$xml .= "<link>http://www.pookmail.com/mailbox.php?email=" . $local . "&sid=" . md5(rand()) . "</link>\n";
$xml .= "<description>" . $e['from'] . "</description>\n";
//$xml .= "<pubDate>".date("D, j M Y H:i:s Z" , $e['date'])."</pubDate>\n";
$xml .= "<pubDate>" . date("r", $e['date']) . "</pubDate>\n";
$xml .= "</item>\n";
}
db_close();
return $xml;
}
