HispaRed Mir 2
Likes Likes:  4
Page 1 of 14 12311 ... LastLast
Results 1 to 15 of 208
  1. #1
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Woool 1.9 Server Files

    Setup Guide:

    Downloads:
    SQL 2000 (Windows XP)
    SQL 2008 (Windows 7)

    Server Files Download (Updated 08/06/2014)
    English WooolClient v1

    Server Source Code




    Move server files to a drive (Default is C:\, if you choose another you will need to change your paths in the server files.)

    STEP 1
    Installing Database [SQL 2008]
    SQL Server Management Studio and login.

    Right Click Databases > Restore Databases...

    Select From Devices and browse to CHERODB.bak (WolServer/DB/DBBack)

    Select the last restore point

    In To Database, type in CHERODB.

    Click OK and finish
    ;----------------------------------------------------------------------------------------------------------------------------
    STEP 2
    Setting Server
    Open DBServer/Configuration.ini
    Edit SQL information

    [DATASETUP]
    DataServer=SQL Instance
    DataBase=CHERODB
    DataAccount=sa
    DataPassWord=Password

    Do the same for the following files
    Loginsrv/Logsrv.ini
    Mir200/!Setup.txt
    ;----------------------------------------------------------------------------------------------------------------------------
    STEP 3
    Setting Paths
    This can be done quick using the GameCenter, open Gamecenter and click Configuration tab. Engine directory by default is C:\WolServer\, so if you have your files in C:\ you do not need to set.
    If you have a different path, edit Engine directory then click "Next", keep clicking next until you are prompted to save and click OK.

    If you struggle to use the Gamecenter, here are the list of paths you need to change.
    DBServer/dbsrc.ini
    Code:
    Dir=C:\WolServer\DBServer\FDB\
    IdDir=C:\WolServer\DBServer\FDB\
    HumDir=C:\WolServer\DBServer\FDB\
    FeeDir=C:\WolServer\DBServer\FDB\
    BackupDir=C:\WolServer\DBServer\Backup\
    ConnectDir=C:\WolServer\DBServer\Connection\
    LogDir=C:\WolServer\DBServer\Log\
    Loginsrv/Logsrv.ini
    Code:
    IdDir=C:\WolServer\LoginSrv\IDDB\
    WebLogDir=C:\WolServer\LoginSrv\GameWFolder\
    CountLogDir=C:\WolServer\LoginSrv\CountLog\
    FeedIDList=C:\WolServer\LoginSrv\FeedIDList.txt
    FeedIPList=C:\WolServer\LoginSrv\FeedIPList.txt
    Mir200/!Setup.txt
    Code:
    TriggerDir=
    BaseDir=C:\WolServer\Mir200\Share\
    IDDBDir=..\LoginSrv\IDDB\
    GuildDir=C:\WolServer\Mir200\GuildBase\Guilds\
    GuildFile=C:\WolServer\Mir200\GuildBase\Guildlist.txt
    VentureDir=C:\WolServer\Mir200\ShareV\
    ConLogDir=C:\WolServer\Mir200\ConLog\
    CastleDir=C:\WolServer\Mir200\Castle\
    CastleFile=.\Castle\List.txt
    EnvirDir=C:\WolServer\Mir200\Envir\
    sFriendsDir=.\Friends\
    MapDir=C:\WolServer\Mir200\Map\
    NoticeDir=C:\WolServer\Mir200\Notice\
    LogDir=C:\WolServer\Mir200\Log\
    PlugDir=.\
    ;----------------------------------------------------------------------------------------------------------------------------
    Additional Information
    Setting Up Online
    Following Ports need forwarding
    7000
    7100
    7200
    7300
    7400

    Reason for the extra ports is because we need to run 3 runagates for secure connection.
    Find your IP Adress http://www.whatismyip.com

    Edit the follow files
    DBServer/!ServerInfo.txt
    127.0.0.1 2.127.3.184 7200 2.127.3.184 7300 2.127.3.184 7400

    LoginSrv/!addrtable.txt
    woool Title1 127.0.0.1 2.127.3.184 2.127.3.184:7100

    Mir200/!runaddr.txt
    127.0.0.1
    2.127.3.184
    ;----------------------------------------------------------------------------------------------------------------------------
    CTDataView
    This is a simple editing tool which allows you to edit all databases, more secure way of editing through SQL.
    Setup CTDataView
    Open CTDataView.iniand enter your sql details
    Code:
    [DATASETUP]
    DataServer=
    DataBase=CHERODB
    DataAccount=sa
    DataPassWord=
    ;----------------------------------------------------------------------------------------------------------------------------

    SQL Picture Guide:
    Download:
    Red: 32bit
    Blue: 64bit
    SQL 2008


    Scroll down the list and download SQL Management Studio.


    Installing SQL 2008 R2



    Accept License Terms.



    You can leave the next part default or you can give it any name you wish, it will be the name of your SQL server instance name and is used in the server files
    Code:
    DataServer=DAZZ-PC\SQLEXPRESS
    DataBase=CHERODB
    DataAccount=sa
    DataPassWord=woool
    SQLEXPRESS is default.




    Select mixed mode and enter a password.


    Click Next on next screen and should start installing.

    Install SQL Management Studio is pretty much exactly the same process, you should see it in the features list when you get to that point, if you don't then it's something to do with other sql installations and i can't exactly remember how to solve that problem, happend to me once but can't remember how i fixed it.
    Last edited by Sanity; 03-05-2015 at 02:59 PM. Reason: Found 2.0 version to be unstable.


  2. Legacy MU Online
  3. #2
    Loyal Member OxxpqxxO's Avatar
    Join Date
    Oct 2012
    Posts
    94

    Re: Woool2 SQL Server Files

    Hello Sanity...can you help me with a link for SQL 2008, with all programs to run it on Windows 7 Ultimate 64-bit.

    I downloaded SQL 2008 from this site http://www.microsoft.com/en-us/downl...s.aspx?id=1695, but not work.. or me i don't know how to install and run this program.

    One more question about this new server file.
    This new SQL Server File is much stable for 2.0?
    Last edited by OxxpqxxO; 12-01-2013 at 06:44 PM.

  4. #3
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    What do you mean it didn't work? You can't install SQL or something? I know it works with 2008 because i was on windows 7 last week and i used 2008 and had the server working. I mean you can try with SQL 2005, but i was told it's best to use 2008 with windows 7.

    Yes this version supports 2.0, supports most of Deamon functionality but you won't be able to do much with deamon as i need to script everything in the files.


  5. #4
    Loyal Member OxxpqxxO's Avatar
    Join Date
    Oct 2012
    Posts
    94

    Re: Woool2 SQL Server Files

    Yes i can't install SQL some problem with install progress, but now is installed.

    Now i have another problem with this SQL 2008... for me is totally new and i do not know how to make database for woool.

    I need to have installed this program Visual Studio 2005 Support for SQL Server 2008 for SQL 2008 or this program is not necessary?
    Last edited by OxxpqxxO; 13-01-2013 at 05:40 PM.

  6. #5
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    Quote Originally Posted by OxxpqxxO View Post
    Yes i can't install SQL some problem with install progress, but now is installed.

    But now i have another problem with this SQL 2008... for me is totally new and i do not know how to make database for woool.

    I need to have installed this program Visual Studio 2005 Support for SQL Server 2008 for SQL 2008 or this program is not necessary.
    Duno i just installed SQL and what ever came with it tbh.

    The SQLConfigTool dose everything for you, it will install the database.


  7. #6
    Loyal Member OxxpqxxO's Avatar
    Join Date
    Oct 2012
    Posts
    94

    Re: Woool2 SQL Server Files

    When i start the SQLConfigTool.exe i get 1 error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    I cannot find CT.dat in C:\WolServer\DB\ for this step Database Backup Files > Browse to C:\WolServer\DB\CT.dat
    Last edited by OxxpqxxO; 12-01-2013 at 07:45 PM.

  8. #7
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    Quote Originally Posted by OxxpqxxO View Post
    When i start the SQLConfigTool.exe i get 1 error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    I cannot find CT.dat in C:\WolServer\DB\ for this step Database Backup Files > Browse to C:\WolServer\DB\CT.dat
    Ops i forgot to add the database .
    http://www.mediafire.com/file/il2bpkk1eswwqmh/ct.dat

    Just put it inside your DB folder.

    The error is ok, all it's doing is searching the the connection to database, this tool you can also edit the databases with without having to open sql, don't worry about the error.

    I added the DB to first post, sorry about that, i started this version with a different set of files and i left it in there when i started a fresh base, my bad.
    Last edited by Sanity; 12-01-2013 at 08:13 PM.


  9. #8
    Loyal Member OxxpqxxO's Avatar
    Join Date
    Oct 2012
    Posts
    94

    Re: Woool2 SQL Server Files

    When i click restore i get this error again [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied... i think is something wrong with my sql, because nothing happens after i click restore.

    And i dont have Enterprise Manager in my sql.. i have only this file... Import and Export Data (64-bit) and 1 folder called Configuration Tools inside this forlder i have only 3 programs SQL Server Configuration Manager, SQL Server Error and Usage Reporting, SQL Server Installation Center (64-bit).
    Last edited by OxxpqxxO; 12-01-2013 at 08:25 PM.

  10. #9
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    Nvm it has it working.

    Could you post what you downloaded to get it working please mate.
    Last edited by Sanity; 13-01-2013 at 02:05 AM.


  11. #10
    Loyal Member OxxpqxxO's Avatar
    Join Date
    Oct 2012
    Posts
    94

    Re: Woool2 SQL Server Files

    If any 1 using SQL Express 2008 read this please.

    SQL Server 2008 Express is now available as part of the November CTP - You can download it from the following link: http://www.microsoft.com/downloads/d...displaylang=en.

    For the November CTP we have only released the basic version of SQL Server 2008 Express. We'll be releasing SQL Server 2008 Express with Advanced Services and Management Studio Express in a future CTP. For now, if you want to use management studio to work with your SQL Express database, you should download SQL Developer edition, which is available from the same site listed above, and install the full version of Management Studio. This will work against SQL Express with no problems.

    This is the best one... including all programs for SQL, you can download it from the following link:
    Microsoft® SQL Server® 2008 R2 SP2 - Express Edition
    Last edited by OxxpqxxO; 13-01-2013 at 11:00 AM.

  12. #11
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    Thanks mate, added link to first post for window 7 users.

    Also i added server setup, which files you need to edit for your sql details.

    Still cannot find a direct link to SQL 2000, check the mir2-3 guides but links are broken.


  13. #12
    Loyal Member OxxpqxxO's Avatar
    Join Date
    Oct 2012
    Posts
    94

    Re: Woool2 SQL Server Files

    I found a link for SQL 2000 in the same site.

    http://www.microsoft.com/en-us/downl....aspx?id=18290

  14. #13
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    If anyone gets a error at login, check the following.

    LoginSrv.ini
    DataServerIndex=1

    Now check your account in SQL, find ServerIndex and see if they match, if they don't then you won't be able to login, i should of left it at 0 before releasing but i was testing it and forgot to change it back.
    I don't know what the purpose of 1-0 is but if i find out il post.

    Also i have just been sent 2.0 server files, i am thinking about starting with them as starting from a base and working out all the scripts is a little too much hassle atm, not tested these files yet but if they good i may begin work on them, also they will match the new sql database.


  15. #14
    LOMCN Rookie KingCheeseburga's Avatar
    Join Date
    May 2011
    Posts
    37

    Re: Woool2 SQL Server Files

    does this thread mean there could be a wool p server?



    wups i dint mean to post here
    Last edited by KingCheeseburga; 13-01-2013 at 08:15 PM.

  16. #15
    LOMCN VIP Sanity's Avatar
    Join Date
    Nov 2007
    Location
    Southport
    Posts
    3,694

    Re: Woool2 SQL Server Files

    Seems if any fields have NULL in Items database then the whole database breaks and nothing will work so run this query.

    Code:
    UPDATE Stditems SET GC=0 WHERE GC IS NULL;UPDATE Stditems SET GC2=0 WHERE GC2 IS NULL;
    UPDATE Stditems SET NeedRealm=0 WHERE NeedRealm IS NULL;
    UPDATE Stditems SET Special=0 WHERE Special IS NULL;
    UPDATE Stditems SET [Convert]=0 WHERE [Convert] IS NULL;
    UPDATE Stditems SET Reflect=0 WHERE Reflect IS NULL;
    UPDATE Stditems SET Jin=0 WHERE Jin IS NULL;
    UPDATE Stditems SET Mu=0 WHERE Mu IS NULL;
    UPDATE Stditems SET shui=0 WHERE shui IS NULL;
    UPDATE Stditems SET Huo=0 WHERE Huo IS NULL;
    UPDATE Stditems SET tu=0 WHERE tu IS NULL;
    UPDATE Stditems SET baohit=0 WHERE baohit IS NULL;
    UPDATE Stditems SET DerateMac=0 WHERE DerateMac IS NULL;
    UPDATE Stditems SET DerateAnti=0 WHERE DerateAnti IS NULL;
    UPDATE Stditems SET Derate=0 WHERE Derate IS NULL;
    UPDATE Stditems SET Spcode=0 WHERE Spcode IS NULL;
    UPDATE Stditems SET DerateAC=0 WHERE DerateAC IS NULL;
    UPDATE Stditems SET DerateAntiMagic=0 WHERE DerateAntiMagic IS NULL;
    All this dose is Change NULL to 0.

    If anyone knows how i can do this with Access could you let me know please.

    ---------- Post Merged on 19-01-2013 at 05:11 PM ---------- Previous Post was on 17-01-2013 at 06:40 PM ----------

    Changing to ACCESS as of today, SQL is breaking too much stuff and i cba dealing with it tbh, see bug list fixed every bug that i found.

    I have 1 problem though, the translated ACCESS database i done isn't working, the original one works fine but the edited one isn't, anyone have a idea how i might of broken it?

    Server files.
    Code:
    LoginSetting Scripts DoneMerchant Scripts Done
    Novice.txt Changed
    GameFeature Scripts Done
    
    
    MerChant.txt Finished. Cleaned. Fixed 2.0 Skins.
    
    
    Monsters.db Complete
    Items.db 60% Complete - [Anicounts bugged, need to fix]
    
    
    MapInfo Done
    
    
    All base NPC's Translated
    Veteran
    Jewelers
    Materials
    Grocery
    Warehouse
    Bookstore
    Pharmacists
    Pharmacy
    Clothing
    Blacksmith
    Butcher
    ShipOwner
    
    
    
    
    Deamon Skill Dan now activates at level 27 (Must Relog)
    
    
    Removed spammed global messages
    
    
    MonItem txt. file names Complete
    
    
    StartPoint.txt all set to PenIsland
    
    
    Mount Food Fixed. 
    
    
    Fixed PK NPC, should now remove PK Points
    
    
    RubyTemple Added - Red Soaring Heaven [Not Translated But tested and works]
    EmeraldTemple Added Blue Soaring Heaven [Not Translated But tested and works]
    
    
    ImmortalIsland Added - Capture mounts [Working] Upgrade Mounts [Working] (Remove Portal to HT)
    
    
    MapInfo - All commands added to maps.
    
    
    
    
    
    
    !Setup.txt Changed
    GMRunAll set back (Only names in Admin list will be GMs)
    EXP Removed, exp is now located in the classes database.
    TriggerDir - fixed path.
    
    
    
    
    PenIsland
    Blacksmith Complete. Quest dialog Complete.
    Bookstore Complete. Quest dialog Complete.
    Butcher Complete Quest dialog Complete.
    Clothing Complete Quest dialog Complete.
    Grocery Complete Quest dialog Complete.
    Jewelers Complete Quest dialog Complete.
    Materials Complete Quest dialog Complete.
    Pharmacists Complete Quest dialog Complete.
    Pharmacy Complete.
    ShipOwner Complete.
    Veteran Complete. (QUEST NOT FINISHED)
    Warehouse Complete Quest dialog Complete.
    
    
    
    
    
    
    BUG:
    Creating Hero [ACCESS Fixed]
    Skill deleting after relog [ACCESS Fixed]
    Cannot learn skills [ACCESS Fixed]
    Items have no function [ACCESS Fixed]
    Fast Buy disconnects you from game [ACCESS Fixed]
    Last edited by Sanity; 19-01-2013 at 07:00 PM.


Page 1 of 14 12311 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •