Quaddicted.com Forum

Moai

Member

Quake Injector only has 1 map

Hey, everyone. Apologies if this post is in the wrong spot. I just joined and this is my first post.

Starting yesterday, when I open Quake Injector it only brings up one available map to download and play. Anyone have any idea why this might be?

Spirit

Administrator

Re: Quake Injector only has 1 map

Ouch, my fault! Should be fixed by adjusting an ugly hack to a changed database scheme. Sorry and thanks for reporting!

Maybe someone knows how to make it not a hack:

My query is

SELECT * FROM maps
LEFT OUTER JOIN (SELECT zipname, GROUP_CONCAT(bsp) AS startmaps FROM startmaps GROUP BY zipname)
AS group_subselectbsp ON group_subselectbsp.zipname = maps.zipname 
LEFT OUTER JOIN (SELECT zipname, GROUP_CONCAT(dependency) 
AS dependencies FROM dependencies GROUP BY zipname) AS group_subselectdep ON group_subselectdep.zipname = maps.zipname 
WHERE maps.type!=4 ORDER BY maps.zipname;

With one array per row it leads to the ['zipname'] being empty but the numeric id ([2] here) being fine:

Array 
 ( 
 [0] => 1 
 [id] => 1 
 [1] => 1374765832 
 [timestamp] => 1374765832 
 [2] => 100b2 
 [zipname] => 
 [3] => 2 
 [type] => 2 
...

I have no clue why.

Spirit

Administrator

Re: Quake Injector only has 1 map

Solved by selecting only the columns that are needed, there were 3 "zipname" columns earlier, so no wonder it went bad. :)

Moai

Member

Re: Quake Injector only has 1 map

Thanks! It's working like a charm once again!