Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 111 | Revision 120 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 111 Revision 114
Zeile 1... Zeile 1...
1 
<?
 1 
<?
Zeile -... Zeile 59...
- 
 
 59 
 
224 
 
 60 
        function fill_form()
- 
 
 61 
        {
- 
 
 62 
            global $db, $smarty, $id, $new_mode, $g_date, $title, $game;
- 
 
 63 
            $teams[-1] = "Bitte wählen!";
- 
 
 64 
            $typ_namen[] = "Bitte wählen!";
- 
 
 65 
            $typ_ids[] = -1;
225 
										}
 66 
            $l_namen[] = "Bitte wählen!";
- 
 
 67 
            $l_ids[] = -1;
- 
 
 68 
            $g_l = Gruppe::listeGruppe( 0, 0 );
226 
										else
 69 
            while ( $row_g = $g_l->fetchRow() )
- 
 
 70 
            {
227 
										{
 71 
                $g_id = $row_g["g_id"];
- 
 
 72 
                $g_name = $row_g["g_name"];
228 
											$m_id="$game->g_m1 OR t_id=$game->g_m2";
 73 
                //				$t_namen[]="---------- Gruppe $g_name ----------";
229 
										}
 74 
                //				$t_ids[]=-1;
230 
										$sql="UPDATE teams SET t_aus='$game->g_type' WHERE t_id=$m_id";
 75 
                $sql_t = "SELECT * FROM teams WHERE t_group=$g_id";
- 
 
 76 
                $t_l = $db->query( $sql_t );
- 
 
 77 
                while ( $row_t = $t_l->fetchRow() )
- 
 
 78 
                {
- 
 
 79 
                    $t_name = $row_t["t_name"];
- 
 
 80 
                    $t_aus = $row_t["t_aus"];
- 
 
 81 
                    $t_id = $row_t["t_id"];
- 
 
 82 
                    //					$t_namen[]=$t_name;
- 
 
 83 
                    //					$t_ids[]=$t_id;
- 
 
 84 
                    $teams["Gruppe $g_name"][$t_id] = $t_name;
- 
 
 85 
                }
- 
 
 86 
            }
- 
 
 87 
            $l_l = Ort::listeOrt( 0, 0 );
- 
 
 88 
            while ( $row_l = $l_l->fetchRow() )
- 
 
 89 
            {
- 
 
 90 
                $l_name = $row_l["l_name"];
- 
 
 91 
                $l_name2 = $row_l["l_name2"];
- 
 
 92 
                $l_id = $row_l["l_id"];
231 
										$res=$db->query($sql);
 93 
                $l_namen[] = "$l_name - $l_name2";
- 
 
 94 
                $l_ids[] = $l_id;
- 
 
 95 
            }
- 
 
 96 
            $typ_l = Typ::listeTyp( 0, 0 );
232 
										if(DB::isError($res))
 97 
            while ( $row_typ = $typ_l->fetchRow() )
- 
 
 98 
            {
- 
 
 99 
                $typ_name = $row_typ["t_name"];
- 
 
 100 
                $typ_id = $row_typ["t_id"];
- 
 
 101 
                $typ_namen[] = $typ_name;
- 
 
 102 
                $typ_ids[] = $typ_id;
- 
 
 103 
            }
- 
 
 104 
            $smarty->assign( "id", $id );
233 
										{
 105 
            $smarty->assign( "g_date", (!($g_date)) ? $game->g_date : $g_date );
- 
 
 106 
            $smarty->assign( "g_name", ($game->g_name) );
- 
 
 107 
            $smarty->assign( "akt_typ_id", $game->g_type );
- 
 
 108 
            $smarty->assign( "akt_m1_id", $game->g_m1 );
234 
											$smarty->assign("meld", "Ein Fehler ist aufgetreten!");
 109 
            $smarty->assign( "akt_m2_id", $game->g_m2 );
- 
 
 110 
            $smarty->assign( "akt_l_id", $game->g_location );
- 
 
 111 
            $smarty->assign( "g_g1", $game->g_g1 );
- 
 
 112 
            $smarty->assign( "g_g2", $game->g_g2 );
- 
 
 113 
            //			$smarty->assign("t_namen", $t_namen);
- 
 
 114 
            $smarty->assign( "teams", $teams );
- 
 
 115 
            //			$smarty->assign("t_ids", $t_ids);
- 
 
 116 
            $smarty->assign( "typ_namen", $typ_namen );
- 
 
 117 
            $smarty->assign( "typ_ids", $typ_ids );
- 
 
 118 
            $smarty->assign( "l_ids", $l_ids );
- 
 
 119 
            $smarty->assign( "l_namen", $l_namen );
235 
											$smarty->assign("db_meld", $db->getUserInfo);
 120 
            $smarty->assign( "mode", $new_mode );
- 
 
 121 
            $smarty->assign( "title", $title );
- 
 
 122 
            $smarty->assign( "extra", ($new_mode == "save") ? "disabled=\"disabled\"" :
- 
 
 123 
                "" );
236 
											$smarty->assign("error", true);
 124 
            $smarty->display( "edit_games.tpl" );
- 
 
 125 
        }
