Finding character IDs and deleting cash items

[xSpeedx]

Those are the only two problems I currently have. I can't find the IDs for each character and I don't know how to delete cash shop items which I cannot remove from the bag ingame (like the premium enhancement stone)

About the IDs, I found a thread in which a user said to open the characterinfo.dbo in MSSQL and look for the row of the character name one wants to have the ID from but do someone who's fairly knew to SQL in general, that didn't give away much info.

[MentaL]

[john007]

You can use the GM tool.

[Patchouli]

Character IDs are in CharacterInfo table. You can also see them as Owner, etc in other tables.

Try these queries to remove class restriction and make stuff destroyable.
update ItemClassInfo set ClassRestriction='1023'
update ItemClassInfo set Indestructible=0

You can also just go into your server item database, sort by ID and then delete stuff manually.

[xSpeedx]

Character IDs are in CharacterInfo table. You can also see them as Owner, etc in other tables.

Try these queries to remove class restriction and make stuff destroyable.
update ItemClassInfo set ClassRestriction='1023'
update ItemClassInfo set Indestructible=0

You can also just go into your server item database, sort by ID and then delete stuff manually.

Thanks, the query to make stuff destructible works. But how do I actually open the dbo.CharacterInfo table in SSMS? I can expand it on the left side but I don't see an actual table which shows the char names, IDs and whatever other info the table contains

[impunity]

Thanks, the query to make stuff destructible works. But how do I actually open the dbo.CharacterInfo table in SSMS? I can expand it on the left side but I don't see an actual table which shows the char names, IDs and whatever other info the table contains

Right click on dbo.CharacterInfo and click Edit Top 2000 Rows. Then you can edit.