Auto Equipment

~~Mr.Rover~~ · 07/16/2016, 18:48

i need a 100% working auto equipment system
anyone ?

Syloxx · 07/16/2016, 20:57

i got a propper one for sale

~~Mr.Rover~~ · 07/16/2016, 21:03

Quote:

Originally Posted by Syloxx

i got a propper one for sale

you always ask for money :3 -_-
thanks ... i need one free

AceSpace · 07/17/2016, 00:10

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

~~Mr.Rover~~ · 07/17/2016, 01:14

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

Thanks very much .... #closed

Syloxx · 07/17/2016, 13:52

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

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)
*/

AceSpace · 07/17/2016, 14:33

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)
*/

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.

Syloxx · 07/17/2016, 14:43

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.

well, mine is but not for free.

there is a difference between "not being public" and "you have to pay for it"

for example:

all my sql stuff is public for an amount of money but Joymax PSD files or even the VSRO 274 server files arent public at all... you can offer me any amount of money i wont sell them

~~Mr.Rover~~ · 07/17/2016, 15:46

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

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

AceSpace · 07/17/2016, 15:48

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

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.

~~Mr.Rover~~ · 07/17/2016, 15:56

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.

-_-

Syloxx · 07/17/2016, 16:14

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.

you see what i mean, that guy is creating an topic about ALL the errors he's facing

srsly he shouln't open a server or pay some1 with some experience...