public function savexi() { $data = Input::all(); $data['openid'] = Session::get('openid') ? Session::get('openid') : null; $save = array('openid' => $data['openid'], 'score' => $data['sub'], 'time' => $data['score']); if ($data['openid'] != null) { $num = Click::where('openid', '=', $data['openid'])->count(); if ($num != 0) { $info = Click::where('openid', '=', $data['openid'])->first(); if ($save['score'] > $info['score']) { Click::where('openid', '=', $data['openid'])->update($save); $id = Click::where('openid', '=', $data['openid'])->first(); } elseif ($save['score'] == $info['score'] && $save['time'] < $info['time']) { Click::where('openid', '=', $data['openid'])->update($save); $id = Click::where('openid', '=', $data['openid'])->first(); } else { $id = Click::create($save); $uid = $id['id']; $paiming = DB::select("SELECT rowno as list FROM (SELECT id,score,time,(@rowno:=@rowno+1) as rowno FROM `click`, (SELECT (@rowno:=0)) a ORDER BY score DESC, time ASC )b WHERE id = {$uid} limit 1"); Click::destroy($uid); return $paiming; } } else { $id = Click::create($save); } } else { $id = Click::create($save); } $uid = $id['id']; $paiming = DB::select("SELECT rowno as list FROM (SELECT id,score,time,(@rowno:=@rowno+1) as rowno FROM `click`, (SELECT (@rowno:=0)) a ORDER BY score DESC, time ASC )b WHERE id = {$uid} limit 1"); return $paiming; }