@GetRektBambi
Everythink works fine.
But there is one thing, when you try to change the character name
Everything is fine, just it, changing the characters name.Code:WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_BuyItem_GP' expects parameter '@in_Qty', which was not supplied.
Looked into this, make sure you have edited the api_CharSlots.aspx.csOriginally Posted by hawkingsamcro
(server\src\Scripts\WZBackend-ASP.NET\WZBackend-ASP.NET.sln)
Search for
Add Undersqcmd.Parameters.AddWithValue("@in_BuyDays", 2000);
This is where it buys the Rename item and @in_Qty is supplied. Make sure you publish the API and if necessary reboot IIS and Servers.sqcmd.Parameters.AddWithValue("@in_Qty", 1);
Yes, it worked now. Excuse the question, but who are you? You know a lot, put much of interest.
Glad its working ^.^
I am, Sean/TheGamingMonkey/Xuzia/SacrificeProductions (Ex DeadZ Dev)/GetRektBambi
o.o nice release if i knew how to work with flash id add that for loop for maps and use this also
Thank for share.
Last edited by LukasCCB; 11-07-16 at 12:04 PM.
please double check the stage 2 editing the api. It is only reason for error like this. Make sure api is published.
just a heads up if you have the "crate system" form here https://forum.ragezone.com/f790/rele...ar-cs-1087540/
it does break this buy in quanitiy stuff
also im getting a failed to buy item error. nothing at all in logs and ive gone through this tut about a dozen times or so to see if ive missed anything. using newest codex source
whats weird is that even tho im getting this error it is buying the items. tho the client it self needs to be restarted for the items to show and for the money to get deduced? something is wrong here cuz ive followed this release down to the T
Last edited by demonlord21; 19-12-15 at 11:36 AM.
Do you have the impliment crate system active? I have seen this working without any problems but again some codes will conflict depending on the source used. This release was created via codex source, however anything you have done may cause conflict.
I can take a look with you some time just grab me on Skype.
no i removed it because of the fact that i dont know sql that well so couldnt update the function for crate system to make it work lol.
it must have been something that ive done in my source then i have a feeling i know what it is gonna try.
edit
well i thought my issue was because with the "crate system" it has you completely replace one of the functions in source that you have to add stuff for this . so i reverted it back to default and that didnt fix my issue so im not sure what else it could be cuz they items buy money gets deducted but error failed to buy item pops up so you have to restart client for items to show in GL and money deduction to happen :/
and so far only things ive real done are what you helped me with. and building adding stuff for premium and legend and such dont see how those edits would affect this.
dont think this would be it cuz ive gone over it several times but could something in the frontend.swf cause this?
after spending the better part of today i believe ive narrowed it down to a flash issue cuz it "works" per say but does what ive alrdy said.
and i dont use skype dont rly care for it.
Last edited by demonlord21; 20-12-15 at 05:01 AM.
Thanks!
I have this error in buy premium.
r3dlog
Code:000037.662| WO_API: failed with error code 5 SQL Select Failed: Arithmetic overflow error converting expression to data type int. Arithmetic overflow error converting expression to data type int. Cannot insert the value NULL into column 'GamePoints', table 'WarZ.dbo.UsersData'; column does not allow nulls. UPDATE fails. Arithmetic overflow error converting expression to data type int. Arithmetic overflow error converting expression to data type int. The statement has been terminated. The statement has been terminated. 000037.662| BuyItem FAILED, code: 5
Premium gived, but the game points will not be charged
Re-up Requires Flash Source Files ??
THX.
Last edited by arnoza085; 06-02-16 at 10:58 AM.
You can pass me the Flash Source Files ??
HELP-ME !!
Ohh, man, thank you :)
99% here :(
CharRename error, how to fix?
Code:000049.623| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_BuyItem_GP' expects parameter '@in_Qty', which was not supplied. 000049.623| ApiCharRename failed: 5
http://forum.ragezone.com/f790/relea...9/#post8548369
Please in future read the thread for same problems. Solution is here
please help me i double check api and noting wrong000056.932| WO_API: failed with error code 5 no parameter Qty
000056.932| BuyItem FAILED, code: 5
Very Usefull bro thanks! yiep same error with the create system and change the character name
logs
as well a good idea for this is put the max amount less than 100 items each one because you can get more than 1,000 of any itemCode:001869.476| ApiLootBoxBuy FAILED, code: 5 001873.075| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_BuyItem_GD' expects parameter '@in_Qty', which was not supplied. 001873.075| ApiLootBoxBuy FAILED, code: 5
Last edited by Bombillo; 24-04-16 at 11:04 AM.
make it just bought 1 standard per item is easy, used in api.Very Usefull bro thanks! yiep same error with the create system and change the character name
logs
as well a good idea for this is put the max amount less than 100 items each one because you can get more than 1,000 of any itemCode:001869.476| ApiLootBoxBuy FAILED, code: 5 001873.075| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_BuyItem_GD' expects parameter '@in_Qty', which was not supplied. 001873.075| ApiLootBoxBuy FAILED, code: 5
Thanks for the tutorial bro but is anyway to active this function using the shift bottom or something else to avoid the amount error by some items?
ApiLootBoxBuy FAILED, code: 5
Thanky you, how to fix buy Case on store witch quantity?
Code:WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_BuyItem_GP' expects parameter '@in_Qty', which was not supplied. 000432.077| ApiLootBoxBuy FAILED, code: 5
I have the same Error and this error when i buy character
000032.961| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_BuyItem_GP' expects parameter '@in_Qty', which was not supplied.
000032.961| BuyItem FAILED, code: 5
I have an other Error...
- - - Updated - - -
Ok I fixed it... it was the problem with the FrontEnd.swf
BUY SLOTS not
Reply With Quote