PageRenderTime 72ms CodeModel.GetById 37ms RepoModel.GetById 0ms app.codeStats 0ms

/datafeed.php

https://bitbucket.org/itoxable/chiron-gaming
PHP | 1900 lines | 1606 code | 241 blank | 53 comment | 240 complexity | beea1dbdb008de0009afa42f84c269e1 MD5 | raw file
Possible License(s): AGPL-1.0, GPL-2.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. 

  3. include_once "general_include.php";
    4. 

  4. include_once("adodb/dbconfig.php");
    5. 

  5. include('transaction_status.class.php');
    6. 

  6. 

  7. function js2PhpTime($jsdate){
    8. 

  8. 	if(preg_match('@(\d+)/(\d+)/(\d+)\s+(\d+):(\d+)@', $jsdate, $matches)==1){
    9. 

  9. 		$ret = mktime($matches[4], $matches[5], 0, $matches[1], $matches[2], $matches[3]);
    10. 

  10. 	}else if(preg_match('@(\d+)/(\d+)/(\d+)@', $jsdate, $matches)==1){
    11. 

  11. 		$ret = mktime(0, 0, 0, $matches[1], $matches[2], $matches[3]);
    12. 

  12. 	}
    13. 

  13. 	return $ret;
    14. 

  14. }
    15. 

  15. function php2MySqlTime($phpDate){
    16. 

  16. 	return date("Y-m-d H:i:s", $phpDate);
    17. 

  17. }
    18. 

  18. if(!isset($_SESSION['user_id'])){
    19. 

  19. 	echo "session not started";
    20. 

  20. 	return;
    21. 

  21. }
    22. 

  22. 

  23. function getPostOrGetParam($param){
    24. 

  24. 	if(isset($_POST[$param]))
    25. 

  25. 		return $_POST[$param];
    26. 

  26. 	else{
    27. 

  27. 		if(isset($_GET[$param]))
    28. 

  28. 			return $_GET[$param];
    29. 

  29. 		else
    30. 

  30. 			return "";
    31. 

  31. 	}
    32. 

  32. }
    33. 

  33. 

  34. class Status{
    35. 

  35. 	public static $AVAILABLE = 1;
    36. 

  36. 	public static $ACTIVE = 2;
    37. 

  37. 	public static $DELETED = 3;
    38. 

  38. 	public static $PENDING = 4;
    39. 

  39. 	public static $ACCEPTED = 5;
    40. 

  40. 	public static $FINISHED = 6;
    41. 

  41. 	public static $DECLINED = 7;
    42. 

  42. 	public static $REQUESTED = 8;
    43. 

  43. }
    44. 

  44. 

  45. class LessonStatus{
    46. 

  46. 	const OPEN = 1;
    47. 

  47. 	const PAID = 2;
    48. 

  48. 	const COMPLETED = 3;
    49. 

  49. 	const CLOSED_WITH_PAYMENT_TO_COACH = 4;
    50. 

  50. 	const CANCELED = 5;
    51. 

  51.         const WAITING_CONFIRMATION = 6;
    52. 

  52. }
    53. 

  53. class LessonType{
    54. 

  54. 	const REGULAR = 0;
    55. 

  55. 	const INSTANT = 1;
    56. 

  56. }
    57. 

  57. 

  58. class UserType{
    59. 

  59. 	const COACH = 1;
    60. 

  60.         const STUDENT = 2;
    61. 

  61. 	const TRAINNING_PARTNER = 3;
    62. 

  62. }
    63. 

  63. 

  64. 

  65. class ErrorCode{
    66. 

  66. 	public static $UNKNOWN= 0;
    67. 

  67. 	public static $ALREADY_USED = -2;
    68. 

  68. 	public static $NO_EVENTS = -3;
    69. 

  69. 	public static $ALREADY_SCHEDULED = -4;
    70. 

  70. }
    71. 

  71. 

  72. class NotificationTypes{
    73. 

  73. 	public static $GENERAL= 0;
    74. 

  74. 	public static $SCHEDULE_ALERT = 1;
    75. 

  75. 	public static $UNKNOWN = 2;
    76. 

  76. 	public static $INSTANT_LESSON = 3;
    77. 

  77.         public static $INSTANT_LESSON_RESPONSE = 5;
    78. 

  78. 	public static $MESSAGE = 4;
    79. 

  79. }
    80. 

  80. 

  81. class Constants{
    82. 

  82. 	public static $TIMES_ARRAY = array("0:00","0:30","1:00","1:30","2:00","2:30","3:00","3:30","4:00","4:30","5:00","5:30","6:00","6:30","7:00","7:30",
    83. 

  83. 			"8:00","8:30","9:00","9:30","10:00","10:30","11:00","11:30","12:00","12:30","13:00","13:30","14:00","14:30","15:00",
    84. 

  84. 			"15:30","16:00","16:30","17:00","17:30","18:00","18:30","19:00","19:30","20:00","20:30","21:00","21:30","22:00","22:30","23:00","23:30","23:59");
    85. 

  85. 

  86. 	public static $SLOTS_ARRAY = array("h0","h1","h2","h3",
    87. 

  87. 			"h4","h5","h6","h7","h8","h9","h10","h11","h12","h13","h14","h15","h16","h17","h18","h19",
    88. 

  88. 			"h20","h21","h22","h23","h24","h25","h26","h27","h28","h29","h30","h31","h32","h33",
    89. 

  89. 			"h34","h35","h36","h37","h38","h39","h40","h41","h42","h43","h44","h45","h46","h47");
    90. 

  90. }
    91. 

  91. 

  92. function login($username,$password){
    93. 

  93. 	try{
    94. 

  94. 		$db = new DBConnection();
    95. 

  95. 		$db->getConnection();
    96. 

  96. 		$sql = "select * from `nk_user` where `email`='".$username."' and `password`='".$password."'";
    97. 

  97. 		$handle = mysql_query($sql);
    98. 

  98. 		$linha = mysql_fetch_row($handle);
    99. 

  99. 

  100. 		$_SESSION['user_id'] = $linha[0];
    101. 

  101. 		$_SESSION['logged_username'] = $linha[3];
    102. 

  102. 		return true;
    103. 

  103. 	}catch(Exception $e){
    104. 

  104. 		return  $e->getMessage();
    105. 

  105. 	}
    106. 

  106. }
    107. 

  107. 

  108. 

  109. class Notification{
    110. 

  110. 	public $notification_id;
    111. 

  111. 	public $user_id;
    112. 

  112. 	public $title;
    113. 

  113. 	public $introduction;
    114. 

  114. 	public $text;
    115. 

  115. 	public $date_value;
    116. 

  116. 	public $link;
    117. 

  117. 	public $new;
    118. 

  118. 	public $date_readed;
    119. 

  119. 	public $modified_date;
    120. 

  120. 	public $creation_date;
    121. 

  121. 	public $origin;
    122. 

  122. 	public $type;
    123. 

  123. 	public $extra_data;
    124. 

  124. 

  125. 	public function setNotification($notification_id=0,$user_id=0,$type=0,$origin="",$title="",$introduction="",$text="",$date_readed="",$date_value="",$link="",$new="", $modified_date="", $creation_date="") {
    126. 

  126. 		$this->notification_id = $notification_id;
    127. 

  127. 		$this->user_id = $user_id;
    128. 

  128. 		$this->title = $title;
    129. 

  129. 		$this->introduction = $introduction;
    130. 

  130. 		$this->text = $text;
    131. 

  131. 		$this->date_readed = $date_readed;
    132. 

  132. 		$this->creation_date = $creation_date;
    133. 

  133. 		$this->modified_date = $modified_date;
    134. 

  134. 		$this->date_value = $date_value;
    135. 

  135. 		$this->link = $link;
    136. 

  136. 		$this->origin = $origin;
    137. 

  137. 		$this->type = $type;
    138. 

  138. 	}
    139. 

  139. 

  140. 	public function __construct($row) {
    141. 

  141. 

  142. 		$this->notification_id = $row->notification_id;
    143. 

  143. 		$this->user_id = $row->user_id;
    144. 

  144. 		$this->title = $row->title;
    145. 

  145. 		$this->introduction = $row->introduction;
    146. 

  146. 		$this->text = $row->text;
    147. 

  147. 		$this->creation_date = $row->creation_date;
    148. 

  148. 		$this->modified_date = $row->modified_date;
    149. 

  149. 		$this->date_readed = $row->date_readed;
    150. 

  150. 		$this->date_value = $row->date_value;
    151. 

  151. 		$this->link = $row->link;
    152. 

  152. 		$this->new = $row->new;
    153. 

  153. 		$this->origin = $row->origin;
    154. 

  154. 		$this->type = $row->nofication_type;
    155. 

  155. 		$this->extra_data = $row->extra_data;
    156. 

  156. 	}
    157. 

  157. 

  158. 	public function __toString(){
    159. 

  159.             return "";
    160. 

  160. 	}
    161. 

  161. }
    162. 

  162. 

  163. class Event{
    164. 

  164. 	public $status = "";
    165. 

  165. 	public $calendarRef = "";
    166. 

  166. 	public $description = "";
    167. 

  167. 	public $requestoruserId = "";
    168. 

  168. 	public $availableSpot = "";
    169. 

  169. 	public $isEmpty = 0;
    170. 

  170. 	public $requestorTxt = "";
    171. 

  171. 	public $slot = "";
    172. 

  172. 	public $calendarId = "";
    173. 

  173. 	public $gameId = array();
    174. 

  174. 	public $userId = "";
    175. 

  175. 	public $date = "";
    176. 

  176. 	public $day = "";
    177. 

  177. 	public $month = "";
    178. 

  178. 	public $year = "";
    179. 

  179. 	public $lessonId = "";
    180. 

  180. 	
    181. 

  181. 	function setStatus($status){
    182. 

  182. 		$this->status = $status;
    183. 

  183. 	}
    184. 

  184. 

  185. 	function setCalendarRef($calendarRef){
    186. 

  186. 		$this->calendarRef = $calendarRef;
    187. 

  187. 	}
    188. 

  188. 

  189. 	function setDescription($description){
    190. 

  190. 		$this->description = $description;
    191. 

  191. 	}
    192. 

  192. 

  193. 	function setRequestoruserId($requestoruserId){
    194. 

  194. 		$this->requestoruserId = $requestoruserId;
    195. 

  195. 	}
    196. 

  196. 

  197. 	function setAvailableSpot($availableSpot){
    198. 

  198. 		$this->$availableSpot = $availableSpot;
    199. 

  199. 	}
    200. 

  200. 

  201. 	function setIsEmpty($isEmpty){
    202. 

  202. 		$this->isEmpty = $isEmpty;
    203. 

  203. 	}
    204. 

  204. 

  205. 	function setRequestorTxt($requestorTxt){
    206. 

  206. 		$this->requestorTxt = $requestorTxt;
    207. 

  207. 	}
    208. 

  208. 	function setGameId($gameId){
    209. 

  209. 		$this->gameId = $gameId;
    210. 

  210. 	}
    211. 

  211. 	function setLessonIdId($lessonId){
    212. 

  212. 		$this->lessonId = $lessonId;
    213. 

  213. 	}
    214. 

  214. 

  215. 	public function setEvent($status="",$description="",$availableSpot="",$gameId="", $requestoruserId="",$calendarRef="",$requestorTxt="",$isEmpty=0,$slot="",$lessonId="") {
    216. 

  216. 		$this->status = $status;
    217. 

  217. 		$this->description = $description;
    218. 

  218. 		$this->availableSpot = $availableSpot;
    219. 

  219. 		$this->requestoruserId = $requestoruserId;
    220. 

  220. 		$this->calendarRef = $calendarRef;
    221. 

  221. 		$this->requestorTxt = $requestorTxt;
    222. 

  222. 		$this->isEmpty = $isEmpty;
    223. 

  223. 		$this->slot = $slot;
    224. 

  224. 		$this->lessonId = $lessonId;
    225. 

  225. 		if(is_array($gameId))
    226. 

  226. 			$this->gameId = $gameId;
    227. 

  227. 		else
    228. 

  228. 			$this->gameId = split('#', $gameId);
    229. 

  229. 	}
    230. 

  230. 

  231. 	public function __construct($event=null, $slot="", $row=null) {
    232. 

  232. 		if(is_null($event)){
    233. 

  233. 			$this->isEmpty = true;
    234. 

  234. 		}else{
    235. 

  235. 			list ($this->status, $this->description,$this->availableSpot, $gameId, $this->requestoruserId, $this->calendarRef, $this->requestorTxt,$this->lessonId) = split(',', $event);
    236. 

  236. 			$this->gameId = split('#', $gameId);
    237. 

  237. 		}
    238. 

  238. 		$this->slot = $slot;
    239. 

  239. 		if($row != null){
    240. 

  240. 			$this->calendarId = $row->calendar_id;
    241. 

  241. 			$this->userId = $row->user_id;
    242. 

  242. 			$this->date = $row->date;
    243. 

  243. 			$this->day = $row->day;
    244. 

  244. 			$this->month = $row->month;
    245. 

  245. 			$this->year = $row->year;
    246. 

  246. 		}
    247. 

  247. 	}
    248. 

  248. 

  249. 	public function __toString(){
    250. 

  250. 		if($this->isEmpty){
    251. 

  251. 			return "NULL";
    252. 

  252. 		}
    253. 

  253. 		$i=0;
    254. 

  254. 		foreach ($this->gameId as $g){
    255. 

  255. 			if($i==0)
    256. 

  256. 				$gameId = $g;
    257. 

  257. 			else
    258. 

  258. 				$gameId = $gameId."#".$g;
    259. 

  259. 			$i++;
    260. 

  260. 		}
    261. 

  261. 		return "'".$this->status.",".$this->description.",".$this->availableSpot.",".$gameId.",".$this->requestoruserId.",".$this->calendarRef.",".$this->requestorTxt.",".$this->lessonId."'";
    262. 

  262. 	}
    263. 

  263. }
    264. 

  264. 

  265. function getAllSlots($userid,$day){
    266. 

  266. 	return getSlots($userid,$day,Constants::$SLOTS_ARRAY);
    267. 

  267. }
    268. 

  268. 

  269. function getAllSlotsByCalendarId($calendarId){
    270. 

  270. 	return getSlotsByCalendarId($calendarId,Constants::$SLOTS_ARRAY);
    271. 

  271. }
    272. 

  272. 

  273. function getSlots($userid,$date,$slots){
    274. 

  274. 	$ret = array();
    275. 

  275. 	try{
    276. 

  276. 		$db = new DBConnection();
    277. 

  277. 		$db->getConnection();
    278. 

  278. 		$sql = "select calendar_id, user_id, date, day, month, year, ";
    279. 

  279. 

  280. 		$i = 0;
    281. 

  281. 		foreach ($slots as $slot){
    282. 

  282. 			if($i == 0)
    283. 

  283. 				$sql = $sql." `".$slot."` ";
    284. 

  284. 			else
    285. 

  285. 				$sql = $sql.", `".$slot."` ";
    286. 

  286. 			$i++;
    287. 

  287. 		}
    288. 

  288. 		$sql = $sql."from `nk_user_calendar` where `user_id` = " .$userid;
    289. 

  289. 		$sql = $sql." and `date` =".$date;
    290. 

  290. 		$handle = mysql_query($sql);
    291. 

  291. 		$row = mysql_fetch_object($handle);
    292. 

  292. 

  293. 		foreach ($slots as $slot){
    294. 

  294. 			$ret[] = new Event($row->$slot, $slot, $row);
    295. 

  295. 

  296. 		}
    297. 

  297. 

  298. 	}catch(Exception $e){
    299. 

  299. 		$ret['error'] = $e->getMessage();
    300. 

  300. 	}
    301. 

  301. 	return $ret;
    302. 

  302. }
    303. 

  303. function getCalendarById($calendarId){
    304. 

  304. 	$ret = array();
    305. 

  305. 	try{
    306. 

  306. 		$db = new DBConnection();
    307. 

  307. 		$db->getConnection();
    308. 

  308. 

  309. 		$sql = "select * from `nk_user_calendar` where `calendar_id` = ".$calendarId;
    310. 

  310. 		$handle = mysql_query($sql);
    311. 

  311. 		return mysql_fetch_object($handle);
    312. 

  312. 

  313. 	}catch(Exception $e){
    314. 

  314. 		$ret['error'] = $e->getMessage();
    315. 

  315. 	}
    316. 

  316. 	return $ret;
    317. 

  317. }
    318. 

  318. 

  319. function getSlotsByCalendarId($calendarId,$slots){
    320. 

  320. 	$ret = array();
    321. 

  321. 	try{
    322. 

  322. 		$db = new DBConnection();
    323. 

  323. 		$db->getConnection();
    324. 

  324. 		$sql = "select calendar_id, user_id, date, day, month, year, ";
    325. 

  325. 		$i = 0;
    326. 

  326. 		foreach ($slots as $slot){
    327. 

  327. 			if($i == 0)
    328. 

  328. 				$sql = $sql." `".$slot."` ";
    329. 

  329. 			else
    330. 

  330. 				$sql = $sql.", `".$slot."` ";
    331. 

  331. 			$i++;
    332. 

  332. 		}
    333. 

  333. 		$sql = $sql."from `nk_user_calendar` where `calendar_id` = ".$calendarId;
    334. 

  334. 		$handle = mysql_query($sql);
    335. 

  335. 		$row = mysql_fetch_object($handle);
    336. 

  336. 		foreach ($slots as $slot){
    337. 

  337. 			$ret[] = new Event($row->$slot, $slot, $row);
    338. 

  338. 		}
    339. 

  339. 

  340. 	}catch(Exception $e){
    341. 

  341. 		$ret['error'] = $e->getMessage();
    342. 

  342. 	}
    343. 

  343. 	return $ret;
    344. 

  344. }
    345. 

  345. 

  346. function listCalendar($userid,$date="0",$timezoneOffset=0){
    347. 

  347. 

  348. 	$ret = array();
    349. 

  349. 	$ret['events'] = array();
    350. 

  350. 	try{
    351. 

  351. 		$db = new DBConnection();
    352. 

  352. 		$db->getConnection();
    353. 

  353. 

  354. 		$sql = "SELECT * FROM `nk_user_calendar` WHERE `user_id` = " .$userid;
    355. 

  355. 		if($date != "0"){
    356. 

  356. 			$sql = $sql." AND `date` = ".$date;
    357. 

  357. 		}
    358. 

  358. 		//logToFile($sql); 
    359. 

  359. 		$handle = mysql_query($sql);
    360. 

  360. 		while ($row = mysql_fetch_object($handle)) {
    361. 

  361.                     $ret['events'][] = array(
    362. 

  362.                         $row->calendar_id,
    363. 

  363.                         $row->user_id,
    364. 

  364.                         $row->date,
    365. 

  365.                         $row->day,
    366. 

  366.                         $row->month,
    367. 

  367.                         $row->year,
    368. 

  368.                         array(
    369. 

  369.                             new Event($row->h0,"h0",$row),
    370. 

  370.                             new Event($row->h1,"h1",$row),
    371. 

  371.                             new Event($row->h2,"h2",$row),
    372. 

  372.                             new Event($row->h3,"h3",$row),new Event($row->h4,"h4",$row),new Event($row->h5,"h5",$row),new Event($row->h6,"h6",$row),new Event($row->h7,"h7",$row),
    373. 

  373.                             new Event($row->h8,"h8",$row),new Event($row->h9,"h9",$row),new Event($row->h10,"h10",$row),new Event($row->h11,"h11",$row),new Event($row->h12,"h12",$row),new Event($row->h13,"h13",$row),new Event($row->h14,"h14",$row),new Event($row->h15,"h15",$row),
    374. 

  374.                             new Event($row->h16,"h16",$row),new Event($row->h17,"h17",$row),new Event($row->h18,"h18",$row),new Event($row->h19,"h19",$row),new Event($row->h20,"h20",$row),new Event($row->h21,"h21",$row),new Event($row->h22,"h22",$row),new Event($row->h23,"h23",$row),
    375. 

  375.                             new Event($row->h24,"h24",$row),new Event($row->h25,"h25",$row),new Event($row->h26,"h26",$row),new Event($row->h27,"h27",$row),new Event($row->h28,"h28",$row),new Event($row->h29,"h29",$row),new Event($row->h30,"h30",$row),new Event($row->h31,"h31",$row),
    376. 

  376.                             new Event($row->h32,"h32",$row),new Event($row->h33,"h33",$row),new Event($row->h34,"h34",$row),new Event($row->h35,"h35",$row),new Event($row->h36,"h36",$row),new Event($row->h37,"h37",$row),new Event($row->h38,"h38",$row),new Event($row->h39,"h39",$row),
    377. 

  377.                             new Event($row->h40,"h40",$row),new Event($row->h41,"h41",$row),new Event($row->h42,"h42",$row),new Event($row->h43,"h43",$row),new Event($row->h44,"h44",$row),new Event($row->h45,"h45",$row),new Event($row->h46,"h46",$row),new Event($row->h47,"h47",$row)
    378. 

  378.                         )
    379. 

  379.                     );
    380. 

  380. 

  381. 		}
    382. 

  382. //		$sql = "SELECT * FROM `nk_user_calendar` WHERE `user_id` = " .$userid;
    383. 

  383. //		if($date != "0"){
    384. 

  384. //                    if($timezoneOffset != 0){
    385. 

  385. //                        $sql = $sql." AND (`date` = ".(intval($date)+(24*3600))." OR `date` = ".(intval($date)-(24*3600)).") ORDER BY `date` ASC";
    386. 

  386. //                        //logToFile($sql); 
    387. 

  387. //                        $handle = mysql_query($sql);
    388. 

  388. //                        while ($row = mysql_fetch_object($handle)) {
    389. 

  389. //                            $ret['events'][($row->date < $date)?'before':'after'] = array(
    390. 

  390. //                                $row->calendar_id,
    391. 

  391. //                                $row->user_id,
    392. 

  392. //                                $row->date,
    393. 

  393. //                                $row->day,
    394. 

  394. //                                $row->month,
    395. 

  395. //                                $row->year,
    396. 

  396. //                                array(
    397. 

  397. //                                    new Event($row->h0,"h0",$row),new Event($row->h1,"h1",$row),new Event($row->h2,"h2",$row),new Event($row->h3,"h3",$row),new Event($row->h4,"h4",$row),new Event($row->h5,"h5",$row),new Event($row->h6,"h6",$row),new Event($row->h7,"h7",$row),
    398. 

  398. //                                    new Event($row->h8,"h8",$row),new Event($row->h9,"h9",$row),new Event($row->h10,"h10",$row),new Event($row->h11,"h11",$row),new Event($row->h12,"h12",$row),new Event($row->h13,"h13",$row),new Event($row->h14,"h14",$row),new Event($row->h15,"h15",$row),
    399. 

  399. //                                    new Event($row->h16,"h16",$row),new Event($row->h17,"h17",$row),new Event($row->h18,"h18",$row),new Event($row->h19,"h19",$row),new Event($row->h20,"h20",$row),new Event($row->h21,"h21",$row),new Event($row->h22,"h22",$row),new Event($row->h23,"h23",$row),
    400. 

  400. //                                    new Event($row->h24,"h24",$row),new Event($row->h25,"h25",$row),new Event($row->h26,"h26",$row),new Event($row->h27,"h27",$row),new Event($row->h28,"h28",$row),new Event($row->h29,"h29",$row),new Event($row->h30,"h30",$row),new Event($row->h31,"h31",$row),
    401. 

  401. //                                    new Event($row->h32,"h32",$row),new Event($row->h33,"h33",$row),new Event($row->h34,"h34",$row),new Event($row->h35,"h35",$row),new Event($row->h36,"h36",$row),new Event($row->h37,"h37",$row),new Event($row->h38,"h38",$row),new Event($row->h39,"h39",$row),
    402. 

  402. //                                    new Event($row->h40,"h40",$row),new Event($row->h41,"h41",$row),new Event($row->h42,"h42",$row),new Event($row->h43,"h43",$row),new Event($row->h44,"h44",$row),new Event($row->h45,"h45",$row),new Event($row->h46,"h46",$row),new Event($row->h47,"h47",$row)
    403. 

  403. //                                )
    404. 

  404. //                            );
    405. 

  405. //                        }
    406. 

  406. //                    }
    407. 

  407. //		}
    408. 

  408. 		
    409. 

  409. 	}catch(Exception $e){
    410. 

  410. 		$ret['error'] = $e->getMessage();
    411. 

  411. 	}
    412. 

  412. 	return $ret;
    413. 

  413. }
    414. 

  414. 

  415. function updateSlots($slots, $requestoruserid, $calendarref, $description,$status="1",$remove=false,$lessonId=0){
    416. 

  416. 	$sl = array();
    417. 

  417. 

  418. 	foreach ($slots as $slot){
    419. 

  419. 		$sl[] = $slot->slot;
    420. 

  420. 	}
    421. 

  421. 	return updateCalendar($slots[0]->userId, $slots[0]->date ,$sl, $status, $slots[0]->description, "0", $slots[0]->gameId, $requestoruserid, $calendarref, $description,false,$lessonId);
    422. 

  422. }
    423. 

  423. 

  424. function updateCalendar($userid,$date,$slots,$status="1",$description="_",$availablespot="1", $gameId="0",$requestoruserid="0",$calendarref="0",$requestorTxt="",$remove=false,$lessonId=0){
    425. 

  425. 	$ret = array();
    426. 

  426. 	try{
    427. 

  427. 		$db = new DBConnection();
    428. 

  428. 		$db->getConnection();
    429. 

  429. 		$event = new Event();
    430. 

  430. 		$event->setEvent($status, $description, $availablespot, $gameId, $requestoruserid, $calendarref, $requestorTxt, $remove,"",$lessonId);
    431. 

  431. 		$sql = "update `nk_user_calendar` set ";
    432. 

  432. 		$i = 0;
    433. 

  433. 		foreach ($slots as $slot){
    434. 

  434. 			if($i == 0)
    435. 

  435. 				$sql = $sql." `".$slot."` = ".$event;
    436. 

  436. 			else
    437. 

  437. 				$sql = $sql.", `".$slot."` = ".$event;
    438. 

  438. 			$i++;
    439. 

  439. 		}
    440. 

  440. 

  441. 		$sql = $sql." where `user_id` = '".$userid."' AND `date` = ".$date;
    442. 

  442. 		if(mysql_query($sql)==false){
    443. 

  443. 			$ret['IsSuccess'] = false;
    444. 

  444. 			$ret['Msg'] = mysql_error();
    445. 

  445. 		}else{
    446. 

  446. 			$ret['IsSuccess'] = true;
    447. 

  447. 			$ret['Msg'] = 'add success';
    448. 

  448. 			$ret['Data'] = $date;
    449. 

  449. 		}
    450. 

  450. 

  451. 	}catch(Exception $e){
    452. 

  452. 		$ret['IsSuccess'] = false;
    453. 

  453. 		$ret['Msg'] = $e->getMessage();
    454. 

  454. 	}
    455. 

  455. 	return $ret;
    456. 

  456. }
    457. 

  457. 

  458. function insertCalendar($userid,$date,$slots,$status="1",$description="_",$availablespot="1", $gameId="0", $requestoruserid="0",$calendarref="0",$requestorTxt="",$lessonId=0){
    459. 

  459. 	$ret = array();
    460. 

  460. 	try{
    461. 

  461. 		$db = new DBConnection();
    462. 

  462. 		$db->getConnection();
    463. 

  463. 

  464. 		list ($day, $month, $year) = split ('-', gmdate('d-m-Y', $date));
    465. 

  465. 		$event = new Event();
    466. 

  466. 		//setEvent($status="",$description="",$availableSpot="",$gameId="", $requestoruserId="",$calendarRef="",$requestorTxt="",$isEmpty=0,$slot="",$lessonId="")
    467. 

  467. 		$event->setEvent($status,$description,$availablespot,$gameId,$requestoruserid,$calendarref,$requestorTxt,0,"",$lessonId);
    468. 

  468. 		$sql = "insert into `nk_user_calendar` (`user_id`, `date`, `day`, `month`,`year`";
    469. 

  469. 

  470. 		foreach ($slots as $slot){
    471. 

  471. 			$sql = $sql.",`".$slot."`";
    472. 

  472. 		}
    473. 

  473. 		$sql =  $sql.") values ('".$userid."', ".$date.", '".$day."', '".$month."', '".$year."'";
    474. 

  474. 

  475. 		foreach ($slots as $slot){
    476. 

  476. 			$sql = $sql.", ".$event."";
    477. 

  477. 		}
    478. 

  478. 		$sql = $sql.")";
    479. 

  479. 		if(mysql_query($sql)==false){
    480. 

  480. 			$ret['IsSuccess'] = false;
    481. 

  481. 			$ret['Msg'] = mysql_error();
    482. 

  482. 		}else{
    483. 

  483. 			$ret['IsSuccess'] = true;
    484. 

  484. 			$ret['Msg'] = 'add success';
    485. 

  485. 			$ret['Data'] = $date;
    486. 

  486. 			$ret['Id'] = mysql_insert_id();
    487. 

  487. 		}
    488. 

  488. 

  489. 	}catch(Exception $e){
    490. 

  490. 		$ret['IsSuccess'] = false;
    491. 

  491. 		$ret['Msg'] = $e->getMessage();
    492. 

  492. 	}
    493. 

  493. 	return $ret;
    494. 

  494. }
    495. 

  495. 

  496. 

  497. function getMonthCalendar($userid){
    498. 

  498. 	$events = array();
    499. 

  499. 	$fullCalendar = listCalendar($userid);
    500. 

  500. 

  501. 	if (empty($fullCalendar))
    502. 

  502. 		return "{}";
    503. 

  503. 	if(!array_key_exists("events", $fullCalendar))
    504. 

  504. 		return "{}";
    505. 

  505. 

  506. 	$ret ="{";
    507. 

  507. 	$i = 0;
    508. 

  508. 	foreach ($fullCalendar['events'] as $event) {
    509. 

  509. 		list ($day, $month,$year) = split ('-', gmdate('d-m-Y',$event[2]));
    510. 

  510. 		$key = "D".$day."_".$month."_".$year;
    511. 

  511. 		$sizeof_day = sizeof($event);
    512. 

  512. 		$notEmptySpots = 0;
    513. 

  513. 		$availableSpots = 0;
    514. 

  514. 		foreach ($event[6] as &$hour){
    515. 

  515. 			if($hour->isEmpty)
    516. 

  516. 				continue;
    517. 

  517. 			$notEmptySpots++;
    518. 

  518. 			if($hour->availableSpot == 1){
    519. 

  519. 				$availableSpots++;
    520. 

  520. 				continue;
    521. 

  521. 			}
    522. 

  522. 		}
    523. 

  523. 		if($i != 0)
    524. 

  524. 			$ret = $ret.',';
    525. 

  525. 

  526. 		if($notEmptySpots == 0){
    527. 

  527. 			$ret = $ret.'"'.$key.'":"NOT_AVAILABLE"';
    528. 

  528. 		}else if($availableSpots == $notEmptySpots){
    529. 

  529. 			$ret = $ret.'"'.$key.'":"ALL_FREE"';
    530. 

  530. 		}else if($availableSpots == 0){
    531. 

  531. 			$ret = $ret.'"'.$key.'":"ALL_BOOKED"';
    532. 

  532. 		}else {
    533. 

  533. 			$ret = $ret.'"'.$key.'":"AVAILABLE_SPOTS"';
    534. 

  534. 		}
    535. 

  535. 		$i++;
    536. 

  536. 	}
    537. 

  537. 	$ret = $ret."}";
    538. 

  538. 	return $ret;
    539. 

  539. }
    540. 

  540. 

  541. function changeStatus($id, $userid, $status){
    542. 

  542. 	//TODO
    543. 

  543. }
    544. 

  544. 

  545. function acceptSchedule($id, $userid){
    546. 

  546. 	//TODO
    547. 

  547. }
    548. 

  548. 

  549. function addSlots($date, $schedules, $userid, $description,$overwrite,$games){
    550. 

  550. 

  551. 	$ret = array();
    552. 

  552. 	$slots = getSlotsArray($schedules);
    553. 

  553. 	$event = listCalendar($userid,$date);
    554. 

  554. 	$sizeof_day = sizeof($event);
    555. 

  555. 

  556. 	if(sizeof($event['events']) == 0){
    557. 

  557. 		$ret = insertCalendar($userid, $date ,$slots, 1, $description, 1,$games);
    558. 

  558. 	}else{
    559. 

  559. 		if($overwrite == 0){
    560. 

  560. 			$times = split(',', $schedules);
    561. 

  561. 			foreach ($times as $time){
    562. 

  562.                             $e = $event['events'][0][6][$time];
    563. 

  563. //				if(!$event['events'][0][6][$time]->isEmpty){
    564. 

  564.                                 if(!$e->isEmpty && $e->availableSpot != 1){
    565. 

  565. 					$ret['IsSuccess'] = false;
    566. 

  566. 					$ret['ErrorCode'] = ErrorCode::$ALREADY_USED;
    567. 

  567. 					return $ret;
    568. 

  568. 				}
    569. 

  569. 			}
    570. 

  570. 		}
    571. 

  571. 		$ret = updateCalendar($userid,$date,$slots,"1",$description,"1",$games);
    572. 

  572. 	}
    573. 

  573. 	return $ret;
    574. 

  574. }
    575. 

  575. 

  576. function cancel($userid,$date,$schedules,$cancelClientEvents="0", $offSet=0){//TODO: Agrupar slots por
    577. 

  577. 	try{
    578. 

  578. 		$ret = array();
    579. 

  579. 		$warnList = array();
    580. 

  580. 		$lessonList = array();
    581. 

  581. 		$clientEvents = array();
    582. 

  582. 		$users = array();
    583. 

  583. 		
    584. 

  584. 		$loggedUser = $_SESSION['ch_user'];
    585. 

  585. 		$slots = getSlotsArray($schedules);
    586. 

  586. 		$event = getSlots($userid, $date, $slots);//gets the data from the selected slots
    587. 

  587. 		if(sizeof($event) == 0){
    588. 

  588. 			$ret['IsSuccess'] = false;
    589. 

  589. 			$ret['ErrorCode'] = ErrorCode::$NO_EVENTS;
    590. 

  590. 			return $ret;
    591. 

  591. 		}else{
    592. 

  592. 			if($cancelClientEvents == 0){
    593. 

  593. 				foreach ($event as $e){
    594. 

  594. 					if(!$e->isEmpty && $e->availableSpot != 1){
    595. 

  595. 						$ret['IsSuccess'] = false;
    596. 

  596. 						$ret['ErrorCode'] = ErrorCode::$ALREADY_SCHEDULED;
    597. 

  597. 						return $ret;
    598. 

  598. 					}
    599. 

  599. 				}
    600. 

  600. 			}else{
    601. 

  601. 				$usersEvents = array();
    602. 

  602. 				foreach ($event as $evn){
    603. 

  603.                                     //TODO: Check events with offset
    604. 

  604. 					$events = getSlotsByCalendarId($evn->calendarRef,$slots);
    605. 

  605. 

  606. 					foreach ($events as $ev){
    607. 

  607. 						$usersEvents[$ev->userId][]= $ev;
    608. 

  608. 					}
    609. 

  609. 				}
    610. 

  610. 				foreach ($usersEvents as $userEvents){
    611. 

  611. 					$res = updateStatus($userEvents, Status::$DELETED);
    612. 

  612. 					if(!in_array($userEvents[0]->userId, $lessonList)){
    613. 

  613. 						$lessonList[] = $userEvents[0]->lessonId;
    614. 

  614. 					}
    615. 

  615. 				}
    616. 

  616. 			}
    617. 

  617. 			$ret = updateCalendar($userid,$date,$slots,"1","","","","","","",true);
    618. 

  618. 			
    619. 

  619. 			foreach ($lessonList as $lessonId){
    620. 

  620. 				$lesson = getLesson($lessonId);
    621. 

  621. 				changeLessonStatus($lessonId, LessonStatus::CANCELED);
    622. 

  622. 				$rate = $lesson->rate;
    623. 

  623.                                 $returnValue = sizeof($event) * $rate;
    624. 

  624.                                 
    625. 

  625. 				if($lesson->coach_id == $_SESSION['user_id']){
    626. 

  626. 					$user = getUserInfo($lesson->student_id);
    627. 

  627.                                            
    628. 

  628.                                         insertTransaction($user->user_id, TransactionStatus::ACTIVE, TransactionType::CREDIT_REFUND, $returnValue, $user->total_points, UserType::STUDENT, ("Refund from canceled lesson from ".$loggedUser['username']));
    629. 

  629. 					insertTransaction($_SESSION['user_id'], TransactionStatus::ACTIVE, TransactionType::DEBIT_REFUND, $returnValue, $loggedUser['total_points'],UserType::COACH, ("Refund from canceled lesson to ".$user->username));
    630. 

  630. 				}else if($lesson->student_id == $_SESSION['user_id']){
    631. 

  631. 					$user = getUserInfo($lesson->coach_id);
    632. 

  632.                                         
    633. 

  633.                                         insertTransaction($user->user_id, TransactionStatus::ACTIVE, TransactionType::DEBIT_REFUND, $returnValue, $user->total_points,UserType::COACH, ("Refund from canceled lesson to ".$loggedUser['username']));
    634. 

  634. 					insertTransaction($_SESSION['user_id'], TransactionStatus::ACTIVE, TransactionType::CREDIT_REFUND, $returnValue, $loggedUser['total_points'],UserType::STUDENT, ("Refund from canceled lesson from ".$user->username));
    635. 

  635. 				}else{
    636. 

  636. 					echo "\n----- BAD NEWS!! -----\n";
    637. 

  637. 				}
    638. 

  638. 				
    639. 

  639. 				insertNotifications($user->id, NotificationTypes::$SCHEDULE_ALERT, $userid, "Schedule", "", "User ".$user->username." has canceled a schedule, please check your calendar","","/schedule.php");
    640. 

  640. 

  641. 			}
    642. 

  642. 			
    643. 

  643. 		}
    644. 

  644. 	}catch(Exception $e){
    645. 

  645. 		$ret['IsSuccess'] = false;
    646. 

  646. 		$ret['Msg'] = $e->getMessage();
    647. 

  647. 	}
    648. 

  648. 	return $ret;
    649. 

  649. }
    650. 

  650. 

  651. function updateStatus($slots, $status){
    652. 

  652. 	$sl = array();
    653. 

  653. 	foreach ($slots as $slot){
    654. 

  654. 		$sl[] = $slot->slot;
    655. 

  655. 	}
    656. 

  656. 

  657. 	return updateCalendar($slots[0]->userId, $slots[0]->date ,$sl, $status, $slots[0]->description, "0", $slots[0]->gameId, $slots[0]->requestoruserId, $slots[0]->calendarref, $slots[0]->requestorTxt);
    658. 

  658. }
    659. 

  659. 

  660. function getSequenceOfRequestor($index,$calendarId){
    661. 

  661. 	$events = getAllSlotsByCalendarId($calendarId);
    662. 

  662. 	$mainevent = $events[$index];
    663. 

  663. 	$requestor = $mainevent->requestoruserId;
    664. 

  664. 

  665. 	$slots = array();
    666. 

  666. 	$slots[]=$mainevent->slot;
    667. 

  667. 	$ret = ($index<10?"0".$index:$index);
    668. 

  668. 	for ($i = ($index+1); $i < 48; $i++) {
    669. 

  669. 		if(!$events[$i]->isEmpty){
    670. 

  670. 			if($events[$i]->requestoruserId == $requestor){
    671. 

  671. 				$ret = $ret."#".($i<10?"0".$i:$i);
    672. 

  672. 			}else
    673. 

  673. 				break;
    674. 

  674. 		}else
    675. 

  675. 			break;
    676. 

  676. 	}
    677. 

  677. 

  678. 	for ($i = ($index-1); $i >= 0; $i--) {
    679. 

  679. 		if(!$events[$i]->isEmpty){
    680. 

  680. 			if($events[$i]->requestoruserId == $requestor){
    681. 

  681. 				$ret = $ret."#".($i<10?"0".$i:$i);
    682. 

  682. 			}else
    683. 

  683. 				break;
    684. 

  684. 		}else
    685. 

  685. 			break;
    686. 

  686. 	}
    687. 

  687. 	return '{"values":"'.$ret.'"}';
    688. 

  688. }
    689. 

  689. 

  690. function getSequenceOfCalendarRef($index,$calendarId){
    691. 

  691. 	$events = getAllSlotsByCalendarId($calendarId);
    692. 

  692. 	$mainevent = $events[$index];
    693. 

  693. 	$calendarRef = $mainevent->calendarRef;
    694. 

  694. 

  695. 	$slots = array();
    696. 

  696. 	$slots[]=$mainevent->slot;
    697. 

  697. 	$ret = ($index<10?"0".$index:$index);
    698. 

  698. 	for ($i = ($index+1); $i < 48; $i++) {
    699. 

  699. 		if(!$events[$i]->isEmpty){
    700. 

  700. 			if($events[$i]->calendarRef == $calendarRef){
    701. 

  701. 				$ret = $ret."#".($i<10?"0".$i:$i);
    702. 

  702. 			}else
    703. 

  703. 				break;
    704. 

  704. 		}else
    705. 

  705. 			break;
    706. 

  706. 	}
    707. 

  707. 	for ($i = ($index-1); $i >= 0; $i--) {
    708. 

  708. 		if(!$events[$i]->isEmpty){
    709. 

  709. 			if($events[$i]->calendarRef == $calendarRef){
    710. 

  710. 				$ret = $ret."#".($i<10?"0".$i:$i);
    711. 

  711. 			}else
    712. 

  712. 				break;
    713. 

  713. 		}else
    714. 

  714. 			break;
    715. 

  715. 	}
    716. 

  716. 	return '{"values":"'.$ret.'"}';
    717. 

  717. }
    718. 

  718. 

  719. function getSlotsArray($schedules,$offSet=0){
    720. 

  720. 	$times = split(',', $schedules);
    721. 

  721. 	foreach ($times as $time){
    722. 

  722. 		$slots[] = Constants::$SLOTS_ARRAY[$time - $offSet];
    723. 

  723. 	}
    724. 

  724. 	return $slots;
    725. 

  725. }
    726. 

  726. 

  727. 

  728. function getDateFromTimeAndSlot($date, $schedules){
    729. 

  729.     $ret = array();
    730. 

  730.     $d = gmdate("Y-m-d",$date);
    731. 

  731.     $times = split(',', $schedules);
    732. 

  732. 

  733.     $ret['start'] = $d." ".Constants::$TIMES_ARRAY[$times[0]];
    734. 

  734.     $ret['end'] = $d." ".Constants::$TIMES_ARRAY[$times[(sizeof($times)-1)]+1];
    735. 

  735.     return $ret;
    736. 

  736. 

  737. }
    738. 

  738. 

  739. function checkIfAlreadyUsed($date,$schedules,$offSet=0){
    740. 

  740.     
    741. 

  741.     $event = listCalendar($_SESSION['user_id'],$date);
    742. 

  742.     if(sizeof($event['events']) > 0){
    743. 

  743.         $times = split(',', $schedules);
    744. 

  744.         foreach ($times as $time){
    745. 

  745.                 if(!$event['events'][0][6][$time - $offSet]->isEmpty){
    746. 

  746.                         $ret['IsSuccess'] = false;
    747. 

  747.                         $ret['ErrorCode'] = ErrorCode::$ALREADY_USED;
    748. 

  748.                         return $ret;
    749. 

  749.                 }
    750. 

  750.         }
    751. 

  751.     }
    752. 

  752. 

  753.     $ret['IsSuccess'] = true;
    754. 

  754.     return $ret;
    755. 

  755. }
    756. 

  756. function scheduleLesson($userid, $date, $schedules, $description, $gameId, $total, $studentPoints, $coachPoints,$requestorname,$coachname,$rate,$offSet=0,$sendEmail="0",$email=""){
    757. 

  757. 	
    758. 

  758.     $ret = array();
    759. 

  759.     $times = split(',', $schedules);
    760. 

  760.     $s = sizeof($times);
    761. 

  761.     
    762. 

  762.     $schedulesArray = array();
    763. 

  763.     $j = 0;
    764. 

  764.     for ($i=0; $i<= ($s-1); $i++){
    765. 

  765.         $schVar = intval($times[$i]);
    766. 

  766.         $beforeSchVar = 0;
    767. 

  767.         if($i > 0){
    768. 

  768.             $beforeSchVar = intval($times[$i-1]);
    769. 

  769.         }
    770. 

  770.         if(($schVar-$beforeSchVar) > 1){
    771. 

  771.             $j++;
    772. 

  772.             $schedulesArray[$j][]=$schVar;
    773. 

  773.             continue;
    774. 

  774.         }
    775. 

  775.         $schedulesArray[$j][]=$schVar;
    776. 

  776.     }
    777. 

  777.     
    778. 

  778.     foreach($schedulesArray as $scd){
    779. 

  779.         
    780. 

  780.         $schedulesX = implode(",", $scd);
    781. 

  781. 	$slots = getSlotsArray($schedulesX);
    782. 

  782.         
    783. 

  783.         $slotsStudent = getSlotsArray($schedulesX,$offSet);
    784. 

  784.         
    785. 

  785. 	$calendarRef = "0";
    786. 

  786. 	$event = listCalendar($_SESSION['user_id'],$date);
    787. 

  787. 	$events = getSlots($userid,$date,$slots);
    788. 

  788.         
    789. 

  789.         $eventsStudent = getSlots($userid,$date,$slotsStudent);
    790. 

  790.         
    791. 

  791. 	$hours = sizeof($slots);
    792. 

  792. 	$startEnd = getDateFromTimeAndSlot($date, $schedulesX);
    793. 

  793.         $lessonPrice = ($rate * sizeof($scd))/2;
    794. 

  794.         $lesson = insertLesson($lessonPrice, $rate, $userid, $_SESSION['user_id'], $gameId, ($hours/2), LessonStatus::OPEN, ($offSet/2),$startEnd['start'], $startEnd['end']);
    795. 

  795.         $lessonId = $lesson['lessonId'];
    796. 

  796.         if(sizeof($event['events']) > 0){
    797. 

  797.                 //If a record for the day already exists, it just updates the selected spots
    798. 

  798. 		$result = updateCalendar($_SESSION['user_id'], $date ,$slotsStudent,Status::$ACTIVE,$description,"0",$events[0]->gameId,$_SESSION['user_id'],$events[0]->calendarId,"",false,$lessonId);
    799. 

  799. 		$calendarRef = $event['events'][0][0];
    800. 

  800. 	}else{
    801. 

  801.                 $ret = insertCalendar($_SESSION['user_id'], $date ,$slotsStudent, "2", $description,"0",$gameId,$_SESSION['user_id'], $events[0]->calendarId,"",$lessonId);
    802. 

  802. 		$calendarRef = $ret['Id'];
    803. 

  803. 	}
    804. 

  804.         //Updating coach calendar
    805. 

  805. 	$ret = updateSlots($events, $_SESSION['user_id'], $calendarRef, $description, Status::$ACTIVE,false, $lessonId);
    806. 

  806. 	if($ret['IsSuccess']){
    807. 

  807. 		$desc = "Lesson, coach: ".$coachname;
    808. 

  808.                 $ch_user = getUserInfo($_SESSION['user_id']);
    809. 

  809. 		$studentTransaction = insertTransaction($_SESSION['user_id'], TransactionStatus::BOOKED, TransactionType::DEBIT, $lessonPrice, $ch_user->total_points,0.0, UserType::STUDENT, $desc);
    810. 

  810. 		if($studentTransaction['IsSuccess'])
    811. 

  811.                     $studentPoints = $studentTransaction['newpoints'];
    812. 

  812.                 
    813. 

  813.                 $user = getUserInfo($userid);
    814. 

  814. 		$descr = "Lesson, student: ".$requestorname;
    815. 

  815. 		$coachTransaction = insertTransaction($userid, TransactionStatus::BOOKED, TransactionType::CREDIT, $lessonPrice, $user->total_points, floatval($lesson['commision']) , UserType::COACH, $descr);
    816. 

  816.                 if($coachTransaction['IsSuccess'])
    817. 

  817.                     $coachPoints = $coachTransaction['newpoints'];
    818. 

  818.                 
    819. 

  819.                 if($sendEmail == "1"){
    820. 

  820.                     sendScheduleEmail($email, $coachname, "Chiron Gaming - Schedule","scheduled",$ch_user->username, $startEnd['start']." - ".$startEnd['end']);
    821. 

  821.                 }
    822. 

  822. 	}
    823. 

  823.     }
    824. 

  824.     insertNotifications($userid, 1, $_SESSION['user_id'], "Schedule", "", "User ".$requestorname." has schedule a lesson, please check your calendar","","/schedule.php");
    825. 

  825.     return $ret;
    826. 

  826. }
    827. 

  827. 

  828. 

  829. function sendScheduleEmail($to,$toName,$subject,$action,$fromName,$date){
    830. 

  830.     
    831. 

  831.     $TemplateFile="email_templates/schedule_notification.html";
    832. 

  832.     $TemplateFileHandler=fopen($TemplateFile,"r");
    833. 

  833.     $TemplateMessage=fread($TemplateFileHandler,filesize($TemplateFile));
    834. 

  834.     fclose($TemplateFileHandler);
    835. 

  835. 

  836.     $TemplateMessage=str_replace("[TO]",$toName,$TemplateMessage);
    837. 

  837.     $TemplateMessage=str_replace("[FROM]",$fromName,$TemplateMessage);
    838. 

  838.     $TemplateMessage=str_replace("[ACTION]",$action,$TemplateMessage);
    839. 

  839.     $TemplateMessage=str_replace("[DATE]",$date,$TemplateMessage);
    840. 

  840.     
    841. 

  841.     sendEmail($to,$subject,$TemplateMessage);
    842. 

  842. }
    843. 

  843. 

  844. function getUserInfo($userId){
    845. 

  845. 	try{
    846. 

  846. 		$db = new DBConnection();
    847. 

  847. 		$db->getConnection();
    848. 

  848. 		$sql = "SELECT * FROM `nk_user` WHERE `user_id` = '".$userId."'";
    849. 

  849. 		$handle = mysql_query($sql);
    850. 

  850. 		$row = mysql_fetch_object($handle);
    851. 

  851. 		
    852. 

  852. 		return $row;
    853. 

  853. 

  854. 	}catch(Exception $e){
    855. 

  855. 		return  $e->getMessage();
    856. 

  856. 	}
    857. 

  857. }
    858. 

  858. 

  859. function getGames(){
    860. 

  860. 	$ret = array();
    861. 

  861. 	try{
    862. 

  862. 		$db = new DBConnection();
    863. 

  863. 		$db->getConnection();
    864. 

  864. 		$sql = "SELECT * FROM `nk_game`";
    865. 

  865. 		$handle = mysql_query($sql);
    866. 

  866. 		$rows = array();
    867. 

  867. 		while ($games = mysql_fetch_object($handle)) {
    868. 

  868. 			$ret[]=$games;
    869. 

  869. 		}
    870. 

  870. 		return $ret;
    871. 

  871. 	}catch(Exception $e){
    872. 

  872. 		return  $e->getMessage();
    873. 

  873. 	}
    874. 

  874. }
    875. 

  875. 

  876. function getGame($gameId){
    877. 

  877. 	$ret = array();
    878. 

  878. 	try{
    879. 

  879. 		$db = new DBConnection();
    880. 

  880. 		$db->getConnection();
    881. 

  881. 		$sql = "SELECT * FROM `nk_game` where game_id = ".$gameId;
    882. 

  882. 		$handle = mysql_query($sql);
    883. 

  883. 		return mysql_fetch_object($handle);
    884. 

  884. 	}catch(Exception $e){
    885. 

  885. 		return  $e->getMessage();
    886. 

  886. 	}
    887. 

  887. }
    888. 

  888. 

  889. function getUserFullInfo($userId){//TODO: separate in 3 functions
    890. 

  890. 	try{
    891. 

  891. 		$db = new DBConnection();
    892. 

  892. 		$db->getConnection();
    893. 

  893. 		$sql = "SELECT * FROM `nk_user` WHERE `user_id` = '".$userId."'";
    894. 

  894. 		$handle = mysql_query($sql);
    895. 

  895. 		$row = mysql_fetch_object($handle);
    896. 

  896. 		$row->onlinestatus = getUserStatusObject($row);
    897. 

  897. 		$sql = "SELECT ut.user_type_id, ut.user_type_name, ut.user_type_description  FROM nk_user_type_user_relation utr, nk_user_type ut WHERE utr.user_type_id = ut.user_type_id AND utr.user_id =".$row->user_id;
    898. 

  898. 		$handle = mysql_query($sql);
    899. 

  899. 		$row->user_types = array();
    900. 

  900. 		while ($types = mysql_fetch_object($handle)) {
    901. 

  901. 			$row->user_types[]=$types;
    902. 

  902. 		}
    903. 

  903. 

  904. 		$sql = "SELECT * FROM nk_game g, nk_user_game ug WHERE g.game_id = ug.game_id AND ug.user_type_id = 1 AND ug.user_id =".$row->user_id;
    905. 

  905. 

  906. 		$handle = mysql_query($sql);
    907. 

  907. 		$row->games = array();
    908. 

  908. 		while ($games = mysql_fetch_object($handle)) {
    909. 

  909. 			$row->games[]=$games;
    910. 

  910. 		}
    911. 

  911. 

  912. 		if($userId == $_SESSION['user_id'])
    913. 

  913. 			$row->owncalendar = '1';
    914. 

  914. 		else{
    915. 

  915. 			$row->owncalendar = '0';
    916. 

  916. 			$sql = "SELECT * FROM `nk_user` WHERE `user_id` = '".$_SESSION['user_id']."'";
    917. 

  917. 			$handle = mysql_query($sql);
    918. 

  918. 			$row->loggedUser = mysql_fetch_object($handle);
    919. 

  919. 		}
    920. 

  920. 		
    921. 

  921. 		return $row;
    922. 

  922. 	}catch(Exception $e){
    923. 

  923. 		return  $e->getMessage();
    924. 

  924. 	}
    925. 

  925. }
    926. 

  926. 

  927. function updateScheduleStatus($id, $startTime, $endTime, $status){
    928. 

  928. 

  929. }
    930. 

  930. function removeSlots($userid,$date,$schedules){
    931. 

  931. 	$slots = getSlotsArray($schedules);
    932. 

  932. 	$ret = updateCalendar($userid,$date,$slots,"1","","","","","","",true);
    933. 

  933. }
    934. 

  934. 

  935. function getUsers(){
    936. 

  936. 	try{
    937. 

  937. 		$db = new DBConnection();
    938. 

  938. 		$db->getConnection();
    939. 

  939. 

  940. 		$sql = "select * from `nk_user`";
    941. 

  941. 		$handle = mysql_query($sql);
    942. 

  942. 		echo "<br/>";
    943. 

  943. 		while ($row = mysql_fetch_object($handle)) {
    944. 

  944. 			echo "<a onclick=\"showCalendar('".$row->user_id."');\" id=\"calendar_".$row->user_id."\" href=\"javascript:;\">".$row->user_id." - ".$row->email."</a>";
    945. 

  945. 			echo "<br/>";
    946. 

  946. 		}
    947. 

  947. 	}catch(Exception $e){
    948. 

  948. 		$ret['error'] = $e->getMessage();
    949. 

  949. 	}
    950. 

  950. }
    951. 

  951. 

  952. 

  953. function getNotifications(){
    954. 

  954. 	$ret = array();
    955. 

  955. 	$ret['notifications'] = array();
    956. 

  956. 	try{
    957. 

  957. 		$db = new DBConnection();
    958. 

  958. 		$db->getConnection();
    959. 

  959. 		//Notification
    960. 

  960. 		$sql = "select * from `nk_notification` where `user_id` = " .$_SESSION['user_id'];
    961. 

  961. 

  962. 		$sql = $sql." order by `modified_date` DESC";
    963. 

  963. 		$handle = mysql_query($sql);
    964. 

  964. 		$unread = 0;
    965. 

  965. 		while ($row = mysql_fetch_object($handle)) {
    966. 

  966. 			if($row->new == 'Y')
    967. 

  967. 				$unread++;
    968. 

  968. 			$ret['notifications'][] = array(new Notification($row));
    969. 

  969. 		}
    970. 

  970. 		$ret['unreaded'] = $unread;
    971. 

  971.                 
    972. 

  972.                 $sql = "SELECT * FROM ".TABLEPREFIX."_user WHERE user_id = ".$_SESSION['user_id'];
    973. 

  973.                 $handle = mysql_query($sql);
    974. 

  974.                 $_SESSION['ch_user'] = mysql_fetch_array($handle);
    975. 

  975. 

  976. 	}catch(Exception $e){
    977. 

  977. 		$ret['error'] = $e->getMessage();
    978. 

  978. 	}
    979. 

  979. 	return $ret;
    980. 

  980. }
    981. 

  981. 

  982. 

  983. function updateNotifications($userId, $title="", $introduction="", $text="", $date=""){//TODO
    984. 

  984. 	$ret = array();
    985. 

  985. 	try{
    986. 

  986. 		$db = new DBConnection();
    987. 

  987. 		$db->getConnection();
    988. 

  988. 		$sql = "update `nk_notification` set ";
    989. 

  989. 		if($title != "")
    990. 

  990. 			$sql = $sql.",`title` = ";
    991. 

  991. 		if($introduction != "")
    992. 

  992. 			$sql = $sql.",`introduction`";
    993. 

  993. 		if($text != "")
    994. 

  994. 			$sql = $sql.",`text`";
    995. 

  995. 		if($date != "")
    996. 

  996. 			$sql = $sql.",`date_value`";
    997. 

  997. 

  998. 		$sql = $sql.",`modified_date`,`creation_date`) VALUES (".$userId;
    999. 

  999. 

  1000. 		if($title != "")
    1001. 

  1001. 			$sql = $sql.",'".$title."'";
    1002. 

  1002. 		if($introduction != "")
    1003. 

  1003. 			$sql = $sql.",'".$introduction."'";
    1004. 

  1004. 		if($text != "")
    1005. 

  1005. 			$sql = $sql.",'".$text."'";
    1006. 

  1006. 		if($date != "")
    1007. 

  1007. 			$sql = $sql.",'".php2MySqlTime(js2PhpTime($date))."'";
    1008. 

  1008. 

  1009. 		$sql = $sql.",SYSDATE(), SYSDATE());";
    1010. 

  1010. 

  1011. 		// 		echo $sql;
    1012. 

  1012. 		if(mysql_query($sql)==false){
    1013. 

  1013. 			$ret['IsSuccess'] = false;
    1014. 

  1014. 			$ret['Msg'] = mysql_error();
    1015. 

  1015. 		}else{
    1016. 

  1016. 			$ret['IsSuccess'] = true;
    1017. 

  1017. 			$ret['Msg'] = 'add success';
    1018. 

  1018. 			$ret['Data'] = $date;
    1019. 

  1019. 			$ret['Id'] = mysql_insert_id();
    1020. 

  1020. 		}
    1021. 

  1021. 

  1022. 	}catch(Exception $e){
    1023. 

  1023. 		$ret['IsSuccess'] = false;
    1024. 

  1024. 		$ret['Msg'] = $e->getMessage();
    1025. 

  1025. 	}
    1026. 

  1026. 

  1027. 	return $ret;
    1028. 

  1028. }
    1029. 

  1029. 

  1030. function insertNotifications($userId, $type=1, $origin="" , $title="", $introduction="", $text="", $date="",$link="",$extra_data="", $sendmail=false,$user=null){ 
    1031. 

  1031. 	$ret = array();
    1032. 

  1032. 	try{
    1033. 

  1033. 		$db = new DBConnection();
    1034. 

  1034. 		$db->getConnection();
    1035. 

  1035. 		$sql = "INSERT INTO `nk_notification` (`user_id`,`nofication_type`";
    1036. 

  1036. 		if($origin != "")
    1037. 

  1037. 			$sql = $sql.",`origin`";
    1038. 

  1038. 		if($title != "")
    1039. 

  1039. 			$sql = $sql.",`title`";
    1040. 

  1040. 		if($introduction != "")
    1041. 

  1041. 			$sql = $sql.",`introduction`";
    1042. 

  1042. 		if($text != "")
    1043. 

  1043. 			$sql = $sql.",`text`";
    1044. 

  1044. 		if($date != "")
    1045. 

  1045. 			$sql = $sql.",`date_value`";
    1046. 

  1046. 		if($link != "")
    1047. 

  1047. 			$sql = $sql.",`link`";
    1048. 

  1048. 		if($extra_data != "")
    1049. 

  1049. 			$sql = $sql.",`extra_data`";
    1050. 

  1050. 

  1051. 		$sql = $sql.",`modified_date`,`creation_date`) VALUES (".$userId.",".$type;
    1052. 

  1052. 

  1053. 		if($origin != "")
    1054. 

  1054. 			$sql = $sql.",'".$origin."'";
    1055. 

  1055. 		if($title != "")
    1056. 

  1056. 			$sql = $sql.",'".$title."'";
    1057. 

  1057. 		if($introduction != "")
    1058. 

  1058. 			$sql = $sql.",'".$introduction."'";
    1059. 

  1059. 		if($text != "")
    1060. 

  1060. 			$sql = $sql.",'".$text."'";
    1061. 

  1061. 		if($date != "")
    1062. 

  1062. 			$sql = $sql.",'".php2MySqlTime(js2PhpTime($date))."'";
    1063. 

  1063. 		if($link != "")
    1064. 

  1064. 			$sql = $sql.",'".$link."'";
    1065. 

  1065. 		if($extra_data != "")
    1066. 

  1066. 			$sql = $sql.",'".$extra_data."'";
    1067. 

  1067. 			
    1068. 

  1068. 		$sql = $sql.",NOW(), NOW());";
    1069. 

  1069. 		
    1070. 

  1070. //		logToFile($sql);		
    1071. 

  1071. 		
    1072. 

  1072. 		if(mysql_query($sql)==false){
    1073. 

  1073. 			$ret['IsSuccess'] = false;
    1074. 

  1074. 			$ret['Msg'] = mysql_error();
    1075. 

  1075. 		}else{
    1076. 

  1076. 			$ret['IsSuccess'] = true;
    1077. 

  1077. 			$ret['Msg'] = 'add success';
    1078. 

  1078. 			$ret['Data'] = $date;
    1079. 

  1079. 			$ret['Id'] = mysql_insert_id();
    1080. 

  1080. 		}
    1081. 

  1081. 		
    1082. 

  1082. 	}catch(Exception $e){
    1083. 

  1083. 		$ret['IsSuccess'] = false;
    1084. 

  1084. 		$ret['Msg'] = $e->getMessage();
    1085. 

  1085. 	}
    1086. 

  1086.         if($sendmail){
    1087. 

  1087.             $body = "<h1></h1>
    1088. 

  1088.                 <div>Hi ".$user->username."<br/></div>
    1089. 

  1089.             ";
    1090. 

  1090.             sendEmail($mail, $title,($link));
    1091. 

  1091.         }
    1092. 

  1092.             
    1093. 

  1093. 	return $ret;
    1094. 

  1094. 

  1095. }
    1096. 

  1096. 

  1097. function sendEmail($to,$subject,$body, $from=""){
    1098. 

  1098.     
    1099. 

  1099.     if($from == "")
    1100. 

  1100.         $from = "no-reply@chirongaming.com";
    1101. 

  1101.     
    1102. 

  1102.     $headers  = 'MIME-Version: 1.0' . "\r\n";
    1103. 

  1103.     $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    1104. 

  1104.     $headers .= 'From: Chirongamming <no-reply@chirongaming.com>';
    1105. 

  1105.     mail($to, $subject, $body, $headers);
    1106. 

  1106. }
    1107. 

  1107. 

  1108. function markAsRead($ids){
    1109. 

  1109. 	$ret = array();
    1110. 

  1110. 	try{
    1111. 

  1111. 		$db = new DBConnection();
    1112. 

  1112. 		$db->getConnection();
    1113. 

  1113. 

  1114. 		$sql = "update `nk_notification` set `new` = 'N', `date_readed` = SYSDATE()  where `notification_id` in (".str_replace('#',',',$ids).")";
    1115. 

  1115. 

  1116. 		if(mysql_query($sql)==false){
    1117. 

  1117. 			$ret['IsSuccess'] = false;
    1118. 

  1118. 			$ret['Msg'] = mysql_error();
    1119. 

  1119. 		}else{
    1120. 

  1120. 			$ret['IsSuccess'] = true;
    1121. 

  1121. 			$ret['Msg'] = 'add success';
    1122. 

  1122. 		}
    1123. 

  1123. 

  1124. 	}catch(Exception $e){
    1125. 

  1125. 		$ret['IsSuccess'] = false;
    1126. 

  1126. 		$ret['Msg'] = $e->getMessage();
    1127. 

  1127. 	}
    1128. 

  1128. 	return $ret;
    1129. 

  1129. }
    1130. 

  1130. 

  1131. function deleteNotifications($ids){
    1132. 

  1132. 	$ret = array();
    1133. 

  1133. 	try{
    1134. 

  1134. 		$db = new DBConnection();
    1135. 

  1135. 		$db->getConnection();
    1136. 

  1136. 

  1137. 		$sql = "DELETE FROM `nk_notification` WHERE `notification_id` IN (".str_replace('#',',',$ids).")";
    1138. 

  1138. 

  1139. 		if(mysql_query($sql)==false){
    1140. 

  1140. 			$ret['IsSuccess'] = false;
    1141. 

  1141. 			$ret['Msg'] = mysql_error();
    1142. 

  1142. 		}else{
    1143. 

  1143. 			$ret['IsSuccess'] = true;
    1144. 

  1144. 			$ret['Msg'] = 'add success';
    1145. 

  1145. 		}
    1146. 

  1146. 

  1147. 	}catch(Exception $e){
    1148. 

  1148. 		$ret['IsSuccess'] = false;
    1149. 

  1149. 		$ret['Msg'] = $e->getMessage();
    1150. 

  1150. 	}
    1151. 

  1151. 	return $ret;
    1152. 

  1152. }
    1153. 

  1153. 

  1154. function getNextEvents($date,$day){
    1155. 

  1155. 

  1156. 	$date = gmdate("d#m#Y#H#i", $date);
    1157. 

  1157. 

  1158. 	list ($d, $month, $year,$hour,$minute) = split ('#',$date);
    1159. 

  1159. 

  1160. 	$calendar= listCalendar($_SESSION['user_id'], $day);
    1161. 

  1161. 

  1162. 	if (empty($calendar))
    1163. 

  1163. 		return "{}";
    1164. 

  1164. 	if(!array_key_exists("events", $calendar))
    1165. 

  1165. 		return "{}";
    1166. 

  1166. 

  1167. 	$ret = array();
    1168. 

  1168. 

  1169. 	$events = $calendar['events'][0][6];
    1170. 

  1170. 	for ($i = (($hour*2)+1); $i < 48; $i++) {
    1171. 

  1171. 		$event = $events[$i];
    1172. 

  1172. 		if($event->isEmpty || $event->availableSpot == 0 || $event->status == 3)
    1173. 

  1173. 			continue;
    1174. 

  1174. 		else{
    1175. 

  1175. 			$ret['events'][] = $event;
    1176. 

  1176. 		}
    1177. 

  1177. 	}
    1178. 

  1178. 

  1179. 	return $ret;
    1180. 

  1180. }
    1181. 

  1181. 

  1182. function doPing(){
    1183. 

  1183. 	$ret = array();
    1184. 

  1184. 	try{
    1185. 

  1185. 		$db = new DBConnection();
    1186. 

  1186. 		$db->getConnection();
    1187. 

  1187. 

  1188. 		$sql = "UPDATE `nk_user` SET `last_ping_time` = SYSDATE(),is_logged_in = 1 WHERE `user_id` = ".$_SESSION['user_id'];
    1189. 

  1189. 

  1190. 		if(mysql_query($sql)==false){
    1191. 

  1191. 			$ret['IsSuccess'] = false;
    1192. 

  1192. 			$ret['Msg'] = mysql_error();
    1193. 

  1193. 		}else{
    1194. 

  1194. 			$ret['IsSuccess'] = true;
    1195. 

  1195. 			$ret['Msg'] = 'update success';
    1196. 

  1196. 		}
    1197. 

  1197. 

  1198. 	}catch(Exception $e){
    1199. 

  1199. 		$ret['IsSuccess'] = false;
    1200. 

  1200. 		$ret['Msg'] = $e->getMessage();
    1201. 

  1201. 	}
    1202. 

  1202. 	return $ret;
    1203. 

  1203. }
    1204. 

  1204. function insertLesson($price,$rate, $coachid, $studentid, $gameId, $hours="1",$status=1, $time_zone_offset = 0, $start=0, $end=0, $lessonType=0){
    1205. 

  1205. 	try{
    1206. 

  1206. 		$db = new DBConnection();
    1207. 

  1207. 		$db->getConnection();
    1208. 

  1208. 		$user = $_SESSION['ch_user'];
    1209. 

  1209. 		$game = getGame($gameId);
    1210. 

  1210.                 $coach_name = "";
    1211. 

  1211.                 $student_name = "";
    1212. 

  1212. 		if($coachid == $_SESSION['user_id']){
    1213. 

  1213.                     $coach_name = $user['username'];
    1214. 

  1214.                     $st = getUserInfo($studentid);
    1215. 

  1215.                     $student_name = $st->username;
    1216. 

  1216.                 }else{
    1217. 

  1217.                     $student_name = $user['username'];
    1218. 

  1218.                     $co = getUserInfo($coachid);
    1219. 

  1219.                     $coach_name = $co->username;
    1220. 

  1220.                 }
    1221. 

  1221.                 
    1222. 

  1222.                 $commision = getDefaultComission();   
    1223. 

  1223.                 
    1224. 

  1224. 		$sql = "INSERT INTO `nk_lesson` (`coach_name`,`student_name`,`lesson_type`,`time_zone_offset`,`game_id`,`lesson_title`,`lesson_description`, `coach_id`, `student_id`, `lesson_price`,`rate`, `lesson_commision_admin`, `lesson_status_id`, `lesson_payment_date`, `lesson_payment_transaction_no`, `lesson_closed_date`, `date_added`, `date_edited`,`start`,`end`) VALUES";
    1225. 

  1225. 		$sql .= " ('".$coach_name."','".$student_name."',".$lessonType.",".$time_zone_offset.",".$gameId.",'Lesson for game ".$game->game_name."', 'Lesson for game ".$game->game_name."',".$coachid.", ".$studentid.", ".$price.",".$rate.", ".$commision.", $status, NOW(), '0', NOW(), NOW(), NOW()";//,NOW(), NOW()+INTERVAL ".$hours." HOUR)";
    1226. 

  1226. 		if($start == 0){
    1227. 

  1227.                     $sql .= ",NOW()";
    1228. 

  1228.                 }else{
    1229. 

  1229.                     $sql .= ",'".$start."'";
    1230. 

  1230.                 }
    1231. 

  1231.                 if($end == 0){
    1232. 

  1232.                     $sql .= ", NOW()+INTERVAL ".$hours." HOUR";
    1233. 

  1233.                 }else{
    1234. 

  1234.                     $sql .= ",'".$end."'";
    1235. 

  1235.                 }
    1236. 

  1236.                     $sql .= ")";
    1237. 

  1237.                     
    1238. 

  1238. //		logToFile($sql);
    1239. 

  1239.                 
    1240. 

  1240. 		if(mysql_query($sql)==false){
    1241. 

  1241. 			$ret['IsSuccess'] = false;
    1242. 

  1242. 			$ret['Msg'] = mysql_error();
    1243. 

  1243. 		}else{
    1244. 

  1244. 			$ret['IsSuccess'] = true;
    1245. 

  1245. 			$ret['gameName'] = $game->game_name;
    1246. 

  1246. 			$ret['text'] = "<div>User <b>".$user['username']."</b> has requested an instant lesson for <b>".$game->game_name."</b></div><div style=\'margin-top: 5px; font-size: 12px\'>If you confirm, the student\'s points will be instantly charged. You must initiate a chat and start coaching now!</div>";
    1247. 

  1247. 			$ret['lessonId'] = mysql_insert_id();
    1248. 

  1248.                         $ret['commision'] = $commision;
    1249. 

  1249. 		}
    1250. 

  1250. 	}catch(Exception $e){
    1251. 

  1251. 		$ret['IsSuccess'] = false;
    1252. 

  1252. 		$ret['Msg'] = $e->getMessage();
    1253. 

  1253. 	}
    1254. 

  1254. 

  1255. 	return $ret;
    1256. 

  1256. }
    1257. 

  1257. 

  1258. function getLesson($lessonId){
    1259. 

  1259. 	$ret = array();
    1260. 

  1260. 	try{
    1261. 

  1261. 		$db = new DBConnection();
    1262. 

  1262. 		$db->getConnection();
    1263. 

  1263. 		$sql = "SELECT * FROM `nk_lesson` WHERE `lesson_id` = ".$lessonId;
    1264. 

  1264. 

  1265. 		$handle = mysql_query($sql);
    1266. 

  1266. 		$row = mysql_fetch_object($handle);
    1267. 

  1267. 		
    1268. 

  1268. 		return $row;
    1269. 

  1269. 	}catch(Exception $e){
    1270. 

  1270. 		$ret['error'] = $e->getMessage();
    1271. 

  1271. 	}
    1272. 

  1272. 	return $ret;
    1273. 

  1273. }
    1274. 

  1274. function changeLessonStatus($lessonId, $status, $statusReason=""){
    1275. 

  1275. 	
    1276. 

  1276. 	try{
    1277. 

  1277.             $ret = array();
    1278. 

  1278.             $db = new DBConnection();
    1279. 

  1279.             $db->getConnection();
    1280. 

  1280.             $sql = "UPDATE `nk_lesson` SET `lesson_status_id` = ".$status.", `status_reason` = '".$statusReason."' WHERE `lesson_id` = ".$lessonId;
    1281. 

  1281.             if(mysql_query($sql)==false){
    1282. 

  1282.                     $ret['IsSuccess'] = false;
    1283. 

  1283.                     $ret['Msg'] = mysql_error();
    1284. 

  1284.             }else{
    1285. 

  1285.                     $ret['IsSuccess'] = true;
    1286. 

  1286.                     $ret['Msg'] = 'add success';
    1287. 

  1287.             }
    1288. 

  1288. 		
    1289. 

  1289. 	}catch(Exception $e){
    1290. 

  1290. 		$ret['error'] = $e->getMessage();
    1291. 

  1291. 	}
    1292. 

  1292. 	return $ret;
    1293. 

  1293. }
    1294. 

  1294. function removeCanceledLesson($lessonId, $utype){
    1295. 

  1295.     try{
    1296. 

  1296.             $ret = array();
    1297. 

  1297.             $ret['lessonId'] = $lessonId;
    1298. 

  1298.             $db = new DBConnection();
    1299. 

  1299.             $db->getConnection();
    1300. 

  1300.             $sql = "UPDATE `nk_lesson` SET `".$utype."` = 1 WHERE `lesson_id` = ".$lessonId;
    1301. 

  1301.             if(mysql_query($sql)==false){
    1302. 

  1302.                     $ret['IsSuccess'] = false;
    1303. 

  1303.                     $ret['Msg'] = mysql_error();
    1304. 

  1304.                     
    1305. 

  1305.             }else{
    1306. 

  1306.                     $ret['IsSuccess'] = true;
    1307. 

  1307.                     $ret['Msg'] = 'add success';
    1308. 

  1308.             }
    1309. 

  1309. 		
    1310. 

  1310. 	}catch(Exception $e){
    1311. 

  1311. 		$ret['error'] = $e->getMessage();
    1312. 

  1312. 	}
    1313. 

  1313. 	return $ret;
    1314. 

  1314. }
    1315. 

  1315. 

  1316. function acceptInstantLesson($accept, $lessonId, $notifId){
    1317. 

  1317.         
    1318. 

  1318. 	$ret = array();
    1319. 

  1319.         try{
    1320. 

  1320.             markAsRead($notifId);
    1321. 

  1321.             $db = new DBConnection();
    1322. 

  1322.             $db->getConnection();
    1323. 

  1323.             $coach = $_SESSION['ch_user'];
    1324. 

  1324.             $lesson = getLesson($lessonId);
    1325. 

  1325.             if($accept == 0){
    1326. 

  1326.                 $sql = "UPDATE `nk_lesson` SET `date_edited` = NOW(), `lesson_payment_date` = NOW(),`status_reason` = 'Instant Lesson not accepted', `lesson_status_id` = ".LessonStatus::CANCELED." WHERE `lesson_id` = ".$lessonId;
    1327. 

  1327. //                logToFile($sql);
    1328. 

  1328.                 $text = "<b>".$coach['username']."</b> refused your Instant Lesson request. Please try again later.";
    1329. 

  1329.                 if(mysql_query($sql)==false){
    1330. 

  1330.                         $ret['IsSuccess'] = false;
    1331. 

  1331.                         $ret['text'] = $text;
    1332. 

  1332.                          $ret['studentid'] = $lesson->student_id;
    1333. 

  1333.                         $ret['Msg'] = mysql_error();
    1334. 

  1334.                 }else{
    1335. 

  1335.                         $ret['IsSuccess'] = true;
    1336. 

  1336.                         $ret['text'] = $text;
    1337. 

  1337.                         $ret['Msg'] = 'add success';
    1338. 

  1338.                          $ret['studentid'] = $lesson->student_id;
    1339. 

  1339.                 }
    1340. 

  1340.                 return $ret;
    1341. 

  1341.             }else{
    1342. 

  1342.                 
    1343. 

  1343. 

  1344.                 
    1345. 

  1345.                 $student = getUserInfo($lesson->student_id);
    1346. 

  1346.                 if(intval($student->total_points) >= intval($lesson->lesson_price)){
    1347. 

  1347.                         insertTransaction($lesson->student_id, TransactionStatus::BOOKED , TransactionType::DEBIT, $lesson->lesson_price,$student->total_points, 0.0,UserType::STUDENT, "Instant Lesson, coach: ".$coach->username);
    1348. 

  1348.                         insertTransaction($_SESSION['user_id'], TransactionStatus::BOOKED , TransactionType::CREDIT, $lesson->lesson_price, $coach['total_points'],$lesson->lesson_commision_admin,UserType::COACH, "Instant Lesson, student: ".$student->username);
    1349. 

  1349. 

  1350.                         $sql = "UPDATE `nk_lesson` SET `date_edited` = NOW(), `lesson_payment_date` = NOW(), `lesson_status_id` = ".LessonStatus::PAID." WHERE `lesson_id` = ".$lessonId;
    1351. 

  1351.                         if(mysql_query($sql)==false){
    1352. 

  1352.                             $ret['IsSuccess'] = false;
    1353. 

  1353.                             $ret['Msg'] = mysql_error();
    1354. 

  1354.                         }else{
    1355. 

  1355.                             $ret['coachid'] = $_SESSION['user_id'];
    1356. 

  1356.                             $ret['studentid'] = $lesson->student_id;
    1357. 

  1357.                             $ret['lessonId'] = $lessonId;
    1358. 

  1358.                             $ret['IsSuccess'] = true;
    1359. 

  1359.                             $ret['text'] = "<div>User <b>".$coach['username']."</b> confirmed your Instant Lesson request.</div><div style=\'margin-top: 5px; font-size: 12px\'><b>".$coach['username']."</b> will initiate a chat to start your lesson shortly</div>";
    1360. 

  1360.                             $ret['Msg'] = 'add success';
    1361. 

  1361.                         }
    1362. 

  1362.                 }else{
    1363. 

  1363.                         $sql = "UPDATE `nk_lesson` SET `date_edited` = NOW(),`status_reason` = 'Not enough points', `lesson_payment_date` = NOW(), `lesson_status_id` = ".LessonStatus::CANCELED." WHERE `lesson_id` = ".$lessonId;
    1364. 

  1364.                         if(mysql_query($sql)==false){
    1365. 

  1365.                                 $ret['IsSuccess'] = false;
    1366. 

  1366.                                 $ret['Msg'] = mysql_error();
    1367. 

  1367.                         }
    1368. 

  1368.                         $ret['IsSuccess'] = false;
    1369. 

  1369.                         $ret['Msg'] = 'The student doesn\'t have enough points';
    1370. 

  1370.                 }
    1371. 

  1371.             }
    1372. 

  1372. 

  1373.         }catch(Exception $e){
    1374. 

  1374. 		$ret['error'] = $e->getMessage();
    1375. 

  1375. 	}
    1376. 

  1376. 	return $ret;
    1377. 

  1377. }
    1378. 

  1378. 

  1379. function calculateCommission($value,$comission=0.0,$userId, $userType, $txType){
    1380. 

  1380.     try{
    1381. 

  1381.         $value = floatval($value);
    1382. 

  1382.         if($comission == 0.0)
    1383. 

  1383.             $comission = getDefaultComission();
    1384. 

  1384.         $percentage = floatval($comission)/100;
    1385. 

  1385. //        if(TransactionType::CREDIT_REFUND == $txType){
    1386. 

  1386. //            $value = $value+($value*$percentage);
    1387. 

  1387. //            //remove points to chiron 
    1388. 

  1388. //        }else
    1389. 

  1389.             if(TransactionType::CREDIT == $txType || TransactionType::CREDIT_REFUND == $txType){
    1390. 

  1390.             $value = $value-($value*$percentage);
    1391. 

  1391.             //add points to chiron 
    1392. 

  1392.         }
    1393. 

  1393.         
    1394. 

  1394.         return $value;
    1395. 

  1395.     
    1396. 

  1396.     }catch(Exception $e){
    1397. 

  1397.         return $value;
    1398. 

  1398.     }
    1399. 

  1399. }
    1400. 

  1400. 

  1401. function insertTransaction($userId, $txStatus, $txType, $value, $oldPoints, $comission=0.0, $userType=1, $description=""){
    1402. 

  1402. 	$ret = array();
    1403. 

  1403. 	try{
    1404. 

  1404. 	
    1405. 

  1405.             $value = calculateCommission($value,$comission,$userId,$userType,$txType);
    1406. 

  1406.             $txDate = date("d/m/Y : H:i:s", time());
    1407. 

  1407.             $txId = md5($userId.$txDate);
    1408. 

  1408.             $newpoints = 0;
    1409. 

  1409.             if($txType == TransactionType::CREDIT || $txType == TransactionType::DEBIT_REFUND)
    1410. 

  1410.                     $newpoints = $oldPoints+$value;
    1411. 

  1411.             else
    1412. 

  1412.                     $newpoints = $oldPoints-$value;
    1413. 

  1413. 

  1414.             $db = new DBConnection();
    1415. 

  1415.             $db->getConnection();
    1416. 

  1416.             $sql = "INSERT INTO nk_user_transaction(commission, nk_user_id, tx_date, rate_point_id, status, nk_tx_id,transaction_type, qty_points, description, total_before , total_after) VALUES(". $comission .",". $userId .", STR_TO_DATE('". $txDate ."', '%d/%m/%Y : %H:%i:%s'),-1, ". $txStatus .",'". $txId ."',".$txType.",".$value.",'".$description."',".$oldPoints.", ".$newpoints.")";
    1417. 

  1417.             //logToFile($sql);
    1418. 

  1418. 

  1419.             if(mysql_query($sql)==false){
    1420. 

  1420.                     $ret['IsSuccess'] = false;
    1421. 

  1421.                     $ret['Msg'] = mysql_error();
    1422. 

  1422.             }else{
    1423. 

  1423.                     $ret['IsSuccess'] = true;
    1424. 

  1424.                     $ret['Msg'] = 'add success';
    1425. 

  1425.                     $ret['newpoints'] = $newpoints;
    1426. 

  1426.                     updateUserPoints($newpoints, $userId);
    1427. 

  1427.             }
    1428. 

  1428. 

  1429. 	}catch(Exception $e){
    1430. 

  1430. 		$ret['error'] = $e->getMessage();
    1431. 

  1431. 	}
    1432. 

  1432. 	return $ret;
    1433. 

  1433. }
    1434. 

  1434. function getDefaultComission(){
    1435. 

  1435.     try{
    1436. 

  1436.         
    1437. 

  1437.         $db = new DBConnection();
    1438. 

  1438.         $db->getConnection();
    1439. 

  1439.         $sql = "SELECT default_comision_value FROM nk_default_comision";
    1440. 

  1440.         $handle = mysql_query($sql);
    1441. 

  1441.         $row = mysql_fetch_object($handle);
    1442. 

  1442.         return $row->default_comision_value;
    1443. 

  1443.         
    1444. 

  1444.     }catch(Exception $e){
    1445. 

  1445.         return 1;
    1446. 

  1446.     }
    1447. 

  1447.     return 1;
    1448. 

  1448. }
    1449. 

  1449. 

  1450. function updateUserPoints($points,$userId=""){
    1451. 

  1451.     $ret = array();
    1452. 

  1452. 	try{
    1453. 

  1453. 		if($userId == "")
    1454. 

  1454. 			$userId = $_SESSION['user_id'];
    1455. 

  1455. 			
    1456. 

  1456. 		$sql = "UPDATE ".TABLEPREFIX."_user SET total_points = '".$points."' WHERE user_id = ".$userId;
    1457. 

  1457. 		if(mysql_query($sql)==false){
    1458. 

  1458. 			$ret['IsSuccess'] = false;
    1459. 

  1459. 			$ret['Msg'] ="Error: ".mysql_error();
    1460. 

  1460. 		}else{
    1461. 

  1461. 			$ret['IsSuccess'] = true;
    1462. 

  1462. 			$ret['Msg'] = "";
    1463. 

  1463.                         
    1464. 

  1464.                         if($userId == $_SESSION['user_id']){
    1465. 

  1465.                             $sql = "SELECT * FROM ".TABLEPREFIX."_user WHERE user_id = ".$userId;
    1466. 

  1466.                             $handle = mysql_query($sql);
    1467. 

  1467.                             $_SESSION['ch_user'] = mysql_fetch_array($handle);
    1468. 

  1468.                         }
    1469. 

  1469.                         
    1470. 

  1470.                       //  $loggedUser = $_SESSION['ch_user'];
    1471. 

  1471.                         
    1472. 

  1472. 		}
    1473. 

  1473. 	
    1474. 

  1474. 	}catch(Exception $e){
    1475. 

  1475. 		$ret['IsSuccess'] = false;
    1476. 

  1476. 		$ret['Msg'] = $e->getMessage();
    1477. 

  1477. 	}
    1478. 

  1478. 	return $ret;
    1479. 

  1479. }
    1480. 

  1480. 

  1481. function getAllEvents(){
    1482. 

  1482. 

  1483. 	$calendar= listCalendar($_SESSION['user_id']);
    1484. 

  1484. 

  1485. 	if (empty($calendar))
    1486. 

  1486. 		return "{}";
    1487. 

  1487. 	if(!array_key_exists("events", $calendar))
    1488. 

  1488. 		return "{}";
    1489. 

  1489. 

  1490. 	$ret = array();
    1491. 

  1491. 

  1492. 	$events = $calendar['events'][0][6];
    1493. 

  1493. 	foreach($events as $event){
    1494. 

  1494. 

  1495. 		if($event->isEmpty || $event->availableSpot == 0 || $event->status == 3) 
    1496. 

  1496. 			continue;
    1497. 

  1497. 		else{
    1498. 

  1498. 			$ret['events'][] = $event;
    1499. 

  1499. 		}
    1500. 

  1500. 	}
    1501. 

  1501. 

  1502. 	return $ret;
    1503. 

  1503. }
    1504. 

  1504. function addAsFriend($user){
    1505. 

  1505. 	$ret = array();
    1506. 

  1506. 	try{
    1507. 

  1507. 		$db = new DBConnection();
    1508. 

  1508. 		$db->getConnection();
    1509. 

  1509.                 
    1510. 

  1510.                 $sqlCheck =  "SELECT * FROM nk_user_f…
    1511.

Large files files are truncated, but you can click here to view the full file