[Release]Shaiya EP9 CN Server Files ^_^

MeGaMaX · Apr 7, 2013

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:

You must be registered to see links

You must be registered to see links

Client exe:

You must be registered to see links

DBS:

You must be registered to see links

Client Patch:

You must be registered to see links

Client:

You must be registered to see links

Master-dlls:

You must be registered to see links

Greetings: MeGaMaX

10dakongyi · Apr 10, 2013

thanks sir

Omegalll · Apr 11, 2013

thanks good aport

Tiffany Tiffy · Apr 14, 2013

androw3349 said:
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:

You must be registered to see links

You must be registered to see links

Client exe:

You must be registered to see links

DBS:

You must be registered to see links

Client Patch:

You must be registered to see links

Client:

You must be registered to see links

Master-dlls:

You must be registered to see links

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 · Apr 30, 2013

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

azex89 · May 9, 2013

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

congmanh333 · Sep 28, 2013

Thanks a lot of

Rowel Rebulado · Oct 22, 2013

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

r0ck7y · Oct 26, 2013

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:

/* 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:

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 · Oct 29, 2013

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

sominus · Nov 4, 2013

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 · Nov 6, 2013

r0ck7y said:

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:

/* 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:

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 · Nov 6, 2013

@juniordark
here is the file at the attachments

SeedSphere · Nov 23, 2013

thanks guys....

sominus · Nov 29, 2013

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

Duong Phan · Dec 5, 2013

Any English patch ?

BeDream · Dec 11, 2013

unpacked the ps_game.exe

You must be registered to see links

----------------------
this ServerFiles package is germany Ep6's ServerFile

Hoocker · Jan 19, 2014

It's all good work, but..How to be with 0 Item Mall points? Of course, i can make a web mall, but maybe available others way to do something with this..

Horatio Doa · Feb 3, 2014

BeDream said:
unpacked the ps_game.exe

You must be registered to see links

----------------------
this ServerFiles package is germany Ep6's ServerFile

pls reupload it to mega
thx

sominus · Feb 6, 2014

Could you please put the unpacked ps_game on any other host? I can't even load Baidu.

Edit:

Ok, I got it. But it says: Trojan Win32/FlyStudio in file ggauth52.dll

This is the content for the rar file:

ggauth52.dll
ps_game_unpacked.exe
ps_game_unpacked_mod.exe
??.jpg
??????.txt

I'll try later on a virtual box to see if it's a false positive, but be careful.

Welcome!

[Release]Shaiya EP9 CN Server Files ^_^

Developer

Junior Spellweaver

Newbie Spellweaver

Initiate Mage

Initiate Mage

Initiate Mage

Initiate Mage

Initiate Mage

Newbie Spellweaver

Developer

Newbie Spellweaver

My heart is crying

Newbie Spellweaver

Attachments

Newbie Spellweaver

Newbie Spellweaver

Experienced Elementalist

Initiate Mage

Initiate Mage

Newbie Spellweaver

Newbie Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor