- Joined
- Feb 27, 2013
- Messages
- 1,430
- Reaction score
- 201
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 :
Select Chest LIKE Avatar & Devil in your character :
Reset Character Mastery :
Some SRO Servers with fake current players on they website(s), So this is small fix.
Fix Fake Current Players Online :
Thread will be updated with new query(s)
Press (LIKE) If helped.
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 :
Code:
USE SRO_VT_SHARD
DECLARE @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name VARCHAR(32)
SET @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name = '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 @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name AND _Inventory.ItemID>0
ORDER BY _Inventory.Slo
Select Chest LIKE Avatar & Devil in your character :
Code:
USE SRO_VT_SHARD
DECLARE @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name VARCHAR(32)
SET @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name = '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 @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name AND _Chest.ItemID>0
ORDER BY _Chest.Slot
Reset Character Mastery :
Code:
USE SRO_VT_SHARD
DECLARE @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID int
SET @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID = 'CharID'
update _CharSkillMastery set Level = 0 WHERE CharID = @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID
delete _CharSkill where CharID = @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID 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
Code:
SET @[I][B][URL="http://forum.ragezone.com/members/77438.html"]Nuser[/URL][/B][/I]Count @[I][B][URL="http://forum.ragezone.com/members/77438.html"]Nuser[/URL][/B][/I]Count+[COLOR=#ff0000]Number[/COLOR]
- 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.
Last edited: