public static function set(Neuron_GameServer_Player $player, $key, $value)
{
$db = Neuron_DB_Database::getInstance();
$data = $db->query("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\tn_players_registry\n\t\t\tWHERE\n\t\t\t\tplid = {$player->getId()} AND \n\t\t\t\tpr_name = '{$db->escape($key)}'\n\t\t");
if (count($data) == 0) {
$db->query("\n\t\t\t\tINSERT INTO\n\t\t\t\t\tn_players_registry\n\t\t\t\tSET\n\t\t\t\t\tplid = {$player->getId()},\n\t\t\t\t\tpr_name = '{$db->escape($key)}',\n\t\t\t\t\tpr_value = '{$db->escape($value)}'\n\t\t\t");
} else {
$db->query("\n\t\t\t\tUPDATE\n\t\t\t\t\tn_players_registry\n\t\t\t\tSET\n\t\t\t\t\tpr_value = '{$db->escape($value)}'\n\t\t\t\tWHERE\n\t\t\t\t\tplid = {$player->getId()} AND\n\t\t\t\t\tpr_name = '{$db->escape($key)}'\n\t\t\t\t\t\n\t\t\t");
}
}
public function setSocialStatus(Neuron_GameServer_Player $player, $status)
{
$db = Neuron_DB_Database::getInstance();
$status = intval($status);
// Check if already in here.
$chk = $db->query("\n\t\t\tSELECT\n\t\t\t\tps_status\n\t\t\tFROM\n\t\t\t\tn_players_social\n\t\t\tWHERE\n\t\t\t\tps_plid = {$this->getId()} \n\t\t\t\tAND ps_targetid = {$player->getId()}\n\t\t");
if (count($chk) == 0) {
$db->query("\n\t\t\t\tINSERT INTO\n\t\t\t\t\tn_players_social\n\t\t\t\tSET\n\t\t\t\t\tps_plid = {$this->getId()},\n\t\t\t\t\tps_targetid = {$player->getId()},\n\t\t\t\t\tps_status = '{$status}'\n\t\t\t");
} else {
$db->query("\n\t\t\t\tUPDATE\n\t\t\t\t\tn_players_social\n\t\t\t\tSET\n\t\t\t\t\tps_status = '{$status}'\n\t\t\t\tWHERE\n\t\t\t\t\tps_targetid = {$player->getId()} AND\n\t\t\t\t\tps_plid = {$this->getId()}\n\t\t\t");
}
}
/**
* @param Neuron_GameServer_Player $objUser
*/
public function __construct(Neuron_GameServer_Player $objUser)
{
$this->objUser = $objUser;
$this->objCredits = self::getPureCreditsObject();
if (!$this->objCredits) {
return;
}
if ($this->objUser->isEmailCertified()) {
$this->objCredits->setEmail($this->getEmail());
}
$this->objCredits->setReferal($objUser->getReferal());
foreach ($objUser->getOpenIDs() as $v) {
$this->objCredits->addOpenID($v);
}
$container = isset($_SESSION['opensocial_container']) ? $_SESSION['opensocial_container'] : null;
if (isset($container)) {
$this->objCredits->setContainer($container);
}
$fullscreen = isset($_SESSION['fullscreen']) && $_SESSION['fullscreen'] ? 1 : 0;
$this->objCredits->setFullscreen($fullscreen);
$this->objCredits->setLanguage(Neuron_Core_Text::getInstance()->getCurrentLanguage());
$this->objCredits->setUserId($objUser->getId());
if (isset($_SESSION['birthday'])) {
$this->objCredits->setBirthday($_SESSION['birthday']);
}
if (isset($_SESSION['gender'])) {
$this->objCredits->setGender(strtolower($_SESSION['gender']) == 'm' ? 'male' : 'female');
}
}
public static function countLogins(Neuron_GameServer_Player $player)
{
$db = Neuron_DB_Database::getInstance();
$data = $db->query("SELECT COUNT(*) AS aantal FROM n_login_log WHERE l_plid = {$player->getId()}");
return $data[0]['aantal'];
}
private function hasPrevious(Neuron_GameServer_Player $player, $page)
{
$db = Neuron_DB_Database::getInstance();
$cnt = $db->query("\n\t\t\tSELECT\n\t\t\t\tCOUNT(pg_id) AS aantal\n\t\t\tFROM\n\t\t\t\tn_players_guide\n\t\t\tWHERE\n\t\t\t\tplid = {$player->getId()}\n\t\t");
return count($cnt) == 1 && $cnt[0]['aantal'] - 1 > $page;
}
private function getModeratorHistory(Neuron_GameServer_Player $objUser)
{
$db = Neuron_DB_Database::getInstance();
$data = $db->query("\n\t\t\tSELECT\n\t\t\t\t*,\n\t\t\t\tUNIX_TIMESTAMP(ma_date) AS datum\n\t\t\tFROM\n\t\t\t\tn_mod_actions\n\t\t\tWHERE\n\t\t\t\tma_target = {$objUser->getId()}\n\t\t\tORDER BY\n\t\t\t\tma_date DESC\n\t\t");
$out = array();
foreach ($data as $v) {
$data = json_decode($v['ma_data'], true);
$out[] = array('date' => $v['datum'], 'data' => $data, 'admin' => Neuron_GameServer::getPlayer($v['ma_plid']), 'reason' => $v['ma_reason'], 'action' => $this->getHistoryText($v['ma_action'], $data), 'isExecuted' => $v['ma_executed'], 'isProcessed' => $v['ma_processed']);
}
return $out;
}
public function addModeratorAction($sAction, $mParams, $reason, Neuron_GameServer_Player $player, $isDone = false)
{
$db = Neuron_DB_Database::getInstance();
$login = Neuron_Core_Login::getInstance();
$userid = intval($login->getUserId());
$isDone = $isDone ? true : false;
$processed = $isDone ? 1 : 0;
$executed = $isDone ? 1 : 0;
$db->query("\n\t\t\tINSERT INTO\n\t\t\t\tn_mod_actions\n\t\t\tSET\n\t\t\t\tma_action = '" . $db->escape($sAction) . "',\n\t\t\t\tma_data = '" . $db->escape(json_encode($mParams)) . "',\n\t\t\t\tma_plid = {$userid},\n\t\t\t\tma_date = NOW(),\n\t\t\t\tma_reason = '" . $db->escape($reason) . "',\n\t\t\t\tma_target = '{$player->getId()}',\n\t\t\t\tma_processed = {$processed},\n\t\t\t\tma_executed = {$executed}\n\t\t");
}
public function countPrivateMessages(Neuron_GameServer_Player $target)
{
$db = Neuron_DB_Database::getInstance();
$data = $db->query("\n\t\t\tSELECT\n\t\t\t\tCOUNT(pu_id) AS aantal\n\t\t\tFROM\n\t\t\t\tn_privatechat_updates\n\t\t\tWHERE\n\t\t\t\tpu_to = {$target->getId()}\n\t\t");
return $data[0]['aantal'];
}
public static function withdraw(Dolumar_Underworld_Models_Mission $mission, Neuron_GameServer_Player $player, Dolumar_Underworld_Models_Army $army, Neuron_GameServer_Map_Location $location)
{
$db = Neuron_DB_Database::getInstance();
$missionId = self::getMissionId($mission);
$armyId = self::getArmyId($mission, $army);
$sql = "\n\t\t\tINSERT INTO\n\t\t\t\tunderworld_log_event\n\t\t\tSET\n\t\t\t\tul_m_id = '{$missionId}',\n\t\t\t\tplid = '{$player->getId()}',\n\t\t\t\tul_a_vid = '{$armyId}',\n\t\t\t\tul_e_action = 'WITHDRAW',\n\t\t\t\tul_e_x = '{$location->x()}',\n\t\t\t\tul_e_y = '{$location->y()}',\n\t\t\t\tul_e_date = NOW()\n\t\t";
$db->query($sql);
}
