Redakčný systém Etomite

česko-slovenské fórum pre užívateľov s podporou zdarma
https://forum.etomite.sk/

EtoEvents

https://forum.etomite.sk/viewtopic.php?t=114

Strana 1 z 1

EtoEvents

Napísané: St Feb 15, 2006 8:09 pm
od používateľa churchyard
Hledám tenhle snippet, kterej je tady: http://hugelmopf.hu.ohost.de/etomite/manager
nenasel sem ho ani tam, ani na etomite.org, ani tady, ani na googlu :(
pisnul jsem hugelmopfovi maila, ale kazdopadne pokud to tady nekdo ma, mohli by ste me nekam poposunout?
________________________________________________________________


To je ono, ale je to pro verzi RC1
prej to muza zverejnit, ale bez jeho podpory (ze to testnete), maximalne se ho muzu na neco zeptat

Kód: Vybrať všetko

$returnstring="";

function mysql2datetime($mysql)    {
    return substr($mysql,8,2) . "." . substr($mysql,5,2) .".". substr($mysql,0,4) . " " . substr($mysql,11,5) ;
    }

function mysql2date($mysql)    {
    return substr($mysql,8,2) . "." . substr($mysql,5,2) .".". substr($mysql,0,4);
    }

function date2mysql($display)    {
    return substr($display,6,4) . "-" . substr($display,3,2) ."-". substr($display,0,2) ;
    }

function datetime2mysql($display)    {
    return substr($display,6,4) . "-" . substr($display,3,2) ."-". substr($display,0,2) . " " . substr($display,11,5) . ":00" ;
    }

// 1 if user is allowed to modify this page, 0 otherwise
{
  $pageinfo=$etomite->getPageInfo($etomite->documentIdentifier,1, "id, pagetitle, longtitle, description, alias, createdby");
  $userdetails=$etomite->userLoggedIn();
  if($userdetails['id']) {
    // check whether user is allowed to modify this page (-> $result1=1)
    $rs1=$etomite->dbQuery("SELECT * FROM (" . $etomite->db . "member_groups JOIN " . $etomite->db . "membergroup_access ON user_group=membergroup) JOIN " . $etomite->db . "document_groups ON documentgroup=document_group WHERE member='" . $userdetails['id'] . "' and document='" . $etomite->documentIdentifier . "'");
    $result1=mysql_num_rows($rs1);
 
    // check if user is administrator (-> $result2=1)
    $rs2=$etomite->dbQuery("SELECT * FROM " . $etomite->db . "user_attributes WHERE id='" . $userdetails['id'] . "' AND role='1'");
    $result2=mysql_num_rows($rs2);
 
    if($result1>0 || $result2>0) $access_permitted=1;
    else $access_permitted=0;
  }
  else $access_permitted=0;
}

$phpself = $this->config['friendly_urls']==1 ? $pageinfo['alias'] : "index.php?id=".$pageinfo['id'];
$tbl = $etomite->db."etoevents";

// If event table has not been created yet, create it now:
$query=mysql_query("SELECT COUNT(*) FROM $tbl");
if(!$query) {
  $sql="  CREATE TABLE $tbl (
          `id` int(10) unsigned NOT NULL auto_increment,
          `start` datetime NOT NULL default '0000-00-00 00:00:00',
          `end` datetime NOT NULL default '0000-00-00 00:00:00',
          `publish_start` datetime NOT NULL default '0000-00-00 00:00:00',
          `publish_end` datetime NOT NULL default '0000-00-00 00:00:00',
          `title` tinytext NOT NULL,
          `author` varchar(50) NOT NULL,
          `text` text NOT NULL,
          PRIMARY KEY  (`id`)
          ) TYPE=MyISAM AUTO_INCREMENT=1 ;";
  $query=$etomite->dbQuery($sql);
}

