Server-wide Player Query - Items

[racegod]

Anyone have a query for mssql to add and item to all players? I've had it sometime before but lost it..

[MentaL]

[Jaren]

INSERT luna_gamedb.dbo.TB_ITEM (
ITEM_IDX,
ITEM_DURABILITY,
ITEM_SHOPIDX,
ITEM_POSITION,
ITEM_SEAL,
CHARACTER_IDX )
select
'XXXXXXXXX',
'1',
propid,
'0',
'0',
'0'
from luna_memberdb.dbo.chr_log_info