Month: March 2011

vBulletin: How to add more buttons to quick reply box toolbar?

When people are replying to a thread, going advanced editing would require an extra click as well as page loading time — very inconvenient. However, atĀ gotalk.org, users would generally want to post a lot of code because it’s a programming language forum in nature. But vBulletin doesn’t come with a CODE button in the quick …

vBulletin: How to add more buttons to quick reply box toolbar? Read More »

vBulletin: Change default height of editor and quick reply box

The quick reply box of vBulletin is by default about 100px or less in height which is bit small for large chunks of text editing such as code. To change the default height of the quick reply box without having to click the enlarge button manually every time, you’ll have to edit the template: Changing …

vBulletin: Change default height of editor and quick reply box Read More »

How to Change the Homepage Title of vBulletin Forum?

By default, only the forum name / title is displayed in the <title></title> tag of the homepage of your vBulletin forum, which is far from ideal in terms of SEO. One should give a much more descriptive title to the home page of the forum other than the mere name of it. To do this: …

How to Change the Homepage Title of vBulletin Forum? Read More »

MySQL: Get the exact size of a database by SQL query

phpMyAdmin doesn’t show the exact size in MB when the size of your database exceeds 1GB. It just shows something like 4.2GB, truncating everything out in the 100MB precision. So is it possible to get the database size in MB in exact numbers using MySQL query? Yes, it is: SELECT CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH – DATA_FREE) …

MySQL: Get the exact size of a database by SQL query Read More »

Pure CSS Rounded Corner, No Images

Though it does look great, I haven’t given it a try until the other day when I was developing smartbabynames.com. Notice the previous and next link immediately below the boy image at here: http://www.smartbabynames.com/meaning/boy/Langleigh/ They look and feel great. So here’s what I’ve done to achieve the rounded corner box in pure CSS — no …

Pure CSS Rounded Corner, No Images Read More »

MySQL: Find non-ASCII characters in a table column

ASCII is the most fundamental character set that has been around since the early days of command line interfaces. There are 128 (0 – 127) most basic ASCII characters such as a-z, A-Z, 0-9, and all the printable punctuations you can type out by a single strike of your keyboard. As all ASCII characters have …

MySQL: Find non-ASCII characters in a table column Read More »