case "moveusermessages": moveUserMessages($option, $cid); break; case "moveusermessagesnow": moveUserMessagesNow($option, $cid); break; case "showCss": showCss($option); break; case "saveeditcss": $file = JRequest::getVar('file', 1); $csscontent = JRequest::getVar('csscontent', 1); saveCss($file, $csscontent, $option); break; case "saveuserprofile": saveUserProfile($option); break; case "pruneforum": pruneforum($kunena_db, $option); break; case "doprune": doprune($kunena_db, $option); break; case "douserssync": douserssync($kunena_db, $option); break; case "syncusers": syncusers($kunena_db, $option); break; case "browseImages": browseUploaded($kunena_db, $option, 1);
<?php // resume the session session_start(); $userName = $_SESSION[username]; $action = isset($_POST['action']); if ($action == 'load') { loadUserProfile($userName); } else { if ($action == 'save') { saveUserProfile(); } } function loadUserProfile($userName) { require "../db/db.php"; $user = $mysqli->real_escape_string($userName); $sql = "SELECT id, name, userName, email, picture, group_id FROM USER WHERE userName='******'"; $result = array(); if ($resultdb = $mysqli->query($sql)) { if ($resultdb->num_rows == 1) { while ($profile = $resultdb->fetch_assoc()) { $result = $profile; } } $resultdb->close(); } echo json_encode(array("success" => $mysqli->connect_errno == 0, "data" => $result)); $mysqli->close(); } function saveUserProfile($array, $userId)