API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 5th, 2017
126
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.75 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. require_once("conf/config.php");
  4. require_once("commons/sql.php");
  5. require_once("commons/logs.php");
  6.  
  7. class aion
  8. {
  9. var $log;
  10.  
  11. public function aion()
  12. {
  13. $this->log=new logs();
  14. }
  15.  
  16. private function crypt_pass($password)
  17. {
  18. $cpass = trim($password);
  19. $cpass = sha1($cpass, true);
  20. $cpass = base64_encode($cpass);
  21. return ($cpass);
  22. }
  23.  
  24. public function isWebLoged()
  25. {
  26. global $_CONF;
  27.  
  28. if( (!isset($_SESSION['uid'])) || (!isset($_SESSION["ultimo_acceso"])) || $_SESSION['uid']==0 )
  29. {
  30. $_SESSION['uid']=0;
  31. $_SESSION["ultimo_acceso"]= date("Y-n-j H:i:s");
  32. return false;
  33. }
  34. else
  35. {
  36. $tiempo_transcurrido = (strtotime(date("Y-n-j H:i:s"))-strtotime($_SESSION["ultimo_acceso"]));
  37. if($tiempo_transcurrido >= ($_CONF['max_time_session']*60))
  38. {
  39. session_destroy();
  40. $_SESSION['uid']=0;
  41. $_SESSION["ultimo_acceso"]= date("Y-n-j H:i:s");
  42. return false;
  43. }
  44. else
  45. {
  46. $_SESSION["ultimo_acceso"]= date("Y-n-j H:i:s");
  47. return true;
  48. }
  49. }
  50. }
  51.  
  52. public function ValideAccount($account, $password)
  53. {
  54. global $_CONF;
  55. $sql_con=new sql();
  56.  
  57. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_login'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  58.  
  59. $user=$sql_con->anti_inyection($account);
  60. $pass=$sql_con->anti_inyection($password);
  61. $query="select * from account_data where name='" . $user . "' and password='" . $this->crypt_pass($pass) . "'";
  62. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  63. {
  64. $_SESSION['uid']=$rows[0]['id'];
  65. $_SESSION['uname']=$rows[0]['name'];
  66. $_SESSION['uaccess_level']=$rows[0]['access_level'];
  67. if($_CONF['enable_logs']=="on") $this->log->addlog("[LOGIN] login_nombre=[" . $user . "], ValideAccount_query=[" . $query . "]", "account");
  68. return true;
  69. }
  70. else
  71. {
  72. if($_CONF['enable_logs']=="on") $this->log->addlog("[NOLOGIN] login_nombre=[" . $user . "], ValideAccount_query=[" . $query . "]", "account");
  73. return false;
  74. }
  75. }
  76.  
  77. public function existAccountName($account)
  78. {
  79. global $_CONF;
  80. $sql_con=new sql();
  81.  
  82. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_login'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  83.  
  84. $user=$sql_con->anti_inyection($account);
  85. $query="select * from account_data where name='" . $user . "'";
  86. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  87. {
  88. return true;
  89. }
  90. else
  91. {
  92. return false;
  93. }
  94. }
  95.  
  96. public function existAccountMail($mail)
  97. {
  98. global $_CONF;
  99. $sql_con=new sql();
  100.  
  101. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_login'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  102.  
  103. $user=$sql_con->anti_inyection($mail);
  104. $query="select * from account_data where mail='" . $mail . "'";
  105. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  106. {
  107. return true;
  108. }
  109. else
  110. {
  111. return false;
  112. }
  113. }
  114.  
  115. public function accountRegister($accountname, $password, $email)
  116. {
  117. global $_CONF;
  118. $sql_con=new sql();
  119.  
  120. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_login'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  121.  
  122. $account_name=$sql_con->anti_inyection($accountname);
  123. $pass=$sql_con->anti_inyection($password);
  124. $mail=$sql_con->anti_inyection($email);
  125. if($this->ValideMail($mail))
  126. {
  127. $query="INSERT INTO account_data (name, password, activated, access_level, mail, last_server, last_ip) VALUES ('" . $account_name . "','" . $this->crypt_pass($pass) . "',1,0,'" . $mail . "', 1,'" . getenv("REMOTE_ADDR") . "')";
  128. if($sql_con->execute($query))
  129. {
  130. if($_CONF['enable_logs']=="on") $this->log->addlog("[ACCOUNTREGISTER] account_name=[" . $account_name . "], mail=[" . $mail . "], accountRegister_query=[" . $query . "]", "account");
  131. return true;
  132. }
  133. else
  134. {
  135. if($_CONF['enable_logs']=="on") $this->log->addlog("[NOACCOUNTREGISTER] account_name=[" . $account_name . "], mail=[" . $mail . "], SetPlayerPosition_query=[" . $query . "]", "account");
  136. return false;
  137. }
  138. }
  139. else
  140. {
  141. if($_CONF['enable_logs']=="on") $this->log->addlog("[NOACCOUNTREGISTER-MAILINCORRECT] account_name=[" . $account_name . "], mail=[" . $mail . "]", "account");
  142. return false;
  143. }
  144. }
  145.  
  146. function ValideMail($pMail)
  147. {
  148. if (preg_match("/^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@+([_a-zA-Z0-9-]+\.)*[a-zA-Z0-9-]{2,200}\.[a-zA-Z]{2,6}$/", $pMail ) )
  149. {
  150. return true;
  151. }
  152. else
  153. {
  154. return false;
  155. }
  156. }
  157.  
  158. public function logout()
  159. {
  160. unset($_SESSION['uid']);
  161. unset($_SESSION["ultimo_acceso"]);
  162. unset($_SESSION['uname']);
  163. unset($_SESSION['uaccesslevel']);
  164. session_destroy();
  165. }
  166.  
  167. public function UpdatePassword($pass, $newpass)
  168. {
  169. global $_CONF;
  170. $sql_con=new sql();
  171.  
  172. if(!$this->isWebLoged()) return false;
  173. else
  174. {
  175. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_login'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  176.  
  177. $user_id=$this->getAccountId();
  178. $pass=$sql_con->anti_inyection($pass);
  179. $new_pass=$sql_con->anti_inyection($newpass);
  180. $query="select * from account_data where id='" . $user_id . "' and password='" . $this->crypt_pass($pass) . "'";
  181. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  182. {
  183. $query="update account_data set password='" . $this->crypt_pass($new_pass) . "' where id=" . $user_id . " and password='" . $this->crypt_pass($pass) . "'";
  184. if($sql_con->execute($query))
  185. {
  186. if($_CONF['enable_logs']=="on") $this->log->addlog("[PASSWORD-UPDATED] login_id=[" . $user_id . "], UpdatePassword_query=[" . $query . "]", "account");
  187. return true;
  188. }
  189. else
  190. {
  191. if($_CONF['enable_logs']=="on") $this->log->addlog("[NO-PASSWORD-UPDATED] login_id=[" . $user_id . "], UpdatePassword_query=[" . $query . "]", "account");
  192. return false;
  193. }
  194. }
  195. else
  196. {
  197. if($_CONF['enable_logs']=="on") $this->log->addlog("[INVALID_LOGIN] login_id=[" . $user_id . "], UpdatePassword_query=[" . $query . "]", "account");
  198. return false;
  199. }
  200. }
  201. }
  202.  
  203. public function getAccountId()
  204. {
  205. if($this->isWebLoged()) return ($_SESSION['uid']);
  206. else return (0);
  207. }
  208.  
  209. public function getAccountName()
  210. {
  211. if($this->isWebLoged()) return $_SESSION['uname'];
  212. else return "anonimo";
  213. }
  214.  
  215. public function isPlayerthisAccount($playerId)
  216. {
  217. global $_CONF;
  218. $sql_con=new sql();
  219.  
  220. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  221.  
  222. $player_id=$sql_con->anti_inyection($playerId);
  223. $query="select * from players where account_id=" . $this->getAccountId() . " and id=" . $player_id;
  224. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  225. {
  226. return (true);
  227. }
  228. else
  229. {
  230. return (false);
  231. }
  232. }
  233.  
  234. public function getPlayers($account_Id, &$rows, &$num_rows)
  235. {
  236. global $_CONF;
  237. $sql_con=new sql();
  238.  
  239. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  240.  
  241. $accountId=$sql_con->anti_inyection($account_Id);
  242. $query="select * from players where account_id=" . $accountId;
  243. return $sql_con->query($query, $rows, $num_rows);
  244. }
  245.  
  246. public function getPlayerActiveSkills($playerId, &$rows, &$num_rows)
  247. {
  248. global $_CONF;
  249. $sql_con=new sql();
  250.  
  251. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  252.  
  253. $player_id=$sql_con->anti_inyection($playerId);
  254. $query="SELECT player_skills.player_id, players.name as player_name, player_skills.skillId, player_skills.skillLevel, web_skill_tree.minLevel, web_skill_tree.name as skill_name,
  255. (CASE web_skill_tree.autolearn
  256. WHEN 'true' THEN 'auto'
  257. ELSE 'book'
  258. END) as type
  259. FROM player_skills
  260. LEFT JOIN web_skill_tree ON web_skill_tree.skillId= player_skills.skillId
  261. LEFT JOIN players ON players.id=player_skills.player_id
  262. WHERE player_skills.player_id=" . $player_id . " and web_skill_tree.skillId is not null and web_skill_tree.type='ACTIVE'
  263. GROUP BY web_skill_tree.name, player_skills.skillId, player_skills.skillLevel
  264. ORDER BY web_skill_tree.type, web_skill_tree.name, player_skills.skillLevel";
  265.  
  266. return $sql_con->query($query, $rows, $num_rows);
  267. }
  268.  
  269. public function getPlayerPasiveSkills($playerId, &$rows, &$num_rows)
  270. {
  271. global $_CONF;
  272. $sql_con=new sql();
  273.  
  274. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  275.  
  276. $player_id=$sql_con->anti_inyection($playerId);
  277. $query="SELECT player_skills.player_id, players.name as player_name, player_skills.skillId, player_skills.skillLevel, web_skill_tree.minLevel, web_skill_tree.name as skill_name,
  278. (CASE web_skill_tree.autolearn
  279. WHEN 'true' THEN 'auto'
  280. ELSE 'book'
  281. END) as type
  282. FROM player_skills
  283. LEFT JOIN web_skill_tree ON web_skill_tree.skillId= player_skills.skillId
  284. LEFT JOIN players ON players.id=player_skills.player_id
  285. WHERE player_skills.player_id=" . $player_id . " and web_skill_tree.skillId is not null and web_skill_tree.type='PASSIVE'
  286. GROUP BY web_skill_tree.name, player_skills.skillId, player_skills.skillLevel
  287. ORDER BY web_skill_tree.type, web_skill_tree.name, player_skills.skillLevel";
  288.  
  289. return $sql_con->query($query, $rows, $num_rows);
  290. }
  291.  
  292. public function getEquipedItems($playerId, &$rows, &$num_rows)
  293. {
  294. global $_CONF;
  295. $sql_con=new sql();
  296.  
  297. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  298.  
  299. $player_id=$sql_con->anti_inyection($playerId);
  300. $query="SELECT * FROM inventory LEFT JOIN web_itemlist on web_itemlist.item_id=inventory.itemId WHERE inventory.isEquiped=1 and inventory.itemLocation=0 and inventory.itemOwner=" . $player_id;
  301.  
  302. return $sql_con->query($query, $rows, $num_rows);
  303. }
  304.  
  305. public function getNoEquipedItems($playerId, &$rows, &$num_rows)
  306. {
  307. global $_CONF;
  308. $sql_con=new sql();
  309.  
  310. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  311.  
  312. $player_id=$sql_con->anti_inyection($playerId);
  313. $query="SELECT * FROM inventory LEFT JOIN web_itemlist on web_itemlist.item_id=inventory.itemId WHERE inventory.isEquiped=0 and inventory.itemLocation=0 and inventory.itemOwner=" . $player_id;
  314.  
  315. return $sql_con->query($query, $rows, $num_rows);
  316. }
  317.  
  318. public function getWarehouseItems($playerId, &$rows, &$num_rows)
  319. {
  320. global $_CONF;
  321. $sql_con=new sql();
  322.  
  323. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  324.  
  325. $player_id=$sql_con->anti_inyection($playerId);
  326. $query="SELECT * FROM inventory LEFT JOIN web_itemlist on web_itemlist.item_id=inventory.itemId WHERE inventory.itemLocation=1 and inventory.itemOwner=" . $player_id;
  327.  
  328. return $sql_con->query($query, $rows, $num_rows);
  329. }
  330.  
  331.  
  332. public function SetPlayerPosition($playerId, $x, $y, $z, $world)
  333. {
  334. global $_CONF;
  335. $sql_con=new sql();
  336.  
  337. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  338.  
  339. $player_id=$sql_con->anti_inyection($playerId);
  340. $query="update players set x=" . $x . ", y=" . $y . ", z=" . $z . ", world_id=" . $world . " where id=" . $player_id;
  341. if($sql_con->execute($query))
  342. {
  343. if($_CONF['enable_logs']=="on") $this->log->addlog("[SETPOSITION] player_id=[" . $player_id . "], SetPlayerPosition_query=[" . $query . "]", "players");
  344. return true;
  345. }
  346. else
  347. {
  348. if($_CONF['enable_logs']=="on") $this->log->addlog("[NOSETPOSITION] player_id=[" . $player_id . "], SetPlayerPosition_query=[" . $query . "]", "players");
  349. return false;
  350. }
  351.  
  352. }
  353.  
  354. public function isPlayerInGame($playerId)
  355. {
  356. global $_CONF;
  357. $sql_con=new sql();
  358.  
  359. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  360.  
  361. $player_id=$sql_con->anti_inyection($playerId);
  362. $query="select * from players where id=" . $player_id;
  363. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  364. {
  365. if($rows[0]['online']==0)
  366. {
  367. return false;
  368. }
  369. else
  370. {
  371. return true;
  372. }
  373. }
  374. else
  375. {
  376. return true;
  377. }
  378. }
  379.  
  380. public function getPlayerId($playerName)
  381. {
  382. global $_CONF;
  383. $sql_con=new sql();
  384.  
  385. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  386.  
  387. $player_name=$sql_con->anti_inyection($playerName);
  388. $query="select * from players where name='" . $player_name . "'";
  389. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  390. {
  391. return ($rows[0]['id']);
  392. }
  393. else
  394. {
  395. return (0);
  396. }
  397. }
  398.  
  399. public function getPlayerName($playerId)
  400. {
  401. global $_CONF;
  402. $sql_con=new sql();
  403.  
  404. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  405.  
  406. $player_id=$sql_con->anti_inyection($playerId);
  407. $query="select * from players where id=" . $player_id;
  408. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  409. {
  410. return ($rows[0]['name']);
  411. }
  412. else
  413. {
  414. return ("NULL");
  415. }
  416. }
  417.  
  418. public function getPlayerLevel($playerId)
  419. {
  420. global $_CONF;
  421. $sql_con=new sql();
  422. $level=1;
  423.  
  424. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  425.  
  426. $player_id=$sql_con->anti_inyection($playerId);
  427. $query="select * from players where id=" . $player_id;
  428. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  429. {
  430. for($i=0; $i<($_CONF['max_level_up']+1); $i++)
  431. {
  432. if($rows[0]['exp']<=$_CONF['exp_level_up'][$i])
  433. {
  434. $level=$i;
  435. break;
  436. }
  437. }
  438. }
  439. if($level<1) $level=1;
  440. if($i>=$_CONF['max_level_up']) $level=$_CONF['max_level_up'];
  441. if($level>$_CONF['max_level_up']) $level=$_CONF['max_level_up'];
  442. return $level;
  443. }
  444.  
  445. public function getPlayerRace($playerId)
  446. {
  447. global $_CONF;
  448. $sql_con=new sql();
  449.  
  450. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  451.  
  452. $player_id=$sql_con->anti_inyection($playerId);
  453. $query="select * from players where id=" . $player_id;
  454. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  455. {
  456. return ($rows[0]['race']);
  457. }
  458. else
  459. {
  460. return ("");
  461. }
  462. }
  463.  
  464. public function getPlayerClass($playerId)
  465. {
  466. global $_CONF;
  467. $sql_con=new sql();
  468.  
  469. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  470.  
  471. $player_id=$sql_con->anti_inyection($playerId);
  472. $query="select * from players where id=" . $player_id;
  473. if(($sql_con->query($query, $rows, $num_rows)) && ($num_rows==1))
  474. {
  475. return ($rows[0]['player_class']);
  476. }
  477. else
  478. {
  479. return ("");
  480. }
  481. }
  482.  
  483. public function isStartingClass($playerClass)
  484. {
  485. $player_class=$sql_con->anti_inyection($playerClass);
  486. if($player_class=="SCOUT" || $player_class=="WARRIOR" || $player_class=="PRIEST" || $player_class=="MAGE")
  487. {
  488. return (true);
  489. }
  490. else
  491. {
  492. return (false);
  493. }
  494. }
  495.  
  496. public function getStartingClass($playerClass)
  497. {
  498. $player_class=$sql_con->anti_inyection($playerClass);
  499. switch ($player_class)
  500. {
  501. case "ASSASSIN": $start_class="SCOUT";
  502. break;
  503. case "RANGER": $start_class="SCOUT";
  504. break;
  505. case "GLADIATOR": $start_class="WARRIOR";
  506. break;
  507. case "TEMPLAR": $start_class="WARRIOR";
  508. break;
  509. case "CHANTER": $start_class="PRIEST";
  510. break;
  511. case "CLERIC": $start_class="PRIEST";
  512. break;
  513. case "SORCERER": $start_class="MAGE";
  514. break;
  515. case "MAGE": $start_class="MAGE";
  516. break;
  517. default: $start_class=$player_class;
  518. }
  519. return ($start_class);
  520. }
  521.  
  522. public function deletePlayerQuest($playerId, $questId)
  523. {
  524. global $_CONF;
  525. $sql_con=new sql();
  526.  
  527. if(!$sql_con->connection($_CONF['db_uname'], $_CONF['db_pass'], $_CONF['db_name_game'], $_CONF['db_host'])) echo "<center>ERROR: SIN CONEXI�N CON LA BASE DE DATOS<BR>CONSULTE CON EL ADMINISTRADOR DEL SISTEMA<center>", exit(-1);
  528.  
  529. $player_Id=$sql_con->anti_inyection($playerId);
  530. $quest_Id=$sql_con->anti_inyection($questId);
  531. $query="DELETE FROM player_quests WHERE player_id=" . $player_Id . " AND quest_id=" . $quest_Id;
  532.  
  533. if($sql_con->execute($query))
  534. {
  535. if($_CONF['enable_logs']=="on") $this->log->addlog("[DELETEQUEST] player_id=[" . $player_Id . "], deletePlayerQuest_query=[" . $query . "]", "players");
  536. return true;
  537. }
  538. else
  539. {
  540. if($_CONF['enable_logs']=="on") $this->log->addlog("[NODELETEQUEST] player_id=[" . $player_Id . "], deletePlayerQuest_query=[" . $query . "]", "players");
  541. return false;
  542. }
  543. }
  544.  
  545. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!