//Dateitypen
$filetypes = array();
$typeinfo = array();
$data = $db->fetch("SELECT * FROM " . PRE . "_forum_filetypes ORDER BY ext ASC");
if (count($data)) {
foreach ($data as $res) {
$filetypes[] = $res['ext'];
$typeinfo[$res['ext']] = array($res['size'] * 1024, $res['icon']);
}
}
//Anhänge auslesen
$attachments = '';
$data = $db->fetch("SELECT * FROM " . PRE . "_forum_attachments WHERE ( postid='" . $postinfo['postid'] . "' AND hash='" . addslashes($postinfo['hash']) . "' ) ORDER BY name ASC");
if (count($data)) {
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
foreach ($data as $res) {
$ext = strtolower($mm->getext($res['name']));
$attachments .= '<img src="' . $typeinfo[$ext][1] . '" alt="" style="vertical-align:middle;" /> ' . $res['name'] . ' (' . round($res['size'] / 1024) . ' KB)';
}
}
//Präfixe
$prefixdata = array();
$prefixInfo = forum_prefixes($foruminfo['forumid']);
foreach ($prefixInfo as $prefix) {
$prefixdata[] = array('ID' => $prefix['prefixid'], 'TITLE' => compatible_hsc($prefix['title']), 'SELECTED' => $_POST['prefix'] == $prefix['prefixid']);
}
$apx->tmpl->assign('USERID', $postinfo['userid']);
if ($postinfo['userid']) {
$apx->tmpl->assign('USERNAME', replace($postinfo['username']));
} else {
function del()
{
global $set, $db, $apx;
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if ($_POST['send'] == 1) {
if (!checkToken()) {
printInvalidToken();
} else {
$res = $db->first("SELECT picture FROM " . PRE . "_calendar_events WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
$db->query("DELETE FROM " . PRE . "_calendar_events WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
//Kommentare löschen
if ($apx->is_module('comments')) {
$db->query("DELETE FROM " . PRE . "_comments WHERE ( module='anzeigenmarkt' AND mid='" . $_REQUEST['id'] . "' )");
}
//Bilder löschen
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$picture = $res['picture'];
$poppic = str_replace('-thumb.', '.', $picture);
if ($picture && file_exists(BASEDIR . getpath('uploads') . $picture)) {
$mm->deletefile($picture);
}
if ($poppic && file_exists(BASEDIR . getpath('uploads') . $poppic)) {
$mm->deletefile($poppic);
}
//Tags löschen
$db->query("DELETE FROM " . PRE . "_calendar_tags WHERE id='" . $_REQUEST['id'] . "'");
logit('CALENDAR_DEL', 'ID #' . $_REQUEST['id']);
printJSRedirect(get_index('calendar.show'));
}
} else {
list($title) = $db->first("SELECT title FROM " . PRE . "_calendar_events WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
$apx->tmpl->assign('MESSAGE', $apx->lang->get('MSG_TEXT', array('TITLE' => compatible_hsc($title))));
tmessageOverlay('deltitle', array('ID' => $_REQUEST['id']), '/');
}
}
$mm = new mediamanager();
$mm->createdir('temp');
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tCREATE TABLE `apx_capcha` (\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t `code` int(5) unsigned NOT NULL default '0',\n\t\t\t\t `hash` tinytext NOT NULL,\n\t\t\t\t `time` int(11) unsigned NOT NULL default '0',\n\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t) ENGINE=MyISAM ;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('main', 'textboxwidth', 'int', '', '', '0', '650');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 101:
//zu 1.0.2
//Temp-DIR
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('temp');
case 102:
//Zu 1.0.3
$mysql = "\n\t\t\t\tALTER TABLE `apx_capcha` RENAME `apx_captcha` ;\n\t\t\t\tDELETE FROM `apx_config` WHERE varname='capcha';\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 103:
//Zu 1.0.4
$mysql = "\n\t\t\t\tCREATE TABLE `apx_cron` (\n\t\t\t\t `funcname` varchar(50) NOT NULL default '',\n\t\t\t\t `module` varchar(50) NOT NULL default '',\n\t\t\t\t `period` int(11) unsigned NOT NULL default '0',\n\t\t\t\t `lastexec` int(11) unsigned NOT NULL default '0',\n\t\t\t\t `hash` tinytext NOT NULL,\n\t\t\t\t PRIMARY KEY (`funcname`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_sections` ADD `lang` VARCHAR( 20 ) NOT NULL AFTER `theme`;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('main', 'tellcaptcha', 'switch', '', '1', '0', '1700');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_links` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `secid` tinytext NOT NULL,\n\t\t `catid` int(11) unsigned NOT NULL default '0',\n\t\t `userid` int(11) unsigned NOT NULL default '0',\n\t\t `send_username` tinytext NOT NULL,\n\t\t `send_email` tinytext NOT NULL,\n\t\t `send_ip` tinytext NOT NULL,\n\t\t `title` tinytext NOT NULL,\n\t\t `url` text NOT NULL,\n\t\t `linkpic` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `meta_description` text NOT NULL,\n\t\t `galid` int(11) unsigned NOT NULL default '0',\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `starttime` int(11) unsigned NOT NULL default '0',\n\t\t `endtime` int(11) unsigned NOT NULL default '0',\n\t\t `broken` int(11) unsigned NOT NULL default '0',\n\t\t `top` tinyint(1) unsigned NOT NULL default '0',\n\t\t `searchable` tinyint(1) unsigned NOT NULL default '0',\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL default '1',\n\t\t `allowrating` tinyint(1) unsigned NOT NULL default '1',\n\t\t `restricted` tinyint(1) unsigned NOT NULL,\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `catid` (`catid`),\n\t\t KEY `userid` (`userid`),\n\t\t KEY `starttime` (`starttime`,`endtime`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_links_cat` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `icon` tinytext NOT NULL,\n\t\t `open` tinyint(1) unsigned NOT NULL default '1',\n\t\t `parents` varchar(255) NOT NULL,\n\t\t `children` text NOT NULL,\n\t\t `ord` tinyint(3) NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `parents` (`parents`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_links_tags` (\n\t\t `id` int(11) unsigned NOT NULL,\n\t\t `tagid` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`,`tagid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('links', 'epp', 'int', '', '20', 'VIEW', 1249981968, 1000),\n\t\t('links', 'searchepp', 'string', '', '20', 'VIEW', 1249981881, 2000),\n\t\t('links', 'catonly', 'switch', '', '1', 'VIEW', 1249981968, 3000),\n\t\t('links', 'sortby', 'select', 'a:2:{i:1;s:7:\"{TITLE}\";i:2;s:6:\"{DATE}\";}', '1', 'VIEW', 1249981968, 4000),\n\t\t('links', 'new', 'int', '', '3', 'VIEW', 1249981968, 5000),\n\t\t\n\t\t('links', 'searchable', 'switch', '', '1', 'OPTIONS', 1249981968, 1000),\n\t\t('links', 'coms', 'switch', '', '1', 'OPTIONS', 1249981968, 2000),\n\t\t('links', 'ratings', 'switch', '', '1', 'OPTIONS', 1249981968, 3000),\n\t\t('links', 'captcha', 'switch', '', '1', 'OPTIONS', 1249981968, 4000),\n\t\t('links', 'spamprot', 'int', '', '1', 'OPTIONS', 1249981968, 5000),\n\t\t('links', 'mailonnew', 'string', '', '', 'OPTIONS', 1249981968, 6000),\n\t\t('links', 'mailonbroken', 'string', '', '', 'OPTIONS', 1249981968, 7000),\n\t\t\n\t\t('links', 'linkpic_width', 'int', '', '120', 'IMAGES', 1249981968, 1000),\n\t\t('links', 'linkpic_height', 'int', '', '120', 'IMAGES', 1249981968, 2000),\n\t\t('links', 'linkpic_popup', 'switch', '', '1', 'IMAGES', 1249981968, 3000),\n\t\t('links', 'linkpic_popup_width', 'int', '', '640', 'IMAGES', 1249981968, 4000),\n\t\t('links', 'linkpic_popup_height', 'int', '', '480', 'IMAGES', 1249981968, 5000),\n\t\t('links', 'linkpic_quality', 'switch', '', '1', 'IMAGES', 1249981968, 6000);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Links-DIR
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('links');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_links`;\n\t\tDROP TABLE `apx_links_cat`;\n\t\tDROP TABLE `apx_links_tags`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//Zu 1.0.1
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('links', 'mailonnew', 'string', '', '', 0, 1800);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('links', 'captcha', 'switch', '', '0', 0, 1350);\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
case 101:
//zu 1.0.2
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` ( `module` , `varname` , `type` , `addnl` , `value` , `lastchange` , `ord` ) VALUES ('articles', 'searchable', 'switch', '', '1', '0', '50');\n\t\t\t\tALTER TABLE `apx_articles` ADD `searchable` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `sticky` ;\n\t\t\t\tALTER TABLE `apx_articles` ADD `keywords` TINYTEXT NOT NULL AFTER `teaser` ;\n\t\t\t\tUPDATE `apx_articles` SET searchable='1';\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 102:
//zu 1.1.0
$mysql = "\n\t\t\t\tCREATE TABLE `apx_articles_previews` (\n\t\t\t\t `artid` int(11) unsigned NOT NULL default '0',\n\t\t\t\t `custom1` tinytext NOT NULL,\n\t\t\t\t `custom2` tinytext NOT NULL,\n\t\t\t\t `custom3` tinytext NOT NULL,\n\t\t\t\t `custom4` tinytext NOT NULL,\n\t\t\t\t `custom5` tinytext NOT NULL,\n\t\t\t\t `custom6` tinytext NOT NULL,\n\t\t\t\t `custom7` tinytext NOT NULL,\n\t\t\t\t `custom8` tinytext NOT NULL,\n\t\t\t\t `custom9` tinytext NOT NULL,\n\t\t\t\t `custom10` tinytext NOT NULL,\n\t\t\t\t `impression` tinytext NOT NULL,\n\t\t\t\t `conclusion` text NOT NULL\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_articles_reviews` (\n\t\t\t\t `artid` int(11) unsigned NOT NULL default '0',\n\t\t\t\t `custom1` tinytext NOT NULL,\n\t\t\t\t `custom2` tinytext NOT NULL,\n\t\t\t\t `custom3` tinytext NOT NULL,\n\t\t\t\t `custom4` tinytext NOT NULL,\n\t\t\t\t `custom5` tinytext NOT NULL,\n\t\t\t\t `custom6` tinytext NOT NULL,\n\t\t\t\t `custom7` tinytext NOT NULL,\n\t\t\t\t `custom8` tinytext NOT NULL,\n\t\t\t\t `custom9` tinytext NOT NULL,\n\t\t\t\t `custom10` tinytext NOT NULL,\n\t\t\t\t `rate1` tinytext NOT NULL,\n\t\t\t\t `rate2` tinytext NOT NULL,\n\t\t\t\t `rate3` tinytext NOT NULL,\n\t\t\t\t `rate4` tinytext NOT NULL,\n\t\t\t\t `rate5` tinytext NOT NULL,\n\t\t\t\t `rate6` tinytext NOT NULL,\n\t\t\t\t `rate7` tinytext NOT NULL,\n\t\t\t\t `rate8` tinytext NOT NULL,\n\t\t\t\t `rate9` tinytext NOT NULL,\n\t\t\t\t `rate10` tinytext NOT NULL,\n\t\t\t\t `final_rate` tinytext NOT NULL,\n\t\t\t\t `positive` text NOT NULL,\n\t\t\t\t `negative` text NOT NULL,\n\t\t\t\t `conclusion` text NOT NULL,\n\t\t\t\t `award` tinytext NOT NULL\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_articles` ADD `links` TEXT NOT NULL AFTER `galid` ;\n\t\t\t\tALTER TABLE `apx_articles` ADD `type` ENUM( 'normal', 'preview', 'review' ) NOT NULL AFTER `id` ;\n\t\t\t\tALTER TABLE `apx_articles` ADD `pictures` TEXT NOT NULL AFTER `links` ;\n\t\t\t\tALTER TABLE `apx_articles` ADD `pictures_nextid` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `pictures` ;\n\t\t\t\t\n\t\t\t\tUPDATE `apx_config` SET ord = ord +700 WHERE module = 'articles' AND ord >800;\n\t\t\t\tUPDATE `apx_config` SET ord = ord +400 WHERE module = 'articles' AND ord >1600;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'picwidth', 'int', '', '640', 1141134229, 900);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'picheight', 'int', '', '480', 1141134229, 1000);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'watermark', 'string', '', '', 1141134229, 1100);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'watermark_transp', 'int', '', '50', 1141134229, 1200);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'watermark_position', 'select', 'a:9:{i:1;s:18:\"{POSTOP} {POSLEFT}\";i:2;s:20:\"{POSTOP} {POSCENTER}\";i:3;s:19:\"{POSTOP} {POSRIGHT}\";i:4;s:21:\"{POSMIDDLE} {POSLEFT}\";i:5;s:23:\"{POSMIDDLE} {POSCENTER}\";i:6;s:22:\"{POSMIDDLE} {POSRIGHT}\";i:7;s:21:\"{POSBOTTOM} {POSLEFT}\";i:8;s:23:\"{POSBOTTOM} {POSCENTER}\";i:9;s:22:\"{POSBOTTOM} {POSRIGHT}\";}', '9', 1141134229, 1300);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'thumbwidth', 'int', '', '120', 1141134229, 1400);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'thumbheight', 'int', '', '90', 1141134229, 1500);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'popup_addwidth', 'int', '', '60', 1143727472, 1520);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'popup_addheight', 'int', '', '150', 1143727472, 1540);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'popup_resizeable', 'switch', '', '1', 1143727472, 1560);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'custom_preview', 'array', '', 'a:0:{}', '0', '1700');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'custom_review', 'array', '', 'a:0:{}', '0', '1800');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'ratefields', 'array', '', 'a:0:{}', '0', '1900');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'awards', 'array', '', 'a:0:{}', '0', '2000');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'reviews_conclusionpage', 'switch', '', '1', '0', '2025');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'previews_conclusionpage', 'switch', '', '1', '0', '2025');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'normalonly', 'switch', '', '1', '0', '2050');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('gallery', 'articles');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'searchepp', 'int', '', '10', '0', '2800');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('articles', 'archiveentrysort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 1144936997, 2750);\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
foreach ($queries as $query) {
$db->query($query);
}
//Locations einfügen
/*require_once(BASEDIR.'lib/class.linereader.php');
$locReader = new LineReader(BASEDIR.getmodulepath('user').'locations.sql', ";\n");
$command = '';
while ( ($line = $locReader->getNext())!==false ) {
if ( $line ) {
$line=str_replace('`apx_','`'.PRE.'_',$line);
$db->query($line);
}
}*/
//User-Gallery-DIR
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('gallery', 'user');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('user', 'visitorself', 'switch', '', '', '0', '1450');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('user', 'gallery_maxpics', 'int', '', '', '0', '4550');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('user', 'friendsepp', 'int', '', '20', '0', '4800');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('user', 'reportmail', 'string', '', '', '0', '5500');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('user', 'onlinerecord', 'int', 'BLOCK', '', '0', '0');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('user', 'onlinerecord_time', 'int', 'BLOCK', '', '0', '0');\n\t\t\t\tALTER TABLE `apx_user` ADD `locid` INT( 11 ) UNSIGNED NOT NULL AFTER `country` ;\n\t\t\t\tALTER TABLE `apx_user` ADD `pub_usegb` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `pub_showbuddies` ;\n\t\t\t\tALTER TABLE `apx_user_online` CHANGE `ip` `ip` VARCHAR( 15 ) NOT NULL ;\n\t\t\t\tALTER TABLE `apx_user_online` ADD INDEX ( `time` ) ;\n\t\t\t\tDROP TABLE IF EXISTS `apx_user_locations`;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_user_friends` (\n\t\t\t\t `userid` int(11) unsigned NOT NULL,\n\t\t\t\t `friendid` int(11) unsigned NOT NULL,\n\t\t\t\t PRIMARY KEY (`userid`,`friendid`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_user_ignore` (\n\t\t\t\t `userid` int(11) unsigned NOT NULL,\n\t\t\t\t `ignored` int(11) unsigned NOT NULL,\n\t\t\t\t `reason` tinytext NOT NULL,\n\t\t\t\t PRIMARY KEY (`userid`,`ignored`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_user_visits` (\n\t\t\t\t `object` varchar(20) NOT NULL,\n\t\t\t\t `id` int(11) unsigned NOT NULL,\n\t\t\t\t `userid` int(11) unsigned NOT NULL,\n\t\t\t\t `time` int(11) unsigned NOT NULL,\n\t\t\t\t PRIMARY KEY (`object`,`id`,`userid`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_user_locations` (\n\t\t\t\t `id` int(11) NOT NULL,\n\t\t\t\t `name` varchar(250) default NULL,\n\t\t\t\t `b` float default NULL,\n\t\t\t\t `l` float default NULL,\n\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_user_locations_plz` (\n\t\t\t\t `locid` int(11) unsigned NOT NULL,\n\t\t\t\t `plz` varchar(5) NOT NULL,\n\t\t\t\t `stamp` varchar(8) NOT NULL,\n\t\t\t\t PRIMARY KEY (`locid`,`plz`),\n\t\t\t\t KEY `stamp` (`stamp`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Locations einfügen
/*require_once(BASEDIR.'lib/class.linereader.php');
$locReader = new LineReader(BASEDIR.getmodulepath('user').'locations.sql', ";\n");
$command = '';
while ( ($line = $locReader->getNext())!==false ) {
if ( $line ) {
$line=str_replace('`apx_','`'.PRE.'_',$line);
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_affiliates` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `title` tinytext NOT NULL,\n\t\t `image` tinytext NOT NULL,\n\t\t `link` tinytext NOT NULL,\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t `ord` smallint(4) unsigned NOT NULL default '0',\n\t\t `active` tinyint(1) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `active` (`active`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('affiliates', 'orderby', 'select', 'a:4:{i:1;s:12:\"{ORDERADMIN}\";i:2;s:16:\"{ORDERHITS_DESC}\";i:3;s:15:\"{ORDERHITS_ASC}\";i:4;s:13:\"{ORDERRANDOM}\";}', '4', '', 1129897415, 1000);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Ordner für Bilder
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('affiliates');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_affiliates`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//Zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_affiliates');
//config Update
updateConfig('affiliates', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('affiliates', 'orderby', 'select', 'a:4:{i:1;s:12:\"{ORDERADMIN}\";i:2;s:16:\"{ORDERHITS_DESC}\";i:3;s:15:\"{ORDERHITS_ASC}\";i:4;s:13:\"{ORDERRANDOM}\";}', '4', '', 1129897415, 1000);\n\t\t\t");
$foruminfo = forum_info($threadinfo['forumid']);
if (!$foruminfo['forumid']) {
message($apx->lang->get('MSG_FORUMNOTEXIST'));
}
if ($threadinfo['del'] && !($user->info['userid'] && ($user->is_admin() || in_array($user->info['userid'], $foruminfo['moderator'])))) {
message($apx->lang->get('MSG_THREADNOTEXIST'));
}
if ($postinfo['del'] && !($user->info['userid'] && ($user->is_admin() || in_array($user->info['userid'], $foruminfo['moderator'])))) {
message($apx->lang->get('MSG_POSTNOTEXIST'));
}
if (!forum_access_addattachment($foruminfo)) {
tmessage('noright', array(), false, false);
}
}
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
//Dateitypen
$typeinfo = array();
$data = $db->fetch("SELECT * FROM " . PRE . "_forum_filetypes ORDER BY ext ASC");
if (count($data)) {
foreach ($data as $res) {
$i++;
$filedata[$i]['EXT'] = $res['ext'];
$filedata[$i]['ICON'] = $res['icon'];
$filedata[$i]['MAXSIZE'] = $res['size'];
$typeinfo[$res['ext']] = array($res['size'] * 1024, $res['icon']);
}
}
//Dateien hochladen
if ($_POST['send']) {
for ($i = 1; $i <= 3; $i++) {
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_downloads', PRE . '_downloads_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_downloads` ADD `meta_description` TEXT NOT NULL AFTER `text` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('downloads', 'mirrorstats', 'switch', '', '1', 'OPTIONS', 1301669229, 4500);\n\t\t\t\tALTER TABLE `apx_downloads` ADD `format` TINYTEXT NOT NULL AFTER `filesize` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tALTER TABLE `apx_downloads` ADD `teaserpic` TINYTEXT NOT NULL AFTER `text` ;\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('downloads', 'teaserpic_width', 'int', '', '120', 'TEASERPIC', 1261490672, 1000),\n\t\t\t\t('downloads', 'teaserpic_height', 'int', '', '120', 'TEASERPIC', 1261490672, 2000),\n\t\t\t\t('downloads', 'teaserpic_popup', 'switch', '', '1', 'TEASERPIC', 1261490672, 3000),\n\t\t\t\t('downloads', 'teaserpic_popup_width', 'int', '', '640', 'TEASERPIC', 1261490672, 4000),\n\t\t\t\t('downloads', 'teaserpic_popup_height', 'int', '', '480', 'TEASERPIC', 1261490672, 5000),\n\t\t\t\t('downloads', 'teaserpic_quality', 'switch', '', '1', 'TEASERPIC', 1261490672, 6000);\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
@$mm->createdir('pics', 'downloads');
}
}
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_products` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `prodid` int(11) unsigned NOT NULL,\n\t\t `type` enum('normal','game','music','movie','book','software','hardware') NOT NULL default 'normal',\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `picture` tinytext NOT NULL,\n\t\t `teaserpic` TINYTEXT NOT NULL,\n\t\t `website` tinytext NOT NULL,\n\t\t `meta_description` text NOT NULL,\n\t\t `regisseur` tinytext NOT NULL,\n\t\t `actors` tinytext NOT NULL,\n\t\t `manufacturer` int(11) unsigned NOT NULL default '0',\n\t\t `publisher` int(11) unsigned NOT NULL default '0',\n\t\t `genre` int(11) NOT NULL default '0',\n\t\t `systems` tinytext NOT NULL,\n\t\t `sk` enum('','all','none','6','12','16','18') NOT NULL default '',\n\t\t `requirements` text NOT NULL,\n\t\t `equipment` text NOT NULL,\n\t\t `os` tinytext NOT NULL,\n\t\t `languages` tinytext NOT NULL,\n\t\t `license` enum('freeware','shareware','commercial') NOT NULL,\n\t\t `version` tinytext NOT NULL,\n\t\t `isbn` tinytext NOT NULL,\n\t\t `media` tinytext NOT NULL,\n\t\t `length` varchar(50) NOT NULL default '',\n\t\t `custom1` tinytext NOT NULL,\n\t\t `custom2` tinytext NOT NULL,\n\t\t `custom3` tinytext NOT NULL,\n\t\t `custom4` tinytext NOT NULL,\n\t\t `custom5` tinytext NOT NULL,\n\t\t `custom6` tinytext NOT NULL,\n\t\t `custom7` tinytext NOT NULL,\n\t\t `custom8` tinytext NOT NULL,\n\t\t `custom9` tinytext NOT NULL,\n\t\t `custom10` tinytext NOT NULL,\n\t\t `buylink` tinytext NOT NULL,\n\t\t `price` varchar(20) NOT NULL default '0',\n\t\t `recprice` tinytext NOT NULL,\n\t\t `guarantee` tinytext NOT NULL,\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `hits` int(11) unsigned NOT NULL,\n\t\t `active` tinyint(1) unsigned NOT NULL,\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL default '1',\n\t\t `allowrating` tinyint(1) unsigned NOT NULL default '1',\n\t\t `restricted` tinyint(1) unsigned NOT NULL,\n\t\t `top` TINYINT(1) UNSIGNED NOT NULL,\n\t\t `searchable` tinyint(1) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `type` (`type`),\n\t\t KEY `active` (`active`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_products_coll` (\n\t\t\t`userid` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t`prodid` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\tPRIMARY KEY ( `userid` , `prodid` )\n\t\t) ENGINE = MYISAM ;\n\t\t\n\t\tCREATE TABLE `apx_products_groups` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `grouptype` enum('medium','system','genre') NOT NULL default 'medium',\n\t\t `type` enum('normal','game','music','movie','book','software','hardware') NOT NULL default 'game',\n\t\t `title` tinytext NOT NULL,\n\t\t `icon` tinytext NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `grouptype` (`grouptype`),\n\t\t KEY `type` (`type`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_products_releases` (\n\t\t `ord` int(11) unsigned NOT NULL auto_increment,\n\t\t `prodid` int(11) unsigned NOT NULL default '0',\n\t\t `system` int(11) unsigned NOT NULL default '0',\n\t\t `data` text NOT NULL,\n\t\t `stamp` int(8) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`ord`),\n\t\t KEY `prodid` (`prodid`),\n\t\t KEY `stamp` (`stamp`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_products_tags` (\n\t\t `id` int(11) unsigned NOT NULL,\n\t\t `tagid` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`,`tagid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tCREATE TABLE `apx_products_units` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `type` enum('company','person') NOT NULL default 'company',\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `meta_description` text NOT NULL,\n\t\t `fullname` tinytext NOT NULL,\n\t\t `picture` tinytext NOT NULL,\n\t\t `address` tinytext NOT NULL,\n\t\t `email` tinytext NOT NULL,\n\t\t `phone` tinytext NOT NULL,\n\t\t `website` tinytext NOT NULL,\n\t\t `founder` tinytext NOT NULL,\n\t\t `founding_year` tinytext NOT NULL,\n\t\t `founding_country` tinytext NOT NULL,\n\t\t `legalform` tinytext NOT NULL,\n\t\t `headquaters` tinytext NOT NULL,\n\t\t `executive` tinytext NOT NULL,\n\t\t `employees` tinytext NOT NULL,\n\t\t `turnover` tinytext NOT NULL,\n\t\t `sector` tinytext NOT NULL,\n\t\t `products` tinytext NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `type` (`type`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('products', 'epp', 'int', '', '20', 'VIEW', 1220200389, 1000),\n\t\t('products', 'manu_epp', 'int', '', '20', 'VIEW', 1220200389, 2000),\n\t\t('products', 'manu_searchepp', 'int', '', '20', 'VIEW', '0', '2500'),\n\t\t('products', 'manuprod_epp', 'int', '', '20', 'VIEW', 1220200389, 3000),\n\t\t('products', 'relepp', 'int', '', '20', 'VIEW', 1220200389, 4000),\n\t\t('products', 'searchepp', 'int', '', '20', 'VIEW', 1220200389, 4500),\n\t\t('products', 'sortby', 'select', 'a:2:{i:1;s:7:\"{TITLE}\";i:0;s:9:\"{RELEASE}\";}', '1', 'VIEW', 1220200389, 5000),\n\t\t\n\t\t('products', 'searchable', 'switch', '', '1', 'OPTIONS', 1220200389, 1000),\n\t\t('products', 'coms', 'switch', '', '1', 'OPTIONS', 1220200390, 2000),\n\t\t('products', 'ratings', 'switch', '', '1', 'OPTIONS', 1220200390, 3000),\n\t\t('products', 'filtermanu', 'switch', '', '1', 'OPTIONS', 1220200390, 4000),\n\t\t('products', 'collection', 'switch', '', '1', 'OPTIONS', '0', '5000'),\n\t\t\n\t\t('products', 'custom_normal', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 1000),\n\t\t('products', 'custom_game', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 2000),\n\t\t('products', 'custom_software', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 3000),\n\t\t('products', 'custom_hardware', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 4000),\n\t\t('products', 'custom_music', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 5000),\n\t\t('products', 'custom_movie', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 6000),\n\t\t('products', 'custom_book', 'array', '', 'a:0:{}', 'CUSTOM', 1220200390, 7000),\n\t\t\n\t\t('products', 'pic_width', 'int', '', '120', 'IMAGES', 1220200390, 1000),\n\t\t('products', 'pic_height', 'int', '', '120', 'IMAGES', 1220200390, 2000),\n\t\t('products', 'pic_popup', 'switch', '', '1', 'IMAGES', 1220200390, 3000),\n\t\t('products', 'pic_popup_width', 'int', '', '640', 'IMAGES', 1220200390, 4000),\n\t\t('products', 'pic_popup_height', 'int', '', '480', 'IMAGES', 1220200390, 5000),\n\t\t('products', 'pic_quality', 'switch', '', '1', 'IMAGES', 1220200390, 6000);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Products-DIR
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('products');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_products`;\n\t\tDROP TABLE `apx_products_groups`;\n\t\tDROP TABLE `apx_products_releases`;\n\t\tDROP TABLE `apx_products_tags`;\n\t\tDROP TABLE `apx_products_units`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_products` ADD `custom1` TINYTEXT NOT NULL AFTER `length` ,ADD `custom2` TINYTEXT NOT NULL AFTER `custom1` ,ADD `custom3` TINYTEXT NOT NULL AFTER `custom2` ,ADD `custom4` TINYTEXT NOT NULL AFTER `custom3` ,ADD `custom5` TINYTEXT NOT NULL AFTER `custom4` ,ADD `custom6` TINYTEXT NOT NULL AFTER `custom5` ,ADD `custom7` TINYTEXT NOT NULL AFTER `custom6` ,ADD `custom8` TINYTEXT NOT NULL AFTER `custom7` ,ADD `custom9` TINYTEXT NOT NULL AFTER `custom8` ,ADD `custom10` TINYTEXT NOT NULL AFTER `custom9` ;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'custom_normal', 'array', '', 'a:0:{}', '0', '820');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'custom_game', 'array', '', 'a:0:{}', '0', '830');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'custom_music', 'array', '', 'a:0:{}', '0', '840');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'custom_movie', 'array', '', 'a:0:{}', '0', '850');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'custom_book', 'array', '', 'a:0:{}', '0', '860');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
| 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!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_videos` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `secid` tinytext NOT NULL,\n\t\t `prodid` int(11) unsigned NOT NULL default '0',\n\t\t `catid` int(11) unsigned NOT NULL default '0',\n\t\t `userid` int(11) unsigned NOT NULL default '0',\n\t\t `file` text NOT NULL,\n\t\t `filesize` BIGINT UNSIGNED NOT NULL,\n\t\t `flvfile` tinytext NOT NULL,\n\t\t `status` enum('new','converting','failed','finished') NOT NULL default 'finished',\n\t\t `source` varchar(30) NOT NULL,\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `teaserpic` tinytext NOT NULL,\n\t\t `meta_description` text NOT NULL,\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `starttime` int(11) unsigned NOT NULL default '0',\n\t\t `endtime` int(11) unsigned NOT NULL default '0',\n\t\t `broken` int(11) unsigned NOT NULL default '0',\n\t\t `password` tinytext NOT NULL,\n\t\t `limit` int(10) unsigned NOT NULL default '0',\n\t\t `top` tinyint(1) unsigned NOT NULL default '0',\n\t\t `regonly` tinyint(1) unsigned NOT NULL default '0',\n\t\t `searchable` tinyint(1) unsigned NOT NULL default '0',\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL default '1',\n\t\t `allowrating` tinyint(1) unsigned NOT NULL default '1',\n\t\t `restricted` tinyint(1) unsigned NOT NULL,\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t `downloads` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `catid` (`catid`),\n\t\t KEY `userid` (`userid`),\n\t\t KEY `starttime` (`starttime`,`endtime`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tCREATE TABLE `apx_videos_cat` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `icon` tinytext NOT NULL,\n\t\t `open` tinyint(1) unsigned NOT NULL default '1',\n\t\t `forgroup` tinytext NOT NULL,\n\t\t `parents` varchar(255) NOT NULL,\n\t\t `children` text NOT NULL,\n\t\t `ord` tinyint(3) NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `parents` (`parents`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tCREATE TABLE `apx_videos_screens` (\n\t\t `pictureid` int(11) unsigned NOT NULL auto_increment,\n\t\t `videoid` int(11) unsigned NOT NULL,\n\t\t `thumbnail` tinytext NOT NULL,\n\t\t `picture` tinytext NOT NULL,\n\t\t PRIMARY KEY (`pictureid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tCREATE TABLE `apx_videos_stats` (\n\t\t `daystamp` int(8) unsigned NOT NULL default '0',\n\t\t `time` int(11) unsigned NOT NULL default '0',\n\t\t `dlid` int(11) unsigned NOT NULL default '0',\n\t\t `bytes` bigint(20) unsigned NOT NULL default '0',\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`daystamp`,`dlid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tCREATE TABLE `apx_videos_tags` (\n\t\t `id` int(11) unsigned NOT NULL,\n\t\t `tagid` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`,`tagid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('videos', 'ffmpeg', 'string', 'BLOCK', '', '', 0, 0),\n\t\t('videos', 'flvtool2', 'string', 'BLOCK', '', '', 0, 0),\n\t\t('videos', 'mencoder', 'string', 'BLOCK', '', '', 0, 0),\n\t\t\n\t\t('videos', 'flvwidth', 'int', '', '400', 'CONVERTER', 1261490672, 1000),\n\t\t('videos', 'flvheight', 'int', '', '300', 'CONVERTER', 1261490672, 2000),\n\t\t('videos', 'vbitrate', 'int', '', '1200', 'CONVERTER', 1261490672, 3000),\n\t\t('videos', 'abitrate', 'int', '', '128', 'CONVERTER', 1261490672, 4000),\n\t\t\n\t\t('videos', 'searchable', 'switch', '', '1', 'OPTIONS', 1261490672, 1000),\n\t\t('videos', 'regonly', 'switch', '', '0', 'OPTIONS', 1261490672, 2000),\n\t\t('videos', 'maxtraffic', 'float', '', '0', 'OPTIONS', 1261490672, 3000),\n\t\t('videos', 'exttraffic', 'switch', '', '1', 'OPTIONS', 1251291273, 3500),\n\t\t('videos', 'coms', 'switch', '', '1', 'OPTIONS', 1261490672, 4000),\n\t\t('videos', 'ratings', 'switch', '', '1', 'OPTIONS', 1261490672, 5000),\n\t\t('videos', 'mailonbroken', 'string', '', '', 'OPTIONS', 1261490672, 6000),\n\t\t\n\t\t('videos', 'addpics', 'int', '', '5', 'SCREENSHOTS', 1261490672, 1000),\n\t\t('videos', 'picwidth', 'int', '', '640', 'SCREENSHOTS', 1261490672, 2000),\n\t\t('videos', 'picheight', 'int', '', '480', 'SCREENSHOTS', 1261490672, 3000),\n\t\t('videos', 'watermark', 'string', '', '', 'SCREENSHOTS', 1261490672, 4000),\n\t\t('videos', 'watermark_transp', 'int', '', '50', 'SCREENSHOTS', 1261490672, 5000),\n\t\t('videos', 'watermark_position', 'select', 'a:9:{i:1;s:18:\"{POSTOP} {POSLEFT}\";i:2;s:20:\"{POSTOP} {POSCENTER}\";i:3;s:19:\"{POSTOP} {POSRIGHT}\";i:4;s:21:\"{POSMIDDLE} {POSLEFT}\";i:5;s:23:\"{POSMIDDLE} {POSCENTER}\";i:6;s:22:\"{POSMIDDLE} {POSRIGHT}\";i:7;s:21:\"{POSBOTTOM} {POSLEFT}\";i:8;s:23:\"{POSBOTTOM} {POSCENTER}\";i:9;s:22:\"{POSBOTTOM} {POSRIGHT}\";}', '9', 'SCREENSHOTS', 1261490672, 6000),\n\t\t('videos', 'thumbwidth', 'int', '', '120', 'SCREENSHOTS', 1261490672, 7000),\n\t\t('videos', 'thumbheight', 'int', '', '90', 'SCREENSHOTS', 1261490672, 8000),\n\t\t('videos', 'quality_resize', 'switch', '', '1', 'SCREENSHOTS', 1261490672, 9000),\n\t\t\n\t\t('videos', 'teaserpic_width', 'int', '', '120', 'TEASERPIC', 1261490672, 1000),\n\t\t('videos', 'teaserpic_height', 'int', '', '120', 'TEASERPIC', 1261490672, 2000),\n\t\t('videos', 'teaserpic_popup', 'switch', '', '1', 'TEASERPIC', 1261490672, 3000),\n\t\t('videos', 'teaserpic_popup_width', 'int', '', '640', 'TEASERPIC', 1261490672, 4000),\n\t\t('videos', 'teaserpic_popup_height', 'int', '', '480', 'TEASERPIC', 1261490672, 5000),\n\t\t('videos', 'teaserpic_quality', 'switch', '', '1', 'TEASERPIC', 1261490672, 6000),\n\t\t\n\t\t('videos', 'epp', 'int', '', '20', 'VIEW', 1261490672, 1000),\n\t\t('videos', 'searchepp', 'string', '', '20', 'VIEW', 1261490672, 2000),\n\t\t('videos', 'catonly', 'switch', '', '1', 'VIEW', 1261490672, 3000),\n\t\t('videos', 'sortby', 'select', 'a:2:{i:1;s:7:\"{TITLE}\";i:2;s:6:\"{DATE}\";}', '1', 'VIEW', 1261490672, 4000),\n\t\t('videos', 'new', 'int', '', '3', 'VIEW', 1261490672, 5000),\n\t\t('videos', 'embed_width', 'int', '', '320', 'VIEW', '0', '6000'),\n\t\t('videos', 'embed_height', 'int', '', '240', 'VIEW', '0', '7000');\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('videos');
$mm->createdir('flv', 'videos');
$mm->createdir('logs', 'videos');
$mm->createdir('pics', 'videos');
$mm->createdir('screens', 'videos');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_videos`;\n\t\tDROP TABLE `apx_videos_cat`;\n\t\tDROP TABLE `apx_videos_screens`;\n\t\tDROP TABLE `apx_videos_stats`;\n\t\tDROP TABLE `apx_videos_tags`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$apx->tmpl->assign('PASSWORD', compatible_hsc($_POST['password']));
$apx->tmpl->assign('ALLOWCOMS', intval($_POST['allowcoms']));
$apx->tmpl->parse('mygallery_addedit');
require 'lib/_end.php';
} elseif ($_REQUEST['do'] == 'del') {
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if ($_POST['send']) {
$db->query("DELETE FROM " . PRE . "_user_gallery WHERE id='" . $_REQUEST['id'] . "' AND owner='" . $user->info['userid'] . "' LIMIT 1");
if ($db->affected_rows()) {
$data = $db->fetch("SELECT picture,thumbnail FROM " . PRE . "_user_pictures WHERE galid='" . $_REQUEST['id'] . "'");
$db->query("DELETE FROM " . PRE . "_user_pictures WHERE galid='" . $_REQUEST['id'] . "'");
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
if (count($data)) {
foreach ($data as $res) {
$picture = $res['picture'];
$thumbnail = $res['thumbnail'];
if ($picture && file_exists(BASEDIR . getpath('uploads') . $picture)) {
$mm->deletefile($picture);
}
if ($thumbnail && file_exists(BASEDIR . getpath('uploads') . $thumbnail)) {
$mm->deletefile($thumbnail);
}
}
}
$mm->deletedir('user/gallery-' . $_REQUEST['id']);
}
message($apx->lang->get('MSG_DEL_OK'), mklink('user.php?action=mygallery', 'user,mygallery.html'));
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_calendar_cat` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `title` tinytext NOT NULL,\n\t\t `icon` tinytext NOT NULL,\n\t\t `parents` varchar(255) NOT NULL,\n\t\t `children` text NOT NULL,\n\t\t `ord` tinyint(3) NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `parents` (`parents`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_calendar_events` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `secid` tinytext NOT NULL,\n\t\t `catid` int(11) unsigned NOT NULL default '0',\n\t\t `userid` int(11) unsigned NOT NULL default '0',\n\t\t `send_username` tinytext NOT NULL,\n\t\t `send_email` tinytext NOT NULL,\n\t\t `send_ip` tinytext NOT NULL,\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `meta_description` text NOT NULL,\n\t\t `location` tinytext NOT NULL,\n\t\t `location_link` tinytext NOT NULL,\n\t\t `picture` tinytext NOT NULL,\n\t\t `priority` enum('1','2','3') NOT NULL default '2',\n\t\t `galid` int(11) unsigned NOT NULL default '0',\n\t\t `links` text NOT NULL,\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `startday` int(8) NOT NULL default '0',\n\t\t `starttime` smallint(4) NOT NULL default '-1',\n\t\t `endday` int(8) NOT NULL default '0',\n\t\t `endtime` smallint(4) NOT NULL default '-1',\n\t\t `searchable` tinyint(1) unsigned NOT NULL default '0',\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL default '0',\n\t\t `allownote` tinyint(1) unsigned NOT NULL default '0',\n\t\t `restricted` tinyint(1) unsigned NOT NULL,\n\t\t `private` tinyint(1) unsigned NOT NULL default '0',\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t `active` INT( 11 ) UNSIGNED NOT NULL default '0',\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `catid` (`catid`),\n\t\t KEY `userid` (`userid`),\n\t\t KEY `active` (`active`),\n\t\t KEY `startday` (`startday`,`endday`,`starttime`,`endtime`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_calendar_parts` (\n\t\t `eventid` int(11) unsigned NOT NULL default '0',\n\t\t `userid` int(11) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`eventid`,`userid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tCREATE TABLE `apx_calendar_tags` (\n\t\t `id` int(11) unsigned NOT NULL,\n\t\t `tagid` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`,`tagid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('calendar', 'eventdays', 'int', '', '7', 'VIEW', 1219685244, 1000),\n\t\t('calendar', 'searchepp', 'int', '', '20', 'VIEW', 1219685244, 2000),\n\t\t('calendar', 'sortby', 'select', 'a:2:{i:1;s:13:\"{SORTBY_TIME}\";i:2;s:14:\"{SORTBY_TITLE}\";}', '1', 'VIEW', 1219685244, 3000),\n\t\t('calendar', 'start', 'select', 'a:3:{s:3:\"day\";s:11:\"{START_DAY}\";s:4:\"week\";s:12:\"{START_WEEK}\";s:5:\"month\";s:13:\"{START_MONTH}\";}', 'month', 'VIEW', '0', '4000'),\n\t\t\n\t\t('calendar', 'searchable', 'switch', '', '1', 'OPTIONS', 1219685244, 1000),\n\t\t('calendar', 'subcats', 'switch', '', '1', 'OPTIONS', 1219685244, 2000),\n\t\t('calendar', 'userevents', 'switch', '', '1', 'OPTIONS', 1219685244, 3000),\n\t\t('calendar', 'captcha', 'switch', '', '1', 'OPTIONS', 1219685244, 4000),\n\t\t('calendar', 'mailonnew', 'string', '', '', 'OPTIONS', 1219685244, 5000),\n\t\t('calendar', 'coms', 'switch', '', '1', 'OPTIONS', 1219685244, 6000),\n\t\t('calendar', 'note', 'switch', '', '1', 'OPTIONS', 1219685244, 7000),\n\t\t\n\t\t('calendar', 'pic_width', 'int', '', '120', 'IMAGES', 1219685244, 1000),\n\t\t('calendar', 'pic_height', 'int', '', '120', 'IMAGES', 1219685244, 2000),\n\t\t('calendar', 'pic_popup', 'switch', '', '1', 'IMAGES', 1219685244, 3000),\n\t\t('calendar', 'pic_popup_width', 'int', '', '640', 'IMAGES', 1219685244, 4000),\n\t\t('calendar', 'pic_popup_height', 'int', '', '480', 'IMAGES', 1219685244, 5000),\n\t\t('calendar', 'pic_quality', 'switch', '', '1', 'IMAGES', 1219685244, 6000);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Bilder-Ordner
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('calendar');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_calendar_cat`;\n\t\tDROP TABLE `apx_calendar_events`;\n\t\tDROP TABLE `apx_calendar_parts`;\n\t\tDROP TABLE `apx_calendar_tags`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `location` TINYTEXT NOT NULL AFTER `text` ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `send_username` TINYTEXT NOT NULL AFTER `userid` , ADD `send_email` TINYTEXT NOT NULL AFTER `send_username` , ADD `send_ip` TINYTEXT NOT NULL AFTER `send_email` ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `secid` TINYTEXT NOT NULL AFTER `id` ;\n\t\t\t\tUPDATE `apx_calendar_events` SET secid = 'all';\n\t\t\t\tALTER TABLE `apx_calendar_cat` ADD `root_id` INT( 11 ) UNSIGNED NOT NULL AFTER `id` ;\n\t\t\t\tALTER TABLE `apx_calendar_cat` ADD `lft` INT( 11 ) UNSIGNED NOT NULL , ADD `rgt` INT( 11 ) UNSIGNED NOT NULL ;\n\t\t\t\tUPDATE `apx_calendar_cat` SET root_id = id;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('calendar', 'subcats', 'switch', '', '1', 1176245712, 50);\n\t\t\t\tINSERT INTO `apx_config` VALUES ('calendar', 'sortby', 'select', 'a:2:{i:1;s:13:\"{SORTBY_TIME}\";i:2;s:14:\"{SORTBY_TITLE}\";}', '1', '0', '250');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('calendar', 'captcha', 'switch', '', '1', '0', '1050');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
if ($threadinfo['del'] && !($user->info['userid'] && ($user->is_admin() || in_array($user->info['userid'], $foruminfo['moderator'])))) {
message($apx->lang->get('MSG_THREADNOTEXIST'));
}
if ($postinfo['del'] && !($user->info['userid'] && ($user->is_admin() || in_array($user->info['userid'], $foruminfo['moderator'])))) {
message($apx->lang->get('MSG_POSTNOTEXIST'));
}
if (!forum_access_read($foruminfo)) {
tmessage('noright', array(), false, false);
}
check_forum_password($foruminfo);
//Lastvisit für dieses Thema bestimmen
$lastvisit = max(array($user->info['forum_lastonline'], thread_readtime($threadinfo['threadid']), forum_readtime($foruminfo['forumid'])));
///////////////////////////////////////////////////////////////////////////////////////// BEITRAG
$res = $postinfo;
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
//Userinfo auslesen
if ($res['userid']) {
$userdat = $db->first("SELECT a.userid,a.groupid,a.reg_time,a.forum_posts,a.avatar,a.avatar_title,a.signature,a.homepage,a.city,a.icq,a.aim,a.yim,a.msn,a.skype,a.forum_lastactive,a.pub_invisible,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,b.gtype FROM " . PRE . "_user AS a LEFT JOIN " . PRE . "_user_groups AS b USING(groupid) WHERE a.userid='" . $res['userid'] . "' LIMIT 1");
} else {
$userdat = array();
}
$mods = $foruminfo['moderator'];
//Text
$text = forum_replace($postinfo['text'], $postinfo['allowcodes'], $postinfo['allowsmilies']);
//Benutzerkennzeichen
$siganture = $avatar = $avatar_title = '';
if ($postinfo['userid']) {
if ($postinfo['allowsig']) {
$signature = $user->mksig($userdat);
}
continue;
}
//Bei required-Feldern Namen kürzen
if (substr($key, -9) == '_required') {
$key = substr($key, 0, strlen($key) - 9);
}
$addnl .= $key . ': ' . $value . "\r\n";
}
//Text erstellen
$text = str_replace("\r", '', $_POST['text']);
$text = str_replace("\n", "\r\n", $text);
$text = $text . iif($addnl, "\r\n\r\n" . $addnl);
//Mediamanger initialisieren
$attachments = array();
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$temphash = md5(microtime());
//Dateien hochladen
for ($i = 1; $i <= 5; $i++) {
$fileinfo = $_FILES['attach' . $i];
if (!$fileinfo['tmp_name']) {
continue;
}
if (!is_uploaded_file($fileinfo['tmp_name'])) {
continue;
}
$tempname = 'contact_' . $temphash . '_' . $fileinfo['name'] . '.tmp';
$mm->uploadfile($fileinfo, 'temp', $tempname);
$attachments[] = array('filename' => $fileinfo['name'], 'source' => $tempname, 'type' => $fileinfo['type']);
}
//Normale eMail senden
function udel()
{
global $set, $db, $apx;
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if ($_POST['send'] == 1) {
if (!checkToken()) {
printInvalidToken();
} else {
//Bild löschen
list($picture) = $db->first("SELECT picture FROM " . PRE . "_products_units WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$poppic = str_replace('-thumb.', '.', $picture);
if ($picture && file_exists(BASEDIR . getpath('uploads') . $picture)) {
$mm->deletefile($picture);
}
if ($poppic && file_exists(BASEDIR . getpath('uploads') . $poppic)) {
$mm->deletefile($poppic);
}
//DB-Eintrag löschen
$db->query("DELETE FROM " . PRE . "_products_units WHERE id='" . $_REQUEST['id'] . "'");
logit('PRODUCTS_UNITS_DEL', 'ID #' . $_REQUEST['id']);
printJSRedirect(get_index('products.ushow'));
}
} else {
list($title) = $db->first("SELECT title FROM " . PRE . "_products_units WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
$apx->tmpl->assign('MESSAGE', $apx->lang->get('MSG_TEXT', array('TITLE' => compatible_hsc($title))));
tmessageOverlay('deltitle', array('ID' => $_REQUEST['id']), '/');
}
}
function pictures()
{
global $set, $db, $apx;
//Notwendig weil 1.7.0 beim Kopieren ein Bild mit ID 0 erzeugt hatte :/
if (isset($_REQUEST['delpic'])) {
$_REQUEST['delpic'] = (int) $_REQUEST['delpic'];
} else {
$_REQUEST['delpic'] = null;
}
//Bilder auslesen
list($pictures, $nextid) = $db->first("SELECT pictures,pictures_nextid FROM " . PRE . "_articles WHERE id='" . $_REQUEST['id'] . "'");
$pictures = unserialize($pictures);
if (!is_array($pictures)) {
$pictures = array();
}
//Bild löschen
if (isset($_REQUEST['delpic']) && isset($pictures[$_REQUEST['delpic']])) {
if ($_POST['delpic']) {
if (!checkToken()) {
printInvalidToken();
} else {
$picinfo = $pictures[$_REQUEST['delpic']];
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
if ($picinfo['thumbnail'] && file_exists(BASEDIR . getpath('uploads') . $picinfo['thumbnail'])) {
$mm->deletefile($picinfo['thumbnail']);
}
if ($picinfo['picture'] && file_exists(BASEDIR . getpath('uploads') . $picinfo['picture'])) {
$mm->deletefile($picinfo['picture']);
}
unset($pictures[$_REQUEST['delpic']]);
$db->query("UPDATE " . PRE . "_articles SET pictures='" . addslashes(serialize($pictures)) . "' WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
printJSRedirect('action.php?action=' . $_REQUEST['action'] . '&id=' . $_REQUEST['id'] . '&pubnow=' . $_REQUEST['pubnow'] . '&pageid=pics');
}
} else {
tmessageOverlay('picdel', array('ID' => $_REQUEST['id'], 'DELPIC' => $_REQUEST['delpic']));
}
} elseif ($_POST['send']) {
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
require_once BASEDIR . 'lib/class.image.php';
$img = new image();
//Bilder abarbeiten
for ($i = 1; $i <= 5; $i++) {
if (!$_FILES['upload' . $i]['tmp_name']) {
continue;
}
$ext = strtolower($mm->getext($_FILES['upload' . $i]['name']));
if ($ext == 'gif') {
$ext = 'jpg';
}
$newname = 'pic' . '-' . $_POST['id'] . '-' . $nextid . '.' . $ext;
$newfile = 'articles/gallery/' . $newname;
$thumbname = 'pic' . '-' . $_POST['id'] . '-' . $nextid . '-thumb.' . $ext;
$thumbfile = 'articles/gallery/' . $thumbname;
//Erfolgreichen Upload prüfen
if (!$mm->uploadfile($_FILES['upload' . $i], 'articles/gallery', $newname)) {
continue;
}
//Bild einlesen
list($picture, $picturetype) = $img->getimage($newfile);
//////// THUMBNAIL
$thumbnail = $img->resize($picture, $set['articles']['thumbwidth'], $set['articles']['thumbheight'], $set['articles']['artpic_quality']);
$img->saveimage($thumbnail, $picturetype, $thumbfile);
//////// BILD
//Bild skalieren
if ($picture !== false && !$_POST['noresize' . $i] && $set['articles']['picwidth'] && $set['articles']['picheight']) {
$scaled = $img->resize($picture, $set['articles']['picwidth'], $set['articles']['picheight'], $set['articles']['artpic_quality'], 0);
if ($scaled != $picture) {
imagedestroy($picture);
}
$picture = $scaled;
}
//Wasserzeichen einfügen
if ($picture !== false && $set['articles']['watermark'] && $_POST['watermark' . $i]) {
$watermarked = $img->watermark($picture, $set['articles']['watermark'], $set['articles']['watermark_position'], $set['articles']['watermark_transp']);
if ($watermarked != $picture) {
imagedestroy($picture);
}
$picture = $watermarked;
}
//Bild erstellen
$img->saveimage($picture, $picturetype, $newfile);
//Cleanup
imagedestroy($picture);
imagedestroy($thumbnail);
unset($picture, $thumbnail);
$pictures[$nextid] = array('picture' => $newfile, 'thumbnail' => $thumbfile);
++$nextid;
}
//Bilder eintragen
$db->query("UPDATE " . PRE . "_articles SET pictures='" . addslashes(serialize($pictures)) . "',pictures_nextid='" . intval($nextid) . "' WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
//Artikel beenden
if ($_POST['submit_finish']) {
$this->finish_article();
return;
} else {
printJSRedirect('action.php?action=' . $_REQUEST['action'] . '&id=' . $_REQUEST['id'] . '&pubnow=' . $_REQUEST['pubnow'] . '&pageid=pics');
}
} else {
echo '<h2>' . $apx->lang->get(iif($this->type == 'normal', 'ARTICLE', strtoupper($this->type))) . ': ' . $this->title . '</h2>';
//Bilderserie auflisten
foreach ($pictures as $id => $res) {
++$i;
$picdata[$i]['ID'] = $id;
$picdata[$i]['IMAGE'] = HTTPDIR . getpath('uploads') . $res['thumbnail'];
$picdata[$i]['LINK'] = HTTPDIR . getpath('uploads') . $res['picture'];
$picdata[$i]['OPTIONS'] .= optionHTMLOverlay('del.gif', $_REQUEST['action'], 'id=' . $_REQUEST['id'] . '&pageid=pics&delpic=' . $id . '&pubnow=' . $_REQUEST['pubnow'], $apx->lang->get('CORE_DEL'));
}
$apx->tmpl->assign('SET_WATERMARK', iif($set['articles']['watermark'], 1, 0));
$apx->tmpl->assign('SET_NORESIZE', iif($set['articles']['picwidth'] && $set['articles']['picheight'], 1, 0));
$apx->tmpl->assign('PIC', $picdata);
$apx->tmpl->assign('PUBNOW', (int) $_REQUEST['pubnow']);
$apx->tmpl->assign('ID', $_REQUEST['id']);
$apx->tmpl->assign('ACTION', iif($_REQUEST['action'] == 'articles.add', 'add', 'edit'));
$apx->tmpl->parse('pictures');
}
}
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE IF NOT EXISTS `apx_teaser` (\n\t\t `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n\t\t `secid` tinytext NOT NULL,\n\t\t `title` tinytext NOT NULL,\n\t\t `text` text NOT NULL,\n\t\t `image` tinytext NOT NULL,\n\t\t `link` tinytext NOT NULL,\n\t\t `group` tinyint(2) unsigned NOT NULL DEFAULT '1',\n\t\t `hits` int(11) unsigned NOT NULL DEFAULT '0',\n\t\t `ord` smallint(4) unsigned NOT NULL DEFAULT '0',\n\t\t `addtime` int(10) unsigned NOT NULL,\n\t\t `starttime` int(10) NOT NULL,\n\t\t `endtime` int(10) NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `addtime` (`addtime`),\n\t\t KEY `starttime` (`starttime`,`endtime`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('teaser', 'orderby', 'select', 'a:3:{i:1;s:12:\"{ORDERADMIN}\";i:2;s:10:\"{ORDERPUB}\";i:3;s:13:\"{ORDERRANDOM}\";}', '2', '', 1129897415, 1000),\n\t\t('teaser', 'groups', 'array', 'BLOCK', 'a:0:{}', '', 0, 0);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Ordner für Bilder
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('teaser');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_teaser`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//Zu 1.1.0
/*
$mysql="
";
function misc_mailform()
{
global $set, $db, $apx, $user;
if ($_SERVER['REQUEST_METHOD'] != 'POST') {
return;
}
if (!isset($set['formmailer']['sendto'][$_POST['sendto']])) {
die('sendto is not a valid mail-ID!');
}
$apx->lang->drop('sendform', 'formmailer');
//Zusätzliche Felder prüfen ob ausgefüllt
$addnl_failed = false;
foreach ($_POST as $key => $value) {
if (in_array($key, array('subject', 'sendto', 'copytome'))) {
continue;
}
if (substr($key, -9) != '_required') {
continue;
}
if (!$value) {
$addnl_failed = true;
}
}
//Absenden
if ($addnl_failed) {
message('back');
} else {
//Text erstellen
$text = '';
foreach ($_POST as $key => $value) {
if (in_array($key, array('subject', 'sendto', 'copytome'))) {
continue;
}
//Bei required-Feldern Namen kürzen
if (substr($key, -9) == '_required') {
$key = substr($key, 0, strlen($key) - 9);
}
$text .= $key . ': ' . $value . "\n";
}
//Betreff
if ($_POST['subject']) {
$subject = $_POST['subject'];
} else {
$subject = 'apexx Formmailer';
}
//Mediamanger initialisieren
$attachments = array();
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$temphash = md5(microtime());
//Dateien hochladen
if (is_array($_FILES) && count($_FILES)) {
foreach ($_FILES as $fileinfo) {
if (!$fileinfo['tmp_name']) {
continue;
}
if (!is_uploaded_file($fileinfo['tmp_name'])) {
continue;
}
$tempname = 'contact_' . $temphash . '_' . $fileinfo['name'] . '.tmp';
$mm->uploadfile($fileinfo, 'temp', $tempname);
$attachments[] = array('filename' => $fileinfo['name'], 'source' => $tempname, 'type' => $fileinfo['type']);
}
}
//Normale eMail senden
if (!count($attachments)) {
if ($set['main']['mailbotname']) {
$from = 'From:' . $set['main']['mailbotname'] . '<' . $set['main']['mailbot'] . '>';
} else {
$from = 'From:' . $set['main']['mailbot'];
}
$sendtomail = $set['formmailer']['sendto'][$_POST['sendto']];
mail($sendtomail, $subject, $text, $from);
} else {
$boundary = md5(uniqid(time()));
if ($set['main']['mailbotname']) {
$from = 'From:' . $set['main']['mailbotname'] . '<' . $set['main']['mailbot'] . '>';
} else {
$from = 'From:' . $set['main']['mailbot'];
}
$header = "MIME-Version: 1.0\n";
$header .= $from . "\n";
$header .= "Content-Type: multipart/mixed; boundary=\"" . $boundary . "\"\n";
$body = "--" . $boundary . "\n";
$body .= "Content-Type: text/plain\n";
$body .= "Content-Transfer-Encoding: 7bit\n\n";
$body .= $text . "\n\n";
//Dateianhänge codieren
$filedata = '';
foreach ($attachments as $source) {
$sourcepath = BASEDIR . getpath('uploads') . 'temp/' . $source['source'];
$filedata = fread(fopen($sourcepath, 'r'), filesize($sourcepath));
$body .= "--" . $boundary . "\n";
$body .= "Content-Type: " . $source['type'] . "; name=\"" . $source['filename'] . "\"\n";
$body .= "Content-Transfer-Encoding: base64\n";
$body .= "Content-Disposition: attachment; filename=\"" . $source['filename'] . "\"\n\n";
$body .= chunk_split(base64_encode($filedata));
$body .= "\n";
}
$body .= "--{$boundary}--\n";
//eMail abschicken
$sendtomail = $set['formmailer']['sendto'][$_POST['sendto']];
mail($sendtomail, $_POST['subject'], $body, $header);
//Anhänge vom Server löschen
foreach ($attachments as $tempfile) {
$mm->deletefile('temp/' . $tempfile['source']);
}
}
message($apx->lang->get('MSG_OK'), mklink('index.php', 'index.html'));
}
}
$threadIds = get_ids($data, 'threadid');
if ($threadIds) {
$db->query("UPDATE " . PRE . "_forum_posts SET del=0 WHERE threadid IN (" . implode(',', $threadIds) . ")");
}
$mysql = "\n\t\t\t\tALTER TABLE `apx_forums` ADD `stylesheet` TINYTEXT NOT NULL AFTER `inherit` ;\n\t\t\t\tALTER TABLE `apx_forum_threads` ADD `prefix` INT( 11 ) UNSIGNED NOT NULL AFTER `forumid` ;\n\t\t\t\tALTER TABLE `apx_forum_attachments` ADD `thumbnail` TINYTEXT NOT NULL AFTER `file` ; \n\t\t\t\tALTER TABLE `apx_forums` ADD `lastpost` INT( 11 ) UNSIGNED NOT NULL AFTER `children` ;\n\t\t\t\tALTER TABLE `apx_forums` ADD `lastthread` INT( 11 ) UNSIGNED NOT NULL AFTER `lastposttime` , ADD `lastthread_title` TINYTEXT NOT NULL AFTER `lastthread`, ADD `lastthread_icon` INT( 11 ) NOT NULL DEFAULT '-1' AFTER `lastthread_title` , ADD `lastthread_prefix` INT( 11 ) UNSIGNED NOT NULL AFTER `lastthread_icon` ;\n\t\t\t\t\n\t\t\t\tINSERT INTO `apx_cron` VALUES ('clean', 'forum', '86400', '1268002800', '');\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_forum_activity` (\n\t\t\t\t `userid` int(11) unsigned NOT NULL,\n\t\t\t\t `ip` int(11) unsigned NOT NULL,\n\t\t\t\t `type` enum('forum','thread') NOT NULL,\n\t\t\t\t `id` int(11) unsigned NOT NULL,\n\t\t\t\t `time` int(11) unsigned NOT NULL,\n\t\t\t\t `invisible` tinyint(1) unsigned NOT NULL,\n\t\t\t\t PRIMARY KEY (`userid`,`ip`,`type`,`id`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_forum_anndisplay` (\n\t\t\t\t `id` int(11) unsigned NOT NULL,\n\t\t\t\t `forumid` int(11) unsigned NOT NULL,\n\t\t\t\t PRIMARY KEY (`id`,`forumid`)\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_forum_announcements` (\n\t\t\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t `userid` int(11) unsigned NOT NULL,\n\t\t\t\t `title` varchar(255) NOT NULL default '',\n\t\t\t\t `text` text NOT NULL,\n\t\t\t\t `addtime` int(11) unsigned NOT NULL,\n\t\t\t\t `starttime` int(11) unsigned NOT NULL,\n\t\t\t\t `endtime` int(11) unsigned NOT NULL,\n\t\t\t\t `views` int(11) unsigned NOT NULL default '0',\n\t\t\t\t PRIMARY KEY (`id`),\n\t\t\t\t KEY `starttime` (`starttime`,`endtime`)\n\t\t\t\t) ENGINE=MyISAM ;\n\t\t\t\t\n\t\t\t\tCREATE TABLE `apx_forum_prefixes` (\n\t\t\t\t `prefixid` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t `forumid` int(11) unsigned NOT NULL,\n\t\t\t\t `title` tinytext NOT NULL,\n\t\t\t\t `code` tinytext NOT NULL,\n\t\t\t\t PRIMARY KEY (`prefixid`)\n\t\t\t\t) ENGINE=MyISAM ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Anhänge aktualisieren
$attachments = '';
$data = $db->fetch("\n\t\t\t\tSELECT id, file FROM\n\t\t\t\t" . PRE . "_forum_attachments\n\t\t\t");
if (count($data)) {
require BASEDIR . 'lib/class.mediamanager.php';
require BASEDIR . 'lib/class.image.php';
$mm = new mediamanager();
$img = new image();
foreach ($data as $res) {
$ext = strtolower($mm->getext($res['file']));
if (in_array($ext, array('gif', 'jpg', 'jpe', 'jpeg', 'png'))) {
$fileid = substr($res['file'], 0, -1 * (strlen($ext) - 1));
$thumbnailPath = $fileid . '_thumb.' . $ext;
list($picture, $picturetype) = $img->getimage($res['file']);
//////// THUMBNAIL
$thumbnail = $img->resize($picture, 120, 90, true);
$img->saveimage($thumbnail, $picturetype, $thumbnailPath);
//Cleanup
imagedestroy($picture);
imagedestroy($thumbnail);
unset($picture, $thumbnail);
//Update SQL
$captchafailed = $captcha->check();
}
if ($captchafailed) {
message($apx->lang->get('MSG_WRONGCODE'), 'javascript:history.back()');
} elseif (!$_POST['send_username'] && !$user->info['userid'] || !$_POST['catid'] || !$_POST['title'] || !$_POST['text'] || !$_FILES['file']['tmp_name']) {
message('back');
} elseif ($spam + $set['downloads']['spamprot'] * 60 > time()) {
message($apx->lang->get('MSG_BLOCKSPAM', array('SEC' => $spam + $set['downloads']['spamprot'] * 60 - time())), 'back');
} else {
$ext = substr(strrchr($_FILES['file']['name'], '.'), 1);
list($special) = $db->first("SELECT special FROM " . PRE . "_mediarules WHERE extension='" . strtoupper($ext) . "' LIMIT 1");
if ($special == 'block') {
message($apx->lang->get('MSG_NOTALLOWED'), 'back');
}
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$stamp = md5(microtime());
$mm->uploadfile($_FILES['file'], 'downloads/uploads', $stamp . '-' . $_FILES['file']['name']);
if ($user->info['userid']) {
$_POST['userid'] = $user->info['userid'];
$_POST['send_username'] = $_POST['send_email'] = '';
} else {
$_POST['userid'] = 0;
}
$_POST['file'] = $_FILES['file']['name'];
$_POST['tempfile'] = 'downloads/uploads/' . $stamp . '-' . $_FILES['file']['name'];
$_POST['addtime'] = time();
$_POST['send_ip'] = get_remoteaddr();
$_POST['local'] = 1;
$_POST['secid'] = 'all';
$_POST['text'] = strtr(strip_tags($_POST['text']), array("\r\n" => "<br />\r\n", "\n" => "<br />\n"));
| 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!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_gallery` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `secid` tinytext NOT NULL,\n\t\t `prodid` int(11) unsigned NOT NULL default '0',\n\t\t `title` tinytext NOT NULL,\n\t\t `description` text NOT NULL,\n\t\t `meta_description` text NOT NULL,\n\t\t `password` tinytext NOT NULL,\n\t\t `preview` tinytext NOT NULL,\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `starttime` int(11) unsigned NOT NULL default '0',\n\t\t `endtime` int(11) unsigned NOT NULL default '0',\n\t\t `lastupdate` INT( 10 ) UNSIGNED NOT NULL,\n\t\t `searchable` tinyint(1) unsigned NOT NULL default '0',\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL,\n\t\t `restricted` tinyint(1) unsigned NOT NULL,\n\t\t `parents` varchar(255) NOT NULL,\n\t\t `children` text NOT NULL,\n\t\t `ord` tinyint(3) NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `parents` (`parents`),\n\t\t KEY `starttime` (`starttime`,`endtime`,`parents`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_gallery_pics` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `galid` int(11) unsigned NOT NULL default '0',\n\t\t `thumbnail` tinytext NOT NULL,\n\t\t `picture` tinytext NOT NULL,\n\t\t `caption` tinytext NOT NULL,\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL default '1',\n\t\t `allowrating` tinyint(1) unsigned NOT NULL default '1',\n\t\t `active` tinyint(1) unsigned NOT NULL default '0',\n\t\t `potw` tinyint(1) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `galid` (`galid`,`active`),\n\t\t KEY `active` (`active`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_gallery_tags` (\n\t\t `id` int(11) unsigned NOT NULL,\n\t\t `tagid` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`,`tagid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('gallery', 'potw_time', 'int', 'BLOCK', '1249981414', '', 0, 0),\n\t\t\n\t\t('gallery', 'listepp', 'int', '', '5', 'VIEW', 1249816805, 1000),\n\t\t('gallery', 'galepp', 'int', '', '16', 'VIEW', 1249816805, 2000),\n\t\t('gallery', 'ordergal', 'select', 'a:3:{i:1;s:11:\"{ORDERTIME}\";i:2;s:12:\"{ORDERTITLE}\";i:3;s:12:\"{ORDERADMIN}\";}', '1', 'VIEW', 1249816805, 3000),\n\t\t('gallery', 'orderpics', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 'VIEW', 1249816805, 4000),\n\t\t('gallery', 'new', 'int', '', '3', 'VIEW', 1249816805, 5000),\n\t\t\n\t\t('gallery', 'searchable', 'switch', '', '1', 'OPTIONS', 1249816805, 1000),\n\t\t('gallery', 'subgals', 'switch', '', '1', 'OPTIONS', 1249816805, 2000),\n\t\t('gallery', 'coms', 'switch', '', '1', 'OPTIONS', 1249816805, 3000),\n\t\t('gallery', 'galcoms', 'switch', '', '1', 'OPTIONS', 1249816805, 3000),\n\t\t('gallery', 'ratings', 'switch', '', '1', 'OPTIONS', 1249816805, 4000),\n\t\t('gallery', 'potw_auto', 'switch', '', '0', 'OPTIONS', 1249816805, 5000),\n\t\t\n\t\t('gallery', 'addpics', 'int', '', '10', 'IMAGES', 1249816805, 1000),\n\t\t('gallery', 'picwidth', 'int', '', '640', 'IMAGES', 1249816805, 2000),\n\t\t('gallery', 'picheight', 'int', '', '480', 'IMAGES', 1249816805, 3000),\n\t\t('gallery', 'watermark', 'string', '', '', 'IMAGES', 1249816805, 4000),\n\t\t('gallery', 'watermark_transp', 'int', '', '50', 'IMAGES', 1249816805, 5000),\n\t\t('gallery', 'watermark_position', 'select', 'a:9:{i:1;s:18:\"{POSTOP} {POSLEFT}\";i:2;s:20:\"{POSTOP} {POSCENTER}\";i:3;s:19:\"{POSTOP} {POSRIGHT}\";i:4;s:21:\"{POSMIDDLE} {POSLEFT}\";i:5;s:23:\"{POSMIDDLE} {POSCENTER}\";i:6;s:22:\"{POSMIDDLE} {POSRIGHT}\";i:7;s:21:\"{POSBOTTOM} {POSLEFT}\";i:8;s:23:\"{POSBOTTOM} {POSCENTER}\";i:9;s:22:\"{POSBOTTOM} {POSRIGHT}\";}', '9', 'IMAGES', 1249816805, 6000),\n\t\t('gallery', 'thumbwidth', 'int', '', '120', 'IMAGES', 1249816805, 7000),\n\t\t('gallery', 'thumbheight', 'int', '', '90', 'IMAGES', 1249816805, 8000),\n\t\t('gallery', 'quality_resize', 'switch', '', '1', 'IMAGES', 1249816805, 9000),\n\t\t('gallery', 'popup', 'switch', '', '1', 'IMAGES', 1249816805, 10000),\n\t\t('gallery', 'popup_addwidth', 'int', '', '60', 'IMAGES', 1249816805, 12000),\n\t\t('gallery', 'popup_addheight', 'int', '', '150', 'IMAGES', 1249816805, 13000),\n\t\t('gallery', 'popup_resizeable', 'switch', '', '1', 'IMAGES', 1249816805, 14000);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('gallery');
$mm->createdir('uploads', 'gallery');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_gallery`;\n\t\tDROP TABLE `apx_gallery_pics`;\n\t\tDROP TABLE `apx_gallery_tags`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_gallery` ADD `endtime` INT( 11 ) UNSIGNED NOT NULL AFTER `starttime`;\n\t\t\t\tUPDATE `apx_gallery` SET endtime='3000000000' WHERE starttime!='0';\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
function del()
{
global $set, $db, $apx;
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if ($_POST['send'] == 1) {
if (!checkToken()) {
printInvalidToken();
} else {
$res = $db->first("SELECT newspic FROM " . PRE . "_news WHERE ( id='" . $_REQUEST['id'] . "' " . iif(!$apx->user->has_spright('news.del'), " AND userid='" . $apx->user->info['userid'] . "'") . " ) LIMIT 1");
$db->query("DELETE FROM " . PRE . "_news WHERE ( id='" . $_REQUEST['id'] . "' " . iif(!$apx->user->has_spright('news.del'), " AND userid='" . $apx->user->info['userid'] . "'") . " ) LIMIT 1");
if (!$db->affected_rows()) {
die('access denied!');
}
//Kommentare + Bewertungen löschen (nur wenn ein Eintrag gelöscht wurde -> User hat Recht dazu!)
if ($apx->is_module('comments')) {
$db->query("DELETE FROM " . PRE . "_comments WHERE ( module='news' AND mid='" . $_REQUEST['id'] . "' )");
}
if ($apx->is_module('ratings')) {
$db->query("DELETE FROM " . PRE . "_ratings WHERE ( module='news' AND mid='" . $_REQUEST['id'] . "' )");
}
//Bilder löschen
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$picture = $res['newspic'];
$poppic = str_replace('-thumb.', '.', $newspic);
if ($picture && file_exists(BASEDIR . getpath('uploads') . $picture)) {
$mm->deletefile($picture);
}
if ($poppic && file_exists(BASEDIR . getpath('uploads') . $poppic)) {
$mm->deletefile($poppic);
}
//Tags löschen
$db->query("DELETE FROM " . PRE . "_news_tags WHERE id='" . $_REQUEST['id'] . "'");
logit('NEWS_DEL', 'ID #' . $_REQUEST['id']);
printJSRedirect(get_index('news.show'));
}
} else {
list($title, $subtitle) = $db->first("SELECT title, subtitle FROM " . PRE . "_news WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
$apx->tmpl->assign('MESSAGE', $apx->lang->get('MSG_TEXT', array('TITLE' => compatible_hsc($title . ($subtitle ? ' - ' . $subtitle : '')))));
tmessageOverlay('deltitle', array('ID' => $_REQUEST['id']), '/');
}
}
| SOFTWARE BELONGS TO ITS AUTHORS! |
\***************************************************************/
//Security-Check
if (!defined('APXRUN')) {
die('You are not allowed to execute this file directly!');
}
//Installieren
if (SETUPMODE == 'install') {
$mysql = "\n\t\tCREATE TABLE `apx_news` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `secid` tinytext NOT NULL,\n\t\t `prodid` int(11) unsigned NOT NULL default '0',\n\t\t `catid` int(11) unsigned NOT NULL default '0',\n\t\t `userid` int(11) unsigned NOT NULL default '0',\n\t\t `send_username` tinytext NOT NULL,\n\t\t `send_email` tinytext NOT NULL,\n\t\t `send_ip` tinytext NOT NULL,\n\t\t `newspic` tinytext NOT NULL,\n\t\t `title` tinytext NOT NULL,\n\t\t `subtitle` tinytext NOT NULL,\n\t\t `teaser` text NOT NULL,\n\t\t `text` mediumtext NOT NULL,\n\t\t `galid` int(11) unsigned NOT NULL default '0',\n\t\t `meta_description` text NOT NULL,\n\t\t `links` text NOT NULL,\n\t\t `addtime` int(11) unsigned NOT NULL default '0',\n\t\t `starttime` int(11) unsigned NOT NULL default '0',\n\t\t `endtime` int(11) unsigned NOT NULL default '0',\n\t\t `top` tinyint(1) unsigned NOT NULL default '0',\n\t\t `sticky` int(11) unsigned NOT NULL default '0',\n\t\t `searchable` tinyint(1) unsigned NOT NULL default '0',\n\t\t `allowcoms` tinyint(1) unsigned NOT NULL default '1',\n\t\t `allowrating` tinyint(1) unsigned NOT NULL default '1',\n\t\t `restricted` tinyint(1) unsigned NOT NULL,\n\t\t `hits` int(11) unsigned NOT NULL default '0',\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `catid` (`catid`),\n\t\t KEY `userid` (`userid`),\n\t\t KEY `starttime` (`starttime`,`endtime`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_news_cat` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `title` tinytext NOT NULL,\n\t\t `icon` tinytext NOT NULL,\n\t\t `open` tinyint(1) unsigned NOT NULL default '1',\n\t\t `forgroup` tinytext NOT NULL,\n\t\t `parents` varchar(255) NOT NULL,\n\t\t `children` text NOT NULL,\n\t\t `ord` tinyint(3) NOT NULL,\n\t\t PRIMARY KEY (`id`),\n\t\t KEY `parents` (`parents`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_news_sources` (\n\t\t `id` int(11) unsigned NOT NULL auto_increment,\n\t\t `title` tinytext NOT NULL,\n\t\t `link` tinytext NOT NULL,\n\t\t PRIMARY KEY (`id`)\n\t\t) ENGINE=MyISAM ;\n\t\t\n\t\tCREATE TABLE `apx_news_tags` (\n\t\t `id` int(11) unsigned NOT NULL,\n\t\t `tagid` int(11) unsigned NOT NULL,\n\t\t PRIMARY KEY (`id`,`tagid`)\n\t\t) ENGINE=MyISAM;\n\t\t\n\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t('news', 'epp', 'int', '', '5', 'VIEW', 1249584889, 1000),\n\t\t('news', 'archiveepp', 'int', '', '5', 'VIEW', 1249584889, 2000),\n\t\t('news', 'archiveall', 'switch', '', '0', 'VIEW', 1249584889, 3000),\n\t\t('news', 'searchepp', 'int', '', '10', 'VIEW', 1249584889, 4000),\n\t\t('news', 'archivesort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '2', 'VIEW', 1249584889, 5000),\n\t\t('news', 'archiveentrysort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 'VIEW', 1249584889, 6000),\n\t\t\n\t\t('news', 'searchable', 'switch', '', '1', 'OPTIONS', 1249584889, 1000),\n\t\t('news', 'subcats', 'switch', '', '1', 'OPTIONS', 1249584889, 2000),\n\t\t('news', 'teaser', 'switch', '', '1', 'OPTIONS', 1249584889, 3000),\n\t\t('news', 'coms', 'switch', '', '1', 'OPTIONS', 1249584889, 4000),\n\t\t('news', 'ratings', 'switch', '', '1', 'OPTIONS', 1249584889, 5000),\n\t\t('news', 'archcoms', 'switch', '', '1', 'OPTIONS', 1249584889, 6000),\n\t\t('news', 'archratings', 'switch', '', '1', 'OPTIONS', 1249584889, 7000),\n\t\t('news', 'captcha', 'switch', '', '1', 'OPTIONS', 1249584889, 8000),\n\t\t('news', 'spamprot', 'int', '', '1', 'OPTIONS', 1249584889, 9000),\n\t\t('news', 'mailonnew', 'string', '', '', 'OPTIONS', 1249584889, 10000),\n\t\t\n\t\t('news', 'newspic_width', 'int', '', '120', 'IMAGES', 1249584889, 1000),\n\t\t('news', 'newspic_height', 'int', '', '120', 'IMAGES', 1249584889, 2000),\n\t\t('news', 'newspic_popup', 'switch', '', '1', 'IMAGES', 1249584889, 3000),\n\t\t('news', 'newspic_popup_width', 'int', '', '640', 'IMAGES', 1249584889, 4000),\n\t\t('news', 'newspic_popup_height', 'int', '', '480', 'IMAGES', 1249584889, 5000),\n\t\t('news', 'newspic_quality', 'switch', '', '1', 'IMAGES', 1249584889, 6000);\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Newsbilder-Ordner
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->createdir('news');
} elseif (SETUPMODE == 'uninstall') {
$mysql = "\n\t\tDROP TABLE `apx_news`;\n\t\tDROP TABLE `apx_news_cat`;\n\t\tDROP TABLE `apx_news_tags`;\n\t\tDROP TABLE `apx_news_sources`;\n\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_news` ADD `galid` INT( 11 ) UNSIGNED NOT NULL AFTER `text` ;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('news', 'subcats', 'switch', '', '1', '0', '150');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
list($precount) = $db->first("SELECT count(postid) FROM " . PRE . "_forum_posts WHERE ( threadid='" . $threadinfo['threadid'] . "' AND time<='" . $postinfo['time'] . "' )");
$page = ceil($precount / $user->info['forum_ppp']);
$link = str_replace('&', '&', mkrellink('thread.php?id=' . $threadinfo['threadid'] . '&p=' . $page . '#p' . $postinfo['postid'], 'thread,' . $threadinfo['threadid'] . ',' . $page . urlformat($threadinfo['title']) . '.html#p' . $postinfo['postid']));
header("HTTP/1.1 301 Moved Permanently");
header('Location: ' . $link);
exit;
}
}
///////////////////////////////////////////////////////////////////////////////////////////////// TPP SETZEN
if (intval($_POST['ppp']) && $user->info['userid']) {
$db->query("UPDATE " . PRE . "_user SET forum_ppp='" . intval($_POST['ppp']) . "' WHERE userid='" . $user->info['userid'] . "' LIMIT 1");
$user->info['forum_ppp'] = intval($_POST['ppp']);
}
///////////////////////////////////////////////////////////////////////////////////////// THEMA ANZEIGEN
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
//Views eins hochzählen
$db->query("UPDATE " . PRE . "_forum_threads SET views=views+1 WHERE threadid='" . $threadinfo['threadid'] . "' LIMIT 1");
//Seitenzahlen
list($count) = $db->first("SELECT count(postid) FROM " . PRE . "_forum_posts WHERE ( threadid='" . $threadinfo['threadid'] . "' )");
pages(mkrellink('thread.php?id=' . $threadinfo['threadid'] . iif($_REQUEST['highlight'], '&highlight=' . urlencode($_REQUEST['highlight'])), 'thread,' . $threadinfo['threadid'] . ',{P}' . urlformat($threadinfo['title']) . '.html' . iif($_REQUEST['highlight'], '?highlight=' . urlencode($_REQUEST['highlight']))), $count, $user->info['forum_ppp']);
//Thema als gelesen markieren (=auf der letzten Seite gewesen und es gibt neue Beiträge)
if ($_REQUEST['p'] == ceil($count / $user->info['forum_ppp']) && $threadinfo['lastposttime'] > $lastvisit) {
thread_isread($threadinfo['threadid']);
}
//Beiträge auslesen
$data = $db->fetch("SELECT * FROM " . PRE . "_forum_posts WHERE ( threadid='" . $threadinfo['threadid'] . "' ) ORDER BY time ASC " . getlimit($user->info['forum_ppp']));
//Anhänge auslesen
$postids = get_ids($data, 'postid');
$attinfo = array();
$attimage = array();
function gallery_pics_del()
{
global $set, $apx, $db, $html;
$_REQUEST['userid'] = (int) $_REQUEST['userid'];
$_REQUEST['galid'] = (int) $_REQUEST['galid'];
if (!$_REQUEST['galid']) {
die('missing GALID!');
}
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if ($_POST['send']) {
if (!checkToken()) {
printInvalidToken();
} else {
list($galid) = $db->first("SELECT id FROM " . PRE . "_user_gallery WHERE id='" . $_REQUEST['galid'] . "' LIMIT 1");
if (!$galid) {
die('access denied!');
}
list($picture, $thumbnail) = $db->first("SELECT picture,thumbnail FROM " . PRE . "_user_pictures WHERE id='" . $_REQUEST['id'] . "' AND galid='" . $_REQUEST['galid'] . "' LIMIT 1");
require_once BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
if ($picture && file_exists(BASEDIR . getpath('uploads') . $picture)) {
$mm->deletefile($picture);
}
if ($thumbnail && file_exists(BASEDIR . getpath('uploads') . $thumbnail)) {
$mm->deletefile($thumbnail);
}
$db->query("DELETE FROM " . PRE . "_user_pictures WHERE id='" . $_REQUEST['id'] . "' AND galid='" . $_REQUEST['galid'] . "' LIMIT 1");
logit('USER_GALLERYPIC_DEL', 'ID #' . $_REQUEST['id']);
printJSReload();
}
} else {
$input = array('ID' => $_REQUEST['id'], 'GALID' => $_REQUEST['galid'], 'USERID' => $_REQUEST['userid']);
tmessageOverlay('gallerypicdel', $input);
}
}
function del()
{
global $set, $db, $apx;
$_REQUEST['id'] = (int) $_REQUEST['id'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if ($_POST['send'] == 1) {
if (!checkToken()) {
infoInvalidToken();
} else {
list($image) = $db->first("SELECT image FROM " . PRE . "_affiliates WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->deletefile($image);
$db->query("DELETE FROM " . PRE . "_affiliates WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
logit('AFFILIATES_DEL', 'ID #' . $_REQUEST['id']);
printJSRedirect(get_index('affiliates.show'));
}
} else {
list($title) = $db->first("SELECT title FROM " . PRE . "_affiliates WHERE id='" . $_REQUEST['id'] . "' LIMIT 1");
$apx->tmpl->assign('MESSAGE', $apx->lang->get('MSG_TEXT', array('TITLE' => compatible_hsc($title))));
tmessageOverlay('del', array('ID' => $_REQUEST['id']));
}
}
$info = getimagesize(BASEDIR . getpath('uploads') . 'user/' . $newfile);
if ($info[0] > $set['user']['avatar_maxdim'] || $info[1] > $set['user']['avatar_maxdim'] || $info[0] == 0 || $info[1] == 0) {
$mm->deletefile('user/' . $newfile);
message($apx->lang->get('MSG_MAXDIM'), 'javascript:history.back()');
require 'lib/_end.php';
}
$db->query("UPDATE " . PRE . "_user SET avatar='" . addslashes($newfile) . "',avatar_title='" . addslashes($_POST['avatar_title']) . "' WHERE userid='" . $user->info['userid'] . "' LIMIT 1");
if ($user->info['avatar']) {
$mm->deletefile('user/' . $user->info['avatar']);
}
message($apx->lang->get('MSG_OK'), mklink('user.php?action=avatar', 'user,avatar.html'));
}
}
} elseif ($_POST['delav']) {
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->deletefile('user/' . $user->info['avatar']);
$db->query("UPDATE " . PRE . "_user SET avatar='',avatar_title='' WHERE userid='" . $user->info['userid'] . "' LIMIT 1");
message($apx->lang->get('MSG_OK'), mklink('user.php?action=avatar', 'user,avatar.html'));
} else {
$db->query("UPDATE " . PRE . "_user SET avatar_title='" . addslashes($_POST['avatar_title']) . "' WHERE userid='" . $user->info['userid'] . "' LIMIT 1");
message($apx->lang->get('MSG_OK'), mklink('user.php?action=avatar', 'user,avatar.html'));
}
} else {
if ($user->info['avatar']) {
$apx->tmpl->assign('CURRENT_AVATAR', $user->mkavatar($user->info));
$apx->tmpl->assign('CURRENT_TITLE', $user->mkavtitle($user->info));
}
$apx->tmpl->assign('MAX_DIMENSIONS', $set['user']['avatar_maxdim']);
$apx->tmpl->assign('MAX_FILESIZE', user_getsize($set['user']['avatar_maxsize'], 0));
$postto = mklink('user.php?action=avatar', 'user,avatar.html');
function pdel()
{
global $set, $db, $apx;
//Mehrere
if (is_array($_REQUEST['multiid'])) {
if (!checkToken()) {
printInvalidToken();
} else {
$cache = array_map('intval', $_REQUEST['multiid']);
if (!count($cache)) {
header("HTTP/1.1 301 Moved Permanently");
header('Location: ' . get_index('gallery.pshow'));
return;
}
if (count($cache)) {
$data = $db->fetch("SELECT galid,thumbnail,picture FROM " . PRE . "_gallery_pics WHERE ( id IN ( " . implode(',', $cache) . ") )");
$db->query("DELETE FROM " . PRE . "_gallery_pics WHERE ( id IN ( " . implode(',', $cache) . ") )");
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$galid = null;
//Bilder löschen
if (count($data)) {
foreach ($data as $res) {
$galid = $res['galid'];
$mm->deletefile($res['thumbnail']);
$mm->deletefile($res['picture']);
}
}
//Kommentare und Bewertungen löschen
if ($apx->is_module('comments')) {
$db->query("DELETE FROM " . PRE . "_comments WHERE ( module='gallery' AND mid IN ( " . implode(',', $cache) . " ) )");
}
if ($apx->is_module('ratings')) {
$db->query("DELETE FROM " . PRE . "_ratings WHERE ( module='gallery' AND mid IN ( " . implode(',', $cache) . " ) )");
}
foreach ($cache as $id) {
logit('GALLERY_PDEL', 'ID #' . $id);
}
//Galerie-Updatetime
if ($galid) {
$this->setGalleryUpdatetime($galid);
}
}
header("HTTP/1.1 301 Moved Permanently");
header('Location: ' . get_index('gallery.pshow'));
}
} else {
$_REQUEST['id'] = (int) $_REQUEST['id'];
$_REQUEST['gid'] = (int) $_REQUEST['gid'];
if (!$_REQUEST['id']) {
die('missing ID!');
}
if (!$_REQUEST['gid']) {
die('missing gallery ID!');
}
if ($_POST['send'] == 1) {
if (!checkToken()) {
printInvalidToken();
} else {
$res = $db->first("SELECT galid,thumbnail,picture FROM " . PRE . "_gallery_pics WHERE ( id='" . $_REQUEST['id'] . "' AND galid='" . $_REQUEST['gid'] . "' ) LIMIT 1");
$db->query("DELETE FROM " . PRE . "_gallery_pics WHERE ( id='" . $_REQUEST['id'] . "' AND galid='" . $_REQUEST['gid'] . "' ) LIMIT 1");
//Nur löschen, wenn der Muttereintrag wirklich gelöscht wurde!
if ($db->affected_rows()) {
//Bilder löschen
require BASEDIR . 'lib/class.mediamanager.php';
$mm = new mediamanager();
$mm->deletefile($res['thumbnail']);
$mm->deletefile($res['picture']);
//Kommentare und Bewertungen löschen
if ($apx->is_module('comments')) {
$db->query("DELETE FROM " . PRE . "_comments WHERE ( module='gallery' AND mid='" . $_REQUEST['id'] . "' )");
}
if ($apx->is_module('ratings')) {
$db->query("DELETE FROM " . PRE . "_ratings WHERE ( module='gallery' AND mid='" . $_REQUEST['id'] . "' )");
}
//Preview-Bild-Zuweisung löschen (falls vorhanden)
$db->query("UPDATE " . PRE . "_gallery SET preview='' WHERE preview='" . addslashes($res['thumbnail']) . "'");
//Galerie-Updatetime
$this->setGalleryUpdatetime($_REQUEST['gid']);
}
logit('GALLERY_PDEL', 'ID #' . $_REQUEST['id']);
printJSRedirect(get_index('gallery.pshow'));
}
} else {
$input['ID'] = $_REQUEST['id'];
$input['GID'] = $_REQUEST['gid'];
tmessageOverlay('pdel', $input);
}
}
}
