Revize 1228
Přidáno uživatelem Jiří Sviták před asi 13 roky(ů)
freenetis/branches/testing/redirection/index.php | ||
---|---|---|
$message_query = "
|
||
SELECT ms.id, ms.text, ms.self_cancel, ip.ip_address, ip.whitelisted, subnet_name,
|
||
mm.name AS member_name, mm.id AS member_id,
|
||
mm.variable_symbol, a.balance, mip.comment
|
||
mm.variable_symbol, a.balance, mip.comment, ip.login
|
||
FROM
|
||
(
|
||
SELECT ip.id, ip.ip_address, ip.whitelisted,
|
||
s.name AS subnet_name, IFNULL(ip.member_id,u.member_id) AS member_id
|
||
s.name AS subnet_name, IFNULL(ip.member_id,u.member_id) AS member_id, u.login
|
||
FROM
|
||
(
|
||
SELECT ip.*, IFNULL(i1.device_id,i2.device_id) AS device_id
|
||
... | ... | |
'???' AS member_id,
|
||
'???' AS balance,
|
||
'???' AS variable_symbol,
|
||
'???' AS comment
|
||
'???' AS comment,
|
||
'???' AS login
|
||
FROM messages ms
|
||
WHERE ms.type = 3";
|
||
$message_result = mysql_query($message_query, $link) or die(mysql_error());
|
Také k dispozici: Unified diff
V presmerovani pridana podpora pro tag {login}.