Music Video Clips, vBulletin queries, DVD based movie collection, Reverse Australian Phone Book

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.

 



 

Music Video Clips, vBulletin queries, DVD based movie collection, Reverse Australian Phone Book MySQL queries that can help vBulletin Forum Administrators Music Video Clips, vBulletin queries, DVD based movie collection, Reverse Australian Phone Book

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
Average age
Please note: 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 without modification.



SiteUptime Web Site Monitoring Service