- 
 
 126 
 
237 
										}
 127 
        switch ( $mode )
- 
 
 128 
        {
- 
 
 129 
            case "edit":
- 
 
 130 
                $title = "Spiel $id ändern";
- 
 
 131 
                $new_mode = "update";
- 
 
 132 
                break;
- 
 
 133 
            case "new":
- 
 
 134 
                $title = "neues Spiel eingeben";
- 
 
 135 
                $new_mode = "save";
- 
 
 136 
                break;
- 
 
 137 
            case "delete":
- 
 
 138 
            case "ask":
- 
 
 139 
                $title = "Spiel $id löschen";
- 
 
 140 
                $new_mode = "delete";
- 
 
 141 
                break;
- 
 
 142 
            case "save":
- 
 
 143 
                $title = "neues Spiel speichern";
- 
 
 144 
                $new_mode = "save";
- 
 
 145 
                $smarty->assign( "save", true );
- 
 
 146 
                $smarty->assign( "weiter", "ein weiteres Spiel eingeben" );
- 
 
 147 
                break;
- 
 
 148 
            case "update":
- 
 
 149 
                $title = "Spiel $id speichern";
- 
 
 150 
                $new_mode = "update";
238 
									}
 151 
                break;
- 
 
 152 
        }
239 
								}
 153 
        if ( $mode == "edit" or $mode == "new" )
240 
							}
 154 
        {
241 
							$smarty->display("meld.tpl");
 155 
            fill_form();
- 
 
 156 
        }
242 
						}
 157 
        else
- 
 
 158 
        {
243 
					}
 159 
            switch ( $mode )
