0) { $array = mysql_fetch_array($erg); $link = "http://".eregi_replace("http://", "", $array["url"]); $erg = SQL("SELECT klicks FROM $DB_TABLE_TRACK_LINKS WHERE link_id='$lID' OR url='$link'"); if (mysql_num_rows($erg) == 0) $erg = SQL("INSERT INTO $DB_TABLE_TRACK_LINKS (link_id, url, last_klick, klicks) VALUES ('$lID', '$link', NOW(), '1')"); else $erg = SQL("UPDATE $DB_TABLE_TRACK_LINKS SET url='$link', last_klick=NOW(), klicks=klicks+1 WHERE link_id='$lID'"); } } else { $erg = SQL("SELECT ID FROM $DB_TABLE_LINKS WHERE url='$link' OR url='".eregi_replace("http://", "", $link)."'"); if (mysql_num_rows($erg)) { $array = mysql_fetch_array($erg); $lID = $array["ID"]; } $erg = SQL("SELECT klicks FROM $DB_TABLE_TRACK_LINKS WHERE link_id='$lID' OR url='$link'"); if (mysql_num_rows($erg) == 0) $erg = SQL("INSERT INTO $DB_TABLE_TRACK_LINKS (link_id, url, last_klick, klicks) VALUES ('$lID', '$link', NOW(), '1')"); else { $erg = SQL("UPDATE $DB_TABLE_TRACK_LINKS SET last_klick=NOW(), klicks=klicks+1 WHERE url='$link'"); if ($lID) $erg = SQL("UPDATE $DB_TABLE_TRACK_LINKS SET link_id='$lID' WHERE url='$link'"); } } @mysql_close($DB_CONNECTION); if ($link) header ("Location: ".stripslashes($link)); ?>