[Release]RaiderZ Updated Version - Client/Server/Src/DB

[Art Devil]

@Jose Lucas
Still have files with reference to MS SQL?
After tinkering on PostgreSQL files there was a lot of errors.

 

[danvalic]

damn, why i'm not a programmer?...
Need fix db connection and some bugs...
who can fix this todo list?):

8. Properly restore dead DB connection.10. Delete dbghelp.h workaround after MS fixes the bug.
22. Implement MC_NPC_MARK_POS and MC_NPC_UNMARK_POS. (Probably used in PvP area wartime to indicate where tower/chief are spawned?)
25. Anti-Cheat improvement: Disallow using talent skill with different weapons.
29. Implement new GM commands.
32. Refactor Debug command table/function.
40. Refactor/Organize enum DISPEL_TYPE and enum BUFF_DISPEL_TYPE
48. Implement new NPC_ICON_TYPE.
49. Implement MC_ITEM_USE_REQ ChangeName parameter.
51. Implement MC_ITEM_CHANGE_LOOK enchant grade parameter.
52. Implement MC_ITEM_ADD nRewardCause parameter.
53. Implement MC_ITEM_REMOVE_WITH_CAUSE.
54. Save "Item Delete Reason" into DB.
62. Implement all Physic/Magic modifier amps.
66. Implement MC_CHAR_REWARD_EXP and MC_CHAR_UPDATE_MONEY reward cause parameter.
67. Implement 2nd skill set system.
70. Fix buff icon bug on screen when hitting multiple enemies at a time.
72. Implement/Adjust MC_FIELD_SECTOR_PLAYER_INFO simple info and player info parameter.
73. Refactor Quest SQL function.
75. Erase old commented code from GDBManager.
76. Fix field login bug: sometimes redirects into Rietz from another field.
83. Pre-collect all mastery talents and use them when players train a talent. (for improve performance.)
84. Item DB access: return process result and sync with GameServer to prevent trouble or corrupt of data.
85. Implement MC_NPCSHOP_SHOW fRepairPriceMod parameter.
95. LServerStatusUpdater::OnUpdate() - RZ_SERVER_UPDATE() : pass correct performance info.
99. Fix incorrect critical rate calculation.
100. Fix too low Mace/Warhammer magic damage.
103. MasterServer - ZPartyLogic::ShowMatchingPublicPartyListReq() : Implement level filtering.
104. Implement new INTERACTION_TYPEs.
105. Implement DB info sync/verify system. (If something went wrong, disconnect the player.)
106. struct TD_ITEM_INSERT: Investigate unknown values.
108. Make mounts cannot be ride in dynamic field.
121. GID (Guild SN), QID (Quest SN) should be 64bit int for data type and Command Table.
122. Rename 'int64 nIUID' to 'IUID nIUID'.
123. AID, CID, IUID etc, are preferred to rename to ACCN_SN or ASN, CHAR_SN or CSN, ITEM_SN or ISN.
124. Refactor GPlayerTDCacheInfoBuilder::BuildEquipment().
125. Investigate FEATURE_ITEMSLOT_UNKNOWN1.
128. Sector NPC info sometimes doesn't send active NPC mode?
131. Refactor SQL function: enum to/from integer conversion. (e.g. Prepare pre-defined value mapper table and load from it.)
132. Delete item_sn parameter from item SQL functions, and return new item_sn from SQL function for validate item info.
133. Add CoolTime checker for inventory sorting.
134. Refactor Attribute Damage AP Modifier. (Merge each value into one array.)

i'm waiting :$:, but i'll try to do something, maybe i will can something to fix... I love Googlett:



@Jose Lucas seems you not without purpose changed the database on PostgreSqL



some screenshots:

 

[Jose Lucas]

The server is running, but you can't wear anything because base changed on posgresql:

You need add the items in Database to work fine

@Jose Lucas
Still have files with reference to MS SQL?
After tinkering on PostgreSQL files there was a lot of errors.

You have the source ^^ edit source to MSSQL

and disconect when i try to open Cash Shop and other services

Its in to do list :V , if some peoples work in this list , will be 100% very fast :V (And change again to mssql, or no ._.)

 

