Auto Equipment

Quote:

Originally Posted by Syloxx i got a propper one for sale ;)

Quote:

Originally Posted by Locklyon Ignore Syloxx. The best auto equipment available at the moment for the public is akasch's Code: http://pastebin.com/2wegdaw4 -- Procedure http://pastebin.com/4M1msreH -- Table Insert into table: Code: INSERT INTO SRO_VT_SHARD.._RoyalItemPoolAutoEquipment SELECT 1, ID, CodeName128, TypeID1, TypeID2, TypeID3, TypeID4, ReqLevel1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, CASE WHEN Country = 1 THEN 1 ELSE 0 END FROM SRO_VT_SHARD.._RefObjCommon WHERE XX => XX -- Put statements Put your own statements to add the items with though they won't have any blues, unless you adjust the other params such as p1, p2, p3 etc and magparamnum and va is the stats

Quote:

Originally Posted by Locklyon Ignore Syloxx. The best auto equipment available at the moment for the public is akasch's Code: http://pastebin.com/2wegdaw4 -- Procedure http://pastebin.com/4M1msreH -- Table Insert into table: Code: INSERT INTO SRO_VT_SHARD.._RoyalItemPoolAutoEquipment SELECT 1, ID, CodeName128, TypeID1, TypeID2, TypeID3, TypeID4, ReqLevel1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, CASE WHEN Country = 1 THEN 1 ELSE 0 END FROM SRO_VT_SHARD.._RefObjCommon WHERE XX => XX -- Put statements Put your own statements to add the items with though they won't have any blues, unless you adjust the other params such as p1, p2, p3 etc and magparamnum and va is the stats

USE SRO_VT_LOG
CREATE TABLE _RefSyloxxAutoEquipment
(
      [Service] BIT NOT NULL
    , RefObjID INT NOT NULL
    , CodeName VARCHAR(128) NOT NULL
    , TypeID3 TINYINT NOT NULL
    , TypeID4 TINYINT NOT NULL
    , Rarity TINYINT NOT NULL
    , SlotIndex TINYINT NOT NULL
    , [Level] TINYINT NOT NULL
    , Gender TINYINT NOT NULL
    , Country BIT NOT NULL
    , OptLevel TINYINT NOT NULL
    , MagParamNum TINYINT NOT NULL
    , MagParam1 BIGINT NOT NULL
    , MagParam2 BIGINT NOT NULL
    , MagParam3 BIGINT NOT NULL
    , MagParam4 BIGINT NOT NULL
    , MagParam5 BIGINT NOT NULL
    , MagParam6 BIGINT NOT NULL
    , MagParam7 BIGINT NOT NULL
    , MagParam8 BIGINT NOT NULL
    , MagParam9 BIGINT NOT NULL
    , MagParam10 BIGINT NOT NULL
    , MagParam11 BIGINT NOT NULL
    , MagParam12 BIGINT NOT NULL
)

INSERT INTO _RefSyloxxAutoEquipment
SELECT RIPAQ.service
    , ROC.ID
    , ROC.CodeName128
    , ROC.TypeID3
    , ROC.TypeID4
    , CASE WHEN ROC.Rarity = 2 AND ROC.CodeName128 LIKE '%A_RARE%' THEN 1
           WHEN ROC.Rarity = 2 AND ROC.CodeName128 LIKE '%B_RARE%' THEN 2
           WHEN ROC.Rarity = 2 AND ROC.CodeName128 LIKE '%C_RARE%' THEN 3
           ELSE 0
      END AS Rarity
    , CASE WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 1 THEN 0
           WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 3 THEN 1
           WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 2 THEN 2
           WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 5 THEN 3
           WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 4 THEN 4
           WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 6 THEN 5
           WHEN ROC.TypeID3 = 6 AND ROC.TypeID4 BETWEEN 2 AND 16 THEN 6
           WHEN ROC.TypeID3 IN (4) AND ROC.TypeID4 IN (1,2) THEN 7
           WHEN ROC.TypeID3 IN (5,12) AND ROC.TypeID4 = 1 THEN 9
           WHEN ROC.TypeID3 IN (5,12) AND ROC.TypeID4 = 1 THEN 10
           WHEN ROC.TypeID3 IN (5,12) AND ROC.TypeID4 = 1 THEN 11
      END
    , ROC.ReqLevel1
    , CASE WHEN I.ReqGender = 1 THEN 1 WHEN I.ReqGender = 0 THEN 2 WHEN I.ReqGender = 2 THEN 0 END
    , ROC.Country
    , 7
    , RIPAQ.MagParamNum
    , RIPAQ.P1
    , RIPAQ.P2
    , RIPAQ.P3
    , RIPAQ.P4
    , RIPAQ.P5
    , RIPAQ.P6
    , RIPAQ.P7
    , RIPAQ.P8
    , RIPAQ.P9
    , 0
    , 0
    , 0