if($access_permitted==1) {
  // if user is allowed to modify and has entered admin mode:
  if($_REQUEST['mode']=="admin") {
    /* Processors -----------------*/
    if($_REQUEST["action"]=="edit") {
      if($_POST['submit']=="Eintrag löschen") {
        $rs1=$etomite->dbQuery("DELETE FROM $tbl WHERE id='" . $_POST['eventid'] . "'");
        $returnstring.="<p>Eintrag gelöscht.</p>";
      }
      elseif($_POST['submit']=="Änderungen speichern") {
        $sql = "REPLACE INTO $tbl VALUES( '" . $_POST['eventid'] . "', '" . datetime2mysql($_POST['start']) . "', '" . datetime2mysql($_POST['end']). "', '" . date2mysql($_POST['publish_start']) . "', '" . date2mysql($_POST['publish_end']) . "', '" . addslashes($_POST['title']). "', '" . $userdetails['username']. "', '" . addslashes($_POST['text']). "')";
        $rs=$etomite->dbQuery($sql);
        $returnstring.="<p>Änderungen gespeichert.</p>";
      }
    }
   
    if($_REQUEST["action"]=="insert") {
        $sql = "INSERT INTO $tbl VALUES( '" . $_POST['eventid'] . "', '" . datetime2mysql($_POST['start']) . "', '" . datetime2mysql($_POST['end']). "', '" . date2mysql($_POST['publish_start']) . "', '" . date2mysql($_POST['publish_end']) . "', '" . addslashes($_POST['title']). "', '" . $userdetails['username']. "', '" . addslashes($_POST['text0']). "')";
        $rs=$etomite->dbQuery($sql);
        $returnstring.="<p>Eintrag hinzugef&uuml;gt.</p>";
    }

    /* Forms ----------- */
    $returnstring.="
    <form action=\"".$phpself."\" method=\"post\" name=\"activateviewform\">
    <input type=\"hidden\" name=\"mode\" value=\"view\">
    <center><input type=\"submit\" value=\"Normalansicht\"></center>
    </form>";

    $returnstring.="
    <h3>Neuen Eintrag hinzuf&uuml;gen:</h3>
    <form action=\"$phpself\" method=\"post\">
    <input type=\"hidden\" name=\"eventid\" value=\"NULL\">
    <input type=\"hidden\" name=\"action\" value=\"insert\">
    <input type=\"hidden\" name=\"mode\" value=\"admin\">
    <table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"1\">
      <tr>
        <td width=\"10%\">Start:</td>
        <td><input name=\"start\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"16\" maxlenght=\"16\" value=\"" . strftime("%d.%m.%Y 19:00") . "\" onfocus=\"select()\">
        <td align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Eintrag hinzuf&uuml;gen\"></td>
      </tr>
      <tr>
        <td>Ende:</td>
        <td><input name=\"end\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"16\" maxlenght=\"16\" value=\"" . strftime("%d.%m.%Y 20:30") . "\" onfocus=\"select()\"></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Ver&ouml;ffentlicht:</td>
        <td colspan=\"2\"><input name=\"publish_start\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"10\" maxlenght=\"10\" value=\"" . strftime("%d.%m.%Y") . "\" onfocus=\"select()\"> &ndash; <input name=\"publish_end\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"10\" maxlenght=\"10\" value=\"00.00.0000\" onfocus=\"select()\"></td>
      </tr>
      <tr>
        <td>Titel:</td>
        <td colspan=\"2\"><input name=\"title\" type=\"text\" style=\"border: 1px solid #0000FF;width:100%\" maxlenght=\"255\" value=\"\"></td>
      </tr>
      <tr>
        <td>Beschreibung:</td>
        <td colspan=\"2\"><textarea id=\"text\" name=\"text\" style=\"width:100%; height:100px;\"></textarea></td>
      </tr>
    </table>
    </form>

    <h3>Eintr&auml;ge bearbeiten/l&ouml;schen</h3>
    ";


    $rs1=$etomite->dbQuery("SELECT * FROM $tbl ORDER BY publish_end DESC,end DESC,publish_start DESC,start DESC");
    while($row=$etomite->fetchRow($rs1)) {

      $returnstring.="
      <form action=\"$phpself\" method=\"post\" name=\"editform\">
      <input type=\"hidden\" name=\"eventid\" value=\"" . $row['id'] . "\">
      <input type=\"hidden\" name=\"action\" value=\"edit\">
      <input type=\"hidden\" name=\"mode\" value=\"admin\">
      <table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"1\" style=\"border-width:1px;\">
        <tr>
          <td width=\"10%\">Start:</td>
          <td><input name=\"start\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"16\" maxlenght=\"16\" value=\"" . mysql2datetime($row['start']) . "\"></td>
          <td align=\"right\"><input type=\"submit\" name=\"submit\" value=\"&Auml;nderungen speichern\"></td>
        </tr>
        <tr>
          <td>Ende:</td>
          <td><input name=\"end\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"16\" maxlenght=\"16\" value=\"" . mysql2datetime($row['end']) . "\"></td>
          <td align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Eintrag l&ouml;schen\"></td>
        </tr>
        <tr>
          <td>Ver&ouml;ffentlicht:</td>
          <td colspan=\"2\"><input name=\"publish_start\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"10\" maxlenght=\"10\" value=\"" . mysql2date($row['publish_start']) . "\"> &ndash; <input name=\"publish_end\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"10\" maxlenght=\"10\" value=\"" . mysql2date($row['publish_end']) . "\"></td>
        </tr>
        <tr>
          <td>Titel:</td>
          <td colspan=\"2\"><input name=\"title\" type=\"text\" style=\"border: 1px solid #0000FF;width:100%\" maxlenght=\"255\" value=\"" . stripslashes($row['title']) . "\"></td>
        </tr>
        <tr>
          <td>Beschreibung:</td>
          <td colspan=\"2\"><textarea id=\"text\" name=\"text\" style=\"width:100%; height:100px;\">" . stripslashes($row['text']) . "</textarea></td>
        </tr>
      </table>
      </form>";
    }

    $returnstring.="
    <h3>Neuen Eintrag hinzuf&uuml;gen:</h3>
    <form action=\"$phpself\" method=\"post\">
    <input type=\"hidden\" name=\"eventid\" value=\"NULL\">
    <input type=\"hidden\" name=\"action\" value=\"insert\">
    <input type=\"hidden\" name=\"mode\" value=\"admin\">
    <table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"1\">
      <tr>
        <td width=\"10%\">Start:</td>
        <td><input name=\"start\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"16\" maxlenght=\"16\" value=\"" . strftime("%d.%m.%Y 19:00") . "\" onfocus=\"select()\">
        <td align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Eintrag hinzuf&uuml;gen\"></td>
      </tr>
      <tr>
        <td>Ende:</td>
        <td><input name=\"end\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"16\" maxlenght=\"16\" value=\"" . strftime("%d.%m.%Y 20:30") . "\" onfocus=\"select()\"></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>Ver&ouml;ffentlicht:</td>
        <td colspan=\"2\"><input name=\"publish_start\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"10\" maxlenght=\"10\" value=\"" . strftime("%d.%m.%Y") . "\" onfocus=\"select()\"> &ndash; <input name=\"publish_end\" type=\"text\" style=\"border: 1px solid #0000FF;\" size=\"10\" maxlenght=\"10\" value=\"00.00.0000\" onfocus=\"select()\"></td>
      </tr>
      <tr>
        <td>Titel:</td>
        <td colspan=\"2\"><input name=\"title\" type=\"text\" style=\"border: 1px solid #0000FF;width:100%\" maxlenght=\"255\" value=\"\"></td>
      </tr>
      <tr>
        <td>Beschreibung:</td>
        <td colspan=\"2\"><textarea id=\"text\" name=\"text\" style=\"width:100%; height:100px;\"></textarea></td>
      </tr>
    </table>
    </form>";

    $returnstring.="
      <script type=\"text/javascript\" type=\"text/javascript\" src=\"manager/media/tinymce/jscripts/tiny_mce/tiny_mce.js\"></script>
      <script type=\"text/javascript\" type=\"text/javascript\">
        tinyMCE.init({
          theme : \"advanced\",
          mode : \"textareas\",
          theme_advanced_buttons1 :\"separator,undo,redo,separator,link,separator,bold,italic,underline,separator,numlist,bullist,separator,hr,separator,code\",
          theme_advanced_buttons2 : \"\",
          theme_advanced_buttons3 : \"\", 
          theme_advanced_toolbar_location : \"top\",
        debug : false
        });
      </script>";

    return $returnstring;
  }
  // if user is allowed to modify, but has not entered admin mode yet:
  else {
    $returnstring.="
    <form action=\"".$phpself."\" method=\"post\" name=\"activateadminform\">
    <input type=\"hidden\" name=\"mode\" value=\"admin\">
    <center><input type=\"submit\" value=\"Termin-Manager\"></center>
    </form>";
  }
}

