questions i could use some help on

[boo.3]

1. How do i create a "query" what is a query and where would i go to make one ?? :squareeyed:

this is another hack i'm stuff on with querys

This is optional, but will speed up the query if you have a large number of members;

Run the following SQL query;

ALTER TABLE user ADD INDEX (lastactivity)

* what would i do ? *

2. where is the "FORUMHOME Template?" * is it in my admin CP? or ftp? :squareeyed:

3. whats the dif from "forum's root folder" and "forum's root directory" ? where would i find the root folder? the forum's root directory is the main folder? right?

4. i'm stuck on a hack that has this "First of all run insert.sql in PHPMYADMIN or MySQLcc or
through your vBulletin area if you're allowed to do so.
It holds all the necassary database changes!
After successfully modified the database... continue!"

* where do i find PHPMYADMIN?*

######################

i'm not a big coder but i would like to learn how this stuff works

huge thanks for anyone who anwsers my questions!!!! :nervous:

[Zachery]

1. How do i create a "query" what is a query and where would i go to make one ??

this is another hack i'm stuff on with querys

This is optional, but will speed up the query if you have a large number of members;

Run the following SQL query;

ALTER TABLE user ADD INDEX (lastactivity)

* what would i do ? *

If you dont know what a query is, you should not be making them, you would go into phpmyadmin, select your database, and run that or run it from the command line.

2. where is the "FORUMHOME Template?" * is it in my admin CP? or ftp?

AdminCP > Styles & Templates > Style Manager > Click on << >> > Find the FORUMHOME Group, expand it > Double click or click on the edit link for the FORUMHOME template.

3. whats the dif from "forum's root folder" and "forum's root directory" ? where would i find the root folder? the forum's root directory is the main folder? right?

It is the lowest level folder with all your vBulletin files in it

4. i'm stuck on a hack that has this "First of all run insert.sql in PHPMYADMIN or MySQLcc or
through your vBulletin area if you're allowed to do so.
It holds all the necassary database changes!
After successfully modified the database... continue!"

* where do i find PHPMYADMIN?*

Depends on your host, if you login to cpanel, its under mysql databases, if your host does not have some sort of control center for you to login to you might need to install it yourself


You should really take some time in learning vB before you run off adding hacks to it.

[boo.3]

ok thanks for your help!

yes i have a C-panel

its my 1st time using vBulletin and i have figed out the basics now i would like to install some hacks * like the arcade one *

my old forums was a IBP 1.0.3 i knew how to work that pretty well.

again huge thanks for answering my questions

[Zachery]

Originally Posted by boo.3

ok thanks for your help!

yes i have a C-panel

its my 1st time using vBulletin and i have figed out the basics now i would like to install some hacks * like the arcade one *

my old forums was a IBP 1.0.3 i knew how to work that pretty well.

again huge thanks for answering my questions

Not a problem