\"$feature[articletitle] $feature[articletitle]

Full story... Discussion..."; // thread exclusion in section statements $threadexclude .=" AND threadid!='$feature[threadid]'"; } // end loop of features // retrieve two columns added (separate columnists) // retrieve last two articles from each major section (excluding features and cover), ordered by typical section order // array of sections and their descriptions $sections=array("WORLD","UM LIFE","SOUND","SIGHT","TOUCH","TASTE","SCENT","SPORT"); $sectiondesc=array("Current Affairs, Travel","The everyday world of Universal Metropolis, UM Events","Music, Live Events, Bands & DJs","Arts & Theatre, The Media, Literature","Computers & The Internet, Toys & Games, Web Media Development","Pop Culture, Food & Drink, Recipes, Restaurants, Bars, Clubs","Lifestyle, Health, Nature & Environment, Science & Space","The World of Sport"); // block of sections $u=0; while($u$sectionfeature[articletitle]" . iif(!empty($sectionfeature[articledesc])," - $sectionfeature[articledesc]","") ."
"; // first feature - boldfaced /*if(!$loop){ $articleblock="$articleblock
"; $loop=1; }*/ } // end of sql retrieval unset($loop); $topmenu .="\"$sections[$u] "; // display templates $sectionfeatureblock .=" \"$sections[$u]


x "; // clear values unset($articleblock); $u++; } $u=0; // end retrieve cover sections // retrieve welcome notice/ announcement // retrieve latest poll or trivia - if already voted, show results // retrieve last ten headlines, regardless of section $result=mysql_query("SELECT t.thread_id AS threadid,t.threadtitle AS title FROM umthreads AS t,umplaces AS p WHERE t.magazine=1 AND t.threadtype='headline' AND t.validity!='n' AND t.validity!='x' AND t.placeid=p.umplace_id AND p.validity='y' AND p.access='pub' GROUP BY t.thread_id ORDER BY t.priority,t.added DESC,t.lasttime DESC LIMIT 10"); while($headline=mysql_fetch_array($result)){ // convert headline to capitals $headline[title]=strtoupper($headline[title]); // background=\"images/bgcoverleft.gif\" $headlineblock .=" $headline[title] "; } // end headlines // upcoming event or advertisement // retrieve latest event info $upcoming=sqlquery("SELECT thread_id AS threadid,threadtitle,threaddesc,threadimage,threadurl FROM umthreads WHERE nowplaying=1 AND released>0 AND validity='y' ORDER BY priority,RAND(),released DESC,added DESC LIMIT 1"); $upcomingeventtitle=$upcoming[threadtitle]; //$upcomingeventdesc=$upcoming[threaddesc]; $upcomingeventimg=$upcoming[threadimage]; $upcomingeventurl=iif(!empty($upcoming[threadurl]),$upcoming[threadurl],"index.php"); // main layout template $sectionmain="cover.php"; // open magazine processing page require(iif($test==1,"new.php","layout.php")); // end umagazine index ?>