[Release] Admin Panel

[[DaE]Asew]

What did you use to program this admin panel?

[nubness]

Originally Posted by [DaE]Asew

What did you use to program this admin panel?

Visual C#

[QQers19]

Originally Posted by QQers19

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

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

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:

UPDATE PS_GameData.dbo.CharItems SET Type = '21', TypeID = '35'  where (CharID = 'xxx') AND (Bag = '1') AND (Slot = '0')

Change items in WH

UPDATE PS_GameData.dbo.UserStoredItems SET Type = '16', TypeID = '205' where (UserUID = 'xxx') AND (Slot = '39')

[arjulie]

This nice release you help the new starting shaiya developer


are you using vb.net or vb6

[Philipp_]

Originally Posted by arjulie

are you using vb.net or vb6

Originally Posted by nubness

Visual C#

Question answered? You should read through the posts before you reply next time.

[_Diavolino_]

he will certainely tell you to advance a little and to use SQL 2008 its the minimum today to use.
Regards

[DuZzi]

work´s with sql 2012 thanks

[Cansas59]

and 2008

[_Diavolino_]

and 2014

[-spAik-]

Awesome release, Chris

[AxelMac]

i have this problem.... when select last 30mins in chat log

fix use this query

 Spoiler

ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN ChatTime datetime NOT NULL
ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN UserUID int
ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN CharID int
ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN ChatType tinyint
ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN TargetName varchar(30)
ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN ChatData varchar(128)
ALTER TABLE PS_CHATLOG.dbo.ChatLog ALTER COLUMN MapID tinyint
ALTER TABLE PS_CHATLOG.dbo.ChatLog DROP COLUMN ChatTime
ALTER TABLE PS_CHATLOG.dbo.ChatLog ADD ChatTime datetime NOT NULL DEFAULT (getdate())
GO

[snowofdragon]

This tool is not show all items in db(action-sent item to giftbox). i checked

[misterdr]

Aaand here is the source code for this thingie

[anon112]

Dont forget to press the thank you button for the awesome works

[sominus]

Necroed a 2017 thread just to say c# can be reflected?