db_connect(); $db->db_select(1); include_once(BASE.'datas/include/config.inc.php'); include_once(BASE.'datas/include/sessionuser.inc.php'); $suchmuster = array('/Ä/','/Ü/','/Ö/','/ä/','/ü/','/ö/','/ß/'); $ersetzung = array('Ae','Ue','Oe','ae','ue','oe','ss'); $title = 'tbody: Das Webdeveloper Forum'; if($postid > 0) { $db->sql("SELECT id, t_autor, t_post, t_erstellzeit, t_status FROM forum_thread WHERE id='$postid' LIMIT 0,1"); if($db->rows() > 0) { $row = $db->assoc(); $post_id = $row['id']; $post_autor = $row['t_autor']; $post_post = $row['t_post']; $post_zeit = $row['t_erstellzeit']; $post_status = $row['t_status']; } else { $post_id = 0; $post_autor = 'no_user'; $post_post = ''; $post_zeit = 0; $post_status = 1; } } if($forumid > 0) { $db->sql("SELECT id, b_titel, b_status FROM forum_board WHERE id='$forumid' LIMIT 0,1"); if($db->rows() > 0) { $row = $db->assoc(); $title = 'tbody Forum: '.$row['b_titel']; $foren_id = $row['id']; $foren_title = $row['b_titel']; $foren_status = $row['b_status']; } else { $foren_id = 0; $foren_title = ''; $foren_status = 1; } } if($threadid > 0) { $db->sql("SELECT id, f_titel, f_status FROM forum_forum WHERE id='$threadid' LIMIT 0,1"); if($db->rows() > 0) { $row = $db->assoc(); $title = 'tbody Forum: '.$row['f_titel']; $thread_id = $row['id']; $thread_title = $row['f_titel']; $thread_status = $row['f_status']; } else { $thread_id = 0; $thread_title = ''; $thread_status = 1; } } function getPosts($boardid) { $result = mysql_query('SELECT id FROM forum_thread WHERE b_id='.$boardid); return mysql_num_rows($result); } function getPostsThread($boardid,$boardid2) { $result = mysql_query('SELECT id FROM forum_thread WHERE b_id='.$boardid.' AND t_id='.$boardid2); return mysql_num_rows($result); } function getThreads($boardid) { $result = mysql_query('SELECT id FROM forum_forum WHERE b_id='.$boardid); return mysql_num_rows($result); } function getLastPost($boardid,$suchmuster,$ersetzung) { $result1 = mysql_query('SELECT id, b_titel FROM forum_board WHERE id='.$boardid.' LIMIT 0,1'); if(mysql_num_rows($result1)) { $row = mysql_fetch_assoc($result1); $b_id = $row['id']; $b_titel = $row['b_titel']; $result2 = mysql_query('SELECT id, f_titel, f_lastautor, f_lasterstellzeit FROM forum_forum WHERE b_id='.$boardid.' ORDER BY f_lasterstellzeit DESC LIMIT 0,1'); if(mysql_num_rows($result2)) { $row = mysql_fetch_assoc($result2); $f_id = $row['id']; $f_titel = $row['f_titel']; $f_lastautor = $row['f_lastautor']; $f_lasterstellzeit = date("d.m.Y H:i:s",$row['f_lasterstellzeit']); if(strlen($f_titel) > 55) { $str_return = ''.substr($f_titel,0,52).'...
'.$f_lasterstellzeit.' von '.getPlayerName($f_lastautor); } else { $str_return = ''.$f_titel.'
'.$f_lasterstellzeit.' von '.getPlayerName($f_lastautor); } } else { $str_return = 'keiner bisher'; } } return $str_return; } function getPlayerPosts($userid) { if((int)$userid) { $result = mysql_query('SELECT id FROM forum_thread WHERE t_autor='.$userid); if(mysql_num_rows($result)) { $str_return = mysql_num_rows($result); } else { $str_return = 0; } } else { $str_return = 0; } return $str_return; } function getPlayerName($userid) { if((int)$userid) { $result = mysql_query('SELECT name FROM member WHERE id='.$userid.' LIMIT 0,1'); if(mysql_num_rows($result)) { $row = mysql_fetch_assoc($result); $str_return = $row['name']; } else { $str_return = 'Gelöschter User'; } } else { $str_return = 'Gelöschter User'; } return $str_return; } if(isset($_POST['new_thread'])) { if($foren_id > 0 AND $member_Id > 0) { $new_titel = trim(strip_tags($_POST['new_titel'])); $new_post = trim(strip_tags($_POST['new_post'])); $time = time(); if((in_array($member_Id,${'forum_'.$foren_id.'_mod'})) OR $foren_status == 0) { $db->sql("INSERT INTO forum_forum (b_id,f_titel,f_autor,f_erstellzeit,f_lastautor,f_lasterstellzeit) VALUES ('$foren_id','$new_titel','$member_Id','$time','$member_Id','$time')"); $db->sql("SELECT id FROM forum_forum WHERE f_erstellzeit='$time' AND f_autor='$member_Id' LIMIT 0,1"); if($db->rows() > 0) { $row = $db->assoc(); $new_thread_id = $row['id']; $db->sql("INSERT INTO forum_thread (t_id,b_id,t_autor,t_post,t_erstellzeit) VALUES ('$new_thread_id','$foren_id','$member_Id','$new_post','$time')"); } $db->sql("UPDATE forum_board SET b_lastautor='$member_Id', b_lasterstellzeit='$time' WHERE id='$foren_id'"); header('Location: '.BASEHEAD.'forum/'.urlencode($foren_title).'-f'.$foren_id.'/'.urlencode($new_titel).'-t'.$new_thread_id.'.html'); } else { header('Location: '.BASEHEAD.'forum/'); } } else { header('Location: '.BASEHEAD.'forum/'); } } elseif(isset($_POST['answer_thread'])) { if($foren_id > 0 AND $thread_id > 0 AND $member_Id > 0) { $answer_post = trim(strip_tags($_POST['answer_post'])); $time = time(); if((in_array($member_Id,${'forum_'.$foren_id.'_mod'})) OR $foren_status == 0 AND $thread_status == 0) { $db->sql("INSERT INTO forum_thread (t_id,b_id,t_autor,t_post,t_erstellzeit) VALUES ('$thread_id','$foren_id','$member_Id','$answer_post','$time') "); $db->sql("UPDATE forum_forum SET f_lastautor='$member_Id', f_lasterstellzeit='$time' WHERE id='$thread_id'"); $db->sql("UPDATE forum_board SET b_lastautor='$member_Id', b_lasterstellzeit='$time' WHERE id='$foren_id'"); header('Location: '.BASEHEAD.'forum/'.urlencode($foren_title).'-f'.$foren_id.'/'.urlencode($thread_title).'-t'.$thread_id.'.html'); } else { header('Location: '.BASEHEAD.'forum/'); } } else { header('Location: '.BASEHEAD.'forum/'); } } elseif(isset($_POST['edit_thread'])) { if($foren_id > 0 AND $thread_id > 0 AND $post_id > 0 AND $member_Id > 0) { $edit_post = trim(strip_tags($_POST['edit_post'])); $time = time(); if(in_array($member_Id,${'forum_'.$foren_id.'_mod'})) { $db->sql("UPDATE forum_thread SET t_post='$edit_post', t_editzahl=t_editzahl + '1', t_editautor='$member_Id', t_editerstellzeit='$time', t_status='1' WHERE b_id='$foren_id' AND t_id='$thread_id' AND id='$post_id'"); } elseif($foren_status == 0 AND $thread_status == 0 AND $post_status == 0 AND $member_Id == $post_autor AND time() - $post_zeit < 1800) { $db->sql("UPDATE forum_thread SET t_post='$edit_post', t_editzahl=t_editzahl + '1', t_editautor='$member_Id', t_editerstellzeit='$time' WHERE t_autor='$member_Id' AND b_id='$foren_id' AND t_id='$thread_id' AND id='$post_id'"); } header('Location: '.BASEHEAD.'forum/'.urlencode($foren_title).'-f'.$foren_id.'/'.urlencode($thread_title).'-t'.$thread_id.'.html'); } else { header('Location: '.BASEHEAD.'forum/'); } } echo''; ?> <?php echo $title; ?>


0) { include(BASE.'datas/include/board/newthread.php'); } elseif($action == 'answer' AND $foren_id > 0 AND $thread_id > 0) { include(BASE.'datas/include/board/answer.php'); } elseif($action == 'edit' AND $foren_id > 0 AND $thread_id > 0) { include(BASE.'datas/include/board/edit.php'); } elseif($thread_id > 0) { include(BASE.'datas/include/board/thread.php'); } elseif($foren_id > 0) { include(BASE.'datas/include/board/forum.php'); } else { include(BASE.'datas/include/board/board.php'); } ?>