Custom Queries with parameters

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

[Marco van Herwaarden]

New version released
Change log:
v1.01 (16-9-2005)
- Parse TABLE_PREFIX
- Added Quick Query

[Marco van Herwaarden]

Originally Posted by nexialys

my dream would be to be able to just have the " . TABLE_PREFIX . " element parsed by this SQL manager... would be simplier for all copy/pastes!

Your dream has come true, so what are you waiting for.

[Boofo]

How about this?

Use descriptions to describe what the query is for and list it on the main page next to the query title. And then have a Notes variable (and link) that will allow you to add any notes on parameters used or anything like that.

Can I get someone esle to agree to this as I was told it might be done with another person wanting the same thing?

[Marco van Herwaarden]

Version 1.02 released:
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

I will try to update the screenshots tomorrow.

PS If someone create some awesome queries, feel free to export and share them in here. If you want i will link them in the first posts.

[Marco van Herwaarden]

Screenshots updated

(Sigh they don't stay in original order)

[Floris]

Nice job Marco

And I am curious at the queries people store. Perhaps the generic ones could be posted here

[Marco van Herwaarden]

Thanks Floris,

Have even ideas for expanding this one, but since i am a bit short on time lately, id din't have the chance yet (also because it didn't get as much installs as i expected).

Yes posting some queries here has also crossed my mind, and i still plan to create a first set myself of common queries.

[Zia]

hello will it works for vb3.5.2
Obiviously it should reduce page loading time...i think..
Am i right ??

Thanks

[Marco van Herwaarden]

Originally Posted by Zia

hello will it works for vb3.5.2

Yes it should work for 3.5.2

Originally Posted by Zia

Obiviously it should reduce page loading time...i think..

I am sorry, but i don't understand what this hack has to do with pageloads?

[Zia]

Originally Posted by MarcoH64

Yes it should work for 3.5.2
I am sorry, but i don't understand what this hack has to do with pageloads?

truly....im thinking...if sql query qty reduced....say:
an forum home page need 24 sql qery to open..
now using this hack if sql query reduced to 16 ..
should the page will load bit faster than before?

Should it??

Pls let me know..
Hope u wont mind to describe some more about this one..controle/rreduce sql query..what good result it will bring...
Thanks