Changeset 7


Ignore:
Timestamp:
Aug 9, 2007, 7:58:59 PM (17 years ago)
Author:
george
Message:

ttt

Files:
1 deleted
1 edited

Legend:

Unmodified
Added
Removed
  • guildy.php

    r6 r7  
    1313DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'mangos');
    1414DB_Query('SET NAMES cp1250');
     15<<<<<<< .mine
    1516
    1617$RanksEN = array('Guildmaster', 'Veteran', 'Intendant', 'Support Officer', 'PR Officer', 'Officer', 'Famed Member',
    1718'Member', 'Rokie', 'Newbie');
    18 $RanksCZ = array('Pán cechu', 'Veterán', 'Vrchní správce', 'Pomocný důstojník', 'PR důstojník', 'Důstojník', 'Proslavený člen', 'Člen', 'Zelenáč', 'Nováček');
     19$RanksCZ = array('Pán cechu', 'Veterán', 'Vrchní správce', 'Pomocný dùstojník', 'PR dùstojník', 'Dùstojník', 'Proslavený èlen', 'Èlen', 'Zelenáè', 'Nováèek');
    1920
    2021echo('<h3>Seznam guild:</h3>');
     
    3637  while($Member = DB_Row())
    3738  {
     39=======
     40
     41$RanksEN = array('Guildmaster', 'Veteran', 'Intendant', 'Support Officer', 'PR Officer', 'Officer', 'Famed Member',
     42'Member', 'Rokie', 'Newbie');
     43$RanksCZ = array('Pán cechu', 'Veterán', 'Vrchní správce', 'Pomocný důstojník', 'PR důstojník', 'Důstojník', 'Proslavený člen', 'Člen', 'Zelenáč', 'Nováček');
     44
     45echo('<h3>Seznam guild:</h3>');
     46DB_Query('SELECT guild.*, COUNT(guild_member.guildid) as member_count FROM guild JOIN guild_member ON guild_member.guildid = guild.guildid GROUP BY guild.name ORDER BY member_count DESC');
     47while($Guild = DB_Row())
     48{
     49//  if($Guild['homepage'] != '') $Guild['name'] = $Guild['name'].' <a href="'.$Guild['homepage'].'">WWW</a>';
     50  //if($Guild['info'] != '') $Guild['info'] = ''.$Guild['info'].'</i>';
     51  echo('<hr><div class="DivGuilda">Guilda '.$Guild['name'].'</div>');
     52  echo('<table width="100%" class="TableGuilda" border="0" cellpadding="1" cellspacing="0">');
     53  //echo('<tr><td colspan="2" Class="TdGuilda">Informace: '.$Guild['public_info'].'</td></tr>');
     54 
     55  $GuildRanks = array();
     56  DB_Save();
     57  DB_Select('guild_rank', '*', 'guildid='.$Guild['guildid']);
     58  while($GuildRank = DB_Row()) $GuildRanks[$GuildRank['rid']] = $GuildRank;
     59 
     60  DB_Query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 35), " ", -1)*1 as level, character.name FROM guild_member JOIN `character` ON guild_member.guid = character.guid AND guild_member.guildid='.$Guild['guildid']);
     61  while($Member = DB_Row())
     62  {
     63>>>>>>> .r6
    3864//    $DataParts = explode(' ', $Member['data']);
    3965//    $Member['level'] .= ','.$DataParts[34];
Note: See TracChangeset for help on using the changeset viewer.