How to send items to all accounts.Rohan

[exstrike1234]

Hi how can i send items directly to there event or item mall inventory? please need some help .

[Marvetick]

You have to create SQL statement which loops adding value to Rohangame .dbo. TEventItem for every user

[Dr.Dr.SheldonLeeCooper]

Originally Posted by exstrike1234

Hi how can i send items directly to there event or item mall inventory? please need some help .

GO
DECLARE @a Integer = 100
DECLARE @i Integer
SELECT @i = COUNT(id) FROM dbo.TCharacter
SET @i = @i + 100
WHILE (@a < @i)
BEGIN
INSERT INTO dbo.TEventItem (type, attr, stack, rank, equip_level, equip_dexterity, equip_intelligence, equip_strength, char_id) VALUES (0, 0, 0, 0, 0, 0, 0, 0, @a)
SET @a = @a + 1
END

Just change the 100 to your the first Char ID on your DB from dbo.TCharacter. It will count every Char on the Server and send it to Event Inventar.

[oziel235]

That's what Dr.Dr.SheldonLeeCooper Said is right. I did a little differently. Why? Simple no one will have access to the server. Only I.
I made a simple program in Java that logs on the server and gives you the options for those who send or even send to all.
An easy way is also using php, makes an Administrator page with the script does a FOREACH only for the ID_CHAR and within that FOR Insert SQL.

Each has a way I prefer more security

[zzerachiel]

It's a bit more elegant this way

INSERT INTO [RohanGame].[dbo].[TEventItem] SELECT
           1 -- [type]
           ,0x00 -- attr
           ,1 -- stack
           ,1 -- rank
           ,1 -- equip level
           ,1 -- str
           ,1 -- dex
           ,1 -- int
           ,id -- char id
           , GETDATE() -- date
            FROM RohanGame.dbo.TCharacter

[oziel235]

Originally Posted by zzerachiel

It's a bit more elegant this way

The only difference is that zzerachiel your code does not loop. Inserts one record at a time.
And as the question was to send items to all the accounts. Better place with Loop.

 

GO
 DECLARE @a Integer = 100
 DECLARE @i Integer
 SELECT @i = COUNT(id) FROM dbo.TCharacter
 SET @i = @i + 100

 WHILE (@a < @i)
 BEGIN
  INSERT INTO dbo.TEventItem (type, attr, stack, rank, equip_level, equip_dexterity, equip_intelligence, equip_strength, char_id) 
  VALUES (0, 0, 0, 0, 0, 0, 0, 0, @a)
  SET @a = @a + 1
END

[zzerachiel]

Since when looping a few thousand times is better than adding all of them at once?

Not to mention that with my code you don't need to know the starting character id, nor the end.

What would your code do if there are gaps in the character_id?

I mean, it's nice that you managed to get a one line statement and turn it into 10 lines, while loosing performance.

[oziel235]

Originally Posted by zzerachiel

Since when looping a few thousand times is better than adding all of them at once?

Not to mention that with my code you don't need to know the starting character id, nor the end.

What would your code do if there are gaps in the character_id?

I mean, it's nice that you managed to get a one line statement and turn it into 10 lines, while loosing performance.

You're right with the Loop loses a bit of performance.
But I replied the post with the Loop because unfortunately I couldn't run your code. may be I missed something. But it's not working for me

[zzerachiel]

Works.

All i said is that my code is a bit more elegant.

[oziel235]

Perfect!
But it's not working for me! -_-

[zzerachiel]

If you edited TEventItem structure, it won't work

[oziel235]

Something in my SQL Server was blocking I have a paid version ... installed some additional patch's dai stopped working the sql scripts. but now it's working is bug.

[moviper]

Originally Posted by zzerachiel

Works.

All i said is that my code is a bit more elegant.

omg!! what hell is that of pict .. seem i need re-school to understand it

[oziel235]

Originally Posted by moviper

omg!! what hell is that of pict .. seem i need re-school to understand it

is a SQL script to insert items in EventInventory.

[dedeernet]

Originally Posted by zzerachiel

It's a bit more elegant this way

INSERT INTO [RohanGame].[dbo].[TEventItem] SELECT
           1 -- [type]
           ,0x00 -- attr
           ,1 -- stack
           ,1 -- rank
           ,1 -- equip level
           ,1 -- str
           ,1 -- dex
           ,1 -- int
           ,id -- char id
           , GETDATE() -- date
            FROM RohanGame.dbo.TCharacter

How to send it if certain players?