Changeset 691 for trunk/pages/spolek.php


Ignore:
Timestamp:
Mar 19, 2010, 9:46:30 PM (15 years ago)
Author:
george
Message:
  • Opraveno: Generování pěkného pro další stránky.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/pages/spolek.php

    r690 r691  
    1616{
    1717  $guild_id = $id;
    18   $DbResult = $db2->query('SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = '.$guild_id.' LIMIT 1');
     18  $DbResult = $db2->query('SELECT `guildid`, `name`, FROM_UNIXTIME(`createdate`) AS `createdate` FROM `guild` WHERE `guildid` = '.$guild_id.' LIMIT 1');
    1919  $guild_data = $DbResult->fetch_assoc();
    2020  $members = $db2->query('SELECT guild_member.guid, guild_member.rank AS mrank, `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['Level'].' + 1), " ", -1) AS level, (SELECT rname FROM guild_rank WHERE guildid ='.$guild_id.' AND rid = mrank + 1) AS rname, guild_member.pnote, guild_member.offnote FROM guild_member,`characters` LEFT JOIN guild_member k1 ON k1.`guid`=`characters`.`guid` WHERE guild_member.guildid = '.$guild_id.' AND guild_member.guid=`characters`.guid ORDER BY mrank');
     
    2929  $time = mktime($time_stp[0], $time_stp[1], $time_stp[2], $date[1], $date[2], $date[0]);
    3030  $human_date = date('d.m.Y H:i:s', $time);
    31   echo('<a href="?page=guildy">&lt;- Zpět na výpis</a><br />');
     31  echo('<a href="'.$html->Link('/spolky/').'">&lt;- Zpět na výpis</a><br />');
    3232  echo('<table class="BaseTable">
    3333    <tr>
     
    9393    echo('<tr>'.
    9494      '<td align="center">'.$member[2].'</td>'.
    95       '<td align="center"><img src="imgs/icons/'.$online['race'].'-'.$gender.'.gif" alt="pohlaví" /></td>'.
    96       '<td align="center"><img src="imgs/icons/'.$online['class'].'.gif" alt="třída" /></td>'.
     95      '<td align="center"><img src="'.$html->Link('/imgs/icons/'.$online['race'].'-'.$gender.'.gif').'" alt="pohlaví" /></td>'.
     96      '<td align="center"><img src="'.$html->Link('/imgs/icons/'.$online['class'].'.gif').'" alt="třída" /></td>'.
    9797      '<td align="center" style="color: '.$LevelColor.'">'.$Level.'</td>'.
    9898      '<td align="center">'.$member[4].' ('.$member[1].')</td>'.
    9999      '<td align="center" style="color: '.$LogoutTimeColor.'">'.$LogoutTime.'</td>'.
    100       '<td align="center">'.(($online['online']) ? '<img src="imgs/inc/on.gif" alt="online" />' : '<img src="imgs/inc/off.gif" alt="offline" />').'</td>'.
     100      '<td align="center">'.(($online['online']) ? '<img src="'.$html->Link('/imgs/inc/on.gif').'" alt="online" />' : '<img src="'.$html->Link('/imgs/inc/off.gif').'" alt="offline" />').'</td>'.
    101101      '</tr>');
    102102  }
    103103  echo('</table>');
    104 } else echo('<meta http-equiv="refresh" content="0;url=?page=guildy">');
     104} else echo('<meta http-equiv="refresh" content="0;url='.$html->Link('/spolky/').'">');
    105105 
    106106?>
Note: See TracChangeset for help on using the changeset viewer.