Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 11:57

  • Please register to post and access all features, it's quick, easy and FREE!

 

[RELEASE] Inventory Viewer Query v1

Reply
 
Old   #16
 
elite*gold: 0
Join Date: Aug 2012
Posts: 312
Received Thanks: 252
But all the GM.tool posted here are in .net is not hard to modify them too


But i agree with you Raskim maybe if your tool is not look like the best tool you have practice and probably learn and that is the more important !



gr4ph0s is offline  
Old   #17
 
elite*gold: 0
Join Date: Nov 2011
Posts: 136
Received Thanks: 61
guys i didnt mean modifying another person work no
i meant the idea of his work like a new gm tool with a better features
and the gm tool ( official ) is a fortune if you get the log server working !



5405045 is offline  
Old   #18
 
elite*gold: 0
Join Date: Aug 2012
Posts: 312
Received Thanks: 252
I agree with you oficial web panel is very good for ban moderator or any else
gr4ph0s is offline  
Old   #19
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
Update:

Here is a MUCH more stream-lined version of my Inventory Viewer!

Inventory Viewing Query v2 [NIBBLER]
Code:
/*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
Hope you enjoy!


ismokedrow is offline  
Thanks
3 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
[RELEASE] Ingame Inventory Viewer
So... today Exsta, DrAg0n (from inforge) and I were discussing about how many people like going around praising about their "own creations", trying...
99 Replies - Metin2 PServer Guides & Strategies
[Release] Web Inventory Viewer
Hi e*pvp. I want to give You my php script. With it you can browse inventory in your webpage. Version 1:
32 Replies - Metin2 PServer Guides & Strategies
[Release] Rez Viewer V.1.0
Hallo Community, da ich immer probleme mit DTXViewer hatte (es mir zulange gedauert hat), habe ich aus langeweile mal was gebastelt. Screens ...
16 Replies - CrossFire
[Release]3D Map Viewer
Hey, ich hab mir die Mühe erstellt und einen 3D Map Viewer erstellt ^^ Leider kann er nur eine Unterteilung der Map auslesen, sprich nur eine...
61 Replies - Metin2 PServer Guides & Strategies
[RELEASE]Map-Viewer
Hier habe ich die Beta Version des Map-viewer zu Veröffentlichen. Mit diesem Tool könnt ihr euch Die Maps ansehen und verschiedene Informationen...
16 Replies - Metin2 PServer Guides & Strategies



All times are GMT +2. The time now is 11:57.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.