nel pastie che ho linkato si vede meglio righe 58-60 sono la definizione di $capt
codice:<style> #nicks{ color: #3366FF !important; } #rolezCell { color: #3366FF !important; font-weight: bolder !important; font-size: 10px !important; } #nickP { font-size: 25px !important; font-weight: bolder !important; } .module-dark .mainbody-tl, .module-dark .mainbody-tr, .module-dark .mainbody-bl, .module-dark .mainbody-br { background-image :url('/osc/images/maintenancebg.jpg') !important; } .mainbody-surround { background-image:url('/osc/images/maintenancebg.jpg') !important; } </style> <?php // no direct access defined( '_JEXEC' ) or die( 'Restricted access' ); $db =& JFactory::getDBO(); class Tabs { public function teamsViewer($sql) { echo "<table width='800' border='0' align ='center'>"; //executing table $query = mysql_query($sql) or die ('Errore nella Query: ' . mysql_errno(). ': '.mysql_error()); while ($row = @mysql_fetch_array($query)) { // flags snippet if ($row[nation] == "") $flag = "N/D"; else $flag = "[img]/osc/images/stories/flags/".strtolower($row[nation])."64.png[/img]"; //called to raceLogos($race) function. $switchrace = $row[race]; $racelogo = $this->raceLogos($switchrace); //nick side if ($row[nick] == "") $row[nick] = "Data Missing"; if ($row[nickid] == "") $bnetid = "Data Missing"; else $bnetid = $row[nickid]; // pics caption for tables from following path so it is choosable from "icon" option of ClanTools if ($row[captimage] == "") $capt = "No caption image provided for the Team " . $row[name] . " "; else $capt = "[img]/osc/images/clantools/logos/".$row[captimage]."[/img]". $capt ."</caption> <tr> <td width = '70' align = 'center'>". $flag ."</td> <td width = '70' align = 'center'>". $racelogo ."</td> <td width = '400' align = 'center'><p id='nickP'>". $row[nick] ."</p></td> <td><p id = 'rolezCell'>". $row[rolez] ."</p></td> </tr>"; } echo "</table> "; } // Race images function private function raceLogos($race) { switch ($race) { case "Terran": return "[img]/osc/images/stories/th_terran.png[/img]"; break; case "Zerg": return "[img]/osc/images/stories/th_zerg.png[/img]"; break; case "Protoss": return "[img]/osc/images/stories/th_protoss.png[/img]"; break; case "Random": return "[img]/osc/images/stories/th_random.png[/img]"; break; default: return "N/D"; } } } // instantiating object $tb = new Tabs(); //Query to get the ordering option of ClanTools joomla plugin $sqlTeamsOrdering = "SELECT ordering, id FROM jos_ct_clan_squad ORDER BY ordering"; $queryTeamsOrdering = mysql_query($sqlTeamsOrdering) or die ('Errore nella Query: ' . mysql_errno(). ': '.mysql_error()); while ($ordering = @mysql_fetch_array($queryTeamsOrdering)) { // called to teamsViewer($sql) function $tb->teamsViewer("SELECT jos_comprofiler.cb_battlenetprofile as bnetprofile, jos_ct_clan_squad.name as name, jos_ct_clan_squad.picture as captimage, jos_ct_clan_squadmember.sid, jos_users.username as nick, cb_sc2race as race, cb_nation as nation, funktion as rolez, jos_ct_clan_squadmember.sid as capt, jos_comprofiler.user_id as id, jos_comprofiler.cb_sc2battlenetid as nickid FROM jos_users, jos_comprofiler, jos_ct_clan_squadmember, jos_ct_clan_squad WHERE jos_comprofiler.id = jos_ct_clan_squadmember.uid AND jos_ct_clan_squad.id = jos_ct_clan_squadmember.sid AND jos_users.id = jos_comprofiler.id AND published = 1 AND jos_ct_clan_squadmember.sid = ".$ordering[id].""); } ?>

Rispondi quotando