error examining NPC

Ardbeg · Post by **Ardbeg** » Fri Oct 05, 2007 5:33 pm

Supreme Commander Azool [NPC] (Federal Government) Supreme Command Ship 0/0 45 Examine

On examine, i get:

Query failed: SELECT * FROM player WHERE game_id = 5 AND (alliance_id IN () OR account_id = 8 OR account_id = 1) AND sector_id = 452
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 ') OR account_id = 8 OR account_id = 1) AND sector_id = 452' at line 1

Curufir · Post by **Curufir** » Fri Oct 05, 2007 8:58 pm

To me that looks like one of those that thar error thingummys.

There should be a limit at the end of that statement. Costs nothing in a search less than the limit and plenty if the search exceeds the limit.

Post by **Azool** » Sat Oct 06, 2007 2:08 am

Fixed.

It is selecting both defenders and attackers. So if I set a 20 player limit it might get 15 defenders and 5 attackers (when there are 20 of each in the sector for example). It would filter out the extra defenders, but leave the attackers at 5.

Curufir · Post by **Curufir** » Sat Oct 06, 2007 10:44 am

Yup.

Sadly yet another reason not to look at code drunk

Post by **Azool** » Sat Oct 06, 2007 4:17 pm

Curufir wrote:Yup.

Sadly yet another reason not to look at code drunk

lol, also sadly I've done the same plenty