[Release] Admin Panel

Page 2 of 3 1 2 3
03/29/2014 23:25 [DaE]Asew#16
What did you use to program this admin panel?
03/30/2014 07:41 nubness#17
Quote:
Originally Posted by [DaE]Asew View Post
What did you use to program this admin panel?
Visual C#
04/05/2014 13:33 QQers19#18
Quote:
Originally Posted by QQers19 View Post
Thank a lot for this release, is very helpful But it is possible somehow change item for another item with that? I mean Item Management-->Inventory/WH legendary Adamas Helmet to Goddess?
Ok i have some query for that

Check Item in WH<--That is hopeful with Admin panel to copy ItemUID
Code:
SELECT ItemName, usi.ItemID, ItemUID, usi.Type, usi.TypeID, usi.Slot, usi.Quality, Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, usi.Count, Maketime, Maketype FROM PS_GameData.dbo.UserStoredItems usi INNER JOIN PS_GameDefs.dbo.Items i ON usi.ItemID = i.ItemID WHERE UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE UserID = 'xxx') ORDER BY usi.Slot

Check Item in inventory<--That is hopeful with Admin panel to copy ItemUID
Code:
SELECT ItemName, ci.ItemID, ItemUID, ci.Type, ci.TypeID, Bag, ci.Slot, ci.Quality, Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, ci.Count, Maketime, Maketype FROM PS_GameData.dbo.CharItems ci INNER JOIN PS_GameDefs.dbo.Items i ON ci.ItemID = i.ItemID WHERE CharID = (SELECT TOP 1 CharID FROM PS_GameData.dbo.Chars WHERE CharName = 'xxx') ORDER BY Bag, ci.Slot

Change Items in Ivnentory:
Code:
UPDATE PS_GameData.dbo.CharItems SET Type = '21', TypeID = '35'  where (CharID = 'xxx') AND (Bag = '1') AND (Slot = '0')
Change items in WH
Code:
UPDATE PS_GameData.dbo.UserStoredItems SET Type = '16', TypeID = '205' where (UserUID = 'xxx') AND (Slot = '39')
04/07/2014 08:34 arjulie#19
This nice release you help the new starting shaiya developer :)


:) are you using vb.net or vb6
04/07/2014 09:09 Philipp_#20
Quote:
Originally Posted by arjulie View Post
are you using vb.net or vb6
Quote:
Originally Posted by nubness View Post
Visual C#
Question answered? You should read through the posts before you reply next time.
01/15/2015 20:02 _Diavolino_#21
he will certainely tell you to advance a little and to use SQL 2008 :) its the minimum today to use.
Regards
01/16/2015 20:01 DuZzi#22
work´s with sql 2012 thanks :)
01/16/2015 20:38 Cansas59#23
and 2008
01/17/2015 01:38 _Diavolino_#24
and 2014 :D
05/08/2015 16:08 -spAik-#25
Awesome release, Chris :)
06/22/2015 20:42 AxelMac#26
i have this problem.... when select last 30mins in chat log
[Only registered and activated users can see links. Click Here To Register...]
fix use this query ;)
03/29/2017 03:13 snowofdragon#27
This tool is not show all items in db(action-sent item to giftbox). i checked
08/15/2020 15:20 misterdr#28
Aaand here is the source code for this thingie :D
08/15/2020 17:21 anon112#29
Dont forget to press the thank you button for the awesome works
08/15/2020 20:11 sominus#30
Necroed a 2017 thread just to say c# can be reflected? :feelsbadman:
Page 2 of 3 1 2 3