|
Drugie artyku?y (sklonowane artyku?y)
|
| Ashnah |
Dodany dnia 16.09.2009 14:13:18
|
Przedszkolak
Postów: 26
Pomógł: 1
Ostrzeżeń: 1
 v7.01.05
Data rejestracji: 10.09.2009 12:13
|
FiXik i Pieka wielkie dzi?ki. Dok?adnie o co? takiego mi chodzi?o 
Pozdrawiam.
Wiadomo?? doklejona:
Witam ponownie.
Pojawi? si? problem przy dodaniu wpisów do bazy.
Prawie wszystko zrobi?am tak jak radzi? Pieka. Prawie, bo chcia?am, ?eby w PA wy?wietla?y mi si? linki do nowoutworzonych dzia?ów, wi?c zamiast u?y? nazwy 'Artyku?y2' zastosowa?am inn? nazw?.
Skutek jest taki, ?e nie wida? opcji przy dodawaniu nowych wpisów do tego dzia?u.
Natomiast dla kategorii tego dzia?u wszystko jest ok.
Ma mo?e kto? pomys? jak to rozwi?za?, bo poza tym fragmentem przy dodawaniu wpisu do bazy ca?? reszt? edytowa?am tak jak opisa? Pieka.
Edytowane przez Ashnah dnia 22.09.2009 13:00:53
|
| |
|
|
| W?cibski Go?? |
Dodany dnia 06.09.2025 17:40:41
|
Pan Kontekstualny
Postów: n^x
Data rejestracji: Zawsze
|
|
| IP: localhost |
|
|
| Ashnah |
Dodany dnia 06.11.2009 13:56:29
|
Przedszkolak
Postów: 26
Pomógł: 1
Ostrzeżeń: 1
v7.01.05
Data rejestracji: 10.09.2009 12:13
|
Mam pytanko.
Klonuj? Artuku?y w PHP-Fusion v7. Czy aby zmieni? typ pola z TEXT na LONGTEXT wystarczy dodaj?c w Dodatkowych Stronach wpis do bazy danych zmieni?:
article_article TEXT NOT NULL
na
article_article LONGTEXT NOT NULL
Generalnie chyba powinno dzia?a?, ale wola?abym si? upewni?.
PW od moderatora:
- Przeniesienie posta - Pieka 06.11 - 13:56
Edytowane przez Ashnah dnia 06.11.2009 13:47:56
|
| |
|
|
| Pieka |
Dodany dnia 06.11.2009 13:59:47
|
Postów: 19887
Pomógł: 767
v7.02.03
Data rejestracji: 23.02.2005 18:12
|
Tak, wystarczy zmienic wartosc TEXT na LONGTEXT w podanym polu zapytania dodajacego druga tabele artykulow.
Jestem jaki jestem |
| |
|
|
| alhenag |
Dodany dnia 05.01.2010 16:42:20
|
Przedszkolak
Postów: 19
Pomógł: 1
Ostrzeżeń: 4
Data rejestracji: 29.08.2009 13:35
|
Witam
Pozwol? sobie zacytowa? sam? siebie sprzed kilku miesi?cy.
alhenag napisa?/a:
Doda?am pliki zapodane przez Piek? i dokona?am wszystkich poprawek, które nakaza? w kolejnym po?cie. Niestety - tak, jak uda?o mi si? rozwi?za? spraw? z drukowaniem, tak o edycji artyku?ów z drugiej i trzeciej grupy mog? pomarzy?. "O?óweczek" w pierwszej grupie artyku?ów pojawia si? i edycja przebiega prawid?owo, za? w drugiej i trzeciej grupie artyku?ów znikn?? w ogóle.
Zgodnie ze wskazówkami dokona?am nast?puj?cej zmiany w pliku theme_functions_include.php:
function articleopts($info, $sep) {
global $locale; $res = "";
if ($info['article_allow_comments']) { $res = "<a onFocus='blur()' href='articles.php?article_id=".$info['article_id']."#comments'>".$info['article_comments'].($info['article_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])."</a>\n"; }
$res .= $info['article_reads'].$locale['global_074']." ".$sep."\n";
$res .= "<a onFocus='blur()' href='print.php?type=A&item_id=".$info['article_id']."'><img src='".get_image("printer")."' alt='".$locale['global_075']."' style='vertical-align:middle;border:0;' /></a>\n";
return "<!--article_opts-->".$res;
}
function articleopts2($info, $sep) {
global $locale; $res = "";
if ($info['article_allow_comments']) { $res = "<a onFocus='blur()' href='articles2.php?article_id=".$info['article_id']."#comments'>".$info['article_comments'].($info['article_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])."</a>\n"; }
$res .= $info['article_reads'].$locale['global_074']." ".$sep."\n";
$res .= "<a onFocus='blur()' href='print.php?type=A2&item_id=".$info['article_id']."'><img src='".get_image("printer")."' alt='".$locale['global_075']."' style='vertical-align:middle;border:0;' /></a>\n";
return "<!--article_opts-->".$res;
}
function articleopts3($info, $sep) {
global $locale; $res = "";
if ($info['article_allow_comments']) { $res = "<a onFocus='blur()' href='articles3.php?article_id=".$info['article_id']."#comments'>".$info['article_comments'].($info['article_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])."</a>\n"; }
$res .= $info['article_reads'].$locale['global_074']." ".$sep."\n";
$res .= "<a onFocus='blur()' href='print.php?type=A3&item_id=".$info['article_id']."'><img src='".get_image("printer")."' alt='".$locale['global_075']."' style='vertical-align:middle;border:0;' /></a>\n";
return "<!--article_opts-->".$res;
}
function itemoptions($item_type, $item_id) {
global $locale, $aidlink; $res = "";
if ($item_type == "N") {
if (iADMIN && checkrights($item_type)) { $res .= "<!--article_news_opts--> · <a onFocus='blur()' href='".ADMIN."news.php".$aidlink."&action=edit&news_id=".$item_id."'><img src='".get_image("edit")."' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0;' /></a>\n"; }
} elseif ($item_type == "A") {
if (iADMIN && checkrights($item_type)) { $res .= "<!--article_admin_opts--> · <a onFocus='blur()' href='".ADMIN."articles.php".$aidlink."&action=edit&article_id=".$item_id."'><img src='".get_image("edit")."' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0;' /></a>\n"; }
} elseif ($item_type == "A2") {
if (iADMIN && checkrights($item_type)) { $res .= "<!--article_admin_opts--> · <a onFocus='blur()' href='".ADMIN."articles2.php".$aidlink."&action=edit&article_id=".$item_id."'><img src='".get_image("edit")."' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0;' /></a>\n"; }
} elseif ($item_type == "A3") {
if (iADMIN && checkrights($item_type)) { $res .= "<!--article_admin_opts--> · <a onFocus='blur()' href='".ADMIN."articles3.php".$aidlink."&action=edit&article_id=".$item_id."'><img src='".get_image("edit")."' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0;' /></a>\n"; }
}
return $res;
}
Bardzo prosz? o podpowied?, co zrobi?am ?le.
Problem nie jest nagl?cy, bo mog? artyku?y edytowa? poprzez PA, to tylko kwestia wygody, ciekawo?ci i nabycia wiedzy.
Mam te? pytanie, jak wy??czy? opcj? komentowania i oceniania artyku?ów "domy?lnie", tzn. ?eby podczas dodawania czy edycji na sta?e by?y odznaczone pola "W??cz komentarze" i "W??cz ocenianie".
Mam nadziej?, ?e tym razem wpisa?am si? w odpowiednim w?tku :)
Pozdrawiam i bardzo prosz? o podpowied?.
Wiadomo?? doklejona:
Witam raz jeszcze.
Znalaz?am sama mo?liwo?? odznaczenia w/w pól, pozostaje kwestia sklonowanych artyku?ów. Wszystko ?adnie mi dzia?a poza t? nieszcz?sn? edycj?. Czy mog? raz jeszcze prosi? o przejrzenie i podpowied?, gdzie jest b??d w pliku "theme_functions_include.php"?
Edytowane przez alhenag dnia 06.01.2010 13:32:59
|
| |
|
|
| cybull |
Dodany dnia 16.01.2010 11:37:21
|
Przedszkolak
Postów: 31
Pomógł: 2
Data rejestracji: 26.11.2008 10:37
|
Witam.
Czy mo?na by?o by liczy? na podpowied? - jak nale?a?oby zmodyfikowa? pliki submit.php oraz administration/submission.php aby u?ytkownicy mogli pisa? tak jak w standardowych artyku?ach , ?eby tekst szed? do akceptacji administratora oraz wy?wietla?a si? informacja o nowych artyku?ach PA, dopiero po akceptacji administratora tekst szed? by do odpowiedniej kategorii drugich artyku?ów. Niestety m?czy?em si? z tym i poleg?em.
Z góry dzi?kuj?.
Edytowane przez cybull dnia 16.01.2010 11:39:08
|
| |
|
|
| alhenag |
Dodany dnia 18.01.2010 15:59:20
|
Przedszkolak
Postów: 19
Pomógł: 1
Ostrzeżeń: 4
Data rejestracji: 29.08.2009 13:35
|
Witam
Cichutko i nie?mia?o zapytam raz jeszcze - czy jest mo?liwo?? sprawdzenia i podpowiedzi w kwestii edytowania sklonowanych artyku?ów? (newsów zreszt? te? http://www.php-fu...ost_140134)
Pozdrawiam zimowo.
|
| |
|
|
| Pieka |
Dodany dnia 25.01.2010 18:21:42
|
Postów: 19887
Pomógł: 767
v7.02.03
Data rejestracji: 23.02.2005 18:12
|
Ostatnio na wniosek kolezanki zebralem sie w sobie i dokonczylem te modyfikacje. Mimo to, caly czas mialem nadzieje, ze ktos inny mnie wyreczy i zamiast czekac na admina da cos od siebie. Niestety, w ten sposob jak widac moglibysmy czekac w nieskonczonosc... Zatem zmodyfikowane pliki czesciowo opatrzone komentarzami umieszczam jako zalacznik. Na opisy poszczegolnych dzialan nie liczcie, az tak zmobilizowany nie jestem 
W srodku:
- Drugie artykuly z osobnymi uprawnieniami.
- Kody ulatwiajace dodanie tabel, wpisow i wprowadzajace zmiany.
- Dodane pelne zarzadzanie komentarzami.
- Dodana pelna edycja, w tym rowniez z poziomu strony (oloweczek ).
- Zglaszanie przez uzytkownikow wraz ze standardowa akceptacja (badz nie) administratora.
Wiecej grzechow nie pamietam. Jesli cos Wam nie dziala, trudno
Pieka dodał/a następującą plik:
Jestem jaki jestem |
| |
|
|
| drzewo |
Dodany dnia 26.01.2010 21:53:50
|
Przedszkolak
Postów: 2
Data rejestracji: 26.01.2010 19:04
|
Próbowa?em edytowa? 'artykuly 2' na recenzje i sklonowa?o sie kilka razy, gdzie moge usun?? powtarzaj?ce si? liki?
screen
|
| |
|
|
| cybull |
Dodany dnia 27.01.2010 09:08:27
|
Przedszkolak
Postów: 31
Pomógł: 2
Data rejestracji: 26.11.2008 10:37
|
|
| |
|
|
| Ashnah |
Dodany dnia 02.03.2010 10:50:45
|
Przedszkolak
Postów: 26
Pomógł: 1
Ostrzeżeń: 1
v7.01.05
Data rejestracji: 10.09.2009 12:13
|
Pieka napisa?/a:
Swieta ida, wiec niech Ci bedzie. Edytuj plik administration/ article_cats2.php, (...) tu pieka t?umaczy jak zmieni? uprawnienia (...)
Zycze powodzenia
Pieka mam pytanie, bo nie jestem pewna, czy dobrze rozumiem:
Je?li sklonowa?am artyku?y 10 razy to musz? t? sam? czynno?? powtórzy? tyle samo razy ile mam sklonowanych artyku?ów i wsz?dzie zamiast Artyku?y 2, AC2, A2, AC2.A2 zmieniam zawarto?? na swoje wersje artyku?ów?
A pó?niej mog? ka?demu u?ytkownikowi z uprawnieniami administratora doda? uprawnienia do konkretnych Artyku?ów?
|
| |
|
|
| Pieka |
Dodany dnia 02.03.2010 11:47:31
|
Postów: 19887
Pomógł: 767
v7.02.03
Data rejestracji: 23.02.2005 18:12
|
Tak, jesli kazdy z administratorow ma posiadac uprawnienia tylko do wybranych artykulow, to musisz powielic wszystkie opisane kroki, czyli musisz miec 10 paczek tego typu, co zalaczona przeze mnie w jednym z postow.
Jestem jaki jestem |
| |
|
|
| Ashnah |
Dodany dnia 02.03.2010 12:08:06
|
Przedszkolak
Postów: 26
Pomógł: 1
Ostrzeżeń: 1
v7.01.05
Data rejestracji: 10.09.2009 12:13
|
No to czeka mnie baaardzo du?o roboty 
Dzi?ki wielkie za pomoc
Wiadomo?? doklejona:
Mam pytanko odno?nie tematu http://www.php-fu...ost_142902 Pisz? tutaj, poniewa? wspomniany temat "martwy" a ja musz? doda? do sklonowanych artyku?ów mo?liwo?? okre?lenia pocz?tkowej i ko?cowej daty ich wy?wietlania.
B?d? bardzo wdzi?czna za pomoc.
Edytowane przez Ashnah dnia 15.03.2010 10:06:36
Nigdy nie mo?na ustali? z pewno?ci? gdzie w kobiecie ko?czy si? Anio? a zaczyna Diabe? |
| |
|
|
| Pawlo_23 |
Dodany dnia 19.06.2010 13:19:39
|
Przedszkolak
Postów: 23
Data rejestracji: 18.05.2010 00:08
|
Witam! Zrobi?em wszystko dok?adnie tak, jak napisa? Pieka w za??czniku do postu: http://www.php-fu...ost_140906.
1. Pliki umie?ci?em w?a?ciwie na serwerze
2. W Pliku theme.php swojej skórki ATLANTIS doda?em sugerowane zmiany
3. Wykona?em: Dodanie_wpisów_do_bazy i Zmiana wielko?ci pola rating_type
4. Wszystko przebieg?o poprawnie i bez b??dów: pojawi?y si? wpisy w bazie danych i skróty w panelu admina
Dopiero tu pojawi?y si? problemy: Nie mog? utworzy? ani kategorii w tych drugich artyku?ach ani artyku?ów, bo po klikni?ciu przenosi mnie na stron? g?ówn? i nic si? dalej nie dzieje...
Co mo?e by? tego przyczyn??
Pawlo |
| |
|
|
| Adko |
Dodany dnia 18.03.2011 19:40:30
|
Przedszkolak
Postów: 28
Data rejestracji: 05.07.2007 11:43
|
Cze??.
Zaktualizowa?em sobie do wersji v7.01.05.
Po aktualizacji nie mam artku?ów 2.
Pojawia si? komunikat :
Notice: Use of undefined constant DB_ARTICLE_CATS_2 - assumed 'DB_ARTICLE_CATS_2' in /home/szopienice/domains/rada.szopienice.eu/public_html/articles2.php on line 70
Table 'szopienice_rada.DB_ARTICLE_CATS_2' doesn't exist
Jak rozwi?za? ten problem?
Mam nadziej?, ?e chodzi?o o to:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: articles.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."protokoly.php";
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['article_id']) && isnum($_GET['article_id'])) {
$result = dbquery(
"SELECT ta.*,tac.*, tu.user_id,user_name FROM ".DB_ARTICLES_2." ta
INNER JOIN ".DB_ARTICLE_CATS_2." tac ON ta.article_cat=tac.article_cat_id
LEFT JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id
WHERE ".groupaccess('article_cat_access')." AND article_id='".$_GET['article_id']."' AND article_draft='0'"
);
if (dbrows($result)) {
require_once INCLUDES."comments_include.php";
require_once INCLUDES."ratings_include.php";
$data = dbarray($result);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($_GET['rowstart'] == 0) { $result = dbquery("UPDATE ".DB_ARTICLES_2." SET article_reads=article_reads+1 WHERE article_id='".$_GET['article_id']."'"); }
$article = stripslashes($data['article_article']);
if (ereg('<--PAGEBREAK-->', $article)) {
$article = explode("<--PAGEBREAK-->", $article);
} else {
$article = explode("<!-- pagebreak -->", $article);
}
$pagecount = count($article);
$article_subject = stripslashes($data['article_subject']);
$article_info = array(
"article_id" => $data['article_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"article_date" => $data['article_datestamp'],
"article_breaks" => $data['article_breaks'],
"article_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='A2' AND comment_item_id='".$data['article_id']."'"),
"article_reads" => $data['article_reads'],
"article_allow_comments" => $data['article_allow_comments']
);
add_to_title($locale['global_201'].$article_subject);
echo "<!--pre_article-->";
render_article($article_subject, $article[$_GET['rowstart']], $article_info);
echo "<!--sub_article-->";
if ($pagecount > 1) {
echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?article_id=".$_GET['article_id']."&")."\n</div>\n";
}
if ($data['article_allow_comments']) { showcomments("A2", DB_ARTICLES_2, "article_id", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); }
if ($data['article_allow_ratings']) { showratings("A2", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); }
} else {
redirect(FUSION_SELF);
}
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) {
opentable($locale['400']);
echo "<!--pre_article_idx-->\n";
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS_2." WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name");
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }
$num = dbcount("(article_cat)", DB_ARTICLES_2, "article_cat='".$data['article_cat_id']."' AND article_draft='0'");
echo "<td valign='top' width='50%' class='tbl article_idx_cat_name'><!--article_idx_cat_name--><a href='".FUSION_SELF."?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a> <span class='small2'>($num)</span>";
if ($data['article_cat_description'] != "") { echo "<br />\n<span class='small'>".$data['article_cat_description']."</span>"; }
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
} else {
echo "<div style='text-align:center'><br />\n".$locale['401']."<br /><br />\n</div>\n";
}
echo "<!--sub_article_idx-->\n";
closetable();
} else {
$res = 0;
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS_2." WHERE article_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['article_cat_access'])) {
$res = 1;
add_to_title($locale['global_201'].$cdata['article_cat_name']);
opentable($locale['400'].": ".$cdata['article_cat_name']);
echo "<!--pre_article_cat-->";
$rows = dbcount("(article_id)", DB_ARTICLES_2, "article_cat='".$_GET['cat_id']."' AND article_draft='0'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery(
"SELECT ta.article_id, ta.article_subject, ta.article_snippet, ta.article_datestamp FROM ".DB_ARTICLES_2." ta
WHERE article_cat='".$_GET['cat_id']."' AND article_draft='0' ORDER BY ".$cdata['article_cat_sorting']." LIMIT ".$_GET['rowstart'].",15"
);
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " <span class='small'>[".$locale['402']."]</span>";
} else {
$new = "";
}
echo "<a href='".FUSION_SELF."?article_id=".$data['article_id']."'>".$data['article_subject']."</a>$new<br />\n".stripslashes($data['article_snippet']);
echo ($i != $numrows ? "<br /><br />\n" : "\n"); $i++;
}
echo "<!--sub_article_cat-->";
closetable();
if ($rows > 15) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n</div>\n";
} else {
echo "<div style='text-align:center'>".$locale['403']."</div>\n";
echo "<!--sub_article_cat-->";
closetable();
}
}
}
if ($res == 0) { redirect(FUSION_SELF); }
}
require_once THEMES."templates/footer.php";
?>
A tu wycinek z tabeli z bazy:
SELECT *
FROM `fusion_radaarticle_cats2`
LIMIT 0 , 30
PW od moderatora:
- Przeniesienie posta - krystian1988 18.03 - 19:40
Edytowane przez Pieka dnia 18.03.2011 20:05:56
|
| |
|
|
| Smok-Wiatru |
Dodany dnia 19.03.2011 17:01:41
|
Przedszkolak
Postów: 53
Pomógł: 1
Ostrzeżeń: 3
v7.01.01
Data rejestracji: 01.07.2010 19:08
ZBANOWANY:
Dożywotnio
|
Adko napisa?/a:
Cze??.
Zaktualizowa?em sobie do wersji v7.01.05.
Po aktualizacji nie mam artku?ów 2.
Pojawia si? komunikat :
Notice: Use of undefined constant DB_ARTICLE_CATS_2 - assumed 'DB_ARTICLE_CATS_2' in /home/szopienice/domains/rada.szopienice.eu/public_html/articles2.php on line 70
Table 'szopienice_rada.DB_ARTICLE_CATS_2' doesn't exist
Jak rozwi?za? ten problem?
Mam nadziej?, ?e chodzi?o o to:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: articles.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."protokoly.php";
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['article_id']) && isnum($_GET['article_id'])) {
$result = dbquery(
"SELECT ta.*,tac.*, tu.user_id,user_name FROM ".DB_ARTICLES_2." ta
INNER JOIN ".DB_ARTICLE_CATS_2." tac ON ta.article_cat=tac.article_cat_id
LEFT JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id
WHERE ".groupaccess('article_cat_access')." AND article_id='".$_GET['article_id']."' AND article_draft='0'"
);
if (dbrows($result)) {
require_once INCLUDES."comments_include.php";
require_once INCLUDES."ratings_include.php";
$data = dbarray($result);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($_GET['rowstart'] == 0) { $result = dbquery("UPDATE ".DB_ARTICLES_2." SET article_reads=article_reads+1 WHERE article_id='".$_GET['article_id']."'"); }
$article = stripslashes($data['article_article']);
if (ereg('<--PAGEBREAK-->', $article)) {
$article = explode("<--PAGEBREAK-->", $article);
} else {
$article = explode("<!-- pagebreak -->", $article);
}
$pagecount = count($article);
$article_subject = stripslashes($data['article_subject']);
$article_info = array(
"article_id" => $data['article_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"article_date" => $data['article_datestamp'],
"article_breaks" => $data['article_breaks'],
"article_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='A2' AND comment_item_id='".$data['article_id']."'"),
"article_reads" => $data['article_reads'],
"article_allow_comments" => $data['article_allow_comments']
);
add_to_title($locale['global_201'].$article_subject);
echo "<!--pre_article-->";
render_article($article_subject, $article[$_GET['rowstart']], $article_info);
echo "<!--sub_article-->";
if ($pagecount > 1) {
echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?article_id=".$_GET['article_id']."&")."\n</div>\n";
}
if ($data['article_allow_comments']) { showcomments("A2", DB_ARTICLES_2, "article_id", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); }
if ($data['article_allow_ratings']) { showratings("A2", $_GET['article_id'], FUSION_SELF."?article_id=".$_GET['article_id']); }
} else {
redirect(FUSION_SELF);
}
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) {
opentable($locale['400']);
echo "<!--pre_article_idx-->\n";
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS_2." WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name");
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }
$num = dbcount("(article_cat)", DB_ARTICLES_2, "article_cat='".$data['article_cat_id']."' AND article_draft='0'");
echo "<td valign='top' width='50%' class='tbl article_idx_cat_name'><!--article_idx_cat_name--><a href='".FUSION_SELF."?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a> <span class='small2'>($num)</span>";
if ($data['article_cat_description'] != "") { echo "<br />\n<span class='small'>".$data['article_cat_description']."</span>"; }
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
} else {
echo "<div style='text-align:center'><br />\n".$locale['401']."<br /><br />\n</div>\n";
}
echo "<!--sub_article_idx-->\n";
closetable();
} else {
$res = 0;
$result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS_2." WHERE article_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['article_cat_access'])) {
$res = 1;
add_to_title($locale['global_201'].$cdata['article_cat_name']);
opentable($locale['400'].": ".$cdata['article_cat_name']);
echo "<!--pre_article_cat-->";
$rows = dbcount("(article_id)", DB_ARTICLES_2, "article_cat='".$_GET['cat_id']."' AND article_draft='0'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery(
"SELECT ta.article_id, ta.article_subject, ta.article_snippet, ta.article_datestamp FROM ".DB_ARTICLES_2." ta
WHERE article_cat='".$_GET['cat_id']."' AND article_draft='0' ORDER BY ".$cdata['article_cat_sorting']." LIMIT ".$_GET['rowstart'].",15"
);
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " <span class='small'>[".$locale['402']."]</span>";
} else {
$new = "";
}
echo "<a href='".FUSION_SELF."?article_id=".$data['article_id']."'>".$data['article_subject']."</a>$new<br />\n".stripslashes($data['article_snippet']);
echo ($i != $numrows ? "<br /><br />\n" : "\n"); $i++;
}
echo "<!--sub_article_cat-->";
closetable();
if ($rows > 15) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n</div>\n";
} else {
echo "<div style='text-align:center'>".$locale['403']."</div>\n";
echo "<!--sub_article_cat-->";
closetable();
}
}
}
if ($res == 0) { redirect(FUSION_SELF); }
}
require_once THEMES."templates/footer.php";
?>
A tu wycinek z tabeli z bazy:
SELECT *
FROM `fusion_radaarticle_cats2`
LIMIT 0 , 30
Nie chodzi o to. Po prostu nie zdefiniowa?e? tabeli.
Dodajesz w multisite_include.php który znajduje si? w includesach to:
define("DB_ARTICLE_CATS_2", DB_PREFIX."radaarticle_cats2");
Kliknij i zaczekaj na załadowanie kodu ...
|
| |
|
|
| Ashnah |
Dodany dnia 13.04.2011 10:00:50
|
Przedszkolak
Postów: 26
Pomógł: 1
Ostrzeżeń: 1
v7.01.05
Data rejestracji: 10.09.2009 12:13
|
Sklonowa?am artyku?y dla v7.01.05.
Wrzucam paczk?, gdyby kto? potrzebowa?.
Dodaj?c wpis do bazy zmieni?am w tabeli articles2 wielko?? pola article_article z TEXT na LONGTEXT. Reszta jak w opisie do plików.
Edytowane przez Ashnah dnia 17.04.2011 15:14:57
Nigdy nie mo?na ustali? z pewno?ci? gdzie w kobiecie ko?czy si? Anio? a zaczyna Diabe? |
| |
|
|
| jbork |
Dodany dnia 27.06.2011 22:29:23
|
Przedszkolak
Postów: 31
Data rejestracji: 28.04.2008 13:52
|
A ma kto? sklonowane artyku?y dla v.7.02.02?
I jeszcze jedno. Prawie wszystko jest ok, ale tam gdzie powinna si? pojawi? rozszerzona tre?? artyku?u, nad nag?ówkiem wyskakuje mi co? takiego.
Table 'jmbork_2.DB_ERRORS' doesn't existTable 'jmbork_2.DB_ERRORS' doesn't exist
Mo?e kto? podpowie czemu to si? "drze"? Czy to ma co? wspólnego z brakiem kompatybilno?ci tych artów z v. 7.02.02? Na wszystkich wcze?niejszych wersjach 7.00.xx by?o OK a teraz mi ten nag?ówek wyskakuje. Ciekawe jest to, ?e tekst si? wy?wietla a w dzienniku b??dów pojawia si? to:
Table 'jmbork_2.DB_ERRORS' doesn't existTable 'jmbork_2.DB_ERRORS' doesn't existTable 'jmbork_2.DB_ERRORS' doesn't exist
Brak b??dów w dzienniku.
Co przeoczy?em?
Edytowane przez jbork dnia 27.06.2011 23:47:24
|
| |
|
|
| SamOn |
Dodany dnia 30.06.2011 07:16:18
|
Przedszkolak
Postów: 3
Data rejestracji: 20.05.2011 16:32
|
Wi?c tak chcia?em sklonowa? plik article.php i reszt? od niego które pliki musia? bym jeszcze zmieni? pozmienia?em (znalaz?em na forum ju? temat o tym ale by? na starsz? wersje, a nie chcia?em wyci?ga? starych tematów)
articel.php(u mnie si? zwie anime.php)
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: anime.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.or...agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."anime.php";
# Breadcrumbs
# Original Code from Rizald "Elyn" Maxwell
# Rewritten for 7.02 by MarcusG
$isTrue = false;
$str = "";
if (isset($_GET['anime_id'])&& isnum($_GET['anime_id'])){
$result = dbquery(
"SELECT ta.anime_cat, tac.anime_cat_name, ta.anime_id, ta.anime_subject FROM ".DB_anime." ta
LEFT JOIN ".DB_ANIME_CATS." tac ON ta.anime_cat=tac.anime_cat_id
WHERE anime_id='".$_GET['anime_id']."'"
);
if (dbrows($result)) {
$data = dbarray($result);
$str .= "<a href='".FUSION_SELF."'><strong>".$locale['404']."</strong></a>";
$str .= " » <a href='".FUSION_SELF."?cat_id=".$data['anime_cat']."'>".$data['anime_cat_name']."</a>";
$str .= " » <a href='".FUSION_SELF."?anime_id=".$_GET['anime_id']."'>".$data['anime_subject']."</a>";
$isTrue = true;
}
} elseif (isset($_GET['cat_id']) && isnum($_GET['cat_id'])){
$result = dbquery(
"SELECT anime_cat_name FROM ".DB_anime_CATS."
WHERE anime_cat_id='".$_GET['cat_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$str .= "<a href='".FUSION_SELF."'><strong>".$locale['404']."</strong></a>";
$str .= " » <a href='".FUSION_SELF."?cat_id=".$_GET['cat_id']."'>".$data['anime_cat_name']."</a>";
$isTrue = true;
}
}
if($isTrue){
opentable($locale['405']);
echo $str;
closetable();
}
# end of breadcrumbs
add_to_title($locale['global_200'].$locale['400']);
if (isset($_GET['anime_id']) && isnum($_GET['anime_id'])) {
$result = dbquery(
"SELECT ta.anime_subject, ta.anime_anime, ta.anime_breaks,
ta.anime_datestamp, ta.anime_reads, ta.anime_allow_comments, ta.anime_allow_ratings,
tac.anime_cat_id, tac.anime_cat_name,
tu.user_id, tu.user_name, tu.user_status
FROM ".DB_anime." ta
INNER JOIN ".DB_anime_CATS." tac ON ta.anime_cat=tac.anime_cat_id
LEFT JOIN ".DB_USERS." tu ON ta.anime_name=tu.user_id
WHERE ".groupaccess('anime_cat_access')." AND anime_id='".$_GET['anime_id']."' AND anime_draft='0'"
);
if (dbrows($result)) {
require_once INCLUDES."comments_include.php";
require_once INCLUDES."ratings_include.php";
$data = dbarray($result);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($_GET['rowstart'] == 0) { $result = dbquery("UPDATE ".DB_anime." SET anime_reads=anime_reads+1 WHERE anime_id='".$_GET['anime_id']."'"); }
$anime = stripslashes($data['anime_anime']);
if (preg_match('<--PAGEBREAK-->', $anime)) {
$anime = explode("<--PAGEBREAK-->", $anime);
} else {
$anime = explode("<!-- pagebreak -->", $anime);
}
$pagecount = count($anime);
$anime_subject = stripslashes($data['anime_subject']);
$anime_info = array(
"anime_id" => $_GET['anime_id'],
"cat_id" => $data['anime_cat_id'],
"cat_name" => $data['anime_cat_name'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"user_status" => $data['user_status'],
"anime_date" => $data['anime_datestamp'],
"anime_breaks" => $data['anime_breaks'],
"anime_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='A' AND comment_item_id='".$_GET['anime_id']."'"),
"anime_reads" => $data['anime_reads'],
"anime_allow_comments" => $data['anime_allow_comments']
);
add_to_title($locale['global_201'].$anime_subject);
echo "<!--pre_anime-->";
render_anime($anime_subject, $anime[$_GET['rowstart']], $anime_info);
echo "<!--sub_anime-->";
if ($pagecount > 1) {
echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?anime_id=".$_GET['anime_id']."&")."\n</div>\n";
}
if ($data['anime_allow_comments']) { showcomments("A", DB_anime, "anime_id", $_GET['anime_id'], FUSION_SELF."?anime_id=".$_GET['anime_id']); }
if ($data['anime_allow_ratings']) { showratings("A", $_GET['anime_id'], FUSION_SELF."?anime_id=".$_GET['anime_id']); }
} else {
redirect(FUSION_SELF);
}
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) {
opentable($locale['400']);
echo "<!--pre_anime_idx-->\n";
//$result = dbquery("SELECT anime_cat_id, anime_cat_name, anime_cat_description FROM ".DB_anime_CATS." WHERE ".groupaccess('anime_cat_access')." ORDER BY anime_cat_name");
// NEW QUERY
$result = dbquery(
"SELECT ac.anime_cat_id, ac.anime_cat_name, ac.anime_cat_description, COUNT(a.anime_cat) AS anime_count FROM ".DB_anime." a
LEFT JOIN ".DB_anime_CATS." ac ON a.anime_cat=ac.anime_cat_id
WHERE ".groupaccess('ac.anime_cat_access')."
GROUP BY ac.anime_cat_id
ORDER BY ac.anime_cat_name"
);
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }
//$num = dbcount("(anime_cat)", DB_anime, "anime_cat='".$data['anime_cat_id']."' AND anime_draft='0'");
echo "<td valign='top' width='50%' class='tbl anime_idx_cat_name'><!--anime_idx_cat_name--><a href='".FUSION_SELF."?cat_id=".$data['anime_cat_id']."'>".$data['anime_cat_name']."</a> <span class='small2'>(".$data['anime_count'].")</span>";
if ($data['anime_cat_description'] != "") { echo "<br />\n<span class='small'>".$data['anime_cat_description']."</span>"; }
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
} else {
echo "<div style='text-align:center'><br />\n".$locale['401']."<br /><br />\n</div>\n";
}
echo "<!--sub_anime_idx-->\n";
closetable();
} else {
$res = 0;
$result = dbquery("SELECT anime_cat_name, anime_cat_sorting, anime_cat_access FROM ".DB_anime_CATS." WHERE anime_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['anime_cat_access'])) {
$res = 1;
add_to_title($locale['global_201'].$cdata['anime_cat_name']);
opentable($locale['400'].": ".$cdata['anime_cat_name']);
echo "<!--pre_anime_cat-->";
$rows = dbcount("(anime_id)", DB_anime, "anime_cat='".$_GET['cat_id']."' AND anime_draft='0'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery(
"SELECT anime_id, anime_subject, anime_snippet, anime_datestamp FROM ".DB_anime."
WHERE anime_cat='".$_GET['cat_id']."' AND anime_draft='0' ORDER BY ".$cdata['anime_cat_sorting']." LIMIT ".$_GET['rowstart'].",".$settings['anime_per_page']
);
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
$class = ($i%2 ? "tbl1" : "tbl2");
if ($data['anime_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " <span class='small' style='color:green;'>[".$locale['402']."]</span>";
} else {
$new = "";
}
echo "<div class='".$class."'><strong><a href='".FUSION_SELF."?anime_id=".$data['anime_id']."'>".$data['anime_subject']."</a></strong>".$new."<br />\n".stripslashes($data['anime_snippet'])."</div>";
echo ($i != $numrows ? "<hr />\n" : "\n"); $i++;
}
echo "<!--sub_anime_cat-->";
closetable();
if ($rows > $settings['anime_per_page']) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'], $settings['anime_per_page'], $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n</div>\n";
} else {
echo "<div style='text-align:center'>".$locale['403']."</div>\n";
echo "<!--sub_anime_cat-->";
closetable();
}
}
}
if ($res == 0) { redirect(FUSION_SELF); }
}
require_once THEMES."templates/footer.php";
?>Kliknij i zaczekaj na załadowanie kodu ...
administrator/articles.php (u mnie si? zwie anime.php)
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: animes.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.or...agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";
if (!checkrights("A") || !defined("iAUTH") || !isset($_GET['aid']) || $_GET['aid'] != iAUTH) { redirect("../index.php"); }
require_once THEMES."templates/admin_header_mce.php";
include LOCALE.LOCALESET."admin/animes.php";
if ($settings['tinymce_enabled'] == 1) {
echo "<script language='javascript' type='text/javascript'>advanced();</script>\n";
} else {
require_once INCLUDES."html_buttons_include.php";
}
if (isset($_GET['status']) && !isset($message)) {
if ($_GET['status'] == "sn") {
$message = $locale['410'];
} elseif ($_GET['status'] == "su") {
$message = $locale['411'];
} elseif ($_GET['status'] == "del") {
$message = $locale['412'];
}
if ($message) { echo "<div id='close-message'><div class='admin-message'>".$message."</div></div>\n"; }
}
$result = dbcount("(anime_cat_id)", DB_anime_CATS);
if (!empty($result)) {
if (isset($_POST['save'])) {
$subject = stripinput($_POST['subject']);
$body = addslash($_POST['body']);
$body2 = addslash($_POST['body2']);
$draft = isset($_POST['anime_draft']) ? "1" : "0";
if ($settings['tinymce_enabled'] != 1) { $breaks = isset($_POST['line_breaks']) ? "y" : "n"; } else { $breaks = "n"; }
$comments = isset($_POST['anime_comments']) ? "1" : "0";
$ratings = isset($_POST['anime_ratings']) ? "1" : "0";
if (isset($_POST['anime_id']) && isnum($_POST['anime_id'])) {
$result = dbquery("UPDATE ".DB_animeS." SET anime_cat='".intval($_POST['anime_cat'])."', anime_subject='$subject', anime_snippet='$body', anime_anime='$body2', anime_draft='$draft', anime_breaks='$breaks', anime_allow_comments='$comments', anime_allow_ratings='$ratings' WHERE anime_id='".$_POST['anime_id']."'");
redirect(FUSION_SELF.$aidlink."&status=su");
} else {
$result = dbquery("INSERT INTO ".DB_animeS." (anime_cat, anime_subject, anime_snippet, anime_anime, anime_draft, anime_breaks, anime_name, anime_datestamp, anime_reads, anime_allow_comments, anime_allow_ratings) VALUES ('".intval($_POST['anime_cat'])."', '$subject', '$body', '$body2', '$draft', '$breaks', '".$userdata['user_id']."', '".time()."', '0', '$comments', '$ratings')");
redirect(FUSION_SELF.$aidlink."&status=sn");
}
} else if (isset($_POST['delete']) && (isset($_POST['anime_id']) && isnum($_POST['anime_id']))) {
$result = dbquery("DELETE FROM ".DB_animeS." WHERE anime_id='".$_POST['anime_id']."'");
$result = dbquery("DELETE FROM ".DB_COMMENTS." WHERE comment_item_id='".$_POST['anime_id']."' and comment_type='A'");
$result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_item_id='".$_POST['anime_id']."' and rating_type='A'");
redirect(FUSION_SELF.$aidlink."&status=del");
} else {
if (isset($_POST['preview'])) {
$anime_cat = $_POST['anime_cat'];
$subject = stripinput($_POST['subject']);
$body = phpentities(stripslash($_POST['body']));
$body2 = phpentities(stripslash($_POST['body2']));
$bodypreview = str_replace("src='".str_replace("../", "", IMAGES_A), "src='".IMAGES_A, stripslash($_POST['body']));
$body2preview = str_replace("src='".str_replace("../", "", IMAGES_A), "src='".IMAGES_A, stripslash($_POST['body2']));
$draft = isset($_POST['anime_draft']) ? " checked='checked'" : "";
if (isset($_POST['line_breaks'])) {
$breaks = " checked='checked'";
$bodypreview = nl2br($bodypreview);
$body2preview = nl2br($body2preview);
} else {
$breaks = "";
}
$comments = isset($_POST['anime_comments']) ? " checked='checked'" : "";
$ratings = isset($_POST['anime_ratings']) ? " checked='checked'" : "";
opentable($subject);
echo $bodypreview."\n";
closetable();
opentable($subject);
echo $body2preview."\n";
closetable();
}
$result = dbquery("SELECT anime_id, anime_subject, anime_draft FROM ".DB_animeS." ORDER BY anime_draft DESC, anime_datestamp DESC");
if (dbrows($result)) {
$editlist = ""; $sel = "";
while ($data = dbarray($result)) {
if ((isset($_POST['anime_id']) && isnum($_POST['anime_id'])) || (isset($_GET['anime_id']) && isnum($_GET['anime_id']))) {
$anime_id = isset($_POST['anime_id']) ? $_POST['anime_id'] : $_GET['anime_id'];
$sel = ($anime_id == $data['anime_id'] ? " selected='selected'" : "");
} else {
$sel = "";
}
$editlist .= "<option value='".$data['anime_id']."'".$sel.">".($data['anime_draft'] ? $locale['433']." " : "").$data['anime_subject']."</option>\n";
}
opentable($locale['402']);
echo "<div style='text-align:center'>\n<form name='selectform' method='post' action='".FUSION_SELF.$aidlink."&action=edit'>\n";
echo "<select name='anime_id' class='textbox' style='width:250px;'>\n".$editlist."</select>\n";
echo "<input type='submit' name='edit' value='".$locale['420']."' class='button' />\n";
echo "<input type='submit' name='delete' value='".$locale['421']."' onclick='return Deleteanime();' class='button' />\n";
echo "</form>\n</div>\n";
closetable();
}
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_POST['anime_id']) && isnum($_POST['anime_id'])) || (isset($_GET['anime_id']) && isnum($_GET['anime_id']))) {
$result = dbquery("SELECT anime_cat, anime_subject, anime_snippet, anime_anime, anime_draft, anime_breaks, anime_allow_comments, anime_allow_ratings FROM ".DB_animeS." WHERE anime_id='".(isset($_POST['anime_id']) ? $_POST['anime_id'] : $_GET['anime_id'])."'");
if (dbrows($result)) {
$data = dbarray($result);
$anime_cat = $data['anime_cat'];
$subject = $data['anime_subject'];
$body = phpentities(stripslashes($data['anime_snippet']));
$body2 = phpentities(stripslashes($data['anime_anime']));
$draft = $data['anime_draft'] ? " checked='checked'" : "";
$breaks = $data['anime_breaks'] == "y" ? " checked='checked'" : "";
$comments = $data['anime_allow_comments'] ? " checked='checked'" : "";
$ratings = $data['anime_allow_ratings'] ? " checked='checked'" : "";
} else {
redirect(FUSION_SELF.$aidlink);
}
}
if ((isset($_POST['anime_id']) && isnum($_POST['anime_id'])) || (isset($_GET['anime_id']) && isnum($_GET['anime_id']))) {
opentable($locale['401']);
} else {
if (!isset($_POST['preview'])) {
$subject = "";
$body = "";
$body2 = "";
$draft = "";
$breaks = " checked='checked'";
$comments = " checked='checked'";
$ratings = " checked='checked'";
}
opentable($locale['400']);
}
$result = dbquery("SELECT anime_cat_id, anime_cat_name FROM ".DB_anime_CATS." ORDER BY anime_cat_name DESC");
$catlist = ""; $sel = "";
while ($data = dbarray($result)) {
if (isset($anime_cat)) $sel = ($anime_cat == $data['anime_cat_id'] ? " selected='selected'" : "");
$catlist .= "<option value='".$data['anime_cat_id']."'$sel>".$data['anime_cat_name']."</option>\n";
}
echo "<form name='inputform' method='post' action='".FUSION_SELF.$aidlink."' onsubmit='return ValidateForm(this)'>\n";
echo "<table cellpadding='0' cellspacing='0' class='center'>\n<tr>\n";
echo "<td width='100' class='tbl'>".$locale['422']."</td>\n";
echo "<td class='tbl'><select name='anime_cat' class='textbox' style='width:250px;'>".$catlist."</select></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='100' class='tbl'>".$locale['423']."</td>\n";
echo "<td class='tbl'><input type='text' name='subject' value='$subject' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td valign='top' width='100' class='tbl'>".$locale['424']."</td>\n";
echo "<td class='tbl'><textarea name='body' cols='95' rows='5' class='textbox' style='width:98%'>".$body."</textarea></td>\n";
echo "</tr>\n";
if ($settings['tinymce_enabled'] != 1) {
echo "<tr>\n<td class='tbl'></td>\n<td class='tbl'>\n";
echo display_html("inputform", "body", true, true, true, IMAGES_A);
echo "</td>\n</tr>\n";
}
echo "<tr>\n<td valign='top' width='100' class='tbl'>".$locale['425']."</td>\n";
echo "<td class='tbl'><textarea name='body2' cols='95' rows='10' class='textbox' style='width:98%'>".$body2."</textarea></td>\n";
echo "</tr>\n";
if ($settings['tinymce_enabled'] != 1) {
echo "<tr>\n<td class='tbl'></td><td class='tbl'>\n";
echo "<input type='button' value='".$locale['432']."' class='button' style='width:80px;' onclick=\"insertText('body2', '<--PAGEBREAK-->');\" />\n";
echo display_html("inputform", "body2", true, true, true, IMAGES_A);
echo "</td>\n</tr>\n";
}
echo "<tr>\n";
echo "<td class='tbl'></td><td class='tbl'>\n";
echo "<label><input type='checkbox' name='anime_draft' value='yes'".$draft." /> ".$locale['426']."</label><br />\n";
if ($settings['tinymce_enabled'] != 1) { echo "<label><input type='checkbox' name='line_breaks' value='yes'".$breaks." /> ".$locale['427']."</label><br />\n"; }
echo "<label><input type='checkbox' name='anime_comments' value='yes'".$comments." /> ".$locale['428']."</label>";
if ($settings['comments_enabled'] == "0") {
echo "<span style='color:red;font-weight:bold;margin-left:3px;'>*</span>";
}
echo "<br />\n";
echo "<label><input type='checkbox' name='anime_ratings' value='yes'".$ratings." /> ".$locale['429']."</label>";
if ($settings['ratings_enabled'] == "0") {
echo "<span style='color:red;font-weight:bold;margin-left:3px;'>*</span>";
}
echo "</td>\n";
echo "</tr>\n";
if ($settings['comments_enabled'] == "0" || $settings['ratings_enabled'] == "0") {
$sys = "";
if ($settings['comments_enabled'] == "0" && $settings['ratings_enabled'] == "0") {
$sys = $locale['459'];
} elseif ($settings['comments_enabled'] == "0") {
$sys = $locale['457'];
} else {
$sys = $locale['458'];
}
echo "<tr>\n<td colspan='2' class='tbl1' style='font-weight:bold;text-align:left; color:black !important; background-color:#FFDBDB;'>";
echo "<span style='color:red;font-weight:bold;margin-right:5px;'>*</span>".sprintf($locale['456'], $sys);
echo "</td>\n</tr>";
}
echo "<tr>\n";
echo "<td align='center' colspan='2' class='tbl'><br />\n";
if ((isset($_POST['anime_id']) && isnum($_POST['anime_id'])) || (isset($_GET['anime_id']) && isnum($_GET['anime_id']))) {
echo "<input type='hidden' name='anime_id' value='".(isset($_POST['anime_id']) ? $_POST['anime_id'] : $_GET['anime_id'])."' />\n";
}
echo "<input type='submit' name='preview' value='".$locale['430']."' class='button' />\n";
echo "<input type='submit' name='save' value='".$locale['431']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
echo "<script type='text/javascript'>\n";
echo "/* <![CDATA[ */\n";
echo "function Deleteanime() {\n";
echo "return confirm('".$locale['451']."');\n}\n";
echo "function ValidateForm(frm) {"."\n"."if(frm.subject.value=='') {\n";
echo "alert('".$locale['450']."');"."\n"."return false;\n}\n}\n";
echo "/* ]]>*/\n";
echo "</script>\n";
}
} else {
opentable($locale['403']);
echo "<div style='text-align:center'>".$locale['452']."<br />\n".$locale['453']."<br />\n";
echo "<a href='anime_cats.php".$aidlink."'>".$locale['454']."</a>".$locale['455']."</div>\n";
closetable();
}
require_once THEMES."templates/footer.php";
?>Kliknij i zaczekaj na załadowanie kodu ...
administrator/article_cats.php (u mnie si? zwie anime_cats.php)
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: anime_cats.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.or...agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";
if (!checkRights("AC") || !defined("iAUTH") || !isset($_GET['aid']) || $_GET['aid'] != iAUTH) { redirect("../index.php"); }
require_once THEMES."templates/admin_header.php";
include LOCALE.LOCALESET."admin/anime-cats.php";
if (isset($_GET['status']) && !isset($message)) {
if ($_GET['status'] == "sn") {
$message = $locale['410'];
} elseif ($_GET['status'] == "su") {
$message = $locale['411'];
} elseif ($_GET['status'] == "deln") {
$message = $locale['412']."<br />\n<span class='small'>".$locale['413']."</span>";
} elseif ($_GET['status'] == "dely") {
$message = $locale['414'];
}
if ($message) { echo "<div id='close-message'><div class='admin-message'>".$message."</div></div>\n"; }
}
if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {
$result = dbcount("(anime_id)", DB_animeS, "anime_cat='".$_GET['cat_id']."'");
if (!empty($result)) {
redirect(FUSION_SELF.$aidlink."&status=deln");
} else {
$result = dbquery("DELETE FROM ".DB_anime_CATS." WHERE anime_cat_id='".$_GET['cat_id']."'");
redirect(FUSION_SELF.$aidlink."&status=dely");
}
} else {
if (isset($_POST['save_cat'])) {
$cat_name = stripinput(trim($_POST['cat_name']));
$cat_description = stripinput(trim($_POST['cat_description']));
$cat_access = isnum($_POST['cat_access']) ? $_POST['cat_access'] : "0";
if (isnum($_POST['cat_sort_by']) && $_POST['cat_sort_by'] == "1") {
$cat_sorting = "anime_id ".($_POST['cat_sort_order'] == "ASC" ? "ASC" : "DESC");
} else if (isnum($_POST['cat_sort_by']) && $_POST['cat_sort_by'] == "2") {
$cat_sorting = "anime_subject ".($_POST['cat_sort_order'] == "ASC" ? "ASC" : "DESC");
} else if (isnum($_POST['cat_sort_by']) && $_POST['cat_sort_by'] == "3") {
$cat_sorting = "anime_datestamp ".($_POST['cat_sort_order'] == "ASC" ? "ASC" : "DESC");
} else {
$cat_sorting = "anime_subject ASC";
}
if ($cat_name) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {
$result = dbquery("UPDATE ".DB_anime_CATS." SET anime_cat_name='$cat_name', anime_cat_description='$cat_description', anime_cat_sorting='$cat_sorting', anime_cat_access='$cat_access' WHERE anime_cat_id='".$_GET['cat_id']."'");
redirect(FUSION_SELF.$aidlink."&status=su");
} else {
$checkCat = dbcount("(anime_cat_id)", DB_anime_CATS, "anime_cat_name='".$cat_name."'");
if ($checkCat == 0) {
$result = dbquery("INSERT INTO ".DB_anime_CATS." (anime_cat_name, anime_cat_description, anime_cat_sorting, anime_cat_access) VALUES ('$cat_name', '$cat_description', '$cat_sorting', '$cat_access')");
redirect(FUSION_SELF.$aidlink."&status=sn");
} else {
$error = 2;
}
}
} else {
$error = 1;
}
}
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {
$result = dbquery("SELECT anime_cat_name, anime_cat_description, anime_cat_sorting, anime_cat_access FROM ".DB_anime_CATS." WHERE anime_cat_id='".$_GET['cat_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$cat_name = $data['anime_cat_name'];
$cat_description = $data['anime_cat_description'];
$cat_sorting = explode(" ", $data['anime_cat_sorting']);
if ($cat_sorting[0] == "anime_id") { $cat_sort_by = "1"; }
if ($cat_sorting[0] == "anime_subject") { $cat_sort_by = "2"; }
if ($cat_sorting[0] == "anime_datestamp") { $cat_sort_by = "3"; }
$cat_sort_order = $cat_sorting[1];
$cat_access = $data['anime_cat_access'];
$formaction = FUSION_SELF.$aidlink."&action=edit&cat_id=".$_GET['cat_id'];
$openTable = $locale['401'];
} else {
redirect(FUSION_SELF.$aidlink);
}
} else {
$cat_name = "";
$cat_description = "";
$cat_sort_by = "2";
$cat_sort_order = "ASC";
$cat_access = "";
$formaction = FUSION_SELF.$aidlink;
$openTable = $locale['400'];
}
$user_groups = getusergroups(); $access_opts = ""; $sel = "";
while(list($key, $user_group) = each($user_groups)){
$sel = ($cat_access == $user_group['0'] ? " selected='selected'" : "");
$access_opts .= "<option value='".$user_group['0']."'$sel>".$user_group['1']."</option>\n";
}
if (isset($error) && isnum($error)) {
if ($error == 1) {
$errorMessage = $locale['460'];
} elseif ($error == 2) {
$errorMessage = $locale['461'];
}
if ($errorMessage) { echo "<div id='close-message'><div class='admin-message'>".$errorMessage."</div></div>\n"; }
}
opentable($openTable);
echo "<form name='addcat' method='post' action='$formaction'>\n";
echo "<table cellpadding='0' cellspacing='0' width='400' class='center'>\n<tr>\n";
echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['420']."</td>\n";
echo "<td class='tbl'><input type='text' name='cat_name' value='".$cat_name."' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['421']."</td>\n";
echo "<td class='tbl'><input type='text' name='cat_description' value='".$cat_description."' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['422']."</td>\n";
echo "<td class='tbl'><select name='cat_sort_by' class='textbox'>\n";
echo "<option value='1'".($cat_sort_by == "1" ? " selected='selected'" : "").">".$locale['423']."</option>\n";
echo "<option value='2'".($cat_sort_by == "2" ? " selected='selected'" : "").">".$locale['424']."</option>\n";
echo "<option value='3'".($cat_sort_by == "3" ? " selected='selected'" : "").">".$locale['425']."</option>\n";
echo "</select>\n<select name='cat_sort_order' class='textbox'>\n";
echo "<option value='ASC'".($cat_sort_order == "ASC" ? " selected='selected'" : "").">".$locale['426']."</option>\n";
echo "<option value='DESC'".($cat_sort_order == "DESC" ? " selected='selected'" : "").">".$locale['427']."</option>\n";
echo "</select></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['428']."</td>\n";
echo "<td class='tbl'><select name='cat_access' class='textbox'>\n".$access_opts."</select></td>\n";
echo "</tr>\n<tr>\n";
echo "<td align='center' colspan='2' class='tbl'>\n";
echo "<input type='submit' name='save_cat' value='".$locale['429']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
opentable($locale['402']);
echo "<table cellpadding='0' cellspacing='1' width='400' class='tbl-border center'>\n";
$result = dbquery("SELECT anime_cat_id, anime_cat_name, anime_cat_description, anime_cat_access FROM ".DB_anime_CATS." ORDER BY anime_cat_name");
if (dbrows($result) != 0) {
$i = 0;
echo "<tr>\n";
echo "<td class='tbl2'>".$locale['440']."</td>\n";
echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>".$locale['441']."</td>\n";
echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>".$locale['442']."</td>\n";
echo "</tr>\n";
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2");
echo "<tr>\n";
echo "<td class='$cell_color'><strong>".$data['anime_cat_name']."</strong>\n";
if ($data['anime_cat_description']) { echo "<br /><span class='small'>".trimlink($data['anime_cat_description'], 45)."</span></td>\n"; }
echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getgroupname($data['anime_cat_access'])."</td>\n";
echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'><a href='".FUSION_SELF.$aidlink."&action=edit&cat_id=".$data['anime_cat_id']."'>".$locale['443']."</a> -\n";
echo "<a href='".FUSION_SELF.$aidlink."&action=delete&cat_id=".$data['anime_cat_id']."' onclick=\"return confirm('".$locale['450']."');\">".$locale['444']."</a></td>\n";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
} else {
echo "<tr><td align='center' class='tbl1'>".$locale['445']."</td></tr>\n</table>\n";
}
closetable();
}
require_once THEMES."templates/footer.php";
?>Kliknij i zaczekaj na załadowanie kodu ...
Co? jeszcze powinienem zmieni??
I jak mam to doda? do tych funkcji jak "Dodaj newsa"?
B?d? bardzo wdzi?czny za pomoc.
PW od moderatora:
- Przeniesienie posta - khaman 30.06 - 07:16
|
| |
|
|
| proton |
Dodany dnia 30.06.2011 17:56:08
|
Bywalec
Postów: 945
Pomógł: 22
Data rejestracji: 10.11.2005 18:29
|
Musisz jeszcze, zrobi? kilka rzeczy, je?li tego oczywi?cie ju? nie zrobi?e?:
1. Doda? locale (pliki j?zykowe): locale/twoj_jezyk/admin/anime.php i locale/twoj_jezyk/anime.php
2. Doda? przede wszystkim dodatkowe dwie tabele w bazie danych
3. Doda? dodatkow? sta?? w includes/multiside_include.php (DB_animeS)
4. "I jak mam to doda? do tych funkcji jak "Dodaj newsa"?" rozumiem ?e chodzi o Panel Admina? Dodaj jeszcze do tabeli prefiks_admin dodatkowy rekord dla tego anime.
Wszystko rób na przyk?adzie tych artyku?ów.
|
| |
|
|
| zukos82 |
Dodany dnia 21.09.2012 20:34:57
|
Przedszkolak
Postów: 5
v7.02.05
Data rejestracji: 21.09.2012 20:27
|
A ma kto? sklonowane artyku?y dla v.7.02.02?
I jeszcze jedno. Prawie wszystko jest ok, ale tam gdzie powinna si? pojawi? rozszerzona tre?? artyku?u, nad nag?ówkiem wyskakuje mi co? takiego.
Table 'jmbork_2.DB_ERRORS' doesn't existTable 'jmbork_2.DB_ERRORS' doesn't exist
Co przeoczy?em?
Czy kto? móg?by mi w tym pomóc?
Bardzo prosz?.
|
| |
|
Rozwiń Kod źródłowy PHP