[HelpDesk]Fixes | Ask For Help | Q&A | Updated

[claudeD]

can somone help me how can i make a update pach

thnx
claude

 

[wolfnibbles]

I gave up on the Chinese Shaiya 2, I don't have the right equipment. I am now trying again to make a Shaiya US version, I can login, choose the server, and then I get character load error!!!
How can I fix this so I can play the game?

 

[ihatehaxor]

character load error?
Can I see a pic

 

[wolfnibbles]

This is what I get after I log in and choose server:

It's the CHARS I can not create, that is why I get (character load error!!!) Can someone help?

 

[wolfnibbles]

Ok, Its fixed, I reinstalled for the 15th time, but now I can at lest play.

 

[xxxsinetxxx]

Help me plz!!
I have this problem !!
<img>

You must be registered to see links

after i start it its work 3 sek

You must be registered to see links

then

You must be registered to see links

and the end

You must be registered to see links

 

[rubixcube40]

Which Ips are needed for lan play? I have hexed the game.exe already to my lan...and added the lan Ip to "public Ip" in the Server manager..Im able to connect and login...but others on the network get "unable to connect to gameserver" error. And I have sent them the hexed game.exe and already added their accounts into the db. Any help would be much appreciated. Thank you.

 

[cosong]

Sorry, LOTS of problem with "name already in use"

if try create new procedure SQL say - procedure already created, so what i nedd? delete old proc and create new proc with HACKOMAN question answering, or edit proc's? if i edit procedures its goon withouut erros but problom not to gone :/ pls can help with them or give more detail cautions

Thanks alot!

 

[cbk666]

Hello everyone. Im having some trouble with setting up my server. I am kinda new and not kinda new to this. But i understand everything but it aint working. But when i click install_server.bat to install the server i get this.

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
OS Error 2 The system cannot find the file specified.

Press any key to continue . . .

Does anyone know anything?

My msn is swaidcbk@hotmail.com thanks.

 

[ihatehaxor]

Thread updated - 4/25/2010
- Made spoiler tags so it can be more organized.
Ask some questions here, and don't forget to check the guide section, and search around if your question is not answered here!

 

[zerox22x]

Spoiler

Originally Posted by Answer/HASKOMAN
GO TO

SQL Database - PS_GameData - CHAR - design table and change Maketime in varchar


xd you have the same problem I've had but I am a good programmer

CHANGE MY SCRYPT


go to USP_SAVE_CHAR_ITEM_ADD_E



/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008-6-7 18:31:57 ******/

/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008/3/15 下午 05:25:52 ******/



/****** 偃羹: 盪濰 煎衛盪 dbo.usp_Save_Char_Item_Add_E 蝶觼董 陳瞼: 2006-04-11 螃 10:57:16 ******/


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,
@Maketime varchar(20)='01/01/1999',
@Maketype char(1)

AS

--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




and

go to usp_Read_Char_Items_Detail_R


CHANGE MY SCRYPT




/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008-6-7 18:31:57 ******/

/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008/3/15 下午 05:25:51 ******/




CREATE Proc usp_Read_Char_Items_Detail_R

@CharID int

AS

/******SET NOCOUNT ON******/

SELECT ItemID, Type, TypeID, ItemUID, Bag, Slot, Quality,
Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, [Count], Maketype ,
'2009' AS MakeTime_YYYY,
'01' AS MakeTime_MM,
'01' AS MakeTime_DD,
'00' AS MakeTime_HH,
'00' AS MakeTime_MI,
'00' AS MakeTime_SS


FROM CharItems

WHERE CharID = @CharID AND Del = 0

/******SET NOCOUNT OFF******/
GO


and restarts all the service and good luck

I've spend 4 days but I've successfully with these changes it is sufficient to look for or just the error ^ ^
And you can create characters now

after having done this, i cant even acces the server anymore(firewall is disabled)
disconnects me with error 0

 

[9thCircle]

Hello, and thank you in advance for any help that may be available. I have exhausted all sources i can find top figure this out.

I have tried with Ep3 and ep4 as well as trying to find a way to attempt with ep5 info. Regardless of the version i get the same error every time.

After following every guide i can find to an exact my server is working. I load the game. Log the admin account. Select the server and then i get the same thing...either a character load error or it simply crashes before getting to the faction select screen.

I've checked and all IP's are set to 127.0.0.1
All files names are correct from what i can tell
...after at least 30 attempts I am exhausted of ideas.

If anyone has a clue then any help would be greatly appreciated. Thank you.

-9thCircle, aka Frank

 

[Twilight]

After following every guide i can find to an exact my server is working. I load the game. Log the admin account. Select the server and then i get the same thing...either a character load error or it simply crashes before getting to the faction select screen.
-9thCircle, aka Frank

..i think problem in database(tables or store proc..).. see logs

 

