<?php
//Plugin: Top By Country
//Author: Ivan
//Display most players from country
if (!isset($website)) {
header('HTTP/1.1 404 Not Found');
die;
}
$PluginEnabled = '1';
if ($PluginEnabled == 1) {
AddEvent("os_add_menu_misc", "OS_TopByCountry");
if (OS_GetAction("top_country")) {
AddEvent("os_content", "OS_ShowTopCountry");
}
function OS_TopByCountry()
{
?>
<li><a href="<?php
echo OS_HOME;
?>
?action=top_country">Top Players by Country</a></li>
<?php
}
function OS_ShowTopCountry()
{
global $db;
//TOP BY COUNTRIES
$sth = $db->prepare("SELECT COUNT( country_code ) AS total, country_code \n FROM `" . OSDB_STATS . "` \n GROUP BY country_code\n ORDER BY total DESC \n LIMIT 100");
$result = $sth->execute();
$c = 0;
<tr>
<td width="150"></td>
<td>
<input type="submit" value = "Submit" class="menuButtons" />
<a href="' . OS_HOME . 'adm/?plugins" class="menuButtons">« Back</a>
</td>
</tr>
</table>
</form>';
}
if (!is_logged() and (OS_GetAction("facebook") or isset($_GET["fb"]))) {
AddEvent("os_start", "OS_RedirectFB");
AddEvent("os_content", "OS_FacebookLogin");
AddEvent("os_start", "OS_CheckFacebookLogin");
}
if (OS_GetAction("facebook") and is_logged()) {
header('location:' . OS_HOME . '');
die;
}
function OS_CheckFacebookLogin()
{
if (isset($_POST["fb_name"]) and isset($_POST["fb_email"]) and isset($_POST["fb_id"])) {
global $db;
$errors = '';
$FBID = trim($_POST["fb_id"]);
$gender = safeEscape(trim($_POST["fb_gender"]));
$name = strip_tags(trim($_POST["fb_name"]));
$email = safeEscape(trim($_POST["fb_email"]));
$IP = safeEscape($_SERVER["REMOTE_ADDR"]);
$avatar = 'https://graph.facebook.com/' . $FBID . '/picture/?type=large';
$www = 'http://www.facebook.com/profile.php?id=' . $FBID . '';
//Author: Ivan
//Users can preview their reports and appeals
if (!isset($website)) {
header('HTTP/1.1 404 Not Found');
die;
}
$PluginEnabled = '1';
//Enable edit plugin options
//$PluginOptions = '1';
if ($PluginEnabled == 1) {
//?action=reports
if (OS_GetAction("reports") and is_logged()) {
AddEvent("os_content", "OS_MyReports");
}
//?action=appeals
if (OS_GetAction("appeals") and is_logged()) {
AddEvent("os_content", "OS_MyAppeals");
}
//Add to main menu (MISC link)
if (is_logged()) {
AddEvent("os_add_menu_misc", "OS_ShowReportAppealMenu");
}
function OS_ShowReportAppealMenu()
{
?>
<li><a href="<?php
echo OS_HOME;
?>
?action=reports">My Reports</a></li>
<li><a href="<?php
echo OS_HOME;
header('HTTP/1.1 404 Not Found');
die;
}
$PluginEnabled = '1';
//Enable edit plugin optins
//$PluginOptions = '1';
//unset($_SESSION["password_send"] );
if ($PluginEnabled == 1) {
if (OS_login_page() and !os_is_logged()) {
AddEvent("os_login_fields", "OS_ForgotPasswordLink");
}
if (OS_GetAction("reset_password") and os_is_logged()) {
header('location:' . OS_HOME . '');
die;
}
if (OS_GetAction("reset_password") and !os_is_logged()) {
AddEvent("os_content", "OS_ForgotPassword");
$HomeTitle = "Password reminder";
}
function OS_ForgotPasswordLink()
{
?>
<tr>
<td></td>
<td class="padLeft">
<div><a href="<?php
echo OS_HOME;
?>
?action=reset_password">Forgot your password?</a></div>
</td>
</tr>
function OS_DisplayCustomField()
{
global $db;
//FUNCTION: OS_GetAction
//OS_GetAction is $_GET["action"]
//OS_GetAction("profile") same as $_GET["action"] == "profile";
if (OS_GetAction("profile") and isset($_GET["id"]) and is_numeric($_GET["id"])) {
$uid = (int) $_GET["id"];
$RealmUn = OS_get_custom_field($uid, "realm_username");
$UserBirth = OS_get_custom_field($uid, "user_birthday");
$UserBirth = str_replace("-", " ", $UserBirth);
?>
<tr>
<td width="130" class="padLeft"><b>Realm username:</b></td>
<td><?php
echo $RealmUn;
?>
</td>
</tr>
<tr>
<td width="130" class="padLeft"><b>Birthday:</b></td>
<td><?php
echo $UserBirth;
?>
</td>
</tr>
<?php
}
}
function OS_PMSystem()
{
if (OS_GetAction("pm")) {
global $db;
$sth = $db->prepare("SET NAMES 'utf8'");
$result = $sth->execute();
global $lang;
global $DateFormat;
$errors = "";
?>
<div class="clr"></div>
<div class="ct-wrapper" id="content" class="s-c-x">
<div class="outer-wrapper wrapper">
<div class="content section" id="main-column">
<div class="widget Blog padding">
<div class="blog-posts hfeed padLeft padTop padBottom inner">
<h2>Private Messages</h2>
<div>
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&inbox">INBOX</a>
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&sent_items">SENT ITEMS</a>
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&new_message">NEW MESSAGE</a>
</div>
<?php
//NEW MESSAGE
if (isset($_GET["new_message"])) {
$PMName = "";
$PMText = "";
if (isset($_POST["pm_message"]) and isset($_POST["pm_name"]) and isset($_SESSION["code"]) and isset($_POST["code"])) {
$PMText = $_POST['pm_message'];
$PMText = strip_tags($PMText);
$PMName = safeEscape(trim($_POST["pm_name"]));
if ($_SESSION["code"] != $_POST["code"]) {
$errors .= "<h4>Form is not valid. Try again.</h4>";
}
if (strlen($PMText) <= 2) {
$errors .= "<h4>There are not enough characters in the message</h4>";
}
if (strlen($PMName) <= 2) {
$errors .= "<h4>Please, write a valid username</h4>";
}
if (strtolower($PMName) == $_SESSION["username"]) {
$errors .= "<h4>You can not send messages to yourself</h4>";
}
if (empty($errors)) {
$sth = $db->prepare("SELECT * FROM " . OSDB_USERS . " \n\t\t\tWHERE LOWER(user_name) = ? LIMIT 1");
$sth->bindValue(1, strtolower($PMName), PDO::PARAM_STR);
$result = $sth->execute();
if ($sth->rowCount() <= 0) {
$errors .= "<h4>User not found</h4>";
} else {
$row = $sth->fetch(PDO::FETCH_ASSOC);
$userID = $row["user_id"];
}
}
if (!empty($errors)) {
echo $errors;
} else {
if (isset($userID) and is_numeric($userID) and $userID != OS_GetUserID()) {
OS_add_custom_field($userID, time() . "|" . OS_GetUserID() . "||p.m.0", $PMText);
$MailText = $PMText;
$PMName = "";
$PMText = "";
?>
<h4>Message was sent successfully</h4><?php
//SEND EMAIL NOTIFICATION
if (!isset($_SESSION["mail_sent"])) {
//$row = $sth->fetch(PDO::FETCH_ASSOC);
$_SESSION["mail_sent"] = 1;
global $lang;
global $mail;
global $DefaultHomeTitle;
$message = "You have just received a private message from " . $_SESSION["username"] . "<br />";
$message .= "Click on the following link to read the message<br />";
$message .= "" . OS_HOME . "?action=pm&inbox";
$message .= "<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />";
$message .= convEnt($MailText);
$message .= "<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />{$DefaultHomeTitle}";
require "inc/class.phpmailer.php";
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->SetFrom($lang["email_from"], $lang["email_from_full"]);
$mail->AddReplyTo($lang["email_from"], $lang["email_from_full"]);
$mail->AddAddress($row["user_email"], "");
$mail->Subject = "New Private Message";
$mail->MsgHTML($message);
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
}
} else {
?>
<h4>The message could not be sent</h4><?php
}
}
}
$code = generate_hash(8);
$_SESSION["code"] = $code;
?>
<form action="" method="post" accept-charset="UTF-8">
<table>
<tr class="row">
<td width="70" class="padLeft"><b>To:</b></td>
<td><input type="text" value="<?php
echo $PMName;
?>
" size="65" name="pm_name" /></td>
</tr>
<tr class="row">
<td width="70" class="padLeft"><b>Message:</b></td>
<td><textarea name="pm_message" rows="9" cols="80" ><?php
echo $PMText;
?>
</textarea></td>
</tr>
<tr class="row">
<td width="70" class="padLeft"></td>
<td><input type="submit" value="Send PM" class="menuButtons" /></td>
</tr>
</table>
<input type="hidden" name="code" value="<?php
echo $code;
?>
" />
</form>
<?php
}
//SEND MESSAGE (USER ID)
if (isset($_GET["send"]) and is_numeric($_GET["send"])) {
$uid = safeEscape((int) $_GET["send"]);
if (OS_GetUserID() == $uid) {
?>
<h4>You can not send messages to yourself</h4>
<?php
} else {
if (isset($_POST["pm_message"]) and isset($_SESSION["code"]) and isset($_POST["code"])) {
if ($_SESSION["code"] != $_POST["code"]) {
$errors .= "<div>Form is not valid. Try again.</div>";
}
$PMText = strip_tags($_POST['pm_message']);
if (strlen($PMText) <= 2) {
$errors .= "<div>There are not enough characters in the message</div>";
}
if (!empty($errors)) {
?>
<h4><?php
echo $errors;
?>
</h4><?php
} else {
//ADD MESSAGE
//ARG: TO - user ID, FROM - time_UserID, message
$sth = $db->prepare("SELECT * FROM " . OSDB_USERS . " WHERE user_id = ? LIMIT 1");
$sth->bindValue(1, $uid, PDO::PARAM_INT);
$result = $sth->execute();
if ($sth->rowCount() >= 1) {
OS_add_custom_field($uid, time() . "|" . OS_GetUserID() . "||p.m.0", $PMText);
}
?>
<h4>Message was sent successfully</h4><?php
}
}
$code = generate_hash(8);
$_SESSION["code"] = $code;
$sth = $db->prepare("SELECT * FROM " . OSDB_USERS . " WHERE user_id = ? LIMIT 1");
$sth->bindValue(1, $uid, PDO::PARAM_INT);
$result = $sth->execute();
if ($sth->rowCount() >= 1) {
$row = $sth->fetch(PDO::FETCH_ASSOC);
$sendTo = $row["user_name"];
?>
<form action="" method="post" accept-charset="UTF-8">
<table>
<tr class="row">
<td width="120" class="padLeft"><b>Send to:</b></td>
<td><?php
echo $sendTo;
?>
</td>
</tr>
<tr class="row">
<td width="120" class="padLeft"><b>Message:</b></td>
<td><textarea name="pm_message" rows="9" cols="80" ></textarea></td>
</tr>
<tr class="row">
<td width="120" class="padLeft"></td>
<td><input type="submit" value="Send PM" class="menuButtons" /></td>
</tr>
</table>
<input type="hidden" name="code" value="<?php
echo $code;
?>
" />
</form>
<?php
if (isset($_GET["m"])) {
$sth = $db->prepare("SELECT * FROM " . OSDB_CUSTOM_FIELDS . " WHERE field_name = ? ");
$sth->bindValue(1, safeEscape($_GET["m"]), PDO::PARAM_STR);
$result = $sth->execute();
$row = $sth->fetch(PDO::FETCH_ASSOC);
$dateFor = explode("|", $row["field_name"]);
$date = (int) $dateFor[0];
//print_r($dateFor);
?>
<div class="padTop"></div>
<table>
<tr class="row">
<td class="padLeft"><b><?php
echo $sendTo;
?>
</b>, <?php
echo date($DateFormat, $date);
?>
</td>
</tr>
<tr>
<td><?php
echo convEnt($row["field_value"]);
?>
</td>
</tr>
</table>
<?php
}
} else {
?>
<h4>User not found</h4><?php
}
}
}
//SENT ITEMS
if (isset($_GET["sent_items"]) and is_logged()) {
?>
<h4>Sent items</h4><?php
//GET ALL MESSAGES
if (!empty($_GET["sent_items"]) and is_numeric($_GET["sent_items"]) and isset($_GET["m"])) {
$id = safeEscape((int) $_GET["sent_items"]);
$field = safeEscape($_GET["m"]);
$sql = "AND c.field_name = ? ";
} else {
$sql = "";
}
$sth = $db->prepare("SELECT COUNT(*) FROM " . OSDB_CUSTOM_FIELDS . " as c\n\t\tWHERE c.field_name LIKE ? {$sql}");
$sth->bindValue(1, "%|" . (int) $_SESSION["user_id"] . "||p.m.%", PDO::PARAM_STR);
if (!empty($sql)) {
$sth->bindValue(2, $field, PDO::PARAM_STR);
}
$result = $sth->execute();
$r = $sth->fetch(PDO::FETCH_NUM);
$numrows = $r[0];
$result_per_page = 10;
$offset = os_offset($numrows, $result_per_page);
$sth = $db->prepare("SELECT c.field_id, c.field_name, c.field_value, u.user_name, u.user_avatar\n\t\tFROM " . OSDB_CUSTOM_FIELDS . " as c\n\t\tLEFT JOIN " . OSDB_USERS . " as u ON u.user_id = c.field_id\n\t\tWHERE c.field_name LIKE ? {$sql}\n\t\tORDER BY c.field_name DESC\n\t\tLIMIT {$offset}, {$result_per_page}");
$sth->bindValue(1, "%|" . OS_GetUserID() . "||p.m.%", PDO::PARAM_STR);
if (!empty($sql)) {
$sth->bindValue(2, $field, PDO::PARAM_STR);
}
$result = $sth->execute();
?>
<table>
<?php
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$dateFor = explode("|", $row["field_name"]);
$date = $dateFor[0];
if (!isset($_GET["m"])) {
$text = limit_words(convEnt($row["field_value"]), 40);
} else {
$text = AutoLinkShort(convEnt($row["field_value"]));
}
?>
<tr class="row">
<td width="140"><a href="<?php
echo OS_HOME;
?>
?action=pm&sent_items=<?php
echo $row["field_id"];
?>
&m=<?php
echo $row["field_name"];
?>
"><b><?php
echo $row["user_name"];
?>
</b>, <?php
echo date($DateFormat, $date);
?>
</a></td>
<td><?php
echo $text;
?>
<?php
if (isset($_GET["m"])) {
?>
<div class="padTop">
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&send=<?php
echo $row["field_id"];
?>
&m=<?php
echo $_GET["m"];
?>
">[SEND MESSAGE]</a>
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&sent_items">« Back</a>
</div>
<?php
} else {
?>
<a href="<?php
echo OS_HOME;
?>
?action=pm&sent_items=<?php
echo $row["field_id"];
?>
&m=<?php
echo $row["field_name"];
?>
">more » </a>
<?php
}
?>
</td>
</tr>
<?php
}
if ($sth->rowCount() <= 0) {
?>
<tr><td>No new messages</td></tr><?php
}
?>
</table>
<?php
os_pagination($numrows, $result_per_page, 5, 1, '&sent_items');
}
//INBOX MESSAGES
if (isset($_GET["inbox"]) and is_logged()) {
?>
<h4>Inbox</h4><?php
if (!empty($_GET["inbox"]) and is_numeric($_GET["inbox"]) and isset($_GET["m"])) {
$id = safeEscape((int) $_GET["inbox"]);
$field = safeEscape($_GET["m"]);
$sql = "AND c.field_name = :field_name ";
$field_name = substr($field, 0, -1) . "1";
} else {
$sql = "";
}
$sth = $db->prepare("SELECT COUNT(*) FROM " . OSDB_CUSTOM_FIELDS . " as c\n\t\tWHERE c.field_id = '" . OS_GetUserID() . "' {$sql}");
//$sth->bindValue(':field_id', "%_".OS_GetUserID()."__p.m.%", PDO::PARAM_STR);
//$sth->bindValue(1, "%_".OS_GetUserID()."__p.m.%", PDO::PARAM_STR);
if (!empty($sql)) {
$sth->bindValue(':field_name', $field, PDO::PARAM_STR);
}
//$sth->bindValue(2, $field, PDO::PARAM_STR);
$result = $sth->execute();
$r = $sth->fetch(PDO::FETCH_NUM);
$numrows = $r[0];
$result_per_page = 10;
$offset = os_offset($numrows, $result_per_page);
$sth = $db->prepare("SELECT c.field_id, c.field_name, c.field_value, u.user_name, u.user_avatar\n\t\tFROM " . OSDB_CUSTOM_FIELDS . " as c\n\t\tLEFT JOIN " . OSDB_USERS . " as u ON u.user_id = c.field_id\n\t\tWHERE c.field_id = '" . OS_GetUserID() . "'\n\t\tAND field_name LIKE('%||p.m.%')\n\t\t{$sql}\n\t\tORDER BY c.field_name DESC\n\t\tLIMIT {$offset}, {$result_per_page}");
//$sth->bindValue(':field_id', "%_".OS_GetUserID()."__p.m.%", PDO::PARAM_STR);
if (!empty($sql)) {
$sth->bindValue(':field_name', $field, PDO::PARAM_STR);
}
$result = $sth->execute();
//UPDATE "read" message
if (!empty($_GET["inbox"]) and is_numeric($_GET["inbox"]) and isset($_GET["m"])) {
$field = safeEscape($_GET["m"]);
$field_name = substr($field, 0, -1) . "1";
$result = $db->update(OSDB_CUSTOM_FIELDS, array("field_name" => $field_name), "field_name = '" . $field . "'");
}
?>
<table>
<?php
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$dateFor = explode("|", $row["field_name"]);
$date = $dateFor[0];
$FromID = $dateFor[1];
$read = substr($row["field_name"], strlen($row["field_name"]) - 1, 1);
if ($read == 1) {
$col = '686A6B';
$readTxt = 'read';
} else {
$col = 'A41600';
$readTxt = '<b>new</b>';
}
if (!isset($_GET["m"])) {
$text = limit_words(convEnt($row["field_value"]), 12);
if ($read == 0) {
$text = '<span style="color: #000;"><b>' . convEnt($text) . '<b/></span>';
}
if ($read == 1) {
$text = '<span style="color: #686A6B;">' . convEnt($text) . '</span>';
}
} else {
$text = AutoLinkShort(convEnt($row["field_value"]));
}
?>
<?php
if (!isset($_GET["m"])) {
?>
<tr class="row">
<td width="120" class="padLeft">
<a href="<?php
echo OS_HOME;
?>
?action=pm&inbox=<?php
echo $FromID;
?>
&m=<?php
echo $row["field_name"];
?>
"><span style="color: #<?php
echo $col;
?>
"><b><?php
echo OS_GetUsernameByUserID($FromID);
?>
</b></span></a>
</td>
<td width="600"><a href="<?php
echo OS_HOME;
?>
?action=pm&inbox=<?php
echo $FromID;
?>
&m=<?php
echo $row["field_name"];
?>
"><?php
echo $text;
?>
</a></td>
<td><?php
echo date($DateFormat, $date);
?>
</td>
</tr>
<?php
} else {
?>
<tr class="row">
<td class="padLeft"><span style="color: #<?php
echo $col;
?>
"><b><?php
echo OS_GetUsernameByUserID($FromID);
?>
</b>, <?php
echo date($DateFormat, $date);
?>
</span></td>
</tr>
<tr>
<td><?php
echo $text;
?>
</td>
</tr>
<tr>
<td><div class="padTop padBottom">
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&send=<?php
echo $FromID;
?>
&m=<?php
echo $_GET["m"];
?>
">[SEND MESSAGE]</a>
<a class="menuButtons" href="<?php
echo OS_HOME;
?>
?action=pm&inbox">« Back</a>
</div></td>
</tr>
<?php
}
?>
<?php
}
if ($sth->rowCount() <= 0) {
?>
<tr><td>No new messages</td></tr><?php
}
?>
</table>
<?php
os_pagination($numrows, $result_per_page, 5, 1, '&inbox');
}
?>
<div class="padTop" style="margin-top:124px;"></div>
</div>
</div>
</div>
</div>
</div>
<?php
}
}
header('location: ' . OS_HOME . '?action=signature&sig=' . $row["id"] . '');
die;
} else {
header('location: ' . OS_HOME . '?action=signature¬_found');
die;
}
}
//Add link to MISC menu
if (SIG_MENU == 1) {
if (SIG_USE == 1 and !is_logged()) {
} else {
AddEvent("os_add_menu_misc", "OS_ShowSigMenu");
}
}
//Hook function
if (OS_GetAction("signature")) {
AddEvent("os_start", "OS_Signatures");
}
function OS_ShowSigMenu()
{
?>
<li><a href="<?php
echo OS_HOME;
?>
?action=signature">Signatures</a></li>
<?php
}
function OS_ShowSignatureForRegistered()
{
?>
<div class="clr"></div>