Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
Reload this Page SQL Query from Control Panel
FAQ Community Calendar Today's Posts Search

Reply
Page 2 of 4 1 2 34
 
Thread Tools
Details »»

Version: , by JamesUS JamesUS is offline
Developer Last Online: Mar 2003 Show Printable Version Email this Page
Version: 2.2.x Rating:
Released: 01-01-2002 Last Update: Never Installs: 71
 
No support by the author.

This hack allows you to execute custom SQL queries from the control panel.

I know there are one or two other hacks that do this but this one is different in that it can also cope with 'SELECT' queries. Results are displayed in a table for select queries. Inspired by wluke's older version of this hack for vB 1.1.x, I have been using this succesfully for a few days now on my own forums.

Instructions[list type=1][*]Upload attached 'query.php' file to the admin folder.[*]In admin/index.php, find:
PHP Code:
makenavselect("Options","<hr>"); 
underneath, add:
PHP Code:
makenavoption("Run Query", "query.php?t=0");
makenavselect("Database Maintanence", "<br>"); 
[/list]This hack copyright James Ussher-Smith &copy; 2001 - 2002

Show Your Support

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

Comments
  #12  
Old 09-02-2002, 12:01 AM
ExAvIoUr ExAvIoUr is offline
 
Join Date: Jan 2002
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thank you, I really need this!
Reply With Quote
  #13  
Old 09-10-2002, 03:38 PM
410 410 is offline
 
Join Date: Jul 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I get this error...

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/public_html/forums/admin/query.php on line 27
Query Result - ALTER TABLE post ADD COLUMN nuked smallint(6) not null;

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/public_html/forums/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/public_html/forums/admin/query.php on line 33
Reply With Quote
  #14  
Old 01-09-2003, 02:29 PM
Brahm Brahm is offline
 
Join Date: Jan 2002
Location: Texas, USA
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Great hack JamesUS
Reply With Quote
  #15  
Old 02-13-2003, 01:42 AM
S1R1US S1R1US is offline
 
Join Date: Nov 2002
Posts: 58
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
will this work with 2.2.9?
Reply With Quote
  #16  
Old 03-25-2003, 06:54 PM
animi12 animi12 is offline
 
Join Date: Mar 2003
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
02-12-03 at 09:42 PM S1R1US said this in Post #14
will this work with 2.2.9?
I'd also like to know if this is compatible with 2.2.9. Thanks!
Reply With Quote
  #17  
Old 03-26-2003, 01:23 AM
user360 user360 is offline
 
Join Date: Sep 2002
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
cool hack.

im getting the error

Quote:
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site34/fst/var/www/html/iforum/admin/query.php on line 27
Query Result - ALTER TABLE bbcode CHANGE bbcodereplacement bbcodereplacement TEXT;

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site34/fst/var/www/html/iforum/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site34/fst/var/www/html/iforum/admin/query.php on line 33
im using 2.2.9
Reply With Quote
  #18  
Old 03-27-2003, 03:17 AM
user360 user360 is offline
 
Join Date: Sep 2002
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
anyone?
Reply With Quote
  #19  
Old 03-27-2003, 04:31 AM
monstergamer's Avatar
monstergamer monstergamer is offline
 
Join Date: Feb 2003
Location: around the corner
Posts: 433
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i get the same thing
using 2.3.0
Reply With Quote
  #20  
Old 03-27-2003, 10:31 AM
user360 user360 is offline
 
Join Date: Sep 2002
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
is JamesUS still around?
Reply With Quote
  #21  
Old 03-27-2003, 02:05 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
"The hacker cannot guarantee to provide support for this hack."
Reply With Quote
Reply
Page 2 of 4 1 2 34

« Previous Thread | Next Thread »

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:55 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05662 seconds
  • Memory Usage 2,303KB
  • Queries Executed 27 (?)
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_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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_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_postinfo_query
  • fetch_postinfo
  • 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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete