Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 11:53

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

 

[Help] Db problem

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 22
[Help] Db problem

Hello Everyone , I m [ADM] of Shaiya Earth . Today someone setted to 4-5 ppl 27000 stat points . I have this server since 7 months and never happend this . User/Pass from Db is change + cripted in filles , this is configured 100% good but i don't know how this person can add 27000 stat points to more ppl . Anyone can help me ? I need some help please



Gamer # is offline  
Old   #2
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,697
Received Thanks: 5,196
Check logs to see if it wasn't a GM character setting stats from in game.


nubness is offline  
Old   #3
 
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 22
Nope, is not a GM account
Gamer # is offline  
Old   #4
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,697
Received Thanks: 5,196
How sure can you be ? Did you check your logs or not ? I doubt you did, so you should do it.

Also, in the SQL Server configuration manager, disable external connections, this way you can only connect from the localhost, which is the server itself. That's if you really believe someone got access to your SQL Server databases.

You should talk here instead of sending me PMs, this is the purpose of the forums.


nubness is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 22
still not solved
Gamer # is offline  
Old   #6
 
elite*gold: 0
Join Date: Jul 2013
Posts: 17
Received Thanks: 42
So if you as you say SQL injection excludes then it must be an GM

shows changing status Gm commands:
Code:
Use PS_GameLog
Select UserId, Charname, MapID, ActionTime, Actiontype, Text1, Text2 as TargetName, Text3 as Value
From ActionLog
where Actiontype = '180' and Text1 like '%SetStatus%'
Order By ActionTime desc
if there is nothing to find then maybe your root is hacked (change Root PW)
littleJon is offline  
Thanks
4 Users
Old   #7
 
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 22
Nope , Last change was 3 months ago with command in game

But Why he can change only Stat points , he can't ban/unban or other things only Set status
Gamer # is offline  
Old   #8
 
elite*gold: 0
Join Date: Oct 2012
Posts: 152
Received Thanks: 24
I think you should recheck your website or something that from web can access to PS_GameData. Or use SQL Profiler to track it. I assume that you have SQL injection that I have experienced before
nick4ever is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 22
Can u help me with this ? my skype : admin_crank
Gamer # is offline  
Old   #10
 
elite*gold: 0
Join Date: Oct 2012
Posts: 152
Received Thanks: 24
@Gamer # : Try this
1. Reset stat point for all players in your server.
2. Shutdown your web or your pages that connect to PS_GameData directly
(Wait for days to assure that the problem comes from your web)

If your web is the cause, you need to move your query to store procedure of use SQL Profiler to track infects

Hope this helps
nick4ever is offline  
Thanks
1 User
Old   #11
 
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 22
Now i see no more stat points added , i removed panel from host but now is hard to work without panel
Gamer # is offline  
Old   #12
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,697
Received Thanks: 5,196
It's hard because you don't know SQL, but you can stay like that for a while, maybe a better admin panel will be released soon.
nubness is offline  
Old   #13
 
elite*gold: 0
Join Date: Oct 2012
Posts: 152
Received Thanks: 24
I have never use admin page, I wrote myself an Java socket application on desktop and android mobile. So I dont really need Admin panel. Try to work around with SQL
nick4ever is offline  
Old   #14




 
elite*gold: 40
Join Date: Dec 2010
Posts: 31,647
Received Thanks: 5,014
#closed


Autrux is offline  
Closed Thread



« Previous Thread | Next Thread »

Similar Threads
[Problem]Habe ein Problem und zwar spinnt mein VPC etwas(ohne Grund)?!
Also wie schon gesagt meins Server spinnt wodurch kiks usw. kommen :( ich lade euch die Screens in den Anhang, mit der Hoffnung, dass ihr mir helfen...
10 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +2. The time now is 11:53.


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.