Hallo, wie kann ich beim Raidplaner wenn man auf die Chars liste geht noch ne Spalte einfügen die die DKPs anzeigt?
hab zwar ne Spalte gemacht aber da Zeigt er dann {dkp} und nicht den Wert
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
1 | $tpl->set_ar_out($rowWC,1); |
1 | $rowWC['dkp'] |
1 2 3 4 | $ergWC = db_query("SELECT * FROM prefix_wowchars WHERE onoff = 0 ORDER BY '".$_GET['SORT']."' DESC"); |
1 2 3 4 | $ergWC = db_query("SELECT * FROM prefix_Raid_DKP AS dkp, prefix_wowchars AS chars WHERE (onoff = 0 AND chars.UID = dkp.uid) ORDER BY '".$_GET['SORT']."' DESC"); |
1 2 3 4 5 | <tr><td><b><a href="index.php?user-wowchars&SORT=skill">Talente</a></b></td><td>=</td><td>T</td></tr> </table> </td> </tr> {EXPLODE} |
1 2 3 4 5 6 | <tr><td><b><a href="index.php?user-wowchars&SORT=skill">Talente</a></b></td><td>=</td><td>T</td></tr> </table> </td> <td>DKP's</td> </tr> {EXPLODE} |
1 2 3 4 5 6 | <tr><td>J<td><td>{nebenjob}</td></tr> <tr><td>T<td><td>{skill}</td></tr> </table> </td> </tr> {EXPLODE} |
1 2 3 4 5 6 7 | <tr><td>J<td><td>{nebenjob}</td></tr> <tr><td>T<td><td>{skill}</td></tr> </table> </td> <td>{dkp}</td> </tr> {EXPLODE} |
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 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 | <?php # Copyright by: Benjamin Brauns # Support: www.Manticors-Thorn.de defined ( 'main' ) or die ( 'no direct access' ); $akttime = date ( 'Y-m-d' ); $SORT = "level" ; function nebenjobs_trimmen( $nebenj , $wo ) { // $wo ist der Ort z.B. Char Detailansicht = 0 ( zur Zeit alles bis auf: // die komplette Char übersicht dort ist $wo = 1 $nebenjob_array = explode ( '-' , $nebenj ); $njobs = '' ; $nj = 0; foreach ( $nebenjob_array as $wert ) { // Die Trennung der Ersten Hilfe if (! empty ( $nebenj )) { if ( $wert == 'ErsteHilfe' ) { $firsthelp = split( 'Erste' , $wert ); $wert = 'Erste ' . $firsthelp [1]; } if ( $nj == 2 AND $wo == 1) { $njobs .= '<br />' ; } $njobs .= $wert . ' ' ; $nj = $nj + 1; } } $nebenjob = ltrim(rtrim( $njobs , "-" ), "-" ); return $nebenjob ; } //If Abfrage um 'MYCHARS' => $raid-MyChars_view_right hinzugefügt um einen Eingeloggten bzw. einem Gast den Link zu den Chars nicht anzuzeigen if ( $_SESSION [ 'authright' ] <= "-2" ) { $MyChars_view = '<a href="index.php?user-mychars">' ; } else { $MyChars_view = '' ; } // Chars Anzeige Alle if ( $menu ->get(3) == '' ){ $title = $allgAr [ 'title' ]. ' :: WoWChars' ; $hmenu = 'WoWChars' ; $design = new design ( $title , $hmenu ); // ab 1.1E $design ->header(); if ( $_SESSION [ 'authright' ] <= "-1" OR $_SESSION [ 'authright' ] == $allgAr [ 'raid-MyChars_view_right' ]) { // sicherung SUPERUSER war vorher <= "-1" $erg70 = db_query( 'SELECT COUNT(level) FROM `prefix_wowchars` WHERE level = "70" AND onoff = 0' ); $anz70 = db_result( $erg70 ,0); $ergAll = db_query( 'SELECT COUNT(CID) FROM `prefix_wowchars` WHERE onoff = 0' ); $anzAll = db_result( $ergAll ,0); $ergMy = db_query( 'SELECT COUNT(CID) FROM `prefix_wowchars` WHERE UID = "' . $_SESSION [ 'authid' ]. '" AND onoff = 0' ); $anzMy = db_result( $ergMy ,0); } //$SORT = "klasse"; // sortirung nach ??? ;-) $class = '' ; $ergWC = db_query("SELECT * FROM prefix_Raid_DKP AS dkp, prefix_wowchars AS chars WHERE (onoff = 0 AND chars.UID = dkp.uid) ORDER BY '".$_GET[' SORT ']."' DESC"); # echo mysql_error(); $tpl = new tpl ( '/user/wowchars.htm' ); // 'MYCHARS' => $raid-MyChars_view_right Hinzugefügt um einen Eingeloggten bzw. einem Gast den Link zu den Chars nicht anzuzeigen $tpl ->set_ar_out ( array ( '70er' => $anz70 , 'ALL' => $anzAll , 'MY' => $anzMy , 'MYCHARS' => $MyChars_view ) , 0 ); if ( $_SESSION [ 'authright' ] <= "-1" OR $_SESSION [ 'authright' ] == $allgAr [ 'raid-MyChars_view_right' ]) { // sicherung SUPERUSER war vorher <= "-1" if ( db_num_rows ( $ergWC ) == 0 ) { echo '<tr class="Cmite"><td colspan="4"><strong><font color="#FF4242">kein Char eingetragen</font></strong></td></tr>' ; } else { while ( $rowWC = db_fetch_assoc( $ergWC ) ) { if ( $class == 'Cmite' ) { $class = 'Cnorm' ; } else { $class = 'Cmite' ; } # $row [ 'name' ] = '<a href="index.php?user-wowchars-detail-' . $row [ 'CID' ]. '"><b>' . $row [ 'name' ]. '</b></a>' ; //ORG # $row [ 'name' ] = "<a href=\"index.php?user-wowchars-detail-" . $row [ 'CID' ]. "\" onmouseover=\"return overlib('This is an ordinary popup.');\" onmouseout=\"return nd();\">" . $row [ 'name' ]. "</a>" ; // Hier stehen die Rollover Effecte $rowWC [ 'ROLLOVER' ] = "'Level : " . $rowWC ['level ']." - ".$rowWC[' klasse ']."<br />Skill : ".$rowWC[' skill ']."<br />Rasse : ".$rowWC[' rasse ']."<br />Geschlecht : ".$rowWC[' sex ']."<br />Beruf 1: ". $rowWC[' work1 '] ."<br />Beruf 2: ". $rowWC[' work2 '] ."' ,CAPTION, '".$rowWC[' name ']." : ".$rowWC[' gilde ']."' ,WRAP"; # <a href= "javascript:void(0);" onmouseover= "return overlib('General');" onmouseout= "return nd();" >test</a> // ORG bsp $rowWC [ 'name' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'name' ]. '' ; $rowWC [ 'level' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'level' ]. '' ; $rowWC [ 'rasse' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'rasse' ]. '' ; $rowWC [ 'work1' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'work1' ]. '' ; $rowWC [ 'work2' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'work2' ]. '' ; $rowWC [ 'skill' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'skill' ]. '' ; $rowWC [ 'nebenjob' ] = nebenjobs_trimmen( $rowWC [ 'nebenjob' ], 1); $rowWC [ 'nebenjob' ] = '<a href="index.php?user-wowchars-detail-' . $rowWC [ 'CID' ]. '" onmouseover="return overlib(' . $rowWC [ 'ROLLOVER' ]. ');" onmouseout="return nd();">' . $rowWC [ 'nebenjob' ]. '' ; $rowWC [ 'class' ] = $class ; $rowWC [ 'dkp' ]; $tpl ->set_ar_out( $rowWC ,1); } } } else { echo '<br><p> <font color="#FF0000">ERROR: unzulässige anfrage, KEINE Berechtigung oder nicht eingeloggt!</font> </p><br>' ; } $tpl ->out(2); // Char Details // $design ->footer(); } elseif ( is_numeric ( $menu ->get(3)) ) { $_GET [ 'mehr' ] = escape( $menu ->get(3), 'integer' ); if ( $menu ->get[ '2' ] == "MyChars" ) { } // Abfrage für MyChars $abf = "SELECT * FROM prefix_wowchars WHERE CID = '" . $_GET ['mehr ']."' AND onoff = 0"; $erg = @db_query( $abf ); // Zuweisung der DB Einträge mit den Platzhaltern in den htm Seiten $row = db_fetch_assoc( $erg ); $row [ 'nebenjob' ] = nebenjobs_trimmen( $row [ 'nebenjob' ], 0); $title = $allgAr [ 'title' ]. ' :: WoWChars' ; if ( $row [ 'UID' ] == $_SESSION [ 'authid' ] ){ $hmenu = '<a href="?user-wowchars" class="smalfont">WoWChars</a><b> » </b> <a href="?user-mychars" class="smalfont">MyChars</a> <b> » </b>' . $row [ 'name' ]. '' ; } else { $hmenu = '<a href="?user-wowchars" class="smalfont">WoWChars</a><b> » </b>' . $row [ 'name' ]. '' ; } $design = new design ( $title , $hmenu ); $design ->header(); $tpl = new tpl ( '/user/wowchars_details' ); // User DKP's Auslesen und ausgeben $userDKP = db_query( "SELECT dkp FROM prefix_Raid_DKP WHERE uid = '" . $row ['UID ']."' "); echo mysql_error(); $row [ 'dkp' ] = db_result( $userDKP ,0); $tpl ->set_ar_out( $row ,0); // Chars Anzeige! $ergU = db_query( "SELECT * FROM prefix_wowchars WHERE UID = '" . $_SESSION ['authid ']."' "); // Check ob an gemeldet if ( $row [ 'UID' ] == $_SESSION [ 'authid' ] ) { if ( db_num_rows ( $ergU ) != 0 ) { } } #--- Deine CHARS Listen Anzeige ---- if ( $row [ 'UID' ] == $_SESSION [ 'authid' ] ) { echo '<tr class="Cmite"><td colspan="4"><b><font color="#009900">Deine Anderen Chars</font><b></td></tr>' ; $ergC = db_query("SELECT * FROM prefix_wowchars WHERE UID = '".$row[' UID ']."' AND CID != '".$row[' CID ']." AND onoff = 0' "); while ( $row2 = db_fetch_assoc( $ergC ) ) { # $row [ 'name' ] = '<a href="index.php?user-wowchars-detail-' . $row [ 'CID' ]. '"><b>' . $row [ 'name' ]. '</b></a>' ; # $row2 [ 'name' ]; $tpl ->set_ar_out( $row2 ,3); // User (Char) Anzeige Pro Account! } } #-------------------------------------------------------------------------------------------------------------------------------- $tpl ->out(4); $design ->footer(); } else { $title = $allgAr [ 'title' ]. ' :: WoWChars' ; $hmenu = '<a href="?user-wowchars" class="smalfont">WoWChars</a><b> » </b>ERROR' ; $design = new design ( $title , $hmenu ); $design ->header(); $tpl = new tpl ( '/user/wowchars_details' ); echo '<tr class="Cmite"><td colspan="4"><b><font color="#FF4242">ERROR: Unzulässiger Link</font><b></td></tr>' ; $design ->footer(); } ?> |
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 | <script type="text/javascript" src="include/includes/js/overlib.js"></script> <script type="text/javascript" src="include/includes/js/overlib_hideform.js"></script> <link rel="stylesheet" type="text/css" href="include/includes/js/stylesRP.css"> <table border="0" cellspacing="1" cellpadding="1" class="border"> <tr class="Chead"> <td align="center" ><font color="#000000">70er</td> <td align="center" ><font color="#000000">Alle</td> <td align="center" ><font color="#000000">-></td> <td align="center" ><font color="#000000">{MYCHARS}<b><u><font color="#000000">mein/e WoW Char's</u></b></a></td> </tr><tr class="Cnorm"> <td align="center"><b><font color="#009933">{70er}</font></b></td> <td align="center"><b><font color="#FFCC00">{ALL}</font></b></td> <td align="center"> </td> <td align="center"><b><font color="#FF4242">{MY}</font></b></td> </tr> </table> <br> <br> <table width="100%" border="0" cellspacing="1" cellpadding="2" class="border"> <tr class="Chead"> <td colspan="6"><b>Char Übersicht</b></td> </tr> <tr class="Cdark"> <td width="26%"><b><a href="index.php?user-wowchars&SORT=name"> <font color="#000000">Name</font></a></b></td> <td width="4%"><b><a href="index.php?user-wowchars&SORT=level"> <font color="#000000">Level</font></a></b></td> <td width="3%"><a href="index.php?user-wowchars&SORT=dkp"><b> <font color="#000000">DKP</font></b></a></td> <td width="7%"><b><a href="index.php?user-wowchars&SORT=klasse"> <font color="#000000">Klasse</font></a></b></td> <td><b><a href="index.php?user-wowchars&SORT=rasse"><font color="#000000">Rasse</font></a></b></td> <td> <table> <tr><td><b><a href="index.php?user-wowchars&SORT=work"> <font color="#000000">Beruf</font></a></b></td><td>=</td><td>B</td></tr> <tr><td><b><a href="index.php?user-wowchars&SORT=work"> <font color="#000000">Jobs</font></a></b></td><td>=</td><td>J</td></tr> <tr><td><b><a href="index.php?user-wowchars&SORT=skill"> <font color="#000000">Talente</font></a></b></td><td>=</td><td>T</td></tr> </table> </td> </tr> {EXPLODE} <tr class="{class}"> <td><table><tr><td><img src="include/images/icons/charpix/{klasse}.jpg" width="20" height="19"></td><td><font color="#000000">{name}</td></tr></table></td> <td valign="center" align="center"><font color="#000000">{level}</td> <td valign="center" align="center">{dkp}</td> <td><font color="#000000"> <!--{klasse}-->{klasse}</td> <td valign="center" align="center"><font color="#000000">{rasse}</td> <td> <table> <tr><td><font color="#000000">B<td><td><font color="#000000">{work1}</td></tr> <tr><td><font color="#000000">B<td><td><font color="#000000">{work2}</td></tr> <tr><td><font color="#000000">J<td><td><font color="#000000">{nebenjob}</td></tr> <tr><td><font color="#000000">T<td><td><font color="#000000">{skill}</td></tr> </table> </td> </tr> {EXPLODE} </table> <br /> <br /> |
Geschlossen | ||
![]() |
Zurück zu Module und Modifikationen |