function deposit($userid, $value, $description = '')
{
global $db;
global $log;
$db->insert($this->table, array("userid", "timestamp", "description", "value"), array((int) $userid, time(), "'" . secureMySQL($description) . "'", (int) $value));
$log->add('credit', 'increased balance of user ' . $userid . ' by ' . $value . ' (currency)');
}
function registerFile($file)
{
global $db;
$c = $db->num_rows($this->table, "`file`='" . secureMySQL($file) . "'");
if ($c == 0) {
$db->insert($this->table, array('file'), array("'" . secureMySQL($file) . "'"));
}
}
function addClanPrefix($userid, $prefix)
{
global $db, $config;
if ($config->get('clan', 'enable-prefix') == '1') {
$sep = $config->get('clan', 'prefix-seperator');
$oldnick = $db->selectOne('users', 'nickname', "`userid`=" . (int) $userid);
$newnick = secureMySQL($prefix) . $sep . $oldnick;
$db->update('users', "`nickname`='" . $newnick . "'", "`userid`=" . (int) $userid);
}
}
function add($mod, $description)
{
global $login;
if ($this->file_enabled == 1) {
$h = fopen($this->path, 'a');
fwrite($h, '[ ' . date("d.m.Y") . " | " . date("H:i.s") . " ] userid = " . $this->makeSpace($login->currentUserID(), 4) . " mod = " . $this->makeSpace($mod, 14) . " " . $description . "\r\n");
fclose($h);
}
if ($this->mysql_enabled == 1) {
global $db;
$db->insert($this->table, array('userid', 'timestamp', 'mod', 'description'), array($login->currentUserID(), time(), "'" . secureMySQL($mod) . "'", "'" . secureMySQL($description) . "'"));
}
}
function makeNews(&$comments, &$db, $table, $tbl_users, $start, $end, $title)
{
global $lng;
$news = '';
$result = $db->query("SELECT * FROM `" . $table . "`, `" . $tbl_users . "`\r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE `" . $table . "`.`userid` = `" . $tbl_users . "`.`userid` \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND `timestamp`>" . $start . " \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND `timestamp`<" . $end . " \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND (`language` = '" . secureMySQL($lng) . "' OR `language` = '')\r\n\t\t\t\t\t\t\t\t\t\t\t\tAND (`domainid` = 0 OR `domainid` = " . getCurrentDomainIndex() . ")\r\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY `timestamp` DESC;");
while ($row = mysql_fetch_assoc($result)) {
$row['time'] = timeElapsed($row['timestamp']);
$row['url'] = makeURL('news', array('newsid' => $row['newsid']));
$row['text'] = stripslashes($row['text']);
$row['title'] = stripslashes($row['title']);
$row['user_url'] = makeURL('profile', array('userid' => $row['userid']));
$row['comments'] = $comments->count('news', $row['newsid']);
$news[] = $row;
}
return array('title' => $title, 'news' => $news, 'news_count' => mysql_num_rows($result));
}
function getConfigList($mod)
{
$sql = "SELECT * FROM `" . $this->table . "` WHERE `mod`='" . secureMySQL($mod) . "' ORDER BY `key` ASC;";
$result = $this->db->query($sql);
while ($row = mysql_fetch_assoc($result)) {
if ($row['type'] == 'list') {
$pos = strpos($row['description'], '|');
if ($pos !== false) {
$row['list'] = explode(',', substr($row['description'], $pos + 1));
$row['description'] = substr($row['description'], 0, $pos);
}
}
$o[] = $row;
$pos = 0;
}
return $o;
}
function doLogin($email, $password, $save_login, $period = 86400)
{
global $log;
global $config;
global $user;
$email = secureMySQL($email);
if ($this->passwordValid($email, $password)) {
$u = $user->getUserByEmail($email);
if ($u['activated'] == 1 || $config->get('login', 'register-activation-required') == 0) {
$_SESSION['email'] = $email;
$_SESSION['password'] = $password;
if ($save_login == '1' && $config->get('core', 'save-login-disabled') == 0) {
setcookie('hfh_email', $email, time() + 31536000);
setcookie('hfh_password', $password, time() + 31536000);
}
$log->add('login', 'valid login by ' . $email);
return true;
}
} else {
$log->add('login', 'login by ' . $email . ' failed');
return false;
}
}
$search = '/(' . $item . ')/i';
$replace = '<span style="background-color:#FFD800;">$1</span>';
$haystack = preg_replace($search, $replace, $haystack);
}
return $haystack;
}
foreach ($engines as $e) {
if ($e['key'] == '' || $e['key'] == 'users' || $this->isInstalled($e['key'])) {
$t['key'] = $e['key'];
$t['name'] = $e['name'];
$engines2[] = $t;
}
}
$smarty->assign('engines', $engines2);
@$smarty->assign('engine', $_GET['engine']);
@($search_string = trim(secureMySQL($_GET['q'])));
$smarty->assign('search_string', $search_string);
if (strlen($search_string) >= 3 || $search_string == '') {
// Search button has been pressed
if ((isset($_GET['find']) || isset($_GET['find_x']) || isset($_GET['q'])) && count($engines) > 0 && $search_string != '') {
$results = array();
if (@$_GET['engine'] == '') {
foreach ($engines as $i => $e) {
if ($e['key'] == 'users' || $this->isInstalled($e['key'])) {
if ($e['key'] != '') {
require_once $mod_dir . "/engines/" . $e['file'];
$result = call_user_func($e['key'], $search_string);
if (count($result) > 0) {
$results = array_merge($results, $result);
}
}
<?php
$tbl_users = MYSQL_TABLE_PREFIX . 'users';
$tbl_register = MYSQL_TABLE_PREFIX . 'register';
$event = $db->selectOneRow($tbl_register, "*", "eventid=" . (int) $_GET['eventid']);
$result = $db->query("SELECT * FROM `" . $tbl_users . "` AS U \r\n\t\t\t\t\tWHERE \r\n\t\t\t\t\t(INSTR(U.`nickname`, '" . secureMySQL($_GET['search_string']) . "') > 0\r\n\t\t\t\t\tOR INSTR(U.`prename`, '" . secureMySQL($_GET['search_string']) . "') > 0\r\n\t\t\t\t\tOR INSTR(U.`lastname`, '" . secureMySQL($_GET['search_string']) . "') > 0)\r\n\t\t\t\t\tLIMIT 5;");
while ($row = mysql_fetch_assoc($result)) {
$dummy = $row;
$registered = $db->selectOneRow($tbl_register, '*', "userid=" . $dummy['userid'] . " AND eventid=" . (int) $_GET['eventid']);
$dummy['reserve'] = (@$event['free'] == 1 or $registered['payed'] > 0);
$dummy['sitdown'] = $registered['appeared'] != 0;
$l[] = $dummy;
}
$lang->addModSpecificLocalization('room');
$smarty->assign('seatable', $lang->get('seatable'));
$smarty->assign('search_string', $_GET['search_string']);
$smarty->assign('list', @$l);
$smarty->display('../mod/default/room/userlist.tpl');
if (count($c) > 0) {
foreach ($c as $question) {
// delete?
if ($_POST['delete_' . $question['id']] == "1") {
$db->query("DELETE FROM " . $table . " WHERE id=" . intval($question['id']));
} else {
$db->query("UPDATE " . $table . " SET faqorder=" . intval($_POST['order_' . $question['id']]) . " WHERE id=" . intval($question['id']));
}
}
}
// add new element
} elseif (isset($_POST['submit'])) {
if ($_POST['sid'] > 0) {
$db->query("UPDATE " . $table . " SET faqorder=" . intval($_POST['new_order']) . ", question='" . secureMySQL($_POST['new_question']) . "', answer='" . secureMySQL($_POST['new_answer']) . "' WHERE id=" . intval($_POST['sid']));
} else {
$db->query("INSERT INTO " . $table . " VALUES (NULL,'" . intval($_POST['new_order']) . "','" . secureMySQL($_POST['new_question']) . "','" . secureMySQL($_POST['new_answer']) . "')");
}
//EDIT Element
} elseif (isset($_GET['edit'])) {
$edit = $db->selectOneRow($table, "*", "id=" . intval($_GET['edit']));
$smarty->assign('edit', $edit);
}
// get questions
$rows = $db->selectList($table, '*', 'true', '');
if ($rows) {
foreach ($rows as $row) {
$row['edit'] = makeURL($mod, array('mode' => 'admin', 'edit' => $row['id']));
$list[] = $row;
}
$smarty->assign('list', $list);
}
function activate($key)
{
global $notify;
global $lang;
$sql = "UPDATE `" . $this->table . "` SET `activated`=1 WHERE `activation_key`='" . secureMySQL($key) . "';";
$this->db->query($sql);
$notify->add($lang->get('login'), $lang->get('account_activated'));
}
<?php
@($score = (int) $_GET['score']);
@($lines = (int) $_GET['lines']);
@($level = (int) $_GET['level']);
@($nick = secureMySQL($_GET['nickname']));
@($field = secureMySQL($_GET['field']));
$db->insert('tetris_chat', array('type', 'nickname', 'text'), array(1, "'" . $nick . "'", "'died.'"));
$db->update('tetris_player', "`field`='" . $field . "'", "`nickname`='" . $nick . "'");
if ($db->num_rows('tetris_player', '`alive` > 0') == 2) {
$winner = $db->selectOneRow('tetris_player', '*', "`alive`=1 && `nickname`!='" . $nick . "'");
$db->insert('tetris_chat', array('type', 'nickname', 'text'), array('1', "'" . $winner['nickname'] . "'", "'[Wins!]'"));
$db->update('tetris_player', '`wins`=`wins`+1', "`nickname`='" . $winner['nickname'] . "'");
}
if ($score < 100) {
die;
}
$user = $db->selectOneRow('tetris_player', '*', "`nickname`= '" . $nick . "'");
// validate if the reported highscore could be possible
if ($level - 1 > $user['level'] || $score * 0.8 > $user['score']) {
die;
}
$db->insert(MYSQL_TABLE_PREFIX . 'tetris_highscore', array('nickname', 'score', 'lines', 'level', 'timestamp'), array("'" . $nick . "'", $score, $lines, $level, time()));
$log->add($mod, 'content ' . $_GET['key'] . ' updated');
$smarty->assign('locked', true);
unset($_GET['version']);
redirect(makeURL($mod, array('mode' => 'content', 'action' => 'edit', 'key' => $_GET['key'])));
} else {
$notify->add($lang->get('error'), $lang->get('content_error'));
}
}
$ver = isset($_GET['version']) ? (int) $_GET['version'] : -1;
$page = $content->getPage($_GET['key'], $ver);
if ($ver == -1) {
$ver = $page['version'];
}
@$smarty->assign('selected_version', $ver);
$smarty->assign('content', $page);
$assigned_groups = array_row($db->selectList('content_permissions', '*', "`key`='" . secureMySQL($_GET['key']) . "'"), 'groupid');
$smarty->assign('permissions', $assigned_groups);
$breadcrumbs->addElement($page['title'], makeURL($_GET['key']));
$breadcrumbs->addElement($lang->get('edit'), makeURL($mod, array('mode' => 'content', 'action' => 'edit', 'key' => $_GET['key'])));
$smarty->assign('path', $template_dir . "/content.edit.tpl");
break;
case 'remove':
if (isset($_POST['yes'])) {
$content->removePage($_GET['key']);
$notify->add($lang->get('content'), $lang->get('content_removed'));
$log->add($mod, 'content ' . $_GET['key'] . ' removed');
} else {
$breadcrumbs->addElement($lang->get('remove'), makeURL($mod, array('mode' => 'content', 'action' => 'remove', 'key' => $_GET['key'])));
$smarty->assign('url_no', makeURL($mod, array('mode' => 'content')));
$smarty->assign('path', $template_dir . "/content.remove.tpl");
break;
// save new data
$start_date = @explode("/", $_POST['start_date']);
$end_date = @explode("/", $_POST['end_date']);
$start = mktime((int) $_POST['start_Hour'], (int) $_POST['start_Minute'], 0, (int) $start_date[0], (int) $start_date[1], (int) $start_date[2]);
$end = mktime((int) $_POST['end_Hour'], (int) $_POST['end_Minute'], 0, (int) $end_date[0], (int) $end_date[1], (int) $end_date[2]);
$fifteen_min = 15 * 60;
if ($end - $start < $fifteen_min) {
$end = $end + $fifteen_min;
}
if (count($start_date) == 3 && count($end_date) == 3 && trim($_POST['title']) != '') {
if ($start >= $end) {
$tmp = $start;
$start = $end;
$end = $tmp;
}
$db->update($tbl, "`title`='" . secureMySQL($_POST['title']) . "',\r\n\t\t\t\t\t\t\t\t\t`start`=" . $start . ", `end`=" . $end . ", `visible`=" . (int) $_POST['visibility'] . ",\r\n\t\t\t\t\t\t\t\t\t`description`='" . secureMySQL($_POST['description']) . "',\r\n\t\t\t\t\t\t\t\t\t`language`='" . secureMySQL($_POST['language']) . "',\r\n\t\t\t\t\t\t\t\t\t`categoryId`='" . secureMySQL((int) $_POST['category']) . "'", "`calendarid`=" . $calendarid);
writeExport();
redirect(makeURL($mod, array('day' => $start, 'view' => $view)));
} else {
$notify->add($lang->get('calendar'), $lang->get('new_calendar_entry_fill'));
}
$entry['title'] = $_POST['title'];
$entry['start'] = $start;
$entry['start_date'] = $_POST['start_date'];
$entry['end'] = $end;
$entry['end_date'] = $_POST['end_date'];
$entry['description'] = $_POST['description'];
$entry['visible'] = $_POST['visibility'];
$entry['category'] = $_POST['category'];
redirect(makeURL($mod));
}
function CreateAll($coursename, $dummypassword, $defaultpassword)
{
global $db;
if (trim($coursename) == "") {
$coursename = "DEMO";
}
if (trim($dummypassword) == "") {
$dummypassword = "******";
}
if (trim($defaultpassword) == "") {
$defaultpassword = "******";
}
$dummypassword = generatePasswordHash(secureMySQL($dummypassword));
$defaultpassword = generatePasswordHash(secureMySQL($defaultpassword));
$dayofweek = date("w");
$offset = 0;
if ($dayofweek == 0) {
$offset = 1;
} else {
$offset = 1 - $dayofweek;
}
$date_monday_day = date("d") + $offset;
$date_monday_month = date("m");
$date_monday_year = date("Y");
//
// Users
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "users` (\r\n\t\t\t `userid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `email` varchar(64) NOT NULL,\r\n\t\t\t `password` varchar(256) NOT NULL,\r\n\t\t\t `ipadress` varchar(16) NOT NULL,\r\n\t\t\t `session_id` varchar(26) NOT NULL,\r\n\t\t\t `nickname` varchar(64) NOT NULL,\r\n\t\t\t `lastname` varchar(64) NOT NULL,\r\n\t\t\t `prename` varchar(64) NOT NULL,\r\n\t\t\t `birthday` int(11) NOT NULL,\r\n\t\t\t `regdate` int(11) NOT NULL,\r\n\t\t\t `lastaction` int(11) NOT NULL,\r\n\t\t\t `template` varchar(64) NOT NULL,\r\n\t\t\t `comment` varchar(256) NOT NULL,\r\n\t\t\t `avatar` varchar(128) NOT NULL,\r\n\t\t\t `ban` int(1) NOT NULL,\r\n\t\t\t `activated` int(1) NOT NULL,\r\n\t\t\t `activation_key` varchar(64) NOT NULL,\r\n\t\t\t `company` varchar(255) NOT NULL,\r\n\t\t\t `address` varchar(1023) NOT NULL,\r\n\t\t\t PRIMARY KEY (`userid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "users` (`userid`, `email`, `password`, `ipadress`, `session_id`, `nickname`, `lastname`, `prename`, `birthday`, `regdate`, `lastaction`, `template`, `comment`, `avatar`, `ban`, `activated`, `activation_key`, `company`, `address`) VALUES\r\n\t\t\t(1, '*****@*****.**', 'e84bf3942a3e99072042e5802b432db4', '141.31.111.1', '82csg28ufsm4vjl2gog4moepq2', 'Admin', 'Admin', 'Anton', 1307211898, 1338834298, 1339666825, '', '', '', 0, 1, 'c9815d89c450ec319a6ca10cb1aaf36f', '', ''),\r\n\t\t\t(2, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Bea', 'Brünette', 'Beate', 575848800, 1338834963, 0, '', '', '', 0, 1, 'e1809f5df02e911190c3aca0df3d0f12', '', ''),\r\n\t\t\t(3, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', '82csg28ufsm4vjl2gog4moepq2', 'Chuck', 'Cnorris', 'Chuck', 541378800, 1338835024, 1339666644, '', '', '3_4fd99ec8696e0_Unbenannt.jpg', 0, 1, 'cded8b60591ea885b103e3d8862e4e3c', '', ''),\r\n\t\t\t(4, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Emilia', 'Echo', 'Emilia', 630889200, 1338835144, 1339661050, '', '', '', 0, 1, '11c258d467d42442282f2f6db4aa8039', '', ''),\r\n\t\t\t(5, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Freddy', 'Feuerstein', 'Fred', 654213600, 1338835184, 1339662325, '', '', '5_4fd99bfaa7cc8_fred-feuerstein.jpg', 0, 1, '13488a0bad56932c32ac3af580cee0af', '', ''),\r\n\t\t\t(6, '*****@*****.**', '" . $dummypassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Gabi', 'Gans', 'Gabriella', 593046000, 1338835237, 1339660668, '', '', '', 0, 1, '25fbe2530a483980c6a26750f84af6a7', '', ''),\r\n\t\t\t(7, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Hansi', 'Halblang', 'Hans', 637974000, 1338835341, 0, '', '', '', 0, 1, 'ff6d745040c13dd6502a1720b6c54b97', '', ''),\r\n\t\t\t(8, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Isabella', 'Isnichdeinernst', 'Isabella', 691542000, 1338835404, 0, '', '', '', 0, 1, 'bff8c6f1744f6f191f26bcddb9ac3d1e', '', ''),\r\n\t\t\t(9, '*****@*****.**', '" . $defaultpassword . "', '', '', 'James', 'Johnson', 'James', 576885600, 1338835449, 0, '', '', '', 0, 1, '4c0c02cdbe5af455ca579ca1a6dc2b55', '', ''),\r\n\t\t\t(10, '*****@*****.**', '" . $dummypassword . "', '', '', 'Kirsten', 'Kurssprecher', 'Kirsten', " . mktime(0, 0, 0, date('m'), date('d'), date('Y')) . ", 1338835509, 0, '', '', '', 0, 1, '63862d42b3bbed8b931b18d929a149c3', '', ''),\r\n\t\t\t(11, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Logan', 'Lonesome', 'Logan', 476233200, 1338835772, 1339662221, '', '', '11_4fd99db67fa6e_Hugh Jackman Wolverine 02.jpg', 0, 1, 'a78b71f4fe4cc1041dba8c7834720e2c', '', ''),\r\n\t\t\t(12, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Marvin', 'Melancholie', 'Marvin', 653349600, 1338835843, 1339661465, '', '', '12_4fd99c7022261_Marvin.jpg-675x550.jpg', 0, 1, '357f0737b7ff12cd57609f8d2bc4301d', '', ''),\r\n\t\t\t(13, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Naomi', 'Niedlich', 'Naomi', 650844000, 1338835889, 0, '', '', '', 0, 1, 'dd07114fc108a36ad1a2cc2d67d3f6d0', '', ''),\r\n\t\t\t(14, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Otto', 'Otter', 'Otto', -870314400, 1338835915, 1339661282, '', '', '14_4fd99b7f44936_zeichenkurs0.jpg', 0, 1, 'd11d99c5eea51a7233e32c9277288e58', '', ''),\r\n\t\t\t(15, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Paul', 'Paulson', 'Paul', 589500000, 1338835958, 0, '', '', '', 0, 1, 'b2aa1970af9eea73d83dc80a436d5091', '', ''),\r\n\t\t\t(16, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Quasi', 'Quast', 'Quasimodo', 608248800, 1338836001, 0, '', '', '', 0, 1, '75d330a257767e968bfddfcd774e3af9', '', ''),\r\n\t\t\t(17, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Raúl', 'Rasmus', 'Raúl', 507855600, 1338836077, 0, '', '', '', 0, 1, 'd67b9f5fbd7e4bf495774f7f4228bf04', '', ''),\r\n\t\t\t(18, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Sunny', 'Sweetheart', 'Sonja', 518306400, 1338836141, 0, '', '', '', 0, 1, 'cce3be584d67c013d94c499129c2bd11', '', ''),\r\n\t\t\t(19, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Tobi', 'Tester', 'Tobi', 529714800, 1338836209, 0, '', '', '', 0, 1, '6b3f7abdc63e1cd28bf919d62444eb9e', '', ''),\r\n\t\t\t(20, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Uwe', 'Underdog', 'Uwe', 525132000, 1338836262, 0, '', '', '', 0, 1, '450a9825737b333e7cec7812f0c2a081', '', ''),\r\n\t\t\t(21, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Van Helsing', 'van Helsing', 'Victor', 604796400, 1338836313, 1339662299, '', '', '21_4fd99d9725f85_van helsing foto.jpg', 0, 1, '124f4953560f96b00b129594918bd7e8', '', ''),\r\n\t\t\t(22, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Xaver', 'Xelsbrot', 'Xaver', -870314400, 1338836349, 0, '', '', '', 0, 1, 'a3e00aec25f47e4ef01658f3eb261099', '', ''),\r\n\t\t\t(23, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Yasmin', 'Yoga', 'Yasmin', 699404400, 1338836384, 0, '', '', '', 0, 1, '54812144089e2c695e07b00537def9b4', '', ''),\r\n\t\t\t(24, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Zooey', 'Zoom', 'Zooey', -870314400, 1338836412, 0, '', '', '', 0, 1, '27d0482a650a922546139161c25e767d', '', ''),\r\n\t\t\t(25, '*****@*****.**', '" . $defaultpassword . "', '141.31.111.1', 'o2hofj4unl8e6i6nlbi5coa8o1', 'Dago', 'Duck', 'Dagobert', 707263200, 1338836483, 1339661671, '', '', '25_4fd99cf3cb994_26868_1.jpg', 0, 1, '21c9805772a0eb5fe78afa1e1c87f8a8', '', ''),\r\n\t\t\t(26, '*****@*****.**', '" . $defaultpassword . "', '', '', 'Warrio', 'W. Waster', 'Warrio', -870314400, 1338836810, 0, '', '', '', 0, 1, '6229a376c9bb44e19885098e8879bc0e', '', '')";
$db->query($sql);
//
// Board
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "board` (\r\n\t\t\t\t `boardid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `board` varchar(64) NOT NULL,\r\n\t\t\t\t `order` int(11) NOT NULL,\r\n\t\t\t\t `description` varchar(64) NOT NULL,\r\n\t\t\t\t `assigned_groupid` int(11) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`boardid`)\r\n\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "board` (`boardid`, `board`, `order`, `description`, `assigned_groupid`) VALUES\r\n\t\t\t\t(1, 'Talk', 1, 'Alles mögliche...', 0),\r\n\t\t\t\t(2, 'Klausuren', 2, 'Übungen, Informationen,...', 0),\r\n\t\t\t\t(3, 'Events', 4, 'WG Parties, Wasen,...', 0),\r\n\t\t\t\t(4, 'Vorlesungen', 3, 'Vorlesungsmaterial', 0);";
$db->query($sql);
//
// Boxes
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "boxes` (\r\n\t\t\t `boxid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `title` varchar(63) NOT NULL,\r\n\t\t\t `file` varchar(255) NOT NULL,\r\n\t\t\t `position` varchar(6) NOT NULL,\r\n\t\t\t `order` int(11) NOT NULL,\r\n\t\t\t `visible` int(1) NOT NULL,\r\n\t\t\t `requires_login` int(1) NOT NULL,\r\n\t\t\t `domainid` int(11) NOT NULL,\r\n\t\t\t PRIMARY KEY (`boxid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "boxes` (`boxid`, `title`, `file`, `position`, `order`, `visible`, `requires_login`, `domainid`) VALUES\r\n\t\t\t\t(1, 'Umfragen', 'poll', 'left', 0, 1, 1, 0),\r\n\t\t\t\t(5, 'Forum', 'board', 'right', 0, 1, 1, 0),\r\n\t\t\t\t(4, 'Vorlesungsplan', 'calendar', 'left', 1, 1, 1, 0),\r\n\t\t\t\t(6, 'Shoutbox', 'shoutbox', 'right', 1, 1, 1, 0);";
$db->query($sql);
//
// Calendar
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "calendar` (\r\n\t\t\t `calendarid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `start` int(11) NOT NULL,\r\n\t\t\t `end` int(11) NOT NULL,\r\n\t\t\t `title` varchar(1023) NOT NULL,\r\n\t\t\t `description` text NOT NULL,\r\n\t\t\t `visible` int(1) NOT NULL,\r\n\t\t\t `language` varchar(4) NOT NULL,\r\n\t\t\t `categoryId` int(10) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`calendarid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "calendar` (`calendarid`, `userid`, `start`, `end`, `title`, `description`, `visible`, `language`, `categoryId`) VALUES\r\n\t\t\t(1, 1, " . mktime(9, 0, 0, $date_monday_month, $date_monday_day, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(12, 15, 0, $date_monday_month, $date_monday_day, $date_monday_year) . ",\r\n\t\t\t\t\t'Mathematik', '', 2, '', 2),\r\n\t\t\t(2, 1, " . mktime(13, 0, 0, $date_monday_month, $date_monday_day, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(16, 45, 0, $date_monday_month, $date_monday_day, $date_monday_year) . ", \r\n\t\t\t\t 'Mathematik', '', 2, '', 2),\r\n\t\t\t(3, 1, " . mktime(9, 0, 0, $date_monday_month, $date_monday_day + 1, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(12, 15, 0, $date_monday_month, $date_monday_day + 1, $date_monday_year) . ", \r\n\t\t\t\t 'ABWL', '', 2, '', 2),\r\n\t\t\t(4, 1, " . mktime(17, 0, 0, $date_monday_month, $date_monday_day + 1, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(20, 00, 0, $date_monday_month, $date_monday_day + 1, $date_monday_year) . ", \r\n\t\t\t\t 'Wasen', 'Treffpunkt bei dem Mann mit der roten Giraffe.', 2, '', 4),\r\n\t\t\t(5, 1, " . mktime(13, 0, 0, $date_monday_month, $date_monday_day + 1, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(16, 30, 0, $date_monday_month, $date_monday_day + 1, $date_monday_year) . ",\r\n\t\t\t\t 'Recht', '', 2, '', 2),\r\n\t\t\t(6, 1, " . mktime(13, 0, 0, $date_monday_month, $date_monday_day + 2, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(16, 30, 0, $date_monday_month, $date_monday_day + 2, $date_monday_year) . ",\r\n\t\t\t\t 'Mathe Tutorium', '', 2, '', 3),\r\n\t\t\t(7, 1, " . mktime(14, 0, 0, $date_monday_month, $date_monday_day + 2, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(17, 00, 0, $date_monday_month, $date_monday_day + 2, $date_monday_year) . ",\r\n\t\t\t\t 'ABWL Tutorium', '', 2, '', 3),\r\n\t\t\t(8, 1, " . mktime(9, 0, 0, $date_monday_month, $date_monday_day + 2, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(12, 15, 0, $date_monday_month, $date_monday_day + 2, $date_monday_year) . ", \r\n\t\t\t\t 'Spanisch', '', 2, '', 3),\r\n\t\t\t(9, 1, " . mktime(9, 0, 0, $date_monday_month, $date_monday_day + 3, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(12, 0, 0, $date_monday_month, $date_monday_day + 3, $date_monday_year) . ",\r\n\t\t\t\t 'Soziale Kompetenzen', '', 2, '', 2),\r\n\t\t\t(10, 1, " . mktime(9, 0, 0, $date_monday_month, $date_monday_day + 4, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(12, 15, 0, $date_monday_month, $date_monday_day + 4, $date_monday_year) . ",\r\n\t\t\t\t 'Grundlegende Technologien zur Entwickung künstlich gesteuerter Massageroboter', '', 2, '', 2),\r\n\t\t\t(11, 1, " . mktime(13, 0, 0, $date_monday_month, $date_monday_day + 4, $date_monday_year) . ", \r\n\t\t\t\t " . mktime(16, 30, 0, $date_monday_month, $date_monday_day + 4, $date_monday_year) . ",\r\n\t\t\t\t 'Fortgeschrittene Technologien zur Entwickung künstlich gesteuerter Massageroboter', '', 2, '', 2);";
$db->query($sql);
//
// Calendar_Categories
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "calendar_categories` (\r\n\t\t\t `categoryId` int(10) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `title` varchar(100) NOT NULL,\r\n\t\t\t `backgroundcolor` varchar(10) NOT NULL,\r\n\t\t\t `fontcolor` varchar(10) NOT NULL,\r\n\t\t\t `description` varchar(1023) NOT NULL,\r\n\t\t\t PRIMARY KEY (`categoryId`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "calendar_categories` (`categoryId`, `title`, `backgroundcolor`, `fontcolor`, `description`) VALUES\r\n\t\t\t(2, 'Pflichtvorlesung', '#6b6b6b', '#000000', ''),\r\n\t\t\t(3, 'Freiwillige Vorlesung', '#b7d59f', '#000000', ''),\r\n\t\t\t(4, 'Event', '#24d5d6', '#000000', '');";
$db->query($sql);
//
// Comments
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "comments` (\r\n\t\t\t `commentid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `mod` varchar(64) NOT NULL,\r\n\t\t\t `contentid` int(11) NOT NULL,\r\n\t\t\t `text` varchar(4095) NOT NULL,\r\n\t\t\t PRIMARY KEY (`commentid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$db->query($sql);
//
// Config
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "config` (\r\n\t\t\t `mod` varchar(64) NOT NULL,\r\n\t\t\t `key` varchar(64) NOT NULL,\r\n\t\t\t `value` varchar(512) NOT NULL,\r\n\t\t\t `type` varchar(64) NOT NULL,\r\n\t\t\t `description` varchar(256) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "config` (`mod`, `key`, `value`, `type`, `description`) VALUES\r\n\t\t\t('core', 'title', '" . $coursename . "', 'string', 'Sets the title of the home page.'),\r\n\t\t\t('core', 'save-login-disabled', '0', 'bool', 'Enables or disables if an user can stay logged in.'),\r\n\t\t\t('core', 'log_file_enabled', '1', 'bool', 'Enables or disables the file version of the log.'),\r\n\t\t\t('core', 'log_mysql_enabled', '0', 'bool', 'Enables or disables the database version of the log.'),\r\n\t\t\t('core', 'log-crypt-key', 'hfh', 'string', 'Specifies the crypt key for the log file names.'),\r\n\t\t\t('core', 'stat-enabled', '0', 'bool', 'Enables or disables the visitors statistic.'),\r\n\t\t\t('core', 'stat-duration', '420', 'int', 'Specifies the value in seconds a visitor is counted as one.'),\r\n\t\t\t('core', 'stat-last-seen-length', '10', 'int', 'Specifies the number of users shown in the last-seen list.'),\r\n\t\t\t('stat', 'show-visitors-this-year', '1', 'bool', 'Enables or diasables the showing of visitors this year.'),\r\n\t\t\t('stat', 'show-visitors-this-month', '1', 'bool', 'Enables or diasables the showing of visitors this month.'),\r\n\t\t\t('stat', 'show-browseragent', '1', 'bool', 'Enables or diasables the showing of the browseragent.'),\r\n\t\t\t('stat', 'show-os', '1', 'bool', 'Enables or diasables the showing of the operationg system.'),\r\n\t\t\t('stat', 'show-referer', '1', 'bool', 'Enables or diasables the showing of the referer.'),\r\n\t\t\t('stat', 'show-bots', '0', 'bool', 'Enables or diasables the showing of bots.'),\r\n\t\t\t('favorites', 'enable', '0', 'bool', 'Enables or disables the global favorites.'),\r\n\t\t\t('login', 'register-send-email', '0', 'bool', 'Sends a mail after registration.'),\r\n\t\t\t('login', 'register-activation-required', '0', 'bool', 'Sets if an activation is required.'),\r\n\t\t\t('login', 'register-mail-subject', '', 'string', 'Sets the subject of the registration mail.'),\r\n\t\t\t('login', 'register-mail-text', '', 'text', 'Sets the text of the registration mail.'),\r\n\t\t\t('login', 'register-mail-sender', '*****@*****.**', 'string', 'Sets the sender of the registration and password mail.'),\r\n\t\t\t('login', 'register-notification-mail-address', '', 'string', 'Specifies the mail address where the register notification will be sent to.'),\r\n\t\t\t('login', 'lostpw-mail-text', '', 'text', 'Sets the text of the password mail.'),\r\n\t\t\t('login', 'lostpw-mail-subject', '', 'string', 'Sets the subject of the password mail.'),\r\n\t\t\t('login', 'disable-second-email', '0', 'bool', 'Enables or disables the second e-mail field of registration.'),\r\n\t\t\t('login', 'disable-nickname', '0', 'bool', 'Disables the nickname field. It will be replaced by pre- and lastname.'),\r\n\t\t\t('login', 'disable-birthday', '0', 'bool', 'Disables the birthday field.'),\r\n\t\t\t('login', 'register-disable', '0', 'bool', 'Enables or disables the register functionality'),\r\n\t\t\t('pmbox', 'email-notification', '0', 'bool', 'Enables or disables the email notification for new pms'),\r\n\t\t\t('pmbox', 'inbox_limit', '35', 'int', 'Sets the max number of messages stored in the inbox.'),\r\n\t\t\t('core', 'maintenance', '0', 'bool', 'Enables or disables the maintenance mode.'),\r\n\t\t\t('core', 'maintenance_description', '', 'text', 'Sets the description for the maintenance mode.'),\r\n\t\t\t('login', 'session-time', '240', 'int', 'Sets the time in seconds a session is valid.'),\r\n\t\t\t('core', 'template', 'smartstudies_orange', 'string', 'Sets the default template.'),\r\n\t\t\t('core', 'default_mod', 'login', 'string', 'Sets the default module for the start page.'),\r\n\t\t\t('core', 'language', 'de', 'string', 'Sets the language.'),\r\n\t\t\t('admin', 'users-per-page', '20', 'int', 'Sets the number of users displayed on one page.'),\r\n\t\t\t('admin', 'comments-per-page', '20', 'int', 'Sets the number of comments displayed on one page.'),\r\n\t\t\t('core', 'mod_rewrite', '1', 'bool', 'Enables or disables mod rewrite.'),\r\n\t\t\t('core', 'debug', '0', 'bool', 'Enables or disables the debug mode.'),\r\n\t\t\t('core', 'bbcode', '1', 'bool', 'Enables or disables the bbcode parser.'),\r\n\t\t\t('core', 'img-width', '150', 'int', 'Sets the avatar width in pixel.'),\r\n\t\t\t('core', 'img-height', '150', 'int', 'Sets the avatar height in pixel.'),\r\n\t\t\t('core', 'timezone', 'Europe/Paris', 'string', 'Sets the server timezone.'),\r\n\t\t\t('core', 'admin-mail', '', 'string', 'Specifies the email adress of the page administrator.'),\r\n\t\t\t('core', 'enable-mobile', '0', 'bool', 'Enables or disables the mobile device detection.'),\r\n\t\t\t('core', 'disable-reflections', '0', 'bool', 'Enables or disables the reflections of the avatars.'),\r\n\t\t\t('core', 'link-mod-to-menu', '0', 'bool', 'When enabled, modules without visible menu entry aren''t accessable.'),\r\n\t\t\t('core', 'link-mod-to-menu-exclusions', '', 'string', 'List of modules, which are always accessable. Separate with semicolon (;).'),\r\n\t\t\t('profile', 'hide-lastname', '0', 'bool', 'Hides the lastname in profile.'),\r\n\t\t\t('core', 'disable-magic-quotes', '0', 'bool', 'Force disables magic quotes, if php.ini is not accessable.'),\r\n\t\t\t('core', 'include-submenu', '0', 'bool', 'Specifies if the submenu entires are included in main menu tree.'),\r\n\t\t\t('core', 'hide-logout-menu-entry', '0', 'bool', 'Specifies if the logout-submenu is included in menu tree.'),\r\n\t\t\t('core', 'password-salt', 'ipvq94w038o', 'string', 'Specifies the string which is used to salt the user passwords.'),\r\n\t\t\t('usercp', 'hide-overview', '0', 'bool', 'Hides the overview submenu entry of the usercp.'),\r\n\t\t\t('usercp', 'hide-personal', '0', 'bool', 'Hides the personal submenu entry of the usercp.'),\r\n\t\t\t('usercp', 'hide-avatar', '0', 'bool', 'Hides the avatar submenu entry of the usercp.'),\r\n\t\t\t('usercp', 'hide-comments', '0', 'bool', 'Hides the my-comments submenu entry of the usercp.'),\r\n\t\t\t('usercp', 'hide-changepw', '0', 'bool', 'Hides the changepw submenu entry of the usercp.'),\r\n\t\t\t('usercp', 'hide-company', '1', 'bool', 'Hides the company submenu entry of the usercp'),\r\n\t\t\t('core', 'allow-html-tags', '1', 'bool', 'Enables or disables html tags in forms.'),\r\n\t\t\t('usercp', 'disable-editing', '0', 'bool', 'Specifies, if an user is allowed to change his pre-, lastname and birthday.'),\r\n\t\t\t('contact', 'login-required', '0', 'bool', 'Specifies, if a guest has to be logged in to send a request.'),\r\n\t\t\t('contact', 'title', '', 'string', 'Specifies the title of the form.'),\r\n\t\t\t('contact', 'description', '', 'text', 'Specifies the description of the form.'),\r\n\t\t\t('contact', 'send-mail', '0', 'bool', 'Sends an email to the specified adress when a new request was sent.'),\r\n\t\t\t('contact', 'email-adress', '', 'string', 'The email adress the notification will be sent to.'),\r\n\t\t\t('calendar', 'enable-ical-export', '1', 'bool', 'Enables or disables the ical file export.'),\r\n\t\t\t('calendar', 'default-view', 'week', 'list', '|day,week,month,year,next'),\r\n\t\t\t('calendar', 'show-birthdays', '1', 'bool', 'Enables or disables the showing of birthdays.'),\r\n\t\t\t('calendar', 'box-number-of-entries', '3', 'int', 'Specifies the number of entries shown in the calendar box.'),\r\n\t\t\t('calendar', 'current-event', '1', 'bool', 'Enables or disables the current event counter in the calendar box.'),\r\n\t\t\t('calendar', 'current-event-refresh-time', '15', 'int', 'Specifies the sync-interval for the current event in seconds.'),\r\n\t\t\t('calendar', 'hide-day-view', '0', 'bool', 'Hides the day-view.'),\r\n\t\t\t('calendar', 'hide-week-view', '0', 'bool', 'Hides the week-view.'),\r\n\t\t\t('calendar', 'hide-month-view', '0', 'bool', 'Hides the month-view.'),\r\n\t\t\t('calendar', 'hide-year-view', '0', 'bool', 'Hides the year-view.'),\r\n\t\t\t('calendar', 'hide-next-view', '0', 'bool', 'Hides the next-view.'),\r\n\t\t\t('calendar', 'default-visibility', 'public', 'list', 'Sets the default visibility for new calendar entries.|private,logged-in,public'),\r\n\t\t\t('guestbook', 'entries-per-page', '20', 'int', 'Sets the number of entries displayed on one page.'),\r\n\t\t\t('guestbook', 'ip-blocker-enable', '0', 'bool', 'Enables or disables the ip blocker.'),\r\n\t\t\t('guestbook', 'ip-blocker-timelimit', '180', 'int', 'Sets the ip blocker timelimit.'),\r\n\t\t\t('events', 'bar-width', '90', 'int', 'Sets the width of the register bar.'),\r\n\t\t\t('media', 'pictures-per-row', '3', 'int', 'Sets the number of images displayed on one page.'),\r\n\t\t\t('media', 'thumbnailwidth', '200', 'int', 'Sets the thumbnail width of image previews.'),\r\n\t\t\t('media', 'download-login-required', '0', 'bool', 'Enables if a login is required to download a file.'),\r\n\t\t\t('media', 'max-upload-size', '10485760', 'int', 'Specifies the maximum file size in bytes you can upload.'),\r\n\t\t\t('media', 'number-of-uploads', '10', 'int', 'Specifies the number of upload forms displayed in the image upload dialog.'),\r\n\t\t\t('media', 'auto-resize', '0', 'bool', 'Enables or disables the auto resize functionality of the uploaded images.'),\r\n\t\t\t('media', 'auto-resize-width', '1024', 'int', 'Specifies the width of the images to which they will be resized to.'),\r\n\t\t\t('media', 'hide-submedia', '0', 'bool', 'Hides or displays the number of subcategories and media of a category.'),\r\n\t\t\t('media', 'mail-notification-address', '', 'string', 'Mail address where download notifications are sent to.'),\r\n\t\t\t('media', 'hide-upload-author', '0', 'bool', 'Hides or shows the user who uploaded content.'),\r\n\t\t\t('media', 'hide-upload-date', '0', 'bool', 'Hides or shows the upload date.'),\r\n\t\t\t('news', 'news-per-page', '5', 'int', 'Sets the number of news displayed on one page.'),\r\n\t\t\t('news', 'news-box-entries', '5', 'int', 'Specifies the number of entries displayed in the news box.'),\r\n\t\t\t('news', 'preview-char-length', '500', 'int', 'Sets the length of the preview news.'),\r\n\t\t\t('news', 'rss', '0', 'bool', 'Enables or disables the rss feed.'),\r\n\t\t\t('news', 'hide-time', '0', 'bool', 'Hides or shows the time.'),\r\n\t\t\t('news', 'hide-author', '0', 'bool', 'Hides or shows the author of a news entry.'),\r\n\t\t\t('poll', 'polls-per-page', '5', 'int', 'Sets the number of polls displayed on one page.'),\r\n\t\t\t('poll', 'maximum-questions', '10', 'int', 'Sets the max number of questions.'),\r\n\t\t\t('poll', 'maxbarlength', '300', 'int', 'Sets the max length of the bar.'),\r\n\t\t\t('poll', 'barcolor', '#00ff00,#00dd00,#00bb00,#009900,#007700', 'string', 'A list of the bar colors.'),\r\n\t\t\t('poll', 'box-show-bar-in-second-row', '1', 'bool', 'Defines if the bar should be shown in a seperate row.'),\r\n\t\t\t('poll', 'box-layout', 'boxes', 'list', '|lines,boxes'),\r\n\t\t\t('poll', 'main-layout', 'boxes', 'list', '|lines,boxes'),\r\n\t\t\t('board', 'posts-per-page', '20', 'int', 'Sets the number of posts displayed on one page.'),\r\n\t\t\t('board', 'threads-per-page', '20', 'int', 'Sets the number of threads displayed on one page.'),\r\n\t\t\t('board', 'convert-urls', '1', 'bool', 'Enables or disables the automatic url converted.'),\r\n\t\t\t('board', 'box-thread-once', '1', 'bool', 'Sets if a thread is only displayed once in the board box.'),\r\n\t\t\t('board', 'box-posts', '5', 'int', 'Sets the number of posts displayed in the board box.'),\r\n\t\t\t('board', 'enable-subscriptions', '0', 'bool', 'Enables or disables thread subscribtions.'),\r\n\t\t\t('board', 'disable-number-of-posts', '0', 'bool', 'Enables or disables the number of posts for an user.'),\r\n\t\t\t('shoutbox', 'posts', '7', 'int', 'Number of posts shown in the shoutbox.'),\r\n\t\t\t('shoutbox', 'lock-time', '15', 'int', 'The time in seconds an user cannot post again.'),\r\n\t\t\t('shoutbox', 'reverse', '0', 'bool', 'Reverses the shoutbox.');";
$db->query($sql);
//
// Contact
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "contact` (\r\n\t\t `contactid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t `userid` int(11) NOT NULL,\r\n\t\t `timestamp` int(11) NOT NULL,\r\n\t\t `uniqid` varchar(64) NOT NULL,\r\n\t\t `subject` varchar(64) NOT NULL,\r\n\t\t `text` text NOT NULL,\r\n\t\t `read` int(1) NOT NULL,\r\n\t\t `done` int(1) NOT NULL,\r\n\t\t PRIMARY KEY (`contactid`)\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$db->query($sql);
//
// Content
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "content` (\r\n\t\t `key` text NOT NULL,\r\n\t\t `title` text NOT NULL,\r\n\t\t `text` text NOT NULL,\r\n\t\t `box_content` text NOT NULL,\r\n\t\t `version` int(11) NOT NULL,\r\n\t\t `version_timestamp` int(11) NOT NULL,\r\n\t\t `version_author` int(11) NOT NULL\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "content` (`key`, `title`, `text`, `box_content`, `version`, `version_timestamp`, `version_author`) VALUES\r\n\t\t\t('emails', 'Wichtige Emailadressen', '<p>\r\n\t<b>Herr Apfel:</b> apfel@saft.de</p>\r\n<p>\r\n\t<b>Herr Walter:</b> walter@t-offline.de</p>\r\n<p>\r\n\t<b>Herr Müller:</b> a.mueller@gabelbw.de</p>\r\n', '', 0, 1338838174, 1),\r\n\t\t\t('websites', 'Webseiten', '<p>\r\n\t<a href=\"http://google.de\" target=\"_blank\">Google</a></p>\r\n<p>\r\n\t<a href=\"http://heise.de\" target=\"_blank\">heise</a></p>\r\n<p>\r\n\t </p>\r\n', '', 0, 1338838265, 1),\r\n\t\t\t('informations', 'Informationen', '<p>\r\n\tWichtige Informationen</p>\r\n', '', 0, 1338838374, 1),\r\n\t\t\t('websites', 'Webseiten', '<p>\r\n\t<a href=\"http://google.de\" target=\"_blank\">Google</a></p>\r\n<p>\r\n\t<a href=\"http://heise.de\" target=\"_blank\">heise</a></p>\r\n<p>\r\n\t<a href=\"http://verydemotivational.memebase.com/\">verydemotivational</a></p>\r\n<p>\r\n\t </p>\r\n', '', 1, 1339662933, 1),\r\n\t\t\t('websites', 'Webseiten', '<p>\r\n\t<a href=\"http://google.de\" target=\"_blank\">Google</a></p>\r\n<p>\r\n\t<a href=\"http://heise.de\" target=\"_blank\">heise</a></p>\r\n<p>\r\n\t<a href=\"http://verydemotivational.memebase.com/\" target=\"_blank\">verydemotivational</a></p>\r\n<p>\r\n\t </p>\r\n', '', 2, 1339662968, 1);\r\n\t\t\t;";
$db->query($sql);
//
// Content_Permissions
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "content_permissions` (\r\n\t\t\t `key` varchar(255) NOT NULL,\r\n\t\t\t `groupid` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Domains
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "domains` (\r\n\t\t\t `domainid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `name` varchar(255) NOT NULL,\r\n\t\t\t `comment` text NOT NULL,\r\n\t\t\t `template` varchar(255) NOT NULL,\r\n\t\t\t PRIMARY KEY (`domainid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$db->query($sql);
//
// Groups
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "groups` (\r\n\t\t\t `groupid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `description` varchar(256) NOT NULL,\r\n\t\t\t `display` int(1) NOT NULL,\r\n\t\t\t `admin` int(1) NOT NULL,\r\n\t\t\t PRIMARY KEY (`groupid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "groups` (`groupid`, `name`, `description`, `display`, `admin`) VALUES\r\n\t\t\t(1, 'Admin', 'Administratoren', 0, 1),\r\n\t\t\t(2, 'Mitglied', 'Studenten des Kurses " . $coursename . "', 0, 0),\r\n\t\t\t(3, 'Kurssprecher', 'Kurssprecher des Kurses " . $coursename . "', 0, 0);";
$db->query($sql);
//
// Groupware
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "groupware` (\r\n\t\t\t `groupwareid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `title` text NOT NULL,\r\n\t\t\t `description` text NOT NULL,\r\n\t\t\t `state` int(1) NOT NULL,\r\n\t\t\t `end` int(11) NOT NULL,\r\n\t\t\t `priority` int(1) NOT NULL,\r\n\t\t\t `contactid` int(11) DEFAULT NULL,\r\n\t\t\t `userid` int(11) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`groupwareid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$db->query($sql);
//
// Group_Rights
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "group_rights` (\r\n\t\t\t `mod` varchar(64) NOT NULL,\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `groupid` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "group_rights` (`mod`, `name`, `groupid`) VALUES\r\n\t\t\t('admin', 'groups', 1),\r\n\t\t\t('admin', 'sessions', 1),\r\n\t\t\t('admin', 'users', 1),\r\n\t\t\t('admin', 'personal_fields', 1),\r\n\t\t\t('admin', 'menu', 1),\r\n\t\t\t('admin', 'mod', 1),\r\n\t\t\t('admin', 'config', 1),\r\n\t\t\t('admin', 'comments', 1),\r\n\t\t\t('admin', 'content', 1),\r\n\t\t\t('admin', 'log', 1),\r\n\t\t\t('admin', 'groupware', 1),\r\n\t\t\t('admin', 'contact', 1),\r\n\t\t\t('admin', 'boxes', 1),\r\n\t\t\t('admin', 'backup', 1),\r\n\t\t\t('imprint', 'manage', 1),\r\n\t\t\t('calendar', 'manage', 1),\r\n\t\t\t('detailedpoll', 'editor', 1),\r\n\t\t\t('events', 'manage', 1),\r\n\t\t\t('guestbook', 'manage', 1),\r\n\t\t\t('media', 'manage', 1),\r\n\t\t\t('media', 'upload', 1),\r\n\t\t\t('news', 'manage', 1),\r\n\t\t\t('poll', 'editor', 1),\r\n\t\t\t('stat', 'manage', 1),\r\n\t\t\t('tetris', 'admin', 1),\r\n\t\t\t('calendar', 'manage', 3),\r\n\t\t\t('guestbook', 'manage', 3),\r\n\t\t\t('events', 'manage', 3),\r\n\t\t\t('news', 'manage', 3),\r\n\t\t\t('poll', 'editor', 3),\r\n\t\t\t('board', 'manage', 1),\r\n\t\t\t('admin', 'personal_fields', 3),\r\n\t\t\t('media', 'upload', 3),\r\n\t\t\t('media', 'manage', 3),\r\n\t\t\t('shoutbox', 'manage', 1),\r\n\t\t\t('shoutbox', 'manage', 3),\r\n\t\t\t('smartstudies', 'manage', 1);";
$db->query($sql);
//
// Group_Users
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "group_users` (\r\n\t\t\t `groupid` int(11) NOT NULL,\r\n\t\t\t `userid` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "group_users` (`groupid`, `userid`) VALUES\r\n\t\t\t(1, 1),\r\n\t\t\t(3, 10),\r\n\t\t\t(2, 10),\r\n\t\t\t(3, 3),\r\n\t\t\t(2, 3),\r\n\t\t\t(2, 2),\r\n\t\t\t(2, 25),\r\n\t\t\t(2, 4),\r\n\t\t\t(2, 5),\r\n\t\t\t(2, 6),\r\n\t\t\t(2, 7),\r\n\t\t\t(2, 8),\r\n\t\t\t(2, 9),\r\n\t\t\t(2, 11),\r\n\t\t\t(2, 12),\r\n\t\t\t(2, 13),\r\n\t\t\t(2, 14),\r\n\t\t\t(2, 15),\r\n\t\t\t(2, 16),\r\n\t\t\t(2, 17),\r\n\t\t\t(2, 18),\r\n\t\t\t(2, 19),\r\n\t\t\t(2, 20),\r\n\t\t\t(2, 21),\r\n\t\t\t(2, 22),\r\n\t\t\t(2, 23),\r\n\t\t\t(2, 24),\r\n\t\t\t(2, 26);";
$db->query($sql);
//
// Guestbook
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "guestbook` (\r\n\t\t\t `guestbookid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `author` varchar(64) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `message` varchar(512) NOT NULL,\r\n\t\t\t `ipadress` varchar(16) NOT NULL,\r\n\t\t\t PRIMARY KEY (`guestbookid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "guestbook` (`guestbookid`, `author`, `timestamp`, `message`, `ipadress`) VALUES\r\n\t\t\t(1, 'Bewunderer', " . mktime(16, 6, 43, date('m'), date('d') - 4, date('Y')) . ", 'Wow, cool.', '127.0.0.1'),\r\n\t\t\t(2, 'Troll', " . mktime(9, 43, 12, date('m'), date('d') - 3, date('Y')) . ", 'I was here.', '141.31.111.1'),\r\n\t\t\t(3, 'Mr. Banane', " . mktime(22, 11, 30, date('m'), date('d') - 3, date('Y')) . ", 'Hey, ich wollte auch mal loswerden, dass diese Seite sehr informativ ist.', '141.31.111.1');\r\n\t\t\t";
$db->query($sql);
//
// Imprint
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "imprint` (\r\n\t\t\t `owner_name` varchar(255) NOT NULL,\r\n\t\t\t `owner_street` varchar(255) NOT NULL,\r\n\t\t\t `owner_loc` varchar(255) NOT NULL,\r\n\t\t\t `owner_tel` varchar(255) NOT NULL,\r\n\t\t\t `owner_mail` varchar(255) NOT NULL,\r\n\t\t\t `cont_name` varchar(255) NOT NULL,\r\n\t\t\t `cont_street` varchar(255) NOT NULL,\r\n\t\t\t `cont_loc` varchar(255) NOT NULL,\r\n\t\t\t `court` varchar(255) NOT NULL,\r\n\t\t\t `imprint` text NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `hfh_imprint` (`owner_name`, `owner_street`, `owner_loc`, `owner_tel`, `owner_mail`, `cont_name`, `cont_street`, `cont_loc`, `court`, `imprint`) VALUES\r\n\t\t\t\t('Nikolaus Themessl', 'Rötlenstraße 25', 'Filderstadt', '', '*****@*****.**', 'Nikolaus Themessl', 'Rötlenstraße 25', 'Filderstadt', '', ' 1. Inhalt des Onlineangebotes\r\n\r\nDer Autor übernimmt keinerlei Gewähr für die Aktualität, Korrektheit, Vollständigkeit oder Qualität der bereitgestellten Informationen. Haftungsansprüche gegen den Autor, welche sich auf Schäden materieller oder ideeller Art beziehen, die durch die Nutzung oder Nichtnutzung der dargebotenen Informationen bzw. durch die Nutzung fehlerhafter und unvollständiger Informationen verursacht wurden, sind grundsätzlich ausgeschlossen, sofern seitens des Autors kein nachweislich vorsätzliches oder grob fahrlässiges Verschulden vorliegt.\r\n\r\nAlle Angebote sind freibleibend und unverbindlich. Der Autor behält es sich ausdrücklich vor, Teile der Seiten oder das gesamte Angebot ohne gesonderte Ankündigung zu verändern, zu ergänzen, zu löschen oder die Veröffentlichung zeitweise oder endgültig einzustellen.\r\n \r\n\r\n\r\n2. Verweise und Links\r\n\r\nBei direkten oder indirekten Verweisen auf fremde Internetseiten ("Links"), die außerhalb des Verantwortungsbereiches des Autors liegen, würde eine Haftungsverpflichtung ausschließlich in dem Fall in Kraft treten, in dem der Autor von den Inhalten Kenntnis hat und es ihm technisch möglich und zumutbar wäre, die Nutzung im Falle rechtswidriger Inhalte zu verhindern.\r\n\r\nDer Autor erklärt hiermit ausdrücklich, dass zum Zeitpunkt der Linksetzung keine illegalen Inhalte auf den zu verlinkenden Seiten erkennbar waren. Auf die aktuelle und zukünftige Gestaltung, die Inhalte oder die Urheberschaft der gelinkten/verknüpften Seiten hat der Autor keinerlei Einfluss. Deshalb distanziert er sich hiermit ausdrücklich von allen Inhalten aller gelinkten /verknüpften Seiten, die nach der Linksetzung verändert wurden. Diese Feststellung gilt für alle innerhalb des eigenen Internetangebotes gesetzten Links und Verweise sowie für Fremdeinträge in vom Autor eingerichteten Gästebüchern, Diskussionsforen und Mailinglisten.\r\n\r\nFür illegale, fehlerhafte oder unvollständige Inhalte und insbesondere für Schäden, die aus der Nutzung oder Nichtnutzung solcherart dargebotener Informationen entstehen, haftet allein der Anbieter der Seite, auf welche verwiesen wurde, nicht derjenige, der über Links auf die jeweilige Veröffentlichung lediglich verweist.\r\n \r\n\r\n\r\n3. Urheber- und Kennzeichenrecht\r\n\r\nDer Autor ist bestrebt, in allen Publikationen die Urheberrechte der verwendeten Grafiken, Tondokumente, Videosequenzen und Texte zu beachten, von ihm selbst erstellte Grafiken, Tondokumente, Videosequenzen und Texte zu nutzen oder auf lizenzfreie Grafiken, Tondokumente, Videosequenzen und Texte zurückzugreifen.\r\nAlle innerhalb des Internetangebotes genannten und ggf. durch Dritte geschätzten Marken- und Warenzeichen unterliegen uneingeschränkt den Bestimmungen des jeweils gültigen Kennzeichenrechts und den Besitzrechten der jeweiligen eingetragenen Eigentümer. Allein aufgrund der bloßen Nennung ist nicht der Schluss zu ziehen, dass Markenzeichen nicht durch Rechte Dritter geschützt sind!\r\n\r\nDas Copyright für veröffentlichte, vom Autor selbst erstellte Objekte bleibt allein beim Autor der Seiten. Eine Vervielfältigung oder Verwendung solcher Grafiken, Tondokumente, Videosequenzen und Texte in anderen elektronischen oder gedruckten Publikationen ist ohne ausdrückliche Zustimmung des Autors nicht gestattet.\r\n \r\n\r\n\r\n4. Datenschutz\r\n\r\nSofern innerhalb des Internetangebotes die Möglichkeit zur Eingabe persönlicher oder geschäftlicher Daten (Emailadressen, Namen, Anschriften) besteht, so erfolgt die Preisgabe dieser Daten seitens des Nutzers auf ausdrücklich freiwilliger Basis. Die Inanspruchnahme und Bezahlung aller angebotenen Dienste ist - soweit technisch möglich und zumutbar - auch ohne Angabe solcher Daten bzw. unter Angabe anonymisierter Daten oder eines Pseudonyms gestattet.\r\n \r\n\r\n\r\n5. Rechtswirksamkeit dieses Haftungsausschlusses\r\n\r\nDieser Haftungsausschluss ist als Teil des Internetangebotes zu betrachten, von dem aus auf diese Seite verwiesen wurde. Sofern Teile oder einzelne Formulierungen dieses Textes der geltenden Rechtslage nicht, nicht mehr oder nicht vollständig entsprechen sollten, bleiben die übrigen Teile des Dokumentes in ihrem Inhalt und ihrer Gültigkeit davon unberührt.\r\n');\r\n\t\t\t\t";
$db->query($sql);
//
// Inbox
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "inbox` (\r\n\t\t\t `pmid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `senderid` int(11) NOT NULL,\r\n\t\t\t `recieverid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `subject` varchar(64) NOT NULL,\r\n\t\t\t `message` text NOT NULL,\r\n\t\t\t `read` int(1) NOT NULL,\r\n\t\t\t `notified` int(1) NOT NULL,\r\n\t\t\t PRIMARY KEY (`pmid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "inbox` (`pmid`, `senderid`, `recieverid`, `timestamp`, `subject`, `message`, `read`, `notified`) VALUES\r\n\t\t\t(1, 3, 1," . mktime(date('H'), date('i') - 31, 0, date('m'), date('d'), date('Y')) . ",\r\n\t\t\t\t\t\t'Admin Rechte', 'Gib mir Adminrechte.\n Sofort.', 0, 0),\r\n\t\t\t(2, 6, 1," . mktime(12, 13, 34, date('m'), date('d') - 2, date('Y')) . ",\r\n\t\t\t\t\t\t'Mittagessen', 'Wo gehn wir heute zum Mittagessen hin, irgendwelche Ideen?', 1, 1);\r\n\t\t\t";
$db->query($sql);
//
// Log
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "log` (\r\n\t\t\t `logid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `mod` varchar(64) NOT NULL,\r\n\t\t\t `description` varchar(256) NOT NULL,\r\n\t\t\t PRIMARY KEY (`logid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$db->query($sql);
//
// Media_Categories
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "media_categories` (\r\n\t\t\t `categoryid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `parentid` int(11) NOT NULL,\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `uniqid` varchar(255) NOT NULL,\r\n\t\t\t `language` varchar(4) NOT NULL,\r\n\t\t\t PRIMARY KEY (`categoryid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "media_categories` (`categoryid`, `parentid`, `name`, `uniqid`, `language`) VALUES\r\n\t\t\t(1, 0, '1. Semester', '20d55d5bfe7e7917b664ea622ff1003e', ''),\r\n\t\t\t(2, 0, '2. Semester', '6d6a95490fd4ce958531f1af5537a519', ''),\r\n\t\t\t(3, 1, 'Statistik', 'bf1723f53565f3dd452fdfb8282219aa', ''),\r\n\t\t\t(4, 1, 'Recht', '37f2e310ff00e4488e9b5fa3c61aefb3', ''),\r\n\t\t\t(5, 1, 'ABWL', 'ceaf346f78d38f2f1935b31e0b80721e', ''),\r\n\t\t\t(6, 1, 'Soziale Kompetenzen', '5e7db39cff497df88e31cd08c1a08084', ''),\r\n\t\t\t(7, 1, 'Methodisches Arbeiten', '604dff2b64d0680cadcd24fc2140827b', ''),\r\n\t\t\t(8, 0, 'Bilder', 'e933bb021584be75f86f952936975247', ''),\r\n\t\t\t(9, 8, 'Gruppenfoto', '7ae5d9796fd2d9b9ed953d83f2abe440', ''),\r\n\t\t\t(10, 8, 'Ausflug in den Zoo', '36730f7f22fb33856be4ccf9a919df31', ''),\r\n\t\t\t(11, 0, 'Sonstiges', 'e7234ad084c5ab81c4a7c8a685a8a2c5', '');";
$db->query($sql);
//
// Media_Categories_Permissions
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "media_categories_permissions` (\r\n\t\t\t `categoryid` int(11) NOT NULL,\r\n\t\t\t `groupid` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Media_Downloads
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "media_downloads` (\r\n\t\t\t `downloadid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `description` varchar(1023) NOT NULL,\r\n\t\t\t `version` varchar(64) NOT NULL,\r\n\t\t\t `file` varchar(256) NOT NULL,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `categoryid` int(11) NOT NULL,\r\n\t\t\t `counter` int(11) NOT NULL,\r\n\t\t\t `release_notes` text NOT NULL,\r\n\t\t\t `thumbnail` varchar(511) NOT NULL,\r\n\t\t\t `disabled` int(1) NOT NULL,\r\n\t\t\t PRIMARY KEY (`downloadid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "media_downloads` (`downloadid`, `name`, `description`, `version`, `file`, `userid`, `timestamp`, `categoryid`, `counter`, `release_notes`, `thumbnail`, `disabled`) VALUES\r\n\t\t\t(1, 'Präsentation', '', '', 'Lorem ipsum.pdf', 1, " . mktime(9, 21, 4, date('m'), date('d') - 5, date('Y')) . ", 3, 0, '', '', 0),\r\n\t\t\t(2, 'Lernblatt', '', '', 'Lorem ipsum 2.pdf', 1, " . mktime(18, 34, 12, date('m'), date('d') - 3, date('Y')) . ", 3, 0, '', '', 0),\r\n\t\t\t(3, 'Übungsaufgaben', '', '', 'Lorem ipsum 1.docx', 1, " . mktime(23, 3, 53, date('m'), date('d') - 2, date('Y')) . ", 3, 0, '', '', 0),\r\n\t\t\t(4, 'Gruppe 1 - Präsentation & Handout', '', '', 'Lorem ipsum 3.rar', 1, " . mktime(12, 46, 52, date('m'), date('d') - 1, date('Y')) . ", 5, 0, '', '', 0),\r\n\t\t\t(5, 'Gruppe 2 - Präsentation & Handout', '', '', 'Lorem ipsum 0.rar', 1, " . mktime(9, 11, 12, date('m'), date('d') - 3, date('Y')) . ", 5, 0, '', '', 0),\r\n\t\t\t(6, 'Beispiel', '', '', 'Lorem ipsum 4.txt', 1, " . mktime(20, 34, 25, date('m'), date('d') - 2, date('Y')) . ", 6, 0, '', '', 0);";
$db->query($sql);
//
// Media_Downloads_Counter
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "media_downloads_counter` (\r\n\t\t\t `downloadid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `browseragent` VARCHAR (511) NOT NULL,\r\n\t\t\t `os` VARCHAR (511) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r\n\t\t\t";
$db->query($sql);
//
// Media_Movies
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "media_movies` (\r\n\t\t\t `movieid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `file` varchar(64) NOT NULL,\r\n\t\t\t `categoryid` int(11) NOT NULL,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `description` varchar(256) NOT NULL,\r\n\t\t\t PRIMARY KEY (`movieid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "media_movies` (`movieid`, `name`, `file`, `categoryid`, `userid`, `timestamp`, `description`) VALUES\r\n\t\t\t(1, 'Tetris to the MaxX Intro', 'tetris.flv', 11, 1, " . mktime(11, 14, 52, date('m'), date('d') - 3, date('Y')) . ", 'Intro zu dem Tetris - Klon Tetris to the MaxX.\nMehr Infos unter www.t3m-game.org.');\r\n\t\t\t";
$db->query($sql);
//
// Menu
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "menu` (\r\n\t\t\t `menuid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `parentid` int(11) NOT NULL,\r\n\t\t\t `order` int(11) NOT NULL,\r\n\t\t\t `title` varchar(64) NOT NULL,\r\n\t\t\t `mod` varchar(64) NOT NULL,\r\n\t\t\t `requires_login` int(1) NOT NULL,\r\n\t\t\t `assigned_groupid` int(11) NOT NULL,\r\n\t\t\t `language` varchar(4) NOT NULL,\r\n\t\t\t `url` varchar(511) NOT NULL,\r\n\t\t\t `home` int(1) NOT NULL,\r\n\t\t\t `template` varchar(255) NOT NULL,\r\n\t\t\t `domainid` int(11) NOT NULL,\r\n\t\t\t PRIMARY KEY (`menuid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "menu` (`menuid`, `parentid`, `order`, `title`, `mod`, `requires_login`, `assigned_groupid`, `language`, `url`, `home`, `template`, `domainid`) VALUES\r\n\t\t\t(1, 0, 6, 'Login', 'login', 0, 0, '', '', 1, '', 0),\r\n\t\t\t(2, 1, 2, 'Admin', 'admin', 1, 1, '', '', 0, '', 0),\r\n\t\t\t(3, 1, 3, 'User Center', 'usercp', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(4, 1, 4, 'Nachrichten', 'pmbox', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(5, 0, 2, 'Vorlesungsplan', 'calendar', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(6, 0, 4, 'Umfragen', 'poll', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(7, 0, 5, 'Mediathek', 'media', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(8, 0, 1, 'News', 'news', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(9, 0, 10, 'Gästebuch', 'guestbook', 0, 0, '', '', 0, '', 0),\r\n\t\t\t(14, 0, 11, 'Informationen', 'informations', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(11, 0, 9, 'Tetris', 'tetris', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(13, 0, 3, 'Forum', 'board', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(15, 14, 12, 'E-Mail Adressen', 'emails', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(16, 14, 13, 'Webseiten', 'websites', 1, 0, '', '', 0, '', 0),\r\n\t\t\t(18, 1, 5, 'Shoutbox', 'shoutbox', 1, 1, '', '', 0, '', 0),\r\n\t\t\t(19, 1, 5, 'SmartStudies', 'smartstudies', 1, 1, '', '', 0, '', 0),\r\n\t\t\t(20, 0, 14, 'Impressum', 'imprint', 0, 0, '', '', 0, '', 0);\r\n\t\t\t";
$db->query($sql);
//
// A
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "mod` (\r\n\t\t\t `mod` varchar(64) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r\n\t\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "mod` (`mod`) VALUES\r\n\t\t\t('login'),\r\n\t\t\t('pmbox'),\r\n\t\t\t('admin'),\r\n\t\t\t('usercp'),\r\n\t\t\t('404'),\r\n\t\t\t('imprint'),\r\n\t\t\t('content'),\r\n\t\t\t('maintenance'),\r\n\t\t\t('profile'),\r\n\t\t\t('contact'),\r\n\t\t\t('calendar'),\r\n\t\t\t('shoutbox'),\r\n\t\t\t('guestbook'),\r\n\t\t\t('events'),\r\n\t\t\t('media'),\r\n\t\t\t('news'),\r\n\t\t\t('tetris'),\r\n\t\t\t('poll'),\r\n\t\t\t('board');";
$db->query($sql);
//
// Newposts
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "newposts` (\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `threadid` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r\n\t\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "newposts` (`userid`, `threadid`) VALUES\r\n\t\t\t(25, 1),\r\n\t\t\t(12, 2),\r\n\t\t\t(5, 3),\r\n\t\t\t(14, 3),\r\n\t\t\t(21, 4);";
$db->query($sql);
//
// News
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "news` (\r\n\t\t\t `newsid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `title` varchar(64) NOT NULL,\r\n\t\t\t `text` text NOT NULL,\r\n\t\t\t `preview` text NOT NULL,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `edit_count` int(11) NOT NULL,\r\n\t\t\t `language` varchar(4) NOT NULL,\r\n\t\t\t `domainid` int(11) NOT NULL,\r\n\t\t\t PRIMARY KEY (`newsid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "news` (`newsid`, `title`, `text`, `preview`, `userid`, `timestamp`, `edit_count`, `language`, `domainid`) VALUES\r\n\t\t\t(1, 'Site geht online', '[b]Hallo zusammen![/b]\n\nIch freue mich euch mitteilen zu könne, dass die Siete [i]ab sofort[/i] für alle Mitglieder des Kurses [u]" . $coursename . "[/u] zugänglich ist!\n\nViel Spaß und Gruß,\nAnton Admin', '[b]Hallo zusammen![/b]\n\nIch freue mich euch mitteilen zu könne, dass die Siete [i]ab sofort[/i] für alle Mitglieder des Kurses [u]" . $coursename . "[/u] zugänglich ist!\n\nViel Spaß und Gruß,\nAnton Admin[/b]', 1, " . mktime(13, 37, 00, date('m'), date('d') - 6, date('Y')) . ", 4, '', 0);\r\n\t\t\t";
$db->query($sql);
//
// Notify
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "notify` (\r\n\t\t\t `file` varchar(64) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r\n\t\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "notify` (`file`) VALUES\r\n\t\t\t('pmbox.notify.php');\r\n\t\t\t";
$db->query($sql);
//
// Outbox
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "outbox` (\r\n\t\t `pmid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t `senderid` int(11) NOT NULL,\r\n\t\t `recieverid` int(11) NOT NULL,\r\n\t\t `timestamp` int(11) NOT NULL,\r\n\t\t `subject` varchar(64) NOT NULL,\r\n\t\t `message` text NOT NULL,\r\n\t\t PRIMARY KEY (`pmid`)\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;\r\n\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "outbox` (`pmid`, `senderid`, `recieverid`, `timestamp`, `subject`, `message`) VALUES\r\n\t\t\t(1, 3, 1, " . mktime(date('H'), date('i') - 31, 0, date('m'), date('d'), date('Y')) . ", 'Admin Rechte', 'Gib mir Adminrechte.');\r\n\t\t\t";
$db->query($sql);
//
// Personal_Data
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "personal_data` (\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `fieldid` int(11) NOT NULL,\r\n\t\t\t `value` varchar(256) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r\n\t\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "personal_data` (`userid`, `fieldid`, `value`) VALUES\r\n\t\t\t(21, 1, ''),\r\n\t\t\t(21, 2, 'Ungeziefer vernichten'),\r\n\t\t\t(21, 3, 'Rot'),\r\n\t\t\t(11, 1, 'X-Men GmbH'),\r\n\t\t\t(11, 2, 'Manuelle Zerstörung'),\r\n\t\t\t(11, 3, 'Gelb');";
$db->query($sql);
//
// Personal_Fields
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "personal_fields` (\r\n\t\t\t `fieldid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `value` varchar(64) NOT NULL,\r\n\t\t\t PRIMARY KEY (`fieldid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "personal_fields` (`fieldid`, `value`) VALUES\r\n\t\t\t(1, 'Unternehmen'),\r\n\t\t\t(2, 'Kenntnisse'),\r\n\t\t\t(3, 'Lieblingsfarbe');";
$db->query($sql);
//
// Poll
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "poll` (\r\n\t\t\t `ID` int(10) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `name` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\r\n\t\t\t `button` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'radio',\r\n\t\t\t `date` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\r\n\t\t\t `active` int(1) NOT NULL DEFAULT '1',\r\n\t\t\t `voted` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\r\n\t\t\t `votes` int(10) NOT NULL DEFAULT '0',\r\n\t\t\t PRIMARY KEY (`ID`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "poll` (`ID`, `name`, `button`, `date`, `active`, `voted`, `votes`) VALUES\r\n\t\t\t(1, 'Wie findet ihr die Seite?', 'radio', '" . mktime(18, 23, 10, date('m'), date('d') - 3, date('Y')) . "', 1, '', 9),\r\n\t\t\t(2, 'Mittagessen, wo geht ihr am liebsten essen?', 'checkbox', '" . mktime(22, 12, 45, date('m'), date('d') - 2, date('Y')) . "', 1, '', 6);\r\n\t\t\t";
$db->query($sql);
//
// Poll_Questions
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "poll_questions` (\r\n\t\t\t `ID` int(10) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `pollID` int(10) NOT NULL,\r\n\t\t\t `text` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\r\n\t\t\t `count` int(10) NOT NULL DEFAULT '0',\r\n\t\t\t PRIMARY KEY (`ID`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;\r\n\t\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "poll_questions` (`ID`, `pollID`, `text`, `count`) VALUES\r\n\t\t\t(1, 1, 'Stark!', 5),\r\n\t\t\t(2, 1, 'Sehr gut', 2),\r\n\t\t\t(3, 1, 'Ok', 1),\r\n\t\t\t(4, 1, 'Naja', 0),\r\n\t\t\t(5, 1, 'URL in Browser eingeben?', 1),\r\n\t\t\t(6, 2, 'Döner', 6),\r\n\t\t\t(7, 2, 'McDonalds', 2),\r\n\t\t\t(8, 2, 'Burger King', 3),\r\n\t\t\t(9, 2, 'Chinese', 3),\r\n\t\t\t(10, 2, 'Bäcker', 1),\r\n\t\t\t(11, 2, 'PizzaHut', 2),\r\n\t\t\t(12, 2, 'Currywurst', 1),\r\n\t\t\t(13, 2, 'Supermarkt', 3),\r\n\t\t\t(14, 2, 'Salat', 0),\r\n\t\t\t(15, 2, 'Anderes (siehe Kommentar)', 1),\r\n\t\t\t(16, 3, 'Döner', 0),\r\n\t\t\t(17, 3, 'McDonalds', 0),\r\n\t\t\t(18, 3, 'Burger King', 0),\r\n\t\t\t(19, 3, 'Chinese', 0),\r\n\t\t\t(20, 3, 'Bäcker', 0),\r\n\t\t\t(21, 3, 'PizzaHut', 0),\r\n\t\t\t(22, 3, 'Currywurst', 0),\r\n\t\t\t(23, 3, 'Supermarkt', 0),\r\n\t\t\t(24, 3, 'Salat', 0),\r\n\t\t\t(25, 3, 'Anderes (siehe Kommentar)', 0);";
$db->query($sql);
//
// Post
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "post` (\r\n\t\t\t `postid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `threadid` int(11) NOT NULL,\r\n\t\t\t `post` text NOT NULL,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `attachments` varchar(255) DEFAULT NULL,\r\n\t\t\t PRIMARY KEY (`postid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;\r\n\t\t\t";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "post` (`postid`, `threadid`, `post`, `userid`, `timestamp`, `attachments`) VALUES\r\n\t\t\t(1, 1, 'Hallo,\n\nich habe mir jetzt ne neue Yacht gekauft und war 3 Wochen in Hawaii. Was könnte man sich grade sonst noch so leisten, irgendwer ne idee?', 25, " . mktime(14, 17, 13, date('m'), date('d') - 2, date('Y')) . ", ''),\r\n\t\t\t(2, 2, 'Hey Leute,\n\nich feiere meinen Geburtstag bei mir daheim. Es wird zwar wie jedes Jahr niemand kommen, aber dennoch seit ihr alle eingeladen.\n\nGruß, Marvin\n', 12, " . mktime(0, 42, 0, date('m'), date('d') - 3, date('Y')) . ", ''),\r\n\t\t\t(3, 3, 'Wie wärs mit eine Lerngruppe für die kommende Matheklausur?', 4, " . mktime(13, 37, 12, date('m'), date('d') - 1, date('Y')) . ", ''),\r\n\t\t\t(4, 3, 'Ich wär dabei!\n\nraff eh nix...', 5, " . mktime(19, 52, 22, date('m'), date('d') - 1, date('Y')) . ", ''),\r\n\t\t\t(5, 3, 'Ich auch!\n\nWir wärs mit nächstem Montag?', 14, " . mktime(8, 27, 13, date('m'), date('d'), date('Y')) . ", ''),\r\n\t\t\t(6, 4, 'Hallo zusammen,\n\ndie X-Men GmbH sucht noch Verstärkung in ihrem Team. Falls ihr Interesse habt könnt ihr mixh gerne ansprechen.\n\nGruß,\nLogan', 11, " . mktime(21, 23, 10, date('m'), date('d') - 3, date('Y')) . ", ''),\r\n\t\t\t(7, 4, 'Generell hätte ich Interesse.\nWas genau macht ihr so?', 21, " . mktime(12, 24, 32, date('m'), date('d') - 2, date('Y')) . ", '');\r\n\t\t\t";
$db->query($sql);
//
// Register
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "register` (\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `eventid` int(11) NOT NULL,\r\n\t\t\t `payed` int(1) NOT NULL,\r\n\t\t\t `appeared` int(1) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Rights
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "rights` (\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `mod` varchar(64) NOT NULL,\r\n\t\t\t `description` varchar(64) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "rights` (`name`, `mod`, `description`) VALUES\r\n\t\t\t('manage', 'stat', ''),\r\n\t\t\t('sessions', 'admin', ''),\r\n\t\t\t('users', 'admin', ''),\r\n\t\t\t('personal_fields', 'admin', ''),\r\n\t\t\t('groups', 'admin', ''),\r\n\t\t\t('menu', 'admin', ''),\r\n\t\t\t('mod', 'admin', ''),\r\n\t\t\t('config', 'admin', ''),\r\n\t\t\t('comments', 'admin', ''),\r\n\t\t\t('content', 'admin', ''),\r\n\t\t\t('log', 'admin', ''),\r\n\t\t\t('groupware', 'admin', ''),\r\n\t\t\t('contact', 'admin', ''),\r\n\t\t\t('boxes', 'admin', ''),\r\n\t\t\t('backup', 'admin', ''),\r\n\t\t\t('manage', 'imprint', ''),\r\n\t\t\t('manage', 'calendar', ''),\r\n\t\t\t('editor', 'detailedpoll', ''),\r\n\t\t\t('manage', 'guestbook', ''),\r\n\t\t\t('manage', 'events', ''),\r\n\t\t\t('manage', 'media', ''),\r\n\t\t\t('upload', 'media', ''),\r\n\t\t\t('manage', 'news', ''),\r\n\t\t\t('admin', 'tetris', ''),\r\n\t\t\t('editor', 'poll', ''),\r\n\t\t\t('manage', 'board', ''),\r\n\t\t\t('manage', 'shoutbox', ''),\r\n\t\t\t('manage', 'smartstudies', '');";
$db->query($sql);
//
// Shoutbox
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "shoutbox` (\r\n\t\t\t `shoutid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `text` varchar(255) NOT NULL,\r\n\t\t\t PRIMARY KEY (`shoutid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "shoutbox` (`shoutid`, `userid`, `timestamp`, `text`) VALUES\r\n\t\t\t(1, 1, " . mktime(12, 41, 15, date('m'), date('d') - 2, date('Y')) . ", 'Hey zusammen!'),\r\n\t\t\t(2, 3, " . mktime(16, 32, 23, date('m'), date('d') - 1, date('Y')) . ", 'Eh, was geht?'),\r\n\t\t\t(3, 6, " . mktime(21, 21, 53, date('m'), date('d') - 1, date('Y')) . ", 'Laaaangweillig'),\r\n\t\t\t(4, 11, " . mktime(13, 13, 42, date('m'), date('d') - 1, date('Y')) . ", 'Interesanter[url=http://www.apfelsoft.net/article.html?categoryid=15&articleid=21] Artikel[/url]'),\r\n\t\t\t(5, 21, " . mktime(date('H'), date('i') - 10, 0, date('m'), date('d'), date('Y')) . ", 'Wer kommt mit heute Vampire jagen?');\r\n\t\t\t";
$db->query($sql);
//
// Stat
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "stat` (\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL,\r\n\t\t\t `duration` int(11) NOT NULL,\r\n\t\t\t `last_action` int(11) NOT NULL,\r\n\t\t\t `referer` varchar(1023) DEFAULT NULL,\r\n\t\t\t `browseragent` varchar(255) DEFAULT NULL,\r\n\t\t\t `os` varchar(255) DEFAULT NULL,\r\n\t\t\t `ipadress` varchar(16) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Tetris_Attack
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "tetris_attack` (\r\n\t\t\t `nickname` varchar(255) NOT NULL,\r\n\t\t\t `rows` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Tetris_Chat
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "tetris_chat` (\r\n\t\t\t `chatid` bigint(20) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `type` int(3) NOT NULL,\r\n\t\t\t `nickname` varchar(255) NOT NULL,\r\n\t\t\t `text` varchar(255) NOT NULL,\r\n\t\t\t PRIMARY KEY (`chatid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;";
$db->query($sql);
//
// Tetris_Highscore
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "tetris_highscore` (\r\n\t\t\t `nickname` varchar(255) NOT NULL,\r\n\t\t\t `score` bigint(20) NOT NULL,\r\n\t\t\t `lines` bigint(20) NOT NULL,\r\n\t\t\t `level` int(11) NOT NULL,\r\n\t\t\t `timestamp` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "tetris_highscore` (`nickname`, `score`, `lines`, `level`, `timestamp`) VALUES\r\n\t\t\t('Chuck', 9999999999, 999999, 99999, " . mktime(13, 37, 00, date('m'), date('d') - 4, date('Y')) . "),\r\n\t\t\t('Marvin', 5000001, 356, 35, " . mktime(12, 11, 15, date('m'), date('d') - 3, date('Y')) . "),\r\n\t\t\t('Gabi', 601235, 281, 28, " . mktime(16, 22, 13, date('m'), date('d') - 32, date('Y')) . "),\r\n\t\t\t('Admin', 50000, 103, 10, " . mktime(3, 51, 13, date('m'), date('d') - 1, date('Y')) . "),\r\n\t\t\t('Spartian', 9000, 23, 2, " . mktime(10, 12, 23, date('m'), date('d') - 2, date('Y')) . "),\r\n\t\t\t('Noob', 403, 2, 1, " . mktime(3, 51, 13, date('m'), date('d') - 1, date('Y')) . ");";
$db->query($sql);
//
// Tetris_Player
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "tetris_player` (\r\n\t\t\t `nickname` varchar(255) NOT NULL,\r\n\t\t\t `ipadress` varchar(31) NOT NULL,\r\n\t\t\t `score` bigint(20) NOT NULL,\r\n\t\t\t `level` int(11) NOT NULL,\r\n\t\t\t `last_action` int(11) NOT NULL,\r\n\t\t\t `last_real_action` int(11) NOT NULL,\r\n\t\t\t `alive` int(1) NOT NULL,\r\n\t\t\t `master` int(1) NOT NULL,\r\n\t\t\t `field` varchar(512) NOT NULL,\r\n\t\t\t `uniquid` varchar(100) NOT NULL,\r\n\t\t\t `games` int(5) NOT NULL,\r\n\t\t\t `wins` int(5) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Tetris_Start
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "tetris_start` (\r\n\t\t `nickname` varchar(255) NOT NULL,\r\n\t\t `seed` int(10) NOT NULL\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Thread
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "thread` (\r\n\t\t\t `threadid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `boardid` int(11) NOT NULL,\r\n\t\t\t `thread` varchar(64) NOT NULL,\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `lastpost` int(11) NOT NULL,\r\n\t\t\t `sticky` int(1) NOT NULL,\r\n\t\t\t `hits` int(11) NOT NULL,\r\n\t\t\t `closed` int(1) NOT NULL,\r\n\t\t\t PRIMARY KEY (`threadid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;";
$db->query($sql);
$sql = "INSERT INTO `" . MYSQL_TABLE_PREFIX . "thread` (`threadid`, `boardid`, `thread`, `userid`, `lastpost`, `sticky`, `hits`, `closed`) VALUES\r\n\t\t\t(1, 1, 'Was macht ihr so mit eurem vielen Geld', 25, 1, 0, 0, 0),\r\n\t\t\t(2, 3, 'Geburtstagsparty', 12, 2, 0, 0, 0),\r\n\t\t\t(3, 2, 'Mathe Lerngruppe', 4, 5, 0, 0, 0),\r\n\t\t\t(4, 1, 'Suche Verstärkung im Team', 11, 7, 0, 0, 0);";
$db->query($sql);
//
// Thread_Abo
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "thread_abo` (\r\n\t\t\t `userid` int(11) NOT NULL,\r\n\t\t\t `threadid` int(11) NOT NULL\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
$db->query($sql);
//
// Events
//
$sql = "CREATE TABLE IF NOT EXISTS `" . MYSQL_TABLE_PREFIX . "events` (\r\n\t\t\t `eventid` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t `name` varchar(64) NOT NULL,\r\n\t\t\t `description` varchar(512) NOT NULL,\r\n\t\t\t `start` int(11) NOT NULL,\r\n\t\t\t `end` int(11) NOT NULL,\r\n\t\t\t `reg_start` int(11) NOT NULL,\r\n\t\t\t `reg_end` int(11) NOT NULL,\r\n\t\t\t `min_age` int(11) NOT NULL,\r\n\t\t\t `agb` text NOT NULL,\r\n\t\t\t `last_check` int(11) NOT NULL,\r\n\t\t\t `login_active` int(1) NOT NULL,\r\n\t\t\t `seats` int(11) NOT NULL,\r\n\t\t\t `free` int(1) NOT NULL,\r\n\t\t\t `credits` int(11) NOT NULL,\r\n\t\t\t PRIMARY KEY (`eventid`)\r\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$db->query($sql);
}
case 'add':
if ($isAllowed) {
$smarty->assign('domains', getDomainList());
$smarty->assign('languages', array_merge(array('' => ''), $lang->listLanguages()));
$breadcrumbs->addElement($lang->get('manage_movies'), makeURL($mod, array('mode' => 'manage')));
if ($mode == 'add') {
$breadcrumbs->addElement($lang->get('add'), makeURL($mod, array('mode' => 'add')));
} else {
$breadcrumbs->addElement($lang->get('edit'), makeURL($mod, array('mode' => 'edit', 'movieid' => $movieid)));
}
if (isset($_POST['save'])) {
if ($movieid == 0) {
$db->insert('movies', array('title', 'description', 'urlid', 'order', 'thumbnail', 'language', 'hidden', 'domainid'), array("'" . $_POST['title'] . "'", "'" . $_POST['description'] . "'", "'" . $_POST['urlid'] . "'", (int) $_POST['order'], (int) $_POST['thumbnail'], "'" . $_POST['language'] . "'", @(int) $_POST['hidden'], @(int) $_POST['domainid']));
redirect(makeURL($mod, array('mode' => 'manage')));
} else {
$db->update('movies', "`title`='" . secureMySQL($_POST['title']) . "',\r\n\t\t\t\t\t\t\t`description`='" . secureMySQL($_POST['description']) . "',\r\n\t\t\t\t\t\t\t`urlid`='" . secureMySQL($_POST['urlid']) . "',\r\n\t\t\t\t\t\t\t`order`=" . (int) $_POST['order'] . ",\r\n\t\t\t\t\t\t\t`thumbnail`=" . (int) $_POST['thumbnail'] . ",\r\n\t\t\t\t\t\t\t`language`='" . secureMySQL($_POST['language']) . "',\r\n\t\t\t\t\t\t\t`hidden`=" . @(int) $_POST['hidden'] . ",\r\n\t\t\t\t\t\t\t`domainid`=" . @(int) $_POST['domainid'], "`movieid`=" . $movieid);
}
}
if ($movieid > 0) {
$movie = $db->selectOneRow('movies', '*', 'movieid = ' . $movieid);
$smarty->assign('movie', $movie);
}
$smarty->assign('path', $template_dir . '/manage_movie.tpl');
}
break;
case 'manage':
if ($isAllowed) {
$breadcrumbs->addElement($lang->get('manage_movies'), makeURL($mod, array('mode' => 'manage')));
$movies = $db->selectList('movies', '*', '1', '`order` ASC');
$smarty->assign('movies', $movies);
$smarty->assign('path', $template_dir . '/manage.tpl');
function syncCreateCategory($usermail, $password, $name, $parentid = 0)
{
global $db;
$tbl_cat = MYSQL_TABLE_PREFIX . 'media_categories';
$assigned_groups = getAssignedGroups($usermail, $password);
if ($assigned_groups == false) {
return false;
}
$parentid = (int) $parentid;
$parent = $db->selectOneRow($tbl_cat, "*", "`categoryid`=" . $parentid);
if ($parent == null && $parentid > 0) {
return false;
}
if ($db->selectOneRow($tbl_cat, "*", "`name`='" . secureMySQL($name) . "'") != null) {
return false;
}
createCategory($name, $parentid);
return true;
}
function postEdit($postid, $post)
{
global $db;
$tbl_post = MYSQL_TABLE_PREFIX . 'post';
global $login;
$sql = "UPDATE `" . $tbl_post . "` SET\r\n\t\t\t\t`post`='" . secureMySQL($post) . "' \r\n\t\t\t\tWHERE `postid`=" . (int) $postid . ";";
$db->query($sql);
}
$smarty->assign('priority', $priority);
$task = $db->selectOneRow($tbl_groupware, "*", "`groupwareid`=" . (int) $_GET['taskid']);
$task['end'] = timeLeft($task['end']);
$task['state'] = $states[$task['state']];
$task['priority'] = $priority[$task['priority']];
$task['description'] = $bbcode->parse($task['description']);
$smarty->assign('task', $task);
$smarty->assign('url_reference', makeURL($mod, array('mode' => 'contact', 'contactid' => $task['contactid'])));
$smarty->assign('url_edit', makeURL($mod, array('mode' => 'groupware', 'action' => 'edittask', 'taskid' => $task['groupwareid'])));
$smarty->assign('url_remove', makeURL($mod, array('mode' => 'groupware', 'action' => 'removetask', 'taskid' => $task['groupwareid'])));
$breadcrumbs->addElement($task['title'], makeURL($mod, array('mode' => 'groupware', 'action' => 'view', 'taskid' => $task['groupwareid'])));
break;
case 'edittask':
if (isset($_POST['save']) && trim($_POST['title']) != '') {
$end = mktime($_POST['Time_Hour'], $_POST['Time_Minute'], 0, $_POST['Date_Month'], $_POST['Date_Day'], $_POST['Date_Year']);
$db->update($tbl_groupware, "`title`='" . secureMySQL($_POST['title']) . "', `description`='" . secureMySQL($_POST['description']) . "', \r\n\t\t\t\t\t\t\t`end`=" . $end . ", `state`=" . (int) $_POST['state'] . ", `priority`=" . (int) $_POST['priority'] . ", `userid`=" . (int) $_POST['private'], "`groupwareid`=" . (int) $_GET['taskid']);
$notify->add($lang->get('groupware'), $lang->get('changes_saved'));
}
$smarty->assign('path', $template_dir . "/edittask.tpl");
$task = $db->selectOneRow($tbl_groupware, "*", "`groupwareid`=" . (int) $_GET['taskid']);
$smarty->assign('task', $task);
$breadcrumbs->addElement($task['title'], makeURL($mod, array('mode' => 'groupware', 'action' => 'view', 'taskid' => $task['groupwareid'])));
$breadcrumbs->addElement($lang->get('edit'), makeURL($mod, array('mode' => 'groupware', 'action' => 'edittask', 'taskid' => $task['groupwareid'])));
$smarty->assign('state', $states);
$smarty->assign('priority', $priority);
$smarty->assign('userid', $login->currentUserID());
break;
case 'newtask':
if (isset($_POST['save']) && trim($_POST['title']) != '') {
$end = mktime($_POST['Time_Hour'], $_POST['Time_Minute'], 0, $_POST['Date_Month'], $_POST['Date_Day'], $_POST['Date_Year']);
$db->insert($tbl_groupware, array('title', 'description', 'state', 'end', 'priority', 'userid'), array("'" . $_POST['title'] . "'", "'" . $_POST['description'] . "'", (int) $_POST['state'], $end, (int) $_POST['priority'], (int) $_POST['private']));
function isInstalled($mod)
{
global $db;
return $db->num_rows($this->table, "`mod`='" . secureMySQL($mod) . "'") > 0;
}
*/
$smarty->assign('available', $available);
if (isset($_POST['remove'])) {
$db->delete('beamer_mod', "`beamerid`=" . $beamerid);
$db->delete('beamer_list', "`beamerid`=" . $beamerid);
$notify->add($lang->get('beamer'), $lang->get('beamer_remove_done'));
} else {
$smarty->assign('path', $template_dir . "/edit.tpl");
if (isset($_POST['save'])) {
$modlist = $db->selectList('beamer_mod', "*", "`beamerid` = " . $beamerid);
if (count($modlist) > 0) {
foreach ($modlist as $mod) {
if (@$_POST['remove_' . $mod['id']] == '1') {
$db->delete('beamer_mod', "`beamerid`=" . $beamerid . " AND `id`=" . $mod['id']);
} else {
$db->update('beamer_mod', "`order`=" . (int) $_POST['order_' . $mod['id']] . ",\r\n\t\t\t\t\t\t\t\t\t `duration`=" . (int) $_POST['duration_' . $mod['id']] . ", \r\n\t\t\t\t\t\t\t\t\t `url`='" . secureMySQL($_POST['url_' . $mod['id']]) . "'", "`id`=" . $mod['id']);
}
}
}
if (trim($_POST['url_0']) != '') {
$db->insert('beamer_mod', array('beamerid', 'order', 'duration', 'url'), array($beamerid, (int) $_POST['order_0'], (int) $_POST['duration_0'], "'" . $_POST['url_0'] . "'"));
}
}
$modlist = $db->selectList('beamer_mod', "*", "`beamerid` = " . $beamerid);
$smarty->assign('list', $modlist);
}
break;
case 'run':
$smarty->assign('path', $template_dir . "/run.tpl");
$modlist = $db->selectList('beamer_mod', "*", "`beamerid` = " . $beamerid);
$smarty->assign('list', $modlist);
$action = '';
} else {
// get user
$u = $user->getUserByID($_GET['userid']);
// delete user
$smarty->assign('path', $template_dir . "/user_delete.tpl");
$breadcrumbs->addElement($u['nickname'], makeURL($mod, array('mode' => 'users', 'action' => 'edit', 'userid' => $u['userid'])));
$breadcrumbs->addElement($lang->get('options_delete'), makeURL($mod, array('mode' => 'users', 'action' => 'delete', 'userid' => $u['userid'])));
}
default:
$find = '';
if (isset($_POST['find'])) {
$find = secureMySQL($_POST['find']);
}
$dir = secureMySQL(isset($_GET['dir']) ? $_GET['dir'] : '');
$order = secureMySQL(isset($_GET['order']) ? $_GET['order'] : '');
if ($dir == 'ASC') {
$other_dir = 'DESC';
} else {
$other_dir = 'ASC';
}
if ($order == '') {
$order = 'nickname';
}
// usercount
$uc = $user->count();
$smarty->assign('usercount', $uc);
// read users
if ($find == '') {
@$pages->setValues((int) $_GET['page'], $upp, $uc);
$userlist = $user->listUsers($pages->currentValue(), $upp, $order . " " . $dir, $find);
$ingredients = $db->selectList('catering_ingredients', '*', '1', '`name` ASC');
foreach ($ingredients as $i => $ingredient) {
$ingredients[$i]['url'] = 'ajax_request.php?mod=catering&file=edit.ingredients.ajax&ingredientid=' . $ingredient['ingredientid'];
$ingredients[$i]['available'] = intToYesNo($ingredient['available']);
}
$smarty->assign('ingredients', $ingredients);
break;
case 'categories':
default:
$breadcrumbs->addElement($lang->get('categories'), makeURL($mod, array('mode' => 'admin', 'action' => 'categories')));
$smarty->assign('path', $template_dir . '/categories.admin.tpl');
if (isset($_POST['NewCategorySubmitButton'])) {
@$db->insert('catering_categories', array('rank', 'name', 'visible'), array((int) $_POST['OrderTextBox'], "'" . $_POST['NameTextBox'] . "'", (int) $_POST['VisibleCheckBox']));
}
if (isset($_POST['EditCategorySubmitButton'])) {
@$db->update('catering_categories', "`rank`=" . (int) $_POST['OrderTextBox'] . ",\r\n\t\t\t\t\t`name`='" . secureMySQL($_POST['NameTextBox']) . "',\r\n\t\t\t\t\t`visible`=" . (int) $_POST['VisibleCheckBox'], "`categoryid`=" . (int) $_POST['categoryid']);
}
if (isset($_POST['DeleteCategorySubmitButton'])) {
$db->delete('catering_categories', "`categoryid`=" . (int) $_POST['categoryid']);
}
$categories = $db->selectList('catering_categories', '*', '1', '`rank` ASC');
foreach ($categories as $i => $category) {
$categories[$i]['url'] = 'ajax_request.php?mod=catering&file=edit.categories.ajax&categoryid=' . $category['categoryid'];
$categories[$i]['visible'] = intToYesNo($category['visible']);
}
$smarty->assign('categories', $categories);
break;
}
$url['AddCategory'] = 'ajax_request.php?mod=' . $mod . '&file=add.categories.ajax';
$url['AddIngredient'] = 'ajax_request.php?mod=' . $mod . '&file=add.ingredients.ajax';
$url['AddProduct'] = 'ajax_request.php?mod=' . $mod . '&file=add.products.ajax';
<?php
if (trim($_GET['search_string']) != '') {
$lang->addModSpecificLocalization('admission');
$table = MYSQL_TABLE_PREFIX . 'events';
$tbl_reg = MYSQL_TABLE_PREFIX . 'register';
$tbl_users = MYSQL_TABLE_PREFIX . 'users';
$paystates = array(0 => $lang->get('not_payed'), 1 => $lang->get('payed_pre'), 2 => $lang->get('payed_box_office'), 3 => $lang->get('pay_reserv'), 4 => $lang->get('pay_wait'), 5 => $lang->get('pay_assistant'), 6 => $lang->get('pay_vip'), 7 => $lang->get('pay_press'), 8 => $lang->get('pay_bonus'));
$result = $db->query("SELECT * FROM `" . $tbl_reg . "`, `" . $tbl_users . "`\r\n\t\t\t\t\t\tWHERE `" . $tbl_reg . "`.`userid` = `" . $tbl_users . "`.`userid`\r\n\t\t\t\t\t\tAND `" . $tbl_reg . "`.`eventid` = " . (int) $_GET['eventid'] . "\r\n\t\t\t\t\t\tAND \r\n\t\t\t\t\t\t(INSTR(`" . $tbl_users . "`.`nickname`, '" . secureMySQL($_GET['search_string']) . "') > 0\r\n\t\t\t\t\t\tOR INSTR(`" . $tbl_users . "`.`prename`, '" . secureMySQL($_GET['search_string']) . "') > 0\r\n\t\t\t\t\t\tOR INSTR(`" . $tbl_users . "`.`lastname`, '" . secureMySQL($_GET['search_string']) . "') > 0)\r\n\t\t\t\t\t\tLIMIT 10;");
while ($row = mysql_fetch_assoc($result)) {
$l[] = $row;
}
$smarty->assign('search_string', $_GET['search_string']);
$smarty->assign('paystates', $paystates);
$smarty->assign('list', @$l);
$smarty->display('../mod/default/admission/userlist.tpl');
}
function insert($table, $fields, $values)
{
$table = $this->addTablePrefix($table);
$f = implode('`, `', $fields);
foreach ($values as $v) {
if (substr($v, 0, 1) == "'" || substr($v, strlen($v) - 1, 1) == "'") {
$vl[] = "'" . secureMySQL(substr($v, 1, strlen($v) - 2)) . "'";
} else {
$vl[] = secureMySQL($v);
}
}
$v = implode(', ', $vl);
$sql = "INSERT INTO `" . secureMySQL($table) . "`\r\n\t\t\t\t\t(`" . $f . "`)\r\n\t\t\t\t\tVALUES\r\n\t\t\t\t\t(" . $v . ");";
$result = $this->query($sql);
return mysql_insert_id();
}
if (allFilled($_POST['category'], $_POST['summary'], $_POST['description'])) {
$db->insert('bugtracker_issues', array('projectid', 'categoryid', 'reproducible', 'effect', 'priority', 'summary', 'description', 'additional', 'userid', 'timestamp'), array($projectid, $issue['categoryid'], "'" . $issue['reproducible'] . "'", "'" . $issue['effect'] . "'", "'" . $issue['priority'] . "'", "'" . $issue['summary'] . "'", "'" . $issue['description'] . "'", "'" . $issue['additional'] . "'", $login->currentUserID(), time()));
$notify->add($lang->get('bugtracker'), $lang->get('addIssueDone'));
} else {
$notify->add($lang->get('bugtracker'), $lang->get('fill_all_fields'));
}
}
break;
case 'editProject':
if (!$isallowed) {
break;
}
$menu->addSubElement($mod, $lang->get('deleteProject'), 'deleteProject', array('projectid' => $projectid));
$breadcrumbs->addElement($lang->get('editProject'), makeURL($mod, array('mode' => 'editProject', 'projectid' => $projectid)));
if (isset($_POST['save'])) {
$db->update('bugtracker_projects', "`name`='" . secureMySQL($_POST['name']) . "', \r\n\t\t\t\t\t\t\t`description`='" . secureMySQL($_POST['description']) . "'", "`projectid`=" . $project['projectid']);
$project['name'] = $_POST['name'];
$project['description'] = $_POST['description'];
$notify->add($lang->get('bugtracker'), $lang->get('editProjectDone'));
}
$smarty->assign('path', $template_dir . "/edit.tpl");
$smarty->assign('project', $project);
break;
case 'deleteProject':
if (!$isallowed) {
break;
}
$smarty->assign('path', $template_dir . "/delete.tpl");
$smarty->assign('url_no', makeURL($mod, array('mode' => 'editProject', 'projectid' => $projectid)));
if (isset($_POST['yes'])) {
$db->delete('bugtracker_projects', "`projectid`=" . $projectid);
function count($mod, $contentid)
{
return (int) $this->db->num_rows($this->table, "`mod`='" . secureMySQL($mod) . "' AND `contentid`=" . (int) $contentid);
}
function setSetting($tournamentid, $settingid, $value)
{
global $db;
if (0 == $db->num_rows('tournamentsettings', "`tournamentid`=" . (int) $tournamentid . " AND `settingid`=" . (int) $settingid)) {
$this->addSetting($tournamentid, $settingid, $value);
} else {
$db->update('tournamentsettings', "`value`='" . secureMySQL($value) . "'", "\r\n\t\t\t\t\t`tournamentid`=" . (int) $tournamentid . "\r\n\t\t\t\t\tAND `settingid`=" . (int) $settingid);
}
}
<?php
if (!$rights->isAllowed('events', 'manage')) {
die;
}
if (isset($_GET['reg'])) {
if ($_GET['reg'] == '1') {
$db->insert('register', array('eventid', 'userid'), array((int) $_GET['eventid'], (int) $_GET['userid']));
} else {
$db->delete('register', "`userid`=" . (int) $_GET['userid'] . " AND \r\n\t\t\t\t`eventid`=" . (int) $_GET['eventid']);
}
} else {
$find = secureMySQL($_GET['find']);
$tbl_users = MYSQL_TABLE_PREFIX . "users";
$tbl_register = MYSQL_TABLE_PREFIX . "register";
if (strlen($find) > 1) {
$sql = "SELECT * FROM\r\n\t\t\t\t\t`" . $tbl_users . "`\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t(\r\n\t\t\t\t\t\tINSTR(`" . $tbl_users . "`.`nickname`, '" . $find . "') > 0\r\n\t\t\t\t\t\tOR\r\n\t\t\t\t\t\tINSTR(`" . $tbl_users . "`.`prename`, '" . $find . "') > 0\r\n\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t`" . $tbl_users . "`.`userid`=" . (int) $find . "\r\n\t\t\t\t\t)\r\n\t\t\t\t\tLIMIT 10;\r\n\t\t\t";
$result = $db->query($sql);
while ($row = mysql_fetch_assoc($result)) {
$row['reg'] = (int) $db->num_rows('register', "`userid`=" . $row['userid'] . " AND `eventid`=" . (int) $_GET['eventid']) > 0;
$userList[] = $row;
}
}
$smarty->assign('userList', @$userList);
$smarty->display('../mod/default/events/results.reg.ajax.tpl');
}
if ($rights->isAllowed($mod, 'manage')) {
$menu->addSubElement($mod, $lang->get('imprint_edit'), 'admin');
$right['manage'] = true;
}
switch ($_GET['mode']) {
case "admin":
if ($right['manage']) {
if (@$_POST['save']) {
$db->query("DELETE FROM " . $table . " WHERE true");
if ($_POST['same'] == "1") {
$_POST['cont_name'] = $_POST['owner_name'];
$_POST['cont_street'] = $_POST['owner_street'];
$_POST['cont_loc'] = $_POST['owner_loc'];
}
$imprint = htmlspecialchars($_POST['imprint']);
$db->query("INSERT INTO " . $table . " VALUES ('" . secureMySQL($_POST['owner_name']) . "','" . secureMySQL($_POST['owner_street']) . "','" . secureMySQL($_POST['owner_loc']) . "','" . secureMySQL($_POST['owner_tel']) . "','" . secureMySQL($_POST['owner_mail']) . "','" . secureMySQL($_POST['cont_name']) . "','" . secureMySQL($_POST['cont_street']) . "','" . secureMySQL($_POST['cont_loc']) . "','" . secureMySQL($_POST['court']) . "','" . $imprint . "')");
global $log;
$log->add('imprint', 'updated');
}
$breadcrumbs->addElement($lang->get('edit'), makeURL($mod, array('mode' => 'admin')));
$smarty->assign('path', $template_dir . '/admin.tpl');
$entry = $db->selectOneRow($table, "*");
if ($entry['owner_name'] != "") {
$entry['same'] = $entry['owner_name'] == $entry['cont_name'] ? "checked='checked'" : "";
}
if ($entry['same'] == "checked='checked'") {
$entry['cont_name'] = "";
$entry['cont_street'] = "";
$entry['cont_loc'] = "";
}
$smarty->assign('edit', $entry);
