public function testInstall() { global $DB; $query = "SHOW FULL TABLES WHERE TABLE_TYPE LIKE 'VIEW'"; $result = $DB->query($query); while ($data = $DB->fetch_array($result)) { $DB->query("DROP VIEW " . $data[0]); } $query = "SHOW TABLES"; $result = $DB->query($query); while ($data = $DB->fetch_array($result)) { $DB->query("DROP TABLE " . $data[0]); } include_once GLPI_ROOT . "/inc/dbmysql.class.php"; include_once GLPI_CONFIG_DIR . "/config_db.php"; // Install a fresh 0.80.5 DB $DB = new DB(); $res = $DB->runFile(GLPI_ROOT . "/install/mysql/glpi-0.80.3-empty.sql"); $this->assertTrue($res, "Fail: SQL Error during install"); // update default language $query = "UPDATE `glpi_configs`\n SET `language` = 'en_GB'"; $this->assertTrue($DB->query($query), "Fail: can't set default language"); $query = "UPDATE `glpi_users`\n SET `language` = 'en_GB'"; $this->assertTrue($DB->query($query), "Fail: can't set users language"); $GLPIlog = new GLPIlogs(); $GLPIlog->testSQLlogs(); $GLPIlog->testPHPlogs(); }
function insert() { $dbc = new DB(); $dbc->connect(); $sql = "insert into registered_users(FullName,Username,Password,Email,Mobile,RegNo) values('{$this->name}','{$this->username}','{$this->password}','{$this->email}','{$this->mobile}','{$this->regNo}')"; $dbc->query($sql); }
function verifyUser($email, $code, $DATABASE) { $db = new DB(); $exists = $db->select("SELECT * \n\t FROM " . $DATABASE . ".users \n\t WHERE email = " . $db->quote($email) . " AND activation = " . $db->quote($code)); if (empty($exists[0])) { error("Invalid Verification", "Your verification is invalid. You might already be verified."); } else { //TODO this is copied into preferences for updateing email if (preg_match("/((@uw\\.edu)|(@u\\.washington\\.edu))/i", $exists[0]["email"])) { $netid = substr($exists[0]["email"], 0, strpos($exists[0]["email"], "@")); $db->query("UPDATE " . $DATABASE . ".users\n\t\t\t SET activation = '1', netid = " . $db->quote($netid) . " WHERE email = " . $db->quote($email)); } else { $db->query("UPDATE " . $DATABASE . ".users\n\t\t\t SET activation = '1', netid = NULL\n\t\t\t WHERE email = " . $db->quote($email)); } head(); ?> <section class="content"> <div class="container"> <h1>Success!</h1> <p>You are now verified with the Experimental College! Sign up for some classes!</p> </div> </section> <?php tail(); } }
function torrents() { $db = new DB(); // Remove inactive peers $db->query("DELETE FROM {PREFIX}peers WHERE peer_last_action < " . $this->deadtime_peers); $db->query("UPDATE {PREFIX}torrents SET torrent_visible='0' WHERE torrent_visible='1' AND torrent_last_action < " . $this->deadtime_peers); $db->query("DELETE FROM {PREFIX}users WHERE user_last_access < " . $this->deadtime_users . " AND user_status != 1"); $torrents = array(); $db = new DB(); $db->query("SELECT peer_torrent, peer_seeder, COUNT(*) AS c FROM {PREFIX}peers GROUP BY peer_torrent, peer_seeder"); while ($db->nextRecord()) { if ($db->peer_seeder == 1) { $key = "seeders"; } else { $key = "leechers"; } $torrents[$db->peer_torrent][$key] = $db->c; } foreach ($torrents as $torrent => $array) { $update = array(); if (isset($array['seeders'])) { $update[] = "torrent_seeders = " . $array['seeders']; } if (isset($array['leechers'])) { $update[] = "torrent_leechers = " . $array['leechers']; } $db->query("UPDATE {PREFIX}torrents SET " . implode(", ", $update) . " WHERE torrent_id = '" . $torrent . "'"); } }
/** * Matriz de permisos - perfiles * @return string html */ public function getMatrizPermisos() { $dataop = ""; $db = new DB(); $sql = "SELECT * FROM perfiles"; $perfiles = $db->query($sql); $sql = "SELECT * FROM opciones"; $opciones = $db->query($sql); /* Cadena con encabezado de opciones (componentes) */ while ($row = $db->fetchNextObject($opciones)) { $dataop .= "<th>{$row->descrip}</th>"; } $data = "<table class='adminlist'>"; $data .= "<tr><th></th>" . $dataop . "</tr>"; while ($line = $db->fetchNextObject($perfiles)) { $data .= "<tr><td class='headlines'>" . $line->descrip . "</td>"; /* Trae de nuevo consulta de opciones para construir */ $opciones = $db->query($sql); while ($row = $db->fetchNextObject($opciones)) { $sql1 = "SELECT perfil_cd, opcion_cd, lectura, escritura " . "FROM permisos WHERE perfil_cd = {$line->codigo} " . "AND opcion_cd = {$row->codigo}"; $res = $db->queryUniqueObject($sql1); $data .= '<td>Lectura: <input type="checkbox" id="" name="" value="" />'; $data .= 'Escritura: <input type="checkbox" id="" name="" value="" /></td>'; } $data .= "</tr>"; } $data .= "</table>"; $tpl = new Erudio_Smarty(); $tpl->assign('matriz', $data); $tpl->display('usuarios/matrizPermisos.tpl'); }
public function index() { $db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE, DB_PORT); if ($this->request->server['REQUEST_METHOD'] == 'POST' && $this->validate()) { $db->query("REPLACE INTO `" . DB_PREFIX . "setting` SET `config_fraud_status_id` = '1', `config_fraud_score` = '" . (int) $this->request->post['config_fraud_score'] . "', `config_fraud_key` = '" . $db->escape($this->request->post['config_fraud_score']) . "', `config_fraud_detection` = '" . (int) $this->request->post['config_fraud_detection'] . "' WHERE `store_id` = '0' AND `code` = 'config'"); $this->session->data['success'] = $this->language->get('text_maxmind_success'); $this->response->redirect($this->url->link('step_4')); } else { $this->document->setTitle($this->language->get('heading_maxmind')); $data['heading_maxmind'] = $this->language->get('heading_maxmind'); $data['heading_maxmind_small'] = $this->language->get('heading_maxmind_small'); $data['text_maxmind_top'] = $this->language->get('text_maxmind_top'); $data['text_maxmind_link'] = $this->language->get('text_maxmind_link'); $data['entry_licence_key'] = $this->language->get('entry_licence_key'); $data['entry_risk'] = $this->language->get('entry_risk'); $data['entry_fraud_status'] = $this->language->get('entry_fraud_status'); $data['help_maxmind_risk'] = $this->language->get('help_maxmind_risk'); $data['help_maxmind_fraud'] = $this->language->get('help_maxmind_fraud'); $data['button_continue'] = $this->language->get('button_continue'); $data['button_back'] = $this->language->get('button_back'); $data['action'] = $this->url->link('maxmind'); if (isset($this->request->post['config_fraud_detection'])) { $data['config_fraud_detection'] = $this->request->post['config_fraud_detection']; } else { $data['config_fraud_detection'] = ''; } if (isset($this->request->post['config_fraud_key'])) { $data['config_fraud_key'] = $this->request->post['config_fraud_key']; } else { $data['config_fraud_key'] = ''; } if (isset($this->request->post['config_fraud_score'])) { $data['config_fraud_score'] = $this->request->post['config_fraud_score']; } else { $data['config_fraud_score'] = '80'; } $data['order_statuses'] = $db->query("SELECT * FROM " . DB_PREFIX . "order_status WHERE language_id = '1' ORDER BY name ASC")->rows; if (isset($this->request->post['config_fraud_status_id'])) { $data['config_fraud_status_id'] = $this->request->post['config_fraud_status_id']; } else { $data['config_fraud_status_id'] = ''; } if (isset($this->error['fraud_key'])) { $data['error_fraud_key'] = $this->error['fraud_key']; } else { $data['error_fraud_key'] = ''; } if (isset($this->error['fraud_score'])) { $data['error_fraud_score'] = $this->error['fraud_score']; } else { $data['error_fraud_score'] = ''; } $data['back'] = $this->url->link('step_4'); $data['footer'] = $this->load->controller('footer'); $data['header'] = $this->load->controller('header'); $this->response->setOutput($this->load->view('maxmind.tpl', $data)); } }
public function getUser() { $sql = "SELECT id, firstname, lastname, password, email, phone, created_at FROM users"; $this->db->query($sql); $users = $this->db->fetch_accoc(); echo '<pre>'; print_r($users); echo '</pre>'; }
public static function create_new($series_name) { $db = new DB(); $query = 'SELECT * FROM cards_series WHERE name ="' . $series_name . '"'; $res = $db->query($query); if (!($row = mysql_fetch_array($res))) { $query = 'INSERT INTO store.cards_series (serial_id , name ) VALUES ( NULL , "' . $series_name . '")'; $db->query($query); } }
public function getGenres($type = '', $activeonly = false) { $db = new DB(); if (!empty($type)) { $typesql = sprintf(" and genres.type = %d", $type); } else { $typesql = ''; } if ($activeonly) { return $db->query(sprintf("SELECT genres.* FROM genres INNER JOIN (SELECT DISTINCT genreID FROM musicinfo) X ON X.genreID = genres.ID %s\n\t\t\tUNION\n\t\t\tSELECT genres.* FROM genres INNER JOIN (SELECT DISTINCT genreID FROM consoleinfo) X ON X.genreID = genres.ID %s\n\t\t\tORDER BY title", $typesql, $typesql)); } else { return $db->query(sprintf("select genres.* from genres where 1 %s order by title", $typesql)); } }
static function getMatchScoreList($verses, $club) { $db = new DB(); $sql = "SELECT match_id FROM game WHERE verses = '{$verses}' AND match_date= CURDATE()"; $m_id = $db->query($sql)->fetch(PDO::FETCH_ASSOC); $mat_id = $m_id['match_id']; $match_id = (int) $mat_id; $sql = "SELECT club_id FROM club WHERE name={$club}"; $c_id = $db->query($sql)->fetch(PDO::FETCH_ASSOC); $clu_id = $c_id['club_id']; $club_id = (int) $clu_id; $sql = "SELECT player.name,player_score,srate,balls FROM playerplay RIGHT JOIN player WHERE \n\t\tplayer.player_id = playerplay.player_id WHERE club_id = {$club_id}"; $res = $db->query($sql); return $res->fetchAll(PDO::FETCH_ASSOC); }
public function run($request) { $gp = ShopConfig::current()->CustomerGroup(); if (empty($gp)) { return false; } $allCombos = DB::query("SELECT \"ID\", \"MemberID\", \"GroupID\" FROM \"Group_Members\" WHERE \"Group_Members\".\"GroupID\" = " . $gp->ID . ";"); //make an array of all combos $alreadyAdded = array(); $alreadyAdded[-1] = -1; if ($allCombos) { foreach ($allCombos as $combo) { $alreadyAdded[$combo["MemberID"]] = $combo["MemberID"]; } } $unlistedMembers = DataObject::get("Member", $where = "\"Member\".\"ID\" NOT IN (" . implode(",", $alreadyAdded) . ")", $sort = null, $join = "INNER JOIN \"Order\" ON \"Order\".\"MemberID\" = \"Member\".\"ID\""); //add combos if ($unlistedMembers) { $existingMembers = $gp->Members(); foreach ($unlistedMembers as $member) { $existingMembers->add($member); echo "."; } } else { echo "no new members added"; } }
public static function authentication() { // print_r($_SERVER); // exit(); if (!isset($_SERVER['PHP_AUTH_USER'])) { header('WWW-Authenticate: Basic realm="My Realm"'); header('HTTP/1.0 401 Unauthorized'); echo 'Text to send if user hits Cancel button'; exit; } else { $db = new DB(); $username = mysql_real_escape_string($_SERVER['PHP_AUTH_USER']); $password = mysql_real_escape_string($_SERVER['PHP_AUTH_PW']); $domain = 'nebula.com'; $hash = md5($username . ':' . $domain . ':' . $password); $sql = "SELECT id from n_nebulauser WHERE username='******' AND ha1='{$hash}'"; $q = $db->query($sql); if (mysql_num_rows($q)) { $fetch = mysql_fetch_assoc($q); return $fetch['id']; } else { return null; } } return false; }
function build_cache_fields_connect_register() { global $_G; $data = array(); $fields = array(); if ($_G['setting']['connect']['register_gender']) { $fields[] = 'gender'; } if ($_G['setting']['connect']['register_birthday']) { $fields[] = 'birthyear'; $fields[] = 'birthmonth'; $fields[] = 'birthday'; } if ($fields) { $query = DB::query("SELECT * FROM " . DB::table('common_member_profile_setting') . " WHERE fieldid IN (" . dimplode($fields) . ")"); while ($field = DB::fetch($query)) { $choices = array(); if ($field['selective']) { foreach (explode("\n", $field['choices']) as $item) { list($index, $choice) = explode('=', $item); $choices[trim($index)] = trim($choice); } $field['choices'] = $choices; } else { unset($field['choices']); } $field['showinregister'] = 1; $field['available'] = 1; $data['field_' . $field['fieldid']] = $field; } } save_syscache('fields_connect_register', $data); }
function updategroupcreditlog($fid, $uid) { global $_G; if (empty($fid) || empty($uid)) { return false; } $today = date('Ymd', TIMESTAMP); $updategroupcredit = getcookie('groupcredit_' . $fid); if ($updategroupcredit < $today) { $status = DB::result_first("SELECT logdate FROM " . DB::table('forum_groupcreditslog') . " WHERE fid='{$fid}' AND uid='{$uid}' AND logdate='{$today}'"); if (empty($status)) { DB::query("UPDATE " . DB::table('forum_forum') . " SET commoncredits=commoncredits+1 WHERE fid='{$fid}'"); DB::query("REPLACE INTO " . DB::table('forum_groupcreditslog') . " (fid, uid, logdate) VALUES ('{$fid}', '{$uid}', '{$today}')"); if (empty($_G['forum']) || empty($_G['forum']['level'])) { $forum = DB::fetch_first("SELECT name, level, commoncredits FROM " . DB::table('forum_forum') . " WHERE fid='{$fid}'"); } else { $_G['forum']['commoncredits']++; $forum =& $_G['forum']; } if (empty($_G['grouplevels'])) { loadcache('grouplevels'); } $grouplevel = $_G['grouplevels'][$forum['level']]; if ($grouplevel['type'] == 'default' && !($forum['commoncredits'] >= $grouplevel['creditshigher'] && $forum['commoncredits'] < $grouplevel['creditslower'])) { $levelid = DB::result_first("SELECT levelid FROM " . DB::table('forum_grouplevel') . " WHERE type='default' AND creditshigher<='{$forum['commoncredits']}' AND creditslower>'{$forum['commoncredits']}' LIMIT 1"); if (!empty($levelid)) { DB::query("UPDATE " . DB::table('forum_forum') . " SET level='{$levelid}' WHERE fid='{$fid}'"); $groupfounderuid = DB::result_first("SELECT founderuid FROM " . DB::table('forum_forumfield') . " WHERE fid='{$fid}' LIMIT 1"); notification_add($groupfounderuid, 'system', 'grouplevel_update', array('groupname' => '<a href="forum.php?mod=group&fid=' . $fid . '">' . $forum['name'] . '</a>', 'newlevel' => $_G['grouplevels'][$levelid]['leveltitle'])); } } } dsetcookie('groupcredit_' . $fid, $today, 86400); } }
public function delete($id, $admin = '') { if (empty($id)) { return false; } return DB::query('DELETE FROM %t WHERE ' . DB::field('id', $id) . ' %i', array($this->_table, $admin ? ' AND ' . DB::field('admin', $admin) : '')); }
public function create($id) { //TODO clean output $this->workout_id = $id; $sql = sprintf("INSERT INTO exercises (workout_id,name,rep_min,rep_max,weight_min,weight_max,number_of_sets) VALUES ('%s','%s','%s','%s','%s','%s','%s')", $this->workout_id, $this->name, $this->setcount, $this->repmin, $this->repmax, $this->weightmin, $this->weightmax); return DB::query($sql); }
public function getLessonByNumber($lesson_number, $course_id) { $db = new DB(); $query = "SELECT * FROM lessons WHERE lesson_number='" . $lesson_number . "' AND course_id='" . $course_id . "'"; $date = $db->query($query); return $date[0]; }
function usesubmit() { global $_G; if (empty($_G['gp_tid'])) { showmessage(lang('magic/sofa', 'sofa_info_nonexistence')); } $thread = getpostinfo($_G['gp_tid'], 'tid', array('fid', 'authorid', 'dateline', 'subject')); $this->_check($thread); $firstsofa = DB::result_first("SELECT COUNT(*) FROM " . DB::table('forum_threadmod') . " WHERE magicid='" . $this->magic['magicid'] . "' AND tid='{$_G['gp_tid']}'"); if ($firstsofa >= 1) { showmessage(lang('magic/sofa', 'sofa_info_sofaexistence'), '', array(), array('login' => 1)); } $sofamessage = lang('magic/sofa', 'sofa_text', array('actor' => $_G['member']['username'], 'time' => dgmdate(TIMESTAMP), 'magicname' => $this->magic['name'])); $dateline = $thread['dateline'] + 1; insertpost(array('fid' => $thread['fid'], 'tid' => $_G['gp_tid'], 'first' => '0', 'author' => $_G['username'], 'authorid' => $_G['uid'], 'dateline' => $dateline, 'message' => $sofamessage, 'useip' => $_G['clientip'], 'usesig' => '1')); DB::query("UPDATE " . DB::table('forum_thread') . " SET replies=replies+1, moderated='1' WHERE tid='{$_G['tid']}'", 'UNBUFFERED'); DB::query("UPDATE " . DB::table('forum_forum') . " SET posts=posts+1, todayposts=todayposts+1 WHERE fid='{$post['fid']}'", 'UNBUFFERED'); usemagic($this->magic['magicid'], $this->magic['num']); updatemagiclog($this->magic['magicid'], '2', '1', '0', 0, 'tid', $_G['gp_tid']); updatemagicthreadlog($_G['gp_tid'], $this->magic['magicid']); if ($thread['authorid'] != $_G['uid']) { notification_add($thread['authorid'], 'magic', lang('magic/sofa', 'sofa_notification'), array('tid' => $_G['gp_tid'], 'subject' => $thread['subject'], 'magicname' => $this->magic['name'])); } showmessage(lang('magic/sofa', 'sofa_succeed'), dreferer(), array(), array('showdialog' => 1, 'locationtime' => 1)); }
/** * Returns true if the folder contains files * @return boolean */ public function containsFiles() { if (!$this->owner instanceof Folder) { return false; } return (bool) DB::query("SELECT COUNT(*) FROM File WHERE ParentID = " . (int) $this->owner->ID . " AND ClassName NOT IN ('" . implode("','", array_values(ClassInfo::subclassesFor('Folder'))) . "')")->value(); }
function getsetting() { global $_G; $settings = array('fids' => array('title' => 'couplebanner_fids', 'type' => 'mselect', 'value' => array()), 'groups' => array('title' => 'couplebanner_groups', 'type' => 'mselect', 'value' => array()), 'position' => array('title' => 'couplebanner_position', 'type' => 'mradio', 'value' => array(array(1, 'couplebanner_position_left'), array(2, 'couplebanner_position_right')), 'default' => 1), 'coupleadid' => array('title' => 'couplebanner_coupleadid', 'type' => 'select', 'value' => array())); loadcache(array('forums', 'grouptype')); $settings['fids']['value'][] = $settings['groups']['value'][] = array(0, ' '); $settings['fids']['value'][] = $settings['groups']['value'][] = array(-1, 'couplebanner_index'); if (empty($_G['cache']['forums'])) { $_G['cache']['forums'] = array(); } foreach ($_G['cache']['forums'] as $fid => $forum) { $settings['fids']['value'][] = array($fid, ($forum['type'] == 'forum' ? str_repeat(' ', 4) : ($forum['type'] == 'sub' ? str_repeat(' ', 8) : '')) . $forum['name']); } foreach ($_G['cache']['grouptype']['first'] as $gid => $group) { $settings['groups']['value'][] = array($gid, str_repeat(' ', 4) . $group['name']); if ($group['secondlist']) { foreach ($group['secondlist'] as $sgid) { $settings['groups']['value'][] = array($sgid, str_repeat(' ', 8) . $_G['cache']['grouptype']['second'][$sgid]['name']); } } } $query = DB::query('SELECT * FROM ' . DB::table('common_advertisement') . " WHERE type='couplebanner'"); while ($couple = DB::fetch($query)) { $settings['coupleadid']['value'][] = array($couple['advid'], $couple['title']); } return $settings; }
function doUp() { global $database; if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'OnSitePhoneNumber')) { $speakers_info_query = <<<SQL SELECT ID, OnSitePhoneNumber, ConfirmedDate, RegisteredForSummit FROM PresentationSpeaker where OnSitePhoneNumber IS NOT NULL; SQL; $res = DB::query($speakers_info_query); foreach ($res as $row) { $speaker_id = intval($row['ID']); $on_site_phone = intval($row['OnSitePhoneNumber']); $confirmed_date = $row['ConfirmedDate']; $registered = (bool) $row['RegisteredForSummit']; $speaker = PresentationSpeaker::get()->byID($speaker_id); if (is_null($speaker)) { continue; } if (PresentationSpeakerSummitAssistanceConfirmationRequest::get()->filter(array('SummitID' => 5, 'SpeakerID' => $speaker_id))->count() > 0) { continue; } $assistance = PresentationSpeakerSummitAssistanceConfirmationRequest::create(); $assistance->SpeakerID = $speaker_id; $assistance->SummitID = 5; $assistance->OnSitePhoneNumber = $on_site_phone; $assistance->ConfirmationDate = $confirmed_date; $assistance->RegisteredForSummit = $registered; $assistance->IsConfirmed = true; $assistance->write(); } DBSchema::dropColumn($database, 'PresentationSpeaker', 'OnSitePhoneNumber'); DBSchema::dropColumn($database, 'PresentationSpeaker', 'ConfirmedDate'); DBSchema::dropColumn($database, 'PresentationSpeaker', 'RegisteredForSummit'); } }
function testMySQLCreateTableOptions() { if (DB::getConn() instanceof MySQLDatabase) { $ret = DB::query(sprintf('SHOW TABLE STATUS WHERE "Name" = \'%s\'', 'DatabaseTest_MyObject'))->first(); $this->assertEquals($ret['Engine'], 'InnoDB', "MySQLDatabase tables can be changed to InnoDB through DataObject::\$create_table_options"); } }
public function delete_by_touid($touids) { if (empty($touids)) { return false; } return DB::query('DELETE FROM mc, mq USING %t AS mc, %t AS mq WHERE mc.' . DB::field('touid', $touids) . ' AND mc.cid=mq.cid', array($this->_table, 'common_mailqueue'), false, true); }
public function GroupedCalendarEventsByDate() { $view = $this->getRequest()->getVar('view'); if ($view == "thisweek") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= DATE_ADD(CURDATE(), INTERVAL (0 - WEEKDAY(CURDATE())) DAY) AND `Date` < DATE_ADD(CURDATE(), INTERVAL (7 - WEEKDAY(CURDATE())) DAY) ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "nextweek") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= DATE_ADD(CURDATE(), INTERVAL (0 - WEEKDAY(CURDATE()) + 7) DAY) AND `Date` < DATE_ADD(CURDATE(), INTERVAL (7 - WEEKDAY(CURDATE()) + 7) DAY) ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "thismonth") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= CONCAT(DATE_FORMAT(LAST_DAY(CURDATE()),'%Y-%m-'), '01') AND `Date` <= LAST_DAY(CURDATE()) ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "nextmonth") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= CONCAT(DATE_FORMAT(LAST_DAY(DATE_ADD(CURDATE(), INTERVAL 1 MONTH)), '%Y-%m-'), '01') AND `Date` <= LAST_DAY(DATE_ADD(CURDATE(), INTERVAL 1 MONTH)) ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "thisyear") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= CONCAT(YEAR(CURDATE()), '-01-01') AND `Date` <= CONCAT(YEAR(CURDATE()), '-12-31') ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "nextyear") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= CONCAT(YEAR(CURDATE()) + 1, '-01-01') AND `Date` <= CONCAT(YEAR(CURDATE()) + 1, '-12-31') ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "all") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= CURDATE() ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } elseif ($view == "events") { $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } else { // Default to the next 14 days $sql = "SELECT `CalendarEvent`.*, `CalendarEventDate`.`Date`, DATE_FORMAT(`CalendarEventDate`.`Date`, '%W %e %M %Y') AS `FormattedDate` FROM `CalendarEvent` INNER JOIN `CalendarEventDate` ON `CalendarEventDate`.`CalendarEventID` = `CalendarEvent`.`ID` WHERE `Date` >= CURDATE() AND `Date` <= DATE_ADD(CURDATE(), INTERVAL 14 DAY) ORDER BY `CalendarEventDate`.`Date`, `CalendarEvent`.`StartTime`, `CalendarEvent`.`EndTime`"; } $records = DB::query($sql); foreach ($records as $record) { $objects[] = new $record['ClassName']($record); } if (isset($objects)) { $arrayList = new ArrayList($objects); } else { $arrayList = new ArrayList(); } return GroupedList::create($arrayList); }
function ManageSupport($row) { Module::Module($row); if (User::is_admin() || User::have_permit(support_all_perm)) { CGlobal::$website_title = 'Quản lý thư góp ý của khách hàng'; switch (Url::get('cmd')) { case 'delete': DB::query('DELETE FROM support WHERE id=' . EClassApi::getParam('id')); Url::redirect_url(Url::build_all(array('chk_id', 'del_all', 'cmd', 'id'))); break; case "edit": /*case "add": require_once 'forms/edit.php'; $this->add_form(new EditBadWordForm()); break;*/ /*case "add": require_once 'forms/edit.php'; $this->add_form(new EditBadWordForm()); break;*/ default: require_once 'forms/list.php'; $this->add_form(new ManageSupportForm()); break; } } else { Url::access_denied(); } }
function build_cache_forumrecommend() { $data = array(); $query = DB::query("SELECT fid FROM " . DB::table('forum_forum') . " WHERE type<>'group' AND status<>3"); while ($row = DB::fetch($query)) { require_once libfile('function/group'); $squery = DB::query("SELECT f.fid, f.name, f.threads, f.lastpost, ff.icon, ff.membernum, ff.description FROM " . DB::table('forum_forum') . " f LEFT JOIN " . DB::table('forum_forumfield') . " ff ON ff.fid=f.fid WHERE recommend='{$row['fid']}'"); while ($group = DB::fetch($squery)) { $group['icon'] = get_groupimg($group['icon'], 'icon'); $lastpost = array(0, 0, '', ''); $group['lastpost'] = is_string($group['lastpost']) ? explode("\t", $group['lastpost']) : $group['lastpost']; $group['lastpost'] = count($group['lastpost']) != 4 ? $lastpost : $group['lastpost']; list($lastpost['tid'], $lastpost['subject'], $lastpost['dateline'], $lastpost['author']) = $group['lastpost']; if ($lastpost['tid']) { $lastpost['dateline'] = dgmdate($lastpost['dateline'], 'Y-m-d H:i:s'); if ($lastpost['author']) { $lastpost['encode_author'] = rawurlencode($lastpost['author']); } $group['lastpost'] = $lastpost; } else { $group['lastpost'] = ''; } $data[$row['fid']][] = $group; } } save_syscache('forumrecommend', $data); }
public function run($request) { // update block/set titles // Name field has been reverted back to Title // DB::query("update Block set Name = Title"); // DB::query("update BlockSet set Name = Title"); // update block areas DB::query("\n\t\t\tupdate SiteTree_Blocks\n\t\t\tleft join Block on SiteTree_Blocks.BlockID = Block.ID\n\t\t\tset BlockArea = Block.Area\n\t\t\twhere BlockID = Block.ID\n\t\t"); // update block sort DB::query("\n\t\t\tupdate SiteTree_Blocks\n\t\t\tleft join Block on SiteTree_Blocks.BlockID = Block.ID\n\t\t\tset Sort = Block.Weight\n\t\t\twhere BlockID = Block.ID\n\t\t"); echo "BlockAreas, Sort updated<br />"; // migrate global blocks $sc = SiteConfig::current_site_config(); if ($sc->Blocks()->Count()) { $set = BlockSet::get()->filter('Title', 'Global')->first(); if (!$set) { $set = BlockSet::create(array('Title' => 'Global')); $set->write(); } foreach ($sc->Blocks() as $block) { if (!$set->Blocks()->find('ID', $block->ID)) { $set->Blocks()->add($block, array('Sort' => $block->Weight, 'BlockArea' => $block->Area)); echo "Block #{$block->ID} added to Global block set<br />"; } } } // publish blocks $blocks = Block::get()->filter('Published', 1); foreach ($blocks as $block) { $block->publish('Stage', 'Live'); echo "Published Block #{$block->ID}<br />"; } }
public function delete_by_pid($pids) { if (empty($pids)) { return false; } return DB::query('DELETE FROM %t WHERE ' . DB::field('pid', $pids), array($this->_table), false, true); }
/** * Write out the tags for a specific resource. * * @param int $resource_id The story we are tagging. * @param int $channel_id The channel id for the story we are tagging * @param array $tags An array of tags. * * @TODO: Move this to a tagger class that uses Content_Tagger * @return boolean * @throws Jonah_Exception */ public function writeTags($resource_id, $channel_id, $tags) { global $conf; // First, make sure all tag names exist in the DB. $tagkeys = array(); $insert = $this->_db->prepare('INSERT INTO jonah_tags (tag_id, tag_name) VALUES(?, ?)'); $query = $this->_db->prepare('SELECT tag_id FROM jonah_tags WHERE tag_name = ?'); foreach ($tags as $tag) { $tag = Horde_String::lower(trim($tag)); $results = $this->_db->execute($query, $this->_db->escapeSimple($tag)); if ($results instanceof PEAR_Error) { throw new Jonah_Exception($results); } elseif ($results->numRows() == 0) { $id = $this->_db->nextId('jonah_tags'); $result = $this->_db->execute($insert, array($id, $tag)); $tagkeys[] = $id; } else { $row = $results->fetchRow(DB_FETCHMODE_ASSOC); $tagkeys[] = $row['tag_id']; } } // Free our resources. $this->_db->freePrepared($insert, true); $this->_db->freePrepared($query, true); $sql = 'DELETE FROM jonah_stories_tags WHERE story_id = ' . (int) $resource_id; $query = $this->_db->prepare('INSERT INTO jonah_stories_tags (story_id, channel_id, tag_id) VALUES(?, ?, ?)'); Horde::log('SQL query by Jonah_Driver_sql::writeTags: ' . $sql, 'DEBUG'); $this->_db->query($sql); foreach ($tagkeys as $key) { $this->_db->execute($query, array($resource_id, $channel_id, $key)); } $this->_db->freePrepared($query, true); /* @TODO We should clear at least any of our cached counts */ return true; }
public function fetch_all_by_bid($bid, $isverified = 1, $start = 0, $limit = 0, $bannedids = array(), $format = true) { $data = array(); if ($bid = dintval($bid, true)) { $addsql = $bannedids = dintval($bannedids, true) ? ' AND id NOT IN (' . dimplode($bannedids) . ')' : ''; $query = DB::query('SELECT * FROM %t WHERE ' . DB::field('bid', $bid) . ' AND isverified=%d' . $addsql . ' ORDER BY stickgrade DESC, displayorder DESC, verifiedtime DESC, dataid DESC ' . DB::limit($start, $limit), array($this->_table, $isverified)); while ($value = DB::fetch($query)) { if ($format) { $value['fields'] = unserialize($value['fields']); $value['fields']['timestamp'] = $value['fields']['dateline']; $value['fields']['dateline'] = dgmdate($value['fields']['dateline']); $value['pic'] = $value['pic'] !== STATICURL . 'image/common/nophoto.gif' ? $value['pic'] : ''; if ($value['pic'] && $value['picflag'] == '1') { $value['pic'] = getglobal('setting/attachurl') . $value['pic']; } elseif ($value['picflag'] == '2') { $value['pic'] = getglobal('setting/ftp/attachurl') . $value['pic']; } $value['dateline'] = dgmdate($value['dateline'], 'u'); $value['verifiedtime'] = dgmdate($value['verifiedtime'], 'u'); } $data[$value['id']] = $value; } } return $data; }