0) { $res2=mysql_query("SELECT COUNT(*) FROM signups WHERE raidid = ".$item['raidid']." AND charid IN (SELECT charid FROM chars WHERE accountid = $userid)"); if(mysql_result($res2,0)==1) $data['charcount']="".$data['charcount'].""; } $raid=$raid.parse_template($raidtemplate,$data); } if($only_origin==1) $res=mysql_query("SELECT raidid,name,date,notes,maxchars,status,(SELECT COUNT(*) FROM signups WHERE raidid = raids.raidid) AS currentchars FROM raids WHERE status IN (2,3) AND notes NOT LIKE '%friendship%' ORDER BY date DESC LIMIT 0,10"); else $res=mysql_query("SELECT raidid,name,date,notes,maxchars,status,(SELECT COUNT(*) FROM signups WHERE raidid = raids.raidid) AS currentchars FROM raids WHERE status IN (2,3) AND notes NOT LIKE '%origin%' ORDER BY date DESC LIMIT 0,10"); $oldraid=""; while($item=mysql_fetch_assoc($res)) { unset($data); $data['day']=$datearray[date("w",$item['date'])]; $data['date']=date("d.m.Y",$item['date']); $data['name']=$item['name']; $data['notes']=$item['notes']; $data['charcount']=$item['currentchars']." (".$item['maxchars'].")"; $data['raidid']=$item['raidid']; $data['color']=getStatusColor($item['status']); $data['status']=getStatusString($item['status']); $oldraid=$oldraid.parse_template($raidtemplate,$data); } unset($data); $data['futureraids']=$raid; $data['pastraids']=$oldraid; echo parse_template($pagetemplate,$data,1); ?>