[ourahen]

Hi, Ace i saw that u know a lot of thing about the creation of server so u can help me. Can u explain me how can i change red X in green X but in details plz

 

[optimus0]

can any one provide me a valid download link for client for this server files http://forum.ragezone.com/f559/release-shaiya-ep4-c-drive-659072/
Thanks

 

[Haydees]

Hi, Ace i saw that u know a lot of thing about the creation of server so u can help me. Can u explain me how can i change red X in green X but in details plz

Same with me.
I am running Win7 x64... Basic Specs:

You must be registered to see links

I have SQL Server 2005:

You must be registered to see links

After 3 attempts to install it, I used a guide on the net. - to make sure I was installing correctly (Which I was).
Before the installation of it was successful, I deleted all files / directories that had to do with SQL (including registry).

Once I installed SQL, I launched "Install_Server.bat" (D:/SHAIYA_SERVER/SERVER/Install_Server.bat)
Everything completed successfully. I clicked "Apply Windows Registry" in the "Server Patch Config" program and hit enter in the command prompt window. PC restarted.

I then continued from the main post. When I clicked "Service Install All" Nothing happens.. I waited 20 minutes while I ate Dinner and when i returned all the red X's were still red and not Green

Anyone have a solution they could share please? :tongue:
Thanks in advance.

 

[demonicdragon17]

I'm having some trouble with the Cash.SData editor by K.E.F.E. and was wondering if someone could please explain what I'm having difficulties with:

I've figured out the ID, Pack, Icon, Point, ItemID, Code, and Name boxes (no-brainer stuff). The only ones I don't understand are the Bit, Sufni, and the 22 sets of boxes in the lower right side.

Apparently the ones I don't understand are what are preventing me from getting this successfully loaded into my data.saf. Another theory I have about it is that it needs to be re-encrypted before being implemented. Any thoughts or help would be seriously appreciated. Thanks!

 

[Haydees]

Someone please help me out.
I cannot figure this out :/:

 

[vampie]

Hello Guys I has installed Mssql after this TUT ready

http://forum.ragezone.com/f560/tut-setup-mssql-2005-express-windows-7-a-658653/

has taken then server here

http://forum.ragezone.com/f560/tut-make-substitute-d-drive-588553/

has put then server after this TUT

http://forum.ragezone.com/f560/tut-shaiya-private-server-instructions-588558/

habe dann in der PublicIP meine hamachi ip eingetragen

has provided game.exe with ip

mine fehler is I come on it on then rechner where server also leuft

but in hamachi in it they are mistakes do not come on it is "failed to connect to game server!!!"

The log are in such a way

C:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Log

PS_DBAGENT__charsave:
//PS_DBAGENT__charsave log start (DBAgent01)

PS_DBAGENT__system:
2010-08-26 21:44:32 PS_DBAGENT__system log start (DBAgent01)

2010-08-26 21:44:38 connect game, Name=



2010-08-26 21:44:39 connect game, Name=



2010-08-26 21:44:39 connect game, Name=

PS_GAME__system:
2010-08-26 21:44:35 PS_GAME__system log start (Game254) [KR]

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/sorp1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/croco1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/croco2

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Troll1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Spink1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/GoldenPig

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Sorp3

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Sorp2

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Deinos

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Parridalis

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Alcarian

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Belizabeth

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Kirhiross

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/CrypticOne

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Haruhion

2010-08-26 21:44:35 Loaded Behavior In Factory : data/ai/Freezing

2010-08-26 21:44:39 connect mgr 992

2010-08-26 21:44:39 connect dbagent 996

2010-08-26 21:44:39 connect dbagent2 1000

2010-08-26 21:44:39 connect gamelog 1016

2010-08-26 21:44:40 Market End -----------------------

2010-08-26 21:44:40 Load Shaiya.SData 0

PS_GAMELOG__system:
2010-08-26 21:44:29 PS_GAMELOG__system log start (GameLog01)

2010-08-26 21:44:38 connect game

2010-08-26 21:44:39 connect game


PS_LOGIN__system:

2010-08-26 21:44:37 PS_LOGIN__system log start (Login01)

PS_SESSION__system:
2010-08-26 21:44:29 PS_SESSION__system log start (Session)

2010-08-26 21:44:37 connect login

2010-08-26 21:44:38 connect game war

2010-08-26 21:44:39 connect game



PS_USERLOG__system:
2010-08-26 21:44:27 PS_USERLOG__system log start (UserLog)

2010-08-26 21:44:29 connect

2010-08-26 21:44:37 connect

2010-08-26 21:44:38 connect

2010-08-26 21:44:39 connect

unfortunately, I cannot so well in English

 

[DemonEyez]

can someone be kind enough to walk me through writing and installing an update patch please, Thx Demon