ilch.de :: Forum :: Allgemein :: HTML, PHP, SQL,...

Hey Leute,

hab da mal wieder n problem mit meiner Datenbank.
Immer wenn ich eine neue Kategorie anlegen möchte kommt folgende Fehlermeldung:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Der zweite Bauabschnitt','','23',0)' at line 1
in Query:
INSERT INTO ic1_gallery_cats (`cat`,`gallery_kat`,`name`,`besch`,pos,recht) VALUES (0,,'Der zweite Bauabschnitt','','23',0)
Debug backtrace:
@ mysql.php:30 -- debug_bt()
@ mysql.php:48 -- db_check_error(...)
@ gallery.php:327 -- db_query(...)
@ admin.php:38 -- require_once(...)

Hab zwar n bsl gegoogelt, komme aber iwie net damit zurecht und hoffe auf hilfe -.-"

gallery.php:

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

<?php
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
 
 
require_once('include/includes/func/gallery.php');
 
// START: Neu seit Ilch 1.1 Patchlevel 15
        function image_valid($type) {
                $file_types  = array(
                        'image/pjpeg'        => 'jpg',
                        'image/jpeg'        => 'jpg',
                        'image/jpeg'        => 'jpeg',
                        'image/gif'                => 'gif',
                        'image/X-PNG'        => 'png',
                        'image/PNG'                => 'png',
                        'image/png'                => 'png',
                        'image/x-png'        => 'png',
                        'image/JPG'                => 'jpg',
                        'image/GIF'                => 'gif',
                );
 
                if ( !array_key_exists ( $type, $file_types ) ) {
                        return false;
                } else {
                        return true;
                }
        }
// END: Neu seit Ilch 1.1 Patchlevel 15
 
function gallery_admin_showcats ( $id , $stufe ) {
    global $menu;
  $q = "SELECT * FROM prefix_gallery_cats WHERE cat = ".$id." ORDER BY pos";
        $erg = db_query($q);
        if ( db_num_rows($erg) > 0 ) {
           while ($row = db_fetch_object($erg) ) {
           if ($menu->getE('S') == $row->id) {
               $row->name = '<strong>'.$row->name.'</strong>';
           }
          echo '<tr class="Cmite"><td>'.$stufe.'- <a href="?gallery-S'.$row->id.'">'.$row->name.'</a></td>';
      echo '<td><a href="javascript:uploadImages('.$row->id.')"><img src="include/images/icons/upload.gif" title="Bilder in diese Kategorie hochladen" alt="Bilder in diese Kategorie hochladen" border="0"></td>';
      echo '<td><a href="javascript:reloadImages('.$row->id.')"><img src="include/images/icons/reload.gif" title="Bilder in diese Kategorie erneuern / einlesen" alt="Bilder in diese Kategorie erneuern / einlesen" border="0"></a></td>';
      echo '<td><a href="admin.php?gallery-E'.$row->id.'#edit"><img src="include/images/icons/edit.gif" border="0" alt="&auml;ndern" title="&auml;ndern"></a></td>';
      echo '<td><a href="javascript:Kdel('.$row->id.')"><img src="include/images/icons/del.gif" border="0" alt="l&ouml;schen" title="l&ouml;schen"></a></td>';
      echo '<td><a href="admin.php?gallery-M'.$row->id.'-o'.$row->pos.'"><img src="include/images/icons/pfeilo.gif" border="0" title="hoch" alt="hoch"></a></td>';
      echo '<td><a href="admin.php?gallery-M'.$row->id.'-u'.$row->pos.'"><img src="include/images/icons/pfeilu.gif" border="0" title="runter" alt="runter"></a></td></tr>';
          gallery_admin_showcats($row->id, $stufe.' &nbsp; &nbsp;' );
          }
        }
}
 
function gallery_admin_selectcats ( $id, $stufe, &$output, $sel = 0) {
  $q = "SELECT * FROM prefix_gallery_cats WHERE cat = ".$id." ORDER BY pos";
        $erg = db_query($q);
        if ( db_num_rows($erg) > 0 ) {
           while ($row = db_fetch_object($erg) ) {
            $output .= '<option value="'.$row->id.'"'.($sel == $row->id?' selected="selected"':'').'>'.$stufe.' '.$row->name.'</option>';
      gallery_admin_selectcats($row->id, $stufe.'&raquo;', $output, $sel );
          }
        }
}
 
