/
news.php
executable file
·204 lines (177 loc) · 11.5 KB
/
news.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
<?php echo 'News block module.<br>';// module for dbscript
if ($debug) echo "Starting...loading core...<br>";
// Äàííàÿ ïðîãðàììà îòíîñèòñÿ ê ïàêåòó DBSCRIPT v2.1 (ñ) dj--alex
// Çàêàçíîé ïëàãèí êrequires tbl dbs id ïàêåòó. "Íîâîñòè äëÿ ñàéòà".
if ($_FILES) ob_start(); // äîáàâëåíî ò.ê. â 2033 ñòðîêå íåïîíÿòíî ïðèñëàëè ôàéë âîîáùå èëè íåò
$nomnu=true;
require_once ('dbscore.lib'); // ôóíêöèÿ ïîäãîòîâêè ê ðàáîòå è àâòîðèçàöèè
$nomnu=1;
if (!$activation) exit;
/*
* ×òî çà áëîã? news.php nedit.php - áëîã äëÿ Dbscript
* Èäåíòèôèêàòîð òàáëèöû áëîãà ñîçäàþùåéñÿ ïðè ïåðâîì åãî çàïóñêå, ID ýòîé òàáëèöû èç àëèàñîâ _íóæíî_ ïðîïèñàòü â àäìèíêå
* ïîñëå ýòîãî áëîã áóäåò ðàáîòàòü ñ òàáëèöåé (dbscriptbk._dbs__news43)
* Ïîääåðæèâàåòñÿ ïîêàç íîâîñòåé çà ïîñëåäíèå 15 äíåé ïî óìîë÷àíèþ
* Íîâîñòè âñå ïî óìîë÷àíèþ ñâåðíóòû è ìîãóò áûòü îòêðûòû
* Ðàáîòàþò ùåë÷êè â øàïêå ïî òåãàì , ïî àâòîðàì, è ïîääåðæêà âèäåîïëååðîâ. (ìîæíî çàëèâàòü flv)
* âàæíî: Â ïîêàçå òàáëèöû ïîääåðæèâàþòñÿ HTML òåãè
* âûäàþòñÿ â âèäå ñòàíäàðòíîé Dbscript òàáëèöû.
* Äëÿ ñîçäàíèÿ íîâîñòåé â áëîãå èñïîëüçóåòñÿ ðåäàêòîð TinyMCE
* Ïîääåðæèâàåòñÿ ïîêàç âèäåî
* Ïëàíèðóåòñÿ ïîääåðæêà ïîêàçà ïî ëþáûì ùåë÷êàì (ïî÷òè ñäåëàíî), áóäó ðàä ïîìîùè â äîðàáîòêå.
*
* Ïðè ðåäàêòèðîâàíèè â îäíîì èç ïîëåé òåðÿþòñÿ äàííûå...õç ïî÷åìó. åñëè êîïèðîâàòü ïåðåä ðåäàêòèðîâàíèåì ýòî ïîìîãàåò.
* * ïîääåðæêè notable ïîêà íåò
* Âîçìîæíîñòü ïîèñêà ïî > < íåîáõîäèìî âíåäðèòü â îñíîâíîé ïîèñê
* Òàêæå â îñíîâíîé ïîèñê íåïëîõî äîáàâèòü è ïîèñêàòü same parameter.
* Ïëàíèðóåòñÿ çàãðóçêà è âûãðóçêà ïîëüçîâàòåëüñêè äàííûõ â îòäåëüíûé plugins.cfg äëÿ íà÷àëà õîòÿáû îáùèå íàñòðîéêè.
*
*/
?>
</head>
<body>
<style media="all" type="text/css">@import "_style/insidestyles.css";</style>
<?
$dbtype="mysql";
$tbl=192;
$tbl=$sd[38];
$x=newscreatesql ();
//..echo " Âû äîëæíû óñòàíîâèòü tbl= òîìó ÈÄ , êîòîðîìó ðàâåí _dbs__news43 îí åñòü â àäìèíêå - $sd[38] Ìîä Áëîã - èäåíòèôèêàòîð òàáëèöû. ";
if ($debug) echo "Returned message about existing tables:$x<br>";
if ($debug)echo "Settings: requires tbl dbs id for work: $tbl *usually 1<br>";
//ïîêàçàòü íîâîñòè çà ïîñëåäíèé ìåñÿö data gutentag
$date=date("d.m.Y H:i:s");
$datesrch=date("m.Y");
$dateinunix=strdbstounixtime ($date);// ïåðåâîäèì îáû÷íóþ dbs äàòó â þíèêñ
//..$dateinunix2=strdbstounixtime ("13.04.2010 10:38:53");// ïåðåâîäèì îáû÷íóþ dbs äàòó â þíèêñ
if ($debug) echo "Now $date = Now date in unix=".$dateinunix."<br>";
//echo "Now date in unix by time ".time ()."<br>";
$dateinunixminux15=$dateinunix-(1295684*2); //CFG OPT FUTURE - ýòî ÷èñëî äíåé 15 åãî ìîæíî èçìåíÿòü.
$dateminus15=date("d.m.Y H:i:s",$dateinunixminux15);
if ($debug) echo "date -15days= ".$dateminus15." ($dateinunixminux15)<br>"; //1295684 - 15 þíèêñ äíåé.
$vID=$datesrch;
//$tempdate=date("d.m.Y H:i:s",1272436417); //ïåðåâîäèì þíèêñ äàòó â äáñ
//echo "Tempdate =$tempdate and date-tempdate=".($dateinunix-1272436417)."<br>";
//TEST TEST TEST!
if ($ADM!==0)echo "<a target=b2 href='news.php?stdout=1'><img src=\"_ico/admin.png\" border=0 title='".cmsg ("WF_CANCSHOW")."'></a>";
// ôóíêöèÿ ïîèñêà ïîõîæèõ íîâîñòåé ïî ùåë÷êó èç çàãîëîâêà.
function tag ($tag,$field) {
//generating automatic tag
$tags=explode (",",$tag);
$counttags=count ($tags) ;
//echo "blax blax $counttags";
for ($a=0;$a<$counttags;$a++) {
echo "<a target=tag href='news.php?".$field."=".$tags[$a]."'>$tags[$a]</a>";
if ($a<$counttags-1) echo ",";
// <img src=\"_ico/admin.png\" border=0 title='".cmsg ("WF_CANCSHOW")."'>
}
}
// copy of search r.php mode == 2
$connect=dbs_connect ($prdbdata[$tbl][6],$sd[14],$sd[17],$dbtype);
dbs_selectdb ("dbscriptbk", $connect,$dbtype); //mod
$data=readdescripters ();// ïîëó÷åíèå äàííûõ çàãîëîâêà ìàññèâ mycol êîë-âî mycols
global $query,$connect;
global $mzdata,$mycols,$myrow,$findrecords,$scrcolumn;
settype ($vID,"integer");
if ($vID==0) msgexiterror ("needcode",$mode,"disable");
//default mode - select only by data last 15 days
$query = "SELECT * FROM `".$prdbdata[$tbl][5]."` WHERE `data` > ".$dateinunixminux15;
if ($tag) $query = "SELECT * FROM `".$prdbdata[$tbl][5]."` WHERE `gutentag` LIKE '%".$tag."%'";
if ($author) $query = "SELECT * FROM `".$prdbdata[$tbl][5]."` WHERE `user` LIKE '%".$author."%'";
//author !!!
//debug $query = "SELECT * FROM `".$prdbdata[$tbl][5]."` WHERE `data` < ".$dateinunixminux15;
echo $query."<br>"; // CFG OPT FUTURE - ýòî óñëîâèå íåïëîõî áû äîáàâèòü â îñíîâíîé ïîèñê > < !=
//if (($prdbdata[$tbl][15]>0)AND ($vID2!=="")) { $query = $query." AND ".$mycol[$prdbdata[$tbl][15]]."= '".$vID2."'";};
//$query=$query.$addsql;// ñîðòèðîâêà, ëèìèò
if (($stdout==1)&&($ADM!==0)) { selectedprintsql ($data); } else {
$result = dbs_query ($query, $connect,$dbtype);
//..echo "[debug] mycols=$mycols";
initwindowactions (0);
?> <link href="msgerr.css" rel="stylesheet" type="text/css"> <?
echo "<font class=text><table id=myTable border=1 width=100% bordercolor=#206621 style=\" color: #".$rgbtext."; \" >";
echo "<tr>";
for ($a=0;$a<$mycols;$a++)
{
//echo "1";
// if ($mzdata[0]==false) {echo "<td><bb>".$mycol[$a]."</bb></td>"; }
while ($myrow = dbs_fetch_row ($result,$dbtype)){ // DECLINED BY FALSE RESULT
//../ if ($myrow==false) echo "False result !!!!!<br>";
$l++ ;
//echo "2";
echo "<tr>";
if ($myrow[2]>0) continue; //skip plevel >0
$datathisline=$myrow[7];
if ($debug) echo "datathisline= $datathisline myrow6=".$myrow[7]." , dateinunixminux15 = $dateinunixminux15, mycols=$mycols<br>";
if ($datathisline>$dateinunixminux15) for ($b=0;$b<$mycols;$b++){
if ($b>0) if ($b>3) echo"<td>";
if ($b==1) {echo "</table>"; echo "<div id=l".$l." style=\" visibility:$hid; height:1 px \">";
echo "<table border=1 width=100% bordercolor=#206621 style=\" color: #".$rgbtext."; \" ><tr><td>";
}
if ($b==0) { echo "<td >"; //îðèãèíàëüíûé "êàòàëîã ïîñòîâ"
?><a HREF="javascript:win('l<?php echo $l;?>',0)"><img src="_ico/w_hide.png" border=0></a>
<a HREF="javascript:win('l<?php echo $l;?>',1)"><img src="_ico/w_zoom_out.png" border=0></a>
<?
echo cmsg("B_POTS")." ".$myrow[0];}// id post
if ($b==1) { echo "<ll ><tr>"; echo cmsg ("B_AUTH")." "; tag ($myrow[1],"author"); echo " :"; };// plevel ignored
if ($b==2) { echo "" ; };// plevel ignored
if ($b==3) { echo ": ".cmsg ("B_THEM")." ".$myrow[3]."=- ::" ; };// subj
if ($b==4) { echo "". cmsg ("B_TAG").": ";tag ($myrow[4],"tag");echo "</tr>" ; };// tag
if ($myrow[5]) if ($b==5) { echo "$myrow[5] :: ";player ($myrow[5]);echo "<br>"; };// vid
if ($b==6) { echo " ".$myrow[6]."<br>"; };// vid
if ($b==7) { echo date("d.m.Y H:i:s",$myrow[7])."<br>"; ; };// data
if ($b==7) { echo "</ll></td></tr></table></div>";}
if ($b>3) echo "</td>";
//if ($myrow[$a]>2) echo "<td><bb>".$myrow[$a]."</bb></td>";
}
echo "</tr><br>";$hid="hidden";
}
}
;
}
//.flv
function player ($file) {
?>
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab
#version=8,0,0,0" width="320" height="260" id="fp" align="middle"><param name="allowScriptAccess" value="sameDomain" /><param name="movie" value="player/fp.swf?video=<?=$file?>&image=img.jpg &title=my video" /><param name="quality" value="high" /><param name="bgcolor" value="#ffffff" /><embed src="player/fp.swf?video=video/<?=$file;?>&image=img.jpg&title=my video" quality="high" bgcolor="#ffffff" width="320" height="260" name="fp" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" /></object>
<?
}
/*.*
function player ($file) {
?><object type="application/x-shockwave-flash" data="/player/player.swf" width="" height="">
<param name="bgcolor" value="#cfffff" />
<param name="allowFullScreen" value="true" />
<param name="allowScriptAccess" value="always" />
<param name="wmode" value="transparent" />
<param name="movie" value="/player/player.swf" />
<param name="flashvars" value="/video/<?=$file?>" />
</object><?
}
* *
*/
function newscreatesql () {
global $pr,$sd,$debug;
if (!$pr[82]) return false ; // CFG OPT FUTURE disables script using checklogssql
//if (!$pr[43]) {
if ($debug) { errorlog ("DEBUG checklogsql:Connection failure. Default host not set or SQL off. trying 127.0.0.1."); $pr[43]="127.0.0.1"; }
$dbtype="mysql";
@$connect=dbs_connect ($pr[43],$sd[14] , $sd[17],$dbtype);
dbs_selectdb ("dbscriptbk", $connect,$dbtype);
if ($connect==false) { errorlog ("DEBUG checklogsql:Connection failure. Default host lost. $pr[43]");return false;}
$mysqlanswer=1;
$prefix=$sd[30];
$tablename="_dbs_".$prefix."_news43";
$query="SHOW CREATE TABLE `dbscriptbk`.`_dbs_".$prefix."_news43`;";
$silent=0;$e=dbs_query ($query,$connect,$dbtype);
if ($e==true) $mysqlanswer=true;
if ($e==false) { echo "initalizing tables..._dbs_".$prefix."_news43 ...";
$query="CREATE DATABASE IF NOT EXISTS `dbscriptbk`;";
$a=dbs_query ($query,$connect,$dbtype);
if ($a==false) sqlerr ();
$query="CREATE TABLE $tablename ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user` text NOT NULL DEFAULT '0', `plevelview` int(2) unsigned NOT NULL DEFAULT '0', `subject` text NOT NULL, `gutentag` text NOT NULL, `video` text NOT NULL, `message` text NOT NULL, `data` text NOT NULL,PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;";
$a=dbs_query ($query,$connect,$dbtype);
if ($a==false) { sqlerr (); $mysqlanswer=false;} else {$mysqlanswer=true;};
// âíèìàíèå çàïèñè ÂÑÅÕ ñóùåñòâóþùèõ êîïèé äáñêðèïò áóäóò ïîïàäàòü â ýòè áàçû- ìîäèôèêàöèè íàçâàíèÿ òàáëèö è ò.ï. ïîêà îòñóòñòâóþò CFG OPT FUTURE
## end of creating tables
}
return $mysqlanswer;
}