getRequestToken('http://twitter.com/oauth/request_token', $callback); //取得したトークンをセッションに保存 $_SESSION['request_token'] = $consumer->getToken(); $_SESSION['request_token_secret'] = $consumer->getTokenSecret(); //認証するためのURL取得 $auth_url = $consumer->getAuthorizeUrl('http://twitter.com/oauth/authenticate'); $wk_tw = $_POST["ore_uma_list"]; $wk_tw = stripslashes($wk_tw); $wk_jisin = $_POST["ore_uma_jisin"]; $wk_jisin = stripslashes($wk_jisin); echo "＜クリックで呟きます！＞
".$wk_tw."を俺軸馬として呟く！
自信度：".$wk_jisin.""; require_once("../class/db.php"); //ＤＢ接続 $db = new db; $sql = "lock tables ore_uma_tw write;"; $rep = mysql_query($sql,$db->conn) or die("lock table error"); $wk_umaban = substr($wk_tw,0,2); $wk_raceid = '201012261011'; $wk_account = ""; // $sql = "select max(id_index) as maxid from ore_uma_tw"; $rep = mysql_query($sql,$db->conn) or die("select max error"); $wk_index = 0; while($row = mysql_fetch_array($rep,MYSQL_ASSOC)){ $wk_index = $row["maxid"]; } $wk_index +=1; $_SESSION['id_index'] = $wk_index; $wk_date = date("Y-m-d H:i:s"); $wk_tw_str = $wk_tw." 自信度：".$wk_jisin." ".$orejiku_tag; $sql = "insert into ore_uma_tw values('".$wk_index."','".$wk_account."','".$wk_raceid."','".$_SERVER['HTTP_USER_AGENT']."','".$wk_tw_str."','".$wk_date."')"; $rep = mysql_query($sql,$db->conn) or die("select max error"); $sql = "unlock tables;"; $rep = mysql_query($sql,$db->conn) or die("unlock table error"); }else{ echo "

"; echo "

競馬予想！軸馬宣言！をツイッターで呟いてみる

"; echo "軸馬は"; echo "01番ミヤギシンザン"; echo "02番テイエムソロン"; echo "03番ベルグヤワタ"; echo "04番タツグレース"; echo "05番ジョウショーモアー"; echo "06番マウントキング"; echo "07番セトウチアポロン"; echo "08番ブルーパピヨン"; echo "09番マチカネゲンジ"; echo "10番チェルケッティ"; echo "11番ネヴァブション"; echo ""; echo "自信度は"; echo "(〃＾∇＾)超絶"; echo "ヽ(*´∀｀)ﾉ普通"; echo "（｀・ω・´）タブン"; echo "(σ＾Д＾)σ穴馬！"; echo "(*｀∀´)φ危険馬"; echo ""; echo ""; //ツイートの保存 echo ""; echo "

"; } ?>

---