su_check(access_control::SU_RIGHT_MULTI,true); /*$ppp = 1; $page = ($_GET['page']) ? $_GET['page'] : 1; $sql = 'SELECT COUNT(*) AS nr FROM accounts WHERE uniqueid!="" GROUP BY uniqueid HAVING COUNT(*) > 1'; $res = db_query($sql); $anzahl = db_fetch_assoc($res); $page_max = ceil($anzahl['nr'] / $ppp); $max = min($page * $ppp, $anzahl['nr']); $start = ($page-1) * $ppp; for($i=1; $i<=$page_max; $i++) { $page_min = max(($i-1) * $ppp,1); $page_max = $ppp * $i; addnav('Seite '.$i.' ('.$page_min.' - '.$page_max.')','multi.php?page='.$i); }*/ /*$ip = $idlist = $users = array(); $sql = 'SELECT uniqueid FROM accounts WHERE uniqueid!="" GROUP BY uniqueid HAVING COUNT(*) > 1'; $result = db_query($sql); while ($row = db_fetch_assoc($result)) { $idlist[] = $row['uniqueid']; }*/ //output("`n`bMulti - genaue Analyse`b`n`n`0"); output('',true); foreach ($_GET['multi_id'] AS $id) { $sql = "SELECT accounts.acctid,accounts.name,lastip,uniqueid,dragonkills,level,laston,referer,guildid FROM accounts LEFT JOIN account_extra_info USING(acctid) WHERE accounts.acctid = '$id' AND locked='0' ORDER BY dragonkills ASC, level ASC"; $result = db_query($sql); while ($row = db_fetch_assoc($result)) { $userlist[] = $row; } //$usergroup[] = $userlist; //unset($userlist); } $usergroup[] = $userlist; foreach ($usergroup AS $group) { $in_acctid = ''; $i = count($group); output("`Q$i Multis`0`n"); output("",true); output("",true); foreach ($group AS $member) { output("",true); output("",true); $in_acctid .= ','.$member['acctid']; $laston=round((strtotime("0 days")-strtotime($member[laston])) / 86400,0)." Tage"; if (substr($laston,0,2)=="1 ") $laston="1 Tag"; if (date("Y-m-d",strtotime($member[laston])) == date("Y-m-d")) $laston="Heute"; if (date("Y-m-d",strtotime($member[laston])) == date("Y-m-d",strtotime("-1 day"))) $laston="Gestern"; if ($loggedin) $laston="Jetzt"; output("",true); output("",true); } output("

AcctID	Spieler/in	letzte IP	Heldentaten	Level	Last On	Geworben von (ID)	GildeID
".$member['acctid']."	".$member['name']."	".$member['lastip']."	" .$member['dragonkills']."	".$member['level']."	".$laston."	".$member['referer']."	".$member['guildid']."

