Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2005, 07:18 PM
mbracing's Avatar
mbracing mbracing is offline
 
Join Date: Jul 2005
Location: NJ
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default What is an SQL QUERY?

I am trying to install this away message program, and the first step, it says...

Quote:
================================================== ========
RUN THE FOLLOWING SQL QUERY
================================================== ========
ALTER TABLE `user` ADD `awaystatus` INT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `awaymessage` VARCHAR( 200 ) NOT NULL ,
ADD `awaysince` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

================================================== ========

What is that?
Reply With Quote
  #2  
Old 08-14-2005, 07:28 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

A SQL Query

[sql]ALTER TABLE `user` ADD `awaystatus` INT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `awaymessage` VARCHAR( 200 ) NOT NULL ,
ADD `awaysince` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL [/sql]
Reply With Quote
  #3  
Old 08-14-2005, 07:28 PM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

your forum is based on sql tables .. you need to run a query to update / change / add to the table structure in order to make a hack work sometimes.

You can either do this in your admincp >> Maintenance >> Execute sql query or run it in phpmyadmin.
Reply With Quote
  #4  
Old 08-14-2005, 07:48 PM
mbracing's Avatar
mbracing mbracing is offline
 
Join Date: Jul 2005
Location: NJ
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by KirbyDE
A SQL Query

[sql]ALTER TABLE `user` ADD `awaystatus` INT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `awaymessage` VARCHAR( 200 ) NOT NULL ,
ADD `awaysince` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL [/sql]
ok im very confussed now, i clicked the link you gave me, and pressed download, and it brings me to this page with purple highlighting on it. How do i download PHPmyadmin???
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:25 PM.


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.03642 seconds
  • Memory Usage 2,185KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete