function add($data) { if (is_array($data)) { if (array_key_exists('u_username', $data)) { if ($this->user->_checkUsername($data['u_username'], $data['u_email'], true, false)) { include_once PATH_CLASS . '/CIdat.php'; // need for Idat include_once PATH_INCLUDE . '/functions.php'; // need for randomString() $idat =& CIdat::getInstance(); $_randId = $idat->nextID('fotoflix.user_id'); $data['u_key'] = substr($_randId . randomString(), 0, 32); $status = $data['u_status']; //$data['u_password'] = md5($data['u_password']); $data = $this->dbh->asql_safe($data); $keys = array_keys($data); $sql = 'INSERT INTO users(' . implode(', ', $keys) . ', u_dateCreated, u_dateModified) ' . 'VALUES(' . implode(', ', $data) . ', NOW(), NOW())'; $this->dbh->execute($sql); $return = $this->dbh->insert_id(); $sql = 'DELETE FROM user_incompletes WHERE u_key = ' . $data['u_key'] . ' '; $this->dbh->execute($sql); if ($status == 'Pending') { $key = $this->dbh->sql_safe(md5(uniqid(rand(), true))); $this->dbh->execute($sql = 'INSERT INTO user_activation(ua_u_id, ua_key) VALUES(' . $return . ', ' . $key . ')'); } return $return; } else { array_push($this->error, 'Username / Email (' . $data['u_username'] . ' / ' . $data['u_email'] . ') contained invalid characters.'); } } else { array_push($this->error, 'No username was specified.'); } } else { array_push($this->error, 'Malformed data sent to update user.'); return false; } }
function copy($foto_id = false, $user_id = false, $group = false) { $retval = false; if ($foto_id !== false) { include_once PATH_INCLUDE . '/functions.php'; // needed for randomString() include_once PATH_CLASS . '/CIdat.php'; include_once PATH_CLASS . '/CFotobox.php'; $id =& CIdat::getInstance(); $fb =& CFotobox::getInstance(); $foto_data = $fb->fotoData($foto_id); if ($user_id === false) { $user_id = $foto_data['P_U_ID']; } $newName = preg_replace('/\\/thumbnail\\/\\d{6}\\/\\d+/', '/' . $this->stamp . '/' . NOW, $foto_data['P_THUMB_PATH']); copy(PATH_FOTOROOT . $foto_data['P_THUMB_PATH'], PATH_FOTOROOT . '/original' . $newName); // duplicate original copy(PATH_FOTOROOT . $foto_data['P_THUMB_PATH'], PATH_FOTOROOT . '/thumbnail' . $newName); // duplicate thumb $add_data = $this->dbh->query_first('SELECT * FROM user_fotos WHERE up_id = ' . intval($foto_id)); // up_web_path, up_flix_path can be removed once the columns are dropped unset($add_data['up_id'], $add_data['up_u_id'], $add_data['up_key'], $add_data['up_created_at'], $add_data['up_modified_at'], $add_data['up_web_path'], $add_data['up_flix_path']); $add_data['up_u_id'] = intval($user_id); // new user id $add_data['up_key'] = $id->nextID(FF_IMAGE_KEY) . randomString(); //if($group !== false) //{ //$add_data['up_status'] = 'pending'; //} $retval = $this->add($add_data); } return $retval; }
case 'live': $oldDB = 'fotoflix_live'; $newDB = 'photagious_live'; $oldPhotoPath = '/www/www.fotoflix.com/html/fotos'; $newPhotoPath = '/www/photagious.com/www/html/photos'; break; default: echo 'no mode'; die; break; } $u =& CUser::getInstance(); $um =& CUserManage::getInstance(); $fb =& CFotobox::getInstance(); $fbm =& CFotoboxManage::getInstance(); $idat =& CIdat::getInstance(); $fl =& CFlix::getInstance(); $flm =& CFlixManage::getInstance(); $accounts = "'premium_trial'"; if (isset($_GET['username'])) { $fotoflixUsers = $GLOBALS['dbh']->query_all($sql = 'SELECT u_username, u_accountType FROM ' . $oldDB . '.users WHERE u_username = '******'dbh']->sql_safe($_GET['username']) . ' AND u_dateExpires > NOW() AND u_status = \'active\''); } else { if ($mode == 'live') { $fotoflixUsers = $GLOBALS['dbh']->query_all($sql = 'SELECT u_username, u_accountType FROM ' . $oldDB . '.users WHERE u_accountType IN(' . $accounts . ') AND u_dateExpires > NOW() AND u_status = \'active\''); } else { $fotoflixUsers = $GLOBALS['dbh']->query_all($sql = 'SELECT u_username, u_accountType FROM ' . $oldDB . '.users WHERE u_accountType IN(' . $accounts . ') AND u_dateExpires > NOW() AND u_status = \'active\''); } } print_r($fotoflixUsers); foreach ($fotoflixUsers as $ffUser) { $username = $ffUser['u_username'];
function CSession($sess_identifier = false, $user_id = false) { include_once PATH_CLASS . '/CIdat.php'; $this->dbh =& $GLOBALS['dbh']; $this->Idat =& CIdat::getInstance(); if (is_numeric($sess_identifier)) { $ar = $this->dbh->fetch_assoc($this->dbh->query("SELECT us_hash FROM user_session WHERE us_id = '{$sess_identifier}'")); $this->sess_id = $sess_id; $this->sess_hash = $ar['us_hash']; } else { if (strlen($sess_identifier) === 13) { $ar = $this->dbh->fetch_assoc($this->dbh->query($sql = "SELECT us_id FROM user_session WHERE us_hash = '{$sess_identifier}'")); $this->sess_hash = $sess_identifier; $this->sess_id = $ar['us_id']; } else { $this->sess_hash = false; $this->sess_id = false; } } if ($user_id === false) { $ar = $this->dbh->fetch_assoc($this->dbh->query("SELECT us_ud_id FROM user_session WHERE us_id = '{$this->sess_id}'")); $this->user_id = $ar['us_ud_id']; } else { $this->user_id = $user_id; } $this->sess_data = array(); }