'; foreach ($d as $n => $c){ // echo ''.$n.''.$c.''; $all[$n]['file'] = $c; } // echo ''; // echo '
'; } //require('duck2011local.php'); $sql = 'SELECT id, name, value FROM duck2011 WHERE name="'.$r.'"'; $mainq = mysql_query($sql); $aantal_lijnen = mysql_num_rows($mainq); if ($aantal_lijnen > 0){ $row=mysql_fetch_row($mainq); $counter = $row[2]; }else{ $counter = 0; $sql = 'INSERT INTO duck2011 (name, value) values ("'.$r.'","'.($counter+1).'")'; $mainq = mysql_db_query($db,$sql, $dbh); } if ($f == 'counter'){ $sql = 'SELECT id, name, value FROM duck2011'; $mainq = mysql_db_query($db,$sql, $dbh); $aantal_lijnen = mysql_num_rows($mainq); //echo ''; for ($i = 0; $i<$aantal_lijnen; $i++){ $row=mysql_fetch_row($mainq); //$counter = $row[2]; // echo ''; $all[$row[1]]['sql'] = $row[2]; } } //echo '

'.$row[1].'

'.$row[2].'

'; //echo '

'; if ($f == 'counter'){ function refstrep($rt,$name,$refnam){ if ($rt != ""){return $rt;} if (strpos($name,$refnam) == 4){return $refnam;} return ""; } echo ''; echo ''; foreach($all as $name => $subject){ if ($subject['file'] > $subject['sql']){$maxx = $subject['file'];}else{$maxx = $subject['sql'];} //echo ''; if (is_file($name)){ if (!isset($correctFiles[($maxx+0)])){$ind = ($maxx+0);}else{$ind = ($maxx+0).$name;} $correctFiles[$ind]['name'] = $name; $correctFiles[$ind]['file'] = ($subject['file']+0); $correctFiles[$ind]['sql'] = ($subject['sql']+0); $correctFiles[$ind]['max'] = ($maxx+0); }elseif(substr($name,0,4) == "REF_"){ $rt = ""; //if (strpos($name,'http://www.minecraftforum.net/viewtopic.php?f=1022&t=165779') == 4){$rt = 'MC_F_T';} //$rt = refstrep($rt,$name,'http://www.minecraftforum.net/viewtopic.php?f=1022&t=165779'); //http://www.minecraftforum.net/viewtopic.php?f= $rt = refstrep($rt,$name,'http://www.minecraftforum.net/topic/153066-'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net/topic/'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net/viewtopic.php?f=1022'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net/viewtopic.php?f='); $rt = refstrep($rt,$name,'http://www.minecraftforum.net/'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net.external.vkontakte.ru/topic/153066-'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net.external.vkontakte.ru/topic/'); //$rt = refstrep($rt,$name,'http://www.minecraftforum.net.external.vkontakte.ru/viewtopic.php?f=1022&t=165779'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net.external.vkontakte.ru/viewtopic.php?f=1022'); $rt = refstrep($rt,$name,'http://www.minecraftforum.net.external.vkontakte.ru/'); $rt = refstrep($rt,$name,'http://www.facebook.com/l.php?u='); $rt = refstrep($rt,$name,'http://translate.googleusercontent.com/translate_c'); if ($rt == ""){$rt = "Other";} //$ind = count($refs[$rt]); if (!isset($refs[$rt][($maxx+0)])){$ind = ($maxx+0);}else{$ind = ($maxx+0).$name;} $refs[$rt][$ind]['name'] = $name; $refs[$rt][$ind]['file'] = ($subject['file']+0); $refs[$rt][$ind]['sql'] = ($subject['sql']+0); $refs[$rt][$ind]['max'] = ($maxx+0); $reftots[$rt]['name'] = $name; $reftots[$rt]['file'] = $reftots[$rt]['file'] + $refs[$rt][$ind]['file']; $reftots[$rt]['sql'] = $reftots[$rt]['sql'] + $refs[$rt][$ind]['sql']; $reftots[$rt]['max'] = $reftots[$rt]['max'] + $refs[$rt][$ind]['max']; $reftots[$rt]['count'] = $reftots[$rt]['count'] + 1; $reftotsort[$rt] = $reftotsort[$rt] + $refs[$rt][$ind]['max']; }else{ // $ind = count($incorrectFiles); if (!isset($incorrectFiles[($maxx+0)])){$ind = ($maxx+0);}else{$ind = ($maxx+0).$name;} $incorrectFiles[$ind]['name'] = $name; $incorrectFiles[$ind]['file'] = ($subject['file']+0); $incorrectFiles[$ind]['sql'] = ($subject['sql']+0); $incorrectFiles[$ind]['max'] = ($maxx+0); $incortots['file'] = $incortots['file'] + $incorrectFiles[$ind]['file']; $incortots['sql'] = $incortots['sql'] + $incorrectFiles[$ind]['sql']; $incortots['max'] = $incortots['max'] + $incorrectFiles[$ind]['max']; } } ksort($correctFiles); $correctFiles = array_reverse($correctFiles); foreach ($correctFiles as $fid => $thisFile){ echo ''; } echo ''; echo ''; echo ''; asort($reftotsort); $reftotsort = array_reverse($reftotsort); //ksort($refs); // foreach ($refs as $rn => $refsa){ foreach($reftotsort as $rn => $bak){ $refsa = $refs[$rn]; if ($rn != ''){echo '';} ksort($refsa); $refsa = array_reverse($refsa); foreach ($refsa as $fid => $thisFile){ echo ''; } } ksort($incorrectFiles); $incorrectFiles = array_reverse($incorrectFiles); /* echo ''; echo ''; foreach ($incorrectFiles as $fid => $thisFile){ echo ''; } */ if ($rn != ''){echo '';} foreach ($incorrectFiles as $fid => $thisFile){ echo ''; } echo '