FROM SRO_VT_SHARD.dbo._RoyalItemPoolAutoEquipment RIPAQ
    JOIN SRO_VT_SHARD.dbo._RefObjCommon ROC ON RIPAQ.CodeName128 = ROC.CodeName128
    JOIN SRO_VT_SHARD.dbo._RefObjItem I ON ROC.Link = I.ID

/*
0 = HAT (1;2;3;9;10;11, 1)
1 = CHEST (1;2;3;9;10;11, 3)
2 = SHOULDER (1;2;3;9;10;11, 2)
3 = HANDS (1;2;3;9;10;11, 5)
4 = LEGS (1;2;3;9;10;11, 4)
5 = FOOT (1;2;3;9;10;11, 6)
6 = WEAPON (6, 2-16)
7 = SHIELD (4, 1;2)
9 = EARRING (5;12, 1)
10 = NECKLACE (5;12, 2)
11 = L-RING (5;12, 3)
12 = R-RING (5;12, 3)
*/

Quote:

Originally Posted by Syloxx nope, it isnt the best out there i had to replace it several times already because people wasn't happy with that just for example: level up sell item level down level up sell item level down etc etc i also have an checker so your sun items for example wont be replaced with sos items incase your sun stuff is better so don't say "the best equipment system is out there for free" if you don't have any clue at all ;) here you can see my table and even the converter from akaschs table into mine ;) Code: USE SRO_VT_LOG CREATE TABLE _RefSyloxxAutoEquipment ( [Service] BIT NOT NULL , RefObjID INT NOT NULL , CodeName VARCHAR(128) NOT NULL , TypeID3 TINYINT NOT NULL , TypeID4 TINYINT NOT NULL , Rarity TINYINT NOT NULL , SlotIndex TINYINT NOT NULL , [Level] TINYINT NOT NULL , Gender TINYINT NOT NULL , Country BIT NOT NULL , OptLevel TINYINT NOT NULL , MagParamNum TINYINT NOT NULL , MagParam1 BIGINT NOT NULL , MagParam2 BIGINT NOT NULL , MagParam3 BIGINT NOT NULL , MagParam4 BIGINT NOT NULL , MagParam5 BIGINT NOT NULL , MagParam6 BIGINT NOT NULL , MagParam7 BIGINT NOT NULL , MagParam8 BIGINT NOT NULL , MagParam9 BIGINT NOT NULL , MagParam10 BIGINT NOT NULL , MagParam11 BIGINT NOT NULL , MagParam12 BIGINT NOT NULL ) INSERT INTO _RefSyloxxAutoEquipment SELECT RIPAQ.service , ROC.ID , ROC.CodeName128 , ROC.TypeID3 , ROC.TypeID4 , CASE WHEN ROC.Rarity = 2 AND ROC.CodeName128 LIKE '%A_RARE%' THEN 1 WHEN ROC.Rarity = 2 AND ROC.CodeName128 LIKE '%B_RARE%' THEN 2 WHEN ROC.Rarity = 2 AND ROC.CodeName128 LIKE '%C_RARE%' THEN 3 ELSE 0 END AS Rarity , CASE WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 1 THEN 0 WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 3 THEN 1 WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 2 THEN 2 WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 5 THEN 3 WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 4 THEN 4 WHEN ROC.TypeID3 IN (1,2,3,9,10,11) AND ROC.TypeID4 = 6 THEN 5 WHEN ROC.TypeID3 = 6 AND ROC.TypeID4 BETWEEN 2 AND 16 THEN 6 WHEN ROC.TypeID3 IN (4) AND ROC.TypeID4 IN (1,2) THEN 7 WHEN ROC.TypeID3 IN (5,12) AND ROC.TypeID4 = 1 THEN 9 WHEN ROC.TypeID3 IN (5,12) AND ROC.TypeID4 = 1 THEN 10 WHEN ROC.TypeID3 IN (5,12) AND ROC.TypeID4 = 1 THEN 11 END , ROC.ReqLevel1 , CASE WHEN I.ReqGender = 1 THEN 1 WHEN I.ReqGender = 0 THEN 2 WHEN I.ReqGender = 2 THEN 0 END , ROC.Country , 7 , RIPAQ.MagParamNum , RIPAQ.P1 , RIPAQ.P2 , RIPAQ.P3 , RIPAQ.P4 , RIPAQ.P5 , RIPAQ.P6 , RIPAQ.P7 , RIPAQ.P8 , RIPAQ.P9 , 0 , 0 , 0 FROM SRO_VT_SHARD.dbo._RoyalItemPoolAutoEquipment RIPAQ JOIN SRO_VT_SHARD.dbo._RefObjCommon ROC ON RIPAQ.CodeName128 = ROC.CodeName128 JOIN SRO_VT_SHARD.dbo._RefObjItem I ON ROC.Link = I.ID /* 0 = HAT (1;2;3;9;10;11, 1) 1 = CHEST (1;2;3;9;10;11, 3) 2 = SHOULDER (1;2;3;9;10;11, 2) 3 = HANDS (1;2;3;9;10;11, 5) 4 = LEGS (1;2;3;9;10;11, 4) 5 = FOOT (1;2;3;9;10;11, 6) 6 = WEAPON (6, 2-16) 7 = SHIELD (4, 1;2) 9 = EARRING (5;12, 1) 10 = NECKLACE (5;12, 2) 11 = L-RING (5;12, 3) 12 = R-RING (5;12, 3) */

