예제 #1
0
파일: Liste.php 프로젝트: hlag/svs
 public function getSongs($status)
 {
     if ($status == 'all') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website ORDER BY title");
     } elseif ($status == 'repertoire') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe != 1 AND probe != 5 ORDER BY title");
     } elseif ($status == 'uebrige') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe != 1 AND probe != 5 ORDER BY g_id,  title");
     } elseif ($status == 'erschienen') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website  ORDER BY erschienen DESC");
     } elseif ($status == 2) {
         $dringend = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = 3 ORDER BY title");
         $proben = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = 2 ORDER BY title");
         $sonstige = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = 4 ORDER BY letzteProbe");
         $songs = array_merge($dringend, $proben, $sonstige);
     } elseif ($status == 5) {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE\n                    angefangen > '" . date("Y-m-d", time() - 3600 * 24 * 21) . "' OR probe = '5' ORDER BY angefangen DESC");
     } else {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = '" . $status . "' ORDER BY title");
     }
     foreach ($songs as $song) {
         $song['b'] = $song['c'];
         $song['arr_b'] = $song['arr_c'];
         $song['arr_t'] = '';
         $song['arr_p'] = '';
         $S = new Song();
         $S->setSong($song);
         $this->songs[$song['id']] = $S;
     }
     return $this->songs;
 }
예제 #2
0
파일: blockSorter.php 프로젝트: hlag/svs
 private function getBlocke($pl_id)
 {
     $bloecke = AGDO::getInstance()->GetAll("SELECT * FROM playlist_bloecke WHERE pl_id = " . $pl_id . " ORDER BY pb_sort_order");
     $countbloecke = count($bloecke);
     $newPosition = $this->g['nr'] + $this->g['change'];
     if ($newPosition < 1) {
         $newPosition = 1;
     }
     if ($newPosition > $countbloecke) {
         $newPosition = $countbloecke;
     }
     $x = 1;
     foreach ($bloecke as $block) {
         $b = new playlist_bloecke();
         $b->setBlock($block);
         if ($b->pb_id == $this->g['pb_id']) {
             $b->pb_sort_order = $newPosition;
             $b->saveBlock();
         } else {
             $this->bloecke[$x++] = $b;
         }
     }
     for ($sortorder = 1; $sortorder < $countbloecke; $sortorder++) {
         if ($sortorder == $newPosition) {
         } elseif ($sortorder > $newPosition) {
             $block = $this->bloecke[$sortorder - 1];
             $block->pb_sort_order = $sortorder;
             $block->saveBlock();
         } else {
             $block = $this->bloecke[$sortorder];
             $block->pb_sort_order = $sortorder;
             $block->saveBlock();
         }
     }
 }
예제 #3
0
파일: spamChecker.php 프로젝트: hlag/svs
	function get_last_entry($ip)
	{
		$prefix = AGDO::getInstance()->getDBConnector()->getPrefix();
		$table = $this->check_table;
		
		$query = "SELECT * FROM ".$prefix.$table." WHERE `ip` = '".$ip."' ORDER BY `time` DESC";
		
		$returnvalue = AGDO::getInstance()->GetAll($query);
		if (!empty($returnvalue))
			return $returnvalue[0];
		else
			return false;
	}
예제 #4
0
 public function __construct($id)
 {
     $article = AGDO::getInstance()->GetAll("SELECT * FROM ".AGDO::getInstance()->getDBConnector()->getParentIDTable()." WHERE article_id = ".$id);
     $permissions = AGDO::getInstance()->GetAll("SELECT * FROM ".AGDO::getInstance()->getDBConnector()->getPrefix()."permission WHERE article_id = ".$article[0]['parent_id']);
     //AGDO::get
     foreach ($permissions as $permission)
     {
         $insertArray=array();
         $insertArray['role_id']=$permission['role_id'];
         $insertArray['article_id']=$id;
         $insertArray['permission']=$permission['permission'];
         AGDO::getInstance()->AutoExecute(AGDO::getInstance()->getDBConnector()->getPrefix()."permission", $insertArray, 'INSERT');
     }
 }
예제 #5
0
파일: Twitter.php 프로젝트: hlag/svs
    public function generateScript($article_url, $language, $article_id)
    {
        $article = AGDO::getInstance()->GetAll("SELECT * FROM ".AGDO::getInstance()->getDBConnector()->getDescriptionTable()." WHERE article_id = ".$article_id);
        $text="";
        if (!empty($article[0]['twitter_text']))
        {
            $text = 'data-text="'.$article[0]['twitter_text'].'"';
        }
	if ($article[0]['article_url']=="/")
		$article_url="";
	else
		$article_url =$article[0]['article_url'].".html"; 
	
        $url = $_SERVER['HTTP_HOST']."/".$article_url;
        return '<a href="http://twitter.com/share" class="twitter-share-button" data-lang="'.$language.'" data-url="http://'.$url.'" '.$text.' data-count="'.$this->dataArray[0]['twitter_ausrichtung']
                .'">Tweet</a><script type="text/javascript" src="http://platform.twitter.com/widgets.js"></script>';
    }
예제 #6
0
파일: Facebook.php 프로젝트: hlag/svs
    public function generateMetaData($article_id)
    {

        $article= AGDO::getInstance()->GetAll("SELECT * FROM ".AGDO::getInstance()->getDBConnector()->getDescriptionTable()." WHERE article_id = ".$article_id);
        $suchmuster="/\< *[img][^\>]*[src] *= *[\"\']{0,1}([^\"\'\ >]*)/i";
        //print_r()
        //preg_match_all($pattern, $subject, $matchesarray)
        if (empty($article[0]['facebook_title']))
            $article[0]['facebook_title']=$article[0]['article_title'];
        $returnvalue='<meta property="og:title" content="'.$article[0]['facebook_title'].'" />'."\r\n";
        $returnvalue.='<meta property="og:type" content="'.$article[0]['facebook_type'].'" />'."\r\n";
        if ($article[0]['article_url']=='/')
            $returnvalue.='<meta property="og:url" content="http://'.$_SERVER['HTTP_HOST'].'" />'."\r\n";
        else
            $returnvalue.='<meta property="og:url" content="http://'.$_SERVER['HTTP_HOST']."/".$article[0]['article_url'].'.html" />'."\r\n";
        preg_match($suchmuster, $article[0]['article_content'], $treffer);
        //print_r($treffer);
        $image = "";
        if (!empty($article[0]['facebook_image']))
        {
            $image=$article[0]['facebook_image'];
        }
        else
        {
            if (!empty($treffer))
            {
                
                $image = str_replace('&quot;', '', $treffer[1]);
            }
            else
            {

                $image = $this->getdefaultImage();
            }
        }
        $returnvalue.='<meta property="og:image" content="http://'.$_SERVER['HTTP_HOST'].$image.'" />'."\r\n";
        $returnvalue.='<meta property="og:site_name" content="'.$this->dataArray[0]['facebook_site_name'].'" />'."\r\n";
        $returnvalue.='<meta property="fb:admins" content="'.$this->dataArray[0]['facebook_admin_code'].'" />'."\r\n";
        if (!empty($article[0]['facebook_description']))
            $returnvalue.='<meta property="og:description" content="'.$article[0]['facebook_description'].'" />'."\r\n";
        return $returnvalue;
    }
예제 #7
0
파일: checkURL.php 프로젝트: hlag/svs
    public function check($URL, $ID, $langID) // added sanitize check JA 23.01.2009
    {
        $URL = $this->sanitzeURL($URL);
        
        $SQLQuery = "SELECT * FROM `".AGDO::getInstance()->getDBConnector()->getDescriptionTable()."` WHERE article_url = '".$URL."' and language_id = ".$langID;
        $result= AGDO::getInstance()->GetAll($SQLQuery);
        $count = count($result);
        //echo $count;
        //print_r($result);
        if ($count==0 )        // Neuer Eintrag
            return $URL;
        else
        {
            if ($count==1 && $result[0]['article_id']==$ID)
            {
                return $URL;
            }
            $SQLQuery = "SELECT COUNT(*) as count FROM `".AGDO::getInstance()->getDBConnector()->getDescriptionTable()."` WHERE article_url LIKE '".$URL."%' and language_id = ".$langID;
            $result=AGDO::getInstance()->GetAll($SQLQuery);
            return $URL.(($result[0]['count'])+1);
        }

    }
예제 #8
0
파일: Registration.php 프로젝트: hlag/svs
    private function activateUser()
    {

	$sql = "SELECT * FROM user WHERE hash = '".Request::getInstance()->getGetRequests('registrieren')."' ";
	$user = AGDO::getInstance()->getAll($sql);

	$sql = "UPDATE ".$this->userTable." SET userActive = 1 WHERE hash = '".Request::getInstance()->getGetRequests('registrieren')."' ";
	AGDO::getInstance()->Execute($sql);




    }
