Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
Reload this Page Administrative and Maintenance Tools - MyQueries - Save custom SQL for future use
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 2 of 3 1 2 3
 
Thread Tools
MyQueries - Save custom SQL for future use Details »»
MyQueries - Save custom SQL for future use
MOD Information
The Developer
 
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
  #12  
Old 04-11-2009, 02:25 PM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
When do you get that?

edit: that's when installing it isn't it?

edit2: try using the xml in this post
Attached Files
File Type: xml product-my_queries.xml (5.8 KB, 14 views)
Reply With Quote
  #13  
Old 04-11-2009, 03:38 PM
ahmed-samara ahmed-samara is offline
 
Join Date: Dec 2004
Location: egypt
Posts: 178
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by jesus likes pie View Post
When do you get that?

edit: that's when installing it isn't it?

edit2: try using the xml in this post
please shack the attack file it's give me gif banner

i working in 3.8.2
Reply With Quote
  #14  
Old 04-11-2009, 04:15 PM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I'm sorry but I don't understand what you said

On the original attachment, the install code includes charset information which I don't think should be there. The attachment in #11 does not have it, so I wanted to know if that one would work for you.

I am working on 3.8.2 as well.
Reply With Quote
  #15  
Old 04-11-2009, 08:08 PM
Sunka Sunka is offline
 
Join Date: Mar 2008
Location: Croatia
Posts: 400
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Very nice...
Taged for a moment.
Will be OK if you put some querries which are not default one (put some new querries).
Reply With Quote
  #16  
Old 04-12-2009, 09:53 PM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Updated with variables feature.
Reply With Quote
  #17  
Old 04-12-2009, 10:09 PM
Sweeks Sweeks is offline
 
Join Date: Jul 2008
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice installing now
________
MAINE MARIJUANA DISPENSARY
Reply With Quote
  #18  
Old 04-13-2009, 02:37 AM
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Location: Germany, Berlin
Posts: 331
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Very very nice, it works excellent, thank you

My wish is to have a way to edit the saved query for automatic use, without going to pma or delete the query first.


Regards,

Stoebi
Reply With Quote
  #19  
Old 04-13-2009, 06:07 AM
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Posts: 336
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Been waiting for something like this! THANKS!
Reply With Quote
  #20  
Old 04-13-2009, 06:45 PM
jesus likes pie jesus likes pie is offline
 
Join Date: Apr 2005
Posts: 342
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Stoebi View Post
Very very nice, it works excellent, thank you

My wish is to have a way to edit the saved query for automatic use, without going to pma or delete the query first.


Regards,

Stoebi

Do you mean a way to edit the queries you add?
Reply With Quote
  #21  
Old 04-15-2009, 02:26 AM
Elenna Elenna is offline
 
Join Date: Jan 2006
Location: St. Charles, MO
Posts: 422
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I believe that is what he was saying. I think that would be useful, too, in case you wanted to change a stored one.

Or perhaps an option to run the current one as-in, or run with changes, which would copy the query to the box below, and allow for modifications that don't get saved.
Reply With Quote
Reply
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »
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 07:01 PM.

Contact Us - Archive - Top

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.04953 seconds
  • Memory Usage 2,337KB
  • 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_quote
  • (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
  • (11)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