API tools faq
paste
Guest User

ApisListController

a guest
Jan 2nd, 2017
48
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 147.62 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /**
  3. * @Controller Name: Apis
  4. * @Created Date : 14_06_2016
  5. * @ all Params Usesd Pacel Case
  6. * @ Error : True/False
  7. */
  8.  
  9. Class ApisListController extends AppController {
  10.  
  11. public $name = 'ApisList';
  12. public $uses = array('User','AppSetting','UserDevice','Room','RoundScore','RoomSlot','ChatInfo','FinalScore','UserPlayGame','RequestRematch','GamePlayData');
  13. public $components = array('RequestHandler','Email','AWSSES');
  14. public $helpers = array('Html');
  15.  
  16.  
  17. public function beforeFilter() {
  18. parent::beforeFilter();
  19. $this->RequestHandler->ext = 'json';
  20. }
  21.  
  22.  
  23. public function test(){
  24. $settingData = $this->AppSetting->find('first',array('fields'=>array('AppSetting.time_setting','AppSetting.Build','AppSetting.UrlIOS','AppSetting.UrlAndroid','AppSetting.UrlWin','AppSetting.UrlOSX','AppSetting.AutoKickTimeout','AppSetting.showads','AppSetting.show_effects')));
  25.  
  26. $this->set(array('response' => array('errorflag'=>0,'user_id'=>123),'_serialize' => array('response')));
  27. }
  28.  
  29. /**
  30. * @method : getSetting()
  31. * @purpose : get app Setting Option Like time for invitation acceptance etc.
  32. * @create_date : 14_06_2016
  33. */
  34.  
  35. public function getSetting(){
  36. $error = '';
  37.  
  38. if(empty($_REQUEST['Build'])){
  39. $error = "Missing Build parameter";
  40. }
  41.  
  42. if(isset($error) && !empty($error )){
  43. $message = array('Error'=>true,'Message'=>$error);
  44. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  45. }else{
  46. $settingData = $this->AppSetting->find('first',array('fields'=>array('AppSetting.time_setting','AppSetting.Build','AppSetting.UrlIOS','AppSetting.UrlAndroid','AppSetting.UrlWin','AppSetting.UrlOSX','AppSetting.AutoKickTimeout','AppSetting.showads','AppSetting.show_effects')));
  47. $time = $settingData['AppSetting']['time_setting'];
  48. $build = $settingData['AppSetting']['Build'];
  49. $UrlIOS = $settingData['AppSetting']['UrlIOS'];
  50. $UrlAndroid = $settingData['AppSetting']['UrlAndroid'];
  51. $UrlWin = $settingData['AppSetting']['UrlWin'];
  52. $UrlOSX = $settingData['AppSetting']['UrlOSX'];
  53. $autokicktime = $settingData['AppSetting']['AutoKickTimeout'];
  54. $showads = $settingData['AppSetting']['showads'] ? $settingData['AppSetting']['showads'] : "0";
  55. $show_effects = $settingData['AppSetting']['show_effects'] ? $settingData['AppSetting']['show_effects'] : "0";
  56. // echo "<pre>"; print_r($settingData); die;
  57.  
  58. $this->set(array('Response' => array('Error'=>false,'Time'=>$time,'Build' => $build, 'UrlIOS' =>$UrlIOS, 'UrlAndroid' => $UrlAndroid,'UrlWin' => $UrlWin, 'UrlOSX' => $UrlOSX,'AutoKickTimeout' => $autokicktime,'ShowAds' => $showads,'ShowEffects' => $show_effects),'_serialize'=>array('Response')));
  59. }
  60. }
  61.  
  62.  
  63. /**
  64. * @method : checkSingIn
  65. * @purpose : check Current Device Staus
  66. * @create_date : 14_06_2016
  67. * #Params : IsAvailable: NotRegistered(if device Id Still not Registred)
  68. * @room_status: 0- still game not started, 1: game running, 2: game finished
  69. */
  70.  
  71. public function checkSingIn(){
  72. $error = '';
  73. if(empty($_REQUEST['DeviceId'])){
  74. $error = "Missing DeviceId parameter";
  75. }
  76.  
  77. if(isset($error) && !empty($error )){
  78. $message = array('Error'=>true,'Message'=>$error);
  79. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  80. } else{
  81. $DeviceId = trim($_REQUEST['DeviceId']);
  82.  
  83. $deviceData = $this->UserDevice->find('first',array('conditions'=>array('UserDevice.DeviceId'=>$DeviceId),'order' =>array('UserDevice.id DESC')));
  84.  
  85. if((empty($deviceData)) || ($DeviceId == 'n/a')){
  86. $this->set(array('Response' => array('Error'=>false,'IsAvailable'=>'NotRegistered'),'_serialize' => array('Response')));
  87. } else{
  88.  
  89. $devicepriId = $deviceData['UserDevice']['id'];
  90.  
  91. $getUser = $this->User->find('first',array('conditions'=>array('User.id'=>$deviceData['UserDevice']['UserId']),'fields'=>array('User.id','User.online_status','User.visible','User.current_device_id')));
  92.  
  93. if(!empty($getUser['User']['current_device_id']))
  94. $currentdeviceid = $getUser['User']['current_device_id'];
  95. else
  96. $currentdeviceid = 0;
  97.  
  98. if( ($getUser['User']['online_status']==1 ) && ($currentdeviceid == $devicepriId ) ){
  99.  
  100. // Checke User Alredy in Game or Not
  101. $roomId = '';
  102. $getSlotData = $this->RoomSlot->find('first',array('conditions'=>array('RoomSlot.UserId'=>$getUser['User']['id'],'RoomSlot.SlotStatus'=>1),'fields'=>array('RoomSlot.RoomId','RoomSlot.UserId','RoomSlot.SlotStatus','RoomSlot.SlotId'),'recursive'=>-1));
  103.  
  104. //chkuserinvited
  105.  
  106. if(isset($getSlotData) && !empty($getSlotData)){
  107. $getroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status !=' =>2),'fields'=>array('Room.room_status','Room.id','Room.OngoingStatus','Room.join_member_count')));
  108.  
  109. if(!empty($getroomStatus) && $getroomStatus['Room']['OngoingStatus'] == 1 && $getroomStatus['Room']['join_member_count'] > 1){
  110. $roomId = $getroomStatus['Room']['id'];
  111. }elseif((!empty($getroomStatus)) && ($getroomStatus['Room']['OngoingStatus'] == 1) && ($getroomStatus['Room']['join_member_count'] == 1)){
  112.  
  113. $roomId = $getroomStatus['Room']['id'];
  114. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  115. $this->Room->delete($roomId);
  116. $roomId = '';
  117.  
  118. }elseif(!empty($getroomStatus) && $getroomStatus['Room']['OngoingStatus'] != 1 && $getroomStatus['Room']['join_member_count'] >= 1){
  119.  
  120. $roomId = $getroomStatus['Room']['id'];
  121. //create empty public room slots
  122.  
  123. $getSlot = $this->RoomSlot->find('all',array('conditions' => array('RoomSlot.RoomId' => $roomId),'order'=>array('RoomSlot.SlotId ASC'),'recursive' => -1));
  124.  
  125. $lastslotidkey = end($getSlot);
  126. $lastslotkey = key($getSlot);
  127. $lastslotid = $getSlot[$lastslotkey]['RoomSlot']['SlotId'];
  128.  
  129. switch ($lastslotid) {
  130. case 0:
  131. for($i=1;$i<=3;$i++){
  132. $datetime = strtotime(date('Y-m-d H:i:s'));
  133. $created_date = date('Y-m-d H:i:s');
  134.  
  135. $slotCreat['RoomSlot']['RoomId'] = $roomId;
  136. $slotCreat['RoomSlot']['UserId'] = 0;
  137. $slotCreat['RoomSlot']['SlotId'] = $i;
  138. $slotCreat['RoomSlot']['slot_type'] = 'public';
  139. $slotCreat['RoomSlot']['SlotStatus'] = 0;
  140. $slotCreat['RoomSlot']['created_time'] = strtotime(date('Y-m-d H:i:s')) ;
  141. $slotCreat['RoomSlot']['created_date'] = date('Y-m-d H:i:s') ;
  142. $this->RoomSlot->saveall($slotCreat);
  143.  
  144.  
  145. }
  146. break;
  147. case 1:
  148. for($i=2;$i<=3;$i++){
  149. $datetime = strtotime(date('Y-m-d H:i:s'));
  150. $created_date = date('Y-m-d H:i:s') ;
  151.  
  152. $slotCreat['RoomSlot']['RoomId'] = $roomId;
  153. $slotCreat['RoomSlot']['UserId'] = 0;
  154. $slotCreat['RoomSlot']['SlotId'] = $i;
  155. $slotCreat['RoomSlot']['slot_type'] = 'public';
  156. $slotCreat['RoomSlot']['SlotStatus'] = 0;
  157. $slotCreat['RoomSlot']['created_time'] = strtotime(date('Y-m-d H:i:s')) ;
  158. $slotCreat['RoomSlot']['created_date'] = date('Y-m-d H:i:s') ;
  159. $this->RoomSlot->saveall($slotCreat);
  160.  
  161.  
  162. }
  163. break;
  164. case 2:
  165. $i = 3;
  166. $datetime = strtotime(date('Y-m-d H:i:s'));
  167. $created_date = date('Y-m-d H:i:s');
  168.  
  169. $slotCreat['RoomSlot']['RoomId'] = $roomId;
  170. $slotCreat['RoomSlot']['UserId'] = 0;
  171. $slotCreat['RoomSlot']['SlotId'] = $i;
  172. $slotCreat['RoomSlot']['slot_type'] = 'public';
  173. $slotCreat['RoomSlot']['SlotStatus'] = 0;
  174. $slotCreat['RoomSlot']['created_time'] = strtotime(date('Y-m-d H:i:s')) ;
  175. $slotCreat['RoomSlot']['created_date'] = date('Y-m-d H:i:s') ;
  176. $this->RoomSlot->saveall($slotCreat);
  177.  
  178. break;
  179. default:
  180. $roomId = $getroomStatus['Room']['id'];
  181. }
  182.  
  183. }else{
  184. //check if user is not sitting in a complete game
  185.  
  186. $getcompleteroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status' =>2),'fields'=>array('Room.room_status','Room.id','Room.OngoingStatus','Room.join_member_count')));
  187.  
  188. if(!empty($getcompleteroomStatus)){
  189. $joinemembercount = $getcompleteroomStatus['Room']['join_member_count'];
  190. $this->RoomSlot->updateAll(array('RoomSlot.UserId' => 0,'RoomSlot.OldSlotUser' => $getUser['User']['id'],'RoomSlot.SlotStatus' => 0),array('RoomSlot.RoomId' => $getSlotData['RoomSlot']['RoomId'],'RoomSlot.SlotId' => $getSlotData['RoomSlot']['SlotId']));
  191.  
  192. $newjoinmemebercount = $joinemembercount - 1;
  193.  
  194. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmemebercount),array('Room.id' => $getSlotData['RoomSlot']['RoomId']));
  195.  
  196. $roomId = '';
  197. }
  198. }
  199. }
  200. // END
  201.  
  202. $this->set(array('Response' => array('Error'=>false,'IsAvailable'=>'True','UserStatus'=>$getUser['User']['visible'],'UserId'=>$getUser['User']['id'],'RoomId'=>$roomId),'_serialize' => array('Response')));
  203.  
  204. } else if(($getUser['User']['online_status']==1 ) && ($currentdeviceid != $devicepriId )){
  205. $this->set(array('Response' => array('Error'=>false,'IsAvailable'=>'AlreadySignin','UserStatus'=>$getUser['User']['visible']),'_serialize' => array('Response')));
  206. } else{
  207.  
  208. // Check User Alredy in Game or Not
  209.  
  210. $getSlotData = $this->RoomSlot->find('first',array('conditions'=>array('RoomSlot.UserId'=>$getUser['User']['id'],'RoomSlot.SlotStatus'=>1),'fields'=>array('RoomSlot.RoomId','RoomSlot.UserId','RoomSlot.SlotStatus'),'recursive'=>-1));
  211.  
  212. $roomId = '';
  213. if(!empty($getSlotData)){
  214. $getroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status !=' =>2),'fields'=>array('Room.room_status','Room.id','Room.join_member_count'),'recursive'=>-1));
  215. if(!empty($getroomStatus) && ('Room.OngoingStatus' == 1) && $getroomStatus['Room']['join_member_count'] > 1){
  216. $roomId = $getroomStatus['Room']['id'];
  217.  
  218. }else{
  219.  
  220. $getcompleteroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status' =>2),'fields'=>array('Room.room_status','Room.id','Room.OngoingStatus','Room.join_member_count')));
  221.  
  222. //check if user is not sitting in a complete game
  223. if(!empty($getcompleteroomStatus)){
  224. $joinemembercount = $getcompleteroomStatus['Room']['join_member_count'];
  225. $this->RoomSlot->updateAll(array('RoomSlot.UserId' => 0,'RoomSlot.OldSlotUser' => $getUser['User']['id'],'RoomSlot.SlotStatus' => 0),array('RoomSlot.RoomId' => $getSlotData['RoomSlot']['RoomId'],'RoomSlot.SlotId' => $getSlotData['RoomSlot']['SlotId']));
  226.  
  227. $newjoinmemebercount = $joinemembercount - 1;
  228.  
  229. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmemebercount),array('Room.id' => $getSlotData['RoomSlot']['RoomId']));
  230.  
  231. $roomId = '';
  232. }
  233. }
  234. }
  235. // END Above Code
  236.  
  237. $userId = $getUser['User']['id'];
  238. $DeviceId = trim($_REQUEST['DeviceId']);
  239.  
  240. $lastseen = strtotime(date('Y-m-d H:i:s'));
  241.  
  242. $this->User->updateAll(array('User.online_status' =>1,'User.current_device_id'=>"'$devicepriId'",'User.last_seen'=>$lastseen), array('User.id' => $userId));
  243. $this->set(array('Response' => array('Error'=>false,'IsAvailable'=>'True','UserStatus'=>$getUser['User']['visible'],'UserId'=>$getUser['User']['id'],'RoomId'=>$roomId),'_serialize' => array('Response')));
  244. }
  245. }
  246. }
  247. }
  248.  
  249.  
  250.  
  251. /**
  252. * @method : signIn
  253. * @purpose : Login with username/Nickname/Email, Password
  254. * @creadted_date : 15_06_2016
  255. * @ Status: 0 - User diasbled by Admin, 2 - NotMatched, 3 :Already Online , 1: device not registred for any users,4: Device is Active for other User
  256. */
  257.  
  258. public function signIn(){
  259. $error = array();
  260. if(empty($this->request->data['Username'])){
  261. $error[] = "Missing Username parameter";
  262. }
  263. if(empty($_REQUEST['Password'])){
  264. $error[] = "Missing Password parameter";
  265. }
  266. if(empty($_REQUEST['DeviceId'])){
  267. $error[] = "Missing DeviceId parameter";
  268. }
  269. if(!empty($error )){
  270. $erroMsg = implode(',', $error);
  271. $message = array('Error'=>true,'Message'=>$erroMsg);
  272. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  273. } else{
  274. $DeviceId = trim($_REQUEST['DeviceId']);
  275.  
  276. if($DeviceId == 'n/a'){
  277. $DeviceId = uniqid();
  278. }
  279.  
  280. $nick = trim($this->request->data['Username']);
  281. $password = md5($this->request->data['Password']);
  282. $UserData = $this->User->find('first',array('fields'=>array('id','nick','firstname','lastname','email','visible','online_status','current_device_id'),'conditions'=>array('User.username'=>$nick,'User.password'=>$password)));
  283. $roomId = '';
  284.  
  285. if(!empty($UserData)){
  286. if($UserData['User']['visible']==1){
  287.  
  288. // Check Device and User Online Status
  289. $userId = $UserData['User']['id'];
  290. $deviceData = $this->UserDevice->find('first',array('conditions'=>array('UserDevice.DeviceId'=>$DeviceId),'order' =>array('UserDevice.id DESC')));
  291.  
  292. /* if user already Login With Other Device */
  293. if($UserData['User']['online_status']==1){
  294.  
  295. // Already Played
  296. $message = array('Error'=>false,'Status'=>3,'UserId'=>$userId,'Message'=>'User already Played');
  297. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  298.  
  299. } else{
  300.  
  301. // Check Current Device
  302. $deviceData = $this->UserDevice->find('first',array('conditions'=>array('UserDevice.DeviceId'=>$DeviceId),'order' =>array('UserDevice.id DESC')));
  303.  
  304. if(empty($deviceData)){
  305.  
  306. $saveDevData['UserDevice']['UserId'] = $userId;
  307. $saveDevData['UserDevice']['DeviceId'] = $DeviceId;
  308. $saveDevData['UserDevice']['PlayStatus'] = 1;
  309. $this->UserDevice->save($saveDevData);
  310. $newDeviceId = $this->UserDevice->getInsertID();
  311. $lastseen = strtotime(date('Y-m-d H:i:s'));
  312. $this->User->updateAll(array('User.online_status' =>1,'User.current_device_id'=>$newDeviceId,'User.last_seen'=>$lastseen), array('User.id' => $userId));
  313.  
  314.  
  315. // Checke User Alredy in Game or Not
  316.  
  317. $getSlotData = $this->RoomSlot->find('first',array('conditions'=>array('RoomSlot.UserId'=>$userId,'RoomSlot.SlotStatus'=>1),'fields'=>array('RoomSlot.RoomId','RoomSlot.UserId','RoomSlot.SlotStatus'),'recursive'=>-1));
  318.  
  319. if(!empty($getSlotData)){
  320. $getroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status !=' =>2),'fields'=>array('Room.room_status','Room.id'),'recursive'=>-1));
  321. if(!empty($getroomStatus)){
  322. $roomId = $getroomStatus['Room']['id'];
  323. }
  324.  
  325. }
  326. // END Above Code
  327.  
  328. $message = array('Error'=>false,'Status'=>1,'UserId'=>$userId,'RoomId'=>$roomId,'Message'=>'Login Success', 'DeviceId' => $DeviceId);
  329. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  330. } else{
  331.  
  332. if(($UserData['User']['current_device_id']==$deviceData['UserDevice']['id'] ) || ($UserData['User']['id']==$deviceData['UserDevice']['UserId'])){
  333.  
  334. // Checke User Alredy in Game or Not
  335.  
  336. $getSlotData = $this->RoomSlot->find('first',array('conditions'=>array('RoomSlot.UserId'=>$UserData['User']['id'],'RoomSlot.SlotStatus'=>1),'fields'=>array('RoomSlot.RoomId','RoomSlot.UserId','RoomSlot.SlotStatus'),'recursive'=>-1));
  337.  
  338. if(!empty($getSlotData)){
  339. $getroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status !=' =>2),'fields'=>array('Room.room_status','Room.id'),'recursive'=>-1));
  340.  
  341. if(!empty($getroomStatus)){
  342. $roomId = $getroomStatus['Room']['id'];
  343. }
  344.  
  345. }
  346.  
  347. // END Above Code
  348.  
  349. $message = array('Error'=>false,'Status'=>1,'UserId'=>$userId,'RoomId'=>$roomId,'Message'=>'Login Success','DeviceId' => $DeviceId);
  350. $devId = $deviceData['UserDevice']['id'];
  351. $this->User->updateAll(array('User.online_status' =>1,'User.current_device_id'=>$devId), array('User.id' => $userId));
  352. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  353. }else if($deviceData['UserDevice']['UserId'] !=$UserData['User']['id']){
  354.  
  355. $devDbId = $deviceData['UserDevice']['id'];
  356. $userId = $UserData['User']['id'];
  357. $lastseen = strtotime(date('Y-m-d H:i:s'));
  358.  
  359. $this->UserDevice->updateAll(array('UserDevice.UserId' =>$userId), array('UserDevice.id' => $devDbId));
  360.  
  361. $this->User->updateAll(array('User.online_status' =>1,'User.current_device_id'=>$devDbId,'User.last_seen'=>$lastseen), array('User.id' => $userId));
  362.  
  363. // Checke User Alredy in Game or Not
  364.  
  365. $getSlotData = $this->RoomSlot->find('first',array('conditions'=>array('RoomSlot.UserId'=>$userId,'RoomSlot.SlotStatus'=>1),'fields'=>array('RoomSlot.RoomId','RoomSlot.UserId','RoomSlot.SlotStatus'),'recursive'=>-1));
  366.  
  367. if(!empty($getSlotData)){
  368. $getroomStatus = $this->Room->find('first',array('conditions'=>array('Room.id'=>$getSlotData['RoomSlot']['RoomId'],'Room.room_status !=' =>2),'fields'=>array('Room.room_status','Room.id'),'recursive'=>-1));
  369. if(!empty($getroomStatus)){
  370. $roomId = $getroomStatus['Room']['id'];
  371. }
  372.  
  373. }
  374.  
  375. // END Above Code
  376.  
  377. $message = array('Error'=>false,'Status'=>1,'UserId'=>$userId,'RoomId'=>$roomId,'Message'=>'Login Success2', 'DeviceId' => $DeviceId);
  378.  
  379. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  380.  
  381. } else{
  382. $message = array('Error'=>false,'Status'=>4,'UserId'=>$userId,'Message'=>'Device Regitered for other user');
  383. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  384. }
  385. }
  386. }
  387.  
  388. } else{
  389. $message = array('Error'=>false,'Status'=>0,'Message'=>'User Inactive');
  390. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  391. }
  392. }else{
  393. $message = array('Error'=>false,'Status'=>2,'Message'=>'Username OR password Wrong');
  394. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  395. }
  396. }
  397.  
  398. }
  399.  
  400.  
  401.  
  402. /**
  403. * @method : verifyEmail
  404. * @purpose : Verify OTP but verification from App Developer
  405. * @created_date: 16_06_2016
  406. */
  407.  
  408. public function verifyEmail(){
  409.  
  410. $error = array();
  411. if(empty($this->request->data['Email'])){
  412. $error[] = "Missing Email parameter";
  413. }
  414. if(!empty($error )){
  415. $message = array('Error'=>true,'Message'=>$error);
  416. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  417. } else{
  418. $checkemail = $this->checkEmail(trim($this->request->data['Email']));
  419.  
  420. if($checkemail){
  421. $message = array('Error'=>true,'OTP'=>'','Message'=>'This email already register');
  422. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  423. } else{
  424.  
  425. $token = mt_rand(10000, 99999);
  426. $aMsg = "Your access token is: ".$token;
  427. $this->Session->write('Person.eyeColor', $aMsg);
  428.  
  429. $this->AWSSES->to = trim($this->request->data['Email']);
  430.  
  431. if($this->AWSSES->_aws_ses('sendmail',$aMsg)){
  432. $arr = array('Response' => array('Error' => false, 'OTP' => $token, 'Status' => 1, 'Message' => 'OTP Number'));
  433.  
  434. echo json_encode($arr);die;
  435. }else{
  436. $message = array('Response' =>array('Error'=>true,'OTP'=>2,'Message'=>'Mail Not Send'));
  437.  
  438. echo json_encode($message);die;
  439. }
  440. }
  441. }
  442. }
  443.  
  444.  
  445. /**
  446. * @method : signUp
  447. * @purpose : Create New Account
  448. * @creadted_date : 16_06_2016
  449. * Email, Username, Password, DeviceId
  450. */
  451.  
  452. public function signUp(){
  453.  
  454. $error = array();
  455. if(empty($this->request->data['Username'])){
  456. $error[] = "Missing Username parameter";
  457. }
  458. if(empty($this->request->data['Email'])){
  459. $error[] = "Missing Email parameter";
  460. }
  461. if(empty($this->request->data['Password'])){
  462. $error[] = "Missing Password parameter";
  463. }
  464. if(empty($this->request->data['DeviceId'])){
  465. $error[] = "Missing DeviceId parameter";
  466. }
  467. if(!empty($error )){
  468. $erroMsg = implode(',', $error);
  469. $message = array('Error'=>true,'Message'=>$erroMsg);
  470. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  471. } else{
  472. // Check Username checkUserName
  473. $cheUname = $this->checkUserName(trim($this->request->data['Username']));
  474. $checkemail = $this->checkEmail(trim($this->request->data['Email']));
  475.  
  476. if($cheUname){
  477. $message = array('Error'=>false,'Status'=>2,'Message'=>'This username already register');
  478. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  479. } else if($checkemail){
  480. $message = array('Error'=>false,'Status'=>3,'Message'=>'This email already register');
  481. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  482. } else{
  483.  
  484. $userData['User']['username'] = $this->request->data['Username'];
  485. $userData['User']['nick'] = $this->request->data['Username'];
  486. $userData['User']['firstname'] = $this->request->data['Username'];
  487. $userData['User']['email'] = $this->request->data['Email'];
  488. $userData['User']['password'] = md5(trim($this->request->data['Password']));
  489. $this->User->save($userData);
  490. $userID = $this->User->getInsertID();
  491. // Save Device Id
  492. $deviceData['UserDevice']['DeviceId'] = $this->request->data['DeviceId'];
  493. $deviceData['UserDevice']['UserId'] = $userID;
  494. $this->UserDevice->save($deviceData);
  495. // Set Device Id */
  496.  
  497. $newDeviceId = $this->UserDevice->getInsertID();
  498. $this->User->updateAll(array('User.current_device_id'=>$newDeviceId), array('User.id' => $userID));
  499.  
  500. $this->set(array('Response' => array('Error'=>false,'Status'=>1,'UserId'=>$userID),'_serialize' => array('Response')));
  501. }
  502. }
  503. }
  504.  
  505.  
  506. /**
  507. * @purpose : tranfer old account, here login will work according to nick name if login details corrent then set nick name as usename
  508. * @ Params : Username, Password, DeviceId
  509. * @created_date : 16_06_2016
  510. * @ Status : 0- account already transfered, 1: tranasfer success, 2: Username or Password wrong
  511. */
  512.  
  513. public function transferAccount(){
  514. $error = array();
  515. if(empty($_REQUEST['Username'])){
  516. $error[] = "Missing Username parameter";
  517. }
  518. if(empty($_REQUEST['Password'])){
  519. $error[] = "Missing Password parameter";
  520. }
  521. if(empty($_REQUEST['DeviceId'])){
  522. $error[] = "Missing DeviceId parameter";
  523. }
  524. if(!empty($error )){
  525. $erroMsg = implode(',', $error);
  526. $message = array('Error'=>true,'Message'=>$erroMsg);
  527. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  528. } else{
  529. $DeviceId = trim($_REQUEST['DeviceId']);
  530. $nick = trim($_REQUEST['Username']);
  531. $password = md5($_REQUEST['Password']);
  532. $UserData = $this->User->find('first',array('fields'=>array('id','nick','username','firstname','lastname','email','visible','online_status','current_device_id','played_games','victories','losses'),'conditions'=>array('User.nick'=>$nick,'User.password'=>$password)));
  533.  
  534. if(!empty($UserData)){
  535. $played_games = $UserData['User']['played_games'];
  536. $victories = $UserData['User']['victories'];
  537. $losses = $UserData['User']['losses'];
  538. $userid = $UserData['User']['id'];
  539. if($played_games == 0){
  540. $winpercentage = 0;
  541. }else{
  542. $winpercentage = ($victories/$played_games) * 100 ;
  543. $winpercentage = round($winpercentage);
  544. }
  545. if(isset($UserData['User']['username']) && !empty($UserData['User']['username'])){
  546. $this->set(array('Response' => array('Error'=>false,'Status'=>0,'UserId'=>$UserData['User']['id'],'Message'=>'This account already trasfered'),'_serialize' => array('Response')));
  547. } else{
  548.  
  549. // Assign Device
  550. $deviceData['UserDevice']['DeviceId'] = trim($this->request->data['DeviceId']);
  551. $deviceData['UserDevice']['UserId'] = $UserData['User']['id'];
  552. $this->UserDevice->save($deviceData);
  553. $newDeviceId = $this->UserDevice->getInsertID();
  554. $username = $UserData['User']['nick'];
  555. $this->User->updateAll(array('User.online_status' =>1,'User.visible' =>1,'User.current_device_id'=>$newDeviceId,'User.username'=>'"'.$username.'"'), array('User.id' => $UserData['User']['id']));
  556.  
  557. $userplaydata['UserPlayGame']['total_game'] = $played_games;
  558. $userplaydata['UserPlayGame']['win_game'] = $victories;
  559. $userplaydata['UserPlayGame']['lost_game'] = $losses;
  560. $userplaydata['UserPlayGame']['win_percent'] = $winpercentage;
  561. $userplaydata['UserPlayGame']['user_id'] = $userid;
  562.  
  563. $this->UserPlayGame->save($userplaydata);
  564.  
  565. $this->set(array('Response' => array('Error'=>false,'Status'=>1,'UserId'=>$UserData['User']['id'],'Message'=>'Account transfered Success'),'_serialize' => array('Response')));
  566. }
  567.  
  568. } else{
  569. $message = array('Error'=>false,'Status'=>2,'Message'=>'Username OR password Wrong');
  570. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  571. }
  572. }
  573. }
  574.  
  575.  
  576. /**
  577. * @method : FbRegister
  578. * @ created_date : 14_06_2016
  579. * @ Status : 0- user laready online, 1: Registred Success, 2: email alredy exist, 3: fbid alredy registred 4:username already exists
  580. */
  581.  
  582. public function fbRegister(){
  583. $error = array();
  584. if(empty($this->request->data['FbId'])){
  585. $error[] = "Missing FbId parameter";
  586. }
  587.  
  588. if(empty($this->request->data['Email'])){
  589. $email = "";
  590. }else{
  591. $email = trim($this->request->data['Email']);
  592. }
  593.  
  594. if(empty($this->request->data['Name'])){
  595. $error[] = "Missing Name parameter";
  596. }
  597.  
  598. if(empty($this->request->data['DeviceId'])){
  599. $error[] = "Missing DeviceId parameter";
  600. }
  601. if(empty($this->request->data['Username'])){
  602. $error[] = "Missing Username parameter";
  603. }
  604. if(!empty($error )){
  605. $erroMsg = implode(',', $error);
  606. $message = array('Error'=>true,'Message'=>$erroMsg);
  607. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  608. } else{
  609.  
  610. $fbemail = $email;
  611.  
  612. $fbusername = trim($this->request->data['Username']);
  613. $fbId = trim($this->request->data['FbId']);
  614. $socialData = $this->checkfbId($fbId);
  615.  
  616. if(empty($socialData)){
  617. // Check Email Id here
  618.  
  619. $chefbemilData = $this->checkFbEmail($fbemail);
  620.  
  621. if(empty($fbemail)) {
  622. $chefbemilData = '';
  623. }
  624.  
  625. $checkuserfbdata = $this->checkFbUsername($fbusername);
  626.  
  627. if(empty($fbusername)){
  628. $checkuserfbdata = "";
  629. }
  630.  
  631. //check if Username or Email Already Exists
  632. if(!empty($chefbemilData)){
  633.  
  634. $this->set(array('Response' => array('Error'=>false,'Status'=>2,'UserId'=>$chefbemilData['User']['id'],'Message'=>'Email already exists'),'_serialize' => array('Response')));
  635. }
  636. elseif(!empty($checkuserfbdata)){
  637. $this->set(array('Response' => array('Error'=>false,'Status'=>4,'UserId'=>$checkuserfbdata['User']['id'],'Message'=>'Username already exists'),'_serialize' => array('Response')));
  638. }
  639. else{
  640. //Fully inseret Data
  641.  
  642. $saveUser['User']['fbid'] = trim($this->request->data['FbId']);
  643. $saveUser['User']['email'] = $email;
  644. $saveUser['User']['firstname'] = trim($this->request->data['Name']);
  645. $saveUser['User']['username'] = trim($this->request->data['Username']);
  646.  
  647. $this->User->save($saveUser);
  648.  
  649. $userId = $this->User->getInsertID();
  650.  
  651. $deviceData['UserDevice']['DeviceId'] = trim($this->request->data['DeviceId']);
  652. $deviceData['UserDevice']['UserId'] = $userId;
  653. $this->UserDevice->save($deviceData);
  654. $DataDeviceId = $this->UserDevice->getInsertID();
  655.  
  656. $lastseen = strtotime(date('Y-m-d H:i:s'));
  657. $this->User->updateAll(array('User.online_status' =>1,'User.current_device_id'=>$DataDeviceId,'User.last_seen'=>$lastseen), array('User.id' =>$userId));
  658. $this->set(array('Response' => array('Error'=>false,'Status'=>1,'UserId'=>$userId,'Message'=>'Success'),'_serialize' => array('Response')));
  659. }
  660. } else{
  661.  
  662. // Updation
  663. if($socialData['User']['online_status']==1){
  664. $this->set(array('Response' => array('Error'=>false,'Status'=>0,'UserId'=>$socialData['User']['id'],'Message'=>'User already online'),'_serialize' => array('Response')));
  665. } else{
  666. $deviceData['UserDevice']['DeviceId'] = trim($this->request->data['DeviceId']);
  667. $deviceData['UserDevice']['UserId'] = $socialData['User']['id'];
  668. $this->UserDevice->save($deviceData);
  669. $newDeviceId = $this->UserDevice->getInsertID();
  670. $fname = $this->request->data['Name'];
  671. $lastseen = strtotime(date('Y-m-d H:i:s'));
  672. $this->User->updateAll(array('User.fbid' =>$fbId,'User.online_status' =>1,'User.current_device_id'=>$newDeviceId,'User.firstname'=>'"'.$fname.'"','User.last_seen'=>$lastseen), array('User.id' => $socialData['User']['id']));
  673.  
  674. $this->set(array('Response' => array('Error'=>false,'Status'=>3,'UserId'=>$socialData['User']['id'],'Message'=>'FBid already registred'),'_serialize' => array('Response')));
  675.  
  676. }
  677. }
  678. }
  679. }
  680.  
  681.  
  682. /**
  683. * @method : updateProfile
  684. * @purpose : Update Login User Data like: Name, Bio etc
  685. * @params : Picture, Name, Bio,UserId
  686. * created_date: 17_06_2016
  687. * updated_date: 21_06_2016
  688. */
  689.  
  690. public function updateProfile(){
  691.  
  692. $error = array();
  693. if(empty($this->request->data['UserId'])){
  694. $error[] = "Missing UserId parameter";
  695. }
  696. if(empty($this->request->data['Name'])){
  697. $error[] = "Missing Name parameter";
  698. }
  699.  
  700. if(empty($this->request->data['Bio'])){
  701. $error[] = "Missing Bio parameter";
  702. }
  703. if($this->request->data['PictureIndex']==''){
  704. $error[] = "Missing PictureIndex parameter";
  705. }
  706.  
  707. if(!empty($error )){
  708. $erroMsg = implode(',', $error);
  709. $message = array('Error'=>true,'Message'=>$erroMsg);
  710. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  711. } else{
  712. $filename ='';
  713. $firstname = trim($this->request->data['Name']);
  714. $info = trim($this->request->data['Bio']);
  715. $UserId = trim($this->request->data['UserId']);
  716. $PictureIndex = trim($this->request->data['PictureIndex']);
  717.  
  718. $userData = $this->User->find('first',array('fields'=>array('PictureIndex'),'conditions'=>array('User.id'=>$UserId)));
  719.  
  720. if(!empty($userData['User']['fbid']) || ($userData['User']['fbid'] != 0) ){
  721. $this->User->updateAll(array('User.PictureIndex'=>4), array('User.id' => $UserId));
  722. }else{
  723. $this->User->updateAll(array('User.PictureIndex'=>$PictureIndex), array('User.id' => $UserId));
  724. }
  725.  
  726. if(!empty($_FILES)){
  727. // Update User Profile
  728. $filename = time().$_FILES['Picture']['name'];
  729.  
  730. move_uploaded_file($_FILES['Picture']['tmp_name'], WWW_ROOT . 'img/members/' . $filename);
  731. $this->User->updateAll(array('User.firstname' =>'"'.$firstname.'"','User.info' =>'"'.$info.'"','User.pic'=>'"'.$filename.'"'), array('User.id' => $UserId));
  732. $message = array('Error'=>false,'Message'=>'Success');
  733. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  734.  
  735. } else{
  736. $this->User->updateAll(array('User.firstname' =>'"'.$firstname.'"','User.info' =>'"'.$info.'"'), array('User.id' => $UserId));
  737. $message = array('Error'=>false,'Message'=>'Success');
  738. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  739. }
  740. }
  741. }
  742.  
  743.  
  744. /**
  745. * @ method : getProfile
  746. * @ params : UserId
  747. * @ created_date : 17_06_2016
  748. */
  749.  
  750. public function getProfile(){
  751. if(empty($_REQUEST['UserId'])){
  752. $this->set(array('Response' => array('Error'=>true,'Message'=>'Missing UserId field'),'_serialize' => array('Response')));
  753. } else{
  754. $userData = $this->User->find('first',array('fields'=>array('id','fbid','star','username','firstname','statas as Statas','info as Bio','pic','PictureIndex','UserPlayGame.total_game','UserPlayGame.win_percent','UserPlayGame.fairPlay'),'conditions'=>array('User.id'=>$_REQUEST['UserId'])));
  755.  
  756. $picUrl = ($userData['User']['pic'])?HTTP_ROOT.'app/webroot/img/members/'.$userData['User']['pic']: $userData['User']['pic'];
  757.  
  758. if(!empty($userData['User']['fbid']) || ($userData['User']['fbid'] != 0) ){
  759. $userData['User']['PictureIndex'] = 4;
  760. }
  761.  
  762. $data['UserId'] = $userData['User']['id'];
  763. $data['FbId'] = $userData['User']['fbid'];
  764. $data['Username'] = $userData['User']['username'];
  765. $data['Name'] = $userData['User']['firstname'];
  766. $data['Bio'] = $userData['User']['Bio'];
  767. $data['Statas'] = $userData['User']['Statas'];
  768. $data['PictureIndex'] = $userData['User']['PictureIndex'];
  769. $data['Star'] = $userData['User']['star'];
  770.  
  771. if(empty($userData['UserPlayGame']['fairPlay'])){
  772. $data['FairPlay'] = 0;
  773. }else{
  774. $data['FairPlay'] = $userData['UserPlayGame']['fairPlay'];
  775. }
  776.  
  777. if(empty($userData['UserPlayGame']['win_percent'])){
  778. $data['WinPercent'] = 0 ;
  779. }else{
  780. $data['WinPercent'] = $userData['UserPlayGame']['win_percent'];
  781. }
  782.  
  783. if(empty($userData['UserPlayGame']['total_game'])){
  784. $data['TotalGame'] = 0;
  785. }else{
  786. $data['TotalGame'] = $userData['UserPlayGame']['total_game'];
  787. }
  788.  
  789. $picUrl = ($userData['User']['pic'])? HTTP_ROOT.'app/webroot/img/members/'.$userData['User']['pic']: $userData['User']['pic'];
  790. $data['Picture'] = $picUrl;
  791. $this->set(array('Response' => array('Error'=>false,'Message'=>'User data','UserData'=>$data),'_serialize' => array('Response')));
  792. }
  793. }
  794.  
  795.  
  796. /**
  797. * @ method : getBadges
  798. * @ params : UserId
  799. * @ created_date : 17_06_2016
  800. */
  801.  
  802. public function getAchievements(){
  803. if(empty($_REQUEST['UserId'])){
  804. $this->set(array('Response' => array('Error'=>true,'Message'=>'Missing UserId field'),'_serialize' => array('Response')));
  805. } else{
  806. $this->loadmodel('UserBadge');
  807. $userId = trim($_REQUEST['UserId']);
  808. $BadgesData = $this->UserBadge->find('first',array('fields'=>array('UserBadge.AchievementData'),'conditions'=>array('UserBadge.user_id'=>$userId)));
  809.  
  810. if(!empty($BadgesData)){
  811.  
  812. $this->set(array('Response' => array('Error'=>false,'AchievementData'=>$BadgesData['UserBadge']['AchievementData'],'Message'=>'Achievements data'),'_serialize' => array('Response')));
  813. } else{
  814. $this->set(array('Response' => array('Error'=>false,'AchievementData'=>'','Message'=>'Achievements data'),'_serialize' => array('Response')));
  815. }
  816. }
  817. }
  818.  
  819.  
  820. /**
  821. * @method : setBadges
  822. * @prams : UserId,name
  823. * @created_date : 17_06_2016
  824. */
  825.  
  826. public function setBadges(){
  827. $error = array();
  828. if(empty($this->request->data['UserId'])){
  829. $error[] = "Missing UserId parameter";
  830. }
  831. if(empty($this->request->data['AchievementData'])){
  832. $error[] = "Missing AchievementData parameter";
  833. }
  834. if(!empty($error )){
  835. $erroMsg = implode(',', $error);
  836. $message = array('Error'=>true,'Message'=>$erroMsg);
  837. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  838. } else{
  839. $this->loadmodel('UserBadge');
  840. // Check this Badge alredy added or not
  841. $badgename = trim($this->request->data['AchievementData']);
  842. $userId = trim($this->request->data['UserId']);
  843. $checkBadge = $this->UserBadge->find('count',array('conditions'=>array('UserBadge.user_id'=>$userId)));
  844. if($checkBadge>0){
  845.  
  846. // Update
  847. $this->UserBadge->updateAll(array('UserBadge.AchievementData' =>'"'.$badgename.'"'),array('UserBadge.user_id' =>$userId));
  848. $message = array('Error'=>false,'Message'=>'Badges updated');
  849. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  850. }else{
  851.  
  852. $saveData['UserBadge']['user_id'] = $userId;
  853. $saveData['UserBadge']['AchievementData'] = $badgename;
  854. $this->UserBadge->save($saveData);
  855. $message = array('Error'=>false,'Message'=>'Success');
  856. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  857. }
  858. }
  859. }
  860.  
  861. /**
  862. * @method : updateSetting
  863. * @params : UserId, StatasStatus
  864. * @created_date : 17_06_2016
  865. */
  866.  
  867. public function updateSetting(){
  868. $error = array();
  869. if(empty($this->request->data['UserId'])){
  870. $error[] = "Missing UserId parameter";
  871. }
  872. if($this->request->data['StatasStatus']==''){
  873. $error[] = "Missing StatasStatus parameter";
  874. }
  875. if(!empty($error )){
  876. $erroMsg = implode(',', $error);
  877. $message = array('Error'=>true,'Message'=>$erroMsg);
  878. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  879. } else{
  880. $UserId = trim($this->request->data['UserId']);
  881. $status = trim($this->request->data['StatasStatus']);
  882. $this->User->updateAll(array('User.statas' =>$status), array('User.id' =>$UserId));
  883. $message = array('Error'=>false,'Message'=>'Success');
  884. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  885. }
  886. }
  887.  
  888.  
  889. /**
  890. * @method : forgotPassword
  891. * @params : Email
  892. * @created : 18_06_2016
  893. *
  894. */
  895.  
  896. public function forgotPassword(){
  897. if(empty($_REQUEST['Email'])){
  898. $this->set(array('Response' => array('Error'=>true,'Message'=>'Missing Email field'),'_serialize' => array('Response')));
  899. } else{
  900. $email = trim($_REQUEST['Email']);
  901. $userData = $this->User->find('first',array('conditions'=>array('User.email'=>$email,'User.username !='=>''),'fields'=>array('User.id','User.email','User.username'),'recursive'=>-1));
  902. if(!empty($userData)){
  903. // Send Mail
  904. $userId = $userData['User']['id'];
  905. $rnadPass = $this->randPass();
  906. $password = md5($rnadPass);
  907. $checkup = $this->User->updateAll(array('User.password' =>'"'.$password.'"'), array('User.id' =>$userId));
  908.  
  909. if($checkup){
  910. $aMsg = "<p>Your Username is: ".$userData['User']['username']."</p>";
  911. $aMsg .= "Your password is: ".$rnadPass;
  912. $this->Session->write('Person.forgotpass', $aMsg);
  913. $this->AWSSES->to = trim($email);
  914.  
  915. if($this->AWSSES->_aws_ses('forgot',$aMsg)){
  916. $arr = array('Response' => array('Error'=>false,'Message'=>'Your Login password has been sent to your mail. Please check.'));
  917. echo json_encode($arr);
  918. }else{
  919. $message = array('Response' =>array('Error'=>true,'Message'=>'Email failed'));
  920. echo json_encode($message);
  921. }
  922. } else{
  923. $message = array('Error'=>true,'Message'=>'Failed !');
  924. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  925. }
  926. }
  927. $message = array('Error'=>false,'Message'=>'Your Login password has been sent to your mail. Please check.');
  928. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  929. }
  930. }
  931.  
  932.  
  933. /**
  934. * @get 6 digint random password
  935. *
  936. */
  937.  
  938. public function randPass(){
  939. $alphabets = range('a','z');
  940. $numbers = range('0','9');
  941.  
  942. $final_array = array_merge($alphabets,$numbers);
  943. $password = '';
  944. $length = 7;
  945. while($length--) {
  946. $key = array_rand($final_array);
  947. $password .= $final_array[$key];
  948. }
  949.  
  950. return $password;
  951.  
  952. }
  953.  
  954. /**
  955. * @method : logOut
  956. * @purpose : Delete User's Current DeviceId
  957. * @created_date : 20_06_2016
  958. */
  959.  
  960. public function logOut(){
  961. $error = array();
  962. if(empty($this->request->data['UserId'])){
  963. $error[] = "Missing UserId parameter";
  964. }
  965. if(empty($this->request->data['DeviceId'])){
  966. $error[] = "Missing DeviceId parameter";
  967. }
  968. if(!empty($error )){
  969. $erroMsg = implode(',', $error);
  970. $message = array('Error'=>true,'Message'=>$erroMsg);
  971. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  972. } else{
  973. try{
  974. $userId = trim($this->request->data['UserId']);
  975.  
  976. $this->removidleuser($userId);
  977.  
  978. $DeviceId = trim($this->request->data['DeviceId']);
  979.  
  980. $this->UserDevice->query("DELETE FROM user_devices where UserId=? and DeviceId = ?",[$userId,$DeviceId]);
  981.  
  982. // Now Update Current Device field in Users Tabls
  983. $this->User->query("UPDATE users SET current_device_id = '', online_status=0 where id=$userId");
  984.  
  985. $this->set(array('Response' => array('Error'=>false,'Message'=>'Success'),'_serialize' => array('Response')));
  986. } catch (Exception $e) {
  987. $this->set(array('Response' => array('Error'=>true,'Message'=>$e->getMessage()),'_serialize' => array('Response')));
  988. }
  989. }
  990. }
  991.  
  992. /**
  993. * @check EmailId already Registrd or not
  994. * @created_date : 15_06_2016
  995. */
  996.  
  997. public function checkEmail($email=null) {
  998. $records1 = $this->User->find('count',array('conditions'=>array('User.email'=>$email)));
  999. if($records1>0){
  1000. return 1;
  1001. } else{
  1002. return 0;
  1003. }
  1004.  
  1005. }
  1006.  
  1007. /**
  1008. * @check username user_badges UserBadge
  1009. * @ check useranem unique
  1010. * @ create_date: 16_06_2016
  1011. */
  1012.  
  1013. public function checkUserName($username=null){
  1014. $usernameCount = $this->User->find('count',array('conditions'=>array('OR' => array(array('User.username' =>$username),array('User.nick' =>$username)))));
  1015. if($usernameCount>0){
  1016. return 1;
  1017. } else{
  1018. return 0;
  1019. }
  1020. }
  1021.  
  1022. /**
  1023. * @ check fbId already registred or Not
  1024. * @ created_date: 16_06_2016
  1025. */
  1026.  
  1027. public function checkfbId($fbid=null){
  1028. $userData = $this->User->find('first',array('conditions' =>array('fbid'=>$fbid)));
  1029.  
  1030. return $userData;
  1031. }
  1032.  
  1033. /**
  1034. * @ Check fb email already registred or Not
  1035. *
  1036. */
  1037.  
  1038. public function checkFbEmail($fbemail=null){
  1039. $userData2 = $this->User->find('first',array('fields'=>array('id','email','online_status'),'conditions'=>array('User.email'=>$fbemail)));
  1040. return $userData2;
  1041. }
  1042.  
  1043. public function checkFbUsername($username=null) {
  1044. $checkUsername = $this->User->find('first',array('fields'=>array('id','email','online_status'),
  1045. 'conditions'=>array('User.username'=>$username)));
  1046. return $checkUsername;
  1047. }
  1048.  
  1049.  
  1050. /*
  1051. status: 0 not registered, 1 online, 2 offline
  1052. */
  1053. public function checkdevice() {
  1054. $error = array();
  1055. if(empty($this->request->data['FbId'])){
  1056. $error[] = "Missing FbId parameter";
  1057. }
  1058. if(empty($this->request->data['DeviceId'])){
  1059. $error[] = "Missing DeviceId parameter";
  1060. }
  1061.  
  1062. if(!empty($error )){
  1063. $erroMsg = implode(',', $error);
  1064. $message = array('Error'=>true,'Message'=>$erroMsg);
  1065. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1066. } else{
  1067. $userfbid = $this->request->data['FbId'];
  1068. $deviceid = $this->request->data['DeviceId'];
  1069. $userdata = $this->User->find('first',array('conditions'=>array('User.fbid' => $userfbid)));
  1070.  
  1071. if(empty($userdata)){
  1072. $this->set(array('Response' => array('Error'=> false,'Status'=> 0,'Message' => 'The user is not registered'),'_serialize'=>array('Response')));
  1073. }else{
  1074. $userstatus = $userdata['User']['online_status'];
  1075. $currentdevice = $userdata['User']['current_device_id'];
  1076. $userid = $userdata['User']['id'];
  1077.  
  1078. $devicedata = $this->UserDevice->find('first',array('conditions'=>array('UserDevice.UserId' => $userid,'UserDevice.id' => $currentdevice),'order' =>array('UserDevice.id DESC')));
  1079.  
  1080. if(empty($devicedata)) {
  1081. $currentdeviceid = "";
  1082. }else{
  1083. $currentdeviceid = $devicedata['UserDevice']['DeviceId'];
  1084. }
  1085.  
  1086. if($userstatus == 1 && $currentdeviceid != $deviceid ) {
  1087. $this->set(array('Response' => array('UserId' => $userid,'Error'=> false,'Status'=> 1,'Message' => 'The user is registered'),'_serialize'=>array('Response')));
  1088. }else{
  1089. $lastseen = strtotime(date('Y-m-d H:i:s'));
  1090. $deviceData['UserDevice']['DeviceId'] = trim($this->request->data['DeviceId']);
  1091. $deviceData['UserDevice']['UserId'] = $userid;
  1092. $this->UserDevice->save($deviceData);
  1093. $DataDeviceId = $this->UserDevice->getInsertID();
  1094. $lastseen = strtotime(date('Y-m-d H:i:s'));
  1095. $this->User->updateAll(array('User.online_status' =>1,'User.current_device_id'=>$DataDeviceId,'User.last_seen'=>$lastseen), array('User.id' =>$userid));
  1096. $this->set(array('Response' => array('UserId' => $userid,'Error'=> false,'Status'=> 2,'Message' => 'The user is registered'),'_serialize'=>array('Response')));
  1097. }
  1098. }
  1099. }
  1100. }
  1101.  
  1102. /**
  1103. * @method : merge
  1104. * Params : UserId, FbId
  1105. * Purpose : Merge FBId after Siple Email Login
  1106. * Create_date : 28_06_2016
  1107. */
  1108.  
  1109. public function mergeFacebookId(){
  1110. $error = array();
  1111. if(empty($this->request->data['FbId'])){
  1112. $error[] = "Missing FbId parameter";
  1113. }
  1114. if(empty($this->request->data['UserId'])){
  1115. $error[] = "Missing UserId parameter";
  1116. }
  1117.  
  1118. if(!empty($error )){
  1119. $erroMsg = implode(',', $error);
  1120. $message = array('Error'=>true,'Message'=>$erroMsg);
  1121. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1122. } else{
  1123. $fbId = trim($this->request->data['FbId']);
  1124. $userId = trim($this->request->data['UserId']);
  1125. $fbuser = $this->User->find('first',array('conditions'=>array('User.fbid'=>$fbId),'fields'=>array('User.id','User.fbid')));
  1126. if(!empty($fbuser)){
  1127. // if FbId for Othe User
  1128. if( $fbuser['User']['id'] !=$userId){
  1129. $this->set(array('Response' => array('Error'=> false,'Status'=> 2,'Message' => 'This FbId alredy set for other user'),'_serialize'=>array('Response')));
  1130. } else{
  1131. $this->set(array('Response' => array('Error'=> false,'Status'=> 3,'Message' => 'This FbId alredy set for current user'),'_serialize'=>array('Response')));
  1132. }
  1133. } else{
  1134. // Set This FB id to Current User
  1135. // One New Case: if Fb Id new but this user alredy connected with other FB then Status: 4
  1136.  
  1137. $getUser=$this->User->find('first',array('conditions'=>array('User.id'=>$userId),'fields'=>array('User.id','User.fbid')));
  1138.  
  1139. if(isset($getUser['User']['fbid']) && !empty($getUser['User']['fbid']) ){
  1140. $this->set(array('Response' => array('Error'=> false,'Status'=> 4,'Message' => 'This user alredy connected with other fbid'),'_serialize'=>array('Response')));
  1141. } else{
  1142. // Now Update
  1143. $this->User->updateAll(array('User.fbid' =>'"'.$fbId.'"'), array('User.id' =>$userId));
  1144. $this->set(array('Response' => array('Error'=> false,'Status'=> 1,'Message' => 'Success'),'_serialize'=>array('Response')));
  1145. }
  1146. }
  1147. }
  1148. }
  1149.  
  1150.  
  1151. /**
  1152. * @method : addFriend
  1153. * @Params : UserId, FriendId
  1154. * Created_date : 29_06_2016
  1155. */
  1156.  
  1157. public function addFriend(){
  1158. $error = array();
  1159. if(empty($this->request->data['UserId'])){
  1160. $error[] = "Missing UserId parameter";
  1161. }
  1162. if(empty($this->request->data['FriendId'])){
  1163. $error[] = "Missing FriendId parameter";
  1164. }
  1165.  
  1166. if(!empty($error )){
  1167. $erroMsg = implode(',', $error);
  1168. $message = array('Error'=>true,'Message'=>$erroMsg);
  1169. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1170. } else{
  1171. /** Check User Already friend List */
  1172. $this->loadmodel('UserFriend');
  1173. $userId = trim($this->request->data['UserId']);
  1174. $FriendId = trim($this->request->data['FriendId']);
  1175. $Data = $this->UserFriend->find('first',array('conditions'=>array('UserFriend.UserId'=>$userId,'UserFriend.FriendId'=>$FriendId),'fields'=>array('UserFriend.id'),'recursive'=>-1));
  1176. if(!empty($Data)){
  1177. $this->set(array('Response' => array('Error'=>false,'Message'=>'Already in friend list'),'_serialize' => array('Response')));
  1178. } else{
  1179. // Add friend
  1180. $this->UserFriend->save($this->request->data);
  1181. $this->set(array('Response' => array('Error'=>false,'Message'=>'Success'),'_serialize' => array('Response')));
  1182. }
  1183. }
  1184. }
  1185.  
  1186. /**
  1187. * @method : removeFriend
  1188. * @Params : UserId, FriendId
  1189. * @created_date : 29_06_2016
  1190. */
  1191.  
  1192. public function removeFriend(){
  1193. $error = array();
  1194. if(empty($this->request->data['UserId'])){
  1195. $error[] = "Missing UserId parameter";
  1196. }
  1197. if(empty($this->request->data['FriendId'])){
  1198. $error[] = "Missing FriendId parameter";
  1199. }
  1200.  
  1201. if(!empty($error )){
  1202. $erroMsg = implode(',', $error);
  1203. $message = array('Error'=>true,'Message'=>$erroMsg);
  1204. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1205. } else{
  1206. $this->loadmodel('UserFriend');
  1207. $userId = trim($this->request->data['UserId']);
  1208. $FriendId = trim($this->request->data['FriendId']);
  1209. $this->UserFriend->deleteAll(array('UserFriend.UserId'=>$userId,'UserFriend.FriendId'=>$FriendId));
  1210. $this->set(array('Response'=>array('Error'=>false,'Message'=>'Success'),'_serialize' => array('Response')));
  1211. }
  1212. }
  1213.  
  1214. /**
  1215. * @method : getFriendList
  1216. * @Params : UserId
  1217. */
  1218.  
  1219. public function getFriendList(){
  1220. if(empty($_REQUEST['UserId'])){
  1221. $this->set(array('Response' => array('Error'=>true,'Message'=>'Missing UserId field'),'_serialize' => array('Response')));
  1222. } else{
  1223. //
  1224. $this->loadmodel('UserFriend');
  1225. $userId = trim($_REQUEST['UserId']);
  1226. $friendData = $this->UserFriend->find('all',array('conditions'=>array('UserFriend.UserId'=>$userId),'fields'=>array('User.id','User.username','User.fbid','User.star','User.pic','User.online_status','User.PictureIndex') ));
  1227.  
  1228. $data = array();
  1229. if(!empty($friendData)){
  1230.  
  1231. foreach($friendData as $key=>$val){
  1232. if(isset($val['User']['id'])){
  1233. $data[$key]['UserId'] = $val['User']['id'];
  1234. $data[$key]['Star'] = $val['User']['star'];
  1235. $data[$key]['Name'] = $val['User']['username'];
  1236. $data[$key]['FbId'] = $val['User']['fbid'];
  1237. $data[$key]['OnlineStatus'] = $val['User']['online_status'];
  1238. $data[$key]['PictureIndex'] = $val['User']['PictureIndex'];
  1239. $picUrl = ($val['User']['pic']) ? HTTP_ROOT.'img/members/'.$val['User']['pic']: $val['User']['pic'];
  1240. $data[$key]['Picture'] = $picUrl;
  1241. }
  1242. }
  1243. $data=array_values($data);
  1244. }
  1245.  
  1246. $this->set(array('Response' => array('Error'=>false,'CustomFriendData'=>$data),'_serialize' => array('Response')));
  1247. }
  1248. }
  1249.  
  1250. /**
  1251. * @method : lastSeen
  1252. * @Params : UserId
  1253. */
  1254.  
  1255. public function lastSeen(){
  1256.  
  1257. $error = array();
  1258. if(empty($_REQUEST['UserId'])){
  1259. $error[] = "Missing UserId parameter";
  1260. }
  1261.  
  1262. if(!empty($error )){
  1263. $erroMsg = implode(',', $error);
  1264. $message = array('Error'=>true,'Message'=>$erroMsg);
  1265. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1266. }else{
  1267. $userId = $_REQUEST['UserId'];
  1268. $data=array();
  1269.  
  1270. $userplaydata = $this->UserPlayGame->find('all', array('conditions' => array('UserPlayGame.user_id'=> $userId), 'recursive' => -1));
  1271. if(count($userplaydata) > 0){
  1272. $homerun = $userplaydata[0]['UserPlayGame']['HomeRun'];
  1273. $Forcer = $userplaydata[0]['UserPlayGame']['Forcer'];
  1274. $Ace = $userplaydata[0]['UserPlayGame']['Ace'];
  1275. $Unstoppable = $userplaydata[0]['UserPlayGame']['Unstoppable'];
  1276. $Winner = $userplaydata[0]['UserPlayGame']['Winner'];
  1277. $Player = $userplaydata[0]['UserPlayGame']['Player'];
  1278. $Looser = $userplaydata[0]['UserPlayGame']['Looser'];
  1279. $FullHouse = $userplaydata[0]['UserPlayGame']['FullHouse'];
  1280. $WinStreak = $userplaydata[0]['UserPlayGame']['WinStreak'];
  1281. $XthreeWinStreak = $userplaydata[0]['UserPlayGame']['XthreeWinStreak'];
  1282. $XfiveWinstreak = $userplaydata[0]['UserPlayGame']['XfiveWinstreak'];
  1283. $XtenWinstreak = $userplaydata[0]['UserPlayGame']['XtenWinstreak'];
  1284.  
  1285. $data = array($Ace,$Unstoppable,$Winner,$Player,$XthreeWinStreak,$XfiveWinstreak,$XtenWinstreak,$Looser,$FullHouse,$homerun,$Forcer);
  1286. }
  1287.  
  1288. $lastseen = strtotime(date('Y-m-d H:i:s'));
  1289. if(empty($_REQUEST['DeviceId'])){
  1290. $this->User->updateAll(array('User.online_status' =>1,'User.last_seen'=>$lastseen), array('User.id' => $userId));
  1291. $this->set(array('Response' => array('Error'=>false,'Message'=>'Success','IsAvailable' =>true,'UserAchievementData' => $data),'_serialize' => array('Response')));
  1292.  
  1293. }else{
  1294. $deviceid = $_REQUEST['DeviceId'];
  1295. $devicedata = $this->UserDevice->find('first',array('conditions'=>array('UserDevice.UserId' => $userId,'UserDevice.DeviceId' => $deviceid),'order' =>array('UserDevice.id DESC')));
  1296.  
  1297. if(empty($devicedata)) {
  1298. $currentdeviceid = "";
  1299. }else{
  1300. $currentdeviceid = $devicedata['UserDevice']['id'];
  1301. }
  1302.  
  1303. $chkusersdevice = $this->User->find('first',array('conditions' => array('User.id' => $userId),'recursive' => -1));
  1304.  
  1305. if($chkusersdevice['User']['online_status'] == 1){
  1306.  
  1307. if($chkusersdevice['User']['current_device_id'] == $currentdeviceid){
  1308.  
  1309. $this->User->updateAll(array('User.online_status' =>1,'User.last_seen'=>$lastseen), array('User.id' => $userId));
  1310.  
  1311. //*******room termination 21-11-2016 *****//
  1312. if(empty($_REQUEST['RoomId'])){
  1313.  
  1314. $this->set(array('Response' => array('Error'=>false,'Message'=>'Success','IsAvailable' =>true,'UserAchievementData' => $data, 'AutoTerminateTable' => false),'_serialize' => array('Response')));
  1315.  
  1316. }else{
  1317.  
  1318. $autoterminate = true;
  1319. $curentRoomId = $_REQUEST['RoomId'];
  1320. $chkRoomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $curentRoomId), 'recursive' => -1));
  1321.  
  1322. //check if room exists or not
  1323. if((!empty($chkRoomdata)) ) {
  1324. //to check if current time is greater that time limit for room termination
  1325.  
  1326. $roomterminateTime = $chkRoomdata['Room']['auto_terminate_update'];
  1327. $joinmemberCount = $chkRoomdata['Room']['join_member_count'];
  1328. $roomStatus = $chkRoomdata['Room']['room_status'];
  1329.  
  1330. $getGameplayData = $this->GamePlayData->find('first', array('conditions' => array('GamePlayData.RoomId' => $curentRoomId), 'recursive' => -1));
  1331.  
  1332. if((strtotime(date('Y-m-d H:i:s')) - strtotime(date($roomterminateTime))) >= 150 && !empty($chkRoomdata['Room']['PhotonId']) && ( empty($getGameplayData) || ($joinmemberCount < 4 && $roomStatus != 2))) {
  1333. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $curentRoomId));
  1334. $this->Room->delete($curentRoomId);
  1335. $autoterminate = true;
  1336. }
  1337. else {
  1338. $autoterminate = false;
  1339. }
  1340. }
  1341.  
  1342. $this->set(array('Response'=>array('Error'=>false,'Message'=>'Success','IsAvailable' =>true,'UserAchievementData' => $data, 'AutoTerminateTable' => $autoterminate),'_serialize'=>array('Response')));
  1343. }
  1344.  
  1345. //*******room termination *****//
  1346.  
  1347.  
  1348. }elseif($chkusersdevice['User']['current_device_id'] != $currentdeviceid){
  1349. $this->set(array('Response' => array('Error'=>false,'Message'=>'Success','IsAvailable' =>'AlreadySignin'),'_serialize' => array('Response')));
  1350. }
  1351. }else{
  1352. $this->User->updateAll(array('User.online_status' =>1,'User.last_seen'=>$lastseen), array('User.id' => $userId));
  1353. $this->set(array('Response' => array('Error'=>false,'Message'=>'Success','IsAvailable' =>true,'UserAchievementData' => $data),'_serialize' => array('Response')));
  1354. }
  1355. }
  1356. }
  1357. }
  1358.  
  1359.  
  1360.  
  1361. /**
  1362. * @created_date : 15_07_2016
  1363. */
  1364. public function searchUser() {
  1365. $error = array();
  1366. if(empty($_REQUEST['UserId'])){
  1367. $error[] = "Missing UserId parameter";
  1368. }
  1369.  
  1370. if(!empty($error )){
  1371. $erroMsg = implode(',', $error);
  1372. $message = array('Error'=>true,'Message'=>$erroMsg);
  1373. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1374. }else{
  1375. $this->loadmodel('UserFriend');
  1376. $userId = trim($_REQUEST['UserId']);
  1377.  
  1378.  
  1379. $limit = 50;
  1380. if(!empty($_REQUEST['Limit'])){
  1381. $limit = $_REQUEST['Limit'];
  1382. }
  1383. $page = 1;
  1384. if(!empty($this->request->data['page'])){
  1385. $page = $this->request->data['page'];
  1386. }
  1387. $offset = ( $page - 1 ) * $limit;
  1388.  
  1389. $UserFrinds = $this->UserFriend->find('list',array('conditions'=>array('UserFriend.UserId'=>$userId),'fields'=>array('UserFriend.FriendId'),'recursive'=>-1));
  1390.  
  1391. array_push($UserFrinds,$userId);
  1392.  
  1393. if(isset($_REQUEST['Username']) && !empty($_REQUEST['Username'])){
  1394. // Get List Of UserFriend
  1395. $username = trim($_REQUEST['Username']);
  1396. $userData = $this->User->find('all', array(
  1397. 'conditions' => array("NOT" => array( "User.id" => $UserFrinds),'Username LIKE'=>'%'.$username.'%','User.username !='=>''),
  1398. 'fields'=>array('User.id','User.username','User.fbid','User.star','User.pic','User.online_status','User.PictureIndex'),
  1399. 'limit' => $limit,
  1400. 'page' => $page,
  1401. 'offset'=>$offset,'recursive'=>-1));
  1402.  
  1403. $data = array();
  1404. if(!empty($userData)){
  1405.  
  1406. foreach($userData as $key=>$val){
  1407.  
  1408. $data[$key]['UserId'] = $val['User']['id'];
  1409. $data[$key]['Name'] = $val['User']['username'];
  1410. $data[$key]['FbId'] = $val['User']['fbid'];
  1411. $data[$key]['Star'] = $val['User']['star'];
  1412. $data[$key]['OnlineStatus'] = $val['User']['online_status'];
  1413. $data[$key]['PictureIndex'] = $val['User']['PictureIndex'];
  1414. $picUrl = ($val['User']['pic']) ? HTTP_ROOT.'img/members/'.$val['User']['pic']: $val['User']['pic'];
  1415. $data[$key]['Picture'] = $picUrl;
  1416.  
  1417. }
  1418. }
  1419. $this->set(array('Response' => array('Error'=>false,'UserData'=>$data),'_serialize' => array('Response')));
  1420. } else{
  1421. // Game Played by This User
  1422. $userData = $this->User->find('all', array(
  1423. 'conditions' => array("NOT" => array( "User.id" => $UserFrinds),'User.username !='=>''),
  1424. 'fields'=>array('User.id','User.username','User.fbid','User.star','User.pic','User.online_status','User.PictureIndex'),
  1425. 'limit' => $limit,
  1426. 'page' => $page,
  1427. 'offset'=>$offset,'order' => 'rand()','recursive'=>-1));
  1428.  
  1429. $data = array();
  1430. if(!empty($userData)){
  1431.  
  1432. foreach($userData as $key=>$val){
  1433.  
  1434. $data[$key]['UserId'] = $val['User']['id'];
  1435. $data[$key]['Name'] = $val['User']['username'];
  1436. $data[$key]['FbId'] = $val['User']['fbid'];
  1437. $data[$key]['Star'] = $val['User']['star'];
  1438. $data[$key]['OnlineStatus'] = $val['User']['online_status'];
  1439. $data[$key]['PictureIndex'] = $val['User']['PictureIndex'];
  1440. $picUrl = ($val['User']['pic']) ? HTTP_ROOT.'img/members/'.$val['User']['pic']: $val['User']['pic'];
  1441. $data[$key]['Picture'] = $picUrl;
  1442. }
  1443. }
  1444. $this->set(array('Response' => array('Error'=>false,'UserData'=>$data),'_serialize' => array('Response')));
  1445. }
  1446. }
  1447. }
  1448.  
  1449.  
  1450. public function GetStar(){
  1451.  
  1452. $error = array();
  1453. if(empty($_REQUEST['Id'] )){
  1454. $error[] = "Missing Id parameter";
  1455. }
  1456. if(empty($_REQUEST['IdType'] )){
  1457. $error[] = "Missing IdType parameter";
  1458. }
  1459.  
  1460. if(!empty($error )){
  1461. $erroMsg = implode(',', $error);
  1462. $message = array('Error'=>true,'Message'=>$erroMsg);
  1463. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1464. }else{
  1465.  
  1466. if($_REQUEST['IdType'] == 1){
  1467. $userid = $_REQUEST['Id'];
  1468. $fbid = '';
  1469. $getstarinfo = $this->User->find('first' , array('conditions' => array('User.id' => $userid), 'fields' => array('star'), 'recursive' => -1));
  1470.  
  1471. if(!empty($getstarinfo)){
  1472. $star = $getstarinfo['User']['star'];
  1473. }else{
  1474. $star = 0 ;
  1475. }
  1476.  
  1477. $this->set(array('Response' => array('Error'=>false,'Star'=> $star),'_serialize' => array('Response')));
  1478.  
  1479. }elseif($_REQUEST['IdType'] == 2){
  1480.  
  1481. $fbid = $_REQUEST['Id'];
  1482. $userid = '';
  1483.  
  1484. $getstarinfo = $this->User->find('first' , array('conditions' => array('User.fbid ' => $fbid), 'fields' => array('star'), 'recursive' => -1));
  1485.  
  1486. if(!empty($getstarinfo)){
  1487. $star = $getstarinfo['User']['star'];
  1488. }else
  1489. $star = 0 ;
  1490.  
  1491. $this->set(array('Response' => array('Error'=>false,'Star'=> $star),'_serialize' => array('Response')));
  1492. }else{
  1493.  
  1494. $idtype = $_REQUEST['IdType'];
  1495. $this->set(array('Response'=>array('Error'=>false,'Message'=>'wrong IdType '.$idtype.''),'_serialize' => array('Response')));
  1496. }
  1497. }
  1498. }
  1499.  
  1500. public function saveRoundScore() {
  1501.  
  1502. $data = $_POST['JsonData'];
  1503. $json = ''.$data.'';
  1504.  
  1505. if(empty($json)){
  1506. $errorData = array('Error' => true, 'Message' => 'No Data Parameters');
  1507. $this->set(array('Response' => $errorData , '_serialize' => array('Response')));
  1508. }
  1509.  
  1510. $yummy = json_decode($json);
  1511. $RoomData = $yummy;
  1512.  
  1513. if(!empty($RoomData)){
  1514. $error = array();
  1515.  
  1516. $senderId = $RoomData->SenderId ;
  1517. $RoomId = $RoomData->RoomId;
  1518. $RoundIndex = $RoomData->RoundIndex;
  1519. if(empty($senderId)) {
  1520. $error[] = "SenderId parameter is empty.";
  1521. }
  1522. if(empty($RoomId)){
  1523. $error[] = "RoomId parameter is empty.";
  1524. }
  1525. if(empty($RoundIndex)){
  1526. $error[] = "RoundIndex parameter is empty.";
  1527. }
  1528.  
  1529. $ScoreDataArray = $RoomData->ScoreData ;
  1530.  
  1531. if(empty($ScoreDataArray)){
  1532. $error[] = "ScoreData parameter is empty.";
  1533. }
  1534.  
  1535. if(!empty($error)){
  1536. $errorMessage = implode(',',$error);
  1537. $errorData = array('Error' => true, 'Message' => $errorMessage);
  1538. $this->set(array('Response' => $errorData , '_serialize' => array('Response')));
  1539. }else{
  1540. $checkdata = $this->RoundScore->find('all',array('conditions'=>array('RoundScore.RoomId' => $RoomId,'RoundScore.RoundIndex' => $RoundIndex)));
  1541.  
  1542. if(count($checkdata) > 0 ){
  1543. $this->set(array('Response'=>array('Error'=>false , 'Message' => 'Round already exist'), '_serialize' => array('Response')));
  1544.  
  1545. }else {
  1546. $teamAarray = $ScoreDataArray[0]->TeamA ;
  1547. $teamAscore = $teamAarray->Score;
  1548. $teamBarray = $ScoreDataArray[1]->TeamB ;
  1549. $teamBscore = $teamBarray->Score;
  1550.  
  1551. if(!empty($teamAscore)){
  1552. $teamAscore = $teamAscore ;
  1553. }else{
  1554. $teamAscore = 0 ;
  1555. }
  1556. $TeamAusers = implode(',',$teamAarray->Users);
  1557. $created_at = strtotime(date('Y-m-d H:i:s'));
  1558.  
  1559. if( $teamAscore > $teamBscore){
  1560. $roundResultA = 'W';
  1561. }elseif($teamAscore < $teamBscore){
  1562. $roundResultA = 'R';
  1563. }elseif($teamAscore == $teamBscore){
  1564. $roundResultA = 'D';
  1565. }
  1566.  
  1567. $teamAdata = array('Result' => $roundResultA,'SenderId' => $senderId, 'RoomId' => $RoomId ,'Score' => $teamAscore ,'RoundIndex' => $RoundIndex ,'Team' => 'A' , 'TeamUsers' => $TeamAusers, 'created_at' => $created_at);
  1568.  
  1569. if(!empty($teamBscore)){
  1570. $teamBscore = $teamBscore ;
  1571. }else{
  1572. $teamBscore = 0 ;
  1573. }
  1574.  
  1575. if($teamBscore > $teamAscore){
  1576. $roundResultB = 'W';
  1577. }elseif($teamBscore < $teamAscore){
  1578. $roundResultB = 'R';
  1579. }elseif($teamBscore == $teamAscore){
  1580. $roundResultB = 'D';
  1581. }
  1582.  
  1583. $TeamBusers = implode(',',$teamBarray->Users);
  1584. $teamBdata = array('Result' => $roundResultB,'SenderId' => $senderId, 'RoomId' => $RoomId ,'Score' => $teamBscore ,'RoundIndex' => $RoundIndex ,'Team' => 'B' , 'TeamUsers' => $TeamBusers, 'created_at' => $created_at);
  1585.  
  1586. $data1 = $teamAdata ;
  1587. $data2 = $teamBdata ;
  1588. $allData = array($data1, $data2);
  1589.  
  1590. $saveData = $this->RoundScore->saveAll($allData);
  1591. $this->set(array('Response' => array('Error' => false , 'Message' => 'Success'), '_serialize' => array('Response')));
  1592. }
  1593. }
  1594.  
  1595. }else{
  1596. $erroMsg = "JsonData parameter is empty";
  1597. $message = array('Error'=>true,'Message'=>$erroMsg);
  1598. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1599. }
  1600. }
  1601.  
  1602. public function SaveFinalScore() {
  1603.  
  1604. $data = $_POST['JsonData'];
  1605. $json = ''.$data.'';
  1606.  
  1607. $yummy = json_decode($json);
  1608.  
  1609. $RoomData = $yummy;
  1610. if(!empty($RoomData)){
  1611.  
  1612. $error = array();
  1613. $senderId = $RoomData->SenderId ;
  1614. $RoomId = $RoomData->RoomId;
  1615.  
  1616. if(empty($senderId)) {
  1617. $error[] = "SenderId parameter is empty.";
  1618. }
  1619. if(empty($RoomId)){
  1620. $error[] = "RoomId parameter is empty.";
  1621. }
  1622.  
  1623. $ScoreDataArray = $RoomData->ScoreData ;
  1624.  
  1625. if(empty($ScoreDataArray)){
  1626. $error[] = "ScoreData parameter is empty.";
  1627. }
  1628. if(!empty($error)){
  1629. $errorMessage = implode(',',$error);
  1630. $errorData = array('Error' => true, 'Message' => $errorMessage);
  1631. $this->set(array('Response' => $errorData , '_serialize' => array('Response')));
  1632. }else{
  1633. $checkdata = $this->FinalScore->find('all',array('conditions'=>array('FinalScore.RoomId' => $RoomId)));
  1634.  
  1635. if(count($checkdata) > 0 ){
  1636. $this->set(array('Response' => array('Error' => false , 'Message' => 'Room data already exists.'), '_serialize' => array('Response')));
  1637. } else {
  1638. $createdAt = strtotime(date('Y-m-d H:i:s'));
  1639.  
  1640. $WinnerArray = $ScoreDataArray[0]->Winner;
  1641. $WinnerScore = $WinnerArray->Score;
  1642. $WinPlayers = implode(',',$WinnerArray->Users);
  1643.  
  1644. $WinnerData = array('SenderId' => $senderId, 'RoomId' => $RoomId, 'Result' => 'W', 'Players' => $WinPlayers, 'Score' => $WinnerScore, 'CreatedAt' => $createdAt);
  1645.  
  1646. $RunnerArray = $ScoreDataArray[1]->Runner;
  1647. $RunnerScore = $RunnerArray->Score;
  1648. $RunnerPlayers = implode(',',$RunnerArray->Users);
  1649.  
  1650. $RunnerData = array('SenderId' => $senderId, 'RoomId' => $RoomId, 'Result' => 'R', 'Players' => $RunnerPlayers, 'Score' => $RunnerScore, 'CreatedAt' => $createdAt);
  1651.  
  1652. $allPlayers = array_merge($WinnerArray->Users,$RunnerArray->Users);
  1653.  
  1654. $total_rounds = $this->RoundScore->find('all',array('conditions' => array('RoundScore.RoomId' => $RoomId,'RoundScore.TeamUsers' => $WinPlayers ), 'recursive' => -1));
  1655.  
  1656. $getRoundDatawinnner = $this->RoundScore->find('all',array('conditions' => array('RoundScore.RoomId' => $RoomId,'RoundScore.Result' => 'W', 'RoundScore.TeamUsers' => $WinPlayers ), 'recursive' => -1));
  1657. $whouseVal = array();
  1658. foreach($getRoundDatawinnner as $key => $val){
  1659. $roundScore = $val['RoundScore']['Score'];
  1660. if($roundScore == 14){
  1661. $whouseVal[] = $roundScore ;
  1662. }else{
  1663. $whouseVal[] = '';
  1664. }
  1665. }
  1666.  
  1667. $WinnerFullHouse = count(array_filter($whouseVal));
  1668.  
  1669. $getRoundDatarunner = $this->RoundScore->find('all',array('conditions' => array('RoundScore.RoomId' => $RoomId,'RoundScore.Result' => 'R', 'RoundScore.TeamUsers' => $RunnerPlayers ), 'recursive' => -1));
  1670.  
  1671. $rhouseVal = array();
  1672. foreach($getRoundDatarunner as $key => $val){
  1673. $roundScore = $val['RoundScore']['Score'];
  1674. if($roundScore == 14){
  1675. $rhouseVal[] = $roundScore ;
  1676. }else{
  1677. $rhouseVal[] = '';
  1678. }
  1679. }
  1680. $RunnerFullHouse = count(array_filter($rhouseVal));
  1681.  
  1682. //Save Data For Winnner
  1683. $newplayerdata = array();
  1684. $UpdateWinArray = '';
  1685.  
  1686. foreach($WinnerArray->Users as $key => $val) {
  1687. $playerid = $val;
  1688.  
  1689. $currentdate =date('Y-m-d');
  1690. $dateexplode = explode('-',$currentdate);
  1691. $currentmonth = $dateexplode['1'];
  1692.  
  1693. $playDateData= $this->FinalScore->find("all",array( 'fields'=>array('FinalScore.Players','FinalScore.CreatedOn'),'conditions'=>array('Players LIKE'=>'%' . $playerid . '%','Date(CreatedOn)' => $currentdate)));
  1694.  
  1695. if(!empty($playDateData)) {
  1696. $noOfgaemesplayedtoday = count($playDateData);
  1697. }else{
  1698. $noOfgaemesplayedtoday = 1;
  1699. }
  1700.  
  1701. $playMonthData= $this->FinalScore->find("all",array( 'fields'=>array('FinalScore.Players','FinalScore.CreatedOn'),'conditions'=>array('Players LIKE'=>'%' . $playerid . '%','Month(CreatedOn)' => $currentmonth)));
  1702.  
  1703. if(!empty($playMonthData)) {
  1704. $noOfGameplaythismonth = count($playMonthData);
  1705. }else{
  1706. $noOfGameplaythismonth = 1;
  1707. }
  1708.  
  1709. $playWeekData= $this->FinalScore->find("all",array( 'fields'=>array('FinalScore.Players','FinalScore.CreatedOn'),'conditions'=>array('Players LIKE'=>'%' . $playerid . '%','YEARWEEK(CreatedOn)=YEARWEEK(CURDATE(), 1)')));
  1710.  
  1711. if(!empty($playWeekData)){
  1712. $noOfGameplayedthisWeek = count($playWeekData);
  1713. }else{
  1714. $noOfGameplayedthisWeek = 1;
  1715. }
  1716.  
  1717. $userGameplayData = $this->UserPlayGame->find('all',array('conditions' => array('UserPlayGame.user_id' => $playerid)));
  1718.  
  1719. if(empty($userGameplayData)){
  1720. $total_game = 1;
  1721. $user_id = $playerid;
  1722. $win_game = 1;
  1723. $lost_game = 0;
  1724. $win_percent = 100;
  1725.  
  1726.  
  1727. if($WinnerScore == 75)
  1728. $Ace = 1;
  1729. else
  1730. $Ace = 0;
  1731.  
  1732. if(count($total_rounds) == 5)
  1733. $Unstoppable = 1;
  1734. else
  1735. $Unstoppable = 0;
  1736.  
  1737. $Winner = 1;
  1738. $player = 1;
  1739. $WfullHouse = $WinnerFullHouse;
  1740. $WinStreak = 1;
  1741.  
  1742. $newplayerdata[] = array('WinStreak' => $WinStreak,'FullHouse' => $WfullHouse,'Player' => $player,'Winner' => $Winner,'Unstoppable' => $Unstoppable,'Weeklygameplay' => $noOfGameplayedthisWeek,'Monthlygameplay' => $noOfGameplaythismonth,'PerdayGameplayed' => $noOfgaemesplayedtoday,'win_percent' => $win_percent,'lost_game' => $lost_game,'win_game' => $win_game,'user_id' => $user_id,'total_game' => $total_game,'Ace' => $Ace ,'fairPlay' => 0);
  1743.  
  1744. }else{
  1745. $total_game = $userGameplayData[0]['UserPlayGame']['total_game'];
  1746. $user_id = $playerid;
  1747. $win_game = $userGameplayData[0]['UserPlayGame']['win_game'];
  1748. $lost_game = $userGameplayData[0]['UserPlayGame']['lost_game'];
  1749. $oldAce = $userGameplayData[0]['UserPlayGame']['Ace'];
  1750. if($WinnerScore == 75){
  1751. $newAce = $oldAce + 1;
  1752. }else{
  1753. $newAce = $oldAce ;
  1754. }
  1755.  
  1756. $oldWinnnerVal = $userGameplayData[0]['UserPlayGame']['Winner'];
  1757. $newWinnerVal = $oldWinnnerVal + 1;
  1758.  
  1759. $oldPalyerVal = $userGameplayData[0]['UserPlayGame']['Player'];
  1760. $newPlayerval = $oldPalyerVal + 1;
  1761.  
  1762. $oldUnstoppable = $userGameplayData[0]['UserPlayGame']['Unstoppable'];
  1763.  
  1764. if(count($total_rounds) == 5){
  1765. $Unstoppable = $oldUnstoppable + 1;
  1766. }else{
  1767. $Unstoppable = $oldUnstoppable;
  1768. }
  1769.  
  1770. $oldwinfullhouse = $userGameplayData[0]['UserPlayGame']['FullHouse'];
  1771. $WfullHouse = $WinnerFullHouse + $oldwinfullhouse;
  1772.  
  1773. $oldWinstreak = $userGameplayData[0]['UserPlayGame']['WinStreak'];
  1774. $newWinstreak = $oldWinstreak + 1;
  1775.  
  1776. $divisiblebyten = 0;
  1777. $divisiblebyfive = 0;
  1778. $divisiblebythree = 0;
  1779. if($newWinstreak % 10 == 0) {
  1780. $divisiblebyten = 1 ;
  1781. }
  1782.  
  1783. if ($newWinstreak % 5 == 0) {
  1784. $divisiblebyfive = 1 ;
  1785. }
  1786.  
  1787. if ($newWinstreak % 3 == 0) {
  1788. $divisiblebythree = 1 ;
  1789. }
  1790.  
  1791. $oldXtenWinstreak = $userGameplayData[0]['UserPlayGame']['XtenWinstreak'];
  1792. $oldXfiveWinstreak = $userGameplayData[0]['UserPlayGame']['XfiveWinstreak'];
  1793. $oldXthreeWinStreak = $userGameplayData[0]['UserPlayGame']['XthreeWinStreak'];
  1794.  
  1795. if($divisiblebyten == 1){
  1796. $newXtenWinstreak = $oldXtenWinstreak + 1;
  1797. }else{
  1798. $newXtenWinstreak = $oldXtenWinstreak ;
  1799. }
  1800.  
  1801. if($divisiblebyfive == 1){
  1802. $newXfiveWinstreak = $oldXfiveWinstreak + 1;
  1803. }else{
  1804. $newXfiveWinstreak = $oldXfiveWinstreak;
  1805. }
  1806. if($divisiblebythree == 1){
  1807. $newXthreeWinStreak = $oldXthreeWinStreak + 1;
  1808. }else{
  1809. $newXthreeWinStreak = $oldXthreeWinStreak ;
  1810. }
  1811.  
  1812.  
  1813. $newtotal_game = $total_game + 1;
  1814. $newin_game = $win_game + 1;
  1815. $newwinpercentage = ($newin_game/$newtotal_game) * 100 ;
  1816. $newpercentage = round($newwinpercentage);
  1817. $created_date = strtotime(date('Y-m-d H:i:s'));
  1818.  
  1819. $oldfairplay = $userGameplayData[0]['UserPlayGame']['fairPlay'];
  1820. if($oldfairplay>0)
  1821. $newfirplay = $oldfairplay-1;
  1822. else
  1823. $newfirplay=0;
  1824.  
  1825. $UpdateWinArray .= $this->UserPlayGame->updateAll(array('UserPlayGame.XtenWinstreak' => $newXtenWinstreak,'UserPlayGame.XfiveWinstreak' => $newXfiveWinstreak,'UserPlayGame.XthreeWinStreak' => $newXthreeWinStreak,'UserPlayGame.WinStreak' => $newWinstreak,'UserPlayGame.FullHouse' => $WfullHouse,'UserPlayGame.Player' => $newPlayerval,'UserPlayGame.Winner' => $newWinnerVal,'UserPlayGame.Unstoppable' => $Unstoppable,'UserPlayGame.Weeklygameplay' => $noOfGameplayedthisWeek, 'UserPlayGame.Monthlygameplay'=> $noOfGameplaythismonth,'UserPlayGame.PerdayGameplayed' => $noOfgaemesplayedtoday,'UserPlayGame.win_percent' => $newpercentage,'UserPlayGame.win_game' => $newin_game,'UserPlayGame.total_game' => $newtotal_game, 'UserPlayGame.Ace'=> $newAce, 'UserPlayGame.fairPlay' => $newfirplay ),array('UserPlayGame.user_id'=> $user_id));
  1826.  
  1827. }
  1828. }
  1829. $this->UserPlayGame->saveAll($newplayerdata);
  1830.  
  1831.  
  1832. //Save Data For Runner
  1833. $newRunnerplayerdata = array();
  1834. $UpdateRunnerArray = '';
  1835. foreach($RunnerArray->Users as $rkey => $rval) {
  1836. $playerid = $rval;
  1837.  
  1838. //if user is other than old user of roomslot then looser data will not be saved
  1839. $checknewjoinee = $this->RoomSlot->find('first',array('conditions' => array('RoomSlot.RoomId' => $RoomId,'RoomSlot.UserId' => $playerid ),'recursive' => -1));
  1840. if(!empty($checknewjoinee)){
  1841. $olduser = $checknewjoinee['RoomSlot']['OldSlotUser'];
  1842. }else{
  1843. $olduser = 0;
  1844. }
  1845.  
  1846. if($olduser == 0){
  1847.  
  1848. $currentdate =date('Y-m-d');
  1849. $dateexplode = explode('-',$currentdate);
  1850. $currentmonth = $dateexplode['1'];
  1851.  
  1852.  
  1853. $playDateData= $this->FinalScore->find("all",array( 'fields'=>array('FinalScore.Players','FinalScore.CreatedOn'),'conditions'=>array('Players LIKE'=>'%' . $playerid . '%','Date(CreatedOn)' => $currentdate)));
  1854.  
  1855. if(!empty($playDateData)) {
  1856. $noOfgaemesplayedtoday = count($playDateData);
  1857. }else{
  1858. $noOfgaemesplayedtoday = 1;
  1859. }
  1860.  
  1861. $playMonthData= $this->FinalScore->find("all",array( 'fields'=>array('FinalScore.Players','FinalScore.CreatedOn'),'conditions'=>array('Players LIKE'=>'%' . $playerid . '%','Month(CreatedOn)' => $currentmonth)));
  1862.  
  1863. if(!empty($playMonthData)) {
  1864. $noOfGameplaythismonth = count($playMonthData);
  1865. }else{
  1866. $noOfGameplaythismonth = 1;
  1867. }
  1868.  
  1869. $playWeekData= $this->FinalScore->find("all",array( 'fields'=>array('FinalScore.Players','FinalScore.CreatedOn'),'conditions'=>array('Players LIKE'=>'%' . $playerid . '%','YEARWEEK(CreatedOn)=YEARWEEK(CURDATE(), 1)')));
  1870.  
  1871. if(!empty($playWeekData)){
  1872. $noOfGameplayedthisWeek = count($playWeekData);
  1873. }else{
  1874. $noOfGameplayedthisWeek = 1;
  1875. }
  1876.  
  1877. $userGameplayData = $this->UserPlayGame->find('all',array('conditions' => array('UserPlayGame.user_id' => $playerid)));
  1878. if(empty($userGameplayData)){
  1879. $total_game = 1;
  1880. $user_id = $playerid;
  1881. $win_game = 0;
  1882. $lost_game = 1;
  1883. $win_percent = 0;
  1884.  
  1885.  
  1886.  
  1887. $player = 1;
  1888. if($RunnerScore < 0){
  1889. $Looser = 1;
  1890. }else{
  1891. $Looser = 0;
  1892. }
  1893.  
  1894. $RfullHouse = $RunnerFullHouse;
  1895. $Winstreak = 0 ;
  1896. $newRunnerplayerdata[] = array('WinStreak' => $Winstreak,'FullHouse' => $RfullHouse,'Looser' => $Looser,'Player' => $player,'Weeklygameplay' => $noOfGameplayedthisWeek,'Monthlygameplay' => $noOfGameplaythismonth,'PerdayGameplayed' => $noOfgaemesplayedtoday,'win_percent' => $win_percent,'lost_game' => $lost_game,'win_game' => $win_game,'user_id' => $user_id,'total_game' => $total_game, 'fairPlay' => 0);
  1897.  
  1898. }else{
  1899. $total_game = $userGameplayData[0]['UserPlayGame']['total_game'];
  1900. $user_id = $playerid;
  1901. $win_game = $userGameplayData[0]['UserPlayGame']['win_game'];
  1902. $lost_game = $userGameplayData[0]['UserPlayGame']['lost_game'];
  1903. $oldunstoppable = $userGameplayData[0]['UserPlayGame']['Unstoppable'];
  1904.  
  1905.  
  1906. $oldPalyerVal = $userGameplayData[0]['UserPlayGame']['Player'];
  1907. $newPlayerval = $oldPalyerVal + 1;
  1908.  
  1909. if($RunnerScore < 0){
  1910. $oldLooserVal = $userGameplayData[0]['UserPlayGame']['Looser'];
  1911. $newLooserVal = $oldLooserVal + 1;
  1912. }else{
  1913. $oldLooserVal = $userGameplayData[0]['UserPlayGame']['Looser'];
  1914. $newLooserVal = $oldLooserVal;
  1915. }
  1916.  
  1917. $oldLooserfullhouse = $userGameplayData[0]['UserPlayGame']['FullHouse'];
  1918. $RfullHouse = $RunnerFullHouse + $oldLooserfullhouse;
  1919. $Winstreak = 0 ;
  1920.  
  1921. $newtotal_game = $total_game + 1;
  1922. $newin_game = $win_game;
  1923. $newlost_game = $lost_game + 1;
  1924. $newwinpercentage = ($newin_game/$newtotal_game) * 100 ;
  1925. $newpercentage = round($newwinpercentage);
  1926. $created_date = strtotime(date('Y-m-d H:i:s'));
  1927.  
  1928. $oldfairplay = $userGameplayData[0]['UserPlayGame']['fairPlay'];
  1929. if($oldfairplay>0)
  1930. $newfirplay = $oldfairplay-1;
  1931. else
  1932. $newfirplay=0;
  1933.  
  1934. $UpdateRunnerArray .= $this->UserPlayGame->updateAll(array('UserPlayGame.WinStreak' =>$Winstreak,'UserPlayGame.FullHouse' => $RfullHouse,'UserPlayGame.Looser' => $newLooserVal,'UserPlayGame.Player' => $newPlayerval,'UserPlayGame.Weeklygameplay' => $noOfGameplayedthisWeek,'UserPlayGame.Monthlygameplay' => $noOfGameplaythismonth,'UserPlayGame.PerdayGameplayed' => $noOfgaemesplayedtoday,'UserPlayGame.win_percent' => $newpercentage,'UserPlayGame.lost_game' => $newlost_game,'UserPlayGame.total_game' => $newtotal_game, 'UserPlayGame.fairPlay' => $newfirplay ),array('UserPlayGame.user_id'=> $user_id));
  1935.  
  1936. }
  1937. }else{
  1938. $newRunnerplayerdata = array();
  1939.  
  1940. }
  1941. }
  1942. $this->UserPlayGame->saveAll($newRunnerplayerdata);
  1943.  
  1944.  
  1945. $GameFinalData = array($WinnerData,$RunnerData);
  1946. $saveData = $this->FinalScore->saveAll($GameFinalData);
  1947.  
  1948. //***************update room status*****************//
  1949. $updateRoomStatus = $this->Room->updateAll(array('Room.room_status' => 2, 'Room.join_member_count' => 4),array('Room.id' => $RoomId));
  1950.  
  1951. //update below line on 10/6/2016 RoomSlot.play_status means game is played and score is submitted
  1952. $updateSlotplaystatus = $this->RoomSlot->updateAll(array('RoomSlot.play_status' => 1),array('RoomSlot.RoomId' => $RoomId));
  1953.  
  1954. $this->set(array('Response' => array('Error' => false, 'Message' => "Success"), '_serialize' => array('Response')));
  1955. }
  1956.  
  1957. }
  1958.  
  1959. }else{
  1960. $erroMsg = "RoomData parameter is empty";
  1961. $message = array('Error'=>true,'Message'=>$erroMsg);
  1962. $this->set(array('Response' => $message,'_serialize' => array('Response')));
  1963. }
  1964. }
  1965.  
  1966. public function resetGamePlay($userId,$roomId,$fairPlayStatus) {
  1967.  
  1968. $userplaydata = $this->UserPlayGame->find('first', array('conditions' => array('UserPlayGame.user_id' => $userId)));
  1969. $check_replacement = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.RoomId' => $roomId,'RoomSlot.UserId'=>$userId,'RoomSlot.OldSlotUser'=>0)) );
  1970.  
  1971. $roomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $roomId),'recursive' => -1));
  1972. $roomstatus = $roomdata['Room']['room_status'];
  1973. $ongoingstatus = $roomdata['Room']['OngoingStatus'];
  1974.  
  1975. if(!empty($userplaydata)){
  1976.  
  1977. $totalGame = $userplaydata['UserPlayGame']['total_game'];
  1978. $winGame = $userplaydata['UserPlayGame']['win_game'];
  1979. $lostGame = $userplaydata['UserPlayGame']['lost_game'];
  1980. $winpercent = $userplaydata['UserPlayGame']['win_percent'];
  1981. $perdayGameplayed = $userplaydata['UserPlayGame']['PerdayGameplayed'];
  1982. $Monthlygameplay = $userplaydata['UserPlayGame']['Monthlygameplay'];
  1983. $Weeklygameplay = $userplaydata['UserPlayGame']['Weeklygameplay'];
  1984. $fairPlay = $userplaydata['UserPlayGame']['fairPlay'];
  1985. $unixtime = $userplaydata['UserPlayGame']['created_date'];
  1986. $currentdate =date('Y-m-d');
  1987. $dateexplode = explode('-',$currentdate);
  1988. $currentmonth = $dateexplode['1'];
  1989.  
  1990. $newtotal_game = $totalGame + 1;
  1991. $newloss_game = $lostGame + 1;
  1992. $newwinpercentage = ($winGame/$newtotal_game) * 100 ;
  1993. $newpercentage = round($newwinpercentage);
  1994. $created_date = strtotime(date('Y-m-d H:i:s'));
  1995.  
  1996. if($fairPlayStatus == 1 && $fairPlay < 10){
  1997. $newFailplayval = $fairPlay + 1;
  1998. }else
  1999. $newFailplayval = $fairPlay;
  2000.  
  2001. if((!empty($check_replacement)) && $ongoingstatus==1 && $roomstatus!=2 && $fairPlayStatus==1){
  2002. $UpdateWinArray = $this->UserPlayGame->updateAll(array('UserPlayGame.win_percent' => $newpercentage,'UserPlayGame.lost_game' => $newloss_game,'UserPlayGame.total_game' => $newtotal_game,'UserPlayGame.fairPlay' => $newFailplayval ),array('UserPlayGame.user_id'=> $userId));
  2003. }
  2004.  
  2005. } else{
  2006.  
  2007. if((!empty($check_replacement)) && $ongoingstatus==1 && $roomstatus!=2 && $fairPlayStatus==1){
  2008. $newUserdata = array('user_id' => $userId, 'fairPlay' => 1,'lost_game'=>1,'total_game'=>1);
  2009. $this->UserPlayGame->saveAll($newUserdata);
  2010. }else{
  2011. $newUserdata = array('user_id' => $userId, 'fairPlay' => 0);
  2012. $this->UserPlayGame->saveAll($newUserdata);
  2013. }
  2014. }
  2015. }
  2016.  
  2017.  
  2018. public function leaveGame() {
  2019. $error = array();
  2020. if(empty($this->request->query['RoomId'])){
  2021. $error[] = "RoomId parameter is empty" ;
  2022. }
  2023. if(empty($this->request->query['UserId'])){
  2024. $error[] = "UserId parameter is empty" ;
  2025. }
  2026. if($this->request->query['FairPlayStatus']== ''){
  2027. $error[] = "FairPlayStatus parameter is empty" ;
  2028. }
  2029. if(!empty($error)){
  2030. $errorMsg = implode(',',$error);
  2031. $response = array('Error' => True, 'Message' => $errorMsg);
  2032. $this->set(array('Response' => $response, '_serialize' => array('Response')));
  2033. }else{
  2034.  
  2035. $userId = $this->request->query['UserId'];
  2036. $roomId = $this->request->query['RoomId'];
  2037.  
  2038. //if user exists in any rematch update it as rejected>>>>>Start
  2039.  
  2040. $getrematchdata = $this->RequestRematch->find('first', array('conditions' => array('RequestRematch.user_id' => $userId,'RequestRematch.room_id' => $roomId), 'recursive' => -1));
  2041. if(!empty($getrematchdata)){
  2042. $this->RequestRematch->updateAll(array('RequestRematch.status' => 2),array('RequestRematch.user_id' =>$userId,'RequestRematch.room_id' => $roomId));
  2043. }
  2044.  
  2045. //if user exists in any rematch update it as rejected>>>>>end
  2046.  
  2047. $fairPlayStatus = $this->request->query['FairPlayStatus'];
  2048. //check if RoomSlot exists
  2049. $roomslotexists = $this->RoomSlot->find('all', array('conditions' => array('RoomSlot.RoomId' => $roomId)) );
  2050.  
  2051. $this->resetGamePlay($userId,$roomId,$fairPlayStatus);
  2052.  
  2053. if(empty($roomslotexists)) {
  2054.  
  2055. $this->set(array('Response' => array('Error' => false , 'Message' => 'No Roomslot exists for this Room' ), '_serialize' => array('Response')));
  2056. }else{
  2057.  
  2058. //check if user is host
  2059.  
  2060. $checkUser = $this->Room->find('all',array('conditions' => array('UserId' => $userId ,'id' => $roomId)));
  2061. $thisroomsdata = $this->Room->find('first' , array('conditions' => array('id' => $roomId), 'recursive' => -1));
  2062. $roomjoinnumbers = $thisroomsdata['Room']['join_member_count'];
  2063.  
  2064. if(empty($checkUser)){
  2065. //Given UserId is not host of the room So we have to remove the other user from slot
  2066.  
  2067. $checkleavingUser = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.UserId' => $userId, 'RoomSlot.RoomId' => $roomId)));
  2068.  
  2069. if(!empty($checkleavingUser)){
  2070.  
  2071. if($checkleavingUser['RoomSlot']['slot_type'] == 'public'){
  2072. $this->RoomSlot->updateAll(array('RoomSlot.UserId' =>null,'RoomSlot.slot_type'=>"'public'",'RoomSlot.SlotStatus' => "0",'RoomSlot.OldSlotUser' => $userId),array('RoomSlot.UserId' => $userId ,'RoomSlot.RoomId' => $roomId ));
  2073. }else{
  2074. $this->RoomSlot->updateAll(array('RoomSlot.UserId' =>null,'RoomSlot.slot_type'=>"'public'",'RoomSlot.SlotStatus' => "0",'RoomSlot.OldSlotUser' => $userId,'RoomSlot.SlotKey' => 0),array('RoomSlot.UserId' => $userId ,'RoomSlot.RoomId' => $roomId ));
  2075. }
  2076. $newjoinmembercount = $roomjoinnumbers - 1;
  2077.  
  2078. $roomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $roomId),'recursive' => -1));
  2079. $roomstatus = $roomdata['Room']['room_status'];
  2080.  
  2081.  
  2082. if($roomstatus != 2){
  2083. $autoterminateTime = date('Y-m-d H:i:s');
  2084. if($roomjoinnumbers==4)
  2085. $this->Room->updateAll(array('Room.auto_terminate_update' => '"'.$autoterminateTime.'"'), array('Room.id' => $roomId));
  2086.  
  2087. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount,'Room.room_status'=>0), array('Room.id' => $roomId));
  2088.  
  2089. }else{
  2090.  
  2091. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount), array('Room.id' => $roomId));
  2092. }
  2093.  
  2094.  
  2095.  
  2096. $userplaydata = $this->UserPlayGame->find('first',array('conditions' => array('UserPlayGame.user_id'=> $userId),'fields' => array('fairPlay')));
  2097.  
  2098. if(!empty($userplaydata)){
  2099. $oldFairplayval = $userplaydata['UserPlayGame']['fairPlay'];
  2100. if($fairPlayStatus == 1 && $oldFairplayval < 10){
  2101. $newFailplayval = $oldFairplayval + 1;
  2102. }else{
  2103. $newFailplayval = $oldFairplayval;
  2104. }
  2105.  
  2106. $this->UserPlayGame->updateAll(array('UserPlayGame.fairPlay' => $newFailplayval),array('UserPlayGame.user_id'=> $userId));
  2107. }else{
  2108. //new user to be added here
  2109.  
  2110. $newUesrData = array('user_id' => $userId, 'fairPlay' => 1);
  2111. $this->UserPlayGame->saveAll($newUesrData );
  2112. }
  2113.  
  2114. //to check if all the slots are empty in that case we have to delete the room and its slots
  2115. // get all slots
  2116. $getallRoomSlotdata = $this->RoomSlot->find('all', array('conditions' => array('RoomSlot.RoomId' =>$roomId, 'RoomSlot.SlotStatus' => 1),'order' =>array('RoomSlot.created_date ASC'),'recursive'=>-1));
  2117.  
  2118. if(empty($getallRoomSlotdata)) {
  2119. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  2120. $this->Room->deleteAll(array('Room.id' => $roomId));
  2121. }
  2122.  
  2123. //$this->Room->find('first', array('conditions' => array('Room')));
  2124. $this->set(array('Response'=>array('Error' => false, 'Message' => "Success"), '_serialize' => array('Response')));
  2125. }else{
  2126.  
  2127. $this->set(array('Response' => array('Error' => false , 'Message' => 'This RoomSlot Does Not Match our records'), '_serialize' => array('Response') ));
  2128. }
  2129. }else{
  2130. $this->RoomSlot->updateAll(array("RoomSlot.UserId" => null,"RoomSlot.SlotStatus" => "0","RoomSlot.slot_type"=>"'public'" ,'RoomSlot.OldSlotUser' => $userId,'RoomSlot.SlotKey' => 0),array('RoomSlot.UserId' => $userId ,'RoomSlot.RoomId' => $roomId ));
  2131. $userplaydata = $this->UserPlayGame->find('first',array('conditions' => array('UserPlayGame.user_id'=> $userId),'fields' => array('fairPlay')));
  2132.  
  2133. $newjoinmembercount = $roomjoinnumbers - 1;
  2134. $roomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $roomId),'recursive' => -1));
  2135. $roomstatus = $roomdata['Room']['room_status'];
  2136.  
  2137. if($roomstatus != 2){
  2138.  
  2139. $autoterminateTime = date('Y-m-d H:i:s');
  2140. if($roomjoinnumbers==4)
  2141. $this->Room->updateAll(array('Room.auto_terminate_update' => '"'.$autoterminateTime.'"'), array('Room.id' => $roomId));
  2142.  
  2143. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount,'Room.room_status'=>0), array('Room.id' => $roomId));
  2144.  
  2145. }else{
  2146. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount), array('Room.id' => $roomId));
  2147. }
  2148.  
  2149.  
  2150.  
  2151. if(!empty($userplaydata)){
  2152. $oldFairplayval = $userplaydata['UserPlayGame']['fairPlay'];
  2153.  
  2154. if($fairPlayStatus == 1 && $oldFairplayval < 10){
  2155. $newFailplayval = $oldFairplayval + 1;
  2156. }else{
  2157. $newFailplayval = $oldFairplayval;
  2158. }
  2159.  
  2160.  
  2161. $this->UserPlayGame->updateAll(array('UserPlayGame.fairPlay' => $newFailplayval),array('UserPlayGame.user_id'=> $userId));
  2162. }else{
  2163.  
  2164.  
  2165. $newUesrData = array('user_id' => $userId, 'fairPlay' => 0);
  2166. $this->UserPlayGame->saveAll($newUesrData );
  2167.  
  2168. }
  2169. $getRoomSlotdata = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.RoomId' =>$roomId,'RoomSlot.SlotStatus' => 1 ),'order' =>array('RoomSlot.created_date ASC'),'recursive' => -1));
  2170.  
  2171. if(!empty($getRoomSlotdata)){
  2172. $newHostid = $getRoomSlotdata['RoomSlot']['UserId'];
  2173. $username = $this->User->find('first' , array('conditions' => array('User.id' => $newHostid), 'fields' => array('username'), 'recursive' => -1));
  2174. $roomusername = $username['User']['username'];
  2175.  
  2176. $this->Room->updateAll(array('Room.UserId' => $newHostid,"Room.name" => '"'.$roomusername.'"', 'Room.HostName' => '"'.$roomusername.'"'),array('Room.id' => $roomId));
  2177. }
  2178.  
  2179. //to check if all the slots are empty in that case we have to delete the room and its slots
  2180. // get all slots
  2181. $getallRoomSlotdata = $this->RoomSlot->find('all', array('conditions' => array('RoomSlot.RoomId' =>$roomId, 'RoomSlot.SlotStatus' => 1),'order' =>array('RoomSlot.created_date ASC'),'recursive'=>-1));
  2182.  
  2183. if(empty($getallRoomSlotdata)) {
  2184. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  2185. $this->Room->deleteAll(array('Room.id' => $roomId));
  2186. }
  2187.  
  2188. $this->set(array('Response' => array('Error' => false , 'Message' => 'The host left the room'), '_serialize' => array('Response')));
  2189. }
  2190. }
  2191. }
  2192. }
  2193.  
  2194.  
  2195. public function saveChatHistory() {
  2196. $error = array();
  2197.  
  2198. if(empty($_POST['RoomId'])){
  2199. $error[] = "RoomId parameter is empty";
  2200. }
  2201.  
  2202. if(empty($_POST['UserId'])){
  2203. $error[] = "UserId parameter is empty";
  2204. }
  2205.  
  2206. if(empty($_POST['Message']) && $_POST['Message']!=0){
  2207. $error[] = "Message parameter is empty";
  2208. }
  2209.  
  2210. if(empty($_POST['Type'])){
  2211. $error[] = "Type parameter is empty";
  2212. }
  2213.  
  2214. if(!empty($error)){
  2215. $errorMsg = implode(',',$error);
  2216. $response = array('Error' => True, 'Message' => $errorMsg);
  2217. $this->set(array('Response' => $response, '_serialize' => array('Response')));
  2218.  
  2219. }else{
  2220.  
  2221. $roomId = $_POST['RoomId'];
  2222. $userId = $_POST['UserId'];
  2223. $Message = $_POST['Message'];
  2224. $Type = $_POST['Type'];
  2225.  
  2226. if($Type == 'E') {
  2227. if(empty($Message)){
  2228. $Emoerror = "EmojiId parameter is empty";
  2229. $this->set(array('Response' => $Emoerror,'_serialize' => array('Response')));
  2230. }else{
  2231. $Message = $Message;
  2232. $data = array('UserId' => $userId, 'RoomId' => $roomId, 'ChatMessage' => $Message , 'Type' => 'E');
  2233. $this->ChatInfo->save($data);
  2234.  
  2235. // chatid in response
  2236. $chatid = $this->ChatInfo->getLastInsertId();
  2237. $this->set(array('Response' => array('Error' => false, 'ChatId' => $chatid, 'Message' => 'Success'),'_serialize' => array('Response')));
  2238. }
  2239.  
  2240. }else{
  2241. $data = array('UserId' => $userId, 'RoomId' => $roomId, 'ChatMessage' => $Message , 'Type' => 'C');
  2242. $this->ChatInfo->save($data);
  2243. $chatid = $this->ChatInfo->getLastInsertId();
  2244. $this->set(array('Response' => array('Error' => false,'ChatId' => $chatid, 'Message' => 'Success'),'_serialize' => array('Response')));
  2245. }
  2246. }
  2247.  
  2248. }
  2249.  
  2250. /***
  2251. Accept status 0: for declined, 1 for Accept
  2252. send null instead of 0
  2253. */
  2254.  
  2255. public function InviteResponse() {
  2256. $error = array();
  2257. if(empty($this->request->query['RoomId'])){
  2258. $error[] = "RoomId parameter is empty." ;
  2259. }
  2260. if(empty($this->request->query['SlotId'])){
  2261. $error[] = "SlotId parameter is empty.";
  2262. }
  2263. if($this->request->query['Status'] == ""){
  2264. $error[] = "Status parameter is empty";
  2265. }
  2266. if(empty($this->request->query['UserId'])){
  2267. $error[] = "UserId parameter is empty.";
  2268. }
  2269.  
  2270. if(!empty($error)) {
  2271. $errMessage = implode(',',$error);
  2272. $Message = array('Error'=>true, 'Message' => $errMessage);
  2273. $this->set(array('Response' => $Message ,'_serialize' => array('Response')));
  2274. }else{
  2275.  
  2276. $roomid = $this->request->query['RoomId'];
  2277. $slotid = $this->request->query['SlotId'];
  2278. $status = $this->request->query['Status'];
  2279. $UserId = trim($this->request->query['UserId']) ;
  2280. if($status == 1){
  2281. //check if room exists in case it has not been updated or deleted already.
  2282. $Roomdata = $this->Room->find('first',array('conditions'=>array('Room.id' => $roomid),'recursive'=>-1));
  2283.  
  2284. if(!empty($Roomdata)){
  2285.  
  2286. $joinmembers = $Roomdata['Room']['join_member_count'];
  2287. //check if roomslot exists
  2288. if($joinmembers < 4) {
  2289. $slotexists = $this->RoomSlot->find('all', array('conditons' => array('RomSlot.RoomId' => $roomid, 'RoomSlot.SlotId' => $slotid), 'recursive' => -1));
  2290. if(!empty($slotexists)) {
  2291. $slotcheck = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.SlotStatus' =>1,'RoomSlot.RoomId' => $roomid, 'RoomSlot.SlotId'=> $slotid),'recursive' => -1));
  2292. if(empty($slotcheck)){
  2293.  
  2294. $chkUser= $this->RoomSlot->find('first' , array('conditions' => array('RoomSlot.UserId' =>$UserId,'RoomSlot.RoomId' => $roomid,'RoomSlot.SlotStatus' =>1)));
  2295. if(empty($chkUser)){
  2296.  
  2297.  
  2298. $chkUserInRooms = $this->RoomSlot->find('first' , array('conditions' => array('RoomSlot.UserId' =>$UserId,'RoomSlot.SlotStatus' =>1)));
  2299. if(empty($chkUserInRooms)){
  2300. $this->RoomSlot->updateAll(array('RoomSlot.SlotStatus' => 1,'RoomSlot.UserId'=>$UserId),array('RoomSlot.RoomId'=>$roomid,'RoomSlot.SlotId'=>$slotid));
  2301. $joinmenbercount = $joinmembers + 1 ;
  2302. $this->Room->updateAll(array('Room.join_member_count' => $joinmenbercount ), array('Room.id' => $roomid));
  2303.  
  2304. $this->set(array('Response' => array('Error' => false , 'Message' => 'Success'), '_serialize' => array('Response')));
  2305. }else{
  2306. $this->set(array('Response' => array('Error' => true , 'Message' => 'This user is already assigned to other room'), '_serialize' => array('Response')));
  2307. }
  2308. }else{
  2309. $this->set(array('Response' => array('Error' => true , 'Message' => 'This user is already assigned'), '_serialize' => array('Response')));
  2310.  
  2311. }
  2312. }else{
  2313. $this->set(array('Response' => array('Error' => true , 'Message' => 'This slot is already assigned'), '_serialize' => array('Response')));
  2314. }
  2315.  
  2316. }else{
  2317. $this->set(array('Response' => array('Error' => true , 'Message' => 'RoomSlot does not exists'),'_serialize'=> array('Response'))) ;
  2318. }
  2319. }else{
  2320.  
  2321. $this->set(array('Response' => array('Error' => true , 'Message' => 'All slots are already filled'), '_serialize' => array('Response'))) ;
  2322. }
  2323. }
  2324. else{
  2325.  
  2326. $this->set(array('Response' => array('Error' => true, 'Message' => 'Room Does not exist.'), '_serialize'=> array('Response')));
  2327. }
  2328.  
  2329. }else{
  2330.  
  2331. $Roomdata = $this->Room->find('first',array('conditions'=>array('Room.id' => $roomid),'recursive'=>-1));
  2332. if(!empty($Roomdata)){
  2333.  
  2334. $slotexists = $this->RoomSlot->find('all', array('conditons' => array('RomSlot.RoomId' => $roomid, 'RoomSlot.SlotId' => $slotid), 'recursive' => -1));
  2335. if(!empty($slotexists)) {
  2336. $public = 'public';
  2337.  
  2338. $slotstatus = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.RoomId'=>$roomid,'RoomSlot.SlotId'=>$slotid,'RoomSlot.SlotStatus' => 1)));
  2339. if(empty($slotstatus)){
  2340. $this->RoomSlot->updateAll(array("RoomSlot.slot_type" =>'"'.$public.'"',"RoomSlot.UserId"=>'0',"RoomSlot.SlotKey" => 0),array('RoomSlot.RoomId'=>$roomid,'RoomSlot.SlotId'=>$slotid));
  2341. $this->set(array('Response' => array('Error' => false , 'Message' => 'RoomSlot Updated Success'),'_serialize'=> array('Response'))) ;
  2342. }else{
  2343. $this->set(array('Response' => array('Error' => true , 'Message' => 'RoomSlot is not available'),'_serialize'=> array('Response'))) ;
  2344. }
  2345. }else{
  2346. $this->set(array('Response' => array('Error' => true , 'Message' => 'RoomSlot does not exists'),'_serialize'=> array('Response'))) ;
  2347. }
  2348.  
  2349. }else{
  2350. $this->set(array('Response' => array('Error' => true, 'Message' => 'Room Does not exist.'), '_serialize'=> array('Response')));
  2351. }
  2352. }
  2353. }
  2354. }
  2355.  
  2356.  
  2357.  
  2358. public function removidleuser($userId){
  2359.  
  2360. $getuSlotData = $this->RoomSlot->find('first',array('conditions'=>array('RoomSlot.UserId'=>$userId,'RoomSlot.SlotStatus'=>1),'fields'=>array('RoomSlot.RoomId','RoomSlot.UserId','RoomSlot.SlotStatus','RoomSlot.SlotId'),'recursive'=>-1));
  2361.  
  2362. if(!empty($getuSlotData)){
  2363.  
  2364. $roomId = $getuSlotData['RoomSlot']['RoomId'];
  2365.  
  2366. //remove user from rematch
  2367. $getrematchdata = $this->RequestRematch->find('first', array('conditions' => array('RequestRematch.user_id' => $userId,'RequestRematch.room_id' => $roomId), 'recursive' => -1));
  2368. if(!empty($getrematchdata)){
  2369.  
  2370. $this->RequestRematch->updateAll(array('RequestRematch.status' => 2),array('RequestRematch.user_id' =>$userId,'RequestRematch.room_id' => $uroomid));
  2371. //removed user from rematch
  2372. }
  2373.  
  2374. $checkUser = $this->Room->find('all',array('conditions' => array('UserId' => $userId ,'id' => $roomId)));
  2375. $thisroomsdata = $this->Room->find('first' , array('conditions' => array('id' => $roomId), 'recursive' => -1));
  2376. $roomjoinnumbers = $thisroomsdata['Room']['join_member_count'];
  2377.  
  2378. if(empty($checkUser)){
  2379. //Given UserId is not host of the room So we have to remove the other user from slot
  2380.  
  2381. $checkleavingUser = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.UserId' => $userId, 'RoomSlot.RoomId' => $roomId)));
  2382.  
  2383. if(!empty($checkleavingUser)){
  2384.  
  2385. $this->RoomSlot->updateAll(array('RoomSlot.UserId' =>null,'RoomSlot.slot_type'=>"'public'",'RoomSlot.SlotStatus' => "0",'RoomSlot.OldSlotUser' => $userId,'RoomSlot.SlotKey' => 0),array('RoomSlot.UserId' => $userId ,'RoomSlot.RoomId' => $roomId ));
  2386.  
  2387. $newjoinmembercount = $roomjoinnumbers - 1;
  2388. $roomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $roomId),'recursive' => -1));
  2389. $roomstatus = $roomdata['Room']['room_status'];
  2390.  
  2391. if($roomstatus != 2){
  2392. $autoterminateTime = date('Y-m-d H:i:s');
  2393. $this->Room->updateAll(array('Room.auto_terminate_update' => '"'.$autoterminateTime.'"'), array('Room.id' => $roomId,'Room.join_member_count'=>4));
  2394.  
  2395. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount,'Room.room_status'=>0), array('Room.id' => $roomId));
  2396. }else{
  2397. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount), array('Room.id' => $roomId));
  2398. }
  2399.  
  2400. $getallRoomSlotdata = $this->RoomSlot->find('all', array('conditions' => array('RoomSlot.RoomId' =>$roomId, 'RoomSlot.SlotStatus' => 1),'order' =>array('RoomSlot.created_date ASC'),'recursive'=>-1));
  2401.  
  2402. if(empty($getallRoomSlotdata)) {
  2403. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  2404. $this->Room->deleteAll(array('Room.id' => $roomId));
  2405. }
  2406.  
  2407. }
  2408.  
  2409. //get room slot count
  2410.  
  2411. }else{
  2412.  
  2413. $this->RoomSlot->updateAll(array("RoomSlot.UserId" => null,"RoomSlot.SlotStatus" => "0","RoomSlot.slot_type"=>"'public'" ,'RoomSlot.OldSlotUser' => $userId,'RoomSlot.SlotKey' => 0),array('RoomSlot.UserId' => $userId ,'RoomSlot.RoomId' => $roomId ));
  2414.  
  2415. $newjoinmembercount = $roomjoinnumbers - 1;
  2416. $roomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $roomId),'recursive' => -1));
  2417. $roomstatus = $roomdata['Room']['room_status'];
  2418.  
  2419. if($roomstatus != 2){
  2420. $autoterminateTime = date('Y-m-d H:i:s');
  2421. $this->Room->updateAll(array('Room.auto_terminate_update' => '"'.$autoterminateTime.'"'), array('Room.id' => $roomId,'Room.join_member_count'=>4));
  2422.  
  2423. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount,'Room.room_status'=>0), array('Room.id' => $roomId));
  2424. }else{
  2425. $this->Room->updateAll(array('Room.join_member_count' => $newjoinmembercount), array('Room.id' => $roomId));
  2426. }
  2427.  
  2428. $getRoomSlotdata = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.RoomId' =>$roomId,'RoomSlot.SlotStatus' => 1 ),'order' =>array('RoomSlot.created_date ASC'),'recursive' => -1));
  2429.  
  2430. if(!empty($getRoomSlotdata)){
  2431. $newHostid = $getRoomSlotdata['RoomSlot']['UserId'];
  2432. $username = $this->User->find('first' , array('conditions' => array('User.id' => $newHostid), 'fields' => array('username'), 'recursive' => -1));
  2433. $roomusername = $username['User']['username'];
  2434.  
  2435. $this->Room->updateAll(array('Room.UserId' => $newHostid,"Room.name" => '"'.$roomusername.'"', 'Room.HostName' => '"'.$roomusername.'"'),array('Room.id' => $roomId));
  2436. }
  2437.  
  2438. //to check if all the slots are empty in that case we have to delete the room and its slots
  2439. // get all slots
  2440. $getallRoomSlotdata = $this->RoomSlot->find('all', array('conditions' => array('RoomSlot.RoomId' =>$roomId, 'RoomSlot.SlotStatus' => 1),'order' =>array('RoomSlot.created_date ASC'),'recursive'=>-1));
  2441.  
  2442. if(empty($getallRoomSlotdata)) {
  2443. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  2444. $this->Room->deleteAll(array('Room.id' => $roomId));
  2445. }
  2446. }
  2447. }
  2448. }
  2449.  
  2450.  
  2451. public function getRoomSearch() {
  2452.  
  2453. $onlineusers = $this->User->find('count',array('conditions' => array('User.online_status' => 1)));
  2454. $onlinegames = $this->Room->find('count',array('conditions' => array('Room.OngoingStatus' => 1,'Room.room_status' => 1)));
  2455. if(!empty($onlineusers)){
  2456. $onlineuserslist = $onlineusers;
  2457. }else{
  2458. $onlineuserslist = 0;
  2459. }
  2460.  
  2461. if(!empty($onlinegames)){
  2462. $ongoingameslist = $onlinegames;
  2463. }else{
  2464. $ongoingameslist = 0;
  2465. }
  2466.  
  2467. $searchList = array();
  2468. if(empty($this->request->query['SearchKey'])) {
  2469. $error = array();
  2470. if(empty($this->request->query['UserId'])){
  2471. $error[] = "UserId parameter is empty.";
  2472. }
  2473.  
  2474. if(!empty($error)) {
  2475. $errMessage = implode(',',$error);
  2476. $Message = array('Error'=>true, 'Message' => $errMessage);
  2477. $this->set(array('Response' => $Message ,'_serialize' => array('Response')));
  2478. }else{
  2479.  
  2480. $useridforsearch = $this->request->query['UserId'];
  2481. $this->removidleuser($useridforsearch);
  2482.  
  2483. // $limit = 1000 ;
  2484. $searchList = $this->Room->find( 'all', array(
  2485. 'fields'=>array('Room.name','Room.id','Room.room_status','Room.OngoingStatus'),
  2486. // 'limit' => $limit,
  2487. 'conditions'=>array('Room.room_status' => 0, 'Room.join_member_count !=' => 4 ),
  2488. //'recursive' => -1
  2489. ));
  2490.  
  2491.  
  2492. if(!empty($searchList)){
  2493.  
  2494. $roomData = array();
  2495. $newRoomData = array();
  2496. foreach($searchList as $k => $v) {
  2497. $roomid = $v['Room']['id'];
  2498. $OngoingStatus = $v['Room']['OngoingStatus'];
  2499. $roomSlots = $v['RoomSlot'];
  2500.  
  2501. if(count($roomSlots) == 4) {
  2502.  
  2503. $rslottype = array();
  2504. $rslotstatus = array();
  2505. $oldslotUser = array();
  2506. $currentuser = array();
  2507. foreach($roomSlots as $rkey => $rval){
  2508. $rslottype[] = $rval['slot_type'];
  2509. $rslotstatus[] = $rval['SlotStatus'];
  2510. $oldslotUser[] = $rval['OldSlotUser'];
  2511. $currentuser[] = $rval['UserId'];
  2512. }
  2513.  
  2514. if((in_array($useridforsearch,$currentuser))) {
  2515. $slotData = '';
  2516. }else{
  2517. if((in_array('public',$rslottype)) || (in_array('private',$rslottype))) {
  2518. if(in_array(1,$rslotstatus)){
  2519.  
  2520. $slotData = array();
  2521. $filledslots = array();
  2522.  
  2523. foreach ($roomSlots as $key => $row) {
  2524. $mid[$key] = $row['SlotId'];
  2525. }
  2526. array_multisort($mid, SORT_ASC, $roomSlots);
  2527.  
  2528. foreach($roomSlots as $rk => $rv) {
  2529.  
  2530. $roomUserid = $rv['UserId'];
  2531. $slottype = $rv['slot_type'];
  2532. $slotKey = $rv['SlotKey'];
  2533. $slotId = $rv['SlotId'];
  2534. $slotStatus = $rv['SlotStatus'];
  2535.  
  2536. if($slotStatus == 1){
  2537. $filledslots[] = $rv;
  2538. }
  2539.  
  2540. $userdata = $this->User->find('first', array('conditions' => array('User.id' => $roomUserid), 'fields' => array('User.fbid','User.pic','User.PictureIndex','User.username','User.star')));
  2541. if(!empty($userdata)){
  2542.  
  2543. $userfbid = $userdata['User']['fbid'];
  2544. $uPic = $userdata['User']['pic'];
  2545. $userPic = ($userdata['User']['pic']) ? HTTP_ROOT .'app/webroot/img/members/'.$uPic: $uPic;
  2546. $picindex = $userdata['User']['PictureIndex'];
  2547. $username = $userdata['User']['username'];
  2548. $star = $userdata['User']['star'];
  2549. }else{
  2550.  
  2551. $userfbid = '';
  2552. $userPic = '';
  2553. $picindex = '';
  2554. $username = '';
  2555. $star = '';
  2556. }
  2557. $slotData[] = array('Star' => $star,'UserName' => $username,'UserId' => $roomUserid, 'Type' => $slottype, 'Key' => $slotKey, 'SlotId' => $slotId, 'SlotStatus' => $slotStatus, 'UserFbId' => $userfbid, 'Picture' => $userPic, 'UserPicIndex' => $picindex) ;
  2558. }
  2559. $slotData = $slotData ;
  2560. }else{
  2561. $slotData = '';
  2562. }
  2563. }else{
  2564. $slotData = '';
  2565. }
  2566. }
  2567.  
  2568. if(!empty($slotData)) {
  2569. $slotFilled = count($filledslots);
  2570. $newRoomData[] = array('RoomId' => $roomid, 'SlotData' => $slotData, 'SlotsFilled' => $slotFilled,'OngoingStatus' => $OngoingStatus);
  2571. }else{
  2572. $newRoomData[] = '';
  2573. $slotFilled = 0 ;
  2574. }
  2575.  
  2576. }else{
  2577. $newRoomData[] = '';
  2578. $slotFilled = 0 ;
  2579. }
  2580. }
  2581.  
  2582. $newRoomData = array_filter($newRoomData);
  2583.  
  2584. if(!empty($newRoomData)){
  2585.  
  2586. $newRoomData = array_filter($newRoomData);
  2587. $newRoomData = array_values($newRoomData);
  2588. $newRoomData = array_slice($newRoomData, 0, 10);
  2589.  
  2590. $this->set(array('Response' => array('Error' => false , 'RoomData' => $newRoomData,
  2591. 'PlayersOnline' => $onlineuserslist,'OngoingGames' => $ongoingameslist), '_serialize' => array('Response')));
  2592. }else{
  2593. $this->set(array('Response' => array('Error' => false , 'Message' => 'No results found','condition' => 'no search key', 'RoomData'=> array(),'PlayersOnline' => $onlineuserslist,'OngoingGames' => $ongoingameslist), '_serialize' => array('Response')));
  2594. }
  2595. }else{
  2596. $this->set(array('Response' => array('Error' => false , 'Message' => 'No Results found' ,'RoomData'=> array(),'PlayersOnline' => $onlineuserslist,'OngoingGames' => $ongoingameslist), '_serialize' => array('Response')));
  2597. }
  2598. }
  2599. }else{
  2600. $error = array();
  2601. if(empty($this->request->query['UserId'])){
  2602. $error[] = "UserId parameter is empty.";
  2603. }
  2604.  
  2605. if(!empty($error)) {
  2606. $errMessage = implode(',',$error);
  2607. $Message = array('Error'=>true, 'Message' => $errMessage);
  2608. $this->set(array('Response' => $Message ,'_serialize' => array('Response')));
  2609. }else{
  2610. $useridforsearch = $this->request->query['UserId'];
  2611. $searchname = $this->request->query['SearchKey'];
  2612. // $limit = 1000;
  2613. $searchList = $this->Room->find('all', array(
  2614. 'fields' => array('Room.name','Room.id','Room.room_status','Room.OngoingStatus'),
  2615. // 'limit' => $limit,
  2616. 'conditions'=>array('name LIKE'=>'%' . $searchname . '%','room_status' => 0,'Room.join_member_count !=' => 4)
  2617. //'recursive' => -1
  2618. ));
  2619.  
  2620. if(!empty($searchList)){
  2621. $roomData = array();
  2622. $newRoomData = array();
  2623. foreach($searchList as $k => $v) {
  2624.  
  2625. $roomid = $v['Room']['id'];
  2626. $OngoingStatus = $v['Room']['OngoingStatus'];
  2627. //$roomData['RoomId'] = $roomid ;
  2628.  
  2629. $roomSlots = $v['RoomSlot'];
  2630. if(count($roomSlots) == 4) {
  2631. $rslottype = array();
  2632. $rslotstatus = array();
  2633. $oldslotUser = array();
  2634. $currentuser = array();
  2635.  
  2636. foreach($roomSlots as $rkey => $rval){
  2637. $rslottype[] = $rval['slot_type'];
  2638. $rslotstatus[] = $rval['SlotStatus'];
  2639. $oldslotUser[] = $rval['OldSlotUser'];
  2640. $currentuser[] = $rval['UserId'];
  2641. }
  2642.  
  2643. if((in_array($useridforsearch,$currentuser))) {
  2644. $slotData = '';
  2645.  
  2646. }else{
  2647.  
  2648. if((in_array('public',$rslottype)) || (in_array('private',$rslottype))){
  2649. if(in_array(1,$rslotstatus)){
  2650.  
  2651. $slotData = array();
  2652. $filledslots = array();
  2653.  
  2654. foreach ($roomSlots as $key => $row) {
  2655. $mid[$key] = $row['SlotId'];
  2656. }
  2657. array_multisort($mid, SORT_ASC, $roomSlots);
  2658.  
  2659. foreach($roomSlots as $rk => $rv) {
  2660.  
  2661. $roomUserid = $rv['UserId'];
  2662. $slottype = $rv['slot_type'];
  2663. $slotKey = $rv['SlotKey'];
  2664. $slotId = $rv['SlotId'];
  2665. $slotStatus = $rv['SlotStatus'];
  2666.  
  2667. if($slotStatus == 1){
  2668. $filledslots[] = $rv;
  2669. }
  2670.  
  2671.  
  2672. $userdata = $this->User->find('first', array('conditions' => array('User.id' => $roomUserid), 'fields' => array('User.fbid','User.pic','User.PictureIndex','User.username','User.star')));
  2673. if(!empty($userdata)){
  2674.  
  2675. $userfbid = $userdata['User']['fbid'];
  2676. $uPic = $userdata['User']['pic'];
  2677. $userPic = ($userdata['User']['pic']) ? HTTP_ROOT .'app/webroot/img/members/'.$uPic: $uPic;
  2678. $picindex = $userdata['User']['PictureIndex'];
  2679. $username = $userdata['User']['username'];
  2680. $star = $userdata['User']['star'];
  2681.  
  2682. }else{
  2683.  
  2684. $userfbid = '';
  2685. $userPic = '';
  2686. $picindex = '';
  2687. $username = '';
  2688. $star = '';
  2689. }
  2690. $slotData[] = array('Star' => $star,'UserName' => $username,'UserId' => $roomUserid, 'Type' => $slottype, 'Key' => $slotKey, 'SlotId' => $slotId, 'SlotStatus' => $slotStatus, 'UserFbId' => $userfbid, 'Picture' => $userPic, 'UserPicIndex' => $picindex) ;
  2691. }
  2692. }else{
  2693. $slotData = '';
  2694. }
  2695.  
  2696. }else{
  2697. $slotData = '';
  2698. }
  2699. }
  2700.  
  2701. if(!empty($slotData)) {
  2702. $slotFilled = count($filledslots);
  2703. $newRoomData[] = array('RoomId' => $roomid, 'SlotData' => $slotData, 'SlotsFilled' => $slotFilled,'OngoingStatus' => $OngoingStatus);
  2704. }else{
  2705. $newRoomData[] = '';
  2706. $slotFilled = 0 ;
  2707. }
  2708.  
  2709. }else{
  2710. $newRoomData[] = '';
  2711. $slotFilled = 0 ;
  2712. }
  2713. }
  2714.  
  2715. if(!empty($newRoomData) ){
  2716. $newRoomData = array_filter($newRoomData);
  2717. $newRoomData = array_values($newRoomData);
  2718. $newRoomData = array_slice($newRoomData, 0, 10);
  2719. $this->set(array('Response' => array('Error' => false , 'RoomData' => $newRoomData,'PlayersOnline' => $onlineuserslist,'OngoingGames' => $ongoingameslist), '_serialize' => array('Response')));
  2720. }else{
  2721. $this->set(array('Response' => array('Error' => false , 'Message' => 'No results found', 'RoomData' => array(),'PlayersOnline' => $onlineuserslist,'OngoingGames' => $ongoingameslist), '_serialize' => array('Response')));
  2722. }
  2723. }else{
  2724. $this->set(array('Response' => array('Error' => false, 'Message' => 'No Results Found','RoomData' => array(),'PlayersOnline' => $onlineuserslist,'OngoingGames' => $ongoingameslist), '_serialize' => array('Response')));
  2725. }
  2726.  
  2727. }
  2728. }
  2729. }
  2730.  
  2731.  
  2732. public function requestRematch() {
  2733. $error = array();
  2734. if(empty($_POST['RoomId'])){
  2735. $error[] = "RoomId parameter is Empty.";
  2736. }
  2737. if(empty($_POST['UserId'])){
  2738. $error[] = "UserId parameter is Empty";
  2739. }
  2740. if($_POST['Status'] == ""){
  2741. $error[] = "Status parameter is Empty";
  2742. }
  2743. if(!empty($error)){
  2744. $errorMsg = implode(',',$error);
  2745. $response = array('Error' => true, 'Message' => $errorMsg);
  2746. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  2747. }else{
  2748.  
  2749. $roomId = $_POST['RoomId'];
  2750. $userId = $_POST['UserId'];
  2751. $status = $_POST['Status'];
  2752.  
  2753. $selectRoomslot = $this->RoomSlot->find('all', array('conditions' => array('RoomSlot.RoomId' => $roomId), 'recursive' => -1, 'order' => array('RoomSlot.SlotId' => 'asc')));
  2754.  
  2755. $slotuserid = array();
  2756. if(!empty($selectRoomslot)){
  2757. foreach($selectRoomslot as $k=>$v){
  2758. $slotuserid[] = $v['RoomSlot']['UserId'];
  2759. }
  2760.  
  2761. if(in_array(0, $slotuserid)){
  2762. $this->set(array('Response' =>array('Error' => true , 'Message' => "Not Enough Users !"), '_serialize' => array('Response')));
  2763. }else{
  2764. if(in_array($userId, $slotuserid)){
  2765.  
  2766. $slotid=-1;
  2767. $data = array();
  2768. $datastatus = '';
  2769. foreach($slotuserid as $key=>$val){
  2770. $slotuser = $val;
  2771.  
  2772. //first check if data already exists
  2773. $rrematchdata = $this->RequestRematch->find('all', array('conditions' => array('RequestRematch.user_id' => $slotuser, 'RequestRematch.room_id' => $roomId)));
  2774.  
  2775. if(empty($rrematchdata)){
  2776. $slotid++;
  2777.  
  2778. if($slotuser == $userId){
  2779. $status = 1 ;
  2780. }else{
  2781. $status = 0;
  2782. }
  2783.  
  2784. $data[] = array('room_id' => $roomId,'host_id' => $userId ,'user_id' => $slotuser, 'slot_id' => $slotid , 'status' => $status);
  2785. $datastatus = 'true';
  2786. }else{
  2787. $data[] = '';
  2788. $datastatus = 'false';
  2789. }
  2790. }
  2791.  
  2792. if($datastatus == 'true'){
  2793.  
  2794. $this->RequestRematch->saveAll($data);
  2795.  
  2796.  
  2797.  
  2798. $this->set(array('Response' => array('Error' => false , 'Message' => 'Success'), '_serialize' => array('Response')));
  2799.  
  2800. }else{
  2801.  
  2802. if($status == 0){
  2803. $status = 1;
  2804. }else{
  2805. $status = $status;
  2806. }
  2807. $this->RequestRematch->updateAll(array('RequestRematch.status' => $status),array('RequestRematch.user_id'=> $userId, 'RequestRematch.room_id' => $roomId));
  2808.  
  2809.  
  2810.  
  2811. $this->set(array('Response' => array('Error' => false , 'Message' => 'Rematch Status Updated'), '_serialize' => array('Response')));
  2812. }
  2813.  
  2814. }else{
  2815. $this->set(array('Response' =>array('Error' => true , 'Message' => "This user have no slot for this room"), '_serialize' => array('Response')));
  2816. }
  2817. }
  2818.  
  2819. }else{
  2820. $this->set(array('Response' => array('Error' => true ,'Message' => "No room slots available.") , '_serialize' => array('Response')));
  2821. }
  2822. }
  2823. }
  2824.  
  2825. public function FetchRequestRematch() {
  2826. $error = array();
  2827. if(empty($_POST['RoomId'])){
  2828. $error[] = "RoomId parameter is empty";
  2829. }
  2830.  
  2831. if(empty($_POST['UserId'])) {
  2832. $error[] = "UserId parameter is empty";
  2833. }
  2834. if(!empty($error)){
  2835. $errorMsg = implode(',',$error);
  2836. $response = array('Error' => true, 'Message' => $errorMsg);
  2837. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  2838.  
  2839. }else{
  2840. $roomId = $_POST['RoomId'];
  2841. $UserId = $_POST['UserId'];
  2842.  
  2843. //check if this room exist on rematch table
  2844. $roomdata = $this->RequestRematch->find('first' , array('conditions' => array('RequestRematch.room_id' => $roomId), 'recursive' => -1));
  2845.  
  2846. if(empty($roomdata)){
  2847. //Case 1
  2848.  
  2849. $this->set(array('Response' => array('Error' => false ,'Message' => "No Room Data.", 'Status' => 'NotSet', 'RoomData'=>array('UserId' => $UserId, 'Name' => '', 'Status' => 'NotSet', 'NewRoomId' => "")) , '_serialize' => array('Response')));
  2850. }else{
  2851.  
  2852. //***********check for status 2 **************//
  2853. $chkRejected = $this->RequestRematch->find('first', array('conditions' => array('RequestRematch.room_id' => $roomId ,'RequestRematch.status' => 2 )));
  2854.  
  2855. if(empty($chkRejected )){
  2856. $checkAccepted = $this->RequestRematch->find('all', array('conditions' => array('RequestRematch.room_id' => $roomId ,'RequestRematch.status' => 1 )));
  2857.  
  2858. if(count($checkAccepted) == 4){
  2859.  
  2860.  
  2861.  
  2862. $oldRoomdata = $this->Room->find('first',array('conditions' => array('Room.id' => $roomId) ,'recursive' => -1) );
  2863. $roomtype = $oldRoomdata['Room']['room_type'];
  2864. $roomphotonid = $oldRoomdata['Room']['PhotonId'];
  2865. $oldroomid = $roomId;
  2866.  
  2867.  
  2868.  
  2869. //chk for room
  2870.  
  2871. $newuserdata = $this->RoomSlot->find('first', array('conditions' => array('RoomSlot.UserId' => $UserId,'RoomSlot.RoomId !=' => $roomId), 'recursive' => -1));
  2872.  
  2873. if(!empty($newuserdata)){
  2874.  
  2875. $newroomid = $newuserdata['RoomSlot']['RoomId'];
  2876. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  2877. $this->set(array('Response' => array('Error' => false , 'Message' => 'Accepted', 'Status' => 'Accepted', 'NewRoomId'=> $newroomid,'RoomData' => array('UserId' => $UserId, 'Name' =>'', 'Status' => 'Accepted', 'NewRoomId' => $newroomid)), '_serialize' => array('Response')));
  2878.  
  2879. }else{
  2880.  
  2881. //create new room
  2882.  
  2883. $gethostid = $this->RequestRematch->find('all' , array('conditions' => array('RequestRematch.room_id' => $roomId), 'fields' => array('host_id','user_id')) );
  2884.  
  2885.  
  2886.  
  2887. $hostId = $gethostid[0]['RequestRematch']['host_id'];
  2888.  
  2889. $hostData = $this->User->find('first', array('conditions' => array('User.id' => $hostId),'recursive' => -1));
  2890.  
  2891. $hostName = $hostData['User']['username'];
  2892. $UserId = $hostId;
  2893. $name = $hostName;
  2894. $HostName = $hostName;
  2895. $join_member_count = 4;
  2896. $created_time = strtotime(date('Y-m-d H:i:s')) ;
  2897. $created_date = date('Y-m-d H:i:s');
  2898.  
  2899. //add room type and photonid
  2900.  
  2901.  
  2902. $roomData = array('UserId' => $UserId,'name' => $name, 'HostName'=>$HostName,' room_type' => $roomtype,'PhotonId' => $roomphotonid, 'join_member_count' => $join_member_count, 'created_time' => $created_time, 'created_date' => $created_date, 'room_status' => '1', 'OngoingStatus' => '1');
  2903. $this->Room->save($roomData);
  2904. $newRoomId = $this->Room->getInsertID();
  2905.  
  2906.  
  2907.  
  2908.  
  2909. $this->RoomSlot->updateAll(array('RoomSlot.RoomId' => $newRoomId,'RoomSlot.OldSlotUser' => 0,'RoomSlot.play_status' => 0),array('RoomSlot.RoomId' => $roomId));
  2910.  
  2911. $this->RoomSlot->deleteAll(array('RoomSlot.RoomId' => $roomId));
  2912.  
  2913. //create room slots
  2914.  
  2915. //delete requestrematch data
  2916.  
  2917.  
  2918.  
  2919.  
  2920. $this->set(array('Response' => array('Error' => false , 'RoomData' => array('UserId' => $UserId, 'Name' => $name, 'Status' => 'Accepted', 'NewRoomId' => $newRoomId) ) , '_serialize' => array('Response') ));
  2921.  
  2922. }
  2923.  
  2924. }else{
  2925.  
  2926. //Case2
  2927. $chkUser = $this->RequestRematch->find('first', array('conditions' => array('RequestRematch.user_id' => $UserId ,'RequestRematch.room_id' => $roomId), 'recursive' => -1));
  2928.  
  2929.  
  2930. if(empty($chkUser)){
  2931. $this->set(array('Response' => array('Error' => false , 'Message' => 'This User is not set','Status' => 'Ask','RoomData' => array('UserId'=>$UserId, 'Name' => '', 'Status' => 'Ask', 'NewRoomId' => '')),'_serialize' => array('Response')));
  2932.  
  2933. }else{
  2934.  
  2935. $userStatus = $chkUser['RequestRematch']['status'];
  2936. if($userStatus == 0){
  2937. $this->set(array('Response' => array('Error' => false , 'Message' => 'Ask', 'Status' => 'Ask','RoomData' => array('UserId' => $UserId,'Name' => '', 'Status' => 'Ask', 'NewRoomId' => '')), '_serialize' => array('Response')));
  2938. }elseif($userStatus == 1){
  2939. $this->set(array('Response' => array('Error' => false , 'Message' => 'Waiting', 'Status' => 'Waiting','RoomData' => array('UserId' => $UserId, 'Name' => '', 'Status' => 'Waiting', 'NewRoomId' => '')), '_serialize' => array('Response')));
  2940. }elseif($userStatus == 2){
  2941. $this->set(array('Response' => array('Error' => false , 'Message' => 'Rejected','Status' => 'Rejected','RoomData' => array('UserId' => $UserId, 'Name' => '', 'Status' => 'Rejected', 'NewRoomId' => '')), '_serialize' => array('Response')));
  2942. }
  2943. }
  2944. }
  2945.  
  2946. }else{
  2947. $this->set(array('Response' => array('Error' => false , 'Message' => 'Rejected', 'Status' => 'Rejected','RoomData' => array('UserId' => $UserId, 'Name' => '', 'Status' => 'Rejected', 'NewRoomId' => '')), '_serialize' => array('Response')));
  2948.  
  2949. }
  2950. }
  2951. }
  2952. }
  2953.  
  2954.  
  2955. public function time_elapsed_string($datetime, $full = false) {
  2956. $now = new DateTime;
  2957. $ago = new DateTime($datetime);
  2958. $diff = $now->diff($ago);
  2959.  
  2960. $diff->w = floor($diff->d / 7);
  2961. $diff->d -= $diff->w * 7;
  2962.  
  2963. $string = array(
  2964. 'y' => 'year',
  2965. 'm' => 'month',
  2966. 'w' => 'week',
  2967. 'd' => 'day',
  2968. 'h' => 'hour',
  2969. 'i' => 'minute',
  2970. 's' => 'second',
  2971. );
  2972. foreach ($string as $k => &$v) {
  2973. if ($diff->$k) {
  2974. $v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : '');
  2975. } else {
  2976. unset($string[$k]);
  2977. }
  2978. }
  2979.  
  2980. if (!$full) $string = array_slice($string, 0, 1);
  2981. return $string ? implode(', ', $string) . ' ago' : 'just now';
  2982. }
  2983.  
  2984.  
  2985. public function UserStats() {
  2986. $error = array();
  2987. if(empty($this->request->query['UserId'])){
  2988. $error[] = "UserId parameter is empty";
  2989. }
  2990. if(!empty($error)){
  2991. $errorMsg = implode(',',$error);
  2992. $response = array('Error' => true, 'Message' => $errMessage);
  2993. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  2994. }else{
  2995. $userid = $this->request->query['UserId'];
  2996. $userStats = $this->UserPlayGame->find('first', array('conditions' => array('UserPlayGame.user_id' => $userid)));
  2997. if(!empty($userStats)){
  2998. $totalGame = $userStats['UserPlayGame']['total_game'];
  2999. $winGame = $userStats['UserPlayGame']['win_game'];
  3000. $lostGame = $userStats['UserPlayGame']['lost_game'];
  3001. $winpercent = $userStats['UserPlayGame']['win_percent'];
  3002. $perdayGameplayed = $userStats['UserPlayGame']['PerdayGameplayed'];
  3003. $Monthlygameplay = $userStats['UserPlayGame']['Monthlygameplay'];
  3004. $Weeklygameplay = $userStats['UserPlayGame']['Weeklygameplay'];
  3005. $fairPlay = $userStats['UserPlayGame']['fairPlay'];
  3006.  
  3007. $unixtime = $userStats['UserPlayGame']['created_date'];
  3008.  
  3009. $lastgameplayed = date("m/d/Y h:i:s",strtotime($unixtime));
  3010.  
  3011.  
  3012. $lastgameplayed = $this->time_elapsed_string(@$unixtime);
  3013.  
  3014. if($lastgameplayed == "2016 years ago"){
  3015. $lastgameplayed = 'Today';
  3016. }
  3017.  
  3018. //last game played to be included
  3019. $userStatsdata = array('WinPercent' => $winpercent,'LostGames' => $lostGame,'TotalGame' => $totalGame, 'WinGames' => $winGame, 'LastGamePlayed' => $lastgameplayed );
  3020.  
  3021. $this->set(array('Response' => array('Error' => false ,'UserStatsMultiPlayer' => $userStatsdata,'Message' => "Success") , '_serialize' => array('Response')));
  3022. }else{
  3023. $this->set(array('Response' => array('Error' => true ,'Message' => "NO UserStats available.") , '_serialize' => array('Response')));
  3024. }
  3025. }
  3026. }
  3027.  
  3028.  
  3029. // Type : 1 private , 2 public
  3030. // Room Status: 0 game not started, 1 game started
  3031. //Online Status : 1 for online, 0 for offline
  3032.  
  3033. public function roomjoinaftersearch(){
  3034.  
  3035. $error = array();
  3036. if(empty($this->request->query['RoomId'])){
  3037. $error[] = "RoomId parameter is empty" ;
  3038. }
  3039. if(empty($this->request->query['UserId'])){
  3040. $error[] = "UserId parameter is empty" ;
  3041. }
  3042. if($this->request->query['SlotId']==''){
  3043. $error[] = "SlotId parameter is empty" ;
  3044. }
  3045. if(!empty($error)){
  3046. $errorMsg = implode(',',$error);
  3047. $response = array('Error' => True, 'Message' => $errorMsg);
  3048. $this->set(array('Response' => $response, '_serialize' => array('Response')));
  3049. }else{
  3050. $userId = $this->request->query['UserId'];
  3051. $slotId = $this->request->query['SlotId'];
  3052. $roomId = $this->request->query['RoomId'];
  3053.  
  3054. $roomData = $this->Room->find('first', array('conditions' => array('Room.id' => $roomId)));
  3055.  
  3056. if(!empty($roomData)){
  3057. $getslotdata = $this->RoomSlot->find('first', array('conditions' => array( 'RoomSlot.SlotId' => $slotId, 'RoomSlot.RoomId' => $roomId ), 'recursive' => -1)) ;
  3058. if(!empty($getslotdata)){
  3059. $currentSlotuser = $getslotdata['RoomSlot']['UserId'];
  3060. if($currentSlotuser != 0){
  3061.  
  3062. $this->set(array('Response' => array('Error' => true , 'Message' => 'SlotAlreadyTaken') , '_serialize' => array('Response')));
  3063.  
  3064. }else{
  3065.  
  3066. $chkuserAssigned = $this->RoomSlot->find('first',array('conditions' => array('RoomSlot.UserId' => $userId)));
  3067. if(!empty($chkuserAssigned)){
  3068. $this->set(array('Response' => array('Error' => true , 'Message' => 'This User is already assigned ') , '_serialize' => array('Response')));
  3069. }else{
  3070. $this->RoomSlot->updateAll(array('RoomSlot.UserId' => $userId, 'RoomSlot.SlotStatus' =>'1'),array('RoomSlot.RoomId' => $roomId, 'RoomSlot.SlotId' => $slotId));
  3071.  
  3072. $newslotdata = $this->RoomSlot->find('all', array('conditions' => array( 'RoomSlot.RoomId' => $roomId ))) ;
  3073.  
  3074. $allSlotdata = array();
  3075. foreach($newslotdata as $k => $v){
  3076.  
  3077. $slotUser = $v['RoomSlot']['UserId'];
  3078. $type = $v['RoomSlot']['slot_type'];
  3079. if($type = 'public') {
  3080. $v['Password'] = null;
  3081. }elseif($type == 'private') {
  3082. $v['Password'] = $v['SlotKey'];
  3083. }elseif($type == 'invite'){
  3084. $v['Password'] = null ;
  3085. }
  3086. $userData =$this->User->find('first' , array('fields' => array('User.fbid', 'User.online_status'), 'conditions' => array('User.id' => $slotUser )));
  3087. if(!empty($userData)){
  3088.  
  3089. $userfbId = $userData['User']['fbid'];
  3090. $onlinestatus = $userData['User']['online_status'];
  3091. $allSlotdata[] = array('OnlineStatus' => $onlinestatus,'FbId' => $userfbId,'UserId' => $slotUser, 'Type' => $type , 'Password' => $v['Password']);
  3092. }else{
  3093. $allSlotdata[] = array('UserId' =>$slotUser );
  3094. }
  3095. }
  3096.  
  3097. $roomType = $roomData['Room']['room_type'];
  3098. $roomStatus = $roomData['Room']['room_status'];
  3099. $hostname = $roomData['Room']['HostName'];
  3100. $RoomCreationTime = $roomData['Room']['created_date'];
  3101. $slotlist = $allSlotdata;
  3102. $totalusers = $roomData['Room']['join_member_count'];
  3103. $photonid = $roomData['Room']['PhotonId'];
  3104.  
  3105. $newRoomJoinCount = $totalusers + 1 ;
  3106. if($newRoomJoinCount == 4){
  3107. $this->Room->updateAll(array('Room.join_member_count' => $newRoomJoinCount, 'Room.room_status' => 1,'OngoingStatus' => 1),array('Room.id' =>$roomId));
  3108.  
  3109. }else{
  3110. $this->Room->updateAll(array('Room.join_member_count' => $newRoomJoinCount),array('Room.id' =>$roomId));
  3111. }
  3112.  
  3113.  
  3114. $this->set(array('Response' => array('Error' => false , 'Status' => 'True',
  3115. 'RoomDetails' => array('RoomId' => $roomId, 'Type' => $roomType, 'RoomStatus' => $roomStatus , 'HostName' => $hostname, 'RoomCreationTime' => $RoomCreationTime ),
  3116. 'SlotList' => $slotlist, 'Message' => 'Success'), '_serialize' => array('Response')));
  3117.  
  3118. }
  3119. }
  3120.  
  3121.  
  3122. }else{
  3123. $this->set(array('Response' => array('Error' => true , 'Message' => 'This slot does not exist'), '_serialize' => array('Response')));
  3124. }
  3125. }else{
  3126. $this->set(array('Response' => array('Error' => true , 'Message' => 'This room Does Not exist.'), '_serialize' => array('Response')));
  3127. }
  3128. }
  3129. }
  3130.  
  3131.  
  3132. /*
  3133. @API: TopTenScores
  3134. Databy : 1 by Date, 2 by Week, 3 by Month
  3135. */
  3136.  
  3137. public function TopTenScores(){
  3138.  
  3139. $error = array();
  3140. if(empty($this->request->query['DataBy'])) {
  3141. $error[] = "DataBy parameter is empty";
  3142. }
  3143.  
  3144. if(!empty($error)){
  3145. $errorMsg = implode(',',$error);
  3146. $response = array('Error' => true, 'Message' => $errorMsg);
  3147. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  3148. }else{
  3149.  
  3150. $dataBy = $this->request->query['DataBy'];
  3151. $currentdate =date('Y-m-d');
  3152. $dateexplode = explode('-',$currentdate);
  3153. $currentmonth = $dateexplode['1'];
  3154.  
  3155. if($dataBy == 1) {
  3156. //Game played today
  3157. $playDateData= $this->FinalScore->find("all",array('conditions'=>array('DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND CURDATE()')));
  3158. // players list for today
  3159.  
  3160. if(!empty($playDateData)){
  3161. $playeronearr = array();
  3162. $playertwoarr = array();
  3163. foreach($playDateData as $k=>$v){
  3164.  
  3165. $playerids = explode(',',$v['FinalScore']['Players']);
  3166.  
  3167. $playerone = $playerids[0];
  3168. $playertwo = $playerids[1];
  3169. $playeronearr[] = $playerone;
  3170. $playertwoarr[] = $playertwo;
  3171.  
  3172. }
  3173. $allplayerarray = array_merge($playeronearr,$playertwoarr);
  3174. if(!empty($allplayerarray)){
  3175.  
  3176. $uniqueplayerslist = array_unique($allplayerarray);
  3177. $resetplayerkeys = array_values($uniqueplayerslist);
  3178. // got the users list until here . Now we have file for user stats 1 from users table
  3179. $requiredids = array();
  3180. foreach($resetplayerkeys as $key=>$playerid) {
  3181. $chkuserstats = $this->User->find("first",array('conditions' => array('User.id' => $playerid),'fields' => array('statas')));
  3182. if(!empty($chkuserstats)){
  3183. if($chkuserstats['User']['statas'] == 1){
  3184. $validuserids = $playerid;
  3185. }else{
  3186. $validuserids = '';
  3187. }
  3188. }else{
  3189. $validuserids = '';
  3190. }
  3191. $requiredids[] = $validuserids;
  3192. }
  3193.  
  3194. $reqids = array_values(array_filter($requiredids));
  3195.  
  3196. if(!empty($reqids)){
  3197. $userdata = array();
  3198. foreach($reqids as $idkey=>$idval){
  3199.  
  3200. $playDateData= $this->FinalScore->find("all",array('conditions'=>array('Players LIKE'=>'%' . $idval . '%','DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND CURDATE()'),'order'=>array('FinalScore.Score'=>'desc'),'fields' => array('RoomId')));
  3201.  
  3202. $noofgameplaytoday = count($playDateData);
  3203. $minimumplaylimit = 10;
  3204.  
  3205. if($noofgameplaytoday >= $minimumplaylimit){
  3206.  
  3207. $winplayDateData= $this->FinalScore->find("all",array('conditions'=>array('Players LIKE'=>'%' . $idval . '%','DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND CURDATE()','Result'=>'W'),'fields' => array('RoomId','Result')));
  3208.  
  3209. $winpercentageofuser = round((count($winplayDateData)/$noofgameplaytoday) * 100);
  3210.  
  3211. $username = $this->User->find("first",array('conditions'=>array('User.id' => $idval),'fields' => array('username')));
  3212.  
  3213. if($winpercentageofuser > 0 ){
  3214. $userdata[] = array('Username' => $username['User']['username'],'WinPercent' => $winpercentageofuser);
  3215. }else{
  3216. $userdata[] = array();
  3217. }
  3218.  
  3219. }else{
  3220. $userdata[] = array();
  3221. }
  3222.  
  3223. }
  3224.  
  3225. $userdata = array_values(array_filter($userdata));
  3226.  
  3227. if(!empty($userdata)){
  3228.  
  3229. foreach ($userdata as $key => $row) {
  3230. $mid[$key] = $row['WinPercent'];
  3231. }
  3232. array_multisort($mid, SORT_DESC, $userdata);
  3233.  
  3234. $allUserData = array_slice($userdata, 0, 10);
  3235. $this->set(array('Response' => array('Error' => false, 'UserPlayData' => $allUserData), '_serialize' => array('Response')));
  3236.  
  3237. }else{
  3238.  
  3239. $this->set(array('Response' => array('Error' => false, 'UserPlayData' => array()), '_serialize' => array('Response')));
  3240. }
  3241.  
  3242. }else{
  3243. $this->set(array('Response'=>array('Error'=>false,'UserPlayData' => array()),'_serialize' => array('Response')));
  3244. }
  3245. }
  3246.  
  3247. }else{
  3248. $this->set(array('Response'=>array('Error' => false, 'UserPlayData' => array()), '_serialize' => array('Response')));
  3249. }
  3250.  
  3251. }elseif($dataBy == 2){
  3252.  
  3253. //Game played this week
  3254.  
  3255. $playDateData= $this->FinalScore->find("all",array('conditions'=>array('DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE()')));
  3256.  
  3257. // players list for this week
  3258.  
  3259. if(!empty($playDateData)){
  3260. $playeronearr = array();
  3261. $playertwoarr = array();
  3262. foreach($playDateData as $k=>$v){
  3263.  
  3264. $playerids = explode(',',$v['FinalScore']['Players']);
  3265.  
  3266. $playerone = $playerids[0];
  3267. $playertwo = $playerids[1];
  3268. $playeronearr[] = $playerone;
  3269. $playertwoarr[] = $playertwo;
  3270.  
  3271. }
  3272. $allplayerarray = array_merge($playeronearr,$playertwoarr);
  3273. if(!empty($allplayerarray)){
  3274.  
  3275. $uniqueplayerslist = array_unique($allplayerarray);
  3276. $resetplayerkeys = array_values($uniqueplayerslist);
  3277. // got the users list until here . Now we have file for user stats 1 from users table
  3278. $requiredids = array();
  3279. foreach($resetplayerkeys as $key=>$playerid) {
  3280. $chkuserstats = $this->User->find("first",array('conditions' => array('User.id' => $playerid),'fields' => array('statas')));
  3281. if(!empty($chkuserstats)){
  3282. if($chkuserstats['User']['statas'] == 1){
  3283. $validuserids = $playerid;
  3284. }else{
  3285. $validuserids = '';
  3286. }
  3287. }else{
  3288. $validuserids = '';
  3289. }
  3290.  
  3291. $requiredids[] = $validuserids;
  3292.  
  3293. }
  3294.  
  3295. $reqids = array_values(array_filter($requiredids));
  3296.  
  3297. if(!empty($reqids)){
  3298. $userdata = array();
  3299. foreach($reqids as $idkey=>$idval){
  3300.  
  3301.  
  3302. $playDateData= $this->FinalScore->find("all",array('conditions'=>array('Players LIKE'=>'%' . $idval . '%','DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE()'),'order'=>array('FinalScore.Score'=>'desc'),'fields' => array('RoomId')));
  3303.  
  3304. $noofgameplaytoday = count($playDateData);
  3305. $minimumplaylimit = 35;
  3306.  
  3307. if($noofgameplaytoday >= $minimumplaylimit){
  3308.  
  3309.  
  3310. $winplayDateData= $this->FinalScore->find("all",array('conditions'=>array('Players LIKE'=>'%' . $idval . '%','DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE()','Result'=>'W'),'fields' => array('RoomId','Result')));
  3311.  
  3312. $winpercentageofuser = round((count($winplayDateData)/$noofgameplaytoday) * 100);
  3313.  
  3314.  
  3315. $username = $this->User->find("first",array('conditions' => array('User.id' => $idval),'fields' => array('username')));
  3316.  
  3317. if($winpercentageofuser > 0 ){
  3318. $userdata[] = array('Username' => $username['User']['username'],'WinPercent' => $winpercentageofuser);
  3319. }else{
  3320. $userdata[] = array();
  3321. }
  3322. }else{
  3323. $userdata[] = array();
  3324. }
  3325.  
  3326. }
  3327.  
  3328. $userdata = array_values(array_filter($userdata));
  3329.  
  3330. if(!empty($userdata)){
  3331.  
  3332. foreach ($userdata as $key => $row) {
  3333. $mid[$key] = $row['WinPercent'];
  3334. }
  3335. array_multisort($mid, SORT_DESC, $userdata);
  3336.  
  3337. $allUserData = array_slice($userdata, 0, 10);
  3338. $this->set(array('Response' => array('Error' => false, 'UserPlayData' => $allUserData), '_serialize' => array('Response')));
  3339.  
  3340. }else{
  3341. $this->set(array('Response'=>array('Error'=>false,'UserPlayData'=>array()), '_serialize' => array('Response')));
  3342. }
  3343.  
  3344. }else{
  3345. $this->set(array('Response' => array('Error' => false, 'UserPlayData' => array()), '_serialize' => array('Response')));
  3346. }
  3347.  
  3348. }
  3349.  
  3350. }else{
  3351. $this->set(array('Response'=>array('Error' => false, 'UserPlayData' => array()), '_serialize' => array('Response')));
  3352. }
  3353.  
  3354. }elseif($dataBy == 3){
  3355.  
  3356. //Game played this month
  3357. $playDateData= $this->FinalScore->find("all",array('conditions'=>array('DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND CURDATE()')));
  3358.  
  3359. // players list for this month
  3360.  
  3361. if(!empty($playDateData)){
  3362. $playeronearr = array();
  3363. $playertwoarr = array();
  3364. foreach($playDateData as $k=>$v){
  3365.  
  3366. $playerids = explode(',',$v['FinalScore']['Players']);
  3367. $playerone = $playerids[0];
  3368. $playertwo = $playerids[1];
  3369. $playeronearr[] = $playerone;
  3370. $playertwoarr[] = $playertwo;
  3371.  
  3372. }
  3373. $allplayerarray = array_merge($playeronearr,$playertwoarr);
  3374. if(!empty($allplayerarray)){
  3375.  
  3376. $uniqueplayerslist = array_unique($allplayerarray);
  3377. $resetplayerkeys = array_values($uniqueplayerslist);
  3378. // got the users list until here . Now we have file for user stats 1 from users table
  3379. $requiredids = array();
  3380. foreach($resetplayerkeys as $key=>$playerid) {
  3381.  
  3382. $chkuserstats = $this->User->find("first",array('conditions' => array('User.id' => $playerid),'fields' => array('statas')));
  3383. if(!empty($chkuserstats)){
  3384. if($chkuserstats['User']['statas'] == 1){
  3385. $validuserids = $playerid;
  3386. }else{
  3387. $validuserids = '';
  3388. }
  3389. }else{
  3390. $validuserids = '';
  3391. }
  3392.  
  3393. $requiredids[] = $validuserids;
  3394. }
  3395.  
  3396. $reqids = array_values(array_filter($requiredids));
  3397.  
  3398. if(!empty($reqids)){
  3399. $userdata = array();
  3400. foreach($reqids as $idkey=>$idval){
  3401.  
  3402.  
  3403. $playDateData= $this->FinalScore->find("all",array('conditions'=>array('Players LIKE'=>'%' . $idval . '%','DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND CURDATE()'),'order'=>array('FinalScore.Score'=>'desc'),'fields' => array('RoomId')));
  3404.  
  3405. $noofgameplaytoday = count($playDateData);
  3406.  
  3407. $minimumplaylimit = 100;
  3408.  
  3409. if($noofgameplaytoday >= $minimumplaylimit){
  3410.  
  3411.  
  3412. $winplayDateData= $this->FinalScore->find("all",array('conditions'=>array('Players LIKE'=>'%' . $idval . '%','DATE(CreatedOn) BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND CURDATE()','Result'=>'W'),'fields' => array('RoomId','Result')));
  3413.  
  3414. $winpercentageofuser = round((count($winplayDateData)/$noofgameplaytoday) * 100);
  3415.  
  3416. $username = $this->User->find("first",array('conditions'=>array('User.id' => $idval),'fields' => array('username')));
  3417.  
  3418. if($winpercentageofuser > 0 ){
  3419. $userdata[] = array('Username' => $username['User']['username'],'WinPercent' => $winpercentageofuser);
  3420. }else{
  3421. $userdata[] = array();
  3422. }
  3423.  
  3424. }else{
  3425. $userdata[] = array();
  3426. }
  3427.  
  3428. }
  3429.  
  3430. $userdata = array_values(array_filter($userdata));
  3431.  
  3432. if(!empty($userdata)){
  3433.  
  3434. foreach ($userdata as $key => $row) {
  3435. $mid[$key] = $row['WinPercent'];
  3436. }
  3437. array_multisort($mid, SORT_DESC, $userdata);
  3438.  
  3439. $allUserData = array_slice($userdata, 0, 10);
  3440. $this->set(array('Response' => array('Error' => false, 'UserPlayData' => $allUserData), '_serialize' => array('Response')));
  3441.  
  3442. }else{
  3443. $this->set(array('Response'=>array('Error'=>false,'UserPlayData' => array()), '_serialize' => array('Response')));
  3444. }
  3445.  
  3446. }else{
  3447. $this->set(array('Response' => array('Error' => false, 'UserPlayData' => array()), '_serialize' => array('Response')));
  3448. }
  3449. }
  3450.  
  3451. }else{
  3452. $this->set(array('Response'=>array('Error' => false, 'UserPlayData'=>array()), '_serialize' => array('Response')));
  3453. }
  3454.  
  3455. }else{
  3456. $this->set(array('Response'=>array('Error'=>true, 'Message' => 'No data available'), '_serialize' => array('Response')));
  3457. }
  3458. }
  3459. }
  3460.  
  3461. public function SetForcerValue(){
  3462. $error = array();
  3463. if(empty($this->request->query['UserId'])) {
  3464. $error[] = "UsedrId parameter is empty";
  3465. }
  3466.  
  3467. if(!empty($error)){
  3468. $errorMsg = implode(',',$error);
  3469. $response = array('Error' => true, 'Message' => $errorMsg);
  3470. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  3471.  
  3472. }else{
  3473. //Check User Exists
  3474. $UserId = $this->request->query['UserId'];
  3475. $chkUser = $this->User->find('first', array('conditions' => array('User.id' => $UserId),'recursive' => -1));
  3476.  
  3477. if(count($chkUser) > 0 ){
  3478.  
  3479. $checkuserplaydata = $this->UserPlayGame->find('first', array('conditions' => array('UserPlayGame.user_id' => $UserId), 'recursive' => -1));
  3480. if(count($checkuserplaydata)> 0){
  3481. $oldForcervalue = $checkuserplaydata['UserPlayGame']['Forcer'];
  3482. $newForcervalue = $oldForcervalue + 1;
  3483. $this->UserPlayGame->updateAll(array('UserPlayGame.Forcer' => $newForcervalue),array('UserPlayGame.user_id' => $UserId ));
  3484. $this->set(array('Response' => array('Error' => false, 'Message' => 'Successfully Updated'), '_serialize' => array('Response')));
  3485.  
  3486. }else{
  3487. $data['UserPlayGame']['user_id'] = $UserId;
  3488. $data['UserPlayGame']['Forcer'] = 1;
  3489. $this->UserPlayGame->save($data);
  3490. $this->set(array('Response' => array('Error' => false, 'Message' => 'Success'), '_serialize' => array('Response')));
  3491. }
  3492.  
  3493. }else{
  3494. $this->set(array('Response'=>array('Error'=>true,'Message' => 'User Does Not exist'), '_serialize' => array('Response')));
  3495. }
  3496. }
  3497. }
  3498.  
  3499. public function SetHomeRunValue(){
  3500. $error = array();
  3501. if(empty($this->request->query['UserId'])) {
  3502. $error[] = "UsedrId parameter is empty";
  3503. }
  3504.  
  3505. if(!empty($error)){
  3506. $errorMsg = implode(',',$error);
  3507. $response = array('Error' => true, 'Message' => $errorMsg);
  3508. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  3509.  
  3510. }else{
  3511.  
  3512. //Check User Exists
  3513. $UserId = $this->request->query['UserId'];
  3514. $chkUser = $this->User->find('first', array('conditions' => array('User.id' => $UserId),'recursive' => -1));
  3515.  
  3516. if(count($chkUser) > 0 ){
  3517.  
  3518. $checkuserplaydata = $this->UserPlayGame->find('first', array('conditions' => array('UserPlayGame.user_id' => $UserId), 'recursive' => -1));
  3519. if(count($checkuserplaydata)> 0){
  3520. $oldHomerunvalue = $checkuserplaydata['UserPlayGame']['HomeRun'];
  3521. $newHomeRunvalue = $oldHomerunvalue + 1;
  3522. $this->UserPlayGame->updateAll(array('UserPlayGame.HomeRun' => $newHomeRunvalue),array('UserPlayGame.user_id' => $UserId ));
  3523. $this->set(array('Response' => array('Error' => false, 'Message' => 'Successfully Updated'), '_serialize' => array('Response')));
  3524.  
  3525. }else{
  3526. $data['UserPlayGame']['user_id'] = $UserId;
  3527. $data['UserPlayGame']['HomeRun'] = 1;
  3528. $this->UserPlayGame->save($data);
  3529. $this->set(array('Response' => array('Error' => false, 'Message' => 'Success'),'_serialize' => array('Response')));
  3530. }
  3531.  
  3532. }else{
  3533. $this->set(array('Response'=>array('Error'=>true,'Message' => 'User Does Not exist'),'_serialize' => array('Response')));
  3534. }
  3535.  
  3536. }
  3537.  
  3538. }
  3539.  
  3540. public function GetAchievementValues(){
  3541.  
  3542. $error = array();
  3543. if(empty($this->request->query['UserId'])) {
  3544. $error[] = "UserId parameter is empty";
  3545. }
  3546.  
  3547. if(!empty($error)){
  3548. $errorMsg = implode(',',$error);
  3549. $response = array('Error' => true, 'Message' => $errorMsg);
  3550. $this->set(array('Response' => $response , '_serialize' => array('Response')));
  3551.  
  3552. }else{
  3553.  
  3554. $userId = $this->request->query['UserId'] ;
  3555. //check if gameplaydata exists for this user
  3556.  
  3557. $userplaydata = $this->UserPlayGame->find('all', array('conditions' => array('UserPlayGame.user_id'=> $userId), 'recursive' => -1));
  3558. if(count($userplaydata) > 0){
  3559. $homerun = $userplaydata[0]['UserPlayGame']['HomeRun'];
  3560. $Forcer = $userplaydata[0]['UserPlayGame']['Forcer'];
  3561. $Ace = $userplaydata[0]['UserPlayGame']['Ace'];
  3562. $Unstoppable = $userplaydata[0]['UserPlayGame']['Unstoppable'];
  3563. $Winner = $userplaydata[0]['UserPlayGame']['Winner'];
  3564. $Player = $userplaydata[0]['UserPlayGame']['Player'];
  3565. $Looser = $userplaydata[0]['UserPlayGame']['Looser'];
  3566. $FullHouse = $userplaydata[0]['UserPlayGame']['FullHouse'];
  3567. $WinStreak = $userplaydata[0]['UserPlayGame']['WinStreak'];
  3568. $XthreeWinStreak = $userplaydata[0]['UserPlayGame']['XthreeWinStreak'];
  3569. $XfiveWinstreak = $userplaydata[0]['UserPlayGame']['XfiveWinstreak'];
  3570. $XtenWinstreak = $userplaydata[0]['UserPlayGame']['XtenWinstreak'];
  3571.  
  3572. $data = array($Ace,$Unstoppable,$Winner,$Player,$XthreeWinStreak,$XfiveWinstreak,$XtenWinstreak,$Looser,$FullHouse,$homerun,$Forcer);
  3573.  
  3574. $this->set(array('Response' => array('Error' => false, 'UserAchievementData' => $data, 'UserId' => $userId), '_serialize' => array('Response')));
  3575. }else{
  3576. $this->set(array('Response' => array('Error' => true, 'Message' => 'User Data Not available'), '_serialize' => array('Response')));
  3577. }
  3578. }
  3579. }
  3580.  
  3581.  
  3582. }
  3583.  
  3584.  
  3585. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!