Shaiya Private Server - Instructions - English

gracias por el aporte pero prodias porner los link :D

Bräucht mal n bissl Hilfe von nem Profi, gern auf deutsch---

Wie kann ich n Server (funzt auf 127.0.0.1 einwandfrei) fürn LAN einstellen, bzw. in welche Ini's muss ich die entsprechenden LAN-IPs eintragen, die dann connecten dürfen ?

PS.
Game.exe, FireWall usw stellen kein Prob dar, im Prinzip gehts darum, das Ding öffentlich zu machen.
Bsp: Laptop = Server (IP 127...) (LAN-IP 192.168..1)
PC1 = Client 1, Acc 1 (IP 192.168..2) (Game.exe IP = 192.168..1)
PC2 = Client 2, Acc 2 (IP 192.168..3) (Game.exe IP = 192.168..1)
.

Hoffe, daß mir da jmd unter die Arme greifen kann, n hilfreicher Link wär da auch ganz nett, da die SuFu nur ConnectProbs mit 127... bzw. DBs ausspuckt...

...ow-no client thats sad ;(

saidlow:

ofc there is no Client because you can use the OS ones or anyone you like and edit the game.exe in HxD or any hex editor to your own ip or 127.0.0.1 if local


~~~~~~~~~~~~~~

Zalora:

Quote:

Originally Posted by Zalora Bräucht mal n bissl Hilfe von nem Profi, gern auf deutsch--- Wie kann ich n Server (funzt auf 127.0.0.1 einwandfrei) fürn LAN einstellen, bzw. in welche Ini's muss ich die entsprechenden LAN-IPs eintragen, die dann connecten dürfen ? PS. Game.exe, FireWall usw stellen kein Prob dar, im Prinzip gehts darum, das Ding öffentlich zu machen. Bsp: Laptop = Server (IP 127...) (LAN-IP 192.168..1) PC1 = Client 1, Acc 1 (IP 192.168..2) (Game.exe IP = 192.168..1) PC2 = Client 2, Acc 2 (IP 192.168..3) (Game.exe IP = 192.168..1) . Hoffe, daß mir da jmd unter die Arme greifen kann, n hilfreicher Link wär da auch ganz nett, da die SuFu nur ConnectProbs mit 127... bzw. DBs ausspuckt...

i didnt understand even with google translate:

Quote:

Bräucht times n bissl professional help of NEM, like in German --- How can I n servers (funzt properly on 127.0.0.1) Set fürn LAN, or in which ini's I must add the appropriate LAN IPs, which may then connect? HP. Game.exe, Firewall, etc. are not a prob, in principle HERE about making the thing public. Example: laptop = server (IP 127th ..) (LAN IP .. 192 168 1) PC1 = client 1, Acc 1 (IP 192 168 .. 2) (IP = 192.168 .. game.exe 1) PC2 = client 2, Ace 2 (192 168 .. 3 IP) (IP = 192.168 .. game.exe 1) . I hope that I can because jmd under the arms n, as well as useful links Advertisement quite nice, as Sufu ConnectProbs only with 127 .. DB or spits out ...

I have a problem with my database.
Look below the error that can have the view:
[Only registered and activated users can see links. Click Here To Register...]
Please Help me !
Answer me as soon as possible.
Thank you ^^

i would prefer if its with English or at least what does it say in English

i Cant start the PSM Service Agent.
It Says a weird message like -> &*R@%@$*(&@()!@&@@&*H#
And i dont know how to fix this, Help Me plz

That might be that you got it bugged, re download it and try again

hello can u help me with the edit of item mall . i have deit one , i update it in sql and game i see it but when i try to buy an item in it the server disconnect . i see error in log but i dont understand what is the error . can see my log and tell me what the error is . thanks

PS_DBAGENT


2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:18 SaveBuyPointItem 86 [GS]2test qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(1,86,0,'PK_ legends01','2012-06-15 13:44:18',1)}








PS_GAME


2012-06-15 13:43:11 error exp over usern=admin,charn=[GS]2test, level=70,exp=7186750,exppn=7186750

2012-06-15 13:44:19 discon client: (104, 1236) T=000:01:00:000, RC=18,RCS=0, RB=169,RBS=1, SC=175,SCS=2, SB=3560,SBS=41




PS_GAMELOG


2012-06-15 13:43:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:43:11 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:43:11' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '127.0.0.1','money=0, bank=0, cash=0','level=70,skp=5,stp=0','s=12,d=9,i=10,w=10 ,r=14,l=10'

2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:44:18' ,113, 3575536024534777856,100051,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'Large Eternal Endurance','PointItem','0,0,0,0,0,0','2012-06-15 13:44:18'

2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:44:18' ,113, 3575536024534908928,100075,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'Double Warehouse','PointItem','0,0,0,0,0,0','2012-06-15 13:44:18'

2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:44:18' ,113, 3575536024534712320,100165,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'30 Days Res Rune','PointItem','0,0,0,0,0,0','2012-06-15 13:44:18'

2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:44:18' ,113, 3575536024534843392,100053,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'Large Prevent of Item Drop','PointItem','0,0,0,0,0,0','2012-06-15 13:44:18'

2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:44:18' ,113, 3575536024534974464,100074,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'Red Phoenix Charm','PointItem','0,0,0,0,0,0','2012-06-15 13:44:18'

2012-06-15 13:44:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-06-15 13:44:19 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,86,'[GS]2test', 70,7186749,2, 1838.930054,129.330002,443.429993, '2012-06-15 13:44:19' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=0, bank=0, cash=0','level=70,skp=5,stp=0','s=12,d=9,i=10,w=10 ,r=14,l=10'

You maybe didn't set them good when editing, but also:

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

Check that

ok thanks but its not that, dc server continue when i buy item, i think the problem come to the DB sql

( 2012-06-15 13:44:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

i edit with shstudio and before run the item.sql i need to enter a values maybe that and item naùme are red thats not normal ? so i continue to search if some one have an idea , i m here lol
P.S i see a thread with abrasive where he tell maybe problem is usp_Save_User_BuyPointItems_NCash


that is the item.sql save witn shstudio

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList];
GO
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Days Pack','PK_legends01',0,100165,1,100051,1,100053,1, 100075,1,100074,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)
GO

My Server Services dont stay playing they go right back to pause any tips??

hey im sorry for this most novice of questions but what do i do to create an exe so i can actually start the p server

@Spot:

Check your logs... :) That will help you to find error so you can start searching solution for it.
Most of time they go back to pause cuz Server Can't connect to the DB But there's always something. Maybe wrong IP's, .ini files.. much things.

Quote:

Originally Posted by lessovick hey im sorry for this most novice of questions but what do i do to create an exe so i can actually start the p server

You do not "create an .exe" you take any .exe that is around (must match your database's EP) and edit the needed information with a Hex Editor