/
nedit.php
executable file
·529 lines (468 loc) · 23.9 KB
/
nedit.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
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
<?php
// Äàííàÿ ïðîãðàììà îòíîñèòñÿ ê ïàêåòó DBSCRIPT v2.1 (ñ) dj--alex
if ($_FILES) ob_start(); // äîáàâëåíî ò.ê. â 2033 ñòðîêå íåïîíÿòíî ïðèñëàëè ôàéë âîîáùå èëè íåò
$nomnu=true;
require_once ('dbscore.lib'); // ôóíêöèÿ ïîäãîòîâêè ê ðàáîòå è àâòîðèçàöèè
if (!$activation) exit;
// TinyMCE addition
?> <script type="text/javascript" src="tinymce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
mode:"textareas",
theme:"advanced",
language:"ru"
});
</script>
<?
// EXTERNAL MINI EDITOR DEMO DBS
function player ($file) {
?><object type="application/x-shockwave-flash" data="/player/player.swf" width="" height="">
<param name="bgcolor" value="#ffffff" />
<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?>.flv" />
</object><?
}
function newswritesql ($id,$user,$plevelview,$subject,$gutentag,$video,$message,$data) {
//// çàäà÷à - ñîõðàíèòü ëîã â sQl áàçå.
global $dbtype,$pr,$sd;
echo "ebaat doshlo!!";
//## Åñëè íå ñîçäàíû íóæíûå òàáëèöû òî âûïîëíÿåòñÿ èíà÷å ïðîïóñêàòü
$query="SHOW CREATE TABLE `dbscriptbk`.`_dbs_".$prefix."_news43`;";
$silent=0;$e=dbs_query ($query,$connect,$dbtype);
if ($e==true) {$mysqlanswer=true;} else { die ("NB_F_NEWSWRITESQL_NOT_CONNECTED.");};
$dbtype="mysql";
$prefix=$sd[30];
@$connect=dbs_connect ($pr[43],$sd[14] , $sd[17],$dbtype);
$logtype=="_dbs_".$prefix."_news43";
$query="INSERT INTO `dbscriptbk`.`".$logtype."` (id,user,plevelview,subject,gutentag,video,message,data)VALUES ('$id','$user','$plevelview','$subject','$gutentag','$video','$message','$data') ;";
// echo $query;
$e=dbs_query ($query,$connect,$dbtype);
dbserr ();
if (!$pr[8]) echo "DEBUG $query.<br>";
return $a;
}
// ïðè ðåäàêòèðîâàíèè èñïîëüçîâàòü ýòó õåðíþ - çàïèñûâàòü òîëüêî èçìåíåííûå çíà÷åíèÿ , à íå âñå ïîäðÿä! è â áàçó è â ëîã!
//end of duplicate mysql log
/*
if (!$action) {
echo "<form target=fileedit method=post>";
hidekey("fileed",$file);
echo "<textarea id=fileed name=vd cols=79 rows=25 >".$vd."</textarea><br>";
submitkey ("go","SAVE");
submitkey ("go","WF_UNDO"); echo "</form>";
}
* */
// COPY PAST nedit.php 4.1.117
if ($menudisable==0) {
?><form action="nedit.php" method=post>
<?
echo "ID1 ";inputtxt ("vID",30);
submitkey ("write","KEY_EDIT");
submitkey ("write","KEY_ADD");
submitkey ("write","KEY_DEL");
echo "</form>";
}
//ïîêàçàòü íîâîñòè çà ïîñëåäíèé ìåñÿö 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 äàòó â þíèêñ
//
//
//ïîäñòðîéêè äëÿ áëîêà êîäà
$tbl=192;//$tbl=0;
$dbtype="mysql";
$tbl=$sd[38];
$prdbdata[$tbl][6]=$pr[43];// ???
//$prdbdata[$tbl][9]="_dbs__news43";
$prauth[$ADM][39]=1;
$md2column=0;
//$oldcoreedit=$prauth[$ADM][39];
//$result=newscreatesql ();
// îêîí÷àíèå ïîäñòðîåê
//
//
//// COPY PAST nedit.php 4.1.117
//ìîäóëü çàïóñêà
if ($write) echo '<form action="nedit.php" method=post>';
if ($write==cmsg ("KEY_EDIT")) {
if ($vID==="") { lprint ("WF_FSELID")."<br>"; exit;};
$connect=dbs_connect ($prdbdata[$tbl][6],$sd[14],$sd[17],$dbtype);
dbs_selectdb ("dbscriptbk", $connect,$dbtype);
$data=readdescripters ();// ïîëó÷åíèå äàííûõ çàãîëîâêà ìàññèâ mycol êîë-âî mycols
if ($data==-1) exit;
$mycolvirtualname=$data[3];if (strlen ($mycolvirtualname[0])<1) $mycolvirtualname=$mycol;
// echo $data[3][0];
//print_r ($mycol);
//$mycol=$data[0];
/*if ($testmode===1) {
$result = dbs_query ($query, $connect,$dbtype);
echo "<font class=text><table id=dbmgr_edit border=0 width=100% bordercolor=#206621 style=\" color: #".$rgbtext."; \" >"; echo "<tr>";
for ($a=0;$a<$mycols;$a++)
{
// if ($mzdata[0]==false) {echo "<td><bb>".$mycol[$a]."</bb></td>"; }
while ($myrow = dbs_fetch_row ($result,$dbtype)){ // DECLINED BY FALSE RESULT
$datathisline=strdbstounixtime ($myrow[5]);
if ($myrow[2]>0) continue; //skip plevel >0
if ($datathisline>$dateinunixminux15) for ($a=0;$a<$mycols;$a++){
if ($a==0) { echo "Psto $myrow[0]";}// id post
if ($a==1) { echo "" ; };// plevel ignored
if ($a==2) { echo " -=$myrow[2]=-<br>" ; };// subj
if ($a==3) { echo " Tags:$myrow[3]" ; };// tag
if ($a==4) { player ($myrow[4]);echo "<br>"; };// vid
if ($a==5) { echo "Message: (".$myrow[5]."<br>"; };// vid
if ($a==6) { echo "d" ; };// data
//if ($myrow[$a]>2) echo "<td><bb>".$myrow[$a]."</bb></td>";
}
}
echo "</table>";
}
exit;
}
*/
if ($prdbdata[$tbl][18]) {//dly redaktirowainya data
echo "pdb18 ".$prdbdata[$tbl][18];
$datacols=explode (",",$prdbdata[$tbl][18]);
$datafilehdr=explode (",",$prdbdata[$tbl][19]);
$datasplitters=explode (",",$prdbdata[$tbl][20]);
///echo "datacol ".$datacols[0]."filehdr ".$datafilehdr[0]." datasplit ".$datasplitters[0]."<br>";
}
$cmd="SELECT * FROM `".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."= '".$vID."'";
echo $cmd;
//if (($virtualid)AND ($vID2!=="")) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$vID2."'";};
$result = dbs_query ($cmd, $connect,$dbtype);
$myrow = dbs_fetch_row ($result,$dbtype);
//ïðîâåðêà íå çàíÿò ëè ID
if ($myrow===false) { echo cmsg ("QUE_EMP")."<br>"; exit; }
@$crc=crc32(trim(implode (";",$myrow)));
$oldcoreedit=$prauth[$ADM][39];
if ($oldcoreedit)
for ($a=0;$a<$mycols;$a++)
{
echo "$mycolvirtualname[$a] "; //
if ($mycol[$md2column]===$mycol[$a]) echo "<ii>(ID1)</ii>";
if ($mycol[$virtualid]===$mycol[$a]) echo "<ii>(ID2)</ii>";
if ($prdbdata[$tbl][18]) for ($b=0;$b<count ($datacols);$b++) { $fil=$tbl.";".$myrow[$md2column].";;".$datacols[$b]."";
if ($a==$datacols[$b]) {echo "<a href='nedit.php?cmd=dat&fil=$fil'><img src='_ico/linked_table-yn.png' border=0 title='".cmsg ("KEY_HEAD")."'></a>";}
} //redaktirowanie data
if ($a===0) { $values="'".$myrow[$a];} // self-control
if ($a>0) {$values="".$values."','".$myrow[$a]; } //self-control
$z{$a}=$myrow[$a]; echo "<td>";
$myrow[1]==$prauth[$ADM][0]; //username fix
if ($a==6) { txtarea ("z6",$lensa,99) ; }; // äåëàåì îñîáûé ñòèëü äëÿ 5 ïîëÿ - ñîîáùåíèÿ.
if ($a!=6) {inputtext ("z$a",20,$myrow[$a]);}
echo "<br></td>";
}
if (!$oldcoreedit) { // â ýòîì ìåñòå ïðîèñõ. èíèö. ãåíåðàö òàáëèöû äëÿ dbmgr_ðåäàêòîðà òîëüêî äëÿ íîâîãî è âåðòèêàëüíîãî ñòèëåé !! êîïèðîâàòü èçìåíåíèÿ îòñþäà!
echo "<table id=dbmgr_edit border=3 width=100% bordercolor=#602621>";//èçìåíåíèå óòâåðæäåíî íåïîëíîñòüþ.åñëè ðåäàêòèðîâàòü òî óæ ñðàçó âñå <table> à íå îäíó.à òî îíè âñå ñòàíóò ðàçíûå.
for ($a=0;$a<$mycols;$a++)
{ //hdr text
if ($prauth[$ADM][41]) echo "<tr>";//optional Box,not linear edit. GMP_41;Ðåäàêòîð, âåðòèêàëü èíòåðôåéñ èç lang/russian.cfg
echo "<td>$mycolvirtualname[$a] ";
if ($mycol[$md2column]===$mycol[$a]) echo "<ii><bb>(ID1)</ii></bb>";
//if ($mycol[$virtualid]===$mycol[$a]) echo "<ii><bb>(ID2)</ii></bb>";
$lensa=strlen ($myrow[$a])+2;// CFG OPT FUTURE
if ($lensa>50) $lensa=50;
if ($prdbdata[$tbl][18]) for ($b=0;$b<count ($datacols);$b++) { $fil=$tbl.";".$myrow[$md2column].";;".$datacols[$b]."";
//if ($a==$datacols[$b]) {echo "<a href='nedit.php?cmd=dat&fil=$fil'><img src='_ico/linked_table-yn.png' border=0 title='".cmsg ("KEY_HEAD")."'></a>";}
} //redaktirowanie data
if ($a===0) { $values="'".$myrow[$a];} // self-control
if ($a>0) {$values="".$values."','".$myrow[$a]; } //self-control
?> </td>
<? if ($prauth[$ADM][41]) echo "</tr><tr>"; //optional Box,not linear edit.
$z{$a}=$myrow[$a]; echo "<td>"; //âîçìîæíî ïîõîæèé ìåõàíèçì ñòîèò ðàçðàáîòàòü è äëÿ editor base
$myrow[1]==$prauth[$ADM][0];
if ($a==6) { txtarea ("z6",$lensa,99) ; }; // äåëàåì îñîáûé ñòèëü äëÿ 5 ïîëÿ - ñîîáùåíèÿ.
if ($a!=6) {inputtext ("z$a",20,$myrow[$a]);}
echo "<br></td>";
//if ($a!==5) <textarea id=dbmgr_txta name=z=$a; cols=; rows=1>=$myrow[$a]</textarea>
//echo "<tr>";//optionalBox,not linear edit. èìÿ ID äîëæíî áûòü êàê ìîæíî êîðî÷å, ò.ê. ýëåìåíòîâ ìîãóò áûòü 1000è
// äîáàâèòü ïîòîì ñþäà trafeconom mode ïîïðàâëþ ïîçæå äðóãèå ñòèëè àíàëîãè÷íî ýòîìó.
} //field text
echo "</table>"; // êîíåö ãåíåðàòîðó òàáëèöû äëÿ dbmgr_edit
}
// ïðîâåðêà çàìîðîçêè
$values=$values."'";
$cmd="REPLACE INTO `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` VALUES ($values);";
@$afile="_conf/autoexec.sql";
$f=fopen ($afile,"r");
if ($f==false) { @$wr=fopen ($afile,"w+"); echo "File created";$f=fopen ($afile,"r");}
while ($checkcmd=@fgets ($f)) {
$findcmd=strpos ($checkcmd,$cmd);
if ($findcmd!==false) { $frozen=1; };
}
fclose ($f);
// îêîí÷àíèå ïðîâåðêè çàìîðîçêè
checkbox ($crcignore,"crcignore"); lprint ("WF_NOCRC");echo "<br>";
hidekey ("crc",$crc);
hidekey ("origid1",$myrow[$md2column]);
hidekey ("origid2",$myrow[$virtualid]);
checkbox ($views,"views") ; echo cmsg ("WF_LOG")."<br>";
if ($prauth[$ADM][33]) if (!$frozen) { checkbox ($enfreez,"enfreez");echo "<font color=red id=errfnt>".cmsg ("KEY_S_FREEZE");echo "</font><br>";};
if ($frozen) {hidekey ("frozen",$frozen); echo "<font color=blue id=bfnt>".cmsg ("KEY_FRZD")."</font><br>";
if ($prauth[$ADM][33]) {checkbox ($unfreez,"unfreez");echo cmsg ("KEY_S_UNFREEZE");echo "<br>";}
};
submitkey ("write","KEY_S_EDIT");echo "<br>";
}
//=========================================
//ìîäóëü îáðàáîòêè
if (($write==cmsg("KEY_S_EDIT"))AND(1==1)) {
@$connect=dbs_connect ($prdbdata[$tbl][6],$sd[14],$sd[17],$dbtype);
@dbs_selectdb ($prdbdata[$tbl][9], $connect,$dbtype);
$data=readdescripters ();
// çàìåíåí vID -> $myrow[$md2column] myrowid->$myrow[$virtualid]
// ñáîðêà âñåõ ïåðåìåííûõ â values è myrow[]
for ($a=0;$a<$mycols;$a++) {
$myrow[$a]=${"z".$a};
if ($a===0) { $values="'".$myrow[$a];}
if ($a>0) {$values="".$values."','".$myrow[$a]; }
}
$values=$values."'";
// ñáîðêà âñåõ ïåðåìåííûõ â values è myrow[]
// íà÷àëî ðàçìîðîçêè åñëè âêë
if ($unfreez) {
$cmd="REPLACE INTO `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` VALUES ($values); #".$prauth[$ADM][0];
$afile="_conf/autoexec.sql";
$afilenew="_conf/autoexec.tmp";
@$f=fopen ($afile,"r");
$fw=fopen ($afilenew,"w");
while ($checkcmd=@fgets ($f)) {
// $lencheck=strlen ($checkcmd);
$findcmd=strpos ($checkcmd,$cmd);
if ($findcmd!==false) { $unfrozen=1;echo"";} else { fwrite ($fw,$checkcmd);};
}
fclose ($f);fclose ($fw);
if ($unfrozen) { unlink ($afile);rename ($afilenew,$afile);};
if (!$unfrozen)echo "<font color=red id=errfnt>".lprint ("FROZ_OTH_USR")."</font><br>";
// ìîæåò ýòó ïðîöåäóðó òîæå êàê òî ñòàíäàðòèçèðîâàòü?
}
//êîíåö ðàçìîðîçêè åñëè âêë
//ïðîâåðêà ñòàðûõ äàííûõ äëÿ CRC i UnDO
$cmd="SELECT * FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."= '".$myrow[$md2column]."'";
if ($virtualid==true) { $addcmd=" AND ".$mycol[$virtualid]."= '".$myrow[$virtualid]."'"; $cmd.=$addcmd;};
$result = dbs_query ($cmd, $connect,$dbtype);
$myrowold = dbs_fetch_row ($result,$dbtype);
if ($myrowold==false) {lprint ("WF_EDITNOTADD");echo "<br>";
//ïðîöåäóðà undo ñòàðîãî ID
$cmd="SELECT * FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."='".$origid1."'";
if ($virtualid==true) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$origid2."'";};
$result=dbs_query ($cmd,$connect,$dbtype);;
$myrowold=dbs_fetch_row ($result,$dbtype); // òóò false åñëè òî çíà÷èò ïïö :)
}
@$olddata=implode (";",$myrowold); // âîò ýòî è íàäî ñîõðàíÿòü è îòêàòûâàòü
$undodata=gencmdlog ("`".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."`",$myrowold,$mycols);
if (!$crcignore) {
@$crcnew=crc32(trim($olddata));
if ($myrowold!==false) if ($crcnew!=$crc) {lprint ("WF_CRCFAIL"); exit;} ;}; //crc32testfunction
// ñòàðîå óñëîâèå äî 3.2.6 ++ $mycol[$md2column]."='".$vID."'";
// îïÿòü âîçìîæíàÿ îøèáêà - íåîáÿçàòåëüíî 0 ÿâëÿåòñÿ êëþ÷îì
$cmd="DELETE FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."='".$myrow[$md2column]."'";
if ($virtualid==true) { $cmd.=$addcmd;};
$cmd2="DELETE FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."='".$origid1."'";
if ($virtualid==true) { $cmd2=$cmd2." AND ".$mycol[$virtualid]."= '".$origid2."'";};
// ýòî óäàëåíèå ñòàðîãî ID åñëè áûë
$a=dbs_query ($cmd,$connect,$dbtype); // óñëîâèå îáíîâëåíî
if (!$pr[8]) {echo "DEBUG Ïîëó÷åí êîä $a<br>";}
if ($a==true) { echo $myrow[0].cmsg ("WF_DELOK")."!<br>";} else { echo cmsg ("WF_DELFAIL")."$myrow[0]<br>";}
$a=dbs_query ($cmd2,$connect,$dbtype); // óñëîâèå îáíîâëåíî
if (!$pr[8]) {echo "DEBUG Ïîëó÷åí êîä $a<br>";}
if ($a==true) { echo $myrow[0].cmsg ("WF_DELOK")."!<br>";} else { echo cmsg ("WF_DELFAIL")."$myrow[0]<br>";}
$cmd="INSERT INTO `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` VALUES ($values)";
$a=dbs_query ($cmd,$connect,$dbtype);//ñäåëàòü ëþáîå êîë-âî
$cmd="REPLACE INTO `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` VALUES ($values)";
if ($enfreez) {
if (($codekey==9)or($codekey==7)) demo ();
$afile="_conf/autoexec.sql"; $autoexeccmd=$cmd."; #".$prauth[$ADM][0]."\r\n";
$f=fopen ($afile,"a+");
$a=fwrite ($f,$autoexeccmd);
if ($a) { echo "<font color=blue id=bfnt>".cmsg ("KEY_FRZD")."</font><br>";};
fclose ($f);
}
if (!$pr[8]) {echo "DEBUG Ïîëó÷åí êîä $a<br>";}
if ($a==true) { echo $myrow[0].cmsg ("WF_ADDED").".<br>";if ($views) echo cmsg ("WF_EXQUE")."$cmd<br>"; } else { echo cmsg ("WF_ADDFAIL")."$myrow[0]<br>";}
if ($a==true) { echo $myrow[0].cmsg ("WF_UPDOK")."!<br>";} else {
$errt=cmsg ("WF_UPDFAIL"); $ermsg="$myrow[0]<br>";}
if ($pr[12]) {$act="EDIT_SQL B $tbl($nametbl) Find$vID Cmd $cmd";
$baseID=$tbl;$hostIP=$prdbdata[$tbl][6];
logwrite ($act) ;undolog ($act,$undodata,$baseID,$hostIP); };
//if ($views) echo cmsg ("WF_EXQUE")."$cmd<br><br>";
echo cmsg ("WF_QUECOMP").dbs_affected_rows ().cmsg ("WF_Q1")."<br>";
$silent=0;$errno=dbserr ();// ïèøåò îøèáêó è åå êîä è åãî æå âîçâðàùàåò
submitkey ("write","WF_UNDO_LAST");
//endof executing
}
//infa DISTINCT - îòêëþ÷èòü äóáëèêàòû
//=========================================
//ìîäóëü çàïóñêà
if (($write==cmsg ("KEY_ADD"))AND(1==1)) {
@$connect=dbs_connect ($prdbdata[$tbl][6],$sd[14],$sd[17],$dbtype);
@dbs_selectdb ($prdbdata[$tbl][9], $connect,$dbtype);
$data=readdescripters ();// ïîëó÷åíèå äàííûõ çàãîëîâêà ìàññèâ mycol êîë-âî mycols
if ($data==-1) exit;
if ($data==-1) exit;
$mycolvirtualname=$data[3];
$maxquery="SELECT MAX(`".$mycol[$md2column]."`)FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."`";
$result = dbs_query ($maxquery,$connect,$dbtype);; $maxtbl = dbs_fetch_row ($result,$dbtype);
echo cmsg ("WF_1NOTUSED").": ".($maxtbl[0]+1)."<bR>";
$cmd="SELECT * FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."= '".$vID."'";
//if (($virtualid>0)AND ($vID2!=="")) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$vID2."'";};
$result = dbs_query ($cmd, $connect,$dbtype);
$myrow = dbs_fetch_row ($result,$dbtype);
//ïðîâåðêà íå çàíÿò ëè ID
if ($myrow===false) {
echo cmsg ("QUE_EMP")."<br>";
$myrow[$md2column]=$vID;
//if (($virtualid>0)AND ($vID2!=="")) $myrow[$virtualid]=$vID2;
}
//end ïðîâåðêà íå çàíÿò ëè ID
$oldcoreedit=$prauth[$ADM][39];
if ($oldcoreedit)
for ($a=0;$a<$mycols;$a++)
{
echo "$mycolvirtualname[$a] ";
if ($mycol[$md2column]===$mycol[$a]) echo "<ii>(ID1)</ii>";
if ($mycol[$virtualid]===$mycol[$a]) echo "<ii>(ID2)</ii>";
$z{$a}=$myrow[$a];
if ($a==7) { $value=$dateinunix;echo "($date)";};
echo "<td>";
if ($a==6) { txtarea ("z$a",$lensa,1) ; }; // äåëàåì îñîáûé ñòèëü äëÿ 5 ïîëÿ - ñîîáùåíèÿ.
if ($a!=6) {inputtext ("z$a",$lensa,$value);}
echo "<br></td>";
}
if (!$oldcoreedit) { echo "<table id=dbmgr_edit border=3 width=100% bordercolor=#602621>";
for ($a=0;$a<$mycols;$a++)
{ //hdr text
if ($prauth[$ADM][41]) echo "<tr>";//optional Box,not linear edit.
echo "<td>$mycolvirtualname[$a] ";
if ($mycol[$md2column]===$mycol[$a]) echo "<ii><bb>(ID1)</ii></bb>";
if ($mycol[$virtualid]===$mycol[$a]) echo "<ii><bb>(ID2)</ii></bb>";
$lensa=strlen ($myrow[$a])+2;// CFG OPT FUTURE
if ($lensa>50) $lensa=50;
if ($a===0) { $values="'".$myrow[$a];} // self-control
if ($a>0) {$values="".$values."','".$myrow[$a]; } //self-control
?> </td>
<?if ($prauth[$ADM][41]) echo "</tr><tr>"; //optional Box,not linear edit.
$z{$a}=$myrow[$a];
if ($a==7) { $value=$dateinunix;echo "($date)";};
echo "<td>";
if ($a==6) { txtarea ("z$a",$lensa,1) ; }; // äåëàåì îñîáûé ñòèëü äëÿ 5 ïîëÿ - ñîîáùåíèÿ.
if ($a!=6) {inputtext ("z$a",$lensa,$value);}
echo "<br></td>";
if ($prauth[$ADM][41]) echo "<tr>";//optionalBox,not linear edit.
} //field text
echo "</table>";
}
echo "";
checkbox ($views,"views") ; echo cmsg ("WF_LOG")."<br>";
submitkey ("write","KEY_S_ADD"); echo "<br>";
}
//=========================================
//ìîäóëü îáðàáîòêè
if (($write==cmsg ("KEY_S_ADD"))AND(1==1)) {
@$connect=dbs_connect ($prdbdata[$tbl][6],$sd[14],$sd[17],$dbtype);
@dbs_selectdb ($prdbdata[$tbl][9], $connect,$dbtype);
$data=readdescripters ();
// ñáîðêà âñåõ ïåðåìåííûõ â values è myrow[]
for ($a=0;$a<$mycols;$a++)
{
$myrow[$a]=${"z".$a};
if ($a===0) { $values="'".$myrow[$a];}
//if ($a==7) {$values="".$values."',NOW().'"; continue;}
if ($a>0) {$values="".$values."','".$myrow[$a]; }
}
$values=$values."'";
// ñáîðêà âñåõ ïåðåìåííûõ â values è myrow[]
//òóò íàäî áû undo
$cmd="INSERT INTO `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` VALUES ($values)";
$a=dbs_query ($cmd,$connect,$dbtype);//ñäåëàòü ëþáîå êîë-âî
$cmd="REPLACE INTO `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` VALUES ($values)";
if (!$pr[8]) {echo "DEBUG Ïîëó÷åí êîä $a<br>";}
if ($a==true) { echo $myrow[0].cmsg ("WF_ADDED").".<br>"; if ($views) echo cmsg ("WF_EXQUE")."$cmd<br>"; } else {
$errt=cmsg ("WF_ADDFAIL"); $ermsg="$myrow[0]".cmsg ("WF_ADDPRS")."<br>";}
$undodata="DELETE FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."='".$vID."'";
//if (($virtualid>0)AND ($vID2!=="")) { $undodata=$undodata." AND ".$mycol[$virtualid]."= '".$vID2."'";};
if ($pr[12]) {$act="ADD_SQL B $tbl($nametbl) Find$vID Cmd $cmd";
$baseID=$tbl;$hostIP=$prdbdata[$tbl][6];
logwrite ($act) ; undolog ($act,$undodata,$baseID,$hostIP);}; // ëîãèðóåìñÿ
//executing+errlogäåëàåì íîðìàëüíóþ îáðàáîòêó îøèáîê èñï âñåãäà ýòîò ìîäóëü
//if ($views) echo cmsg ("WF_EXQUE")."$cmd<br><br>";
echo cmsg ("WF_QUECOMP").dbs_affected_rows ().cmsg ("WF_Q1")."<br>";
$silent=0;$errno=dbserr ();// ïèøåò îøèáêó è åå êîä è åãî æå âîçâðàùàåò
submitkey ("write","WF_UNDO_LAST");
//endof executing
}
//=========================================
//ìîäóëü çàïóñêà
if (($write==cmsg ("KEY_DEL"))AND(1==1)) {
if (($virtualid==true)AND($vID2==false)) echo "<font color=red id=errfnt>".cmsg
("WF_DEL_GROUP")." ".$vID." </font><br>";
if ($vID==="") { lprint ("WF_FSELID");exit;};
hidekey ("vID",$vID);
submitkey ("write","KEY_S_DEL");
}
//=========================================
//ìîäóëü îáðàáîòêè
if (($write==cmsg("KEY_S_DEL"))AND(1==1)) {
@$connect=dbs_connect ($prdbdata[$tbl][6],$sd[14],$sd[17],$dbtype);
@dbs_selectdb ($prdbdata[$tbl][9], $connect,$dbtype);
$data=readdescripters ();// ïîëó÷åíèå äàííûõ çàãîëîâêà ìàññèâ mycol êîë-âî mycols
if ($data==-1) exit;
$cmd="SELECT * FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."= '".$vID."'";
echo $cmd;
//if (($virtualid>0)AND ($vID2!=="")) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$vID2."'";};
$result = dbs_query ($cmd, $connect,$dbtype);
for ($c=0;$myrow = dbs_fetch_row ($result,$dbtype);$c++) {
if (!$test) $test=$myrow[0];
$undodata.=gencmdlog ("`".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."`",$myrow,$mycols)." ";
};
// òóò íàäî áû undo
$a=$test;
$cmd="DELETE FROM `".$prdbdata[$tbl][9]."`.`".$prdbdata[$tbl][5]."` WHERE ".$mycol[$md2column]."='".$vID."'";
//if (($virtualid>0)AND ($vID2!=="")) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$vID2."'";};
dbs_query ($cmd,$connect,$dbtype);
if (!$pr[8]) {echo "DEBUG Ïîëó÷åí êîä $a<br>";}
if ($a==true) { echo $vID.cmsg ("WF_DELOK")."!<br>";} else {
$errt=cmsg ("WF_DELFAIL"); $ermsg=cmsg ("WF_NOQUE")."<br>";}
if ($pr[12]) {$act="DEL_SQL B $tbl($nametbl) Find$vID Cmd $cmd";
$baseID=$tbl;$hostIP=$prdbdata[$tbl][6];logwrite ($act) ;
undolog ($act,$undodata,$baseID,$hostIP);
}; //
//if ($views) cmsg ("WF_EXQUE")."$cmd<br><br>";
echo cmsg ("WF_QUECOMP").dbs_affected_rows ().cmsg ("WF_Q1")."<br>";
$silent=0;$errno=dbserr ();
//endof executing
submitkey ("write","WF_UNDO_LAST");
}
//END COPY PAST
if ($write) echo "</form>";
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` int(10) unsigned 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` timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (`id`) ) ;";
$a=dbs_query ($query,$connect,$dbtype);
if ($a==false) { sqlerr (); $mysqlanswer=false;} else {$mysqlanswer=true;};
// âíèìàíèå çàïèñè ÂÑÅÕ ñóùåñòâóþùèõ êîïèé äáñêðèïò áóäóò ïîïàäàòü â ýòè áàçû- ìîäèôèêàöèè íàçâàíèÿ òàáëèö è ò.ï. ïîêà îòñóòñòâóþò CFG OPT FUTURE
## end of creating tables
}
return $mysqlanswer;
}
?>