  |
| Voir le sujet précédent :: Voir le sujet suivant |
| Auteur |
Message |
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
 Posté le: 20 Jan 2008, 11:39 Sujet du message: Block Info [RESOLU] |
 |
|
Bonjour,
je recherche un block ou je pourrai annoncer les projets en cours avec les liens nécéssaires.
Existe t il un block de ce genre
J ai la solution de passé par le html et l inclure dans un block, mais je prefererai passé par l admin!
Merci d avance
Zika  |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 20 Jan 2008, 12:13 Sujet du message: Re : Block Info |
|
|
Finalement je test le block NewsFlash, mais je n arrive pas a valider les News...
Affichage des erreurs: rien!
La table n est pas mise a jours, la requete s affiche dans l admin mais rien ne se passe... Quelqu un connait il se bug? La version NewsFlash est elle compatible avec ESVNuke 8.1.04?
Merci d avance
Zika |
|
|
|
| Revenir en haut de page |
|
stefvar
Administrateur
Inscrit le: Jul 06, 2005
Messages: 8268
Localisation: France Corse Ventiseri
|
| Posté le: 20 Jan 2008, 12:52 Sujet du message: Re : Block Info |
|
|
Bonjour,
Cette version n'étant pas toute jeune, vérifie que le préfixe des tables correspond bien à celui de ta base de données.
_________________
Avant de poster, lire la charte du forum, merci. |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 20 Jan 2008, 15:20 Sujet du message: Re: Re : Block Info |
|
|
| stefvar a écrit: | Bonjour,
Cette version n'étant pas toute jeune, vérifie que le préfixe des tables correspond bien à celui de ta base de données. |
re
en clair, je dois eplucher les codes pour voir si il appelle le $prefix ou nuke_ partant du principe que j ai renomé mon prefix, c est ca?  |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 20 Jan 2008, 17:22 Sujet du message: Re : Block Info |
|
|
Bon, j ai rien trouvé d anormal avec mon faible niveau de php
Je ne sais pas pourquoi cela ne fonctionne pas! 
Tanpis, si quelqu un a une idee
Zika |
|
|
|
| Revenir en haut de page |
|
Snesman
Bénévole SV
Inscrit le: Apr 30, 2006
Messages: 1862
|
| Posté le: 20 Jan 2008, 17:53 Sujet du message: Re : Block Info |
|
|
Bonjour,
Tu peux mettre le code du bloc ? |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 20 Jan 2008, 19:32 Sujet du message: Re : Block Info |
|
|
merci les gars!
Lolo, s occupe de moi!
je tacherai de poster le solution trouvée par les autres!!
voila en attendant le module original
admin/modules/
| Code: |
<?php
/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Newsflash Block */
/* =============== */
/* */
/* Copyright (c) 2003 by el Flynn <el_flynn@yahoo.com> */
/* */
/* This program 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 2 of the License. */
/* */
/************************************************************************/
/* Adapt by Stefvar */
/* http://www.stefvar.com */
/************************************************************************/
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
global $prefix, $db, $admin_file, $currentlang;
if (file_exists("admin/language/newsflash/lang-$currentlang.php")) {
include_once("admin/language/newsflash/lang-$currentlang.php");
} else {
include_once("admin/language/newsflash/lang-french.php");
}
$aid = substr("$aid", 0,25);
$row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if ($row['radminsuper'] == 1) {
function showmenu() {
global $admin_file;
OpenTable();
echo "<P><center><b>"._NEWSFLASH_ADMIN."</b><P>[ <a href=\"".$admin_file.".php?op=NF_List\">"._NEWSFLASH_LIST."</a> | <a href=\"".$admin_file.".php?op=NF_Add\">"._NEWSFLASH_ADD."</a> ]</center>";
CloseTable();
echo "<P>";
}
function ListNF($offset) {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
/* Do the "nav" bars, if applicable */
$max = 5;
$currpage = $offset;
if (! $offset) { $offset = 0; }
else { $offset = $offset * $max; }
$result = $db->sql_query("select count(*) from ".$prefix."_newsflash");
list($tot) = $db->sql_fetchrow($result);
if ($tot < $max) { $num_pages = 0; }
else { $num_pages = ($tot / $max); }
OpenTable();
echo "<B>"._NEWSFLASH_LISTING."</b>";
$sql = "select nid, title, launch_time, expires, active from ".$prefix."_newsflash order by launch_time desc limit $offset,$max";
$result = $db->sql_query($sql);
if ($db->sql_numrows($result) == 0) {
echo "<P>"._NEWSFLASH_NONEWS."";
}
else {
echo "<P><table cellpadding=5 cellspacing=0 border=1><tr><td><b>"._NEWSFLASH_TITRE."</b></td><td><b>"._NEWSFLASH_LAUNCH."</b></td><td><b>Expires".
"</b></td><td><b>"._NEWSFLASH_ACTIVE."</b></td><td><b>Action</b></td></tr>";
while(list($nid, $title, $launch, $expire, $active) = $db->sql_fetchrow($result)) {
if ($active == 1) { $active_desc = "Y"; }
else { $active_desc = "N"; }
echo "<tr><td>$title</td><td>$launch</td><td>$expire</td><td>$active_desc</td><td>[ <a href=\"".$admin_file.".php?".
"op=NF_Edit&nid=$nid\">"._NEWSFLASH_EDIT."</a> | <a href=\"".$admin_file.".php?op=NF_Delete&nid=$nid\">"._NEWSFLASH_DELETE."</a>".
" ]</td></tr>";
}
$navbar = "<tr><td colspan=4> </td></tr><tr><td colspan=4>Page: ";
for ($i = 0; $i < $num_pages; $i++) {
$navbar .= "<a href=\"".$admin_file.".php?op=NF_List&offset=$i\">";
if ($i == $currpage) { $navbar .= "<font color=red>" . ($i + 1) . "</font></a> "; }
else { $navbar .= ($i + 1) . "</a> "; }
}
$navbar .= "</td></tr>";
if ($num_pages > 1) { echo $navbar; }
echo "</table>";
}
CloseTable();
include("footer.php");
}
function AddNF() {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
OpenTable();
echo "<B>"._NEWSFLASH_ADD."</B>";
/* Print html form */
echo "<P>"._NEWSFLASH_DETAIL."<br><form action=\"".$admin_file.".php\" method=\"post\"><table cellpadding=3 cellspacing=3 border=0><tr>"
."<td>"._NEWSFLASH_TITRE.":</td><td><input name=title size=50 maxlength=150></td></tr><tr><td>"._NEWSFLASH_CONTENT.":</td><td><textarea name=content "
."cols=50 rows=10 wrap=virtual></textarea></td></tr>";
$date = getdate();
$year = $date['year'];
$month = $date['month'];
$day_now = $date['mday'];
/* Build list of days */
$day = 1;
$daylist = "";
while ($day <= 31) {
if ($day == $day_now) { $sel = "selected"; }
else { $sel = ""; }
$daylist .= "<option name=\"day\" $sel>$day</option>";
$day++;
}
/* Build month list */
$monthlist = "";
$arMonth = array( "Janvier" => 1, "Février" => 2, "Mars" => 3, "Avril" => 4, "Mai" => 5, "Juin" => 6,
"Juillet" => 7, "Août" => 8, "Septembre" => 9, "Octobre" => 10, "Novembre" => 11, "Décembre" => 12);
foreach ($arMonth as $mname => $mval) {
if ($mname == $month) { $sel = "selected"; }
else { $sel = ""; }
$monthlist .= "<option value=\"$mval\" $sel>$mname</option>";
}
/* Build hour list */
$hour = 0;
$cero = "0";
$hourlist = "";
while ($hour <= 23) {
$dummy = $hour;
if ($hour < 10) { $hour = "$cero$hour"; }
$hourlist .= "<option value=\"$hour\">$hour</option>";
$hour = $dummy;
$hour++;
}
/* Build minutes list */
$min = 0;
$minlist = "";
while ($min <= 59) {
if (($min == 0) OR ($min == 5)) { $min = "0$min"; }
$minlist .= "<option value=\"$min\">$min</option>";
$min = $min + 5;
}
/* Print out the date/time listboxes */
echo "<tr><td>"._NEWSFLASH_STARTDATE.":</td><td><select name=\"day\">$daylist</select> <select name=\"month\">$monthlist"
."</select> <input type=\"text\" name=\"year\" value=\"$year\" size=\"4\" maxlength=\"4\"></td></tr>"
."<tr><td>"._NEWSFLASH_STARTTIME.":</td><td><select name=\"hour\">$hourlist</select> : <select name=\"min\">$minlist</select> : 00"
."</td></tr><tr><td>"._NEWSFLASH_EXPIRE.":</td><td><select name=\"expires\"><option value=\"1\">"._NEWSFLASH_DAY1."</option><option value=\"2\">"._NEWSFLASH_DAY2.""
."</option><option value=\"3\">"._NEWSFLASH_DAY3."</option><option value=\"4\">"._NEWSFLASH_DAY4."</option><option value=\"5\">"._NEWSFLASH_DAY5."</option>"
."<option value=\"10\">"._NEWSFLASH_DAY10."</option><option value=\"15\">"._NEWSFLASH_DAY15."</option><option value=\"30\">"._NEWSFLASH_DAY30."</option>"
."<option value=\"0\">"._NEWSFLASH_DAYUNL."</option></select></td></tr><tr><td>"._NEWSFLASH_STATUS.":</td><td><select name=\"active\"><option "
."value=\"1\" selected>"._NEWSFLASH_ACTIVE."</option><option value=\"0\">"._NEWSFLASH_INACTIVE."</option></select></td></tr><tr><td colspan=\"2\">"
."<input type=\"submit\" value=\""._NEWSFLASH_PREVIEW."\"> <input type=\"reset\" value=\""._NEWSFLASH_RESET."\"><input type=hidden "
."name=\"op\" value=\"NF_Preview\"></table></form>";
CloseTable();
include("footer.php");
}
function PreviewNF($xtitle, $xcontent, $xday, $xmonth, $xyear, $xhour, $xmin, $xexpires, $active) {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
OpenTable();
/* Check the input */
$xtitle = stripslashes(FixQuotes($xtitle));
$xcontent = stripslashes(FixQuotes($xcontent));
$xday = stripslashes(FixQuotes($xday));
$xmonth = stripslashes(FixQuotes($xmonth));
$xyear = stripslashes(FixQuotes($xyear));
$xhour = stripslashes(FixQuotes($xhour));
$xmin = stripslashes(FixQuotes($xmin));
$xexpires = stripslashes(FixQuotes($xexpires));
echo "<center><b>"._NEWSFLASH_ADD." :: "._NEWSFLASH_PREVIEW."</b></center><P>";
/* Print preview of newsflash */
OpenTable2();
$nicedate = "$xhour:$xmin " . formatTimestamp("$xyear-$xmonth-$xday $xhour:$xmin:00");
echo "<b>"._NEWSFLASH_TITRE."</b>: $xtitle<P><b>"._NEWSFLASH_CONTENT.":</b><BR>$xcontent<P><b>"._NEWSFLASH_RELEASEDON.":</b> $nicedate<BR>";
if ($xexpires == 0) { echo "<b>"._NEWSFLASH_EXPIRENO."</b>"; }
elseif ($xexpires == 1) { echo "<b>"._NEWSFLASH_EXPIRE.":</b> "._NEWSFLASH_EXPIREAFTER1."$xexpires "._NEWSFLASH_EXPIREAFTER2.""; }
else { echo "<b>"._NEWSFLASH_EXPIRE.":</b> "._NEWSFLASH_EXPIREAFTER1."$xexpires"._NEWSFLASH_EXPIREAFTER2.""; }
CloseTable2();
/* For convenience we'll add form items where user can edit the newsflash data */
/* Print html form */
echo "<P>"._NEWSFLASH_DETAIL."<br><form action=\"".$admin_file.".php\" method=\"post\"><table cellpadding=3 cellspacing=3 border=0><tr>"
."<td>"._NEWSFLASH_TITRE.":</td><td><input name=title size=50 maxlength=150 value=\"$xtitle\"></td></tr><tr><td>"._NEWSFLASH_CONTENT.":</td><td>"
."<textarea name=content cols=50 rows=10 wrap=virtual>$xcontent</textarea></td></tr>";
$date = getdate();
$year = $date['year'];
$month = $date['month'];
$day_now = $date['mday'];
/* Build list of days */
$day = 1;
$daylist = "";
while ($day <= 31) {
if ($day == $xday) { $sel = "selected"; }
else { $sel = ""; }
$daylist .= "<option name=\"day\" $sel>$day</option>";
$day++;
}
/* Build month list */
$monthlist = "";
$arMonth = array( "Janvier" => 1, "Février" => 2, "Mars" => 3, "Avril" => 4, "Mai" => 5, "Juin" => 6,
"Juillet" => 7, "Août" => 8, "Septembre" => 9, "Octobre" => 10, "Novembre" => 11, "Décembre" => 12);
foreach ($arMonth as $mname => $mval) {
if ($mval == $xmonth) { $sel = "selected"; }
else { $sel = ""; }
$monthlist .= "<option value=\"$mval\" $sel>$mname</option>";
}
/* Build hour list */
$hour = 0;
$cero = "0";
$hourlist = "";
while ($hour <= 23) {
$dummy = $hour;
if ($hour < 10) { $hour = "$cero$hour"; }
if ($hour == $xhour) { $sel = "selected"; }
else { $sel = ""; }
$hourlist .= "<option value=\"$hour\" $sel>$hour</option>";
$hour = $dummy;
$hour++;
}
/* Build minutes list */
$min = 0;
$minlist = "";
while ($min <= 59) {
if (($min == 0) OR ($min == 5)) { $min = "0$min"; }
if ($min == $xmin) { $sel = "selected"; }
else { $sel = ""; }
$minlist .= "<option value=\"$min\" $sel>$min</option>";
$min = $min + 5;
}
/* Build the expiration list */
$explist = "";
if ($xexpires == 1) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"1\" $sel>"._NEWSFLASH_DAY1."</option>";
foreach (array(2,3,4,5) as $daynum) {
if ($daynum == $xexpires) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"$daynum\" $sel>$daynum "._NEWSFLASH_DAY."</option>";
}
if ($xexpires == 10) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"10\" $sel>"._NEWSFLASH_DAY10."</option>";
if ($xexpires == 15) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"15\" $sel>"._NEWSFLASH_DAY15."</option>";
if ($xexpires == 30) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"30\" $sel>"._NEWSFLASH_DAY30."</option>";
if ($xexpires == 0) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"0\" $sel>"._NEWSFLASH_DAYUNL."</option>";
if ($active == 0) { $activelist = "<option value=\"1\">"._NEWSFLASH_ACTIVE."</option><option value=\"0\" selected>"._NEWSFLASH_INACTIVE."</option>"; }
else { $activelist = "<option value=\"1\" selected>"._NEWSFLASH_ACTIVE."</option><option value=\"0\">"._NEWSFLASH_INACTIVE."</option>"; }
echo "<tr><td>"._NEWSFLASH_STARTDATE.":</td><td><select name=\"day\">$daylist</select> <select name=\"month\">$monthlist"
."</select> <input type=\"text\" name=\"year\" value=\"$year\" size=\"4\" maxlength=\"4\"></td></tr>"
."<tr><td>"._NEWSFLASH_STARTTIME.":</td><td><select name=\"hour\">$hourlist</select> : <select name=\"min\">$minlist</select> : 00"
."</td></tr><tr><td>"._NEWSFLASH_EXPIRE.":</td><td><select name=\"expires\">$explist</select></td></tr><tr><td>"._NEWSFLASH_STATUS.":</td><td>"
."<select name=\"active\">$activelist</select></td></tr><tr><td colspan=\"2\"><select name=\"op\"><option "
."value=\"NF_Preview\">"._NEWSFLASH_PREVIEW."</option><option value=\"NF_Post\">"._NEWSFLASH_CONFIRM."</option></select> <input type=\"submit\" "
."value=\"Go\"></table></form>";
CloseTable();
include("footer.php");
}
function PostNF($title, $content, $day, $month, $year, $hour, $min, $expires, $active) {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
/* Check the input */
$title = stripslashes(FixQuotes($title));
$content = stripslashes(FixQuotes($content));
$day = stripslashes(FixQuotes($day));
$month = stripslashes(FixQuotes($month));
$year = stripslashes(FixQuotes($year));
$hour = stripslashes(FixQuotes($hour));
$min = stripslashes(FixQuotes($min));
$expires = stripslashes(FixQuotes($expires));
$active = stripslashes(FixQuotes($expires));
/* Strip the leading <P> that the WYSIWYG editor sometimes puts in */
if (substr($content, 0, 4) == " <P>") { $content = substr($content, 4); }
$sql = "insert into ".$prefix."_newsflash values (null, '$title', '$content', '$year-$month-$day $hour:$min:00', ";
if ($expires == 0) {
$sql .= "null, $active)";
}
else {
$expdate = date("Y-m-d H:i", mktime($hour, $min, 0, $month, $day + $expires, $year)) . ":00";
$sql .= "'$expdate', $active)";
}
$result = $db->sql_query($sql);
OpenTable();
if (!$result) { echo $sql; exit(); }
echo "<center><b>"._NEWSFLASH_ADD."</center><P>";
OpenTable2();
$nicedate = "$hour:$min " . formatTimestamp("$year-$month-$day $hour:$min:00");
echo "<center><P>"._NEWSFLASH_ADDCONFIRM.":</center><P><b>"._NEWSFLASH_TITRE."</b>: $title<P><b>"._NEWSFLASH_CONTENT.":</b>"
."<BR>$content<P><b>"._NEWSFLASH_RELEASEDON.":</b> $nicedate<BR>";
if ($expires == 0) { echo "<b>No expiry date</b>"; }
elseif ($expires == 1) { echo "<b>Expires:</b> $expires day after release date."; }
else { echo "<b>"._NEWSFLASH_EXPIRE.":</b> "._NEWSFLASH_EXPIREAFTER1."$expires"._NEWSFLASH_EXPIREAFTER2.""; }
if ($active == 0) { $act = "Inactive"; }
else { $act = "Active"; }
echo "<br><b>"._NEWSFLASH_STATUS_CURRENT.":</b> $act";
CloseTable2();
CloseTable();
include("footer.php");
}
function EditNF($nid) {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
/* Check the input */
$title = stripslashes(FixQuotes($title));
$content = stripslashes(FixQuotes($content));
$day = stripslashes(FixQuotes($day));
$month = stripslashes(FixQuotes($month));
$year = stripslashes(FixQuotes($year));
$hour = stripslashes(FixQuotes($hour));
$min = stripslashes(FixQuotes($min));
$expires = stripslashes(FixQuotes($expires));
$active = stripslashes(FixQuotes($expires));
OpenTable();
echo "<center><b>"._NEWSFLASH_EDITNEWFLASH."</b></center><P>";
/* Retrieve newsflash */
$result = $db->sql_query("select title, data, launch_time, to_days(expires) - to_days(launch_time) 'expires', active from "
."".$prefix."_newsflash where nid = $nid");
list($title, $data, $launch_time, $expires, $active) = $db->sql_fetchrow($result);
/* Display newsflash */
OpenTable2();
$launch = getdate(strtotime($launch_time));
$lyear = $launch['year'];
$lmonth = $launch['mon'];
$lday = $launch['mday'];
$lhour = $launch['hours'];
$lmin = $launch['minutes'];
$nicedate = "$launch_time " . formatTimestamp("$launchtime");
echo "<b>"._NEWSFLASH_TITRE."</b>: $title<P><b>"._NEWSFLASH_CONTENT.":</b><BR>$data<P><b>"._NEWSFLASH_RELEASEDON.":</b> $nicedate<BR>";
if ($expires == 0) { echo "<b>No expiry date!</b>"; }
elseif ($expires == 1) { echo "<b>Expires:</b> 1 day after release date."; }
else { echo "<b>"._NEWSFLASH_EXPIRE.":</b> "._NEWSFLASH_EXPIREAFTER."$expires"._NEWSFLASH_EXPIREAFTER2.""; }
if ($active == 0) { $act = "Inactive"; }
else { $act = "Active"; }
echo "<br><b>"._NEWSFLASH_STATUS_CURRENT.":</b> $act";
CloseTable2();
/* For convenience we'll add form items where user can edit the newsflash data */
echo "<P>"._NEWSFLASH_DETAIL."<br><form action=\"".$admin_file.".php\" method=\"post\"><table cellpadding=3 cellspacing=3 border=0><tr>"
."<td>"._NEWSFLASH_TITRE.":</td><td><input name=title size=50 maxlength=150 value=\"$title\"></td></tr><tr><td>"._NEWSFLASH_CONTENT.":</td><td>"
."<textarea name=content cols=50 rows=10 wrap=virtual>$data</textarea></td></tr>";
/* Build list of days */
$day = 1;
$daylist = "";
while ($day <= 31) {
if ($day == $lday) { $sel = "selected"; }
else { $sel = ""; }
$daylist .= "<option name=\"day\" $sel>$day</option>";
$day++;
}
/* Build month list */
$monthlist = "";
$arMonth = array( "Janvier" => 1, "Février" => 2, "Mars" => 3, "Avril" => 4, "Mai" => 5, "Juin" => 6,
"Juillet" => 7, "Août" => 8, "Septembre" => 9, "Octobre" => 10, "Novembre" => 11, "Décembre" => 12);
foreach ($arMonth as $mname => $mval) {
if ($mval == $lmonth) { $sel = "selected"; }
else { $sel = ""; }
$monthlist .= "<option value=\"$mval\" $sel>$mname</option>";
}
/* Build hour list */
$hour = 0;
$cero = "0";
$hourlist = "";
while ($hour <= 23) {
$dummy = $hour;
if ($hour < 10) { $hour = "$cero$hour"; }
if ($hour == $lhour) { $sel = "selected"; }
else { $sel = ""; }
$hourlist .= "<option value=\"$hour\" $sel>$hour</option>";
$hour = $dummy;
$hour++;
}
/* Build minutes list */
$min = 0;
$minlist = "";
while ($min <= 59) {
if (($min == 0) OR ($min == 5)) { $min = "0$min"; }
if ($min == $lmin) { $sel = "selected"; }
else { $sel = ""; }
$minlist .= "<option value=\"$min\" $sel>$min</option>";
$min = $min + 5;
}
/* Build the expiration list */
$explist = "";
if ($expires == 1) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"1\" $sel>"._NEWSFLASH_DAY1."</option>";
foreach (array(2,3,4,5) as $daynum) {
if ($daynum == $expires) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"$daynum\" $sel>$daynum "._NEWSFLASH_DAY."</option>";
}
if ($expires == 10) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"10\" $sel>"._NEWSFLASH_DAY10."</option>";
if ($expires == 15) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"15\" $sel>"._NEWSFLASH_DAY15."</option>";
if ($expires == 30) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"30\" $sel>"._NEWSFLASH_DAY30."</option>";
if ($expires == 0) { $sel = "selected"; }
else { $sel = ""; }
$explist .= "<option value=\"0\" $sel>"._NEWSFLASH_DAYUNL."</option>";
if ($active == 0) { $activelist = "<option value=\"1\">"._NEWSFLASH_ACTIVE."</option><option value=\"0\" selected>"._NEWSFLASH_INACTIVE."</option>"; }
else { $activelist = "<option value=\"1\" selected>"._NEWSFLASH_ACTIVE."</option><option value=\"0\">"._NEWSFLASH_INACTIVE."</option>"; }
echo "<tr><td>"._NEWSFLASH_STARTDATE.":</td><td><select name=\"day\">$daylist</select> <select name=\"month\">$monthlist"
."</select> <input type=\"text\" name=\"year\" value=\"$lyear\" size=\"4\" maxlength=\"4\"></td></tr>"
."<tr><td>"._NEWSFLASH_STARTTIME.":</td><td><select name=\"hour\">$hourlist</select> : <select name=\"min\">$minlist</select> : 00"
."</td></tr><tr><td>"._NEWSFLASH_EXPIRE.":</td><td><select name=\"expires\">$explist</select></td></tr><tr><td>"._NEWSFLASH_STATUS.":</td><td>"
."<select name=\"active\">$activelist</select></td></tr><tr><td colspan=\"2\"><input type=\"hidden\" name=\"nid\" "
."value=\"$nid\"><input type=\"hidden\" name=\"op\" value=\"NF_Update\"><input type=\"submit\" value=\""._NEWSFLASH_UPDATE."\"></table></form>";
CloseTable();
include("footer.php");
}
function UpdateNF($nid, $title, $content, $day, $month, $year, $hour, $min, $expires, $active) {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
/* Check the input */
$nid = stripslashes(FixQuotes($nid));
$title = stripslashes(FixQuotes($title));
$content = stripslashes(FixQuotes($content));
$day = stripslashes(FixQuotes($day));
$month = stripslashes(FixQuotes($month));
$year = stripslashes(FixQuotes($year));
$hour = stripslashes(FixQuotes($hour));
$min = stripslashes(FixQuotes($min));
$expires = stripslashes(FixQuotes($expires));
$active = stripslashes(FixQuotes($active));
/* Strip the leading <P> that the WYSIWYG editor sometimes puts in */
if (substr($content, 0, 4) == " <P>") { $content = substr($content, 4); }
$sql = "update ".$prefix."_newsflash set title = '$title', data = '$content', launch_time = '$year-$month-$day $hour:$min:00', ";
if ($expires == 0) { $sql .= "expires = null, "; }
else {
$expdate = date("Y-m-d H:i", mktime($hour, $min, 0, $month, $day + $expires, $year)) . ":00";
$sql .= "expires = '$expdate'";
}
$sql .= ", active = $active where nid = $nid";
$result = $db->sql_query($sql);
OpenTable();
if (!$result) { echo $sql; exit(); }
echo "<center><b>"._NEWSFLASH_UPDATETITRE."</center><P>";
OpenTable2();
$nicedate = "$hour:$min " . formatTimestamp("$year-$month-$day $hour:$min:00");
echo "<center><P>"._NEWSFLASH_UPDATETCONFIRM.":</center><P><b>"._NEWSFLASH_TITRE."</b>: $title<P><b>"._NEWSFLASH_CONTENT.":</b>"
."<BR>$content<P><b>"._NEWSFLASH_RELEASEDON.":</b> $nicedate<BR>";
if ($expires == 0) { echo "<b>No expiry date</b>"; }
elseif ($expires == 1) { echo "<b>Expires:</b> $expires day after release date."; }
else { echo "<b>"._NEWSFLASH_EXPIRE.":</b> "._NEWSFLASH_EXPIREAFTER1."$expires"._NEWSFLASH_EXPIREAFTER2.""; }
if ($active == 0) { $act = "Inactive"; }
else { $act = "Active"; }
echo "<br><b>"._NEWSFLASH_STATUS_CURRENT.":</b> $act";
CloseTable2();
echo "<P><a href=\"".$admin_file.".php?op=NF_Edit&nid=$nid\">"._NEWSFLASH_EDITNEWSFLASHAGAIN."</a>";
CloseTable();
include("footer.php");
}
function DeleteNF($nid, $go) {
global $prefix, $db, $admin_file;
include("header.php");
GraphicAdmin();
showmenu();
OpenTable();
echo "<B>"._NEWSFLASH_DELETENEWSFLASH."</B>";
if (! $go) {
echo "<P>"._NEWSFLASH_DELETECONFIRM." [ <a href=\"".$admin_file.".php?op=NF_Delete&nid=$nid&go=1\">"._NEWSFLASH_YES."</a> ] [ <a href=\"javascript".
":history.go(-1);\">"._NEWSFLASH_NO."</a> ]";
}
else {
$result = $db->sql_query("delete from ".$prefix."_newsflash where nid = $nid");
if ($result) { echo "<P>"._NEWSFLASH_DELETED.""; }
}
CloseTable();
include("footer.php");
}
switch($op) {
case "NF_Main":
ListNF($offset);
break;
case "NF_List":
ListNF($offset);
break;
case "NF_Add":
AddNF();
break;
case "NF_Preview":
PreviewNF($title, $content, $day, $month, $year, $hour, $min, $expires, $active);
break;
case "NF_Post":
PostNF($title, $content, $day, $month, $year, $hour, $min, $expires, $active);
break;
case "NF_Edit":
EditNF($nid);
break;
case "NF_Update":
UpdateNF($nid, $title, $content, $day, $month, $year, $hour, $min, $expires, $active);
break;
case "NF_Delete":
DeleteNF($nid, $go);
break;
default:
ListNF($offset);
break;
}
}
else {
echo "Access Denied. Go away.";
}
?>
|
sql (j ai modifier mon prefixe!!)
| Code: |
DROP TABLE IF EXISTS nuke_newsflash;
CREATE TABLE nuke_newsflash (
nid int(11) NOT NULL auto_increment,
title varchar(150) NOT NULL,
data blob,
launch_time datetime NOT NULL,
expires datetime default NULL,
active int(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (nid)
);
#ALTER TABLE `nuke_authors` ADD `radminNewsflashAdmin` TINYINT(2) NOT NULL AFTER `radminency`;
#update nuke_authors set radminNewsflashAdmin = 1 where aid = 'admin';
|
je fais le bon reporter!! je note en meme temps... |
|
|
|
| Revenir en haut de page |
|
lorky
Bénévole SV
Inscrit le: Sep 26, 2006
Messages: 490
Localisation: France, 74, Saint Jorioz
|
| Posté le: 20 Jan 2008, 22:56 Sujet du message: Re : Block Info |
|
|
Salut
Sinon, si tu recherche un truc plus simple, j'avais développé pour un de mes clients un block avec des infos défilantes. Administrable via l'admin, et possibilité de mettre en lien ou pas.
Tiens moi au courant si ca t'interresse
@+ |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 21 Jan 2008, 10:30 Sujet du message: Re : Block Info |
|
|
Bonjour.
Oui ca m interesse!
J aimerai l adapter dans le header ensuite, si j y arrive  |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 21 Jan 2008, 11:59 Sujet du message: Re : Block Info |
|
|
Re,
j essai d adapter le block newsflash dans mon header!
ca marche pas, pourtant j arrive a afficher des news...
Je regarde la table en question, et la je ne vois pas la texte de la news, mais un [blob]
comment je peux appeler le blob dans mon header, c est qui ou quoi blob?
si je fais exporter la table! j ai des lettres et chiffres comme un mdp codé!
bon ok, c est binaire, mais comment je l affiche dans mon header?
Peut etre devrai je modifer la table pour qu elle soit en texte?  |
|
|
|
| Revenir en haut de page |
|
jetdesh
Bénévole SV
Inscrit le: Dec 07, 2006
Messages: 885
|
| Posté le: 21 Jan 2008, 12:13 Sujet du message: Re : Block Info |
|
|
Salut,
J'utilise 4 newsflash que j'ai nommé différement. En effet, j'ai aussi un soucis de récupération par la base de données.
Je vais donc directement dans la base sql pour saisir le texte c'est moins pratique mais cela fonctionne.
De plus je regarde le fameux blob et cela me dit quelque chose. Je vais aussi jeter un coup d'oeil dans ma base et te dire ce qu'il en est.
Tu sais c'est avec les newsflashs que je t'ai écrit un petit texte défilent en bas sur mon site  A propos du peut-être premier inscrit
A+ (je te tiens au courant).
Jet
_________________
Un site pour les profs :
http://profs.123.fr |
|
|
|
| Revenir en haut de page |
|
jetdesh
Bénévole SV
Inscrit le: Dec 07, 2006
Messages: 885
|
| Posté le: 21 Jan 2008, 12:17 Sujet du message: Re : Block Info |
|
|
Salut,
Je viens de regarder je ne vois plus le blob mais cela me dit quelque chose.
Si tu veux je peux te faire des screens de la base d'un newsflash pour voir comment c'est paramétré.
On sait jamais.
A+
Jet
_________________
Un site pour les profs :
http://profs.123.fr |
|
|
|
| Revenir en haut de page |
|
lorky
Bénévole SV
Inscrit le: Sep 26, 2006
Messages: 490
Localisation: France, 74, Saint Jorioz
|
| Posté le: 21 Jan 2008, 12:29 Sujet du message: Re: Re : Block Info |
|
|
| zikadonfeur a écrit: | Bonjour.
Oui ca m interesse!
J aimerai l adapter dans le header ensuite, si j y arrive |
Ok, alors des que j'ai 5 min, je te fais une archive et je te la met à dispo.
@+ |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 21 Jan 2008, 14:51 Sujet du message: Re : Block Info |
|
|
Re,
merci Monsieur |
|
|
|
| Revenir en haut de page |
|
lorky
Bénévole SV
Inscrit le: Sep 26, 2006
Messages: 490
Localisation: France, 74, Saint Jorioz
|
| Posté le: 21 Jan 2008, 16:14 Sujet du message: Re : Block Info |
|
|
Jette un oeil ici -> http://www.chaussin.org avant pour etre sur que c'est ce genre de truc que tu veux.
En bas a gauche
@+ |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 21 Jan 2008, 16:45 Sujet du message: Re : Block Info |
|
|
Bonjour!
j ai une page blanche avec un beau http://www.chaussin.org au milieu!
mais il est beau en tout cas |
|
|
|
| Revenir en haut de page |
|
lorky
Bénévole SV
Inscrit le: Sep 26, 2006
Messages: 490
Localisation: France, 74, Saint Jorioz
|
| Posté le: 21 Jan 2008, 16:46 Sujet du message: Re : Block Info |
|
|
ha ??? pourtant j'ai tout virer 
essaye avec index.php en plus
@+ |
|
|
|
| Revenir en haut de page |
|
Snesman
Bénévole SV
Inscrit le: Apr 30, 2006
Messages: 1862
|
| Posté le: 21 Jan 2008, 16:49 Sujet du message: Re : Block Info |
|
|
Bonjour,
Ca fonctionne correctement chez moi. |
|
|
|
| Revenir en haut de page |
|
zikadonfeur
Spécialiste
Inscrit le: Aug 21, 2006
Messages: 866
Localisation: La Roche Posay (86)
|
| Posté le: 21 Jan 2008, 17:59 | | |
