Mods Database 1.0.7

Here my mods and history gets moved when validated and released to the phpbb.com MODDB

Mods Database 1.0.7

Postby lefty » Mon Aug 27, 2007 9:57 pm

MOD Title: Mods Database
MOD 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
MOD Version: 1.0.7

MOD Download: Mods Database 1.0.7
phpbb3 version: 3.0.6

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

Image

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

German Translation: Thanks very much to Hand of Shadow

Spanish Translation: Thanks very much to Alorse
Last edited by lefty on Tue Oct 30, 2007 10:21 pm, edited 2 times in total.
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Postby lefty » Wed Sep 12, 2007 9:31 pm

updated to version 0.1.0
added mod detail page, see screenshot in first post for more info.

To upgrade
Code: Select all
#
#-----[ COPY ]------------------------------------------
#
root/adm/style/acp_modsdb.html to adm/style/acp_modsdb.html
root/modsdb.php to modsdb.php
root/includes/acp/acp_modsdb.php to includes/acp/acp_modsdb.php
root/language/en/mods_db.php to language/en/mods_db.php
root/language/en/acp/modsdb.php to language/en/acp/modsdb.php
root/styles/prosilver/template/modsdb_body.html to styles/prosilver/template/modsdb_body.html
root/styles/prosilver/template/modsdb_body_detail.html to styles/prosilver/template/modsdb_body_detail.html
root/styles/subsilver2/template/modsdb_body.html to styles/subsilver2/template/modsdb_body.html
root/styles/subsilver2/template/modsdb_body_detail.html to styles/subsilver2/template/modsdb_body_detail.html

#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE `phpbb_mods_database` ADD `mod_phpbb_version` varchar (10) NOT NULL ;
ALTER TABLE `phpbb_mods_database` ADD `mod_comments` TEXT NOT NULL ;
ALTER TABLE `phpbb_mods_database` ADD `mod_author_email` varchar (30) NOT NULL ;
ALTER TABLE `phpbb_mods_database` ADD `mod_install_date` int(11) NOT NULL ;
#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#


Don't forget to clear your cache and refresh your templates.

lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Postby lefty » Fri Sep 14, 2007 11:05 pm

upgraded to v.0.1.1

- fixed bug when checking whether at least mod title and version are completed
- corrected spelling mistake
- fixed install file
- added check to avoid duplicate mod titles

to upgrade all you need to do is

Code: Select all
Copy: root/inlcudes/acp/acp_modsdb.php
   To: inlcudes/acp/acp_modsdb.php

Copy: root/language/en/acp/modsdb.php
   To: language/en/acp/modsdb.php
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Postby lefty » Tue Oct 30, 2007 10:24 pm

updated to v 0.1.2.

Code: Select all
## 2007-10-30 - Version 0.1.2
##      -changed DB tables to UTF-8, updated to make RC7 compliant


to upgrade
Code: Select all
ALTER TABLE `phpbb_mods_database`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_title` `mod_title` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_version` `mod_version` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_version_type` `mod_version_type` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_desc` `mod_desc` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_url` `mod_url` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_author` `mod_author` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_download` `mod_download` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_phpbb_version` `mod_phpbb_version` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;
ALTER TABLE `phpbb_mods_database` CHANGE `mod_author_email` `mod_author_email` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

root/adm/style/acp_modsdb.html to adm/style/acp_modsdb.html
root/includes/acp/acp_modsdb.php to includes/acp/acp_modsdb.php
root/styles/prosilver/template/modsdb_body_detail.html to styles/prosilver/template/modsdb_body_detail.html
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [BETA] Mods Database 0.2.0

Postby lefty » Mon Feb 11, 2008 12:09 am

updated to v020
## 2008-02-10 - Version 0.2.0
## -added a switch to show DB to certain groups (Regular Members, Mods or Admins), also gives the option show certain mods only to admins

