Kalonline request section

Page 59 of 59 FirstFirst ... 949515253545556575859
Results 871 to 874 of 874
  1. #871
    Enthusiast Jonwr is offline
    MemberRank
    Sep 2017 Join Date
    EveryWhere :)Location
    47Posts

    Re: Kalonline request section

    does anybudy , got SQL Query Start with item?

  2. #872
    Helper for everyone Ismir93 is offline
    MemberRank
    Oct 2010 Join Date
    BosniaLocation
    1,200Posts

    Re: Kalonline request section

    PHP Code:
    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE 
    [dbo].[CreatePlayer]

    @
    uid int,   [MENTION=1333344765]name[/MENTIONvarchar(14),   [MENTION=437263]clas[/MENTION]s tinyint,   [MENTION=1333337944]Strength[/MENTIONtinyint,   [MENTION=1333358440]Health[/MENTIONtinyint,   [MENTION=1333377165]Intelligence[/MENTIONtinyint,   [MENTION=775152]Wisdom[/MENTIONtinyint,   [MENTION=372998]dexterity[/MENTIONtinyint,
    @
    curhp smallint,
    @
    curmp smallint,
    @
    map tinyint,
    @
    x int,
    @
    y int,
    @
    z int,   [MENTION=12229]face[/MENTIONtinyint,   [MENTION=297467]Hai[/MENTION]r tinyint

    AS

    DECLARE @
    PID int
    DECLARE @GM int
    DECLARE  [MENTION=49]global[/MENTION]gm int
    DECLARE @itemid int
    DECLARE  [MENTION=829527]Start[/MENTION]items int
    DECLARE  [MENTION=1333341659]knightX[/MENTIONint
    DECLARE  [MENTION=112839]KnightY[/MENTIONint
    DECLARE @knightz int
    DECLARE @knightm int
    DECLARE  [MENTION=229454]mage[/MENTION]x int
    DECLARE  [MENTION=229454]mage[/MENTION]y int
    DECLARE  [MENTION=592500]magez[/MENTIONint
    DECLARE  [MENTION=229454]mage[/MENTION]m int
    DECLARE  [MENTION=3043]archer[/MENTION]x int
    DECLARE  [MENTION=3043]archer[/MENTION]y int
    DECLARE  [MENTION=3043]archer[/MENTION]z int
    DECLARE  [MENTION=3043]archer[/MENTION]m int

    --***************************************
    SET  [MENTION=829527]Start[/MENTION]items --set to 0 to disable
    --Knight*********************************
    SET  [MENTION=1333341659]knightX[/MENTION] = 257565 -- X Coord
    SET  
    [MENTION=112839]KnightY[/MENTION] = 259394 -- Y Coord
    SET 
    @knightz 16131 -- Z Coord
    SET 
    @knightm -- MAPfor normal world
    --Mage***********************************
    SET  [MENTION=229454]mage[/MENTION]257473 -- X Coord
    SET  
    [MENTION=229454]mage[/MENTION]259191 -- Y Coord
    SET  
    [MENTION=592500]magez[/MENTION] = 16080 -- Z Coord
    SET  
    [MENTION=229454]mage[/MENTION]-- MAPfor normal world
    --Archer*********************************
    SET  [MENTION=3043]archer[/MENTION]257254 -- X Coord
    SET  
    [MENTION=3043]archer[/MENTION]259242 -- Y Coord
    SET  
    [MENTION=3043]archer[/MENTION]16104 -- Z Coord
    SET  
    [MENTION=3043]archer[/MENTION]-- MAPfor normal world
    --***************************************


    --
    Start Koordinates für jedes Klasse extra zuweisen
    IF   [MENTION=437263]clas[/MENTION]0) --knight
       begin
       Set 
    @=  [MENTION=1333341659]knightX[/MENTION]
       
    Set @=  [MENTION=112839]KnightY[/MENTION]
       
    Set @= @knightz
       Set 
    @map = @knightm
       end
    ELSE IF   [MENTION=437263]clas[/MENTION]1) --mage
       begin
       Set 
    @=  [MENTION=229454]mage[/MENTION]x
       Set 
    @=  [MENTION=229454]mage[/MENTION]y
       Set 
    @=  [MENTION=592500]magez[/MENTION]
       
    Set @map =  [MENTION=229454]mage[/MENTION]m
       end
    ELSE IF   [MENTION=437263]clas[/MENTION]2) --archer
       begin
       Set 
    @=  [MENTION=3043]archer[/MENTION]x
       Set 
    @=  [MENTION=3043]archer[/MENTION]y
       Set 
    @=  [MENTION=3043]archer[/MENTION]z
       Set 
    @map =  [MENTION=3043]archer[/MENTION]m
       end
    set  
    [MENTION=775152]Wisdom[/MENTION] =  [MENTION=775152]Wisdom[/MENTION]+200
    --Charakter erstellen
    begin
    INSERT INTO Player 
    ( [UID], [Admin], [Name], [Class], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( @uid0,  [MENTION=1333344765]name[/MENTION],  [MENTION=437263]clas[/MENTION]s,  [MENTION=1333337944]Strength[/MENTION],  [MENTION=1333358440]Health[/MENTION]  [MENTION=1333377165]Intelligence[/MENTION]  [MENTION=775152]Wisdom[/MENTION],  [MENTION=372998]dexterity[/MENTION],@curhp,@curmp,  @map, @x, @y, @z,  [MENTION=12229]face[/MENTION],  [MENTION=297467]Hai[/MENTION]r)
    end

    --Jeder Klasse eigene Items geben
    IF   [MENTION=829527]Start[/MENTION]items 1)
    begin
    SET 
    @PID = (select max([PID]) from Player WHERE [UID] = @UID)
    SET @itemid =(select max([IID]) from Item)

       --
    common items
        
    IF (@itemid >= 1000000)
          
    begin
          SET 
    @itemid =(select max([IID]) from Item) + 1
          end
        
    ELSE
          
    begin
          SET 
    @itemid 1000000
          end


        INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid30220128100000000000)
        
    SET @itemid = @itemid 1
        INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid300901283000000000000)
        
    SET @itemid = @itemid 1
        INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid30000128100000000000)
        
    SET @itemid = @itemid 1
        INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid538012810000000000)
        
    SET @itemid = @itemid 1
        INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid471012810000000000)

    IF   [
    MENTION=437263]clas[/MENTION]0) --knight
       begin
          
    --weapon
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid61461291121208000008)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid67461291121208000008)
          --
    armor
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid4901291121200000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid50012918800000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid51012916600000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid52012918800000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid5301291101000000000)
          --
    baked eel
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid268012810000000000)
          
    INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES 23 5, @PID )
      
    end

    ELSE IF   [MENTION=437263]clas[/MENTION]2) --archer
       begin
          
    --weapon
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid64461291121200800008)
          --
    armor
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid5401291121200000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid55012918800000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid56012916600000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid57012918800000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid5801291101000000000)
             --
    baked eel
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid268012810000000000)
          
    INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES 3, @PID )
       
    end

    ELSE IF   [MENTION=437263]clas[/MENTION]1) --mage
       begin
          
    --weapon
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid98461291121208000008)
          --
    armor
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid8501291121200000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid86012918800000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid87012916600000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid88012918800000000)
          
    SET @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid8901291101000000000)
             --
    eel soup
          SET 
    @itemid = @itemid 1
          INSERT INTO Item 
    ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid268012810000000000)
          
    INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES 24 1, @PID )
       
    end
    end 
    - - - Updated - - -

    Quote Originally Posted by Jonwr View Post
    does anybudy , got SQL Query Start with item?
    there you go
    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[CreatePlayer]

    @uid int, @name varchar(14), @class tinyint, @Strength tinyint, @Health tinyint, @Intelligence tinyint, @Wisdom tinyint, @dexterity tinyint,
    @curhp smallint,
    @curmp smallint,
    @map tinyint,
    @x int,
    @y int,
    @z int, @face tinyint, @Hair tinyint

    AS

    DECLARE @PID int
    DECLARE @GM int
    DECLARE @globalgm int
    DECLARE @itemid int
    DECLARE @Startitems int
    DECLARE @knightX int
    DECLARE @KnightY int
    DECLARE @knightz int
    DECLARE @knightm int
    DECLARE @magex int
    DECLARE @magey int
    DECLARE @magez int
    DECLARE @magem int
    DECLARE @archerx int
    DECLARE @archery int
    DECLARE @archerz int
    DECLARE @archerm int

    --***************************************
    SET @Startitems = 1 --set to 0 to disable
    --Knight*********************************
    SET @knightX = 257565 -- X Coord
    SET @KnightY = 259394 -- Y Coord
    SET @knightz = 16131 -- Z Coord
    SET @knightm = 0 -- MAP, 0 for normal world
    --Mage***********************************
    SET @magex = 257473 -- X Coord
    SET @magey = 259191 -- Y Coord
    SET @magez = 16080 -- Z Coord
    SET @magem = 0 -- MAP, 0 for normal world
    --Archer*********************************
    SET @archerx = 257254 -- X Coord
    SET @archery = 259242 -- Y Coord
    SET @archerz = 16104 -- Z Coord
    SET @archerm = 0 -- MAP, 0 for normal world
    --***************************************


    --Start Koordinates für jedes Klasse extra zuweisen
    IF @class = 0) --knight
    begin
    Set @x = @knightX
    Set @y = @KnightY
    Set @z = @knightz
    Set @map = @knightm
    end
    ELSE IF @class = 1) --mage
    begin
    Set @x = @magex
    Set @y = @magey
    Set @z = @magez
    Set @map = @magem
    end
    ELSE IF @class = 2) --archer
    begin
    Set @x = @archerx
    Set @y = @archery
    Set @z = @archerz
    Set @map = @archerm
    end
    set @Wisdom = @Wisdom+200
    --Charakter erstellen
    begin
    INSERT INTO Player ( [UID], [Admin], [Name], [Class], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( @uid, 0, @name, @class, @Strength, @Health @Intelligence @Wisdom, @dexterity,@curhp,@curmp, @map, @x, @y, @z, @face, @Hair)
    end

    --Jeder Klasse eigene Items geben
    IF @Startitems = 1)
    begin
    SET @PID = (select max([PID]) from Player WHERE [UID] = @UID)
    SET @itemid =(select max([IID]) from Item)

    --common items
    IF (@itemid >= 1000000)
    begin
    SET @itemid =(select max([IID]) from Item) + 1
    end
    ELSE
    begin
    SET @itemid = 1000000
    end


    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3022, 0, 128, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3009, 0, 128, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3000, 0, 128, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 538, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 471, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )

    IF @class = 0) --knight
    begin
    --weapon
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 61, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 67, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
    --armor
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 49, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 50, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 51, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 52, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 53, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    --baked eel
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 23 , 5, @PID )
    end

    ELSE IF @class = 2) --archer
    begin
    --weapon
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 64, 46, 129, 1, 12, 12, 0, 0, 8, 0, 0, 0, 0, 8, 8 )
    --armor
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 54, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 55, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 56, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 57, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 58, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    --baked eel
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 6 , 3, @PID )
    end

    ELSE IF @class = 1) --mage
    begin
    --weapon
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 98, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
    --armor
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 85, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 86, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 87, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 88, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 89, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    --eel soup
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 24 , 1, @PID )
    end
    end

  3. #873
    Apprentice 3moegyx is online now
    MemberRank
    Dec 2019 Join Date
    16Posts
    would anyone reupload KWE please?

  4. #874
    Apprentice daim2604 is offline
    MemberRank
    Aug 2018 Join Date
    19Posts
    Quote Originally Posted by Ismir93 View Post
    Repack - Webadim Ultimate
    This is the Webadim Ultimate Full Repack
    PK Password: BLACK#NASE#ÖÖ
    https://mega.nz/file/fAYRSRZR#qZNui1...o_v5f2FEkLuQ0I

    This is the Paradise Kal Full Repack
    https://mega.nz/file/acpC0LBD#3OEjRt...bZlBWCe1yfdqzk
    Hi, do you still have these files? can you reupload please? thanks in advance



Advertisement