Mod Name / Version - Modifications Information for ubb.threads Version - 0.2.1 Description - This mod creates a database list of modifications applied to a UBBT installation, and lists information about each modification. An administrator must of course submit this information. This is useful for keeping track of mods and version numbers, as well as for the information of your visitors. Full use of language files, and uses a template file even. Includes English and French. Working Under - ubbt 6.2; should work under all 6.x. Pre-requisites - Modifications (it'd be silly to install otherwise ) Files Altered - admin/menu.php templates/default/ubbt_footer.tmpl (though you can put the link wherever you want) New Files - ubbt_modifications.php languages/**language**/ubbt_modifications.php templates/default/ubbt_modifications.tmpl admin/editubbt_modifications.php languages/**language**/admin/editubbt_modifications.php altertable_mod.php (one-time script) New Database Tables - [w3t_]Mods_Mod Author - Dalar (Rob Porter) Example - Legends of Tacendia Forums Admin Example: []http://dalar.danbo.com/adminex.jpg[/]
If anyone uses this, let me know how it goes - and certainly anyone is free to suggest additions and expansion to this mod.
Yeah, I'm thinking when 6.3 gets stable... we can rehack. This hack will be first...
Then I'll be religious about updating this.
I have an idea to tweak this a bit.... to put the post number of the hack in. Then people here can view what hacks we have, and click right to the post.... thus we can be a "showcase".
CREATE TABLE w3t_Mods_Files ( M_ID int(11) NOT NULL default 0, M_File varchar(255) NOT NULL default '', M_New char(1) NOT NULL default '0', KEY M_ID (M_ID), KEY M_File (M_File) );
This table keeps track of which files were added (M_New = '1') or modified (M_New = '0') by each mod.
Each row of the table contains one filename, so if a mod affected ten files, then there would be ten rows.
Then by doing the appropriate query, you could obtain a list of all files related to a specific mod, or a list of all mods that affect a specific file.
Yeah - the way it works currently is that any link can be placed in the listing. The way I was doing it, was putting the URL to the post in. It should be an easy hack to have an alternate post-number entry to enter that turns into a full link rather than entering the whole URL manually.
CREATE TABLE w3t_Mods_Files ( M_ID int(11) NOT NULL default 0, M_File varchar(255) NOT NULL default '', M_New char(1) NOT NULL default '0', KEY M_ID (M_ID), KEY M_File (M_File) );
This table keeps track of which files were added (M_New = '1') or modified (M_New = '0') by each mod.
Each row of the table contains one filename, so if a mod affected ten files, then there would be ten rows.
Then by doing the appropriate query, you could obtain a list of all files related to a specific mod, or a list of all mods that affect a specific file. [/]
Thanks for the suggestion. I was thinking about something towards that direction, but wasn't sure exactly how to approach it yet.
Ultimately an interesting idea would be to come up with some kind of standard SQL string that every mod'er could supply (like the standard format that people use for posting mods), then it could be integrated with the forums here, and at the same time the same SQL query could be run by those who install it into their .threads, provided they have the mod first.
Basically:
-author writes mod, submits it on a form here similar to the admin/ubbtedit_modification.php form, except it also generates a post using the newpost.php (so that file upload is same as always) -the form is shown in the parent post, and has a pop-up link with generated SQL code to update the modification table when the code is installed -admin-user of the code makes the hacks as usual, and runs the SQL query to update their modifications table
I hope that's not too big looking, but that's what I think a version one would be like. I've written something similar in a private hack that was like photopost, minus the generated SQL code of course
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.