[Tutorial] Vault activation

so why is this not working for invasion source. all i get is a code 5 error.

Not working on DNC for me. error code 7 wo api.

current session not disconected.

And why it nor work on infestation ?

Maybe because is not the same source file ?

hopefully we can figure this out.

http://www.youtube.com/watch?feature...;v=4wecm5P3XKI

Quote:

---

Originally Posted by Poster13

http://www.youtube.com/watch?feature=player_detailpage&v=4wecm5P3XKI

---

not really helping our problem is it.

Quote:

---

Originally Posted by Lewis Caddick

not really helping our problem is it.

---

I do not think I can only say that the code is not finished, it has a lot of things flaw for Dupe, and also when the player connects to the server and on its back a large backpack or small any more, your vault is not working) Sorry ((

Quote:

---

Originally Posted by Lewis Caddick

not really helping our problem is it.

---

Vault for DNC release: https://mega.co.nz/#!5gFnwQaK!cq72Gx...WwLXu449RVDFRk
WARNING THIS VAULT NOT FINISHED!

Quote:

---

Originally Posted by Poster13

http://www.youtube.com/watch?feature=player_detailpage&v=4wecm5P3XKI

---

it's in studio ? not server

to fix the bug and the backpack facinho friend.
see my example!

Code:

---

if(@in_Alive = 0) begin
                update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
                -- update of backpacks
                update UsersChars set BackpackID=20175, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20177, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20178, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20179, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20180, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20181, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20185, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20196, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20200, BackpackSize=12 where CharID=@in_CharID


                -- delete stuff from backpack
                delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID
        end

---

Quote:

---

Originally Posted by renildomarcio

to fix the bug and the backpack facinho friend.
see my example!

Code:

---

if(@in_Alive = 0) begin
        update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
        -- update of backpacks
        update UsersChars set BackpackID=20175, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20177, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20178, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20179, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20180, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20181, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20185, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20196, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20200, BackpackSize=12 where CharID=@in_CharID


        -- delete stuff from backpack
        delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID
    end

---

---

Thank you1 This is good work!

Quote:

---

Originally Posted by Poster13

Thank you1 This is good work!

---

I'm here to help the community ragezone friend!

update source for the invasionmmo :D

Code:

---




-- ----------------------------
-- Procedure structure for [WZ_Char_SRV_SetStatus]
-- ----------------------------


ALTER PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
        @in_CustomerID int,
        @in_CharID int,
        @in_Alive int,
        @in_GamePos varchar(256),
        @in_GameFlags int,
        @in_Health float,
        @in_Hunger float,
        @in_Thirst float,
        @in_Toxic float,
        @in_TimePlayed int,
        @in_XP int,
        @in_Reputation int,
        @in_GameDollars int,
        @in_Stat00 int,
        @in_Stat01 int,
        @in_Stat02 int,
        @in_Stat03 int,
        @in_Stat04 int,
        @in_Stat05 int,
        @in_SkillID0 int,
        @in_SkillID1 int,
        @in_SkillID2 int,
        @in_SkillID3 int,
        @in_SkillID4 int,
        @in_SkillID5 int,
        @in_SkillID6 int,
        @in_SkillID7 int,
        @in_SkillID8 int,
        @in_SkillID9 int,
        @in_SkillID10 int,
        @in_SkillID11 int,
        @in_SkillID12 int,
        @in_SkillID13 int,
        @in_SkillID14 int,
        @in_SkillID15 int,
        @in_SkillID16 int,
        @in_SkillID17 int,
        @in_SkillID18 int,
        @in_SkillID19 int,
        @in_SkillID20 int,
        @in_SkillID21 int,
        @in_SkillID22 int,
        @in_SkillID23 int,
        @in_SkillID24 int,
        @in_SkillID25 int,
        @in_SkillID26 int,
        @in_SkillID27 int,
        @in_SkillID28 int,
        @in_SkillID29 int,
        @in_SkillID30 int,
        @in_SkillID31 int,
        @in_SkillID32 int,
        @in_SkillID33 int
       
AS
BEGIN
        SET NOCOUNT ON;
       
        --
        -- this function should be called only by server, so we skip all validations
        --


        DECLARE @date datetime
        SET @date = DATEADD(second, -120, GETDATE())
       
        -- record last game update
        update UsersData set GameDollars=@in_GameDollars, lastgamedate=GETDATE() where CustomerID=@in_CustomerID


        -- update basic character data
        update UsersChars set
                GamePos=@in_GamePos,
                GameFlags=@in_GameFlags,
                Alive=@in_Alive,
                Health=@in_Health,
                Food=@in_Hunger,
                Water=@in_Thirst,
                Toxic=@in_Toxic,
                TimePlayed=@in_TimePlayed,
                LastUpdateDate=GETDATE(),
                XP=@in_XP,
                Reputation=@in_Reputation,
                Stat00=@in_Stat00,
                Stat01=@in_Stat01,
                Stat02=@in_Stat02,
                Stat03=@in_Stat03,
                Stat04=@in_Stat04,
                Stat05=@in_Stat05,
                SkillID0=@in_SkillID0,
                SkillID1=@in_SkillID1,
                SkillID2=@in_SkillID2,
                SkillID3=@in_SkillID3,
                SkillID4=@in_SkillID4,
                SkillID5=@in_SkillID5,
                SkillID6=@in_SkillID6,
                SkillID7=@in_SkillID7,
                SkillID8=@in_SkillID8,
                SkillID9=@in_SkillID9,
                SkillID10=@in_SkillID10,
                SkillID11=@in_SkillID11,
                SkillID12=@in_SkillID12,
                SkillID13=@in_SkillID13,
                SkillID14=@in_SkillID14,
                SkillID15=@in_SkillID15,
                SkillID16=@in_SkillID16,
                SkillID17=@in_SkillID17,
                SkillID18=@in_SkillID18,
                SkillID19=@in_SkillID19,
                SkillID20=@in_SkillID20,
                SkillID21=@in_SkillID21,
                SkillID22=@in_SkillID22,
                SkillID23=@in_SkillID23,
                SkillID24=@in_SkillID24,
                SkillID25=@in_SkillID25,
                SkillID26=@in_SkillID26,
                SkillID27=@in_SkillID27,
                SkillID28=@in_SkillID28,
                SkillID29=@in_SkillID29,
                SkillID30=@in_SkillID30,
                SkillID31=@in_SkillID31,
                SkillID32=@in_SkillID32,
                SkillID33=@in_SkillID33
               
        where CharID=@in_CharID
       
        if(@in_Alive = 0) begin
                update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
                                -- update of backpacks
                                update UsersChars set BackpackID=20175, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20177, BackpackSize=12 where CharID=@in_CharID
                                update UsersChars set BackpackID=20178, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20179, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20180, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20181, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20185, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20196, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20200, BackpackSize=12 where CharID=@in_CharID
                -- delete stuff from backpack
                delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID
        end


        select 0 as ResultCode
END

---

Quote:

---

Originally Posted by renildomarcio

to fix the bug and the backpack facinho friend.
see my example!

Code:

---

if(@in_Alive = 0) begin
        update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
        -- update of backpacks
        update UsersChars set BackpackID=20175, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20177, BackpackSize=12 where CharID=@in_CharID
        update UsersChars set BackpackID=20178, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20179, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20180, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20181, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20185, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20196, BackpackSize=12 where CharID=@in_CharID
                update UsersChars set BackpackID=20200, BackpackSize=12 where CharID=@in_CharID


        -- delete stuff from backpack
        delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID
    end

---

---

Where in the code should this be added?

Also I am getting this error when trying to compile.

http://oi42.tinypic.com/sdfhwn.jpg

skillid is for skill tree, so if you don't have don't take this code.

Quote:

---

Originally Posted by Stea1th

Where in the code should this be added?

Also I am getting this error when trying to compile.

http://oi42.tinypic.com/sdfhwn.jpg

---

it must be added in sql friend

I need Objects NPC Vault :):

I want to put in the studio vault sends 1 tutorial of how to put in the studio to add to the vault in the studio!