Stored Procedure Mssql 2000

Results 1 to 4 of 4
  1. #1
    Account Upgraded | Title Enabled! spatti88 is offline
    MemberRank
    Mar 2010 Join Date
    Poland ;)Location
    927Posts

    Stored Procedure Mssql 2000

    Code:
    You Must Added It in DataBase/KalDB/StoredProcedure:
    CREATE PROCEDURE SetPrefix
    
    
    @prefix int,
    @iid int
    
    AS
    
    
    declare @pid int
    declare @index int
    declare @bof_index int
    declare @bofindex1 int
    SET @pid = (SELECT PID FROM Item WHERE [IID] = @iid)
    SET @index = (SELECT [Index] FROM [Item] WHERE [IID] = @iid)
    SET @bof_index = (SELECT [BofIndex] FROM [BofTable] WHERE [Index] = @index)
    
    IF (@prefix = 113)
    begin
    --do a special thing, like make bound
    UPDATE [Item] SET Info = (Info|128) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 114)
    begin
    --do a special thing, like make unbound
    UPDATE [Item] SET Info = Info - (Info&128) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 115)
    begin
    --Stone of Demon Blood G3
    UPDATE [Item] SET Info = (Info|1310912) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 116)
    begin
    --Stone of Shadow G1
    UPDATE [Item] SET Info = (Info|524672) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 117)
    begin
    --Stone of Shadow G2
    UPDATE [Item] SET Info = (Info|1048960) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 118)
    begin
    --Stone of Holy G1
    UPDATE [Item] SET Info = (Info|524928) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 119)
    begin
    --Stone of Holy G2
    UPDATE [Item] SET Info = (Info|1049216) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 120)
    begin
    --Stone of Flame G1
    UPDATE [Item] SET Info = (Info|525440) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 121)
    begin
    --Stone of Flame G2
    UPDATE [Item] SET Info = (Info|1049728) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 122)
    begin
    --Stone of Ice G1
    UPDATE [Item] SET Info = (Info|526464) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 123)
    begin
    --Stone of Ice G2
    UPDATE [Item] SET Info = (Info|1050752) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 124)
    begin
    --Stone of Lightning G1
    UPDATE [Item] SET Info = (Info|528512) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 125)
    begin
    --Stone of Lightning G2
    UPDATE [Item] SET Info = (Info|1052800) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 126)
    begin
    --Stone of Poison G1
    UPDATE [Item] SET Info = (Info|532608) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 127)
    begin
    --Stone of Poison G2
    UPDATE [Item] SET Info = (Info|1057016) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 128)
    begin
    --Stone of Para G1
    UPDATE [Item] SET Info = (Info|540910) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 129)
    begin
    --Stone of Para G2
    UPDATE [Item] SET Info = (Info|1065088) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 130)
    begin
    --Stone of Str G1
    UPDATE [Item] SET Info = (Info|557184) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 131)
    begin
    --Stone of Str G2
    UPDATE [Item] SET Info = (Info|1081472) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 132)
    begin
    --Stone of Skill G1
    UPDATE [Item] SET Info = (Info|589952) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 133)
    begin
    --Stone of Skill G2
    UPDATE [Item] SET Info = (Info|1114240) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 134)
    begin
    --Stone of Mistery G3
    UPDATE [Item] SET Info = (Info|1179776) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 135)
    begin
    --[15]EB
    UPDATE [Item] SET UpgrLevel = 15 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 136)
    begin
    --[10]OTP
    UPDATE [Item] SET XHit = 10 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 137)
    begin
    --[15]Attack
    UPDATE [Item] SET XAttack = 15 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 138)
    begin
    --[15]Magic Attack
    UPDATE [Item] SET XMagic = 15 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 139)
    begin
    --[20]EB [20]Attack [20]OTP
    UPDATE [Item] SET UpgrLevel = 20, XHit = 20, XAttack = 20 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 140)
    begin
    --[15]EB [15]Attack [5]OTP [15]Magic
    UPDATE [Item] SET UpgrLevel = 15, XHit = 5, XAttack = 15, XMagic = 15, Prefix = 100 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 141)
    begin
    --Guild Time Reset
    UPDATE [GuildMember] SET Date = 0 WHERE PID = @pid
    end
    
    ELSE IF (@prefix = 142)
    begin
    --20/20/20/20 Red Claw
    UPDATE [Item] SET UpgrLevel = 20, XHit = 20, XAttack = 20, Prefix = 101 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 143)
    begin
    --Eb success chance 100% - UpgradeRate -> 100
    UPDATE [Item] SET UpgrRate = 100 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 144)
    begin
    --5 Def / 1 Eva[Armor] -> Players
    UPDATE [Item] SET XDefense = 5, XDodge = 1 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 145)
    begin
    --10 Def / 1Eva[Armor] -> Gm's
    UPDATE [Item] SET XDefense = 10, XDodge = 1 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 146)
    begin
    --10 Def / 1Eva / Red Claw / Db Mix G3[Armor] -> Gm's (kann bei zu viel parts probleme verursachen GLAUBE ich)
    UPDATE [Item] SET XDefense = 10, XDodge = 1, Prefix = (Info|1310720) WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 147)
    begin
    --20/20/255 Darkchaos - Pamz
    UPDATE [Item] SET UpgrLevel = 255, XHit = 20, XAttack = 20, Prefix = 100 WHERE IID = @iid
    end
    
    ELSE IF (@prefix = 148)
    begin
    if(@bof_index > 1)
    SET @bofindex1 = @bof_index
    else
    SET @bofindex1 = @index
    
    UPDATE Item SET [Index] = @bofindex1 WHERE [IID] = @iid
    end
    
    ELSE
    begin
    --Do the normal query
    UPDATE Item SET [Prefix] = @prefix WHERE [IID] = @iid
    end
    GO
    Code:
    In Config and Server Files Prefix:
    
    (prefix (index 113) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 114) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 115) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 116) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 117) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 118) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 119) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 120) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 121) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 122) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 123) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 124) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 125) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 126) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 127) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 128) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 129) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 130) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 131) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 132) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 133) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 134) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 135) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 136) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 137) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 138) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 139) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 140) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 141) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 142) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 143) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 144) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 145) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 146) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 147) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    (prefix (index 148) (level 0) (sell 50) (str 0) (Hth 0) (hit 0) (Int 0) (Dex 0) )
    Code:
    InitItem:
    
    (item (name 2390) (Index 1081) (Image "boundsp") (desc 9355)(class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 113)) )
    (item (name 2391) (Index 1082) (Image "unboundsp") (desc 9356) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 114)) )
    (item (name 2392) (Index 1083) (Image "item017") (desc 9357) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 115)) )
    (item (name 2393) (Index 1084) (Image "Item2020") (desc 9358) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 116)) )
    (item (name 2394) (Index 1085) (Image "Item2020") (desc 9359) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 117)) )
    (item (name 2395) (Index 1086) (Image "Item2030") (desc 9360) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 118)) )
    (item (name 2396) (Index 1087) (Image "Item2030") (desc 9361) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 119)) )
    (item (name 2397) (Index 1088) (Image "Item2040") (desc 9362) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 120)) )
    (item (name 2398) (Index 1089) (Image "Item2040") (desc 9363) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 121)) )
    (item (name 2399) (Index 1090) (Image "Item2050") (desc 9364) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1)(buy 0) (sell 1500) (specialty (changeprefix weapon 50 122)) )
    (item (name 2400) (Index 1091) (Image "Item2050") (desc 9365) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 123)) )
    (item (name 2401) (Index 1092) (Image "Item2060") (desc 9366) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 124)) )
    (item (name 2402) (Index 1093) (Image "Item2060") (desc 9367) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 125)) )
    (item (name 2403) (Index 1094) (Image "Item2070") (desc 9355) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 126)) )
    (item (name 2404) (Index 1095) (Image "Item2070") (desc 9369) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 127)) )
    (item (name 2405) (Index 1096) (Image "Item2080") (desc 9370) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 128)) )
    (item (name 2406) (Index 1097) (Image "Item2080") (desc 9371) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 129)) )
    (item (name 2407) (Index 1098) (Image "Item2090") (desc 9372) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 130)) )
    (item (name 2408) (Index 1099) (Image "Item2090") (desc 9373) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 131)) )
    (item (name 2409) (Index 1100) (Image "Item2100") (desc 9374) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 132)) )
    (item (name 2410) (Index 1101) (Image "Item2100") (desc 9375) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 133)) )
    (item (name 2411) (Index 1102) (Image "Item2110") (desc 9376) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 134)) )
    (item (name 2412) (Index 1103) (Image "Item017") (desc 9377) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 135)) )
    (item (name 2413) (Index 1104) (Image "item017") (desc 9378) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 136)) )
    (item (name 2414) (Index 1105) (Image "item0520") (desc 9379) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 137)) )
    (item (name 2415) (Index 1106) (Image "item0530") (desc 9380) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 50 138)) )
    (item (name 2416) (Index 1107) (Image "pimpsp") (desc 9381) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 139)) )
    (item (name 2417) (Index 1108) (Image "pimpsp") (desc 9382) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 140)) )
    (item (name 2418) (Index 1109) (Image "GTR") (desc 9383) (class general charm) (code 3 5 12 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 141)) )
    (item (name 2419) (Index 1110) (Image "boundsp") (desc 9384) (class general charm) (code 3 5 14 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix ornament 100 113)) )
    (item (name 2420) (Index 1111) (Image "unboundsp") (desc 9385) (class general charm) (code 3 5 14 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix ornament 100 114)) )
    (item (name 2421) (Index 1112) (Image "boundsp") (desc 9386) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix defense 100 113)) )
    (item (name 2422) (Index 1113) (Image "unboundsp") (desc 9387) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix defense 100 114)) )
    (item (name 2423) (Index 1114) (Image "item017") (desc 9388) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 142)) )
    (item (name 2424) (Index 1115) (Image "item017") (desc 9389) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 143)) )
    (item (name 2425) (Index 1116) (Image "pimpsp") (desc 9390) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix defense 100 144)) )
    (item (name 2426) (Index 1117) (Image "pimpsp") (desc 9387) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix defense 100 145)) )
    (item (name 2427) (Index 1118) (Image "pimpsp") (desc 9392) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix defense 100 146)) )
    (item (name 2428) (Index 1119) (Image "item1470") (desc 9393) (class general etc) (code 4 9 0 0) (country 2) (use 1) (plural 1) (buy 0) (sell 0) )
    (item (name 2429) (Index 1120) (Image "unboundsp") (desc 9394) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 147)) )
    (item (name 2430) (Index 1121) (Image "unboundsp") (desc 9395) (class general charm) (code 3 5 13 0) (country 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix defense 100 147)) )
    (item (name 2431) (Index 1122) (Image "Item2100") (desc 9396) (class general charm) (code 3 5 12 0) (country 0 1 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 147)) )
    (item (name 2432) (Index 1123) (Image "Item2100") (desc 9397) (class general charm) (code 3 5 12 0) (country 0 1 2) (use 1) (plural 1) (buy 0) (sell 1500) (specialty (Changeprefix weapon 100 148)) )
    Code:
    Message-E
    
    (prefixname 113 "Bound")
    (prefixname 114 "Unbound")
    (prefixname 115 "Demons Blood G3")
    (prefixname 116 "Shadow G1")
    (prefixname 117 "Shadow G2")
    (prefixname 118 "Holy G1")
    (prefixname 119 "Holy G2")
    (prefixname 120 "Flame G1")
    (prefixname 121 "Flame G2")
    (prefixname 122 "Ice G1")
    (prefixname 123 "Ice G2")
    (prefixname 124 "Lightning G1")
    (prefixname 125 "Lightning G2")
    (prefixname 126 "Poison G1")
    (prefixname 127 "Poison G2")
    (prefixname 128 "Para G1")
    (prefixname 129 "Para G2")
    (prefixname 130 "Strenght G1")
    (prefixname 131 "Strenght G2")
    (prefixname 132 "Skill G1")
    (prefixname 133 "Skill G2")
    (prefixname 134 "Mystic G3")
    (prefixname 135 "EB +15")
    (prefixname 136 "OTP +10")
    (prefixname 137 "Attack +15")
    (prefixname 138 "Magic +15")
    (prefixname 139 "Pimp 20/20/20/20")
    (prefixname 140 "Pimp 15/15/5")
    (prefixname 141 "Guild Time Reset")
    
    (prefixname 142 "Pimp 20/20/20/Tali")
    (prefixname 143 "EB Upgrade Rate 100%")
    (prefixname 144 "Pimp 5/1")
    (prefixname 145 "Pimp 10/1")
    (prefixname 146 "Pimp 10/1/Tali")
    
    (prefixname 147 "Pamzi's Pimped")
    
    (prefixname 148 "BoF")
    
    ;Talis
    
    ( itemname 2390 "Bound Talisman[Weapon]")
    ( itemname 2391 "Unbound Talisman[Weapon]")
    ( itemname 2392 "Talisman of Demons Blood G3")
    ( itemname 2393 "Talisman of Shadow G1")
    ( itemname 2394 "Talisman of Shadow G2")
    ( itemname 2395 "Talisman of Holy G1")
    ( itemname 2396 "Talisman of Holy G2")
    ( itemname 2397 "Talisman of Flame G1")
    ( itemname 2398 "Talisman of Flame G2")
    ( itemname 2399 "Talisman of Ice G1")
    ( itemname 2400 "Talisman of Ice G2")
    ( itemname 2401 "Talisman of Lightning G1")
    ( itemname 2402 "Talisman of Lightning G2")
    ( itemname 2403 "Talisman of Poison G1")
    ( itemname 2404 "Talisman of Poison G2")
    ( itemname 2405 "Talisman of Para G1")
    ( itemname 2406 "Talisman of Para G2")
    ( itemname 2407 "Talisman of Strenght G1")
    ( itemname 2408 "Talisman of Strenght G2")
    ( itemname 2409 "Talisman of Skill G1")
    ( itemname 2410 "Talisman of Skill G2")
    ( itemname 2411 "Talisman of Mystery G3")
    ( itemname 2412 "Talisman of EB [+15]")
    ( itemname 2413 "Talisman of OTP [+10] ")
    ( itemname 2414 "Talisman of Attack [+15]")
    ( itemname 2415 "Talisman of Magic [+15]")
    ( itemname 2416 "Talisman of Pimping [20/20/20]")
    ( itemname 2417 "Talisman of Pimping [15/15/15]")
    ( itemname 2418 "Guild Time Reset Talisman")
    ( itemname 2419 "Bound Talisman[Accessoir]")
    ( itemname 2420 "Unbound Talisman[Accessoir]")
    ( itemname 2421 "Bound Talisman[Armor]")
    ( itemname 2422 "Unound Talisman[Armor]")
    ( itemname 2423 "Talisman of Pimping[20/20/20/Mix/Tali]")
    ( itemname 2424 "Talisman of EB[Upgrate Rate]")
    ( itemname 2425 "Talisman of Pimping[5/1]")
    ( itemname 2426 "Talisman of Pimping[5/1]")
    ( itemname 2427 "Talisman of Pimping[10/1/Tali]")
    ( itemname 2428 "Upgrade Talisman[G65->G67]")
    ( itemname 2429 "Upgrade Talisman[G60->G65]")
    ( itemname 2430 "Talisman of Pimping[Pamzi]")
    ( itemname 2431 "BoF Talisman")
    ( itemname 2432 "Blabla")
    
    ( itemdesc 9355 "#3-----------------------#n#3Drag this Item on your Weapon - Bounds your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9356 "#3-----------------------#n#3Drag this Item on your Weapon - Unbounds your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9357 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9358 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9359 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9360 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9361 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9362 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9363 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9364 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9365 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9366 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9367 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9368 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9369 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9370 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9371 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9372 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9373 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9374 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9375 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9376 "#3-----------------------#n#3Drag this Item on your Weapon - Mixes your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9377 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9378 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9379 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9380 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9381 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9382 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9383 "#3-----------------------#n#3Drag this Item on your Weapon - Resets your Guild Time#n-----------------------#n#2Relog after success")
    ( itemdesc 9384 "#3-----------------------#n#3Drag this Item on your Accessoir - Bounds your Accessoir#n-----------------------#n#2Relog after success")
    ( itemdesc 9385 "#3-----------------------#n#3Drag this Item on your Accessoir - Unbounds your Accessoir#n-----------------------#n#2Relog after success")
    ( itemdesc 9386 "#3-----------------------#n#3Drag this Item on your Armor - Bounds your Armor#n-----------------------#n#2Relog after success")
    ( itemdesc 9387 "#3-----------------------#n#3Drag this Item on your Armor - Unbounds your Armor#n-----------------------#n#2Relog after success")
    
    ( itemdesc 9388 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your Weapon#n-----------------------#n#2Relog after success")
    ( itemdesc 9389 "#3-----------------------#n#3Drag this Item on your Weapon - Sets the Upgrade Rate on 100%#n-----------------------#n#2Relog after success")
    ( itemdesc 9390 "#3-----------------------#n#3Drag this Item on your Armor - Pimps your Armor#n-----------------------#n#2Relog after success")
    ( itemdesc 9391 "#3-----------------------#n#3Drag this Item on your Armor - Pimps your Armor#n-----------------------#n#2Relog after success")
    ( itemdesc 9392 "#3-----------------------#n#3Drag this Item on your Armor - Pimps your Armor#n-----------------------#n#2Relog after success")
    
    ( itemdesc 9394 "#3-----------------------#n#3Drag this Item on your Weapon - Upgrades your Weapon from G65 to G67#n-----------------------#n#2Relog after success")
    ( itemdesc 9395 "#3-----------------------#n#3Drag this Item on your Armor - Upgrades your Armor from G60 to G65#n-----------------------#n#2Relog after success")
    ( itemdesc 9396 "#3-----------------------#n#3Drag this Item on your Weapon - Pimps your weapon#n-----------------------#n#2Relog after success")
    
    ( itemdesc 9397 "#3-----------------------#n#3Drag this Item on your Weapon - Does BoF on it#n-----------------------#n#2Relog after success"0)
    Goodluck.
    Last edited by spatti88; 29-09-12 at 09:10 PM.


  2. #2
    Account Upgraded | Title Enabled! KingForex is offline
    MemberRank
    Nov 2009 Join Date
    200Posts

    Re: Stored Procedure Mssql 2000

    thanks ,but you have to say that " Credits go to sirix

  3. #3
    Member Anglewings is offline
    MemberRank
    Dec 2010 Join Date
    beijingLocation
    58Posts

    Re: Stored Procedure Mssql 2000

    thanks ^^

  4. #4
    Alpha Member Zen is offline
    MemberRank
    Dec 2006 Join Date
    MelbourneLocation
    2,291Posts

    Re: Stored Procedure Mssql 2000

    old and public.



Advertisement