How to send item just for Online Players

04/01/2014 13:31 itdhos#1

Hi Guys !
Many times i asked to people in elitepvpers but no one respond me :(
i was search it but i cant find it >,<
if you know how to send item just for online players please share it :)
thx before :D

05/09/2014 19:46 DevParanoid#2

Code:

INSERT INTO [RohanGame].[dbo].[TEventItem] SELECT
           4722689 -- [type]
           ,0x00 -- attr
           ,2 -- stack
           ,0 -- rank
           ,0 -- equip level
           ,0 -- str
           ,0 -- dex
           ,0 -- int
           ,char_id -- char id
           , GETDATE() -- date
            FROM RohanGame.dbo.TCharacterLogin where login = 1

05/10/2014 15:20 PenguinJoe#3

Post your question here and I will be happy to answer you.
[Only registered and activated users can see links. Click Here To Register...]

I will no longer answer questions such as this outside of that thread.

05/11/2014 11:07 itdhos#4

Quote:

Originally Posted by DevParanoid

Code:

INSERT INTO [RohanGame].[dbo].[TEventItem] SELECT
           4722689 -- [type]
           ,0x00 -- attr
           ,2 -- stack
           ,0 -- rank
           ,0 -- equip level
           ,0 -- str
           ,0 -- dex
           ,0 -- int
           ,char_id -- char id
           , GETDATE() -- date
            FROM RohanGame.dbo.TCharacterLogin where login = 1

how abaut Login ID ?