<?php
/*
Copyright (c) PORTANEO.
This file is part of POSH (Portaneo Open Source Homepage) http://sourceforge.net/projects/posh/.
POSH is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version
POSH is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Posh. If not, see <http://www.gnu.org/licenses/>.
*/
# !! be careful, this file must be saved under uft8 format, and display an e accentuated here : é
$index_getNbOfModules = "
SELECT count(id) AS nb
FROM dir_item
WHERE status = 'O' ";
$index_getNbOfModulesToValidate = "
SELECT count(*) AS nb
FROM temp_dir_item,temp_dir_cat_item
WHERE id = item_id
AND status = 'N' ";
$index_getNbOfUsers = "SELECT count(*) AS nb FROM users WHERE typ = 'I'";
$index_getPagesName = "SELECT name,id FROM pages WHERE group_id=0 ORDER BY seq";
$index_getNbOfPortals = "SELECT count(*) AS nb FROM portals WHERE status = 'O'";
$index_getNbOfPortalsToValidate = "SELECT count(id) AS nb FROM portals,portals_category WHERE status = 'N' AND id=portal_id ";
$tabs_getTabs = "SELECT id,name,label,type,param FROM adm_tabs ORDER BY id";
$communication_getConfig = "SELECT parameter,value FROM adm_config ";
$communication_sentEmails = "SELECT id,UNIX_TIMESTAMP(sentdate) AS date,subject,sender,receiver FROM contact_sentitems WHERE status='S' ORDER BY sentdate DESC ";
$communication_sentEmailDetail = "SELECT UNIX_TIMESTAMP(sentdate) AS date,subject,message,sender,receiver FROM contact_sentitems WHERE id=%u ";
$admin_getTabFunctions = "SELECT label,description,link FROM adm_tabs_fct WHERE tabname=%s ";
$plugin_getPluginList = "
SELECT name, forced
FROM adm_plugins
WHERE status='O'
ORDER BY name ";
$config_getParameters = "
SELECT parameter,value,datatype,desttype,category,editable
FROM adm_config
ORDER BY category";
$configfeatures_getHeadLinks = "SELECT id,uniq_id,type,label,comment,clss,images,fct,status,seq,anonymous,connected,admin FROM adm_headlinks ORDER BY seq ASC ";
$configfeatures_getParameters = "SELECT parameter,value FROM adm_config ";
$configtheme_getThemes = "SELECT name FROM adm_themes ORDER BY seq ASC ";
$module_getMainDirectory = "SELECT id,name,seq,lang FROM dir_category,dir_cat_properties WHERE parent_id=0 AND category_id=id ORDER BY seq ";
$portals_getPortalsList = " SELECT portals.name,portals.description,portals.status,category_id,dir_category.name AS name2 FROM portals,portals_category,dir_category
WHERE portals.id=portal_id AND dir_category.id=category_id AND portals.id=%u ";
$portals_getModules = "
SELECT id,
name
FROM portals_module, dir_item
WHERE item_id = id
AND portal_id = %u ";
$module_getTempCategory = "
SELECT a.id,a.name
FROM dir_category AS a
INNER JOIN temp_dir_cat_item AS b
on a.id = b.category_id
WHERE b.item_id=%u
ORDER BY first DESC
";
$module_getModulesToValidate = "SELECT tdi.id,name,tdi.url,tdi.defvar,
u.username,u.long_name,
tdi.description,tdi.height,tdi.keywords,
tdi.minwidth,tdi.sizable,
tdi.format,tdi.website,tdi.nbvariables,
tdi.autorefresh,tdi.lang,
tdi.l10n,tdi.views,tdi.logo
FROM
temp_dir_item tdi,
users u
WHERE
tdi.id=%u
AND tdi.status='N'
AND tdi.editor_id=u.id ";
$module_getCategory = "
SELECT a.id,a.name
FROM dir_category AS a
INNER JOIN dir_cat_item AS b
ON a.id = b.category_id
WHERE b.item_id = %u
ORDER BY first DESC
";
$module_getModule = "
SELECT id,
name,
url,
defvar,
description,
typ,
status,
height,
minwidth,
sizable,
format,
website,
nbvariables,
autorefresh,
icon
FROM dir_item
WHERE id = %u ";
$module_getKeywords = "SELECT id, label, weight FROM search_index, search_keyword WHERE kw_id=id AND item_id=%u ORDER BY weight DESC,label ";
$users_groupNumber = "SELECT count(*) FROM users_group WHERE parent_id=%u ";
$users_getUsersNumber = "SELECT count(*) FROM users_group_map WHERE group_id=%u ";
$users_deleteGroup = "DELETE FROM users_group WHERE id=%u ";
$users_getGroupName = "SELECT name FROM users_group WHERE id=%u ";
$isGroupName = "SELECT id FROM users_group WHERE parent_id=%u AND name=%s";
$module_getSubCategoryNumber = "SELECT count(*) FROM dir_category WHERE parent_id=%u ";
$module_getTempSubCatNumber = "SELECT count(*) FROM dir_cat_item WHERE category_id=%u ";
$module_getParentDirectory = "SELECT parent_id,lang FROM dir_category WHERE id=%u ";
$module_removeDirectory = "DELETE FROM dir_category WHERE id=%u ";
$module_getDirectoryType = "SELECT typ,lang FROM dir_category WHERE id=%u ";
$module_getCategoryName = "
SELECT name,lang
FROM dir_category
WHERE id = %u
";
$users_getUserInformation = "
SELECT username,
email,
long_name,
typ,
lang,
expiration_date,
creation_date,
lastconnect_date
FROM users
WHERE id = %u
";
$users_getUserGroup = "SELECT id, name FROM users_group, users_group_map WHERE id=group_id AND user_id=%u ";
$cachewaiting_getModules = "SELECT dir_item.id, dir_item.name FROM dir_item, dir_cat_item, dir_category
WHERE dir_item.typ<>'A' AND status='O' AND dir_item.id=item_id AND dir_category.id=category_id AND secured=0 AND first='Y' ORDER BY creation_date DESC, dir_item.id DESC LIMIT 0,6 ";
$pages_getPagesList ="SELECT
name,
description,position,type,
param,nbcol,showtype,npnb,style,
modulealign,controls,icon,removable,
showwidgetbar
FROM
pages
WHERE id=%u ";
$pages_getModules = "SELECT item_id,
posx,
posy,
posj,
x,
y,
variables,
uniq,
height,
name,
minwidth,
sizable,
url,
format,
website,
nbvariables,
blocked,
minimized,
dir_item.usereader,
dir_item.autorefresh,
dir_item.views,
dir_item.icon,
dir_item.l10n
FROM
pages_module,
dir_item
WHERE
item_id=dir_item.id
AND page_id=%u ";
$pages_selectMainGroups = "
SELECT id,
name
FROM users_group
ORDER BY name";
$pages_getTabsList = " SELECT pages.id,name,description,ref_pages_mode.label AS mode,ref_pages_type.label AS type,param,seq FROM pages,ref_pages_mode,ref_pages_type
WHERE ref_pages_mode.id=pages.position AND ref_pages_type.id=type AND group_id=%u ORDER BY seq ";
$communication_setBarType = "UPDATE adm_config SET value=%s WHERE parameter='bartype' ";
$communcation_insertBarType = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('bartype',%s,'int','A') ";
$admin_setLang = "UPDATE users SET lang=%s WHERE id=%u ";
$configfeatures_deleteHeadLinks = "DELETE FROM adm_headlinks ";
$configfeatures_insertHeadLinks = "INSERT INTO adm_headlinks (id,uniq_id,type,label,comment,clss,images,fct,status,seq,anonymous,connected,admin) VALUES (%u,%s,%s,%s,%s,%s,%s,%s,'O',%u,%u,%u,%u) ";
$configfeatures_setUseReader = "UPDATE adm_config SET value=%s WHERE parameter='usereader' ";
$configfeatures_insertUseReader = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('usereader',%s,'int','J') ";
$configfeatures_setShowTabIcon = 'UPDATE adm_config SET value=%s WHERE parameter="showtabicon" ';
$configfeatures_insertShowTabIcon = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('showtabicon',%s,'int','J') ";
$configfeatures_setColumnChange = "UPDATE adm_config SET value=%s WHERE parameter='columnchange' ";
$configfeatures_insertColumChange = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('columnchange',%s,'int','J') ";
$configfeatures_setCtrlHiding = "UPDATE adm_config SET value=%s WHERE parameter='ctrlhiding' ";
$configfeatures_insertCtrlHiding = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('ctrlhiding',%s,'int','J') ";
$configfeatures_setDoubleProtection = "UPDATE adm_config SET value=%s WHERE parameter='doubleprotection' ";
$configfeatures_insertDoubleProtection = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('doubleprotection',%s,'int','J') ";
$configfeatures_setShowRssCell = "UPDATE adm_config SET value=%s WHERE parameter='showrsscell' ";
$configfeatures_insertShowRssCell = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('showrsscell',%s,'int','J') ";
$configfeatures_setShowModuleSearch = "UPDATE adm_config SET value=%s WHERE parameter='showModuleSearch' ";
$configfeatures_insertShowModuleSearch = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('showModuleSearch',%s,'int','J') ";
$configfeatures_setShowModuleExpl = "UPDATE adm_config SET value=%s WHERE parameter='showModuleExpl' ";
$configfeatures_insertShowModuleExpl = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('showModuleExpl',%s,'int','J') ";
$cachegeneration_setZeroQuantity = "
UPDATE dir_category
SET quantity = 0,
secured_quantity = 0
";
$cachegeneration_removeTempDirectories = "
DELETE FROM temp_category
";
$cachegeneration_5thDirectoryLevel = "
INSERT INTO temp_category (category_id, quantity, gener1, gener2, gener3, gener4, pass, secured)
SELECT category_id, count(*), cat2.id, cat3.id, cat4.id, cat5.id, '1', cat1.secured
FROM dir_item, dir_cat_item, dir_category as cat1, dir_category as cat2, dir_category as cat3, dir_category as cat4, dir_category as cat5
WHERE cat1.id=category_id AND cat2.id=cat1.parent_id AND cat3.id=cat2.parent_id AND cat4.id=cat3.parent_id AND cat5.id=cat4.parent_id AND cat5.parent_id=0
AND dir_item.id=dir_cat_item.item_id AND dir_item.status = 'O'
GROUP BY category_id, cat2.id, cat3.id, cat4.id, cat5.id, cat1.secured";
$cachegeneration_4thDirectoryLevel = "
INSERT INTO temp_category (category_id, quantity, gener1, gener2, gener3, gener4, pass, secured)
SELECT category_id, count(*), cat2.id, cat3.id, cat4.id, 0 as id5, '1', cat1.secured
FROM dir_item, dir_cat_item, dir_category as cat1, dir_category as cat2, dir_category as cat3, dir_category as cat4
WHERE cat1.id=category_id AND cat2.id=cat1.parent_id AND cat3.id=cat2.parent_id AND cat4.id=cat3.parent_id AND cat4.parent_id=0
AND dir_item.id=dir_cat_item.item_id AND dir_item.status='O'
GROUP BY category_id, cat2.id, cat3.id, cat4.id, id5, cat1.secured ";
$cachegeneration_3rdDirectoryLevel = "
INSERT INTO temp_category (category_id, quantity, gener1, gener2, gener3, gener4, pass, secured)
SELECT category_id, count(*), cat2.id, cat3.id, 0 as id4, 0 as id5, '1', cat1.secured
FROM dir_item, dir_cat_item, dir_category as cat1, dir_category as cat2, dir_category as cat3
WHERE cat1.id=category_id AND cat2.id=cat1.parent_id AND cat3.id=cat2.parent_id AND cat3.parent_id=0
AND dir_item.id=dir_cat_item.item_id AND dir_item.status='O'
GROUP BY category_id, cat2.id, cat3.id, id4, id5, cat1.secured ";
$cachegeneration_2ndDirectoryLevel = "
INSERT INTO temp_category (category_id, quantity, gener1, gener2, gener3, gener4, pass, secured)
SELECT category_id, count(*), cat2.id, 0 as id3, 0 as id4, 0 as id5, '1', cat1.secured
FROM dir_item, dir_cat_item, dir_category as cat1, dir_category as cat2
WHERE cat1.id=category_id AND cat2.id=cat1.parent_id AND cat2.parent_id=0
AND dir_item.id=dir_cat_item.item_id AND dir_item.status='O'
GROUP BY category_id, cat2.id, id3, id4, id5, cat1.secured";
$cachegeneration_1stDirectoryLevel = "
INSERT INTO temp_category (category_id, quantity, gener1, gener2, gener3, gener4, pass, secured)
SELECT category_id, count(*), 0 as id2, 0 as id3, 0 as id4, 0 as id5, '1', cat1.secured
FROM dir_item, dir_cat_item, dir_category as cat1
WHERE cat1.id=category_id AND cat1.parent_id=0
AND dir_item.id=dir_cat_item.item_id AND dir_item.status='O' AND dir_item.hidden=0
GROUP BY category_id, id2, id3, id4, id5, cat1.secured";
$cachegeneration_mystery1stLevel = "
INSERT INTO temp_category (category_id, quantity, pass, secured)
SELECT gener1, sum(quantity), '2', secured
FROM temp_category
WHERE gener1 > 0
GROUP BY gener1, secured ";
$cachegeneration_mystery2ndLevel = "
INSERT INTO temp_category (category_id, quantity, pass, secured)
SELECT gener2, sum(quantity), '2', secured
FROM temp_category
WHERE gener2 > 0
GROUP BY gener2, secured ";
$cachegeneration_mystery3rdLevel = "
INSERT INTO temp_category (category_id, quantity, pass, secured)
SELECT gener3, sum(quantity), '2', secured
FROM temp_category
WHERE gener3 > 0
GROUP BY gener3, secured";
$cachegeneration_mystery4thLevel = "
INSERT INTO temp_category (category_id, quantity, pass, secured)
SELECT gener4, sum(quantity), '2', secured
FROM temp_category
WHERE gener4 > 0
GROUP BY gener4, secured";
$cachegeneration_mystery5thLevel = "
INSERT INTO temp_category (category_id, quantity, pass, secured)
SELECT category_id, sum(quantity), '3', secured
FROM temp_category
GROUP BY category_id, secured";
$cachegeneration_updateTempCat = "
UPDATE dir_category, temp_category
SET dir_category.quantity = temp_category.quantity
WHERE dir_category.id = temp_category.category_id
AND pass = '3'
AND temp_category.secured = 0";
$cachegeneration_updateTempCatSecured = "
UPDATE dir_category, temp_category
SET dir_category.secured_quantity = temp_category.quantity
WHERE dir_category.id = temp_category.category_id
AND pass = '3'
AND temp_category.secured = 1";
//$cachegeneration_getDirectoryId = "SELECT id,lang FROM dir_category,dir_cat_properties WHERE dir_category.id=dir_cat_properties.category_id ";
$cachegeneration_getDirectoryId = "SELECT id,lang,parent_id FROM dir_category WHERE secured=0 ";
$cachegeneration_getModuleId = "SELECT dir_item.id FROM dir_item, dir_cat_item, dir_category WHERE dir_item.id=item_id AND dir_category.id=category_id AND secured=0 ";
$cachegeneration_getPortalsId = "SELECT id FROM portals, portals_category WHERE id=portal_id ";
$cachegeneration_getPagesId = "SELECT id FROM pages WHERE position IN (1,3) ORDER BY seq LIMIT 1 ";
$cachegeneration_getPersonalizedPages = "SELECT id FROM pages WHERE type=1 ";
$cacheupdate_getModuleNumber = "SELECT count(id) AS nb FROM dir_item, dir_cat_item WHERE status='O' and id=item_id AND typ<>'A' AND first='Y' AND lang='fr' ";
$communication_getUsersList = "
SELECT username, email
FROM users
WHERE typ = 'I'
";
$communication_addSentItem = "INSERT INTO contact_sentitems (sender,subject,message,receiver,sentdate,status) VALUES (%s,%s,%s,%s,CURRENT_DATE,'S') ";
$communication_setRssInfo = "UPDATE adm_config SET value=%s WHERE parameter='rssinfo' ";
$communication_insertRssInfo = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('rssinfo',%s,'str','J') ";
$communication_setInfoBar = "UPDATE adm_config SET value=%s WHERE parameter='barclosing' ";
$communication_insertInfoBar = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('barclosing',%s,'int','J') ";
$communication_setBarTextHtml = "UPDATE adm_config SET value=%s WHERE parameter='bartexthtml' ";
$communication_insertBarTextHtml = "INSERT INTO adm_config
(parameter,value,datatype,desttype)
VALUES
('bartexthtml',%s,'str','J') ";
$users_removeUser = "
DELETE FROM users
WHERE id=%u
";
$config_setLocalfolder = "UPDATE adm_config SET value=%s WHERE parameter='LOCALFOLDER' ";
$config_insertLocalfolder = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('LOCALFOLDER',%s,'str','P') ";
$config_setNotificationemail = "UPDATE adm_config SET value=%s WHERE parameter='NOTIFICATIONEMAIL' ";
$config_insertNotificationemail = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('NOTIFICATIONEMAIL',%s,'str','P') ";
$configgenerate_getParameters = "SELECT parameter,value,datatype,desttype FROM adm_config ";
$configgenerate_getHeadLinks = "
SELECT id,
uniq_id,
type,
label,
comment,
clss,
images,
fct,
anonymous,
connected,
admin,
seq,
position
FROM adm_headlinks
WHERE status='O'
ORDER BY seq ";
$configgenerate_getHeadLink = "SELECT label,comment,clss,images,fct,anonymous,connected,admin FROM adm_headlinks WHERE status='O' AND id=%u AND seq>0 ORDER BY seq ";
$plugin_removePlugin = 'DELETE FROM adm_plugins WHERE name=%s ';
$plugin_addNewPlugin = "INSERT INTO adm_plugins (name,link,dependency) VALUES (%s,%s,%s) ";
$plugin_getPlugins = "SELECT link FROM adm_plugins WHERE status='O' ";
$configtheme_removeAll = 'DELETE FROM adm_themes ';
$configtheme_addNewTheme = 'INSERT INTO adm_themes (name,seq) VALUES(%s,%u) ';
$configtheme_deleteTheme = 'DELETE FROM adm_themes WHERE id=%u ';
$configtheme_updateConfigVariable='
UPDATE adm_config
SET value="%s"
WHERE parameter="themeList"
';
$configtheme_insertConfigVariable = '
INSERT INTO adm_config (parameter,value,datatype,desttype)
VALUES ("themeList","%s","arr","J")
';
$configtheme_updateDefTheme = "UPDATE adm_config SET value=%s WHERE parameter='theme' ";
$configtheme_insertDefTheme = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('theme',%s,'str','J') ";
$module_addNewDirectory = "INSERT INTO dir_category (name,parent_id,typ,lang,secured) VALUES (%s,%u,%s,%s,%u) ";
$module_updateDirectory = 'UPDATE dir_category SET name=%s,secured=%u WHERE id=%u ';
$module_getDirectoryParent = "SELECT parent_id,lang FROM dir_category where id=%u ";
$module_moveDirectory = "UPDATE dir_category SET parent_id=%u WHERE id=%u ";
$users_addGroup = "INSERT INTO users_group (name,parent_id) VALUES (%s,%u) ";
$module_updateGroupName = "UPDATE users_group SET name=%s WHERE id=%u ";
$users_getGroupParent = "SELECT parent_id FROM users_group where id=%u ";
$users_moveGroup = 'UPDATE users_group SET parent_id=%u WHERE id=%u ';
$module_getbyUrl = "SELECT id FROM dir_item WHERE url like %s";
$module_updateremove = "UPDATE dir_item set status='S' , typ='E' WHERE id=%u";
$module_updateModule = "UPDATE
dir_item
SET
url = %s,
defvar = %s,
name = %s,
description = %s,
typ = %s,
status = %s,
height = %u,
minwidth = %u,
sizable = %u,
website = %s,
lastmodif_date = CURRENT_DATE,
updated = 'Y',
views = %s,
hidden = %s
WHERE id = %u ";
//$module_updateModuleDirectory = "UPDATE dir_cat_item SET category_id=%u WHERE item_id=%u AND first='Y' ";
$module_removeKeywords = "DELETE FROM search_index WHERE item_id=%u ";
$module_getKeyword = "SELECT id FROM search_keyword WHERE label_simplified=%s";
$module_addKeyword = "INSERT INTO search_keyword (label,label_simplified) VALUES (%s,%s) ";
$module_addModuleKeyword = "INSERT INTO search_index (kw_id, item_id, weight) VALUES (%u,%u,%u) ";
$module_getTempModule = "SELECT
format,temp_dir_item.typ,
defvar,sizable,logo,username AS edemail,
keyword, temp_dir_item.lang,
temp_dir_item.l10n,temp_dir_item.views
FROM
temp_dir_item,
users
WHERE
temp_dir_item.id=%u
AND editor_id=users.id ";
$module_validateModule = "INSERT INTO
dir_item
(url, name, description, defvar,
typ, status, height, format, minwidth,
sizable, website, editor_id, nbvariables,
creation_date, lastmodif_date, lang, usereader,
autorefresh, views, l10n, hidden)
SELECT %s, %s, %s,%s,
typ, 'O', %u, format, %u,
sizable, %s, editor_id, nbvariables,
creation_date, CURRENT_DATE, lang,
usereader, autorefresh, views, l10n, %s
FROM
temp_dir_item
WHERE id=%u ";
$module_updateSource = "UPDATE dir_item_external
SET
item_id = %u,
url=%s,
status=%s
WHERE item_id = %u
";
$module_getSource = "SELECT source,xmlmodule,url,view,type
FROM dir_item_external
WHERE
item_id=%u";
$module_removeTempModule = "DELETE FROM temp_dir_item WHERE id=%u ";
$module_addDirectoryTempModule = "
INSERT INTO dir_cat_item (
item_id,
category_id,
first)
SELECT %u,
category_id,
'N'
FROM temp_dir_cat_item
WHERE item_id = %u
AND first='N' ";
$module_addModuleSubDirectory = "
INSERT into dir_cat_item (item_id, category_id, first)
VALUES (%u,%u, %s)
";
$module_addDirectoryModule = "INSERT into dir_cat_item (item_id, category_id, first) VALUES (%u,%u,'N')";
$module_removeTempDirectory = "
DELETE FROM temp_dir_cat_item
WHERE item_id = %u
";
$module_addRedactorFeed = "INSERT INTO redactor_map_item_feed (item_id,item_url,feed_id) VALUES (%u,'',%u) ";
$module_getValidationKeyword = "SELECT id FROM search_keyword WHERE label_simplified=%s ";
$module_addValidationKeyword = "INSERT INTO search_keyword (label,label_simplified) VALUES (%s,%s) ";
$module_addValidationModuleKeyword = "INSERT INTO search_index (kw_id, item_id, weight) VALUES (%u,%u,%u) ";
$module_removeValidationModule = "UPDATE temp_dir_item SET status='C' WHERE id=%u ";
$pages_getSequence = "SELECT seq FROM pages WHERE id=%u ";
$pages_moveNextSeqLeft = "UPDATE pages SET seq=seq-1 WHERE seq>%u ";
$pages_moveNextSeqRight = "UPDATE pages SET seq=seq+1 WHERE seq>=%u ";
$pages_updateSeq = "UPDATE pages SET seq=%u WHERE id=%u ";
$pages_getPagesId = "SELECT id FROM pages WHERE position IN (1,3) AND group_id=0 ORDER BY seq LIMIT 1 ";
//$oages_getPersonalizedPageId = "SELECT id FROM pages WHERE type=1 AND position=1";
$oages_getPersonalizedPageId = "SELECT id,position FROM pages WHERE type=1";
$pages_getPageSequence = "SELECT seq FROM pages WHERE id=%u ";
$pages_updatePageSeqForGroup = "UPDATE pages SET seq=seq-1 WHERE seq>%u AND group_id=%u ";
$pages_removePage = "DELETE FROM pages WHERE id=%u ";
$rootdirectory_addDirectory = "INSERT INTO dir_category (name,parent_id,typ,quantity,updated,lang) VALUES (%s,0,'O',0,'Y',%s) ";
$rootdirectory_addProperties = "INSERT INTO dir_cat_properties (category_id,seq) VALUES (%u,%u) ";
$rootdirectory_updateSeq = "UPDATE dir_cat_properties SET seq=%s WHERE category_id=%u AND seq=%s ";
$rootdirectory_updateName = "UPDATE dir_category SET name=%s,lang=%s WHERE id=%u ";
$rootdirectory_getDirectory = "SELECT id,name,seq,lang FROM dir_category,dir_cat_properties WHERE parent_id=0 AND category_id=id ORDER BY seq ";
$rootdirectory_getDimension = "UPDATE adm_config SET value=%s WHERE parameter='dimension' ";
$rootdirectory_insertDimension = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('dimension',%s,'arr','J') ";
$pages_setProperties = '
UPDATE pages
SET name=%s,
description=%s,
position=%u,
type=%u,
param=%s,
icon=%s,
WHERE id=%u ';
$pages_getMaxSeq = 'SELECT (MAX(seq)+1) AS nseq FROM pages WHERE group_id=%u ';
$pages_addNew = "INSERT INTO pages (group_id,name,description,position,type,param,seq,icon,removable) VALUES (%u,%s,%s,%u,%u,%s,%u,%s,%u) ";
$pages_updateSubProperties = "
UPDATE pages
SET nbcol=%u,
showtype=%u,
npnb=%u,
style=%u,
modulealign=%s,
controls=%s,
showwidgetbar=%s
WHERE id=%u ";
$pages_removeModules = "DELETE FROM pages_module WHERE page_id=%u ";
$pages_addModules = "INSERT INTO pages_module
(item_id,page_id,posx,
posy,posj,x,y,variables,
uniq,blocked,minimized)
VALUES
(%u,%u,%u,
%u,%u,%u,%u,%s,
%u,%u,%u) ";
$portal_update = "UPDATE portals SET name=%s,description=%s,status=%s WHERE id=%u ";
$portal_updateDirectory = "UPDATE portals_category SET category_id=%u WHERE portal_id=%u ";
$rootdirectory_removeProperties = "DELETE FROM dir_cat_properties WHERE category_id=%u AND seq=%u ";
$rootdirectory_updateProperties = "UPDATE dir_cat_properties SET seq=CONV(seq,10,10)-1 WHERE seq>%u ";
$users_addNew = "
INSERT INTO users (
username,
email,
pass,
long_name,
typ,
expiration_date,
creation_date,
lastconnect_date,
md5pass,
md5user,lang
)
VALUES (
%s,
%s,
'',
%s,
%s,
%u,
CURRENT_DATE,
CURRENT_DATE,
MD5(%s),
%s,
%s)
";
$users_logUserAdd = "
INSERT INTO log (
action,
pubdate,
param1
)
VALUES (
3,
CURRENT_DATE,
%u
)
";
$users_updateWithPass = "
UPDATE users
SET username = %s,
email = %s,
long_name = %s,
typ = %s ,
pass = '',
md5pass = MD5(%s),
md5user = %s,
lang = %s,
expiration_date = %u
WHERE id = %u
";
$users_updateWithoutPass = "
UPDATE users
SET username = %s,
email = %s,
long_name = %s,
typ = %s,
lang = %s,
expiration_date = %u
WHERE id = %u ";
$user_removeFromGroup = "DELETE FROM users_group_map WHERE user_id=%u ";
$users_addInGroup = "INSERT INTO users_group_map (user_id,group_id) VALUES (%u,%u) ";
$users_updatePassword = "UPDATE users SET md5pass=%s WHERE id=%u ";
$temcache_getLastModules = "SELECT id, name, description FROM dir_item WHERE lang='fr' ORDER BY id DESC LIMIT 0,10 ";
$stats_computeNbOfUsers = "INSERT INTO stats_final (action,treatdate,result1)
SELECT action,pubdate,count(param1) FROM log WHERE action=3 AND pubdate!=CURRENT_DATE GROUP BY action,pubdate ";
$stats_computeOpenings = "INSERT INTO stats_final (action,treatdate,result1)
SELECT action,pubdate,count(param1) FROM log WHERE action=2 AND pubdate!=CURRENT_DATE GROUP BY action,pubdate ";
$stats_computeVisitors = "INSERT INTO stats_final (action,treatdate,result1)
SELECT 6,pubdate,count(distinct param1) FROM log WHERE action=2 AND pubdate!=CURRENT_DATE GROUP BY pubdate ";
$stats_removeOld = "DELETE FROM log WHERE (action!=4 AND pubdate!=CURRENT_DATE) OR (action=4 AND MONTH(pubdate)!=MONTH(CURRENT_DATE)) ";
$stats_getDailyVisitors = "SELECT DAYOFMONTH(treatdate) AS absc,result1 AS ord FROM stats_final WHERE action=6 AND MONTH(treatdate)=%s ORDER BY absc ";
$stats_getMonthlyVisitors = "SELECT MONTH(treatdate) as absc, sum(result1) AS ord FROM stats_final WHERE action=8 AND YEAR(treatdate)=%s GROUP BY absc ORDER BY absc ";
$stats_getDailyNewUsers = "SELECT DAYOFMONTH(treatdate) AS absc,result1 as ord FROM stats_final WHERE action=3 AND MONTH(treatdate)=%s ORDER BY treatdate ";
$stats_getMonthlyNewUsers = "SELECT MONTH(treatdate) as absc, sum(result1) AS ord FROM stats_final WHERE action=3 AND YEAR(treatdate)=%s GROUP BY absc ORDER BY absc ";
$stats_getDailyOpenings = "SELECT DAYOFMONTH(treatdate) AS absc,result1 AS ord FROM stats_final WHERE action=2 AND MONTH(treatdate)=%s ORDER BY absc ";
$stats_getMonthlyOpenings = "SELECT MONTH(treatdate) as absc,sum(result1) AS ord FROM stats_final WHERE action=2 AND YEAR(treatdate)=%s GROUP BY absc ORDER BY absc ";
//$widnotes_newNote = "INSERT INTO users_notes (user_id, notes) VALUES (0,%s) ";
//$widnotes_updateNote = 'UPDATE users_notes SET notes=%s WHERE id=%u ';
//$widtask_removeTask = "DELETE FROM users_tasks WHERE task_id=%s ";
//$widtask_addId = 'INSERT INTO users_tasks_id (status) VALUES("A") ';
//$widtask_addTask = "INSERT INTO users_tasks (id,comments,name) VALUES (%u,%s,%s) ";
//$widtask_changeStatus = "UPDATE users_tasks SET done=%s WHERE task_id=%u ";
//$widlink_removeLink = "DELETE FROM users_favorites WHERE link_id=%u ";
//$widlink_addId = 'INSERT INTO users_favorites_id (status) VALUES("A") ';
//$widlink_addLink = "INSERT INTO users_favorites (id,name,url) VALUES (%u,%s,%s) ";
//$widcal_remove = "DELETE FROM users_calendar WHERE cal_id=%u ";
//$widcal_addId = 'INSERT INTO users_calendar_id (status) VALUES("A") ';
//$widcal_addEvent = "INSERT INTO users_calendar (id,title,comments,pubdate,time,endtime) VALUES (%u,%s,%s,%s,%s,%s) ";
//$widcal_getEvent = "SELECT cal_id, title, comments, time, endtime FROM users_calendar WHERE id=%u AND pubdate=%s ORDER BY time ";
//$widcal_getMonthEvents = "SELECT cal_id, DAYOFMONTH(pubdate) as day, title, time, endtime FROM users_calendar WHERE id=%u AND MONTH(pubdate)=%s AND YEAR(pubdate)=%s ORDER BY pubdate,time ";
$users_getAllXml = "
SELECT id,username,long_name,typ
FROM users
ORDER BY long_name ASC,username ASC
LIMIT %u,21 ";
$module_searchModule = "SELECT dir_item.id, SUM(weight) AS wei, name, dir_item.icon FROM search_index, search_keyword, dir_item
WHERE dir_item.id=item_id AND search_keyword.id=kw_id AND label_simplified IN (%s)
GROUP BY item_id ORDER BY wei DESC,notation DESC LIMIT %u,21 ";
$module_getAllValidXml = "SELECT id, name, status, icon FROM dir_item
WHERE status!='S' ORDER BY name ASC, id DESC LIMIT %u,21 ";
$cache_getAllModuleXml = "SELECT id, name, ROUND(notation/20) AS nota, substring(description,1,80) AS descr FROM dir_item
WHERE typ<>'A' AND status='O' ORDER BY creation_date DESC, id DESC LIMIT %u,7 ";
$cache_getModule = "
SELECT c.url
, c.name
, c.description
, c.defvar
, c.height
, c.minwidth
, c.sizable
, c.format
, c.website
, ROUND(c.notation/20) AS nota
, c.nbvariables
, c.usereader
, c.autorefresh
, c.editor_id
, d.long_name
, c.creation_date
, c.views
, c.icon
FROM dir_cat_item AS a
, dir_category AS b
, dir_item AS c
LEFT JOIN users AS d
ON d.id=c.editor_id
AND d.typ!='A'
WHERE c.id=%u
AND c.id=a.item_id
AND b.id=a.category_id
AND b.secured=0
ORDER BY name
";
$cache_getRssModule = "
SELECT a.url
, a.name
, a.description
, a.defvar
, a.height
, a.minwidth
, a.sizable
, a.format
, a.website
, ROUND(a.notation/20) AS nota
, a.nbvariables
, a.usereader
, a.autorefresh
, a.editor_id
, b.long_name
, a.creation_date
FROM dir_item AS a
LEFT JOIN users AS b
ON b.id=a.editor_id
WHERE a.id=86
ORDER BY a.name
";
$cache_getPortal = "SELECT name,description,status,author,nbcol,style,position,modulealign FROM portals WHERE id=%u ";
$cache_getPortalModules = "SELECT item_id,name,posx,posy,posj,x,y,variables,height,website,minwidth,sizable,url,format,nbvariables,blocked,minimized,usereader,autorefresh FROM portals_module,dir_item WHERE portal_id=%u AND item_id=id ORDER BY posx,posy,posj ";
$cache_getChildrenDirectory = "SELECT id, name FROM dir_category WHERE parent_id = %u AND secured=0 ORDER BY name ";
$cache_getPortalInformation = "SELECT id, name FROM portals_category,portals WHERE id = portal_id AND category_id = %u AND status = 'O' ";
$module_getChildrenDirectoryXml = "
SELECT id,
name,
quantity + secured_quantity AS quantity,
secured
FROM dir_category
WHERE parent_id = %u
ORDER BY name ";
$module_getModuleOfDirectoryXml = "SELECT id, name FROM dir_cat_item, dir_item WHERE id = item_id AND category_id = %u AND status = 'O' ORDER BY sorting ";
$users_getGroupXml = "SELECT name FROM users_group WHERE id IN (%s)";
$users_getChildrenGroupsXml = "SELECT id, name FROM users_group WHERE parent_id = %u and id IN (%s) ORDER BY name ";
$users_getUsersOfGroupXml = "SELECT id, username, long_name, typ FROM users_group_map, users WHERE id = user_id AND group_id = %u AND typ in ('I','A') ORDER BY long_name ASC, username ASC ";
$pagegeneration_getPage = "
SELECT name, type, param, seq, nbcol, showtype,
npnb, style, modulealign, position, controls,
showwidgetbar, template
FROM pages
WHERE id = %u ";
$pagegeneration_getPageModules = "
SELECT posx,
posy,
posj,
x,
y,
height,
item_id,
website,
name,
variables,
minwidth,
sizable,
url,
uniq,
format,
nbvariables,
blocked,
minimized,
usereader,
autorefresh,
dir_item.views,
dir_item.l10n,
dir_item.icon
FROM pages_module,
dir_item
WHERE page_id=%u
AND dir_item.id=item_id
ORDER BY uniq ";
$users_searchXml = "SELECT id,username,long_name,typ FROM users
WHERE typ in ('I','A') AND (username like %s OR long_name like %s)
ORDER BY long_name, username LIMIT %u,21 ";
$pages_getConnectedTabs = "
SELECT id, name, type, param, seq, icon, template
FROM pages
WHERE group_id = 0
AND position IN (2,3)
ORDER BY seq ";
$pages_getAnonymousTabs = "SELECT id,name,type,param,seq,icon FROM pages WHERE group_id=0 AND position IN (1,3) ORDER BY seq ";
$module_toValidateXml = "SELECT id, name, status, logo FROM temp_dir_item,temp_dir_cat_item WHERE id=item_id AND status='N' ORDER BY name ASC, id DESC LIMIT %u,21 ";
$module_getNbXml ="SELECT count(*) AS nb FROM dir_item WHERE status = 'O'";
$module_getNbToValidateXml ="SELECT count(*) AS nb
FROM temp_dir_item,temp_dir_cat_item
WHERE id=item_id
AND status = 'N'";
$cache_getDirectoryInformation = "
SELECT id,
parent_id,
name,
quantity,
lang
FROM dir_category
WHERE id=%u
AND secured=0
";
$cache_getRootDirectoryChildren = "
SELECT id,
name,
quantity,
secured,
secured_quantity,
lang
FROM dir_category,
dir_cat_properties
WHERE parent_id = %u
AND id = category_id
AND secured = 0 ORDER BY seq ASC
";
$cache_getDirectoryChildren = "
SELECT id,
name,
quantity,
lang,
secured,
secured_quantity
FROM dir_category
WHERE parent_id = %u
ORDER BY name ";
$module_getModuleInformationXml = "
SELECT id,
icon,
name,
first,
ROUND(notation/20) AS nota
FROM dir_cat_item,
dir_item
WHERE id = item_id
AND category_id = %u
AND status = 'O'
ORDER BY sorting,name ";
$refreshcache_setModuleAsUpdated = "UPDATE dir_item SET updated='Y' WHERE id=%u ";
$refreshcache_getLang = "
SELECT lang,
secured
FROM dir_category
WHERE id = %u ";
$refreshcache_getModuleNbInDir = "
SELECT count(item_id)
FROM dir_cat_item,dir_item
WHERE category_id = %u
AND id = item_id
AND status = 'O'
AND hidden = 0 ";
$refreshcache_getSubDirNb = "
SELECT sum(quantity),
sum(secured_quantity)
FROM dir_category
WHERE parent_id = %u";
$refreshcache_setQuantity = "
UPDATE dir_category
SET quantity = %u,
secured_quantity = %u,
updated = 'Y'
WHERE id = %u ";
$refreshcache_getParentDirectory = "SELECT parent_id FROM dir_category WHERE id=%u ";
$refreshcache_setDirectoryAsUpdated = "UPDATE dir_category SET updated='Y' WHERE id=%u ";
$refreshcache_getPortalLang = "SELECT lang FROM %u WHERE id=%u ";
$refreshcache_getParentId = "SELECT parent_id FROM %u WHERE id=%u ";
$config_saveParamValue = "
UPDATE adm_config
SET value = %s
WHERE parameter = %s
AND editable = 1";
$stats_computeVisitorsMonth = "INSERT INTO stats_final (action,treatdate,result1)
SELECT 8,CONCAT(YEAR(pubdate),'-',MONTH(pubdate),'-01'),count(distinct param1) FROM log WHERE action=4 GROUP BY MONTH(pubdate) ";
$stats_computeArchiveForMonth = "INSERT INTO log (action,pubdate,param1,param2,param3) SELECT '4',pubdate,param1,param2,param3 FROM log WHERE action=2 ";
$configfeatures_setModuleAlign = "UPDATE adm_config SET value=%s WHERE parameter='moduleAlign' ";
$configfeatures_insertModuleAlign = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('moduleAlign',%s,'int','J') ";
$scr_modulevalidateall_getItems = "
SELECT a.id,
a.url,
a.name,
a.description,
a.height,
a.minwidth,
a.sizable,
a.website,
b.category_id,
a.typ,
a.format,
a.defvar,
a.lang,
a.keywords ,
c.username ,
c.email,
a.views,
a.l10n,
a.logo,
a.id_dir_item
FROM temp_dir_item AS a,
temp_dir_cat_item AS b,
users AS c
WHERE a.id=b.item_id
AND a.editor_id=c.id
AND a.status='N'
";
$directory_addGroup = "INSERT INTO users_group_category_map (group_id,category_id) VALUES (%u,%u)";
$directory_getDirGroups = "SELECT id,name FROM users_group,users_group_category_map WHERE group_id=id AND category_id=%u ";
$directory_removeGroups = "DELETE FROM users_group_category_map WHERE category_id=%u ";
$users_removeFromGroups = "
DELETE FROM users_group_map
WHERE user_id = %u
";
$logMaintenance = "INSERT INTO adm_log(log,logdate,typ) VALUES ('maintenance done !',CURRENT_DATE,'A') ";
$config_getTemplate = "SELECT value FROM adm_config WHERE parameter='template' ";
$config_setTemplate = "UPDATE adm_config SET value=%s WHERE parameter='template'";
$config_deleteTemplate = "DELETE FROM adm_config where template=%s ";
$scr_moduleDuplicate="
INSERT INTO dir_item (url,defvar,name,description,
typ,status,format,height,minwidth,sizable,website,
editor_id,nbvariables,creation_date,lastmodif_date,
notation,voter_nb,updated,nbusers,sorting,lang,usereader,
autorefresh,views,l10n,hidden,group_access)
SELECT url,defvar,CONCAT(name,' (2)'),description,
typ,status,format,height,minwidth,sizable,website,
editor_id,nbvariables,creation_date,lastmodif_date,
notation,voter_nb,updated,nbusers,sorting,lang,usereader,
autorefresh,views,l10n,hidden,group_access
FROM dir_item
WHERE id = %u";
$module_getModuleDirectory="
SELECT category_id
FROM dir_cat_item
WHERE item_id = %u
";
$module_addModuleDirectory = "
INSERT INTO dir_cat_item (item_id,category_id,first)
VALUES (%u,%u,%s)";
$module_setNewUrl = "UPDATE dir_item SET url=%s WHERE id=%u";
$users_updatePortalsLanguage = "UPDATE profile SET lang=%s WHERE user_id=%u";
$config_setValue = "UPDATE adm_config SET value=%s WHERE parameter=%s ";
$config_getNotification = "SELECT id,lang,subject,message,sender,copy FROM adm_mail WHERE lang in(%s,'en') AND libelle='%s' ";
$config_setNotification = "UPDATE adm_mail SET subject=%s, message=%s, sender=%s, copy=%s WHERE id=%u";
$config_setNewNotification = "INSERT INTO adm_mail SET subject=%s, message=%s, sender=%s, copy=%s, lang=%s,libelle=%s";
$config_getNotificationTitles = "SELECT DISTINCT(libelle) FROM adm_mail";
$applications_getApplications = "SELECT id,title,icon,action FROM applications ORDER BY title LIMIT %u,21";
$users_deleteTabs= "
DELETE FROM profile
WHERE user_id = %u
";
$users_deleteModules= "
DELETE FROM module
WHERE user_id = %u
";
//$users_deleteProfileModules= "DELETE FROM module WHERE profile_id = %u ";
$applications_getApplicationInformation = "SELECT title, description FROM applications WHERE id=%u";
$application_updateInfo = "UPDATE applications SET title=%s,description=%s WHERE id=%u";
$application_addGroup = "INSERT INTO applications_groups_map (application_id,group_id) VALUES (%u,%u)";
$application_getSelGroups = "SELECT a.id,a.name FROM users_group AS a,applications_groups_map AS b WHERE b.group_id=a.id AND b.application_id=%u ";
$application_removeGroups = "DELETE FROM applications_groups_map WHERE application_id=%u";
$config_setParam = "
UPDATE adm_config
SET value = %s
WHERE parameter = %s
AND editable = 1";
$config_insertParam = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES (%s,%s,%s,%s) ";
$users_removeUserInfos = "
DELETE FROM users_info
WHERE user_id=%u
";
$users_addUserInfos = "INSERT INTO users_info (user_id,info_id,parameters,ispublic) VALUES (%u,%u,%s,'1') ";
$users_updateUserInfos = "UPDATE users_info SET parameters=%s WHERE user_id=%u AND info_id=%u ";
$config_updatePagePermission = "UPDATE adm_config SET value=%s WHERE parameter='addPagePermission' ";
$config_insertaddPagePermission = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('addPagePermission',%s,'int','J') ";
$criteria_getUserCriterias = "
SELECT id,
label,
type,
options,
mandatory,
parameters
FROM adm_userinfo,
users_info
WHERE adm_userinfo.id = users_info.info_id
AND users_info.user_id=%u
";
$criteria_getInformations="SELECT id,label,type,options,mandatory,editable FROM adm_userinfo";
$user_addUserInformations="INSERT INTO adm_userinfo (label,type,options,mandatory,editable,public) VALUES (%s,%u,%s,%u,%u,'0')";
$user_getUserInformations="SELECT id,label,type,options,mandatory,editable,displayon FROM adm_userinfo VALUES (%s,%s,%s,%u,%u,%u)";
$users_userscriteria_delete="DELETE FROM users_info WHERE info_id=%u";
$users_criteria_delete="DELETE FROM adm_userinfo WHERE id=%u";
$user_updateUserInformations="UPDATE adm_userinfo SET label=%s,mandatory=%u,editable=%u WHERE id=%u";
$config_setDisplayrssdesc = "UPDATE adm_config SET value=%s WHERE parameter='displayrssdesc' ";
$config_insertDisplayrssdesc = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('displayrssdesc',%s,'int','J') ";
$config_setDisplayrsssource = "UPDATE adm_config SET value=%s WHERE parameter='displayrsssource' ";
$config_insertDisplayrsssource = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('displayrsssource',%s,'int','J') ";
$config_setDisplayrssimages = "UPDATE adm_config SET value=%s WHERE parameter='displayrssimages' ";
$config_insertDisplayrssimages = "INSERT INTO adm_config (parameter,value,datatype,desttype) VALUES ('displayrssimages',%s,'int','J') ";
$users_getId = "SELECT DISTINCT id FROM users ";
$users_getProfileId= "
SELECT id
FROM profile
WHERE page_id = %u
";
$users_getUserProfilesId= "SELECT id FROM profile WHERE page_id=%u AND user_id=%u";
$users_getPublicAndGroupPages= "
SELECT id,
name,
nbcol,
controls,
showtype,
style,
seq,
icon,
modulealign,
type,
param,
removable,
showwidgetbar
FROM pages
WHERE group_id = %u
AND position IN (1,3)
";
$users_getPages = "SELECT id FROM pages,users_group_map WHERE pages.group_id = users_group_map.group_id AND user_id=%u ";
$users_deleteToUpdateTabs= "
DELETE FROM profile
WHERE page_id = %u
AND user_id = %u
";
$users_deleteGroupProfiles= "DELETE FROM profile WHERE id=%u AND user_id=%u";
$user_addProfilePages = "
INSERT INTO profile (
user_id,
name,
width,
style,
creation_date,
modif_date,
controls,
showtype,
seq,
icon,
modulealign,
type,
param,
page_id,
removable,
showwidgetbar
)
VALUES (
%u,
%s,
%u,
%u,
CURRENT_DATE,
CURRENT_DATE,
%s,
%s,
%u,
%s,
%s,
%s,
%s,
%u,
%u,
%u
)
";
$profile_addPage = "
INSERT INTO profile (
user_id,name,width,height,
style,creation_date,modif_date,
controls,showtype,seq,icon,modulealign,
type,param,page_id,status,removable,
showwidgetbar, template)
SELECT user_id, %s, %u, 5,
%u, CURRENT_DATE, CURRENT_DATE,
%s, %u, (MAX(seq)+1), %s, %s,
%u, %s, %u, %u, %u,
%u, %u
FROM profile
WHERE user_id IN (%s)
GROUP BY user_id";
$profile_updatePage = "
UPDATE profile
SET name=%s,
width=%u,
style=%u,
modif_date=CURRENT_DATE,
controls=%s,
showtype=%u,
icon=%s,
modulealign=%s,
type=%u,
param=%s,
status=1,
removable=%u,
showwidgetbar=%u,
template = %u
WHERE page_id=%u ";
$profile_updatePageid = "UPDATE profile SET page_id=%u WHERE page_id=%u";
$modules_addNewMod = "
INSERT INTO module (item_id,user_id,profile_id,posx,posy,
posj,x,y,typ,variables,
uniq,blocked,minimized)
SELECT %u,p.user_id,p.id,%u,%u,
%u,%u,%u,'D',%s,
%u,%u,%u
FROM profile AS p
WHERE p.user_id = %u
AND p.page_id = %u";
$page_getPagesModule = "SELECT item_id,page_id,posx,posy,posj,x,y,variables,uniq,blocked,minimized FROM pages_module WHERE page_id=%u ";
$tabs_getAdminTabs = "SELECT id,name,label,type,param FROM adm_tabs,adm_tabs_map WHERE adm_tabs.id=adm_tabs_map.tab_id AND user_id=%u ORDER BY id";
$tabs_getUpdateAdminTabs = "SELECT tab_id FROM adm_tabs_map WHERE user_id=%u";
$users_removeFromTabs = "
DELETE FROM adm_tabs_map
WHERE user_id=%u
";
$users_addAdmTabMap = "INSERT INTO adm_tabs_map (user_id,tab_id) VALUES (%u,%u)";
$users_deleteAdmTabMap = "
DELETE FROM adm_tabs_map
WHERE user_id = %u
";
$users_getExistingPublicPages = "SELECT id FROM profile WHERE user_id=%u AND page_id=%u ";
$users_getExistingUserGroup = "SELECT group_id FROM users_group_map WHERE group_id=%u AND user_id=%u ";
$configgenerate_newRand = "UPDATE adm_config SET value='%s' WHERE parameter='rand'";
$tabs_access_control = "SELECT id FROM adm_tabs_map atm,adm_tabs at WHERE atm.tab_id=at.id AND user_id=%u AND name=%s";
$users_activateAdmin="
UPDATE users
SET typ='A'
WHERE id=%u
AND typ='B'";
$users_activateUser="
UPDATE users
SET typ='I'
WHERE id=%u
AND typ='J'";
$users_inactivateAdmin="
UPDATE users
SET typ='B'
WHERE id=%u
AND typ='A'";
$users_inactivateUser="
UPDATE users
SET typ='J'
WHERE id=%u
AND typ='I'";
$users_controlExistingAccount="
SELECT count(id) as nb
FROM users
WHERE username = %s ";
$pages_getUserPageSequence="
SELECT seq
FROM profile
WHERE page_id=%u
AND user_id=%u";
$scr_moduleDuplicateCategory="
INSERT INTO dir_cat_item (item_id,category_id,first)
VALUES(%u,%u,%s) ";
$module_getModuleCategory="
SELECT category_id,first
FROM dir_cat_item
WHERE item_id=%u";
$getNbMessages="
SELECT DISTINCT(label)
FROM translation";
$getAllMessages="
SELECT label,lang,message,typefile,usage_label
FROM translation
WHERE lang=%s
ORDER BY usage_label";
$getAllLanguages="
SELECT DISTINCT lang
FROM translation";
$users_deleteProfileModules= "DELETE m
FROM module AS m
INNER JOIN profile AS p WHERE m.profile_id = p.id
AND p.page_id = %u ";
$admin_getSubTabs = "SELECT tabname,fctname,label,description
FROM adm_tabs_fct
ORDER BY tabname ASC";
$pages_getGroupPages = "
SELECT id
FROM pages
WHERE group_id = %u
";
$users_getCriteriasParameters = "SELECT info_id,parameters FROM users_info WHERE user_id=%u";
$users_getSpecificCriteria = "SELECT parameters FROM users_info WHERE user_id=%u AND info_id=%u";
$admin_addInGroupMap = "INSERT INTO adm_group_map (user_id,group_id) VALUES (%u,%u) ";
$adm_getGroupId = "
SELECT group_id
FROM adm_group_map
WHERE user_id = %u";
$adm_getUserIdByGroup = "
SELECT DISTINCT id,username,long_name,typ
FROM users u,
users_group_map ugm
WHERE u.id=ugm.user_id
AND ugm.group_id IN (%s)
ORDER BY long_name ASC, username ASC
LIMIT %u,21 ";
$admin_getUserGroup = "
SELECT DISTINCT user_id,
group_id
FROM adm_group_map
WHERE user_id = %u
";
$adm_getGroupNameByIdGroup = "SELECT ug.id,ug.name FROM users_group ug WHERE ug.id IN (%s)";
$users_getAllGroupXml = "SELECT name FROM users_group WHERE id = %u ";
$users_getChildrenAllGroupsXml = "SELECT id, name FROM users_group WHERE parent_id = %u ORDER BY name ";
//$users_getNbXml ="SELECT count(*) AS nb FROM users WHERE typ in ('I','A','R')";
$users_getNbXml ="SELECT count(DISTINCT user_id) AS nb FROM users_group_map WHERE group_id in (%s)";
$users_getAllNbXml ="SELECT count(*) AS nb FROM users WHERE typ in ('I','A','R')";
$admin_removeFromGroup = "DELETE FROM adm_group_map WHERE user_id=%u";
$adm_userIdSubGroup = "
SELECT DISTINCT id,
parent_id
FROM users_group u
WHERE u.parent_id IN(%s)";
$adm_getUserIdById = "SELECT id,username,long_name,typ FROM users u WHERE u.id IN (%s)";
$pages_selectAdminGroups = "
SELECT id,
name
FROM users_group
WHERE id IN (%s)
ORDER BY name";
$pages_getAdminTabsList = "
SELECT pages.id,name,description,ref_pages_mode.label AS mode,ref_pages_type.label AS type,param,seq
FROM pages,ref_pages_mode,ref_pages_type
WHERE ref_pages_mode.id=pages.position AND ref_pages_type.id=type AND group_id IN (%s) ORDER BY seq ";
$module_getChildrenAdminDirectoryXml = "
SELECT id,
name,
quantity + secured_quantity AS quantity,
secured
FROM dir_category
WHERE id IN (%s)
AND parent_id = %u
ORDER BY name ";
$users_getGroupCategoryMapXml = "SELECT category_id FROM users_group_category_map WHERE group_id IN (%s)";
$communication_getUsersListByGroup = "
SELECT username, email
FROM users
WHERE typ = 'I'
AND id IN (%s)
";
$communication_getUsersIdByGroup = "SELECT DISTINCT user_id FROM users_group_map WHERE group_id IN (%s) ";
$index_getNbOfUsersByGroup = "SELECT count(*) AS nb FROM users WHERE typ = 'I' AND id IN (%s)";
$statsmodules_getDailyTopModules = "SELECT name,sum(result2) AS tot FROM stats_final,dir_item WHERE action=4 AND result1=id AND treatdate LIKE %s GROUP BY name ORDER BY tot DESC LIMIT 50 ";
$statsmodules_getDailyTopDirRss = "SELECT name,sum(result2) AS tot FROM stats_final,dir_item WHERE action=7 AND result1=id AND treatdate LIKE %s GROUP BY name ORDER BY tot DESC LIMIT 50 ";
$statsmodules_getDailyTopRss = "SELECT result1,sum(result2) AS tot FROM stats_final WHERE action=5 AND treatdate LIKE %s GROUP BY result1 ORDER BY tot DESC LIMIT 50 ";
$statsmodules_getMonthlyTopModules = "SELECT name,sum(result2) AS tot FROM stats_final,dir_item WHERE action=4 AND result1=id AND treatdate LIKE %s GROUP BY name ORDER BY tot DESC LIMIT 50 ";
$statsmodules_getMonthlyTopDirRss = "SELECT name,sum(result2) AS tot FROM stats_final,dir_item WHERE action=7 AND result1=id AND treatdate LIKE %s GROUP BY name ORDER BY tot DESC LIMIT 50 ";
$statsmodules_getMonthlyTopRss = "SELECT result1,sum(result2) AS tot FROM stats_final WHERE action=5 AND treatdate LIKE %s GROUP BY result1 ORDER BY tot DESC LIMIT 50 ";
$statsmodules_countModOpening = "INSERT INTO stats_final (action,treatdate,result1,result2)
SELECT 4,pubdate,param2,count(param3) FROM log,dir_item WHERE dir_item.id=param2 AND format!='R' AND action=1 AND param2!=86 AND pubdate!=CURRENT_DATE AND param2!='86' GROUP BY pubdate,param2 ";
$statsmodules_countDirRssOpening = "INSERT INTO stats_final (action,treatdate,result1,result2)
SELECT 7,pubdate,param2,count(param3) FROM log,dir_item WHERE dir_item.id=param2 AND format='R' AND action=1 AND param2!=86 AND pubdate!=CURRENT_DATE AND param2!='86' GROUP BY pubdate,param2 ";
$statsmodules_countRssOpening = "INSERT INTO stats_final (action,treatdate,result1,result2)
SELECT 5,pubdate,SUBSTRING(param3,LOCATE('rssurl',param3)+7,LOCATE('&',SUBSTRING(param3,LOCATE('rssurl',param3)))-7) AS rssurl,count(param2) FROM log WHERE action=1 AND pubdate!=CURRENT_DATE AND param2='86' GROUP BY pubdate,rssurl ";
$xml_getsupport="SELECT id,log,logdate,typ FROM adm_log ORDER BY id DESC LIMIT %u,100";
$support_deleteAllLogs="DELETE FROM adm_log";
$support_deleteOldLogs="DELETE FROM adm_log WHERE logdate < %s";
$support_deleteStats="DELETE FROM stats_final WHERE treatdate!=CURRENT_DATE";
$dir_rss_setIconId="UPDATE dir_rss SET iconid=%s WHERE iconid=%s ";
$module_deleteModuleCategory="
DELETE FROM dir_cat_item
WHERE item_id = %u
AND category_id = %u
";
$users_getMd5user="SELECT id, md5user FROM users WHERE username=%s";
$users_getuseridFromUsername="SELECT id FROM users WHERE username=%s";
$users_getuserInfoFromUsername="SELECT id,long_name,typ,lang FROM users WHERE username=%s";
$module_addDirItemExternal="INSERT INTO dir_item_external
(item_id,source,xmlmodule,url,last_updated,status,view,type)
SELECT %u,source,xmlmodule,url,CURRENT_DATE,'validated',view,type
FROM temp_dir_item_external
WHERE item_id=%u";
$dir_item_setIcon="UPDATE dir_item SET icon=%s WHERE id=%u ";
$scr_moduleUpdateIcon="UPDATE dir_item SET icon=%s WHERE id=%u";
$modules_deleteTempCat="DELETE FROM temp_dir_cat_item WHERE item_id=%u";
$modules_deleteTempDirItem="DELETE FROM temp_dir_item WHERE id=%u";
$modules_deleteTempDirItemExternal="DELETE FROM temp_dir_item_external WHERE item_id=%u";
$module_getModuleInfoOfDirectoryXml = "SELECT id, name, icon FROM dir_cat_item, dir_item WHERE id = item_id AND category_id = %u AND status = 'O' ORDER BY name ";
$cache_getModuleXml = "
SELECT c.url
, c.name
, c.description
, c.defvar
, c.height
, c.minwidth
, c.sizable
, c.format
, c.website
, ROUND(c.notation/20) AS nota
, c.nbvariables
, c.usereader
, c.autorefresh
, c.editor_id
, d.long_name
, c.creation_date
, c.icon
, c.views
, c.l10n
FROM dir_cat_item AS a
, dir_category AS b
, dir_item AS c
LEFT JOIN users AS d
ON d.id=c.editor_id
AND d.typ!='A'
WHERE c.id=%u
AND c.id=a.item_id
AND b.id=a.category_id
AND b.secured=0
ORDER BY name
";
$module_getModuleInformationByXml = "
SELECT id,
name,
first,
ROUND(notation/20) AS nota,
icon
FROM dir_item
INNER JOIN dir_cat_item ON dir_item.id = dir_cat_item.item_id
WHERE ( category_id = %u
AND status = 'O'
AND hidden = 0
)
ORDER BY sorting,name
";
$module_getTempModuleToValidate = "
SELECT format,
temp_dir_item.typ,
defvar,
sizable,
logo,
email AS edemail,
keyword,
temp_dir_item.lang,
id_dir_item,
l10n,
views
FROM temp_dir_item,
users
WHERE temp_dir_item.id = %u
AND editor_id = users.id ";
$modules_deleteDirItemExternal="DELETE FROM dir_item_external WHERE item_id=%u";
$module_updateDirItemExternal = " UPDATE dir_item_external SET source=%s, xmlmodule=%s, url=%s, view=%s, type=%s WHERE item_id=%u";
$module_getDirItemExternal = "SELECT source,xmlmodule,url,view,type FROM temp_dir_item_external WHERE item_id=%u";
$module_getAdminAllowedWidgets = "SELECT dir_item.id, dir_item.name, dir_item.status, dir_item.icon FROM dir_cat_item,adm_group_map,users_group_category_map,dir_item WHERE adm_group_map.group_id=users_group_category_map.group_id AND users_group_category_map.category_id=dir_cat_item.category_id AND dir_cat_item.item_id=dir_item.id AND dir_item.status!='S' AND adm_group_map.user_id=%u ORDER BY name ASC, id DESC LIMIT %u,21";
$module_getAdminAllowedGroupsId = "SELECT users_group_category_map.group_id FROM dir_cat_item, users_group_category_map WHERE users_group_category_map.category_id=dir_cat_item.category_id AND dir_cat_item.category_id = %u AND users_group_category_map.category_id IN (%s)";
$module_getAdminAllowedWidgetsToValidate = "SELECT temp_dir_item.id, temp_dir_item.name, temp_dir_item.status, temp_dir_item.logo
FROM
temp_dir_cat_item,
adm_group_map,
users_group_category_map,
temp_dir_item
WHERE
temp_dir_item.id=temp_dir_cat_item.item_id
AND adm_group_map.group_id=users_group_category_map.group_id
AND users_group_category_map.category_id=temp_dir_cat_item.category_id
AND temp_dir_cat_item.item_id=temp_dir_item.id
AND temp_dir_item.status='N'
AND adm_group_map.user_id=%u
ORDER BY name ASC, id
DESC LIMIT %u,21";
$module_searchModuleAllowed = "SELECT dir_item.id, SUM(weight) AS wei, name, dir_item.icon FROM search_index, search_keyword, dir_item , dir_cat_item, adm_group_map, users_group_category_map WHERE dir_item.id=search_index.item_id AND dir_item.id=dir_cat_item.item_id AND search_keyword.id=kw_id AND label_simplified IN (%s) AND adm_group_map.group_id=users_group_category_map.group_id AND users_group_category_map.category_id=dir_cat_item.category_id AND adm_group_map.user_id=%u GROUP BY dir_item.id ORDER BY wei DESC,notation DESC LIMIT %u,21 ";
$scr_modulevalidateall_getAllowedItems = "
SELECT a.id,a.url,a.name,a.description,a.height,a.minwidth,a.website,
b.category_id,
a.typ,a.format,a.defvar,a.lang,a.keywords ,
c.username , c.email,
a.views,a.logo,
a.id_dir_item
FROM temp_dir_item AS a,
temp_dir_cat_item AS b,
users AS c,
adm_group_map AS gmap,
users_group_category_map AS gcat
WHERE a.id=b.item_id
AND a.editor_id=c.id
AND a.status='N'
AND gmap.group_id=gcat.group_id
AND gcat.category_id=b.category_id
AND gmap.user_id=%u ";
$users_searchXmlAllowed = "SELECT DISTINCT id,username,long_name,typ
FROM users,users_group_map
WHERE users_group_map.group_id IN (%s)
AND users.id = users_group_map.user_id
AND typ in ('I','A')
AND (username like %s OR long_name like %s)
ORDER BY long_name, username LIMIT %u,21 ";
$admin_removeFromGroupByGroup = "DELETE FROM adm_group_map WHERE group=%u";
$index_getPagesNameAllowed = "SELECT name,id FROM pages,adm_group_map WHERE pages.group_id=adm_group_map.group_id AND user_id=%u";
$module_getItemId = "SELECT item_id FROM dir_item_external WHERE item_id=%u";
$modules_addTempDirItemExternalLanguage="INSERT INTO dir_item_external_language (item_id,lang,url,source,viewtype,view,last_updated)
SELECT %u,lang,url,source,viewtype,view,CURRENT_DATE
FROM temp_dir_item_external_language
WHERE item_id=%u";
$modules_deleteTempDirItemExternalLanguage="DELETE FROM temp_dir_item_external_language WHERE item_id=%u";
$modules_getDirItemExternalLanguage="SELECT
lang,source,viewtype,view
FROM dir_item_external_language
WHERE
item_id=%u";
$module_getModuleAndView = "
SELECT id,
name,
url,
defvar,
description,
typ,
status,
height,
minwidth,
sizable,
format,
website,
nbvariables,
autorefresh,
icon,
views,
hidden
FROM dir_item
WHERE id = %u ";
$scr_moduleDuplicateExternal="INSERT INTO dir_item_external SELECT %u,source,xmlmodule,url,CURRENT_DATE,'validated',view,type FROM dir_item_external WHERE item_id=%u";
$scr_moduleDuplicateExternalLanguage="INSERT INTO dir_item_external_language SELECT %u,lang,url,source,params,viewtype,view,CURRENT_DATE FROM dir_item_external_language WHERE item_id=%u";
$users_deleteToUpdateTabsByPageId= "
DELETE FROM profile
WHERE page_id = %u";
$xml_getCategories = "SELECT id, name, lang FROM dir_category ORDER BY name";
$api_checkurl = "SELECT id, url FROM dir_rss WHERE url LIKE %s";
$api_insertDirRss = "INSERT INTO dir_rss(url,title,iconid)VALUES(%s,%s,%s)";
$api_insertDirItem = "INSERT INTO dir_item
(url,defvar,name,description,typ,status,format,height,minwidth,sizable,website,editor_id,nbvariables,updated,sorting,lang,usereader,autorefresh,icon)
VALUES(%s,%s,%s,%s,%s,%s,%s,%u,%u,%s,%s,%u,%u,%s,%u,%s,%u,%u,%s)";
$api_updateStatusDirItem = "UPDATE dir_item SET status=%s WHERE defvar LIKE %s ";
$api_updateDirItem = "UPDATE
dir_item
SET
name=%s,
status=%s,
icon=%s,
defvar=%s
WHERE id=%u ";
$api_insertInCategory = "INSERT INTO dir_cat_item(item_id,category_id,first)VALUES(%u,%u,%s)";
$api_addValidationModuleKeyword = "INSERT INTO search_index (kw_id, item_id, weight) VALUES (%u,%u,%u) ";
$api_addValidationKeyword = "INSERT INTO search_keyword (label,label_simplified) VALUES (%s,%s) ";
$api_updateValidationKeyword = "UPDATE search_keyword
INNER JOIN search_index
INNER JOIN dir_item
SET search_keyword.label=%s, search_keyword.label_simplified=%s
WHERE
search_keyword.id=search_index.kw_id AND
search_index.item_id=(SELECT id FROM dir_item
WHERE defvar LIKE %s)";
$pages_getPagesInfos ="SELECT
id,group_id,name,
description,position,type,
param,nbcol,showtype,npnb,style,
modulealign,controls,icon,removable,
showwidgetbar
FROM
pages
WHERE name=%s
AND group_id=%u
";
$api_updateInCategory = "UPDATE dir_cat_item SET category_id=%u WHERE item_id=%u";
$api_getKeyword = "SELECT label FROM search_keyword sk, search_index si WHERE sk.id=si.kw_id AND si.item_id=%u";
$api_getItemRssId = "SELECT id FROM dir_item WHERE defvar LIKE %s";
$api_getItemIframeId = "SELECT id FROM dir_item WHERE url = %s";
$module_getLastModulesToValidate = "SELECT tdi.id,name,long_name,tdi.creation_date
FROM temp_dir_item AS tdi, users
WHERE status='N'
AND editor_id=users.id
ORDER BY id DESC";
$admin_updateModeTag = "UPDATE adm_config SET value=%s WHERE parameter='restrictOnExistingTags'";
$admin_deleteTagInSearch_keywords = "DELETE FROM search_keyword WHERE id=%u";
$admin_deleteTagInNetwork_keywords = "DELETE FROM network_keywords WHERE kw_id=%u";
$admin_deleteTagInSearch_index = "DELETE FROM search_index WHERE kw_id=%u";
$admin_deleteTagInUsers_articles_keywords = "DELETE FROM users_articles_keywords WHERE kw_id=%u";
$admin_deleteTagInNotebook_article_keywords = "DELETE FROM notebook_article_keywords WHERE kw_id=%u";
$admin_getTagsListOffset = "SELECT id,label,label_simplified FROM search_keyword LIMIT %u,%u";
$admin_getTagsList = "SELECT id,label,label_simplified FROM search_keyword";
$admin_updateTagName = "UPDATE search_keyword SET label=%s,label_simplified=%s WHERE id=%u";
$admin_updateTagInNetwork_keywords = "UPDATE network_keywords SET kw_id=%u WHERE kw_id=%u";
$admin_updateTagInSearch_index = "UPDATE search_index SET kw_id=%u WHERE kw_id=%u";
$admin_updateTagInUsers_articles_keywords = "UPDATE users_articles_keywords SET kw_id=%u WHERE kw_id=%u";
$admin_updateTagInNotebook_article_keywords = "UPDATE notebook_article_keywords SET kw_id=%u WHERE kw_id=%u";
$admin_getUsersNotesSharedmd5key = "SELECT shared FROM users_notes WHERE id=%u";
$email_notification = "SELECT nba.id AS IDARTICLE,
nba.title AS TITLEARTICLE,
u.long_name, u.id as USERID,
u.lang,
u.username,
u.email,
COUNT( nbc.id ) AS NBCOMMENTS
FROM notebook_article nba
INNER JOIN notebook_article_users nbau on nba.id=nbau.article_id
INNER JOIN users u on nbau.user_id = u.id
INNER JOIN notebook_comments nbc on nbc.article_id = nba.id
WHERE
nbc.status = 'O'
AND nbc.pubdate BETWEEN '%s' AND '%s'
GROUP BY nba.id
ORDER BY u.username
";
$email_notification_comment = "SELECT message FROM notebook_comments WHERE article_id=%u";
$users_getUserPages = "
SELECT pr.id,
pr.name,
pa.id AS pageid
FROM profile AS pr
LEFT JOIN pages AS pa
ON pr.page_id = pa.id
WHERE pr.user_id = %u
ORDER BY pr.seq
";
$users_getUserWidgets = "
SELECT di.name
FROM module AS m
INNER JOIN dir_item AS di
ON m.item_id = di.id
WHERE profile_id = %u
";
$users_removePage = "
DELETE FROM profile
WHERE id = %u
";
$users_removePageModule = "
DELETE FROM module
WHERE profile_id = %u
";
$user_backToDefaultPage_removeWidgets = "
INSERT INTO module (item_id,user_id,profile_id,posx,posy,
posj,x,y,typ,variables,
uniq,blocked,minimized,feed_id)
SELECT item_id,%u,%u,posx,posy,
posj,x,y,'D',variables,
uniq,blocked,minimized,0
FROM pages_module
WHERE page_id = %u
";
$pages_update = " UPDATE pages
SET group_id=%u,
name=%s,
description=%s ,
position=%u ,
type=%u,
param=%s,
icon=%s,
removable=%u
WHERE id=%u";
$pages_getAnonymousTabInfo = "
SELECT id, name, type, param, seq, icon,removable, template
FROM pages
WHERE group_id = 0
AND position IN (1,3)
ORDER BY seq ";
$users_getExistingPageForUser = "
SELECT id
FROM profile
WHERE user_id = %u
AND page_id = %u
";
$users_getIdGroup = "
SELECT ugm.user_id
FROM users_group_map AS ugm
INNER JOIN users AS u
ON ugm.user_id = u.id
WHERE ugm.group_id = %u
";
$users_getIdSubGroup = "
SELECT ugm.user_id
FROM users_group_map AS ugm
INNER JOIN users AS u
ON ugm.user_id = u.id
INNER JOIN users_group AS ug1
ON ug1.id = ugm.group_id
WHERE ug1.parent_id = %u
";
$users_getIdSubSubGroup = "
SELECT ugm.user_id
FROM users_group_map AS ugm
INNER JOIN users AS u
ON ugm.user_id = u.id
INNER JOIN users_group AS ug1
ON ug1.id = ugm.group_id
INNER JOIN users_group AS ug2
ON ug2.id = ug1.parent_id
WHERE ug2.parent_id = %u
";
$module_getModIdByExtModId = "SELECT id FROM dir_item WHERE url LIKE %s ";
$ctrl_scriptAccess = " SELECT id
FROM adm_tabs AS at
INNER JOIN adm_tabs_map AS atm ON at.id = atm.tab_id
WHERE atm.user_id = %u
AND at.name IN (%s) ";
$adm_getActiveKey = "SELECT value FROM adm_config WHERE parameter='activkey' OR parameter='hash_public'";
$adm_getDownloadDate = "SELECT value FROM adm_config WHERE parameter='datedownload'";
$adm_getHashPublic = "SELECT value FROM adm_config WHERE parameter='hash_public'";
$adm_setActiveKey = "UPDATE adm_config SET value=%s WHERE parameter='activkey' ";
$users_getAllXmlExceptN = "
SELECT id,username,long_name,typ
FROM users
WHERE typ!='N'
ORDER BY long_name ASC,username ASC
LIMIT %u,21 ";
$pages_addNewPages = "
INSERT INTO pages (group_id, name, description, position, type,
param, seq, icon, removable, directories,
template)
VALUES (%u, %s, %s, %u, %u,
%s, %u, %s, %u, %s,
%u) ";
$pages_getPagesListAndCat ="
SELECT name, description, position, type,
param,nbcol, showtype, npnb, style,
modulealign, controls, icon, removable,
showwidgetbar, directories, template
FROM pages
WHERE id = %u ";
$pages_updatePages = "
UPDATE pages
SET group_id = %u,
name=%s,
description=%s ,
position=%u ,
type=%u,
param=%s,
icon=%s,
removable=%u,
directories=%s,
template = %u
WHERE id = %u";
$xml_getLogSupport="SELECT
adml.id, adml.log, adml.admin_id, u.username AS admin_name, adml.logdate, adml.typ
FROM adm_log AS adml
INNER JOIN users u ON adml.admin_id=u.id
ORDER BY id DESC LIMIT %u,100";
$addLogs = "INSERT INTO adm_log(admin_id,log,logdate,typ) VALUES (%u,%s,now(),'A') ";
$pages_insertNewCategory= "INSERT INTO pages_widget_category_map (dir_id,page_id) VALUES (%u,%u) ";
$pages_deleteCategory= "DELETE FROM pages_widget_category_map WHERE page_id = %u";
$module_getPagesIdByWidgetCat = "SELECT page_id FROM pages_widget_category_map WHERE dir_id=%u";
$module_getAllWidgetCatForPage = "SELECT GROUP_CONCAT( dir_id ) AS dir_id FROM pages_widget_category_map WHERE page_id = %u";
$pages_getPagesListAndCatGroupConcat ="SELECT
pages.name, pages.description, pages.position, pages.type, pages.param,
pages.nbcol, pages.showtype, pages.npnb, pages.style, pages.modulealign,
pages.controls, pages.icon, pages.removable, pages.showwidgetbar,
GROUP_CONCAT( (SELECT pwcm.dir_id FROM pages_widget_category_map WHERE pages.id=pwcm.page_id GROUP BY pwcm.dir_id) ) AS directories
FROM pages,pages_widget_category_map pwcm
WHERE pages.id=%u GROUP BY pages.id";
$pages_updatePages = " UPDATE pages
SET group_id=%u,
name=%s,
description=%s ,
position=%u ,
type=%u,
param=%s,
icon=%s,
removable=%u,
directories=%s
WHERE id=%u";
$users_addNew2 = "
INSERT INTO users (
username,
email,
pass,
long_name,
typ,
expiration_date,
creation_date,
lastconnect_date,
md5pass,
md5user,lang,password_change_date,force_user_change_password
)
VALUES (
%s,
%s,
'',
%s,
%s,
%u,
CURRENT_DATE,
CURRENT_DATE,
MD5(%s),
%s,
%s,
CURRENT_DATE,
%u)
";
$module_setUserGroupMapping = "INSERT INTO users_group_widget_map (item_id,group_id) VALUES (%u,%u)";
$module_getUserGroupMapping = " SELECT item_id,group_id,name
FROM `users_group_widget_map`
INNER JOIN users_group ON users_group_widget_map.group_id = users_group.id
WHERE item_id = %u";
$module_getUserGroupMappingGroupId = " SELECT group_id
FROM `users_group_widget_map`
WHERE item_id = %u";
$module_deleteUserGroupMapping = "DELETE FROM `users_group_widget_map` WHERE item_id = %u";
$module_deleteUserGroupMappingByGroup = "DELETE FROM `users_group_widget_map` WHERE group_id = %u";
$module_duplicateUserGroupMapping="INSERT INTO `users_group_widget_map`
SELECT %u,group_id
FROM users_group_widget_map WHERE item_id=%u";
$dir_item_setUserGroupMapping = "UPDATE dir_item SET group_access=%s WHERE id=%u";
$scr_insertPortalPass = "INSERT INTO users_password_history(user_id,md5pass,date_creating)VALUES(%u,MD5(%s),CURRENT_TIMESTAMP)";
$users_updateWithPass2 = "
UPDATE users
SET username = %s,
email = %s,
long_name = %s,
typ = %s ,
pass = '',
md5pass = MD5(%s),
md5user = %s,
lang = %s,
expiration_date = %u,
password_change_date = CURRENT_DATE,
force_user_change_password = %u
WHERE id = %u
";
$users_updateWithoutPass2 = "
UPDATE users
SET username = %s,
email = %s,
long_name = %s,
typ = %s,
lang = %s,
expiration_date = %u,
password_change_date = CURRENT_DATE,
force_user_change_password = %u
WHERE id = %u ";
$modules_addPageModules = "
INSERT INTO module (item_id,user_id,profile_id,posx,posy,
posj,x,y,typ,variables,
uniq,blocked,minimized)
SELECT %u,p.user_id,p.id,%u,%u,
%u,%u,%u,'D',%s,
%u,%u,%u
FROM profile AS p
WHERE p.user_id IN (%s)
AND p.page_id = %u";
$users_getRemovedPages = "
SELECT t.id
FROM
(SELECT u.id, p.page_id
FROM users AS u
LEFT JOIN profile AS p
ON p.user_id = u.id
AND p.page_id = %u
WHERE u.id IN (%s)
) AS t
WHERE t.page_id IS NULL
";
$users_controlExistingEmail="
SELECT email
FROM users
WHERE email = %s ";
$users_initDefaultCriteriaValue = "
INSERT INTO users_info (info_id,parameters,ispublic,user_id)
SELECT %u,%s,1,id
FROM users";
?>