Woool2 SQL Server Files

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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
2iu59va.png


Scroll down the list and download SQL Management Studio.
hv80p0.png


Installing SQL 2008 R2

npkq6r.png


Accept License Terms.

27y5moj.png


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=[COLOR=#ff0000][B]DAZZ-PC\SQLEXPRESS[/B][/COLOR]
DataBase=CHERODB
DataAccount=sa
DataPassWord=woool
SQLEXPRESS is default.
2e4vg9e.png


wl6qb.png


Select mixed mode and enter a password.
2lj3ret.png


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:

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
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/download/details.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:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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.
 

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
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:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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.
 

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
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:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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:

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
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:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Nvm it has it working.

Could you post what you downloaded to get it working please mate.
 
Last edited:

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
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/...60-f404-4d45-9ac0-d7f1b3ed1053&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:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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.
 

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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.
 

KingCheeseburga

Dedicated Member
Dedicated Member
May 25, 2011
37
0
32
does this thread mean there could be a wool p server?



wups i dint mean to post here
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
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:

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
Congratulation a lot of things are done, the next release will be great.
 
Last edited:

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
[video=youtube;bwWXstB8Hzo]http://www.youtube.com/watch?v=bwWXstB8Hzo&feature=youtu.be[/video]

TigerKing: Learning Skills done, removing skills done, Orb levelng done.
Rhino Mount: Fixed. 3rd Riding image bug. Pet interface bug.
HeavenSoaring: Angel + Hell Soaring Done. Dragon Soaring Not Done ( don't know how it works)
Hero Fusion: Bonecompound Done. Lights Done. 2nd Hero Done. Main Fusion not done. (Fusion has changed, i need to find out how it works.)

Oh once you get TigerKing to level 100, you can upgrade it to a Evil thing, but i never done it before but i have added all items to database, sure it works just like TigerKing though.
 
  • Like
Reactions: MythRohan

Sanity

Legend
Legendary
Nov 7, 2007
3,809
115
300
Updated server files link, will be my last release on the files, as am working on my own server.
 

OxxpqxxO

Dentity
Veteran
Oct 25, 2012
331
44
55
I want to tell you that you did a exelent job, thanks for your server files and I wish you success with your own server.

+respect