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 Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 2 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
  #12  
Old 10-22-2003, 06:33 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 legendarysk8er
So do you need the password for the phpmyadmin?
question not understood
Reply With Quote
  #13  
Old 11-17-2003, 03:13 PM
X-Sector X-Sector is offline
 
Join Date: Oct 2003
Posts: 154
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
legendarysk8er

don't need to have the password for the phpmyadmin to access because the logician query hack will ask you what is your MySQL database name, user and password so it will be connect with your phpmyadmin

Anyway, Great hack.. I was getting errors when run the queries in the phpmyadmin. I tried to run the query in your hack and it works great. Great job
Reply With Quote
Reply
Page 2 of 2 1 2

« 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:07 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.06574 seconds
  • Memory Usage 2,226KB
  • Queries Executed 20 (?)
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
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (1)postbit_attachment
  • (3)postbit_onlinestatus
  • (3)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_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