# Bilder einer Kategorie erneuern oder einlesen
if ( $menu->get(1) == 'reloadImages' ) {
  $msg = '';
  if (isset($_POST['do_aktion']) AND $_POST['do_aktion'] == 'yes') {
    # wenn keine aktion gewaehlt wurde
    if (empty($_POST['aktion'])) {
      $msg = 'Bitte eine Aktion ausw&auml;hlen<br />';
 
    # aktion alle bilder eines ordners einlesen
    } elseif ($_POST['aktion'] == 'ins') {
      if (is_dir($_POST['dir'])) {
        $msg .= 'Bilder aus Ordner '.$_POST['dir'].' eingefugt<br />';
        $o = opendir($_POST['dir']);
        while($f = readdir($o)) {
          if ($f == '.' OR $f == '..') { continue; }
          $imgpath = $_POST['dir'].'/'.$f;
          $size = getimagesize($imgpath);
          if ($size[2] == 2 OR $size[2] == 3) {
            $name = basename($imgpath);
            $tmp = explode('.',$name);
            $tm1 = count($tmp) -1;
            $endung = $tmp[$tm1];
            unset($tmp[$tm1]);
            $name = implode('',$tmp);
            $id = db_result(db_query("SHOW TABLE STATUS FROM `". DBDATE ."` LIKE 'prefix_gallery_imgs'"),0,'Auto_increment');
            $bild_url = 'include/images/gallery/img_'.$id.'.'.$endung;
            if (@copy ($imgpath,$bild_url)){
              db_query("INSERT INTO prefix_gallery_imgs (cat,datei_name,endung,besch) VALUES (".$menu->get(2).",'".$name."','".$endung."','')");
              $msg .= '- '.$imgpath.'<br />';
              $bild_thumb = 'include/images/gallery/img_thumb_'.$id.'.'.$endung;
              $bild_norm  = 'include/images/gallery/img_norm_'.$id.'.'.$endung;
              create_thumb ($bild_url, $bild_thumb, $allgAr['gallery_preview_width']);
              create_thumb ($bild_url, $bild_norm , $allgAr['gallery_normal_width']);
            }
          }
        }
      } else {
        $msg = 'Konnte den Ordner '.$_POST['dir'].' nicht finden<br />';
      }
 
    # aktion alle bilder erneuern mit oder ohne ueberschreiben
    } elseif ($_POST['aktion'] == 'alle' OR $_POST['aktion'] == 'alle_no') {
      $erg = db_query("SELECT id,endung FROM prefix_gallery_imgs WHERE cat = ".$menu->get(2));
      while ($r = db_fetch_assoc($erg)) {
        $endung = $r['endung'];
        $id     = $r['id'];
        $bild_url = 'include/images/gallery/img_'.$id.'.'.$endung;
        if (file_exists ($bild_url)) {
          $bild_thumb = 'include/images/gallery/img_thumb_'.$id.'.'.$endung;
          $bild_norm  = 'include/images/gallery/img_norm_'.$id.'.'.$endung;
          if ($_POST['aktion'] == 'alle' OR !file_exists($bild_thumb)) {
            create_thumb ($bild_url, $bild_thumb, $allgAr['gallery_preview_width']);
          }
          if ($_POST['aktion'] == 'alle' OR !file_exists($bild_norm)) {
            create_thumb ($bild_url, $bild_norm , $allgAr['gallery_normal_width']);
          }
        }
      }
 
      if ($_POST['aktion'] == 'alle') {
        $msg = 'Alle Bilder erneuert';
      } else {
        $msg = 'Alle Bilder erneuert, nicht &uuml;berschrieben';
      }
    }
  }
 
  # anzeigen
  $tpl = new tpl ( 'gallery/images_reload', 1);
  $cname = 'keine Kategorie';
  if ($menu->get(2) > 0) {
    $cname = db_result(db_query("SELECT name FROM prefix_gallery_cats WHERE id = ".$menu->get(2)),0,0);
  }
  $tpl->set('cat', $menu->get(2) );
  $tpl->set('cname',$cname);
  $tpl->set('msg', $msg);
  $tpl->out(0);
  exit();
}
 
# Bilder in eine Kategorie hochladen
if ( $menu->get(1) == 'uploadImages' ) {
  $msg = '';
  if (isset($_POST['hochladen']) AND $_POST['hochladen'] == 'yes') {
    foreach ($_FILES['file']['name'] AS $k => $v) {
      if (!empty($_FILES['file']['name'][$k])) {
        $name = $_FILES['file']['name'][$k];
        $tmp = explode('.',$name);
        $tm1 = count($tmp) -1;
        $endung = $tmp[$tm1];
        unset($tmp[$tm1]);
        $name = implode('',$tmp);
        $besch = escape($_POST['besch'][$k],'string');
        $id = db_result(db_query("SHOW TABLE STATUS FROM `". DBDATE ."` LIKE 'prefix_gallery_imgs'"),0,'Auto_increment');
        $bild_url = 'include/images/gallery/img_'.$id.'.'.$endung;
 
                // START: Geändert seit Ilch 1.1 Patchlevel 15
                        if( image_valid ( $_FILES['file']['type'][$k] ) ) {
                                if (@move_uploaded_file ($_FILES['file']['tmp_name'][$k], $bild_url)) {
                                  @chmod($bild_url, 0777);
                                  db_query("INSERT INTO prefix_gallery_imgs (cat,datei_name,endung,besch) VALUES (".$menu->get(2).",'".$name."','".$endung."','".$besch."')");
                                  $msg .= 'Datei '.$name.'.'.$endung.' erfolgreich hochgeladen<br />';
                                  $bild_thumb = 'include/images/gallery/img_thumb_'.$id.'.'.$endung;
                                  $bild_norm  = 'include/images/gallery/img_norm_'.$id.'.'.$endung;
                                  create_thumb ($bild_url, $bild_thumb, $allgAr['gallery_preview_width']);
                                  @chmod($bild_thumb, 0777);
                                  create_thumb ($bild_url, $bild_norm , $allgAr['gallery_normal_width']);
                                  @chmod($bild_norm, 0777);
                                } else {
                                  $msg .= 'Datei '.$name.'.'.$endung.' konnte nicht hochgeladen werden<br />';
                                }
                        } else {
                                $msg .= 'Falsches Dateiformat';
                        }
                // END: Geändert seit Ilch 1.1 Patchlevel 15
 
      }
    }
  }
  # bilder hochladen
 
  $anzb = 5;
  if (isset($_GET['anzb']) AND is_numeric($_GET['anzb'])) {
    $anzb = $_GET['anzb'];
  }
  $tpl = new tpl ( 'gallery/images_upload', 1);
  $tpl->set('cat', $menu->get(2) );
  $tpl->set('msg', $msg);
  $tpl->out(0);
  $class = 'Cmite';
  for($i=1;$i<=$anzb;$i++) {
    $tpl->set('class', ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' ) );
    $tpl->out(1);
  }
  $tpl->out(2);
  exit();
}
 
# Kategorie löschen
if ( $menu->getA(1) == 'D' ) {
 
    $tpl = new tpl('gallery/delkat', 1);
    $tpl->out(0);
    //Kategorie und alle Bilder löschen
    if ($menu->get(2) == 'delall') {
        $r = db_fetch_assoc(db_query("SELECT id, pos, cat FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'"));
        db_query("DELETE FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'");
        db_query("UPDATE prefix_gallery_cats SET pos = pos - 1 WHERE pos > ".$r['pos']." AND cat = ".$r['cat']);
        $sql = db_query("SELECT * FROM prefix_gallery_imgs WHERE cat = '{$r['id']}'");
        while($r2 = db_fetch_assoc($sql)){
            @unlink ('include/images/gallery/img_'.$r2['id'].'.'.$r2['endung']);
            @unlink ('include/images/gallery/img_thumb_'.$r2['id'].'.'.$r2['endung']);
            @unlink ('include/images/gallery/img_norm_'.$r2['id'].'.'.$r2['endung']);
        }
        db_query("DELETE FROM prefix_gallery_imgs WHERE cat = '".$r['id']."'");
        echo 'Kategorie und Bilder gel&ouml;scht<br />';
        $tpl->out(2);
    } elseif ($menu->get(2) == 'delkat') {
        $r = db_fetch_assoc(db_query("SELECT id, pos, cat FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'"));
        db_query("DELETE FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'");
        db_query("UPDATE prefix_gallery_cats SET pos = pos - 1 WHERE pos > ".$r['pos']." AND cat = ".$r['cat']);
        db_query("DELETE FROM prefix_gallery_imgs WHERE cat = '".$r['id']."'");
        echo 'Nur Kategorie gel&ouml;scht, Bilder noch auf dem FTP<br />';
        $tpl->out(2);
    } elseif (isset($_POST['move']) AND $_POST['cat'] != $menu->getE(1)) {
            $_POST['cat'] = escape($_POST['cat'], 'integer');
        $r = db_fetch_assoc(db_query("SELECT id, pos, cat FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'"));
        db_query("DELETE FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'");
        db_query("UPDATE prefix_gallery_cats SET pos = pos - 1 WHERE pos > ".$r['pos']." AND cat = ".$r['cat']);
        db_query("UPDATE prefix_gallery_imgs set cat = '{$_POST['cat']}' WHERE cat = '".$r['id']."'");
        echo 'Bilder in Kategorie "'.@db_result(db_query("SELECT name FROM prefix_gallery_cats WHERE id = '{$_POST['cat']}'"),0).'" verschoben und alte Kategorie gel&ouml;scht.<br />';
        $tpl->out(2);
    } else {
        $row = array('id' => $menu->getE(1));
        gallery_admin_selectcats('0','',$row['cats'],$row['cats']);
        $row['cats'] = '<option value="0">Keine</option>'.$row['cats'];
        $tpl->set_ar_out($row,1);
    }
    $tpl->out(3);
    exit();
}
 
#Bilder verschieben
if (isset($_POST['movepics'])) {
    if (count($_POST['img']) > 0) {
        $pics = implode(',',$_POST['img']);
        $cat = escape($_POST['movecat'],'integer');
        db_query("UPDATE prefix_gallery_imgs SET cat = $cat WHERE id IN ($pics);");
        $menu->set_url(1,'S'.$cat);
    }
}
 
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'gallery/gallery', 1);
 
# Bild loeschen
if ( $menu->getA(1) == 'd' ) {
  $id = $menu->getE(1);
  $row = db_fetch_assoc(db_query("SELECT endung,cat FROM prefix_gallery_imgs WHERE id = ".$id));
  $endung = $row['endung'];
  @unlink ('include/images/gallery/img_'.$id.'.'.$endung);
  @unlink ('include/images/gallery/img_thumb_'.$id.'.'.$endung);
  @unlink ('include/images/gallery/img_norm_'.$id.'.'.$endung);
  db_query("DELETE FROM prefix_gallery_imgs WHERE id = ".$id);
  $azk = $row['cat'];
}
 
# Bild Beschreibung aendern
if ( $menu->getA(1) == 'e' ) {
  $id = $menu->getE(1);
  $besch = escape($_REQUEST['besch'],'string');
  $row = db_fetch_assoc(db_query("SELECT cat FROM prefix_gallery_imgs WHERE id = ".$id));
  db_query("UPDATE prefix_gallery_imgs SET besch = '".$besch."' WHERE id = ".$id);
  $azk = $row['cat'];
}
 
# Bild erneuern
if ( $menu->getA(1) == 'r' ) {
  $id         = $menu->getE(1);
  $row        = db_fetch_assoc(db_query("SELECT endung,cat FROM prefix_gallery_imgs WHERE id = ".$id));
  $endung     = $row['endung'];
  $bild_url   = 'include/images/gallery/img_'.$id.'.'.$endung;
  if (file_exists ($bild_url)) {
    $bild_thumb = 'include/images/gallery/img_thumb_'.$id.'.'.$endung;
    $bild_norm  = 'include/images/gallery/img_norm_'.$id.'.'.$endung;
    create_thumb ($bild_url, $bild_thumb, $allgAr['gallery_preview_width']);
    create_thumb ($bild_url, $bild_norm , $allgAr['gallery_normal_width']);
  }
  $azk = $row['cat'];
}
 
if ($menu->getA(1) == 'M') {
  $pos = $menu->getE(2);
  $id = $menu->getE(1);
  $cat = db_result(db_query("SELECT cat FROM prefix_gallery_cats WHERE id = ".$id),0);
  $nps = ( $menu->getA(2) == 'u' ? $pos + 1 : $pos - 1 );
  $anz = db_result(db_query("SELECT COUNT(*) FROM prefix_gallery_cats WHERE cat = ".$cat),0);
 
  if ($nps < 0) {
    db_query("UPDATE prefix_gallery_cats SET pos = ".$anz." WHERE id = ".$id);
    db_query("UPDATE prefix_gallery_cats SET pos = pos -1 WHERE cat = ".$cat);
  }
  if ($nps >= $anz) {
    db_query("UPDATE prefix_gallery_cats SET pos = -1 WHERE id = ".$id);
    db_query("UPDATE prefix_gallery_cats SET pos = pos +1 WHERE cat = ".$cat);
  }
 
  if ( $nps < $anz AND $nps >= 0 ) {
    db_query("UPDATE prefix_gallery_cats SET pos = ".$pos." WHERE pos = ".$nps." AND cat = ".$cat);
    db_query("UPDATE prefix_gallery_cats SET pos = ".$nps." WHERE id = ".$id);
  }
}
 
# kategorie eintrage speichern oder aendern.
if ( isset ( $_POST['Csub']) ) {
  if ( empty($_POST['Ccat']) ) {
          $_POST['Ccat'] = 0;
        }
        if ( empty ($_POST['Cpkey']) ) {
    $nextpos = db_result(db_query("SELECT COUNT(*) FROM prefix_gallery_cats WHERE cat = ".$_POST['Ccat']),0,0);
    db_query("INSERT INTO prefix_gallery_cats (`cat`,`gallery_kat`,`name`,`besch`,pos,recht) VALUES (".$_POST['Ccat'].",".$_POST['gallery_kat'].",'".$_POST['Cname']."','".$_POST['Cdesc']."','".$nextpos."',".$_POST['Crecht'].")");
        } else {
    $r = db_fetch_assoc(db_query("SELECT cat, pos FROM prefix_gallery_cats WHERE id = ".$_POST['Cpkey']));
 
    $bool = true;
    $tc = $_POST['Ccat'];
    while ($tc > 0) {
    if ($tc == $_POST['Cpkey']) { $bool = false; }
    $tc = @db_result(db_query("SELECT cat FROM prefix_gallery_cats WHERE id = $tc"));
    }
    if ($bool) {
      $epos = $r['pos'];
      $akc  = $r['cat'];
      $npos = $epos;
      if ($akc != $_POST['Ccat']) {
        $npos = db_result(db_query("SELECT COUNT(*) FROM prefix_gallery_cats WHERE cat = ".$_POST['Ccat']),0,0);
      }
            db_query("UPDATE prefix_gallery_cats SET `cat` = '".$_POST['Ccat']."',`gallery_kat` = '".$_POST['katbild']."',pos=".$npos.",recht=".$_POST['Crecht'].",`name` = '".$_POST['Cname']."',`besch` = '".$_POST['Cdesc']."' WHERE `id` = '".$_POST['Cpkey']."'");
      if ($akc != $_POST['Ccat']) {
        db_query("UPDATE prefix_gallery_cats SET pos = pos - 1 WHERE pos > ".$epos." AND cat = ".$akc);
      }
    }
        }
  $azk = $_POST['Ccat'];
}
 
    if ( !isset($azk) ) {
      $azk = 0;
      if ( $menu->getA(1) == 'S' OR $menu->getA(1) == 'E' ) {
        $azk = $menu->getE(1);
      }
    }
 
    $tpl->out(0); $class = 0;
    $abf = "SELECT id,besch,datei_name,endung FROM prefix_gallery_imgs WHERE cat = ".$azk;
    $erg = db_query($abf);
    $i = 0;
    while ($row = db_fetch_assoc($erg) ) {
                  $class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
      $row['class'] = $class;
      if ( $i <> 0 AND ($i % $allgAr['gallery_imgs_per_line'] ) == 0 ) { echo '</tr><tr>'; }
      $tpl->set_ar_out($row,1);
      $i++;
    }
 
    # links
    $tpl->out(2);
    # cat
    if ( $menu->getA(1) == 'E' ) {
      $erg = db_query("SELECT id,cat as Ccat,gallery_kat as katbild, recht as Crecht, name as Cname,pos as Cpos,`besch` as Cdesc FROM prefix_gallery_cats WHERE id = '".$menu->getE(1)."'");
                  $_Cilch = db_fetch_assoc($erg);
                        $_Cilch['Cpkey'] = $menu->getE(1);
                } else {
                  $_Cilch = array (
                          'Ccat' => '',
                          'katbild' => '',
                                'Cpkey' => '',
                                'Cpos' => '',
                                'Cname' => '',
        'Crecht' => '',
                                'Cdesc' => ''
                        );
                }
    #$_Cilch['Crecht'] = arlistee($_Cilch['Crecht'],getFuerAr());
          gallery_admin_selectcats('0','',$_Cilch['Ccat'],$_Cilch['Ccat']);
    $_Cilch['Ccat']   = '<option value="0">Keine</option>'.$_Cilch['Ccat'];
                $_Cilch['Crecht'] = dblistee($_Cilch['Crecht'],"SELECT id,name FROM prefix_grundrechte ORDER BY id DESC");
    gallery_admin_showcats ( 0 , '' );
 
    $tpl->set_ar($_Cilch);
    $tpl->out(3);
 
$design->footer();
?>

gallery.htm

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

<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/gallery.png" /></td><td width="30"></td><td valign="bottom"><h1>Gallery</h1></td></tr></table>
<form action="admin.php?gallery" method="POST">
<table width="100%">
  <tr>
          <td valign="top" width="60%" rowspan="2">
 
      <table cellpadding="3" border="0" cellspacing="5" class="border">
        <tr>
        {EXPLODE}
        <td class="{class}" valign="top">
          <table cellpadding="2" border="0" cellspacing="1" class="border">
            <tr>
              <td colspan="2" class="{class}"><font size="-1">include/images/gallery/img_norm_{id}.{endung}</font> </td>
            </tr>
            <tr>
              <td valign="top" class="{class}">
 
          <table cellpadding="1" border="0" cellspacing="0" class="border">
            <tr>
              <td class="Cmite"><a href="javascript:del({id})"><img src="include/images/icons/del.gif" border="0" title="löschen" alt="löschen"></a></td>
            </tr><tr>
              <td class="Cnorm"><a href="javascript:edit('{besch}',{id})"><img src="include/images/icons/edit.gif" title="ändern" border="0" alt="ändern"></a></td>
            </tr><tr>
              <td class="Cmite"><a href="javascript:reload({id})"><img src="include/images/icons/reload.gif" border="0" title="erneuern" alt="erneuern"></a></td>
            </tr><tr>
              <td class="Cnorm"><input type="checkbox" name="img[]" value="{id}" style="margin:0px; padding: 0px;" title="Bild für Verschieben markieren" /></td>
            </tr>
          </table>
              </td><td valign="top" class="{class}">
                <img title="{datei_name} |---| {besch}" alt="{datei_name}" src="include/images/gallery/img_thumb_{id}.{endung}" />
              </td>
            </tr>
          </table>
        </td>
        {EXPLODE}
        </tr>
      </table>
    </td>
    <td valign="top" width="40%">
 
<table cellpadding="3" border="0" cellspacing="1" class="border">
  <tr class="Chead">
                <td colspan="9"><b>Kategorien</b></td>
  </tr><tr class="Cmite">
    <td><a href="?gallery-S0">Keine</a></td>
    <td><a href="javascript:uploadImages(0)"><img src="include/images/icons/upload.gif" title="Bilder in diese Kategorie hochladen" alt="Bilder in diese Kategorie hochladen" border="0"></a></td>
    <td><a href="javascript:reloadImages(0)"><img src="include/images/icons/reload.gif" title="Bilder in diese Kategorie erneuern / einlesen" alt="Bilder in diese Kategorie erneuern / einlesen" border="0"></a></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
  </tr>{EXPLODE}
</table>
<br />
<table cellpadding="3" border="0" cellspacing="1" class="border">
  <tr class="Chead">
                <td colspan="9"><b>Bilder verschieben</b></td>
  </tr><tr class="Cmite"><td>nach:</td><td><select name="movecat">{Ccat}</select></td>
  </tr><tr class="Cdark">
        <td colspan="2"><input type="submit" value="markierte Bilder verschieben" name="movepics" /></td>
  </tr>
</table>
<br />
        <input type="hidden" name="Cpkey" value="{Cpkey}">
 
        <table class="border" cellpadding="3" cellspacing="1" border="0">
    <tr class="Chead">
                  <td colspan="2"><b>Gallery Kategorien</b></td>
                </tr>
      <td class="Cmite">Kategorie</td>
                        <td class="Cnorm"><select name="Ccat">{Ccat}</select></td>
    </tr>
    <tr>
      <td class="Cmite" align="right">Kategoriebild : </td>
      <td class="Cnorm"><input size="55" type="text" name="katbild" value="{katbild}"></td>
    </tr><tr>
      <td class="Cmite">Sichtbar&nbsp;ab</td>
                        <td class="Cnorm"><select name="Crecht">{Crecht}</select></td>
    </tr><tr>
      <td class="Cmite">Name</td>
                        <td class="Cnorm"><input type="text" name="Cname" value="{Cname}" /></td>
    </tr><tr>
      <td class="Cmite">Beschreibung</td>
                        <td class="Cnorm"><textarea cols="30" rows="3" name="Cdesc">{Cdesc}</textarea></td>
    </tr>
                <tr class="Cdark">
                  <td></td>
                        <td><input type="submit" value="Absenden" name="Csub" /></td>
                </tr>
  </table>
</form>
 
</td></td></table>
<script language="JavaScript" type="text/javascript">
<!--
 
  function Kdel ( id1 ) {
    var Fenster = window.open ('admin.php?gallery-D' + id1, 'delKat', 'status=yes,scrollbars=yes,height=150,width=550,left=300,top=50');
    Fenster.focus();
  }
  function del ( id1 ) {
    var x = confirm ( "Dieses Bild wirklich löschen?" );
                if ( x ) {
                  document.location.href="?gallery-d"+id1;
                }
        }
  function edit ( besch, id1 ) {
    var x = prompt ( "Bitte die neue Beschreibung eingeben!", besch);
    if ( x ) {
      document.location.href="?gallery-e"+id1+"=0&besch=" + x;
    }
  }
  function reload ( id1 ) {
    var x = confirm ( "Dieses Bild wirklich erneuern?" );
    if ( x ) {
      document.location.href="?gallery-r"+id1;
    }
  }
  function reloadImages (kid) {
    var Fenster = window.open ('admin.php?gallery-reloadImages-' + kid, 'reloadImages', 'status=yes,scrollbars=yes,height=500,width=350,left=300,top=50');
    Fenster.focus();
  }
  function uploadImages (kid) {
    var x = prompt ( "Wie viele Bilder möchten Sie hochladen?", "5");
    if ( x ) {
      var Fenster = window.open ('admin.php?gallery-uploadImages-' + kid + '=0&anzb=' + x, 'uploadImages', 'status=yes,scrollbars=yes,height=500,width=350,left=300,top=50');
      Fenster.focus();
    }
  }
//-->
</script>

Geschlossen

	Zurück zu HTML, PHP, SQL,...

Beitrag zur Merkliste hinzufügen

ilch Forum » Allgemein » HTML, PHP, SQL,... » Gallery Kategorie