vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   Photopost to vb/Home Intergration v1.7 (https://vborg.vbsupport.ru/showthread.php?t=53539)

themonarch 09-02-2003 12:18 AM

I'm trying to tweak this script to just call one user's photo(s) and use that over in each member's profile... here's what I edited in thumbnailer, but it's not working right. It calls user 1's thumbnails.
Code:

//Display Setting (Changes to fit your page)
$q_switch = "theuser";            // "random" or "most_views" or "latest" or "theuser"
$limit = 10;                        //number of image to show
$table_width = "80%";            //width of the table generated
$column = 2;                    //number of columns of the table generated
$photo_cell_align = "center";    //alignment of those cells

and then this further down:
Code:

//added by themonarch
                case "theuser":
            if ( !IsSet($cat) ) {
                $group_title = "Individual Users Photo";
                $query = "SELECT id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating FROM photos WHERE bigimage!='' AND userid='$bbuserid'";
            }
            else {
                $query = "SELECT id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating FROM photos WHERE bigimage!='' AND userid='Sbbuserid'";
                $group_title = "Individual Users Photos";
            }
            break;
                        //themonarch

You can see it here:
http://www.allartistaccess.com/media...2.php?userid=1

If you change the userid to userid=43, it still pulls user 1's images.

Mickie D 09-02-2003 12:50 AM

bloody 3am in the morning i have been doingthis for lol

here is a screenie of my new addon ... and it also has my hacked thumbincluder.php (allowing it to display top uploaders)

sorry all are lame thumbs but its my test board (local) wont add no beta hacks i made to my forums until i test this a bit more

Mickie D 09-02-2003 05:40 PM

@ themonarch

i would be interested in helping you finish this :)

and also i am now making the amount of pictures uploaded show up in post bit (finding this not as easy though)

PixelFx 09-03-2003 09:28 AM

small Note, I'm working on update for photopost 4.1 and reading back the last few posts, mickie some great ideas and looks like work put into this ... I'm working on 2.0 update that will have addons posted soon I hope, got hit with two contracts last few days so should be back on track tomorrow I hope, for a few hours to update before next contract... ;)

I've got huge update on my personal site coming up to test this and some new new features for the thumbnail includer :)

Mickie D 09-03-2003 03:18 PM

yeah i have been playing with this alot :)

i really like this hack and i dont mind sharing with anyone what i have made, also my templates are poor because i was so happy i got it working i just ram'd it on my site asap, i am sorting out my templates now and should have it all done proppa (without the <hr> tag lol to divide it)

also i am working on other ways for the thumbincluder to call other aspects of the photopost database, i will keep everyone posted on what is going on and what i have done.

PS i noted your pm pixelfx about the thumbincluder and modding it (i will tell matt about what i have done to it and ask his permissions b4 i share anything) and i will only post my thumbincluder that i mod on the photopost site !!! :)

Intex 09-04-2003 03:59 PM

Looking forward to these updates guys :). Is anybody on working on some sort of notification when a new gallery photo is uploaded. I think that is one of the most wanted missing elements.

PixelFx 09-04-2003 07:16 PM

I'm currently testing update for photopost 4.1 final vb2 / vb3.0 support for next update. I'm also playing with specific news and catigory linking for specific gallery and vbforums on there own news pages if that made sence. It's working well but still testing, I'm also working on custom templates in photopost 4.1 for better site intergration both on forum home / vbhome / support for vbindex.

Mickie D is also doing a great job on forum home, and pulling other photopost data to the forum home etc. ALthough we are not yet currectly working directly together we have common goals which as you can see in the posts above help the community over all.

I'm still relatively new to hacking vbulletin, so this is a learning process for me which is quite fun, however is time consumming so I'll try and support and post updates in a timely manner. :)

Harlequin 09-16-2003 12:17 AM

There's something important to mention here (if it hasn't been mentioned already somewhere in this thread).


I was receiving the 'Query Failed' message for a day or two until I finally started searching around on threads and found someone's solution that worked like a charm, and while I forget who it is, they're a great, great person to get this going and noticing something that I had completely skipped.


In an untouched thumbinclude.php around line 177 they'll be a bunch of these similiar-looking $query statements. >

$query = "SELECT id,user,userid,cat,title,bigimage,views FROM photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";


Note the 'photos'.



It's a simple oversight, but if you've added a prefix on to Photopost's queries during it's install, say 'photopost_photos' (as I have it on my forum), then you would most certainly get the Query Failed message as I did.


So to remedy this, I added the prefix:

$query = "SELECT id,user,userid,cat,title,bigimage,views FROM photopost_photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";


And boom, it came up and worked beautifully.


Each of the $query statements in the thumbinclude.php need to be edited the same way if they're making a call to 'photos' rather than, like in my example, 'photopost_photos'.

<edit>

Btw, ty Pixel and Mickie. :)

And heck, this may have actually been mentioned in this thread. My brain ain't with it.

PixelFx 09-16-2003 05:49 AM

thanks for the update, I haven't gotten your error, but it's good to get every angle possible sorted out :)

I just setup my local webserver on xp so will be trying to install on it this hack to test it there as well. Then update my txt files, and add mickie D hack info as well :)

do you have a link for your site? would be nice to see how you made use of the script :)

Harlequin 09-17-2003 09:29 AM

I'm not releasin' anything about the site just yet. ;) It's one of those 'in beta' things.


Though I've converted this to work with vBIndex, though it wasn't that hard or anything to just move the variables over.


All times are GMT. The time now is 03:35 PM.

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.01198 seconds
  • Memory Usage 1,747KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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