private function optionLoadGameMsgSpecific()
{
global $ldTpl, $TABLES_CONFIGS, $PANELADMIN_MODULE;
if ($_GET['action'] == "sendMsg") {
require "modules/classes/ldnetwork.class.php";
require "modules/classes/ldgame.class.php";
if (isset($_POST['usernames']) == false) {
$tempTpl .= "<script type=\"text/javascript\"> alert(\"" . LDPA_GAME_MSG_SPECIFIC_SELECT_ANY_USER . "\"); </script>";
} elseif (empty($_POST['message']) == true || strlen($_POST['message']) > 60) {
$tempTpl .= "<script type=\"text/javascript\"> alert(\"" . LDPA_GAME_MSG_SPECIFIC_INVALID_SIZE_TEXT . "\"); </script>";
} else {
$ldGame = new ldGame($PANELADMIN_MODULE['JOINSERVER']['IP'], $PANELADMIN_MODULE['JOINSERVER']['PORT']);
foreach ($_POST['usernames'] as $username) {
$ldGame->sendMessage($username, $_POST['message']);
}
$tempTpl .= "<script type=\"text/javascript\"> alert(\"" . LDPA_GAME_MSG_SPECIFIC_TEXT_SEND_SUCCESS . "\"); </script>";
$this->writeLog(20, "", "", LDPA_GAME_MSG_SPECIFIC_LOG_SEND_SUCCESS . ": " . $_POST['message']);
}
}
$tempTpl .= "<form action='?page=paneladmin&option=GAME_MSG_SPECIFIC&action=sendMsg' method='post'>\n <table border='0' width='100%'>\n <tr>\n <td align='center' bgcolor='#E2DEC5'><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_LOGIN . "</strong></td>\n <td align='center' bgcolor='#E2DEC5'><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_CHARACTER . "</strong></td>\n <td align='center' bgcolor='#E2DEC5'><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_CONNECT_TM . "</strong></td>\n <td align='center' bgcolor='#E2DEC5'><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_SERVER . "</strong></td>\n <td align='center' bgcolor='#E2DEC5'><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_SEND . "</strong></td>\n </tr>";
$findAccountsOnlineQ = $this->query("Use " . DATABASE_ACCOUNTS . "; SELECT MEMB_STAT.memb___id, MEMB_STAT.ConnectTM, MEMB_STAT.ServerName, AccountCharacter.GameIDC FROM " . DATABASE_ACCOUNTS . ".dbo.MEMB_STAT JOIN " . DATABASE_CHARACTERS . ".dbo.AccountCharacter ON (MEMB_STAT.memb___id = AccountCharacter.Id) WHERE MEMB_STAT.ConnectStat = 1 ");
while ($findAccountsOnline = mssql_fetch_object($findAccountsOnlineQ)) {
++$i;
$checkVipQ = $this->query("Use " . DATABASE . "; SELECT " . $TABLES_CONFIGS['WEBVIPS']['columnType'] . " as type FROM " . $TABLES_CONFIGS['WEBVIPS']['database'] . ".dbo." . $TABLES_CONFIGS['WEBVIPS']['table'] . " WHERE " . $TABLES_CONFIGS['WEBVIPS']['columnUsername'] . "='" . $findAccountsOnline->memb___id . "'");
$checkVip = mssql_fetch_object($checkVipQ);
$tempTpl .= "<tr id='rowDc{$i}'>\n <td align='center' bgcolor='#EDEBDC'>" . $findAccountsOnline->memb___id . "</td>\n <td align='center' bgcolor='#EDEBDC'>" . $findAccountsOnline->GameIDC . "</td>\n <td align='center' bgcolor='#EDEBDC'>" . $findAccountsOnline->ConnectTM . "</td>\n <td align='center' bgcolor='#EDEBDC'>" . $findAccountsOnline->ServerName . "</td>\n <td align='center' bgcolor='#EDEBDC'><input type=\"checkbox\" name=\"usernames[]\" value=\"{$findAccountsOnline->memb___id}\" /></td>\n </tr>";
}
$tempTpl .= "<tr><td colspan='5'><em><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_TOTAL_ONLINES . ": " . (int) $i . " </strong></em></td></tr>";
$tempTpl .= "<tr><td colspan='5'><em><strong>" . LDPA_GAME_MSG_SPECIFIC_TEXT_MESSAGE . ": </strong></em><input type=\"text\" name=\"message\" value=\"" . LDPA_GAME_MSG_SPECIFIC_TEXT_MESSAGE . "\" maxlength=\"60\" /><input type=\"submit\" value=\"" . LDPA_GAME_MSG_SPECIFIC_TEXT_SUBMIT . "\" class=\"button\" /></td></tr></table></form>";
$ldTpl->set("RESULTTPL", $tempTpl);
}
