Главная Проект 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айт по вселенной трилогии "Матрица". Форум и онлайн рпг, статьи и юмор, обои и скринсейверы, другие игры и файлы
Киевский компьютерный клуб "Бункер"
Сербская игровая сеть
Проза Поэзия Юмор История или "про нас"
 Предыстория Протоссов - перевод оригинального мануала © Blizzard Entertainment, перeвод с английского Peace Keeper
 Во благо Улья © Boroda
 Боевая стажировка. Повесть © DiVerSant
 Улыбка © loki
 Живое к живому © loki
 Курс лекций для призраков и офицеров © loki
 Эксперимент © corvus
 Один © MAX_[D.F.B.]
 Берги и Эйда. Рассказ © SS.
 Кеавина © SS.
 "Рейнор". Пьеса © Hydralisk666
 "Рэйнор" Акт II © Hydralisk666
 "Рэйнор" Акт III © Hydralisk666
 "Старкрафтер". Рассказ © Fantasy
 "Жажда смерти". Эссе © Serg
 Ангел в стальных доспехах © PhoenixTFB
 Покидая Аюр © DiVerSant
 Реквием Крейсеру © DiVerSant
 Дурачества по StarCraft © DiVerSant
 Судьба зилотская © DiVerSant
 Бесконечная война © XaLen
 Белая поэма без названия © Chiffa
 "На гибель Чау Сара" © Serg
 Перемены © OverDyPb
 Expansion set: Druid in the house - рассказ по мотивам Diablo II: LOD. © OverDyPb
 Expansion set: Druid in the house - 2 - продолжение рассказа по мотивам Diablo II: LOD. © OverDyPb
 Expansion set: Druid in the house - 3 - продолжение рассказа по мотивам Diablo II: LOD. © OverDyPb
 Один день Юрия Молотова © OverDyPb
 Другой день Юрия Молотова © OverDyPb
 Знаменательный день уже непонятно кого... дружбы © OverDyPb
 День Зависимости © OverDyPb
 Кабачок "У зеалота" © corvus
 WarCraft III: Новобранцы. - рассказ по мотивам WarCraft III. © OverDyPb
 Kто-то нажал B C... © OverDyPb
 Мечты терранина © SS.
 FAQ для новичков © Stasik & Гарм
 Солнце склонялось к закату... - Старый бред Гарма © Гарм
 Комикс про маринов на www.blizzard.ru.
 "Новая жизнь". Рассказ © Гарм
 Новая жизнь - 2 © OverDyPb
 Новая жизнь - 3 © corvus
 Новая жизнь - 4 © OverDyPb
 Новая жизнь - 5 © OverDyPb
 "Когда погибает вера...". Притча © sc-ratch
 В гостях у семейства Ботовых. Интервью © Hyperion DAv
 "Раскол". Хроника раскола на starcraft.ru © Гарм
 "История Мятежа". Чудом спасенная рукопись © старый Темплар
 "Звьоздне рэмэсло". Памфлет-п'єса на 4 акти в кацапськiй зонi Интернета, в стиле Леся Подервьянского. © sc-ratch
 "Звьоздне рэмэсло-2 або Актiвiруєм дезактiвiрование актiватори" . Памфлет-п'єса на 4 дiї в кацапськiй зонi Интернета, в стиле Леся Подервьянского. © sc-ratch
Rambler's Top100 Яндекс цитирования
Copyright ©2001, Stormwave.ru - The Sons of Korhal Site