public function __construct()
{
$this->_table_prefix = '#__' . TABLE_PREFIX . '_';
$this->_db = Jfactory::getDBO();
$this->_session = JFactory::getSession();
$this->_order_functions = new order_functions();
$this->_extra_field = new extra_field();
$this->_extraFieldFront = new extraField();
$this->_redhelper = new redhelper();
$this->_producthelper = new producthelper();
$this->_shippinghelper = new shipping();
}
/**
* Example Search method
*
* The sql must return the following fields that are used in a common display
* routine:
- title;
- href: link associated with the title;
- browsernav if 1, link opens in a new window, otherwise in the same window;
- section in parenthesis below the title;
- text;
- created;
* @param string Target search string
* @param string matching option, exact|any|all
* @param string ordering option, newest|oldest|popular|alpha|category
* @param mixed An array if the search it to be restricted to areas, null if search all
*
* @return array Search results
*/
public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null)
{
$result = array();
// jelenleg semmilyen paramétert nem veszek figyelembe és hozzáférés ellenörzés sincs.
$db = Jfactory::getDBO();
// témakorok
$db->setQuery('select t.megnevezes as title,
t.id,
"2" as browsernav,
"' . JText::_('TEMAKOROK') . '" as section,
"" as `text`,
t.letrehozva as created
from #__temakorok t
where t.megnevezes like "%' . $text . '%"
order by t.id DESC');
$res = $db->loadObjectList();
foreach ($res as $res1) {
$res1->href = 'index.php?option=com_szavazasok&view=szavazasoklist&temakor=' . $res1->id;
$result[] = $res1;
}
// szavazások
$db->setQuery('select sz.megnevezes as title,
sz.id,
"2" as browsernav,
"' . JText::_('SZAVAZASOK') . '" as section,
"" as `text`,
sz.letrehozva as created
from #__szavazasok sz
where sz.megnevezes like "%' . $text . '%"
order by sz.id DESC');
$res = $db->loadObjectList();
foreach ($res as $res1) {
$res1->href = 'index.php?option=com_alternativak&view=alternativaklist&szavazas=' . $res1->id;
$result[] = $res1;
}
// alternativák
$db->setQuery('select sz.megnevezes as title,
sz.id,
"2" as browsernav,
"' . JText::_('ALTERNATIVAK') . '" as section,
"" as `text`,
sz.letrehozva as created
from #__szavazasok sz, #__alternativak a
where a.szavazas_id = sz.id and a.megnevezes like "%' . $text . '%"
order by sz.id DESC');
$res = $db->loadObjectList();
foreach ($res as $res1) {
$res1->href = 'index.php?option=com_alternativak&view=alternativaklist&szavazas=' . $res1->id;
$result[] = $res1;
}
return $result;
}
public function __construct($params)
{
$this->_params = $params;
$this->_db = Jfactory::getDBO();
if (JRequest::getCmd('option') == 'com_joomleague') {
$p = JRequest::getInt('p', $params->get('default_project_id'));
} else {
$p = $params->get('default_project_id');
}
$this->_project_id = intval($p);
$this->_project = $this->getProject();
$this->_round_id = JRequest::getInt('r');
$this->_division_id = JRequest::getInt('division', 0);
$this->_team_id = JRequest::getInt('tid', 0);
}
/**
* make sure the version table has the proper structure (1.0 import !)
* if not, update it
*/
function _checkVersionTable()
{
$db = Jfactory::getDBO();
$res = $db->getTableFields('#__joomleague_version');
$cols = array_keys(reset($res));
if (!in_array('major', $cols)) {
$query = ' ALTER TABLE #__joomleague_version ADD `major` INT NOT NULL ,
ADD `minor` INT NOT NULL ,
ADD `build` INT NOT NULL ,
ADD `count` INT NOT NULL ,
ADD `revision` VARCHAR(128) NOT NULL ,
ADD `file` VARCHAR(255) NOT NULL';
$db->setQuery($query);
if (!$db->query()) {
echo JText::_('Failed updating version table');
}
}
}
/**
* rekord sorozat beolvasása az adatbázisból
* @JRequest filter, order, limit, limitstart
* @return array of records
*/
public function getItems($state)
{
$db = Jfactory::getDBO();
$query = $this->getListQuery($state);
$limit = 100000;
$limitstart = $state->limitstart;
if ($limit == '') {
$limit = 20;
}
if ($limit == 0) {
$limit = 20;
}
if ($limitstart == '') {
$limitstart = 0;
}
$db->setQuery($query, $limitstart, $limit);
return $db->loadObjectList();
}
/**
* rekord sorozat beolvasása az adatbázisból
* @JRequest filter, order, limit, limitstart
* @return array of records
*/
public function getItems($state)
{
$db = Jfactory::getDBO();
$query = $this->getListQuery($state);
$limit = JRequest::getvar('limit', 20);
$limitstart = JRequest::getvar('limitstart', 0);
if ($limit == '') {
$limit = 20;
}
if ($limit == 0) {
$limit = 20;
}
if ($limitstart == '') {
$limitstart = 0;
}
$db->setQuery($query, $limitstart, $limit);
return $db->loadObjectList();
}
/**
* Post-flight extension installer method.
*
* This method runs after all other installation code.
*
* @param $type
* @param $parent
*
* @return void
* @since 1.0.3
*/
function postflight($type, $parent)
{
// Display a move files and folders to parent.
jimport('joomla.filesystem.folder');
$srcBase = JPATH_PLUGINS . '/editors/arkeditor/layouts/joomla/';
$dstBase = JPATH_SITE . '/layouts/joomla/';
$folders = JFolder::folders($srcBase);
$manifest = $parent->getParent()->getManifest();
$attributes = $manifest->attributes();
$method = $attributes->method ? (string) $attributes->method : false;
foreach ($folders as $folder) {
if ($method != 'upgrade') {
if (JFolder::exists($dstBase . $folder)) {
JFolder::delete($dstBase . $folder);
}
}
JFolder::copy($srcBase . $folder, $dstBase . $folder, null, true);
}
if ($type == 'install') {
//update $db
$db = Jfactory::getDBO();
$toolbars = base64_encode('{"back":[[ "Templates" ],[ "Cut","Copy","Paste","PasteText","PasteFromWord" ] ,["SelectAll","SpellChecker", "Scayt" ] ,["Bold","Italic","Underline","Strike","Subscript","Superscript","-","RemoveFormat" ] ,[ "NumberedList","BulletedList","Outdent","Indent","-","Blockquote","CreateDiv","JustifyLeft","JustifyCenter","JustifyRight","JustifyBlock","BidiLtr","BidiRtl" ],[ "Link","Document","Unlink","Anchor" ], [ "Image","Flash","Table","Smiley","SpecialChar","PageBreak","Iframe" ],[ "Styles","Format","Font","FontSize" ],[ "TextColor","BGColor" ],[ "Maximize", "ShowBlocks","-","About" ]],"front":[[ "Templates" ],[ "Cut","Copy","Paste","PasteText","PasteFromWord"] ,["Bold","Italic","Underline","Strike","RemoveFormat" ], [ "NumberedList","BulletedList","Outdent","Indent","Blockquote"],[ "Link","Document","Unlink","Anchor" ],[ "Image","Table","SpecialChar","PageBreak","Iframe"],["Styles","Format" ],[ "Maximize", "ShowBlocks","About" ]],"inline" :[["Sourcedialog","Bold","NumberedList","BulletedList"],["PasteText","Image","Link","Document"],["Format"],["Readmore"],["Save"],["Versions"],["Close"] ],"title":[["Save"],["Cut","Copy","PasteText"],["Undo"],["Close"]],"image":[["Save"],["Image"],["Link","Document"],["Close"]],"mobile":[["Bold"],["Link"],["Image"],["Save"],["Versions"],["Close"]]}');
$query = $db->getQuery(true);
$query->select('params')->from('#__extensions')->where('folder = ' . $db->quote('editors'))->where('element = ' . $db->quote('arkeditor'));
$db->setQuery($query);
$params = $db->loadResult();
if ($params === false) {
throw new Exception('Failed to retrieve parameters from Editor');
}
if (!$params) {
$params = '{}';
}
$params = new JRegistry($params);
$params->set('toolbars', $toolbars);
$query->clear()->update('#__extensions')->set('params= ' . $db->quote($params->toString()))->where('folder = ' . $db->quote('editors'))->where('element = ' . $db->quote('arkeditor'));
$db->setQuery($query);
if (!$db->query()) {
throw new Exception('Failed to update parameters for Editor');
}
}
}
public function __construct($params)
{
$this->_params = $params;
$this->_db = Jfactory::getDBO();
// $this->_division_id = JRequest::getVar('jlamdivisionid',0,'default','POST');
/*
if (JRequest::getCmd('option') == 'com_joomleague') {
$p = JRequest::getInt('p', $params->get('default_project_id'));
}
else {
$p = $params->get('default_project_id');
}
*/
//$this->_project_id = intval($p);
/*
$this->_project_id = JRequest::getInt('p');
$this->_project = $this->getProject();
$this->_round_id = JRequest::getInt('r');
$this->_division_id = JRequest::getInt('division',0);
$this->_team_id = JRequest::getInt('tid',0);
*/
/*
echo 'project int -> <pre>'.print_r(JRequest::getInt('p'),true).'</pre><br>';
echo 'project var -> <pre>'.print_r(JRequest::getVar('p'),true).'</pre><br>';
echo 'project view -> <pre>'.print_r(JRequest::getVar('view'),true).'</pre><br>';
echo 'project tid -> <pre>'.print_r(JRequest::getVar('tid'),true).'</pre><br>';
echo 'get -> <pre>'.print_r($_GET,true).'</pre><br>';
echo 'post -> <pre>'.print_r($_POST,true).'</pre><br>';
echo 'request -> <pre>'.print_r($_REQUEST,true).'</pre><br>';
*/
if ($this->_project_id) {
JRequest::setVar('jlamseason', $this->getSeasonId());
JRequest::setVar('jlamleague', $this->getLeagueId());
JRequest::setVar('jlamproject', $this->_project_id);
JRequest::setVar('jlamdivisionid', $this->_division_id);
}
}
function getProgram()
{
$database = Jfactory::getDBO();
if (empty($this->_attribute)) {
$this->_attribute = $this->getTable("guruPrograms");
$this->_attribute->load($this->_id);
}
$data = JRequest::get('post');
if (!$this->_attribute->bind($data)) {
$this->setError($item->getErrorMsg());
return false;
}
if (!$this->_attribute->check()) {
$this->setError($item->getErrorMsg());
return false;
}
$sql = "SELECT sum(lt.time) AS course_time \r\n\t\t\t FROM `#__guru_task` as lt \r\n\t\t\t LEFT JOIN `#__guru_mediarel` lm on lt.id=lm.media_id \r\n\t\t\t LEFT JOIN `#__guru_days` as ld on lm.type_id=ld.id\r\n\t\t\t WHERE type='dtask' and ld.pid=" . $this->_id;
$database->setQuery($sql);
$database->query();
$result = $database->loadResult();
$hours = intval($result / 60);
$minutes = $result % 60;
$this->_attribute->duration = $hours . ":" . $minutes;
switch ($this->_attribute->level) {
case "0":
$this->_attribute->level = JText::_('GURU_LEVEL_BEGINER');
break;
case "1":
$this->_attribute->level = JText::_('GURU_LEVEL_INTERMEDIATE');
break;
case "2":
$this->_attribute->level = JText::_('GURU_LEVEL_ADVANCED');
break;
}
return $this->_attribute;
}
function Joom_CompleteBreadcrumbs($catid, $id, $func = '')
{
$config = Joom_getConfig();
$mainframe =& JFactory::getApplication('site');
$database =& Jfactory::getDBO();
$user =& JFactory::getUser();
$pathway =& $mainframe->getPathway();
// Sonderfaelle zuerst
switch ($func) {
case 'userpanel':
$pathway->addItem(JText::_('JGS_USER_PANEL'));
break;
case 'uploadhandler':
case 'showupload':
$pathway->addItem(JText::_('JGS_USER_PANEL'), 'index.php?option=com_joomgallery&func=userpanel' . _JOOM_ITEMID);
$pathway->addItem(JText::_('JGS_NEW_PICTURE'));
break;
case 'showusercats':
$pathway->addItem(JText::_('JGS_USER_PANEL'), 'index.php?option=com_joomgallery&func=userpanel' . _JOOM_ITEMID);
$pathway->addItem(JText::_('JGS_CATEGORIES'));
break;
case 'newusercat':
$pathway->addItem(JText::_('JGS_USER_PANEL'), 'index.php?option=com_joomgallery&func=userpanel' . _JOOM_ITEMID);
$pathway->addItem(JText::_('JGS_NEW_CATEGORY'));
break;
case 'showfavourites':
if ($user->get('id') && $config->jg_usefavouritesforzip != 1) {
$pathway->addItem(JText::_('JGS_FAV_MY'));
} else {
$pathway->addItem(JText::_('JGS_ZIP_MY'));
}
break;
case 'createzip':
$pathway->addItem(JText::_('JGS_ZIP_DOWNLOAD'));
break;
}
if ($func != '' && $func != 'viewcategory' && $func != 'detail') {
return;
}
// falls keine catid vorhanden
if ($catid == 0 || $func == 'detail') {
if ($id != 0) {
$database->setQuery(" SELECT \n a.id,\n a.imgtitle,\n a.catid\n FROM \n #__joomgallery AS a, \n #__joomgallery_catg AS cc\n WHERE \n a.catid = cc.cid \n AND a.id = '{$id}' \n AND cc.access <= '" . $user->get('aid') . "'\n ");
if (!($row = $database->loadObject())) {
return false;
}
$catid = $row->catid;
} else {
return false;
}
}
// catid ist hier auf jeden Fall gesetzt
// id's und Namen aller uebergeordneten Kategorien aus der Datenbank holen
$cat_ids = array($catid);
$cat_names = array();
while ($catid != 0) {
$database->setQuery(" SELECT \n name,\n parent,\n cid \n FROM \n #__joomgallery_catg\n WHERE \n cid = '{$catid}' \n AND published = '1' \n AND access <= '" . $user->get('aid') . "'\n ");
if (!($cat_row = $database->loadObject())) {
$catid = 0;
} else {
$catid = $cat_row->parent;
}
if ($catid != 0) {
array_unshift($cat_ids, $catid);
}
array_unshift($cat_names, $cat_row->name);
}
// Breadcrumbs mit Kategorien vervollstaendigen
for ($i = 0; $i < count($cat_names); $i++) {
$pathway->addItem($cat_names[$i], 'index.php?option=com_joomgallery&func=viewcategory&catid=' . $cat_ids[$i] . _JOOM_ITEMID);
}
// eventuell Bildnamen hinzufuegen
if (isset($row->id)) {
$pathway->addItem($row->imgtitle, 'index.php?option=com_joomgallery&func=detail&id=' . $row->id . _JOOM_ITEMID);
}
}
/**
* Adds attendees numbers to rows
*
* @param $data reference to event rows
* @return false on error, $data on success
*/
static function getAttendeesNumbers(&$data)
{
// Make sure this is an array and it is not empty
if (!is_array($data) || !count($data)) {
return false;
}
// Get the ids of events
$ids = array();
foreach ($data as $event) {
$ids[] = $event->id;
}
$ids = implode(",", $ids);
$db = Jfactory::getDBO();
$query = $db->getQuery(true);
$query->select('COUNT(id) as total, SUM(waiting) as waitinglist, event');
$query->from('#__jem_register');
$query->where('event IN (' . $ids . ')');
$query->group('event');
$db->setQuery($query);
$res = $db->loadObjectList('event');
foreach ($data as $k => $event) {
if (isset($res[$event->id])) {
$data[$k]->waiting = $res[$event->id]->waitinglist;
$data[$k]->regCount = $res[$event->id]->total - $res[$event->id]->waitinglist;
} else {
$data[$k]->waiting = 0;
$data[$k]->regCount = 0;
}
$data[$k]->available = $data[$k]->maxplaces - $data[$k]->regCount;
}
return $data;
}
function onAfterProcess($params, &$formModel)
{
if ($params->get('notification_ajax', 0) == 1) {
return;
}
$user =& JFactory::getUser();
$userid = $user->get('id');
$notify = JRequest::getInt('fabrik_notification', 0);
if ($userid == 0) {
return;
}
$label = '';
foreach ($formModel->_data as $k => $v) {
if (strstr($k, 'title')) {
$label = $v;
break;
}
}
$why = JRequest::getInt('rowid') == 0 ? 'author' : 'editor';
$this->process($notify, $why, $label);
// add entry indicating the form has been updated this record will then be used by the cron plugin to
// see which new events have been generated and notify subscribers of said events.
$db =& Jfactory::getDBO();
$event = JRequest::getInt('rowid') == 0 ? $db->Quote(JText::_('RECORD_ADDED')) : $db->Quote(JText::_('RECORD_UPDATED'));
$date = JFactory::getDate();
$date = $db->Quote($date->toMySQL());
$ref = $this->getRef();
$msg = $notify ? JText::_('PLG_CRON_NOTIFICATION_ADDED') : JText::_('PLG_CRON_NOTIFICATION_REMOVED');
$app =& JFactory::getApplication();
$app->enqueueMessage($msg);
$db->setQuery("INSERT INTO #__fabrik_notification_event (`reference`, `event`, `user_id`, `date_time`) VALUES ({$ref}, {$event}, {$userid}, {$date})");
$db->query();
}
public function plgRedform_integrationRedevent(&$subject, $config = array())
{
parent::__construct($subject, $config);
$this->loadLanguage();
$this->_db =& Jfactory::getDBO();
}
/**
* @param array (form array) CSAK MÓDOSÍTÁS felvitel nincs
* user_id, user_name, user_username, user_email, user_psw, user_psw2
* fcsop_1, terszerv_fcsop1_1, terszerv_fcsop1_2,......
* fcsop_2, terszerv_fcsop2_1, terszerv_fcsop2_2,......
*
* fcsop_1, fcsop_2 ... tartalma felhcsop_id
* terszerv_###_1, terszerv_###_2 ... tartalma tervesz_id (### fcsop_id)
* hilrlevelemail_#### (### fcsop_id)
* @return true vagy false
*/
public function save($data) {
//DBG echo 'model save rutin ';
//DBG echo '<pre>'; print_r($data); echo '</pre>';
$manager = false;
$hirlevelKezelo = false;
$db = Jfactory::getDBO();
// user_terhat rekordok törlése
$db->setQuery('delete from #__tny_felh_terhat where felh_id='.$db->quote($data['user_id']));
if ($db->query()) {
// user terhat rekordok tárolása
for ($fcsi = 1; $fcsi < 20; $fcsi++) {
// van "fcsop_$fcsi" adat a $data -ban?
if (isset($data["fcsop_$fcsi"])) {
$fcsop = $data["fcsop_$fcsi"];
// fcsop rekord beolvasása
$db->setQuery('select * from #__tny_felhcsoportok where fcsop_id='.$db->quote($fcsop));
$felhCsop = $db->loadObject();
if ($felhCsop->jog_felhasznalok == 1) $manager = true;
if ($felhCsop->jog_hirlevel == 1) $hirlevelKezelo = true;
//DBG echo '<p>Van fcsop '.$fcsi.' fcsop='.$fcsop.'</p>';
for ($fthi = 1; $fthi < 200; $fthi++) {
// ha van "terszerv_$fcsop_$thi" adat a tömbben akkor rekord kiirás
if (isset($data['terszerv_'.$fcsop.'_'.$fthi])) {
//DBG echo '<p>van terszerv adat </p>';
$db->setQuery('insert into #__tny_felh_terhat
values ('.$db->quote($data['user_id']).',
'.$db->quote($fcsop).',
'.$db->quote($data['terszerv_'.$fcsop.'_'.$fthi]).',
'.$db->quote($data['commentemail_'.$fcsop]).'
)');
//DBG echo '<p>'.$db->getQuery().'</p>';
if (!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
}
}
}
}
} else {
$this->setError($db->getErrorMsg());
return false;
}
// Joomla usergroup besorolás kezelése
// 10 usergroupba mindenképpen tartozik
// ha hírlevél kezelõ akkor 11 usergroupba is tartozik
// ha felhasználó kezelõ akkor 6 usergroupba is tartozik
$db->setQuery('delete from #__user_usergroup_map where user_id='.$db->quote($data['user_id']).' and (group_id=6 or group_id=11 or group_id=10)');
$db->query();
$db->setQuery('insert into #__user_usergroup_map values ('.$db->quote($data['user_id']).',10)');
$db->query();
if ($manager) {
$db->setQuery('insert into #__user_usergroup_map values ('.$db->quote($data['user_id']).',6)');
$db->query();
}
if ($hirlevelKezelo) {
$db->setQuery('insert into #__user_usergroup_map values ('.$db->quote($data['user_id']).',11)');
$db->query();
}
return true;
}
/**
* return round roundcode
*
* @param int $round_id
* @return int roundcode
*/
function _getRoundcode($round_id)
{
if (empty($this->_roundcodes)) {
$db = Jfactory::getDBO();
$query = ' SELECT r.roundcode, r.id ' . ' FROM #__joomleague_round AS r ' . ' WHERE r.project_id = ' . $this->_projectid;
$db->setQuery($query);
$this->_roundcodes = $db->loadAssocList('id');
}
if (!isset($this->_roundcodes[$round_id])) {
JError::raiseWarning(0, JText::_('COM_JOOMLEAGUE_RANKING_ERROR_UNKOWN_ROUND_ID') . ': ' . $round_id);
return false;
}
return $this->_roundcodes[$round_id];
}
<?php
// itt most rejtett divisionokba létre kell hozni a lehetséges popup listboxokat
// div.id="helpMezonev", select.id=""
// - területi szervezetek
// - kategoriák
// - cimkék
// - nem
// főmenüből is van inditva JSession::checkToken() or die( 'Invalid Token' );
$db = Jfactory::getDBO();
if (JRequest::getVar('task') == 'szures') {
echo '<h2>Kapcsolatok szűrés</h2>';
}
if (JRequest::getVar('task') == 'groupedit') {
echo '<h2>Csoportos módosítás - szűrés</h2>
<p>Alakitsa ki azt a listát amit modósítani akar!</p>';
}
if (JRequest::getVar('task') == 'szurtexport') {
echo '<h2>Exportálás CSV fájlba - szűrés</h2>
<p>Alakitsa ki azt a listát amit exportálni akar!</p>';
}
if (JRequest::getVar('task') == 'hirlevel') {
echo '<h2>Hírlevél küldés - szűrés</h2>
<p>Alakitsa ki azt a listát akinek hírlevelet akar küldeni!</p>';
}
?>
<script language="javascript" type="text/javascript">
Joomla.submitbutton = function(task) {
/**
* átlag fogyás beirása a termék rekordba
* @JRequest integer termek_id
* @Jrequest integer atlagfogyas
*/
public function atlagfogyas()
{
JSession::checkToken('get') or die('Invalid Token');
$db = Jfactory::getDBO();
$termek_id = JRequest::getVar('termek_id', 0);
$atlagfogyas = JRequest::getvar('atlagfogyas', 0);
if ($termek_id > 0) {
$db->setQuery('update #__keszlet_termek
set fogyas = ' . $db->quote($atlagfogyas) . '
where id = ' . $db->quote($termek_id));
if ($db->query()) {
$this->message->txt = 'Átlag fogyás tárolva';
$this->message->class = 'alert-info';
} else {
$this->message->txt = $model->getError();
$this->message->class = 'alert-error';
}
}
$this->browser();
}
/**
* @param string: an iso3 country code, e.g AUT
* @return string: a country name
*/
public static function getCountryName($iso3)
{
$db = Jfactory::getDBO();
$lang = JFactory::getLanguage();
$extension = "com_joomleague_countries";
$source = JPATH_ADMINISTRATOR . '/components/' . $extension;
$lang->load("{$extension}", JPATH_ADMINISTRATOR, null, false, false) || $lang->load($extension, $source, null, false, false) || $lang->load($extension, JPATH_ADMINISTRATOR, $lang->getDefault(), false, false) || $lang->load($extension, $source, $lang->getDefault(), false, false);
$query = "SELECT name from #__joomleague_countries\n where alpha3 like '" . $iso3 . "'";
$db->setQuery($query);
$res = $db->loadResult();
//$countries=Countries::getCountries();
if ($res) {
//return JText::_($countries[$iso3]['name']);
return JText::_($res);
}
}
function _getList()
{
$check = $this->_chkextension();
if (!$check) {
return;
}
$list = "";
$query = "SELECT id,name FROM #__xipt_profiletypes ";
$db = Jfactory::getDBO();
$db->setQuery($query);
$list = $db->loadObjectList();
return $list;
}
/**
* Finds image type definition by name and type
* @param string $name
* @param string $type
* @param JeproshopOrderModelOrder $order
*/
public static function getByNameNType($name, $type = null, $order = null)
{
if (!isset(self::$images_types_name_cache[$name . '_' . $type . '_' . $order])) {
$db = Jfactory::getDBO();
$query = "SELECT " . $db->quoteName('image_type_id') . ", " . $db->quoteName('name') . ", ";
$query .= $db->quoteName('width') . ", " . $db->quoteName('height') . ", " . $db->quoteName('products');
$query .= ", " . $db->quoteName('categories') . ", " . $db->quoteName('manufacturers') . ", ";
$query .= $db->quoteName('suppliers') . ", " . $db->quoteName('scenes') . " FROM " . $db->quoteName('#__jeproshop_image_type');
$query .= "\tWHERE " . $db->quoteName('name') . " LIKE " . $db->quote($db->escape($name));
$query .= !is_null($type) ? " AND " . $db->quoteName($db->escape($type)) . " = 1" : "";
$query .= !is_null($order) ? " ORDER BY " . $db->quoteName($db->escape($order)) . " ASC" : "";
$db->setQuery($query);
self::$images_types_name_cache[$name . '_' . $type . '_' . $order] = $db->loadObject();
}
return self::$images_types_name_cache[$name . '_' . $type . '_' . $order];
}
function unInstallWS()
{
//Read the script file and execute
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.folder');
$sql = JFile::read(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_jws' . DS . 'jws_files' . DS . 'scripts' . DS . 'database' . DS . 'ws_drop.sql');
$db =& Jfactory::getDBO();
$db->setQuery($sql);
$db->query();
echo "<br /> DB tables uninstalled..<br />";
//backup files.
echo "<br /> Deleting Created files..<br />";
JFile::delete(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'views' . DS . 'user' . DS . 'view.html.php');
JFile::move(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'views' . DS . 'user' . DS . 'view.html.php.jws', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'views' . DS . 'user' . DS . 'view.html.php');
JFile::delete(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'views' . DS . 'user' . DS . 'tmpl' . DS . 'form.php');
JFile::move(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'views' . DS . 'user' . DS . 'tmpl' . DS . 'form.php.jws', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'views' . DS . 'user' . DS . 'tmpl' . DS . 'form.php');
JFile::delete(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'controller.php');
JFile::move(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'controller.php.jws', JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_users' . DS . 'controller.php');
JFile::delete(JPATH_SITE . DS . 'standalone.php');
JFolder::delete(JPATH_SITE . DS . 'api');
}
static function showRentHistory($option, $rows, $pageNav, $params)
{
global $my, $Itemid, $mosConfig_live_site, $mainframe, $booklibrary_configuration;
$session = JFactory::getSession();
$acl = JFactory::getACL();
$arr = $session->get("array", "default");
$doc = JFactory::getDocument();
$doc->addStyleSheet($mosConfig_live_site . '/components/com_booklibrary/includes/booklibrary.css');
$doc->addStyleSheet($mosConfig_live_site . '/components/com_booklibrary/includes/custom.css');
// for 1.6
$doc->addStyleSheet($mosConfig_live_site . '/components/com_booklibrary/includes/custom.css');
if ($option == 'com_booklibrary') {
$user = Jfactory::getuser();
$db = Jfactory::getDBO();
$query = "SELECT * FROM #__booklibrary_lend_request AS b WHERE b.status=0";
$db->setQuery($query);
$current_user_rent_request_array = $db->loadObjectList();
$check_for_show_rent_request = 0;
if (isset($current_user_rent_request_array)) {
$check_for_show_rent_request = 1;
}
if ($booklibrary_configuration['cb_mybook']['show'] == '1' && checkAccessBL($booklibrary_configuration['cb_mybook']['registrationlevel'], 'NORECURSE', userGID_BL($my->id), $acl)) {
echo "<span class='books_button'><a class='my_btn my_btn-primary' href='" . JRoute::_('index.php?option=' . $option . '&task=show_my_books&layout=mybooks') . "'>" . _BOOKLIBRARY_LABEL_CBBOOKS_TT . "</a></span>";
}
if ($booklibrary_configuration['cb_edit']['show'] == '1' && checkAccessBL($booklibrary_configuration['cb_mybook']['registrationlevel'], 'NORECURSE', userGID_BL($my->id), $acl)) {
echo " <span class='books_button'><a class='my_btn my_btn-primary' href='" . JRoute::_('index.php?option=' . $option . '&task=showmybooks&layout=mybooks') . "'>" . _BOOKLIBRARY_LABEL_CBEDIT . "</a></span>";
}
if ($booklibrary_configuration['cb_history']['show']) {
$params->def('show_history', 1);
$i = checkAccessBL($booklibrary_configuration['cb_history']['registrationlevel'], 'NORECURSE', userGID_BL($my->id), $acl);
if ($i) {
$params->def('show_history_registrationlevel', 1);
}
if ($params->get('show_history')) {
if ($params->get('show_history_registrationlevel')) {
if ($check_for_show_rent_request != 0) {
echo " <span class='books_button'>\n\t\t\t\t\t\t\t\t\t\t<a class='my_btn my_btn-primary' href='" . JRoute::_('index.php?option=com_booklibrary&task=rent_history_books&name=' . $user->name . '&user='******'&is_show_data=1') . "'>" . _BOOKLIBRARY_MY_LEND_HISTORY . "</a></span>";
}
//echo "<div style=\" border:1px solid black; padding: 10px; text-align:center; \">you dont have rent_history_lable</div>";
}
}
}
if ($booklibrary_configuration['cb_rent']['show']) {
$params->def('show_rent', 1);
$i = checkAccessBL($booklibrary_configuration['cb_rent']['registrationlevel'], 'NORECURSE', userGID_BL($my->id), $acl);
if ($i) {
$params->def('show_rent_registrationlevel', 1);
}
if ($params->get('show_rent')) {
if ($params->get('show_rent_registrationlevel')) {
if ($check_for_show_rent_request != 0) {
echo " <span class='books_button'><a class='my_btn my_btn-primary' href='" . JRoute::_('index.php?option=' . $option . '&task=rent_requests_cb_books&is_show_data=1') . "'>" . _BOOKLIBRARY_LEND_REQUESTS . "</a></span>";
}
}
}
}
?>
<style type="text/css">
.row0 {background-color:#F9F9F9;}
</style><br/><br/><br/><?php
}
?>
<?php
//---------------------------------------------------------------------------- view
//echo " <span class='books_button'><a class='my_btn my_btn-primary' href='" . JRoute::_('index.php?option=com_booklibrary&task=show_my_books&layout=mybooks') . "'>" . _BOOKLIBRARY_LABEL_CBBOOKS_TT . "</a></span>";
?>
<?php
if ($rows) {
?>
<form class="g" action="index.php" method="get" name="adminForm" id="adminForm">
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="basictable my_table my_table-bordered
my_table-hover bl_all_categories_show_my_book_lend_history">
<tr>
<th align = "center" width="30">#</th>
<th align = "center" class="title" width="5%" nowrap="nowrap"><?php
echo _BOOKLIBRARY_LABEL_BOOKID;
?>
</th>
<th align = "center" class="title" width="40%" nowrap="nowrap"><?php
echo _BOOKLIBRARY_LABEL_TITLE;
?>
</th>
<th align = "center" class="title" width="20%" nowrap="nowrap"><?php
echo _BOOKLIBRARY_ORDER_LEND_FROM;
?>
</th>
<th align = "center" class="title" width="20%" nowrap="nowrap"><?php
echo _BOOKLIBRARY_ORDER_LEND_UNTIL;
?>
</th>
<th align = "center" class="title" width="20%" nowrap="nowrap"><?php
echo _BOOKLIBRARY_SHOW_LEND_RETURN;
?>
</th>
</tr>
<?php
$numb = 0;
//echo "<br/><pre>". print_r($rows,true)."</pre>";exit;
for ($i = 0, $n = count($rows); $i < $n; $i++) {
$row = $rows[$i];
$book = $row->id;
$title = $row->title;
$numb++;
?>
<tr>
<td align="center"><?php
echo $numb;
?>
</td>
<td align="center"><?php
echo $row->bookid;
?>
</td>
<td align="center"><?php
echo $row->title;
?>
</td>
<td align="center"><?php
echo $row->lend_from;
?>
</td>
<td align="center"><?php
echo $row->lend_until;
?>
</td>
<td align="center"><?php
echo $row->lend_return;
?>
</td>
</tr>
<?php
}
?>
<tr class="for_paginator">
<td colspan="6" align="center" id="pagenavig">
<?php
$paginations = $arr;
if ($paginations && $pageNav->total > $pageNav->limit) {
echo $pageNav->getPagesLinks();
}
?>
</td>
</tr>
</table>
</form> <?php
}
//else echo "<div style=\"text-align:center;\">HISTORY IS EMPTY</div>"
?>
<?php
}
public function 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 = WebserviceHelper::constructResult(500, 'APIKey and secret key does not match', "getUserById");
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 userid from jos_users_apikey where apikey = '$apikey' AND secretkey='$secret'";
$sql = "SELECT u.username FROM jos_users u LEFT JOIN `jos_users_apikey` uapi ON ( u.id = uapi.userid )" . " WHERE `apikey` = '{$apikey}' AND `secretkey` = '{$secret}'";
$db->setQuery($sql);
$user_name = $db->loadResult();
$sql = "select id from #__users where username='******'";
$db->setQuery($sql);
$userid = $db->loadResult();
//$user = & JFactory::getUser($userid);
$sql = "select * from #__users where id=" . $userid;
$db->setQuery($sql);
$user = $db->loadObject();
$string = XMLSerializer::generateValidXmlFromObj($user, 'user_data');
$result = WebserviceHelper::constructResultData(200, 'User Object Loaded', $string, "getUserById");
return $result->asXML();
}
function getQuizById()
{
$db = Jfactory::getDBO();
$query = "select * from #__guru_quiz where id=" . intval($this->_id) . " limit 1";
$db->setQuery($query);
$db->query();
$result = $db->loadObject();
return $result;
}
function OnAfterGetEstimate($plg_targetfiels)
{
$userlist = array();
if (!$plg_targetfiels) {
return array();
}
foreach ($plg_targetfiels as $key => $value) {
if ($key == 'group') {
$query = "SELECT memberid from #__community_groups_members AS grusers LEFT JOIN #__community_groups AS grps ON grps.id=grusers.groupid WHERE grusers.groupid IN('{$value}') AND grps.published=1 GROUP BY grusers.memberid";
//die;
$db = Jfactory::getDBO();
$db->setQuery($query);
$userlist = $db->loadColumn();
}
}
return $userlist;
}
function _getList()
{
$check = $this->_chkextension();
if (!$check) {
return;
}
$list = "";
$query = "SELECT id,title FROM #__social_profiles ORDER BY title";
$db = Jfactory::getDBO();
$db->setQuery($query);
$list = $db->loadObjectList();
return $list;
}
function getSchemaAway($schemaaway)
{
$db =& Jfactory::getDBO();
$bildpositionen = array();
$position = 1;
if ($schemaaway) {
$query = " SELECT extended" . " FROM #__joomleague_rosterposition " . " WHERE name LIKE '" . $schemaaway . "'" . " AND short_name = 'AWAY_POS'";
$db->setQuery($query);
$res = $db->loadResult();
$xmlfile = JPATH_COMPONENT_ADMINISTRATOR . DS . 'assets' . DS . 'extended' . DS . 'rosterposition.xml';
$jRegistry = new JRegistry();
$jRegistry->loadString($res, 'ini');
for ($a = 0; $a < 11; $a++) {
$bildpositionen[$schemaaway][$a]['gast']['oben'] = $jRegistry->get('COM_JOOMLEAGUE_EXT_ROSTERPOSITIONS_' . $position . '_TOP');
$bildpositionen[$schemaaway][$a]['gast']['links'] = $jRegistry->get('COM_JOOMLEAGUE_EXT_ROSTERPOSITIONS_' . $position . '_LEFT');
$position++;
}
return $bildpositionen;
} else {
return false;
}
}
public static function getAmountQuizzes($id)
{
$db = Jfactory::getDBO();
$sql = "SELECT \tquizzes_ids FROM #__guru_quizzes_final WHERE qid=" . $id;
$db->setQuery($sql);
$db->query();
$result = $db->loadColumn();
@($result_qids = explode(",", trim($result["0"], ",")));
if (isset($result_qids[0]) && $result_qids[0] != "") {
$query = "select count(id) from #__guru_questions_v3 where qid IN (" . implode(",", $result_qids) . ")";
$db->setQuery($query);
$db->query();
$result = $db->loadResult();
return $result;
}
}
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();
}
}
/**
* Example Search method
*
* The sql must return the following fields that are used in a common display
* routine:
- title;
- href: link associated with the title;
- browsernav if 1, link opens in a new window, otherwise in the same window;
- section in parenthesis below the title;
- text;
- created;
* @param string Target search string
* @param string matching option, exact|any|all
* @param string ordering option, newest|oldest|popular|alpha|category
* @param mixed An array if the search it to be restricted to areas, null if search all
*
* @return array Search results
*/
public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null)
{
$user = JFactory::getUser();
$result = array();
// jelenleg semmilyen paramétert nem veszek figyelembe
$db = Jfactory::getDBO();
// témakorok
$db->setQuery('select t.megnevezes as title,
t.id,
"2" as browsernav,
"' . JText::_('TEMAKOROK') . '" as section,
"" as `text`,
t.letrehozva as created
from #__temakorok t
left outer join #__tagok ta
on ta.temakor_id = t.id and ta.user_id = "' . $user->id . '"
where t.megnevezes like "%' . $text . '%" and
((t.lathatosag = 0) or
(t.lathatosag = 1 and "' . $user->id . '" > 0) or
(ta.user_id is not null)
)
order by t.id DESC');
$res = $db->loadObjectList();
foreach ($res as $res1) {
$res1->href = 'index.php?option=com_szavazasok&view=szavazasoklist&temakor=' . $res1->id;
$result[] = $res1;
}
// szavazások
$db->setQuery('select sz.megnevezes as title,
sz.id,
"2" as browsernav,
"' . JText::_('SZAVAZASOK') . '" as section,
"" as `text`,
sz.letrehozva as created
from #__szavazasok sz
left outer join #__temakorok t on t.id = sz.temakor_id
left outer join #__tagok ta
on ta.temakor_id = t.id and ta.user_id = "' . $user->id . '"
where sz.megnevezes like "%' . $text . '%" and
((t.lathatosag = 0) or
(t.lathatosag = 1 and "' . $user->id . '" > 0) or
(ta.user_id is not null)
)
order by sz.id DESC');
$res = $db->loadObjectList();
foreach ($res as $res1) {
$res1->href = 'index.php?option=com_alternativak&view=alternativaklist&szavazas=' . $res1->id;
$result[] = $res1;
}
// alternativák
$db->setQuery('select sz.megnevezes as title,
sz.id,
"2" as browsernav,
"' . JText::_('ALTERNATIVAK') . '" as section,
"" as `text`,
sz.letrehozva as created
from #__szavazasok sz
inner join #__alternativak a on a.szavazas_id = sz.id
left outer join #__temakorok t on t.id = sz.temakor_id
left outer join #__tagok ta
on ta.temakor_id = t.id and ta.user_id = "' . $user->id . '"
where a.megnevezes like "%' . $text . '%" and
((t.lathatosag = 0) or
(t.lathatosag = 1 and "' . $user->id . '" > 0) or
(ta.user_id is not null)
)
order by sz.id DESC');
$res = $db->loadObjectList();
foreach ($res as $res1) {
$res1->href = 'index.php?option=com_alternativak&view=alternativaklist&szavazas=' . $res1->id;
$result[] = $res1;
}
return $result;
}
