[Release]Shaiya EP9 CN Server Files ^_^

**MeGaMaX** · 07-04-13

Why this section is dead lol come on guys, I'm not Shaiya developer or even player, i'm pentester so i found that EP9.0 files in my hdd and would like to share them with you, if the server files wrong version don't flame i just tried to help, good luck

Server:

PSM_Server.rar
PSM_Client.rar

Client exe:

Client-exe.rar

DBS:

DBS.rar

Client Patch:

Shaiya-Patch.rar

Client:

http://ct1.download.shaiya.cdcgames....a9.0_setup.exe

Master-dlls:

master-dlls.rar

Greetings: MeGaMaX

**MentaL**

**10dakongyi** · 10-04-13

thanks sir

**Omegalll** · 11-04-13

thanks good aport

**Tiffany Tiffy** · 14-04-13

Originally Posted by androw3349

Why this section is dead lol come on guys, I'm not Shaiya developer or even player, i'm pentester so i found that EP9.0 files in my hdd and would like to share them with you, if the server files wrong version don't flame i just tried to help, good luck

Server:

PSM_Server.rar
PSM_Client.rar

Client exe:

Client-exe.rar

DBS:

DBS.rar

Client Patch:

Shaiya-Patch.rar

Client:

http://ct1.download.shaiya.cdcgames....a9.0_setup.exe

Master-dlls:

master-dlls.rar

Greetings: MeGaMaX

Hello :3 i Keep Getting this error when logining into the game

Please Try to reconnect to the server Error 0

any help would be great..

**siban** · 30-04-13

androw3349
Pm me please i want ask you somthing privat
send me message

**azex89** · 09-05-13

Hi mate! How fix a itemmall points? In this server it show as 0 in each account.

**congmanh333** · 28-09-13

Thanks a lot of

**Rowel Rebulado** · 22-10-13

@MeGaMaX Pls send a guide on how to make a ep9 private server using that files pls... thank you..

**r0ck7y** · 26-10-13

everything is good but the Game.exe is not for EP9 tried too many times still the same error :)
edit: okay i fixed everything worked like a charm the error is in the PS_GameData.dbo.usp_Read_Char_Product_Item_E
tyvm again!!! ^^

LAST EDIT: there is some bugs in the Database so u should fix them up.
1st one is dc after the server selection how to fix use execute this Query on your DB

PHP Code:


/* Add linked servers */  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game') BEGIN     EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='game', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB') BEGIN     EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH') BEGIN     EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB') BEGIN     EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01') BEGIN     EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01') BEGIN     EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';

credits goes to ShaiyaOmega

the other one is Name is already in use how to fix execute this Query on your DB

PHP Code:


USE [PS_GameData] GO drop procedure [dbo].[usp_Save_Char_Item_Add_E] GO  SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO   /****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/   CREATE Proc usp_Save_Char_Item_Add_E  @CharID int, @ItemUID bigint, @Bag tinyint, @Slot tinyint, @ItemID int, @Type tinyint, @TypeID tinyint, @Quality int, @Gem1 tinyint, @Gem2 tinyint, @Gem3 tinyint, @Gem4 tinyint, @Gem5 tinyint, @Gem6 tinyint, @Craftname varchar(20) = '', @Count tinyint, @MaketimeZ varchar(50), @Maketype char(1)  AS DECLARE @Maketime as datetime SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120) --SET NOCOUNT ON  IF(@Quality >= 5000) BEGIN SET @Quality=0 END  INSERT INTO CharItems (CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4, gem5, gem6, craftname, [count], maketime, maketype) VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4, @Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)  IF(@@ERROR = 0) BEGIN RETURN 1 END ELSE BEGIN RETURN -1 END  --SET NOCOUNT OFF    GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

credits goes to JohnHeatz

**MeGaMaX** · 29-10-13

Good to see there is still some members helping in this section :)

**sominus** · 04-11-13

Tested with a clean old EP5.4 USA Client, and works fine,
HP displays fine.
Skills past level 3 works fine.

Just two bad things:

1)A bug on Item Mall, it shows 0 AP for every account, and wont let you buy even 0AP items.
2)The ps_game.exe file is packed with Molebox (so we can't edit it)

**juniordark** · 06-11-13

Originally Posted by r0ck7y

everything is good but the Game.exe is not for EP9 tried too many times still the same error :)
edit: okay i fixed everything worked like a charm the error is in the PS_GameData.dbo.usp_Read_Char_Product_Item_E
tyvm again!!! ^^

LAST EDIT: there is some bugs in the Database so u should fix them up.
1st one is dc after the server selection how to fix use execute this Query on your DB

PHP Code:


/* Add linked servers */  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game') BEGIN     EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='game', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB') BEGIN     EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH') BEGIN     EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB') BEGIN     EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01') BEGIN     EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';  IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01') BEGIN     EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';     EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'; END  exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true'; exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';

credits goes to ShaiyaOmega

the other one is Name is already in use how to fix execute this Query on your DB

PHP Code:


USE [PS_GameData] GO drop procedure [dbo].[usp_Save_Char_Item_Add_E] GO  SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO   /****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/   CREATE Proc usp_Save_Char_Item_Add_E  @CharID int, @ItemUID bigint, @Bag tinyint, @Slot tinyint, @ItemID int, @Type tinyint, @TypeID tinyint, @Quality int, @Gem1 tinyint, @Gem2 tinyint, @Gem3 tinyint, @Gem4 tinyint, @Gem5 tinyint, @Gem6 tinyint, @Craftname varchar(20) = '', @Count tinyint, @MaketimeZ varchar(50), @Maketype char(1)  AS DECLARE @Maketime as datetime SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120) --SET NOCOUNT ON  IF(@Quality >= 5000) BEGIN SET @Quality=0 END  INSERT INTO CharItems (CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4, gem5, gem6, craftname, [count], maketime, maketype) VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4, @Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)  IF(@@ERROR = 0) BEGIN RETURN 1 END ELSE BEGIN RETURN -1 END  --SET NOCOUNT OFF    GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

credits goes to JohnHeatz

Thanks.
I'm having the error: The connection with the server was closed ERROR 0
The first query worked, but I'm having an error in the second, you could post the file .sql of this query?
thank you

**r0ck7y** · 06-11-13

@juniordark
here is the file at the attachments

**SeedSphere** · 23-11-13

thanks guys....

**sominus** · 29-11-13

Any one knows how to remove Molebox from the ps_game.exe in this release?

[Release]Shaiya EP9 CN Server Files ^_^

Thread Tools

[Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Re: [Release]Shaiya EP9 CN Server Files ^_^

Advertisement