Search found 42 matches

by BBloke
Mon 26 Nov 2007 4:37 pm
Forum: General Discussion
Topic: italy map - genova wont populate
Replies: 7
Views: 2346

Hi Shades, I have been trying to think on what impact the following may have as to what I have done in the database tables. 1. amended the specified flights to the take off points as detailed in the FMB and further reduced the value by 300 so its within a tighter radius - This is so it can be listed...
by BBloke
Mon 26 Nov 2007 2:26 pm
Forum: General Discussion
Topic: italy map - genova wont populate
Replies: 7
Views: 2346

I tried a simple single flight at Genova for Blue and the same on another strip of A20's. The Base for A20's populates but the blue base is empty. The ObjMissionData table has both records for the planes UPDATE: I check the genova airfield based around the napoli field flight and bearing in mind I d...
by BBloke
Fri 09 Nov 2007 9:19 am
Forum: General Discussion
Topic: BUS Database Enhancement and MySQL Error 2206
Replies: 4
Views: 2436

No problem Shades. I have always tended to fall back on the seow.sourceforge.net pages for help and thats where my lack of clarity has stemmed from. After all that where the files are downloaded from and we all like to be guided with our hands held from time to time. Thanks for the wiki link it is c...
by BBloke
Fri 09 Nov 2007 6:23 am
Forum: General Discussion
Topic: Maps with Factories
Replies: 7
Views: 2560

Sweet Shades.

You memory is certainly better than mine.

I amended the query to:

SELECT Map, Count(*) FROM Industrial_Installations WHERE Location LIKE '%Factory%' GROUP BY Map ORDER BY Map;
by BBloke
Fri 09 Nov 2007 5:01 am
Forum: General Discussion
Topic: BUS Database Enhancement and MySQL Error 2206
Replies: 4
Views: 2436

Thanks Shades.

Wish I knew that a little while back :)
by BBloke
Thu 08 Nov 2007 7:43 pm
Forum: Technical Discussion
Topic: Bug Reports: B16Enk's seow_server_v1.0
Replies: 24
Views: 9649

This little script will help. Save it to a file in your www folder and call it through your web browser. <?php $dbname = 'seow'; if (!mysql_connect('localhost', 'root', 'root')) { echo 'Could not connect to mysql'; exit; } $result = mysql_list_tables($dbname); if (!$result) { echo "DB Error, co...
by BBloke
Thu 08 Nov 2007 11:15 am
Forum: Technical Discussion
Topic: Factories and Fuel Dumps not showing up on Map
Replies: 8
Views: 2291

Thanks for that Shades. It has helped me figure a few things out. I remember in the earlier days there was a base file then additional map files which found its way in to my head and wont go away. I have put together a post which cures the BUS and helps MySQL standalone version from barfing at data ...
by BBloke
Thu 08 Nov 2007 11:12 am
Forum: General Discussion
Topic: Maps with Factories
Replies: 7
Views: 2560

Sorry for double posting but I have worked out a cure and I believe it sorts the factories out too.

There is a little snippet in it for a standalone MySQL version which helps with database population.

Please see this thread: http://raf74.net/seow/viewtopic.php?p=1116#1116
by BBloke
Thu 08 Nov 2007 11:03 am
Forum: General Discussion
Topic: BUS Database Enhancement and MySQL Error 2206
Replies: 4
Views: 2436

BUS Database Enhancement and MySQL Error 2206

Hi All, I read the message originally posted by doubletap http://raf74.net/seow/viewtopic.php?p=1115 so I did some digging. Unfortunately it appears there has been an error on populating the database which has left it short. Below is how to cure this problem. Ok. There are a few things that need att...
by BBloke
Thu 08 Nov 2007 10:21 am
Forum: General Discussion
Topic: Maps with Factories
Replies: 7
Views: 2560

I'm just doing some testing with different installations on my system and the BUS. From what I can see so far the DB hasn't taken too well. I have tried to push the SQL Unix Reference file in and it sqeeled at around line 60,000. Server gone away (this was via client server over the web). I correcte...
by BBloke
Thu 08 Nov 2007 7:34 am
Forum: Technical Discussion
Topic: Factories and Fuel Dumps not showing up on Map
Replies: 8
Views: 2291

Hi doubletap, I will have a look at the database in the BUS. It may be incomplete for your sector. Give me a little time and I'll post back. I have a question regarding the SQL files. I have pondered over it before but am I right in thinking that you can get away with using the Unix Reference file w...
by BBloke
Sat 08 Sep 2007 11:28 am
Forum: General Discussion
Topic: Hello and thank you!
Replies: 12
Views: 4073

S! B16, Very nice work and takes a lot of pain away from the end user. I did a little work on the funny character and to eliminate it without changing browser settings follow the details below: Funny character fix. If you've noticed that annoying funny character ? crop up on the pages then you can d...