Quote:
Originally Posted by eoc_Jason
You can make a little icon (or link, whatever you want) and have it display on the postbits template if they have created a profile.
Just edit showthread.php & find the big query around line 844, add your 'vbgarage_users.userid' to the SELECT part, and add a 'LEFT JOIN " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users ON(vbgarage_users.userid = user.userid)
Then in your postbit (or postbit_legacy) template, you can add something like:
Code:
<if condition="$post['vbgarage']"><a href="vbgarage.php?$session[sessionurl]do=view&id=$post[userid]">(image or text here)</a></if>
That way as people read threads, they can go directly to that person's page...
|
Hey, I tried to use your SQL code and while the field I added to the select statement works, the LEFT clause kept giving me errors... would you mind just copy/pasting the full SQL...? Thanks.