Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

New Admin Features -- wish list :)

Quote Reply
New Admin Features -- wish list :)
Alex,

The new admin features are great!

How about integrating an "add table" feature to the admin? It shouldn't be too hard, since all the routines are there to work with the tables, what's missing is the 'create' table commands to create the .def file (unless I'm missing something)

I was able to create a couple of new tables, kludge the definition files, and add them to the admin_html file, and successfully modify, add and delete fields.

This is great!

Keyword tracking looks like it will be a dozen lines of code, if that Smile I just need to figure out the SQL commands <G> The perl part was/is easy.

Quote Reply
Re: New Admin Features -- wish list :) In reply to
I'll look at adding that feature into the admin. It's pretty easy to do in perl using the DBSQL module:

use Links: BSQL;
$db = new Links: BSQL '/path/to/Links.def';
$sth = $db->prepare ("CREATE TABLE STATEMENT");
$sth->execute;
$db->load_from_sql ('NewTableName');
$db->write_to_file ('/path/to/Newtable.def');

That will create the table and create a .def file for you.

Cheers,

Alex