database command (PHPMYADMIN)

[Jamzitox]

I need to change an item to all players, would tell me how?

 

[8408323]

It's much easier to use a mod than add it through PHPMYADMIN

<?xml version="1.0" encoding="UTF-8"?>
<mod name="Items" author="8408323" enabled="yes">
	<config name="items_config"><![CDATA[
		config = {
			storage = 30001,
		}
	]]></config>

	<event type="login" name="Items" event="script"><![CDATA[
		domodlib('items_config')

		function onLogin(cid)
			if(getPlayerStorageValue(cid, config.storage) > 0) then
				return true
			end
				doPlayerAddItem(cid, [COLOR="#FF0000"]2650[/COLOR], 1)
			end
			setPlayerStorageValue(cid, config.storage, 1)
			return true
		end
	]]></event>
</mod>

Something like that should work. Just let me know if it doesn't work.

p.s just edit the red text "2650" to the item id that you want all players to get

 

[Jamzitox]

I do not want players to get, I want to change an item for another item

 

[Loney]

DELETE FROM player_items WHERE itemtype = 9999;

 

[ahmed30]

1st new id
2nd old id

UPDATE `player_items` SET `itemtype` = 1234 WHERE `itemtype` = 12345

 

[sn3ejk]

Also

UPDATE `player_depotitems` SET `itemtype` = 1000 WHERE `itemtype` = 1001;
UPDATE `tile_items` SET `itemtype` = 1000 WHERE `itemtype` = 1001