|
Knowledgeable |
|
Joined: Mon May 29, 2006 6:23 pm Posts: 128
|
A work in progress (need to make some points more clear.) guide for getting a default v3.0.7 working.Mirage Source 3.0.7 :: Installation GuideAuthor: Cruzn. MS Build: 3.0.7 (download) Guide Release: June 22nd, 2007 Last Update: --- Guide Notes: A simple crash-course guide into getting Mirage Source 3.0.7 fully functional. Abbreviations:
MS = Mirage Source, Root = The path to your mirage source installation. Example: C://Documents and Settings/YourComputer/Desktop/MS3.0.7/ *** Mirage Source REQUIRES Visual Basic 6.0. If you don't have this, you cannot edit the project. ONLY Visual Basic 6.0. VB.NET, or any other version, will not work. Sorry. Discussion of illegal distributions is strictly prohibited. Please do not ask for a copy on this thread or any other thread. ***For Mirage Source 3.0.7, we will need 3 components: MySQL, MySQL ODBC, and MS3.0.7. =) Installing MySQL:Download MySQL 5.0 from http://dev.mysql.com/downloads/mysql/5.0.html. 1. Open up the MySQL installer you downloaded and click Next. view image 2. You should see 3 options for installing: Typical, Complete, and Custom. I'm chooinsg complete, but Typical should suffice for most users. Click next. view image 3. Let it begin installing by click Install. view image 4. When it's finished, you will be given a screen with a checkbox. We do want to configure the server now, so check the box and click Finish. view image 5. Click next. view image 6. We're going to customize our server right now so select Detailed Configuration and click Next. view image 7. If you are going to run the server and MySQL on the same machine, select Developer Machine. If you can spare the memory and are going to run soley MySQL on a computer, select Server or Dedicated Machine. Click next. view image 8. Select Multifunctional Database for this one. It suits our purpose best. Click next. view image 9. Select the path where you want your data stored and click next. view image 10. This is the number of max connections that are available at any given time for your server. If you don't plan on having any other users connecting to your database, you may want to select Manual Setting and set the max connections to 5 or lower. Otherwise, Decision Support is fine. Click Next. view image 11. If you don't plan on allowing any external editting (from another computer) then disable TCP/IP networking. I recommend keeping strict mode enabled. Click Next. view image 12. Standard character set should do fine. Click Next. view image 13. This page is purely optional, but these are the settings I will be using: view image. Click Next. 14. Check the Modify Security Settings box and type in your root username and password. I don't recommend adding the annonymous account. Click Next. view image 15. Execute, wait, and finish! view image Installing ODBC:Download the ODBC driver from http://dev.mysql.com/downloads/connector/odbc/3.51.html. 1. Open up the ODBC installer you downloaded and click Next. view image 2. I recommend a full install but a typical installation will suffice. view image 3. Install. view image 4. Finish! You're done with this. view image Fixing Up the Source:There are a few things we need to take care of. 1. Copy AES.cls from the client folder to the server folder. 2. Update Public Const strCONN to reflect our database information. 3. Dim HD in Public Function SerialsBlank in the server. Dim HD As String. 4. Remove a small period from Sub SaveSerials. Currently, it says .cLogin. It should simply be cLogin. (Run and compile and you'll see.) 5. Comment out a call to Function SerialExists. This function does not exist. Search forCode: If SerialsExist(HDModel, HDSerial) Then Comment out the 4-line statement. 6. Convert class creating to use MySQL. It currently uses the old method.
FindCode: Sub AddChar You'll notice that it is still the same as the versions that don't use MySQL. With this sub, no characters will be added to the database.
Replace, entireCode: Sub AddChar(ByVal Index As Long, ByVal Name As String, ByVal Sex As Byte, ByVal ClassNum As Byte, ByVal CharNum As Long) Dim RS As ADODB.Recordset Set RS = New ADODB.Recordset RS.Open "SELECT * FROM characters;", Conn_Client, adOpenStatic, adLockOptimistic RS.AddNew
RS!Account = Player(Index).FKey RS!Name = Trim(Name) RS!Sex = Sex RS!Class = ClassNum RS!Sprite = Class(ClassNum).Sprite RS!Level = 1 RS!str = Class(ClassNum).str RS!DEF = Class(ClassNum).DEF RS!SPEED = Class(ClassNum).SPEED RS!MAGI = Class(ClassNum).MAGI RS!Map = 1 RS!X = 1 RS!Y = 1 RS!HP = 10 RS!MP = 10 RS!SP = 10 RS.Update If Player(Index).Char(CharNum).FKey = 0 Then Player(Index).Char(CharNum).FKey = RS!FKey End If
RS.Close Set RS = Nothing End Sub 7. You won't be able to run the server just yet. The way this is set up, if you don't have the exact number of rows in your database that you have defined your max values, you will get an error. I recommened using my sql dump. This will give you 5 maps, 5 shops, 5 items, 5 npcs, and 5 spells. Set your MAX_ variables to equal these (both client and server) and test out your 3.0.7 server. =) Afterwards you can add blank rows to your database. This could be done easily in the server project. Call savemap X times, call savenpc X times, etc etc.
|
|