Set up foreign keys within the database. There is a small chance I may have broken emails, unlocks, or chat. Will test :)

4 files changed, 6 insertions, 26 deletions

diff --git a/pages/chat.php b/pages/chat.php
index 8d3501b..4f903a8 100644
--- a/pages/chat.php
+++ b/pages/chat.php
@@ -1,7 +1,7 @@
 <?php

 htmlHeader(

 	array('stats', 'chat'), 'Chat', 

-	'BetaChat for Pathery.com', 

+	'Chat for Pathery.com', 

 	array('scores', 'dateformat')

 );

 ?>

@@ -76,7 +76,7 @@ function getChatDone(data) {
 		if (chat.userID == userObj.ID) {

 			strClass += ' self';

 		}

-		if (chat.userID == '-1') {

+		if (chat.userID == null || chat.userID <= 0) {

 			strClass += ' server';

 			chat.displayName = 'SERVER'

 		}

@@ -110,7 +110,7 @@ function getChatDone(data) {
 		p = p+ "	</div>";

 		

 		p = p+ " <div class='chatColumn2'>";

-		if (chat.userID == '-1') {

+		if (chat.userID == null || chat.userID <= 0) {

 			p = p+ "<span class='chatUsername"+usernameClass+"'><a href='home'>";

 		} else {

 			p = p+ "<span class='chatUsername"+usernameClass+"'><a href='achievements?id="+chat.userID+"' style='color:"+chat.displayColor+"'>";

diff --git a/pages/cp.php b/pages/cp.php
index f6efd30..d5fff2b 100644
--- a/pages/cp.php
+++ b/pages/cp.php
@@ -143,25 +143,5 @@ $displayName = $_SESSION['displayName'];
 <?php

 

 

-function chatFilter($chat) {

-   //cuss words

-   $chat = str_replace("fuck you", "i am moron", $chat);

-   $chat = str_replace("fuck", "dumb", $chat);

-	

-   $chat = str_replace("asshole", "dumb", $chat);

-   $chat = str_replace("damnit", "dumb", $chat);

-   $chat = str_replace("damn", "dumb", $chat);

-   $chat = str_replace("cunt", "dumb", $chat);

-   $chat = str_replace("shit", "dumb", $chat);

-   $chat = str_replace("bitch", "dumb", $chat);

-   $chat = str_replace("sucks ass", "is dumb", $chat);

-   $chat = str_replace("suck ass", "is dumb", $chat);

-   $chat = str_replace("stfu", "shutup", $chat);

-   $chat = str_replace("omfg", "omg", $chat);

-   $chat = str_replace("fuk", "dumb", $chat);

- return $chat;

-}

-

-

 htmlFooter();

 ?>

diff --git a/pages/login.php b/pages/login.php
index 07662c3..04b4083 100644
--- a/pages/login.php
+++ b/pages/login.php
@@ -139,7 +139,7 @@ try {
 				throwLoginError($d, "Unknown DB Registration failure");

             exit;

          }

-			addchat(-1, "New user registered: \"$display\"");

+			addchat(null, "New user registered: \"$display\"");

 			sendNewUserEmail($userID, $email, $display, $dateJoined);

       }

       //If 'remember me' use this for cookie password

@@ -193,7 +193,7 @@ Happy Pathing,
  The Pathery Team

 ";

 	$emailSubject = 'Welcome to Pathery.com!';

-	QueueEmail(0, $email, $emailSubject, $emailBody, 5, true);

+	QueueEmail(null, $email, $emailSubject, $emailBody, 5);

 }

 

 function throwLoginError($data, $explination) {

diff --git a/pages/massemail.php b/pages/massemail.php
index 2d80b17..d009cf9 100644
--- a/pages/massemail.php
+++ b/pages/massemail.php
@@ -69,7 +69,7 @@ if (isset($_POST['queueMassEmail']) AND $_POST['queueMassEmail'] == 'true') {
 		$tmpTitle = replaceByArray($tmpTitle, $replacements);

 		echo "$tmpBody <br />";

 		//This Sanitizes data - so no worries!

-		QueueEmail(0, $tmpEmail, $tmpTitle, $tmpBody, 100, true);

+		QueueEmail(null, $tmpEmail, $tmpTitle, $tmpBody, 100);

 	}

 	

 	echo "Complete!...<br/>";