PDA

View Full Version : [Revamp] DB Query Hack v1.5

shovel
07-31-2002, 10:00 PM
    After being given the go ahead by FireFly for the ability to revamp the coding of his old hack, the DB Query Hack, I'm finally finished. It wasn't alot of coding to debug and fix but I had a good time doing it.

- Instructions -
Open File: ADMIN/index.php

FIND This(Around Line 322):
------------------------------------
makenavoption("Back-up Database","backup.php?action=choose","<br>");

ADD This BEFORE It:
-------------------------------------
makenavoption("DB Query","query.php?action=enter","<br>");

Download The Attachment And Upload The File query.php To Your ADMIN Directory.

Enjoy. ;)

- Specs -
- Run Up To Ten Mulitple Queries
- Chose To Run Only One Query

- In Development -
- .sql Uploading
shovel
08-01-2002, 08:23 PM
&nbsp;&nbsp;&nbsp;&nbsp;Would somebody mind taking me a screenshot? Please. Thank you.
Rose
08-01-2002, 08:30 PM
What's the difference between this and JamesUS's db hack? Different features?
lordnet
08-01-2002, 09:04 PM
can we see a screen shot plz ??

my best wish...

LORD
shovel
08-01-2002, 10:08 PM
&nbsp;&nbsp;&nbsp;&nbsp;As far as I know Rose, I've never used JamesUS's hack. I just asked Chen, after he dropped that hack, if I could revamp the coding and re-release it.
Unknown553
08-02-2002, 12:42 AM
What exactly did you do to "revamp" the hack? Any new features or has it just been updated for the newest versions of PHP/vB/MySQL?
Boofo
08-02-2002, 03:29 AM
Can this one also be made to do 10 queries and have the width set to 90?

Originally posted by Crater Seraph
&nbsp;&nbsp;&nbsp;&nbsp;After being given the go ahead by FireFly for the ability to revamp the coding of his old hack, the DB Query Hack, I'm finally finished. It wasn't alot of coding to debug and fix but I had a good time doing it.
shovel
08-02-2002, 02:43 PM
&nbsp;&nbsp;&nbsp;&nbsp;Sure. *Updates*
Chris M
08-02-2002, 04:44 PM
Is there an upload .sql file feature, like phpmyadmin?

Satan
Boofo
08-02-2002, 05:00 PM
Can we please get it? :)

Originally posted by Crater Seraph
&nbsp;&nbsp;&nbsp;&nbsp;Sure. *Updates*
shovel
08-02-2002, 05:51 PM
&nbsp;&nbsp;&nbsp;&nbsp;Give me ten minutes to get home Boofo and I'll fix it up. I'm at work at the moment.
Boofo
08-02-2002, 05:55 PM
Thank you very much, sir. :) How hard would it be to add the upload .sql files like chris talked about? Can it be done?

Also, it might not be a bad idea to have it be able to run SELECT queries, too. You're one stop shop for queries. ;)

Originally posted by Crater Seraph
&nbsp;&nbsp;&nbsp;&nbsp;Give me ten minutes to get home Boofo and I'll fix it up. I'm at work at the moment.
Chris M
08-02-2002, 06:51 PM
Lol...

That upload feature would be good...Especially for things like Kurafire's Quote hack...

Satan
shovel
08-02-2002, 06:53 PM
&nbsp;&nbsp;&nbsp;&nbsp;Lol. Yeah, those are great ideas. *Makes A Mentle Note* Ok. UPDATED.

What exactly did you do to "revamp" the hack? Any new features or has it just been updated for the newest versions of PHP/vB/MySQL?
&nbsp;&nbsp;&nbsp;&nbsp;I straightened out the coding and fixed a bunch of spelling errors. And yes, the coding is fit for all the latests versions of PHP/vB/MySQL. Thanks for asking.
Obi-Wan
08-02-2002, 09:13 PM
Great hack m8.

this one worked superbly:D
EchoHype.com
08-02-2002, 09:31 PM
Does this allow you to upload .sql files?

=)
Chris M
08-02-2002, 10:05 PM
Not yet;)

Satan
shovel
08-02-2002, 11:38 PM
Originally posted by EchoHype.com
Does this allow you to upload .sql files?

=)

&nbsp;&nbsp;&nbsp;&nbsp;Currently working on it.
Chris M
08-03-2002, 12:28 AM
Hehe:)

Cant wait:D

Satan
DrkFusion
08-03-2002, 02:01 AM
hehe, I just made a link to my phpmyadmin in my vb panel lol.

Though its double login, I use these for my little queries.

Nice, one, thanks
Drk
Boofo
08-05-2002, 11:42 AM
If you use AI Roboform, it is just another click of the button. ;)

Originally posted by DrkFusion
hehe, I just made a link to my phpmyadmin in my vb panel lol.

Though its double login, I use these for my little queries.

Nice, one, thanks
Drk
PennylessZ28
09-26-2002, 05:37 PM
for some reason when i try to post something it goes to my urls defulat, www.hr3rdgen.org rather than to hr3rdgen.org/forum/

and i can't post anything, followed instructions to the teeth
Red Blaze
02-11-2003, 04:27 PM
Works great. I like.
*clicks install*
subu1
02-22-2003, 07:45 AM
sorry but i have a error:
I want to run a querie in my acp but .....

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE pollvote ADD showvote TINYINT(1) DEFAULT "0" NOT NULL;

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

Date: Saturday 22nd of February 2003 10:43:00 AM


whats going on, i must have this hack :-)))))

greetz subu1
Black Vivi
05-03-2003, 09:15 AM
try this:

ALTER TABLE pollvote ADD showvote TINYINT(1) DEFAULT '0' NOT NULL

sometimes it doesn't run em if they have ";" on the end... :confused:
hagi
09-29-2003, 12:56 AM
Does this allow you to upload .sql files?

=)

did this ever get installed into this hack? it would be really helpful if it did.
Josh Combs
11-29-2003, 07:14 PM
any update on this project? and when I try it with my forum I get db errors :(