Forums / Cotonti / Extensions / [HELP][WIP] Plugin: User Comments

<?PHP
/* ====================
[BEGIN_SED_EXTPLUGIN]
Code=usercomments
Part=user
File=usercomments.user
Hooks=users.details.tags
Tags=users.details.tpl:{USERS_DETAILS_COMCOUNT}
Order=10
[END_SED_EXTPLUGIN]
==================== */

/**
 * Part of plug UserComments
 *
 * @package Cotonti
 * @version 0.6.4
 * @author MusicOnly
 * @copyright All rights reserved. 2008-2009
 * @license BSD
 */

defined('SED_CODE') or die('Wrong URL');

/*----------------------------
----Comment Count-------
----------------------------*/

	$sql1 = sed_sql_query("SELECT * FROM $db_com WHERE com_authorid = $id");
	$noc = sed_sql_numrows($sql1);
	
/*-----------------------------------------
-----Display all user comments------
----------------------------------------*/	
	
	$sac = "<a href='/plug.php?e=usercomments&ui=$id'>".$noc."</a>";
	

	
	$t->assign('USERS_DETAILS_COMCOUNT', $sac );

?>

<?PHP
/* ====================
[BEGIN_SED_EXTPLUGIN]
Code=usercomments
Part=main
File=usercomments
Hooks=standalone
Tags=
Order=
[END_SED_EXTPLUGIN]
==================== */

/**
 * List of all user comments ever made
 *
 * @package Cotonti
 * @version 0.6.4
 * @author MusicOnly
 * @copyright Copyright (c) Cotonti Team 2008-2009
 * @license BSD
 */

defined('SED_CODE') && defined('SED_PLUG') or die('Wrong URL');
	
	$t = new XTemplate(sed_skinfile('usercomments', true));
	
	$sql2 = sed_sql_query("SELECT * FROM $db_com WHERE com_authorid = '$ui'");

	while($row = sed_sql_fetcharray($sql2))
	{
	$t->assign(array(
		'UC_ROW_CID' => $row['com_id'],
		'UC_ROW_CC' => $row['com_code'],
		'UC_ROW_CAI' => $row['com_authorid'],
		'UC_ROW_CA' => $row['com_author'],
		'UC_ROW_CT' => $row['com_text'],
		'UC_ROW_CD' => $row['com_date']
	));
		$t->parse('MAIN.UC_ROW');
	}

?>

<!-- BEGIN: MAIN -->
<div id="fullpage">
You look like you did before
</div>

<!-- BEGIN: UC_ROW -->
{UC_ROW_CID} - {UC_ROW_CC} - {UC_ROW_CAI} - {UC_ROW_CA} - {UC_ROW_CT} - {UC_ROW_CT} - {UC_ROW_CD} <br />
<!-- END: UC_ROW -->

<!-- END: MAIN -->