ITEM_SEND_TBL Dont appear ingame email

04/28/2014 20:46 iii123#1
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
04/28/2014 21:16 Sedrika#2
I recommend the OnBuyingInfo function for this kind of creating items via web.
04/28/2014 21:38 iii123#3
Where is it?
It is? [Only registered and activated users can see links. Click Here To Register...]

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...
04/28/2014 22:48 xTwiLightx#4
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)
04/28/2014 23:29 iii123#5
#Fixed, thanks all ^^