Gossamer Forum
Quote Reply
Tables Version 2 Release
For those of you who are developers, this might be of interest to you.

I have created a new version of Tables...

http://www.gossamer-threads.com/...orum.cgi?post=294026

that will allow you to edit the principal keys and indexes, along with auto increment. Later, I plan on adding the ability to add and edit ANY key and index , just like you can in mysql man, but yet still keeping the functionality of the definition files... but for now I decided to post my work.

If anyone finds any bugs, let me know. I just threw together the version for links, as the version for community is the version I have been working with.


and continuing to the advanced editor...


Tables.tar is the version for Links.

CTables.tar needs to be renamed to Tables.tar if you plan on using it with community.

I hope this can be of help to somebody...

- Jonathan
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
Oh, I must warn you that this is for DEVELOPERS ONLY. Do not change the keys to any tables that you have not backed up already! The errors are dumped to $GT::SQL::error

- Jonathan

Last edited by:

jdgamble: Jul 31, 2007, 2:26 PM
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
Hi,

Very cool plugin - thanks for sharing it :)

Just one problem I found with it. When clicking "Adv", I get this error:
Quote:
A fatal error has occured:

GT::Config (30907): Unable to compile '/var/home/xxx/cgi-bin/dev/admin/defs/Links.def': No such file or directory. at /var/home/xxx/cgi-bin/dev/admin/Plugins/Tables.pm line 282.

Please enable debugging in setup for more details.
Seems to be missing the prefix?

Other than that - a great addition to the developers tools :) (I was actually going to write something like this a while back, but got sidetracked <G>)

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
Hi,

Just so you know, here's the bug fix for that issue :)

Just replace (line 282 I think):

Code:
my $tb = GT::Config->load($CFG->{admin_root_path}."/defs/".$pre.$table."\.def");

..with:

Code:
my $pre = $DB->prefix(); # db prefix

my $tb = GT::Config->load($CFG->{admin_root_path}."/defs/".$pre.$table."\.def");

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Tables Version 2 Release In reply to
Thanks, I went ahead a fixed the problem. I have also added a new feature that allows you to toggle the protection of columns. Ironically I don't think this is useful unless you are using GForum, but I don't have a Tables version written for it.



The LinkID is now hidden from editing.



It wasn't hard to implement, so here is tables 2.1!

Hope some of you find this useful,

- Jonathan
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
Hi,

Cool - looks good :D

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
Hi,

I've found this tool really useful over the last few months - in both GComm + GLinks - so I thought I would convert it to work with GForum too - as I've started working more on GForum over the last couple of months.

Its attached, for anyone who may wanna use it Smile

As far as I can see, there shouldn't be any issues (it was really a case of moving the stuff from Tables.pm, into tables.cgi - cos of differences in GForum compared to GLinks/GForum) ...all seems to be working for me thus far.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Tables Version 2 Release In reply to
I assume you've been given permission by the author?
Quote Reply
Re: [Wychwood] Tables Version 2 Release In reply to
This is not my lasted version: its here:

http://www.gossamer-threads.com/...?post=298948#p298948

Please post any more comments in that URL.

Thanks for the add Andy, I've been meaning to do that myself, but I don't use Gforum that often.

- Jonathan

Last edited by:

jdgamble: Dec 20, 2008, 10:03 AM
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
I don't know why that link copied like that:

Anyway here is the link to version 3:

http://www.gossamer-threads.com/forum/?post=298948

- Jonathan
Quote Reply
Re: [jdgamble] Tables Version 2 Release In reply to
Hi,

Quote:
http://www.gossamer-threads.com/...?post=298948#p298948

Please post any more comments in that URL.

Whoops, I'll update that, and post in that URL ;)

Quote:
Thanks for the add Andy, I've been meaning to do that myself, but I don't use Gforum that often.

NP

I've found a couple of issues with the version I upload (some of the links don't work), but I'll get them fixed up tomorrow probably :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!