[tjmaxwell]

Hi,

I followed these instructions and it appeared to be working fine, but now I'm getting random database errors in certain threads:

                SELECT *
                FROM video 
                WHERE (userid = );

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Error Number  : 1064

Any ideas why this might be happening? I really want to be able to use this.

Originally Posted by CypherSTL

Alright, seen a few of you asking for this, and I wanted something like this as well for an Off-Road 4x4 Forum I'm working on.

To add a "View My Videos" link to your postbit, only if the user has videos, here is the following template, and plugin.

View My Video's Link:
TEMPLATE
--------
Title: video_postbit

Template Code:

<!-- show vid link -->
<div>
<br>
<a href="video.php?do=viewuser&userid=$post[userid]">View My Videos</a><br />
</div>
<!-- /show vid link -->

PLUGIN
------
Name: Video Directory - Display Video Link in Profile
Hook Location: postbit_display_start
Execution Order: 5

Plugin PHP Code:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'showthread') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply'))
{
    global $db, $vbulletin;
    {
        if (THIS_SCRIPT == 'private')
        {
            $this->post['userid'] =& $post['fromuserid'];
        }
            $alluservideos =  $db->query_read("
                SELECT *
                FROM " . TABLE_PREFIX . "video 
                WHERE (userid = ".$this->post['userid'].")
                ");

            $db->num_rows($alluservideos);

            if ($db->num_rows($alluservideos) > 0)
            {
                eval('$template_hook[\'postbit_userinfo_right\'] .= "' . fetch_template('video_postbit') . '";');
            }
                $db->free_result($alluservideos);
    }
}

Navigation Link Suggestion:
Since the link is added to the navigation bar via plug-ins and some people have vbAdvanced, or another form of CMS/Portal page, this edit for that plugin will automatically add the Forum URL to the link.

Plug-In Name: Navbar-Link
Product: Video-Directory

if ($vbulletin->options['videodirectory_navbarlink_hook'] == 1)
{
    $template_hook['navbar_buttons_left'] .= '<td class="vbmenu_control"><a href="'.$vbulletin->options['bburl'].'/video.php'.$session['sessionurl'].'">'.$vbphrase['video_directory'].'</a></td>';
}

if ($vbulletin->options['videodirectory_navbarlink_hook'] == 2)
{
    $template_hook['navbar_quick_links_menu_pos1'] .= '<tr><td class="vbmenu_option"><a href="'.$vbulletin->options['bburl'].'/video.php'.$session['sessionurl'].'">'.$vbphrase['video_directory'].'</a></td></tr>';
}

if ($vbulletin->options['videodirectory_navbarlink_hook'] == 3)
{
    $template_hook['navbar_community_menu_end'] .= '<tr><td class="vbmenu_option"><a href="'.$vbulletin->options['bburl'].'/video.php'.$session['sessionurl'].'">'.$vbphrase['video_directory'].'</a></td></tr>';
}

Jaxel, feel free to add these to the mod if you would like.