Airline Mogul Forum

Airline Mogul => Bugs => Topic started by: sopangyu on October 08, 2007, 01:34:49 pm

Title: Can't Register
Post by: sopangyu on October 08, 2007, 01:34:49 pm

I Can't register due to account problems ,My email is sopangyu@hotmail.com or sopangyu@sjc.edu.hk

Title: Can't Register
Post by: Jps on October 08, 2007, 01:36:35 pm

Explain in details  :D ... what did it say? "Email already used"?

Title: Can't Register
Post by: dktc on October 08, 2007, 01:41:55 pm

Nope. No player with those email.

... but yes, give us more details if you will.

Title: Can't Register
Post by: sopangyu on October 09, 2007, 02:27:04 pm

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/register.php on line 115

Notice: Query: INSERT INTO `users` (`email`, `pass`, `first_name`, `last_name`, `username`, `security`, `active`, `registration_date`, `airline_name`, `airline_code`, `airline_type`, `airline_cash`, `continent_no`, `reg_ip`, `airline_value`) VALUES ('sopangyu@sjc.edu.hk', '9477f28373ab52b539b65e19128d264f2b3c1434', 'So', 'Pang Yu Derek', 'sopangyu', '4', '', NOW(), 'L'Avion Voyager', 'LAV', '', '2000000', '3', '61.18.170.250', '19500000')
MySQL 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 'Avion Voyager', 'LAV', '', '2000000', '3', '61.18.170.250', '19500000')' at line 4 in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/register.php on line 162

You could not be registered due to a system error. We appologise for any inconvenience. Please try again, if problem persists report this error and any detail you can provide in the forums

Title: Can't Register
Post by: Jps on October 09, 2007, 02:30:56 pm

Do you use Apple or PC?

Speed of Internet? Example: 104.0 Mbps

Internet Explorer, Firefox or other crappy explorers?

Who do you prefer to answer your question, Dktc or Stephen?  :D

MrOrange or Skylite (pick one):

Thanks

Title: Can't Register
Post by: dktc on October 09, 2007, 02:31:31 pm

THe registration script is broken. We are in the process of fixing it. Check back in 10 hours or so. Hopefully Will will get it done by then. If not, check back again in another 10 hours :lol:

Title: Can't Register
Post by: MrOrange on October 09, 2007, 02:31:39 pm

You used L'Avion Voyager as airline name, correct? When you use an ' in the name, the MySQL query will be completely messed up because it uses ' as separators for values, IIRC. I had this problem so, so many times with other things. I think that might be the problem. Try registering without the ' in the name.

Title: Can't Register
Post by: Jps on October 09, 2007, 02:32:54 pm

Doesn't matter with the '? Or does it?

Title: Can't Register
Post by: MrOrange on October 09, 2007, 02:32:59 pm

@dktc: Don't know if you understand MySQL, but it seems like it doesn't understand (and it has a point) the extra '.

@JPS: I guess it does.

Title: Can't Register
Post by: dktc on October 09, 2007, 02:34:39 pm

That ' is one problem. Yes, try omitting it.

Another one is that the registration is acting weird. I couldn't even get in with the bypass script after I registered a test account (on Will's request, which mean he / other admins has(ve) notice something abnormal there). So... :?

Title: Can't Register
Post by: MrOrange on October 09, 2007, 02:35:56 pm

I haven't tried yet, but I might have to give it a go.

Title: Can't Register
Post by: Jps on October 09, 2007, 02:37:21 pm

So you can't register in AM for 10 hours..

