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ü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ü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ü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> </td>
</tr>
<tr>
<td>Verö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()\"> – <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äge bearbeiten/lö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=\"Ä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öschen\"></td>
</tr>
<tr>
<td>Verö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']) . "\"> – <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ü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ü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> </td>
</tr>
<tr>
<td>Verö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()\"> – <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']) . " – " . mysql2datetime($row['end']) . "</td>
<td class=\"titlecell\" align=\"right\">Autor: " . $row['author'] . "</td>
</tr>
</table><br/>";
}
return $returnstring;