Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    New Zealand
    Posts
    15

    Question change fopen to outside URL to local file

    Hi all, I am not too good at PHP but i am learning. I have a site that is mostly PHP script, one page is to call a file and dump it into MySQL. Problem is the webhost wont allow fopen command, so i am trying to get the script to look in the same directory it resides to get the file and dump to mysql

    Here is the piece of code that needs changing

    Code:
    $f = fopen("http://domain.here/thisfile.txt", "r");
    if (!$f)
      die("Cannot download thisfile.txt!");
    
    mysql_query("DELETE FROM bans WHERE comment LIKE 'PeerGuardian: %'") or sqlerr(__FILE__, __LINE__);
    i need the script to pull "thisfile.txt" from the wwwroot, (this script actually sits in the wwwroot)

    the complete file is this

    Code:
    <?
    // This script downloads/adds/updates peerguardian IP ranges in the bans table.
    
    require_once("backend/functions.php");
    
    dbconn();
    
    if (get_user_class() < UC_ADMINISTRATOR)
      die;
    
    $f = fopen("http://domain.here/thisfile.txt", "r");
    if (!$f)
      die("Cannot download thisfile.txt!");
    
    mysql_query("DELETE FROM bans WHERE comment LIKE 'PeerGuardian: %'") or sqlerr(__FILE__, __LINE__);
    
    $n = 0;
    $o = 0;
    $dt = sqlesc(get_date_time());
    while (!feof($f))
    {
      ++$o;
      $s = rtrim(fgets($f));
      $i = strrpos($s, ":");
      if (!$i) continue;
      $comment = sqlesc("PeerGuardian: " . substr($s, 0, $i));
      $s = substr($s, $i + 1);
      $i = strpos($s, "-");
      $first = ip2long(substr($s, 0, $i));
      $last = ip2long(substr($s, $i + 1));
      if ($first == -1 || $last == -1) continue;
      mysql_query("INSERT INTO bans (added, addedby, first, last, comment) VALUES($dt, $uid, $first, $last, $comment)") or sqlesc(__FILE__, __LINE__);
      ++$n;
    }
    $o -= $n;
    print("$n ranges imported, $o line(s) was discarded.");
    
    ?>
    Any help to do this and point me in the right direction is most appreciated, and my sincere thanks to those who take the time to look at this for me.

  2. #2
    Join Date
    Dec 2003
    Location
    New Zealand
    Posts
    15
    **SOLVED**

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •