playerapi.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360
  1. <?php
  2. //error_reporting(0);
  3. session_start();
  4. list($msec, $sec) = explode(' ', microtime());
  5. $msectime = (float)sprintf('%.0f', (floatval($msec) + floatval($sec)) * 1000);
  6. if ($msectime - (float)$_SESSION['lasttime'] < 2000) {
  7. echo json_encode(array('info'=>0,msg=>'2秒发送一次'));die;
  8. // echo json_encode(array('info'=>0,'msg'=>'无此授权卡'));die;
  9. } else {
  10. $_SESSION['lasttime'] = $msectime;
  11. }
  12. //date_default_timezone_set('PRC');
  13. header("Content-type: text/html; charset=utf8");
  14. //var_dump($_POST);die;
  15. include 'config.php';
  16. $type = $_POST['type'];
  17. $checknum=$_POST['pswd'];
  18. // $quid = trim(poststr('qu'));
  19. $quid=$_POST['qu'];
  20. $qu = $quarr[$quid];
  21. // $uid = trim(poststr('uid'));
  22. $uid=$_POST['username'];
  23. $gid = $qu['gid'];
  24. $zoneid = $qu['zoneid'];
  25. $manageurl = $qu['manageurl'];
  26. $dbip = $qu['host'];
  27. $dbname = $qu['dbname'];
  28. $dbuser = $qu['user'];
  29. $dbpwd = $qu['pwd'];
  30. $quname = $qu['name'];
  31. $uid=$_POST['username'];
  32. if(!$uid){
  33. echo json_encode(array('info'=>0,msg=>'uid不能为空'));die;
  34. }
  35. $pswd=$_POST['pswd'];
  36. if(!$pswd){
  37. echo json_encode(array('info'=>0,msg=>'后台密码不能为空'));die;
  38. }
  39. $db2 = mysqli_connect('127.0.0.1','root','wch123.com','cdks',3306) or die("数据库连接错误1");
  40. $db2->query('set names utf8');
  41. //var_dump($mysql);die;
  42. //$ss = mysqli_fetch_assoc($mysql->query("SELECT FROM cdk WHERE uid = '$rid' limit 1"));
  43. $ss = mysqli_fetch_assoc($db2->query("SELECT * FROM cdks.cdk WHERE uid = '{$uid}' "));
  44. //var_dump($ss);die;
  45. if($ss['status'] != 1 && $type != 'pay'){
  46. echo json_encode(array('info'=>0,msg=>'角色未授权'));die;
  47. }
  48. if($ss['pass'] != $checknum && $type != 'pay'){
  49. echo json_encode(array('info'=>0,msg=>'后台密码错误'));die;
  50. }
  51. switch($_POST['type']){
  52. case 'charge':
  53. $mailid = trim(poststr('rechargeId'));
  54. $mailnum = trim(poststr('number'));
  55. if ($mailnum == '' || $mailnum < 0 || $mailnum > 1000000) {
  56. // exit('发送数量错误');
  57. echo json_encode(array('info'=>0,msg=>'数量最大1000000'));die;
  58. }
  59. $roleId = $_POST["username"];
  60. $connnect = new Mongo("mongodb://127.0.0.1:27017");
  61. $db = $connnect->selectDB($dbname)->selectCollection("char");
  62. $cursor = $db->findOne(array('name' => $roleId));
  63. $roleId11=$cursor['_id']->{'$id'};
  64. $collection = $connnect->selectDB($dbname)->selectCollection("mail");
  65. $document = array(
  66. "flag" => 1,
  67. "receiverUuid" => $roleId11,
  68. "senderName" => "充值系统",
  69. "head" => 0,
  70. "items" => [
  71. [
  72. (int)$mailid,
  73. (int)$mailnum
  74. ]
  75. ],
  76. "title" => "充值系统",
  77. "type" => 1,
  78. "time" => time(),
  79. "content" => "123"
  80. );
  81. $result = $collection->insert($document);
  82. echo json_encode(array('info'=>1,'msg'=>'充值成功,邮箱领取!'));
  83. break;
  84. case 'mail':
  85. $mailid = trim(poststr('mailid'));
  86. $mailnum = trim(poststr('mailnumyj'));
  87. if ($mailnum == '' || $mailnum < 0 || $mailnum > 9) {
  88. // exit('发送数量错误');
  89. echo json_encode(array('info'=>0,msg=>'数量最大9'));die;
  90. }
  91. $roleId = $_POST["username"];
  92. $connnect = new Mongo("mongodb://127.0.0.1:27017");
  93. $db = $connnect->selectDB($dbname)->selectCollection("char");
  94. $cursor = $db->findOne(array('name' => $roleId));
  95. $roleId11=$cursor['_id']->{'$id'};
  96. $collection = $connnect->selectDB($dbname)->selectCollection("mail");
  97. $document = array(
  98. "flag" => 1,
  99. "receiverUuid" => $roleId11,
  100. "senderName" => "系统邮件",
  101. "head" => 0,
  102. "items" => [
  103. [
  104. (int)$mailid,
  105. (int)$mailnum
  106. ]
  107. ],
  108. "title" => "系统邮件",
  109. "type" => 1,
  110. "time" => time(),
  111. "content" => "123"
  112. );
  113. $result = $collection->insert($document);
  114. echo json_encode(array('info'=>1,'msg'=>'发送成功,邮箱领取!'));
  115. break;
  116. case 'clearbag':
  117. $roleId = $_POST["username"];
  118. //链接mongodb
  119. $manager = new MongoDB\Driver\Manager('mongodb://127.0.0.1:27017');
  120. $filter = [ 'name' => ''.$roleId.'' ]; //查询条件 user_id大于0
  121. $query = new MongoDB\Driver\Query($filter); //查询请求
  122. $list = $manager->executeQuery('goal.Player', $query); // 执行查询 location数据库下的box集合
  123. foreach ($list as $document) {
  124. $roleId11 = $document->_id;//能打印下吗
  125. }
  126. //print_r($roleId11);
  127. $bulk = new MongoDB\Driver\BulkWrite();
  128. $bulk->delete(array(_id => $roleId11));
  129. //print_r($bulk);
  130. $result = $manager->executeBulkWrite('goal.PlayerItem', $bulk);
  131. if($result->getDeletedCount()){
  132. echo json_encode(array('info'=>1,'msg'=>'已清除,请重新登录!'));
  133. }else{
  134. echo json_encode(array('info'=>0,'msg'=>'清除失败,没有数据!'));
  135. }
  136. break;
  137. case 'clearresource':
  138. $roleId = $_POST["username"];
  139. //链接mongodb
  140. $manager = new MongoDB\Driver\Manager('mongodb://127.0.0.1:27017');
  141. $filter = [ 'name' => ''.$roleId.'' ]; //查询条件 user_id大于0
  142. $query = new MongoDB\Driver\Query($filter); //查询请求
  143. $list = $manager->executeQuery('goal.Player', $query); // 执行查询 location数据库下的box集合
  144. foreach ($list as $document) {
  145. $roleId11 = $document->_id;//能打印下吗
  146. }
  147. //print_r($roleId11);
  148. $bulk = new MongoDB\Driver\BulkWrite();
  149. $bulk->delete(array(_id => $roleId11));
  150. //print_r($bulk);
  151. $result = $manager->executeBulkWrite('goal.PlayerEquipment', $bulk);
  152. if($result->getDeletedCount()){
  153. echo json_encode(array('info'=>1,'msg'=>'已清除,请重新登录!'));
  154. }else{
  155. echo json_encode(array('info'=>0,'msg'=>'清除失败,没有数据!'));
  156. }
  157. break;
  158. case 'clearherb':
  159. $roleId = $_POST["username"];
  160. //链接mongodb
  161. $manager = new MongoDB\Driver\Manager('mongodb://127.0.0.1:27017');
  162. $filter = [ 'name' => ''.$roleId.'' ]; //查询条件 user_id大于0
  163. $query = new MongoDB\Driver\Query($filter); //查询请求
  164. $list = $manager->executeQuery('goal.Player', $query); // 执行查询 location数据库下的box集合
  165. foreach ($list as $document) {
  166. $roleId11 = $document->_id;//能打印下吗
  167. }
  168. //print_r($roleId11);
  169. $bulk = new MongoDB\Driver\BulkWrite();
  170. $bulk->delete(array(_id => $roleId11));
  171. //print_r($bulk);
  172. $result = $manager->executeBulkWrite('goal.PlayerCoachItem', $bulk);
  173. if($result->getDeletedCount()){
  174. echo json_encode(array('info'=>1,'msg'=>'已清除,请重新登录!'));
  175. }else{
  176. echo json_encode(array('info'=>0,'msg'=>'清除失败,没有数据!'));
  177. }
  178. break;
  179. case 'clearstone':
  180. $roleId = $_POST["username"];
  181. //链接mongodb
  182. $manager = new MongoDB\Driver\Manager('mongodb://127.0.0.1:27017');
  183. $filter = [ 'name' => ''.$roleId.'' ]; //查询条件 user_id大于0
  184. $query = new MongoDB\Driver\Query($filter); //查询请求
  185. $list = $manager->executeQuery('goal.Player', $query); // 执行查询 location数据库下的box集合
  186. foreach ($list as $document) {
  187. $roleId11 = $document->_id;//能打印下吗
  188. }
  189. //print_r($roleId11);
  190. $bulk = new MongoDB\Driver\BulkWrite();
  191. $bulk->delete(array(_id => $roleId11));
  192. //print_r($bulk);
  193. $result = $manager->executeBulkWrite('goal.PlayerEquipPiece', $bulk);
  194. if($result->getDeletedCount()){
  195. echo json_encode(array('info'=>1,'msg'=>'已清除,请重新登录!'));
  196. }else{
  197. echo json_encode(array('info'=>0,'msg'=>'清除失败,没有数据!'));
  198. }
  199. break;
  200. case 'pay':{
  201. $cdk = $_POST['cdk'];
  202. $pswd = $_POST['pswd'];
  203. $xxs = mysqli_fetch_assoc($db2->query("SELECT * FROM cdk WHERE uid = '$uid' limit 1"));
  204. if($xxs['id'] !=''){
  205. echo json_encode(array('info'=>0,'msg'=>'角色已授权,无需再次授权'));die;
  206. }
  207. $xxx = mysqli_fetch_assoc($db2->query("SELECT * FROM cdk WHERE cdk = '$cdk' limit 1"));
  208. if($xxx['cdk'] ==''){
  209. echo json_encode(array('info'=>0,'msg'=>'无此授权卡'));die;
  210. }
  211. if($xxx['status'] != 0){
  212. echo json_encode(array('info'=>0,'msg'=>'此授权卡已被使用'));die;
  213. }
  214. if($db2->query("UPDATE cdk SET status = 1 , qid = '$quid' ,uid = '$uid', pass = '$pswd' WHERE cdk = '$cdk';")){
  215. echo json_encode(array('info'=>1,'msg'=>'角色授权成功'));die;
  216. }else{
  217. echo json_encode(array('info'=>0,'msg'=>'授权失败.请联系管理员'));die;
  218. }
  219. }
  220. break;
  221. }
  222. ?>