FPSBANANA > Scripts > CS

Help Wanted
SFX Artist/Musician @ Anarchy Studio's (See All)

Remove the ads!

Scripts > CS >

Main

Filter:

Query failed - SELECT CONCAT('
',scriptcats.name,'
'),CONCAT('
',scripts.name,'

',scripts.postcount,' comment',IF(scripts.postcount<>1,'s',''),IF(scripts.lastpost_date>0,CONCAT('
(',IF(scripts.postcount>1,'Last: ',''),'[PARSE%FUNC]date_format2(',scripts.lastpost_date,')[/PARSE%FUNC])'),''),'

',IF(scripts.studioid>0,CONCAT('[PARSE%FUNC]FPSB_Membership::Banner(studios[,]',scripts.studioid,')[/PARSE%FUNC]
','[PARSE%FUNC]User::Get(',scripts.userid,'[,]upic)[/PARSE%FUNC]'),CONCAT('[PARSE%FUNC]User::Get(',scripts.userid,'[,]avatar
upic)[/PARSE%FUNC]'))),CONCAT('
',IF(scripts.rating=0,'',CASE WHEN scripts.rating >= 9 THEN '' WHEN scripts.rating >= 8 THEN '' WHEN scripts.rating >= 6.5 THEN '' ELSE '' END),'
',IF(scripts.rating>0,CONCAT(scripts.rating,'/10'),'?/10'),'
',scripts.votes,' vote',IF(scripts.votes<>1,'s','')),scripts.views,scripts.id,CONCAT('
',IF(scripts.rating=0,'',CASE WHEN scripts.rating > 8.9 THEN '' WHEN scripts.rating > 6.9 THEN '' WHEN scripts.rating > 4.9 THEN '' ELSE '' END),'
',IF(scripts.rating>0,CONCAT(scripts.rating,'/10'),'?/10'),'

',IF(scripts.votes>=30,'30 of 30
votes

Done',CONCAT('',scripts.votes,' of 30
votes'))),scripts.downloads,scripts.fav_count,scripts.postcount,CONCAT('[PARSE%FUNC]User::Get(',scripts.userid,'[,]name)[/PARSE%FUNC]'),scripts.name,scripts.status FROM scripts LEFT JOIN scriptcats ON scripts.catid=scriptcats.id LEFT JOIN games ON scriptcats.catid=games.id WHERE games.genre='fps' AND scripts.date>1222898183 AND scriptcats.catid=3 ORDER BY scripts.views desc LIMIT 25 - Unknown column 'scripts.downloads' in 'field list'
Main query failed