[RELEASE] NIBBLER v2|FLEXO v1|KIFF v1|LEELU v1|LARS v1

[ismokedrow]

Here is some queries for those who don't really care about the GM-TOOL

!! WARNING THESE QUERIES ARE BASED OFF AND TESTED ON 6.1 !!

If you don't agree with this post and/or find it useful, do us all a favor and keep going without leaving a response. Thank you!

If you include these queries in any program/website or post them to any other website be a sport and give a link back to this thread or credits to iSmokeDrow

If you would like a query updated (7.3/7.4) for you please send me a private message, do NOT post your request in this thread. Thank you!

---------------------------------------------------------------

To ensure proper usage of the queries, make sure to copy the desired code into a New Query window that was called from the root of your server.
e.g.



NIBBLER - Inventory Viewer

 Spoiler

Screenshot:

/*NIBBLER [Inventory Viewer v2]*/
/*Created by: iSmokeDrow*/
/*Revisements Contributed by: Glandu2, Haxti*/
/*Purpose: Viewing Player Inventories*/
/*Change Notes: Execution time reduced significantly (77 records @ 2 seconds)*/

/*To use, edit @owner_name = 'ENTER CHARACTER NAME HERE' to the desired Character Name and execute*/
DECLARE @owner_name NVARCHAR(55)
SET @owner_name = 'ENTER CHARACTER NAME HERE'

/*DO NOT EDIT ANYTHING BELOW*/
SELECT INVENTORY.owner_id, CHAR.name as owner_name, CHAR.account, STRINGRES.value as item_name,
INVENTORY.Code as item_id, INVENTORY.cnt as amount, INVENTORY.level, INVENTORY.enhance as enchant_lv,
INVENTORY.wear_info as equipment_slot, INVENTORY.socket_0, INVENTORY.socket_1, INVENTORY.socket_2, 
INVENTORY.socket_3, INVENTORY.remain_time, INVENTORY.update_time, ITEMRES.icon_file_name
FROM Telecaster.dbo.Item INVENTORY 
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.sid = INVENTORY.owner_id 
INNER JOIN Arcadia.dbo.ItemResource ITEMRES
on ITEMRES.id = INVENTORY.code
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = ITEMRES.name_id
WHERE CHAR.name = @owner_name
ORDER BY INVENTORY.owner_id ASC

FLEXO - Warehouse Viewer

 Spoiler

Screenshot:

/*FLEXO [Warehouse Viewer v1]*/
/*Created by: iSmokeDrow*/
/*Purpose: Viewing Player Warehouse*/

/*To use, edit @owner_name = 'ENTER CHARACTER NAME HERE' to the desired Character Name and execute*/
DECLARE @owner_name NVARCHAR(55)
SET @owner_name = 'ENTER CHARACTER NAME HERE'

/*DO NOT EDIT ANYTHING BELOW*/
SELECT INVENTORY.account_id, CHAR.name as owner_name, CHAR.account, STRINGRES.value as item_name,
INVENTORY.Code as item_id, INVENTORY.cnt as amount, INVENTORY.level, INVENTORY.enhance as enchant_lv,
INVENTORY.wear_info as equipment_slot, INVENTORY.socket_0, INVENTORY.socket_1, INVENTORY.socket_2, 
INVENTORY.socket_3, INVENTORY.remain_time, INVENTORY.update_time, ITEMRES.icon_file_name
FROM Telecaster.dbo.Item INVENTORY 
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.account_id = INVENTORY.account_id 
INNER JOIN Arcadia.dbo.ItemResource ITEMRES
on ITEMRES.id = INVENTORY.code
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = ITEMRES.name_id
WHERE CHAR.name = @owner_name 
ORDER BY INVENTORY.account_id ASC

KIFF - Skill Viewer

 Spoiler

Screenshot:

/*KIFF [Skill Viewer v1]*/
/*Created by: iSmokeDrow*/
/*Purpose: Viewing Player Skills*/

/*To use, edit @owner_name = 'ENTER CHARACTER NAME HERE' to the desired Character Name and execute*/
DECLARE @owner_name NVARCHAR(55)
SET @owner_name = 'ENTER CHARACTER NAME HERE'

