[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3  #===========================================================================

   4  #= Project : PluggedOut Nexus

   5  #= Version : 0.1

   6  #= Author  : Jonathan Beckett

   7  #= Email   : jonbeckett@pluggedout.com

   8  #= Home    : http://www.pluggedout.com/index.php?pk=dev_nexus

   9  #= Support : http://www.pluggedout.com/development/forums/viewforum.php?f=24

  10  #===========================================================================

  11  #= Copyright (c) 2005 Jonathan Beckett

  12  #= You are free to use and modify this script as long as this header

  13  #= section stays intact. This file is part of PluggedOut Nexus.

  14  #=

  15  #= This program is free software; you can redistribute it and/or modify

  16  #= it under the terms of the GNU General Public License as published by

  17  #= the Free Software Foundation; either version 2 of the License, or

  18  #= (at your option) any later version.

  19  #=

  20  #= This program is distributed in the hope that it will be useful,

  21  #= but WITHOUT ANY WARRANTY; without even the implied warranty of

  22  #= MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

  23  #= GNU General Public License for more details.

  24  #=

  25  #= You should have received a copy of the GNU General Public License

  26  #= along with BLOG files; if not, write to the Free Software

  27  #= Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

  28  #===========================================================================

  29  */
  30  
  31  
  32  include  "./lib/config.php";
  33  include  "./lib/database.php";
  34  
  35  
  36  $con = db_connect();            
  37  
  38  $sql = "SELECT nUserId FROM nexus_users";
  39  $result = mysql_query($sql,$con);
  40  
  41  if ($result!=false){
  42  
  43      while ($row=@mysql_fetch_array($result)){
  44  
  45          if (file_exists("pictures/".$row["nUserId"].".jpg")){
  46          
  47              $sql = "UPDATE nexus_users SET cImageFile='pictures/".$row["nUserId"].".jpg' WHERE nUserId=".$row["nUserId"];
  48              $aresult = mysql_query($sql,$con);
  49          }
  50      }
  51  
  52  }
  53  
  54  print "finished";
  55  
  56  ?>