Select which part of the site you would like to view by clicking on the links below.
The pictures are currently offline as they have become too old.
If you wish to email me, please use the contact form.
||MySQL queries that can help vBulletin Forum Administrators
This is a collection of 10 MySQL queries that vBulletin Forum Administrators will find helpful.
Table prefixes are not used in these examples, so if your database uses them, simply insert your prefix
before any table name you may see.
Without a prefix:
SELECT userid FROM user WHERE username = 'Lats'
With a prefix of vb3_
SELECT userid FROM vb3_user WHERE username = 'Lats'
|Promote by referrals|
|Update posts without signatures|
|Select users in an age range|
|Replace old domain with new|
|Most popular forums|
|Who referred who|
|Top posters in forums|
|Who voted and when|
|Who didn't vote|
The queries are shown in a easy to read format and may not
work directly within the Admin Control Panel without removing the vertical spacing. They do however work
well within phpMyAdmin