XOOPSモジュール版WordPressでAjaxを使った投票システムを作ってみた

CREATE TABLE `xoops_wp_popularity` (
? `postnumber` int(11) NOT NULL default '0',
? `good` int(11) NOT NULL default '0',
? `bad` int(11) NOT NULL default '0',
? PRIMARY KEY? (`postnumber`)
) TYPE=MyISAM;

<?php
//美乳
//WordPress人気投票(vote.php)
$fail = "fail";

$id = $_GET['id'];
if (!is_numeric($id)){
?print $fail;
?return;
}

$conn = mysql_connect("server","user","password");
mysql_select_db("xoops");

switch ($_GET["vote"]){
?case "good" :
??voteGood($id);
??//print "good: " . $id;
??break;
?case "bad" :
??voteBad($id);
??//print "bad: " . $id;
??break;
?default :
??print($fail);
}

function voteGood($p_number){
?$result = isExsits($p_number);
?$test = 0;
?while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
??$row[1] += 1;
??$sql = sprintf("update xoops_wp_popularity
set good = %d where postnumber = %d;", $row[1], $row[0]);
??@mysql_query($sql);
??$test = 1;
?}
?if ($test == 0) {
??$sql = sprintf("insert into xoops_wp_popularity(postnumber, good, bad)
values(%d, 1, 0);",$p_number);
??@mysql_query($sql);
?}
}

function voteBad($p_number){
?$result = isExsits($p_number);
?$test = 0;
?while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
??$row[2] += 1;
??$sql = sprintf("update xoops_wp_popularity set bad = %d
where postnumber = %d;",$row[2],$row[0]);
??@mysql_query($sql);
??$test = 1;
?}
?if ($test == 0) {
??$sql = sprintf("insert into xoops_wp_popularity(postnumber, good, bad)
values(%d, '0', '1');",$p_number);
??@mysql_query($sql);
?}
}

function isExsits($p_number){
?$sql = sprintf("select postnumber, good, bad from xoops_wp_popularity
where postnumber = %d;",$p_number);
?return mysql_query($sql);
}
?>

// JavaScript Document
// 美乳(votescript.js)
function voteGood(id)
{
?displayProgress();

?new Ajax.Request("/ajax/vote.php?id=" + id + "&vote=good",
{ method: 'get', onSuccess: displayResult, onFailure : displayFail });
}

function voteBad(id)
{
?displayProgress();

?new Ajax.Request("/ajax/vote.php?id=" + id + "&vote=bad",
{ method: 'get', onSuccess : displayResult ,onFailure : displayFail});
}

function displayProgress()
{
?$("vote-result").innerHTML = '投票処理中・・・'
}

function displayResult(responseHttpObj)
{
?if (responseHttpObj.responseText == 'fail')
?{
??$("vote-result").innerHTML
= 'ごめんなさい、サーバーに問題が発生していてうまく投票できませんでした';
?}else{
??$("vote-result").innerHTML = '投票ありがとうございます!';
?}
}

function displayFail()
{
?$("vote-result").innerHTML = 'サーバーエラー!';
}

<script language="javascript" src="/ajax/prototype.js"></script>
<script language="javascript" src="/ajax/votescript.js"></script>

<div class="vote-box" id="vote-result">
この記事は良かったですか?
<input type="submit" name="Submit" value="良い"
onClick="voteGood(<?php print($post->ID); ?>);">
<input type="submit" name="Submit" value="イマイチ"
onClick="voteBad(<?php print($post->ID); ?>);">
</div>

global $xoopsUser,$xoopsDB;
$sql = "select m.postnumber, m.good ,p.post_title
FROM ".$xoopsDB->prefix('wp_popularity')." m
INNER JOIN ".$xoopsDB->prefix('wp_posts')." p
ON m.postnumber = p.ID WHERE m.good <> 0 ORDER BY m.good DESC LIMIT 10";
$res = $xoopsDB->query($sql);
$rank=0;
while($value = $xoopsDB->fetchArray($res)){
?$rank = $rank + 1;
?echo $rank.".<a href=https://a-tak.com/xoops/modules/wordpress/index.php?p=
.$value["postnumber"]."&more=1&c=1">".$value["post_title"]
."(".$value["good"]." votes)</a><br/>";
}
echo "11位以降は
<a href="https://a-tak.com/xoops/modules/info/index.php?id=11">こちら</a><br/>";
echo date("m月d日 H時i分")." 更新";