(that's a bad experience for a first time joiner in AM)

Title: Can't Register
Post by: sopangyu on October 09, 2007, 02:51:31 pm

Anyway,Thanks for your reply and helps

Title: Can't Register
Post by: dktc on October 09, 2007, 02:53:28 pm

Quote from: "Jps"

So you can't register in AM for 10 hours..

(that's a bad experience for a first time joiner in AM)

It is not about the delay. It is about how we treat our guest during the delays.

As the airline pilots love to say, "we will keep you all updated on the situation. We would try to get it working as soon as we could."

It is the spirit that counts :lol:

Title: Can't Register
Post by: Jps on October 09, 2007, 02:55:48 pm

Quote from: "sopangyu"

Anyway,Thanks for your reply and helps

NP..

@Dktc How will you help me get pass this terribly long reset  :D ..

Title: Can't Register
Post by: MrOrange on October 09, 2007, 02:56:29 pm

Besides, after registering, you'll have to wait for like 20 hours until the game comes back on, so there's nothing to do except browsing the forums.

Title: Can't Register
Post by: Jps on October 09, 2007, 02:59:32 pm

browse the old threads.. developments of AM  :D

Title: Can't Register
Post by: dktc on October 09, 2007, 03:40:35 pm

Quote from: "Jps"

@Dktc How will you help me get pass this terribly long reset  :D ..

hmm.... go find me the followings, (with sources included in APA format):

Range for:
Cunliffe-Owen Concordia
DH.29 Doncaster
Martin 2-0-2
Sikorsky S-29-A
Belriot 25
Dewoitine D.14
DH.54

Speed for:
Burnelli CB-16

Range and pax for:
Cunliffe-Owen OA-1

Speed and range for:
Burnelli RB-1
Burnellie UB-20
Potez P.840
Liore-Olivier LeO.21
Fokker F.VIII
Ford Stout
Saunders Kittywake (or Kittiwake depending on what source you are looking at)



These should keep you occupied :)

Title: Can't Register
Post by: MrOrange on October 09, 2007, 03:53:55 pm

Question. When you say speed, do you use the cruise speed or the max speed?

Edit: Can I use MLA format too? I use that more often than APA.

Title: Can't Register
Post by: dktc on October 09, 2007, 04:12:17 pm

Usually max speed (I know that is unrealistic... esp. when max speed combined with max range :roll: , but that is the tradition here)

I use APA more than MLA. I can't do a MLA out of my head, but APA I could. :wink:
k... just for you. If you want to us MLA, go ahead :lol:

Title: Can't Register
Post by: Blue Sky Mine on October 09, 2007, 04:13:20 pm

Quote

Belriot 25

Did you mean Belriot or Bleriot?

Title: Can't Register
Post by: MrOrange on October 09, 2007, 04:13:57 pm

I'd say Bleriot, I've never heard of Belriot.

And @d: Thanks :lol:

Title: Can't Register
Post by: dktc on October 09, 2007, 04:16:13 pm

Typo :oops:

Title: Can't Register
Post by: Air Elbonia on October 09, 2007, 07:36:25 pm

Quote from: "sopangyu"

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/register.php on line 115

Notice: Query: INSERT INTO `users` (`email`, `pass`, `first_name`, `last_name`, `username`, `security`, `active`, `registration_date`, `airline_name`, `airline_code`, `airline_type`, `airline_cash`, `continent_no`, `reg_ip`, `airline_value`) VALUES ('sopangyu@sjc.edu.hk', '9477f28373ab52b539b65e19128d264f2b3c1434', 'So', 'Pang Yu Derek', 'sopangyu', '4', '', NOW(), 'L'Avion Voyager', 'LAV', '', '2000000', '3', '61.18.170.250', '19500000')
MySQL 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 'Avion Voyager', 'LAV', '', '2000000', '3', '61.18.170.250', '19500000')' at line 4 in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/register.php on line 162

You could not be registered due to a system error. We appologise for any inconvenience. Please try again, if problem persists report this error and any detail you can provide in the forums

-immediately puts on to-fix-today list.-

Alrighty:

I think i fixed it.  If not, please tell me again. i'll do my best to straighten it out as soon as possible.  The cause was (most likely) the fact your airline name had a ' in it.  

If you cannot recreate it with L'Avion Voyager as the name, try an airline name without a ' (for the time being) and tell me if that works instead.  If neither work, i've greatly misjudged the source of the error, if the latter works...i'll try again to fix it (and will manually update the airline name if you so desire).

Title: Can't Register
Post by: Jps on October 10, 2007, 12:58:53 pm

Quote from: "dktc"

Quote from: "Jps"

@Dktc How will you help me get pass this terribly long reset  :D ..

hmm.... go find me the followings, (with sources included in APA format):

Range for:
Cunliffe-Owen Concordia
DH.29 Doncaster
Martin 2-0-2
Sikorsky S-29-A
Belriot 25
Dewoitine D.14
DH.54

Speed for:
Burnelli CB-16

Range and pax for:
Cunliffe-Owen OA-1

Speed and range for:
Burnelli RB-1
Burnellie UB-20
Potez P.840
Liore-Olivier LeO.21
Fokker F.VIII
Ford Stout
Saunders Kittywake (or Kittiwake depending on what source you are looking at)



These should keep you occupied :)

I'd rather wait patiently thanks  :wink:

Title: Can't Register
Post by: MrOrange on October 10, 2007, 01:00:27 pm

You should give it a try, it's really tough to find anything useful. Oh, and scrap:

Speed for:
Burnelli CB-16

Pax for:
Cunliffe-Owen OA-1

Title: Can't Register
Post by: Jps on October 10, 2007, 01:04:40 pm

I typed in google.. it didnt tell much  :roll:

Title: Can't Register
Post by: MrOrange on October 10, 2007, 01:05:21 pm

That's why it's so hard to find.

Title: Can't Register
Post by: Jps on October 10, 2007, 01:09:15 pm

That's why im searching on wiki now  :D

Title: Can't Register
Post by: MrOrange on October 10, 2007, 01:09:37 pm

Don't bother.

Title: Can't Register
Post by: dktc on October 10, 2007, 01:12:25 pm

Quote from: "MrOrange"

Don't bother.

I have tried both google and wiki... so... what MrOrange said :wink:

Title: Can't Register
Post by: blue25 on October 10, 2007, 01:14:05 pm

Quote from: "dktc"

Quote from: "MrOrange"

Don't bother.

I have tried both google and wiki... so... what MrOrange said :wink:

Lazy :roll:
What are you accomplishing next?
The award for "Most Creative Posts"?

Title: Can't Register
Post by: Jps on October 10, 2007, 01:30:08 pm

^ How's his posts creative.. anyways where do you guys find the information  :lol:

Title: Can't Register
Post by: MrOrange on October 10, 2007, 01:38:41 pm

Full-text University Libraries, aviation magazines, some better googling, manufacturer datasheets, where possible more of the mentioned sources together.

Quote

Lazy Rolling Eyes
What are you accomplishing next?
The award for "Most Creative Posts"?

? Don't get your point. If you mean my posts aren't creative, then why do you bother? I've seen posts coming from you that aren't creative (I'm not joining this one, for example) so don't go blaming me. Besides, I'm just telling him to not search on wikipedia, because I know he's not gonna find anything. It's a warning, not an airline report.

Title: Can't Register
Post by: Scandalian Airlines on October 10, 2007, 02:42:06 pm

Martin 2-O-2 range 1500, can't tell if it's empty or loaded though :)
Would think it's empty considering the 4-O-4 has an empty range of 2575, and only 805 fully loaded.

Title: Can't Register
Post by: MrOrange on October 10, 2007, 02:43:04 pm

Source? :)

Title: Can't Register
Post by: Jps on October 10, 2007, 02:44:18 pm

Quote from: "MrOrange"

Source? :)

Yea source please lol

Title: Can't Register
Post by: MrOrange on October 10, 2007, 02:45:50 pm

I think the data is quite reliable, but you never know :) @JPS: You just want to know where to look right?

Title: Can't Register
Post by: Jps on October 10, 2007, 02:46:07 pm

Oh.. he got it from here http://en.wikipedia.org/wiki/Martin_2-0-2

@MrOrange yes but i found out

Title: Can't Register
Post by: MrOrange on October 10, 2007, 02:56:24 pm

Thing with wikipedia is, you never know how reliable is is unless the article correctly quotes its sources.

Title: Can't Register
Post by: Jps on October 10, 2007, 03:04:16 pm

Most of them are wrong anyways... and the CRJ's in game have inaccurate data

Title: Can't Register
Post by: Scandalian Airlines on October 10, 2007, 03:05:12 pm

Hmmm, if I release my source I lose my advantage in the run for aircraft data officer :D

But here it is:
http://www.aerofiles.com/_martin.html
And you can find ton's of stuff navigating from their first page.

Title: Can't Register
Post by: Scandalian Airlines on October 10, 2007, 03:25:27 pm

Burnelli RB-1, range 760

Title: Can't Register
Post by: dktc on October 10, 2007, 03:27:44 pm

Quote from: "Scandalian Airlines"

Burnelli RB-1, range 760

km? mi? nm? m? ft? :lol:

Title: Can't Register
Post by: Scandalian Airlines on October 10, 2007, 03:35:44 pm

feet lol
Miles, for me it's always miles etc when it's about aviation, even though I am a metric fan.

Title: Can't Register
Post by: MrOrange on October 10, 2007, 03:50:04 pm

I know aerofiles. The problem with it is that it doesn't quote sources individually, which is something I do want. If I get data from aerofiles, I really want to crosscheck them before I publish it. Oh, and speed for the RB-1 is (also according to aerofiles) 91 kts. The 760 listed as range is in nautical miles.

Title: Can't Register
Post by: StephenM on October 10, 2007, 05:11:15 pm

Topic gone way off, so its now locked.