[sailnet]

Originally Posted by shaqoneal

Phalynx - my PhotoPost is in a database different from vbulletin so the PhotoPost Pro add-on does not work. Can you please modify the plugin so that it can connect and pull data from the PhotoPost Pro database? It would be much appreciated.

mine is too - so I did a little digging and found that if you go to :
---> Plugin Manager and edit:
---> vBExperience PhotoPost Pro Integration xperience_calcdata

and change the code to the following (assuming you put in your photopost database name, username and password) it will work:

PHP Code:

if (($vbulletin->options['xperience_points_ppprogali'] > 0) OR ($vbulletin->options['xperience_points_ppprogalv'] > 0))
{
    if ($DoDebug == 1) echo "<br/>PhotoPost Pro Images and Image Views";

    $connection = mysql_connect("localhost", "root", "password") or die ("Unable to connect!");
    mysql_select_db("photopost_database_name") or die ("Unable to select database!");            
    $queryq = "select COUNT(id) as cnt_images, sum(views) as sum_views from photos where  WHERE userid=".$user['userid']." GROUP BY userid";        
    if (mysql_num_rows($queryq) > 0)
    {
        $query = mysql_fetch_array($queryq);
                
        if ($vbulletin->options['xperience_points_ppprogali'] > 0)
        {
            $xperience['count_misc_ppprogali'] = $query['cnt_images'] * $vbulletin->options['xperience_points_ppprogali'];
            $xperience['count_misc'] += $xperience['count_misc_ppprogali'];
            $additionalsql .= "points_misc_ppprogali=".$xperience['count_misc_ppprogali'].",";
        }
        
        if ($vbulletin->options['xperience_points_ppprogalv'] > 0)
        {
            $xperience['count_misc_ppprogalv'] = $query['sum_views'] * $vbulletin->options['xperience_points_ppprogalv'];
            $xperience['count_misc'] += $xperience['count_misc_ppprogalv'];
            $additionalsql .= "points_misc_ppprogalv=".$xperience['count_misc_ppprogalv'].",";
        }
        
    }
    mysql_close($connection);
}