예제 #9
0
파일: TreeBuilder.php 프로젝트: hlag/svs
 public function getCompleteTreeFromDatabase($id,$ebene)
 {
     $aktDate=date("Y")."-".date("n")."-".date("j");
     $SQLQuery="Select ".$this->articleTable.".article_id, ".$this->articleTable.".published, ".$this->articleTable.".viewable, ".$this->descriptionTable.".article_linktext, ".$this->articleTable.".article_type, ".$this->descriptionTable.".article_url, ".$this->parentIDTable.".parent_id , ".$this->descriptionTable.".farbe ".
                 "FROM ".$this->articleTable." join ".$this->descriptionTable." ON ".$this->articleTable.".article_id = ".$this->descriptionTable.".article_id " .
                 "join ".$this->parentIDTable." ON ".$this->descriptionTable.".article_id = ".$this->parentIDTable.".article_id " .
                 "where ".$this->parentIDTable.".parent_id='".$id."' " .
                 "and language_id='".$this->lang."' ".
                 "ORDER by sort_order";
     $result =  AGDO::getInstance()->GetAll($SQLQuery);
     if(!empty($result))
     {
         for ($zaehler=0; $zaehler< count($result);$zaehler++ )
         {
             if ($result[$zaehler]['article_id']=="4")
                 $this->home=$result[$zaehler];
             if ($ebene==2)
             {
                 $this->setFlavour($result[$zaehler]['article_id']);
             }
             if ($ebene==4)
             {
                 $this->setSecondFlavour($result[$zaehler]['parent_id']);
             }
             $result[$zaehler]['mark']=false;
             $result[$zaehler]['Child']=$this->getCompleteTreeFromDatabase($result[$zaehler]['article_id'],($ebene+1));
             if ($ebene>2)
             {
                 $this->flavourArray[$result[$zaehler]['article_id']]=$this->getFlavour();
                 $result[$zaehler]['flavour']=$this->getFlavour();
             }
             if ($ebene>3)
             {
                 $this->flavourArray2[$result[$zaehler]['article_id']]=$result[$zaehler]['parent_id'];
                 $result[$zaehler]['flavour2']=$result[$zaehler]['parent_id'];
                 $this->setSecondFlavour($result[$zaehler]['parent_id']);
                 $result[$zaehler]['self']=$result[$zaehler]['article_id'];
             }
         }
     }
     return $result;
 }
예제 #10
0
파일: playlistSongs.php 프로젝트: hlag/svs
 private function organizePost($command)
 {
     if ($command) {
         $p = Request::getInstance()->getPostRequests();
         switch ($command) {
             case 'insertSong':
                 $lastEntry = AGDO::getInstance()->GetFirst("SELECT * FROM playlists WHERE pl_number = " . $p['pl_id'] . " AND  block_number = " . $p['block_number'] . " ORDER BY sort_order DESC");
                 if (isset($lastEntry['sort_order'])) {
                     $sort_order = $lastEntry['sort_order'] + 10;
                 } else {
                     $sort_order = 10;
                 }
                 AGDO::getInstance()->Execute("INSERT INTO playlists SET pl_number = " . $p['pl_id'] . ", id = " . $p['id'] . ", block_number = " . $p['block_number'] . ", sort_order = " . $sort_order . " ");
                 break;
             default:
                 z($p);
         }
     }
 }
예제 #11
0
파일: playlist.php 프로젝트: hlag/svs
 public function savePlaylist()
 {
     AGDO::getInstance()->Execute("UPDATE playlists SET pl_name = '" . $this->pl_name . "',\n         pl_datum = '" . $this->pl_datum . "',\n          pl_start = '" . $this->pl_start . "'\n          WHERE  pl_id = '" . $this->pl_id . "'");
 }
예제 #12
0
파일: Song.php 프로젝트: hlag/svs
 public function delete()
 {
     $mp3 = PATH . 'files/' . $this->mp3;
     if (file_exists($mp3)) {
         unlink($mp3);
     }
     $txt = PATH . 'files/' . $this->txt;
     if (file_exists($txt)) {
         unlink($txt);
     }
     AGDO::getInstance()->Execute("DELETE  FROM SVsongs  WHERE id = " . $this->id);
     header("location:index.php?idt=Liste&status=1");
 }
