31 lines
665 B
PHP
31 lines
665 B
PHP
<?php
|
|
|
|
$nickname = iconv('UTF-8','ASCII//TRANSLIT',addslashes(htmlentities(substr($_POST["meta"], 0, 30), ENT_QUOTES, 'UTF-8')));
|
|
|
|
if(empty($nickname)) {
|
|
print("nicknameEmpty");
|
|
die();
|
|
}
|
|
|
|
|
|
$sql = "SELECT `settings` FROM `VokabelBox2Users` WHERE `userid` = '$userid'";
|
|
$result_articles = $conn->query($sql);
|
|
while ($articleDb = mysqli_fetch_object($result_articles))
|
|
{
|
|
$settings = json_decode($articleDb->settings, true);
|
|
}
|
|
|
|
$settings[0]['nickname'] = $nickname;
|
|
|
|
$settings_new = json_encode($settings);
|
|
|
|
|
|
$conn->query("UPDATE `VokabelBox2Users` SET `settings` = '$settings_new' WHERE `userid` = '$userid'");
|
|
|
|
|
|
|
|
print("true");
|
|
|
|
|
|
?>
|