Go Back   vb.org Archive > vBulletin Article Depository > Read An Article > General Articles
Reload this Page [RELEASE] SQL Query Script: Run SQL Queries in your MYSQL Database
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
[RELEASE] SQL Query Script: Run SQL Queries in your MYSQL Database
Logician's Avatar
Logician
Join Date: Nov 2001
Posts: 4,449

MCSE, MCDBA, Coder

inside vb code
Show Printable Version Email this Page Subscription
Logician Logician is offline 05-04-2002, 10:00 PM
Hey there,

I release a small script of mine which allows you to run SQL queries in MYSQL database.

The Script can handle not only SELECT queries (and return them in sorted tables) but you can also run INSERT, DELETE, UPDATE, ALTER, CREATE TABLE etc. queries.

It's not intergrated to vbulletin so you can use it even if you dont have vbulletin. This is also why I didnt publish it in the "Full Release Hack" Section.

As a Hacker I dont think you'll use it much, because probably you all have PHP My Admin or other software to handle SQL queries. However I found this script useful when you release a hack that requires MYSQL database alteration.

So if your hacks require to run SQL queries, you can include the script with your hack and provide the users with the relevant SQL query and the users will be able to run the necassary query on their own. I used to write individual installation scripts to handle this, but then I found this method more useful.

Installation is very simple: Edit the first few lines of the script, upload it to ANY directory in your server and run it.

Enjoy.. \\=^))

Logician
Attached Files
File Type: php logician_query.php (11.6 KB, 274 views)
Reply With Quote
  #2  
Old 05-05-2002, 09:01 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Here is a screenshot:
Attached Images
File Type: gif logician_query.gif (16.7 KB, 0 views)
Reply With Quote
  #3  
Old 05-08-2002, 07:41 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i was done by firefly, in a more extensive format. look at his hacks.
Reply With Quote
  #4  
Old 05-08-2002, 09:27 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by nakkid
i was done by firefly, in a more extensive format. look at his hacks.
There is one hack I know which is "run SQL query from your Admin CP" (JamesUS?). However:
1- It's vb-integrated, this is not.
2- It can handle only SELECT queries (eg ALTER queries produces errors), this can handle all.

When you create a hack, you sometimes need to run SQL commands and IMHO it's not practical to ask the users to first install another hack to be able to install yours. This is why I published this small script. You can simply include it inside your hack and the users who install your hack can easily run the necassary SQL query.

As I mentioned in my message, you as a hacker would need neither this script, nor the other one, because you probably have MySQLAdmin etc. But before writing this script I felt obligated to code individiual installation scripts for my hacks which require SQL query runs but now I just add the script into my installation file and give the necessary SQL command in instructions and I'm done.

I'm sure the hack you mentioned is a nice and useful hack, so kudos to its author (Firefly?, JamesUS?) but I dont think the hack and this script serve to the same purpose, although what they do looks same. However if the author is offended in anyway, I allow this thread to be removed.

Regards,
Logician
Reply With Quote
  #5  
Old 05-13-2002, 04:07 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
the easiest way for users is to include the .php query installer.
is extremly easy to make it.
Reply With Quote
  #6  
Old 01-27-2003, 04:29 AM
Dan_UPC Dan_UPC is offline
 
Join Date: Dec 2002
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This is really nice Logician however it doesnt work with DESCRIBE queries :'(
Reply With Quote
  #7  
Old 01-27-2003, 02:20 PM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Wow how did i ever miss this script

Thanks Logician

- miSt
Reply With Quote
  #8  
Old 08-01-2003, 12:48 PM
pie pie is offline
 
Join Date: May 2003
Location: Devon, England
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks Logician mate, am having probs with it but sure to overcoem it soon.

[edit]doh! forgot to configure it - forgot it was standalone
Reply With Quote
  #9  
Old 09-04-2003, 09:56 AM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
works fine for me

allowed to me to add queries that phpmyadmin was giving me errors on so im a happy chappie

Cheers logician (once again)
Reply With Quote
  #10  
Old 10-22-2003, 01:32 AM
legendarysk8er legendarysk8er is offline
 
Join Date: Nov 2002
Posts: 131
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
So do you need the password for the phpmyadmin?
Reply With Quote
Reply
Page 1 of 2 1 2

« 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 02:02 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.07978 seconds
  • Memory Usage 2,312KB
  • Queries Executed 24 (?)
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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_article
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (2)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)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