[CMS system] dededecms data archiving cannot read the bound level 2 domain name
0) {$ where = "and typeid = $ tid" ;}$ pagesize = 30; // 30 data records per page by default $ maxpages = 9; // $ pagepre = 4; // use $ pageno = isset ($ _ GET ["pageno"]) for pagination? Intval ($ _ GET ["pageno"]): 1; $ csql = "select count (*) as c from #@__ archives, ##__ arctype where pubdate> $ starttime and pubdate <$ endtime $ where AND ##__ arctype. id =#@__ archives. typeid "; $ crow = $ db-> GetOne ($ csql); $ GLOBALS ['datacount'] = $ datacount = $ crow ['c']; // total number of bars $ startrow = ($ pageno-1) * $ pagesize; // start number $ rili = rili ($ date, '', true, $ db ); if ($ datacount> 0) // Obtain the page number {$ maxpage = $ datacount % $ pagesize; // if ($ ma Xpage> 0) {$ maxpage = ceil ($ datacount/$ pagesize);} else {$ maxpage = $ datacount/$ pagesize; // obtain the total number of pages} else {$ maxpage = 0;} if ($ pageno> $ maxpage & $ maxpage! = 0) {echo "script" alert ('It seems that there are not so many pages of data! '); History. go (-1); script "; exit () ;}$ query =" select #@__ archives. id, #@__ archives. pubdate, #@__ archives. title, #@__ archives. senddate, #@__ archives. ismake, #@__ archives. arcrank, #@__ archives. money, #@__ arctype. namerule, #@__ arctype. typedir, #@__ archives. typeid from #@__ archives, #@__ arctype where pubdate> $ starttime and pubdate <$ endtime and ismake = 1 $ where AND ##__ arctype. id =#@__ archives. typeid LIMIT $ startrow, $ pagesize "; $ db-> setquery ($ query); $ db-> execute (); $ list = array (); while ($ row = $ db-> getarray () {$ row ['Time'] = date ('20y-m-d H: I ', $ row ['pubdate']); $ row ['pubdate'] = date ('20ymd', $ row ['pubdate']); $ list [] = $ row;} require_once (dirname (_ FILE __). "/.. /date/date.htm "); function GetArcUrl ($ aid, $ typeid, $ timetag, $ title, $ ismake = 0, $ rank = 0, $ namerule = "", $ artdir = "", $ money = 0) {return GetFileUrl ($ aid, $ typeid, $ timetag, $ title, $ ismake, $ rank, $ namerule, $ artdir, $ money);} function rili ($ date, $ file = '/date/index. php', $ nomax = false, $ db = '') {$ curtime = time (); // Obtain the timestamp if (empty ($ date )) {$ timestamp = $ curtime;} else {$ timestamp = strtotime ($ date);} $ selectedyear = date ('Y', $ timestamp ); $ selectedmonth = date ('N', $ timestamp); $ selectedday = date ('D', $ timestamp ); // specify the day of the week on the first day of the month $ firstday = date ('W', mktime (0, 0, $ selectedmonth, 1, $ selectedyear )); /// The number of days in a given month $ lastday = date ('t', $ timestamp); // The number of days in a given month $ preyear = date ('Y ', mktime (, 0, $ selectedmonth, 0, $ selectedyear); $ nextyear = date ('Y', mktime (, 0, $ selectedmonth, $ lastday + 1, $ selectedyear); $ premonth = date ('N', mktime (, 0, $ selectedmonth, 0, $ selectedyear); $ nextmonth = date ('N ', mktime (, 0, $ selectedmonth, $ lastday + 1, $ selectedyear); $ premonthdays = date ('t', mktime (, 0, 0, $ selectedmonth, 0, $ selectedyear); $ nextmonthdays = date ('t', mktime (0, 0, $ selectedmonth, $ lastday + 1, $ selectedyear )); $ preday = min ($ selectedday, $ premonthdays); $ nextday = min ($ selectedday, $ nextmonthdays); // display the calendar header $ days = array ("day ", "1", "2", "3", "4", "5", "6"); $ months = array ("January", "February ", "August ", "December"); $ monthName = $ months [$ selectedmonth-1]; $ str ="
"; $ Str. ="
<
$ Selectedyear $ monthName"; If ($ nomax & mktime (0, 0, 0, $ nextmonth, 1, $ nextyear) >$ curtime) {$ str. =">
";} Else {$ str. =">";}$ Str. ="
"; For ($ I = 0; $ I <7; $ I ++) {$ str. ="
$ Days [$ I] | ";}$ Str. ="
"; // Specify the position on the first day of the current month. $ I = 0; while ($ I <$ firstday) {$ str. ="
| "; $ I ++;} $ day = 0; while ($ day <$ lastday) {if ($ I % 7) = 0) {$ str. ="
";}$ Day ++; $ I ++; // You can check whether an article exists every day. $ starttime = mktime (, 0, $ selectedmonth, $ day, $ selectedyear ); $ endtime = $ starttime + 86400; $ csql2 = "select count (*) as c from #@__ archives, ##__ arctype where pubdate> $ starttime and pubdate <$ endtime and ismake = 1 $ where AND ##__ arctype. id =#@__ archives. typeid "; $ crow = $ db-> GetOne ($ csql2); $ datacount = $ crow ['c']; // if ($ day = $ selectedday &&! $ Datacount) {$ prevdate = date ('Y-m-D', $ GLOBALS ['articledate']); // if there are no articles from the beginning of the day, if (! $ GLOBALS ['articledate']) {$ csql2 = "select pubdate from #@__ archives, ##__ arctype where pubdate <= $ starttime and ismake = 1 $ where AND ##__ arctype. id =#@__ archives. typeid order by pubdate desc "; $ crow = $ db-> GetOne ($ csql2); $ prevdate = date ('Y-m-D ', $ crow ['pubdate']);} header ("Location: index. php? Date = ". $ prevdate); exit () ;}// if ($ day ==$ selectedday) {$ str. ="
$ Day ($ datacount) | ";} Elseif ($ nomax & mktime (0, 0, $ selectedmonth, $ day, $ selectedyear)> $ curtime) {$ str. ="
$ Day | ";} Elseif ($ datacount) {$ str. ="
$ Day ($ datacount) | "; $ Currenttime = mktime (0, 0, 0, $ selectedmonth, $ selectedday, $ selectedyear); if ($ starttime <= $ currenttime) $ GLOBALS ['articledate'] = $ starttime;} else $ str. ="
$ Day | ";}$ Str. ="
"; Return $ str ;}?>
Reply to discussion (solution)
Please give me some advice.
Please refer to the following link for more information: I have searched Baidu and Google for several days.