-
Valued Member
[Help] Problem request sql : MAIL_TBL !
Hi
I tested this request sql but it's not work , not item in bank. 
Infos: idsender(0000000)is FLYFF.
INSERT INTO [MAIL_TBL](serverindex, nMail, idReceiver, idSender, nGold, tmCreate, byRead, szTitle,
szText, dwItemId, nItemNum, nRepairNumber, nHitPoint, nMaxHitPoint, nMaterial, byFlag, dwSerialNumber,
nOption, bItemResist, nResistAbilityOption, idGuild, nResistSMItemId, bCharged, dwKeepTime,
nRandomOptItemId, nPiercedSize, dwItemId1, dwItemId2, dwItemId3, dwItemId4, SendDt, ReadDt, GetGoldDt,
DeleteDt, ItemFlag, ItemReceiveDt, GoldFlag, bPet, nKind, nLevel, dwExp, wEnergy, wLife,
anAvailLevel_D, anAvailLevel_C, anAvailLevel_B, anAvailLevel_A, anAvailLevel_S, dwItemId5)
values
('01','13000','0000228','0000000','0','1272566896','0','','','22500','1','0','-1','0','0','0','777225466','0','0','0','0','0','0','0','0','0','0','0','0','0','29/04/2010 19:48:16',NULL,NULL,NULL,'0',NULL,'0','0','0','0','0','0','0','0','0','0','0','0','0')
Have you an idea please? Thanks.
Last edited by Looky; 30-04-10 at 12:19 PM.
-
-
Account Upgraded | Title Enabled!
Re: [Help] Problem request sql : MAIL_TBL !
You cannot directly insert mail messages into the database. You have to restart the server for them to show up.
If you're trying to send items to people from a website, use the 'ITEM_SEND_TBL' instead.
-
Valued Member
Re: [Help] Problem request sql : MAIL_TBL !
Ok thanks