Official SEOW

Posted: **Mon 08 Oct 2007 9:49 am**

Nice to know EJGr.Ost_Chamel!

I am running a server using the XAMPP package, and had the problem with no response from MySQL on some of the detailed mission statistic pages.

First, InnoDB was not enabled by default, which I fixed using your post here. But since I was already 15+ missions into the campaign, I also had to convert the tables already in use from MyISAM to InnoDB. I did that by using

Code: Select all

ALTER TABLE ... ENGINE=INNODB

on all SEOW tables, as described here.

And now, the detailed mission statistic works for all the missions. Thanks!

Posted: **Mon 08 Oct 2007 5:45 pm**

Mhondoz wrote: I did that by using
Code: Select all
ALTER TABLE ... ENGINE=INNODB
on all SEOW tables, as described here.

Nice one! I didn't know that and my way was way less elegant.

I converted my DB by exporting it into a SQL-Dump, editing the dump with a text editor replacing "MyISAM" with InnoDB (88 times) and then restored the DB from the modified dump.

But I have a good excuse: it was very late at night on a LAN-Party and I had no access to the internet!

Greetings

Chamel

Posted: **Thu 08 Nov 2007 7:43 pm**

This little script will help.

Save it to a file in your www folder and call it through your web browser.

Code: Select all

<?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, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    $sql = "ALTER TABLE ".$row[0]." ENGINE=INNODB";
    
    mysql_query($sql);
    echo "Table ".$row[0]." Changed<br/>";
}

mysql_free_result($result);

?>

Posted: **Fri 29 Aug 2008 8:15 pm**

Hi

Our Group are playing a lot COOP missions at the moment and the concept of an internal Squad War came up.
Having come across SEOW sytem I'd thought that would do the trick nicely.
BUT my knowledge regarding setting up SQL based DB's on PC based web server is zero so was attempting to source the auto installer package. Any updates to a link or is it still been repackaged with the newer versions DB MP etc ?

Any assistance appreciated.

CadMan
Mission Builder InSPire Dedicated
Online since Nov 2004
"The Flying Kiwis"

Posted: **Fri 29 Aug 2008 9:52 pm**

Hi CadMan,

Welcome! The all-in-one installer put together by BBloke has been superseded by newer releases of SEOW. You could try to contact BBloke to see if he wants to produce a new installer, or you could try the standard install. Check out the SEOWiki for some instructions.

http://seowwiki.swil.fr/index.php?title=Main_Page

Cheers,
4Shades

Posted: **Sun 31 Aug 2008 6:07 am**

I've had this same problem, 2 guys form JFC have both had a shot at trying to set it up and we haven't succeeded.
I tried to modify the original all-in-one installer and failed, so a newer all-in-one would be good!

Posted: **Sun 31 Aug 2008 10:34 am**

Hi Tom,

If you want to test out SEOW before embarking on the install again, just drop by at SEOW HQ teamspeak some time and we'll show you the system.

Cheers,
4Shades

Posted: **Sun 31 Aug 2008 2:24 pm**

Thanks for the offer, I'll try and come by some time in the near future

Posted: **Sat 20 Sep 2008 11:16 am**

Sorry if I've missed something obvious, but I can't seem to find an IP for your teamspeak on the forums. Is there one running?
I've just got permission from the head of JFC to use some of the JFC website space to host the appropriate files (ie the mission planner) if I can get it working. I've downloaded the most recent Scorched Earth files, so all I need now is to know how!

Posted: **Sat 20 Sep 2008 11:49 am**

Hi Tom,

Check out http://seowhq.net/, the TS password is "seow".

Cheers,
4Shades

Official SEOW

Bug Reports: B16Enk's seow_server_v1.0