Name	File	SQL	Max
'.$name.'	'.($subject['file']+0).'	'.($subject['sql']+0).'	'.($maxx+0).'
'.$thisFile['name'].'	'.$thisFile['file'].'	'.$thisFile['sql'].'	'.$thisFile['max'].'
Referrer Name	File	SQL	Max
'.$rn.' ('.$reftots[$rn]['count'].')	'.$reftots[$rn]['file'].'	'.$reftots[$rn]['sql'].'	'.$reftots[$rn]['max'].'
'.$thisFile['name'].'	'.$thisFile['file'].'	'.$thisFile['sql'].'	'.$thisFile['max'].'
Typo Name	File	SQL	Max
'.$thisFile['name'].'	'.$thisFile['file'].'	'.$thisFile['sql'].'	'.$thisFile['max'].'
Typos ('.count($incorrectFiles).')	'.$incortots['file'].'	'.$incortots['sql'].'	'.$incortots['max'].'
'.$thisFile['name'].'	'.$thisFile['file'].'	'.$thisFile['sql'].'	'.$thisFile['max'].'

'; } $sql = 'UPDATE duck2011 SET value="'.($counter+1).'" WHERE name="'.$r.'"'; $mainq = mysql_db_query($db,$sql, $dbh); $ref = 'REF_'.$_SERVER['HTTP_REFERER']; if (strpos($ref,'http://www.minecraftforum.net/viewtopic.php?f=1022&t=165779&sid=')!== false){$ref = 'REF_SID_http://www.minecraftforum.net/viewtopic.php?f=1022&t=165779';} $sql = 'SELECT id, name, value FROM duck2011 WHERE name="'.$ref.'"'; $mainq = mysql_query($sql); $aantal_lijnen = mysql_num_rows($mainq); if ($aantal_lijnen > 0){ $row=mysql_fetch_row($mainq); $refCounter = $row[2]; }else{ $refCounter = 0; $sql = 'INSERT INTO duck2011 (name, value) values ("'.$ref.'","'.($refCounter+1).'")'; $mainq = mysql_db_query($db,$sql, $dbh); } $sql = 'UPDATE duck2011 SET value="'.($refCounter+1).'" WHERE name="'.$ref.'"'; $mainq = mysql_db_query($db,$sql, $dbh); if ($f != 'counter'){ header('Location: http://www.duponline.net/cartograph_g/'.$f); } ?>