$bulkload_connection = new SQLite3("counter.sqlite");
$cc_highest_score = "";
$cc_id = "";
$cc_name = "";
$s_start = "";
$str_ccid = "";
$cur = "";
$max = "";
if (isset($_REQUEST["s"]))
{
$s_start = $_REQUEST["s"];
}
if (isset($_REQUEST["cid"]))
{
$cc_id = $_REQUEST["cid"];
}
if (isset($_REQUEST["cc"]))
{
$str_ccid = $_REQUEST["cc"];
}
if (isset($_REQUEST["cur"]))
{
$cur = $_REQUEST["cur"];
}
if ($cur=="")
{
$cur=1;
}
if (isset($_REQUEST["max"]))
{
$max = $_REQUEST["max"];
}
if ($str_ccid=="")
{
//$strSQL = "SELECT * from counter_category where nov_id = " . $_REQUEST["id"] . "";
$strSQL = "SELECT * from counter_category";
//echo $strSQL . "
";
$result_char=$bulkload_connection->query($strSQL);
if ($result_char===false) {
//echo "error";
echo $bulkload_connection->lasterrormsg();
}
else
{
while ($row_char = $result_char->fetcharray())
{
//echo $row_char["cc_highest_score"];
if ($str_ccid!="")
{
$str_ccid .= ",";
}
$str_ccid .= $row_char["cc_id"];
}
}
//echo $str_ccid . "
";
$aryCCid = explode(",", $str_ccid);
shuffle($aryCCid);
//print_r($aryCCid_);
$str_ccid = implode(",", $aryCCid);
//echo $str_ccid . "
";
$max = sizeof($aryCCid);
//echo $max . "
";
}
$aryCCid_ = explode(",", $str_ccid);
//echo $aryCCid_[intval($cur-1)] . "
";
if ($cc_id=="")
{
$cc_id = $aryCCid_[intval($cur-1)];
}
if ($cc_id!="")
{
//$strSQL = "SELECT * from counter_category where nov_id = " . $_REQUEST["id"] . "";
$strSQL = "SELECT * from counter_category where cc_id=" . $cc_id. "";
//echo $strSQL . "
";
$result_char=$bulkload_connection->query($strSQL);
if ($result_char===false) {
//echo "error";
echo $bulkload_connection->lasterrormsg();
}
else
{
while ($row_char = $result_char->fetcharray())
{
$cc_highest_score = $row_char["cc_highest_score"];
$cc_id = $row_char["cc_id"];
$cc_name = $row_char["cc_name"];
}
}
}
if ($cc_highest_score=="")
{
$cc_highest_score = 0;
}
?>
// echo $cc_name;?> |
![]() |
Name as many things from the category as you can.
|