multi accounts,

[grlayouts]

the script i have i want it to search the database table players then compare the fields to see if two players have the same ip?

but it doesnt give me a result at all..

what i have is!

[code]<?php $title = "Multi Log"; include("header.php"); ?>
 
<?php
$get_mm = mysql_query("SELECT COUNT(id),ip FROM players WHERE count(id) > 1 GROUP BY ip");
$get_mn = mysql_query("SELECT COUNT(id) FROM users GROUP BY lastIP");
$multi = mysql_result($get_mm);



echo "<font color=red>$multi[ip]</font>";
    echo "<font color=red>$get_mn</font>";
    exit;

?>
<?php include("footer.php"); ?>
[/code]

[rotwyla98]

What do you want the script to in the end do? Perhaps there is an easier solution.

[taith]

this might be slow... but its an idea...

[code]
<?
$title = "Multi Log";
include("header.php");

$get_mm = mysql_query("SELECT COUNT(id),ip FROM players WHERE count(id) > 1 GROUP BY ip");
while($row=mysql_fetch_array($get_mm)){
$ip=$row[ip;]
$get_mn = mysql_query("SELECT ip, id FROM users WHERE `ip`='$ip'");
$row2=mysql_fetch_array($get_mm);
if(!empty($row2)) $doubleips[] = $row[id];
}
print_r($doubleips);

include("footer.php");
?>
[/code]

[grlayouts]

now im getting

Array ( [0] => 52 [1] => 71 [2] => 141 [3] => 34 [4] => 6 [5] => 135 [6] => 140 [7] => 118 [8] => 77 [9] => 98 [10] => 72 [11] => 76 [12] => 116 [13] => 37 [14] => 142 [15] => 150 [16] => 107 [17] => 13 [18] => 149 [19] => 53 [20] => 55 [21] => 33 [22] => 41 [23] => 82 [24] => 39 [25] => 7 [26] => 97 [27] => 102 [28] => 22 [29] => 101 [30] => 152 [31] => 21 [32] => 30 [33] => 114 [34] => 29 [35] => 130 [36] => 122 [37] => 19 [38] => 28 [39] => 80 [40] => 32 [41] => 110 [42] => 153 [43] => 54 [44] => 151 [45] => 60 [46] => 73 [47] => 83 [48] => 20 [49] => 42 [50] => 104 [51] => 133 [52] => 40 [53] => 119 [54] => 84 [55] => 126 [56] => 103 [57] => 58 [58] => 49 [59] => 35 [60] => 89 [61] => 12 [62] => 131 [63] => 112 [64] => 108 [65] => 79 [66] => 47 [67] => 94 [68] => 144 )

[taith]

oops

[code]
<?
$title = "Multi Log";
include("header.php");

$get_mm = mysql_query("SELECT * FROM users");
while($row=mysql_fetch_array($get_mm)){
$ip=$row[ip];
$get_mn = mysql_query("SELECT * FROM users WHERE `ip`='$ip'");
$row2=mysql_fetch_array($get_mm);
if(!empty($row2)) $doubleips[] = $row2[id];
}
print_r($doubleips);

include("footer.php");
?>
[/code]

that should output usernames... not ip addresses...

[grlayouts]

Array ( [0] => 1 [1] => 6 [2] => 1 [3] => 1 [4] => 10 [5] => 9 [6] => 11 [7] => 12 [8] => 27 [9] => 13 [10] => 19 [11] => 14 [12] => 15 [13] => 16 [14] => 17 [15] => 18 [16] => 22 [17] => 20 [18] => 24 [19] => 21 [20] => 23 [21] => 25 [22] => 26 [23] => 46 [24] => 28 [25] => 29 [26] => 32 [27] => 30 [28] => 31 [29] => 34 [30] => 35 [31] => 33 [32] => 39 [33] => 40 [34] => 37 [35] => 37 [36] => 38 [37] => 41 [38] => 42 [39] => 1 [40] => 43 [41] => 44 [42] => 47 [43] => 59 [44] => 37 [45] => 60 [46] => 49 [47] => 52 [48] => 51 [49] => 53 [50] => 54 [51] => 55 [52] => 56 [53] => 57 [54] => 58 [55] => 61 [56] => 62 [57] => 64 [58] => 65 [59] => 66 [60] => 67 [61] => 68 [62] => 69 [63] => 70 [64] => 71 [65] => 72 [66] => 73 [67] => 74 [68] => 75 [69] => 76 [70] => 77 [71] => 78 [72] => 81 [73] => 79 [74] => 80 [75] => 82 [76] => 83 [77] => 89 [78] => 87 [79] => 85 [80] => 84 [81] => 86 [82] => 90 [83] => 92 [84] => 88 [85] => 74 [86] => 91 [87] => 93 [88] => 94 [89] => 97 [90] => 95 [91] => 96 [92] => 98 [93] => 100 [94] => 106 [95] => 101 [96] => 104 [97] => 108 [98] => 102 [99] => 103 [100] => 110 [101] => 105 [102] => 107 [103] => 109 [104] => 111 [105] => 112 [106] => 113 [107] => 118 [108] => 116 [109] => 114 [110] => 110 [111] => 117 [112] => 123 [113] => 119 [114] => 120 [115] => 121 [116] => 122 [117] => 125 [118] => 124 [119] => 129 [120] => 126 [121] => 127 [122] => 128 [123] => 1 [124] => 130 [125] => 131 [126] => 135 [127] => 133 [128] => 134 [129] => 137 [130] => 136 [131] => 125 [132] => 140 [133] => 139 [134] => 141 [135] => 144 [136] => 142 [137] => 125 [138] => 147 [139] => 145 [140] => 146 [141] => 149 [142] => 150 [143] => 148 [144] => 151 [145] => 152 [146] => 153 [147] => 154 [148] => 155 )

now im getting that???

[grlayouts]

ok after a jingle im getting

Array ( [0] => Admin [1] => murda inc [2] => Admin [3] => Admin [4] => The Goon [5] => eber [6] => nolan4 [7] => maxpg [8] => xiaoou [9] => laner [10] => lestah [11] => beava [12] => Krazy [13] => kurtis469 [14] => PUCK_ME [15] => Ghost [16] => lstuartreno [17] => bogus103 [18] => SVENG52 [19] => tzayfod [20] => Driftasoarer [21] => jiang [22] => sami270 [23] => briggs80 [24] => hotlude [25] => silent72 [26] => Windowpane [27] => drut86 [28] => 75firebird [29] => Whalen [30] => meredith 91 [31] => One Hit [32] => dietalibanman [33] => TwIsTeD_MaRiNe [34] => freshman91 [35] => freshman91 [36] => 5WoodY5 [37] => mz.murder [38] => mike the VAlint [39] => Admin [40] => XMastaCrackaX [41] => ftk420 [42] => rosco [43] => Nicola [44] => freshman91 [45] => lost [46] => chaosthirteen [47] => Abbath [48] => cockatoo [49] => Beanz [50] => foreman [51] => Replikan [52] => Bam~Bam [53] => maka695 [54] => Toon [55] => pussy [56] => jambo [57] => darkrayne [58] => h01377 [59] => CheeseOnToast [60] => Fury [61] => aok [62] => anglegurlstar92 [63] => A33ER [64] => delta0999 [65] => shirubesutsure [66] => josh305 [67] => Zoner [68] => Zorro [69] => bizzybonee99 [70] => ROLLING SQUAD [71] => afonsodomingues [72] => Treven [73] => Russian ppl [74] => trouble [75] => abayahya [76] => bennerhingl [77] => gunne2006 [78] => scarydukey [79] => VikoVeiga [80] => Ayedon [81] => Gruzza [82] => duce [83] => bj977 [84] => 9 Unit's [85] => Zoner [86] => hobomajomo [87] => inturbo [88] => carl4000111 [89] => stedders [90] => billy [91] => island [92] => sweep [93] => mrhobo [94] => mooiiiboyyy [95] => yogie [96] => Shaeed [97] => leatheldave [98] => kovokashi [99] => tno9 [100] => masteroftigerz [101] => Untouchable [102] => warbasherz [103] => nojoegohome [104] => davis [105] => IceCube [106] => Rose [107] => clackfish [108] => steve121 [109] => PiprH [110] => masteroftigerz [111] => Thrice [112] => mikemmax [113] => Connodor [114] => bigdizzle [115] => devilman954 [116] => St.Jimmy [117] => bradleynutty [118] => tygrer [119] => bradleylowe [120] => Jager [121] => HobO [122] => treadon [123] => Admin [124] => theclowns [125] => hooky [126] => KidA1337 [127] => SBKvenomKWC [128] => yoyak [129] => thedon [130] => jessiesmomie21 [131] => bradleynutty [132] => sinboi [133] => sfkgamer [134] => kourrie14 [135] => splotman [136] => GothicMetal [137] => bradleynutty [138] => marilyn96 [139] => darerevo [140] => mechacourage [141] => kuledude [142] => TrIcKz [143] => Bledsoe [144] => navydawg13 [145] => lady pharaoh [146] => dogsdog [147] => 2quik4u [148] => Thru ) Thru

now how do i get it to display only the same ones and there username?

[taith]

oh! oops! i see whats going on here :-)
[code]
<?
$title = "Multi Log";
include("header.php");

$result= mysql_query("SELECT * FROM users");
while($row=mysql_fetch_array($result)){
$ip=$row[ip];
$result2= mysql_query("SELECT * FROM users WHERE `ip`='$ip'");
$row2=mysql_fetch_array($result2);
if(!empty($row2)) $doubleips[] = $row2[id];
}
print_r($doubleips);

include("footer.php");
?>
[/code]

we had
[code]
mysql_fetch_array($get_mm);
[/code]
twice