UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods [6.x] Modifications Information for ubb.threads v0.2.1

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.

This looks cool.
Might need to give this a whirl too!

Thanks for all the mods.

yes, thanks.. we've been talkin for ages about how to keep up with what we've installed here This looks like it'll do the job, thanks

no prob

Once any bugs found get worked out and I get a bit of free time, I'll be getting the language files in and perhaps a template file.

Nice work... wish I had put this one in first

Although... to impliment this.... I need to remember what I installed here.

Maybe this goes in for 6.3 and I start fresh again.

This has been updated to now be a ZIP file with new files in it. The new files are all language and template files. Included are English and French.

Cool I love this one. Although I am still waiting for the first one I entered to display. Everyone I added after has displayed.

Err.. oops!

I think I know what might have done that. Gimme a few minutes, I'll have a fix up for you

Here you go...

ubbt_modifications.php
----------------------

after:

$result = $dbh -> do_query($query);
$html -> open_table();

insert:

$i = 0;


templates/default/ubbt_modifications.tmpl
-----------------------------------------

change:

for ($i=1;$i<$modrowsize;$i++) {

to:

for ($i=0;$i<$modrowsize;$i++) {


I'll have a version 0.21 up soon to fix that. For new downloads.

Sounds a great idea - thanks

This is a really nice one. Thanks!

[]JoshPet said:
Although... to impliment this.... I need to remember what I installed here.

Maybe this goes in for 6.3 and I start fresh again. [/]

Probably the best solution... it's always good to get a fresh start once in a while, gets rid of bugs from old beta stuff long forgotten

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".

good idea

Thanks.

I suggest adding another table:

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.

Yeah, and in 6.3... the post number will be all we need to link to. The board=keyword is no longer needed.

[]Dave_L said:
Thanks.

I suggest adding another table:

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

[]JoshPet said:
Yeah, and in 6.3... the post number will be all we need to link to. The board=keyword is no longer needed. [/]

I know -- I will *love* that new feature.