[How to] Create item shop stored proceedures

[PanKJ]

It doesnt really concern me, but i accidentally found how to make the needed queries. I dont have time to work on it and test it atm but i can give you the knowledge to do it yourselves. So, open the field server using a debugger. Search for the string "billing". Youll most probably find the queries. Now, look for their references (first start with this '{call dbo.Billing_Get_Point(?)}'), and set break points. Start the servers and the client. Try to buy something from cs shop and the debbuger will most probably stop on a break point. Now try to find what arguments were passed (this '{call dbo.Billing_Get_Point(?)}' query has only one, the others have more). Identify what the arguments values mean and make a stored proceedure that uses the arguments. If you know something about debugging it should be that hard, just time consuming. Ill try to make it work when i have time anyway, but i stress the when.

offtopic: some mod make the "Question about ep3 config files" thread stickied and rename it (somehow i cant) to "MUST READ FOR EP3 SERVER" cause there 100 threads asking how to solve already solved problems per each thread thats about actual development.

[MentaL]

[Abry]

Thread moved to Tutorials section.

some mod make the "Question about ep3 config files" thread stickied and rename it (somehow i cant) to "MUST READ FOR EP3 SERVER" cause there 100 threads asking how to solve already solved problems per each thread thats about actual development.

Done. :)

[PanKJ]

Thx, i hope itll help newbies. Did anyone try to create the queries i mentioned above?

Anybody knows which culomn is supposed to store your creds? I suppose its something in td_Account (atm im experimenting using JuminNumber which is null anyway and idk what it is for). Any ideas?

[XxDeMoNxX]

Thx, i hope itll help newbies. Did anyone try to create the queries i mentioned above?

Anybody knows which culomn is supposed to store your creds? I suppose its something in td_Account (atm im experimenting using JuminNumber which is null anyway and idk what it is for). Any ideas?

You have to actually re-construct the billing. The way the files are delivered, is without working cash shop

[PanKJ]

Yeah i noticed that. I made another table and im trying to make it work. But i thought it tried to call these proceedures. Anyway, what makes it difficult is that hackshield doesnt let me use debugger lol. Ill install sandboxie and see what happens and whether the proceedures are actually called. If they are all i need to do is to make am fuctional.

[XxDeMoNxX]

Yeah i noticed that. I made another table and im trying to make it work. But i thought it tried to call these proceedures. Anyway, what makes it difficult is that hackshield doesnt let me use debugger lol. Ill install sandboxie and see what happens and whether the proceedures are actually called. If they are all i need to do is to make am fuctional.

You should disable hackshield so you can use a debugger,
Either way, you dont need to create anything extra for it to work.
All you need is there, atleast, the procedures, tables, and stuff. It's basically just modding work, Can be quite tricky and elusive i might add

[PanKJ]

Were you talking about disabling hs or abou adding cs? If it was about hs, yeah, thats the reason i prefered not to do it for now. CS obviously has mising stuff tho (we all know it lol).

[HrxLux]

The procedures are missing indeed. I rewrote them 4 months ago, and It's not that hard, just write the procedures which PankJ listed above.

[XxDeMoNxX]

Were you talking about disabling hs or abou adding cs? If it was about hs, yeah, thats the reason i prefered not to do it for now. CS obviously has mising stuff tho (we all know it lol).

Was responding to multiple posts, forgot to add the names -.-'' sorry. lol

[HexCoded]

Did it.

Thankyou for tutorial !

[PanKJ]

Grats. For what server? Ep3 or ep2?

[HawkEyeWPR]

with the X-Rivals pack what client i must use?

[PanKJ]

Dont post irrelevant post in wrong threads.

[mKeey]

Fixed for the EP 2 and EP 3.2 Server. I will upload all things later. Thanks PanKJ!

[WARonline]

this one too.