Select Item/Chest in Certain Character

[RenePunik]

Hello RaGEZONE legends, I've created simple query. You can see items,avatars,devils in a specific character.

Query created and fixed by me, It was results many DUMMY_OBJECTS , Now this gone. It displays currently active items.
RIGHT CREDITS : RenePunik


Select Items in your character :

USE SRO_VT_SHARD
DECLARE @CharName VARCHAR(32)
SET @CharName = 'CharName'
SELECT _Inventory.Slot, _RefObjCommon.CodeName128, _Items.OptLevel,   _Items.Data, _Items.Serial64 FROM _Char,  _Inventory,_Items,_RefObjCommon 
    WHERE _Inventory.ItemID=_Items.ID64 and  _Items.RefItemID=_RefObjCommon.ID and _Inventory.CharID=_Char.CharID AND  _Char.CharName16 @CharName AND _Inventory.ItemID>0
    ORDER BY _Inventory.Slo

Select Chest LIKE Avatar & Devil in your character :

USE SRO_VT_SHARD
DECLARE @CharName VARCHAR(32)
SET @CharName = 'CharName'    
SELECT _Chest.Slot, _RefObjCommon.CodeName128, _Items.OptLevel,  _Items.Data, _Items.Serial64 FROM _Char,  _Chest,_Items,_RefObjCommon,_User 
    WHERE _Chest.ItemID=_Items.ID64 and  _Items.RefItemID=_RefObjCommon.ID and _Chest.UserJID=_User.UserJID AND  _User.CharID=_Char.CharID AND _Char.CharName16 @CharName AND _Chest.ItemID>0
    ORDER BY _Chest.Slot

Reset Character Mastery :

USE SRO_VT_SHARD
DECLARE @CharID int
SET @CharID = 'CharID'
update _CharSkillMastery set Level = 0 WHERE CharID = @CharID 
delete _CharSkill where CharID = @CharID AND SkillId not in(select SkillID from _RefCharDefault_Skill)

Some SRO Servers with fake current players on they website(s), So this is small fix.
Fix Fake Current Players Online :

• Go to SRO_VT_ACCOUNT database.
• Open Programmability
• Modify _AddCurrentUserCount
• You will see this line

  SET @NuserCount @NuserCount+Number

• Red word, must be changed with (+0)
• See your website you will get REAL online players.

Thread will be updated with new query(s)
Press (LIKE) If helped.

[MentaL]

[thebigbody]

Hello RaGEZONE legends, I've created simple query. You can see items,avatars,devils in a specific character.

Query created and fixed by me, It was results many DUMMY_OBJECTS , Now this gone. only select items are currently on characters.
RIGHT CREDITS : RenePunik


Select Items in your character :

USE SRO_VT_SHARD
DECLARE @CharName VARCHAR(32)
SET @CharName = 'CharName'
SELECT _Inventory.Slot, _RefObjCommon.CodeName128, _Items.OptLevel,   _Items.Data, _Items.Serial64 FROM _Char,  _Inventory,_Items,_RefObjCommon 
    WHERE _Inventory.ItemID=_Items.ID64 and  _Items.RefItemID=_RefObjCommon.ID and _Inventory.CharID=_Char.CharID AND  _Char.CharName16 =   @CharName AND _Inventory.ItemID>0
    ORDER BY _Inventory.Slo

you have a wrong value in this query and it's with the RED LINE
very small wrong in writing won't make the query work
btw add at the last

ORDER BY Slot ASC

that would be better

then it will be like this at the end

USE SRO_VT_SHARD
DECLARE @CharName VARCHAR(32)
SET @CharName = ''
SELECT _Inventory.Slot, _RefObjCommon.CodeName128, _Items.OptLevel, _Items.Data, _Items.Serial64 FROM _Char, _Inventory,_Items,_RefObjCommon
WHERE _Inventory.ItemID=_Items.ID64 and _Items.RefItemID=_RefObjCommon.ID and _Inventory.CharID = _Char.CharID AND _Char.CharName16 = @CharName AND _Inventory.ItemID>0 order by Slot ASC

[RenePunik]

What's difference, Executing give same results.

[thebigbody]

What's difference, Executing give same results.

nope your query is wrong it misses "=" before @CharName i mentioned about in the previous comment
and the other difference is my last edition will just make it in sort
it will show the results in asc sort

[xxNukertube]

~^_^ old but nice

[RenePunik]

~^_^ old but nice

Thank you for commenting! Don't stop your mouse to give me LIKE