Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 08:31

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Euphoria Dev Team Release] Starter Gears

Discussion on [Euphoria Dev Team Release] Starter Gears within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.

Reply
 
Old 08/01/2013, 22:09   #16
 
elite*gold: 0
Join Date: Jul 2013
Posts: 4
Received Thanks: 0
PS_GameData -> Programmability -> Functions -> Scalar-valued Function and Delate dbo.ItemUID

Then the run
[Dev]Optimum is offline  
Old 08/01/2013, 22:13   #17
 
[Dev]Matheus's Avatar
 
elite*gold: 0
Join Date: May 2013
Posts: 60
Received Thanks: 44
My logs

PS_DBAGENT
Code:
//PS_DBAGENT__charsave log start (DBAgent01)

//PS_DBAGENT__charsave log start (DBAgent01)
Code:
2013-08-01 17:03:21 PS_DBAGENT__system log start (DBAgent01)

2013-08-01 17:03:29 connect game, Name=



2013-08-01 17:03:29 connect game, Name=



2013-08-01 17:07:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PS_GameData.dbo.NewID'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2013-08-01 17:07:41 ::CreateCharacter 0 Test_N1 retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'611327',2,'Test_N1', 0,3,3,0,0,2,0,0, 1,0,0, 16,12,11,8,11,7, 372,110,247, 2,0, 0,0, 1838.930054,129.330002,443.429993, 0,200,0,0,0)}

2013-08-01 17:07:41 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=9,RCS=0, RB=303,RBS=1, SC=8,SCS=0, SB=2227,SBS=8

2013-08-01 17:08:02 disconnect game, Name=Game01



2013-08-01 17:08:02 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=3,SCS=0, SB=2064,SBS=7

2013-08-01 17:08:02 disconnect game, Name=Game01



2013-08-01 17:08:02 save market... wait plz...



2013-08-01 17:08:02 save all... wait plz... enter /uc



2013-08-01 17:08:02 3 1 SERVICE_CONTROL_STOP

2013-08-01 17:08:02 PS_DBAGENT__system log end (DBAgent01)


2013-08-01 17:08:02 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAME
Code:
2013-08-01 17:03:23 PS_GAME__system log start (Game01) [KR]

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/sorp1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/croco1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/croco2

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Troll1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Spink1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/GoldenPig

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Sorp3

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/SorpNamed1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/SorpNamed2

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Sorp2

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/CrocoNamed1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/CrocoNamed2

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/CrocoNamed3

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/OrcNamed1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/OrcNamed2

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/OrcNamed3

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/TrollNamed1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Deinos

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Parridalis

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Alcarian

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/ZinAlcaria

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Belizabeth

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Kirhiross

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/CrypticOne

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Haruhion

2013-08-01 17:03:23 Loaded Behavior In Factory : data/ai/Freezing

2013-08-01 17:03:23 RandomOption Error : ItemID=24077, byServer=2, Wis=0

2013-08-01 17:03:23 RandomOption Error : ItemID=24078, byServer=2, Wis=0

2013-08-01 17:03:23 RandomOption Error : ItemID=24162, byServer=2, Wis=0

2013-08-01 17:03:23 RandomOption Error : ItemID=24163, byServer=2, Wis=0

2013-08-01 17:03:23 RandomOption Error : ItemID=24247, byServer=2, Wis=0

2013-08-01 17:03:23 RandomOption Error : ItemID=24248, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=39077, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=39078, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=39162, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=39163, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=39247, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=39248, byServer=2, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=44039, byServer=5, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=44040, byServer=3, Wis=0

2013-08-01 17:03:24 RandomOption Error : ItemID=44041, byServer=2, Wis=0

2013-08-01 17:03:29 connect mgr 888

2013-08-01 17:03:29 connect dbagent 892

2013-08-01 17:03:29 connect dbagent2 896

2013-08-01 17:03:29 connect gamelog 928

2013-08-01 17:03:30 Market End -----------------------

2013-08-01 17:03:39 Load Shaiya.SData 1

2013-08-01 17:08:02 3 1 SERVICE_CONTROL_STOP

2013-08-01 17:08:02 Call save all waiting...

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=2,RCS=0, RB=106,RBS=0, SC=5,SCS=0, SB=117,SBS=0

