Ok, this topic may be old, but here's new update info on where to download MSSQL 2000 for those who have CDWriters v3.62/v3.81 Originals.
<a href='
http://download.microsoft.com/download/ ... QLEVAL.exe' target='_blank'>Microsoft SQL Server 2000</a>
<a href='
http://www.xandiumstudios.net/SQLCrack.rar' target='_blank'>MSSQL 2000 Crack</a>
Setup... By CDWriter and
www.mysticalhb.com
1. unzip this to your c drive or any drive u like, Lets get started by seting up your CFG files and what u need to change ...Open up these files 1 at a time and change the IP address...I should have the Ports set all ready but if not change them to what u want.
GateServer.cfg
GMIpList.cfg
HMLserver.cfg
ISPIPlist.cfg
WLserver.cfg
/HGServers/GServer.cfg
2. Next we need to setup MSsql db witch i have included here with the reg crack..first run SQLEVAL.exe and place the files in a directory somewhere does not matter where or witch Drive.. after this goto where u extraced the files and hit the autorun.exe and install MSsql DB to your c:\program files\.....Make sure when installing u use MIXED Mode. Add a password and make sure u write that down. then open SQL Crack.zip and copy the crack file to where u installed MSsql DB , mine is C:\Program Files\Microsoft SQL Server\MSSQL\Binn place the crack here and Crack the MSsql DB.
3. Now after this lets setup the MSsql DB from the Orginal files taken from Siementech HB Modifiyed by CDWriter and iluvatar. Open the file called CDWritersWS1Works3.sql with notepad. This should be in the SQLsetupFiles Directory and change the path to where your MSsql DB Data files should be if u installed it to the Normal path C:\Program Files\ then the first and second path should be correct all ready, If u have not then correct the path to where you stalled MSsql. Start again with line 3 but this time open the file called CDWritersMainLoginWorks3.sql and change the paths.
4. After all above is done lets open the MSsql Enterprise Manager, This is assuming u started the Mssql from control panel/Administrative tools/Services. If not go there now and open up services looking for Mssql and start it .. Now goto Tools / SQL Query Analyzer above when the Windows opens make sure master is set - top middle of the window -, Now click on the Open folder and browse to your 351HB directory inside the folder called SQLsetupFiles click on CDWritersWS1WorksX.sql when it opens click the Blue check mark or (Ctrl+F5) u should get a (The command(s) completed successfully.) in the results list. Now click Run green arrow next to the Blue check mark or press f5 it should finish completed. after this hit the save command and open the next file called CDWritersMainLoginWorksX.sql and do the exact same thing. MSSQL Bases COMPLETE.
5. Next we need to set up your Data Sources (ODBC) goto your control panel/Administrative tools/Data Sources (ODBC) when this open goto the tab System DSN hit add select SQL server then enter account for the Name and change the pull down for Server to local, click next. now on the next page u want to make sure that u have checked "with SQL Server authentication using a login ID and password entered by user" soon as this is checked u need to add your Login ID : sa and your password when u installed MSSQL in Mixed mode. after that it should check your l/p connection with mssql automaticly when u hit Next. Now on Next window u need to make sure that u have the check mark on "Change the defualt database to" and use the pull down to select mainlogin, hit next . on the next page leave everything else alone but make sure u check the "Log ODBC driver statistics to Log file" hit Finish. Now Test then OK.
6. On the tab System DSN again hit add select SQL server then enter character for the Name and change the pull down for Server to local, click next. now on the next page u want to make sure that u have checked "with SQL Server authentication using a login ID and password entered by user" soon as this is checked u need to add your Login ID : sa and your password when u installed MSSQL in Mixed mode. after that it should check your l/p connection with mssql automaticly when u hit Next. Now on Next window u need to make sure that u have the check mark on "Change the defualt database to" and use the pull down to select ws1, hit next . on the next page leave everything else alone but make sure u check the "Log ODBC driver statistics to Log file" hit Finish. Now Test then OK. Your DONE with your DB setup and ODBC connections ...
7. Now for the fun part u need to hex edit the MainLServer.exe and WorldLServer-3.51.exe. Lets start with the first one use any hex editor and search for the word ACCOUNT_T and below that u will find a line like this.
DSN=account;User ID=sa;pwd=XXXXXXXXX;Provider=MSDASQL.1 use your hex editor and add in your NEW MSSQL sa password, save your done. now for WorldLServer-3.51.exe its the same above but this time u will see a line like this.
Data Source=character;User ID=sa;pwd=XXXXXXXX;Provider=MSDASQL.1; use your hex editor and add in your NEW MSSQL sa password.. Your Finished
8. Makeing a new connection ...
9 Ok lets get started on the New connection first u need to make a account in your new Sql Dbases u have made open up SQL Server Enterprise Manager and then click on Mircosoft Sql Servers / SQL Server Group / (Local)(Windows NT) / Databases ..Once u have this open click on mainlogin then Tables, soon as u click on table it will open up the window to the right and show u all the tables now left click on the ACCOUNT_T then right click it goto OPEN Tables / return all rows.. a window will open and this is where u need to add in your account info which ill give example below - the password..
Account[cAccountID] XXXXX[cPasswd] 1001[iAccountID] <NULL>[cLoginIpAddress] <NULL>[IsGMAccount] <NULL>[CreatDate] <NULL>[LoginDate] <NULL>[LogoutDate] <NULL>[BlockDate] CDWriter[cRealName] <NULL>[SSN]
me@home.com[cEmail] <NULL>[cCharRecord] <NULL>[cQuiz] <NULL>[cAnswer] <SetDateValidatesAccount>[ValidDate] <SetTimeValidatesAccountByTime>[iValidTime] 2000[MaxUser] <NULL>[ShopID]
I also got it to connect with just cAccountID(Name) , cPasswd(XXXXX), iAccountID(Sql Auto starts with 1001-UP just skip this.) and u need <ValidDate>12/2/3254 Or <iValidTime>1-10000 eather one but u must have 1 of them set, dont forget to add in your MaxUsers..... There is no such thing as a GM account so make sure u change the IsGMAccount and all other accounts u create will be 0 always. Siementech HB changed to this when they made it all SQL so they could give 1 GM char to others with out haveing them make new GM charactors.. now close this and log on to the Server with your 3.51 client ...As soon as u get to your charactor menu create a Charactor like you would normaly, log on and walk around for a few secs, then log off ....Your done and u can make new chars to play ... But hey wait what about a GM account ok lets do this again after u have logged out go back to your SQL Manager now this time open the dbases called ws1 then click on tables right click on CHARACTOR_T table then goto OPEN Tables / return all rows.. a window will open and this is where u will see your new charactor u made and walked around, move it over till u see sAdminLevel change this to a 5 <-- Full GM access a sAdminLevel of 1 will give them access to TP and watch others but this is all ... got GM commands u need to open the HGserver in a hex editor and search for the word "PC CHAT". u will find something like this ..
If u change anything in the hex editor make sure u have a back up so if u make a mistake u still have Orginals...
PC Chat(%s):"%s" to GM(%s) ¿ù ¿ì ¿ö /beginheldenianfight /endheldenian /beginheldenian /endapocalypse /beginapocalypse /getticket /setobservermode (!) GAME SERVER SHUTDOWN PROCESS BEGIN(by Admin-Command)!!! /shutdownthisserverrightnow /deleteparty /getpartyinfo /dismissparty /joinparty /createparty GM Order(%s): endcrusadetotalwar /endcrusadetotalwar GM Order(%s): begincrusadetotalwar /begincrusadetotalwar GM Order(%s): energysphere /energysphere /MonsterCount /enableadmincommand 4415 /enableadmincreateitem 4415 /createitem /disconnectall /summon /setforcerecalltime /setattackmode /gns /setinvi /polymorph /checkip /unsummonboss /unsummonall /summonplayer /summondemon /goto /tp /teleport /createfish /attack /dissmiss /reservefightzone /°Åð /ban /closeconn /ÀÚÀ¯ /free /°ø°Ý /tgt /¸ØÃã /hold /³ª»ÛÆò°¡ /rep- /ÁÁÀºÆò°¡ /rep+ /shutup /ÇÁ·ÎÇʺ¸±â /pf /ÇÁ·ÎÇʼ³Á¤ /setpf /±Ó¼Ó¸» /to /Á¢¼ÓÈ®ÀÎ /fi /who GM Chat
These are your GM commands if u notice in your hex editor some of them have a single space after the command and here is a run down on a few of them ...
/tp <map>
Teleports you to your desired maps default recall position. (map list below). EG: /tp default
/tp <map> ### ###
Teleports you to your desired map specific location (map list below). EG: /tp default 40 100
/fi <player>
Give you the coords of a player who is logged ingame, and the map they are on. EG: /fi GM9
/summonplayer <player>
Summons a player to your location. This command is not to be used often at all! Never summon anyone to a place they can run to themselves. Never summon someone to any of the new maps, or close to the icebound teleport! Mostly used to summon people back to an arena if they dc before the match starts (So you dont have to give them another ticket.) If they dc after the round starts, never tp them back to an arena match!
/shutup <name> <time in minute>
Even though it will show on the screen as being seconds, it's actually minutes.
Mutes the player for the amount of time. Never mute for longer than 60.EG: /shutup GM13 5
/shutup <player> 0
To remove a mute
/shutup <player> <#>
Also disables a persons admin powers. If a person is using tp hack /shutup will disable their commands. It will also disable a GM from being able to use other commands should one be 'hacked'.
/setinvi 0
Allows you to be viewed / visible.
/setinvi 1
Allows you to be invis / invisiable with out casting the spell.
/who
Shows how many people are online at that particular moment
/setobservermode
Allows you to move around the screen (at the moment only UP and LEFT) with out being hindered by players, or hindering them in any way. Move the cursor to the edge of the screen in order to move your screen.
This is a fast way to log out. Along with being able to view people with out them viewing you if they are using invis hack.
/attack <player>
This will summon 1 guard on the player.
/goto <player>
This will tp (Teleport) you directly to the right of the player.
/closeconn <player>
This sends a player to Bleeding Island for approx 5 mins. It also often disconnects the person as they connect through to the Bleeding Island server.
For the following <SPACE> means that the space bar button will need to be pressed in order for the command to work.
/reservefightzone #_<SPACE>
This is a GM's command for reserving an arena, it's like a guild master reserving it with out having to buy the tickets.
You should get verification of this at the bottom of the screen.
/reservefightzone #_<SPACE>
This command also unreserves an arena that has been reserved.
You should get verification of this at the bottom of the screen.
/setattackmode 0
Puts the map in to a safe zone. No one can do damage, or cast a spell.
You should get verification of this at the bottom of the screen.
/setattackmode 1
Puts the map in to an attack zone. Damage can be delt, and spells can be cast.
You should get verification of this at the bottom of the screen.
/getticket fightzone#
This will give you 3 tickets for the arena your in. Make sure that your standing in the arena that you wish to have tickets for.
Starting Heldenian and crusade and apoc
code
/beginheldenian 10(time) 1(BtField) 2(HRampart)
/beginheldenianfight ?
/begincrusadetotalwar
/endcursadetotalwar
/tp ... command / map
default Beginner Zone
elvine Elvine
aresden Aresden
middleland Middle Land
elvuni Elvine Garden
areuni Aresden Garden
huntzone1 Rocky Highland
huntzone2 Eternal Field
huntzone3 Death Valley
huntzone4 Silent
elvfarm Elvine farm
arefarm Aresden farm
elvined1 Elvine Dungeon
aresdend1 Aresden Dungeon
bisle Bleeding Isle
resurr1 Resurrection Zone
resurr2 Resurrection Zone
toh1 Tower of Hell level 1
toh2 Tower of Hell level 2
toh3 Tower of Hell level 3
middled1x Middle Mine Land
middled1n Beginner Dungeon
2ndmiddle Land of Promise
dglv2 Dungeon level 2
dglv3 Dungeon level 3
dglv4 Dungeon level 4
icebound Ice Bound
Druncncity Druncian City
inferniaA Infernia A
inferniaB Infernia B
procella Procella
maze Maze
abaddon Abaddon
GodH Seige Map 1
HRampart Seige Map 2
BtField battle field
wrhus_1 wwh
arewrhus ewh
wrhus_1f fwh ares
wrhus_2 nwh
elvwrhus swh
wrhus_2f fwh elv
bsmith_1 bs aresden
bsmith_1f bs ares farm
bsmith_2 bs elvine
bsmith_2f bs elvine farm
gshop_1 shop ares
gshop_1f shop ares farm
gshop_2 shop elv
gshop_2f shop elv farm
wzdtwr_1 wizard tower ares
wzdtwr_2 wizard tower elv
Cmd_Hall_1 Command Hall ares
Cmd_Hall_2 Command Hall elv
cityhall_1 City Hall ares
cityhall_2 City Hall elv
cath_1 Church ares
cath_2 Church elv
/tp <map>
Teleports you to your desired maps default recall position. (map list below). EG: /tp default
/tp <map> ### ###
Teleports you to your desired map specific location (map list below). EG: /tp default 40 100
Your Done!!!!
thanks to GoldenBoy,iluvatar for his help and hours of testing for me and helping with the SQL stuff...
CDWriter
anyone with some brains can get that shit from anywhere..Also i doubt you can use updates which XP needs sp3 or higher to run properly too if you use the crack..just letting ya'll no 
.As for setting up..it not that bad..If ya want a server without Angels then this is pretty stable for sure.maybe even bullet proof..lol :ph34r: 
