There is a backdoor in this DB, a trigger in ChatLog delete that. It enable any1 to become GM and also allows remote access to server.
This is a discussion on [Release]EP 7 Chinese (EP 5 Compatible) Private Server Files within the Shaiya Releases forums, part of the Shaiya category; Originally Posted by Twilight find PSM_Server\ps_passwordEnc.exe run and generate new hash for sa copy hash key and replace in PSM_Client\Bin\Config\ps_game.ini ...
There is a backdoor in this DB, a trigger in ChatLog delete that. It enable any1 to become GM and also allows remote access to server.
A little help here? I click that damn start button and NO error, NO message... NOTHING starts, NOTHING happens.
Can i ask wth is causing that? :)
EDIT: Nwm, fixed it. For now :)
EDIT-2: Everything starts and after 5 sec everything get's that green pause button next to them, is it normal?
Last edited by danger-bk; 18-03-11 at 01:47 PM.
Old CABAL TFN - Moderator (also GA)
btw these files have a chat trigger in them so becareful
How to delete that? I searched through the DB and couldn't find it.
EDIT: I removed the trigger, my other problem persists tho.
Can anyone help me with my error? Pl0x X__x
EDIT: My log.
andCode:2011-03-18 15:24:00 PSMSERVER_AGENT__system log start (PS_AGENT) 2011-03-18 15:48:42 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 15:48:42 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 15:48:42 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main 2011-03-18 15:59:12 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 15:59:12 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 15:59:12 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main 2011-03-18 16:03:38 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:03:39 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:03:39 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main 2011-03-18 16:03:46 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:03:46 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:03:46 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main 2011-03-18 16:04:05 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:04:05 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:04:05 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main 2011-03-18 16:07:15 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:07:15 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Common 2011-03-18 16:07:15 127.0.0.1 FILE_ERROR_FILELIST ServerAgent\Main 2011-03-18 16:09:43 3 1 SERVICE_CONTROL_STOP 2011-03-18 16:09:43 PSMSERVER_AGENT__system log end (PS_AGENT) 2011-03-18 16:09:43 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Code:2011-03-18 18:45:07 PSM_AGENT__system log start (PS_AGENT) 2011-03-18 18:45:17 Update start 127.0.0.1:40901... 2011-03-18 18:45:21 download error file list 2011-03-18 18:45:21 download error file list 2011-03-18 18:45:22 download error file list 2011-03-18 18:45:22 Update complete...
EDIT: Everything starts fine now, besides the GameGroup (nothing from there).
Last edited by danger-bk; 18-03-11 at 06:24 PM. Reason: Read edit.
Old CABAL TFN - Moderator (also GA)
sql 2000? can i use it?
Yes you can, i'm also using SQL 2000.
Might try with 2005 later, maybe that's why the gamegroup can't connect to SQL :/
Old CABAL TFN - Moderator (also GA)
but this files are crap^^
They aren't crap... the problem 99% of the users have is VERY EASY to fix.
Go cry somewhere else, please, the files ain't crap.
Old CABAL TFN - Moderator (also GA)
ok to remove the chat trigger go to ur chat click the + symbol and go down to ur trigger then open up that then go delete
You want say this files EP7 ?
This its only EP 4.5 you must many FIX
The EXpDefs, StatusDef, Skills, Monster, Items not all includet.
^^ All this files here are Dreams and not full EP7
i know now 3 Server with full files and new Dungeon and 1 Server its from me with the new mobs, new Items 70+ Gear and Weapons but not realy with this files ^^
error
Msg 15025, Level 16, State 1, Line 1
The server principal 'sa' already exists.
Msg 8144, Level 16, State 2, Procedure sp_addsrvrolemember, Line 0
Procedure or function sp_addsrvrolemember has too many arguments specified.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'game' already exists.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'PS_NCASH' already exists.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'PS_USERDB' already exists.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'PS_USERDB01' already exists.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'PS_DEFINEDB' already exists.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'PS_GAMEDB01' already exists.
(1 row(s) affected)
(1 row(s) affected)
Last edited by akademik; 24-04-11 at 08:28 PM.
Im running into an error with the "SQL New Installation" File, when I execute it i get the error message:
"Msg 4701, Level 16, State 1, Line 9
Cannot find the object "GameAccountTBL" because it does not exist or you do not have permissions."
As far as i can tell from spanning the tree it doesn't exist... any idea where it could be?
thank you.
Code in SQL New Installation.SQL
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
where? OMG_GameWEB
I'm not see at all,
Every DB have Prefix Like PS_
It's Make Error When Run Query
OMG_GameWeb was on older table used for web based websites. Most people removed it, and patched the login over it. It's useless.