This mod will show the fanlistings that havent been updated in 2 months in the main page of the admin panel just so it warms you to update your fanlisting before it is reported as a trouble. This modification wont email you the fanlistings that havent been updated in 2 months because I dont like getting emails. I'd rather check my admin panel instead. First things first, this is for enthusiast 3.0 and I will be editing home.php so please please back that up before reading further. Right so on with the tutorial.

1. BACK UP YOUR HOME.PHP (in case you didnt read that bit above)
2. Look for this line in home.php
   require_once( 'mod_settings.php' );
   And underneath that line add:
   require_once( 'mod_notify.php' );
   
3. Look for this line in home.php
   Number of collective affiliates: <b>< ?= count( get_affiliates() ) ? ></b><br /> </p>
   Underneath that line add these lines:
   <* $today = date('Y-m-j'); $get_owned = mysql_query("SELECT * FROM owned WHERE status='2' ORDER BY subject ASC"); $Array = array(); $total = 0; while ($row = mysql_fetch_array($get_owned)) { $subject = $row[subject]; $url = $row[url]; $table = $row[dbtable]; //SHOW LAST UPDATED DATE $query3 = "SELECT `added` FROM $row[dbtable] WHERE `pending` = 0 ORDER BY `added` " . 'DESC LIMIT 1'; $result3 = mysql_query( $query3 ) or die( mysql_error() ); $row3 = mysql_fetch_array( $result3 ); $lastupdated = $row3['added']; // get added date in affiliates table if affiliates is present $afftable = $row[dbtable] . '_affiliates'; if( $row[affiliates] == 1 ) { $query4 = "SELECT added FROM `$afftable` ORDER BY added DESC LIMIT 1"; $result4 = mysql_query( $query4 ); $row4 = mysql_fetch_array( $result4 ); if( $row4['added'] && $row4['added'] > $lastupdated ) $lastupdated = $row4['added']; } $diff = diff_days($today, $lastupdated); if ($diff >= 60){ //echo "<a href=\"" . $url . "\" target=\"_blank\">" . $subject . "</a> <br />"; $total++; $Array[]="<a href=\"" . $url . "\" target=\"_blank\">" . $subject . "</a> - " . $diff; } }//end of while if ($total > 0){ echo "<font color=\"red\">NOTICE</font></p><p>You have " . $total . " fanlistings that havent been updated in over 2 months. They are:<br />"; foreach($Array as $key => $value) { print "$value<br />"; } } *>
   Replace *> with ?> and <* with < ? (without the space).
4. Save home.php and upload it in the admin folder.
5. Create a new file and copy the code below and paste it on your new file
   <* function diff_days($date1,$date2,$seperator="-") { //split parts of the date. IMPORTANT: dd mm yyyy order (seperator is an argument) $date1 = explode($seperator,$date1); $date2 = explode($seperator,$date2); //create UNIX-Time (seconds since the epoche) $unix_date1 = mktime(0,0,0,$date1[1],$date1[2],$date1[0]); $unix_date2 = mktime(0,0,0,$date2[1],$date2[2],$date2[0]); //caluclate the diff $unix_diff = 0; if ($unix_date1 > $unix_date2) { $unix_diff = $unix_date1 - $unix_date2; } else { $unix_diff = $unix_date2 - $unix_date1; } //one day has 86400 seconds return round($unix_diff/86400); } *>
   Replace *> with ?> and <* with < ? (without the space). Save it as mod_notify.php and upload it in the admin folder
6. That is it. If there are any problems please use the contact information in here.

Loaded in 9.6E-05 seconds.