Subscribe
|
GFX
|
|
|
|
|
|
|
READ
|
|
PLAYHUB
|
Search
Register or Reset Password
SUBMISSIONS
GENERATORS
INSTALL HELP
DEVHUB
FOR MAPPERS
HELP WANTED
Animator
Coder/Scripter
Compiler
Concept Artist
Graphic Artist
Mapper
Modeller
Skinner
SFX Artist/Musician
Texture Artist
Video Producer
Web Developer
Coder/Scripter
Compiler
Concept Artist
Graphic Artist
Mapper
Modeller
Skinner
SFX Artist/Musician
Texture Artist
Video Producer
Web Developer
CLANS
SPONSORS
 Stats |
Filter:  Query failed - SELECT CONCAT(','/ico/games/',IF(games.icon<>'',games.icon,'_.gif'),') ',games.abbreviation,' > ',soundcats.name,''),CONCAT('  ',sounds.name,'',IF(1 > 2,CONCAT('  '),''),'',sounds.postcount,' comment',IF(sounds.postcount<>1,'s',''),IF(sounds.lastpost_date>0,CONCAT(' (',IF(sounds.postcount>1,'Last: ',''),'[PARSE%FUNC]date_format2(',sounds.lastpost_date,')[/PARSE%FUNC])'),'')),CONCAT(' ',CASE sounds.status WHEN 1 THEN 'Expert' WHEN 2 THEN 'Intermediate' WHEN 4 THEN 'Beginner' ELSE 'Undefined' END,' ',IF(sounds.rating>0,CONCAT(sounds.rating,'/10'),'?/10'),' ',IF(sounds.votes>=30,'30 of 30 votes  Done',CONCAT('',sounds.votes,' of 30votes',IF(sounds.votes<3,CONCAT(' ',3-sounds.votes,' votes needed!'),'')))),sounds.date,sounds.views,sounds.id,CONCAT('',users.name,' ',@dots,''),sounds.name,sounds.status FROM sounds LEFT JOIN soundcats ON sounds.catid=soundcats.id LEFT JOIN games ON soundcats.catid=games.id WHERE sounds.userid=425965 ORDER BY sounds.date desc LIMIT 0,15 - Unknown column 'users.name' in 'field list' Main query failed |
Favorited Sounds i've favorited. None Found |
Add this moduleTheme: | 220 Members Online | File Mirrors | Terms of Service | Rules | Advertise here | Contact | Report a problem