patch-4.2.6-uploads.php

<?php
/*
UserSpice 4
An Open Source PHP User Management System
by the UserSpice Team at http://UserSpice.com
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://
//::
//:: This will patch your database from v4.2.6
//::
//:: WARNING ! BACKUP YOUR DATABASE BEFORE RUNNING THIS PATCH
//::
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://
require_once '../users/init.php';
require_once $abs_us_root.$us_url_root.'users/includes/header.php';
require_once $abs_us_root.$us_url_root.'users/includes/navigation.php';


  $profileA = $db->query("ALTER TABLE profiles
         ADD COLUMN avatar varchar(255) NOT NULL
         ");

  $fields = array(
      'avatar'  => '',
  );
  $profileQ = $db->insert('profiles',$fields);

bold("<br><br>You're good to go.  Delete PATCH FILE and bask in the glory");