Grant items to players

[Talaysen]

I'd like to grant a couple of items to all of my players, and I'm trying to figure out the best way to do this.

I was looking at the 'Utility: Promotional Codes", which seemed promising, but people could keep creating accounts and redeeming that code, as there's no way to limit a code to a particular level or other similar requirement.

 

So, seems like the best option available would be to manually grant the items.

I should be able to do this through an SQL query, I'd imagine, but what's the best method?

I don't want to add items to player inventories, as I imagine if their inventory is full, it would be a problem.

 

It seems like adding items to storage is equally complicated, requiring that you check that their storage isn't full.

 

Is it possible to create/send mail to all players with their items?

[Talaysen]

Any suggestions appreciated.

[DarkIrata]

im not sure if it's possible to send items with mail from a script. 

Never tested it or thougt about it.

 

To check player level to make the code useable is easy, also check inventory / storage status.

 

If you want this as a ingame script (when the player spawn as example) i could make you one.

[Talaysen]

We had some intermittent downtime issues over the past few weeks and I wanted to reward all of the players with a little bonus, likely some exp manuals/bubblegums.

I was hoping to just grant the items with an SQL query, instead of implementing any new scripts, albeit, if that's what needs to be done, I suppose that'd be fine.

[DarkIrata]

It is possible with a sql query, but a script would be easyer and wouldnt make many problems aaaand faster.

[puding]

I suggest to you to do this via NPC Script PLUS SQL Query, since in MySQL the loop's condition (while, for) is not so easy.

 

Well I'm not an expert in SQL and I strongly suggest to do this on a secondary db. Here is the logic:

In Inventory you have each rows a unique player item. So to do that you must run a query that goes to the first "char_id" to the last one, creating each row for each player. So if you have 50 players, the loop will run 50 times.

 

    for(set @i, 150000, set @j, 3; @i <= 150060; set @i, @i + 1, set @j, @j + 1){
  
    query_sql " INSERT INTO `inventory`(`id`, `char_id`, `nameid`,
`amount`, `equip`, `identify`, `refine`, `attribute`, `card0`, `card1`,
`card2`, `card3`, `expire_time`, `favorite`, `bound`, `unique_id`)
VALUES ("+@j+","+@i+",ITEM ID,AMOUNT,0,0,0,0,0,0,0,0,0,0,0,0)";
    }

 

Mine for example:

 

If I had 5 players, will start at 150000 and end at 150005. And I need to respect the ID order.

 

Hope you get it, I dont know if this is correct

 

 

Edited June 30, 2013 by puding