openrat-cms

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs

commit ca0ef81a1095ec7661ba9cc933589f97625b6c5f
parent 2fa315e06587605eefe1a64a9affe3a6305bb271
Author: dankert <devnull@localhost>
Date:   Thu, 14 Jan 2010 23:23:48 +0100

Modell-Tabelle heißt t_projectmodel (nicht t_model!)

Diffstat:
objectClasses/Model.class.php | 24++++++++++++------------
objectClasses/Project.class.php | 4++--
2 files changed, 14 insertions(+), 14 deletions(-)

diff --git a/objectClasses/Model.class.php b/objectClasses/Model.class.php @@ -71,7 +71,7 @@ class Model { $db = db_connection(); - $sql = new Sql('SELECT 1 FROM {t_model} '. + $sql = new Sql('SELECT 1 FROM {t_projectmodel} '. ' WHERE id={id}'); $sql->setInt('id' ,$id ); @@ -89,7 +89,7 @@ class Model global $SESS; $db = db_connection(); - $sql = new Sql( "SELECT id,name FROM {t_model} ". + $sql = new Sql( "SELECT id,name FROM {t_projectmodel} ". " WHERE projectid = {projectid} ". " ORDER BY name" ); @@ -108,7 +108,7 @@ class Model { $db = db_connection(); - $sql = new Sql( 'SELECT * FROM {t_model}'. + $sql = new Sql( 'SELECT * FROM {t_projectmodel}'. ' WHERE id={modelid}' ); $sql->setInt( 'modelid',$this->modelid ); @@ -131,7 +131,7 @@ class Model $db = db_connection(); // Gruppe speichern - $sql = new Sql( 'UPDATE {t_model} '. + $sql = new Sql( 'UPDATE {t_projectmodel} '. ' SET name = {name} '. ' WHERE id={modelid}' ); $sql->setString( 'name' ,$this->name ); @@ -169,11 +169,11 @@ class Model $db = db_connection(); - $sql = new Sql('SELECT MAX(id) FROM {t_model}'); + $sql = new Sql('SELECT MAX(id) FROM {t_projectmodel}'); $this->modelid = intval($db->getOne($sql))+1; // Modell hinzuf?gen - $sql = new Sql( 'INSERT INTO {t_model} '. + $sql = new Sql( 'INSERT INTO {t_projectmodel} '. "(id,projectid,name,extension,is_default) VALUES( {modelid},{projectid},{name},'',0 )"); $sql->setInt ('modelid' ,$this->modelid ); @@ -190,7 +190,7 @@ class Model global $SESS; $db = db_connection(); - $sql = new Sql( 'SELECT id FROM {t_model} '. + $sql = new Sql( 'SELECT id FROM {t_projectmodel} '. ' WHERE projectid={projectid}'. ' ORDER BY is_default DESC' ); if ( isset($this->projectid) ) @@ -213,14 +213,14 @@ class Model $db = db_connection(); // Zuerst alle auf nicht-Standard setzen - $sql = new Sql( 'UPDATE {t_model} '. + $sql = new Sql( 'UPDATE {t_projectmodel} '. ' SET is_default = 0 '. ' WHERE projectid={projectid}' ); $sql->setInt('projectid',$this->projectid ); $db->query( $sql ); // Jetzt die gew?nschte Sprachvariante auf Standard setzen - $sql = new Sql( 'UPDATE {t_model} '. + $sql = new Sql( 'UPDATE {t_projectmodel} '. ' SET is_default = 1 '. ' WHERE id={modelid}' ); $sql->setInt('modelid',$this->modelid ); @@ -238,16 +238,16 @@ class Model $db = db_connection(); // Modell l?schen - $sql = new Sql( 'DELETE FROM {t_model} WHERE id={modelid}' ); + $sql = new Sql( 'DELETE FROM {t_projectmodel} WHERE id={modelid}' ); $sql->setInt( 'modelid',$this->modelid ); $db->query( $sql ); // Anderes Modell auf "Default" setzen (sofern vorhanden) - $sql = new Sql( 'SELECT id FROM {t_model} WHERE projectid={projectid}' ); + $sql = new Sql( 'SELECT id FROM {t_projectmodel} WHERE projectid={projectid}' ); $sql->setInt( 'projectid',$this->projectid ); $new_default_modelid = $db->getOne( $sql ); - $sql = new Sql( 'UPDATE {t_model} SET is_default=1 WHERE id={modelid}' ); + $sql = new Sql( 'UPDATE {t_projectmodel} SET is_default=1 WHERE id={modelid}' ); $sql->setInt( 'modelid',$new_default_modelid ); $db->query( $sql ); } diff --git a/objectClasses/Project.class.php b/objectClasses/Project.class.php @@ -445,7 +445,7 @@ SQL // ORDER BY deswegen, damit immer mind. eine Sprache // gelesen wird - $sql = new Sql( 'SELECT id FROM {t_model} '. + $sql = new Sql( 'SELECT id FROM {t_projectmodel} '. ' WHERE projectid={projectid}'. ' ORDER BY is_default DESC' ); $sql->setInt('projectid',$this->projectid ); @@ -744,7 +744,7 @@ EOF /** - * Ermittelt die Größe aller Dateien in diesem Projekt. + * Ermittelt die Gr��e aller Dateien in diesem Projekt. * @return int Summe aller Dateigroessen */ function size()