';
$query = 'SELECT * FROM feedback WHERE fb_wiki="' . $fb_wiki .
'" and fb_date="' . $fb_date . '"
ORDER BY fb_timestamp DESC';
$result = mysql_query( $query );
$num=mysql_numrows($result);
echo "Total rows for " . $fb_date . " in this result: " . $num . "
";
$i=0;
while ($i < $num) {
$fb_option = mysql_result($result,$i,'fb_option');
if ( $fb_option < 1 ) $fb_option = "";
if ( $fb_option > 0 ) $fb_option = "(" . $fb_option . ")";
$fb_revid = mysql_result($result,$i,'fb_revid');
if ( $fb_revid < 2 ) {
$fb_revid = "" ;
} else {
$fb_revid = "(revid=" . $fb_revid . ")";
}
$fb_lang = substr($fb_wiki, 0, 2);
$fb_mywikt = substr($fb_wiki, 2);
if ( $fb_mywikt == "wiki" ) $fb_mywikt = "wikipedia";
echo mysql_result($result,$i,'fb_count') . " - " .
'' .
mysql_result($result,$i,'fb_page') .
" " .
$fb_revid . " - " .
$fb_option . " " .
mysql_result($result,$i,'fb_comment') . "
\n" ;
$i++;
}
mysql_close();
exit;
}
$query = 'SELECT * FROM feedback WHERE fb_wiki="' .
$fb_wiki .
'" and fb_page="' .
$fb_page .
'" and fb_comment = "' .
$fb_comment .
'" and fb_date = "' .
$fb_date .
'"';
$result = mysql_query($query);
if ( mysql_numrows($result) < 1 ) {
$query = 'INSERT INTO feedback ' .
'(fb_wiki, fb_page, fb_comment, fb_date, fb_count, fb_option, fb_revid) VALUES ("' .
$fb_wiki . '","' .
$fb_page .
'","' . $fb_comment .
'","' . $fb_date . '", "0", "' .
$fb_option . '", "' . $fb_revid . '")' ;
$result = mysql_query($query);
$query = 'SELECT * FROM feedback WHERE fb_wiki="' .
$fb_wiki
. '" and fb_page="' .
$fb_page .
'" and fb_comment = "' .
$fb_comment .
'" and fb_date = "' .
$fb_date .
'"';
$result = mysql_query($query);
}
if ( $fb_lastip == mysql_result($result, 0, 'fb_lastip') ) exit;
$num = mysql_result($result, 0, "fb_count") ;
$num = $num + 1 ;
$query = "UPDATE feedback SET fb_count='" . $num . "', " .
"fb_lastip='" . $fb_lastip . "' WHERE fb_wiki='" .
$fb_wiki . "' AND fb_page = '" .
$fb_page . "' AND fb_comment = '" .
$fb_comment . "' AND fb_date = '" .
$fb_date . "'" ;
$result = mysql_query($query);
if(!$result) Die("ERROR: No result returned.");
echo "The number of clicks so far is: $num.";
mysql_close();
?>