public function view() { RoutingEngine::setPage("runnDAILY View Route", "PV__300"); RoutingEngine::getInstance()->registerParams("rid"); if (!isset($_GET["rid"])) { Page::redirect("/routes"); } $rid = $_GET["rid"]; //$route = Route::fromRouteIdentifier($rid); $route = Route::sql()->select("routes.*, u_username, u_uid")->leftjoin("users", "u_uid", "r_uid", true)->where_eq("r_id", $rid)->execute(true, false); //get training types for create new training modal /*$stmt = Database::getDB()->prepare(" SELECT t_type_id, t_type_name FROM training_types "); $stmt->execute(); $stmt->store_result(); $types = array(); while($row = $stmt->fetch_assoc()){ $types[] = array("id"=>$row["t_type_id"], "name"=>$row["t_type_name"]); } $stmt->close();*/ $types_sql = new SQL("training_types"); $types = $types_sql->select("t_type_id, t_type_name")->execute(false, true); //$training_items = TrainingLog::getItemsForUserForRoute(User::$current_user->uid, $rid); $training_items = TrainingLog::sql()->select("r_name, t_rid, t_tid, t_time, t_distance, t_pace, t_date, t_comment")->leftjoin("routes", "r_id", "t_rid")->where_eq("t_uid", User::$current_user->uid)->where_eq("t_rid", $rid)->orderby("t_date")->execute(false, true); RoutingEngine::getSmarty()->assign("t_types", $types); RoutingEngine::getSmarty()->assign("route_view", $route); RoutingEngine::getSmarty()->assign("training_items", $training_items); }
/** * Get the categories list * * @param integer Parent category ID * @param integer Level * @return array Categories */ function fcpf_categories_select($parent_category_ID = -1, $level = 0) { global $blog, $DB; $result_Array = array(); $SQL = new SQL(); $SQL->SELECT('cat_ID, cat_name'); $SQL->FROM('T_categories'); $SQL->WHERE('cat_blog_ID = ' . $DB->quote($blog)); if ($parent_category_ID == -1) { $SQL->WHERE_and('cat_parent_ID IS NULL'); } else { $SQL->WHERE('cat_parent_ID = ' . $DB->quote($parent_category_ID)); } $SQL->ORDER_BY('cat_name'); $categories = $DB->get_results($SQL->get()); if (!empty($categories)) { foreach ($categories as $category) { $result_Array[] = array('value' => $category->cat_ID, 'label' => str_repeat(' ', $level) . $category->cat_name); $child_Categories_opts = fcpf_categories_select($category->cat_ID, $level + 1); if ($child_Categories_opts != '') { foreach ($child_Categories_opts as $cat) { $result_Array[] = $cat; } } } } return $result_Array; }
public static function _clean($max) { $db = new SQL(0); $conn = $db->Verbindungsnr(0); $max = mysql_real_escape_string(time() - $max, $conn); return mysql_query("DELETE FROM `user_sessions` WHERE `access` < '{$max}'", $conn); }
function smarty_function_init_language($params, &$smarty) { global $site, $leht; $content_template =& $leht->content_template; ################## # default values extract($params); if (!isset($name)) { $name = "language"; } # / default values ################### $sql = $site->db->prepare("SELECT keel_id AS id, nimi AS name, extension FROM keel WHERE on_kasutusel"); $sth = new SQL($sql); $sth->debug->msg($sth->debug->get_msgs()); while ($result = $sth->fetch()) { // if not in editor and use aliases has been enabled if (!$site->in_editor && $site->CONF['use_aliases']) { $result['href'] = $site->CONF['wwwroot'] . '/' . $result['extension']; } else { $result['href'] = $site->CONF['wwwroot'] . ($site->in_editor ? '/editor' : '') . '/?lang=' . $result['extension']; } $result['home_id'] = $site->alias(array('key' => 'rub_home_id', 'keel' => $result['id'])); $language[] = $result; } ############## # assign to template variables $smarty->assign(array($name => $language)); }
public function test() { $sql = new SQL(); $doc = $sql->main(); echo $doc; $this->assertNotEquals($doc, true); }
/** * Uninstall b2evolution: Delete DB & Cache files */ function uninstall_b2evolution() { global $DB; /* REMOVE PAGE CACHE */ load_class('_core/model/_pagecache.class.php', 'PageCache'); // Remove general page cache $PageCache = new PageCache(NULL); $PageCache->cache_delete(); // Skip if T_blogs table is already deleted. Note that db_delete() will not throw any errors on missing tables. if ($DB->query('SHOW TABLES LIKE "T_blogs"')) { // Get all blogs $blogs_SQL = new SQL(); $blogs_SQL->SELECT('blog_ID'); $blogs_SQL->FROM('T_blogs'); $blogs = $DB->get_col($blogs_SQL->get()); $BlogCache =& get_BlogCache('blog_ID'); foreach ($blogs as $blog_ID) { $Blog = $BlogCache->get_by_ID($blog_ID); // Remove page cache of current blog $PageCache = new PageCache($Blog); $PageCache->cache_delete(); } } /* REMOVE DATABASE */ db_delete(); echo '<p>' . T_('Reset done!') . '</p>'; }
function forum_do_edit_stick(&$sqlm) { global $forum_lang, $user_lvl, $mmfpm_db; $sqlm = new SQL(); $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); if ($user_lvl == 0) { error($forum_lang['no_access']); } if (!isset($_GET['id'])) { error($forum_lang['no_such_topic']); } else { $id = $sqlm->quote_smart($_GET['id']); } if (!isset($_GET['state'])) { error('Bad request, please mail admin and describe what you did to get this error.'); } else { $state = $sqlm->quote_smart($_GET['state']); } $sqlm->query(' UPDATE mm_forum_posts SET sticked = ' . $state . ' WHERE id = ' . $id . ''); $sqlm->close(); redirect('forum.php?action=view_topic&id=' . $id . ''); // Queries : 1 }
function TreeSearch($searches, $classes, $language_id = 0) { global $site; $this->classes = (array) $classes; foreach ($this->classes as $i => $class) { $this->classes[$i] = "'" . mysql_real_escape_string($class) . "'"; } $sql = 'select tyyp_id from tyyp where klass in (' . implode(',', $this->classes) . ');'; $result = new SQL($sql); $this->classes = array(); while ($row = $result->fetch('ASSOC')) { $this->classes[] = $row['tyyp_id']; } $where = 'tyyp_id in (' . implode(',', $this->classes) . ') and keel = ' . mysql_real_escape_string($language_id) . ' '; foreach ($searches as $field => $keyword) { $where .= ' and ' . mysql_real_escape_string($field); if ($field == 'objekt_id' || $field == 'ttyyp_id' || $field == 'page_tyyp_id' || $field == 'kesk') { $where .= ' = ' . (int) $keyword; } else { $where .= " like '%" . mysql_real_escape_string($keyword) . "%' "; } } $sql = 'select objekt_id from objekt where ' . $where . ';'; //printr($sql); $result = new SQL($sql); while ($row = $result->fetch('ASSOC')) { $this->found_object_ids[] = $row['objekt_id']; } }
function html_header() { if (!defined('SITE_ROOT')) { define('SITE_ROOT', './'); } require SITE_ROOT . 'portal_config.php'; require_once SITE_ROOT . 'include/database.class.php'; $currentUserID = $_SESSION['current_userID']; $db = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false); $db->query("SELECT * FROM forum_users WHERE id='{$currentUserID}'"); if ($row = $db->fetch_array()) { $username = $row['username']; $realname = $row['realname']; } $db->close(); if ($realname !== null) { $displayname = $realname; } else { $displayname = $username; } echo ' <div id="wrap"> <div class="navbar navbar-top"><div class="navbar-inner"><div class="container"> <a class="brand" href="#index.php"><div class="logo-ip"></div></a> <div class="btn-group pull-left"> <a href="../forum" class="btn btn-inverse"><i class="icon-rss"></i> Forum Ishare</a> </div> <div class="btn-group"> <button class="btn dropdown-toggle" data-toggle="dropdown"><i class="icon-list muted"></i> KampusLinks <span class="caret"></span></button> <ul class="dropdown-menu"> <li><a href="http://mpp.eng.usm.my/">MPPUSMKKj Official Blog</a></li> <li><a href="http://hepp.eng.usm.my/">BHEPP USMKKj</a></li> <li><a href="http://infodesk.eng.usm.my/">Infodesk PPKT USMKKj</a></li> <li><a href="http://www.eng.usm.my/php/blockedIP/">Blocked Port List</a></li> <li><a href="http://elearning.usm.my/">e-Learning Portal</a></li> <li><a href="http://campusonline.usm.my/">CampusOnline Portal</a></li> <li><a href="http://www.tcom.usm.my/">Sistem Direktori Telefon USM</a></li> <li><a href="http://www.facebook.com/ppkt.eng.usm">Facebook PPKT USMKKj</a></li> <li class="divider"></li> <li><a href="http://hik3.net/refcode"><i class="icon-bookmark"></i> RefCode (Snippets)</a></li> </ul> </div> <div class="btn-group pull-right"> <a href="index.php" class="btn btn-primary"><i class="icon-home icon-white"></i> Home</a> <a href="profile.php?id=' . $currentUserID . '" class="btn btn-inverse"><i class="icon-user"></i> ' . $displayname . '</a> <button class="btn btn-danger dropdown-toggle" data-toggle="dropdown"><span class="caret"></span></button> <ul class="dropdown-menu"> <li><a href="edit_profile.php"><i class="icon-edit muted"></i> Edit Profile</a></li> <li><a href="edit_sharerlink.php"><i class="icon-hdd muted"></i> Edit Sharerlink</a></li> <li class="divider"></li> <li><a href="../forum/login.php?action=out&id=' . $currentUserID . '"><i class="icon-off muted"></i> Logout</a></li> </ul> </div> </div></div></div> '; }
public function test() { $sql = new SQL(); echo "Hello"; $doc = $sql->main(); //$doc = false; $this->assertNotEquals($doc, false); }
private static function _load($id) { if (isset(self::$_cache[$id])) { return; } $db = new SQL(0); self::$_cache[$id + 0] = $db->cmdrow(0, 'SELECT * FROM user_list WHERE id={0} LIMIT 0,1', array($id + 0)); }
public function build(Breakdown $bk, $tabs) { $bk->append(" UNION"); if ($this->all) { $bk->append(" ALL"); } $this->sql->build($bk, $tabs); }
function smarty_function_init_folders($params, &$smarty) { global $site, $leht, $class_path; include_once $class_path . 'adminpage.inc.php'; ############## # default values extract($params); if (!isset($name)) { $name = 'folders'; } if (!isset($parent) && !isset($parent_dir)) { # default parent for file (folder "public/"): get folder ID of "public/" $sql = $site->db->prepare("SELECT objekt_id, relative_path FROM obj_folder WHERE relative_path = ? LIMIT 1", $site->CONF['file_path']); $sth = new SQL($sql); $folder = $sth->fetch(); $parent_dir = $folder['relative_path']; $parent = $folder['objekt_id']; } elseif (isset($parent)) { # get parent folder info $parent = (int) $parent; if ($parent) { $sql = $site->db->prepare("SELECT objekt_id, relative_path FROM obj_folder WHERE objekt_id = ?", $parent); $sth = new SQL($sql); } else { return; } } elseif (isset($parent_dir)) { $parent_dir = preg_replace('#^/#', '', $parent_dir); $parent_dir = preg_replace('#/$#', '', $parent_dir); $sql = $site->db->prepare("SELECT objekt_id, relative_path FROM obj_folder WHERE relative_path = ? LIMIT 1", '/' . $parent_dir); $sth = new SQL($sql); if ($sth->rows == 1) { $folder = $sth->fetch(); $parent_dir = $folder['relative_path']; $parent = $folder['objekt_id']; } } else { return; } $folders = array(); $folders_from_fm = get_subfolders($parent); foreach ($folders_from_fm as $folder) { $obj = new stdClass(); # Bug #2318 $obj->title = $folder['title']; $obj->path = $folder['relative_path']; $obj->id = $folder['objekt_id']; # current folder ID $obj->parent_id = $folder['parent_id']; ## parent folder ID?? $obj->fullpath = $site->absolute_path . $folder['relative_path']; # absolute path of the folder $obj->file_count = $folder['file_count']; $folders[] = $obj; } $smarty->assign($name, $folders); return; }
public static function allread($data) { if (!MyUser::isloggedin()) { throw new APIException("Nicht angemeldet...", 100); } $db = new SQL(0); $db->cmd(0, 'DELETE * FROM user_notification WHERE user = {0}', true, array(MyUser::id())); return true; }
function get_realm_name($realm_id) { global $realm_db; $sqlr = new SQL(); $sqlr->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); $result = $sqlr->query("SELECT name FROM `realmlist` WHERE id = '{$realm_id}'"); $realm_name = $sqlr->result($result, 0); return $realm_name; }
/** * Delete a Categorie in DB * parameters = POST: Categorie ID */ public function deleteKategorien() { require 'classes/SQL.php'; $sql = new SQL(); $sql->connect(); $id = mysql_real_escape_string($_POST['id']); if (is_numeric($id)) { $sql->doThat('DELETE FROM quizCategories WHERE id=' . $id); } }
/** * Remove Question in DB * parameters = POST: QuestionID */ public function deleteQuestion() { require 'classes/SQL.php'; $sql = new SQL(); $sql->connect(); $id = mysql_real_escape_string($_POST['id']); if (is_numeric($gameID)) { $sql->doThat('DELETE FROM quizQuestions WHERE id=' . mysql_real_escape_string($id)); } }
/** * Execute the query and fetch data in required format to be written to DBF file. */ function getData() { $objSQL = new SQL(); $resultSet = $objSQL->getQueryResults($this->sqlQuery); $this->schema = $resultSet["Header"]; $this->result = $resultSet["Data"]; if ($resultSet["Memo"]) { $this->memodata = $resultSet["Memo"]; } }
/** * This source file is is part of Saurus CMS content management software. * It is licensed under MPL 1.1 (http://www.opensource.org/licenses/mozilla1.1.php). * Copyright (C) 2000-2010 Saurused Ltd (http://www.saurus.info/). * Redistribution of this file must retain the above copyright notice. * * Please note that the original authors never thought this would turn out * such a great piece of software when the work started using Perl in year 2000. * Due to organic growth, you may find parts of the software being * a bit (well maybe more than a bit) old fashioned and here's where you can help. * Good luck and keep your open source minds open! * * @package SaurusCMS * @copyright 2000-2010 Saurused Ltd (http://www.saurus.info/) * @license Mozilla Public License 1.1 (http://www.opensource.org/licenses/mozilla1.1.php) * */ function smarty_function_save_mailinglist($params, &$smarty) { global $site; extract($params); $user_id = (int) $user; if (!$user_id) { $user_id = $site->user->user_id; } ################### # salvestame mailinglistide valik # muide, kui kasutaja e-mail salvestati tühjana, siis ei lisata ka ühtegi meili-listi ja kustutatakse vanadki if ($user_id) { // get user data $sql = $site->db->prepare('select * from users where user_id = ?', $user_id); $result = new SQL($sql); $user_data = $result->fetch('ASSOC'); ################### # salvestame mailinglistide valik # ja lisada uued mailinglistid ################### # kustutada vanad mailinglistid $sql = $site->db->prepare("SELECT user_mailinglist.objekt_id FROM user_mailinglist LEFT JOIN objekt ON user_mailinglist.objekt_id = objekt.objekt_id WHERE user_mailinglist.user_id = ? AND objekt.keel=?", $user_id, $site->keel); $sth = new SQL($sql); $site->debug->msg($sth->debug->get_msgs()); $del_obj = array(); while ($del_obj_id = $sth->fetchsingle()) { $del_obj[] = $del_obj_id; } $sql = $site->db->prepare("DELETE FROM user_mailinglist WHERE user_id=? AND FIND_IN_SET(objekt_id,?)", $user_id, join(",", $del_obj)); $sth = new SQL($sql); $site->debug->msg($sth->debug->get_msgs()); # ja lisada uued (NB! aga ainult siis kui kasutaja e-mail ei ole tühi) if (trim($site->user->all['email'] != '') && is_array($fields)) { # rubrigide ID kontroll # kas on seal meilinglist, kas on rubriik avaldatud $sql = $site->db->prepare("SELECT obj_rubriik.objekt_id FROM obj_rubriik,objekt WHERE obj_rubriik.objekt_id=objekt.objekt_id AND objekt.on_avaldatud='1' AND obj_rubriik.on_meilinglist = '1' AND find_in_set(obj_rubriik.objekt_id, ?)", join(",", $fields)); $sth = new SQL($sql); $site->debug->msg($sth->debug->get_msgs()); $values = array(); while ($objekt_id = $sth->fetchsingle()) { $values[] = $site->db->prepare("(?,?)", $user_id, $objekt_id); } if (sizeof($values)) { $sql = "INSERT INTO user_mailinglist (user_id, objekt_id) VALUES " . join(",", $values); $sth = new SQL($sql); $site->debug->msg($sth->debug->get_msgs()); } } # if mõni meilinglist oli chekitud } # kui kasutaja lisati edukalt # / salvestame mailinglistide valik ################### }
function search() { global $lang_global, $lang_mail, $output, $itemperpage, $item_datasite, $mangos_db, $characters_db, $realm_id, $sql_search_limit; wowhead_tt(); if (!isset($_GET['search_value']) || !isset($_GET['search_by'])) { redirect("mail_on.php?error=2"); } $sql = new SQL(); $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $search_value = $sql->quote_smart($_GET['search_value']); $search_by = $sql->quote_smart($_GET['search_by']); $search_menu = array('sender', 'receiver'); // if (!array_key_exists($search_by, $search_menu)) $search_by = 'sender'; $start = isset($_GET['start']) ? $sql->quote_smart($_GET['start']) : 0; $order_by = isset($_GET['order_by']) ? $sql->quote_smart($_GET['order_by']) : "id"; $dir = isset($_GET['dir']) ? $sql->quote_smart($_GET['dir']) : 1; $order_dir = $dir ? "ASC" : "DESC"; $dir = $dir ? 0 : 1; $temp = $sql->query("SELECT guid FROM `characters` WHERE name like '%{$search_value}%'"); $search_value = $sql->result($temp, 0, 'guid'); $query_1 = $sql->query("SELECT count(*) FROM `mail`"); $query = $sql->query("SELECT a.id, a.messageType, a.sender, a.receiver, a.subject, a.itemTextId, a.has_items, a.money, a.cod, a.checked, b.item_template\r\n FROM mail a\r\n INNER JOIN mail_items b ON a.id = b.mail_id\r\n WHERE {$search_by} = {$search_value}\r\n ORDER BY {$order_by} {$order_dir} LIMIT {$start}, {$itemperpage}"); $this_page = $sql->num_rows($query); $all_record = $sql->result($query_1, 0); $total_found = $sql->num_rows($query); //==========================top page navigation starts here======================== $output .= "<center><table class=\"top_hidden\">\r\n <tr><td>\r\n <table class=\"hidden\">\r\n <tr><td>\r\n <form action=\"mail_on.php\" method=\"get\" name=\"form\">\r\n <input type=\"hidden\" name=\"action\" value=\"search\" />\r\n <input type=\"hidden\" name=\"error\" value=\"4\" />\r\n <input type=\"text\" size=\"45\" name=\"search_value\" />\r\n <select name=\"search_by\">\r\n <option value=\"sender\">Sender</option>\r\n <option value=\"receiver\">Receiver</option>\r\n </select></form></td><td>"; makebutton($lang_global['search'], "javascript:do_submit()", 80); $output .= "</td></tr></table>\r\n <td align=\"right\">"; $output .= generate_pagination("mail_on.php?action=search&order_by={$order_by}&dir=" . !$dir, $all_record, $itemperpage, $start); $output .= "</td></tr></table>"; //==========================top page navigation ENDS here ======================== $output .= "<table class=\"lined\">\r\n <tr>\r\n <th width=\"5%\">" . $lang_mail['id'] . "</th>\r\n <th width=\"5%\">" . $lang_mail['mail_type'] . "</th>\r\n <th width=\"10%\">" . $lang_mail['sender'] . "</th>\r\n <th width=\"10%\">" . $lang_mail['receiver'] . "</th>\r\n <th width=\"15%\">" . $lang_mail['subject'] . "</th>\r\n <th width=\"5%\">" . $lang_mail['has_items'] . "</th>\r\n <th width=\"25%\">" . $lang_mail['text'] . "</th>\r\n <th width=\"20%\">" . $lang_mail['money'] . "</th>\r\n <th width=\"5%\">" . $lang_mail['checked'] . "</th>\r\n </tr>"; while ($mail = $sql->fetch_array($query)) { $g = floor($mail[7] / 10000); $mail[7] -= $g * 10000; $s = floor($mail[7] / 100); $mail[7] -= $s * 100; $c = $mail[7]; $money = ""; if ($mail[7] > 0) { $money = $g . "<img src=\"./img/gold.gif\" /> " . $s . "<img src=\"./img/silver.gif\" /> " . $c . "<img src=\"./img/copper.gif\" /> "; } $output .= "<tr valign=top>\r\n <td>{$mail['0']}</td>\r\n <td>" . get_mail_source($mail[1]) . "</td>\r\n <td><a href=\"char.php?id={$mail['2']}\">" . get_char_name($mail[2]) . "</a></td>\r\n <td><a href=\"char.php?id={$mail['3']}\">" . get_char_name($mail[3]) . "</a></td>\r\n <td>{$mail['4']}</td>\r\n "; $output .= "<td>"; $output .= "\r\n <a style=\"padding:2px;\" href=\"{$item_datasite}{$mail[10]}\" target=\"_blank\">\r\n <img class=\"bag_icon\" src=\"" . get_item_icon($mail[10]) . "\" alt=\"\" />\r\n </a>"; //maketooltip("<img src=\"./img/up.gif\" alt=\"\">", $item_datasite{$mail[10]}, $mail[10], "item_tooltip", "target=\"_blank\""); $output .= "</td>"; $output .= "<td>" . get_mail_text($mail[5]) . "</td>\r\n <td>{$money}</td>\r\n <td>" . get_check_state($mail[9]) . "</td>\r\n </tr>"; } /*--------------------------------------------------*/ $output .= "<tr><td colspan=\"6\" class=\"hidden\" align=\"right\">All Mails: {$all_record}</td></tr>\r\n </table></center>"; $sql->close(); }
function smarty_resource_style_timestamp($tpl_name, &$tpl_timestamp, &$smarty) { // do database call here to populate $tpl_timestamp. $sql = new SQL(); $sql->query("select tpl_timestamp\n from my_table\n where tpl_name='{$tpl_name}'"); if ($sql->num_rows) { $tpl_timestamp = $sql->record['tpl_timestamp']; return true; } else { return false; } }
/** * Return Data-Model for the View */ private function getModel() { require_once 'classes/SQL.php'; $model = new stdClass(); $model->template = 'admin/HighscoreTable'; $model->isAdmin = person::getPermissionName() == 'admin' ? 'true' : 'false'; $model->gameID = $this->getGameId(); $sql = new SQL(); $sql->connect(); $model->data = $sql->get("SELECT * FROM ViewHighscore ORDER BY GamerMainScore DESC"); return $model; }
function smarty_function_sync_folder($params, &$smarty) { global $site, $leht, $class_path; ############## # default values extract($params); //if(!isset($name)) { $name = 'folder'; } //eelista id'd if (isset($id)) { $id = (int) $id; $objekt = new Objekt(array('objekt_id' => $id)); //printr($objekt->all); //kui on album if ($objekt->all['tyyp_id'] == 16) { $conf = new CONFIG($objekt->all['ttyyp_params']); if ($folder_path = $conf->get('path')) { $folder_path = preg_replace('#^/#', '', $folder_path); $folder_path = preg_replace('#/$#', '', $folder_path); $folder_abs_path = $site->absolute_path . $folder_path; $sql = $site->db->prepare('select objekt_id from obj_folder where relative_path = ?', '/' . $folder_path); $result = new SQL($sql); if ($result->rows) { $id = $result->fetchsingle(); include_once $class_path . 'picture.inc.php'; generate_images($folder_abs_path, $conf->get('tn_size'), $conf->get('pic_size')); } else { //no such folder return; } } else { //no image folder set return; } } elseif ($objekt->all['tyyp_id'] != 22) { return; } } elseif (isset($path)) { $path = (string) $path; $path = preg_replace('#^/#', '', $path); $path = preg_replace('#/$#', '', $path); $sql = $site->db->prepare('select objekt_id from obj_folder where relative_path = ?', $path); $result = new SQL($sql); if ($result->rows) { $id = $result->fetchsingle(); } else { //no such folder return; } } include_once $class_path . 'adminpage.inc.php'; synchronise_folder($id); }
protected static function _load($id) { if (isset(self::$_cache[$id])) { return self::$_cache[$id]; } $db = new SQL(0); $row = $db->cmdrow(0, 'SELECT * FROM questions WHERE id={0} LIMIT 0,1', array($id)); if (!isset($row["id"])) { return null; } self::$_cache[$row["id"]] = $row; return $row; }
public function trigger() { if ($this->Game->current_chamber == $this->Game->bullet_chamber) { $this->SQL->delete_game($this->chat_id); $this->SQL->update_stats($this->user_id, true); return true; } else { $this->Game->current_chamber++; $this->SQL->update_game($this->Game); $this->SQL->update_stats($this->user_id); return false; } }
function get_mail_text($id) { global $characters_db, $realm_id; if ($id) { $sqlc = new SQL(); $sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $result = $sqlc->query("SELECT `body` FROM `mail` WHERE `id` = '{$id}'"); $text_subject = $sqlc->result($result, 0); return $text_subject; } else { return NULL; } }
function get_char_name($id) { global $characters_db, $realm_id; if ($id) { $sqlc = new SQL(); $sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $result = $sqlc->query("SELECT `name` FROM `characters` WHERE `guid` = '{$id}'"); $player_name = $sqlc->result($result, 0); return $player_name; } else { return NULL; } }
function dologin(&$sqlr) { global $mmfpm_db, $require_account_verify; if (empty($_POST['user']) || empty($_POST['pass'])) { redirect('login.php?error=2'); } $user_name = $sqlr->quote_smart($_POST['user']); $user_pass = $sqlr->quote_smart($_POST['pass']); if (255 < strlen($user_name) || 255 < strlen($user_pass)) { redirect('login.php?error=1'); } $result = $sqlr->query('SELECT id, username FROM account WHERE username = \'' . $user_name . '\' AND sha_pass_hash = \'' . $user_pass . '\''); $result2 = $sqlr->query('SELECT id, gmlevel FROM account_access'); if ($require_account_verify) { $sqlm = new SQL(); $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); $result2 = $sqlm->query("SELECT * \n\t\t\t\t\t\t\t\t\tFROM mm_account_verification \n\t\t\t\t\t\t\t\t\tWHERE username = '******'"); if ($sqlm->num_rows($result2) >= 1) { $sqlm->close; redirect('login.php?error=7'); } } unset($user_name); if (1 == $sqlr->num_rows($result)) { $id = $sqlr->result($result, 0, 'id'); if ($sqlr->result($sqlr->query('SELECT count(*) FROM account_banned WHERE id = ' . $id . ' AND active = \'1\''), 0)) { redirect('login.php?error=3'); } else { $_SESSION['user_id'] = $id; $_SESSION['uname'] = $sqlr->result($result, 0, 'username'); if ($sqlr->result($result2, 0, 'gmlevel') == null) { $_SESSION['user_lvl'] = 0; } else { $_SESSION['user_lvl'] = $sqlr->result($result2, 0, 'gmlevel'); } $_SESSION['realm_id'] = $sqlr->quote_smart($_POST['realm']); $_SESSION['client_ip'] = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : getenv('REMOTE_ADDR'); $_SESSION['logged_in'] = true; if (isset($_POST['remember']) && $_POST['remember'] != '') { setcookie('uname', $_SESSION['uname'], time() + 60 * 60 * 24 * 7); setcookie('realm_id', $_SESSION['realm_id'], time() + 60 * 60 * 24 * 7); setcookie('p_hash', $user_pass, time() + 60 * 60 * 24 * 7); } redirect('index.php'); } } else { redirect('login.php?error=1'); } }
/** * calculate creature health, mana and armor * * kinda crappy way, but works * * if $type is used: * 1 -> returns health * 2 -> returns mana * 3 -> returns armor * 0 -> returns array(health,mana,armor) */ function get_additional_data($entryid, $type = 0) { global $world_db, $realm_id; if (!is_numeric($entryid)) { return array(0, 0, 0); } $sqlw = new SQL(); $sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']); $q = $sqlw->query("\n\t\tSELECT \n\t\t\t(SELECT unit_class \n\t\t\tFROM creature_template \n\t\t\tWHERE entry = " . $entryid . ") AS class, \n\t\t\t\t(SELECT FLOOR(minlevel + (RAND() * (maxlevel - minlevel + 1))) \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ") AS level, \n\t\t\t\t(SELECT exp \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ") AS exp;"); $data = $sqlw->fetch_assoc($q); if ($sqlw->num_rows($q) == 0) { return array(0, 0, 0); } $q = "\n\t\t\tSELECT \n\t\t\t\t((SELECT Health_Mod \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ")\n\t\t\t\t\t*(SELECT basehp" . $data['exp'] . " \n\t\t\t\t\tFROM creature_classlevelstats \n\t\t\t\t\tWHERE level = " . $data['level'] . " AND class = " . $data['class'] . ")+0.5), \n\t\t\t\t((SELECT Mana_Mod \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ")\n\t\t\t\t\t*(SELECT basemana \n\t\t\t\t\tFROM creature_classlevelstats \n\t\t\t\t\tWHERE level = " . $data['level'] . " AND class = " . $data['class'] . ")+0.5),\n\t\t\t\t((SELECT Armor_Mod \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ")\n\t\t\t\t*(SELECT basearmor \n\t\t\t\tFROM creature_classlevelstats \n\t\t\t\tWHERE level = " . $data['level'] . " AND class = " . $data['class'] . ")+0.5);"; if ($type == 1) { $q = "\n\t\t\tSELECT \n\t\t\t\t((SELECT Health_Mod \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ")\n\t\t\t\t\t*(SELECT basehp" . $data['exp'] . " \n\t\t\t\t\tFROM creature_classlevelstats \n\t\t\t\t\tWHERE level = " . $data['level'] . " AND class = " . $data['class'] . ")+0.5);"; } if ($type == 2) { $q = "\n\t\t\tSELECT \n\t\t\t\t((SELECT Mana_Mod \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ")\n\t\t\t\t\t*(SELECT basemana \n\t\t\t\t\tFROM creature_classlevelstats \n\t\t\t\t\tWHERE level = " . $data['level'] . " AND class = " . $data['class'] . ")+0.5);"; } if ($type == 3) { $q = "\n\t\t\tSELECT \n\t\t\t\t((SELECT Armor_Mod \n\t\t\t\tFROM creature_template \n\t\t\t\tWHERE entry = " . $entryid . ")\n\t\t\t\t\t*(SELECT basearmor \n\t\t\t\t\tFROM creature_classlevelstats \n\t\t\t\t\tWHERE level = " . $data['level'] . " AND class = " . $data['class'] . ")+0.5);"; } $query = $sqlw->query($q); $result = $sqlw->fetch_row($query); $sqlw->close(); unset($sql); if ($type == 2 && $result[0] == 0.5) { return 0; } if ($type == 0 && $result[1] == 0.5) { return array($result[0], 0, $result[2]); } return $type > 0 ? $result[0] : $result; }
public static function tnquestion($data) { $db = new SQL(0); $out = array(); $rows = $db->cmdrows(0, 'SELECT *,MATCH (title,question,tags) AGAINST ("{0}") as Score FROM questions WHERE MATCH (title,question,tags) AGAINST ("{0}") ORDER BY Score DESC LIMIT 0,10', array($data["term"])); foreach ($rows as $row) { $b = array(); $b["label"] = $row["title"]; $b["value"] = $row["title"]; $b["type"] = "question"; $b["score"] = $row["Score"] + 0; $out[] = $b; } return $out; }