Help Php Send Item To Char Realtime

[martynasr08]

how to send any item to character using web PHP while he is online ? 

 

 

[mwn]

how to send any item to character using web PHP while he is online ? 

think this can inspire -> https://goo.gl/dULNXo

[Xeonc]

While player is online - there is no way to send the item in PTS

[eressea]

If you really need player to be online, you can use premium item system but it would require some work...

[giorgijorji]

think this can inspire -> https://goo.gl/dULNXo

for what chronicle is it? because Gracia Final Cashed refused it ...

 

and emca is right u can send item with simple code of php by inserting item in sql server database, into user_premium_item. if player online it needs just to restart, but as emca said it needs some work to make vitamin manager work not only for premium users

 

UPDATE.

yes this works, but item add works only if character is offline, just need some work to make it work even if char is online

Edited August 9, 2017 by giorgijorji

[Jojo_]

On 05/08/2017 at 10:13 PM, eressea said:

If you really need player to be online, you can use premium item system but it would require some work...

Well for curiousity I tried that method.
First add in e_premium_manager001.htm
this 

<a action="bypass -h menu_select?ask=1&reply=1"><font color="LEVEL">Receive vitamins items</font></a><br>

now with a builder charater does that : 

//premium_item new 0 20227 1
new is used to tell to add a new item in list
0 is id of premium item line

20227 is One-Eyed Bat Drove Agathion Pack
and 1 the amount of it

feel free to correct me if i am wrong

And now go check your Dimensional keeper press that added line (turn off html caching if you are not waiting to reboot server)
It will show you that tiny window with One-Eyed Bat Drove Agathion Pack.

Now what will try to find is a way to give that to all characters.
And right now I have no idea :)
Could be really userful for gift like xmas etc ~

[Jojo_]

Hi, I made a tiny SQL for that :)
 

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[user_premium_item]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[user_premium_item](
	[warehouse_no] [bigint] NOT NULL IDENTITY,
	[buyer_id] [int] NOT NULL,
	[buyer_char_id] [int] NULL,
	[buyer_char_name] [nvarchar](50) NULL,
	[recipient_id] [int] NOT NULL,
	[recipient_char_id] [int] NULL,
	[recipient_char_name] [nvarchar](50) NULL,
	[server_receive_date] [datetime] NOT NULL CONSTRAINT [DF_premium_service_server_receive_date]  DEFAULT (getdate()),
	[item_id] [int] NOT NULL,
	[item_amount] [bigint] NOT NULL,
	[item_remain] [bigint] NOT NULL,
	[ibserver_delete_date] [datetime] NULL,
 CONSTRAINT [PK_user_premium_item] PRIMARY KEY CLUSTERED 
(
	[warehouse_no] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO

INSERT INTO user_premium_item 
	(buyer_id,
	buyer_char_id,
	buyer_char_name,
	recipient_id,
	recipient_char_id,
	recipient_char_name,
	item_id,
	item_amount,
	item_remain,
	ibserver_delete_date)
SELECT
	<Builder Account ID>,
	<Builder Character ID>,
	'<Builder Charater Name>',
	uid,
	0,
	null,
	<Item ID>,
	<Quantity>,
	<Quandity left>,
	<Expire Date can be null>
FROM lin2db.dbo.user_account

it require to drop the table '[dbo].[user_premium_item]' to allow Warehouse_no to be auto_increment :)
It seem to work perfectly to me :)
Enjoy and feel free to correct and or use this tiny script as you wish ~ 
(No need to reboot only character will get notification when they relog, even if you drop the table :))
Also remove that create table part and leave insert when you want to give item only :))

Edit1: 
For players it will look like that  (yes my htm for dimensional is no correct I am aware)

Edited October 23, 2017 by Jojo_