Главная Проект 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айт по вселенной трилогии "Матрица". Форум и онлайн рпг, статьи и юмор, обои и скринсейверы, другие игры и файлы
Киевский компьютерный клуб "Бункер"
Сербская игровая сеть
Общие Terran Protoss Zerg
 Важность стиля © Tsunami перeвод с английского by sagitarius
 Правильное Микро © Tsunami c сайта www.geocities.com/brattsunami/.
 Количественные и качественные показатели в StarCraft`е (апгрейды) © sagitarius
 Минералы для счастья © XOpen
 Рабский труд © -the TiTaN[BW]
 Апгрейды и роль целых чисел в математике СтарКрафта © Shootnik[SoK]
 Дропинг © HookedOnChronic c сайта www.broodwar.de, перевод Johann
 Терраны vs Зерги на островах © неизвестный автор с сайта www.broodwar.de, перевод [RA]Johann
 Раш Дарками © XOpen
 Раш с пробками © XOpen
 Использование Статиса © DarkElf[PoS]
 Красный архон © SS.
 Риверы © -the TiTaN[BW]
 Раш Фотонками и методы противодействия © -the TiTaN[BW]
 Тактика иллюзий © XOpen
 Про Риверов © SS.
 Раш зилотами © UltraMariNe
 Protoss vs. Protoss © неизвестный автор c сайта hometown.aol.com/engelmannbeuna/, перевод Johann
 Специальный Раш Двойных Врат © Xds~Fire c сайта www.broodwar.com, перевод Chiffa
 Zerg vs zerg на bloodbath © © Wic
 Борьба с механическим терраном (вторая версия) © Shootnik[SoK]
 Зерг при игре 2х2 © sagitarius
 Зерг против Зерга на Lost Temple © -the TiTaN[BW]
 Дефайлеры © -the TiTaN[BW]
 Королевы © SS.
 Люркеры © -the TiTaN[BW]
 Раш санкенами © -the TiTaN[BW]
 Муталиски © -the TiTaN[BW]
 Опасная ловушка © неизвестный автор c сайта starcraft.gamesweb.com, перевод by Stasik
Rambler's Top100 Яндекс цитирования
Copyright ©2001, Stormwave.ru - The Sons of Korhal Site