I need help with setting up a LAN server using OA base.

[Roach :3]

Basically, I suck at MYSQL and I need some help.

Code: [Select]

// This is the MySQL configuration file for the OpenAura framework.
// Simply edit the values below and stick to the format of the example.
[MySQL]
force mysql_characters_table = 100;
force mysql_players_table = 100;
force mysql_username = example;
force mysql_password = example;
force mysql_database = example;
force mysql_host = example.com;

Code: [Select]

CREATE TABLE IF NOT EXISTS `characters` (
  `_Key` smallint(11) unsigned NOT NULL AUTO_INCREMENT,
  `_Data` text NOT NULL,
  `_Name` varchar(150) NOT NULL,
  `_Ammo` text NOT NULL,
  `_Cash` varchar(150) NOT NULL,
  `_Model` varchar(250) NOT NULL,
  `_Flags` text NOT NULL,
  `_Schema` text NOT NULL,
  `_Gender` varchar(50) NOT NULL,
  `_Faction` varchar(50) NOT NULL,
  `_SteamID` varchar(60) NOT NULL,
  `_SteamName` varchar(150) NOT NULL,
  `_Inventory` text NOT NULL,
  `_OnNextLoad` text NOT NULL,
  `_Attributes` text NOT NULL,
  `_LastPlayed` varchar(50) NOT NULL,
  `_TimeCreated` varchar(50) NOT NULL,
  `_CharacterID` varchar(50) NOT NULL,
  `_RecognisedNames` text NOT NULL,
  PRIMARY KEY (`_Key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `players` (
  `_Key` smallint(11) unsigned NOT NULL AUTO_INCREMENT,
  `_Data` text NOT NULL,
  `_Schema` text NOT NULL,
  `_SteamID` varchar(60) NOT NULL,
  `_Donations` text NOT NULL,
  `_UserGroup` text NOT NULL,
  `_IPAddress` varchar(50) NOT NULL,
  `_SteamName` varchar(150) NOT NULL,
  `_OnNextPlay` text NOT NULL,
  `_LastPlayed` varchar(50) NOT NULL,
  `_TimeJoined` varchar(50) NOT NULL,
  PRIMARY KEY (`_Key`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
...What the heck do I do?

By the way, this is a simple server for some weapon/item testing nothing special.

[coolzeldad]

Not sure what oa base is but I'll try to give you a lead.

Install mysql.

Run setup script, most default values should be the safest to use in production if i remember correctly.. be sure though and check the options carefully.

Setup another mysql user with username, pass, and ip/hostname to where the machine that user will login from.

Login to mysql as root and create a new database. Execute those queries (in your second code block), it should create two tables: characters and players, within the new database.

As root assign your user that you created permissions for the database or individual tables (not sure which ones.. probably want to refer to whatever documentation that came with, can try select, insert, update.. don't recommend all permissions..)

Now go to your config file (first codeblock) and set the correct username, password, database name, and location of the mysql server.

The MySQL documentation has some really helpful examples for doing this, or you can try a GUI tool like sqlyog (community edition is free) http://code.google.com/p/sqlyog/

Good luck!