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

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2004, 06:56 PM
ezsouljahs ezsouljahs is offline
 
Join Date: Oct 2004
Location: VIRGINIA
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default adding mod problem

i just leased vbulletin for a year and got some sweet mods i wanna install but i don't understand when they say Run the following queries.. they say its in the forum database using phpmyadmin but i have no idea on how to do it.. all i get is something like this in the readme..

ALTER TABLE user ADD pettype int(3) NOT NULL
ALTER TABLE user ADD petname varchar(25) NOT NULL
ALTER TABLE user ADD petgender int(3) NOT NULL
ALTER TABLE user ADD petowned int(3) NOT NULL default '0'
Reply With Quote
  #2  
Old 10-20-2004, 06:37 AM
ezsouljahs ezsouljahs is offline
 
Join Date: Oct 2004
Location: VIRGINIA
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^bump
Reply With Quote
  #3  
Old 10-20-2004, 08:33 AM
Colin F's Avatar
Colin F Colin F is offline
 
Join Date: Jul 2004
Location: Switzerland
Posts: 1,551
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

run those sql queries. see the instructions at the top of the box bellow.

[sql]foo[/sql]
Reply With Quote
  #4  
Old 10-20-2004, 08:47 AM
ezsouljahs ezsouljahs is offline
 
Join Date: Oct 2004
Location: VIRGINIA
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thats the thing.. how do i

EDIT.. i saw the link how to do it.. :speechless:
Reply With Quote
  #5  
Old 10-20-2004, 08:59 AM
ezsouljahs ezsouljahs is offline
 
Join Date: Oct 2004
Location: VIRGINIA
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

2] On the right side, once the page loads, scroll down and find the box that says "Run SQL query/queries on database yourdatabasename" above it.

i can't find it.. i only have

Check All / Uncheck All / Check overheaded With selected: Drop Empty Print view Check table Optimize table Repair table Analyze table

--------------------------------------------------------------------------------
Print view Data Dictionary

Create new table on database gunitd_forum:
Name:
Fields:

Rename database to:

at the bottom of the rightside forum database
Reply With Quote
  #6  
Old 10-20-2004, 09:59 AM
neocorteqz's Avatar
neocorteqz neocorteqz is offline
 
Join Date: May 2002
Location: Barefoot Bay Fl
Posts: 473
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you can run queries via the admincp.

AdminCP > Import & Maintenence > Execute SQL query

in PHpmyadmin, Select your DB from the Left panel, then at the top select SQL

in the box run your queries from there.

I believe you can run all of them at the same time, but just in case I'm wrong, run them one at a time.

Note the Crappy Pic edited by paint attached.
Attached Images
File Type: png phpmyadmin2.png (30.6 KB, 0 views)
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 08:22 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.02044 seconds
  • Memory Usage 2,220KB
  • Queries Executed 12 (?)
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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (1)postbit_attachment
  • (6)postbit_onlinestatus
  • (6)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_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
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete