Revize c1bdc1c4
Přidáno uživatelem Michal Kliment před více než 9 roky(ů)
application/models/variable_symbol.php | ||
---|---|---|
return $query;
|
||
}
|
||
|
||
/**
|
||
* Returns member id of given variable_symbol
|
||
*
|
||
* @param int $variable_symbol
|
||
* @return null|int
|
||
*/
|
||
public function get_member_id($variable_symbol)
|
||
{
|
||
$query = $this->db->query("
|
||
SELECT a.member_id
|
||
FROM variable_symbols vs
|
||
JOIN accounts a ON a.id = vs.account_id
|
||
WHERE vs.variable_symbol = ?
|
||
", $variable_symbol);
|
||
|
||
if ($query->count() > 0)
|
||
{
|
||
return $query->current()->member_id;
|
||
}
|
||
|
||
return NULL;
|
||
}
|
||
|
||
/**
|
||
* Returns variable symbol id of given variable_symbol
|
||
*
|
||
... | ... | |
public function get_variable_symbol_id($variable_symbol)
|
||
{
|
||
$query = $this->db->query("
|
||
SELECT id
|
||
SELECT *
|
||
FROM variable_symbols
|
||
WHERE variable_symbol = ?
|
||
", $variable_symbol);
|
Také k dispozici: Unified diff
Release 1.1.0