Changeset 7
- Timestamp:
- Aug 9, 2007, 7:58:59 PM (17 years ago)
- Files:
-
- 1 deleted
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
guildy.php
r6 r7 13 13 DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'mangos'); 14 14 DB_Query('SET NAMES cp1250'); 15 <<<<<<< .mine 15 16 16 17 $RanksEN = array('Guildmaster', 'Veteran', 'Intendant', 'Support Officer', 'PR Officer', 'Officer', 'Famed Member', 17 18 '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'); 19 20 20 21 echo('<h3>Seznam guild:</h3>'); … … 36 37 while($Member = DB_Row()) 37 38 { 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 45 echo('<h3>Seznam guild:</h3>'); 46 DB_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'); 47 while($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 38 64 // $DataParts = explode(' ', $Member['data']); 39 65 // $Member['level'] .= ','.$DataParts[34];
Note:
See TracChangeset
for help on using the changeset viewer.