[BETA]Installed Modfication List (9/29/2008)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Get Involved
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

[BETA]Installed Modfication List (9/29/2008)

Post by Silverdown »

This is now native within Phpbb 3.1, therefor this is no longer needed. so I will no longer develop something the latest version already had within the core code.


7/15/2008 is updated to 1.0.4b2 - Fixed errors
Classification: Add-on
phpBB Part: Unknown
MOD Author: silverdown
MOD Title: Installed Modification List
Posting Template : Seen it from one of Highway to life's posts :D
MOD Description: I was tired of people signing up to my board or emailing me asking me where do I get my mods. Anyone feel the same?
MOD Version: 1.0.4 B2
Live Demo: Not Available
Author Notes: Just a little note, I am learning as I make these mods. So If some features are postponed and given a temp method please understand!
Features and planned features:
Features planned in first released version of the Mod List MOD:
1.0.Beta1(100%)
  • Add installed mods by Name, Version installed and where it can be downloaded
  • *Easy Installation
  • Add & Delete right from the ACP
1.0.b2(100%)
  • Fixed small modlist.php prefix error.
1.0.B3(100%)
  • Version update: 1.0b3
  • Dropdown Delete
  • Temp but clean admin menu
  • NEW GO button instead of the long link
1.0.4b(100%)
  • ACP menu is now complte
  • 2 new column, a simple rearrange system.
1.0.4b2(100%)
  • Compatible with Handyman's Mod Version Check
  • Fixed Errors found by MydnyteSyn.
Planned, but unsure how to implement(add)
  • Alter(modify) right from the ACP
Feature Requests:
  • Rearrange list by by cyb0rg(ADDED in release 1.0.4b)
  • ACP Editable Entries cyb0rg(ADDED in release 1.0.4b)
  • Dropdown Deletion menu by Desdenova(ADDED in release 1.0.b3)
  • Mod Recognition by Desdenova
Works with:
  • phpBB 3.0.1 (Created using this version)
  • phpBB 3.0.2

Format: XML FIle
Language:
  • English
Styles Supported:
  • Prosilver
  • Subsilver2 (working on it)
Licence: GNU General Public License v2

History:
  • April 22 2008 - First Release
  • April 30 2008 - Variable error Fix found by cyb0rg
  • May 26 2008 - Release of 1.03b
  • July 12 2008 - Release of 1.04b
  • July 15 2008 - Release of 1.04b2



Screenshots: Installation Level: Easy
Installation Time: 5-10 Minutes
Format: ??
Download: Package Download History
  • Total Downloads [21]
  • 1.0.4b [00]
  • 1.0.3B [09]
  • 1.0.2B [06] (A simple variable error fix, same as beta 1)
  • 1.0.1B [06]
Last edited by Silverdown on Tue Jan 27, 2015 10:29 pm, edited 21 times in total.
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by Silverdown »

First release is out!, You may say "I don't like downloading betas" well this mod is only in beta stage because it doesn't have what I want for a final release version plus I'm in a new modding tactic. It's stable and does not have any errors nor has any novice coding. Anyhow it's released. My demo is up and running at main board.

(Demo Link removed due to being oudated and invalid) - Silverdown -
Last edited by Silverdown on Fri Jul 18, 2008 5:42 am, edited 1 time in total.
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
cyb0rg
Registered User
Posts: 177
Joined: Thu Aug 02, 2007 12:03 am

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by cyb0rg »

Could you please help me

Im getting this when trying to add a mod to the list,

Code: Select all

SQL ERROR [ mysql4 ]

Table 'my_database.phpbb_mod_list' doesn't exist [1146]

SQL

INSERT INTO phpbb_mod_list (name, version, link) VALUES ('Installed Modification List', '1.0 Beta 1.', 'http://www.phpbb.com/community/viewtopic.php?f=70&t=904725')

BACKTRACE

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

FILE: includes/acp/acp_mod_list.php
LINE: 55
CALL: dbal_mysql->sql_query()

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

FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()
and im getting this when i try to browse to modlist.php

Code: Select all

SQL ERROR [ mysql4 ]

Table 'my_database.phpbb_mod_list' doesn't exist [1146]

SQL

SELECT * FROM phpbb_mod_list

BACKTRACE

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

FILE: modlist.php
LINE: 56
CALL: dbal_mysql->sql_query()
Thanks
cyb0rg
Registered User
Posts: 177
Joined: Thu Aug 02, 2007 12:03 am

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by cyb0rg »

anyone? please?
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by Silverdown »

Error #1
To me it seems it can't find the table to insert the mod your trying to add

Code: Select all

Table 'my_database.phpbb_mod_list' doesn't exist [1146]
Error #2
Oops, hehe my error

open up /modlist.php

find

Code: Select all

$sql = "SELECT * FROM phpbb_mod_list";
replace with

Code: Select all

$sql = "SELECT * FROM " . $table_prefix . "mod_list";
I had it set for to work only for my database while testing it, releasing it I forgot to change it. sorry about that.
Last edited by Silverdown on Wed Apr 30, 2008 12:00 pm, edited 1 time in total.
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
cyb0rg
Registered User
Posts: 177
Joined: Thu Aug 02, 2007 12:03 am

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by cyb0rg »

Still getting the same errors.
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by Silverdown »