Quote:

Originally Posted by Locklyon I did mention it being publicly released and correct me if I'm wrong, yours isnt. I made my own, its faster, better etc but look its not public.

Quote:

Originally Posted by Locklyon Ignore Syloxx. The best auto equipment available at the moment for the public is akasch's Code: http://pastebin.com/2wegdaw4 -- Procedure http://pastebin.com/4M1msreH -- Table Insert into table: Code: INSERT INTO SRO_VT_SHARD.._RoyalItemPoolAutoEquipment SELECT 1, ID, CodeName128, TypeID1, TypeID2, TypeID3, TypeID4, ReqLevel1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, CASE WHEN Country = 1 THEN 1 ELSE 0 END FROM SRO_VT_SHARD.._RefObjCommon WHERE XX => XX -- Put statements Put your own statements to add the items with though they won't have any blues, unless you adjust the other params such as p1, p2, p3 etc and magparamnum and va is the stats

  INSERT INTO SRO_VT_SHARD.._RoyalItemPoolAutoEquipment
  SELECT 1, ID, CodeName128, TypeID1, TypeID2, TypeID3, TypeID4, ReqLevel1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0,  CASE WHEN Country = 1 THEN 1 ELSE 0 END
  FROM SRO_VT_SHARD.._RefObjCommon
  WHERE XX => XX -- Put statements

Quote:

Originally Posted by Mr.Rover error : Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '>'. while using : Code: INSERT INTO SRO_VT_SHARD.._RoyalItemPoolAutoEquipment SELECT 1, ID, CodeName128, TypeID1, TypeID2, TypeID3, TypeID4, ReqLevel1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, CASE WHEN Country = 1 THEN 1 ELSE 0 END FROM SRO_VT_SHARD.._RefObjCommon WHERE XX => XX -- Put statements

Quote:

Originally Posted by Locklyon Lol.. change "XX => XX" with your statements such as "WHERE TypeID1 = 3 AND TypeID2 = 1" etc in order to add all the items, I'm not free to write them all for you.

Quote:

Originally Posted by Locklyon Lol.. change "XX => XX" with your statements such as "WHERE TypeID1 = 3 AND TypeID2 = 1" etc in order to add all the items, I'm not free to write them all for you.