$sql="SELECT * FROM $tbl WHERE (publish_start<=CURRENT_DATE() OR publish_start='0000-00-00') AND (publish_end>=CURRENT_DATE() OR publish_end='0000-00-00') ORDER BY start DESC";
$rs=$etomite->dbQuery($sql);
$i=0;
while($row=$etomite->fetchRow($rs)) {
  $returnstring.="
  <table border=\"0\" width=\"100%\">
    <tr>
      <td colspan=\"2\" class=\"titlecell\">" . htmlentities(stripslashes($row['title'])) . "</td>
    </tr>
    <tr>
      <td colspan=\"2\" class=\"textcell\">" . stripslashes($row['text']) . "</td>
    </tr>
    <tr>
      <td class=\"titlecell\">" . mysql2datetime($row['start']) . " &ndash; " . mysql2datetime($row['end']) . "</td>
      <td class=\"titlecell\" align=\"right\">Autor: " . $row['author'] . "</td>
    </tr>
  </table><br/>";
}

return $returnstring;

Napísané: St Feb 15, 2006 10:53 pm
od používateľa _rasel^
Hmm... tak tento snippet som ties nenasiel.

Nasiel som iba tieto:
event-list: http://www.etomite.org/browsesnippets.h ... snipid=162
Events_Suite: http://www.etomite.org/browsesnippets.h ... snipid=173

