public function consultar(db $db, usuariosModel $usuario, $status) { $db->clear(); $sql = "select * from sys_usuarios as a \n\t\t\t\t\t\t inner join nivel_acesso as b on a.id_nivel_acesso = b.id_nivel_acesso\n\t\t\t\t\t\t inner join funcionarios as c on a.id_funcionario = c.id_funcionario AND c.id_funcionario = ?\n\t\t\t\t\t\t where a.status_usuario in ('" . implode("','", $status) . "')"; $db->setParameter(1, $this->funcionario->getId()); if ($db->query($sql)) { return $db->result(); } else { return null; } }
public function consultar(db $db, caixasModel $caixa) { $db->clear(); $db->setTabela('caixas'); $db->setCondicao("id_caixa = '" . $caixa->getId() . "'"); if ($db->select()) { return $db->result(); } else { return null; } }
public function consultar(db $db, funcionariosModel $funcionario, $status) { $db->clear(); $db->setTabela('funcionarios'); $db->setCondicao("id_funcionario = ? and status_funcionario in ('" . implode("','", $status) . "')"); $db->setParameter(1, $funcionario->getId()); if ($db->select()) { return $db->result(); } else { return null; } }
public function consultar(db $db, caixasModel $caixa) { $db->clear(); $db->setTabela('caixas'); $db->setCondicao("ip_maquina = ? "); $db->setParameter(1, $caixa->getIp()); if ($db->select()) { return $db->result(); } else { return null; } }
public function consultar(db $db, produtosModel $produto, $status) { try { $db->clear(); $db->setTabela('produtos as a, categorias as b , marcas as c'); $db->setCondicao("a.id_produto = ? and b.id_categoria = a.id_categoria and c.id_marca = a.id_marca AND a.status_produto in ('" . implode("','", $status) . "')"); $db->setParameter(1, $produto->getId()); if ($db->select()) { return $db->result(); } } catch (dbException $e) { return $e->gerMessageErro(); } }
public static function query($sql, $params = false) { self::connect(); self::$result = self::$conn->prepare($sql); try { if ($params) { self::$result->execute($params); } else { self::$result->execute(); } } catch (PDOException $e) { //echo '<pre>'.$e->getMessage()."\n".$e; //print_r($params); //echo '</pre>'; } return self::$result->rowCount(); }
<?php define('ROOT', '../'); //define('HOST','localhost'); //define('USER','root'); //define('PASS','admin'); //define('DBNAME','2015_etc'); define('HOST', 'localhost'); define('USER', 'root'); define('PASS', ''); define('DBNAME', 'admin_masterapk'); //require_once( ROOT.'../wp-admin/admin.php' ); include "inc/db.php"; include "inc/lib.php"; include "inc/simple_html_dom.php"; include "inc/function_string.php"; $db = new db(); $sql = "SELECT ID, file FROM wp_posts as p, wp_downloads as d WHERE p.ID = d.post_id ORDER BY ID DESC"; $list = $db->result($sql); foreach ($list as $rs) { $id_com = getCom($rs->file); $vdata['id_com'] = $id_com; $db->update("wp_posts", $vdata, array("ID" => $rs->ID)); unset($vdata); }
} $article['related'] = array(); if ($page < 2 && $op != 'addpage') { $query = DB::query("SELECT a.aid,a.title\n\t\t\t\tFROM " . DB::table('portal_article_related') . " r\n\t\t\t\tLEFT JOIN " . DB::table('portal_article_title') . " a ON a.aid=r.raid\n\t\t\t\tWHERE r.aid='{$aid}'"); while ($value = DB::fetch($query)) { $article['related'][] = $value; } } } $_GET['from_id'] = empty($_GET['from_id']) ? 0 : intval($_GET['from_id']); if ($_GET['from_idtype'] != 'blogid') { $_GET['from_idtype'] = 'tid'; } $idtypes = array($_GET['from_idtype'] => ' selected'); if ($_GET['from_idtype'] && $_GET['from_id']) { $havepush = db::result(db::query("SELECT COUNT(*) FROM " . db::table('portal_article_title') . " WHERE id='{$_GET['from_id']}' AND idtype='{$_GET['from_idtype']}'"), 0); if ($havepush) { showmessage('article_push_invalid_repeat', '', array(), array('return' => true)); } switch ($_GET['from_idtype']) { case 'blogid': $query = DB::query("SELECT b.*, bf.message FROM " . DB::table('home_blog') . " b\n\t\t\t\tLEFT JOIN " . DB::table('home_blogfield') . " bf ON bf.blogid=b.blogid\n\t\t\t\tWHERE b.blogid='{$_GET['from_id']}'"); if ($blog = DB::fetch($query)) { if ($blog['friend']) { showmessage('article_push_invalid_private'); } $article['title'] = getstr($blog['subject'], 0); $article['summary'] = portalcp_get_summary($blog['message']); $article_content['content'] = dhtmlspecialchars($blog['message']); } break;
function timezone_diff_get($params = array()) { if (isset($params['sensor']) && !is_numeric($params['sensor'])) { return false; } $sensor = sensor_get($params['sensor']); date_default_timezone_set('UTC'); if (isset($sensor[$params['sensor']]['measure_timezone_diff']) && is_numeric($sensor[$params['sensor']]['measure_timezone_diff']) && $sensor[$params['sensor']]['measure_timezone_diff'] >= 1) { if (isset($params['debug'])) { debug('Found timezone settings in sensor in timezone_diff_get', $sensor[$params['sensor']]); } $timezone_diff = $sensor[$params['sensor']]['measure_timezone_diff']; } else { $db = new db(); $r = array(); $db->query("SELECT * FROM measure_system WHERE measure_system_setting_name = 'global_timezone_use'"); $d = $db->result(); if (isset($params['debug'])) { debug('No timezone settings in sensor. Search global timezone settings in db in timezone_diff_get', $d); } $timezone_diff = $d['measure_system_setting_value']; } if (!isset($timezone_diff) || $timezone_diff == 0) { if (isset($params['debug'])) { debug('Found no timezone settings in timezone_diff_get', $timezone_diff); } return false; } preg_match('/(-)?(.+)/', $timezone_diff, $r); $diff['prefix'] = $r[1] != '' ? $r[1] : false; $diff['diff'] = $r[2] * 60 * 60; return $diff; }
<?php /** * [Discuz!] (C)2001-2099 Comsenz Inc. * This is NOT a freeware, use is subject to license terms * * $Id: spacecp_upload.php 10707 2010-05-14 02:36:45Z zhengqingpeng $ */ if (!defined('IN_DISCUZ')) { exit('Access Denied'); } $albumid = empty($_GET['albumid']) ? 0 : intval($_GET['albumid']); if ($_GET['op'] == 'recount') { $newsize = db::result(db::query("SELECT SUM(size) FROM " . db::table('home_pic') . " WHERE uid='{$_G['uid']}'"), 0); db::update('common_member_count', array('attachsize' => $newsize), array('uid' => $_G['uid'])); showmessage('do_success', 'home.php?mod=spacecp&ac=upload'); } if (submitcheck('albumsubmit')) { if ($_POST['albumop'] == 'creatalbum') { $_POST['albumname'] = empty($_POST['albumname']) ? '' : getstr($_POST['albumname'], 50, 1, 1); if (empty($_POST['albumname'])) { $_POST['albumname'] = gmdate('Ymd'); } $_POST['friend'] = intval($_POST['friend']); $_POST['target_ids'] = ''; if ($_POST['friend'] == 2) { $uids = array(); $names = empty($_POST['target_names']) ? array() : explode(' ', str_replace(array(lang('spacecp', 'tab_space'), "\r\n", "\n", "\r"), ' ', $_POST['target_names'])); if ($names) { $query = DB::query("SELECT uid FROM " . DB::table('common_member') . " WHERE username IN (" . dimplode($names) . ")"); while ($value = DB::fetch($query)) {
ckstart($start, $perpage); if ($id > 0) { $query = DB::query("SELECT * FROM " . DB::table('home_album') . " WHERE albumid='{$id}' AND uid='{$space['uid']}' LIMIT 1"); $album = DB::fetch($query); if (empty($album)) { showmessage('to_view_the_photo_does_not_exist'); } ckfriend_album($album); $wheresql = "albumid='{$id}'"; $count = $album['picnum']; if (empty($count) && !$space['self']) { DB::query("DELETE FROM " . DB::table('home_album') . " WHERE albumid='{$id}'"); showmessage('to_view_the_photo_does_not_exist', "home.php?mod=space&uid={$album['uid']}&do=album&view=me"); } if ($album['catid']) { $album['catname'] = db::result(db::query("SELECT catname FROM " . db::table('home_album_category') . " WHERE catid='{$album['catid']}'"), 0); } } else { $wheresql = "albumid='0' AND uid='{$space['uid']}'"; $count = getcount('home_pic', array('albumid' => 0, 'uid' => $space['uid'])); $album = array('uid' => $space['uid'], 'albumid' => -1, 'albumname' => lang('space', 'default_albumname'), 'picnum' => $count); } $albumlist = array(); $maxalbum = $nowalbum = $key = 0; $query = DB::query("SELECT * FROM " . DB::table('home_album') . " WHERE uid='{$space['uid']}' ORDER BY updatetime DESC LIMIT 0, 100"); while ($value = DB::fetch($query)) { if ($value['friend'] != 4 && ckfriend($value['uid'], $value['friend'], $value['target_ids'])) { $value['pic'] = pic_cover_get($value['pic'], $value['picflag']); } elseif ($value['picnum']) { $value['pic'] = STATICURL . 'image/common/nopublish.gif'; } else {