Running mySQL queries from adminCP, any hacks ??

[PurpleCow]

Hello,

I'd like to install a hack which helps me run mysql queries from my vB adminCP.

I have checked the entire hack databse and couldn't find any ?

But, i read on a few threads that there are a few hacks which helps us run queries from adminCP, kindly help me with the links for the same in this forum.

I am using vB ver2.3.0.

Thank you

[Koutaru]

I know I've seen this somewhere but I cant find it XD
I think Logician is the one I'm supposed to credit for this ;)

upload to /admin folder

[PurpleCow]

Koutaru :

Thanks for the attachment.

Do i just upload that file to the admin folder and immediately have access in my adminCP to run queries ??
Do i have to retain the same file name logician_query.php or can i change the name of the file and still get it to work ??

Thanks for your time.

[Koutaru]

Edit the first few lines

$servername='localhost';
$dbusername='root';
$dbpassword='password';
$dbname='test';

This will allow you to access your database. You can rename it and it should work fine :)

[PurpleCow]

Thanks for the instructions.

Hope other that that, i don't have to make any more changes...or run/execute a file??

Just change those details and upload, right...

I wanted to make sure thats it !

Thanks much again

[Koutaru]

Yep, just change those details, upload it to your /admin directory (or any directory for that matter, since it is password protected), and start running queries

[PurpleCow]

I think, if i change the name of the file : I'll have to make the following change, i suppose ??

In line 261, I have this :

<form name="form1" method="post" action="logician_query.php">

If the file name is changed, i'll have to change the action="newfilename.php" , right ??

Thanks much

[Koutaru]

Yes, that's correct. Thanks for pointing that out

[lasto]

logician to the rescue again :)

i was having probs running queries though phpmyadmin (kept giving me an error so tried this and they went in first time and the hack works fine so can someone explain how this worked and phpmyadmin never.

[Logician]

This is way too simple, this can be the cause.. :)

Well frankly this can't be a match for a great script like phpmyadmin.. I use phpmyadmin for my needs too. The reason I coded that script was to include in my hacks when a SQL query should be run. It is easier to say "upload&run this file and write this line in query box" instead of instructing a newbie to install phpmyadmin. Besides some hosts do not like you to install phpmyadmin too.

BTW. the URL of the script was this:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=38262