get() public static method

public static get ( )
Example #1
0
 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;
 }
Example #2
0
 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;
 }
Example #3
0
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;
}
Example #4
0
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');
}
Example #5
0
 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;
    }
Example #7
0
    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;
    }
Example #8
0
 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");
 }
Example #10
0
 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;
 }
Example #11
0
 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;
 }
Example #12
0
    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');
        }
    }
Example #13
0
 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");
     }
 }
Example #15
0
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");
     }
 }
Example #17
0
 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;
 }
Example #18
0
    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="#">&laquo;</a></th><th colspan="5">' . date('M Y') . '</th><th><a href="#">&raquo;</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">&nbsp;</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">&nbsp;</td>';
        }
        $output .= '</tr></tbody></table>';
        echo $output;
    }
Example #19
0
	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($_);
	}
Example #20
0
 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;
 }
Example #21
0
 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;
 }
Example #22
0
 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;
 }
Example #23
0
 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;
 }
Example #24
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);
 }
Example #25
0
 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;
 }
Example #26
0
 protected function __construct()
 {
     parent::__construct($this->settings);
     $database = DB::get();
     $result = $database->settings->find();
     foreach ($result as $row) {
         $this->settings[$row["key"]] = $row["value"];
     }
 }
Example #27
0
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]";
}
Example #28
0
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']);
}
Example #29
0
 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;
 }
Example #30
0
 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;
 }