$_GET["action"] = "";
// So you don't trigger the close action later
}
if ($_POST["action"] == "doCustomPick") {
$school = preg_replace('/[^a-zA-Z]+/i', '', getSingleton("fch_schools", "school_name", " WHERE school_id = \"" . $_POST["schoolID"] . "\""));
debug("DoCustomPick. School is " . $school);
$playerID = preg_replace('/[^a-z\\d ]/i', '', $_POST["first"] . $_POST["last"] . $school);
$first = $_POST["first"];
$last = $_POST["last"];
$position = $_POST["position"];
$schoolID = $_POST["schoolID"];
debug("DoCustomPick. {$first} {$last} {$position} {$schoolID}");
if (intval(selectCount("fch_draft_customplayer", " WHERE playerID = \"{$playerID}\"")) > 0) {
echo displayResults(getReturnCode(0, "Error: Someone else has already made this custom pick."));
} else {
$result = executeGenericInsertSQL("INSERT INTO fanta66_joomla.fch_draft_customplayer (id, userID, leagueID, first, last, playerID,position ,schoolID ) VALUES (NULL, {$userID}, {$leagueID}, \"{$first}\", \"{$last}\",\"{$playerID}\", \"{$position}\", \"{$schoolID}\")");
if ($result == -1) {
$r["msg"] = "There has been a database error.";
$r["status"] = 0;
echo displayResults($r);
return;
}
echo displayResults(draftPlayer($userID, $leagueID, $playerID, $position, $_POST["transactionID"], "C"));
}
}
if ($_POST["action"] == "skipPick") {
debug("Calling skipPick: User="******"userID"] . " leagueID = " . $_POST["leagueID"]);
echo displayResults(draftPlayer($_POST["userID"], $_POST["leagueID"], "PassedPick", "X", $transactionID, "P"));
}
// If we did a POST, purge GET.
if (strlen($_POST["action"]) > 0) {
<?php
require_once "fch-lib.php";
$userID = getUserID();
$os = "";
debug("regarding-league");
//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");
function generateUserPreferences($userID)
{
debug("<B>GenerateUserPreferences</b>");
$season = getSeason();
$prefCount = intval(selectCount("fch_user_preferences", " WHERE userID = {$userID} and season = \"{$season}\""));
// 1. Is there a preference row at all?
if ($prefCount == 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);
}
// 2. Is there a league in the preference row?
$displayLeague = getSingleton("fch_user_preferences", "displayLeague", " WHERE userID = {$userID}");
debug("Display League is ({$displayLeague})");
if ($displayLeague == "") {
debug("No display league set.");
// If not, see if he has a league at all.
$l = getSingleton("fch_league_membership", "leagueID", " WHERE userID = {$userID} and status = \"active\" and season = \"{$season}\" ORDER BY id desc LIMIT 0,1");
// If so, set it.
if ($l != "") {
debug("Setting display League {$l}");
executeGenericSQL("UPDATE fch_user_preferences SET displayLeague = {$l} WHERE userID = {$userID} ");
} else {
debug("Display League was already set.");
}
}
$leagueCount = intval(selectCount("fch_league_membership", " WHERE userID = {$userID} and status = \"active\" and season = \"{$season}\""));
$l = getSingleton("fch_league_membership", "leagueID", " WHERE userID = {$userID} and season = \"{$season}\" and status = \"active\" LIMIT 0,1");
executeGenericSQL("UPDATE fch_user_preferences SET displayLeague = {$l} WHERE userID = {$userID} ");
/*
if ($leagueCount < 2)
{
debug("generateUserPreferencesDeprecated, leaguecount < 2");
$sql = "
UPDATE fch_user_preferences SET displayLeague = ( SELECT leagueID
FROM fch_league_membership
WHERE leagueID = 35
AND userID = $userID
and season = \"$season\")
WHERE userID = $userID
";
executeGenericSql($sql);
}
*/
}
