commands phpmyadmin

[ItsMeMagic]

hello otlanders..
i wonder .
what is the command to add an item to a online player by phpmyadmin ?
since i cant give an item ingame to a x player because i cant log on a computer.
i would to give the item via phpmyadmin.
a magic plate armor for example?

 

[slaw]

Are you using Gesior Shop System? You got z_ots_comunication table in phpmyadmin?

If so, you can use this code:

INSERT INTO `z_ots_comunication` (`id`, `name`, `type`, `action`, `param1`, `param2`, `param3`, `param4`, `param5`, `param6`, `param7`, `delete_it`) VALUES
(1, 'Admin', 'login', 'give_item', '2160', '100', '', '', 'item', 'Item Name', '', 1);

 

[ItsMeMagic]

I have znote.
Can you explain to me what u should edit ?

 

[WibbenZ]

I have znote.
Can you explain to me what u should edit ?

Depends on your TFS versions, so please read the rules; Rules for the Support board
#5

ZnoteAAC/LUA at master · Znote/ZnoteAAC · GitHub

 

[ItsMeMagic]

tfs 1.2

 

[WibbenZ]

tfs 1.2

Okay in that case you do pretty much what @slawkens said, but with the Znote tables;

CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`type` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`count` int(11) NOT NULL,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB;

Just change the values and names from his query to the ones above, you might have to add / remove some.
Then you set the itemid etc etc

After that the player has to use the talkaction command.