to upgrade
Code: Select all
#
#-----[ COPY ]------------------------------------------
#
root/adm/style/acp_modsdb.html to adm/style/acp_modsdb.html
root/modsdb.php to modsdb.php
root/includes/acp/acp_modsdb.php to includes/acp/acp_modsdb.php
root/language/en/acp/modsdb.php to language/en/acp/modsdb.php
root/styles/prosilver/template/modsdb_body.html to styles/prosilver/template/modsdb_body.html
root/styles/subsilver2/template/modsdb_body.html to styles/subsilver2/template/modsdb_body.html

#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE `phpbb_mods_database` ADD `mod_access` TINYINT( 1 ) NOT NULL ;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_show', '0');

#
#-----[ OPEN ]------------------------------------------
#
includes/functions.php
#
#-----[ FIND ]------------------------------------------
#
      'U_MODS_DB'            => append_sid("{$phpbb_root_path}modsdb.$phpEx"), //lefty74

#
#-----[ REPLACE WITH ]------------------------------------------
#
      'S_MOD_DISPLAY'         => ( $config['mod_show'] == 0 && $user->data['is_registered'] && !$user->data['is_bot']) ? true : ( $config['mod_show'] == 1 && $auth->acl_get('a_',' m_') ) ? true : ( $config['mod_show'] == 2 && $auth->acl_get('a_') ) ? true : false,
      'U_MODS_DB'            => append_sid("{$phpbb_root_path}modsdb.$phpEx"), //lefty74

#
#-----[ OPEN ]------------------------------------------
#
styles/prosilver/template/overall_footer.html
#
#-----[ FIND ]------------------------------------------
#
<a href="{U_TEAM}">{L_THE_TEAM}</a>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
&bull; <a href="{U_MODS_DB}">{L_MODS_DB}</a> 
#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------
#
<!-- IF S_MOD_DISPLAY--> &bull; <a href="{U_MODS_DB}">{L_MODS_DB}</a><!-- ENDIF -->   

#
#-----[ OPEN ]------------------------------------------
#
styles/subsilver2/template/overall_header.html
#
#-----[ FIND ]------------------------------------------
#
               &nbsp; &nbsp;<a href="{U_MODS_DB}"><img src="{T_THEME_PATH}/images/icon_mini_members.gif" width="12" height="13" alt="*" /> {L_MODS_DB}</a>

#
#-----[ REPLACE WITH ]------------------------------------------
#
               <!-- IF S_MOD_DISPLAY-->&nbsp; &nbsp;<a href="{U_MODS_DB}"><img src="{T_THEME_PATH}/images/icon_mini_members.gif" width="12" height="13" alt="*" /> {L_MODS_DB}</a><!-- ENDIF -->

#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#
Don't forget to enable the module and clear your cache and refresh your templates.
   
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [BETA] Mods Database 0.2.1

Postby madmax765 » Wed Mar 19, 2008 2:40 am

Hello Lefty. You done some real nice work here....I hope its ok to post here.. if not ill delete it or you may. got one question on this mod. I add this mod to another style. How can i move the header line going thow the words down ?
your work is good... I been learning alot... lest im trying to :ideabulb:

Image

i got rid of the icon ok.. just cant firger out how to make Mods Database read like MD or to move line down, inclosed it part of the header code


<!-- ELSE --> &nbsp;<a href="{U_REGISTER}">{L_REGISTER}</a>
<!-- ENDIF -->
<!-- ENDIF -->
</td>
<td class="genmed" align="{S_CONTENT_FLOW_END}">
<a href="{U_GALLERY_MOD}" title="{L_GALLERY_EXPLAIN}"> {L_GALLERY}</a>&nbsp; &nbsp;
<a href="{U_FAQ}">{L_FAQ}</a>
<!-- IF S_DISPLAY_SEARCH -->&nbsp; &nbsp;<a href="{U_SEARCH}">{L_SEARCH}</a><!-- ENDIF -->
<!-- IF not S_IS_BOT -->
<!-- IF S_DISPLAY_MEMBERLIST -->&nbsp; &nbsp;<a href="{U_MEMBERLIST}">{L_MEMBERLIST}</a><!-- ENDIF -->
<!-- IF S_USER_LOGGED_IN -->&nbsp; &nbsp;<a href="{U_PROFILE}">{L_PROFILE}</a><!-- ENDIF -->
<!-- ENDIF -->
<!-- IF S_MOD_DISPLAY-->&nbsp; &nbsp;<a href="{U_MODS_DB}"> {L_MODS_DB}</a><!-- ENDIF -->

