How can we implement a new database table in flynax

[Steffen Buschkemper]

Hello Flynax team.

I have created a new table fl_citys in the database.
In this table there are the complete zip codes and citys from germany.
How can i integrate this in flynax admin panel.

I wrote a jQuery and php script that will simplify the user input.

Only registered members can view the code.

All works fine and The city is automatically inserted after the zip code input.
How can I integrate into flynax admin panel? The plz.php makes the database query.

The picture is the table structur.

[Mike]

Hi,

You have to implement manager for this data to the admin panel. I can't write all steps of it as it's not quick job, just main steps for creating new manager in AP.

Insert entry to admin_controls, lang_keys table

create two files with same name as database entries key

one file is php to get and save data to table
another file is tpl to display grid and other layout.

You can check how other pages in admin panel implemented and easier would be copy existing page and then change to make working with your table.

By the way:
Very nice feature, i like it

it's very useful feature and as well can be done even if you don't have zip codes database for your region (for others who interested better to create ticket) . or i can try to post solution similar to Steffen's here

[Steffen Buschkemper]

Hi Mike,

Thanks for your answer.
I need some help for this.
I have create 2 Files and insert phrase to lang_keys and extJs.
As example files i took transactions.tpl and transactions.inc.php.
Now i can see in Admin panel the new category -> PLZ & Stadt
Also i can see the search button and the search fields - all be fine.
But i can not see the table and entries.

This is my PHP Code

Only registered members can view the code.

Where is the Problem?

Best regards
Steffen