ROW fixed server and client files

[Arpakuutio]

This is release for Return of Warrior private server developement.
It still need some work but this release let you install and play ROW server easier.


Credits to:
------------------------
-MorbidA who fixed all server files, mssql database and unpacked ROW client.exe...and gave permission to release files here.
-Xavi2k4 who provided various client backup files.
-few others that was part of getting and releasing offical server files public.


This release contains:
------------------------
-ROW server files with fixed DBagent, Gameserver and DemonSetup.ini
-ROW fixed database (in MSSQL 2008 format)
-RYL2 V2240 Databases (in MSSQL 2005 format) that should work with ROW server also.
-9 different ROW client.exe versions
-7 different offical ROW scripts versions
-Full ROW client patch that works well with server files and has additional stuff made on them to try out.
-txt versions from client side scripts
-Unpacked ROW client.exe v1020
-ROW gm command list (originally released here by yoshi1337)
-ROW server setup and MSSQL 2008 database installation guides with pictures
-RylCoder with ROW 1020-> compatible keys

login.dat ip and all other ip settings are made to connect to 127.0.0.1 in default
version is set to 1022 in server and client and checksum is set to 0x00000001.
Copy DemonSetup.ini to your windows folder and you can edit setup with using SeverSetupDlg program in your row server folder.
ROW database has 5 game accounts ready.


known bugs:
------------------------
-upgrading works only with client.exe 1020 and below
-ride & transform works with client.exe 1022 and above


Download all from here:
------------------------

You must be registered to see links

additional downloads:
------------------------
MSSQL2005 express:

You must be registered to see links

MSSQL2008 express:

You must be registered to see links

Some helpful links for ROW developement:
---------------------------------------------------
http://forum.ragezone.com/f283/release-rylcoder-2-7-0-a-415208/
http://forum.ragezone.com/f283/row-1021-xor-keys-455016/
http://forum.ragezone.com/f283/return-of-warrior-row-1-0-3-1-server-files-and-tools-458905/


MSSQL 2005/2008 Server configuration manager settings(taken from my working server):

SQL Server network protocols -> Protocols for SQLEXPRESS:
-Shared memory = Enabled
-Named Pipes = Disabled
-TCP/IP = Enabled
-VIA = Disabled

TCP/IP properties (IP address tab):
Active YES
Enabled YES
IP Address 127.0.0.1
TCP port 1433

SQL native client configuration -> Client protocols:
-Shared memory = Enabled
-Named Pipes = Enabled
-TCP/IP = Enabled
-VIA = Disabled

 

[yoshi1337]

All that time tryin to figure out the demon T_T. Anyways nice release.

was figured out longggggggggggg time ago, no one shared it tho

guess I still wonder why now was picked to share it?
If your gonna share it then share it, if your gonna horde it then horde it. Why wait 2 months then share it

hopefully people have better luck with the unpacked clients then I did, they seem to still send really fucked auth data for me

Good work to everyone who was involved with making this all happen, was really a pretty big joint effort between a lot of people to get all this work done

Nice Refine rate on that DemonSetup.... I'd like to play on that server

/edit/
I have a bigger collection of official clients and client patches if anyone needs too, he posted a pretty good set which covers all the major versions so I doubt anyone would need mine

 

[Magnumutz]

Sweet release Arpakuutio.
Thanks !!

One question though...
HOW can we make upgrading, riding and transformation work on the same server?

 

[wck19842003]

wow! great release i holp that can be use then can host the ROW server
But the DB is SQL2008, the Db can use the SQL2000?

 

[Arpakuutio]

if you can find sql2000 databases for ryl2 224x then it shouldnt be problem...or try out 2008 instead.

 

[wck19842003]

i have support 2240 database for sql2000, i try that can use it in ROW server?

 

[Arpakuutio]

max gm level is 3 but i also used 5 first time since that is max in ryl1 atleast
admintool i havent tried myself so dunno about it..

client patch was used in my public row test server so i created there new mounts and transforms to mess around with them...they work with 1024 best but also works with 1022 client...but imo 1020 is best version to use with server files.

statue wars zone 16 was tested but it has bugs....sometimes only gave star but most of time not.
guild wars i didnt get work but i didnt spent much time for that anyway.

little bit work and you may get well working game.

 

[ChoijiLor]

