PP Classifieds Modul

<?php
require $vbulletin->options['pppath'].'/config-int.php';

$dbhost = $vbulletin->options['dbhost'];
$dbuser = $vbulletin->options['dbuser'];
$dbpass = $vbulletin->options['dbpass'];
$dbname = $vbulletin->options['db1'];
$link = mysql_connect ("$dbhost", "$dbuser", "$dbpass") or die('I cannot connect to the database.');
mysql_select_db ("$dbname")or die("Could not select photopost database");

// Number of photos to display
$num_display = 4;

// Number of columns (1 for vertical)
$columns = 4;

// which type of images do you want to show (random, most_view, latest)
$q_switch = "latest";


// == END CONFIGURATION ==
////////////////////////////////////////////////////////////////////////////

if ( !isset($ViewPerm) )
{
    if ( isset($bbuserinfo['usergroupid']) )
    {
        $mygroups = $bbuserinfo['usergroupid'];

        if ( $bbuserinfo['membergroupids'] != "" )
        {
            $mygroups .= ",".$bbuserinfo['membergroupids'];
        }
    }
    else
    {
        // vB3.5 uses $vbulletin
        $mygroups = $vbulletin->userinfo['usergroupid'];

        if ( $vbulletin->userinfo['membergroupids'] != "" )
        {
            $mygroups .= ",".$vbulletin->userinfo['membergroupids'];
        }
    }

    $grouparr = explode( ",", $mygroups );

    $resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories");
    $ViewPerm = array();

    while ( list( $catugid, $ugnoview ) = mysql_fetch_row($resultb) )
    {
        $noview=0;
        $ViewPerm[$catugid] = 1;

        $allnoview = explode( ",", $ugnoview );

        foreach ($allnoview as $key)
        {
            if (in_array($key, $grouparr) )
            {
                $noview = 1;
            }
        }

        if ( $noview == 0 )
        {
            $ViewPerm[$catugid]=0;
        }
    }
}

function pp_get_ext( $filename )
{
    return substr($filename, strrpos($filename,"."));
}

function pp_get_filename($filename)
{
    return str_replace( pp_get_ext($filename), "", $filename );
}

function pp_is_image( $filename )
{
    $mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
    $ext = pp_get_ext( $filename );

    if ( in_array(strtolower($ext), $mediatypes) )
    {
        return( true );
    }

    return( false );
}

function pp_is_multimedia( $filename )
{
    $mediatypes = array( ".avi", ".mov", ".mpg", ".mpeg", ".swf", ".flv" );
    $ext = pp_get_ext( $filename );

    if ( in_array(strtolower($ext), $mediatypes) )
    {
        return( true );
    }

    return( false );
}

$resultc = mysql_query("SELECT setting FROM {$pp_db_prefix}settings WHERE id=133");
list( $seotype ) = mysql_fetch_row($resultc);

$resultd = mysql_query("SELECT setting FROM {$pp_db_prefix}settings WHERE id=6");
list( $data_full ) = mysql_fetch_row($resultd);
//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

switch ($q_switch)
{
    case "most_view":
        $query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.title,c.catname,c.photos,c.posts
                        FROM {$pp_db_prefix}photos p
                        LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
                        WHERE c.password = '' AND p.storecat = 0
	                ORDER BY views DESC";
        break;

    case "latest":
        $query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.title,c.catname,c.photos,c.posts
                        FROM {$pp_db_prefix}photos p
                        LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
                        WHERE c.password = '' AND p.storecat = 0
                        ORDER BY date DESC";
        break;

    default:
        $query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.title,c.catname,c.photos,c.posts
                        FROM {$pp_db_prefix}photos p
                        LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
                        WHERE c.password = '' AND p.storecat = 0
                        ORDER BY RAND()";
}
$result = mysql_query($query) or die(mysql_error());

$counted = 0;
$countcol = 0;
$pppro_imagebits = null;
$pppro_imagebits .= '<table cellpadding="0" cellspacing="0" border="0" width="100%"><tr>';
while (list($pid,$puser,$puserid,$pcat,$photo,$ptitle,$catname,$cphotos,$cposts) = mysql_fetch_row($result))
{

    if ( pp_is_image($photo)|| pp_is_multimedia($photo) )
    {
	    if ( pp_is_image($photo) )
	    {
	        if ( $seotype == "seo" )
	        {
	            $plink = "<td><a href=\"{$url_path}/$catname/p{$pid}-{$ptitle}.html\"><img src=\"{$data_dir}{$pcat}/thumbs/$photo\" border=\"0\" alt=\"\" /></a><br />";
	            $catlink = "<a href=\"{$url_path}/g{$pcat}-{$catname}.html\">$catname</a><br />";
	        }
	        else
	        {
	            $plink = "<td><a href=\"{$url_path}/showphoto.php?photo={$pid}\"><img src=\"{$data_dir}{$pcat}/thumbs/$photo\" border=\"0\" alt=\"\" /></a><br />";
	            $catlink = "<a href=\"{$url_path}/showgallery.php?cat={$pcat}\">$catname</a><br />";
	        }
	    }

	    if ( pp_is_multimedia($photo) )
	    {
	        $filenoext = pp_get_filename( $photo );
	        $mmthumb = "{$data_dir}/$pcat/thumbs/$filenoext.jpg";
	        $dirthumb = "{$data_full}/$pcat/thumbs/$filenoext.jpg";

	        if ( !file_exists($dirthumb) )
	        {
	            $mmthumb = "{$url_path}/images/video.gif";
	        }

	        if ( $seotype == "seo" )
	        {
	            $plink = "<td><a href=\"{$url_path}/$catname/p{$pid}-{$ptitle}.html\"><img src=\"{$mmthumb}\" border=\"0\" alt=\"\" /></a><br />";
	            $catlink = "<a href=\"{$url_path}/g{$pcat}-{$catname}.html\">$catname</a><br />";
	        }
	        else
	        {
	            $plink = "<td><br /><a href=\"{$url_path}/showphoto.php?photo={$pid}\"><img src=\"{$mmthumb}\" border=\"0\" alt=\"\" /></a><br />";
	            $catlink = "<a href=\"{$url_path}/showgallery.php?cat={$pcat}\">$catname</a><br />";
	        }
	    }

// One box for each feature
$pppro_imagebits .= <<<PPPRINT

         $plink

        <font size="1" face="verdana,arial">by {$puser}<br />
        · · ·<br />
        $catlink
        $cphotos photos<br />$cposts comments<br /></font>
</td>
PPPRINT;

        $counted++;
        $countcol++;
    }

    // If we've reached our limit, quit
    if ( $counted == $num_display )
    {
        break;
    }

    // If we need to end the column, do so.
    if ( $countcol == $columns )
    {
$pppro_imagebits .= <<<PPPRINT
    </tr>
    <tr>
PPPRINT;

    $countcol = 0;
    }
}
@mysql_free_result($result);

$pppro_imagebits .= '</tr></table';
$templater = vB_Template::create('forumhome_addon');
$templater->register_page_templates();
$templater->register('pppro_imagebits', $pppro_imagebits);

$template_hook['forumhome_above_forums'] .= $templater->render();
echo '<div class="vbcmsmodul collapse">
      <h2 class="blockhead vbcmsmodul_head">
         Neue Galerie-Bilder
      </h2>
      <div class="blockrow vbcmsmodul_body">';

echo $pppro_imagebits;

echo '      </div>
</div>';
?>

$host = 'localhost';
$dbUser = ' ';
$dbPass = '';
$db = '';
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

ob_start();

$result = mysql_query("SELECT id,cat,bigimage FROM cp_products order by rand() LIMIT 1" ) or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
print"<center>";
print "<a href=\"http://mysite.net/pp-classifieds/showproduct.php?product=" . $row['id'] . "&cat=" . $row['cat'] . "\"><img src=\"http:/mysite.net/pp-classifieds/data/" . $row['cat'] . "/thumbs/" . $row['bigimage'] . "\" border=\"0\"></a>";
print "</center>";
}

$output .= ob_get_contents();
ob_end_clean();

$host = 'localhost';
$dbUser = ' ';
$dbPass = '';
$db = '';
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());


$result = mysql_query("SELECT id,cat,bigimage FROM cp_products order by rand() LIMIT 1" ) or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
print"<center>";
print "<a href=\"http://mysite.net/pp-classifieds/showproduct.php?product=" . $row['id'] . "&cat=" . $row['cat'] . "\"><img src=\"http:/mysite.net/pp-classifieds/data/" . $row['cat'] . "/thumbs/" . $row['bigimage'] . "\" border=\"0\"></a>";
print "</center>";
}