FPSBANANA > Scripts > TF2

Remove the ads!

Scripts > TF2 >

Main

Newest

Add Script

Add Category

RSS

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('
',CASE scripts.status WHEN 1 THEN 'Expert' WHEN 2 THEN 'Intermediate' WHEN 4 THEN 'Beginner' ELSE 'Undefined' 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',IF(scripts.votes<3,CONCAT('

',3-scripts.votes,' votes
needed!'),'')))),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>1218856824 AND scriptcats.catid=297 ORDER BY scripts.views desc LIMIT 25 - Unknown column 'scripts.downloads' in 'field list'
Main query failed