//debug(selectCount("fch_user_preferences"," WHERE userID = $userID "));
if (selectCount("fch_user_preferences", " WHERE userID = {$userID} ") == 0) {
//debug("Creating preference row , ");
$key = rand(0, 2147483647);
$sql = "INSERT INTO `fanta66_joomla`.`fch_user_preferences` (`id` ,`userID` ,`displayLeague`, `secretKey`) VALUES (NULL , {$userID}, NULL, {$key});";
//debug($sql);
executeGenericInsertSQL($sql);
}
//if (getSingleton("fch_user_preferences","displayLeague", " WHERE userID = $userID") == NULL)
//generateUserPreferences($userID);
$leagueCount = intval(selectCount("fch_league_membership", " where userID = {$userID} "));
$season = getSeason();
$dbLeague = getSingleton("fch_user_preferences", "displayLeague", " WHERE userID = {$userID}");
if (strlen($dbLeague) == 0) {
debug("Setting default league.");
generateUserPreferences($userID);
}
/*
if ($leagueCount == 1)
{
debug("In only one league");
if (intval(selectCount("fch_league_membership", " WHERE userID = $userID and season = \"$season\"")) == 1)
{
debug("In only one league. Setting default membership.");
$thisLeague = getSingleton("fch_league_membership","leagueID"," WHERE season = \"$season\" and userID = $userID");
debug("Setting default league for user $userID to $thisLeague");
$sql = "
UPDATE fch_user_preferences SET displayLeague = $thisLeague
WHERE userID = $userID";
executeGenericSql($sql);
}
function addGMToLeague($leagueID, $userID, $displayName)
{
$con = initializeDB();
$season = getSeason();
$sql = <<<SQL
\tINSERT INTO fanta66_joomla.fch_league_membership (
\t\tid ,
\t\tleagueID ,
\t\tuserID ,
\t\tteamDisplayName,
\t\tseason,
\t\tstatus
\t\t)
\t\tVALUES (
\t\t\tNULL , {$leagueID}, {$userID}, "{$displayName}", "{$season}", "active"
\t\t);
\t\t
SQL;
//echo $sql;
$con->close();
executeGenericSQL($sql);
generateUserPreferences($userID);
return getReturnCode(1, "You have successfully joined the league.");
}
