$(DBS)
SELECT 'admin' FROM dual
SELECT '' FROM dual
SELECT '1' FROM dual
SELECT '10' FROM dual
SELECT '1' FROM dual
SELECT '10' FROM dual
SELECT '1' FROM dual
SELECT '10' FROM dual
SELECT '1' FROM dual
SELECT '10' FROM dual
SELECT '' FROM dual
SELECT '' FROM dual
SELECT 'ASC' FROM dual
SELECT AUSERID,AFIRSTNAME,ALASTNAME,AMIDNAME,ANICKNAME,AEMAIL,AURL
FROM apooGetUserList('$uid', '$pwd') WHERE auserid >= 0;
SELECT b.BNO,b.BACTIVE,b.BNAME,b.BISSUE,b.BISSUESINT,b.BCALCRULE,
b.BCOST,b.BCOSTWORD,b.BCOSTCHAR,b.BDESC,b.BURL,b.BSYNCURL,b.BSYNCID,
b.BSYNC,b.BISRSS,b.BLANG,b.BCREATED,
case b.bsync
when '*' then '<img src="i/label.gif" width="13" height="13" />'
else '<img src="i/published.gif" width="13" height="13" />'
end bsyncimg,
'blog.htm?id=' || b.bno blocalurl
FROM bulletin b, customer2bulletin cb, customer c
WHERE cb.cbno = b.bno and cb.ccno = c.cno AND b.bactive = '*' AND b.bname LIKE('%$(s)%') AND b.bsynckind = 'B' ORDER BY b.bsync DESC, b.bname
SELECT b.BNO,b.BACTIVE,b.BNAME,b.BISSUE,b.BISSUESINT,b.BCALCRULE,b.BCOST,b.BCOSTWORD,b.BCOSTCHAR,b.BDESC,b.BURL,b.BSYNCURL,
b.BSYNCID,b.BSYNC,b.BISRSS,b.BLANG,b.BCREATED,
case b.bsync
when '*' then '<img src="i/label.gif" width="13" height="13" />'
else '<img src="i/unread.gif" width="12" height="13" />' end bsyncimg,
'blog.htm?id=' || b.bno blocalurl FROM bulletin b, customer2bulletin cb, customer c
WHERE cb.cbno = b.bno AND cb.ccno = c.cno AND b.bactive = '*' AND b.bname LIKE('%$(sf)%')
AND (b.bsynckind = 'R' OR b.bsynckind = 'F' OR b.bsynckind = 'A') ORDER BY b.bsync DESC, b.bname
SELECT m.mcreated, c.cname, m.mno, m.mmessage, s.sname, s.stitle, b.bname, b.bno, s.sno FROM msg m, section s, bulletin b,
msg2section ms, customer c WHERE s.sbno = b.bno AND ms.msectno = s.sno AND ms.mmsgno = m.mno AND c.cno = m.mcustno ORDER BY m.mcreated DESC
SELECT b.BNO, b.bname FROM bulletin b WHERE b.bactive = '*' AND b.bsynckind = 'B' ORDER BY b.bsync DESC, b.bno DESC
Блокси Управление
Синхр. все!
Синхр. все!
