vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   [RELEASE v2] Run a SQL query directly from your admin contorl panel (https://vborg.vbsupport.ru/showthread.php?t=26272)

Wayne Luke 08-24-2001 09:19 PM

This isn't as fancy but it can run every query MySQL can process. It gives columnized results and it works on all versions of vBulletin. This is probably my first hack ever for vBulletin and I have been using it successfully for the last year.

Just rename it query.php and put a link for it in index.php.

Admin 08-25-2001 06:26 AM

So you're saying I wasted a day of my life? :p
Thanks Wayne. :)

orca 08-25-2001 07:18 AM

Quote:

Originally posted by FireFly
Orca, I'll see what I can do. :)
(btw, are you a female or a male? I've been wondering for days now :p)

Just checked: Still all male. ;)

Pie'oh'pah 08-25-2001 10:50 AM

Thumbs up dude

This is some serious hack! Small, easy to do and running fine! :D

Thnx

-Alex

webhost 08-25-2001 03:51 PM

Thanks For the hack Firefly, This will make things alot easier.

Fred 09-24-2001 03:26 AM

Got a weird error. I did what you said, then when I clicked on the link on the side to add a query. It went to the page, and above it all had this:
Code:

Fatal error: Call to undefined function: getrowbg() in /usr/accountname/forum/admin/query.php on line 66

[VbbFr]Elie 09-24-2001 04:58 AM

It's looking to work but what horible look (wluke file)
One small problem ... If there is HTML in table, there is not keep caracter and translate in HTML in the page ...

Sorry about my bad english :)

GetMeHosted.com 09-24-2001 05:34 PM

Simple, and a all around Great Feature!

Thanks...

God Bless,

Mike Gaidin 09-24-2001 10:03 PM

Great hack FireFly!!!! :D

I love this one. Good job!

JJR512 09-24-2001 10:20 PM

This is a good idea, but it definitely needs some way to view the output. For example, I'd like to be able to run this query and see the list it gives me:
SELECT username FROM user WHERE dct='X' ORDER BY username ASC
(Which involves a custom field in my user table.)


All times are GMT. The time now is 01:46 AM.

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.00942 seconds
  • Memory Usage 1,729KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete