Jump to content

Revision 878: fixed #191 fixed #198 fixed #202, refs #182


Nabeel

Recommended Posts

  • Administrators

fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/191" title="enhancement: Expand Admin Email Section (closed: fixed)">#191</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/198" title="bug: TOTAL_HOURS missing from settings (closed: fixed)">#198</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/202" title="bug: Pirep charts noticed #34;min#34;: 1, #34;max#34;: 1, (closed: fixed)">#202</a>, refs <a class="accepted ticket" href="http://bugs.phpvms.net/ticket/182" title="enhancement: draw routes on database on pireps/schedules/acars (accepted)">#182</a>

View more details, download from here

Notes

You can drop these two tables:

phpvms_navdb

phpvms_airways

The install/navdata.sql file has to be manually imported as well. Mouse over the links above to see which bugs have been fixes. Routes aren't cached anymore except for PIREPs. Re-wrote the route parsing mechanism - only uses 2 queries flat, instead of the (n+n) queries (where n = number of segments in the route). The new table format helps with this. The file is almost smaller with fewer entries, but does cover nearly everything. Let me know if something huge is missing.

Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs.

Note 2

Fresh install won't work with this - the update will complete but throws an error. Just create an "airways.sql" file which is blank in the /install directory

Link to comment
Share on other sites

  • Moderators

fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/191" title="enhancement: Expand Admin Email Section (closed: fixed)">#191</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/198" title="bug: TOTAL_HOURS missing from settings (closed: fixed)">#198</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/202" title="bug: Pirep charts noticed #34;min#34;: 1, #34;max#34;: 1, (closed: fixed)">#202</a>, refs <a class="accepted ticket" href="http://bugs.phpvms.net/ticket/182" title="enhancement: draw routes on database on pireps/schedules/acars (accepted)">#182</a>

View more details, download from here

Notes

You can drop these two tables:

phpvms_navdb

phpvms_airways

The install/navdata.sql file has to be manually imported as well. Mouse over the links above to see which bugs have been fixes. Routes aren't cached anymore except for PIREPs. Re-wrote the route parsing mechanism - only uses 2 queries flat, instead of the (n+n) queries (where n = number of segments in the route). The new table format helps with this. The file is almost smaller with fewer entries, but does cover nearly everything. Let me know if something huge is missing.

Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs.

will test it in a few hours

now its famely time with the wife :P;)

Link to comment
Share on other sites

  • Moderators

will test it in a few hours

now its famely time with the wife :P;)

got this error

Warning: file_get_contents(/home/tntvirtua/domains/tnt-virtual.be/public_html//install/airways.sql) [function.file-get-contents]: failed to open stream: No such file or directory in /home/tntvirtua/domains/tnt-virtual.be/public_html/install/Installer.class.php on line 306

Link to comment
Share on other sites

  • Administrators

Yeah it looks like mysqldump does one huge insert, which kinda sucks. But I'm checking the options for that, I think I can break it up.

I have scripts which run and generate all the data from the nav files (which take about 45 minutes by itself), and then finally do a dump, so it just uses the CLI. I'm too lazy to go through phpmyadmin/download/reupload, etc etc lol

Link to comment
Share on other sites

  • Moderators

Yeah it looks like mysqldump does one huge insert, which kinda sucks. But I'm checking the options for that, I think I can break it up.

I have scripts which run and generate all the data from the nav files (which take about 45 minutes by itself), and then finally do a dump, so it just uses the CLI. I'm too lazy to go through phpmyadmin/download/reupload, etc etc lol

LAZY BOY B)

Link to comment
Share on other sites

Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs.

Thanks for adding this Nabeel!

While testing this feature I found that half of it works.

The e-mail for submitted PIREPS worked correctly and went to the e-mail I stated. The e-mail for the registered users did not work right. It sent an e-mail to the address I had set for the PIREPS but not the one defined in the config file.

I'm still getting the "Invalid address: You must provide at least one recipient email address." after someone registers.

Link to comment
Share on other sites

  • Administrators

Thanks for adding this Nabeel!

While testing this feature I found that half of it works.

The e-mail for submitted PIREPS worked correctly and went to the e-mail I stated. The e-mail for the registered users did not work right. It sent an e-mail to the address I had set for the PIREPS but not the one defined in the config file.

I'm still getting the "Invalid address: You must provide at least one recipient email address." after someone registers.

Seems like I copy/pasted and didn't change which setting it looked at =\

I'm trying to duplicate the second one - what's the email address you're entering? And what PHP version are you on?

Link to comment
Share on other sites

  • Moderators

These are the errors im getting with IE on the Live map,

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0)

Timestamp: Tue, 2 Mar 2010 14:28:16 UTC

Message: Expected identifier

Line: 89

Char: 5

Code: 0

URI: http://www.easyjetva.com/lib/js/phpvms.js

Message: Object doesn't support this property or method

Line: 95

Char: 3

Code: 0

URI: http://www.easyjetva.com/lib/js/acarsmap.js

Message: Unspecified error.

Line: 32

Char: 37

Code: 0

And these when viewing a pirep map,

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0)

Timestamp: Tue, 2 Mar 2010 14:31:13 UTC

Message: Unspecified error.

Line: 13

Char: 458

Code: 0

URI: http://maps.gstatic.com/intl/en_gb/mapfiles/api-3/30/main.js

Message: Unspecified error.

Line: 32

Char: 37

Code: 0

URI: http://maps.gstatic.com/intl/en_gb/mapfiles/api-3/30/main.js

URI: http://maps.gstatic.com/intl/en_gb/mapfiles/api-3/30/main.js

Link to comment
Share on other sites

  • Moderators

OK on my dev site i have just gone back to the default skin to eliminate any thing i have done and i still get the following error for viewing the pireps map,

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0)

Timestamp: Tue, 2 Mar 2010 17:12:35 UTC

Message: Expected identifier, string or number

Line: 145

Char: 3

Code: 0

URI: bladebla/index.php/pireps/view/30

Link to comment
Share on other sites

×
×
  • Create New...