This small tutorial will guide you threw the steps of running a query. Queries are often needed to to be run before a hack can work properly. If your reading a hack install file, and come across something that says "run the following queries" This is what you can do.



There are three diffrent ways to run queries. So pick which is best for you.

1. Log into your Admin Control Panel (located at www.yoursite.com/forums/admincp)
2. On the left menu scroll down to the very bottom. You should see "Import & Maintenance" (screenshot 1a)
3. Click on "Execute SQL Query" (screenshot 1a)
4. You should see "Manual Query" Go ahead and run the following query.
   Code:

   DELETE FROM session
   

   (screenshot 1b)
5. You will see a message that says "Confirm Query Execution" Click continue (Screenshot 1c)
6. Then you will be redirected to a "vBulletin Message" In this case "Affected Rows: 0"
7. That wasn't to hard no was it?

• Log into phpMyAdmin. This will be located in your control panel where you are being hosted. Most sites use cPanel X.
• phpMyAdmin will be located in one of two locations.
  1. On the main page of your cPanelx after you have logged in. Should be a link called phpMyAdmin
  2. On the main page you will see "MySQL Databases" click that and scroll to the very bottom and you should see a link that says "phpMyAdmin" click it. That should log you into phpMyAdmin.
  
  
• Great now where logged in.
• Choose your forums database in the dropdown menu located on the top left hand of that page (screenshot 2a)
• After you select your forums database you will be redirected to a page with a list of things. Some should say Table, Action. Records, Type. Size, and Overhead.
• On the top you will see a link that says "SQL" Click it, that will directed you to the page were you can run queries (screenshot 2b)
• You will see a box to type in
• Go ahead and run the following query.
  Code:

  DELETE FROM session
  

  (screenshot 2c)
• a popup message will show asking "Do you really want to: DELETE FROM session. JUst press okay.
• That was easy right?

• Few times you may have to upload a .sql file via phpMyAdmin.
• Log into phpMyAdmin using the instructions from the above tutorial.
• Once logged into phpMyAdmin
• Choose your forums database in the dropdown menu located on the top left hand of that page (screenshot 3a)
• After you select your forums database you will be redirected to a page with a list of things. Some should say Table, Action. Records, Type. Size, and Overhead.
• On the top you will see a link that says "SQL" Click it, that will directed you to the page were you can run queries (screenshot 3b)
  You will see a box to type in and under that box will be something that says. "Or Location of the textfile "
• From there you my click browse, and choose the location of the .sql file and click submit/go
• Thats it very simple!

If you have any questions about running queries, please don't not hesitate to ask how to questions in the General Hacking forum. Thanks for reading.

About first version: When I go on AdminCp -> Execute SQL Query board show me this message:

What's wrong?

EDIT: I'm in local, and I use EasyPHP

Edit your includes/config.php file to allow you to run queries.

Find:
Replace With:
X = Your userid

And if I am in a local forum I must put "127.0.0.1", right?

you need to enter your userid, most likely "1", as I suppose you are using the user that was created during the setup

your userid on this board is "7215"

Ahhhhh I understand! Thanks man!

Great!

Screenshoots are missing...

I'll bet the code needs updating to work with vB3.7.x

Nope, should be the same with all vb 3.x

DOH! :grin:

Aaah, yes, because it's direct SQL on your MySQL... Sorry, I was in a different world; I though we were writing code for vB to commit SQL.

Sorry, my bad.