</td>
</tr>
</table>
</div>

<div id="wrapheader">

<div id="logodesc">
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td align="left">
<br/><br/><br/><br/>
madmax765
Forum Member
 
Posts: 45
Joined: Tue Mar 18, 2008 2:11 pm
Location: U.S.

Re: [BETA] Mods Database 0.2.1

Postby lefty » Wed Mar 19, 2008 9:36 am

hi, dont worry about posting, thats the reason the thread is up.

looks like there is too much text so that Mods Database moves a line down. Try reducing the text to maybe Mods DB.
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [BETA] Mods Database 0.2.1

Postby Black Olrac » Tue Mar 25, 2008 3:11 pm

Code: Select all
[25-Mar-2008  05:16:27] [phpBB Debug] [client **.**.**.**] [File adm/index.php?i=31] PHP Notice: in file /var/www/vhosts/somewhereontheinternet.com/httpdocs/includes/acp/acp_modsdb.php on line 309 : Undefined index:  mod_show


working as intended just a little error i found, i love errorfree mods so please fix but no need to rush :excellent:
Black Olrac
Newbie/Neuling
 
Posts: 3
Joined: Tue Mar 25, 2008 3:03 pm

Re: [BETA] Mods Database 0.2.1

Postby lefty » Tue Mar 25, 2008 5:19 pm

did you clear your cache as that error should not occur?
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [BETA] Mods Database 0.2.1

Postby Black Olrac » Tue Mar 25, 2008 5:31 pm

guess that was it, no errors now
Black Olrac
Newbie/Neuling
 
Posts: 3
Joined: Tue Mar 25, 2008 3:03 pm

Re: [BETA] Mods Database 0.2.1

Postby lefty » Tue Mar 25, 2008 5:50 pm

great :)
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.0

Postby lefty » Sat Jul 12, 2008 12:22 am

Code: Select all
2008-07-10- Version 1.0.0


added css to separate file, repackaged to new guidelines
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.1

Postby lefty » Sat Jul 12, 2008 5:36 pm

Code: Select all
## 2008-07-10 - Version 1.0.0
##      -deleted a value assignment in 1.0.0 by accident
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.1

Postby madmax765 » Sat Jul 19, 2008 4:22 am

i love this mod... is there a way to make it open a new window then using the curent window... when i go to check on a new version or to down load a newer version ?
madmax765
Forum Member
 
Posts: 45
Joined: Tue Mar 18, 2008 2:11 pm
Location: U.S.

Re: Mods Database 1.0.1

Postby lefty » Sat Jul 19, 2008 11:16 am

um, not sure what you mean, sorry.

when should it open a new window exactly?
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.1

Postby madmax765 » Mon Aug 04, 2008 5:05 pm

LIke lets say i am in Manage Mods Database in my forum. And i scroll down the list to like Mods Database.. i then hit the download buttion to check for a newer version. it goes to the down laod page. from my currtion window i was in. Can this be changed to open a new window... So then i can conpare stuff.. its no biggie. But would be nice :) But I still love your work :) Keep it up
madmax765
Forum Member
 
Posts: 45
Joined: Tue Mar 18, 2008 2:11 pm
Location: U.S.

Re: Mods Database 1.0.1

Postby neweditionfan » Wed Aug 06, 2008 12:12 am

I just installed but in the ACP I see a .mods tab and when I click on it I get this (yes, I did the SQL) :
Code: Select all
General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT * FROM MODS_DATABASE_TABLE ORDER BY mod_title ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_modsdb.php
LINE: 338
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_modsdb->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
neweditionfan
Newbie/Neuling
 
