if (count($fs) != 2) {
// if $fi[0] is not like abc/def
_xsendfile($picpath, $_GET['f']);
} else {
if (strlen($fs[0]) != 3) {
//exit("2");//for debug
exit("Wrong directory name format.");
} else {
if (strlen($fs[1]) < 3) {
//exit("3");//for debug
exit("Wrong file name format.");
} else {
$zconn = new zmysqlConn();
$fileserial = $fs[0] . substr($fs[1], 0, 3);
$clientkey = $_GET['ckey'];
$r = _getlastvote($zconn, $fileserial, $clientkey);
$sql = "update pictures set clicks = clicks + 1, weeklyclicks = weeklyclicks + 1 where fileserial = '{$fileserial}'";
mysql_query($sql, $zconn->dblink);
if (count($r) >= 2) {
//exit("0, $file");//for debug
_xsendfile($picpath, $file, $r);
} else {
//exit("4");//for debug
_xsendfile($picpath, $file);
}
}
}
}
}
} else {
/**
exit;
}
}
if ($vote == 1) {
$sql = "insert into votes (weibouserid, clientid, likes, `type`, `time`) values ({$weibouserid}, {$clientid}, 1, {$vote}, '{$time}')" . " ON DUPLICATE KEY UPDATE likes = likes + 1, `type` = {$vote}, `time` = '{$time}'";
array_push($sqls, $sql);
$sql = "update weibo_users set likes = likes + 1, weeklylikes = weeklylikes + 1, lastvotetime = '{$time}' where id = {$weibouserid};";
array_push($sqls, $sql);
} else {
if ($vote == -1) {
$sql = "insert into votes (weibouserid, clientid, dislikes, `type`, `time`) values ({$weibouserid}, {$clientid}, 1, {$vote}, '{$time}')" . " ON DUPLICATE KEY UPDATE dislikes = dislikes + 1, `type` = {$vote}, `time` = '{$time}'";
array_push($sqls, $sql);
$sql = "update weibo_users set dislikes = dislikes + 1, weeklydislikes = weeklydislikes + 1, lastvotetime = '{$time}' where id = {$weibouserid};";
array_push($sqls, $sql);
}
}
} else {
$sql = sprintf("update weibo_users set clicks = clicks + 1, weeklyclicks = weeklyclicks + 1 where id = %d", $weibouserid);
array_push($sqls, $sql);
}
//echo print_r($sqls, true); exit();//for debug
for ($i = 0; $i < count($sqls); $i++) {
$sql = $sqls[$i];
mysql_query($sql, $zconn->dblink) or die("~failed~DB err: " . mysql_error() . "~failed~");
}
$r = _getlastvote($zconn, $weibouserid, $clientkey);
if (count($r) > 0) {
echo "~successful~" . $r['lastvote'] . "," . $r['lastvotetime'] . "," . $r['clicks'] . "," . $r['likes'] . "," . $r['dislikes'] . "," . $r['weeklyclicks'] . "," . $r['weeklylikes'] . "," . $r['weeklydislikes'] . "~successful~";
} else {
echo "~successful~~successful~" . print_r($r, true);
}
