Meine news.php:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 | <?php # Copyright by: Manuel # Support: www.ilch.de defined ( 'main' ) or die ( 'no direct access' ); function show_members ( $gid , $tpl ) { global $allgAr ; # icq team bild, hier die zahl aendern. $teams_show_icq_pic = 7; $q = "SELECT b.uid, a.icq, a.avatar, a.status, a.name, c.name as posi, staat FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_groupfuncs c ON b.fid = c.id WHERE b.gid = " . $gid . " ORDER BY c.pos ASC, a.name ASC" ; $erg = db_query( $q ); if (db_num_rows( $erg ) < 1) { return false; } $tpl ->out(1); $class = 'Cnorm' ; while ( $row = db_fetch_assoc( $erg ) ) { $class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' ); $row [ 'class' ] = $class ; if ( $row [ 'staat' ] != '' ) { $row [ 'staat' ] = '<img src="include/images/flags/' . $row [ 'staat' ]. '" alt="" border="0">' ; } else { $row [ 'staat' ] = 'n/a' ; } $row [ 'status' ] = ( $row [ 'status' ]? 'aktiv' : 'inaktiv' ); if (! empty ( $row [ 'icq' ])){ $row [ 'icq' ] = '<a href="http://www.icq.com/whitepages/cmd.php?uin=' . $row [ 'icq' ]. '&action=add"><img src="http://wwp.icq.com/scripts/online.dll?icq=' . $row [ 'icq' ]. '&img=' . $teams_show_icq_pic . '" valign="bottom" border="0"></a>' ; } else { $row [ 'icq' ] = 'n/a' ; } if ( $allgAr [ 'teams_show_list' ]==1){ if ( empty ( $row [ 'avatar' ])){ $row [ 'avatar' ] = 'n/a' ; } else { $row [ 'avatar' ] = '<img src="' . $row [ 'avatar' ]. '" alt="Avatar von ' . $row [ 'name' ]. '" border="0" >' ; } $tpl ->set_ar_out( $row ,2); } else { $tpl ->set_ar_out( $row ,3); } } $tpl ->out(4); } if ( $menu ->get(1) == 'show' ) { $groups = array (); #collect given teams $i = 2; while ( $gid = escape( $menu ->get( $i ), 'integer' )){ $groups [] = $gid ; $i ++; } # $gid = escape( $menu ->get(2), 'integer' ); if ( count ( $groups ) == 1){ #only 1 group to show $gid = $groups [0]; $name = @db_result (db_query( "SELECT name FROM prefix_groups WHERE id =" . $gid )); $bild = @db_result (db_query( "SELECT img FROM prefix_groups WHERE id =" . $gid )); $title = $allgAr [ 'title' ]. ' :: Teams :: ' . $name ; $hmenu = '<a class="smalfont" href="?teams">Teams</a> » ' . $name ; $design = new design ( $title , $hmenu ); $design ->header(); $tpl = new tpl ( 'teams' ); if (! empty ( $bild ) ) { $show = '<img src="' . $bild . '" title="' . $name . '" alt="' . $name . '" border="0"></a>' ; } else { $show = '<b>' . $name . '</b>' ; } $tpl ->set_out( 'show' , $show ,0); show_members ( $gid , $tpl ); } else { #more groups to show $title = $allgAr [ 'title' ]. ' :: Teams :: ' ; $hmenu = '<a class="smalfont" href="?teams">Teams</a>' ; $design = new design ( $title , $hmenu ); $design ->header(); $tpl = new tpl ( 'teams' ); foreach ( $groups as $gid ){ $sql = db_query( "SELECT name, img FROM prefix_groups WHERE id =" . $gid ); if (db_num_rows( $sql ) < 1) { continue ; } $row = db_fetch_assoc ( $sql ); if (! empty ( $row [ 'img' ]) ) { $show = '<img src="' . $row [ 'img' ]. '" title="' . $row [ 'name' ]. '" alt="' . $row [ 'name' ]. '" border="0"></a>' ; } else { $show = '<b>' . $row [ 'name' ]. '</b>' ; } $tpl ->set_out( 'show' , $show ,0); show_members ( $gid , $tpl ); } } } else { $title = $allgAr [ 'title' ]. ' :: Teams' ; $hmenu = 'Teams' ; $design = new design ( $title , $hmenu ); $design ->header(); $tpl = new tpl ( 'teams' ); $erg1 = db_query( "SELECT name,img,id as gid FROM prefix_groups WHERE zeigen = 1 ORDER BY pos" ); while ( $row = db_fetch_assoc( $erg1 ) ) { if (! empty ( $row [ 'img' ]) ) { $row [ 'show' ] = '<a href="index.php?teams-show-' . $row [ 'gid' ]. '"><img src="' . $row [ 'img' ]. '" title="' . $row [ 'name' ]. '" alt="' . $row [ 'name' ]. '" border="0"></a>' ; } else { $row [ 'show' ] = '<a href="index.php?teams-show-' . $row [ 'gid' ]. '"><b>' . $row [ 'name' ]. '</b></a>' ; } $tpl ->set_ar_out( $row ,0); if ( $allgAr [ 'teams_show_cat' ] == 0) { show_members ( $row [ 'gid' ], $tpl ); } } } $design ->footer(0); ?> |
Nun möchte ich den Wohnort aus der datenbank auslesen.
Das tue ich hiermit:
1 | $wohnort = @db_result (db_query("SELECT wohnort FROM prefix_user WHERE id =".$gid)); |
ab jetzt blick ich aber nicht weiter durch. Normal könnte ich ja $wohnort in die teams.htm schreiben aber das klappt nicht, was habe ich vergessen zu beachten?
betroffene Homepage: rmb-gaming.de/airsoftev/index.php?news