poco rating - add a test module for pulling out ratings

1 files changed, 38 insertions, 0 deletions

diff --git a/mod/prep.php b/mod/prep.php
new file mode 100644
index 000000000..e53f7ac4e
--- /dev/null
+++ b/mod/prep.php
@@ -0,0 +1,38 @@
+<?php
+
+function prep_content(&$a) {
+
+	if(argc() > 1)
+		$hash = argv(1);
+
+	if(! $hash) {
+		notice('Must supply a channel identififier.');
+		return;
+	}
+
+	$p = q("select * from xchan where xchan_hash like '%s'",
+		dbesc($hash . '%')
+	);
+
+	$r = q("select * from xlink left join xchan on xlink_xchan = xchan_hash where xlink_link like '%s' and xlink_rating != 0",
+		dbesc($hash . '%')
+	);
+
+	$ret = array();
+
+	if($p && $r) {
+		$ret['poi'] = $p[0];
+		$ret['raters'] = $r;
+
+		$o = replace_macros(get_markup_template('prep.tpl'),array(
+			'$header' => t('Ratings'),
+			'$poi' => $p[0],
+			'$raters' => $r
+		));
+
+		return $o;
+	}
+	return '';
+}
+
+			
\ No newline at end of file