VIP sql script

Hello all, i need some help with sql VIP script, it should look like that

UPDATE MEMB_INFO
SET SCFIsVip=1,SCFVipDays=7
FROM Character
WHERE cLevel<=5 and Resets<=1

or trigger like this:
--Auto VIP
CREATE TRIGGER Auto_VIP
ON [MuOnline].[dbo].[MEMB_INFO]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[MEMB_INFO]
SET [SCFIsVip] = 1
SET [SCFVipDays] = 7
WHERE [cLevel]<5 and [LevelUpPoint]<50 and [Resets]<1
Go

But now it gives VIP for everyone, but i need just for beginners, like you see until level five or above.
Thanks for any examples

PHP Code:

---

WHERE [cLevel]<5 and [LevelUpPoint]<50 and [Resets]<1 


---

WHERE

Level < 5

AND

LevelUpPoint < 50

AND

Resets < 1

Does this mean that everyone gets the VIP who has 5 levels and does not reset!

You have to change the condition for adding VIP, unless you want to get a VIP everybody who makes the 5 levels.

just edit the create character procedure

Quote:

---

Originally Posted by leorond

PHP Code:

---

WHERE [cLevel]<5 and [LevelUpPoint]<50 and [Resets]<1 


---

WHERE

Level < 5

AND

LevelUpPoint < 50

AND

Resets < 1

Does this mean that everyone gets the VIP who has 5 levels and does not reset!

You have to change the condition for adding VIP, unless you want to get a VIP everybody who makes the 5 levels.

---

It should be like a present for new players.

Yow excuse me wrong, I understand it.

Quote:

---

Originally Posted by leorond

PHP Code:

---

WHERE [cLevel]<5 and [LevelUpPoint]<50 and [Resets]<1 


---

WHERE

Level = 1

AND

Resets =0

Does this mean that everyone gets the VIP who has 5 levels and does not reset!

You have to change the condition for adding VIP, unless you want to get a VIP everybody who makes the 5 levels.

---

I correct it, that is only example what i need.

- - - Updated - - -

Quote:

---

Originally Posted by natzugen

just edit the create character procedure

---

Can you explain little bit more

natzugen means to edit wz_Createcharacter in stored procedures and modify it there

Code:

---


CREATE Procedure [dbo].[WZ_CreateCharacter] 
    @accountID        varchar(10),
    @name            varchar(10),
    @class            tinyint
 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
    If EXISTS ( SELECT  Name  FROM  BotPet 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, 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
TranProcEnd:    -- GOTO
    IF ( @result  <> 0 )
        ROLLBACK TRAN
    ELSE
        COMMIT    TRAN
ProcEnd:
    SET NOCOUNT OFF
    SET    XACT_ABORT OFF
    SELECT
      CASE @result
          WHEN 0x00 THEN 0x01
          WHEN 0x01 THEN 0x00
          WHEN 0x03 THEN 0x03
          ELSE 0x02
      END AS Result
End
GO

---

Ohhh it's little to hard for my, i'm not big expert in things like these...

[Help]
[Help] prefix it is one reason to make sure that you've seen the rules.Use [Help] prefix always when you wanna create a new Thread on Help Section.
You should be careful and go into specific details when it comes to giving a title to your problem in your post.


Topic sorted but next time please follow the rules.

you can't take data from memb-info and character like this:
UPDATE MEMB_INFO
SET SCFIsVip=1,SCFVipDays=7
FROM Character
WHERE cLevel<=5 and Resets<=1

try this:

Quote:

---

<?php
$query = mssql_query("Select *from character where

---

Quote:

---

Resets<=1 and cLevel <=5");
while($row = mssql_fetch_arrary($query))
{
mssql_query("Update MEMB_INFO Set SCFIsVip=1,SCFVipDays=7 where memb___id='$row[AccountID]'");
}
?>

---

reply me if doesnt work

Quote:

---

Originally Posted by getmylife1

you can't take data from memb-info and character like this:
UPDATE MEMB_INFO
SET SCFIsVip=1,SCFVipDays=7
FROM Character
WHERE cLevel<=5 and Resets<=1

try this:

reply me if doesnt work

---

Thank you very much, i will try little later, and let you know is it working.