Shaiya Private Server - Instructions - English

03/09/2010 19:14 Piratejoke#436
heres the deal i trying making a private sever and ive been reading and reading. and reading and no clue where to start any ideals. i want to set up a decated private sever for shaiya sever. so private help would be greta contact me on windows messager [Only registered and activated users can see links. Click Here To Register...] would greatly apearicate it. okay this is where i am i dont get it i have done up to where i am suppose to in the tuti am at step 2 i am thinking i did something wrong but when i get to the restry i did that but after that it keeps restarting or not working at all can some one please please please help i am so lost

okay i got it figured out coing soon a new private sever contact me on msn if you like to help run the game as a gm sever will be a dedicated sever and will be up and open to public in no more than 4 days for beta testing ill post all info then pm me if your interest
03/10/2010 21:57 Kumarian#437
Idk what my problem is but i cant seem to get the server list to stay on play they keep going back to pause i may be overlookin something obvious but i get them to change to play for a moment then they go to pause thank you in advance for any help.
03/12/2010 16:10 bham666#438
I have a problem, When i click active all service they all turn to the play thing but they fail 1 by 1 and go bacxk to stop, here is the log

2010-03-12 17:07:32 PS_USERLOG__system log start (UserLog)

2010-03-12 17:07:48 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2010-03-12 17:07:48 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-03-12 17:07:48 PS_USERLOG__system log end (UserLog)

2010-03-12 17:07:48 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Please can anyone help me with it?
03/14/2010 03:34 hopeloz#439
i've got all smooth and running, but when i try to connect, i put my pwd and login (admin admin123) and log, when is going to the toon creation or selection, it freezes, and freeze all my computer... do someone knows what it is?
03/15/2010 23:33 nephren#440
Hi,

i got the Server but on the toon Creation it says always:

name already in use.

any idea?

(Sorry for my bad english)
03/17/2010 20:10 vAcun#441
Hy
I'm getting this error everytime i run instal_server.bat

[Only registered and activated users can see links. Click Here To Register...]

what should i do? Plz help me ^^
03/17/2010 22:17 nephren#442
Try to run as Admin.. its windows 7 :)
03/18/2010 18:29 vAcun#443
it doesnt work still same error cmon help me plz i realy wanna do my own private
03/19/2010 11:10 20$#444
when i type in a command in "GameGroups01 >> Game" i get an error and "Game" pauses...

Code:
# /nprotectoff
error console command write
03/19/2010 21:15 McMizzle#445
ive got the server to run (green arrow on all thing) but then they all slowly start turning back into green pauses... what wrong???
03/20/2010 08:30 Iam4eversmart#446
My error:
[Only registered and activated users can see links. Click Here To Register...]

Location of my files: D:\SHAIYA_SERVER\SERVER


It's not getting permission to access those files I believe, how do I fix this?
:/
03/20/2010 21:35 Migfenril34#447
hi all,i can log in game but when i want to create a char i cant create it because all name are taking.anyone can help me for find my problem pls.
ps:i have the same problem what Terence hill
03/21/2010 14:02 hopeloz#448
Quote:
Originally Posted by Migfenril34 View Post
hi all,i can log in game but when i want to create a char i cant create it because all name are taking.anyone can help me for find my problem pls.
ps:i have the same problem what Terence hill
Hi, migfenril34 and Terence Hill...
i've got this answer from another forum, that i will not say wich is, but everyone must know what zone i'm talking about..



Quote:
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
03/21/2010 16:55 bernardooo2#449
some1 should make a video tutorial for this
03/22/2010 18:41 _ares_#450
Hi all, and thank you all for the tutorials, but i have a problem :(

I have installed server on a virtual machine, server running without problems;
Public IP has been set and a my friend can enter for play;
The problem is how i can connect to my VM for play too?

Net configuration is:
My PC IP: 192.168.1.1
VM IP: 192.168.1.10
Router: 192.168.1.X
Server Game Public IP: X.X.X.X

Which IP i can enter on game.exe for connect?
if i put in my public IP, the client can't start and return an error, if i put my local IP client start, i can login and chose server but when i click OK button i receive error "failed to connect to game server"

Thank you!

P.S. Sorry for my bad english :(