
pugdog
User
Karma: -0 / +1
Sep 29, 2005, 10:44 PM
Post #5 of 6
(6106 views)
Shortcut
Send pugdog a wink
|
It's a little late, but I've been thinking about this. Basically, rather than a "merge" function, which would be a tad sematically complex, a "Move All" function should be farily easy. All that needs to be done to move links from one category to another is to update the CatLink table, changing the Category_ID from the old category to the new one: The MySQL query is simply: update prefix_CatLinks set Category_ID = new_category where Category_ID = old_category Moving categories is a bit more complex. Because duplicate entries should be disallowed, this would have to be done checking to see if a link already existed in the new category, and if so, deleting the old record, rather than modifying it. If I ever get the toolbox cleaned up, this will probably be one of the features in it. It would be nice if it could be integrated into the Browser code, but I'm not even going to attempt that ... you'll have an admin option to move links from one category to another, and you'll have a check box to move multiple links, and anoption to 'check all' to move all links. On the list of things to do, though, unless I have a client site that needs this for some pressing reason, it probably won't get done until after the holidays. It's a convenience thing, since for 90% of "pressing needs", entering the MySQL command to do it from the MySQLMan utility works, it just doesn't have a pretty interface. How links are assigned to categories is one of the nicer features of Links/Glinks.
|