Page 1 of 13

Mods Database

Posted: Mon Mar 16, 2009 8:18 pm
by Extensions Robot
Modification name: Mods Database
Author: TW1920
Modification description: Adds a simple Mods Database for keeping track of the mods installed on the board with possibility to add various additional information.
Mod detail page to view the additional information, founders will be able to see installation date on mod detail page
Modification version: 1.0.7
Tested on phpBB version: 3.0.6

Download file: mods_database107.zip
File size: 96.45 KiB

Modification overview page: View

The phpBB Team is not responsible nor required to provide support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB Extension Customisations Team may not be able to provide support.

-->Modification support<--

Mods Database

Posted: Mon Mar 16, 2009 8:18 pm
by Paul
Modification validated/released

Notes:

Mods Database

Posted: Mon Mar 16, 2009 8:18 pm
by lefty74
Dutch translation can be found here - thanks to dtech for the link

Demo Board: Demoboard
Demo Username: test
Demo Password: testtest

Note:
RobinAndersson wrote:Lefty, It's URL Rewriting that is the problem. You should write something about that people should disable URL Rewriting in their SEO mods temporarily to install this mod, on the same page that they can download it or something, and You'll probably save Yourself lots of headaches! ;)


Image

Credits: Many thanks to kingmob for the great prosilver download button

Re: Mods Database

Posted: Mon Mar 16, 2009 8:59 pm
by lefty74
Thanks very much for validating the mod again :)

Re: Mods Database

Posted: Mon Mar 16, 2009 9:00 pm
by Richazey
Congrats Lefty its a great mod, love to see what you have planned next ;)

Re: Mods Database

Posted: Mon Mar 16, 2009 10:53 pm
by lefty74
thanks parkstee :)

Re: Mods Database

Posted: Thu Mar 19, 2009 10:46 am
by Matthew1992
Just a quick question.

Is this MOD better then the Check for MOD Updates MOD?

Re: Mods Database

Posted: Thu Mar 19, 2009 11:14 am
by wolfman24
It does not check your mods for new versions etc, it's just a database to administrate your mods.

Re: Mods Database

Posted: Fri Mar 20, 2009 1:06 pm
by Drakken
After doing the edits and uploads, i go to install/index.php and get the option to uninstall or upgrade. As far as i know, this is the first time I've ever installed this. No matter which option i choose its tells me MODS_DATABASE_TABLE doesn't exists, which of course it shouldn't. Any ideas?

Re: Mods Database

Posted: Fri Mar 20, 2009 5:09 pm
by GoBieN
Drakken wrote:After doing the edits and uploads, i go to install/index.php and get the option to uninstall or upgrade. As far as i know, this is the first time I've ever installed this. No matter which option i choose its tells me MODS_DATABASE_TABLE doesn't exists, which of course it shouldn't. Any ideas?

Code: Select all

if (!isset($config['mod_show']) && !isset($config['moddb_version']))
		{
			$msg .= '<span style="color:red;">' . $user->lang['MODDB_INSTALL_DESC'] . '</span><br /><br />';				
			$msg .= '<a href="' . append_sid("{$phpbb_root_path}install/index.$phpEx", "action=install") . '">' . $user->lang['MODDB_NEW_INSTALL'] . '</a><br />';
		}
This is the relevant part of the install/index.php that decides to show the install link.
So it would seem that you have the mod_show or the moddb_version config parameters already on your system.
Perhaps another mod is already using these config parameters ?

Anyway, if you would like to proceed with the install, go to install/index.php?action=install and installation will start (forced). But maybe this will break the other mod that is already using the same config parameters. Always make DB & Files backup before installing a mod. so you can roll back !

Re: Mods Database

Posted: Fri Mar 20, 2009 5:15 pm
by Drakken
Thanks for the reply! I don't think i have anything else using those parameters but if i did i wouldn't know it either, hehe. I'll give this a whirl, thanks again!

Re: Mods Database

Posted: Fri Mar 20, 2009 5:18 pm
by lefty74
hmm, i am sure i had submitted my reply.


oh well, have to be short now as i am out of the door with one leg already :P

apart from checking in the phpbb_config table of your database if you have the fields mod_show and moddb_version, please also check that your includes/constant.php edit was made and uploaded as normally you would not get MODS_DATABASE_TABLE doesn't exists but the actual table.

Re: Mods Database

Posted: Fri Mar 20, 2009 5:40 pm
by Drakken
Well i tried again and got the same thing. In my phpbb_config table i do already have mod_show but not moddb_version. I went ahead and did the install/index.php?action=install and everything seems to be working fine. Hopefully it doesn't sneak up on me in the future cuz i'll be clueless, lol. Thanks for the help fellas!

Re: Mods Database

Posted: Fri Mar 20, 2009 11:23 pm
by Ahri89
Thanks!!! :D :D :D

Re: Mods Database

Posted: Thu Mar 26, 2009 7:36 pm
by BarryARob
GoBieN wrote:
Drakken wrote:After doing the edits and uploads, i go to install/index.php and get the option to uninstall or upgrade. As far as i know, this is the first time I've ever installed this. No matter which option i choose its tells me MODS_DATABASE_TABLE doesn't exists, which of course it shouldn't. Any ideas?

Code: Select all

if (!isset($config['mod_show']) && !isset($config['moddb_version']))
		{
			$msg .= '<span style="color:red;">' . $user->lang['MODDB_INSTALL_DESC'] . '</span><br /><br />';				
			$msg .= '<a href="' . append_sid("{$phpbb_root_path}install/index.$phpEx", "action=install") . '">' . $user->lang['MODDB_NEW_INSTALL'] . '</a><br />';
		}
This is the relevant part of the install/index.php that decides to show the install link.
So it would seem that you have the mod_show or the moddb_version config parameters already on your system.
Perhaps another mod is already using these config parameters ?

Anyway, if you would like to proceed with the install, go to install/index.php?action=install and installation will start (forced). But maybe this will break the other mod that is already using the same config parameters. Always make DB & Files backup before installing a mod. so you can roll back !
Ok I have just installed this mod, also I was able to get to the main install screen where it had a insall button i click on it and then got an error messege what do I do
this is the error messege I am getting
SQL ERROR [ mysqli ]

Table 'boilerma_boilermakers.MODS_DATABASE_TABLE' doesn't exist [1146]

SQL

INSERT INTO MODS_DATABASE_TABLE (mod_title, mod_version, mod_version_type, mod_desc, mod_desc_bbcode_uid, mod_desc_bbcode_bitfield, mod_desc_bbcode_options, mod_author, mod_author_email, mod_url, mod_download, mod_phpbb_version, mod_comments, mod_comments_bbcode_uid, mod_comments_bbcode_bitfield, mod_comments_bbcode_options, mod_access, mod_install_date) VALUES ('Mods Database', '1.0.6a', '', 'Adds a simple Mods Database for keeping track of the mods installed on the board with possibility to add various additional information.\nMod detail page to view the additional information, admins with appropriate permissions will be able to see installation date on mod detail page.', '', '', 7, 'lefty74', 'lefty@lefty74.com', '', '', '3.0.4', '', '', '', 0, 0, 1238095915)

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/index.php
LINE: 86
CALL: dbal_mysqli->sql_query()