2013-08-01 17:08:02 discon mgr ((3,1236, 106,117)

2013-08-01 17:08:02 mgr Connection Lost INFO : T=000:04:00:000, RC=2,RCS=0, RB=106,RBS=0, SC=5,SCS=0, SB=117,SBS=0

2013-08-01 17:08:02 mgr server disconnection

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-08-01 17:08:02 discon gamelog ((3,1236, 0,37)

2013-08-01 17:08:02 gamelog Connection Lost INFO : T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-08-01 17:08:02 game log server disconnection

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=8,RCS=0, RB=2227,RBS=8, SC=9,SCS=0, SB=303,SBS=1

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:02 discon dbagent ((3,1236, 2227,303)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=3,RCS=0, RB=2064,RBS=7, SC=1,SCS=0, SB=37,SBS=0

2013-08-01 17:08:02 dbagent Connection Lost INFO : T=000:04:00:000, RC=8,RCS=0, RB=2227,RBS=8, SC=9,SCS=0, SB=303,SBS=1

2013-08-01 17:08:02 discon dbagent2 ((3,1236, 2064,37)

2013-08-01 17:08:02 db agent server disconnected...

2013-08-01 17:08:02 dbagent2 Connection Lost INFO : T=000:04:00:000, RC=3,RCS=0, RB=2064,RBS=7, SC=1,SCS=0, SB=37,SBS=0

2013-08-01 17:08:02 call disconnectAll...

2013-08-01 17:08:02 db agent2 server disconnected...

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=0

2013-08-01 17:08:02 discon userlog ((3,1236, 0,126)

2013-08-01 17:08:02 userlog Connection Lost INFO : T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=0

2013-08-01 17:08:02 userlog log server disconnection

2013-08-01 17:08:02 server shutdown Connection INFO : T=000:04:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=1,CReq=1,CCnt=1,DCCnt=1, CTimeT=000:01:00:000,CTimeAvg=000:01:00:000, RBT=62,RBS=0,RBSC=0,SBT=87,SBS=0,SBSC=1

2013-08-01 17:08:02 Save Shaiya.SData 1

2013-08-01 17:08:02 PS_GAME__system log end (Game01)

2013-08-01 17:08:02 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAMELOG
Code:
2013-08-01 17:03:21 PS_GAMELOG__system log start (GameLog01)

2013-08-01 17:03:29 connect game

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-08-01 17:08:02 disconnect game

2013-08-01 17:08:02 3 1 SERVICE_CONTROL_STOP

2013-08-01 17:08:02 PS_GAMELOG__system log end (GameLog01)

2013-08-01 17:08:02 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_LOGIN

Code:
2013-08-01 17:03:23 PS_LOGIN__system log start (Login01)

2013-08-01 17:08:01 3 1 SERVICE_CONTROL_STOP

2013-08-01 17:08:03 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:03 1 1 T=000:04:00:000, RC=9,RCS=0, RB=156,RBS=0, SC=31,SCS=0, SB=392,SBS=1

2013-08-01 17:08:03 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:03 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-08-01 17:08:03 mgr server disconnection

2013-08-01 17:08:03 log system server disconnection

2013-08-01 17:08:03 PS_LOGIN__system log end (Login01)

2013-08-01 17:08:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_SESSION
Code:
2013-08-01 17:03:21 PS_SESSION__system log start (Session)

2013-08-01 17:03:23 connect login

2013-08-01 17:03:29 connect game

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=5,RCS=0, RB=117,RBS=0, SC=2,SCS=0, SB=106,SBS=0

2013-08-01 17:08:02 disconnect game

2013-08-01 17:08:02 3 1 SERVICE_CONTROL_STOP

2013-08-01 17:08:03 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:03 1 1 T=000:04:00:000, RC=31,RCS=0, RB=392,RBS=1, SC=9,SCS=0, SB=156,SBS=0

2013-08-01 17:08:03 disconnect login

2013-08-01 17:08:03 1 1 SAgent::Disconnect: (3, 1236)

2013-08-01 17:08:03 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-08-01 17:08:03 log system server disconnection

2013-08-01 17:08:03 PS_SESSION__system log end (Session)

2013-08-01 17:08:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_USERLOG
Code:
2013-08-01 17:03:21 PS_USERLOG__system log start (UserLog)

2013-08-01 17:03:22 connect

2013-08-01 17:03:23 connect

2013-08-01 17:03:29 connect

2013-08-01 17:08:02 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:02 1 1 T=000:04:00:000, RC=3,RCS=0, RB=126,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-08-01 17:08:02 disconnect

2013-08-01 17:08:03 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:03 1 1 T=000:04:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-08-01 17:08:03 disconnect

2013-08-01 17:08:03 1 1 SAgent::Disconnect: (4, 64)

2013-08-01 17:08:03 1 1 T=000:04:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-08-01 17:08:03 disconnect

2013-08-01 17:08:03 3 1 SERVICE_CONTROL_STOP

2013-08-01 17:08:03 PS_USERLOG__system log end (UserLog)

2013-08-01 17:08:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown
_______________________
Edit

I followed your tutorial correctly I believe it ran all the scripts contained in the topic.
[Dev]Matheus is offline  
Old 08/01/2013, 22:17   #18
 
nubness's Avatar
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
[Dev]Matheus, please edit your post and place the content of the logs in a spoiler. And for future reference, try to use spoilers on big posts.
nubness is offline  
Thanks
1 User
Old 08/01/2013, 22:19   #19
 
Philipp_'s Avatar
 
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
Quote:
Originally Posted by [Dev]Matheus View Post
Invalid object name 'PS_GameData.dbo.NewID'.
You did not follow my guide properly. You have to create a view in case to get my function working. Here is the query again, paste it into a new query window and simply execute it.
Code:
USE PS_GameData
GO
CREATE VIEW NewID
AS
SELECT NewID() AS NewID
Philipp_ is offline  
Thanks
3 Users
Old 08/01/2013, 22:36   #20
 
[Dev]Matheus's Avatar
 
elite*gold: 0
Join Date: May 2013
Posts: 60
Received Thanks: 44
Edit

Problem solved the "name already exists" just you run this query

Code:
USE PS_GameData
GO
CREATE VIEW NewID
AS
SELECT NewID() AS NewID
after performing all the steps.
Thanks, Philipp_
[Dev]Matheus is offline  
Old 08/02/2013, 05:31   #21
 
[Admin]ßІί†ž's Avatar
 
elite*gold: 0
Join Date: Dec 2009
Posts: 157
Received Thanks: 466
Nice, very nice release Philly :P
[Admin]ßІί†ž is offline  
Thanks
2 Users
Old 10/04/2013, 11:37   #22
 
nubness's Avatar
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
If you want them to start with 10 mil gold you should simply add

SET @Money = 10000000

before the SQL transaction start.
nubness is offline  
Thanks
1 User
Old 10/11/2013, 15:50   #23
 
elite*gold: 0
Join Date: Feb 2011
Posts: 295
Received Thanks: 18
shaiya euphoria down or what is the new link?
accuface35 is offline  
Old 10/11/2013, 16:23   #24
 
nubness's Avatar
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
Quote:
Originally Posted by accuface35 View Post
shaiya euphoria down or what is the new link?
Yea, we closed the server almost 3 months ago due to financial(and not only) issues.
nubness is offline  
Old 02/15/2014, 11:14   #25
 
elite*gold: 0
Join Date: Aug 2013
Posts: 9
Received Thanks: 0
I do not know that much and I can not do it: (
Please guide me with 1 video clip, thanks very much, sorry for my very bad english
emconyeu is offline  
Old 02/15/2014, 18:46   #26
 
Philipp_'s Avatar
 
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
It's explained pretty well - If your english skills cause your failure you should take some english lessons, because it's like a requirement for shaiya development.
Philipp_ is offline  
Thanks
4 Users
Old 02/11/2015, 19:11   #27
 
elite*gold: 0
Join Date: Jun 2014
Posts: 14
Received Thanks: 5
already performed all set up but when I create the character of a "name already exists" can anyone help me?
Parktutoriais is offline  
Old 02/12/2015, 14:26   #28
 
elite*gold: 50
Join Date: Sep 2011
Posts: 408
Received Thanks: 1,262
Check your logs.
JuuF is offline  
Old 03/08/2015, 03:00   #29
 
[DEV]Warlock's Avatar
 
elite*gold: 0
Join Date: Mar 2015
Posts: 3
Received Thanks: 0
Hello i followed all steps i did not get any error but when i go game nothing happen, so how can i do toon start with gears / accs and weps if you give some hand wpuld be really good and before i ask i have been tried other ways too but nothing happened
[DEV]Warlock is offline  
Old 03/08/2015, 15:45   #30
 
elite*gold: 260
Join Date: Sep 2011
Posts: 487
Received Thanks: 359
Quote:
Originally Posted by [DEV]Warlock View Post
Hello i followed all steps i did not get any error but when i go game nothing happen, so how can i do toon start with gears / accs and weps if you give some hand wpuld be really good and before i ask i have been tried other ways too but nothing happened
I guess your problem must be in that part:
Quote:
Originally Posted by Philipp_ View Post
Hello community,

Next we will take use of this and implement it in our usp_Create_Char_R procedure (located in PS_GameData).
Code:
INSERT INTO CharItems
SELECT @CharID AS CharID,ItemID,dbo.ItemUID() AS ItemUID,Type,TypeID,Bag,Slot,Quality,Gem1,Gem2,Gem3,Gem4,Gem5,Gem6,Craftname,1 AS COUNT,GETDATE() AS Maketime,'S' AS Maketype,0 AS Del
FROM PS_GameDefs.dbo.BaseGearsDefs WHERE Family = @Family AND Job = @Job AND Level = @Level
Paste the upper code right after the following line at the nearly end of your proc:
Code:
SET @CharID = IDENT_CURRENT('Chars')
Best regards,
Philipp.
SnickQ is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
[Euphoria Dev Team Release] Perfect Orange Stats Game Service
05/25/2021 - Shaiya PServer Guides & Releases - 119 Replies
Hello elitepvpers, After multiple requests, I decided to release the Perfect Orange Stats Service that we used on Shaiya Euphoria. Before releasing it, we decided to improve it a little bit, to make it even more powerful and flexible. Some of you might prefer the web based recreation service, we chose to create something different, it's purely game based, you don't have to go on any website to do apply Perfect Orange Stats to your items. The former players of Shaiya Euphoria loved it, it is...
5.1 Todesritter auf Starter Edition erstellen / Create Death Knight on Starter Acc's
01/03/2013 - WoW Exploits, Hacks, Tools & Macros - 17 Replies
Sehr geeehrte Damen und Herren. Auf einem Starter Account ist es eigentlich nicht möglich ein Todesritter zu erstellen. Doch mit dem 5.1 Patch ist es durch eine kleine Sicherheitslücke möglich, soviele Todesritter wie möglich zu erstellen. Allerdings bekommt man keine Erfahrung und man bleibt auf lvl55. Ihr könnt auf jedem beliebigen Realm ein Todesritter erstellen doch davor müsst ihr ein Todesritter auf dem Italienischen Realm: "Nemesis" erstellen, erst dann ist es auf jedem Realm...
[Release] PacketLogger Starter
08/10/2012 - Nostale Hacks, Bots, Cheats & Exploits - 41 Replies
Hier mein erster Release :) Es ist zwar nur ein kleines tool, wird jedoch vielen helfen denke ich :) Infos Es startet den Multiclient und ändert anschließend die VersionsNr. Zudem Injizieret er die dll automatisch. Somit muss man dies nicht mehr mit CE machen. http://www.abload.de/img/unbenanntogxfy.png
[Release] 190 gears
03/09/2011 - Zero - 12 Replies
190 gears + weps have fun:D /awarditem 90100209 Engine /awarditem 600269 armor /awarditem 700209 booster /awarditem 100259 thrusters /awarditem 90800209 hp mod /awarditem 90300199 cabin /awarditem 90600259 df mod
Selling Account + Gears + Gears & More Gears @ Snowwhite!
06/29/2010 - Conquer Online 2 Trading - 1 Replies
Server: Cinderella/Snowwhite (Tro) Gears: Sup +6 SDG/SDG -5 Ears lvl 112 (102HP) Sup +6 SDG -5 130 Necky lvl 130 (130HP) Sup +6 SDG/SDG Blade lvl 130 (142HP) Sup +6 SDG/SDG -3 Trojan Armor lvl 120 (130HP) GoodLuck -1 Sup +6 SDG/SDG -5 Sword lvl 130 (225HP) Sup +6 SGG/SGG -1 Fan



All times are GMT +2. The time now is 08:31.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.