AdminCP → Maintenance → Diagnostics → System Information MySQL's SHOW TABLE STATUS command helps gather information about tables in a database. When executed, it provides a detailed overview of various metrics related to each table in the database. This information can be valuable for database administrators and developers to optimize performance, troubleshoot issues, and better understand their databases' structure. Let's delve into the output of MySQL's SHOW TABLE STATUS command and underst...
-
Understanding MySQL's Table Status Output
- Created by: Wayne Luke
- Published: Thu 22 Feb '24, 10:13am
- 55 views
- 0 comments
-
vbevent.php
- Created by: Wayne Luke
- Published: Mon 8 Jan '24, 10:28am
- 97 views
- 0 comments
vbevent.php
(vBulletin 6+) This script will handle running the vbulletin offline events (Such as sending notifications for a post). This avoids having users trigger AJAX calls when hitting the site. It also avoids the problem where the background tasks fail to run because there is not enough traffic to trigger all of the scripts in a timely fashion. To use do the following: Copy the script from the do_not_upload directory of your vBulletin files to your web server. Preferably outside of the web root directory. S... -
vbcron.php
- Created by: Wayne Luke
- Published: Mon 8 Jan '24, 10:24am
- 55 views
- 0 comments
vbcron.php
This script will handle running the vbulletin schedule tasks (see the Scheduled Tasks menu in the Admincp). This avoids having users trigger ajax calls when hitting the site. It also avoids the problem where the scheduled tasks fail to run because there is not enough site traffic to trigger all of the scripts in a timely fashion.
To use do the following
- You will find this script in your
do_not_upload
directory. Copy the script to your web server. Preferably outside of the w...
Last edited by Wayne Luke; Fri 26 Jan '24, 8:25am. -
Changing your site's favicon
- Created by: Wayne Luke
- Published: Tue 21 Nov '23, 10:39am
- 199 views
- 0 comments
Changing your site's favicon
The favicon allows you to extend your brand identity to the browser tab. This can often be the only thing a user sees if they have many tabs open. The favicon is a special 16 X 16 icon that the browser automatically looks for in the root directory of your site. vBulletin also ships with one in its root directory. If vBulletin is installed in the root directory of your site, you can overwrite the provided icon to change it for your users. However, you will need to remember to do this with every version... -
Common Mime Types
- Created by: Wayne Luke
- Published: Tue 21 Nov '23, 10:30am
- 88 views
- 0 comments
Common Mime Types
vBulletin allows the upload of file attachments. Servers and browsers generally recognize the type of file using two methods; file extensions and MIME types. This document is to allow you to match extensions with MIME types so they are properly handled by browsers. table {width: 80%; margin-left:auto; margin-right:auto} table td:first-child { text-align:center} tr:nth-child(even) {background: #CCC} tr:nth-child(odd) {background: #FFF} th{ color: white; background: black; } Media Images ... -
Including Custom PHP in Templates.
- Created by: Wayne Luke
- Published: Mon 20 Nov '23, 9:42am
- 20 comments
Including Custom PHP in Templates.
We've created a new package that is intended to facilitate the replacement of custom PHP modules with custom Display Template modules. It also demonstrates how to create custom API functions in general. You will find this package attached below. Steps to replace a PHP module Module Edit the api/main.php file Find the customWidgetHtml function Copy your php code from the module into the function. Change the code to generate a string value instead of echoing content and set that to the $myhtml par...Last edited by Wayne Luke; Tue 26 Apr '22, 2:38pm. -
About .htaccess
- Created by: Wayne Luke
- Published: Mon 11 Sep '23, 11:57am
- 304 views
- 0 comments
About .htaccess
.htaccess is a configuration file for the Apache Web Server. It allows you to customize how your server works. Depending on how your hosting provider has the server configured, you can redirect people to different locations, secure directories and files, tell browsers how long to cache files, update PHP variables, and more. vBulletin comes with a pretty extensive .htaccess file that does a these things for you. Location vBulletin comes with a file named htaccess.txt in the original download. When ... -
vBulletin Database Tools
- Created by: Wayne Luke
- Published: Thu 10 Aug '23, 12:49pm
- 28 comments
vBulletin Database Tools
The vBulletin Database Tools are a series of command line scripts that allow you to quickly make modifications to your database in order to provide performance fixes and update them to UTF8 standards. IMPORTANT- These files must be run via the command line, either if you have local access to the server or ssh access. If you are on shared hosting your access may be limited. You may ask your host for ssh access. If they say it is not available ask if they will run the commands for you. These scri...Last edited by Wayne Luke; Mon 31 Oct '22, 8:46am. -
Answered Topics
- Created by: Mark.B
- Published: Sun 8 Jan '23, 11:43am
- 0 comments
Answered Topics
In vBulletin 5.6.5, we added a new feature - Answered Topics.
Topics can now be marked as "Answered." This is a special status applied to a specific post within the topic. The post that is marked as the Answer will be highlighted and show directly under the starting post in the topic.
The ability to mark posts as the Answer in a topic is controlled by permissions. There are three different permissions to control this.
Usergroup and Channel Permissions both...Last edited by Mark.B; Sun 8 Jan '23, 12:17pm. -
How To Find StyleVars in vB4 Using Firebug
- Created by: Trevor Hannant
- Published: Fri 6 Jan '23, 11:37am
- 1 comment
How To Find StyleVars in vB4 Using Firebug
Following on from many queries on how to find a specific StyleVar in vBulletin 4, here's a short video tutorial on how to use the free Firebug add-on for Firefox in conjunction with your AdminCP to find and edit these.
Note that Internet Explorer and Google Chrome also have toolbars that can provide the information seen in the above video.
Download links:
Firefox
Firebug Add-on...
Categories
Latest Articles
-
by Wayne Luke
AdminCP → Maintenance → Diagnostics → System Information MySQL's SHOW TABLE STATUS command helps gather information about tables in a database. When executed, it provides a detailed overview of various metrics related to each table in the database. This information can be valuable for database administrators and developers to optimize performance, troubleshoot issues, and better understand their databases' structure. Let's delve into the output of MySQL's SHOW TABLE STATUS command and underst...
-
Channel: Reference
Thu 22 Feb '24, 10:13am -
-
by Wayne Luke(vBulletin 6+) This script will handle running the vbulletin offline events (Such as sending notifications for a post). This avoids having users trigger AJAX calls when hitting the site. It also avoids the problem where the background tasks fail to run because there is not enough traffic to trigger all of the scripts in a timely fashion. To use do the following: Copy the script from the do_not_upload directory of your vBulletin files to your web server. Preferably outside of the web root directory. S...
-
Channel: Reference
Mon 8 Jan '24, 10:28am -
-
by Wayne Luke
This script will handle running the vbulletin schedule tasks (see the Scheduled Tasks menu in the Admincp). This avoids having users trigger ajax calls when hitting the site. It also avoids the problem where the scheduled tasks fail to run because there is not enough site traffic to trigger all of the scripts in a timely fashion.
To use do the following
- You will find this script in your
do_not_upload
directory. Copy the script to your web server. Preferably outside of the w...
-
Channel: Reference
Mon 8 Jan '24, 10:24am - You will find this script in your
-
by Wayne LukeThe favicon allows you to extend your brand identity to the browser tab. This can often be the only thing a user sees if they have many tabs open. The favicon is a special 16 X 16 icon that the browser automatically looks for in the root directory of your site. vBulletin also ships with one in its root directory. If vBulletin is installed in the root directory of your site, you can overwrite the provided icon to change it for your users. However, you will need to remember to do this with every version...
-
Channel: Tutorials
Tue 21 Nov '23, 10:39am -
-
by Wayne LukevBulletin allows the upload of file attachments. Servers and browsers generally recognize the type of file using two methods; file extensions and MIME types. This document is to allow you to match extensions with MIME types so they are properly handled by browsers. table {width: 80%; margin-left:auto; margin-right:auto} table td:first-child { text-align:center} tr:nth-child(even) {background: #CCC} tr:nth-child(odd) {background: #FFF} th{ color: white; background: black; } Media Images ...
-
Channel: Reference
Tue 21 Nov '23, 10:30am -
-
by Wayne Luke.htaccess is a configuration file for the Apache Web Server. It allows you to customize how your server works. Depending on how your hosting provider has the server configured, you can redirect people to different locations, secure directories and files, tell browsers how long to cache files, update PHP variables, and more. vBulletin comes with a pretty extensive .htaccess file that does a these things for you. Location vBulletin comes with a file named htaccess.txt in the original download. When ...
-
Channel: Tutorials
Mon 11 Sep '23, 11:57am -