Esempio n. 1
0
 function delete()
 {
     if ($this->is_saved()) {
         dbkit_execute("DELETE FROM `{$this->table_name}` WHERE `id` = ?", $this->id);
         $this->delete_children();
         $this->id = null;
     }
 }
Esempio n. 2
0
<?php

include '../lib/common.inc.php';
$test_id = $_REQUEST['test_id'];
if (!Test::get("SELECT id FROM tests WHERE id=?", $test_id)) {
    error_redirect('', 'Такого теста больше нет');
}
foreach ($_REQUEST['question_order'] as $qid => $order) {
    dbkit_execute("UPDATE questions SET `order`=? WHERE test_id=? AND id=?", $order, $test_id, $qid);
}
Esempio n. 3
0
 function delete_children()
 {
     dbkit_execute("DELETE FROM answers WHERE question_id = ?", $this->id);
     dbkit_execute("DELETE FROM questions WHERE id = ?", $this->id);
 }
Esempio n. 4
0
function stat_sms_received($session_id, $test_id, $partner_id, $day, $paid, $service_earning, $partner_earning)
{
    dbkit_execute("UPDATE `sessions` SET `sms_received_at`=NOW(), `service_earning`=`service_earning`+?, `partner_earning`=`partner_earning`+? WHERE `id`=?", $service_earning, $partner_earning, $session_id);
    dbkit_execute("UPDATE `daily_statistics` SET `count_smses`=`count_smses`+1, `service_earning`=`service_earning`+?, `partner_earning`=`partner_earning`+? WHERE `day`=? AND `partner_id`=? AND `test_id`=?", $service_earning, $partner_earning, $day, $partner_id, $test_id);
}