Ejemplos de get_id_by_name en PHP

Ejemplo n.º 1

Archivo: admin.ratio-editor.php Proyecto: Karpec/gizd

        } elseif ($_POST["bytes"] == '4') {
            $uploaded = $_POST["uploaded"] * 1024 * 1024 * 1024;
            $downloaded = $_POST["downloaded"] * 1024 * 1024 * 1024;
        } elseif ($_POST["bytes"] == '5') {
            $uploaded = $_POST["uploaded"] * 1024 * 1024 * 1024 * 1024;
            $downloaded = $_POST["downloaded"] * 1024 * 1024 * 1024 * 1024;
        }
        if ($_POST["what"] == '1') {
            $result = do_sqlquery("SELECT `uploaded`, `downloaded` FROM `{$TABLE_PREFIX}users` WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
            $arr = mysqli_fetch_assoc($result);
            $uploaded = $arr["uploaded"] + $uploaded;
            $downloaded = $arr["downloaded"] + $downloaded;
            do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `uploaded` = {$uploaded}, `downloaded` = {$downloaded} WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
        } elseif ($_POST["what"] == '2') {
            $result = do_sqlquery("SELECT `uploaded`, `downloaded` FROM `{$TABLE_PREFIX}users` WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
            $arr = mysqli_fetch_assoc($result);
            $uploaded = $arr["uploaded"] - $uploaded;
            $downloaded = $arr["downloaded"] - $downloaded;
            do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `uploaded` = {$uploaded}, `downloaded` = {$downloaded} WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
        } elseif ($_POST["what"] == '3') {
            do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `uploaded` = {$uploaded}, `downloaded` = {$downloaded} WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
        }
        redirect("index.php?page=admin&user="******"uid"] . "&code=" . $CURUSER["random"] . "&do=ratio-editor&updated=yes");
    } else {
        stderr($language["ERROR"], $language["ALL_FIELDS_REQUIRED"]);
    }
} else {
    $admintpl->set("updated", $_GET["updated"] == "yes", true);
    $admintpl->set("language", $language);
    $admintpl->set("frm_action", "index.php?page=admin&user="******"uid"] . "&code=" . $CURUSER["random"] . "&do=ratio-editor&action=save");
}

Ejemplo n.º 2

Archivo: functions.php Proyecto: karkochart/Persons

function subject_marks_limit($subject, $from, $to, $pers_ides_str)
{
    if ($from || $to) {
        if ($from && $to) {
        } elseif ($from) {
            $to = 10;
        } else {
            $from = 1;
        }
        return " WHERE  Subj_ID='" . get_id_by_name("Subjects", "{$subject}") . "' and `Mark` BETWEEN '{$from}' AND '{$to}' {$pers_ides_str}";
    } else {
        return '';
    }
}

Ejemplo n.º 3

Archivo: admin.sb-editor.php Proyecto: Karpec/gizd

                $sbb = $arrdt["seedbonus"] + $sb;
                do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `seedbonus` = {$sbb} WHERE `id` = " . $arrdt["id"], true) or sqlerr(__FILE__, __LINE__);
            }
        } elseif ($_POST["what"] == '2' and $_POST["all"] == '2') {
            $result = do_sqlquery("SELECT `seedbonus`  FROM `{$TABLE_PREFIX}users` WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
            $arr = mysqli_fetch_assoc($result);
            $sbb = $arr["seedbonus"] - $sb;
            do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `seedbonus` = {$sbb} WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
        } elseif ($_POST["what"] == '2' and $_POST["all"] == '1') {
            $result = do_sqlquery("SELECT `id` , `seedbonus`  FROM `{$TABLE_PREFIX}users` WHERE `id_level` >2 ", true) or sqlerr(__FILE__, __LINE__);
            while ($arrdt = mysqli_fetch_assoc($result)) {
                $sbb = $arrdt["seedbonus"] - $sb;
                do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `seedbonus` = {$sbb} WHERE `id` = " . $arrdt["id"], true) or sqlerr(__FILE__, __LINE__);
            }
        } elseif ($_POST["what"] == '3' and $_POST["all"] == '2') {
            do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `seedbonus` = {$sb} WHERE `id` = " . get_id_by_name($username) . "", true) or sqlerr(__FILE__, __LINE__);
        } elseif ($_POST["what"] == '3' and $_POST["all"] == '1') {
            $result = do_sqlquery("SELECT `id` , `seedbonus`  FROM `{$TABLE_PREFIX}users` WHERE `id_level` >2 ", true) or sqlerr(__FILE__, __LINE__);
            while ($arrdt = mysqli_fetch_assoc($result)) {
                do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `seedbonus` = {$sb} WHERE `id` = " . $arrdt["id"], true) or sqlerr(__FILE__, __LINE__);
            }
        }
        //all
        redirect("index.php?page=admin&user="******"uid"] . "&code=" . $CURUSER["random"] . "&do=sb-editor&updated=yes");
    } else {
        stderr($language["ERROR"], $language["ALL_FIELDS_REQUIRED"]);
    }
} else {
    $admintpl->set("updated", $_GET["updated"] == "yes", true);
    $admintpl->set("language", $language);
    $admintpl->set("frm_action", "index.php?page=admin&user="******"uid"] . "&code=" . $CURUSER["random"] . "&do=sb-editor&action=save");

Ejemplo n.º 4

Archivo: add-person.php Proyecto: karkochart/Persons

<?php

$obj = new Params();
$add_person = get_form_result($obj->get());
$person_added = add_personal_date($add_person["name"], $add_person["surname"], $add_person["age"]);
if ($person_added) {
    $person_id = get_id_by_name('Personal', $add_person["name"], $add_person["surname"], $add_person["age"]);
    $subjects = get_subjects();
    foreach ($subjects as $id => $name) {
        if ($add_person['subj' . $id]) {
            add_person_mark($person_id, $id, $add_person['subj' . $id]);
        }
    }
    if ($add_person["category"]) {
        add_person_cat($person_id, get_id_by_name('Categories', $add_person["category"]));
    }
    echo "<p class='added' >Person successfuly added!</p>";
}