Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 23:06

  • Please register to post and access all features, it's quick, easy and FREE!


Wrong password buying from Dshop

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
Question Wrong password buying from Dshop

I have a random issue. Some players get a Wrong Password error when buying from Dshop. It's not all players, it's random. It's also on any item in Dshop not just 1 in particular. I created 3 characters and all of them were fine to buy from Dshop. I've deleted the user_use_log from the cash database and restarted the server. All user_no are unique in the user_cash. Still, sometimes someone creates a character and they can't buy anything from Dshop. If anyone has any ideas let me know thanks.



freez00 is offline  
Old 11/20/2015, 04:04   #2
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
I hope someone can point me in the right direction. All of a sudden when you create a new character, that character can't buy anything from Dshop. Incorrrect password always comes up now. Existing characters can buy from Dshop.

I created a new character and couldn't buy from Dshop. I logged in my other character with the same client and could buy from Dshop. I checked the database and the user_no is unique in the cash, character and account databases.


freez00 is offline  
Old 11/20/2015, 08:14   #3
 
elite*gold: 22
Join Date: Sep 2015
Posts: 952
Received Thanks: 83
I think its a mistake at databases , since region dont match and anyway when you field an correct or random password , the database cant choose.
Proxynear is offline  
Old 11/20/2015, 19:16   #4
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
I'm not sure what you mean about the region? That's set in the server ini file. I'm trying to see where the error is in the database but when I compare the new char to old ones the flags are the same.


freez00 is offline  
Old 11/20/2015, 19:28   #5
 
elite*gold: 0
Join Date: Nov 2011
Posts: 562
Received Thanks: 309
I think your best bet is to restore the database with a working one
Ultimo ☼ is offline  
Old 11/20/2015, 19:46   #6
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
I've been running this server for some time now. This is a new issue that has come up. If I restore from backup, Players will lose accounts etc.
freez00 is offline  
Old 11/20/2015, 19:49   #7
 
elite*gold: 0
Join Date: Jan 2012
Posts: 2,258
Received Thanks: 928
I might be wrong but dshop transactions are done directly on the database so perhaps you should run profiler and see what gets executed
guesswho-.- is offline  
Old 11/20/2015, 20:31   #8
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
After running the profile on my old character, it runs properly:
set @p18=0xE51A135A05000101960018C6CC66447E
declare @p19 int
set @p19=1150666 <-- item index
declare @p20 int
set @p20=2592000 <-- Use period

On the new character it doesn't pick up the item index or use period:
set @p18=0x00000000000000000000000000000000 <-- declared as 0 binary
declare @p19 int
set @p19=0 <-- item index
declare @p20 int
set @p20=0 <-- use period

This all happens before running the BL_IF_BuyProc_CRU stored procedure.
The profiler doesn't tell me what stored procedure is declaring the p19 and p20 variables. If anyone knows then I can track it down.
freez00 is offline  
Old 11/21/2015, 00:12   #9
 
elite*gold: 22
Join Date: Sep 2015
Posts: 952
Received Thanks: 83
I think its some querry not parsering since before it gives you an generated code and variables got value , after that you try to get something and you get nulled p18 and the rest too
Proxynear is offline  
Old 11/21/2015, 00:30   #10
 
elite*gold: 0
Join Date: Jan 2012
Posts: 2,258
Received Thanks: 928
check @sp_rtn then track it to the place where it sets the value. @sp_rtn should be the first returned value I think.
guesswho-.- is offline  
Old 11/21/2015, 02:44   #11
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
Well, to add even more weirdness to this... If I create a character manually by adding the values to the account.user_profile and cash.user_cash tables I can create a character and buy from Dshop fine. It seems it's only when creating it from the website which the code hasn't changed! By the way, I do appreciate the help. This is certainly a strange error. I'll try rebooting the web server and see if it helps. Maybe the query is cached somehow.
freez00 is offline  
Old 11/22/2015, 18:35   #12
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 136
Seems that a client hack from someone messed up the stored procedure when buying from Dshop. Since we removed the exploit and restarted the server all is fine. This wasn't an error with the database nor the serer files.


freez00 is offline  
Reply



« Thinking About Open A Server . | #help , vote script »

Similar Threads
NEED HELP! Wrong Password(746)?????????
08/11/2012 - Need for Speed World - 2 Replies
When i log in it says Wrong Password 746, what does that mean?
Wrong ID or password Q.Q
06/04/2012 - S4 League - 5 Replies
Hey! I was playing s4 normally since yesterday and now i dunno what the happend whenever i make new Acc it is Wrong id or pw 6 acc's theey all work on the site but ot in game Q.Q Q.Q what should i do now supoort aint wokig right now Q.Q plz...
Buying 20 Offline PSC WITHOUT A Password
05/20/2011 - elite*gold Trading - 6 Replies
I need 20 Without PW PSC ASAP PM ME
wrong password ? =.=
08/06/2008 - Dekaron Private Server - 10 Replies
im getting "wrong password" all the time on the 20x,100x chinese server... is anyone getting the same thing as me ? (no,noone has my account,and i only play alone at home)
Wrong id or password WTF
04/28/2007 - SRO Main - Discussions / Questions - 2 Replies
Guys, today i reinstaleld my silkroad and pur again the easter sm on my silk files and tried to run trial.. when i look for the keys it dosnt finds noone and when i try to open silkroad i get an error that says "wrong id or password" wtf is up with...



All times are GMT +2. The time now is 23:06.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.