• Author: 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/

• 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

• 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

• 1. Copy AES.cls from the client folder to the server folder.
  2. Update Public Const strCONN to reflect our database information.
  • Replace
    Code:

    DRIVER={MySQL};
    With
    Code:

    DRIVER={MySQL ODBC 3.51 Driver};
    Change the UID and PWD to the username and password you created when you installed MySQL.
  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 for
  Code:

  If SerialsExist(HDModel, HDSerial) Then
  Comment out the 4-line statement.
  6. Convert class creating to use MySQL. It currently uses the old method.
  • Find
    Code:

    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, entire
    Code:

    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.

Paneak Wrote:Any way to repost sql_dump? The link is dead.

Beres Wrote:thx, but i ment cruzns one with the 5 everything >_>