| 1 | <?php |
|---|
| 2 | if (!defined('_DIR_PLUGIN_AGENDA')){ // definie automatiquement en 1.9.2 |
|---|
| 3 | $p=explode(basename(_DIR_PLUGINS)."/",str_replace('\\','/',realpath(dirname(__FILE__)))); |
|---|
| 4 | define('_DIR_PLUGIN_AGENDA',(_DIR_PLUGINS.end($p))); |
|---|
| 5 | } |
|---|
| 6 | include_spip('base/agenda_evenements'); |
|---|
| 7 | |
|---|
| 8 | function cron_agenda_nettoyer_base($t){ |
|---|
| 9 | # les evenements lies a un article inexistant |
|---|
| 10 | $res = spip_query("SELECT evenements.id_evenement,evenements.id_article |
|---|
| 11 | FROM spip_evenements AS evenements |
|---|
| 12 | LEFT JOIN spip_articles AS articles |
|---|
| 13 | ON evenements.id_article=articles.id_article |
|---|
| 14 | WHERE articles.id_article IS NULL"); |
|---|
| 15 | while ($row = spip_fetch_array($res,SPIP_ASSOC)) |
|---|
| 16 | spip_query("DELETE FROM spip_evenements |
|---|
| 17 | WHERE id_evenement=".$row['id_evenement'] |
|---|
| 18 | ." AND id_article=".$row['id_article']); |
|---|
| 19 | |
|---|
| 20 | # les liens de mots affectes a des evenements effaces |
|---|
| 21 | $res = spip_query("SELECT mots_evenements.id_mot,mots_evenements.id_evenement |
|---|
| 22 | FROM spip_mots_evenements AS mots_evenements |
|---|
| 23 | LEFT JOIN spip_evenements AS evenements |
|---|
| 24 | ON mots_evenements.id_evenement=evenements.id_evenement |
|---|
| 25 | WHERE evenements.id_evenement IS NULL"); |
|---|
| 26 | |
|---|
| 27 | while ($row = spip_fetch_array($res,SPIP_ASSOC)) |
|---|
| 28 | spip_query("DELETE FROM spip_mots_evenements |
|---|
| 29 | WHERE id_mot=".$row['id_mot'] |
|---|
| 30 | ." AND id_evenement=".$row['id_evenement']); |
|---|
| 31 | |
|---|
| 32 | return 1; |
|---|
| 33 | } |
|---|
| 34 | |
|---|
| 35 | function Agenda_taches_generales_cron($taches_generales){ |
|---|
| 36 | $taches_generales['agenda_nettoyer_base'] = 3600*48; |
|---|
| 37 | return $taches_generales; |
|---|
| 38 | } |
|---|
| 39 | |
|---|
| 40 | function exec_calendrier() |
|---|
| 41 | { |
|---|
| 42 | $mode = _request('mode'); |
|---|
| 43 | if ($mode=='editorial'){ |
|---|
| 44 | include_spip('exec/calendrier'); |
|---|
| 45 | global $type, $css; |
|---|
| 46 | // icones standards, fonction de la direction de la langue |
|---|
| 47 | |
|---|
| 48 | global $bleu, $vert, $jaune, $spip_lang_rtl; |
|---|
| 49 | $bleu = http_img_pack("m_envoi_bleu$spip_lang_rtl.gif", 'B', "class='calendrier-icone'"); |
|---|
| 50 | $vert = http_img_pack("m_envoi$spip_lang_rtl.gif", 'V', "class='calendrier-icone'"); |
|---|
| 51 | $jaune= http_img_pack("m_envoi_jaune$spip_lang_rtl.gif", 'J', "class='calendrier-icone'"); |
|---|
| 52 | |
|---|
| 53 | $date = date("Y-m-d", time()); |
|---|
| 54 | if ($type == 'semaine') { |
|---|
| 55 | |
|---|
| 56 | $GLOBALS['afficher_bandeau_calendrier_semaine'] = true; |
|---|
| 57 | $titre = _T('titre_page_calendrier', |
|---|
| 58 | array('nom_mois' => nom_mois($date), 'annee' => annee($date))); |
|---|
| 59 | } |
|---|
| 60 | elseif ($type == 'jour') { |
|---|
| 61 | $titre = nom_jour($date)." ". affdate_jourcourt($date); |
|---|
| 62 | } |
|---|
| 63 | else { |
|---|
| 64 | $titre = _T('titre_page_calendrier', |
|---|
| 65 | array('nom_mois' => nom_mois($date), 'annee' => annee($date))); |
|---|
| 66 | } |
|---|
| 67 | |
|---|
| 68 | debut_page($titre, "redacteurs", "calendrier","",$css); |
|---|
| 69 | barre_onglets("calendrier", "editorial"); |
|---|
| 70 | echo "<div> </div>" ; |
|---|
| 71 | echo http_calendrier_init('', $type, '','',generer_url_ecrire('calendrier', 'mode=editorial'.($type ? "&type=$type" : ''))); |
|---|
| 72 | |
|---|
| 73 | fin_page(); |
|---|
| 74 | } |
|---|
| 75 | else{ |
|---|
| 76 | $var_f = charger_fonction('agenda_evenements'); |
|---|
| 77 | $var_f(); |
|---|
| 78 | } |
|---|
| 79 | } |
|---|
| 80 | ?> |
|---|
