[Tutorial] Using server-side commands

[Aznkidd235]

It's pretty simple follow the instructions on the image to make it easier, but basically i select MMOChannelService, select the option in the toolbar and submit a command to the server. With these server files they don't use ItemID, it uses Item Class you must get the item file name example, "randomitem_avatar_sao_general_male_kirito" that is the Sword Art Online clothing bundle set. By using the PushItem command everyone who is logged onto the server will receive the items/gold.

You can find ItemClasses under heroesContent.db3, table ItemClassInfo.

Here are some items that you guys might be interested in:

cash_freepass_15_hair - Will give you any hair/color in the Avatar shop
cash_freepass_15_inner - Will give you any inner clothing in the Avatar shop

[MentaL]

[Meteorite]

Do you know how to clear the "cache" of this command?
For me, it continues to give ALL previously spawned items with every new command issued, so my inventory's pretty much been getting wrecked.

[Aznkidd235]

Do you know how to clear the "cache" of this command?
For me, it continues to give ALL previously spawned items with every new command issued, so my inventory's pretty much been getting wrecked.

I don't i'm still trying to figure out all the commands myself.

[Patchouli]

To clear the "cache" of the push command:
Look inside the "heroes" database on your server.
There'll be a table, "QueuedItem". In there are all the previous commands.
Using NaviCat, right click and selecting "empty table" will clear all the values.
Found and tested it myself. Seems to work.

[Meteorite]

To clear the "cache" of the push command:
Look inside the "heroes" database on your server.
There'll be a table, "QueuedItem". In there are all the previous commands.
Using NaviCat, right click and selecting "empty table" will clear all the values.
Found and tested it myself. Seems to work.

Nice find and thanks for sharing; this will make my inventory a lot less cancerous from now on.

[SanGawku]

If you don't want it to queue up, then use the HeroCommand service, Click the Other button with chinese text and it wont' queue up. It just pushes everything one time. Thats the way i do it

[Patchouli]

I figured it was one of those buttons that turned on queueing. Thanks.

Is there an easy way to get rid of inventory stuff I don't want?
It won't let me delete stuff in-game, and now I have 130+ pages of trash.

[SanGawku]

Delete from the database.

do a query like

Select * from Items where ownerid = 'your character id'

[Patchouli]

It wasn't showing that particular character ID for some reason, but I managed to find and delete the items now.
Thanks.

Edit: Figured out why I couldn't see some entries. Navicat only shows 1000 entries per page.

[IamTheWolk]

For me is the box empty, no commands :/

[john007]

I spammed these free hair and inner but didn't received. That's strange.

[Vargle]

I spammed these free hair and inner but didn't received. That's strange.

Pushing items is entirely case-sensitive so make sure you enter the item classes exactly.

[john007]

Pushing items is entirely case-sensitive so make sure you enter the item classes exactly.

Oh I see now, it was the item classes.

[aedaru]

No commands. Help please.

- - - Updated - - -

Never mind. It worked after fixing the workgroup stuff!

[jhonshaa]

removed
im lost