Главная Проект Stormwave Games Форум Чат Библиотека Галерея Музыка Баннеры  
  Реплеи Стратегии Справочник Файлы  
 
Опрос временно не функционирует
Blizzard
Starcraft
Diablo II
Warcraft 3
Westwood
Разное
Новое на сайте
\n"); if ($showicon == "1") { echo(""); } // the last poster column, if ($lastposter == "1") { echo("\n"); } // the last post date & time column, if ($lastpostdate == "1") { echo("\n"); } // the views column, if ($views == "1") { echo("\n"); } // and/or the replies column if ($replies == "1") { echo("\n"); } echo("\n"); // the base WHERE statement $wheresql = "WHERE thread.lastposter=user.username AND thread.open!='10'"; // we can't have both the last 24 hours *and* the last 7 days, so error out if needed if ($last24 == "1" && $last7 == "1") { print("Error: \$last24 and \$last7 are both set to 1. Please change one of them to 0."); exit; } // otherwise we're gonna find out which one it is // last 24 if ($last24 == "1") { $time = time()-86400; $wheresql .= " AND thread.lastpost>'$time'"; } // last 7 if ($last7 == "1") { $time = time()-604800; $wheresql .= " AND thread.lastpost>'$time'"; } // are we trying to exclude *and* include forums? if so, error out if ($excludeforums != "" && $includeforums != "") { print("Error: \$includeforums and \$excludeforums are both set with numbers. Please remove the numbers from one of these two to proceed."); exit; } // otherwise figure out which one we're using // include forums if ($includeforums == "" or $includeforums <= "0") { $quarter = "no"; } else { $incfid = explode(",",$includeforums); $i = 0; $a = count($incfid); if ($a > 1) { $wheresql .= " AND (thread.forumid='$incfid[0]'"; ++$i; while ($i < $a) { $wheresql .= " OR thread.forumid='$incfid[$i]'"; ++$i; } $wheresql .= ")"; } else { $wheresql .= " AND thread.forumid='$incfid[$i]'"; } } // or exclude forums if ($excludeforums == "" or $excludeforums <= "0") { $quarter = "no"; } else { $excfid = explode(",",$excludeforums); $i = 0; $a = count($excfid); while ($i < $a) { $wheresql .= " AND thread.forumid!='$excfid[$i]'"; ++$i; } } if ($showforumtitle == "1") { $ftitle = ",forum"; $fsel = ",forum.title AS ftitle"; $wheresql .= " AND thread.forumid=forum.forumid"; } // ooh a query! $query = "SELECT thread.lastpost,thread.title,thread.lastposter,thread.replycount,thread.views,user.userid,thread.threadid,thread.forumid$fsel,thread.iconid FROM thread,user$ftitle $wheresql ORDER BY thread.$ob $obdir LIMIT $maxthreads"; // let's get the info $tr = mysql_query($query) or die("MySQL reported this error while trying to retreive the info: ".mysql_error()); $dtf = mysql_query("SELECT value FROM setting WHERE varname='dateformat' OR varname='timeformat' OR varname='timeoffset' ORDER BY varname"); $df = mysql_result($dtf,0,0); $tf = mysql_result($dtf,1,0); $tof = mysql_result($dtf,2,0); if ($showdate == "1") { $fdt = "$df $tf"; } else { $fdt = "$tf"; } $cols = 1; // let's display the info while ($threads = mysql_fetch_array($tr)) { // are we going to show the message too? if ($showmessages == "1") { $query0 = "SELECT pagetext,postid,dateline,iconid FROM post WHERE threadid='$threads[threadid]' ORDER BY dateline DESC LIMIT 1"; $lastpost = mysql_query($query0) or die("MySQL reported this error while trying to retrieve the last post info: ".mysql_error()); while ($lastpost1 = mysql_fetch_array($lastpost)) { $lastpostshort = $lastpost1[pagetext]; $postii = $lastpost1[iconid]; } if (strlen($lastpostshort) > $lplen) { $lastpostshort = substr($lastpostshort,0,$lplen); $lastpostshort .= "..."; } $smilies = mysql_query("SELECT smilietext,smiliepath FROM smilie"); while ($smiles = mysql_fetch_array($smilies)) { $lastpostshort = str_replace($smiles[smilietext],"",$lastpostshort); } if ($nb == "1") { $lastpostshort = nl2br($lastpostshort); } $lastpostshort = str_replace("[i]","",$lastpostshort); $lastpostshort = str_replace("[/i]","",$lastpostshort); $lastpostshort = str_replace("[u]","",$lastpostshort); $lastpostshort = str_replace("[/u]","",$lastpostshort); $lastpostshort = str_replace("[b]","",$lastpostshort); $lastpostshort = str_replace("[/b]","",$lastpostshort); $lastpostshort = str_replace("[quote]","
quote:

",$lastpostshort); $lastpostshort = str_replace("[/quote]","

\n",$lastpostshort); $lastpostshort = str_replace("[I]","",$lastpostshort); $lastpostshort = str_replace("[/I]","",$lastpostshort); $lastpostshort = str_replace("[U]","",$lastpostshort); $lastpostshort = str_replace("[/U]","",$lastpostshort); $lastpostshort = str_replace("[B]","",$lastpostshort); $lastpostshort = str_replace("[/B]","",$lastpostshort); $lastpostshort = str_replace("[QUOTE]","
quote:

