You are not logged in.

Post a reply

Write your message and submit
Are you human or robot? If you have trouble, mail to spirit åt quaddicted døt c

Checking if this is requested by a real person and not an automated program.

Go back

Topic review (newest first)

Moai
2013-07-30 02:26:51

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

Spirit
2013-07-28 10:22:43

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

Spirit
2013-07-27 08:59:49

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.

Moai
2013-07-26 21:56:18

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?

Board footer