diff --git a/2016/user-edit.php b/2016/user-edit.php index 2109372..327e587 100644 --- a/2016/user-edit.php +++ b/2016/user-edit.php @@ -1,393 +1,395 @@ . require 'load.php'; $user = null; if( isset( $_GET['uid'] ) ) { $user = User::factoryFromUID( @ $_GET['uid'] ) ->queryRow(); if( !$user ) { die( "not found" ); } if( !$user->hasPermissionToEditUser() ) { error_die( "Can't edit user" ); } } else { if( !has_permission( 'edit-users' ) ) { error_die( "Can't create user" ); } } // register form submit action if( is_action( 'save-user' ) ) { // avoid spaces if( $_POST['email'] ) { $_POST['email'] = luser_input( $_POST['email'], 32 ); } // generate Gravatar if( $_POST['email'] ) { $_POST['gravatar'] = md5( $_POST['email'] ); } // prepare data sent via POST $data = []; $data[] = new DBCol( User::NAME, $_POST['name'], 's' ); $data[] = new DBCol( User::SURNAME, $_POST['surname'], 's' ); $data[] = new DBCol( User::UID, $_POST['uid'], 's' ); $data[] = new DBCol( User::EMAIL, $_POST['email'], 'snull' ); $data[] = new DBCol( User::WEBSITE, $_POST['site'], 'snull' ); $data[] = new DBCol( User::GRAVATAR, $_POST['gravatar'], 'snull' ); $data[] = new DBCol( User::LOVED_LICENSE, $_POST['lovelicense'], 'snull' ); // promote empty strings to null foreach( $data as $row ) { $row->promoteNULL(); } if( $user ) { // update existing user User::factoryByID( $user->getUserID() ) ->update( $data ); } else { // insert a new User User::factory() ->insertRow( $data ); } $id = $user ? $user->getUserID() : last_inserted_ID(); $user = User::factoryByID( $id ) ->queryRow(); // POST -> redirect -> GET http_redirect( $user->getUserEditURL(), 302 ); } if( isset( $_POST['action'], $_POST['skill_uid'], $_POST['skill_score'] ) ) { $skill = Skill::factoryFromUID( $_POST['skill_uid'] ) ->queryRow(); $skill or error_die( sprintf( "Skill '%s' not found", esc_html( $_POST['skill_uid'] ) ) ); if( is_action( 'change-skill' ) ) { if( isset( $_POST['skill_delete'] ) ) { // Delete skill checked query( sprintf( "DELETE FROM {$T('user_skill')} WHERE user_ID = %d AND skill_ID = %d", $user->getUserID(), $skill->getSkillID() ) ); } else { // Update skill elsewhere query_update('user_skill', new DBCol('skill_score', $_POST['skill_score'], 'd' ), sprintf( 'skill_ID = %d', $skill->getSkillID() ) ); } } if( is_action( 'add-skill' ) ) { $skill = Skill::factoryFromUID( $_POST['skill_uid'] ) ->queryRow(); // If exists, delete it query( sprintf( "DELETE FROM {$T('user_skill')} WHERE user_ID = %d AND skill_ID = %d", $user->getUserID(), $skill->getSkillID() ) ); insert_row('user_skill', [ new DBCol('user_ID', $user->getUserID(), 'd'), new DBCol('skill_ID', $skill->getSkillID(), 'd'), new DBCol('skill_score', $_POST['skill_score'], 'd'), ] ); } } // register action to delete the user if( $user && is_action( 'delete-user' ) ) { // delete the user from the database User::factory() ->whereInt( 'user_ID', $user->getUserID() ) ->delete(); // POST -> redirect -> GET http_redirect( $user->getUserEditURL(), 302 ); } Header::spawn('user', [ 'title' => $user ? sprintf( __("Modifica utente %s"), $user->getUserFullname() ) : __( "Aggiungi Utente" ) , 'url' => $user ? $user->getUserURL() : null, ] ); ?>
= HTML::a( $user->getUserURL(), __( "Vedi" ) . icon('account_box', 'left') ) ?>