$$('.form-to-option-service').on('click', function(){
app.dialog.confirm('Применить изменения?', function () {
var i = 0,
yourArray_service = [],
item_option = {};
item_option['id'] = id_service;
$$('#option-service-form').find('input, textarea, select').each(function() {
item_option[this.name] = this.value;
i++;
});
yourArray_service.push(item_option);
app.request({
url: url_link + 'option-service.php',
dataType: 'json',
data: JSON.stringify(yourArray_service),
method: "POST",
success: function(response2) {
if(response2['json'] == 'error'){
app.dialog.alert('Такой задачи нету', 'Ошибка');
}else{
home_load();
return false;
}
},
error: function(){
app.dialog.alert('Повторите попытку позже.', 'Ошибка при отправке');
}
});
});
});$dbh = $db->prepare("SELECT *, `c`.`a_nas` + IFNULL(`s`.`sum`, 0)
FROM (
SELECT *, `c`.`a_user_index`, `a_user_idx`, SUM(`a_count`) AS `sum`
FROM `t_stash04`
GROUP BY `a_user_idx`
) AS `s`
RIGHT JOIN `t_characters` AS `c`
ON `c`.`a_user_index` = `s`.`a_user_idx`
");
$dbh->execute();
while ($count_char_array = $dbh->fetch()) {
echo $count_char_array['a_nas'];
}