function search_gallery($items, $conn)
{
global $set, $db, $apx, $user;
require_once BASEDIR . getmodulepath('gallery') . 'functions.php';
//Suchstring generieren
$tagmatches = gallery_match_tags($items);
foreach ($items as $item) {
$tagmatch = array_shift($tagmatches);
$search1[] = "caption LIKE '" . addslashes_like($item) . "'";
$search2[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR description LIKE '%" . addslashes_like($item) . "%' ) ";
}
$searchstring1 = implode($conn, $search1);
$searchstring2 = implode($conn, $search2);
//Bilder durchsuchen
$data = $db->fetch("SELECT galid FROM " . PRE . "_gallery_pics WHERE ( active='1' AND ( " . $searchstring1 . " ) ) GROUP BY galid");
$galids = get_ids($data, 'galid');
if (count($galids)) {
$picres = " id IN (" . @implode(',', $galids) . ") OR ";
}
//Ergebnisse
$data = $db->fetch("SELECT id,title FROM " . PRE . "_gallery WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $picres . " ( " . $searchstring2 . " ) ) ) ORDER BY title ASC");
if (count($data)) {
foreach ($data as $res) {
++$i;
$result[$i]['TITLE'] = strip_tags($res['title']);
$result[$i]['LINK'] = mklink('gallery.php?id=' . $res['id'], 'gallery,list' . $res['id'] . ',1' . urlformat($res['title']) . '.html');
}
}
return $result;
}
function forum_threads_updated($count = 5, $inforumid = 0, $notforumid = 0, $template = 'updated')
{
require_once BASEDIR . getmodulepath('forum') . 'functions.php';
global $set, $apx, $db;
$count = (int) $count;
//Erlaubte Foren
if (is_int($forumid)) {
$inforum = array($inforumid);
} else {
$inforum = intlist($inforumid);
}
if (is_int($notforumid)) {
$notforum = array($notforumid);
} else {
$notforum = intlist($notforumid);
}
$forumids = forum_allowed_forums($inforum, $notforum);
//Daten auslesen
$fields = implode(',', array('threadid', 'prefix', 'title', 'opener_userid', 'opener', 'opentime', 'lastposter_userid', 'lastposter', 'lastposttime', 'posts', 'views'));
if (count($forumids)) {
$data = $db->fetch("SELECT " . $fields . " FROM " . PRE . "_forum_threads WHERE ( del=0 AND moved=0 AND forumid IN (" . implode(',', $forumids) . ") ) ORDER BY lastposttime DESC " . iif($count, "LIMIT " . $count));
} else {
$data = array();
}
forum_threads_print($data, $template, 'lastposttime');
}
function connect()
{
global $set, $db, $apx;
//PHP5 benötigt
if (version_compare(phpversion(), '5', '<')) {
message($apx->lang->get('MSG_PHP5ONLY'));
return;
}
require BASEDIR . getmodulepath('twitter') . 'epitwitter/class.epicurl.php';
require BASEDIR . getmodulepath('twitter') . 'epitwitter/class.epioauth.php';
require BASEDIR . getmodulepath('twitter') . 'epitwitter/class.epitwitter.php';
$consumer_key = 'nJFE6htU7i5Bf637pvdLBg';
$consumer_secret = '7P4dgrc5OT6Ic0ePE6xz9u69weqNwpBQxkigRJhHk';
if ($_GET['oauth_token'] && $_GET['oauth_verifier']) {
$twitterObj = new EpiTwitter($consumer_key, $consumer_secret);
$twitterObj->setToken($_GET['oauth_token']);
$token = $twitterObj->getAccessToken(array('oauth_verifier' => $_GET['oauth_verifier']));
$db->query("UPDATE " . PRE . "_config SET value='" . addslashes($token->oauth_token) . "' WHERE module='twitter' AND varname='oauth_token' LIMIT 1");
$db->query("UPDATE " . PRE . "_config SET value='" . addslashes($token->oauth_token_secret) . "' WHERE module='twitter' AND varname='oauth_secret' LIMIT 1");
$twitterObj->setToken($token->oauth_token, $token->oauth_token_secret);
$twitterInfo = $twitterObj->get_accountVerify_credentials();
message($apx->lang->get('MSG_DONE', array('ACCOUNT' => $twitterInfo->screen_name)), 'action.php?action=main.mconfig&module=twitter');
} else {
$twitterObj = new EpiTwitter($consumer_key, $consumer_secret);
$redirect = $twitterObj->getAuthorizeUrl(null, array('oauth_callback' => HTTP_HOST . HTTPDIR . 'admin/action.php?action=twitter.connect'));
header('HTTP/1.1 301 Moved Permanently');
header('Location: ' . $redirect);
}
}
function execute_action()
{
if (!file_exists(BASEDIR . getmodulepath($this->module()) . 'admin.php')) {
message($this->lang->get('CORE_MISSADMIN'));
} elseif (!isset($this->actions[$this->module()][$this->action()])) {
message($this->lang->get('CORE_NOTREG'));
} elseif (!$this->user->has_right($_REQUEST['action'])) {
if ($this->user->info['userid']) {
message($this->lang->get('CORE_NORIGHT'));
} else {
header("HTTP/1.1 301 Moved Permanently");
header('Location: action.php?action=user.login');
exit;
}
} else {
$this->lang->dropaction();
//Action-Sprachpaket des Moduls laden
require_once BASEDIR . getmodulepath($this->module()) . 'admin.php';
$adminclass = new action();
$action = $this->action();
if (method_exists($adminclass, $action)) {
$adminclass->{$action}();
} else {
message($this->lang->get('CORE_METHODFAIL'));
}
}
}
function misc_products_comments()
{
global $set, $db, $apx, $user;
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
$apx->tmpl->loaddesign('blank');
require_once BASEDIR . getmodulepath('calendar') . 'functions.php';
products_showcomments($_REQUEST['id']);
}
function action()
{
global $apx;
//if ( $_REQUEST['module'] && !$apx->is_module($_REQUEST['module']) ) die('module does not exist!');
$this->module = $_REQUEST['module'];
$this->mid = (int) $_REQUEST['mid'];
$apx->tmpl->assign('MODULE', $this->module);
$apx->tmpl->assign('MID', $this->mid);
//Settings
require_once BASEDIR . getmodulepath('comments') . 'class.comments.php';
$this->coms = @new comments($this->module);
}
function content_showcomments($id)
{
global $set, $db, $apx, $user;
$res = $db->first("SELECT allowcoms FROM " . PRE . "_content WHERE ( id='" . $id . "' AND active='1' " . section_filter() . " ) LIMIT 1");
if (!$apx->is_module('comments') || !$set['content']['coms'] || !$res['allowcoms']) {
return;
}
require_once BASEDIR . getmodulepath('comments') . 'class.comments.php';
$coms = new comments('content', $id);
$coms->assign_comments();
$apx->tmpl->parse('comments', 'comments');
require 'lib/_end.php';
}
function comments_usercount($userid = 0, $template = 'commentcount')
{
global $apx, $db, $set;
$userid = (int) $userid;
if (!$userid) {
return;
}
include BASEDIR . getmodulepath('comments') . 'functions.php';
$tmpl = new tengine();
$apx->lang->drop('commentcount', 'comments');
$tmpl->assign('COUNT', comments_count($userid));
$tmpl->assign('USERID', $userid);
$tmpl->parse('functions/' . $template, 'comments');
}
function search_poll($items, $conn)
{
global $set, $db, $apx, $user;
require_once BASEDIR . getmodulepath('poll') . 'functions.php';
$tagmatches = poll_match_tags($items);
foreach ($items as $item) {
$tagmatch = array_shift($tagmatches);
$query = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " question LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a1 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a2 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a3 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a4 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a5 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a6 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a7 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a8 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a9 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a10 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a11 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a12 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a13 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a14 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a15 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a16 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a17 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a18 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a19 LIKE '%" . addslashes_like($item) . "%'";
$query .= " OR a20 LIKE '%" . addslashes_like($item) . "%' )";
$search[] = $query;
}
$searchstring = implode($conn, $search);
//Aktuelle Umfrage
require_once BASEDIR . getmodulepath('poll') . 'functions.php';
$recent = poll_recent();
//Ergebnisse
$data = $db->fetch("SELECT id,question FROM " . PRE . "_poll WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY starttime DESC");
if (count($data)) {
foreach ($data as $res) {
++$i;
if ($res['id'] == $recent) {
$link = mklink('poll.php?recent=1', 'poll,recent.html');
} else {
$link = mklink('poll.php?id=' . $res['id'], 'poll,' . $res['id'] . '.html');
}
$result[$i]['TITLE'] = strip_tags($res['question']);
$result[$i]['LINK'] = $link;
}
}
return $result;
}
function forum_allowed_forums($inforumid = array(), $notforumid = array())
{
static $readable;
require_once BASEDIR . getmodulepath('forum') . 'basics.php';
//Erlaubte Foren auslesen
if (!isset($readable)) {
$readable_info = forum_get_readable();
$readable = get_ids($readable_info, 'forumid');
}
$ids = $readable;
//Gewünschte Foren ermitteln
if (is_array($inforumid) && count($inforumid)) {
$ids = array_intersect($ids, $inforumid);
}
if (is_array($notforumid) && count($notforumid)) {
$ids = array_diff($ids, $notforumid);
}
return $ids;
}
function search_glossar($items, $conn)
{
global $set, $db, $apx, $user;
require_once BASEDIR . getmodulepath('glossar') . 'functions.php';
//Suchstring generieren
$tagmatches = glossar_match_tags($items);
foreach ($items as $item) {
$tagmatch = array_shift($tagmatches);
$search[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
}
$searchstring = implode($conn, $search);
//Ergebnisse
$data = $db->fetch("SELECT id,title FROM " . PRE . "_glossar WHERE ( searchable='1' AND starttime!='0' AND ( " . $searchstring . " ) ) ORDER BY title ASC");
if (count($data)) {
foreach ($data as $res) {
++$i;
$result[$i]['TITLE'] = strip_tags($res['title']);
$result[$i]['LINK'] = mklink('glossar.php?id=' . $res['id'], 'glossar,id' . $res['id'] . urlformat($res['title']) . '.html');
}
}
return $result;
}
function search_videos($items, $conn)
{
global $set, $db, $apx, $user;
require_once BASEDIR . getmodulepath('videos') . 'functions.php';
//Suchstring generieren
$tagmatches = videos_match_tags($items);
foreach ($items as $item) {
$tagmatch = array_shift($tagmatches);
$search[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
}
$searchstring = implode($conn, $search);
//Videos durchsuchen
$data = $db->fetch("SELECT id,title FROM " . PRE . "_videos WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY addtime DESC");
if (count($data)) {
foreach ($data as $res) {
++$i;
$result[$i]['TITLE'] = $res['title'];
$result[$i]['LINK'] = mklink('videos.php?id=' . $res['id'], 'videos,id' . $res['id'] . urlformat($res['title']) . '.html');
}
}
return $result;
}
function search_calendar($items, $conn)
{
global $set, $db, $apx, $user;
require_once BASEDIR . getmodulepath('calendar') . 'functions.php';
//Suchstring generieren
$tagmatches = calendar_match_tags($items);
foreach ($items as $item) {
$tagmatch = array_shift($tagmatches);
$search[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
}
$searchstring = implode($conn, $search);
//Ergebnisse
$data = $db->fetch("SELECT id,title FROM " . PRE . "_calendar_events WHERE ( active!=0 AND private=0 " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY startday ASC, starttime ASC, title ASC");
if (count($data)) {
foreach ($data as $res) {
++$i;
$link = mklink('events.php?id=' . $res['id'], 'events,id' . $res['id'] . urlformat($res['title']) . '.html');
$result[$i]['TITLE'] = strip_tags($res['title']);
$result[$i]['LINK'] = $link;
}
}
return $result;
}
function search_articles($items, $conn)
{
global $set, $db, $apx, $user;
require_once BASEDIR . getmodulepath('articles') . 'functions.php';
//Suchstrings generieren
$tagmatches = articles_match_tags($items);
foreach ($items as $item) {
$tagmatch = array_shift($tagmatches);
$search1[] = "( title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
$search2[] = "( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR subtitle LIKE '%" . addslashes_like($item) . "%' OR teaser LIKE '%" . addslashes_like($item) . "%' ) ";
}
$searchstring1 = "( " . implode($conn, $search1) . " )";
$searchstring2 = "( " . implode($conn, $search2) . " )";
//Seiten durchsuchen
$data = $db->fetch("SELECT artid FROM " . PRE . "_articles_pages WHERE ( " . $searchstring1 . " ) GROUP BY artid");
$artids = get_ids($data, 'artid');
if (count($artids)) {
$pageres = "id IN (" . @implode(',', $artids) . ") OR";
}
//Artikel durchsuchen
$data = $db->fetch("SELECT id,type,title,subtitle FROM " . PRE . "_articles WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $pageres . " " . $searchstring2 . " ) ) ORDER BY starttime DESC");
if (count($data)) {
foreach ($data as $res) {
++$i;
//Wohin soll verlinkt werden?
if ($res['type'] == 'normal') {
$link2file = 'articles';
} else {
$link2file = $res['type'] . 's';
}
$link = mklink($link2file . '.php?id=' . $res['id'], $link2file . ',id' . $res['id'] . ',0' . urlformat($res['title']) . '.html');
$result[$i]['TITLE'] = strip_tags($res['title']) . iif($res['subtitle'], ' - ' . strip_tags($res['subtitle']));
$result[$i]['LINK'] = $link;
}
}
return $result;
}
| apexx CMS & Portalsystem |
| ============================ |
| (c) Copyright 2005-2009, Christian Scheb |
| http://www.stylemotion.de |
| |
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
define('APXRUN', true);
////////////////////////////////////////////////////////////////////////////////////////////////////////
require 'lib/_start.php';
//////////////////////////////////////////////////////////// SYSTEMSTART ///
////////////////////////////////////////////////////////////////////////////////////////////////////////
require_once BASEDIR . getmodulepath('calendar') . 'functions.php';
$apx->module('calendar');
$apx->lang->drop('send');
headline($apx->lang->get('HEADLINE'), mklink('sendevent.php', 'sendevent.html'));
titlebar($apx->lang->get('HEADLINE'));
////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($_POST['send']) {
list($spam) = $db->first("SELECT addtime FROM " . PRE . "_calendar_events WHERE send_ip='" . get_remoteaddr() . "' ORDER BY addtime DESC");
//Captcha prüfen
if ($set['calendar']['captcha'] && !$user->info['userid']) {
require BASEDIR . 'lib/class.captcha.php';
$captcha = new captcha();
$captchafailed = $captcha->check();
}
if ($captchafailed) {
message($apx->lang->get('MSG_WRONGCODE'), 'javascript:history.back()');
| |
| apexx CMS & Portalsystem |
| ============================ |
| (c) Copyright 2005-2009, Christian Scheb |
| http://www.stylemotion.de |
| |
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
require_once BASEDIR . getmodulepath('links') . 'functions.php';
//Kommentar-Popup
function misc_links_comments()
{
global $set, $db, $apx, $user;
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
$apx->tmpl->loaddesign('blank');
links_showcomments($_REQUEST['id']);
}
//Link aufrufen
function misc_gotolink()
{
global $set, $db, $apx, $user;
| (c) Copyright 2005-2009, Christian Scheb |
| http://www.stylemotion.de |
| |
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
define('APXRUN', true);
define('NOSTATS', true);
////////////////////////////////////////////////////////////////////////////////////////////////////////
require 'lib/_start.php';
//////////////////////////////////////////////////////////// SYSTEMSTART ///
////////////////////////////////////////////////////////////////////////////////////////////////////////
//Funktionen laden
foreach ($apx->modules as $module => $info) {
if (!file_exists(BASEDIR . getmodulepath($module) . 'misc.php')) {
continue;
}
include_once BASEDIR . getmodulepath($module) . 'misc.php';
}
$call = 'misc_' . $_REQUEST['action'];
if (!function_exists($call)) {
die('action does not exist!');
}
//Aktion ausführen
$call();
////////////////////////////////////////////////////////////////////////////////////////////////////////
require 'lib/_end.php';
/////////////////////////////////////////////////////////// SCRIPT BEENDEN ///
////////////////////////////////////////////////////////////////////////////////////////////////////////
| (c) Copyright 2005-2009, Christian Scheb |
| http://www.stylemotion.de |
| |
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
# PRODUCTS CLASS
# ==============
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Funktionen laden
include BASEDIR . getmodulepath('products') . 'admin_extend.php';
class action extends products_functions
{
//Produkttypen
var $types = array('game', 'software', 'hardware', 'music', 'movie', 'book');
var $genretypes = array('game', 'music', 'movie', 'book');
var $mediatypes = array('game', 'software', 'music', 'movie', 'book');
var $alltypes = array('normal', 'game', 'software', 'hardware', 'music', 'movie', 'book');
//***************************** Spiele zeigen *****************************
function show()
{
global $set, $db, $apx, $html;
//Suche durchführen
if ($_REQUEST['item'] && ($_REQUEST['title'] || $_REQUEST['text'])) {
$where = '';
//Suche wird ausgeführt...
} else {
$coms->mid = $res['id'];
}
$link = mklink('videos.php?id=' . $res['id'], 'videos,id' . $res['id'] . urlformat($res['title']) . '.html');
$tabledata[$i]['COMMENT_COUNT'] = $coms->count();
$tabledata[$i]['COMMENT_LINK'] = $coms->link($link);
$tabledata[$i]['DISPLAY_COMMENTS'] = 1;
if (in_template(array('VIDEO.COMMENT_LAST_USERID', 'VIDEO.COMMENT_LAST_NAME', 'VIDEO.COMMENT_LAST_TIME'), $parse)) {
$tabledata[$i]['COMMENT_LAST_USERID'] = $coms->last_userid();
$tabledata[$i]['COMMENT_LAST_NAME'] = $coms->last_name();
$tabledata[$i]['COMMENT_LAST_TIME'] = $coms->last_time();
}
}
//Bewertungen
if ($apx->is_module('ratings') && $set['videos']['ratings'] && $res['allowrating']) {
require_once BASEDIR . getmodulepath('ratings') . 'class.ratings.php';
if (!isset($rate)) {
$rate = new ratings('videos', $res['id']);
} else {
$rate->mid = $res['id'];
}
$tabledata[$i]['RATING'] = $rate->display();
$tabledata[$i]['RATING_VOTES'] = $rate->count();
$tabledata[$i]['DISPLAY_RATING'] = 1;
}
}
}
//Sortby
ordervars($orderdef, mklink('videos.php?catid=' . $_REQUEST['catid'], 'videos,' . $_REQUEST['catid'] . ',1.html'));
$apx->tmpl->assign('VIDEO', $tabledata);
$apx->tmpl->parse('index');
function glossar_showcomments($id)
{
global $set, $db, $apx, $user;
$id = (int) $id;
$res = $db->first("SELECT id,allowcoms FROM " . PRE . "_glossar WHERE ( id='" . $id . "' AND starttime!='0' ) LIMIT 1");
if (!$apx->is_module('comments') || !$set['glossar']['coms'] || !$res['allowcoms']) {
return;
}
require_once BASEDIR . getmodulepath('comments') . 'class.comments.php';
$coms = new comments('glossar', $id);
$coms->assign_comments();
$apx->tmpl->parse('comments', 'comments');
require 'lib/_end.php';
}
| (c) Copyright 2005-2009, Christian Scheb |
| http://www.stylemotion.de |
| |
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
# USER CLASS
# ==========
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//CityMatch laden
include BASEDIR . getmodulepath('user') . 'citymatch.php';
class action
{
//***************************** Login *****************************
function login()
{
global $set, $apx, $db;
//Weiterleiten auf Startseite, wenn angemeldet
if ($apx->user->info['userid']) {
header('Location: index.php');
}
if ($_POST['send']) {
if ($_POST['login_user'] && $_POST['login_pwd']) {
$res = $db->first("SELECT userid,password,salt,active,gtype FROM " . PRE . "_user AS a LEFT JOIN " . PRE . "_user_groups AS b USING(groupid) WHERE LOWER(username_login)='" . addslashes(strtolower($_POST['login_user'])) . "' LIMIT 1");
list($count) = $db->first("SELECT count(time) FROM " . PRE . "_loginfailed WHERE ( userid='" . $res['userid'] . "' AND time>='" . (time() - 15 * 60) . "' )");
if (!checkToken()) {
function get_modules()
{
global $db;
$data = $db->fetch("SELECT * FROM " . PRE . "_modules WHERE active='1'");
if (count($data)) {
foreach ($data as $res) {
$module = $action = $modset = array();
list($modulename) = $res;
if (!is_dir(BASEDIR . getmodulepath($modulename))) {
continue;
}
//Modul-INIT
require BASEDIR . getmodulepath($modulename) . 'init.php';
$this->register_module($modulename, $module);
$this->register_actions($modulename, $action);
$this->register_functions($modulename, $func);
unset($module, $action, $func);
}
}
}
function calendar_print($data, $template)
{
global $set, $db, $apx, $user;
$tmpl = new tengine();
$parse = $tmpl->used_vars($template, 'calendar');
//Kategorie-Info
$catids = get_ids($data, 'catid');
$catdata = array();
if (count($catids)) {
$catdata = $db->fetch_index("SELECT * FROM " . PRE . "_calendar_cat WHERE id IN (" . implode(',', $catids) . ")", 'id');
}
//Termine auflisten
if (count($data)) {
foreach ($data as $res) {
++$i;
$event = array();
//Kategorie-Info
$catinfo = $catdata[$res['catid']];
//Link zum Termin
$link = mklink('events.php?id=' . $res['id'], 'events,id' . $res['id'] . urlformat($res['title']) . '.html');
//Aufmacher
$picture = $picture_popup = '';
if (in_template(array('EVENT.PICTURE', 'EVENT.PICTURE_POPUP', 'EVENT.PICTURE_POPUPPATH'), $parse)) {
list($picture, $picture_popup, $picture_popuppath) = calendar_pic($res['picture']);
}
//Start berechnen
$startday = $starttime = $endday = $endtime = 0;
if (in_template(array('EVENT.STARTDAY', 'EVENT.STARTTIME'), $parse)) {
$startday = calendar_stamp2time($res['startday']);
if ($res['starttime'] != -1) {
$time_comp = calendar_explode_stamp($res['startday']);
$tmpstamp = sprintf('%04d', $res['starttime']);
$time_comp['hour'] = substr($tmpstamp, 0, 2);
$time_comp['minute'] = substr($tmpstamp, 2, 2);
$starttime = mktime($time_comp['hour'], $time_comp['minute'], 0, $time_comp['month'], $time_comp['day'], $time_comp['year']) + TIMEDIFF;
}
}
//Ende berechnen (falls nötig)
if (in_template(array('EVENT.ENDDAY', 'EVENT.ENDTIME'), $parse)) {
if ($res['endday'] != $res['startday'] || $res['endtime'] != -1) {
$endday = calendar_stamp2time($res['endday']);
if ($res['endtime'] != -1) {
$time_comp = calendar_explode_stamp($res['endday']);
$tmpstamp = sprintf('%04d', $res['endtime']);
$time_comp['hour'] = substr($tmpstamp, 0, 2);
$time_comp['minute'] = substr($tmpstamp, 2, 2);
$endtime = mktime($time_comp['hour'], $time_comp['minute'], 0, $time_comp['month'], $time_comp['day'], $time_comp['year']) + TIMEDIFF;
}
}
}
//Username + eMail
if ($res['userid']) {
$username = $res['username'];
$email = iif(!$res['pub_hidemail'], $res['email']);
} else {
$username = $res['send_username'];
$email = $res['send_email'];
}
//Text
$eventtext = '';
if (in_array('EVENT.TEXT', $parse)) {
$eventtext = mediamanager_inline($res['text']);
if ($apx->is_module('glossar')) {
$eventtext = glossar_highlight($eventtext);
}
}
//Datehead
if ($laststamp != $res['startday']) {
$event['DATEHEAD'] = $startday;
}
//Tags
if (in_array('EVENT.TAG', $parse) || in_array('EVENT.TAG_IDS', $parse) || in_array('EVENT.KEYWORDS', $parse)) {
list($tagdata, $tagids, $keywords) = calendar_tags($res['id']);
}
$event['ID'] = $res['id'];
$event['TITLE'] = $res['title'];
$event['TEXT'] = $eventtext;
$event['LINK'] = $link;
$event['LOCATION'] = compatible_hsc($res['location']);
$event['LOCATION_LINK'] = compatible_hsc($res['location_link']);
$event['PRIORITY'] = $res['priority'];
$event['RESTRICTED'] = $res['restricted'];
$event['PRIVATE'] = $res['private'];
$event['HITS'] = $res['hits'];
$event['RELATED'] = calendar_links($res['links']);
$event['PICTURE'] = $picture;
$event['PICTURE_POPUP'] = $picture_popup;
$event['PICTURE_POPUPPATH'] = $picture_popuppath;
$event['STARTDAY'] = $startday;
$event['STARTTIME'] = $starttime;
$event['ENDDAY'] = $endday;
$event['ENDTIME'] = $endtime;
$event['USERID'] = $res['userid'];
$event['USERNAME'] = replace($username);
$event['EMAIL'] = replace($email);
$event['EMAIL_ENCRYPTED'] = replace(cryptMail($email));
$event['CATID'] = $res['catid'];
$event['CATTITLE'] = $catinfo['title'];
$event['CATICON'] = $catinfo['icon'];
//Tags
$event['TAG'] = $tagdata;
$event['TAG_IDS'] = $tagids;
$event['KEYWORDS'] = $keywords;
//Galerie
if ($apx->is_module('gallery') && $res['galid'] && !$res['private'] && in_template(array('EVENT.GALLERY_ID', 'EVENT.GALLERY_TITLE', 'EVENT.GALLERY_LINK'), $parse)) {
$galinfo = gallery_info($res['galid']);
$event['GALLERY_ID'] = $galinfo['id'];
$event['GALLERY_TITLE'] = $galinfo['title'];
$event['GALLERY_LINK'] = mklink('gallery.php?id=' . $galinfo['id'], 'gallery,list' . $galinfo['id'] . ',1' . urlformat($galinfo['title']) . '.html');
}
//Kommentare
if ($apx->is_module('comments') && $set['calendar']['coms'] && $res['allowcoms']) {
require_once BASEDIR . getmodulepath('comments') . 'class.comments.php';
if (!isset($coms)) {
$coms = new comments('calendar', $res['id']);
} else {
$coms->mid = $res['id'];
}
$link = mklink('events.php?id=' . $res['id'], 'events,id' . $res['id'] . urlformat($res['title']) . '.html');
$event['COMMENT_COUNT'] = $coms->count();
$event['COMMENT_LINK'] = $coms->link($link);
$event['DISPLAY_COMMENTS'] = 1;
if (in_template(array('EVENT.COMMENT_LAST_USERID', 'EVENT.COMMENT_LAST_NAME', 'EVENT.COMMENT_LAST_TIME'), $parse)) {
$event['COMMENT_LAST_USERID'] = $coms->last_userid();
$event['COMMENT_LAST_NAME'] = $coms->last_name();
$event['COMMENT_LAST_TIME'] = $coms->last_time();
}
}
$eventdata[$i] = $event;
$laststamp = $res['startday'];
}
}
$tmpl->assign('EVENT', $eventdata);
$tmpl->parse($template, 'calendar');
}
function videos_showcomments($id)
{
global $db, $tmpl, $user, $set, $apx;
$res = $db->first("SELECT id,allowcoms FROM " . PRE . "_videos WHERE id='" . intval($id) . "' LIMIT 1");
if (!$set['videos']['coms'] || !$res['allowcoms'] || !$apx->is_module('comments')) {
return;
}
require_once BASEDIR . getmodulepath('comments') . 'class.comments.php';
$coms = new comments('videos', $res['id']);
$coms->assign_comments();
$apx->tmpl->parse('comments', 'comments');
require 'lib/_end.php';
}
function products_collection_user($prodid = 0, $count = 999999, $template = 'collectionuser')
{
global $set, $apx, $db, $user;
require_once BASEDIR . getmodulepath('user') . 'tfunctions.php';
$prodid = (int) $prodid;
if (!$prodid) {
return;
}
$count = (int) $count;
if ($count < 1) {
$count = 1;
}
$apx->lang->drop('func_newuser', 'user');
$data = $db->fetch("SELECT a.userid,a.username,a.email,a.groupid,a.reg_time,a.realname,a.gender,a.city,a.plz,a.country,a.city,a.lastactive,a.avatar,a.avatar_title,a.birthday,a.pub_hidemail,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10 FROM " . PRE . "_products_coll AS c LEFT JOIN " . PRE . "_user AS a USING(userid) WHERE c.prodid='" . $prodid . "' AND a.reg_key='' ORDER BY a.username ASC LIMIT " . $count);
user_print($data, 'functions/' . $template, 'USER', false, 'products');
}
function downloads_print($data, $template)
{
global $set, $db, $apx, $user;
$tmpl = new tengine();
$apx->lang->drop('global', 'downloads');
//Verwendete Variablen auslesen
$parse = $apx->tmpl->used_vars($template, 'downloads');
//Kategorien auslesen
if (in_array('DOWNLOAD.CATTITLE', $parse) || in_array('DOWNLOAD.CATTEXT', $parse) || in_array('DOWNLOAD.CATICON', $parse) || in_array('DOWNLOAD.CATLINK', $parse)) {
$catids = get_ids($data, 'catid');
if (count($catids)) {
$catdata = $db->fetch("SELECT id,title,text,icon FROM " . PRE . "_downloads_cat WHERE id IN (" . implode(',', $catids) . ")");
if (count($catdata)) {
foreach ($catdata as $catres) {
$catinfo[$catres['id']] = $catres;
}
}
}
}
//User auslesen
$userinfo = array();
if (in_template(array('DOWNLOAD.UPLOADER', 'DOWNLOAD.UPLOADER_EMAIL', 'DOWNLOAD.UPLOADER_EMAIL_ENCRYPTED'), $parse)) {
$userids = get_ids($data, 'userid');
if ($userids) {
$userinfo = $db->fetch_index("\n\t\t\t\tSELECT userid, username, email, pub_hidemail\n\t\t\t\tFROM " . PRE . "_user\n\t\t\t\tWHERE userid IN (" . implode(',', $userids) . ")\n\t\t\t", 'userid');
}
}
if (count($data)) {
foreach ($data as $res) {
++$i;
//Link
$link = mklink('downloads.php?id=' . $res['id'], 'downloads,id' . $res['id'] . urlformat($res['title']) . '.html');
//Teaserbild
if (in_array('DOWNLOAD.TEASERPIC', $parse) || in_array('DOWNLOAD.TEASERPIC_POPUP', $parse) || in_array('DOWNLOAD.TEASERPIC_POPUPPATH', $parse)) {
list($picture, $picture_popup, $picture_popuppath) = downloads_teaserpic($res['teaserpic']);
}
//Dateigröße auslesen
if (in_array('DOWNLOAD.SIZE', $parse)) {
$thefsize = downloads_filesize($res);
}
//Download-Link
if (!$set['downloads']['regonly'] && !$res['regonly'] || $user->info['userid']) {
$sechash = md5($_SERVER['HTTP_HOST'] . $res['file'] . date('Y/m/d', time() - TIMEDIFF));
$dllink = 'misc.php?action=downloadfile&id=' . $res['id'] . '&sechash=' . $sechash . iif($apx->section_id(), '&sec=' . $apx->section_id());
} else {
$dllink = mklink('user.php', 'user.html');
}
//Bilder
if (in_array('DOWNLOAD.PICTURE', $parse)) {
$picdata = downloads_pictures($res['pictures']);
}
//Neu?
if ($res['addtime'] + $set['downloads']['new'] * 24 * 3600 >= time()) {
$new = 1;
} else {
$new = 0;
}
//Username + eMail
if ($res['userid']) {
$userdata = $userinfo[$res['userid']];
$uploader = $userdata['username'];
$uploader_email = iif(!$userdata['pub_hidemail'], $userdata['email']);
} else {
$uploader = $res['send_username'];
$uploader_email = $res['send_email'];
}
//Datehead
if ($laststamp != date('Y/m/d', $res['starttime'] - TIMEDIFF)) {
$tabledata[$i]['DATEHEAD'] = $res['starttime'];
}
//Text
$text = '';
if (in_array('DOWNLOAD.TEXT', $parse)) {
$text = mediamanager_inline($res['text']);
if ($apx->is_module('glossar')) {
$text = glossar_highlight($text);
}
}
//Tags
if (in_array('DOWNLOAD.TAG', $parse) || in_array('DOWNLOAD.TAG_IDS', $parse) || in_array('DOWNLOAD.KEYWORDS', $parse)) {
list($tagdata, $tagids, $keywords) = downloads_tags($res['id']);
}
$tabledata[$i]['ID'] = $res['id'];
$tabledata[$i]['SECID'] = $res['secid'];
$tabledata[$i]['TITLE'] = $res['title'];
$tabledata[$i]['TEXT'] = $text;
$tabledata[$i]['LINK'] = $link;
$tabledata[$i]['TEASERPIC'] = $picture;
$tabledata[$i]['TEASERPIC_POPUP'] = $picture_popup;
$tabledata[$i]['TEASERPIC_POPUPPATH'] = $picture_popuppath;
$tabledata[$i]['SIZE'] = downloads_getsize($thefsize);
$tabledata[$i]['FORMAT'] = downloads_getformat($res);
$tabledata[$i]['HITS'] = number_format($res['hits'], 0, '', '.');
$tabledata[$i]['TIME'] = $res['starttime'];
$tabledata[$i]['PICTURE'] = $picdata;
$tabledata[$i]['TOP'] = $res['top'];
$tabledata[$i]['RESTRICTED'] = $res['restricted'];
$tabledata[$i]['NEW'] = $new;
$tabledata[$i]['DOWNLOADLINK'] = $dllink;
//Tags
$tabledata[$i]['TAG'] = $tagdata;
$tabledata[$i]['TAG_IDS'] = $tagids;
$tabledata[$i]['KEYWORDS'] = $keywords;
//Kategorien
$tabledata[$i]['CATID'] = $res['catid'];
$tabledata[$i]['CATTITLE'] = $catinfo[$res['catid']]['title'];
$tabledata[$i]['CATTEXT'] = $catinfo[$res['catid']]['text'];
$tabledata[$i]['CATICON'] = $catinfo[$res['catid']]['icon'];
$tabledata[$i]['CATLINK'] = mklink('downloads.php?catid=' . $res['catid'], 'downloads,' . $res['catid'] . ',1' . urlformat($catinfo[$res['catid']]['title']) . '.html');
//Produkt
$tabledata[$i]['PRODUCT_ID'] = $res['prodid'];
//Uploader
$tabledata[$i]['UPLOADER_ID'] = $res['userid'];
$tabledata[$i]['UPLOADER'] = replace($uploader);
$tabledata[$i]['UPLOADER_EMAIL'] = replace($uploader_email);
$tabledata[$i]['UPLOADER_EMAIL_ENCRYPTED'] = replace(cryptMail($uploader_email));
//Autor
$tabledata[$i]['AUTHOR'] = replace($res['author']);
$tabledata[$i]['AUTHOR_LINK'] = replace($res['author_link']);
//Galerie
if ($apx->is_module('gallery') && $res['galid']) {
$galinfo = gallery_info($res['galid']);
$tabledata[$i]['GALLERY_ID'] = $galinfo['id'];
$tabledata[$i]['GALLERY_TITLE'] = $galinfo['title'];
$tabledata[$i]['GALLERY_LINK'] = mklink('gallery.php?id=' . $galinfo['id'], 'gallery,list' . $galinfo['id'] . ',1' . urlformat($galinfo['title']) . '.html');
}
//Kommentare
if ($apx->is_module('comments') && $set['downloads']['coms'] && $res['allowcoms']) {
require_once BASEDIR . getmodulepath('comments') . 'class.comments.php';
if (!isset($coms)) {
$coms = new comments('downloads', $res['id']);
} else {
$coms->mid = $res['id'];
}
$link = mklink('downloads.php?id=' . $res['id'], 'downloads,id' . $res['id'] . urlformat($res['title']) . ',1.html');
$tabledata[$i]['COMMENT_COUNT'] = $coms->count();
$tabledata[$i]['COMMENT_LINK'] = $coms->link($link);
$tabledata[$i]['DISPLAY_COMMENTS'] = 1;
if (in_template(array('DOWNLOAD.COMMENT_LAST_USERID', 'DOWNLOAD.COMMENT_LAST_NAME', 'DOWNLOAD.COMMENT_LAST_TIME'), $parse)) {
$tabledata[$i]['COMMENT_LAST_USERID'] = $coms->last_userid();
$tabledata[$i]['COMMENT_LAST_NAME'] = $coms->last_name();
$tabledata[$i]['COMMENT_LAST_TIME'] = $coms->last_time();
}
}
//Bewertungen
if ($apx->is_module('ratings') && $set['downloads']['ratings'] && $res['allowrating']) {
require_once BASEDIR . getmodulepath('ratings') . 'class.ratings.php';
if (!isset($rate)) {
$rate = new ratings('downloads', $res['id']);
} else {
$rate->mid = $res['id'];
}
$tabledata[$i]['RATING'] = $rate->display();
$tabledata[$i]['RATING_VOTES'] = $rate->count();
$tabledata[$i]['DISPLAY_RATING'] = 1;
}
$laststamp = date('Y/m/d', $res['starttime'] - TIMEDIFF);
}
}
$tmpl->assign('DOWNLOAD', $tabledata);
$tmpl->parse($template, 'downloads');
}
| (c) Copyright 2005-2009, Christian Scheb |
| http://www.stylemotion.de |
| |
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
# FORUM
# =====
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Funktionen laden
include BASEDIR . getmodulepath('forum') . 'admin_extend.php';
class action extends forum_functions
{
var $cat;
//Startup
function action()
{
require_once BASEDIR . 'lib/class.recursivetree.php';
$this->cat = new RecursiveTree(PRE . '_forums', 'forumid');
require_once BASEDIR . 'lib/class.mediamanager.php';
$this->mm = new mediamanager();
}
//Definiert die Rechte-Felder und deren Standardeinstellung
//Welche Benutzergruppen bekommen standardmäßig welche Rechte?
var $rightfields = array('right_visible' => array('all'), 'right_read' => array('all'), 'right_open' => array('public', 'indiv'), 'right_announce' => array('none'), 'right_post' => array('public', 'indiv'), 'right_editpost' => array('public', 'indiv'), 'right_delpost' => array('public', 'indiv'), 'right_delthread' => array('none'), 'right_addattachment' => array('public', 'indiv'), 'right_readattachment' => array('all'));
///////////////////////////////////////////////////////////////////////////////////// BENUTZER SUCHEN
function cron_twitter_real($lastexec)
{
global $set, $db, $apx;
$twitter = null;
if (version_compare(phpversion(), '5', '<')) {
return;
}
if (!$set['twitter']['oauth_token'] || !$set['twitter']['oauth_secret']) {
return;
}
if (!function_exists('curl_init')) {
return;
}
//CURL benötigt
$apx->lang->drop('twitter', 'twitter');
//News
if ($apx->is_module('news') && $set['twitter']['news']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title, a.subtitle, b.title AS cattitle\n\t\t\tFROM " . PRE . "_news AS a\n\t\t\tLEFT JOIN " . PRE . "_news_cat AS b ON a.catid=b.id\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postNewsTwitter($data, $twitter);
}
}
//Artikel
if ($apx->is_module('articles') && $set['twitter']['articles']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title, a.subtitle, a.type, b.title AS cattitle\n\t\t\tFROM " . PRE . "_articles AS a\n\t\t\tLEFT JOIN " . PRE . "_articles_cat AS b ON a.catid=b.id\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postArticlesTwitter($data, $twitter);
}
}
//Videos
if ($apx->is_module('videos') && $set['twitter']['videos']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title, b.title AS cattitle\n\t\t\tFROM " . PRE . "_videos AS a\n\t\t\tLEFT JOIN " . PRE . "_videos_cat AS b ON a.catid=b.id\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postVideosTwitter($data, $twitter);
}
}
//Downloads
if ($apx->is_module('downloads') && $set['twitter']['downloads']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title, b.title AS cattitle\n\t\t\tFROM " . PRE . "_downloads AS a\n\t\t\tLEFT JOIN " . PRE . "_downloads_cat AS b ON a.catid=b.id\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postDownloadsTwitter($data, $twitter);
}
}
//Galerien
if ($apx->is_module('gallery') && $set['twitter']['gallery']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title\n\t\t\tFROM " . PRE . "_gallery AS a\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postGalleryTwitter($data, $twitter);
}
}
//Links
if ($apx->is_module('links') && $set['twitter']['links']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title, b.title AS cattitle\n\t\t\tFROM " . PRE . "_links AS a\n\t\t\tLEFT JOIN " . PRE . "_links_cat AS b ON a.catid=b.id\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postLinksTwitter($data, $twitter);
}
}
//Glossar
if ($apx->is_module('glossar') && $set['twitter']['glossar']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.title, b.title AS cattitle\n\t\t\tFROM " . PRE . "_glossar AS a\n\t\t\tLEFT JOIN " . PRE . "_glossar_cat AS b ON a.catid=b.id\n\t\t\tWHERE starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postGlossarTwitter($data, $twitter);
}
}
//Termine
if ($apx->is_module('calendar') && $set['twitter']['events']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.title, b.title AS cattitle\n\t\t\tFROM " . PRE . "_calendar_events AS a\n\t\t\tLEFT JOIN " . PRE . "_calendar_cat AS b ON a.catid=b.id\n\t\t\tWHERE a.active>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postEventsTwitter($data, $twitter);
}
}
//Forum
if ($apx->is_module('forum') && $set['twitter']['forum']) {
require_once BASEDIR . getmodulepath('forum') . 'functions.php';
$forumids = forum_allowed_forums();
if (count($forumids)) {
$data = $db->fetch("\n\t\t\t\tSELECT a.threadid, a.title\n\t\t\t\tFROM " . PRE . "_forum_threads AS a\n\t\t\t\tWHERE del=0 AND moved=0 AND forumid IN (" . implode(',', $forumids) . ") AND opentime>'" . $lastexec . "'\n\t\t\t\tORDER BY opentime DESC\n\t\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postForumTwitter($data, $twitter);
}
}
}
//Umfragen
if ($apx->is_module('poll') && $set['twitter']['poll']) {
$data = $db->fetch("\n\t\t\tSELECT a.id, a.secid, a.question AS title\n\t\t\tFROM " . PRE . "_poll AS a\n\t\t\tWHERE " . time() . " BETWEEN starttime AND endtime AND starttime>'" . $lastexec . "'\n\t\t\tORDER BY starttime DESC\n\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postPollTwitter($data, $twitter);
}
}
//Benuter
if ($apx->is_module('user')) {
//Blogs
if ($set['twitter']['user_blog']) {
$data = $db->fetch("\n\t\t\t\tSELECT a.id, a.userid, a.title\n\t\t\t\tFROM " . PRE . "_user_blog AS a\n\t\t\t\tWHERE a.time>'" . $lastexec . "'\n\t\t\t\tORDER BY a.time DESC\n\t\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postUserBlogTwitter($data, $twitter);
}
}
//Galerien
if ($set['twitter']['user_gallery']) {
$data = $db->fetch("\n\t\t\t\tSELECT a.id, a.owner, a.title\n\t\t\t\tFROM " . PRE . "_user_gallery AS a\n\t\t\t\tWHERE a.addtime>'" . $lastexec . "' AND a.password=''\n\t\t\t\tORDER BY a.addtime DESC\n\t\t\t");
if (count($data)) {
if (is_null($twitter)) {
$twitter = twitter_connect();
}
postUserGalleryTwitter($data, $twitter);
}
}
}
}
|---------------------------------------------------------------|
| THIS SOFTWARE IS NOT FREE! MAKE SURE YOU OWN A VALID LICENSE! |
| DO NOT REMOVE ANY COPYRIGHTS WITHOUT PERMISSION! |
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
////////////////////////////////////////////////////////////////////////////////////////////////
$apx->module('forum');
$apx->tmpl->loaddesign('forum');
$apx->lang->drop('global');
$now = time();
require_once 'lib/functions.php';
require_once BASEDIR . getmodulepath('forum') . 'basics.php';
//Forum-Uservars
if (!$user->info['forum_ppp']) {
$user->info['forum_ppp'] = $set['forum']['ppp'];
}
if (!$user->info['forum_tpp']) {
$user->info['forum_tpp'] = $set['forum']['tpp'];
}
//Lastonline aktualisieren, wenn angemeldet
if ($user->info['userid']) {
if ($user->info['forum_lastactive'] + $set['forum']['timeout'] * 60 < $now) {
$db->query("UPDATE " . PRE . "_user SET forum_lastonline=forum_lastactive,forum_lastactive='" . $now . "' WHERE userid='" . $user->info['userid'] . "' LIMIT 1");
$user->info['forum_lastonline'] = $user->info['forum_lastactive'];
$user->info['forum_lastactive'] = $now;
} else {
$db->query("UPDATE " . PRE . "_user SET forum_lastactive='" . $now . "' WHERE userid='" . $user->info['userid'] . "' LIMIT 1");
<?php
//Produkt-Modul wird benötigt
if (!$apx->is_module('products')) {
filenotfound();
return;
}
//Include von Produkt-Modul
require BASEDIR . getmodulepath('products') . 'pub/collection.php';
