/** * Method to add a new sportstype if not already exists * * @access private * @return boolean True on success **/ function addSportsType($newSportsTypeName) { $path = JPATH::clean(JPATH_ROOT . '/images/com_joomleague/database/events/' . JFolder::makesafe($newSportsTypeName)); if (!JFolder::exists($path)) { JFolder::create($path); } // SportsType does NOT exist and has to be created $tblSportsType = $this->getTable(); $tblSportsType->load(array('name' => $newSportsTypeName)); $tblSportsType->name = $newSportsTypeName; $tblSportsType->store(); return $tblSportsType->id; }
/** * Method to add a new sportstype if not already exists * * @access private * @return boolean True on success * @since 1.5 **/ function addSportsType($newsportstype) { //check if sportstype exists. If not add a new sportstype to table $query = "SELECT * FROM #__joomleague_sport_type WHERE name=" . $this->_db->Quote($newsportstype); $this->_db->setQuery($query); $sportstypeObject = $this->_db->loadObject(); if ($sportstypeObject->id) { //sportstype already exists return $sportstypeObject->id; } JFolder::create(JPATH::clean(JPATH_ROOT . '/images/com_joomleague/database/events/' . JFolder::makesafe($name))); //sportstype does NOT exist and has to be created $p_sportstype =& $this->getTable(); $p_sportstype->set('name', $newsportstype); if (!$p_sportstype->store()) { $sportstypeObject->id = 0; } else { $sportstypeObject->id = $this->_db->insertid(); //mysql_insert_id(); } return $sportstypeObject->id; }