/*DO NOT EDIT ANYTHING BELOW*/
SELECT PLAYERSKILL.owner_id, CHAR.name, CHAR.account, STRINGRES.value, 
PLAYERSKILL.skill_id, PLAYERSKILL.SKILL_LEVEL 
FROM Telecaster.dbo.skill PLAYERSKILL 
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.sid = PLAYERSKILL.owner_id 
INNER JOIN Arcadia.dbo.SkillResource SKILLRES
on SKILLRES.id = PLAYERSKILL.skill_id
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = SKILLRES.text_id
WHERE CHAR.name = @owner_name 
ORDER BY PLAYERSKILL.owner_id ASC

LEELU - Summon Viewer

 Spoiler

Screenshot:

/*LEELU [Summon Viewer v1]*/
/*Created by: iSmokeDrow*/
/*Purpose: Viewing Player Skills*/

/*To use, edit @owner_name = 'ENTER CHARACTER NAME HERE' to the desired Character Name and execute*/
DECLARE @owner_name NVARCHAR(55)
SET @owner_name = 'ENTER CHARACTER NAME HERE'

/*DO NOT EDIT ANYTHING BELOW*/
SELECT PLAYERSUMMON.owner_id, CHAR.name as owner_name, CHAR.account as owner_account, 
PLAYERSUMMON.name as pet_name, PLAYERSUMMON.TRANSFORM as evolution, STRINGRES.value as evo_name, 
PLAYERSUMMON.LV, PLAYERSUMMON.JLV, PLAYERSUMMON.JP
FROM Telecaster.dbo.Summon PLAYERSUMMON 
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.sid = PLAYERSUMMON.owner_id 
INNER JOIN Arcadia.dbo.SummonResource SUMMONRES
on SUMMONRES.id = PLAYERSUMMON.CODE
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = SUMMONRES.name_id
WHERE CHAR.name = @owner_name 
ORDER BY PLAYERSUMMON.owner_id ASC

LARS - Belt Pet Viewer

 Spoiler

Screenshot:

/*LARS [Belt Pet Viewer v1]*/
/*Created by: iSmokeDrow*/
/*Purpose: Viewing Player Belt Pets*/

/*To use, edit @owner_name = 'ENTER CHARACTER NAME HERE' to the desired Character Name and execute*/
DECLARE @owner_name NVARCHAR(55)
SET @owner_name = 'ENTER CHARACTER NAME HERE'

/*DO NOT EDIT ANYTHING BELOW*/
SELECT SUMMON.owner_id, CHAR.name as owner_name, SUMMON.name as pet_name,
SUMMON.TRANSFORM as evo, STRINGRES.value as card_name, SUMMON.code as creature_id,
SUMRES.card_id
FROM Telecaster.dbo.Character PLAYERBELT
INNER JOIN Telecaster.dbo.Summon SUMMON
on SUMMON.CARD_UID = PLAYERBELT.belt_00 OR SUMMON.CARD_UID = PLAYERBELT.belt_01
OR SUMMON.CARD_UID = PLAYERBELT.belt_02 OR SUMMON.CARD_UID = PLAYERBELT.belt_03
OR SUMMON.CARD_UID = PLAYERBELT.belt_04 OR SUMMON.CARD_UID = PLAYERBELT.belt_05
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.sid = SUMMON.OWNER_ID
INNER JOIN Arcadia.dbo.SummonResource SUMRES
on SUMRES.id = SUMMON.code
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = SUMRES.name_id
WHERE PLAYERBELT.name = @owner_name*
ORDER BY PLAYERBELT.sid ASC

I will only assist competent people with updating these queries for 7.3/7.4 servers! This however is NOT A SUPPORT/DISCUSSION/HELP thread!

Credits/Shout-Outs:

Marek: For getting me interested in making such a complex query in the first place
Glandu2: For pointing out a method to stream-line the queries
Haxti: For reminding me of Declared Variables (used in search credentials)

[marekrndr]

Gooooooo FUTURAMA!

[haxti]

Sexy Querys and thanks for mentioning me

/free bump

[iPwnStar]

good job.