Custom Queries with parameters
Mod Version: 1.02, by Marco van Herwaarden
This modification is in the archives.
| vB Version: 3.5.8 | Rating:  (0 vote - 0 average) |
Installs: 12 |
| Released: 13 Sep 2005 | Last Update: 18 Sep 2005 | Downloads: 54 |
 Not Supported
 DB Changes
Uses Plugins
Additional Files
|
||
Custom Queries - version 1.02
==========================================================================
Hack: Custom Queries
Version: 1.02
vB Version: 3.5.0 RC3
Author: MarcoH64
Description:
This hack will let you store SQL-statements that you use more then once in the database for later use. You can see it as an
extension the the standard predefined queries, but now you can define your own, use parameters and parse TABLE_PREFIX.
Features:
- Store SQL-statements for later use
- Use any number of parameters in your SQL-statements
- Query execution is done by standard vB scripts, so normal vB security is active on them.
- Full Admin Help (needs to be installed seperate)
- Can handle TABLE_PREFIX
- Quick Query for executing 1 time queries (including TABLE_PREFIX parsing)
- Import/Export groups of safed Queries
Donations are always welcome to Paypal: marcoh64 @ gmail.com
Change log:
v1.02 (18-9-2005)
- Added 'groupname' for queries. (used when exporting queries)
- Export Queries to an XML-File
- Import Queries from XML-File
- Direct safe Quick Query
v1.01 (16-9-2005)
- Parse TABLE_PREFIX
- Added Quick Query
- Added TABLE_PREFIX to install code
v1.00 (13-9-2005)
- Update: Admin help was not in product xml-file, see readme.txt
===========================================================================
Installation:
- Upload all files from the upload directory to your forumhome directory.
- Install the product XML-File
- If Admin Help is wanted, also upload the file mh_cq-adminhelp.xml in your Admin Help Manager (only accessible in debug mode, or
by going to http://www.myboard.com/admincp/help.php?do=files)
===========================================================================
When using parameters in a query, you can use the parametername surrounded by brackets (ie. {parametername})
in the SQL-statement.
Example:
Parametername: username
Query:
SELECT * FROM user WHERE username LIKE '%{username}%'
Attached is also an example export file with a demo query.
==========================================================================
Hack: Custom Queries
Version: 1.02
vB Version: 3.5.0 RC3
Author: MarcoH64
Description:
This hack will let you store SQL-statements that you use more then once in the database for later use. You can see it as an
extension the the standard predefined queries, but now you can define your own, use parameters and parse TABLE_PREFIX.
Features:
- Store SQL-statements for later use
- Use any number of parameters in your SQL-statements
- Query execution is done by standard vB scripts, so normal vB security is active on them.
- Full Admin Help (needs to be installed seperate)
- Can handle TABLE_PREFIX
- Quick Query for executing 1 time queries (including TABLE_PREFIX parsing)
- Import/Export groups of safed Queries
Donations are always welcome to Paypal: marcoh64 @ gmail.com
Change log:
v1.02 (18-9-2005)
- Added 'groupname' for queries. (used when exporting queries)
- Export Queries to an XML-File
- Import Queries from XML-File
- Direct safe Quick Query
v1.01 (16-9-2005)
- Parse TABLE_PREFIX
- Added Quick Query
- Added TABLE_PREFIX to install code
v1.00 (13-9-2005)
- Update: Admin help was not in product xml-file, see readme.txt
===========================================================================
Installation:
- Upload all files from the upload directory to your forumhome directory.
- Install the product XML-File
- If Admin Help is wanted, also upload the file mh_cq-adminhelp.xml in your Admin Help Manager (only accessible in debug mode, or
by going to http://www.myboard.com/admincp/help.php?do=files)
===========================================================================
When using parameters in a query, you can use the parametername surrounded by brackets (ie. {parametername})
in the SQL-statement.
Example:
Parametername: username
Query:
SELECT * FROM user WHERE username LIKE '%{username}%'
Attached is also an example export file with a demo query.
Download
This modification is archived and cannot be downloaded.
Screenshots