Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
[Revamp] DB Query Hack v1.5 Details »»
[Revamp] DB Query Hack v1.5
Version: 1.00, by shovel shovel is offline
Developer Last Online: Jan 2012 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 07-31-2002 Last Update: Never Installs: 31
 
No support by the author.

    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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #22  
Old 08-05-2002, 11:42 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #23  
Old 09-26-2002, 05:37 PM
PennylessZ28 PennylessZ28 is offline
 
Join Date: Mar 2002
Location: North America
Posts: 737
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #24  
Old 02-11-2003, 04:27 PM
Red Blaze's Avatar
Red Blaze Red Blaze is offline
 
Join Date: Jan 2003
Location: Texas
Posts: 493
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Works great. I like.
*clicks install*
Reply With Quote
  #25  
Old 02-22-2003, 07:45 AM
subu1 subu1 is offline
 
Join Date: Sep 2002
Location: Germany
Posts: 189
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #26  
Old 05-03-2003, 09:15 AM
Black Vivi's Avatar
Black Vivi Black Vivi is offline
 
Join Date: Dec 2002
Location: United Kingdom
Posts: 120
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...
Reply With Quote
  #27  
Old 09-29-2003, 12:56 AM
hagi hagi is offline
 
Join Date: Jan 2002
Location: Chi-town
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #28  
Old 11-29-2003, 07:14 PM
Josh Combs's Avatar
Josh Combs Josh Combs is offline
 
Join Date: Oct 2002
Location: Cincinnati Ohio
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

any update on this project? and when I try it with my forum I get db errors
Reply With Quote
Reply


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 05:46 AM.


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.04305 seconds
  • Memory Usage 2,276KB
  • Queries Executed 24 (?)
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
  • (2)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (7)postbit
  • (8)postbit_onlinestatus
  • (8)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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete