vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   [Revamp] DB Query Hack v1.5 (https://vborg.vbsupport.ru/showthread.php?t=41792)

shovel 07-31-2002 10:00 PM

[Revamp] DB Query Hack v1.5
 
    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):
------------------------------------
PHP Code:

makenavoption("Back-up Database","backup.php?action=choose","<br>"); 

ADD This BEFORE It:
-------------------------------------
PHP Code:

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?

Quote:

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? :)

Quote:

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. ;)

Quote:

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.

Quote:

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

Quote:

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. ;)

Quote:

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:
[sql]
ALTER TABLE pollvote ADD showvote TINYINT(1) DEFAULT '0' NOT NULL
[/sql]
sometimes it doesn't run em if they have ";" on the end... :confused:

hagi 09-29-2003 12:56 AM

Quote:

Originally Posted by EchoHype.com
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 :(


All times are GMT. The time now is 02:45 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01167 seconds
  • Memory Usage 1,768KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (27)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete