ITEM_SEND_TBL Dont appear ingame email

[iii123]

PHP Code:

$query=sqlsrv_query($connC,"INSERT INTO ITEM_SEND_TBL (m_idPlayer,serverindex,Item_Name,Item_count) VALUES ('$user','01','Scroll of SProtect','1')",array(),array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));

QUERY SUCCESS
Register before enter ingame:

0000014 01 Scroll of SProtect 1 0 14 NULL 0 0 1 0000000 0 0 0 0 0 0 0 2014-04-28 20:44:04.787 NULL 0 NULL 0 0 0 0 0 0 0 0 0 0 0 0


Now I go ingame and dont appear nothing on Post Box...
Register after enter ingame:

0000014 01 Scroll of SProtect 1 0 14 NULL 0 0 1 0000000 0 0 0 0 0 0 1 2014-04-28 20:44:04.787 2014-04-28 20:45:50.720 0 NULL 0 0 0 0 0 0 0 0 0 0 0 0

[Sedrika]

I recommend the OnBuyingInfo function for this kind of creating items via web.

[iii123]

Where is it?
It is?

My server only accept sqlsrv_ functions, cant execute procedures from php.

EDIT:

PHP Query:

$query=sqlsrv_query($connC,"EXEC shopSendItem @m_idPlayer='0000014',@serverindex='01',@item_name ='Scroll of SProtect',@item_count='1',@item_id='10464'",array( ));
if( $query === false ) {
die( print_r( sqlsrv_errors(), true));
}else{
echo 'correcto';
}

It works, insert in database.

Still... coming ingame, dont work...


EDIT2:
Tried to modify OnBuyingInfo... and nothing too...

[xTwiLightx]

There won't appear a mail when you provide items over ITEM_SEND_TBL - this table just provides items to users when they log in.

If you want it like a mail, use the MAIL_STR (or MAIL_TBL)

[iii123]

#Fixed, thanks all ^^