[vaskies]

[S]Quick syntax question. 10 pages of google turned up nada.

if ($vbulletin->options['threadpreview'] > 0)
	{
		$previewfield = "post.pagetext AS preview,";

I understand this code except for one part: "AS preview,"
Here's my understanding:

If threadpreview is enabled in vbulletin's options,
statement: assigning $previewfield the value of field pagetest in the post table

What language is AS from? It's a PHP if statement so I assume php, but it wasn't covered at all in the tutorials so far. I need to know, because I'm going to need to recreate how vbulletin defined $threadinfo[preview] inside of the plugin.

Edit: It would also help me better understand your post better too. I also see an "ON" in there. [/S]

Google to the rescue :0 http://www.tizag.com/sqlTutorial/sqlas.php
Back to work...