Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons

Reply
 
Thread Tools
MyQueries - Save custom SQL for future use Details »»
MyQueries - Save custom SQL for future use
Version: 2.10, by jesus likes pie jesus likes pie is offline
Developer Last Online: Jul 2013 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.8.x Rating:
Released: 04-10-2009 Last Update: 04-19-2009 Installs: 24
DB Changes Uses Plugins
Re-useable Code Translations  
No support by the author.

My Queries by Rafael Lopez
04/10/2009 (m/d/y)

This mod allows you to store custom queries for later use. Simply define the query once, save it, and it'll appear under "Automatic Queries" in the
Admin CP - allowing you to run it again in a matter of seconds.

::: CHANGE LOG :::
v1.0 - original release
v2.0 - 4/12/09
-----New feature: Variables
-----A few bug fixes
v2.1 - 4/20/09
-----Saved queries can now be edited.


::: Installation :::

Extract product-my_queries.xml
Upload product-my_queries.xml by going to ADMIN CP --> PLUGINS AND PRODUCTS --> MANAGE PRODUCTS --> ADD/IMPORT PRODUCT
If you are upgrading then you should set "over-write" to yes.

And you're done!




As always with my releases, you are free to modify, distribute, derive work from, and translate this mod.

If you liked this mod you might also like my others:

Select Postbit [https://vborg.vbsupport.ru/showthread.php?t=203324]
Shared Admin Notes [https://vborg.vbsupport.ru/showthread.php?t=203326]
Internal Forums Closed Message/Reason [https://vborg.vbsupport.ru/showthread.php?t=207855]
Auto-Moderate Evading Banned Members [https://vborg.vbsupport.ru/showthread.php?t=207966]
Multi-Quote / Edit Integration [https://vborg.vbsupport.ru/showthread.php?t=210620]

Download Now

File Type: zip My Queries.zip (242.8 KB, 59 views)
File Type: zip My Queries 2.0.zip (1,022.8 KB, 41 views)
File Type: zip My Queries 2.1.zip (1.07 MB, 119 views)

Screenshots

File Type: jpg general.jpg (103.9 KB, 0 views)
File Type: jpg preview.jpg (200.8 KB, 0 views)
File Type: jpg one_var.jpg (210.9 KB, 0 views)
File Type: jpg three_vars.jpg (204.6 KB, 0 views)
File Type: jpg definitions.jpg (99.4 KB, 0 views)
File Type: jpg results.jpg (103.3 KB, 0 views)
File Type: jpg edit2.JPG (67.1 KB, 0 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #22  
Old 04-15-2009, 07:22 PM
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
Location: Russia, St.Petersburg
Posts: 428
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very nice. Thanks a lot.
Reply With Quote
  #23  
Old 04-20-2009, 04:09 AM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Updated to version 2.1:

allows editing of saved queries.

see this attachment for preview
Reply With Quote
  #24  
Old 04-20-2009, 05:58 AM
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Location: Germany, Berlin
Posts: 331
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi

Thank you very much

Have a MySQL Error, if i hit Save after editing my content.

This is my Content:
Title: Update Phrases (vbulletin)
Code:
UPDATE phrase
SET version = '{version}'
WHERE languageid = 3
AND product = 'vbulletin'
Variables: version

This is the error:
Code:
Datenbankfehler in vBulletin 3.8.2:

Invalid SQL:
UPDATE customqueries SET `name` = 'Phrasen aktualisieren (vbulletin)', `query` = 'UPDATE phrase
SET version = '{version}'
WHERE languageid = 3
AND product = 'vbulletin'', `variables` = 'version' WHERE qid = 1356;

MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{version}'
WHERE languageid = 3
AND product = 'vbulletin'', `variables` = 've' at line 1
Fehler-Nr.    : 1064
Fehler-Zeit   : Monday, 20.04.2009 @ 08:58:15
Datum         : Monday, 20.04.2009 @ 08:58:15
Skript        : http://localhost/vb/yvb382/admincp/queries.php?do=addquery
Referrer      : http://localhost/vb/yvb382/admincp/queries.php?do=addquery
IP-Adresse    : 127.0.0.1
Benutzername  : Stoebi
Klassenname   : vB_Database
MySQL-Version : 5.0.67-community
Regards, Stoebi
Reply With Quote
  #25  
Old 04-20-2009, 01:20 PM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ah that's my bad.

Re-download the 2.1 file. Should be fixed now.
Reply With Quote
  #26  
Old 04-20-2009, 02:12 PM
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Location: Germany, Berlin
Posts: 331
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you so much. Works perfectly now.

An idea I have. What do you think about an import/export option?


Kind Regards,

Stoebi
Reply With Quote
  #27  
Old 08-10-2009, 04:22 AM
Sunka Sunka is offline
 
Join Date: Mar 2008
Location: Croatia
Posts: 400
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Changed from taged to installed! :up:

Still it would be OK if someone will write here some querries that are not by default in ACP
Reply With Quote
  #28  
Old 08-10-2009, 10:32 AM
Sweeks Sweeks is offline
 
Join Date: Jul 2008
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the update
Reply With Quote
  #29  
Old 08-10-2009, 10:43 AM
dilbert dilbert is offline
 
Join Date: Nov 2004
Location: Boston
Posts: 251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very nice, thank you.
Reply With Quote
  #30  
Old 08-10-2009, 10:54 AM
DubaiZone DubaiZone is offline
 
Join Date: Aug 2009
Location: United Arab Emirates {Dxb
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nice Jod .. Thanx

*Installed soon*
Reply With Quote
  #31  
Old 07-05-2010, 02:15 AM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can anyone tell me if this works on vB4?

I've been very outside the loop and I don't know if vB3 mods need to be rewritten to work in vB4. (I also don't have a vB4 forum installed, yet)
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:39 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04598 seconds
  • Memory Usage 2,331KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete