update xarmy set trained=trained+1 where gameid = 134 and type=1 and ownerid = 32573 and x = 12 and y = 72 and characterid = 24update xarmy set trained=trained+1 where gameid = 134 and type=1 and ownerid = 32573 and x = 17 and y = 74 and characterid = 7update xarmy set trained=trained+1 where gameid = 134 and type=1 and ownerid = 32573 and x = 29 and y = 103 and characterid = 3update xarmy set trained=trained+1 where gameid = 134 and type=1 and ownerid = 32573 and x = 34 and y = 105 and characterid = 4


"this is what shown at the top of the page after i update my military training and that makes all of my barracks only been able to use one slot to produce the army i want and the other slot producing spearman which i believe is at the top of the troops ready table"


p/s-oh and what is shown in the table is that it only will produce half the amount of the per turn production which means i only produce 5 mace per turn instead of 10 while there`s no production shown in the spearman altho used by one of the production slot.

Last Edited : Thursday, 13 January 2005 - 18:57

yes i get this too.

update xarmy set trained=trained+1 where gameid = 419 and type=1 and ownerid = 7480 and x = 9 and y = 48 and characterid = 7update xarmy set trained=trained+1 where gameid = 419 and type=1 and ownerid = 7480 and x = 14 and y = 50 and characterid = 7update xarmy set trained=trained+1 where gameid = 419 and type=1 and ownerid = 7480 and x = 23 and y = 77 and characterid = 12update xarmy set trained=trained+1 where gameid = 419 and type=1 and ownerid = 7480 and x = 35 and y = 26 and characterid = 13update xarmy set trained=trained+1 where gameid = 419 and type=1 and ownerid = 7480 and x = 42 and y = 59 and characterid = 13

then all i get is spearmen.

ooops.

fixed it

thanks req