cyb0rg wrote:Still getting the same errors.
In your database : my_database
You don't have a table called : phpbb_mod_list

You would have to run this sql to create the table in my_database

Code: Select all

CREATE TABLE `YOUR_PHPBB3_TABLE_PREFIX_mod_list` (
`name` VARCHAR( 255 ) NOT NULL ,
`version` VARCHAR( 6 ) NOT NULL ,
`link` MEDIUMTEXT NOT NULL ,
PRIMARY KEY ( `name` )
) TYPE = MYISAM ;
Change YOUR_PHPBB3_TABLE_PREFIX_ to whatever your prefix it called default is phpbb_
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
cyb0rg
Registered User
Posts: 177
Joined: Thu Aug 02, 2007 12:03 am

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by cyb0rg »

Sorted, cheers mate.

I had followed the SQL edits, just didnt change the prefix.

Thanks again, and good job!

P.S. for future releases, what about an option to edit current entries and be able to move them up/down etc?
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by Silverdown »

cyb0rg wrote: P.S. for future releases, what about an option to edit current entries and be able to move them up/down etc?
I could do that :)
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
Desdenova
Registered User
Posts: 646
Joined: Sat Feb 23, 2008 7:25 pm

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by Desdenova »

Why not use a <SELECT> menu for deleting?

Just have elements listed as <OPTION>...

Like this: http://www.cs.tut.fi/~jkorpela/HTML3.2/5.47.html
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

Re: [BETA]Installed Modfication List 1.0.Beta1 (April 22 2008)

Post by Silverdown »

Desdenova wrote:Why not use a <SELECT> menu for deleting?

Just have elements listed as <OPTION>...

Like this: http://www.cs.tut.fi/~jkorpela/HTML3.2/5.47.html
That can also be arranged :D

Aslo
Repacked and fixed the error in modlist.php you don't need to re-download beta2 it's the same as beta1 just with the fixed variable

If you have beta1 here is the fix.

Open : /modlist.php

Find:

Code: Select all

$sql = "SELECT * FROM phpbb_mod_list";
Replace with:

Code: Select all

$sql = "SELECT * FROM " . $table_prefix . "mod_list";
Gonna start working on the feature requests: ;)
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
Desdenova
Registered User
Posts: 646
Joined: Sat Feb 23, 2008 7:25 pm

Re: [BETA]Installed Modfication List 1.0.Beta2 (April 30 2008)

Post by Desdenova »

That's good.

I'll probably be installing this MOD on the few boards I am techie on once more progress has been made. ;)

For now, though, just XAMPP.
Silverdown
Registered User
Posts: 176
Joined: Thu Jun 08, 2006 6:31 pm
Location: USA

Re: [BETA]Installed Modfication List 1.0.Beta2 (April 30 2008)

Post by Silverdown »

Update News
This mod is not abandoned, I just been working on this trying to get the following features working.
  • Jump Menu Entry(s) Deletion
  • Modifying Entry(s)
  • A better Add function
Note:
I am unable to get it to work in the ACP for some odd reason I just cannot figure it out. So it will be located by
phpbb_root_path/modlist/index.php. It also will have a Admin area for only administrator status.

Hopefully I can get 1.0.1b3 out soon.
My Extentions: None
PHPBB Fan since: 2.0.6 Version Using: phpBB 3.2.3
Dev Version Using: phpBB 3.2.3
User avatar
Mitch1063
Registered User
Posts: 525
Joined: Wed Jul 28, 2004 2:49 pm
Location: WWW
Contact:

Re: [BETA]Installed Modfication List 1.0.Beta2 (April 30 2008)

Post by Mitch1063 »

I'm getting this error when trying to open modlist.php via overall_header

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'hamradio_phpbb3.phpbb__mod_list' doesn't exist [1146]

SQL

SELECT * FROM phpbb__mod_list

BACKTRACE

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

FILE: modlist.php
LINE: 56
CALL: dbal_mysql->sql_query()
I had the other error

Code: Select all

YOUR_PHPBB3_TABLE_PREFIX_mod_list
at first but corrected it

Now getting only the

Code: Select all

Table 'hamradio_phpbb3.phpbb__mod_list' doesn't exist [1146]
error
User avatar
Mitch1063
Registered User
Posts: 525
Joined: Wed Jul 28, 2004 2:49 pm
Location: WWW
Contact:

Re: [BETA]Installed Modfication List 1.0.Beta2 (April 30 2008)

Post by Mitch1063 »

Found it changed

Code: Select all

$sql = "SELECT * FROM " . $table_prefix . "_mod_list";
to

Code: Select all

$sql = "SELECT * FROM " . $table_prefix . "mod_list";
Mitch1063 wrote:I'm getting this error when trying to open modlist.php via overall_header

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'hamradio_phpbb3.phpbb__mod_list' doesn't exist [1146]

SQL

SELECT * FROM phpbb__mod_list

BACKTRACE

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

FILE: modlist.php
LINE: 56
CALL: dbal_mysql->sql_query()
I had the other error

Code: Select all

YOUR_PHPBB3_TABLE_PREFIX_mod_list
at first but corrected it

Now getting only the

Code: Select all

Table 'hamradio_phpbb3.phpbb__mod_list' doesn't exist [1146]
error
Locked

Return to “[3.0.x] MODs in Development”