FireFox Posted October 7, 2007 Report Share Posted October 7, 2007 Kaa var spelei counter-strike webam uztaisit taadu scriptu kur raadas cik banus ir uzlicis tas un tas admins Piemeeram ka te TOP 10 admins: http://chill.lv/bans/ Plzzz help! Link to comment Share on other sites More sharing options...
martins256 Posted October 7, 2007 Report Share Posted October 7, 2007 izvilks admina niku un ierakstu skaitu ar šo niku tabulā (var izmantot, lai noteiktu cik ir katrs banojis) SELECT admina_niks, COUNT(admina_niks) FROM bani GROUP BY admina_niks Man nesen ar bija problēma ar tādu sarežģītu query... Tas otrs ir grutāks, bet, pēc manām domām, izskatītos šādi. SELECT bani.admina_niks, summary.banu_skaits FROM (SELECT admina_niks, COUNT(admina_niks) AS banu_skaits FROM products GROUP BY admina_niks) summary, bani WHERE summary.admina_niks = bani.admina_niks ORDER BY summary.banu_skaits DESC LIMIT 10 Link to comment Share on other sites More sharing options...
Recommended Posts