",true); // -> debuglog $sql = 'SELECT date,actor,target,message,a1.name as actorname,a2.name as targetname FROM debuglog LEFT JOIN accounts as a1 ON a1.acctid=debuglog.actor LEFT JOIN accounts as a2 ON a2.acctid=debuglog.target WHERE actor IN (-1'.$in_acctid.') AND target IN (-1'.$in_acctid.') ORDER BY date DESC, actor ASC'; $result = db_query($sql); if (db_num_rows($result) == 0) { output("`^Debuglog:`0`n Keine Interaktion. `@Guuuuuut.`0`n"); } else { output("`^Debuglog:`0`n Die folgenden Interaktionen wurden gefunden:`n"); while ($row = db_fetch_assoc($result)) { output("`$ Log:`0 ".$row['date']." - ".$row['actorname']." ".$row['message']. " ".$row['targetname']."`n" ); } } // -> houses Eigentümer $comarray = array(); $vergehen=0; $owner=0; $sql = 'SELECT houseid,owner,status,housename,a1.name as hausholder FROM houses LEFT JOIN accounts as a1 ON a1.acctid=houses.owner WHERE owner IN (-1'.$in_acctid.') ORDER BY owner ASC'; $result = db_query($sql); if (db_num_rows($result) == 0) { output("`^Häuser:`0 Keine Hauseingentümer!`0`n"); } else { $i = 1; output("`^Häuser:`0`n"); while ($row = db_fetch_assoc($result)) { $sql2 = 'SELECT houses.houseid, houses.status, a1.name as hausholder, a2.name as keyholder, k.owner as keyowner FROM keylist k INNER JOIN houses ON k.value1 = houses.houseid LEFT JOIN accounts as a1 ON a1.acctid=houses.owner LEFT JOIN accounts as a2 ON a2.acctid=k.owner WHERE houses.owner = '.$row[owner].' AND k.owner IN (-1'.$in_acctid.') AND k.owner != '.$row[owner].' AND k.type = '.HOUSES_KEY_DEFAULT.' ORDER BY keyholder ASC'; $result2 = db_query($sql2); if (db_num_rows($result2) == 0) { output("Hauseingentümer ".$row['hausholder']." `@ohne Schlüssel-Vergehen!`0`n"); } else { while ($row2 = db_fetch_assoc($result2)) { output("`$ Vergehen $i:`0 Hausbesitzer ist ".$row2['hausholder'].", Schlüssel hat ".$row2['keyholder']." `n"); //status als zaehler brauchen $row2['status']= $i; $comarray[] = $row2; $vergehen++; //commentary hauseigentümer über folgenden trickauslesen //if ( $owner == 0 || $owner == $row['owner'] ) { if ( $owner != $row['owner'] ) { $row2['keyowner']=$row['owner']; $comarray[] = $row2; $owner=$row['owner']; } // $i++; } } } } // -> Houses Eigentümer commentary $flag = 0; if ( $vergehen > 0 ) { $i=1; $hoch = 0; foreach ($comarray AS $com) { if ( $flag == 0 ) { output("`6Comment Summary:`0`n"); $flag++; } $i = $com['status']; $section = "house-".$com['houseid']; $author = $com['keyowner']; $hausnr = $com['houseid']; $sql = 'SELECT *, a1.name as actorname FROM commentary LEFT JOIN accounts as a1 ON a1.acctid=commentary.author WHERE author ='.$author.' AND section ="'.$section.'" AND self = 0 ORDER BY commentid ASC'; $result = db_query($sql); if (db_num_rows($result) == 0) { output("`6($i)`0 Keine Einträge`n"); } else { $dg = $ng = $de = $ne = 0; while ($row = db_fetch_assoc($result)) { $text = $row['comment']; $wer = $row['actorname']; $text2 = str_replace(": ", " ", $row['comment']); //output($row['actorname']."`0 ".$text2."`0`n" ); if ( !strpos( $text, "Edelsteine") ) { if ( !strpos( $text, "nimmt") ) { $tmp = str_replace(": `@deponiert `^", "", $text); $tmp = str_replace("`@ Gold.", "", $tmp); $dg += $tmp; } else { $tmp = str_replace(": `\$nimmt `^", "", $text); $tmp = str_replace("`$ Gold.", "", $tmp); $ng += $tmp; } } else { if ( !strpos( $text, "nimmt") ) { $tmp = str_replace(": `@deponiert `#", "", $text); $tmp = str_replace("`@ Edelsteine.", "", $tmp); $de += $tmp; } else { $tmp = str_replace(": `\$nimmt `#", "", $text); $tmp = str_replace("`$ Edelsteine.", "", $tmp); $ne += $tmp; } } } output("`0`6($i) Haus $hausnr:`0 $wer `$ deponiert $dg Gold und $de Gems, nimmt $ng Gold und $ne Gems.`0`n" ); } if ( $hoch == 0 ) { $hoch = 1; } else { $i++; $hoch = 0; } } } unset($comarray); // -> houses Bewohner $comarray = array(); $id_alt=0; $sql = 'SELECT k.value1, k.owner AS keyowner, houses.owner AS houseowner FROM keylist k LEFT JOIN houses ON houses.houseid=k.value1 WHERE k.owner!=houses.owner AND k.owner IN (-1'.$in_acctid.') AND k.type = '.HOUSES_KEY_DEFAULT.' ORDER BY houses.owner ASC'; $result = db_query($sql); if (db_num_rows($result) == 0) { output("`^Schlüssel:`0 Kein Schlüsselbesitz!`0`n"); } else { $i = 1; output("`^Schlüssel:`0`n"); while ($row = db_fetch_assoc($result)) { if ( $id_alt != $row['houseowner'] ) { $id_alt = $row['houseowner']; $sql2 = 'SELECT k.value1, k.owner AS keyowner, houses.owner AS houseowner, a1.name as hausholder, a2.name as keyholder FROM keylist k LEFT JOIN houses ON houses.houseid=k.value1 LEFT JOIN accounts as a1 ON a1.acctid=houses.owner LEFT JOIN accounts as a2 ON a2.acctid=k.owner WHERE k.owner!=houses.owner AND k.owner IN (-1'.$in_acctid.') AND houses.owner = '.$id_alt.' AND k.type = '.HOUSES_KEY_DEFAULT.' ORDER BY houses.owner ASC'; $result2 = db_query($sql2); if (db_num_rows($result2) == 0) { output("Hauseingentümer ".$row['hausholder']." `@ohne Schlüssel-Vergehen!`0`n"); } else if (db_num_rows($result2) == 1) { $row2 = db_fetch_assoc($result2); output("Hausbesitzer Nr. ".$row2['value1']." ist ".$row2['hausholder'].", Schlüssel hat ".$row2['keyholder']." `@Ok.`0`n"); } else { while ($row2 = db_fetch_assoc($result2)) { output("`$ Vergehen $i:`0 Hausbesitzer Nr. ".$row2['value1']." ist ".$row2['hausholder'].", Schlüssel hat ".$row2['keyholder']." `n"); $comarray[] = $row2; $i++; } } } } } // -> Houses Bewohner commentary $flag = 0; $i = 1; foreach ($comarray AS $com) { if ( $flag == 0 ) { output("`6Comment Summary:`0`n"); $flag++; } $section = "house-".$com['value1']; $author = $com['keyowner']; $hausnr = $com['value1']; $sql = 'SELECT *, a1.name as actorname FROM commentary LEFT JOIN accounts as a1 ON a1.acctid=commentary.author WHERE author ='.$author.' AND section ="'.$section.'" ORDER BY commentid ASC'; $result = db_query($sql); if (db_num_rows($result) == 0) { output("`6($i)`0 Keine Einträge`n"); } else { $dg = $ng = $de = $ne = 0; while ($row = db_fetch_assoc($result)) { $text = $row['comment']; $wer = $row['actorname']; $text2 = str_replace(": ", " ", $row['comment']); //output($row['actorname']."`0 ".$text2."`0`n" ); if ( !strpos( $text, "Edelsteine") ) { if ( !strpos( $text, "nimmt") ) { $tmp = str_replace(": `@deponiert `^", "", $text); $tmp = str_replace("`@ Gold.", "", $tmp); $dg += $tmp; } else { $tmp = str_replace(": `\$nimmt `^", "", $text); $tmp = str_replace("`$ Gold.", "", $tmp); $ng += $tmp; } } else { if ( !strpos( $text, "nimmt") ) { $tmp = str_replace(": `@deponiert `#", "", $text); $tmp = str_replace("`@ Edelsteine.", "", $tmp); $de += $tmp; } else { $tmp = str_replace(": `\$nimmt `#", "", $text); $tmp = str_replace("`$ Edelsteine.", "", $tmp); $ne += $tmp; } } } output("`0`6($i) Haus $hausnr:`0 $wer `$ deponiert $dg Gold und $de Gems, nimmt $ng Gold und $ne Gems.`0`n" ); } $i++; } unset($comarray); output("`n`n"); } popup_footer(); ?>