Dshop SQL procedure?

07/23/2009 13:33 prox32#1
Ok i want to use the Dshop but it asks for a password and then gives an error because i need to make a procedure in the DB. I have some knowledge of SQL but i need a help in hand if anyone could help?
07/23/2009 16:18 gedimazs#2
Quote:
Originally Posted by prox32 View Post
Ok i want to use the Dshop but it asks for a password and then gives an error because i need to make a procedure in the DB. I have some knowledge of SQL but i need a help in hand if anyone could help?
What error? something like -300 blabla and so on?
07/23/2009 19:32 prox32#3
Quote:
Originally Posted by gedimazs View Post
What error? something like -300 blabla and so on?


yeh i get the -300 error in game, and i look at the dbmon and it says about a procedure.

P.S sry for the late answer
07/23/2009 20:30 caper#4
Did you get your DB files from silkbotter's stickied thread? You shouldn't have any problems unless you got a corrupted DB set or something.

Some of the various other DB downloads I've seen offered on the site seem to have a few problems in them but silkbotter's worked great for me and everyone else I know that used them.
07/23/2009 20:58 prox32#5
Quote:
Originally Posted by caper View Post
Did you get your DB files from silkbotter's stickied thread? You shouldn't have any problems unless you got a corrupted DB set or something.

Some of the various other DB downloads I've seen offered on the site seem to have a few problems in them but silkbotter's worked great for me and everyone else I know that used them.
silk botters and they arent corrupt as far as i know, it just wen you open the Dshop adn try to buy something it asks for a a password, then when you type the right password in it gives this -300 error :s. On dbmon it says about a procedure missing from the database...
07/25/2009 06:28 xOWNEDGEx#6
Hey i went into my server files then go to DekaronServer folder then open regist.csv and somewhere in there it will either say GAMEHI or ACCLAIM, just change it to the opposite, fixed all my dshop problems, hope it helps =)
07/25/2009 10:41 gedimazs#7
Simple to fix it. Go to you DB and change User_no for example to 6655447788 everywhere you can. It will be in acount DB these 2 tables tbl_user and USER_PROFILE. Then in cash.db table USER_CASH and finally Character.db table user_character. I know it looks hard but if you have one or two problems with that error so you can use my method. It helps me ;)