integrate mixpanel people

https://mixpanel.com/docs/people-analytics

1 files changed, 5 insertions, 2 deletions

diff --git a/pages/login.php b/pages/login.php
index 5042cd8..b8662ab 100644
--- a/pages/login.php
+++ b/pages/login.php
@@ -50,7 +50,7 @@ try {
 		//* Modify this to WHERE `email`

       //$sql = "SELECT `ID`, `isAdmin`, `openID`, `displayName` FROM `users` WHERE `email` = '$email'";

       //$sql = "SELECT `ID`, `isAdmin` FROM `users` WHERE `openID` = '$claimedid'";

-      $sql = "SELECT `ID`, `isAdmin`, `openID`, `displayName` FROM `users` WHERE `openID` = '$claimedid' OR `email` = '$email'";

+      $sql = "SELECT `ID`, `isAdmin`, `openID`, `displayName`, `dateJoined` FROM `users` WHERE `openID` = '$claimedid' OR `email` = '$email'";

       $result = mysql_query($sql);

       

       $_SESSION['isAdmin'] = false;

@@ -62,8 +62,8 @@ try {
          if (mysql_result($result, 0, 'isAdmin') == 1)

 				$_SESSION['isAdmin'] = true;

 			

-			//Use the displayname we have on record.

 			$display = mysql_result($result, 0, 'displayName');

+			$dateJoined = mysql_result($result, 0, 'dateJoined');

 			

 			// <DEBUG>

 			//Multiple accounts found?

@@ -115,6 +115,7 @@ try {
 			//echo "$sql <br /> <br />";

          if ($result) {

             $userID = mysql_insert_id();

+            $dateJoined = date(DateTime::ISO8601);

          } //Oh crap?

          else {

 				$errortext = "<br />new-user db register failure of unknown cause.\n

@@ -134,7 +135,9 @@ try {
       //$_SESSION['Passcode'] = MD5($Password.$Pepper.$Username);

       $_SESSION['accepted'] = 1;

       $_SESSION['userID'] = $userID;

+      $_SESSION['email'] = $email;

       $_SESSION['displayName'] = $display;

+      $_SESSION['dateJoined'] = $dateJoined;

 		

 		//The below is me hashing the claimedID.

 		$salt = "33qs5d4j6z98gt1a7n6b5d4x1c66f5nuh8a6d8g9j09aphgf56z5745";