Posts: 1
Joined: Wed Aug 06, 2008 12:09 am

Re: Mods Database 1.0.1

Postby Tomo » Thu Aug 07, 2008 5:30 pm

but u did it wrong

same mistake i had on first install

then i repeated steps more careffuly like i don't know anything about phpbb and all was good then
Image
Tomo
Newbie/Neuling
 
Posts: 3
Joined: Mon Aug 04, 2008 4:07 pm

Re: Mods Database 1.0.1

Postby lefty » Sat Aug 09, 2008 3:57 pm

madmax765 wrote:LIke lets say i am in Manage Mods Database in my forum. And i scroll down the list to like Mods Database.. i then hit the download buttion to check for a newer version. it goes to the down laod page. from my currtion window i was in. Can this be changed to open a new window... So then i can conpare stuff.. its no biggie. But would be nice :) But I still love your work :) Keep it up

this could be simple done by adding a target='_blank' in the link code but you can just press shift or control when clicking on the link, should do the same.
neweditionfan wrote:I just installed but in the ACP I see a .mods tab and when I click on it I get this (yes, I did the SQL) :
Code: Select all
General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT * FROM MODS_DATABASE_TABLE ORDER BY mod_title ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_modsdb.php
LINE: 338
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_modsdb->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

did you do the edits in inlcudes/constants.php ?

i am working on an install file that should do everything from sql statements to installing the modules but i am not sure when i will be able to get this out.
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.1

Postby thedawn2009 » Sun Aug 10, 2008 7:01 pm

Hi Lefty, I'm having a problem with this mod. I go to setup the MODs DB ACP but the "Mods Database" Module is not in the list of available modules. Any idea why? I did all the install changes over and reuploaded everything. Still no module.
thedawn2009
Newbie/Neuling
 
Posts: 2
Joined: Sun Aug 10, 2008 6:56 pm

Re: Mods Database 1.0.1

Postby lefty » Sun Aug 10, 2008 11:30 pm

that is very strange, you should see the mod database as a module.
did you clear the cache and upload the files in the root folder of the mod?
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.1

Postby thedawn2009 » Mon Aug 11, 2008 4:17 am

I did all that. I just checked my root folder again and realised my FTP had skipped some files. I must have over looked them the first time. Problem solved.

P.S
Very useful mod
thedawn2009
Newbie/Neuling
 
Posts: 2
Joined: Sun Aug 10, 2008 6:56 pm

Re: Mods Database 1.0.1

Postby cedomirovic » Mon Aug 11, 2008 10:27 am

Where to find in aerogreen

<!-- IF S_USER_LOGGED_IN -->&nbsp; &nbsp;<a href="{U_PROFILE}"><img src="{T_THEME_PATH}/images/icon_mini_profile.gif" width="12" height="13" alt="*" /> {L_PROFILE}</a><!-- ENDIF -->
<!-- ENDIF -->
cedomirovic
Newbie/Neuling
 
Posts: 2
Joined: Mon Aug 11, 2008 10:10 am

Re: Mods Database 1.0.1

Postby lefty » Mon Aug 11, 2008 5:43 pm

cedomirovic wrote:Where to find in aerogreen

<!-- IF S_USER_LOGGED_IN -->&nbsp; &nbsp;<a href="{U_PROFILE}"><img src="{T_THEME_PATH}/images/icon_mini_profile.gif" width="12" height="13" alt="*" /> {L_PROFILE}</a><!-- ENDIF -->
<!-- ENDIF -->

i dont know aerogreen, try looking for U_PROFILE or L_PROFILE, that should get you close to the find line.
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: Mods Database 1.0.1

Postby cedomirovic » Mon Aug 11, 2008 9:07 pm

thanks
cedomirovic
Newbie/Neuling
 
Posts: 2
Joined: Mon Aug 11, 2008 10:10 am

Next

Return to [3.0.x] MOD Database Releases

Who is online

Users browsing this forum: No registered users and 1 guest

cron