예제 #13
0
    public function generate($array, $langshort, $langID, $mode)
    {
        //print_r($array);
	//echo $langID;
        Logger::getInstance()->Log($_POST, LOG_ABLAUF);
        //$array['article_url_de'] = iconv('ISO-8859-1',"UTF-8",$array['article_url_de']);
        Logger::getInstance()->Log($array, LOG_ABLAUF);
        $arrayKeys = array_keys($array);
        $returnArray=array();
        if (ModuleManager::getInstance()->getModuleByName('Rechteverwaltung'))
        {
            $rechteverwaltung = ModuleManager::getInstance()->getModuleByName('Rechteverwaltung');
            $rechteverwaltung->setConnection(AGDO::getInstance());
            $rechteverwaltung->setLanguage(1);
            $rechteverwaltung->calculate();
            $permissions = array();
            foreach ($arrayKeys as $keys)
            {

                if (!(strpos($keys,'role_')===false))
                {
                    //echo strpos($keys,'e_');
                    $roleID = substr($keys,5);
                    //echo $roleID;
                    $permission = $array['GroupSelect_'.$roleID];
                    $permissions[]=array('permission'=>$permission,'role_id'=>$roleID);
                    //
                }
            }
            if (isset( $array['ID']))
              $rechteverwaltung->setPermissions($permissions, $array['ID']);
            if (isset($array['rolerekursiv']))
            {
                $this->updateRecPermission($rechteverwaltung, $permissions, $array['ID']);
            }
        }
        if (isset($array['tag_new']))
            $returnArray['tags']=$array['tag_new'];
        else
	{
           if (isset($array['tags'])) 
		$returnArray['tags']=$array['tags'];
	   else 
		$returnArray['tags']="";
	}
        if (isset($array['kopfbild_de']))
                $returnArray['kopfbild']=$array['kopfbild_de'];
        if(empty($array['kopfbildgalerie_on_de']))
            $returnArray['kopfbildgalerie_on'] = 'no';
	if (isset($array['kopfbild_slideshow']))
	     $returnArray['kopfbild_slideshow']=$array['kopfbild_slideshow'];
        else
            $returnArray['kopfbild_slideshow']='';
        if (isset($array['facebook']))
            $returnArray['facebook']=1;
        else
            $returnArray['facebook']=0;
        if (isset($array['twitter']))
            $returnArray['twitter']=1;
        else
            $returnArray['twitter']=0;
        if (empty($array['twitter_text']))
            $returnArray['twitter_text']="";
        if (empty($array['facebook_title']))
            $returnArray['facebook_title']="";
        if (empty($array['facebook_description']))
            $returnArray['facebook_description']="";
        if (empty($array['facebook_image']))
            $returnArray['facebook_image']="";
        if (isset($array['tags']) && $array['tags']=='Keine')
            $returnArray['tags']=NULL;
        // JA 09.03.2010 Rating

        $returnArray['rating_enabled'] = !empty($array['rating_enabled']) + '';
        $returnArray['show_rating'] = !empty($array['show_rating']) + '';
        if(isset($array['avg_rating']))
            $returnArray['avg_rating'] = $array['avg_rating']; 
        if(!empty($array['reset_rating'])){
            // reset data
            $returnArray['avg_rating'] = $returnArray['rating_count'] = 0;
            
            // delete rating info
            $settings = unserialize(SETTINGS);
            $table = $this->dbconnector->getPrefix() . $settings['rating']['table'];
            
            $query = "DELETE FROM $table 
                    WHERE article_id = ".$array['article_id'];
             $result = $this->dbverbindung->Execute($query);
        }
        
        foreach ($arrayKeys as $keys)
        {
            // JA 23.06.2009: that method is unsafe and kills description.
            /* 
            if (strpos($keys,"_".$langshort)>0)
            {
                $newkey=substr($keys,0,strpos($keys,"_".$langshort));
                $returnArray[$newkey]=$array[$keys];
            }
            */
            $parts = explode('_',$keys);
            if( count($parts) > 1 and end($parts) === $langshort)
            {
                array_pop($parts);
                $returnArray[join($parts,'_')]=$array[$keys];
            }
        }
        if (isset($returnArray['Modul']))                    //05.07.2007
            $returnArray['Module']=$returnArray['Modul'];
        else                                                //10.10.2007
            $returnArray['Module']="";                        //10.10.2007
        if (isset($returnArray['Modul_parameter']))                    //05.07.2007
            $returnArray['module_parameter']=$returnArray['Modul_parameter'];
        else                                                //10.10.2007
            $returnArray['module_parameter']="";
        
         if (isset($returnArray['Modul_parameter_2']))                    //05.07.2007
            $returnArray['module_parameter_2']=$returnArray['Modul_parameter_2'];
        else                                                //10.10.2007
            $returnArray['module_parameter_2']="";
        $bereinigterArtikelName="";
        if (!isset($returnArray['article_as_link']))
            $returnArray['article_as_link']='0';
        if (isset($returnArray['article_name']))
        {
            //echo "update";
            /** No automated change of page title and menu title. JA 30.01.2009
            if ($mode=='UPDATE')
            {
                $isChangedArticleName= $this->checkArticleName(mb_convert_encoding($returnArray['article_name'],"HTML-ENTITIES","auto"),$array['article_id'],$langID);
                 if ($isChangedArticleName)
                 {
                    unset($returnArray['article_linktext']);
                    unset($returnArray['article_title']);
                    //unset($myArray['article_url_'.$this->languageID[$counter]['short']]);
                 }
            }
            **/
            $bereinigterArtikelName = str_replace("\'","",$returnArray['article_name']);
            $bereinigterArtikelName = str_replace("\\\"","",$bereinigterArtikelName);
            if (!isset($returnArray['article_linktext']))
            {
                $returnArray['article_linktext']=$bereinigterArtikelName;
            }
            if (!isset($returnArray['article_title']))
            {
                $returnArray['article_title']=$bereinigterArtikelName;
            }
            
            if (!isset($returnArray['article_url']))
            {

                $returnArray['article_url']=$this->convertArticleNameToArticleUrl($returnArray['article_name']);
                $returnArray['article_url']=$this->urlchecker->check($returnArray['article_url'], $array['article_id'],$langID);
            }
            else
            {
                $returnArray['article_url']=$this->urlchecker->check($returnArray['article_url'], $array['article_id'],$langID);
            }
        }
        else
        {
            
            $returnArray['article_name']="";
            if (!isset($returnArray['article_linktext']))
                $returnArray['article_linktext']="";
        }
        if (!isset($returnArray['Additional_Content']))                //MG 10.10.2007
            $returnArray['Additional_Content']=0;
        if (!isset($returnArray['article_teaser_link_1']))            //MG 02.10.2007
            $returnArray['article_teaser_link_1']=0;
        if (!isset($returnArray['article_teaser_link_2']))
            $returnArray['article_teaser_link_2']=0;
        if (!isset($returnArray['article_teaser_link_3']))
            $returnArray['article_teaser_link_3']=0;
        if (!isset($returnArray['article_teaser_link_4']))
            $returnArray['article_teaser_link_4']=0;
        if ($array['article_id']==4 && $langID==1)
            $returnArray['article_url']="/";
        //$returnArray['article_url']=$array['article_url_de'];
        if (isset($array['jslib']) && $array['jslib']!='keine')
            $returnArray['jslib']=$array['jslib'];
        else
            $returnArray['jslib']=NULL;
        $returnArray['article_name']=$this->checkString($returnArray['article_name']);
        //$returnArray['article_name']=str_replace("\'","&#39;",$returnArray['article_name']);
        $returnArray['article_id']=$array['article_id'];
        if (!isset($array['show_navi']))
            $returnArray['show_navi']=0;
        else
            $returnArray['show_navi']=1;
        if (!isset($array['template']))
            $returnArray['template']='MainTemplate.htm';
        else
            $returnArray['template']=$array['template'];
        $returnArray['language_id']=$langID;
        if (isset($returnArray['ta']) && $returnArray['ta']!="")                    //MG 04.10.2007
            $returnArray['article_content']=$this->checkString(mb_convert_encoding($returnArray['ta'],"HTML-ENTITIES","auto"));
        else
            $returnArray['article_content']="";    
        if (isset($returnArray['article_description']) && $returnArray['article_description']!="")                    //MG 04.10.2007
            $returnArray['article_description']=$this->checkString(mb_convert_encoding($returnArray['article_description'],"HTML-ENTITIES","auto"));
        else
            $returnArray['article_description']="";
        if (isset($array['article_type']))
            $returnArray['article_type']=$array['article_type'];
        else
            $returnArray['article_type']=1;
        $returnArray['article_name']=mb_convert_encoding($returnArray['article_name'],"HTML-ENTITIES","auto");
        if (isset($array['GroupID']))
            $returnArray['GroupID']=$array['GroupID'];
        else
            $returnArray['GroupID']=0;
        if (isset($array['UserID']))
            $returnArray['UserID']=$array['UserID'];
        else
            $returnArray['UserID']=0;
        if (isset($returnArray['article_linktext']))
            $returnArray['article_linktext']=mb_convert_encoding($returnArray['article_linktext'],"HTML-ENTITIES","auto");
        if (isset($returnArray['article_title']))
            $returnArray['article_title']=mb_convert_encoding($returnArray['article_title'],"HTML-ENTITIES","auto");
        if (!isset($returnArray['article_teaserhead']))
            $returnArray['article_teaserhead'] = $this->getTeaderHeadFromArticleName($returnArray['article_name']);
        else
            $returnArray['article_teaserhead']=$this->checkString($returnArray['article_teaserhead']);
        if (!isset($returnArray['article_teaser_content']))
            $returnArray['article_teaser_content']= $this->checkString($this->getTeaserContentFromArticleContent($returnArray['article_content']));
        $returnArray['article_teaser_content']= $this->checkString($returnArray['article_teaser_content']);                 //MG 26.09.2007
        if (isset($returnArray['picture_name']))
        {
            $returnArray['picture_name']= mb_convert_encoding($returnArray['picture_name'],"HTML-ENTITIES","auto");
            $returnArray['picture_name']=$this->checkString($returnArray['picture_name']);
        }
        else
            $returnArray['picture_name']="";
            
        
        $returnArray['newsdate']= empty($array['newsdate']) ? '0000-00-00' : $array['newsdate']; // 03.09.2008 JA
        Logger::getInstance()->Log("returnArray", LOG_ABLAUF);
        Logger::getInstance()->Log($returnArray, LOG_ABLAUF);
        //echo "langshort".$langshort;
        //echo "<!--\n".print_r($returnArray,true)."-->";
        return $returnArray;
    }
