/** * chapter/index and book/index by name callback * @param eRequest $request */ public function chapterIdByTitle(eRequest $request) { $name = $request->getRequestParam('name'); if ($id = $request->getRequestParam('id')) { $request->setRequestParam('name', $id); return; } elseif (!$name || is_numeric($name)) { if (ADMIN) { e107::getMessage()->addError("One of your page-chapters is missing a SEF URL value"); } return; } $sql = e107::getDb('url'); $name = e107::getParser()->toDB($name); if ($sql->select('page_chapters', 'chapter_id', "chapter_sef='{$name}'")) { $name = $sql->fetch(); $request->setRequestParam('id', $name['chapter_id']); $request->setRequestParam('type', 'bk'); e107::getMessage()->addDebug("Set CHAPTER ID = '" . $name['chapter_id'] . "'"); } elseif ($sql->select('page', 'page_id', "page_sef='{$name}'")) { $name = $sql->fetch(); $request->setRequestParam('id', $name['page_id']); $request->setRequestParam('type', 'id'); e107::getMessage()->addDebug("Set PAGE ID = '" . $name['page_id'] . "'"); } else { if (ADMIN) { e107::getMessage()->addError("Couldn't find a book, chapter or page with a SEF URL value of '" . $name . "'"); } $request->setRequestParam('id', 0); } }
function sc_newscomments($parm = null) { $pref = e107::getPref(); $sql = e107::getDb(); if ($this->commentsDisabled || $this->commentsEngine != 'e107') { return ''; } $news_item = $this->news_item; $param = $this->param; if ($param['current_action'] == 'extend') { return LAN_NEWS_99 . ' (' . $news_item['news_comment_total'] . ')'; } if (vartrue($pref['multilanguage'])) { // Can have multilanguage news table, monlingual comment table. If the comment table is multilingual, it'll only count entries in the current language $news_item['news_comment_total'] = $sql->count("comments", "(*)", "WHERE comment_item_id='" . $news_item['news_id'] . "' AND comment_type='0' "); } //XXX - ??? - another query? We should cache it in news table. if ($pref['comments_icon'] && $news_item['news_comment_total']) { $sql->select('comments', 'comment_datestamp', "comment_item_id='" . intval($news_item['news_id']) . "' AND comment_type='0' ORDER BY comment_datestamp DESC LIMIT 0,1"); list($comments['comment_datestamp']) = $sql->fetch(); $latest_comment = $comments['comment_datestamp']; if ($latest_comment > USERLV) { $NEWIMAGE = $param['image_new_small']; } else { $NEWIMAGE = $param['image_nonew_small']; } } else { $NEWIMAGE = $param['image_nonew_small']; } if (deftrue('BOOTSTRAP')) { $NEWIMAGE = ""; } return !$news_item['news_allow_comments'] ? '' . ($pref['comments_icon'] ? $NEWIMAGE . ' ' : '') . "<a title='Comments' href='" . e107::getUrl()->create('news/view/item', $news_item) . "'>" . $param['commentlink'] . intval($news_item['news_comment_total']) . '</a>' : vartrue($param['commentoffstring'], 'Disabled'); }
function getListData() { $sql = e107::getDb(); $tp = e107::getParser(); $list_caption = $this->parent->settings['caption']; $list_display = $this->parent->settings['open'] ? "" : "none"; if ($this->parent->mode == "new_page" || $this->parent->mode == "new_menu") { $lvisit = $this->parent->getlvisit(); $qry = "cb_datestamp>" . $lvisit; } else { $qry = "cb_id != '0' "; } $qry .= " ORDER BY cb_datestamp DESC LIMIT 0," . intval($this->parent->settings['amount']); $bullet = $this->parent->getBullet($this->parent->settings['icon']); if (!($chatbox_posts = $this->parent->e107->sql->gen("SELECT * FROM #chatbox WHERE " . $qry))) { $list_data = LIST_CHATBOX_2; } else { while ($row = $this->parent->e107->sql->fetch()) { $cb_id = substr($row['cb_nick'], 0, strpos($row['cb_nick'], ".")); $cb_nick = substr($row['cb_nick'], strpos($row['cb_nick'], ".") + 1); $cb_message = $row['cb_blocked'] ? CHATBOX_L6 : str_replace("<br />", " ", $tp->toHTML($row['cb_message'])); $rowheading = $this->parent->parse_heading($cb_message); $record['icon'] = $bullet; $record['heading'] = $rowheading; $record['author'] = $this->parent->settings['author'] ? $cb_id != 0 ? "<a href='" . e_BASE . "user.php?id.{$cb_id}'>" . $cb_nick . "</a>" : $cb_nick : ""; $record['category'] = ""; $record['date'] = $this->parent->settings['date'] ? $row['cb_datestamp'] ? $this->parent->getListDate($row['cb_datestamp']) : "" : ""; $record['info'] = ""; $list_data[] = $record; } } //return array with 'records', (global)'caption', 'display' return array('records' => $list_data, 'caption' => $list_caption, 'display' => $list_display); }
function getHookImages($hook, $count) { $sql = e107::getDb(); $pref = e107::pref('imggregator'); $count = isset($count) ? $count : $pref['imagesToFetch']; $tokens = explode(';', $sql->retrieve('hooks', 'hook_tokens', 'hook_name="' . $hook . '"')); if ($hook == 'instagram') { $user_id = explode(':', $tokens[0]); $access_token = explode(':', $tokens[1]); $url = fetchData('https://api.instagram.com/v1/users/' . $user_id[1] . '/media/recent/?access_token=' . $access_token[1] . '&count=' . $count); $result = json_decode($url); $i = 0; foreach ($result->data as $image) { copy($image->images->standard_resolution->url, 'images/instagram' . $i . '.jpg'); $i++; //$images[] = $image->images->standard_resolution->url; } } else { if ($hook == 'flickr') { $user_id = explode(':', $tokens[0]); $api_key = explode(':', $tokens[1]); $xml = simplexml_load_file('https://api.flickr.com/services/rest/?method=flickr.people.getPublicPhotos&api_key=' . $api_key[1] . '&user_id=' . urlencode($user_id[1]) . '&format=rest'); $i = 0; foreach ($xml->photos->photo as $photo) { if ($photo['ispublic'] == 1) { copy('https://farm' . $photo['farm'] . '.staticflickr.com/' . $photo['server'] . '/' . $photo['id'] . '_' . $photo['secret'] . '.jpg', 'images/flickr' . $i . '.jpg'); $i++; //$images[] .= 'https://farm'.$photo['farm'].'.staticflickr.com/'.$photo['server'].'/'.$photo['id'].'_'.$photo['secret'].'.jpg'; } } } } return $images; }
function forum_thread_moderate($p) { $e107 = e107::getInstance(); $sql = e107::getDb(); foreach ($p as $key => $val) { if (preg_match("#(.*?)_(\\d+)_x#", $key, $matches)) { $act = $matches[1]; $id = (int) $matches[2]; switch ($act) { case 'lock': $sql->update('forum_thread', 'thread_active=0 WHERE thread_id=' . $id); return LAN_FORUM_CLOSE; break; case 'unlock': $sql->update('forum_thread', 'thread_active=1 WHERE thread_id=' . $id); return LAN_FORUM_OPEN; break; case 'stick': $sql->update('forum_thread', 'thread_sticky=1 WHERE thread_id=' . $id); return LAN_FORUM_STICK; break; case 'unstick': $sql->update('forum_thread', 'thread_sticky=0 WHERE thread_id=' . $id); return LAN_FORUM_UNSTICK; break; case 'deleteThread': return forumDeleteThread($id); break; case 'deletePost': return forumDeletePost($id); break; } } } }
/** * Configuration Fields. * @return array */ public function config($menu = '') { $fields = array(); $categories = array(); $tmp = e107::getDb()->retrieve('news_category', 'category_id,category_name', null, true); foreach ($tmp as $val) { $id = $val['category_id']; $categories[$id] = $val['category_name']; } switch ($menu) { case "latestnews": $fields['caption'] = array('title' => LAN_CAPTION, 'type' => 'text', 'multilan' => true, 'writeParms' => array('size' => 'xxlarge')); $fields['count'] = array('title' => LAN_LIMIT, 'type' => 'text', 'writeParms' => array('pattern' => '[0-9]*', 'size' => 'mini')); $fields['category'] = array('title' => LAN_CATEGORY, 'type' => 'dropdown', 'writeParms' => array('optArray' => $categories, 'default' => 'blank')); break; case "news_categories": $fields['caption'] = array('title' => LAN_CAPTION, 'type' => 'text', 'multilan' => true, 'writeParms' => array('size' => 'xxlarge')); $fields['count'] = array('title' => LAN_LIMIT, 'type' => 'text', 'writeParms' => array('pattern' => '[0-9]*')); break; case "news_months": $fields['showarchive'] = array('title' => "Display Archive Link", 'type' => 'boolean'); $fields['year'] = array('title' => "Year", 'type' => 'text', 'writeParms' => array('pattern' => '[0-9]*', 'size' => 'mini')); break; case "other_news": case "other_news2": $fields['caption'] = array('title' => LAN_CAPTION, 'type' => 'text', 'multilan' => true, 'writeParms' => array('size' => 'xxlarge')); break; } return $fields; }
/** * For inserting default database content during install after table has been created by the test_sql.php file. */ function install_post($var) { $sql = e107::getDb(); $mes = e107::getMessage(); /* $e107_test = array( 'test_id' =>'1', 'test_icon' =>'{e_PLUGIN}test/images/test_32.png', 'test_type' =>'type_1', 'test_name' =>'My Name', 'test_folder' =>'Folder Value', 'test_version' =>'1', 'test_author' =>'bill', 'test_authorURL' =>'http://e107.org', 'test_date' =>'1352871240', 'test_compatibility' =>'2', 'test_url' =>'http://e107.org' ); if($sql->insert('test',$e107_test)) { $mes->add("Custom - Install Message.", E_MESSAGE_SUCCESS); } else { $mes->add("Custom - Failed to add default table data.", E_MESSAGE_ERROR); }*/ }
function iconpicker_shortcode($parm) { $parms = array(); parse_str($parm, $parms); $name = varset($parms['id']); $sql = e107::getDb(); $frm = e107::getForm(); $tp = e107::getParser(); // $sc_parameters is currently being used to select the media-category. $qry = "SELECT * FROM `#core_media` WHERE media_userclass IN (" . USERCLASS_LIST . ") "; $qry .= vartrue($sc_parameters) ? " AND media_category = '" . $sc_parameters . "' " : " AND `media_category` REGEXP '_icon_16|_icon_32|_icon_48|_icon_64' "; $qry .= "ORDER BY media_category,media_name"; $str = ""; $size_section = array(); $lastsize = "16"; if ($sql->db_Select_gen($qry)) { while ($row = $sql->db_Fetch()) { list($tmp, $tmp2, $size) = explode("_", $row['media_category']); if ($str != '' && $size != $lastsize) { $size_section[] = $str; $str = ""; } $str .= "<a href='#" . $row['media_url'] . "' title='{$filepath}' onclick=\"e107Helper.insertText('{$row['media_url']}','{$name}','{$name}-iconpicker'); return false; \"><img class='icon picker list%%size%%' src='" . $tp->replaceConstants($row['media_url'], 'abs') . "' alt='{$row['media_name']}' /></a>"; $lastsize = $size; } return '<div id="' . $name . '-iconpicker-ajax"><div class="field-spacer iconpicker">' . str_replace('%%size%%', '', implode('</div><div class="field-spacer iconpicker">', $size_section)) . '</div></div>'; } }
public function renderBanner($row) { $sql = e107::getDb('banner'); $tp = e107::getParser(); if (!$row['banner_image']) { return "<a href='" . e_HTTP . 'banner.php?' . $row['banner_id'] . "' rel='external'>no image assigned to this banner</a>"; } $fileext1 = substr(strrchr($row['banner_image'], '.'), 1); $sql->update('banner', 'banner_impressions=banner_impressions+1 WHERE banner_id=' . (int) $row['banner_id']); switch ($fileext1) { case 'swf': return "\n\t\t\t\t\t<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0\" width=\"468\" height=\"60\">\n\n\t\t\t\t\t<param name=\"movie\" value=\"" . e_IMAGE_ABS . "banners/" . $row['banner_image'] . "\">\n\n\t\t\t\t\t<param name=\"quality\" value=\"high\">\n\n\t\t\t\t\t<param name=\"SCALE\" value=\"noborder\">\n\n\t\t\t\t\t<embed src=\"" . e_IMAGE_ABS . "banners/" . $row['banner_image'] . "\" width=\"468\" height=\"60\" scale=\"noborder\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"></embed>\n\t\t\t\t\t</object>\n\t\t\t\t\t"; break; case 'html': case 'js': case 'php': // Code - may 'echo' text, or may return it as a value $file_data = file_get_contents(e_IMAGE . 'banners/' . $row['banner_image']); return $file_data; break; default: $src = $row['banner_image'][0] == '{' ? $tp->thumbUrl($row['banner_image']) : e_IMAGE_ABS . 'banners/' . $row['banner_image']; $ban_ret = "<img class='e-banner img-responsive' src='" . $src . "' alt='" . $row['banner_clickurl'] . "' style='border:0' />"; break; } return "<a class='e-tip' href='" . e_HTTP . 'banner.php?' . $row['banner_id'] . "' rel='external' title=\"" . $tp->toAttribute($row['banner_description']) . "\">" . $ban_ret . '</a>'; }
function unanswered() { $sql = e107::getDb(); $tp = e107::getParser(); $limit = 25; $count = $sql->retrieve('faqs', 'faq_id', "faq_answer='' ", true); $existing = $sql->retrieve('faqs', 'faq_id,faq_question,faq_datestamp', "faq_answer='' ORDER BY faq_datestamp DESC LIMIT " . $limit, true); if (empty($existing)) { return; } $questions = array(); foreach ($existing as $row) { $questions[] = "<i>" . $row['faq_question'] . "</i><br /><small>" . $tp->toDate($row['faq_datestamp'], 'short') . "</small>\n"; // $questions[] = $row['faq_question']; } // // $questions = array( "<i>Test Question</i><br /><small>".$tp->toDate(time(),'short')."</small>"); $name = SITENAME . " Automation"; $email = e107::pref('core', 'siteadminemail'); $name = e107::pref('core', 'siteadmin'); $link = $tp->replaceConstants("{e_PLUGIN}faqs/admin_config.php?mode=main&action=list&filter=pending", 'full'); $body = "<h2>" . count($count) . " Unuanswered Questions at " . SITENAME . "</h2>To answer these questions, please login to " . SITENAME . " and then <a href='{$link}'>click here</a>.<br />\n\t\t\tThe " . $limit . " most recent questions are displayed below.\n\t\t\t<ul><li>" . implode("</li><li>", $questions) . "</li></ul>"; $eml = array('subject' => count($count) . " Unuanswered Question as of " . date('d-M-Y') . " ", 'sender_name' => SITENAME . " Automation", 'html' => true, 'template' => 'default', 'body' => $body); e107::getEmail()->sendEmail($email, $name, $eml); }
/** * Compile RSS Data * @param $parms array url, limit, id * @return array */ function data($parms = '') { $sql = e107::getDb(); $rss = array(); $i = 0; if ($items = $sql->select('chatbox', "*", "cb_blocked=0 ORDER BY cb_datestamp DESC LIMIT 0," . $parms['limit'])) { while ($row = $sql->fetch()) { $tmp = explode(".", $row['cb_nick']); $rss[$i]['author'] = $tmp[1]; $rss[$i]['author_email'] = ''; $rss[$i]['link'] = "chatbox_menu/chat.php?" . $row['cb_id']; $rss[$i]['linkid'] = $row['cb_id']; $rss[$i]['title'] = ''; $rss[$i]['description'] = $row['cb_message']; $rss[$i]['category_name'] = ''; $rss[$i]['category_link'] = ''; $rss[$i]['datestamp'] = $row['cb_datestamp']; $rss[$i]['enc_url'] = ""; $rss[$i]['enc_leng'] = ""; $rss[$i]['enc_type'] = ""; $i++; } } return $rss; }
function getlinks($cat = 1) { $this->eLinkList = array(); // clear the array in case getlinks is called 2x on the same page. $sql = e107::getDb('sqlSiteLinks'); $ins = $cat > 0 ? "link_category = " . intval($cat) . " AND " : ""; $query = "SELECT * FROM #links WHERE " . $ins . " link_class IN (" . USERCLASS_LIST . ") ORDER BY link_order ASC"; if ($sql->db_Select_gen($query)) { while ($row = $sql->db_Fetch()) { if ($row['link_sefurl']) { $this->sefList[$row['link_sefurl']] = $row['link_url']; } // if (substr($row['link_name'], 0, 8) == 'submenu.'){ // $tmp=explode('.', $row['link_name'], 3); // $this->eLinkList[$tmp[1]][]=$row; if (isset($row['link_parent']) && $row['link_parent'] != 0) { $this->eLinkList['sub_' . $row['link_parent']][] = $row; } else { $this->eLinkList['head_menu'][] = $row; if (vartrue($row['link_function'])) { list($path, $method) = explode("::", $row['link_function']); if (include_once e_PLUGIN . $path . "/e_sitelink.php") { $class = $path . "_sitelinks"; $sublinkArray = e107::callMethod($class, $method); //TODO Cache it. if (vartrue($sublinkArray)) { $this->eLinkList['sub_' . $row['link_id']] = $sublinkArray; } } } } } } }
function colorizeLine($line) { $starPlayers = e107::getDb()->retrieve('starPlayers', '*', '', true); $words = explode(" ", $line); if (!empty($starPlayers[0])) { foreach ($starPlayers as $player) { $usernames = explode(',', $player['usernames']); $colorIt = false; foreach ($usernames as $username) { if (strpos($words[0], $username) !== false) { $colorIt = true; } } if ($colorIt) { $newLine = '<span style="color:' . $player['hexcolor'] . ';">' . $line . '</span>'; break; } else { $newLine = $line; } } $output = $newLine; } else { $output = $line; } return $output; }
function sc_oneliner($parm = '') { $sql = e107::getDb(); $icon = $this->var['current']['icon']; $oneliners = $sql->retrieve('forecasty_oneliners', '*', "`condition`='" . $icon . "' AND `vulgarity`='" . e107::pref('forecasty', 'vulgarity') . "'", true); return $oneliners[array_rand($oneliners)]['line']; }
function install_post($var) { e107::includeLan(e_PLUGIN . 'featurebox/languages/' . e_LANGUAGE . '_admin_featurebox.php'); $mes = e107::getMessage(); $query = array(); $query['fb_category_id'] = 0; $query['fb_category_title'] = 'General'; $query['fb_category_template'] = 'default'; $query['fb_category_random'] = 0; $query['fb_category_class'] = e_UC_PUBLIC; $query['fb_category_limit'] = 1; $inserted = e107::getDb()->db_Insert('featurebox_category', $query); $status = $inserted ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR; $mes->add(FBLAN_INSTALL_01, $status); if ($inserted) { $query = array(); $query['fb_id'] = 0; $query['fb_category'] = $inserted; $query['fb_title'] = 'Default Title'; $query['fb_text'] = 'Default Message'; $query['fb_mode'] = 0; $query['fb_class'] = e_UC_PUBLIC; $query['fb_rendertype'] = 0; $query['fb_template'] = 'default'; $query['fb_order'] = 0; $query['fb_image'] = ''; $query['fb_imageurl'] = ''; $status = e107::getDb('sql2')->db_Insert('featurebox', $query) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR; } else { $status = E_MESSAGE_ERROR; } $mes->add(FBLAN_INSTALL_02, $status); }
function init() { $this->forum_attachment_path = vartrue(trim($_POST['forum_attachment_path'], "/"), false); if ($data = e107::getDb('phpbb')->retrieve('userclass_classes', 'userclass_id', "userclass_name='FORUM_MODERATOR' ")) { $this->forum_moderator_class = $data; } }
function getListData() { $sql = e107::getDb(); $list_caption = $this->parent->settings['caption']; $list_display = $this->parent->settings['open'] ? "" : "none"; $qry = ''; if ($this->parent->mode == "new_page" || $this->parent->mode == "new_menu") { $qry = "user_join>" . $this->parent->getlvisit() . " AND "; } $qry .= " user_ban=0 ORDER BY user_join DESC LIMIT 0," . intval($this->parent->settings['amount']); $bullet = $this->parent->getBullet($this->parent->settings['icon']); if (!$this->parent->e107->sql->gen("SELECT user_id,user_name,user_join FROM #user WHERE " . $qry)) { $list_data = LIST_MEMBER_2; } else { while ($row = $this->parent->e107->sql->fetch()) { $record = array(); $rowheading = $this->parent->parse_heading($row['user_name']); //<a href='".e_BASE."user.php?id.".$row['user_id']."'>".$rowheading."</a> $uparams = array('id' => $row['user_id'], 'name' => $rowheading); $link = e107::getUrl()->create('user/profile/view', $uparams); $userlink = "<a href='" . $link . "'>" . $rowheading . "</a>"; $record['icon'] = $bullet; $record['heading'] = USER ? $userlink : $rowheading; $record['category'] = ''; $record['author'] = ''; $record['date'] = vartrue($this->parent->settings['date']) ? $this->parent->getListDate($row['user_join']) : ""; $record['info'] = ''; $list_data[] = $record; } } //return array with 'records', (global)'caption', 'display' return array('records' => $list_data, 'caption' => $list_caption, 'display' => $list_display); }
function do_export($filename, $type_list = '', $format_array, $sep = ',', $quot = '"') { $sql = e107::getDb(); $export_text = ''; $qry = "SELECT * FROM `#banlist` "; if ($type_list != '') { $qry .= " WHERE`banlist_bantype` IN ({$type_list})"; } if (!$sql->db_Select_gen($qry)) { return 'No data: ' . $qry; } while ($row = $sql->db_Fetch()) { $line = ''; $spacer = ''; foreach ($format_array as $f => $v) { switch ($f) { case 'banlist_ip': case 'banlist_bantype': case 'banlist_reason': case 'banlist_notes': $line .= $spacer . $quot . $row[$f] . $quot; break; case 'banlist_datestamp': case 'banlist_banexpires': if ($row[$f]) { $line .= $spacer . $quot . strftime($v, $row[$f]) . $quot; } else { $line .= $spacer . $quot . '0' . $quot; } break; } $spacer = $sep; } $export_text .= $line . "\n"; } if (defined('CSV_DEBUG')) { $export_text .= 'Summary data: <br />'; $export_text .= 'File: ' . $filename . '<br />'; $export_text .= 'Types: ' . $type_list . '<br />'; $export_text .= 'Query: ' . $qry . '<br />'; echo str_replace("\n", "<br />", $export_text); } else { if (headers_sent()) { return "Cannot output file - some data already sent<br /><br />"; } //Secure https check if (isset($_SERVER['HTTP_USER_AGENT']) && $_SERVER['HTTP_USER_AGENT'] == 'contype') { header('Pragma: public'); } if (isset($_SERVER['HTTP_USER_AGENT']) && strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE')) { header('Content-Type: application/force-download'); } else { header('Content-Type: application/octet-stream'); } header('Content-Length: ' . strlen($export_text)); header('Content-disposition: attachment; filename="' . $filename . '"'); echo $export_text; } }
function install_post($var) { $sql = e107::getDb(); $mes = e107::getMessage(); $query = "INSERT INTO #pcontent VALUES \n\t\t(1, 'content', '', '', '', '1', '', '', '', '0', '0', '0', '0', '', '" . time() . "', '0', '0', '', '1', '0', '', '') ,\n\t\t(2, 'article', '', '', '', '1', '', '', '', '0', '0', '0', '0', '', '" . time() . "', '0', '0', '', '2', '0', '', ''),\n\t\t(3, 'review', '', '', '', '1', '', '', '', '0', '0', '0', '0', '', '" . time() . "', '0', '0', '', '3', '0', '', '')"; $status = $sql->gen($query) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR; $mes->add("Adding Default table categories to table: content ", $status); }
function upgrade_post($var) { $sql = e107::getDb(); if ($sql->isEmpty('forum_thread') === true && $sql->isTable('forum_t') && $sql->isEmpty('forum_t') === false) { $mes = e107::getMessage(); $mes->addSuccess("Migration is required. Please click 'Continue'.<br /><a class='btn btn-primary' href='" . e_PLUGIN . "forum/forum_update.php'>Continue</a>"); } }
function __construct() { $books = e107::getDb()->retrieve("SELECT * FROM #page_chapters ORDER BY chapter_id ASC", true); foreach ($books as $row) { $id = $row['chapter_id']; $this->chapterData[$id] = $row; } }
function install_post($var) { $sql = e107::getDb(); $mes = e107::getMessage(); $insert = array(array('rss_id' => 0, 'rss_name' => 'News', 'rss_url' => 'news', 'rss_topicid' => '', 'rss_path' => 'news', 'rss_text' => 'The rss feed of the news', 'rss_datestamp' => time(), 'rss_class' => '0', 'rss_limit' => '9')); $status = $sql->insert('rss', $insert) ? E_MESSAGE_SUCCESS : E_MESSAGE_ERROR; $mes->add("Adding Default table data to table: rss", $status); //TODO Generic LAN "LAN_DEFAULT_TABLE_DATA" }
public function __construct() { $this->sql_r = e107::getDb('sql_r'); $this->isAdmin = FALSE; $this->fixed_classes = array(e_UC_PUBLIC => UC_LAN_0, e_UC_GUEST => UC_LAN_1, e_UC_NOBODY => UC_LAN_2, e_UC_MEMBER => UC_LAN_3, e_UC_ADMIN => UC_LAN_5, e_UC_MAINADMIN => UC_LAN_6, e_UC_READONLY => UC_LAN_4, e_UC_NEWUSER => UC_LAN_9, e_UC_BOTS => UC_LAN_10); $this->text_class_link = array('public' => e_UC_PUBLIC, 'guest' => e_UC_GUEST, 'nobody' => e_UC_NOBODY, 'member' => e_UC_MEMBER, 'admin' => e_UC_ADMIN, 'main' => e_UC_MAINADMIN, 'new' => e_UC_NEWUSER, 'mods' => e_UC_MODS, 'bots' => e_UC_BOTS, 'readonly' => e_UC_READONLY); $this->readTree(TRUE); // Initialise the classes on entry }
function faqCategories() { $sql = e107::getDb(); $sublinks = array(); $sql->db_Select("faqs_info", "*", "faq_info_id != '' ORDER BY faq_info_order"); while ($row = $sql->db_Fetch()) { $sublinks[] = array('link_name' => $row['faq_info_title'], 'link_url' => '{e_PLUGIN}faqs/faqs.php?cat.' . $row['faq_info_id'], 'link_description' => $row['faq_info_about'], 'link_button' => '', 'link_category' => '', 'link_order' => '', 'link_parent' => '', 'link_open' => '', 'link_class' => intval($row['faq_info_class'])); } return $sublinks; }
function getRecord($id) { $sql = e107::getDb(); $this->row = ''; $qry = "SELECT p.*, u.user_id, u.user_name FROM #page AS p\n\t\tLEFT JOIN #user AS u ON p.page_author = u.user_id\n\t\tWHERE p.page_id='{$id}' AND p.page_class IN (" . USERCLASS_LIST . ") "; if ($sql->gen($qry)) { $this->row = $sql->fetch(); } return $this->row; }
function status() { $sql = e107::getDb(); $chatbox_posts = $sql->count('chatbox'); $var[0]['icon'] = "<img src='" . e_PLUGIN_ABS . "chatbox_menu/images/chatbox_16.png' style='width: 16px; height: 16px; vertical-align: bottom' alt='' /> "; $var[0]['title'] = LAN_PLUGIN_CHATBOX_MENU_POSTS; $var[0]['url'] = e_PLUGIN . "chatbox_menu/admin_chatbox.php"; $var[0]['total'] = $chatbox_posts; return $var; }
function myfunction() { $sql = e107::getDb(); $sublinks = array(); $sql->db_Select("page", "*", "page_theme = '' ORDER BY page_title"); while ($row = $sql->db_Fetch()) { $sublinks[] = array('link_name' => $row['page_title'], 'link_url' => 'page.php?' . $row['page_id'], 'link_description' => '', 'link_button' => '', 'link_category' => '', 'link_order' => '', 'link_parent' => '', 'link_open' => '', 'link_class' => intval($row['page_class'])); } return $sublinks; }
function latest() { $sql = e107::getDb(); $reported_posts = $sql->count('generic', '(*)', "WHERE gen_type='reported_post' OR gen_type='Reported Forum Post'"); $var[0]['icon'] = E_16_FORUM; $var[0]['title'] = ADLAN_LAT_6; $var[0]['url'] = e_PLUGIN . "forum/forum_admin.php?sr"; $var[0]['total'] = $reported_posts; return $var; }
function latest() { $db = e107::getDb(); $submitted_links = $db->count("links_page", "(*)", "WHERE link_active = 0 "); $var[0]['icon'] = "<img src='" . e_PLUGIN_ABS . "links_page/images/linkspage_16.png' style='width: 16px; height: 16px; vertical-align: bottom' alt='' /> "; $var[0]['title'] = ADLAN_LAT_5; $var[0]['url'] = e_PLUGIN . "links_page/admin_linkspage.php"; $var[0]['total'] = $submitted_links ? $submitted_links : 0; return $var; }
function getRecord($id) { $sql = e107::getDb(); $this->row = ''; $qry = "SELECT d.*\n\t\tFROM #download as d\n\t\tWHERE d.download_id='{$id}' AND d.download_class REGEXP '" . e_CLASS_REGEXP . "' "; if ($sql->gen($qry)) { $this->row = $sql->fetch(); } return $this->row; }