Napísané: St Feb 15, 2006 11:08 pm
od používateľa churchyard
uvidim, jestli odpovi a mozna potom, kazdopadne poskytnu 8)

Napísané: Št Feb 16, 2006 11:16 pm
od používateľa churchyard
Event List prácička:
http://www.prdi.cz/index.php?id=69

Napísané: Št Feb 16, 2006 11:21 pm
od používateľa dutch
hmmm...
to se mi moc libi ;) co zdrojak bude k nahlednuti? :)

Napísané: Št Feb 16, 2006 11:38 pm
od používateľa churchyard
jestli chces, ale je tu jeden problem: je to ifram (nahore) takze trochu komplikovano...
udelam to na vic prispevku na kousky

dil 1 z nekolika

V repository udelej slozku Events (id XY -> pak ho budem nekam psat, tak se na nej koukni)
do ni napis uvodni text (pro info klikni na...)

Udelej novej dokument (normalne v menu), obsahem:

Kód: Vybrať všetko

<fieldset><legend>Info</legend><iframe scrolling="no" name="podrobnosti" src="index.php?id=XY" noresize frameborder="0" width="100%" height="30">Váš prohlížeč nepodporuje rámy</iframe></fieldset>
<p>[[Events]]</p>
Samozrejme html si muzes usporadat jinak

EDIT: Ten dokument se nesmi ukladat do kese

Napísané: Št Feb 16, 2006 11:40 pm
od používateľa churchyard
dil 2 z nekolika
Samozrejme snippet [[Events]][code]/* you can use the snippet as follows:
[[Events?resourceparent=4&maxEventNumbers=6&maxPeriod=6]]
To set a default setting here you can change the last number after the variable name in the following three lines, e.g.
$resourceparent = isset($resourceparent) ? $resourceparent : 8; means $resourceparent=8 if not set in the snippet call.
*/
$resourceparent = isset($resourceparent) ? $resourceparent : XY;
$maxEventNumbers = isset($maxEventNumbers ) ? $maxEventNumbers : 5;
$maxPeriod = isset($maxPeriod ) ? $maxPeriod : 6;
$showEventInformation = isset($showEventInformation ) ? $showEventInformation : false;
$fullEventDate = isset($fullEventDate ) ? $fullEventDate : 'd.m.Y';
$quickEventDate = isset($quickEventDate ) ? $quickEventDate : 'd.m.';
$monthNames = array('Leden', 'Únor', 'Březen', 'Duben', 'Květen', 'Červen', 'Červenec', 'Srpen', 'Září', 'Říjen', 'Listopad', 'Prosinec');