예제 #14
0
 public function deleteBlock($pb_id)
 {
     $this->getBlockByID($pb_id);
     $this->getSongs();
     if (count($this->songs) == 0) {
         AGDO::getInstance()->Execute("DELETE FROM playlist_bloecke WHERE pb_id=" . $this->pb_id);
     }
 }
예제 #15
0
파일: AGDO.php 프로젝트: hlag/svs
	public function updateRecursive($parentID, $updateField, $updateValue, $languageID)
	{
		$query	= "SELECT ".$this->DBConnector->getDescriptionTable().".article_id " .
				"FROM ".$this->DBConnector->getDescriptionTable()." JOIN ".$this->DBConnector->getParentIDTable()." " .
				"ON ".$this->DBConnector->getDescriptionTable().".article_id = ".$this->DBConnector->getParentIDTable().".article_id " .
				"WHERE parent_id='".$parentID."' AND language_id='".$languageID."'";
		$returnvalue=AGDO::getInstance()->GetAll($query);
		if (empty($returnvalue))
		{
			return "";
		}
		else
		{
			foreach ($returnvalue as $line)
			{
				$query="UPDATE ".$this->DBConnector->getDescriptionTable()." SET `".$updateField."`='".$updateValue."' WHERE article_id='".$line['article_id']."' AND language_id='".$languageID."'";
				$returnvalue=AGDO::getInstance()->Execute($query);
				//echo $query."<br>";
				$this->updateRecursive($line['article_id'],$updateField, $updateValue, $languageID );
			}
		}
	}
예제 #16
0
파일: LostPassword.php 프로젝트: hlag/svs
    private function activateNewPasswort($newPasswortMD5, $user_id)
    {
	$sql = "UPDATE user SET passwort = '".$newPasswortMD5."', newPassword = '', hash = '', userActive = 1 WHERE user_id = '".$user_id."'";
	AGDO::getInstance()->Execute($sql);
    }
예제 #17
0
파일: Login.php 프로젝트: hlag/svs
 public function getUser()
 {
     $user = AGDO::getInstance()->GetAll("SELECT * FROM ".$this->userTable." WHERE betreuer_id = ".$this->getUserID());
     return $user[0];
 }
예제 #18
0
파일: ajax.php 프로젝트: hlag/svs
 private function getSingleDatum($table, $field, $id, $id_name)
 {
     $res = AGDO::getInstance()->GetFirst("SELECT " . $id_name . ", " . $field . " FROM " . $table . " WHERE " . $id_name . " = '" . $id . "'");
     $data['table'] = $table;
     $data['field'] = $field;
     $data['id'] = $id;
     $data['id_name'] = $id_name;
     $data['value'] = $res[$field];
     return TemplateParser::getInstance()->parseTemplate($data, 'ajax/ajaxSingleForm.html', PATH);
 }