Compiled Howtos Kleines SWGEMu Update

MYSQL TUTORIAL by: Nimion For support go to: http://forums.swgemu.com/viewtopic.php?t=2790

This is for all the people who are having trouble setting up their database. It includes pictures! So pay attention and go step by step. I'll make sure to be pretty detailed. Each step has a step # picture procedure which shows the steps in a graphical format =P

Im assuming... -> You have a working compiled version -> You have MYSQL 5.x installed correctly -> Downloaded ultymas client and followed the setup First you need to download a program called Navicat, now I've provided the link below. Just an FYI theres about 3-4 versions I found when I was looking for it, so use the one from my link because the others dont work with what we're doing. Navicat - http://www.navicat.com/ For those using windows use the (x86) version. Once installed open it up because this is where we're going to do everything to load the swgemu.sql into the mysql database so the server has something to look at. Step 1 - Setting up Navicat: Step 1 Picture Procedure http://i56.photobucket.com/albums/g162/nimion/step1.jpg Click the connection button, this will open up the connection properties window. This is where we specify all the information needed to connect to our mysql database. Hostname/IP address: localhost (use localhost if your going to be hosting the db, otherwise use the IP of the computer which is) Port: 3306 Usename: root Password: whatever you chose as the root password at your mysql setup Now click test connection, if a box pops up saying Connection successfull, congrats on making it this far! If you got an error, make sure the hostname, username and password are correct. AND that your database is online and running. Step 2 - Creating the blank database for swgemu: Step 2 Picture Procedure http://i56.photobucket.com/albums/g162/nimion/step2.jpg You should now have a new item in the Connections box called localhost (or whatever IP/name you gave it). Please press the + next to it, dont worry it wont bite. You should see a few green or gray cylinder stacks. Those are our infamous databases! However we arnt going to be touching those, we want to create our own. Right click localhost (or the name of the conncetion) and click New database...a window will pop up. Now this is where we refer to the core config file. So open that up with notepad or whatever and copy the DBName = string into the database name box in navicat. Click ok and you'll see a new green/gray icon there which the name swgemu next to it. If you do not, recheck the steps. Step 3 - Uploading the SWGEMU database: Step 3 Picture Procedure http://i56.photobucket.com/albums/g162/nimion/step3.jpg Remember that shiney new database we called swgemu in the last step? Well right click it and and choose Execute Batch File... Another window will pop up (surprised yet?) that will ask for you to input a .sql file. This is where we point to the swgemu.sql. Once you've done that click ok and you'll see another screen pop up which loads the database. Check the picture to make sure both screens show "[Msg] Finished - 36 queries executed successfully" Step 4 - Configureing the core configure file and connecting to the server Step 4 Picture Procedure http://i56.photobucket.com/albums/g162/nimion/step4.jpg Lets open the core config file back up and make sure all our information is correct for the server to connect to it. DBIP = 127.0.0.1 (or localhost) DBPort = 3306 DBUser = root DBPass = (your mysql password) DBName = swgemu Make sure that information is correct and is relevent to YOUR mysql database such as the password. Save and exit the core file. Now open up the swgemu.exe and launch the server. You should see all this... (Finally we've connected!) Now dont get all happy yet we've still got to create our character account! Step 5 - Creating your account and logging in Step 5 Picture Procedure http://i56.photobucket.com/albums/g162/nimion/step5.jpg This is the final step, bring Navicat back up and expand the swgemu database by the + next to it. You'll see a lot fo confusing options, however we're just going to want to mess with the tables so click that. In the right window you'll start to see a few tables, account, badge, etc. Click account and then click the button open table which is right above that. The account table will open showing a few parameters we can change. Now you can change the username & password or leave it as is. Just so everyone knows the default password and username is test/test. Now that we have our password and username minimize navicat and launch the swg emu client ( i've already assumed you've set that up correctly so I wont go into it). Once started up you'll see the login screen, enter test & test (or whatever u changed it to) and click login. VOILA! Welcome to precu swg emu style. If theres any problems post'em here and I'll see what I can do or correct any mistakes in my howto! Very Happy

END MYSQL, BEGIN Binary SETUP GUIDE by: nom, For support go to: http://forums.swgemu.com/viewtopic.php?t=2781

Step 1 - Download MySQL from mysql.com. - Done from tut 1. Step 2 - Configure a password for MySQL (I beleive this is done in the MySQL server configuration, but I skipped that myself because I know what i'm doing with MySQL) - - Done from tut 1. Step 3 - Download SWGEmu server (see http://forums.swgemu.com/viewtopic.php?t=2768 for Source Code). Compile it. Step 4 - Configure SWGEmu Server. Unzip/Unrar the files and edit conf/Core.conf. Change the MySQL IP, login and password as necessary. (If your MySQL server is running on the same computer as the server, you can leave the IP as 127.0.0.1). Step 5 - Load SQL for database. This will be in the MySQL folder of the binary distribution above. Once you have it open a Command Prompt in Windows (Start => Run => 'cmd' ) Run mysql -u root -p < swgemu.sql (Replace any filenames, usernames etc with the details you used) Step 6 - Load the SWGEmu Server. If you get an error about MYSQL libraries, go into your MySQL folder, and search for libmysql.dll. Copy this file to C:\Windows\System\ Step 7 - If all goes well, you should have a server up and running. Next, try to load the client. I don't know of a download link for the client, at this point in time, so if someone finds one, please let me know and i'll update this thread. Edit swgemu_login.cfg and change the loginServerAddress0=127.0.0.1 (or the ip address of your server) Create a shortcut to swgemu.exe (the client, not the server) and add the following command line options: -- -s Station subscriptionFeatures=1 gameFeatures=255 For example: F:\Games\SWG\swgemu.exe -- -s Station subscriptionFeatures=1 gameFeatures=255 Step 8 Log in and play! The default database creates a username 'test' with password 'test'. You can use that, or if you know your way around MySQL, insert another row into the database with the details you'd like to use, along with a row in the character table to log in with.[/b]