Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Module CMPS: Add vBGallery Image comments Details »»
Module CMPS: Add vBGallery Image comments
Version: 1.00, by Zachariah Zachariah is offline
Developer Last Online: Jan 2020 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 04-18-2006 Last Update: 05-11-2006 Installs: 8
Template Edits
Additional Files  
No support by the author.

/* -----------------4/19/2006 12:41PM -----------------

Add Gallery Image comments to CMPS Block

Tested on:
  • vBulletin 3.5.4
  • PhotoPost vBGallery v1.0.2
  • vBadvanced CMPS v2.0.1

DEMO - ? Recent Gallery Comments
  1. Number of comments to display in a block
  2. Size of thumbnails
  3. Comment Text Cutoff
  4. BBCodes
  5. Smilles



1 query added to CMPS page



--------------------------------------------------*/

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 04-20-2006, 06:42 PM
klaush klaush is offline
 
Join Date: Oct 2005
Posts: 340
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Zachariah

@klaush
Hey dude your site is looken good
You know, that your pp vBGallery hacks are the main and important hacks on our site? Yes, you know that! :-)
Reply With Quote
  #13  
Old 05-12-2006, 05:17 PM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Added:
- functions_gallery_store.php

This method works for PHP4x , 5x. I have tested this and it works.

This will "globalize" the needed $phrasegroup and $specialtemplates with 1 file edit so no other file edits are needed on hacks that need the gallery's:

- $phrasegroups
- $specialtemplates

--------------------------------

* This will add all the needed file edits for gallery add-ons.
* This will work on ALL VB powered pages
* This will work on vBAdvanced CMPS pages
* This will work on vPortal pages and Blocks
* This only needs to be done once

- I will update any hack I create with this method. The file will be with every hack until a standard can be added to the main build.

http://www.photopost.com/forum/showthread.php?t=123315
Reply With Quote
  #14  
Old 12-15-2006, 01:42 AM
thegodfather2 thegodfather2 is offline
 
Join Date: Dec 2006
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

just wondering if this can be used to rate pictures... like hot or not, or if you know of something that can be installed to be used with vb3.6, that will have same functions...

i tryed i-rater, but... really need to know what your doing to try and incorporate with vb. over my head
Reply With Quote
  #15  
Old 01-03-2007, 02:53 PM
klaush klaush is offline
 
Join Date: Oct 2005
Posts: 340
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi Zach; we need to exclude one or two categories.

Possible?

Thanks!
Reply With Quote
  #16  
Old 01-03-2007, 08:08 PM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by klaush View Post
Hi Zach; we need to exclude one or two categories.

Possible?

Thanks!
Edit the file:
- forums/modules/vbg_comments.php

Add Bold:
Code:
$getposts = $db->query("
	SELECT posts.title, posts.userid, posts.username, posts.dateline, posts.pagetext, posts.imageid, posts.visible, posts.allowsmilie, posts.iconid, posts.showsignature, posts.ipaddress, images.userid as imageuserid, images.filename,images.extension, images.height, images.width, images.thumbname
	FROM " . TABLE_PREFIX . "adv_gallery_posts as posts
	LEFT JOIN " . TABLE_PREFIX . "adv_gallery_images AS images ON (images.imageid = posts.imageid)
	WHERE images.catid NOT IN (6,7,8,9)
	ORDER BY dateline DESC
	LIMIT " . $vba_options[comments_block_count]
);
In the EX: I used ID's: 6,7,8,9
Reply With Quote
  #17  
Old 01-04-2007, 08:29 AM
klaush klaush is offline
 
Join Date: Oct 2005
Posts: 340
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks, Zach. This was the half step!:-)

It excludes the picture but not the comment.

Any idea?
Reply With Quote
  #18  
Old 01-08-2007, 08:01 PM
klaush klaush is offline
 
Join Date: Oct 2005
Posts: 340
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Zach? Any idea?
Reply With Quote
  #19  
Old 01-23-2007, 01:05 AM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by klaush View Post
Zach? Any idea?
Post 15 updated
Reply With Quote
  #20  
Old 01-23-2007, 03:34 AM
klaush klaush is offline
 
Join Date: Oct 2005
Posts: 340
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Zachariah View Post
Post 15 updated
Thanks, Zach, that did the trick!
Reply With Quote
  #21  
Old 01-28-2007, 11:26 AM
puregraf's Avatar
puregraf puregraf is offline
 
Join Date: May 2006
Posts: 175
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hi, i went to install and i got this error after i added the line :

require_once(CWD . '/includes/functions_gallery_store.php');

to the required place on init.php under :
require_once(CWD . '/includes/class_core.php');


error:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Active Graffiti Picture Gallery. Only the BEST Artists Accepted, 100% Quality. Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
<!--
blockquote { margin-top: 75px; }
p { font: 11px tahoma, verdana, arial, sans-serif; }
-->
</style>
</head>
<body>
<blockquote>
<blockquote>
<p><strong>There seems to have been a problem with the Active Graffiti Picture Gallery. Only the BEST Artists Accepted, 100% Quality. database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="<A href="mailtog@puregraffiti.com">Technical">mailt og@puregraffiti.com">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>

<!--
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;
MySQL Error : Unknown column 'language.phrasegroup_adv_gallery' in 'field list'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 05:21:49 AM
Script : http://www.puregraffiti.com/graffiti-space/index.php
Referrer : http://www.puregraffiti.com/graffiti...ex.php?do=head
IP Address : 201.9.197.133
Username :
Classname : vb_database
-->

</blockquote>
</blockquote>
</body>
</html>


i removed the line, and the error disapeared. the files are currently both uploaded the the correct locations and I await instructions on why im receiving this database error.


thanks
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04621 seconds
  • Memory Usage 2,315KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete