You are not logged in.
Pages: 1
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?
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.
Solved by selecting only the columns that are needed, there were 3 "zipname" columns earlier, so no wonder it went bad. :)
Thanks! It's working like a charm once again!
Pages: 1