public static function getYesUsers($eid) { global $fp; $fp->log("eid: {$eid}"); $db = DB::get()->getConnection(); $sql = "SELECT user.*, event.quota as quota FROM user_event, user, event WHERE event.eid =:eid AND user.uid = user_event.uid AND user_event.eid =:eid AND answer = 1"; $stmt = $db->prepare($sql); if (!$stmt->execute(array(':eid' => $eid))) { $err = "ERROR(UserEvent::getYes): Update on the server failed!->" . join(", ", $stmt->errorInfo()); error_log($err); $fp->log($err); return false; } $out = array(); $i = 0; while ($r = $stmt->fetch(PDO::FETCH_ASSOC)) { if ($i == 0) { $o->quota = $r['quota']; } $out[$r['uid']] = $r; ++$i; } $o->num = count($out); if (!isset($o->quota)) { $o->quota = 1000000; } $o->users = $out; return $o; }
function _markov($params) { $user = $params['user']; $channel = $params['channel']; $msg = Utils::cmdout($params); $data = DB::get()->val("SELECT data FROM presence WHERE data <> '' AND cssclass='' AND data NOT LIKE '%<%' AND user_id = :user_id ORDER BY RAND() LIMIT 1", array('user_id' => $user->id)); list($word, ) = explode(' ', $data, 2); $output = $word . ' '; for ($z = 0; $z < 20; $z++) { $data = DB::get()->val("SELECT data FROM presence WHERE data LIKE :chain AND cssclass='' AND data NOT LIKE '%<%' AND user_id = :user_id ORDER BY RAND() LIMIT 1", array('user_id' => $user->id, 'chain' => '%' . $word . '%')); if ($data) { $words = explode(' ', $data); $index = array_search($word, $words); if ($index !== false) { if ($word = $words[$index + 1]) { $output .= $word . ' '; } } } else { break; } } $msg .= trim($output); Status::create()->data($msg)->user_id($user->id)->cssclass('markov')->channel($channel)->insert(); return true; }
function show_page() { $row = DB::queryFirstRow('SELECT * FROM pages WHERE page_id="' . mysqli_real_escape_string(DB::get(), $_GET['ID']) . '"'); $name = htmlentities($row['name']); $content = " " . str_replace("\n", "\n ", $row['content']); if (strpos($content, '<h1>') != 6) { $content = '<h1></h1><br /><br />' . $content; } global $LMT_EMAIL; $content = str_replace('{CONTACT_LINK}', email_obfuscate($LMT_EMAIL, null, '<span class="b">Please email us at:</span> '), $content); $page_id = htmlentities($_GET['ID']); global $use_rel_external_script; $use_rel_external_script = true; lmt_page_header($name); echo <<<HEREDOC \t <div style="float: left; margin-top: 40px;"> <a href="List"><img src="../../../res/icons/arrow_left.png" alt="" /> Return to Page List</a> <div class="halfbreak"></div> <a href="Edit?ID={$page_id}"><img src="../../../res/icons/edit.png" alt="" /></a> <a href="Delete?ID={$page_id}"><img src="../../../res/icons/delete.png" alt="" /></a> </div> HEREDOC; echo $content; }
function do_move() { if ($_GET['xsrf_token'] != $_SESSION['xsrf_token']) { trigger_error('XSRF code incorrect', E_USER_ERROR); } if (isset($_GET['Up'])) { $operator = ' < '; $sql_order = 'DESC'; $modifier = -1; } else { if (isset($_GET['Down'])) { $operator = ' > '; $sql_order = 'ASC'; $modifier = 1; } else { trigger_error('Neither Up nor Down specified', E_USER_ERROR); } } $row = DB::queryFirstRow('SELECT order_num FROM pages WHERE page_id="' . mysqli_real_escape_string(DB::get(), $_GET['ID']) . '"'); $order = $row['order_num']; $row = DB::queryFirstRow('SELECT page_id, order_num FROM pages WHERE order_num' . $operator . $order . ' ORDER BY order_num ' . $sql_order . ' LIMIT 1'); $other_id = $row['page_id']; $new_order = (int) $order + $modifier; DB::queryRaw('UPDATE pages SET order_num="' . mysqli_real_escape_string(DB::get(), $new_order) . '" WHERE page_id="' . mysqli_real_escape_string(DB::get(), $_GET['ID']) . '" LIMIT 1'); DB::queryRaw('UPDATE pages SET order_num="' . mysqli_real_escape_string(DB::get(), $order) . '" WHERE page_id="' . mysqli_real_escape_string(DB::get(), $other_id) . '" LIMIT 1'); header('Location: List'); }
function _minibar($params) { $watch = $params['watch']; $user = Auth::user(); $widgets = DB::get()->results("SELECT * FROM options WHERE grouping = 'widgets' AND user_id = :user_id", array('user_id' => $user->id)); foreach ($widgets as $widget) { $data = unserialize($widget->value); if ($data['name'] == 'minibar') { $data['rooms'][] = $watch; $widget->value = serialize($data); $widget->update('options', 'id'); Immediate::create()->js("reloadWidgets();addSystem({user_id:{$user->id}, data: 'Added \\'" . addslashes($watch) . "\\' to minibar.', cssclass: 'ok', username: '******', nickname: '{$user->nickname}', status: " . microtime(true) . ", js:''}, '#notices');do_scroll();"); return true; } } $lastwidgetid = DB::get()->val("SELECT MAX(id) FROM options"); if (!$lastwidgetid) { $lastwidgetid = 0; } $lastwidgetid++; $data = array('name' => 'minibar', 'params' => '', 'rooms' => array($watch)); DB::get()->query("INSERT INTO options (name, grouping, value, user_id) VALUES (:name, 'widgets', :value, :user_id);", array('name' => $lastwidgetid, 'value' => serialize($data), 'user_id' => $user->id)); Immediate::create()->js("reloadWidgets();addSystem({user_id:{$user->id}, data: 'Added \\'" . addslashes($watch) . "\\' as minibar widget.', cssclass: 'ok', username: '******', nickname: '{$user->nickname}', status: " . microtime(true) . ", js:''}, '#notices');do_scroll();"); return true; }
public static function Fundacion() { $db = DB::get(); $row = $db->query("SELECT * FROM galeria_principal"); $html = ""; $results = $row->fetchAll(); foreach ($results as $k => $v) { $html .= ' <div class="swiper-slide Galeriaswiper-container"> <div style="width:100%"> <img class="slide-img ' . self::checkSize('upload/' . $v["imagen"]) . '" src="upload/' . $v["imagen"] . '" style="top: 0;left: 0;margin:0;"> <a href="LaTienda.php"> <div class="row"> <div class=" slider-data PlacaTienda"><h1>' . $v["titulo"] . '</h1> <p class="SacarSeccionCelular">' . $v["descripcion"] . '</p> </div> </div> </a> </div> </div> '; } // self::checkSize('upload'.$v["imagen"]); echo $html; }
function _retcon($params) { include_once "Text/Diff.php"; include_once "Text/Diff/Renderer.php"; include_once "Text/Diff/Renderer/inline.php"; $user = $params['user']; $channel = $params['channel']; $query = $params['query']; $status = $params['status']; /* $output = Utils::cmdout($params); $output .= htmlspecialchars($query); Status::create() ->data($output) ->user_id($user->id) ->channel($channel) ->insert(); //*/ $statusok = DB::get()->assoc("SELECT status, data FROM presence WHERE user_id = :user_id AND type = 'message' AND data <> '' AND status = :status ORDER BY msgtime DESC LIMIT 10", array('user_id' => $user->id, 'status' => $status)); if ($statusok) { $data = reset($statusok); $diff =& new Text_Diff(explode("\n", $data), explode("\n", htmlspecialchars_decode($query))); $renderer =& new Text_Diff_Renderer_inline(); $replacement = $renderer->render($diff); $replacement = addslashes($replacement); $replacement = str_replace("\n", '\\n', $replacement); $js = <<<REPLJS retcon({$status}, '{$replacement}'); REPLJS; Status::create()->user_id($user->id)->js($js)->channel($channel)->insert(); } return true; }
public function find($search) { $params = []; if (is_scalar($search)) { $paramKey = $this->dbPrimaryKey; $paramValue = $search; $params[$paramKey] = $paramValue; } else { foreach ($search as $paramKey => $paramValue) { $params[$paramKey] = $paramValue; } } $response = DB::get($this->dbTable, $params, 1); if (count($response) > 0) { $first = $response[0]; foreach ($first as $key => $value) { if (property_exists($this, $key)) { $this->{$key} = $value; } } return true; } else { return false; } }
public function testCreate() { $db = DB::get(); $srv = new CashMovementsService(); $mvt = new CashMovement($this->cashId, $db->readDate("2014-01-03 00:00:00"), CashMovement::TYPE_CASHIN, 10.0, $this->currencyId, 12, "note"); $id = $srv->create($mvt); $this->assertNotEquals(false, $id, "Creation failed"); $pdo = PDOBuilder::getPDO(); $stmt = $pdo->prepare("SELECT * FROM RECEIPTS WHERE ID = :id"); $stmt->bindParam(":id", $id); $stmt->execute(); $row = $stmt->fetch(); $this->assertNotEquals(false, $row, "No receipt found"); $this->assertEquals($mvt->date, $db->readDate($row['DATENEW']), "Date mismatch"); $this->assertEquals($mvt->cashId, $row['MONEY'], "Cash session id mismatch"); $stmtP = $pdo->prepare("SELECT * FROM PAYMENTS WHERE ID = :id"); $stmtP->bindParam(":id", $id); $stmtP->execute(); $row = $stmtP->fetch(); $this->assertNotEquals(false, $row, "No payment found"); $this->assertEquals($id, $row['RECEIPT'], "Receipt id mismatch"); $this->assertEquals($mvt->type, $row['PAYMENT'], "Payment type mismatch"); $this->assertEquals($mvt->amount, $row['TOTAL'], "Amount mismatch"); $this->assertEquals($mvt->currencyId, $row['CURRENCY'], "Currency id mismatch"); $this->assertEquals($mvt->currencyAmount, $row['TOTALCURRENCY'], "Currency amount mismatch"); $this->assertEquals($mvt->note, $row['NOTE'], "Note mismatch"); }
function user_from_name(&$m) { static $userlist = false; if (!$userlist) { $userlist = DB::get()->results("SELECT users.*, options.value as nickname FROM users LEFT JOIN options ON options.user_id = users.id AND name = 'Nickname' AND grouping = 'Identity' ORDER BY LENGTH(username) DESC"); } $m = trim($m); foreach ($userlist as $user) { if (strlen($user->username) > strlen($user->nickname)) { $us = array($user->username, $user->nickname); } else { $us = array($user->nickname, $user->username); } foreach ($us as $u) { if (!$u) { continue; } if (stripos($m, $u) === 0) { $m = trim(substr($m, strlen($u))); return $user; } } } return false; }
function poll($laststatus, $statuscode, $user) { static $alarms = null; if (!isset($alarms) || $laststatus != $statuscode) { $adata = DB::get()->val("SELECT value FROM options WHERE user_id = :user_id AND name = 'alarmdata' AND grouping = 'Alarms'", array('user_id' => $user->id)); $alarms = unserialize($adata); } $changed = false; if (is_array($alarms)) { foreach ($alarms as $key => $alarm) { if ($alarm['time'] < time()) { $output = 'ALARM: ' . $alarm['event']; $js = 'bareffect(function(){play("/plugins/alarm/alarm.mp3", true)});'; unset($alarms[$key]); DB::get()->query("INSERT INTO presence (data, user_id, type, cssclass, user_to, channel, js) VALUES (:msg, :user_id, 'system', 'alarm', :user_to, '', :js)", array('msg' => $output, 'user_id' => 0, 'user_to' => $user->id, 'js' => $js)); //DB::get()->query("INSERT INTO presence (data, user_id, channel, cssclass) VALUES (:msg, :user_id, :channel, 'alarm')", array('msg' => $output, 'user_id' => $user->id, 'channel' => $channel)); $changed = true; } } if ($changed) { DB::get()->query("DELETE FROM options WHERE user_id = :user_id AND name = 'alarmdata' AND grouping = 'Alarms'", array('user_id' => $user->id)); DB::get()->query("INSERT INTO options (grouping, name, user_id, value) VALUES('Alarms', 'alarmdata', :user_id, :value)", array('user_id' => $user->id, 'value' => serialize($alarms))); } } return $laststatus; }
function __construct($path) { $chanbar = ' <ul> <li id="settings" class="option"><a href="#" class="button">settings</a></li> <li id="files" class="option"><a href="#" class="button">files</a></li> <li id="people" class="option"><a href="#" class="button">people</a></li> </ul> '; $user = Auth::user(); $curchan = DB::get()->val('SELECT name from channels where user_id = :user_id AND active = 1', array('user_id' => $user->id)); if ($curchan == '') { $curchan = 'bar'; } $widgets = Widgets::get_widgets(); $components = array('title' => 'Barchat Home', 'path' => $path, 'chanbar' => $chanbar, 'user_id' => Auth::user_id(), 'username' => $user->username, 'nickname' => $user->nickname, 'session_key' => $user->session_key, 'cur_chan' => addslashes($curchan), 'widgets' => $widgets); $v = new View($components); Plugin::call('reload', $user); //check for user agent $useragent = $_SERVER['HTTP_USER_AGENT']; // if (preg_match('/ip(hone|od|ad)/i', $useragent)) { $v->render('template-ios'); } else { $v->render('template'); } }
public static function init() { $config = Config::load('modules'); self::$default_modules = $config['default']; $db = DB::get(); $modules = array(); $enabled_modules = array(); if (!empty($config['table'])) { $table = new $config['table'](); $modules = $table->whereBy('module_enabled', 'Y')->column('module_key'); $enabled_modules = array_merge($enabled_modules, $modules); } self::$enabled_modules = array_merge(self::$default_modules, $enabled_modules); $app = App::get(); Access::reset(); self::$paths = array(); foreach (self::$enabled_modules as $v) { $cl = 'Pina\\Modules\\' . $v . '\\' . $v . 'Module'; $path = ''; if (class_exists($cl)) { $c = new $cl(); $path = $c->path(); } else { $path = App::path() . '/default/Modules/' . $v; } self::$paths[$v] = $path; } foreach (self::$paths as $base) { $path = $base . '/' . $app . '/init.php'; if (is_file($path)) { include_once $path; } } }
public function testCreateFull() { $item = new InventoryItem(null, $this->products[0]->id, null, 1, 2, 3, 4, 5); $inv = new Inventory(stdtimefstr("2001-01-01 00:00:00"), $this->locations[0]->id); $inv->addItem($item); $srv = new InventoriesService(); $id = $srv->create($inv); $this->assertNotEquals(false, $id, "Creation failed"); $pdo = PDOBuilder::getPDO(); $db = DB::get(); $stmt = $pdo->prepare("SELECT * FROM STOCK_INVENTORY"); $this->assertNotEquals(false, $stmt->execute(), "Query failed"); if ($row = $stmt->fetch()) { $this->assertEquals($id, $row['ID'], "Id mismatch"); $this->assertEquals($inv->locationId, $row['LOCATION_ID'], "Location id mismatch"); $this->assertEquals($inv->date, $db->readDate($row['DATE']), "Date mismatch"); } else { $this->assertTrue(false, "No inventory found after creation"); } $stmt = $pdo->prepare("SELECT * FROM STOCK_INVENTORYITEM"); $this->assertNotEquals(false, $stmt->execute(), "Query failed"); if ($row = $stmt->fetch()) { $this->assertEquals($id, $row['INVENTORY_ID'], "Id mismatch"); $this->assertEquals($item->productId, $row['PRODUCT_ID'], "Product id mismatch"); $this->assertEquals($item->attrSetInstId, $row['ATTRSETINST_ID'], "Attribute set instance id mismatch"); $this->assertEquals($item->qty, $row['QTY'], "Quantity mismatch"); $this->assertEquals($item->lostQty, $row['LOSTQTY'], "Lost quantity mismatch"); $this->assertEquals($item->defectQty, $row['DEFECTQTY'], "Defect quantity mismatch"); $this->assertEquals($item->missingQty, $row['MISSINGQTY'], "Missing quantity mismatch"); $this->assertEquals($item->unitValue, $row['UNITVALUE'], "Unit value mismatch"); } else { $this->assertTrue(false, "No inventory item found after creation"); } }
function process_form() { if ($_POST['xsrf_token'] != $_SESSION['xsrf_token']) { show_page('Huh? ERROR: big kablooie'); return; } $query = 'SELECT id, name FROM users WHERE id="' . mysqli_real_escape_string(DB::get(), $_POST['account_id']) . '"'; $result = DB::queryRaw($query); if (mysqli_num_rows($result) != 1) { show_page('Nonexistent ID'); return; } $row = mysqli_fetch_assoc($result); $id = $row['id']; $name = $row['name']; // ** FORM VALIDATED AT THIS POINT ** // perform elevation $query = 'UPDATE users SET permissions="A", approved="1" WHERE id="' . $id . '" LIMIT 1'; DB::queryRaw($query); // show confirmation page page_header('Super-Admin'); echo <<<HEREDOC <h1>Super-Admin</h1> <span class="b">{$name}</span> was approved and elevated. Now clear the Super-Admin password. HEREDOC; //$names[0] = 'Super-Admin'; //$pages[0] = ''; //page_footer($names, $pages); }
public function testCreateNoReturn() { $rules = array(); $values = array(new PaymentModeValue(10, "label_10", 1), new PaymentModeValue(20, "label_20", 2)); $mode = new PaymentMode("code", "label", "backLabel", PaymentMode::CUST_ASSIGNED, false, $rules, $values, true, true, 2); $srv = new PaymentModesService(); $mode->id = $srv->create($mode); $this->assertNotEquals(false, $mode->id, "Creation failed"); $pdo = PDOBuilder::getPDO(); $sql = "SELECT * FROM PAYMENTMODES"; $stmt = $pdo->prepare($sql); $this->assertNotEquals($stmt->execute(), false, "Query failed"); $row = $stmt->fetch(); $db = DB::get(); $this->assertNotEquals(false, $row, "Nothing found"); $this->assertEquals($mode->id, $row['ID'], "Id mismatch"); $this->assertEquals($mode->code, $row['CODE'], "Code mismatch"); $this->assertEquals($mode->label, $row['NAME'], "Label mismatch"); $this->assertEquals($mode->backLabel, $row['BACKNAME'], "Back label mismatch"); $this->assertEquals($mode->flags, $row['FLAGS'], "Flags mismatch"); $this->assertEquals($mode->active, $db->readBool($row['ACTIVE']), "Active mismatch"); $this->assertEquals($mode->system, $db->readBool($row['SYSTEM']), "System mismatch"); $this->assertEquals($mode->dispOrder, $row['DISPORDER'], "Order mismatch"); $stmtRules = $pdo->prepare("SELECT * FROM PAYMENTMODES_RETURNS " . "ORDER BY MIN ASC"); $this->assertNotEquals(false, $stmtRules->execute(), "Query failed"); while ($row = $stmtRules->fetch()) { $this->assertTrue(false, "Unknown rule"); } }
function reload($user) { $lastfacts = DB::get()->val("SELECT value FROM options WHERE name='facts' and grouping = 'misc'"); if ($lastfacts < mktime(0, 0, 0)) { DB::get()->query("SELECT * FROM drawers WHERE indexed = 'facts'"); $users = DB::get()->col("SELECT id FROM users"); $zip = new ZipArchive(); if ($zip->open(dirname(__FILE__) . '/facts.zip') === TRUE) { $facts = explode("\n", $zip->getFromName('facts.txt')); $zip->close(); $fact = '<div class="factoidtext">' . $facts[date('z')] . '</div>'; } else { $content = file_get_contents('http://www.mentalfloss.com/amazingfactgenerator/?p=' . date('z')); $content = SimpleHTML::str_get_html($content); $fact = '<div class="factoidtext">FAIL:' . $content->find('.amazing_fact_body p', 0)->innertext . '</div>'; } $msg = '<a href="#" class="close" onclick="return closedrawer({$drawer_id});">close this drawer</a>' . $fact; foreach ($users as $user_id) { DB::get()->query("INSERT INTO drawers (user_id, message, indexed, cssclass) VALUES (:user_id, :msg, 'facts', 'factoid');", array('user_id' => $user_id, 'msg' => $msg)); } DB::get()->query("DELETE FROM options WHERE name = 'facts' AND grouping = 'misc'"); DB::get()->query("INSERT INTO options (name, grouping, value) VALUES ('facts', 'misc', :value);", array('value' => mktime(0, 0, 0))); } return $user; }
function ajax_widgetcal($path) { $id = $path[0][0]; $user = Auth::user(); $widgetdata = DB::get()->row("SELECT * FROM options WHERE user_id = :user_id AND grouping = 'widgets' AND id = :id ORDER BY name ASC", array('user_id' => $user->id, 'id' => $id)); $data = (object) unserialize($widgetdata->value); $calendars = DB::get()->results("SELECT * FROM options WHERE user_id = :user_id AND grouping = 'calendar'", array('user_id' => $user->id)); $date = new DateTime('now', new DateTimeZone('GMT')); $date->setTimezone(new DateTimeZone('America/New_York')); $events = array(); foreach ($calendars as $cal) { $this->_get_events_url($events, $cal->value, $date); } $m = $date->format('n'); $d = $date->format('j'); $y = $date->format('Y'); $output = '<table class="calendar" cellspacing="0" style="width:100%;"> <thead> <tr><th><a href="#">«</a></th><th colspan="5">' . date('M Y') . '</th><th><a href="#">»</a></th></tr> <tr><th>Sun</th><th>Mon</th><th>Tue</th><th>Wed</th> <th>Thu</th><th>Fri</th><th>Sat</th></tr> </thead> <tbody><tr>'; $calstart = getdate(mktime(0, 0, 0, $m, 1, $y)); $wday = $calstart['wday']; for ($z = 1; $z <= $wday; $z++) { $output .= '<td class="day_empty"> </td>'; } $daysinmonth = getdate(mktime(0, 0, 0, $m + 1, 0, $y)); $todaytime = mktime(0, 0, 0); for ($z = 1; $z <= $daysinmonth['mday']; $z++) { $daytime = sprintf('%04d-%02d-%02d', $y, $m, $z); $day = getdate(strtotime($daytime)); $classes = array(); if ($daytime == $date->format('Y-m-d')) { $classes[] = 'today'; } if (isset($events[$daytime])) { $classes[] = 'date_has_event'; } $output .= '<td class="' . implode(' ', $classes) . '"><span>' . $day['mday'] . '</span>'; if (isset($events[$daytime])) { $output .= '<div class="events"><ul>'; foreach ($events[$daytime] as $event) { $output .= '<li>' . $event . '</li>'; } $output .= '</ul></div>'; } $output .= '</td>'; if ($day['wday'] == 6) { $output .= '</tr><tr>'; } } for ($z = $daysinmonth['wday'] + 1; $z <= 6; $z++) { $output .= '<td class="day_empty"> </td>'; } $output .= '</tr></tbody></table>'; echo $output; }
function form ($form) { $db =& DB::get(); $purchasetable = DatabaseObject::tablename(Purchase::$table); $next = $db->query("SELECT auto_increment as id FROM information_schema.tables WHERE table_schema=database() AND table_name='$purchasetable' LIMIT 1"); $Order = $this->Order; $Order->_2COcart_order_id = date('mdy').'-'.date('His').'-'.$next->id; // Build the transaction $_ = array(); // Required $_['sid'] = $this->settings['sid']; $_['total'] = number_format($Order->Cart->Totals->total,$this->precision); $_['cart_order_id'] = $Order->_2COcart_order_id; $_['vendor_order_id'] = $this->session; $_['id_type'] = 1; // Extras if ($this->settings['testmode'] == "on") $_['demo'] = "Y"; $_['fixed'] = "Y"; $_['skip_landing'] = "1"; $_['x_Receipt_Link_URL'] = $this->settings['returnurl']; // Line Items foreach($this->Order->Cart->contents as $i => $Item) { // $description[] = $Item->quantity."x ".$Item->name.((!empty($Item->optionlabel))?' '.$Item->optionlabel:''); $id = $i+1; $_['c_prod_'.$id] = 'ecart_pid-'.$Item->product.','.$Item->quantity; $_['c_name_'.$id] = $Item->name; $_['c_description_'.$id] = !empty($Item->option->label)?$Item->$Item->option->label:''; $_['c_price_'.$id] = number_format($Item->unitprice,$this->precision); } $_['card_holder_name'] = $Order->Customer->firstname.' '.$Order->Customer->lastname; $_['street_address'] = $Order->Billing->address; $_['street_address2'] = $Order->Billing->xaddress; $_['city'] = $Order->Billing->city; $_['state'] = $Order->Billing->state; $_['zip'] = $Order->Billing->postcode; $_['country'] = $Order->Billing->country; $_['email'] = $Order->Customer->email; $_['phone'] = $Order->Customer->phone; $_['ship_name'] = $Order->Customer->firstname.' '.$Order->Customer->lastname; $_['ship_street_address'] = $Order->Shipping->address; $_['ship_street_address2'] = $Order->Shipping->xaddress; $_['ship_city'] = $Order->Shipping->city; $_['ship_state'] = $Order->Shipping->state; $_['ship_zip'] = $Order->Shipping->postcode; $_['ship_country'] = $Order->Shipping->country; return $form.$this->format($_); }
public function liste() { $query = DB::get("yonetim"); foreach ($query->result() as $yonetim) { $yonetimData[] = array('id' => $yonetim->id, 'username' => $yonetim->username, 'email' => $yonetim->email, 'isim' => $yonetim->isim, 'soyisim' => $yonetim->soyisim, 'durum' => $yonetim->durum, 'ban_durum' => $yonetim->ban_durum); } return $yonetimData; }
function css($path) { $channel = array_shift($path); $file = DB::get()->val("SELECT value FROM options WHERE name = 'css' AND grouping = 'decor' AND room = :channel;", array('channel' => $channel)); header('content-type: text/css'); echo $file; die; }
function _report_data() { $servers = DB::get()->assoc("SELECT name, value FROM options WHERE grouping = 'stats servers'"); foreach ($servers as $name => $value) { $servers[$name] = json_decode(file_get_contents($value)); } return $servers; }
public static function isPermit(Controller $ctrl, string $method) : bool { $req = DB::get()->prepare("SELECT COUNT(*) AS nb FROM permission WHERE controller_id = ? AND `action` = ? AND rank_id = ?"); $req->execute([$ctrl->id, $method, Request::get()->getClient()->rank_id]); $data = $req->fetch(); $req->closeCursor(); return $data['nb'] > 0; }
function test_1_create_table() { DB::query("CREATE TABLE `accounts` (\n `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `profile_id` INT NOT NULL,\n `username` VARCHAR( 255 ) NOT NULL ,\n `password` VARCHAR( 255 ) NULL ,\n `age` INT NOT NULL DEFAULT '10',\n `height` DOUBLE NOT NULL DEFAULT '10.0',\n `favorite_word` VARCHAR( 255 ) NULL DEFAULT 'hi',\n `birthday` TIMESTAMP NOT NULL\n ) ENGINE = InnoDB"); DB::query("CREATE TABLE `profile` (\n `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `signature` VARCHAR( 255 ) NULL DEFAULT 'donewriting'\n ) ENGINE = InnoDB"); $mysqli = DB::get(); DB::disconnect(); @$this->assert($mysqli->server_info === null); }
public function check($source, $items = array()) { foreach ($items as $item => $rules) { foreach ($rules as $rule => $rule_value) { $value = trim($source[$item]); $item = escape($item); if ($rule === 'required' && empty($value)) { $this->addErro($item, 'é obrigatório'); } elseif (!empty($value)) { switch ($rule) { case 'min': if (strlen($value) < $rule_value) { $this->addErro($item, $rule_value); } break; case 'max': if (strlen($value) > $rule_value) { $this->addErro($item, $rule_value); } break; case 'matches': if ($value != $source[$rule_value]) { $this->addErro($item, $rule_value); } break; case 'email': if (!filter_var($value, FILTER_VALIDATE_EMAIL)) { $this->addErro($item, $rule_value); } break; case 'unique': $check = $this->db->get($rule_value, "{$item} = '{$value}'"); if ($check->getNumRegistros()) { $this->addErro($item, $rule_value); } break; } } } } if (empty($this->erros)) { $this->passed = true; } return $this; }
protected function __construct() { parent::__construct($this->settings); $database = DB::get(); $result = $database->settings->find(); foreach ($result as $row) { $this->settings[$row["key"]] = $row["value"]; } }
function generate_results() { if ($_GET['term'] == '') { die; } $query = mysqli_real_escape_string(DB::get(), $_GET['term']); $query = str_replace(" ", "%", $query); $comma = ""; echo "["; if (isset($_GET['Individual'])) { $result = DB::queryRaw('SELECT DISTINCT name FROM individuals WHERE name LIKE "%' . $query . '%" OR id="' . $query . '" AND deleted="0" LIMIT 5'); $row = mysqli_fetch_assoc($result); while ($row) { echo $comma . "\n" . ' { "label": "' . $row['name'] . '", "category": "Individuals" }'; $comma = ","; $row = mysqli_fetch_assoc($result); } } else { if (isset($_GET['Unaffiliated'])) { $result = DB::queryRaw('SELECT DISTINCT name FROM individuals WHERE name LIKE "%' . $query . '%" OR id="' . $query . '" AND email <> "" AND deleted="0" LIMIT 5'); $row = mysqli_fetch_assoc($result); while ($row) { echo $comma . "\n" . ' { "label": "' . $row['name'] . '", "category": "Individuals" }'; $comma = ","; $row = mysqli_fetch_assoc($result); } } } if (isset($_GET['Team'])) { $result = DB::queryRaw('SELECT DISTINCT name FROM teams WHERE name LIKE "%' . $query . '%" OR team_id="' . $query . '" AND deleted="0" LIMIT 5'); $row = mysqli_fetch_assoc($result); while ($row) { echo $comma . "\n" . ' { "label": "' . $row['name'] . '", "category": "Teams" }'; $comma = ","; $row = mysqli_fetch_assoc($result); } } if (isset($_GET['School'])) { $result = DB::queryRaw('SELECT DISTINCT name FROM schools WHERE name LIKE "%' . $query . '%" OR school_id="' . $query . '" AND deleted="0" LIMIT 5'); $row = mysqli_fetch_assoc($result); while ($row) { echo $comma . "\n" . ' { "label": "' . $row['name'] . '", "category": "Schools" }'; $comma = ","; $row = mysqli_fetch_assoc($result); } } if (isset($_GET['Coach'])) { $result = DB::queryRaw('SELECT DISTINCT coach_email FROM schools WHERE coach_email LIKE "%' . $query . '%" AND deleted="0" LIMIT 5'); $row = mysqli_fetch_assoc($result); while ($row) { echo $comma . "\n" . ' { "label": "' . $row['coach_email'] . '", "category": "Coaches" }'; $comma = ","; $row = mysqli_fetch_assoc($result); } } echo "\n]"; }
function do_school() { DB::queryRaw('UPDATE schools SET deleted="0" WHERE school_id="' . mysqli_real_escape_string(DB::get(), $_GET['School']) . '" LIMIT 1'); global $LMT_DB; if (mysqli_affected_rows($LMT_DB) != 1) { trigger_error('School not found', E_USER_ERROR); } header('Location: School?ID=' . $_GET['School']); }
public static function SetColumn($id, $col, $value) { $db = DB::get()->getConnection(); $stmt = $db->prepare("INSERT INTO user (uid, {$col}) VALUES (:u, :v) ON DUPLICATE KEY UPDATE {$col}=:v"); if (!$stmt->execute(array(':u' => $id, ':v' => $value))) { error_log("ERROR(SetUserColumn): Update on the server failed!->" . join(", ", $stmt->errorInfo())); return false; } return true; }
public function listele($data = array()) { if (!empty($data)) { } $query = DB::get("haberler"); foreach ($query->result() as $haber) { $haberData[] = array('id' => $haber->id, 'sef' => $haber->sef, 'baslik' => $haber->baslik, 'resim' => $haber->resim, 'detay' => $haber->detay, 'etiketler' => $haber->etiketler, 'tarih' => $haber->tarih, 'durum' => $haber->durum); } return $haberData; }