diff --git a/docroot/TUve.swf b/docroot/TUve.swf
index 4a94369..9aedb36 100755
--- a/docroot/TUve.swf
+++ b/docroot/TUve.swf
Binary files differ
diff --git a/docroot/amfphp/services/tuve.php b/docroot/amfphp/services/tuve.php
index 8ed1b61..b7b487c 100755
--- a/docroot/amfphp/services/tuve.php
+++ b/docroot/amfphp/services/tuve.php
@@ -16,33 +16,6 @@
}
}
- /* Get Picture */
- function getPic($data) {
- $query = "SELECT profile_image,main_image FROM users WHERE username LIKE '$data'";
-
- if (!$result = @$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
-
- $row = $result->fetch_assoc();
-
- $imIndex = $row['profile_image'];
- if ($imIndex == 0)
- return($row['main_image'] . "-small.png");
- else {
- switch($imIndex) {
- case 1:
- return("http://www.ubixonline.com/images/sb/none.gif-small.png");
- case 2:
- return("http://www.ubixonline.com/images/sb/female_icon.png-small.png");
- case 3:
- return("http://www.ubixonline.com/images/sb/male_icon.png-small.png");
- }
- }
- }
-
/* Function For TUplayer */
function pVid($vid) {
if ($vid == 0)
@@ -186,32 +159,6 @@
return($return_array);
}
- function getFullInfo($data) {
- $query = "SELECT thumb,v.artist,title,bio,photo,description FROM videos v INNER JOIN artists a ON v.aid = a.aid WHERE v.vid = $data";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database [$query] query error: " . $errno);
- }
- if ($result->num_rows == 0) {
-
- $query = "SELECT thumb,artist,title,'NA' as bio,'/images/UbixCube.swf' AS photo FROM videos WHERE vid = $data";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database [$query] query error: " . $errno);
- }
-
-
- }
-
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
-
-
function getNextMovie() {
$query = "SELECT file,artist,title FROM videos";
if (!$result = @$this->mysqli->query($query)) {
@@ -332,7 +279,7 @@
}
function getFriends($uid) {
- $query = "SELECT username,uid FROM friends f INNER JOIN users u ON f.fid = u.uid WHERE oid = $uid";
+ $query = "SELECT username,uid FROM friends f INNER JOIN users u ON f.fid = u.uid WHERE oid = $uid ORDER BY username";
if (!$result=@$this->mysqli->query($query)) {
$errno=$this->mysqli->errno;
$this->mysqli->close();
@@ -345,93 +292,5 @@
}
- function updateView($data) {
- $uid = $data['uid'];
- $viewXML = $data['viewXML'];
- $query = "UPDATE users SET viewXML = '$viewXML' WHERE uid = $uid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- return(null);
- }
-
- function getPublicView($username) {
- $query = "SELECT viewXML FROM users WHERE username = '$username'";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
- function getPortal($pid) {
- $query = "SELECT portalXML,portalName FROM tmpP WHERE pid = $pid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
-
- function cmpMail($data) {
- $query = "SELECT * FROM users WHERE uid = $data[mailTo]";
- $result = @$this->mysqli->query($query);
- $userInfo = $result->fetch_array(MYSQLI_ASSOC);
-
- $name = $userInfo['firstName'] . " " . $userInfo['lastName'];
-
- switch($data['pid']) {
- case -1:
- $podName = "Mega Pod";
- break;
- case -3:
- $podName = "Friends Pod";
- break;
- default:
- $query = "SELECT * FROM podz WHERE pid = $data[pid]";
- $result = @$this->mysqli->query($query);
- $podInfo = $result->fetch_array(MYSQLI_ASSOC);
- $podName = $podInfo['podName'];
- break;
- }
-
- return(array(array('mailTo' => $name,'toUID' => $data['mailTo'],'podName' => $podName,'pid' => $data['pid'])));
- }
-
- function getPod($pid) {
- $query = "SELECT * FROM podz WHERE pid = $pid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: [$query] " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
-
- function sendMail($data) {
- $query = "SELECT username FROM users WHERE uid = $data[toUID]";
- $result = $this->mysqli->query($query);
- $userInfo = $result->fetch_array(MYSQLI_ASSOC);
-
- $email = $userInfo['username'] . "@podz.ubixos.com";
- $from = "From: " . $data['fromName'] . " <" . $data['fromEmail'] . "@cupid.ubixos.com>";
- mail($email,$data['subject'],$data['message'],$from);
-
- return;
- }
-
-
}
?>
diff --git a/docroot/amfphp/services/tuveAdmin.php b/docroot/amfphp/services/tuveAdmin.php
index 62eaec1..8bf4ccb 100755
--- a/docroot/amfphp/services/tuveAdmin.php
+++ b/docroot/amfphp/services/tuveAdmin.php
@@ -325,7 +325,7 @@
return($return_array);
}
- function getChans($data) {
+ function getUserChans($data) {
$sKey = $data['skey'];
$uid = $data['uid'];
if ($data['gid'] == 1)
@@ -615,95 +615,6 @@
return($return_array);
}
- function getFriends($uid) {
- $query = "SELECT friendsXML FROM users WHERE uid = $uid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
-
-
- function updateView($data) {
- $uid = $data['uid'];
- $viewXML = $data['viewXML'];
- $query = "UPDATE users SET viewXML = '$viewXML' WHERE uid = $uid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- return(null);
- }
-
- function getPublicView($username) {
- $query = "SELECT viewXML FROM users WHERE username = '$username'";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
- function getPortal($pid) {
- $query = "SELECT portalXML,portalName FROM tmpP WHERE pid = $pid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
-
- function cmpMail($data) {
- $query = "SELECT * FROM users WHERE uid = $data[mailTo]";
- $result = @$this->mysqli->query($query);
- $userInfo = $result->fetch_array(MYSQLI_ASSOC);
-
- $name = $userInfo['firstName'] . " " . $userInfo['lastName'];
-
- switch($data['pid']) {
- case -1:
- $podName = "Mega Pod";
- break;
- case -3:
- $podName = "Friends Pod";
- break;
- default:
- $query = "SELECT * FROM podz WHERE pid = $data[pid]";
- $result = @$this->mysqli->query($query);
- $podInfo = $result->fetch_array(MYSQLI_ASSOC);
- $podName = $podInfo['podName'];
- break;
- }
-
- return(array(array('mailTo' => $name,'toUID' => $data['mailTo'],'podName' => $podName,'pid' => $data['pid'])));
- }
-
- function getPod($pid) {
- $query = "SELECT * FROM podz WHERE pid = $pid";
- if (!$result=@$this->mysqli->query($query)) {
- $errno=$this->mysqli->errno;
- $this->mysqli->close();
- trigger_error("AMFPHP Remoting database SELECT query error: [$query] " . $errno);
- }
- while ($row = $result->fetch_assoc()) {
- $return_array[] = $row;
- }
- return($return_array);
- }
-
/* Send Mail For TUve */
function sendMail($data) {
$oid = $data['tid'];
@@ -735,7 +646,7 @@
}
- $query = "SELECT firstname,lastname,email FROM users WHERE uid = $oid";
+ $query = "SELECT firstname,lastname,email,notifications FROM users WHERE uid = $oid";
if (!$result=@$this->mysqli->query($query)) {
$errno=$this->mysqli->errno;
$this->mysqli->close();
@@ -743,11 +654,58 @@
}
$row = $result->fetch_assoc();
-
- send_mail("$row[firstname] $row[lastname] <$row[email]>","You have a new message waiting for you.
Message Sender: $from
Message Subject: $data[subject]
Please follow this link http://www.tuve.tv/ to log into your account.
Sincerely,
TUve Staff
","New Message On TUve","support@tuve.tv","TUve Support");
+ if ($row['notifications'][N_MAIL])
+ send_mail("$row[firstname] $row[lastname] <$row[email]>","You have a new message waiting for you.
Message Sender: $from
Message Subject: $data[subject]
Please follow this link http://www.tuve.tv/ to log into your account.
Sincerely,
TUve Staff
","New Message On TUve","support@tuve.tv","TUve Support");
return;
+ } /* End Send Mail for TUve */
+ /* Get Picture */
+ function getPic($data) {
+ $query = "SELECT profile_image,main_image FROM users WHERE username LIKE '$data'";
+
+ if (!$result = @$this->mysqli->query($query)) {
+ $errno=$this->mysqli->errno;
+ $this->mysqli->close();
+ trigger_error("AMFPHP Remoting database SELECT query error: " . $errno);
+ }
+
+ $row = $result->fetch_assoc();
+
+ $imIndex = $row['profile_image'];
+ if ($imIndex == 0)
+ return($row['main_image'] . "-small.png");
+ else {
+ switch($imIndex) {
+ case 1:
+ return("http://www.ubixonline.com/images/sb/none.gif-small.png");
+ case 2:
+ return("http://www.ubixonline.com/images/sb/female_icon.png-small.png");
+ case 3:
+ return("http://www.ubixonline.com/images/sb/male_icon.png-small.png");
+ }
+ }
}
+ function getChans() {
+ $query = "SELECT channel FROM channels";
+ if (!$result=@$this->mysqli->query($query)) {
+ $errno=$this->mysqli->errno;
+ $this->mysqli->close();
+ trigger_error("AMFPHP Remoting database [$query] query error: " . $errno);
+ }
+
+ if ($result->num_rows == 0) {
+ $return_array[] = array('channel' => '#General');
+ }
+ else {
+ while ($row = $result->fetch_assoc()) {
+ $return_array[] = $row;
+ }
+ }
+
+ return($return_array);
+ }
+
+
}
?>
diff --git a/docroot/images/profile/51.png b/docroot/images/profile/51.png
index 292887d..da222ac 100755
--- a/docroot/images/profile/51.png
+++ b/docroot/images/profile/51.png
Binary files differ