[ABD] SQL Query Engine

[Unknown Bliss]

[img]http://sa007.cz.cc/images/SQL%20Query%20Engine.png[/img]
SQL Query Engine

Modification Name:
SQL Query Engine
Author:
SA007 and imkingdavid

Install Time and Difficulty:
2 minutes - Easy

Modification Description:
This adds an ACP Module for Founders only so that they can execute sql queries on the forums database. Useful for installing MODs and for MOD developers when testing and creating MOD. A simple MOD that requires no file edits. Just 4 uploads and running the UMIF install file.

Modification Version:
[RC2] 0.2.0

Development and Support Forum:
http://sa007.cz.cc

Requirements:

• It has only been tested with MySQL and MySQLli.

phpBB Version:

• phpBB 3.0.7
• phpBB 3.0.7-PL1

Features:

• Founder Only Access
• Sucess and Failed Messages
• ACP Module
• Show Query Output/Results
• Version Check

Screenshots:
[img]http://sa007.cz.cc/images/sql.png[/img]

Modification Download:
[url=http://www.assembla.com/spaces/sqlqueryengine/documents/bdqYw6qIer34QLeJe5avMc/download/SQL%20Query%20Engine%20RC2]Download[/url]

The logo contains a customization of the phpBB Logo, the orginal phpbb logo is copyright of phpbb.com.
The logo also contains the MySQL Logo, copyright of Sun Microsystems/Orcale.

[Oyabun1]

In the ACP in the version check successbox it shows: %s is up to date - Re-Check version. Seems to be a missing language variable for the title of the MOD %s.

[tumba25]

That string does not seem to be from either phpBB or from this MOD. Neither of them contains %s is up to date. This MOD contains the name hard coded in the language strings.

[RMcGirr83]

You don't need all these globals

Code: Select all

      global $db, $user, $auth, $template;
      global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

like the entire second line and $auth in the first.

Code: Select all

                if(!$user->data['user_type'] == 3) // See if the user is a founder.   Â      

..you aren't using the constant

Code: Select all

if(!$user->data['user_type'] == USER_FOUNDER)

..and you aren't checking the form upon submit

Code: Select all

add_form_key();

installer file

Code: Select all

// The name of the mod to be displayed during installation.
$mod_name = 'SQL Query Engine';

hard coded language. If you placed this within the same file

Code: Select all

$language_file = 'mods/info_acp_sql_engine_install';

before the above, you could then use a lang var.

The version numbering is "development", just thought I would state that as well.

[Oyabun1]

That string does not seem to be from either phpBB or from this MOD. Neither of them contains %s is up to date. ...

It may be a conflict with Handyman's Version Check MOD. In the language file for that MOD, info_acp_version_check.php, is the line 'UP_TO_DATE' => '%s is up to date',. Maybe that is being called somehow by this MOD.

[Unknown Bliss]

This is a very old version of an ABD MOD of mine.