",$lastpostshort); $lastpostshort = str_replace("[/QUOTE]","

\n",$lastpostshort); $lastpostshort = str_replace("[CODE]","
code:

",$lastpostshort); $lastpostshort = str_replace("[/CODE]","

\n",$lastpostshort); $lastpostshort = str_replace("[code]","
code:

",$lastpostshort); $lastpostshort = str_replace("[/code]","

\n",$lastpostshort); $lastpostshort = str_replace("[img]","",$lastpostshort); $lastpostshort = str_replace("[/img]","",$lastpostshort); $lastpostshort = str_replace("[IMG]","",$lastpostshort); $lastpostshort = str_replace("[/IMG]","",$lastpostshort); $lastpostshort = str_replace("[url]","",$lastpostshort); $lastpostshort = str_replace("[/url]","",$lastpostshort); $lastpostshort = str_replace("[URL]","",$lastpostshort); $lastpostshort = str_replace("[/URL]","",$lastpostshort); } // thanks to kier for this idea to do the alternating row colors if (($counter++ % 2) != 0) { $bc=$bc1; } else { $bc=$bc2; } // if the title is more than $len characters, we need to cut it off and add ... to the end if (strlen($threads[title]) > $len) { $title = substr($threads[title],0,$len); $title .= "..."; } else { $title = $threads[title]; } // convert the date to a format readable by non-unix geeks :) $fd = date($fdt,$threads[lastpost]); // display everything in a nice table. in the future we're gonna try to do this so others can format the data, but this is sufficient for now echo(""); if ($showicon == "1") { echo(""); ++$cols; } echo("\n"); // last poster column? if ($lastposter == "1") { echo("\n"); ++$cols; } // the last post date & time column, if ($lastpostdate == "1") { echo("\n"); ++$cols; } // views column? if ($views == "1") { echo("\n"); ++$cols; } // replies column? if ($replies == "1") { echo("\n"); ++$cols; } echo(""); // are we showing the last post? if ($showmessages == "1") { echo("\n"); } $fd = ""; } // close it all up echo("
 Last PosterLast PostViewsReplies
"); if ($postii != "0" && $postii != "") { echo(""); } if (($postii == "0" || $postii == "") && $threads[iconid] != "0" && $threads[iconid] != "") { echo(""); } if (($postii == "0" || $postii == "") && ($threads[iconid] == "0" || $threads[iconid] == "")) { echo(" "); } echo(""); if ($showforumtitle == "1") { echo("$threads[ftitle]: "); } echo(" $title$threads[lastposter]$fd$threads[views]$threads[replycount]
\n"); echo("\n"); echo("\n"); echo("\n"); echo("
Last Post:$lastpostshort
"); // bye! ?>
Ложки.net - Передовой cайт по вселенной трилогии "Матрица". Форум и онлайн рпг, статьи и юмор, обои и скринсейверы, другие игры и файлы
Киевский компьютерный клуб "Бункер"
Сербская игровая сеть
 Музыка и аудиокомпозиции
 Композиции DnKm'а
  Sleepless Nights © DnKm
  Roll It Up © DnKm
  The Missed Thing © DnKm
  Beyond The Sky © DnKm
  Power to the Horde © DnKm
  Insomnia © DnKm
  Deep Trip © DnKm
  Rainy © DnKm
  Shape Up © DnKm
  Somewhere in Time © DnKm
  Splash Attack © DnKm
  10 000 years (Darkness mix) © DnKm
  Alone © DnKm
  Existent Zone © DnKm
  Forgive Her © DnKm
  Keep Hope Alive © DnKm
  S-Reflex © DnKm
  For Auir © DnKm
  Zerg Evolution © DnKm
  Terran War © DnKm
  Just the Protoss © DnKm
  Marine versus Bug Guy © DnKm
  Just the Terran © DnKm
  Praetor Fenix and big mistake of Tassadar © DnKm
  Crack © DnKm
  Zealot © DnKm
  Stormwave © DnKm
  The New Beginning (6251кб) © DnKm
 Композиции sc-ratch
  Valkyrie Fly © sc-ratch
  Duran&Kerrigan Last DanceFloor Night © sc-ratch
  Dominator © sc-ratch
  Mar Sara del Mar © sc-ratch
  Witness Raid © sc-ratch
  Lost In A Dreams © sc-ratch
 Композиции от Blizzard Entertainment
  Requiem (тема из ролика к BroodWar'у) © Blizzard
  A Call To Arms (тема из трейлера к WarCraft3) © Blizzard
  Radio Free Zerg © Blizzard
  The 12 Days O Xmas © Blizzard
  Greetings (The Cain Rap Final) © Blizzard -- Текст песни
 Композиции других исполнителей
  Massiv Drop © PomX
  The Dark Brethren © Intel
  Commando Storm © Intel
  Khirador © Intel
  Homeworld © Intel
  Protoss Mix © Intel
  Who Wants to Sing © Nuclear Rage
  Overmind Theme © StarCraft
  Nuclear Attack (Fractal) © StarCraft
  Kerrigan © StarCraft
  I Felt Your Presence © StarCraft
  For Adun © StarCraft
  12th Area © StarCraft
 Пародии
  Zergstein © Alex D'Astous
  With Marines © Heath 'SirZealot' Tindall -- Текст песни
Rambler's Top100 Яндекс цитирования
Copyright ©2001, Stormwave.ru - The Sons of Korhal Site