phpBB.de

Code: Alles auswählen

################################################################################
##
##	Mod Title:	Word Cloud
##	Mod Version:	1.0
##	Author:		vgan <transflux@msn.com> (Steve Cvar) http://stevecvar.com
##
##	Description:	Adds a Word Cloud block to your ezPortal. Each word contains a search link that returns topics which contain it.
##			The more often a word has appeared, the larger the font size which will be used to display it.
##			The concept is based on those Tag Clouds you see on everyone's blogs, except that its generated from your word index instead of tags.
##			By default, it displays the 50 most newly mentioned words which have appeared 3 times or more.  
##			These settings can be changed at the top of the mod code in portal.php and will likely need to be tuned a bit for your site.						
##			
##			
##	Compatibility:	2.0.0 - 2.0.22
##
##	Installation Level:	Easy
##	Installation Time:	10 Minutes
##	Files To Edit:		2
##			portal.php
##			templates/subSilver/portal_body.tpl
##
##	History:
##			4-25-2007 - Version 1.0
##				- First Release
##
##	Author Notes:
##		This Mod pulls words from an index of words which appear in ALL forums regardless of a user or groups permissions to access those forums.
##		So, although a user may see words displayed from restricted forums, they will receive a "topic does not exist" error if they click the link.
##
##		The SQL query I use excludes any numbers or words which begin with numbers; otherwise you'd get tons of numbers in your cloud and it's a word cloud, not a number cloud! ;)
##
################################################################################
##
##	Support:      http://www.phpbbhacks.com/forums
##	Copyright:    © 2007 Steve Cvar
##
################################################################################
##
################################################################################
##	Before Adding This MOD To Your Forum,
##	You Should Back Up All Files Related To This MOD
################################################################################

#
#-----[ OPEN portal.php ]------------------------------------------
#

#
#-----[ FIND ]------------------------------------------
#

//
// End session management
//

#
#-----[ AFTER, ADD ]------------------------------------------
#
/////
// 	BEGIN VGAN'S WORD CLOUD MOD
/////

//	Set the minimum count a word must appear before entering the cloud.
$cloud_min = 3;

//	Set the total number of words to display in the cloud.
$cloud_total = 50;

{
$sql = "SELECT phpbb_search_wordlist.word_text, COUNT(phpbb_search_wordmatch.word_id) AS count FROM phpbb_search_wordmatch , phpbb_search_wordlist WHERE phpbb_search_wordmatch.word_id =phpbb_search_wordlist.word_id AND phpbb_search_wordlist.word_text REGEXP '^[a-zA-Z]' GROUP BY phpbb_search_wordmatch.word_id HAVING COUNT(phpbb_search_wordmatch.word_id) >= ". $cloud_min ." ORDER BY phpbb_search_wordmatch.word_id DESC LIMIT 0,". $cloud_total ."";
	if($result = $db->sql_query($sql))
	{
		$cloud_row = $db->sql_fetchrowset($result);
		if (!empty($cloud_row))
		{

			for($j = 0; $j < count($cloud_row); $j++)
			{
				$word_text = $cloud_row[$j]['word_text'];
				$word_count = $cloud_row[$j]['count'];
 
			switch( $cloud_row[$j]['count'])
			{
				case $cloud_min:
					$style_color = 'style="font-size:8px;text-decoration:none;"'; 
					break;
				case $cloud_min + 1:
					$style_color = 'style="font-size:12px;text-decoration:none;"';
					break;
				case $cloud_min + 2:
					$style_color = 'style="font-size:16px;text-decoration:none;"';
					break;
				case $cloud_min + 3:
					$style_color = 'style="font-size:20px;text-decoration:none;"';
					break;
				case $cloud_min + 4:
					$style_color = 'style="font-size:24px;text-decoration:none;"';
					break;
				case $cloud_min + 5:
					$style_color = 'style="font-size:28px;text-decoration:none;"';
					break;
				case $cloud_min + 6:
					$style_color = 'style="font-size:32px;text-decoration:none;"';
					break;
				case $cloud_min + 7:
					$style_color = 'style="font-size:36px;text-decoration:none;"';
					break;
				default:
					$style_color = 'style="font-size:40px;text-decoration:none;"'; 
					break;
			}

			$cloud .= ' <b><a href="' . append_sid("search.$phpEx?mode=results&search_keywords=". $cloud_row[$j]['word_text']) . '"' . $style_color .'title="Appears '. $cloud_row[$j]['count']. ' times">' . $cloud_row[$j]['word_text'] . '</a></b>'; 

			}
			if( empty($cloud_row))
			{
				print 'Sorry, no Cloud for you...';
			}
		}
	}
$db->sql_freeresult($result);
}
/////
////////// END VGAN'S WORD CLOUD MOD
/////

#
#-----[ FIND ]------------------------------------------
#
	'L_VOTE_BUTTON' => $lang['Vote'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
// VGAN'S WORD CLOUD MOD
	'CLOUD' => $cloud,
	'WORD_TEXT' => $word_text[$j],
	'WORD_COUNT' => $word_count[$j],
	'WORD_LINK' => append_sid("search.$phpEx?mode=results&search_keywords=". $word_text[$j]),

#
#-----[ OPEN templates/subSilver/portal_body.tpl ]------------------------------------------
#

#
#-----[ FIND ]------------------------------------------
#
			<input type="hidden" name="mode" value="vote" />
			<!-- END switch_user_logged_in -->
			<br />
		</td>
	   </tr>
	  </table>
	  </form>

	  <br />
#
#-----[ AFTER, ADD ]------------------------------------------
#
	<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">
	 <tr>
		<td class="catHead" height="25"><span class="genmed"><b>Word Cloud</b></span></td>
	 </tr>
	 <tr> 
		<td class="row1">
		{CLOUD}
		<br /><br />
		</td>
	 </tr>
	</table>

	<br />

#
#-----[ SAVE & CLOSE ALL FILES ]--------------------------
#