| 48 | if ($display_graphics == "") { | = | 48 | if ($display_graphics == "") { |
| 49 | $display_graphics = "N"; | 49 | $display_graphics = "N"; | |
| 50 | } | 50 | } | |
| 51 | $logo_width = $_POST['logo_width']; | 51 | $logo_width = $_POST['logo_width']; | |
| 52 | $rssurl = $_POST['rssurl']; | 52 | $rssurl = $_POST['rssurl']; | |
| 53 | $spread = $_POST['spread']; | 53 | $spread = $_POST['spread']; | |
| 54 | $UseSMTP = $_POST['UseSMTP']; | +- | ||
| 55 | if ($UseSMTP == "") { | |||
| 56 | $UseSMTP = "N"; | |||
| 57 | } | |||
| 58 | $SMTPHost = $_POST['SMTPHost']; | |||
| 59 | $SMTPUser = $_POST['SMTPUser']; | |||
| 60 | $SMTPPassWord = $_POST['SMTPPassWord']; | |||
| 61 | if ($spread == "" ) { | = | 54 | if ($spread == "" ) { |
| 62 | $spread = "N"; | 55 | $spread = "N"; | |
| 63 | } | 56 | } | |
| 64 | 57 | |||
| 65 | $sql = "UPDATE ".$football->prefix."variables SET admin_email='$admin_email', domain='$domain', offset='$offset', display_offset='$display_offset', game_display_offset='$game_display_offset', timezone='$timezone', timezone_display='$timezone_display', sitetitle='$sitetitle', copyright='$copyright', copyrightweb='$copyrightweb', showpicks='$showpicks', password_min_len='$password_min_len', bet_amount='$bet_amount', display_graphics='$display_graphics', logo_width='$logo_width', rssurl='$rssurl', spread='$spread', UseSMTP='$UseSMTP', SMTPHost='$SMTPHost', SMTPUser='$SMTPUser', SMTPPassWord='$SMTPPassWord' WHERE PoolID = '$PoolID'"; | <> | 58 | $sql = "UPDATE ".$football->prefix."variables SET admin_email='$admin_email', domain='$domain', offset='$offset', display_offset='$display_offset', game_display_offset='$game_display_offset', timezone='$timezone', timezone_display='$timezone_display', sitetitle='$sitetitle', copyright='$copyright', copyrightweb='$copyrightweb', showpicks='$showpicks', password_min_len='$password_min_len', bet_amount='$bet_amount', display_graphics='$display_graphics', logo_width='$logo_width', rssurl='$rssurl', spread='$spread' WHERE PoolID = '$PoolID'"; |
| 66 | = | 59 | ||
| 67 | $rs = $football->dbQuery($sql); | 60 | $rs = $football->dbQuery($sql); | |
| 68 | if( !$rs ) | 61 | if( !$rs ) | |
| 69 | { | 62 | { | |
| 70 | die("Error executing query"); | 63 | die("Error executing query"); | |
| 71 | } | 64 | } | |
| 82 | { | = | 75 | { |
| 83 | $PoolID = ""; | 76 | $PoolID = ""; | |
| 84 | $display = "none"; | 77 | $display = "none"; | |
| 85 | } | 78 | } | |
| 86 | if($display <> "none") | 79 | if($display <> "none") | |
| 87 | { | 80 | { | |
| 88 | $sql = "SELECT * FROM ".$football->prefix."variables WHERE PoolID = '$PoolID'"; | <> | 81 | $sql = "SELECT admin_email, domain, offset, display_offset, game_display_offset, timezone, timezone_display, sitetitle, copyright, copyrightweb, showpicks, password_min_len, bet_amount, display_graphics, logo_width, rssurl, spread FROM ".$football->prefix."variables WHERE PoolID = '$PoolID'"; |
| 89 | $rs = $football->dbQuery($sql); | = | 82 | $rs = $football->dbQuery($sql); |
| 90 | 83 | |||
| 91 | if( !$rs ) | 84 | if( !$rs ) | |
| 92 | { | 85 | { | |
| 93 | die("Error executing query"); | 86 | die("Error executing query"); | |
| 94 | } | 87 | } | |
| 95 | $row = mysql_fetch_object($rs); | <> | 88 | $row = mysql_fetch_array($rs); |
| 96 | if(!$row) $display = "none"; | = | 89 | if(!$row) $display = "none"; |
| 97 | else | 90 | else | |
| 98 | { | 91 | { | |
| 99 | $admin_email = $row->admin_email; | <> | 92 | $admin_email = $row[0]; |
| 100 | $domain = $row->domain; | 93 | $domain = $row[1]; | |
| 101 | $offset = $row->offset; | 94 | $offset = $row[2]; | |
| 102 | $display_offset = $row->display_offset; | 95 | $display_offset = $row[3]; | |
| 103 | $game_display_offset = $row->game_display_offset; | 96 | $game_display_offset = $row[4]; | |
| 104 | $timezone = $row->timezone; | 97 | $timezone = $row[5]; | |
| 105 | $timezone_display = $row->timezone_display; | 98 | $timezone_display = $row[6]; | |
| 106 | $sitetitle = $row->sitetitle; | 99 | $sitetitle = $row[7]; | |
| 107 | $copyright = $row->copyright; | 100 | $copyright = $row[8]; | |
| 108 | $copyrightweb = $row->copyrightweb; | 101 | $copyrightweb = $row[9]; | |
| 109 | $showpicks = $row->showpicks; | 102 | $showpicks = $row[10]; | |
| 110 | if ($showpicks == "") { | = | 103 | if ($showpicks == "") { |
| 111 | $showpicks = "N"; | 104 | $showpicks = "N"; | |
| 112 | } | 105 | } | |
| 113 | $password_min_len = $row->password_min_len; | <> | 106 | $password_min_len = $row[11]; |
| 114 | $bet_amount = $row->bet_amount; | 107 | $bet_amount = $row[12]; | |
| 115 | $display_graphics = $row->display_graphics; | 108 | $display_graphics = $row[13]; | |
| 116 | if ($display_graphics == "") { | = | 109 | if ($display_graphics == "") { |
| 117 | $display_graphics = "N"; | 110 | $display_graphics = "N"; | |
| 118 | } | 111 | } | |
| 119 | $logo_width = $row->logo_width; | <> | 112 | $logo_width = $row[14]; |
| 120 | $rssurl = $row->rssurl; | 113 | $rssurl = $row[15]; | |
| 121 | $spread = $row->spread; | 114 | $spread = $row[16]; | |
| 122 | $UseSMTP = $row->UseSMTP; | |||
| 123 | if ($UseSMTP == "") { | |||
| 124 | $UseSMTP = "N"; | |||
| 125 | } | |||
| 126 | $SMTPHost = $row->SMTPHost; | |||
| 127 | $SMTPUser = $row->SMTPUser; | |||
| 128 | $SMTPPassWord = $row->SMTPPassWord; | |||
| 129 | if ($spread == "") { | = | 115 | if ($spread == "") { |
| 130 | $spread = "N"; | 116 | $spread = "N"; | |
| 131 | } | 117 | } | |
| 132 | } | 118 | } | |
| 133 | mysql_free_result($rs); | 119 | mysql_free_result($rs); | |
| 134 | } | 120 | } | |
| 244 | <option value="<?php echo $row->url; ?>"<?php echo $row->url == $rssurl ? " Selected" : ""; ?>><? echo $row->rssname; ?></option> | = | 230 | <option value="<?php echo $row->url; ?>"<?php echo $row->url == $rssurl ? " Selected" : ""; ?>><? echo $row->rssname; ?></option> |
| 245 | <?php | 231 | <?php | |
| 246 | } | 232 | } | |
| 247 | ?> | 233 | ?> | |
| 248 | </select></td> | 234 | </select></td> | |
| 249 | </tr> | 235 | </tr> | |
| 250 | <tr class="WSGField"> | <> | ||
| 251 | <td class="WSGFieldHeader">Use SMTP to mail Users</td> | |||
| 252 | <td class="WSGFieldData" align="left"><input class="WSGInputText" type="checkbox" name="UseSMTP" value="Y" <?php echo $UseSMTP == "Y" ? " Checked" : ""; ?>></td> | |||
| 253 | </tr> | |||
| 254 | <tr class="WSGField"> | |||
| 255 | <td class="WSGFieldHeader">SMTP Host Name</td> | |||
| 256 | <td class="WSGFieldData" align="left"><input class="WSGInputText" type="text" name="SMTPHost" size="40" value="<? echo $SMTPHost;?>"></td> | |||
| 257 | </tr> | |||
| 258 | <tr class="WSGField"> | |||
| 259 | <td class="WSGFieldHeader">SMTP User</td> | |||
| 260 | <td class="WSGFieldData" align="left"><input class="WSGInputText" type="text" name="SMTPUser" size="40" value="<? echo $SMTPUser;?>"></td> | |||
| 261 | </tr> | |||
| 262 | <tr class="WSGField"> | |||
| 263 | <td class="WSGFieldHeader">SMTP Password</td> | |||
| 264 | <td class="WSGFieldData" align="left"><input class="WSGInputText" type="password" name="SMTPPassWord" size="40" value="<? echo $SMTPPassWord;?>"></td> | |||
| 265 | </tr> | |||
| 266 | ||||
| 267 | <tr><td colspan="2"><input type="hidden" name="__record_save__" value="1"> </td></tr> | = | 236 | <tr><td colspan="2"><input type="hidden" name="__record_save__" value="1"> </td></tr> |
| 268 | <tr class="WSGField"> | 237 | <tr class="WSGField"> | |
| 269 | <td class="WSGFieldData" colspan="2" align="center"><input class="WSGInputButton" type="submit" name="submit" value="Save Data"></td> | 238 | <td class="WSGFieldData" colspan="2" align="center"><input class="WSGInputButton" type="submit" name="submit" value="Save Data"></td> | |
| 270 | </tr> | 239 | </tr> | |
| 271 | </table> | 240 | </table> | |
| 272 | </center> | 241 | </center> | |