Code: Select all
<?php
if (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}
$index = 1;
require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
include("modules/League/includes/league_functions.php");
$user_id = $cookie[0];
$current_ladder = $_GET[lid];
$players_count = 0;
opentable();
$ladders = sql_query("SELECT ladder_id, ladder_name, ladder_directory, sql_db, sql_username, sql_pw, sql_prefix, pri_color, sec_color
FROM ".$prefix."_league_ladders WHERE ladder_id = $current_ladder");
list($ladder_id, $ladder_name, $ladder_directory, $sql_db, $sql_username, $sql_pw, $sql_prefix, $pri_color, $sec_color) = sql_fetch_row($ladders);
connection($sql_db, $sql_username, $sql_pw);
$sql = 'SELECT * FROM `'.$sql_prefix.'_players`';
$result = mysql_query($sql) or die('SQL ['.$sql.'] caused: '. mysql_error());
//initialize variable as an array
$players = array();
//assuming you have a unique id for each player
//loop results
while ($row = mysql_fetch_assoc($result)) {
//store player ids inside an array
$players[] = $row['player_id'];
}
$num_players = count($players);
$user_profile = sql_query("SELECT user_id, username, user_status, user_avatar, total_matches, total_points, user_honor,
user_disputes, user_regdate FROM ".$prefix."_users WHERE user_id = $user_id");
list($user_id, $username, $user_status, $user_avatar, $total_matches, $total_points, $user_honor, $user_disputes, $user_regdate) = sql_fetch_row($user_profile);
if ($db->sql_numrows($db->sql_query("SELECT username FROM ".$sql_prefix."_users WHERE username='$username'")) > 0) $stop = "<center>"You are already registered in this ladder."</center><br>";
if (!$stop) {
$join_league = mysql_query("INSERT INTO ".$sql_prefix."_players
(`player_id` , `user_id` , `player_name` , `clan_id` , `player_rank`, `recieve_clan_invites`, `player_wins` , `player_losses` ,
`player_points` , `player_streak` , `player_avatar` , `clan_rank` , `permission_invite` , `permission_kick` ,
`career_wins` , `career_losses` , `career_games` , `career_points` , `career_streak` )
VALUES ('', '$user_id', '$username', '', '$num_players', '', '', '', '', '', '', '', '', '', '', '', '', '', '');");
echo "Thank-you $username, You have successfully joined $ladder_name !";
}
}else{
echo "$stop";
}
include("modules/League/includes/update_ranks.php");
closetable();
?>