[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.

[ABD] SQL Query Engine

Postby Unknown Bliss » 05 May 2010, 22:05

Image
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:
Image

Modification Download:
Download

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 tumba25 on 21 Nov 2010, 10:04, edited 1 time in total.
Reason: Marked as abandoned.
User avatar
Unknown Bliss
New member
New member
 
Posts: 46
Joined: 24 Oct 2010, 02:08
Location: Inside your head.
Real name: Michael.C.

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

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
tumba25
Administrator
Administrator
 
Posts: 877
Joined: 24 Oct 2007, 13:10
Location: Kokkola, Finland.
Real name: Jari Kanerva

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.
Image
User avatar
RMcGirr83
MOD Team Leader
MOD Team Leader
 
Posts: 444
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

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

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.
User avatar
Unknown Bliss
New member
New member
 
Posts: 46
Joined: 24 Oct 2010, 02:08
Location: Inside your head.
Real name: Michael.C.


Return to MOD Feedback

Who is online

Users browsing this forum: Brandwatch [Spider] and 1 guest

cron