[Help] New Codex Source Release Bugs

[m70b1jr]

When i join in a Map, my fps is 130, then drops to 6 in seconds.
When spawning an item, i get kicked from the server

000036.765| CAsyncApiWorker 0 executing CJobUpdateChar[1000044] 062EC058
000036.885| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_Backpack_SRV_AddItem' expects parameter '@in_Durability', which was not supplied.
000036.885| !!!! UpdateCharThread failed, code: 5, ans: SQL Select Failed: Procedure or function 'WZ_Backpack_SRV_AddItem' expects parameter '@in_Durability', which was not supplied.

And then this

[MentaL]

[jacubb]

There are some missconfigurations between SQL procedures and API. For example:

Register API:

sqcmd.CommandText = "WZ_ACCOUNT_CREATE";
sqcmd.Parameters.AddWithValue("@in_IP", LastIP);
sqcmd.Parameters.AddWithValue("@in_EMail", web.Param("username")); // login name from updater
sqcmd.Parameters.AddWithValue("@in_Password", web.Param("password"));
sqcmd.Parameters.AddWithValue("@in_SerialKey", web.Param("serial"));
sqcmd.Parameters.AddWithValue("@in_SerialEmail", web.Param("email"));   // email used in serial key purchase

But in procedure WZ_ACCOUNT_CREATE is also 6th parameter - ReferralID.

Login API:

sqcmd.CommandText = "WZ_ACCOUNT_LOGIN";
sqcmd.Parameters.AddWithValue("@in_IP", LastIP);
sqcmd.Parameters.AddWithValue("@in_EMail", username);
sqcmd.Parameters.AddWithValue("@in_Password", password);
sqcmd.Parameters.AddWithValue("@in_HardwareID", computerid);
sqcmd.Parameters.AddWithValue("@in_Mac", mac);

Here are 5 params, but in procedure WZ_ACCOUNT_LOGIN are only 3 params - HWID and Mac are missing.



For now I found only this, because I am still downloading client... But I amsure there will be more problems like this.

[jacubb]

It will be nice from you guys if you will share fixes for DB and API.

[Noobly]

This isn't a fix but none the less enjoy

- Change backpack (Small backpack is bugged)


Edit:
For me sharing other stuff ill post it once its to my liking as i have the full database, and most the stuff is working but there still is minor bugs once i've fixed them ill post a full download in the release section.

[MrGrimm]

This isn't a fix but none the less enjoy

- Change backpack (Small backpack is bugged)


Edit:
For me sharing other stuff ill post it once its to my liking as i have the full database, and most the stuff is working but there still is minor bugs once i've fixed them ill post a full download in the release section.

That only seems to fix all the weapons showing up....you cant buy anything from market and add it to your inventory.

Looking foward to the fixes! :)

[Cryptopia]

I fixed the most now but what about the Global Inventory bug?
Does this have something todo with the api or something else?

[AlexRedd]

somebody solved the problem Global Inventory?

[GUARDIIANN]

Can you help me? WAS_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_ACCOUNT_LOGIN' expects parameter '@in_Mac', which was not supplied.

- - - Updated - - -

Can you help me? WAS_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_ACCOUNT_LOGIN' expects parameter '@in_Mac', which was not supplied.