Alex,
I haven't used the validate table before, since all additions are through the User Admin.
If we make changes to the Links table, the same changes have to be made to the validate table, right?
If so, there should be an option on the Link Table edit screen to "update Validation Table" as well. The simplest way would be to drop the table, dump Links, and execute the dump as a create table.
Of course a check to make sure the table was empty first would be in order.
A more complex way would be to compare the fields of the Links table to the Validate table, and "alter" the validate table to match the Links table.
I'm going to have to do this, since I want to use the Validate table as a 'holding' pen for links I don't want visible (a "preview" area type throw back to the BBS days), as well as allowing users to add to fields not in the Validate table until sync'd with the Links table..
I haven't used the validate table before, since all additions are through the User Admin.
If we make changes to the Links table, the same changes have to be made to the validate table, right?
If so, there should be an option on the Link Table edit screen to "update Validation Table" as well. The simplest way would be to drop the table, dump Links, and execute the dump as a create table.
Of course a check to make sure the table was empty first would be in order.
A more complex way would be to compare the fields of the Links table to the Validate table, and "alter" the validate table to match the Links table.
I'm going to have to do this, since I want to use the Validate table as a 'holding' pen for links I don't want visible (a "preview" area type throw back to the BBS days), as well as allowing users to add to fields not in the Validate table until sync'd with the Links table..