PS_GameData -> Programmability -> Functions -> Scalar-valued Function and Delate dbo.ItemUID
Then the run
Then the run
[Euphoria Dev Team Release] Starter Gears
08/01/2013 22:09
[Dev]Optimum#16
08/01/2013 22:13
[Dev]Matheus#17
My logs
PS_DBAGENT
PS_GAME
PS_GAMELOG
PS_LOGIN
PS_SESSION
PS_USERLOG
_______________________
Edit
I followed your tutorial correctly I believe it ran all the scripts contained in the topic.
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
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
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
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
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
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.
08/01/2013 22:17
nubness#18
[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.
08/01/2013 22:19
Philipp_#19
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.Quote:
Invalid object name 'PS_GameData.dbo.NewID'.
Code:
USE PS_GameData GO CREATE VIEW NewID AS SELECT NewID() AS NewID
08/01/2013 22:36
[Dev]Matheus#20
Edit
Problem solved the "name already exists" just you run this query
after performing all the steps.
Thanks, Philipp_
Problem solved the "name already exists" just you run this query
Code:
USE PS_GameData GO CREATE VIEW NewID AS SELECT NewID() AS NewID
Thanks, Philipp_
08/02/2013 05:31
[Admin]ßІί†ž#21
Nice, very nice release Philly :P
10/04/2013 11:37
nubness#22
If you want them to start with 10 mil gold you should simply add
SET @Money = 10000000
before the SQL transaction start.
SET @Money = 10000000
before the SQL transaction start.
10/11/2013 15:50
accuface35#23
shaiya euphoria down or what is the new link?
10/11/2013 16:23
nubness#24
Yea, we closed the server almost 3 months ago due to financial(and not only) issues.Quote:
02/15/2014 11:14
emconyeu#25
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 :(
Please guide me with 1 video clip, thanks very much, sorry for my very bad english :(
02/15/2014 18:46
Philipp_#26
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.
02/11/2015 19:11
Parktutoriais#27
already performed all set up but when I create the character of a "name already exists" can anyone help me?
02/12/2015 14:26
JuuF#28
Check your logs.
03/08/2015 03:00
[DEV]Warlock#29
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
03/08/2015 15:45
SnickQ#30
I guess your problem must be in that part:Quote:
Quote:
Next we will take use of this and implement it in our usp_Create_Char_R procedure (located in PS_GameData).
Paste the upper code right after the following line at the nearly end of your proc: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
Best regards,Code:SET @CharID = IDENT_CURRENT('Chars')
Philipp.