function NewsLetter($id=null)
{
- global $globals;
-
if (isset($id)) {
if ($id == 'last') {
$res = XDB::query("SELECT MAX(id) FROM newsletter WHERE bits!='new'");
function setSent()
{
- global $globals;
XDB::execute("UPDATE newsletter SET bits='sent' WHERE id={?}", $this->_id);
}
function save()
{
- global $globals;
XDB::execute('UPDATE newsletter SET date={?},titre={?},head={?} WHERE id={?}',
- $this->_date, $this->_title, $this->_head, $this->_id);
+ $this->_date, $this->_title, $this->_head, $this->_id);
}
// }}}
function saveArticle(&$a)
{
- global $globals;
if ($a->_aid>=0) {
XDB::execute('REPLACE INTO newsletter_art (id,aid,cid,pos,title,body,append)
VALUES ({?},{?},{?},{?},{?},{?},{?})',
function delArticle($aid)
{
- global $globals;
XDB::execute('DELETE FROM newsletter_art WHERE id={?} AND aid={?}', $this->_id, $aid);
foreach ($this->_arts as $key=>$art) {
unset($this->_arts[$key]["a$aid"]);
function insert_new_nl()
{
- global $globals;
XDB::execute("INSERT INTO newsletter SET bits='new',date=NOW(),titre='to be continued'");
}
function get_nl_slist()
{
- global $globals;
$res = XDB::query("SELECT id,date,titre FROM newsletter ORDER BY date DESC");
return $res->fetchAllAssoc();
}
function get_nl_list()
{
- global $globals;
$res = XDB::query("SELECT id,date,titre FROM newsletter WHERE bits!='new' ORDER BY date DESC");
return $res->fetchAllAssoc();
}
function get_nl_state()
{
- global $globals;
- $res = XDB::query('SELECT 1 FROM newsletter_ins WHERE user_id={?}', Session::getInt('uid'));
+ $res = XDB::query('SELECT 1 FROM newsletter_ins WHERE user_id={?}', S::v('uid'));
return $res->fetchOneCell();
}
function unsubscribe_nl()
{
- global $globals;
- XDB::execute('DELETE FROM newsletter_ins WHERE user_id={?}', Session::getInt('uid'));
+ XDB::execute('DELETE FROM newsletter_ins WHERE user_id={?}', S::v('uid'));
}
function subscribe_nl($uid=-1)
{
- global $globals;
- $user = ($uid == -1) ? Session::getInt('uid') : $uid;
+ $user = ($uid == -1) ? S::v('uid') : $uid;
XDB::execute('REPLACE INTO newsletter_ins (user_id,last)
- VALUES ({?}, 0)', $user);
+ VALUES ({?}, 0)', $user);
}
function justify($text,$n)