-
Start stat points and zen (With ScreenShot)! 300 point thing :)
Quote:
Originally Posted by
gradius
go to stored procedures of DB muonline and search for WZ_CreateCharacter and search this
Quote:
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,200000
FROM DefaultClassType WHERE Class = @Class
SET @Result = @@Error
THX to gradius!
http://shadowvzs87.uw.hu/upload/300point.JPG
double click to WZ_CreateCharacter
http://shadowvzs87.uw.hu/upload/300point1.JPG
-
Re: [Guide] Start stat points and zen! 300 point thing :)
"go to stored procedures of DB "
Can you tell me how to do that in a more noobish way? :)
-
Re: [Guide] Start stat points and zen! 300 point thing :)
Quote:
Originally Posted by
vaiben
"go to stored procedures of DB "
Can you tell me how to do that in a more noobish way? :)
its easy, i uploaded 2 screen shot
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Looks like good work to me :red_india Thanks for this very useful Guide.
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Nice guide for the new guyz :)
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Good & useful guide, Thanks.
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
nice but can be done even better
I can make it change anything .. like quest,inventory well anything .. even warehouse.. if someone needs this .. i can explain
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Quote:
Originally Posted by
Lincolin
nice but can be done even better
I can make it change anything .. like quest,inventory well anything .. even warehouse.. if someone needs this .. i can explain
so why didn't you open the guide because there where many questions about this in help section before
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Thank!
I need all guides of store procedures...!
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
jim3481
:D:D:D You Made Me Laughing :D:D:D
it doesn't need any guides.. just open up Procedures, Read it, Close it..
And then you can create some things like Create Character in Website , new Reset system or smth ^^
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Quote:
Originally Posted by
shadowvzs
so why didn't you open the guide because there where many questions about this in help section before
Was it ? ohh// sry didin't know .. I will make a guide on making a realy custom character creation :D... SQL ofcourse .. but olso can make one in php .. or a very custom reset script...
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
How to make that all new char, except DK would get points?
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
how to make it for this? 1.01e...
PHP Code:
CREATE procedure MX_CreateCharacter
@AccountID varchar(10),
@Name nvarchar(12),
@cLevel smallint,
@LevelUpPoint int,
@Class tinyint,
@Experience int,
@Strength int,
@Dexterity int,
@Vitality int,
@Energy int,
@Money int,
@Life real,
@MaxLife real,
@Mana real,
@MaxMana real,
@MapNumber smallint,
@MapPosX smallint,
@MapPosY smallint,
@MapDir tinyint
as
set nocount on
INSERT INTO Character
(AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, MDate,LDate,DbVersion
,zs_count
)
VALUES
(@AccountID, @Name, @cLevel, @LevelUpPoint, @Class, @Experience, @Strength, @Dexterity, @Vitality, @Energy, @Money, @Life, @MaxLife, @Mana, @MaxMana, @MapNumber, @MapPosX, @MapPosY, @MapDir, getdate(), getdate(), 1
,5
)
set nocount off
GO
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Great guide, thanks alot :)
-
Re: [Guide] Start stat points and zen (With ScreenShot)! 300 point thing :)
Hello, maybe this is old guide, very old guide, sorry for bump, but i just want help. I had same error 121. I know now, how to fix it.
Code:
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, 100, @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
Bold font shows changed items. 100 = level up points, 1000000 = starting zen and Money, you just needed to insert that ! Now it will work! :w00t::thumbup:
BTW: it doesnt funct in 1.2Q ! for me :(
-
2 Attachment(s)
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
How can I fix it, if your way to do it doesn't work for me, let me show you I can't get a good result...
By the way I am working with WZT Group Release I use 2 DB, MuOnline and MuLog
I thougth I could resolve this issue by makin a task to erase the 300 stat points, but if the player can see the 300 points, just doing a small change in points of any characteristic of his/her character, the task wont work...
Maybe i can try just changing 300 leveluppoints if level up points = 300 and Resets = 0 or working in a more complex query...
Any idea?....
I did a job, I know it is not the best way to fix it, but it would be until find anything else better and not laggy
Code:
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('28') and Dexterity=('20') and Vitality=('25') and energy=('10') and Resets=('0') and LevelUpPoint=('300')
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('18') and Dexterity=('18') and Vitality=('15') and energy=('30') and Resets=('0') and LevelUpPoint=('300')
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('22') and Dexterity=('25') and Vitality=('20') and energy=('15') and Resets=('0') and LevelUpPoint=('300')
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('26') and Dexterity=('26') and Vitality=('26') and energy=('26') and Resets=('0') and LevelUpPoint=('300')
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('26') and Dexterity=('20') and Vitality=('20') and energy=('15') and Resets=('0') and LevelUpPoint=('300')
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('26') and Dexterity=('26') and Vitality=('26') and energy=('26') and Resets=('0') and LevelUpPoint=('300')
UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('21') and Dexterity=('21') and Vitality=('18') and energy=('23') and Resets=('0') and LevelUpPoint=('300')
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
HELP ?! I dont have WZ_CreateCharacter in MuOnline stored procedures :grr::grr:
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
And what to do if you don't see that text when double clicking WZ_CreateCharacter ?
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
how aboout adding set or creits after register
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
Sorry for the bump, but I cant seem to get rid of the points...
I edited the procedure, but it still gives them...
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
wow, thanks alot. really nice :tongue:
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
how about what if starter item?instead of stats and zen?
-
Re: Start stat points and zen (With ScreenShot)! 300 point thing :)
thank you for this guide ^^