Im useing 2240 that was released here not along time ago. Considering I don't feel like downloading 2005 / 2008. Also, once I get these DBs fully functioning on MSSQL 2000 I don't mind releaseing them. For some reason teleporting to Zone 12 (Almighty) and Zone 16 (Battle Grounds) seem to be bugged as well. Don't know if it's DB sided but i'll check it out and give the results.
AdminTool is new and I've translated most of the parts beside the new ones. I'll be working on that and I'll release it if anyone wants it as well.
Overall release is descent and nice +10 for Arpakuutio & morb and everyone else who was involed into this.

Edit:
Forgot to mention that I changed the "rylCoder_hack.cfg" to the ROW encryption keys and doesn't manage to work. But, Im going to keep messing around with this as well.

Edit2:
Ugh another one I forgot to mention. The table "tblcurrentuser" in "pay_gamemyth" seems to be bugged somehow in MSSQL 2000 w/ default 2240 dbs and doesn't seem to log when someone logs out.

 

[Arpakuutio]

we can add them in first post if you get something fixed....teleporting should work ok i didnt have problems with it but i only used those row fixed dbs to run server.
when i used unfixed offical db i couldnt tp to any zone at all.

 

[yoshi1337]

Sweet release Arpakuutio.
Thanks !!

One question though...
HOW can we make upgrading, riding and transformation work on the same server?

you can have one or the other

or both if you know how to do a lot of ASM editing/packet manipulation

it may not be just the upgrading that is broken fyi

 

[roosterkin123]

is the max level 60 on this? or any way to change it

 

[Tyfix]

max lvl is 60 and yes you can ofcourse change it. xp table works up till lvl 100.

 

[Gauss]

sorry to ask a question,i am using x32 system,can i use sql 2008 express x86 or x64?

 

[ChoijiLor]

Yeah you can. But, Im currently having problems with it. Saying "Keeper DB" (pay_gamemyth) isn't connecting meanwhile when I used 2000 it was all fine.

 

[Arpakuutio]

sorry to ask a question,i am using x32 system,can i use sql 2008 express x86 or x64?

x86 = 32bit
x64 = 64bit

And about those dbs...those 2008 backups were taken from live test server after it was tested to work during 2 weeks online period so they could work best but you need to use exactly same name in some of those dbs that you see backups named to...so its better to name all your dbs same name as backup names.
I think my teleporting problem in beginning was caused by wrong db names that didnt match to stored procedures.
Youxiuser i took from ryl2 db because it was easier to set account creation page for it.

I added SQL server configuration settings for 2005/2008 in main post if some ppl have problem to get it connect.

 

[Gauss]

i understand now thank you all.there is a common problem with my sql server,when server files connect to it,they give me this message:[DBNETLIB][ConnectionOpen (Invalid Instance()).]
it is believed that this problem is related the the name,but i don't know what name it is mean to

 

[Tyfix]

i understand now thank you all.there is a common problem with my sql server,when server files connect to it,they give me this message:[DBNETLIB][ConnectionOpen (Invalid Instance()).]
it is believed that this problem is related the the name,but i don't know what name it is mean to

You prolly have it setup to use direct sql connections but you're trying to use ODBC. Either change ryl to use ODBC & then put in ODBC info in setup or set it to use direct connections and then setup ip info in setup.

Also make sure you have TCP/IP connections allowed on your sql server. Oh yeah and you can get this sometimes if you're using ODBC but you're only calling the instance name and not the whole server name. like "ServerName\MSSQL_InstanceName"

 

[ChoijiLor]

There are tons of guides how to. Use the search function.

 

[berranteiro]

I have can make this server work, the services start to crash and this is wath say in log file.

Ty-ERR][Tm-2008-11-05 22:24:15][Ex-DB Connect failed : [163:0x80004005] [DBNETLIB][ConnectionOpen (Connect()).]SQL Server inexistente ou acesso negado. [M:IDBInitialize::Initialize]][Rt-CDBComponent::Connect][FN-.\Db\DBComponent.cpp][LN-53]
[Ty-ERR][Tm-2008-11-05 22:24:15][Ex-

 

[Tyfix]

wasn't specifically related to ODBC alone. You have a custom language windows so i can't read excactly what the error is saying, but it looks like no access or doesn't exist. Which means there is either no connection to the db or the account you are using is denied access. Check permissions on the account you are using to connect and check there is a connection to the db.. simple.

I really wish we could talk more about development and less about connecting to a database that are so basic and everyone should really know how to operate a mssql database..