WG, MajorMUD, Pervasive SQL Install Guide

[Bleak]

@Ray
So, the team members would access the DB through the PSQL client or NMR?
Is there some ODBC provision in NMR I'm not seeing?

DOH... NM.
I guess that answers my question. Thanks Ghaleon.

[Raybdbomb]

Quote from: Ghaleon;108963Yup. You can also do what I did and create a windows server with remote login and run psql, install nightmare, and have all your editors log in with their own names. They would be able to edit using nightmare at the same time.

The only problem was the rare instance where someone would be editing the same item, but that was rare and it only just removed the work that was being done that instant.

But yes with the new psql I have had no problems editing/updating/importing in nightmare while the bbs and mud was running.

make a user lock table

[Bustin]

I'm fairly new to SQL so sorry if this is an obvious question. If I'm understanding the script right, it's pulling the data out from the .dats and into a SQL database... Is there any reason this script wouldn't work with mySQL 5.0/php5/apache web server?

Thanks

[Ghaleon]

um no and no. its not pulling any data anywhere.

[Bustin]

oh it looked like it was creating tables in the database based off the .dats... what exactly does the script do then? and by no do you mean, no i shouldn't have any problem running the script with my setup? o_O im such a sql newb.

[Ghaleon]

Well first off you need to have SOME knowledge in dealing with SQL. The install file basically maps the location for all of the information found in the data files.

[Janus]

thanks for your guys' work on this, i got it workin perfectly right now.

one small note-- you have to restart your computer after installing psql before you can connect to the database

[Raybdbomb]

you might just have to load the db... but w/e works for ya.

95%+ of solutions windows problems involve rebooting. <1% of solutions to linux problems involve rebooting.

[Janus]

also, if you're relatively new to all this (like me) you might have a hard time figuring out how to read the data once all the tables are set up. i'm sure theres an easier way using the functions in config.php, but this is what i found works:

Quote$connection = odbc_connect("driver={Pervasive ODBC Client
Interface};ServerName=localhost;ServerDSN=mud", "", "");
$query = "SELECT * FROM classes"; // or whatever query you want
$result = odbc_exec($connection, $query);

while($row = odbc_fetch_array($result)) {
echo $row['name'];
echo "
";
}

that example prints out all the class names.

thanks again to ray and ghaleon!

[Raybdbomb]

bump for invisigod