Ringthane
Public Area Guest
Ardet nec Consumitur
Posts: 5,446
|
Post by Ringthane on Aug 13, 2004 10:29:36 GMT
From player details screen:
UPDATE GML_GameLords INNER JOIN RAC_Races ON RAC_ID = GML_RAC_ID SET GML_RAC_ID = 3 ,GML_Gender = 'M' ,GML_Mounted = 1 ,GML_GraphicFile = 'foul' ,GML_Riders = ((((ROUND(RAND() * 120) + 1) * 5) + 400) * 1) ,GML_Warriors = (((ROUND(RAND() * 120) + 1) * 5) + 700) + ((((ROUND(RAND() * 120) + 1) * 5) + 400) * NOT(1)) WHERE GML_ID = 4120
Failed trying to update Game Lord records for current user
|
|
|
Post by sparrowhawk on Aug 14, 2004 9:25:39 GMT
damn. It's another instance of that SQL bug that occured when 0.2a was released. Works fine on dev, but the UKLinux box just won't accept it for some reason.
Will amend the code to use the workaround that I used elsewhere. Makes me wonder where else this might be happening...
|
|
|
Post by sparrowhawk on Aug 14, 2004 11:07:24 GMT
Addressed by 0.2b R4 release - please test and update status if you are happy that it is now working
|
|
Ringthane
Public Area Guest
Ardet nec Consumitur
Posts: 5,446
|
Post by Ringthane on Aug 14, 2004 11:23:57 GMT
Indeed, seems fixed.
|
|