[ABD] SQL Query Engine

Post your MODs, receive and provide feedback!
Topics in this forum are not for MOD support, they are for giving the author feedback.
Forum rules
The topics in this forum are not for general MOD support, they are for giving the MOD author some feedback, ideas and bug reports.
User avatar
Unknown Bliss
New member
New member
Posts: 45
Joined: 24 Oct 2010, 02:08
Real name: Michael.C.
Location: Inside your head.

[ABD] SQL Query Engine

Postby Unknown Bliss » 05 May 2010, 22:05

[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.
Last edited by Unknown Bliss on 13 Jan 2015, 00:00, edited 2 times in total.
Reason: Marked as abandoned.

Oyabun1
New member
New member
Posts: 34
Joined: 16 Sep 2009, 08:16

Re: [RC] SQL Query Engine

Postby Oyabun1 » 19 Nov 2010, 11:15

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.

User avatar
tumba25
Past Contributor
Past Contributor
Posts: 1058
Joined: 24 Oct 2007, 13:10
Real name: Jari Kanerva
Location: Kokkola, Finland.

Re: [RC] SQL Query Engine

Postby tumba25 » 19 Nov 2010, 11:48

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.

User avatar
RMcGirr83
Past Contributor
Past Contributor
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: [RC] SQL Query Engine

Postby RMcGirr83 » 19 Nov 2010, 11:54

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
New member
New member
Posts: 34
Joined: 16 Sep 2009, 08:16

Re: [RC] SQL Query Engine

Postby Oyabun1 » 19 Nov 2010, 22:42

tumba25 wrote: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.

User avatar
Unknown Bliss
New member
New member
Posts: 45
Joined: 24 Oct 2010, 02:08
Real name: Michael.C.
Location: Inside your head.

Re: [RC] SQL Query Engine

Postby Unknown Bliss » 21 Nov 2010, 02:17

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


Return to “MOD Feedback”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests