public static function getOne($id) { $data = array(); $sql = ' SELECT * FROM {{translator}} WHERE id=' . $id . ' '; $item = DB::getRow($sql); $sql = ' SELECT * FROM {{translator}} WHERE parent=' . $item['id'] . ' '; $rows = DB::getALL($sql); foreach (Translator::getLanguage() as $ii => $lang) { if ($ii == 0) { $data[$item['lang']] = $item; } else { foreach ($rows as $row) { if ($row['lang'] == $lang['value']) { $data[$row['lang']] = $row; } } } } return $data; }
public static function getValuesNumber($path) { $data = array(); $tree = Tree::getTreeByUrl(); $ids[] = $tree['id']; $ids = array_merge($ids, Tree::getChilds($tree['id'])); $sql = ' SELECT DISTINCT type FROM {{data}} WHERE path=\'' . $path . '\' AND tree IN (' . implode(',', $ids) . ') '; $type = DB::getOne($sql); if ($type) { $sql = ' SELECT MAX(' . Fields::$fieldsName[$type] . ') AS maxv, MIN(' . Fields::$fieldsName[$type] . ') AS minv FROM {{data}} WHERE path=\'' . $path . '\' AND tree IN (' . implode(',', $ids) . ') '; $data = DB::getRow($sql); $data['type'] = substr($type, 0, 1); } if ($data['maxv'] > 0) { return $data; } else { return array(); } }
public function login() { $pass = new Password($this->password); $db = new DB(); $db->where(['email' => $this->email, 'username' => $this->username], 'AND', "OR"); $db->where(['password' => $this->password], 'AND'); $data = $db->getRow($this->table); //_print_r($data); if (count($data) > 0 && $pass->verifyPassword()) { if ($n = $pass->needRehash()) { $newHash = $pass->reHashPassword(); $db->where(['email' => $this->email, 'username' => $this->username], 'AND', "OR"); $db->where(['password' => $this->password], 'AND'); $res = $db->update($this->table, ['hash' => $newHash]); } /************ SET SESSION VARIABLES HERE **************/ //session_start(); $_SESSION['logged'] = TRUE; $_SESSION['userid'] = $data->id; $_SESSION['username'] = $data->username ? $data->username : ""; /****************** END SESSION SETTINGS **************/ return $data; } else { return FALSE; } }
public function indexAction() { //get the aff_camapaign_id $mysql['use_pixel_payout'] = 0; //see if it has the cookie in the campaign id, then the general match, then do whatever we can to grab SOMETHING to tie this lead to if ($_COOKIE['btclickid']) { $click_pid = $_COOKIE['btclickid']; } else { //ok grab the last click from this ip_id $mysql['ip_address'] = DB::quote($_SERVER['REMOTE_ADDR']); $daysago = time() - 2592000; // 30 days ago $click_sql1 = "\tSELECT \tbt_s_clicks.click_id\n\t\t\t\t\t\t\tFROM \t\tbt_s_clicks\n\t\t\t\t\t\t\tLEFT JOIN\tbt_s_clicks_advanced USING (click_id)\n\t\t\t\t\t\t\tLEFT JOIN \tbt_s_ips USING (ip_id)\n\t\t\t\t\t\t\tWHERE \tbt_s_ips.ip_address='" . $mysql['ip_address'] . "'\n\t\t\t\t\t\t\tAND\t\tbt_s_clicks.time >= '" . $daysago . "'\n\t\t\t\t\t\t\tORDER BY \tbt_s_clicks.click_id DESC\n\t\t\t\t\t\t\tLIMIT \t\t1"; $click_row1 = DB::getRow($click_sql1); $click_pid = base_convert($click_row1['click_id'], 10, 36); $mysql['ad_account_id'] = DB::quote($click_row1['ad_account_id']); } $click = ClickModel::model()->getRow(array('conditions' => array('click_id' => base_convert($click_pid, 36, 10)))); if (!$click) { BTApp::end(); } if ($click->get('ad_account_id')) { if (getArrayVar($_GET, 'amount') && is_numeric($_GET['amount'])) { $mysql['use_pixel_payout'] = 1; } if ($mysql['use_pixel_payout'] == 1) { $click->convert(0, $_GET['amount']); } else { $click->convert(); } if ($click->campaign->option('pixel_type')->value) { $sql = "select v1.var_value as v1, v2.var_value as v2, v3.var_value as v3, v4.var_value as v4 from bt_s_clicks_advanced adv\n\t\t\t\t\tleft join bt_s_variables v1 on (v1.var_id=adv.v1_id)\n\t\t\t\t\tleft join bt_s_variables v2 on (v2.var_id=adv.v2_id)\n\t\t\t\t\tleft join bt_s_variables v3 on (v3.var_id=adv.v3_id)\n\t\t\t\t\tleft join bt_s_variables v4 on (v4.var_id=adv.v4_id)\n\t\t\t\t\twhere adv.click_id=?"; $st = DB::prepare($sql); $st->execute(array($click->id())); $row = $st->fetch(); $data['v1'] = $row['v1']; $data['v2'] = $row['v2']; $data['v3'] = $row['v3']; $data['v4'] = $row['v4']; $data['clickid'] = $click->id(); $data['keyword'] = ''; $data['amount'] = $click->payout; $code = replaceTrackerPlaceholders($click->campaign->option('pixel_code')->value, $data); $code = str_replace('[[amount]]', $data['amount'], $code); switch ($click->campaign->option('pixel_type')->value) { case 1: case 2: case 3: echo $code; break; case 4: $ch = curl_init($code); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 Postback-Bot v1.0'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_exec($ch); break; } } } }
public function __construct() { if ($_GET['ref']) { $sql = 'SELECT iuser FROM {{iusers_options}} WHERE selfcode=\'' . $_GET['ref'] . '\''; $iuser = DB::getOne($sql); if ($iuser) { $_SESSION['referal'] = $iuser; } } $sql = 'SELECT * FROM {{tree}} WHERE parent=410 AND visible=1 ORDER BY num'; $list = DB::getAll($sql); foreach ($list as $item) { $fields = Fields::getFieldsByTree($item['id'], 'wide'); $item['pic'] = $fields['files_gal']['image'][0]['path']; $multi = Fields::getMultiFields($item['id']); foreach ($multi['color'] as $row) { $item['list'][$row] = Funcs::$referenceId['color'][$row]['name']; } Run::$colors[$item['id']] = $item; } //print '<pre>';print_r(Run::$colors);die; $sql = 'SELECT * FROM {{tree}} WHERE id=1'; $row = DB::getRow($sql); Run::$socTitle = $row['seo_title']; Run::$socDescription = $row['seo_description']; }
public static function getCity($name) { $data = array(); $sql = 'SELECT * FROM {{regions}} WHERE visible=1 AND parent<>0 AND name=\'' . $name . '\''; $data = DB::getRow($sql); return $data; }
function getEdit() { $sql = 'SELECT * FROM {{cron}} WHERE id=' . $_GET['id'] . ''; $data = DB::getRow($sql); $data['timing'] = explode(' ', $data['timing']); return $data; }
function forgot() { if ($_POST) { DB::escapePost(); $sql = ' SELECT * FROM {{users}} WHERE login=\'' . $_POST['login'] . '\' '; $return = DB::getRow($sql); if ($return) { $pass = Funcs::generate_password(8); $sql = ' UPDATE {{users}} SET pass=MD5(\'' . $pass . '\') WHERE login=\'' . $_POST['login'] . '\' '; DB::exec($sql); $text = ' Здравствуйте, ' . $return["login"] . '.<br /> Ваш новый пароль ' . $pass . '.<br /> Сменить пароль Вы можете в личном кабинете. '; $mail = new Email(); $mail->To($return['email']); $mail->Subject('Восстановление пароля на сайте www.' . str_replace("www.", "", $_SERVER["HTTP_HOST"])); $mail->Text($text); $mail->Send(); } $this->redirect('/'); } else { View::$layout = 'empty'; View::render('site/forgot'); } }
function run($path) { $sql = 'SELECT * FROM {{forms}} WHERE path=\'' . $path . '\''; $form = DB::getRow($sql); $sql = 'SELECT * FROM {{forms_fields}} WHERE forms=' . $form['id'] . ' ORDER BY num'; $fields = DB::getAll($sql); foreach ($fields as $item) { $item['required'] = $item['required'] == 1 ? 'required' : ''; switch ($item['type']) { case 'string': $text .= FormWidget::getString($item); break; case 'text': $text .= FormWidget::getText($item); break; case 'select': $text .= FormWidget::getSelect($item); break; case 'radio': $text .= FormWidget::getRadio($item); break; case 'hidden': $text .= FormWidget::getString($item); break; case '': break; } } return str_replace('{content}', $text, View::getWidget('form', $form)); }
/** * Returns information for a virtual id. * * @param integer $virtual_id The virtual id for which to return * information. * * @return array The virtual email information. */ public function getVirtual($virtual_id) { $sql = 'SELECT ' . $this->_getTableFields('virtuals') . ' FROM ' . $this->_params['tables']['virtuals'] . ' WHERE ' . $this->_getTableField('virtuals', 'virtual_id') . ' = ?'; Horde::log($sql, 'DEBUG'); $virtual = $this->_db->getRow($sql, array((int) $virtual_id), DB_FETCHMODE_ASSOC); $virtual['stripped_email'] = Vilma::stripUser($virtual['virtual_email']); return $virtual; }
public function getLang($id) { $sql = ' SELECT * FROM {{lang}} WHERE id=' . $id . ' '; return DB::getRow($sql); }
/** * Read function must return string value always to make save handler work as expected. Return empty string if there is no data to read. * Return values from other handlers are converted to boolean expression. TRUE for success, FALSE for failure. * * @param string $id * @return string * @author Ken Mickles */ public static function read($id) { $sql = 'SELECT `data` FROM ' . SESSION_DB . '.sessions WHERE id=' . DB::s($id); if ($row = DB::getRow($sql, __LINE__, __FILE__)) { return (string) $row['data']; } return ''; }
function getBindModule() { $sql = ' SELECT * FROM {{relations}} WHERE modul1=\'tree\' AND id1=\'' . Funcs::$uri[1] . '\' '; return DB::getRow($sql); }
static function getOne(array $where, $select = '*', $order = '') { if (!$where) { return false; } self::_init(); return DB::getRow($where, static::$_table, $select, $order); }
public static function getVar($sql, $default = '') { $row = DB::getRow($sql); if (!$row) { return $default; } return array_shift($row); }
/** * Returns associative array of values from the first row * * The returned value will be based upon the sql specified by $sql. This is * basically a wrapper for the * {@link http://pear.php.net/manual/en/package.database.db.db-common.getrow.php DB_common::getCol} * method of the Pear DB module, but DB_FETCHMODE_ASSOC is always used. * * @param string $sql The SQL code to be executed * @param array $data If $sql is a paramatised query, then the data for each parameter goes in this array * @return array * */ public function getRow($sql, $data = array()) { $result = $this->conn->getRow($sql, $data, DB_FETCHMODE_ASSOC); self::logQuery(); if (DB::isError($result)) { throw new LoggedException($result->getMessage() . ". SQL: {$sql}", $result->getCode(), self::module); } return $result; }
public static function getModuleById($id = '') { if (is_numeric($id)) { $sql = 'SELECT * FROM {{modules}} WHERE id=' . $id . ''; return DB::getRow($sql); } else { return false; } }
public static function getOne($id) { $sql = ' SELECT {{requests}}.*, {{iusers}}.name, {{iusers}}.balance FROM {{requests}} INNER JOIN {{iusers}} ON {{requests}}.iuser={{iusers}}.id WHERE {{requests}}.id=' . $id . ' '; $data = DB::getRow($sql); return $data; }
/** * we use a special method m() to create new models, this allows us to among other * things lazy load the include file for that model * * @depends testCreateAndSave */ public function testBuildNewModel() { // fetch a real planet id from the database $row = DB::getRow('select planetID from hotscot_test.planet limit 1'); $planetID = $row['planetID']; $planet = m('planet', $planetID); // assert that this is a planet object $this->assertTrue($planet instanceof PlanetModel); // assert that this planet object was built as expected $this->assertEquals($planet->getID(), $planetID); }
/** * Get user profile * * @param string $user Username */ protected function _getProfile($user) { $query = 'SELECT user_email, user_status, user_url, user_description, user_comments, ' . ' user_city, user_country, user_gender, user_birthday, user_video, ' . ' last_online, last_online_on, activity_log, user_vacation, activity, popularity, ' . ' user_picture, count_classifieds, count_news, count_videos, ' . ' count_attendances, count_wishes, count_galleries, count_blogs ' . ' FROM ' . $this->_params['table'] . ' WHERE user_uid = ?'; $result = $this->_db->getRow($query, array(strval($user)), DB_FETCHMODE_ASSOC); if ($result instanceof PEAR_Error) { return $result; } elseif (empty($result)) { return PEAR::raiseError(sprintf(_("User \"%s\" does not exists."), $user)); } return $result; }
public static function makeAuth($args) { $md5pass = md5($args[1].Config::$Security['passwordsalt']); $table = Config::$DBConf['prefix'].Authorization::$table; $row = DB::getRow("Select * From $table Where `login`='$args[0]' and `password`='$md5pass'"); if($row != NULL && $row['status'] == '0' ){ self::$user = $row; DB::exec( "UPDATE $table SET `status` = 1 WHERE `login` = '".$args[0]."'" ); setcookie("user_name",$row['name'], time()+60*60*24*365); setcookie("user_id",$row['id'], time()+60*60*24*365); return $row['category']; }else return NULL; }
function getEdit() { $data = array(); $sql = 'SELECT * FROM {{reference}} WHERE id=' . $_GET['id'] . ''; $data = DB::getRow($sql); $sql = 'SELECT * FROM {{reference_files}} WHERE reference=' . $_GET['id'] . ''; $files = DB::getAll($sql); foreach ($files as $file) { $file['info'] = Funcs::getFileInfo($file['path']); $data['files'][] = $file; } return $data; }
public static function getList() { $data = array(); $row = 0; $is_catalog = false; foreach (Impexp::$treeFieldsRus as $item) { $data[$row][] = $item; } $sql = 'SELECT * FROM {{tree}} WHERE parent=' . Funcs::$uri[3] . ' ORDER BY num'; $list = DB::getAll($sql); $module = Module::getModuleByTree($list[0]['id']); $moduleFields = Module::getFieldList($module['id'], 'all'); foreach ($moduleFields as $item) { if (in_array($item['type'], Impexp::$usingFieldsByType)) { $data[$row][] = $item['name']; } } $row++; $sql = 'SELECT id FROM {{catalog}} WHERE tree=' . $list[0]['id']; if (DB::getOne($sql)) { $is_catalog = true; } foreach ($list as $item) { foreach (Impexp::$treeFields as $field) { $data[$row][] = $item[$field]; } $fields = Impexp::getFieldsByTree($item['id']); if ($is_catalog) { $sql = 'SELECT * FROM {{catalog}} WHERE tree=' . $item['id']; $item = DB::getRow($sql); foreach ($moduleFields as $field) { if (in_array($field['type'], Impexp::$usingFieldsByType)) { if (in_array($field['path'], OneSSA::$catalogStandart)) { $data[$row][] = $item[$field['path']]; } else { $data[$row][] = $fields[$field['path']]; } } } } else { foreach ($moduleFields as $field) { if (in_array($field['type'], Impexp::$usingFieldsByType)) { $data[$row][] = $fields[$field['path']]; } } } $row++; } return $data; }
/** * Gets the latest released story from a given internal channel * * @param int $channel_id The channel id. * * @return int The story id. * @throws Jonah_Exception * @throws Horde_Exception_NotFound */ public function getLatestStoryId($channel_id) { $sql = 'SELECT story_id FROM jonah_stories' . ' WHERE channel_id = ? AND story_published <= ?' . ' ORDER BY story_updated DESC'; $values = array((int) $channel_id, time()); Horde::log('SQL Query by Jonah_Driver_sql::getLatestStoryId(): ' . $sql, 'DEBUG'); $result = $this->_db->getRow($sql, $values, DB_FETCHMODE_ASSOC); if ($result instanceof PEAR_Error) { Horde::log($result, 'ERR'); throw new Jonah_Exception($result); } elseif (empty($result)) { return Horde_Exception_NotFound(sprintf(_("Channel \"%s\" not found."), $channel_id)); } return $result['story_id']; }
public static function calcSale($orderId) { $order = DealersOrders::getOrderProp($orderId); $sql = ' SELECT {{dealers}},*, {{dealers_status}}.sale as statussale FROM {{dealers}} LEFT JOIN ((dealers_status)) ON {{dealers}}.status = {{dealers_status}}.id WHERE {{dealers}}.id=' . $order['dealer'] . ' '; $dealer = DB::getRow($dealerId); $sale_status = $dealer['statussale']; $sale_one = self::calc($order['sum'], 'sale_one'); $sale_year = self::calc($order['sum'], 'sale_year'); $sale_total = $sale_status + max($sale_year, $sale) + $order['add_sale']; return $sale_total; }
/** * Constructor * @return void */ function __construct($var = 0) { if ($var > 0) { $db = new DB(); $obj = $db->getRow($this->table, '*'); if (is_object($obj)) { $this->id = stripslashes($obj->id); $this->username = stripslashes($obj->username); $this->password = stripslashes($obj->password); $this->hash = stripslashes($obj->hash); $this->email = stripslashes($obj->email); $this->display_name = stripslashes($obj->display_name); $this->status = stripslashes($obj->status); $this->updated_on = stripslashes($obj->updated_on); } } }
/** * Fetches a gateway from the backend. * * @param int $gateway_id The gateway id to fetch. * * @return array An array containing the gateway settings and parameters. */ function &getGateway($gateway_id) { /* Get the gateways. */ $sql = 'SELECT * FROM swoosh_gateways WHERE gateway_id = ?'; $values = array((int) $gateway_id); Horde::log('SQL Query by Hylax_Storage_sql::getGateway(): ' . $sql, 'DEBUG'); $gateway = $this->_db->getRow($sql, $values, DB_FETCHMODE_ASSOC); if (is_a($gateway, 'PEAR_Error')) { Horde::log($gateway, 'ERR'); return $gateway; } /* Unserialize the gateway params. */ $gateway['gateway_params'] = Horde_Serialize::unserialize($gateway['gateway_params'], Horde_Serialize::UTF7_BASIC); /* Unserialize the gateway send params. */ $gateway['gateway_sendparams'] = Horde_Serialize::unserialize($gateway['gateway_sendparams'], Horde_Serialize::UTF7_BASIC); return $gateway; }
function run($id = '') { $fullURI = Funcs::$uri; if ($id) { $fullURI = explode('/', Tree::getPathToTree($id)); unset($fullURI[0]); unset($fullURI[count($fullURI)]); } $data = array(); $parent = Funcs::$siteDB; $path = ''; foreach ($fullURI as $uri) { $path = $path . '/' . $uri; if (is_numeric($uri)) { $sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND id=' . $uri . ''; } else { $sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND path=\'' . $uri . '\''; } $row = DB::getRow($sql); $row['path'] = $path . '/'; $parent = $row['id']; if ($parent == '') { $parent = 0; } $data[] = $row; } if ($fullURI[0] == 'catalog' && is_numeric($fullURI[count(Funcs::$uri) - 1])) { $uri = explode('/', $_SERVER['REQUEST_URI']); $num = count($data); $data[count($data)] = $data[count($data) - 1]; $path = $data; unset($path[count($path) - 1]); unset($path[count($path) - 1]); $items = array(); foreach ($path as $item) { $items[] = $item['path']; } Funcs::$reference['vendor'][$uri[$num]]['path'] = $items[count($items) - 1] . Funcs::$reference['vendor'][$uri[$num]]['path'] . '/'; $data[count($data) - 2] = Funcs::$reference['vendor'][$uri[$num]]; } elseif (isset($_GET['ve'])) { $path = $items[count($items)] . Funcs::$reference['vendor'][$uri[$num]]['path'] . '/'; $data[] = array('name' => Funcs::$referenceId['vendor'][$_GET['ve']]['name'], 'path' => $path); } View::widget('crumbs', array('list' => $data)); }
public static function getOrders() { $data = array(); $sql = 'SELECT MAX(cdate) AS maxdate, MIN(cdate) AS mindate FROM {{orders}} WHERE status=\'done\''; $dates = DB::getRow($sql); for ($i = date('Y', strtotime($dates['mindate'])); $i <= date('Y', strtotime($dates['maxdate'])); $i++) { for ($num = 0; $num < 12; $num++) { $db = date('Y-m-d 00:00:01', strtotime($i . '-' . str_repeat('0', 2 - strlen($num + 1)) . ($num + 1) . '-01 00:00:01')); $de = date('Y-m-d 00:00:01', strtotime($i . '-' . str_repeat('0', 2 - strlen($num + 1)) . ($num + 1) . '-01 00:00:01 +1 month')); $sql = 'SELECT SUM(price) FROM {{orders}} WHERE status=\'done\' AND (cdate BETWEEN \'' . $db . '\' AND \'' . $de . '\' )'; $sum = DB::getOne($sql); if ($sum != '') { $data[$i][str_repeat('0', 2 - strlen($num + 1)) . ($num + 1)] = array('name' => Funcs::$monthsRusB[$num], 'sum' => $sum); } } } return $data; }
public static function get_keyword_id($keyword) { //only grab the first 255 charactesr of keyword $keyword = substr($keyword, 0, 255); $mysql['keyword'] = DB::quote($keyword); $keyword_sql = "SELECT keyword_id FROM bt_s_keywords WHERE keyword='" . $mysql['keyword'] . "'"; $keyword_row = DB::getRow($keyword_sql); if ($keyword_row) { //if this already exists, return the id for it $keyword_id = $keyword_row['keyword_id']; return $keyword_id; } else { //else if this ip doesn't exist, insert the row and grab the id for it $keyword_sql = "INSERT INTO bt_s_keywords SET keyword='" . $mysql['keyword'] . "'"; $keyword_result = DB::query($keyword_sql); //($keyword_sql); $keyword_id = DB::insertId(); return $keyword_id; } }