File manager - Edit - /home/missmand/public_html/learning/old/main/webservices/example_fill_users_fields.php
Back
<?php /** * This script populates the user_extra_fields_value table with a new field which * contains the username for each user. This allows you to use web * services to update users based on their username (which is assumed * to be the same as in the application which calls the webservice). * This script should be called any time a new user (or a large group of new * users) is added to the database. * @package chamilo.webservices */ //remove the next line to enable the script (this can harm your database so // don't enable unless you know what you're doing and you have a backup) die(); // update this ID after you create the corresponding field through the Chamilo // profile fields manager (admin page, users section) as text field. // Give this field a name you will later use in original_field_id_name, while // you will use the normal username of Chamilo users. $extra_field_id = 9; require_once('../inc/global.inc.php'); $tuser = Database::get_main_table(TABLE_MAIN_USER); $tuserfv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES); $sql = "SELECT user_id, username FROM $tuser ORDER BY user_id"; $res = Database::query($sql); while($row = Database::fetch_array($res)) { $sql2 = "INSERT INTO $tuserfv (user_id, field_id, field_value) VALUES (".$row['user_id'].", 11,'".$row['username']."')"; $res2 = Database::query($sql2); }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings