con(); $dbcon->open("signupsystem"); $items = ""; $items = ' http://raid.crabpeople.se/ Active Raids Active Raids en-us RAID RSS-generator 1.0 Beta ' . date("r") . ' spam@herkulesjonssonsstorverk.se spam@herkulesjonssonsstorverk.se '; $currentraiders = $dbcon->sendQuery("SELECT raiders FROM raids WHERE active = '1' GROUP BY raiders ORDER BY raiders DESC"); while($raider = mysql_fetch_array($currentraiders)) { $SQLR_raids = $dbcon->sendQuery("SELECT raidtimestamp, icon, r.raidid AS raidid, r.targetid AS targetid, r.info AS info, r.raiddate AS date, active, rt.name AS targetname, raiders, hour, day, minute, month, year, groups FROM raids r, raidtargets rt WHERE r.targetid = rt.targetid AND active = '1' AND raiders = '$raider[raiders]' ORDER BY raidtimestamp "); while($raid = mysql_fetch_array($SQLR_raids)) { $SQLR_signups = $dbcon->sendQuery("SELECT COUNT(charid) AS nbrsignups FROM raidsignups WHERE raidid = $raid[raidid] "); $signupdata = mysql_fetch_array($SQLR_signups); $title = date("l, jS \of F, Y, H:i", $raid['raidtimestamp'])." - ".$raid['targetname']." - ".$signupdata['nbrsigns']." signs."; $rep1 = array("å","ä","ö","Å","Ä","Ö"); $rep2 = array("å","ä","ö","Å","Ä","Ö"); $description = str_replace($rep1, $rep2, $raid['info']); $link = 'http://raid.crabpeople.se/?p=raid&rid='.$raid["raidid"]; $items .= ' '. $link .' '. $description .' '; } } $items .= ' '; echo $items; ?>