- 
 
 160 
            {
- 
 
 161 
                case "save":
- 
 
 162 
                case "delete":
- 
 
 163 
                case "update":
- 
 
 164 
                    if ( !checkdate($month, $day, $config->year) )
- 
 
 165 
                    {
- 
 
 166 
                        $meld = "Ein Fehler ist aufgetreten!";
- 
 
 167 
                        $db_meld = "$day.$month.$config->year ist kein gültiges Datum!";
- 
 
 168 
                        $error = true;
- 
 
 169 
                        $smarty->assign( "db_meld", $db_meld );
- 
 
 170 
                        $smarty->assign( "error", $error );
- 
 
 171 
                        $smarty->assign( "meld", $meld );
- 
 
 172 
                        fill_form();
- 
 
 173 
                    }
- 
 
 174 
                    else
- 
 
 175 
                    {
- 
 
 176 
                        if ( ($mode == "save" && $anz >= $t->t_max) || ($mode ==
- 
 
 177 
                            "update" && $anz > $t->t_max) )
- 
 
 178 
                        {
- 
 
 179 
                            $meld = "Ein Fehler ist aufgetreten!";
- 
 
 180 
                            $db_meld = "Es kann nur $t->t_max Spiele vom Typ \"$t->t_name\" geben! Bitte den Typ oder ein vorhandenes Spiel ändern!";
- 
 
 181 
                            $error = true;
- 
 
 182 
                            $smarty->assign( "db_meld", $db_meld );
- 
 
 183 
                            $smarty->assign( "error", $error );
- 
 
 184 
                            $smarty->assign( "meld", $meld );
- 
 
 185 
                            fill_form();
- 
 
 186 
                        }
- 
 
 187 
                        else
- 
 
 188 
                        {
- 
 
 189 
                            $res = $game->save( $mode );
- 
 
 190 
                            if ( true == DB::isError($res) )
- 
 
 191 
                            {
- 
 
 192 
                                $smarty->assign( "meld",
- 
 
 193 
                                    "Ein Fehler ist aufgetreten!" );
- 
 
 194 
                                $smarty->assign( "db_meld", $res->
- 
 
 195 
                                    getUserInfo() );
- 
 
 196 
                                $smarty->assign( "error", true );
- 
 
 197 
                            }
- 
 
 198 
                            else
- 
 
 199 
                            {
- 
 
 200 
                                if ( $mode == "save" )
- 
 
 201 
                                {
- 
 
 202 
                                    $akt = "hinzugefügt";
- 
 
 203 
                                } elseif ( $mode == "update" )
- 
 
 204 
                                {
- 
 
 205 
                                    $akt = "geändert";
- 
 
 206 
                                }
- 
 
 207 
                                else
- 
 
 208 
                                {
- 
 
 209 
                                    $akt = "gelöscht";
- 
 
 210 
                                }
- 
 
 211 
                                $smarty->assign( "title", $title );
- 
 
 212 
                                $smarty->assign( "meld",
- 
 
 213 
                                    "Datensatz erfolgreich $akt!" );
- 
 
 214 
                                $smarty->assign( "db_meld", "" );
- 
 
 215 
                                $logger->info( "Spiel $game->g_name erfolgreich $akt!" );
- 
 
 216 
                                $smarty->assign( "error", false );
- 
 
 217 
                                if ( $mode == "update" )
- 
 
 218 
                                {
- 
 
 219 
                                    if ( $game->g_type != 4 )
- 
 
 220 
                                    {
- 
 
 221 
                                        if ( $game->g_type < 4 )
- 
 
 222 
                                        {
- 
 
 223 
                                            if ( $game->g_g1 < $game->g_g2 )
- 
 
 224 
                                            {
- 
 
 225 
                                                $m_id = $game->g_m1;
- 
 
 226 
                                            }
- 
 
 227 
                                            else
- 
 
 228 
                                            {
- 
 
 229 
                                                $m_id = $game->g_m2;
- 
 
 230 
                                            }
- 
 
 231 
 
- 
 
 232 
                                        }
- 
 
 233 
                                        else
- 
 
 234 
                                        {
- 
 
 235 
                                            $m_id = "$game->g_m1 OR t_id=$game->g_m2";
- 
 
 236 
                                        }
- 
 
 237 
                                        $sql = "UPDATE teams SET t_aus='$game->g_type' WHERE t_id=$m_id";
- 
 
 238 
                                        $res = $db->query( $sql );
- 
 
 239 
                                        if ( DB::isError($res) )
- 
 
 240 
                                        {
- 
 
 241 
                                            $smarty->assign( "meld",
- 
 
 242 
                                                "Ein Fehler ist aufgetreten!" );
- 
 
 243 
                                            $smarty->assign( "db_meld", $db->
- 
 
 244 
                                                getUserInfo );
- 
 
 245 
                                            $smarty->assign( "error", true );
- 
 
 246 
                                        }
- 
 
 247 
                                    }
- 
 
 248 
                                }
- 
 
 249 
                            }
- 
 
 250 
                            $smarty->display( "meld.tpl" );
- 
 
 251 
                        }
- 
 
 252 
                    }
244 
					break;
 253 
                    break;
245 
				case "ask":
 254 
                case "ask":
246 
					$smarty->assign("title", $title);
 255 
                    $smarty->assign( "title", $title );
247 
					$smarty->assign("art", "Spiel");
 256 
                    $smarty->assign( "art", "Spiel" );
248 
					$smarty->assign("id", $id);
 257 
                    $smarty->assign( "id", $id );
249 
					$smarty->assign("name",$game->g_name);
 258 
                    $smarty->assign( "name", $game->g_name );
250 
					$smarty->display("del.tpl");
 259 
                    $smarty->display( "del.tpl" );
251 
					break;
 260 
                    break;
252 
				default:
 261 
                default:
253 
					$smarty->assign("title", $title);
 262 
                    $smarty->assign( "title", $title );
254 
					$smarty->assign("meld","Ein Fehler ist aufgetreten!");
 263 
                    $smarty->assign( "meld", "Ein Fehler ist aufgetreten!" );
255 
					$smarty->assign("db_meld", "Ungültiger Modsu!");
 264 
                    $smarty->assign( "db_meld", "Ungültiger Modsu!" );
256 
					$smarty->assign("error", true);
 265 
                    $smarty->assign( "error", true );
257 
					$smarty->display("meld.tpl");
 266 
                    $smarty->display( "meld.tpl" );
258 
			}
 267 
            }
259 
		}
 268 
        }
260 
	}
 269 
    }