Here is event (using Navicat events) i used in 1.3.6.0, couple month ago, to spawn coins via DB in Navicat once a hour, to those who online, using livemap:
- Code: Select all
INSERT INTO
containers(containers.ParentID, containers.ObjectTypeID, containers.Quality)
SELECT
`character`.RootContainerID,
1059,
100
FROM
nyu_online_players
INNER JOIN `character` ON nyu_online_players.CharacterID = `character`.ID
Hovewer user must to log off and connect again to see it on inventory. Also there was a problem to stuck coins properly, player must give coin to someone via trade window.
May not work in 1.4.0.2 and current version of livemap/TT mod eth.
Plz test.