public function getArticles() { $db =& Jfactory::getDBO(); if (isset($_GET['catid'])) { $catid = $_GET['catid']; } else { if (isset($_POST['catid'])) { $catid = $_POST['catid']; } } if (isset($catid)) { $sql = "select c.id, c.title, c.introtext, c.fulltext, c.catid, c.created_by, c.images, c.urls, c.hits," . " u.name, u.username, u.email, u.usertype, cc.title as cat_title" . " from #__content c left join #__categories cc on (c.catid = cc.id) left join #__users u on (c.created_by = u.id)" . " where catid = " . $catid; $db->setQuery($sql); $objectList = $db->loadObjectList(); if (!empty($objectList)) { $string = XMLSerializer::generateValidXmlFromArray($objectList, 'articles_data'); $result = WebserviceHelper::constructResultData(200, 'Articles Listed', $string, "getArticles"); return $result->asXML(); } else { $result = WebserviceHelper::constructResult(200, 'No Articles associated to the category id', "getArticles"); return $result->asXML(); } } else { $result = WebserviceHelper::constructResult(500, 'No category id specified', "getArticles"); return $result->asXML(); } }
public function getUserByUsername($apikey, $secret) { if (!JOM_SOCIAL) { return $this->getBaseUserByUsername($apikey, $secret); } $auth = new Auth($apikey, $secret); if ($auth->isAuthenticate()) { if (isset($_GET['username'])) { $username = $_GET['username']; } else { if (isset($_POST['username'])) { $username = $_POST['username']; } } } else { $result = WSHelper::constructResult(500, 'APIKey and secret key does not match', "getUserByName"); return $result->asXML(); } if (!isset($username)) { $result = WebserviceHelper::constructResult(500, 'One of the required fields is not set', "getBaseUserById"); return $result->asXML(); } $db =& JFactory::getDBO(); $sql = "SELECT `id` , `name` , `username` , `email` , `usertype` ,\r\n\t\t\t\t\tSTATUS , points, avatar, thumb, friendcount\r\n\t\t\t\t\tFROM jos_users, jos_community_users\r\n\t\t\t\t\tWHERE jos_users.id = jos_community_users.userid and jos_users.username='******'"; $db->setQuery($sql); $user = $db->loadObject(); //$user->thumb = 'http://'.$_SERVER["SERVER_NAME"].'/'.$user->thumb; //$user->avatar = 'http://'.$_SERVER["SERVER_NAME"].'/'.$user->avatar; //$user->fields = $this->_getUserFields($username, 'username') ; if ($db->getErrorNum()) { $result = WebserviceHelper::constructResult(500, $db->stderr(), "getUserByName"); return $result->asXML(); } else { $user->thumb = 'http://' . $_SERVER["SERVER_NAME"] . '/' . $user->thumb; $user->avatar = 'http://' . $_SERVER["SERVER_NAME"] . '/' . $user->avatar; $fields = $this->_getUserFields($username, 'username'); $this->_renderFields($fields, $user); //print_r($user); //die(); $string = XMLSerializer::generateValidXmlFromObj($user, 'user_data'); $result = WebserviceHelper::constructResultData(200, 'User Object Loaded', $string, "getUserByName"); return $result->asXML(); } }