vb.org Archive
Page 7 of 9 « First 56 7 89
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Photopost Latest uploads in user profile (https://vborg.vbsupport.ru/showthread.php?t=111893)

phkk 05-16-2006 11:42 PM
if you are using diff database or and database account
delete //

the original of the plug in is
//$link=mysql_connect("localhost","$dbuserid","$dbus erpassword") OR die("I cannot connected to the Database");
//mysql_select_db("products") OR die("failed to select PhotoPost Database");

make them become . delete the // . your forum will connect to your database

$link=mysql_connect("localhost","$dbuserid","$dbus erpassword") OR die("I cannot connected to the Database");
mysql_select_db("products") OR die("failed to select PhotoPost Database");

bada_bing 05-17-2006 02:39 AM
Is there a way to have it display more then one row ? I am showing 3 images so that it will allign with my style correctly but I would like to add two rows and 3 images per row

glowinggal 05-18-2006 12:23 PM
Quote:
Originally Posted by AsukaValentine
I installed it and obtain this error:

Parse error: parse error, unexpected '<' in /home/bbsdream/public_html/member.php(653) : eval()'d code on line 304


This appears at top of users profile, and I don't modify the MEMBERINFO template yet (only in my test template and it doesn't show anything).

I uninstall the plugin and the error persist.

Some fields on my user profile don't show now.
How can I fix it??

I'm getting this as well this morning and when I disable the module - no more errors so it's definetely related to this.

Here is my members.php coding; HAVE NO IDEA what the issue is... but it's something....

I know FOR CERTAIN that my path is correct..... running PP Gallery database on vbulletin - integrated. No database extension prefix.


Parse error: parse error, unexpected '<' in /home/sbbamy/public_html/chat/member.php(651) : eval()'d code on line 1


****** update to the above issue ******
deleted the plug in and then reinstalled it.... .Now receiving this error. Our PP gallery does not have a prefix (as noted above).


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /member.php(651) : eval()'d code on line 34

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /member.php(651) : eval()'d code on line 86

glowinggal 05-18-2006 01:06 PM
Quote:
Originally Posted by Delphiprogrammi
check your database config your datase needs a predix i guess
So what happens if PP doesn't a prefix for the database? Is this not useable :(

futuredood 07-06-2006 04:34 AM
can this be fixed to work with vbgallery? it's pretty much the same file system isn't it, except filenames?

mcyates 07-15-2006 08:37 PM
I'm getting this error:

Warning: mysql_connect(): Access denied for user 'myfootba'@'localhost' (using password: NO) in /member.php(829) : eval()'d code on line 32
I cannot connect to the database.

EVEN though i have entered the username and password for the photopost database. The one at the top and the one at the very bottom.

LICryptkeeper 09-24-2006 12:42 AM
I tried installing it on 3.6.1, installing the plugin breaks member.php :( I really need this!

LICryptkeeper 09-24-2006 01:05 AM
by breaks, I mean nothing shows up.

I did manage to start playing with some connection settings, and now I get "cannot connect" but I know the paths are correct. I'm not sure if it's a VB issue, version isue, or PP issue.

edit: Now I get "failed to select PhotoPost Database" I changed it from 192.168.1.1(which is the pp database) to localhost, do i need to edit anythign else?

I unccomented out the 2 lines in the mysql connection, and the last line. inside confic_inc.php the database user is $mysql_user and in the plugin it's $dbuserid,

is that correct?
vb3.6.1
pp 5.21

edit 2: moved the gallery into the forum directory, still no go.

Code:
$ppath="/home/******/public_html/forums/m_gallery";
require "{$ppath}/config-int.php";
//###################################################################################
//if you use Photopost in a SEPERATED database from vbulletin uncomment these lines
//###################################################################################
$link=mysql_connect("localhost","$dbuserid","$dbuserpassword") OR die("I cannot connected to the Database");
mysql_select_db("products") OR die("failed to 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 = "random";
//######################################################################
if(!isset($ViewPerm))
{
        if(isset($vbulletin->userinfo['usergroupid']))
        {
                $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_is_image( $filename)
{
        $retval = 0;
        $mediatypes = array( ".jpg", ".gif", ".png", ".bmp");
        $ext = pp_get_ext($filename);
        if (in_array(strtolower($ext),$mediatypes)) $retval=1;
        return $retval;
}
switch ($q_switch)
{
        case "latest":
        $query = "SELECT id,user,userid,cat,bigimage,height,width
                        FROM {$pp_db_prefix}photos
                        WHERE storecat = 0 AND userid = $userinfo[userid]
                        ORDER BY date DESC";
                break;
        case "most_view":
        $query = "SELECT id,user,userid,cat,bigimage,height,width
                        FROM {$pp_db_prefix}photos
                        WHERE storecat = 0 AND userid = $userinfo[userid]
                        ORDER BY views DESC";
                break;
        case "random":
        $query = "SELECT id,user,userid,cat,bigimage,height,width
                        FROM {$pp_db_prefix}photos
                        WHERE storecat = 0 AND userid = $userinfo[userid]
                        ORDER BY RAND()";
                break;
}
$result=mysql_query($query);
$counted = 0; $countcol = 0; $profileimagebits = "";
while (list($pid,$puser,$puserid,$pcat,$photo,$height,$width) = mysql_fetch_row($result))
{
        if ( $ViewPerm[$pcat] == 1 ) continue;
        if (pp_is_image($photo))
        {
                $temp_user = $puserid;
                if ($height > $width)
                          $mthumb = "<img src=\"{$url_path}/images/overlay-roundp.gif\" height=\"105\" width=\"81\" border=\"0\" alt=\"\" />";
                else
                        $mthumb = "<img src=\"{$url_path}/images/overlay-round.gif\" height=\"81\" width=\"105\" border=\"0\" alt=\"\" />";
                $profileimagebits .= <<<PPPRINT
    <td align="center" class="alt1">
        <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td style="background: url({$data_dir}{$pcat}/thumbs/$photo); background-color: #000000; background-repeat: no-repeat; background-position: center;"><a href="{$url_path}/showphoto.php?photo={$pid}">$mthumb</a></td>
        </tr>
        </table>
    </td>
PPPRINT;
        $counted++;
        $countcol++;
        }
        if ($counted == $num_display ) break;
        if ($countcol == $columns)
        {
                $profileimagebits .= <<<PPPRINT
    </tr>
    <tr>
PPPRINT;
    $countcol = 0;
        }
}
@mysql_free_result($result);

//###################################################################################################################
//if you use PhotoPost in a SEPERATED database you need to uncomment this line to reselect it
//###################################################################################################################
//mysql_select_db("products") or die("Unable to select PhotoPost Database");

Delphiprogrammi 10-01-2006 09:39 AM
Quote:
Originally Posted by futuredood
can this be fixed to work with vbgallery? it's pretty much the same file system isn't it, except filenames?
No photopost pro and photopost vbgallerry is a big difference

Delphiprogrammi 10-01-2006 09:41 AM
Quote:
Originally Posted by mcyates
I'm getting this error:

Warning: mysql_connect(): Access denied for user 'myfootba'@'localhost' (using password: NO) in /member.php(829) : eval()'d code on line 32
I cannot connect to the database.

EVEN though i have entered the username and password for the photopost database. The one at the top and the one at the very bottom.
don't fill in both that error means your MySQL account info is not correct


All times are GMT. The time now is 04:15 PM.
Page 7 of 9 « First 56 7 89
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01298 seconds
  • Memory Usage 1,768KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete