Mirage Source

Free ORPG making software.
It is currently Thu Mar 28, 2024 12:40 pm

All times are UTC




Post new topic Reply to topic  [ 11 posts ] 
Author Message
PostPosted: Sat Jun 23, 2007 2:43 am 
Offline
Knowledgeable
User avatar

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 Guide
    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/

*** 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.
      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.


Top
 Profile  
 
PostPosted: Fri Sep 21, 2007 8:11 am 
Offline
Community Leader
User avatar

Joined: Mon May 29, 2006 1:00 pm
Posts: 2538
Location: Sweden
Google Talk: johansson_tk@hotmail.com
How come I never seen this tytorial xD ?

Made it into a announcement since its so good :lol:

_________________
I'm on Facebook!My Youtube Channel Send me an email
Image


Top
 Profile  
 
PostPosted: Wed Jan 09, 2008 5:01 am 
Offline
Newbie

Joined: Wed Jan 09, 2008 5:00 am
Posts: 8
Any way to repost sql_dump? The link is dead.

_________________
Image


Top
 Profile  
 
PostPosted: Wed Jan 09, 2008 8:52 pm 
Offline
Knowledgeable
User avatar

Joined: Mon May 29, 2006 6:23 pm
Posts: 128
Paneak wrote:
Any way to repost sql_dump? The link is dead.
All links should work now.


Top
 Profile  
 
PostPosted: Thu Jan 10, 2008 2:50 am 
Offline
Newbie

Joined: Wed Jan 09, 2008 5:00 am
Posts: 8
Thank you very much.

_________________
Image


Top
 Profile  
 
PostPosted: Fri Jan 11, 2008 1:45 pm 
Offline
Newbie

Joined: Wed Jan 09, 2008 5:00 am
Posts: 8
Do no use the AddChar function above it will lock up the server. This post needs to be edited as it does have some problems and is incomplete.

_________________
Image


Top
 Profile  
 
PostPosted: Tue May 27, 2008 1:57 am 
Offline
Knowledgeable

Joined: Sun Jul 29, 2007 12:23 am
Posts: 199
anyone wanna post that sql_dump again? link is bad


Top
 Profile  
 
PostPosted: Tue May 27, 2008 2:23 am 
Offline
Pro
User avatar

Joined: Wed Jun 07, 2006 8:04 pm
Posts: 464
Location: MI
Google Talk: asrrin29@gmail.com
Try This:


Attachments:
mirage_online.zip [1.3 KiB]
Downloaded 463 times

_________________
Image
Image
Top
 Profile  
 
PostPosted: Tue May 27, 2008 2:27 am 
Offline
Knowledgeable

Joined: Sun Jul 29, 2007 12:23 am
Posts: 199
thx, but i ment cruzns one with the 5 everything >_>


Top
 Profile  
 
PostPosted: Tue May 27, 2008 2:41 am 
Offline
Knowledgeable
User avatar

Joined: Mon May 29, 2006 6:23 pm
Posts: 128
Beres wrote:
thx, but i ment cruzns one with the 5 everything >_>
Sorry, made a new one and it's uploaded now.

sql dump


Top
 Profile  
 
PostPosted: Wed Aug 13, 2008 1:35 am 
Offline
Newbie

Joined: Wed Aug 13, 2008 1:33 am
Posts: 1
That character addition code does indeed crash the server.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group