[RELEASE]EP5 files that work

[Svinseladden]

i have tried just becouse i wanted to help ppl to find stuff here. and that's well not just hard but insane.


so well here it is..

server files:



yea so what's the big deal about this stuff?

you need sql 2012 to make them work..



take the one with tools 32 bit or 64 bit depends on your system..

other then that what is so great about this?

well first of all. they work.

they even have maps from 0-80

you can get everything you want in this one.

ep6 maps? yes they are here.

you only have to set them up

so tell you what. you can even download aeria and use that as client

just put this in:



it have ip 127.0.0.1

what do you need?

shtool here:

+ you need this:




other then that thanks bane for the orginal files i have messed around with




what to know about sql? remeber to have browser at automatic. (not that when you install)

don't forget to activate MSDTC (Distributed Transaction Coordinator) under service how too?

open up start. type in services.msc and enter and look for it put it on auto and start it up (windows 7)


using this files in windows 7 ? mabe vista? (sorry don't use that crap)(remember to turn off UAC) more info how to here:



Important one..

the Server Patch Config don't run like the "Instruction for Dummies.txt" say. so to install the server go in the shaiyaserver\PSM_Client open PSM_AgentInstall let it install and push the button apply windows registry

then go down to PSM_ServiceMgr install all exept gamewar (windows 7)

then go to the files:

shaiyaserver\PSM_Client\Bin\Config

change all the usernames there to your username (say's shaiya there now)

username = same username you use in sql in SQL New Installation as 'your-db-username'

they need to match. then go to :

shaiyaserver\PSM_Server and open ps_passwordEnc put in your database password (same as 'your-db-userpassword' in the file SQL New Installation)

that ps_passwordEnc will then give you a big ENC password buttom one.

copy that and past that in all the files in shaiyaserver\PSM_Client\Bin\Config

after the username (is a big one there already. just change it with the one you get from ps_passwordEnc)

you need to put in ip (local = 127.0.0.1) where it say GamePublicIP= in the file ps_game in shaiyaserver\PSM_Client\Bin\Config and server name where it say GameName= in the same file

remember to have the same server name in the file called ps_session same place..

be sure to read shtool closely so you get sql files from every sdata in the client or it will not run..

you need to know how to extract client and how to work with the client in shtool or you can't get a server started. sorry..

now after that i guess your ready :-)

WHY this files?

it have dupe fix installed already. close to all buggs you can get is already fixed. took me 5 min to setup a server priv in windows 7 and it worked. it's that easy..

it even have the GM_stuff installed if you like to have controll panel installed later on (using this also makes all players that use the same ip "if you ip ban" banned. and even if they try some elses ip or change ip they still are banned)

thanks to who that was that made the GM_stuff files(sorry don't remember right now)

for now i hope i got it all. not great at explaning but ask and i will answer when i can..


PS:
max lvl = 80

can change that here:

[JohnHeatz]

#Added to the Index

[Svinseladden]

i got this. server working great but i can't get in..


well if you can read that you need shtool



but even before shtool you need



with this tool you can extract your client. so you can have a server running and not extract just the part you like. then you have nothing like icons and so on..

extract the data folder in your client.. with shaiya data files tool (link above) then start working in shtool

in shtool you need to read alot of it..

this is going to be your home the next years if your running a server

the tool start off with how to work with it..

read..

1.3 Working with version 0.7.5 (forget for now. it's not out yet. just 0.7.1 for now..

2. Cash.sdata. open it. save it when shtool is setup you get a cash.sql files in server files

3. Skills it's in data characters skill.sdata (yes client is extracted) open it. and save it and it will make another skill.sql in server files..

4. Item.sdata sdave open it. save it and you will have another item.sql in server files..

5. NpcQuest.sdata this don't make sql files in server data but another NpcQuest.sdata in server files. this is going under shaiyaserver\PSM_Client\Bin\Data

6. Monster.sdata no this one you can't just open and save..

you need this:

Editing only the content of the monster.sdata file was not satisfactory; indeed the big part of information is in BD only.
The solution is an extended monster file ("MonsterEx.SData") file that contains the monster.sdata information plus DB information (the content of the dbo.Mobs & dbo.MobItems table).
This file is generated once with the monster.sdata and the 2 tables (exported from SQL Studio in .CSV format) and imported by the tool.
The file is then used to regenerate the monster.sdata file and a SQL script to update the Mobs & MobItems tables.

Be sure to properly export the full tables with all OS defined columns (no more, no less and in right order) or the import will fail.
The field separator (the character between each field) must be a comma or a semi-colon, also no thousand separators shall be present in numerical figures (eg the value 2500 shall be "2500" and not "2,500" or "2.500").
The csv files must be saved as plain ANSI text, SQL Studio saves files with UTF-8 or Unicode encoding as default choices, make sure to define the encoding options to "ANSI" with the small down arrow on the Save button.

The expected format for the Mobs.csv is:
Spoiler: Code:
RowID;MobID;MobName;Level;Exp;AI;Money1;Money2;Que stItemID;HP;SP;MP;Dex;Wis;Luc;Day;Size;Attrib;Defe nse;Magic;ResistState1;ResistState2;ResistState3;R esistState4;ResistState5;ResistState6;ResistState7 ;ResistState8;ResistState9;ResistState10;ResistSta te11;ResistState12;ResistState13;ResistState14;Res istState15;ResistSkill1;ResistSkill2;ResistSkill3; ResistSkill4;ResistSkill5;ResistSkill6;NormalTime; NormalStep;ChaseTime;ChaseStep;ChaseRange;AttackTy pe1;AttackTime1;Attackrange1;Attack1;Attackplus1;A ttackattrib1;Attackspecial1;Attackok1;Attacktype2; Attacktime2;Attackrange2;Attack2;Attackplus2;Attac kattrib2;Attackspecial2;Attackok2;Attacktype3;Atta cktime3;Attackrange3;Attack3;Attackplus3;Attackatt rib3;Attackspecial3;Attackok3
1;0;??;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0 ;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0 ;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0
2;1;Small Ruined Wolf;38;704;1;1820;3822;0;2765;874;1578;60;40;53;3 ;1;4;38;31;0;0;0;0;0;0;0;1;0;0;0;0;0;0;0;0;0;0;0;0 ;0;4000;6;1800;9;9;0;2500;2;167;83;0;0;1;37;2500;2 ;142;85;0;0;1;0;0;0;277;0;0;3;0
3;2;Rotting Poison Larva;38;704;1;1820;3822;0;2765;874;1578;60;40;53; 3;2;0;38;31;0;0;0;0;0;0;0;1;1;0;0;0;0;0;0;0;0;0;0; 0;0;4000;6;1800;9;9;0;2500;2;167;83;0;0;1;19;2500; 2;142;85;0;0;1;0;0;0;277;0;0;3;0
... all other lines ...


The expected format for the MobItems.csv is:
Spoiler:
RowID;MobID;ItemOrder;Grade;DropRate
1;0;1;0;0
2;0;2;0;0
3;0;3;0;0
... and so on ...

The editor saves the Monster.sdata file encrypted from where it was opened; it also saves an extended monsters file ("monsterEx.sdata") in the same folder than the one containing the monster.sdata file. Using a global server repository here was not possible since this will prevent the existence and edition of several monster.sdata.
That extended file is not supposed to be packed in a client package; it is your responsability to move/remove/... it.

A SQL script is also saved in the server directory.

For first use, you must export the 2 required tables in .CSV format and then import them (File menu, Import item).
These 2 CSV files are no longer needed after import and can be deleted.
For next uses, you simply open the monster.sdata file - you don't select the monsterEx.sdata, it is automatically detected and used by the tool.

all this is just a total copy of shtool here



this was just a mini tutorial on how to get your server online. not even talked about editig yet so again read about shtool.

[TeddyBear94]

svinseladden maybe tell us what all in the database is already done ( in the server files)

[Svinseladden]

well ip ban in GM_Tools is from this one:



i havent worked on the admin panel it self but added the ip banning stuff in there. + made that work in the db it self. added what needs to be added and so on..

but the full admin panle don't work fully..


secound fix? dupe protection. both the one litle pro hacker released and the other.



+

the IF @ActionType = '116 is already in and working

the gm explosit is removed (where you have the chat trigger stuff)

well i don't even remeber all the small fixes i have done. he he

and no it's not fully 1-9 skills


ask if you want to know more..

[Kyonhism]

Is this best EP5 server in this site ?

[Svinseladden]

i would think so. but remember to setup 75+ in maps and put up a portal to them anywhere you like. i removed that becouse i don't want ppl to use my names for it LOL..

[hootzoo]

what is the diffrance with these and ??? i look but pretty much every thing is the same..... well beside the addon fixes i thing right?

[Svinseladden]

ready for the new sql. 2012.

alot of fixes. the db GM_Tools from controll panel.

dupe fix.

it's a long list of small fixes and so on.

[jpldias]

hello i´m sorry i´m trying to install you pack to make a private server i read almost everything in this forum how to make a private server and see a lot of videos and i cant put your files working can you please make a video tutorial how to setup everything i want to play shaiya with my friends and thanks for your work

[564lopes564]

One question to SQL Express 2012

I need to download LocalDB or Express or Express with tools or Sql managment studio or Express with advanced services?

[TeddyBear94]

express with tools

[Svinseladden]

Originally Posted by jpldias

hello i´m sorry i´m trying to install you pack to make a private server i read almost everything in this forum how to make a private server and see a lot of videos and i cant put your files working can you please make a video tutorial how to setup everything i want to play shaiya with my friends and thanks for your work

well if you been reading alot you find way's here

like sql install

Tutorial 01 Installing MSSQL on Microsoft® Windows XP

here




this is 2005 but still works kind of the same. need the sql with express toolls and no neeed for local db when you install but don't give a prob if you have it..

Remember to have browser on automatic

in there you have a file, i don't have that so attach db..

you open SQL Server Management Studio

this is when yout totaly done intalling sql

and rightclick the folder databses in SQL Server Management Studio

choose attach and find your server files. attach then 1 by 1 untill you have them all

run both the file shaiya_svc_register and SQL New Installation

in SQL New Installation put in the username and password you want for your server wher it say's 'your-db-username'=Username and 'your-db-userpassword'= Password

What username and password? Your own make it up...

open ps_passwordEnc

type in the same as you used in the file SQL New Installation and the long password that look's more or less like this:E139DD323EBA8BCBC8A46603C3AC562C7478D50F87B42 7578E59E6D21AC38032AB6118C696C1411985178BCFC0C9381 3396ED2BFEBE3E5EABC8E6277635240630F66067C37A47A23D F48CDC7F0F1A460245E8C52D0AD2A371076A9804B165A9E424 7D3BADB94B783A8341D150F564EDA44D1B5D550E89836E7A9E 16936DE80E7 (this is made when you type in the ps_passwordEnc)

then you have you password copy this

open shaiyaserver\PSM_Client\Bin\Config

all the ini files there have both username and password in them already. you have to change username with your username and password with the long password you got from ps_passwordEnc

remeber server name both under ps.game.ini and ps_session.ini

ps_game.ini also need ip (127.0.0.1 if you run this localy on your computer or servers ip if you have this on a server)

try opening the file PSM_AgentInstall and after that PSM_ServiceMgr and install on all exept ps_gamewar leave that alone

both file are located at shaiyaserver\PSM_Client

when that done go to the folder

shaiyaserver\PSM_Server and open PSMServer_Mgr ansd try starting your server.

[QQers19]

Hello!
I have problem-i can't connect with DataBase.
MSDTC-auto
I try use this tut:

But still server is pause
I have sql 2012-mixed mode(shaiya123)









Log:

2012-10-09 12:38:15 PS_DBAGENT__system log start (DBAgent01) 2012-10-09 12:38:32 DB gamedata connect error 2012-10-09 12:38:32 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-10-09 12:38:32 DBKillCountSave db alloc failed 2012-10-09 12:38:32 SAVE kill count ERROR 2012-10-09 12:38:32 CKeepObeliskMgr:BSave db alloc failed 2012-10-09 12:38:32 SAVE g_KeepObeliskMgr ERROR 2012-10-09 12:38:32 GuildMgrSave:BSave db alloc failed 2012-10-09 12:38:32 SAVE g_GuildMgrSave ERROR 2012-10-09 12:38:32 PS_DBAGENT__system log end (DBAgent01)
2012-10-09 12:38:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Log:

2012-10-09 12:38:21 PS_GAME__system log start (Game01) [KR] 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/sorp1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/croco1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/croco2 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Troll1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Spink1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/GoldenPig 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Sorp3 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/SorpNamed1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/SorpNamed2 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Sorp2 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/CrocoNamed1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/CrocoNamed2 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/CrocoNamed3 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/OrcNamed1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/OrcNamed2 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/OrcNamed3 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/TrollNamed1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/HellTouthNamed1 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Deinos 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Parridalis 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Alcarian 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/ZinAlcaria 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Belizabeth 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Kirhiross 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/CrypticOne 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Haruhion 2012-10-09 12:38:21 Loaded Behavior In Factory : data/ai/Freezing 2012-10-09 12:38:37 DB gamedef connect error 2012-10-09 12:38:37 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-10-09 12:38:37 Call save all waiting... 2012-10-09 12:38:37 Call save all failed dbagent disconnected(user count = 0)... 2012-10-09 12:38:37 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-10-09 12:38:37 Save Shaiya.SData 0 2012-10-09 12:38:37 PS_GAME__system log end (Game01) 2012-10-09 12:38:37 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Log:

2012-10-09 12:38:10 PS_GAMELOG__system log start (GameLog01) 2012-10-09 12:38:26 DB gamelog connect error 2012-10-09 12:38:26 init db error 2012-10-09 12:38:26 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-10-09 12:38:26 PS_GAMELOG__system log end (GameLog01) 2012-10-09 12:38:26 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Log:

2012-10-09 12:38:00 PS_SESSION__system log start (Session) 2012-10-09 12:38:01 userlog connect failed 2012-10-09 12:38:01 initserver() failed 2012-10-09 12:38:01 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-10-09 12:38:01 PS_SESSION__system log end (Session) 2012-10-09 12:38:01 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Log:

2012-10-09 12:37:57 PS_USERLOG__system log start (UserLog) 2012-10-09 12:38:13 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=shaiya, Pass=shaiya123 2012-10-09 12:38:13 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-10-09 12:38:13 PS_USERLOG__system log end (UserLog) 2012-10-09 12:38:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown

ps.ini

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=3000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
GameData=127.0.0.1, PS_GameData, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
[GAMEINFO]
GameName=shaiya server
GamePublicIP=127.0.0.1
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
DBChat01=127.0.0.1, PS_ChatLog, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=
[CONNECTION]
UserLog=127.0.0.1
[GAMESERVERS]
GameServerCount=1
Game01=shaiya server
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, shaiya, BAA40D237E80006D51931469F8C8703BE4BDADC28CD7EAD011 9DE0B13224819F9110ED9C3B06F42592A47F6946295AE34C1B 609ED1BC53E822C1D5D9B7DE0D4A496CACEB0A694DE69E2CA3 1AFD0A5213F310BAD4D26BD4B858DA5BBBF5EEE72850E9A327 9A86A358AFF682F8458DB71514BD519EBF3C13F81891F800EE E71A63
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

And i have no idea how fix this QQ

[RebeccaBlack]

It's not connecting to your database. (The UserLog error), either the database isn't attached, you didn't set the network up properly (TCP/IP), or the username/password for MSSQL is incorrect.