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]

This hack has nothing to do with queries executed on pages, not does it in any way influence pageloads.

In vBulletin you have the option to run some predefined queries from the AdminCP. This hack let you define your own queries to be run manually.

I don't understand what in the hacks description make you think this got anything to do with queries run when a page load.

[Uno]

works it for vb3.6? (3.6.3)
Thank

[Uno]

Originally Posted by Uno

works it for vb3.6? (3.6.3)
Thank

Yes i have try now on local

[Boofo]

Will this work on 3.7.1?

[EvilHawk]

Yes, it works fine!

[Boofo]

Thank you, sir.

[Uno]

Work on 3.8.*?

[Marco van Herwaarden]

I see no reason why it should not work on any 3.5 or higher version.

[Uno]

Originally Posted by Marco van Herwaarden

I see no reason why it should not work on any 3.5 or higher version.

Oh yes i have try now on local (vb 3.8.1) and it go
Thank you Marco, this mod is simple, i use not much, but for query fast, without open phpMyAdmin or shell is very useful and allow of to remember easily the query more used :up:

[Uno]

No there is a little problem, export not work but i found solution

edit file mh_cq.php

PHP Code:

$xml = new XMLexporter(); 


and replace with

PHP Code:

$xml = new vB_XML_Builder($vbulletin); 


and mod is good also for 3.6.0 and up