[Resolved] return gates produces error / negative gates as a result

I maybe found the cause for the "negative gates problem". I do not now if this is a newly introduced error or if this persists for longer now:

When returning gates, I get:

SQL/DB Error -- [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 '(gates_avail + 1)) WHERE identifier = 'CPH'' at line 1]

As I recall it, the available gates at the airport are not ADDED but DEDUCTED as a result. I have produced a "minus gates" at CDG by returning gates. (Sure, I do not know if somebody else caused it at the same time, but I guess it could have been me).

You could check that on a clean server where only you have access to.

Thanks for the info - will check this

Due to the - amount in gates this round needs to be halted until this problem is fixed.

AMSAmsterdam Netherlands 12467 2 1 -5/119 $167,826Rent
FRAFrankfurt Germany 13123 -3/142 $174,561Rent
LHRLondon Heathrow United Kingdom 12799 2 0 -30/214 $185,442Rent
CDGParis Charles-De-Gaulle France 13829 5 6 -30/170 $181,408Rent

I have paused the time for now as we work on the problem and decide the next steps. Thank you for your patience.

I do not think there is a need for a reset, now that game is paused, i think problem can be fixed, and game restarted.
3 reset in 15 days ... would be not funny.
by the way , from what i can see it is a syntax error.. not a major bug

SQL/DB Error -- [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 '' at line 1]

SQL/DB Error -- [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 'AND time >=' at line 2]

Are two statements I receive within my opening page

I do not think there is a need for a reset, now that game is paused, i think problem can be fixed, and game restarted.
3 reset in 15 days ... would be not funny.
by the way , from what i can see it is a syntax error.. not a major bug

Well, good luck with getting gates at the major cities then is all I say. I would say the game has just started so it would be no problem to reset it again after the problem is fixed.

As for your comment on the syntaxt error, I'm glad your not a programmer!

Reset - Could be a simple solution - but as the clock just started to tick and there is no gates, then the Anti-Cheat Staff need to look ino IP's and remove all those who have duplicate / 3 / 4 /10 and more airlines setup

AE is ONE Player = ONE airline - some and you only need to look at names / reg numbers have several setup against AE rules.

So, my way would be to solve this:

1. Double the amount of Gates as did happen within sim1 not long ago

2. Have the Cheat Police go into the IP's and remove airlines that fail to honor the AE Laws and Rules.

There are only 300 set up now wouldnt take long to check IP's

(Those removed will have to start again and their IP's will be on a log that will be recorded by the Cheat Police)

Just a suggestion......

Well, good luck with getting gates at the major cities then is all I say. I would say the game has just started so it would be no problem to reset it again after the problem is fixed.

As for your comment on the syntaxt error, I'm glad your not a programmer!

I actually am DB2 tho.. not an SQL expert but i think those errors pops for bad variable type definition, bad syntax,open ended function etc etc

Reset - Could be a simple solution - but as the clock just started to tick and there is no gates, then the Anti-Cheat Staff need to look ino IP's and remove all those who have duplicate / 3 / 4 /10 and more airlines setup

AE is ONE Player = ONE airline - some and you only need to look at names / reg numbers have several setup against AE rules.

So, my way would be to solve this:

1. Double the amount of Gates as did happen within sim1 not long ago

2. Have the Cheat Police go into the IP's and remove airlines that fail to honor the AE Laws and Rules.

There are only 300 set up now wouldnt take long to check IP's

(Those removed will have to start again and their IP's will be on a log that will be recorded by the Cheat Police)

Just a suggestion......

Very good idea! I would like airlines who already have 3 or 4 planes looked into.

As i PM Travelhouse , IP can be tricky, at work most of the people in my dept play, and we use proxy so you'll get at least 10 connections from same ip. Same story with flatmates,people sharing wireless connection etc etc

Some ideas :

1)limit the possibility to buy more than 5 gates/day( real time) in major airports

2) allowing the rental of gates in an airport only if gates aleady owned are at 100% utilizzation ( have a look at some airlines, they have 25 gates, 26% util)

The game is running again, and the original problem on gate return is fixed

The game is running again, and the original problem on gate return is fixed

Hi Tobias, the original problem is fixed, glad about that but now there are 0 gates at AMS - FRA - CDG - HND etc etc ...

That can't be right 10 game days into the game?

Can you increase the amount of gates at the major hubs to normal levels?

Very good idea! I would like airlines who already have 3 or 4 planes looked into.

Go ahead, I bought the 2 planes in a fair way. As I am running only one Airline. Problem is only, that I can not see anymore, as with the old used market, from who the planes are coming. Then I would have send a copy of the confirmatiom to you so that you could check from wich IP adress they were sold. But I assume the bank is also keeping these details. All I did was checking every 30 minutes today if any plane was offered, during my work. 2 times I was lucky.

Go ahead, I bought the 2 planes in a fair way. As I am running only one Airline. Problem is only, that I can not see anymore, as with the old used market, from who the planes are coming. Then I would have send a copy of the confirmatiom to you so that you could check from wich IP adress they were sold. But I assume the bank is also keeping these details. All I did was checking every 30 minutes today if any plane was offered, during my work. 2 times I was lucky.

With the current setup of there being a delay in the buying and selling from the bank you would constantly need to be pressing F5, which makes me wonder do you ever get any work done :sdrool:

It's easy to circumvent the IP check, I have 3 or 4 different servers I could use in different parts of the world so it's not difficult at all.

With the current setup of there being a delay in the buying and selling from the bank you would constantly need to be pressing F5, which makes me wonder do you ever get any work done :sdrool:.

I was not doing a lot today. On the Airport Amsterdam is a recession either, so not a lot of cargo coming in and out today at our company:cry: but I am getting of topic now

As far as removing "duplicate" airlines with the same IP address, we have to remember that some people are playing legitimately from one IP (i.e. I know at least three people including myself who play AE at my school and we all share one IP address to the outside).

Sometime today I will make and run a script to recount the correct number of gates for each airport, so we will have an accurate number of gates available and no need to reset.

As far as removing "duplicate" airlines with the same IP address, we have to remember that some people are playing legitimately from one IP (i.e. I know at least three people including myself who play AE at my school and we all share one IP address to the outside).

Agree, there is no easy format to attack but names / IP / Consecective or close reg numbers plus looking at airlines that open today and just hold gates, we must look into their activity, it may be action taken over a week, but those who are abusing the game play should be removed.

My son and I have an account with AE and YES we both share the same IP as many other offices and schools do the same.

I am sure some have suggestions as to how to stop cheating, we need to look at all avenues.