set zen in new char

how to set zen on char...when he create one char it will have lets say 1000000 zen in his inventory..

where i'm going to put the code..

http://forum.ragezone.com/f197/verry...pts-mu-344193/

Quote:

---

UPDATE Character
SET Money=('10000000')
WHERE Money<1

---

were i'm going to put this code it what file in the data...

can help me thx

It's a sql script, so you must use mssql.

But is useless for your case.
You want that every new character have 10000000 zen in his inventory, right?

Quote:

---

Originally Posted by bastard79

It's a sql script, so you must use mssql.

But is useless for your case.
You want that every new character have 10000000 zen in his inventory, right?

---

exacly...

You must edit the wz_createcharacter stored procedures.

You have something like

Code:

---

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, 0, @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,0
                        FROM  DefaultClassType WHERE Class = @Class                                       

                        SET @Result  = @@Error
                end

---

Change red value in 10000000

Quote:

---

Originally Posted by bastard79

You must edit the wz_createcharacter stored procedures.

You have something like

Code:

---

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, 0, @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,0
                        FROM  DefaultClassType WHERE Class = @Class                                       

                        SET @Result  = @@Error
                end

---

Change red value in 10000000

---

thank you so much I finally got it...xD