0 && $tileNum<4001 && (strcmp($sponsor,"")!= 0 || strcmp($delTile,"")!= 0 )){ $link = mysql_connect('localhost:2082','jclassyc_swetusr', 'SwetSponsor15'); if (!$link){ die('Unable to connect'); } mysql_select_db('jclassyc_wrdp1') or die('Unable to select'); $rowNum = $tileNum - (($tileNum-1) % 25) ; $rowOffset = ($tileNum-1) % 25; $qrow = mysql_real_escape_string($rowNum); $result = mysql_query("SELECT rowdesc FROM swet_row_desc WHERE row='$qrow'"); if (!result){ die("ERROR WITH SYSTEM"); } $row = mysql_fetch_row($result); $rowDesc = $row[0]; $statusMsg = ""; $diffPos = ""; if (strcmp($rowDesc[$rowOffset],"0")==0){ if ($subTile){ $qtile = mysql_real_escape_string($tileNum); $qsponsor = mysql_real_escape_string($sponsor); $result = mysql_query("INSERT INTO swet_sponsors VALUES('$qtile','$qsponsor')"); if (!$result){ die(mysql_error()); } $diffPos = substr($rowDesc, 0, $rowOffset)."1".substr($rowDesc, $rowOffset+1); if ($tileNum>3000){ $qmsg = mysql_real_escape_string($msg); $result = mysql_query("INSERT INTO swet_msg VALUES('$qtile','$qmsg')"); if (!$result){ die('Error updating msgs: '.mysql_error()); } } } if ($delTile){ $statusMsg = "Tile ".$tileNum." is not sponsored"; } } else{ echo "DELETE"; if ($subTile){ $statusMsg = "Tile ".$tileNum." has already been sponsored."; } if ($delTile){ $qtile = mysql_real_escape_string($tileNum); $qsponsor = mysql_real_escape_string($sponsor); $result = mysql_query("DELETE FROM swet_sponsors WHERE tile='$qtile'"); if (!$result){ die(mysql_error()); } $diffPos = substr($rowDesc, 0, $rowOffset)."0".substr($rowDesc, $rowOffset+1); if ($tileNum>3000){ $qmsg = mysql_real_escape_string($msg); $result = mysql_query("DELETE FROM swet_msg WHERE tile='$qtile'"); if (!$result){ die('Error updating msgs: '.mysql_error()); } } } } if (strcmp($diffPos,"")!=0){ $result = mysql_query("UPDATE swet_row_desc SET rowdesc='$diffPos' WHERE row='$qrow'"); if (!$result){ die('Error updating records: '.mysql_error()); } $statusMsg = "Records Updated"; } mysql_close($link); } } ?>

Tile Number (1-4000)
Name (max 50 characters)
Message (max 160 characters)	0