Subscribe
|
GFX
|
|
|
|
|
|
|
READ
|
|
PLAYHUB
|
 |
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 Submissions: 5 Total Views: 9,580 (40th) Total Feedback: 43 posts Average Rating: 9.2/10 (75th) Unrated Tutorials: 1 Total Favs: 3 (66th) First Submission: 3 months ago Latest Submission: 29 days ago Favorite Category: CS > Other/Misc (3 releases) |
Filter:  Query failed - SELECT CONCAT(','/ico/games/',IF(games.icon<>'',games.icon,'_.gif'),') ',games.abbreviation,' > ',tutcats.name,''),CONCAT('  ',tuts.name,' ',tuts.postcount,' comment',IF(tuts.postcount<>1,'s',''),IF(tuts.lastpost_date>0,CONCAT(' (',IF(tuts.postcount>1,'Last: ',''),'[PARSE%FUNC]date_format2(',tuts.lastpost_date,')[/PARSE%FUNC])'),'')),CONCAT(IF(tuts.screenshots <> '',CONCAT(' ,'/ss/tuts/thm_',SUBSTRING_INDEX(tuts.screenshots, '&&', 1),') '),' No Screens')),CONCAT('',CASE tuts.status WHEN 1 THEN 'Expert' WHEN 2 THEN 'Intermediate' WHEN 4 THEN 'Beginner' ELSE 'Undefined' END,' ',IF(tuts.rating>0,CONCAT(tuts.rating,'/10'),'?/10'),' ',IF(tuts.votes>=30,'30 of 30 votes  Done',CONCAT('',tuts.votes,' of 30votes',IF(tuts.votes<3,CONCAT(' ',3-tuts.votes,' votes needed!'),'')))),tuts.date,tuts.views,tuts.id,CONCAT('',users.name,' ',@dots,''),tuts.name,tuts.status FROM tuts LEFT JOIN tutcats ON tuts.catid=tutcats.id LEFT JOIN games ON tutcats.catid=games.id WHERE tuts.studioid=1935 ORDER BY tuts.date desc LIMIT 0,20 - Unknown column 'users.name' in 'field list' Main query failed |