How to Start Scripting Item Mall Official Files

[mcrolanson]

I want to develop Item Mall in Official server files. I have been searching on Procedures in character dbf and found some codes like in events and a new created char in the a specific time and date and the items are inserted. Like in CHARACTER_STR at the bottom line there is a code that inserts item in ITEM_SEND_TBL in a specific time is created or more. or even found some scripts/codes in PROCEDURES that inserts items in MAIL_TBL. I have done a tried this inserting the datas needed and tested but no avail to work. Its like it must be triggered so that the items that is new inserted is recognized in the live server running. I Really need help. Thanks

[MentaL]

[heathj]

if your on about an item mall like a donation panel or similar then you will need to use php to make a shopping cart type webpage whereby after using points or clicking apaying for what they want it inserts the item into their inventory ingame

[mcrolanson]

Items inserted in Mail is not recommeded. Ill go check on how to insert items on inventory. I hope i can procedures for these so it is easy to do. Or i will make procedures for it so it will be easy. Thanks. I may post back here if i need help again..

Thanks heathj.
Ill be releasing it here if my work is working.

[Mohanddo]

As far as i know rows inserted into [ITEM_SEND_TBL] will be appended to invetory however you have to relog for the item to be shown in the invetory. There must already be a stored procedure to do it without relogging since gpotato flyff store is able to do it.

[Mootie]

As far as i know rows inserted into [ITEM_SEND_TBL] will be appended to invetory however you have to relog for the item to be shown in the invetory. There must already be a stored procedure to do it without relogging since gpotato flyff store is able to do it.

Just use the ITEM_SEND_TBL. It is the easiest method and doesn't use the in-game shop(Gala would not like that much xD).

Here's the query I use:

INSERT [dbo].[ITEM_SEND_TBL]([m_idPlayer], [serverindex], [Item_Name], [Item_count], [idSender], [adwItemId0]) 
                                                      VALUES(N'$charid', N'01', N'$itemname0', $itemqty0, N'0000000', $itemid0)

Check out my item shop at demonflyff.com. It needs some work still though. (Do not go here unless you are the OP.) NOT ADVERTISING.

[elverloon]

Hello !

[ITEM_SEND_TBL] doesn't work in v14 file, anyone have solution for v14 files ?

[Imortal]

First off, yes it does, second off this thread is over a month old.