[FIXED AGAIN] Defeats

[Natmus]

Pressing the 'Defeats' button gives:

" Your Defeats

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND GML_GAM_ID = 34 AND MPD_SCN_ID = 1' at line 1

SELECT GML_ID, GML_ShortName, GML_Name, GML_KilledOn, GML_King,USR_ShieldGraphic, MPD_Description FROM (GML_GameLords INNER JOIN MPD_MapDescriptions ON (MPD_Row = GML_Row) AND (MPD_Column = GML_Column)) LEFT JOIN USR_Users ON USR_ID = GML_USR_ID WHERE GML_ID = AND GML_GAM_ID = 34 AND MPD_SCN_ID = 1"

[sparrowhawk]

That's odd. It's working here. Let me check it on the testbed at the uklinux site.

Could you give me the game id at the icemark site?

[sparrowhawk]

Could you try it now? It should be fixed (fingers crossed).

[sparrowhawk]

Natmus said:

Yes, it works now. If only you could fix everything that fast ;D

That would be nice! ;D
My own stupid fault that one. It did work, then I decided to add a little extra bit of info and for some reason I didn't check it. Bit of a muppety thing to do.

[sparrowhawk]

Yep, day 16. I've uploaded a fix - please try that.

I was displaying the slaying lord's killed on date instead of the date your vassal was slain on!