/* output generation */
$output = '';
$resource = $etomite->getActiveChildren($resourceparent, 'alias', 'ASC', $fields='id, longtitle, alias, description, content');

$displayedEvents = 0;
$numberEvents = count($resource);
$lastMonth = -1;
$currentDate = mktime(0,0,0);
$endDate = $currentDate + $maxPeriod * 30 * 24 * 60 * 60;

for ($i = 0; $i < $numberEvents && $displayedEvents < $maxEventNumbers; ++$i) {
$alias = $resource[$i]['alias'];
$eventtitle = $resource[$i]['longtitle'];

if (strlen($alias) > 0 && strlen($eventtitle) > 0 && preg_match('/^\d{8,8}/',$alias, $dateText)) {
$dateYear = substr($dateText[0], 0, 4);
$dateMonth = substr($dateText[0], 4, 2);
$dateDay = substr($dateText[0], 6, 2);
$eventDate = mktime(0, 0, 0, $dateMonth, $dateDay, $dateYear);
if ($eventDate < $currentDate || $eventDate > $endDate) {
continue;
}
$dateArray = getdate($eventDate);
$curMonth = $dateArray['mon'];
if ($curMonth != $lastMonth) {
if ($lastMonth != -1) {
$output .= '</li></ul>';
}
$output .= '<li class="eventmonth">'.$monthNames[$curMonth-1].'<ul>';
}
$pageid = $resource[$i]['id'];
$eventdescription = $resource[$i]['description'] == '' ? "$eventtitle - ".date($fullEventDate,$eventDate) : $resource[$i]['description'];
$eventInformation = $resource[$i]['content'];
$href = date($quickEventDate ,$eventDate)."<br/><a href='[~$pageid~]' title=\"$eventdescription\" target=\"podrobnosti\">$eventtitle</a>";
$output .= "<li class=\"eventitem\">$href".($showEventInformation ? "<br/><span class=\"event-information\">$eventInformation</span>" : '')."</li>";
++$displayedEvents;
$lastMonth = $curMonth;
}
}

if (strlen($output) == 0) {
$output .= "Žádné akce nenalezeny.";
} else {
$output = '<ul>'.$output.'</ul></li></ul>';
}

return $output;[/code]

Napísané: Št Feb 16, 2006 11:44 pm
od používateľa churchyard
dil 3 z nekolika
udelej sablonu "Nic"

Kód: Vybrať všetko

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
  <title>[*pagetitle*]</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

  <style type="text/css">
TVUJ STYL ABY TO ZAPADALO DO STRANKY
POZOR: pozadi musi bejt stejny jako je pozadi obsahu stranek (u me bila, kdezto background je cernej)

.etoNotice { display:none; } /* removne ti kopirajc, i kdyz se to nesmi, tak v tom iframu by prekazel */
#etoNotice { display:none; } /* u ruznejch verzi to dela ruznej radek */
  </style>
  <!--[if gte IE 5.5000]>
    <script type="text/javascript" src="templates/Horizontal/pngfix.js"></script>
  <![endif]-->

</head>

<body>
<div id="content">
      [*content*]
</div>
</body>
</html>
mam tan pngfix z horizontalu, ten tam bejt nemusi


slozce Events dej sablonu Nic

Napísané: Št Feb 16, 2006 11:48 pm
od používateľa churchyard
dil 4 ze 4 aneb jak na novou akci
ted udelas dokument ve slozce Events
sablona: Nic
obsah dokumentu: to se zobrazi v iframu
nazev dokumentu: se zobrazi ve stromu v administraci
dlouhy nazev: se zobrazi na strance (kdyz nezadas dlouhy nazev, tak se nezobrazi)
alias: cas ve tvaru YYYYMMDD -> 20060216 pro dnesek
publikovat -> konec publikace (ja davam takhle): den po akci ve 12:00:00

snad sem na nic nezapomel. jo ta slzoka Events musi bejt taky publikovana
Všetky časy sú v UTC+03:00
Strana 1 z 1

Založené na phpBB® Forum Software © phpBB Limited