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)

cyrus 09-25-2001 09:28 AM

Is this similar to TELNET ?? ( which I have but it would be easier to do it through here ! )

Also, how acn I make a DB BACKUP through this ??

thanks

Admin 09-25-2001 12:19 PM

JJR512, I understand that the code wluke posted does that.
Like he said, it's not fancy or anythin, but works.

Cyrus, no, not really.
This is more like (a very very lite version of) phpMyAdmin, not Telnet.
Although most of the commands you can use in Telnet you can use here (SELECT, UPDATE, INSERT, DELETE, ALTER queries, stuff like that), I'm not sure how you can do a backup from here.
And don't forget there is a backup utility in vBulletin. :)

JJR512 09-26-2001 04:20 AM

I have had an error with wluke's version. I don't know if there was a thread for that or not, so I don't know where else to put this but here, sorry.

This is the query I attempted to run:
SELECT username FROM user WHERE dct='2' ORDER BY username ASC

This is the error message I received:
Quote:

Database error in vBulletin Control Panel: Invalid SQL: E
mysql error: You have an error in your SQL syntax near 'E' at line 1
mysql error number: 1064
Date: Wednesday 26th of September 2001 01:16:53 AM
Script: /forums/admin/query.php?action=run
Referer: http://216.118.105.52/forums/admin/w-query.php

JohnBradshaw 09-26-2001 08:15 AM

This has got to be one of the best hacks I have ever seen! Much better then having sort out MyAdmin!

YourHostSucks 09-27-2001 07:04 PM

This is very handy and works like a charm (most of the time) :)

Thanks!

TheComputerGuy 11-04-2001 11:29 AM

This is just the update for 2.20 Enjoy...Follow all other instructions

In the admin/index.php
Find:
// ***
makenavoption("Add","announcement.php?action=add", "|");
makenavoption("Modify","announcement.php?action=mo dify");
makenavselect("Announcements");
// ***

Above that place this:
makenavoption("Run MySQL","query.php?s=<?php echo $session[sessionhash]; ?>");
makenavselect("MySQL Query");

And save and upload

And upload the Query.php to your admin folder....

Enjoy...
Chris

xug 11-04-2001 05:12 PM

Very Cool Hack

Thank you FireFly.

|DarkManX| 11-04-2001 06:05 PM

thanks GREAT HACK!!

SirSteve 11-08-2001 01:46 AM

Works great!

Harvey 03-20-2002 11:28 AM

just another query.php, if I may post it.

features:
- run nearly every command MySQL understands
- select the database
- HTML-Tags are shown as HTML-Tags

missing features:
- multiple queries
- no confirmation

known bugs:
- select of DB only works if host/user/pass are the same as for VBB
- warning on statements wich return no result (it still works, but I don't know how to fix)


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.01204 seconds
  • Memory Usage 1,734KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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