As a summary, it is used in an online fantasy strategy game to update citadels for races that can ride(eg men and elves as opposed to dwarves, giants, etc).
Code: Select all
UPDATE Lords INNER JOIN Races ON RaceID = LordRaceID
SET Riders = Riders + 5, Warriors = Warriors + 10
WHERE GameID = 67
AND UserID <> 0
AND INSTR('CY', Garrison) > 0
AND Riders + Warriors < 2500
AND RaceCanRide = 1As I said earlier, this code works fine onmy dev PC.
Any ideas?