actualizare user // functioneaza in parametrii normali
Cod: Selectaţi tot
function update_user_xp($user_id, $xp_ammount){
global $db;
$params = array('user_id' => $user_id);
$users = $db->rawQuery("SELECT * FROM users_xp WHERE user_id = ?", $params);
$data = array(
'user_xp_amount' => $xp_ammount + $users[0]['user_xp_amount'],
'user_id' => $user_id
);
$db->where ('user_id', $data['user_id']);
if ($db->update ('users_xp', $data)){
$xpReceived = 'You have received '.$xp_ammount.' points of experience! Have a total of '.$data['user_xp_amount'].' points of experience.';
} else {
$xpReceived = $db->getLastError();
}
return $xpReceived;
}
luare xp din db de la utilizator pe baza de id
Cod: Selectaţi tot
function get_user_xp ($user_id){
global $db;
$params = array('user_id' => $user_id);
$user = $db->rawQueryOne ('SELECT * FROM users_xp WHERE user_id=?', $params);
$xp = $user['user_xp_amount'];
return $xp;
}
//Aici codul problema si ce am incercat
Cod: Selectaţi tot
function xp_need ($user_id) {
global $db;
$userXP = get_user_xp($user_id);
$xpBarNeed = $db->rawQuery("SELECT `level`, `expneeded` FROM `experience_level`");
$output = array();
foreach($xpBarNeed as $key => $value){
for($i = 0; $i < count($value['expneeded']); $i++){
if(isset($value['expneeded'])){
var_dump($key[$i]);
}
}
}
return $output;
}
$xpuserNeed = xp_need(4);
var_dump($xpuserNeed);
Ceva sugestii??