0.2b - progress

[sparrowhawk]

0.2 bug fixes and changes are about 80% complete, but I've now hit a work peak and will not be able to do MU stuff for a couple of days. So don't expect any new release until the end of the wekk at the earliest.

small changes like missing gfx will still be done as they only take a few seconds.

[sparrowhawk]

Revised: about 60% complete - I'd missed a major tweak that needs doing (the battle/ally issue that I explained to those who volunteered to look at the battle code)

[sparrowhawk]

Just a quick update to let you know that I've not really managed to move forward at all these last few days. Too much work, house repairs, enjoying the 2-day english summer with the children.

Will try to start moving things forward again asap.

[sparrowhawk]

Post-work, post-sunshine, post-illness - got some coding done on the battle algorithm (the bloody bane of my life, if ever there was one).

Not quite there yet, and in typical fashion I've adopted a pick-n-mix approach, taking most of my original script, and adding bits from Mads, Matija et al, here and there.

It's not working yet (what a surprise), as at the moment, poor old Oberon is getting a sound whipping from his ally JeanYves at Sunset. Rather unsporting of JeanYves that.

So the allies bit is not quite there yet. Close though.

Also the dishing-out damage proportionately (sp?) bits are not working either. Well not completely. But getting closer.

But other than that all is rosy in the garden of battle-scriptdom...

[sparrowhawk]

0.2b has been uploaded but at the moment falls over on the end turn processing with an SQL error. As such I have disabled accounts until such time as can fix this issue.

It's working fine on my dev PC, and I've checked the tables and they are the same (ie unchanged).

If anyone can help out, here is the code that is causing the failure:

You have an error in your SQL syntax near 'INNER JOIN RAC_Races ON RAC_ID = GML_RAC_ID SET GML_Riders = GML_Riders + 5, ' at line 1

UPDATE GML_GameLords INNER JOIN RAC_Races ON RAC_ID = GML_RAC_ID
   SET GML_Riders = GML_Riders + 5, GML_Warriors = GML_Warriors + 10
   WHERE GML_GAM_ID = 67
       AND GML_USR_ID <> 0
       AND INSTR('CY', GML_Garrison) > 0
       AND GML_Riders + GML_Warriors < 2500
       AND RAC_CanRide = 1


[sparrowhawk]

Fault is with the INNER JOIN part. Maybe for some reason this is not supported on UKLinux if they use different defualt table types? No idea.

Anyway, 0.2b R 2 is out with a workaround fix. Not ideal, but it will do until I can figure out what's going on.

---

Important: casualties are quite different in this version, so please feedback if they are better/worse than before (constructive criticisms please! )

Also, there are some new bugs - see To Do document.