[danvalic]

But u've an old .dll and .exe which are based on mssql
maybe u share it?

I think that RZ community is dead and if someone else will be working on this files he doesn't share it



relocate the server to Ms SQL
PLEAAAAAAAAAAAASEEEEEEEEEEEEEEEEEEEEEE
WE WANT TO PLAY....:w00t:

 

[Danny Reich]

Where did you set server and IP adress? i must only set server ID 1, Servername Test and 127.0.0.1 in adress? (Or I must set her my rootserver IP?) Mist I do set anything else in db?

I have the following error.
DB can not link, I would like to ask you to help me!
thank you！

Still have this consoleerror, with 32 bit

Fixed. I forgot the ( and ) before and after Unicode in the inis

1. Still need a bit help on configure in database

2. I got virus detected on splash.exe..for what is this exe? Can I delete it?

 

[xjzragezone]

Does anyone have database of RaideaZ in mssql2000?

 

[a2003430453]

Where did you set server and IP adress? i must only set server ID 1, Servername Test and 127.0.0.1 in adress? (Or I must set her my rootserver IP?) Mist I do set anything else in db?





Still have this consoleerror, with 32 bit

Fixed. I forgot the ( and ) before and after Unicode in the inis

1. Still need a bit help on configure in database

2. I got virus detected on splash.exe..for what is this exe? Can I delete it?

Yes.
Whether Postsql 32 bit and psqlODBC 32 bit
Or 64 bit and ODBC 64 bit
I have used, but the result is the same.
I hope someone can help me correct me, or you can share its experience.
I am very grateful! !

 

[Danny Reich]

Show me ur server ini of one from the 4 or only the ODBC line

 

[danvalic]

Download PostgeSQL 9.5.x.x (x86)

You must be registered to see links

and install it.

Then in Stack Builder select psqlODBC driver (32 bit) and install it too.

In .ini u mustn't change ip and ODBC.
Change only password on ur.

then go to rz_accountdb_test -> rz_world
it should be like this:

Run servers.







but it is a biiiig butt for me, c++
who can relocate server to MSSQL?

 

[Danny Reich]

Thanks for settings in sql!

If you have still the console problem change the content of ODBC in each server ini to "PostgreSQL ODBC Driver(Unicode)" that worked by me

 

[danvalic]

It remains to fix the error or alter the server on MSSQL
All work 100%, only need fix DB and some bugs at services

 

[Danny Reich]

Hm I must check it later...

1. Accountcreation still only via Login and it create byself?

2. Hoe to change that all new created chars start at startpoint?

3. How I fill the database with items that I can wear them? Can I use a created database and use copy&paste? XD

4. GM console still like the versions before? And set a GM/Dev like versions before too?

 

[danvalic]

hm i must check it later...

1. Accountcreation still only via login and it create byself?

2. Hoe to change that all new created chars start at startpoint?

3. How i fill the database with items that i can wear them? Can i use a created database and use copy&paste? Xd

4. Gm console still like the versions before? And set a gm/dev like versions before too?

idite nafig

 

[Danny Reich]

Hm I don't become a server to select it after I logged in...when I start masterserver I become a big red content but he starts

And he don't create the account in the database


Edit: I´m glad when anyone can help me with it on skype...(cabalshenra)

 

[alembizim55]

How to change exp rates ? and start level gold etc. help pls

 

[Danny Reich]

I installed it now on my local pc and it works....idk why it don´t work on my root server....

 

[danvalic]

I installed it now on my local pc and it works....idk why it don´t work on my root server....

Can u recompile server to MSSQL DB?

 

[Danny Reich]

When I get the server running on the root I would try it and work on it and work on the todo list with a friend

 

[Art Devil]

I installed it now on my local pc and it works....idk why it don´t work on my root server....

U have skype? can u say ur skype?

 

[Danny Reich]

Yeah, write it a hour agi, cabalshenra^^

Still problems to run it on root, no world display

#GM commands don´t work



put firewall off..opened all incoming and outcomping ports which are in inis and checked all, I reinstalled my root but still the same problem, I don´t become a server select...need help on this pls
cmb ; Jose Lucas ; danvalic