function sigControl()
{
global $pref, $board_time;
$r_log = db_query("SELECT\n user_ismod,\n user_isadmin,\n ad_sig,\n ad_time\n FROM " . $pref . "user WHERE user_id='{$_SESSION['userid']}'");
if (db_rows($r_log) != 1) {
return 0;
} else {
$a_log = db_result($r_log);
$ismod = 0;
if ($a_log['user_ismod'] == 1 || $a_log['user_isadmin'] == 1) {
$ismod = 1;
}
$sigok = 0;
if ($a_log['ad_sig'] == $_SESSION['adsig']) {
$sigok = 1;
}
$timeok = 0;
if ($a_log['ad_time'] > $board_time - 600) {
$timeok = 1;
}
if ($ismod == 1 && $sigok == 1 && $timeok == 1) {
return 1;
} else {
return 0;
}
}
}
function annoncForm($announc, $action, $boards)
{
global $pref;
$boards[] = 'a';
$back = '<form action="announc.php" method="post">
<table cellpadding="4" cellspacing="0" border="0">
<tr>
<td style="width:200px"><b>Bezeichener</b><br /><font size="1">(Wenn Du das Feld leer lässt<br />ist der Bezeichner <b>Ankündigung</b>)</font></td>
<td> </td>
<td style="vertical-align:top">
<input type="text" maxlength="50" name="announc[word]" value="' . (isset($announc['newsword']) ? decode(addslashes($announc['newsword'])) : '') . '" id="border-tab" />
</td>
</tr>
<tr>
<td><b>Topic</b></td>
<td> </td>
<td><input type="text" size="50" maxlength="255" name="announc[topic]" value="' . (isset($announc['newstopic']) ? decode(addslashes($announc['newstopic'])) : '') . '" id="border-tab" /></td>
</tr>
<tr>
<td style="vertical-align:top"><b>Text</b></td>
<td> </td>
<td><textarea cols="50" rows="6" name="announc[text]" id="border-tab">' . (isset($announc['newstext']) ? decode(addslashes($announc['newstext'])) : '') . '</textarea></td>
</tr>
<tr>
<td><b>Index</b></td>
<td> </td>
<td>
<input type="checkbox" name="announc[index]" value="1"' . (in_array('0', $boards) === FALSE ? '' : ' checked') . ' />
<font size="1">Auch auf der Indexseite anzeigen.</font>
</td>
</tr>
<tr>
<td style="vertical-align:top"><b>Boards</b></td>
<td> </td>
<td>';
$back .= '<select name="boardids[]" size="5" id="border-tab" multiple>';
$r_boards = db_query("SELECT\n board_id,\n board_name\n FROM " . $pref . "board");
if (db_rows($r_boards) == 0) {
$back .= 'Noch keine Boards angelegt.';
} else {
while ($a_boards = db_result($r_boards)) {
$back .= '<option value="' . $a_boards['board_id'] . '"' . (in_array($a_boards['board_id'], $boards) === FALSE ? '' : ' selected') . '>' . $a_boards['board_name'] . '</option>';
}
}
$back .= '</select>
</td>
</tr>
</table>
<br />
<center>
<input type="hidden" name="action" value="' . $action . '" />
<input type="hidden" name="announc[id]" value="' . (isset($announc['newsid']) ? $announc['newsid'] : '') . '" />
<input type="submit" value=" Senden " id="border-tab" />
</center>
</form>';
return $back;
}
if (U_ID != 0) {
$r_board = db_query("SELECT\n board_id\n FROM " . $pref . "board WHERE category!='0' AND disabled!='1'");
if (db_rows($r_board) > 0) {
while ($a_board = db_result($r_board)) {
$session_var_name = 'b' . $a_board['board_id'];
$r_post_id = db_query("SELECT\n MAX(post_id)\n FROM " . $pref . "post WHERE board_id='{$a_board['board_id']}'");
if (db_rows($r_post_id) == 0) {
$_SESSION[$session_var_name] = 0;
} else {
$a_post_id = db_result($r_post_id);
list(, $poid) = each($a_post_id);
$_SESSION[$session_var_name] = $poid;
}
}
}
}
message_redirect('Alle Foren wurden als gelesen makiert, bitte warten ...', 'index.php');
} else {
if (U_ID != 0) {
$session_var_name = 'b' . $boardid;
$r_post_id = db_query("SELECT\n MAX(post_id)\n FROM " . $pref . "post WHERE board_id='{$boardid}'");
if (db_rows($r_post_id) == 0) {
$_SESSION[$session_var_name] = 0;
} else {
$a_post_id = db_result($r_post_id);
list(, $poid) = each($a_post_id);
$_SESSION[$session_var_name] = $poid;
}
}
message_redirect('Board wurde als gelesen makiert, bitte warten ...', 'board.php?boardid=' . $boardid);
}
function board_nav($boardid, $threadid, $nav_path)
{
global $TBoard, $pref;
// thread --
$r_thread = db_query("SELECT\n thread_id,\n\t thread_topic\n FROM " . $pref . "thread WHERE thread_id='{$threadid}' AND board_id='{$boardid}'");
if (db_rows($r_thread) != 1) {
message('Sorry! Fehlerhafter Link.', 'Fehler', 0);
} else {
$thread = db_result($r_thread);
}
// board --
$r_board = db_query("SELECT \n\t board_id,\n\t\t board_name,\n\t\t category\n\t FROM " . $pref . "board WHERE board_id='{$boardid}'");
$board = db_result($r_board);
// category --
$r_category = db_query("SELECT\n\t category_id,\n\t\t category_name\n\t FROM " . $pref . "category WHERE category_id='{$board['category']}'");
$category = db_result($r_category);
$nav_path .= ' >> <a href="category.php?catid=' . $category['category_id'] . '"
class="bg">' . (strlen($category['category_name']) > 30 ? substr($category['category_name'], 0, 27) . '...' : $category['category_name']) . '</a>';
$nav_path .= ' >> <a href="board.php?boardid=' . $board['board_id'] . '"
class="bg">' . (strlen($board['board_name']) > 50 ? substr($board['board_name'], 0, 47) . '...' : $board['board_name']) . '</a>';
$nav_path .= ' >> <a href="showtopic.php?boardid=' . $board['board_id'] . '&threadid=' . $thread['thread_id'] . '"
class="bg">' . $thread['thread_topic'] . '</a>';
mysql_free_result($r_thread);
mysql_free_result($r_board);
mysql_free_result($r_category);
return $nav_path;
}
if (!isset($_SESSION['openclose'])) {
// openclose schon erzeugt ?
$_SESSION['openclose'] = '0';
}
$boards = '';
while ($a_category = db_result($r_category)) {
$new_cat = 0;
$session_cat = 'c' . $a_category['category_id'];
// openclose Variable
if ($_SESSION['openclose'] == 0) {
$_SESSION[$session_cat] = $a_category['category_is_open'];
// SESSION_vars für openclose setzen
}
$board_count = 0;
$r_boards = db_query("SELECT\n\t board_id,\n\t\t board_name,\n\t\t\t board_under,\n\t\t\t last_act_time,\n\t\t\t last_post_id,\n\t\t\t last_act_user, \n\t\t\t last_thread_id, \n\t\t\t last_act_thread,\n\t\t\t threads,\n\t\t\t posts,\n\t\t\t threads_del,\n\t\t\t posts_del\n\t FROM " . $pref . "board WHERE disabled='0' AND category='" . $a_category['category_id'] . "' ORDER BY board_order ASC");
if (db_rows($r_boards) > 0) {
$category = '';
while ($board = db_result($r_boards)) {
$P = boardPermissions(U_GROUPIDS, $board['board_id']);
if ($P[0] == 1) {
$board_count++;
$session_var = 'b' . $board['board_id'];
$new_topic = 0;
$gif = '';
if (U_ID != 0) {
if ($board['last_post_id'] > $_SESSION[$session_var] && $board['last_post_id'] != 0) {
$gif = '_new';
$new_topic = 1;
$new_cat = 1;
}
}
$user = db_result($r_user);
$r_pm = db_query("SELECT\n\t COUNT(pm_id)\n\t FROM " . $pref . "pm WHERE pm_empf='" . U_NAME . "'");
$pm = db_result($r_pm);
list(, $pm_count) = each($pm);
$r_pm = db_query("SELECT\n\t COUNT(pm_id)\n\t FROM " . $pref . "pm WHERE pm_empf='" . U_NAME . "' AND pm_gelesen='0'");
$pm = db_result($r_pm);
list(, $pm_noread) = each($pm);
db_query("UPDATE " . $pref . "user SET\n\t pm_count='{$pm_count}',\n\t\t pm_overflow='" . ($pm_count <= $config['max_pm_count'] ? 0 : 1) . "',\n\t\t pm_new='" . ($pm_noread == 0 ? 0 : 1) . "'\n\t WHERE user_id='" . U_ID . "'");
if ($no_delete == 1) {
message('<form action="pm.php" method="post" name="weiter">
Mindestens eine der gewälten PM wurde durch Dich geschützt.</form>', 'Geschützte PM gefunden', 2);
}
message_redirect('PM gelöscht, bitte warten ...', 'pm.php');
} elseif ($action == 'save') {
$r_pm = db_query("SELECT\n\t pm_saved\n\t FROM " . $pref . "pm WHERE pm_empf='" . U_NAME . "' AND pm_id='{$pmid}'");
if (db_rows($r_pm) == 1) {
$pm = db_result($r_pm);
$save = 0;
if ($pm['pm_saved'] == 0) {
$save = 1;
}
$r_pm = db_query("SELECT\n\t\t COUNT(pm_id)\n\t\t FROM " . $pref . "pm WHERE pm_empf='" . U_NAME . "' AND pm_saved='1'");
$pm = db_result($r_pm);
list(, $saved_pms) = each($pm);
if ($saved_pms >= $config['max_pm_saved'] && $save == 1) {
message('Du kannst maximal ' . $config['max_pm_saved'] . ' PMs schützen.', 'Maximum erreicht', 0);
}
db_query("UPDATE " . $pref . "pm SET\n\t\t pm_saved='{$save}'\n\t\t WHERE pm_id='{$pmid}'");
}
message_redirect('PM-Sicherung bearbeitet, bitte warten ...', 'pm.php');
} else {
case 2:
$endtime = $ban['time'] * 60;
}
$endtime = $board_time + $endtime;
}
// banedby aus header.inc übernehmen #############################################################
db_query("INSERT INTO " . $pref . "ban SET\n bantime='{$board_time}',\n banreason='" . addslashes($ban['reason']) . "',\n bannote='" . addslashes($ban['note']) . "',\n banedby='0',\n baned_name='" . addslashes($ban['user_name']) . "',\n baned_id='" . $user['user_id'] . "',\n timetoend='{$endtime}'");
$data['work'] = 'User: <b>' . $ban['user_name'] . '</b> ist gebannt.';
}
}
}
}
// banlist ----------------------------------------------------------
if ($action == 'banlist') {
$r_ban = db_query("SELECT\n *\n FROM " . $pref . "ban ORDER BY baned_name");
if (db_rows($r_ban) == 0) {
$data['work'] = 'Es sind keine User in der Bannliste';
} else {
$data['work'] = '<b>Bannliste</b><br />
<table width="100%" cellpadding="4" cellspacing="0" border="0">
<tr>
<td id="blank"><i>Username</i></td>
<td id="blank"><i>Bannbeginn</i></td>
<td id="blank"><i>Bannende</i></td>
<td id="blank"><i>Optionen</i></td>
</tr>';
$i = 0;
while ($a_ban = db_result($r_ban)) {
$data['work'] .= '<tr bgcolor="' . ($i % 2 == 0 ? '#DADADA' : '') . '">
<td id="blank">' . $a_ban['baned_name'] . '</td>
<td id="blank">' . date("d.m.Y H:i", $a_ban['bantime']) . '</td>';
</form>';
message($mess, 'Fehler', 1);
} else {
db_query("UPDATE " . $pref . "post SET\n\t\t\t\t post_text='" . addslashes($text) . "',\n\t\t\t\t\t guest_name='" . addslashes($new['autor']) . "',\n\t\t\t\t\t post_smilies='" . (isset($do_smilies) ? 1 : '') . "',\n\t\t\t\t\t last_edit_by='" . addslashes(U_NAME) . "',\n\t\t\t\t\t last_edit_time='{$board_time}',\n\t\t\t\t\t last_edit_ip='" . getenv('REMOTE_ADDR') . "',\n\t\t\t\t\t edit_count='" . ($post['edit_count'] + 1) . "',\n\t\t\t\t\t bcode='" . (isset($b_code) ? 1 : '') . "',\n\t\t\t\t\t sendmail='" . (isset($abbo) ? 1 : '') . "'\n\t\t\t\t WHERE post_id='{$postid}'");
if (P_EDITTOPIC == 1) {
db_query("UPDATE " . $pref . "thread SET\n\t\t\t\t\t thread_topic='" . addslashes($new['topic']) . "'\n\t\t\t\t\t WHERE thread_id='{$threadid}'");
}
message_redirect('Der Beitrag wurde editiert, bitte warten ...', 'showtopic.php?boardid=' . $boardid . '&threadid=' . $threadid . '&page=' . $page . '#p' . $postid);
}
}
} else {
message('Sorry! Du bist nich berechtigt dieses Posting zu editierten.', 'Rechte', 0);
}
} elseif ($action == 'delete') {
$r_post = db_query("SELECT\n\t deleted,\n\t\t user_id\n\t FROM " . $pref . "post WHERE thread_id='{$threadid}' AND post_id='{$postid}'");
if (db_rows($r_post) != 1) {
message('Sorry! Fehlerhafter Link', 'Fehler', 0);
}
$post = db_result($r_post);
if ($post['deleted'] == 1) {
message('Dieses Posting ist bereits als gelöscht makiert.<br />
Echtes löschen ist nur im Mod,- oder Admincenter durch Administratoren möglich.', 'Fehler', 0);
}
$del_thread = 0;
$r_post = db_query("SELECT\n\t MIN(post_id)\n\t FROM " . $pref . "post WHERE thread_id='{$threadid}'");
$post = db_result($r_post);
list(, $min_id) = each($post);
if ($min_id == $postid) {
$del_thread = 1;
}
$r_post = db_query("SELECT\n\t count(post_id)\n\t FROM " . $pref . "post WHERE thread_id='{$threadid}' AND deleted='0'");
$th_count += $board['threads_del'];
}
$data['thread_nav'] = check_pages($th_count, $config['thread_rows'], $page, 0, 'board.php?boardid=' . $board['board_id']);
// define LIMIT
if ($page == 'last') {
$page = $a_board['threads'];
}
$page = intval($page);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $config['thread_rows'];
$limit = $start . ', ' . $config['thread_rows'];
// threadrows--------------------------------
$r_thread = db_query("SELECT\n thread_id,\n\t\t\t board_id,\n replies,\n thread_autor,\n thread_topic,\n last_act_time,\n last_post_id,\n last_act_user,\n thread_icon,\n thread_views,\n\t\t\t thread_closed,\n sticky,\n deleted,\n replies_del,\n link\n FROM " . $pref . "thread WHERE board_id='" . $board['board_id'] . "' OR link='" . $board['board_id'] . "' ORDER BY sticky DESC,last_act_time DESC LIMIT " . $limit . " ");
if (db_rows($r_thread) < 1) {
$data['threads'] = '<tr><td class="cellb" colspan="6"><center><font color="[color_err]">Noch keine Threads angelegt.</font></center></td></tr>';
} else {
$data['threads'] = '';
while ($thread = db_result($r_thread)) {
if ($thread['deleted'] == 1 && P_SHOWDELETED != 1) {
continue;
} else {
$session_var = 'b' . $board['board_id'];
// icon
$iconadd = '';
$pic = 'icon/' . $thread['thread_icon'];
if ($thread['thread_closed'] == 1) {
$pic = 'closed';
}
if (U_ID != 0) {
$qlink = $_POST['qlink'];
if (!$qlink['link'] || !$qlink['name']) {
$data['work'] .= 'Du mußt wenigstens URL und Name angeben.';
} else {
if (substr($qlink['link'], 0, 7) != "http://") {
$qlink['link'] = "http://" . $qlink['link'];
}
db_query("INSERT INTO " . $pref . "qlink SET\n linkname='" . addslashes($qlink['name']) . "',\n linklink='" . addslashes($qlink['link']) . "',\n linkcount='" . intval($qlink['count']) . "',\n linkart='" . intval($qlink['art']) . "',\n linkalt='" . addslashes($qlink['alt']) . "',\n linkstatus='{$qlink['status']}'");
$data['work'] .= 'Link gespeichert.';
$action = '';
}
}
// list qlinks -------------------------------------------
if ($action == '') {
$r_qlink = db_query("SELECT\n *\n FROM " . $pref . "qlink");
if (db_rows($r_qlink) == 0) {
$data['work'] .= 'Keine quicklinks gespeichert.';
} else {
$data['work'] .= '<table width="100%" cellpadding="4" cellspacing="0" border="0">
<tr>
<td><i>Link</i></td>
<td> </td>
<td><i>Name</i></td>
<td> </td>
<td><i>Optionen</i></td>
</tr>';
$i = 0;
while ($a_qlink = db_result($r_qlink)) {
$data['work'] .= '<tr bgcolor="' . ($i % 2 == 0 ? '#DADADA' : '') . '">
<td><a href="' . $a_qlink['linklink'] . '">' . $a_qlink['linklink'] . '</a></td>
<td> </td>
function num_rows($query)
{
$query = db_rows($query);
return $query;
}
==============================================
*/
include 'inc/header.inc.php';
// nav_path ------------------------------------------
$data['nav_path'] .= ' >> Teampage';
// global Templates ----------------------------------
$TBoard = Get_Template('templates/' . $style['styletemplate'] . '/board.html');
$TTeam = Get_Template('templates/' . $style['styletemplate'] . '/team.html');
$TTeamrow = Get_Template('templates/' . $style['styletemplate'] . '/teamrow.html');
if (U_ID < 1 && $config['guest_team'] == 0) {
message('Die Teampage ist wurde vom Administrator für Gäste gesperrt.', 'Rechte', 0);
}
$r_team = db_query("SELECT\n user_name,\n\t user_mail,\n\t user_ismod,\n\t user_isadmin,\n\t user_lastacttime\n FROM " . $pref . "user WHERE user_team='1' ORDER BY user_name");
$teamrows = '';
if (db_rows($r_team) > 0) {
$i = 0;
while ($team = db_result($r_team)) {
$level = ' ';
if ($team['user_ismod'] == 1) {
$level = 'Moderator';
}
if ($team['user_isadmin'] == 1) {
$level = 'Administrator';
}
$onlinetime = $board_time - 600;
$row = $TTeamrow;
$row = str_replace('[rowcolor]', $i % 2 == 0 ? '[CellA]' : '[CellB]', $row);
$row = str_replace('[level]', $level, $row);
$row = str_replace('[name]', $team['user_name'], $row);
$row = str_replace('[mail]', '<a href="mailto:' . $team['user_mail'] . '">' . $team['user_mail'] . '</a>', $row);
$board = db_result($r_board);
if ($board['category'] == 0) {
message('Sorry! Dieses Board gibt es nicht.', 'Fehler', 0);
}
// category
$r_category = db_query("SELECT\n category_id,\n\t category_name\n FROM " . $pref . "category WHERE category_id='{$board['category']}'");
$category = db_result($r_category);
// nav_path
$data['nav_path'] .= ' >> <a href="category.php?catid=' . $category['category_id'] . '"
class="bg">' . (strlen($category['category_name']) > 30 ? substr($category['category_name'], 0, 27) . '...' : $category['category_name']) . '</a>';
$data['nav_path'] .= ' >> <a href="board.php?boardid=' . $boardid . '"
class="bg">' . (strlen($board['board_name']) > 50 ? substr($board['board_name'], 0, 47) . '...' : $board['board_name']) . '</a>';
// thread
if ($action != 'new') {
$r_thread = db_query("SELECT\n thread_id,\n\t thread_topic,\n\t\t thread_closed,\n\t\t replies\n FROM " . $pref . "thread WHERE thread_id='{$threadid}' AND board_id='{$boardid}'");
if (db_rows($r_thread) != 1) {
message('Sorry! Fehlerhafter Link.', 'Fehler', 0);
}
$thread = db_result($r_thread);
$new['topic'] = $thread['thread_topic'];
$data['nav_path'] .= ' >> <a href="showtopic.php?boardid=' . $boardid . '&threadid=' . $threadid . '"
class="bg">' . $thread['thread_topic'] . '</a>';
}
// actions ----------------------------
// new Thread
if ($action == 'new') {
$data['nav_path'] .= ' >> Neuen Thread anlegen';
if (!P_POSTNEW) {
message('Sorry! Du bist nicht berechtigt hier neue Threads anzulegen.', 'Fehler', 0);
}
if (!isset($send)) {
$post_num_string = '0' . $post_num_string;
}
}
$post_num++;
// ip
$ip = '';
if (P_IP == 1) {
$ip = 'IP: ' . $post['post_ip'];
}
// gast? user?
$gast = 0;
if ($post['user_id'] == 0) {
$gast = 1;
} else {
$r_user = db_query("SELECT \n\t\t\t user_name,\n\t\t\t\t user_title,\n\t\t\t\t user_avatar,\n\t\t\t\t user_ismod,\n\t\t\t\t user_isadmin,\n\t\t\t\t user_hp,\n\t\t\t\t user_join,\n\t\t\t\t signatur,\n\t\t\t\t post_count,\n\t\t\t\t show_sig\n\t\t\t FROM " . $pref . "user WHERE user_id='" . $post['user_id'] . "'");
if (db_rows($r_user) != 1) {
$gast = 1;
} else {
$user = db_result($r_user);
mysql_free_result($r_user);
}
}
$threadautor = '';
// user exist
if ($gast == 0) {
// user_name
$user_name = $user['user_name'];
// title
$user_title = '';
if ($user['user_ismod'] == 1) {
$user_title = 'Moderator';
<input type="checkbox" name="link" value="1" /> Link in jetzigem Forum hinterlassen.<br /><br />
</td>
</tr>
<tr>
<td class="header" style="text-align:center">
<input type="submit" value=" Weiter >> " id="border-tab" />
</td>
</tr>
</form>
</table>';
$data['nav_path'] .= ' >> ' . $thread['thread_topic'] . ' >> Verschieben';
echo Output(Template($TBoard));
exit;
} else {
$r_board = db_query("SELECT\n\t\t\t category\n\t\t\t FROM " . $pref . "board WHERE board_id='{$new_board}'");
if (db_rows($r_board) != 1) {
message('Dieses gewählte Board existiert nicht!', 'Fehler', 0);
} else {
// zugriff auf Adminboards verhindern
$board = db_result($r_board);
if ($board['category'] == 0) {
message('Dieses gewählte Board existiert nicht!', 'Fehler', 0);
}
}
// threaddaten ändern
$more = '';
if (isset($link)) {
$more = ", link='" . $boardid . "'";
}
db_query("UPDATE " . $pref . "thread SET\n\t\t\t board_id='{$new_board}'\n\t\t\t\t " . $more . "\n\t\t\t WHERE thread_id='{$threadid}'");
// postdaten ändern
<?php
/* $Id: login.php,v 1.3 2003/06/16 18:08:20 master_mario Exp $ */
include 'inc/header.inc.php';
$r_login = db_query("SELECT\n user_id,\n user_pw,\n user_lastacttime\n FROM " . $pref . "user WHERE user_name='" . addslashes($login['name']) . "'");
if (db_rows($r_login) == 1) {
$a_login = db_result($r_login);
if (md5(addslashes($login['pw'])) == $a_login['user_pw']) {
// login --------------------------
db_query("UPDATE " . $pref . "user SET\n user_session='" . $sid . "',\n user_oldsavet='" . $a_login['user_lastacttime'] . "'\n WHERE user_id='" . $a_login['user_id'] . "'");
// gast l�schen -------------------
db_query("DELETE FROM " . $pref . "guest WHERE session_id='{$sid}'");
db_query("OPTIMIZE TABLE " . $pref . "guest");
setNewposts($a_login['user_lastacttime']);
// Weiterleitung ------------------
message_redirect('Du hast Dich erfolgreich eingeloggt, bitte warten ...', $loginscript);
} else {
$TBoard = Get_Template('templates/' . $style['styletemplate'] . '/board.html');
message('Das Passwort ist falsch.', 'Fehler', 0);
}
} else {
$TBoard = Get_Template('templates/' . $style['styletemplate'] . '/board.html');
message('Es ist kein User mit diesem Namen registriert.', 'Fehler', 0);
}
$q[] = "stamp < " . date2stamp($in['date_end']);
}
if ($in['username']) {
$q[] = "( from_user LIKE '%" . $in['username'] . "%' OR from_nick LIKE '%" . $in['username'] . "%' )";
}
if ($in['mode']) {
$q[] = "mode = 1";
}
if ($in['keyword']) {
$q[] = "message LIKE '%" . $in['keyword'] . "%'";
}
if ($in['roomname']) {
$q[] = "roomname LIKE '%" . $in['roomname'] . "%'";
}
$conds = null;
if ($q) {
$conds = " WHERE " . implode(' AND ', $q);
}
$result = $db->query("SELECT COUNT(*) as cnt FROM chat_log {$conds}");
$row = $result->fetch_assoc();
$total_post = $row['cnt'];
if (!($no_of_post = $in['no_of_posts'])) {
$no_of_post = 30;
}
if (empty($in['page_no'])) {
$in['page_no'] = 1;
}
$start = $in['page_no'] - 1;
$query = "SELECT * FROM chat_log {$conds} ORDER BY stamp DESC LIMIT {$start},{$no_of_post}";
$rows = db_rows($query);
}
$data['calendar'] .= '<b>' . $days . '</b>';
// time index -------------------------
$start = mktime(23, 59, 59, $m, $days - 1, $y);
$end = mktime(0, 0, 0, $m, $days + 1, $y);
// event ------------------------------
$r_event = db_query("SELECT \n\t\t\t calid,\n\t\t\t\t caltime,\n\t\t\t\t caltopic\n\t\t\t FROM " . $pref . "calendar WHERE caltime>'{$start}' AND caltime<'{$end}' AND aktiv='1'");
if (db_rows($r_event) > 0) {
while ($event = db_result($r_event)) {
$data['calendar'] .= "<br />[smallfont][ <a href=# onclick=\"window.open('event.php?event={$event['calid']}','show_event','width=400,height=500,scrollbars=yes,menubar=no,toolbar=no,statusbar=no')\">" . $event['caltopic'] . "</a> ][smallfontend]";
}
}
// user -------------------------------
if (U_ID > 0 || U_ID < 1 && $config['guest_memberlist'] == 1) {
$r_user = db_query("SELECT \n\t\t\t user_name,\n\t\t\t\t user_bday,\n\t\t\t\t user_bday_year\n\t\t\t FROM " . $pref . "user WHERE user_bday='" . ($days < 10 ? '0' . $days : $days) . '-' . ($m < 10 ? '0' . $m : $m) . "'");
}
if (db_rows($r_user) > 0) {
while ($user = db_result($r_user)) {
$dat = explode('-', $user['user_bday']);
$bday = mktime(0, 0, 0, $dat[1], $dat[0], $user['user_bday_year']);
$t = mktime(0, 0, 0, $m, $days, $y) - $bday;
$t = @bcdiv($t, 31547600, 0);
$data['calendar'] .= '<br />[smallfont]<a href="s_profile.php?username='******'user_name'] . '" target="_blank">' . $user['user_name'] . '</a> (' . $t . ')[smallfontend]';
}
}
}
$data['calendar'] .= '</td>';
if ($days >= $last) {
$lastrow = 1;
}
}
$data['calendar'] .= '</tr>';
}
// list events -------------------------------------------------------
if ($action == '') {
$r_events = db_query("SELECT\n calid,\n caltime,\n caltopic,\n calautor\n FROM " . $pref . "calendar ORDER BY caltime ASC");
$data['work'] .= '<table width="100%" cellpadding="4" cellspacing="0" border="0">
<tr>
<td><i>Event</i></td>
<td> </td>
<td> </td>
<td> </td>
<td><i>Von</i></td>
<td> </td>
<td><i>Optionen</i></td>
</tr>
';
if (db_rows($r_events) > 0) {
$i = 0;
while ($a_events = db_result($r_events)) {
$data['work'] .= '<tr bgcolor="' . ($i % 2 == 0 ? '#DADADA' : '') . '">
<td>' . date("d.m.Y H:i\\U\\h\\r", $a_events['caltime']) . ($a_events['caltime'] < $board_time ? ' <font color="[color_err]" size="1">(alt)</font>' : '') . '</td>
<td> </td>
<td>' . $a_events['caltopic'] . '</td>
<td> </td>
<td>' . $a_events['calautor'] . '</td>
<td> </td>
<td>
<a href="calendar.php?action=editEvent&calid=' . $a_events['calid'] . '">Editieren</a> |
<a href="calendar.php?action=deleEvent&calid=' . $a_events['calid'] . '">Löschen</a>
</td>
</tr>';
$i++;
==============================================
*/
include 'inc/header.inc.php';
include 'inc/bcode.inc.php';
$TBoard = Get_Template('templates/' . $style['styletemplate'] . '/board.html');
$TReport = Get_Template('templates/' . $style['styletemplate'] . '/report.html');
$data['nav_path'] = board_nav($boardid, $threadid, $data['nav_path']) . ' >> Melden';
if ($config['report'] == 0) {
message('Meldungen sind vom Administrator deaktiviert.', 'Rechte', 0);
}
if (U_ID == 0) {
message('Meldungen können nur von registrierten Usern gemacht werden.', 'Rechte', 0);
}
$r_report = db_query("SELECT\n report_id\n FROM " . $pref . "report WHERE user_id='" . U_ID . "' AND post_id='{$postid}'");
if (db_rows($r_report) > 0) {
message('Du hast dieses Posting bereits gemeldet.', 'Fehler', 0);
}
$form = 'form';
$textarea = 'text';
$laenge = $config['report_max_len'];
if ($laenge > 1500) {
$laenge = 1500;
}
$data['javascript'] = "\n function textlen ()\n {\n textarea = window.document.forms['{$form}'].elements['{$textarea}'];\n alert(textarea.value.length + ' Zeichen (Maximal erlaubte Länge {$laenge} Zeichen)');\n }";
if (!isset($send)) {
$r_post = db_query("SELECT\n\t post_text,\n\t\t bcode,\n\t\t post_smilies\n\t FROM " . $pref . "post WHERE post_id='{$postid}'");
$post = db_result($r_post);
$data['post'] = parse_code(stripslashes($post['post_text']), 1, 1, $post['bcode'], $post['post_smilies']);
$data['inputs'] = '<input type="hidden" name="boardid" value="' . $boardid . '" />
<input type="hidden" name="threadid" value="' . $threadid . '" />
$data['work'] = 'Sorry, you cannot delete this group (Are you trying to delete the default or guest group?).';
} else {
$data['work'] = 'You are going to delete "' . $group['name'] . '". Are you sure? (Group members will be removed from group)<br><br><a href="groups.php?action=drop&groupid=' . $_GET['groupid'] . '">Yes</a>';
}
} elseif ($action == 'edit') {
$r_group = db_query("SELECT\n groupid,\n name,\n accessmask,\n title,\n priority\n FROM " . $pref . "group WHERE groupid='" . $_GET['groupid'] . "'");
$group = db_result($r_group);
$data['work'] = '<b>Edit group</b><br><br>';
$data['work'] .= group_form($group, 'update');
} elseif ($action == 'editgroupboard') {
$r_group = db_query("SELECT\n groupid,\n name,\n accessmask\n FROM " . $pref . "group WHERE groupid='{$_GET['groupid']}'");
$group = db_result($r_group);
$r_board = db_query("SELECT\n board_id,\n board_name\n FROM " . $pref . "board WHERE board_id='{$_GET['boardid']}'");
$board = db_result($r_board);
$r_groupboard = db_query("SELECT\n groupid,\n accessmask\n FROM " . $pref . "groupboard WHERE groupid='{$_GET['groupid']}' AND boardid='{$_GET['boardid']}'");
if (db_rows($r_groupboard) > 0) {
$groupboard = db_result($r_groupboard);
$group['accessmask'] = $groupboard['accessmask'];
$data['work'] = groupboard_form($groupboard, $board, false);
} else {
$data['work'] = groupboard_form($group, $board, false);
}
} elseif ($action == 'drop') {
/* put members into the default group */
/*query("UPDATE $pref"."user SET groupid=$config[default_groupid] WHERE groupid='$groupid'");*/
$r_user = db_query("SELECT\n user_id,\n groupids\n FROM " . $pref . "user WHERE INSTR(groupids, ',{$_GET['groupid']},')>0");
while ($user = db_result($r_user)) {
$user['groupids'] = substr($user['groupids'], 1, strlen($user['groupids']) - 2);
grouplist_remove($user['groupids'], $_GET['groupid']);
$user['groupids'] = ',' . $user['groupids'] . ',';
db_query("UPDATE " . $pref . "user SET\n groupids='{$user['groupids']}'\n WHERE userid={$user['user_id']}");
/**
* Tests if a database lock is set
*
* @access public
*/
function testLock()
{
$this->_debugMessage('testLock()');
if ($lockID = $this->structureTableLock) {
return $lockID;
}
$this->_lockGC();
$tb = $this->lock_table;
$stb = $this->node_table;
$lockTTL = time() - $this->lockTTL;
$sql = "SELECT lockID FROM {$tb} WHERE lockTable=" . $this->db->quote($stb);
$res = $this->db->query($sql);
$this->_testFatalAbort($res, __FILE__, __LINE__);
// if ($res->numRows()) {
if (db_rows()) {
return new PEAR_Error($this->_getMessage(NESE_ERROR_TBLOCKED), NESE_ERROR_TBLOCKED);
}
return false;
}
define("U_PM_OVER", $a_user['pm_overflow']);
define("U_PM_NEW", $a_user['pm_new']);
define("U_PM_COUNT", $a_user['pm_count']);
define("U_NO_PM", $a_user['noPM_message']);
$data['login'] = '';
db_query("UPDATE " . $pref . "user SET\n\t user_lastacttime='{$board_time}' WHERE user_id='" . U_ID . "'");
} else {
define("U_ID", '0');
define("U_NAME", 'Gast');
define("U_ISMOD", '0');
define("U_ISADMIN", '0');
define("U_ISURADMIN", '0');
define("U_GROUPIDS", ',' . $config['guest_groupid'] . ',');
define("U_STYLEID", '0');
$r_guest = db_query("SELECT\n\t last_act_time\n\t FROM " . $pref . "guest WHERE session_id='{$sid}'");
if (db_rows($r_guest) == 1) {
$a_guest = db_result($r_guest);
define("U_LAST", $a_guest['last_act_time']);
db_query("UPDATE " . $pref . "guest SET\n\t\t\t last_act_time='{$board_time}' WHERE session_id='{$sid}'");
} else {
define("U_LAST", 0);
db_query("INSERT INTO " . $pref . "guest SET\n\t\t session_id='{$sid}',\n\t\t\t last_act_time='{$board_time}'");
}
}
// _groups lesen und Rechtestring erstellen
if (isset($boardid)) {
$P = boardPermissions(U_GROUPIDS, $boardid);
define('P_VIEW', $P[0]);
define('P_REPLY', $P[1]);
define('P_POSTNEW', $P[2]);
define('P_CLOSE', $P[3]);
==============================================
(c) 2003 by
Mario Pischel <*****@*****.**>
download the latest version:
https://developer.berlios.de/projects/thwc/
This program is free software; you can
redistribute it and/or modify it under the
terms of the GNU General Public License as
published by the Free Software Foundation;
either version 2 of the License, or (at
your option) any later version.
==============================================
*/
include 'inc/header.inc.php';
include 'inc/bcode.inc.php';
// global Template
$TEvent = Get_Template('templates/' . $style['styletemplate'] . '/event.html');
$r_event = db_query("SELECT\n caltime,\n\t caltopic,\n\t calautor,\n\t caltext\n FROM " . $pref . "calendar WHERE calid='{$event}'");
if (db_rows($r_event) == 1) {
$event = db_result($r_event);
$data['datum'] = date("d.m.Y (H:i\\U\\h\\r)", $event['caltime']);
$data['event'] = parse_code($event['caltopic'], 1, 0, 0, $config['eventcode']);
$data['text'] = parse_code($event['caltext'], 1, 0, $config['eventcode'], $config['eventcode']);
$data['autor'] = '<a href="s_profile.php?username='******'calautor'] . '" target="_blank">' . $event['calautor'] . '</a>';
} else {
echo 'Fehler! Kein Event mit dieser ID gefunden.';
}
echo Output(Template($TEvent));
<?php
include_once 'admin_user_add.php';
$rows = db_rows("SELECT seq, username FROM admin ORDER BY seq DESC");
?>
<table id='chat-log-table' cellpadding=0 cellspacing=0 width='100%' border=0>
<tr id='tr-header'>
<td nowrap>번호</td>
<td nowrap>아이디</td>
<td>관리</td>
</tr>
<?php
foreach ( $rows as $row ) {
?>
<tr>
<td><?=$row['seq']?></td>
<td><?=$row['username']?></td>
<td>
<a href='?option=admin_user_management&seq=<?=$row['seq']?>'>관리</a>
<a href='admin_user_delete.php?seq=<?=$row['seq']?>' target='hiframe'>삭제</a>
</td>
</tr>
<?}?>
</table>
$mon = (int) substr($value, 3, 2);
$year = (int) substr($value, 6, 4);
$timestamp = mktime(0, 0, 0, $mon, $day, $year);
if ($lookhow[$key] == 'vor') {
$where .= " < {$timestamp}";
} else {
$where .= " > {$timestamp}";
}
}
}
}
$r_finduser = db_query("SELECT\n user_id,\n user_name,\n user_mail\n FROM " . $pref . "user " . $where . " ORDER BY user_name ASC");
if (db_rows($r_finduser) < 1) {
$data['work'] = '<b>Ergebnis:</b> Kein User gefunden.';
} else {
$data['work'] = '<b>Ergebnis:</b> ' . db_rows($r_finduser) . ' User gefunden.<br /><br />
<form action="useredit.php" name="form" method="post">
<table cellpadding="3" cellspacing="1" border="0">
<tr>
<td id="blank"> </td>
<td id="blank"><i>User ID</i></td>
<td id="blank" style="width:150px"><i>Username</i></td>
<td id="blank" style="width:250px"><i>Email-Adresse</i></td>
<td id="blank"><i>Optionen</i></td>
</tr>';
$i = 0;
while ($found = db_result($r_finduser)) {
$data['work'] .= '
<tr bgcolor="' . ($i % 2 == 0 ? '#DADADA' : '#E5E5E5') . '">
<td id="blank"><input type="checkbox" name="userid[' . $found['user_id'] . ']" value="1" /></td>
<td id="blank"><b>' . $found['user_id'] . '</b></td>
if ($action == 'defaultStyle') {
db_query("UPDATE " . $pref . "style SET styleisdefault='0'");
db_query("UPDATE " . $pref . "style SET styleisdefault='1' WHERE styleid='{$styleid}'");
$action = '';
}
// deleStyle ------------------------------------------------------
if ($action == 'deleStyle') {
db_query("DELETE FROM " . $pref . "style WHERE styleid='{$styleid}'");
// USER AUF DEFAULT SETZEN WENN SIE DIESEN BENUTZEN #############################################################
db_query("OPTIMIZE TABLE " . $pref . "style");
$action = '';
}
// list styles -------------------------------------------------------
if ($action == '') {
$r_list = db_query("SELECT\n styleid,\n stylename,\n styleispublic,\n styleisdefault,\n styletemplate\n FROM " . $pref . "style");
if (db_rows($r_list) < 1) {
$data['work'] = '<font color="#990000">Kein Style angelegt.</font>';
} else {
$data['work'] .= '<a href="style.php?action=publicStyle&styleid=all">Alle als öffendlich makieren</a> |
<a href="style.php?action=publicStyle&styleid=no">Alle als nicht öffendlich makieren</a><br /><br />
<table cellpadding="3" cellspacing="0" border="0">';
while ($list = db_result($r_list)) {
$data['work'] .= '<tr>
<td>' . $list['stylename'] . '</td>
<td> </td>
<td><font color="#FF0000">' . ($list['styleisdefault'] == 1 ? '*' : ' ') . '</font></td>
<td><font color="#0000FF">' . ($list['styleispublic'] == 1 ? '*' : ' ') . '</font></td>
<td> </td>
<td>
<a href="style.php?action=editStyle&styleid=' . $list['styleid'] . '">Editieren</a> |
<a href="style.php?action=deleStyle&styleid=' . $list['styleid'] . '">Löschen</a> |
}
if (count($onuser) > 0) {
$onlinelist = implode(' ,', $onuser);
}
unset($onuser);
mysql_free_result($r_onuser);
$r_onguest = db_query("SELECT\n COUNT(session_id)\n FROM " . $pref . "guest WHERE last_act_time>'{$onlinelimit}'");
$a_onguest = db_result($r_onguest);
list(, $guestcount) = each($a_onguest);
$onlinecount = $onlinecount + $guestcount;
mysql_free_result($r_onguest);
$onlinecount24 = 0;
$onuser24 = array();
$onlinelist24 = '';
$r_24user = db_query("SELECT\n user_name,\n\t user_ishidden\n FROM " . $pref . "user WHERE user_lastacttime>'" . ($board_time - 86400) . "'");
if (db_rows($r_24user) > 0) {
while ($a_24user = db_result($r_24user)) {
if ($a_24user['user_ishidden'] == 0) {
$onlinecount24++;
$onuser24[] = '<a href="s_profile.php?username='******'user_name'] . '">' . $a_24user['user_name'] . '</a>';
} else {
if (P_CANSEEINVIS == 1) {
$onlinecount24++;
$onuser24[] = '<a href="s_profile.php?username='******'user_name'] . '">' . $a_24user['user_name'] . '</a>(Versteckt)';
}
}
}
}
if (count($onuser24) > 0) {
$onlinelist24 = implode(' ,', $onuser24);
}
