what is the script for zen and stats?when someone is starts the game first time ?and where i put them sql analyzer then execute and thats it ?what db i choose?any answer i will really appreciate it
---------- Post added at 08:39 PM ---------- Previous post was at 07:10 PM ----------
bump it.i searched it but i cannot find it:(
---------- Post added at 08:41 PM ---------- Previous post was at 08:39 PM ----------
bump it.i searched it but i cannot find it:(
databases/MuOnline/Stored Procedures/WZ_CreateCharacter
300 = level up points for new caracterCode:/* 1) 橇肺矫廉疙 : WZ_CreateCharacter 2) 累诀老 : 2003. 09. 15. 3) 累诀磊疙 : 眠槛 4) 傈崔牢磊 : 拌沥沥焊, 某腐磐疙, 努贰胶 鸥涝, 己傍咯何 馆券沥焊 5) 馆券牢磊(Result) : 1 : 悼老 某腐磐疙 粮犁 2 : 后浇吩捞 粮犁 窍瘤 臼澜 3 何磐 ~ : SQL Error Code 6) 努贰胶 鸥涝 0 : 孺付过荤 16 : 孺扁荤 32 : 夸沥 48 : 付八荤 64:促农肺靛 7) VERSION 1 8) Last Update Date : 2004.06.15 2003.10.16 : 飘罚黎记 困摹 坷幅 (SaemSong) BEGIN TRAN 巩捞 甸绢啊扁 傈俊 悼老某腐疙 粮犁矫 ProcEnd 肺 GOTO 茄促 捞锭, ProcEnd俊急 费归捞唱 目乖阑 角青窍骨肺 牢秦 TranProcEnd甫 眠啊窍咯 飘罚璃记 贸府甫 窍瘤 臼绰 镑栏肺 GOTO茄促. */ CREATE Procedure WZ_CreateCharacter @AccountID varchar(10), --// 拌沥 沥焊 @Name varchar(10), --// 某腐磐 @Class tinyint --// Class Type AS Begin SET NOCOUNT ON SET XACT_ABORT ON DECLARE @Result tinyint --// 搬苞蔼 檬扁拳 SET @Result = 0x00 --==================================================================================== -- 某腐磐 粮犁咯何 犬牢 --==================================================================================== If EXISTS ( SELECT Name FROM Character WHERE Name = @Name ) begin SET @Result = 0x01 --// 悼老 某腐磐疙 粮犁 GOTO ProcEnd end BEGIN TRAN --==================================================================================== -- 拌沥 粮犁 咯何 犬牢 棺 后 浇吩 沥焊 犬牢窍咯 历厘 --==================================================================================== If NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID ) begin INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL) SET @Result = @@Error end else begin --// 某腐磐 后 浇吩 汲沥 Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10) SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID if( ( @g1 Is NULL) OR (Len(@g1) = 0)) begin UPDATE AccountCharacter SET GameID1 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g2 Is NULL OR Len(@g2) = 0) begin UPDATE AccountCharacter SET GameID2 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g3 Is NULL OR Len(@g3) = 0) begin UPDATE AccountCharacter SET GameID3 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g4 Is NULL OR Len(@g4) = 0) begin UPDATE AccountCharacter SET GameID4 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g5 Is NULL OR Len(@g5) = 0) begin UPDATE AccountCharacter SET GameID5 = @Name WHERE Id = @AccountID SET @Result = @@Error end else --// 秦寸 后 浇吩 沥焊啊 粮犁 窍瘤 臼促. begin SET @Result = 0x03 GOTO TranProcEnd end end --==================================================================================== -- 某腐磐 沥焊 历厘 --==================================================================================== if( @Result <> 0 ) begin GOTO TranProcEnd end else begin INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money ) SELECT @AccountID As AccountID, @Name As Name, Level, 300, @Class As Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,1000000 FROM DefaultClassType WHERE Class = @Class SET @Result = @@Error end TranProcEnd: -- GOTO IF ( @Result <> 0 ) ROLLBACK TRAN ELSE COMMIT TRAN ProcEnd: SET NOCOUNT OFF SET XACT_ABORT OFF --==================================================================================== -- 搬苞蔼 馆券 贸府 -- 0x00 : 某腐磐 粮犁, 0x01 : 己傍肯丰, 0x02 : 某腐磐 积己 角菩 , 0x03 : 后浇吩 粮犁窍瘤 臼绰促 --==================================================================================== SELECT CASE @Result WHEN 0x00 THEN 0x01 --// 己傍 馆券 WHEN 0x01 THEN 0x00 --// 某腐磐 粮犁 WHEN 0x03 THEN 0x03 --// 后浇吩捞 粮犁窍瘤 臼绰促. ELSE 0x02 --// 扁鸥 俊矾内靛绰 积己 圾菩 馆券 END AS Result End GO
1000000 = zen
and stats:
databases/MuOnline/Tables/DefaultClassType
Last edited by ThePunish3r; 27-05-10 at 11:17 PM.
and what about lvl up points what i put and where?
if you refere to: how manny points per level ... i am not shure but i think it has nothing to do with sql ... its in server ... i may be wrong ... i dont relly know that much about how everithing works in a MuOnline server (or any other game)... i just start learning hou to set up a mu server about 2 months ago :D
hi you change the points inOriginally Posted by TheUninvited
C:\MuServer\SCFData\SCF_Common
hope this helps
not that one xD just for start for instance 350 points like zen :P not always .
yes but i think he wanted to no how to have more level up points instead of 5 for elfs dw and bk and 7 for dl and mg :) i think lol
No problem dude^^
oops sorry i miss read :( :))
---------- Post added at 12:18 AM ---------- Previous post was at 12:15 AM ----------
Hi dont supose u can help me with my webpage :)
:D ... you whant to gain more points per level instaid of 5 fore BK fore example? ... hmm ... with the server files that i have that's easy too. i just have to edit them in SCF_common.ini ... so everithing that has to do with how manny points per level is in gs not in sql
what did i talk in ur profile xD i want the script which put just for starts zen not that scf common doesht called script.
What you want is an SQL Trigger which you run as a query on the MuOnline DataBase... you select which character class starts with a certain amount of zen... so you need to define zen amount and character class ID.
Fairy Elf = Class 32
Dark Knight = Class 16
Dark Wizard = Class 0
Hope this helps. And yes I do have the full script you need but I'm not sharing it with you because I don't like you. Yes I'm an asshole, what are u going to do about it. nothing
Re: Script Of Zen and stats problem
dude laughing my ass off here
btw fix your signature, how can u call urself greek and don't know how the heck to spell "ΕΛΛΗΝΑΣ"
oh btw, the stats,the levels, zen blabla when you create a character is all in the proc.
what about stats?
I have it too. Same thing, define class ID in sql trigger (which you create and run as query) and can add how many stat points you want new character to start with.
PS: I hope you die
still dont get it nvm
