ilch.de :: Forum :: Ilch Clan 1.1 :: Module und Modifikationen

include/contents

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

<?php 
#   Copyright by: Manuel Staechele
#   Support: www.ilch.de
 
 
defined ('main') or die ( 'no direct access' );
 
 
 
$title = $allgAr['title'].' :: Referenzen';
$hmenu = 'Referenzen';
$design = new design ( $title , $hmenu );
 
 
 
function referenzen_find_kat ($kat) {
     
        $katpfad = 'include/images/referenzen/';
        $katjpg = $katpfad.$kat.'.jpg';
        $katgif = $katpfad.$kat.'.gif';
        $katpng = $katpfad.$kat.'.png';
         
        if ( file_exists( $katjpg ) ) {
          $pfadzumBild = $katjpg;
        } elseif ( file_exists ( $katgif ) ) {
          $pfadzumBild = $katgif;
        } elseif ( file_exists ( $katpng ) ) {
          $pfadzumBild = $katpng;
        }
         
        if ( !empty( $pfadzumBild ) ) {
            $kategorie = '<img style="" src="'.$pfadzumBild.'" alt="'.$kat.'">';
        } else {
          $kategorie = '<b>'.$kat.'</b><br /><br />';
        }
         
        return ( $kategorie );
}
 
 
 
if ( !is_numeric($menu->get(1)) )  {
  if($menu->get(1) == 'rss' || $menu->get(1) == 'atom')
  {
      #ob_clean();
      $feed_type = $menu->get(1);
       
    $abf = "SELECT MAX(referenzen_time) AS last_update FROM prefix_referenzen";
    $erg = db_query($abf);
    $row = db_fetch_assoc($erg);
    $last_update = str_replace(' ', 'T', $row['last_update']) . 'Z';
     
    $abf = "SELECT
      a.referenzen_title as title,
      a.referenzen_id as id,";
    $abf .= ($feed_type == 'atom') ? 'a.referenzen_time as datum,' : "DATE_FORMAT(a.referenzen_time,'%a, %e %b %y %H:%i:%s') as datum,"; 
    $abf .=  
     "a.referenzen_kat as kate,
      a.referenzen_text as text,
    a.referenzen_designer as designer,
    a.referenzen_screen as screen,
      b.name as username
    FROM prefix_referenzen as a
    LEFT JOIN prefix_user as b ON a.user_id = b.id
    WHERE a.referenzen_recht = 0
    ORDER BY referenzen_time ASC LIMIT 15";
    $erg = db_query($abf);
    $tpl = new tpl( 'referenzen_'.$menu->get(1).'.htm' );
     
    header('Content-type: application/' . $menu->get(1)  . '+xml');
 
    $tpl->set_ar_out(array('FEEDTITLE' => $allgAr['title'],
                           'UPDATED' => $last_update), 0);
    while ($row = db_fetch_assoc($erg))
    {
      if($feed_type == 'atom')
      {
          $row['datum'] = str_replace(' ', 'T', $row['datum']) . 'Z';
      }
       
      $a = explode('[PREVIEWENDE]', $row['text']);
      $tpl->set_ar_out(array('TITLE' => $row['title'],
                             'TXT' => bbcode($a[0]),
                             'LINK' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']). '/index.php?referenzen-' . $row['id'],
                             'AUTHOR' => $row['username'],
                             'DATE' => $row['datum'],
                             'DESIGNER'  => $row-> referenzen_designer,
                             'SCREEN'  => $row-> referenzen_screen
                             ), 1);
    }
    $tpl->out(2);
    exit;
  }
  else
  {
    $design->header();
    $limit = $allgAr['Nlimit'];
    $page = ( $menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
    $MPL = db_make_sites ($page , "WHERE referenzen_recht >= ".$_SESSION['authright'] , $limit , '?referenzen' , 'referenzen' );
    $anfang = ($page - 1) * $limit;
     
    $tpl = new tpl ( 'referenzen.htm' );
 
    $abf = "SELECT
      a.referenzen_title as title,
      a.referenzen_id as id,
      DATE_FORMAT(a.referenzen_time,'%d. %m. %Y') as datum,
      DATE_FORMAT(a.referenzen_time,'%W') as dayofweek,
      a.referenzen_kat as kate,
      a.referenzen_text as text,
    a.referenzen_designer as designer,
    a.referenzen_slicer as slicer,
    a.referenzen_anpasser as anpasser,
    a.referenzen_code as code,
    a.referenzen_preis as preis,
    a.referenzen_anmerkung as anmerkung,
    a.referenzen_vprogramme as vprogramme,
    a.referenzen_zeit as zeit,
    a.referenzen_release as rel,
    a.referenzen_name as na,
    a.referenzen_nname as nna,
    a.referenzen_email as email,
    a.referenzen_icq as icq,
    a.referenzen_hp as hp,
    a.referenzen_screen as screen,
      b.name as username
    FROM prefix_referenzen as a
    LEFT JOIN prefix_user as b ON a.user_id = b.id
    WHERE ".$_SESSION['authright']." <= a.referenzen_recht
       OR a.referenzen_recht = 0
    ORDER BY referenzen_time DESC 
    LIMIT ".$anfang.",".$limit;
    #echo '<pre>'.$abf.'</pre>';
     
    $erg = db_query($abf);
    echo mysql_error();
    while ($row = db_fetch_assoc($erg)) {
       
      $k0m  = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = ".$row['id']." AND cat = 'referenzen'");
      $row['kom']  = db_result($k0m,0);
       
      $row['kate'] = referenzen_find_kat($row['kate']);
      $row['datum'] = $lang[$row['dayofweek']].' '.$row['datum'];
      if ( strpos ( $row['text'] , '[PREVIEWENDE]' ) !== FALSE ) {
        $a = explode('[PREVIEWENDE]' , $row['text']);
        $row['text'] = $a[0];
      }
      $row['text'] = bbcode($row['text']);
      $tpl->set_ar_out($row,0);
    }
    $tpl->set_out('SITELINK', $MPL,1);
    unset($tpl);
  }
 
   
   
} else {
  
 $design->header();
 $nid = escape($menu->get(1), 'integer');
 $row = db_fetch_object(db_query("SELECT * FROM `prefix_referenzen` WHERE referenzen_id = '".$nid."'"));
 
  if ( has_right(array($row->referenzen_recht)) ) {
    $komsOK = true;
      if ( $allgAr['Ngkoms'] == 0 ) {
      if ( loggedin() ) {
        $komsOK = true;
        } else {
          $komsOK = false;
          }
    }
      if ( $allgAr['Nukoms'] == 0 ) {
        $komsOK = false;
      }
 
    # kommentar add
    if ( (loggedin() OR chk_antispam ('referenzenkom')) AND $komsOK AND !empty($_POST['name']) AND !empty($_POST['txt']) ) {
      $_POST['txt'] = escape($_POST['txt'],'string');
          $_POST['name'] = escape($_POST['name'],'string');
      db_query("INSERT INTO `prefix_koms` VALUES ('',".$nid.",'referenzen','".$_POST['name']."','".$_POST['txt']."')");
      } 
      # kommentar add
         
    # kommentar loeschen
    if ($menu->getA(2) == 'd' AND is_numeric($menu->getE(2)) AND has_right(-7, 'referenzen')) {
      $kommentar_id = escape($menu->getE(2),'integer');
      db_query("DELETE FROM prefix_koms WHERE uid = ".$nid." AND cat = 'referenzen' AND id = ".$kommentar_id);
    }
    # kommentar loeschen
    $kategorie = referenzen_find_kat($row->referenzen_kat);
         
        $textToShow = bbcode($row->referenzen_text);
        $textToShow = str_replace('[PREVIEWENDE]','',$textToShow);
        if ( !empty($such) ) {
          $textToShow = markword($textToShow,$such);
        }
         
        $tpl = new tpl ( 'referenzen.htm' );
        $ar = array (
      'TEXT'  => $textToShow,
            'KATE'  => $kategorie,
      'NID' => $nid,
      'uname' => $_SESSION['authname'],
            'ANTISPAM' => (loggedin()?'':get_antispam ('referenzenkom', 0)),
            'NAME'  => $row->referenzen_title,
                'DESIGNER'  => $row-> referenzen_designer,
    'SILCER'  => $row-> referenzen_slicer,
    'ANPASSER'  => $row-> referenzen_anpasser,
    'CODE'  => $row-> referenzen_code,
    'PREIS'  => $row-> referenzen_preis,
    'ANMERKUNG'  => $row-> referenzen_anmerkung,
    'VPROGRAMME'  => $row-> referenzen_vprogramme,
    'ZEIT'  => $row-> referenzen_zeit,
    'RELEASE'  => $row-> referenzen_release,
    'NAME'  => $row-> referenzen_name,
    'NNAME'  => $row-> referenzen_nname,
    'EMAIL'  => $row-> referenzen_email,
    'ICQ'  => $row-> referenzen_icq,
    'HP'  => $row-> referenzen_hp,
    'SCREEN'  => $row-> referenzen_screen,
        );
        $tpl->set_ar_out($ar, 2 );
         
        if ($komsOK) {
          $tpl->set_ar_out ( array ( 'NAME' => $row->referenzen_title , 'NID' => $nid ), 3 );
        }
    $erg1 = db_query("SELECT text, name, id FROM `prefix_koms` WHERE uid = ".$nid." AND cat = 'referenzen' ORDER BY id DESC");
        $ergAnz1 = db_num_rows($erg1);
        if ( $ergAnz1 == 0 ) {
          echo '<b>'.$lang['nocomments'].'</b>';
        } else {
          $zahl = $ergAnz1;
          while ($row1 = db_fetch_assoc($erg1)) {
        $row1['text'] = bbcode(trim($row1['text']));
        if (has_right(-7, 'referenzen')) {
          $row1['text'] .= '<a href="?referenzen-'.$nid.'-d'.$row1['id'].'"><img src="include/images/icons/del.gif" alt="l&ouml;schen" border="0" title="l&ouml;schen" /></a>';
        }
        $tpl->set_ar_out( array('NAME' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ) , 4 );
        $zahl--;
          }
    }
    }
  $tpl->out(5);
}
 
$design->footer();
 
?>

include/templates

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

      <table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#F8F8F8" id="table25">  <tr bgcolor="#F8F8F8"> 
    <td class="title" colspan="2" width="100%"><a href="index.php?referenzen-{id}" target="_self"><h2>&raquo; &nbsp;{title}</h2></a></td>
  </tr>
  <tr>
   <td bgcolor="#F8F8F8" colspan="2" width="100%"></td>
  </tr>
  <tr bgcolor="#F8F8F8">
    <td bgcolor="#F8F8F8" width="110" height="170"><p align="center"><a href="{screen}" target="_blank" ><img src="{screen}" alt="" border="0" width="150" height="150"></a></td>
    <td bgcolor="#F8F8F8" width="100%" valign="top" height="170">
      <table border="0" width="100%" cellspacing="1" cellpadding="2" id="table26">
      <tr> 
        <td width="100%"><a href="" target="_blank"></a></td>
 
      </tr>
      <tr> 
        <td width="100%" style="border-bottom: 1px dashed #DEDEDE;" size="1">Referenz wurde eingetragen von 
        <b>{username}</b></td>
      </tr>
      <tr> 
        <td width="100%" style="border-bottom: 1px dashed #DEDEDE;" size="1">Design wurde erstellt von 
        {designer}</td>
      </tr>
      <tr> 
        <td width="100%" style="border-bottom: 1px dashed #DEDEDE;" size="1">Beschreibung: {text}</td>
 
      </tr>
      <tr>
        <td><a href="index.php?referenzen-{id}" target="_self">Mehr Details</a></td>
      </tr>
    </table>
    </td></tr>
     <tr bgcolor="#F8F8F8">
    <td bgcolor="#F8F8F8" width="110" colspan="2"></td>
 
</tr>  </table>
   
 
 
<br />
<br />
{EXPLODE}
<br />
<br />
<center>{SITELINK}</center>
   
{EXPLODE}
<!-- News Kommentare und Mehr lesen -->
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="table16">
  <tr> 
    <td width="150%" valign="top"> 
    <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table17">
        <tr> 
          <td width="100%" valign="top">
            <table width="100%" cellpadding="2" cellspacing="1" bgcolor="#F8F8F8" id="table18">
              <tr> 
                <td colspan="2" class="title" bgcolor="#F8F8F8">&nbsp;<b>&raquo; </b>
                   {NAME}</td>
 
              </tr>
              <tr> 
                <td colspan="2" bgcolor="#F8F8F8"></td>
              </tr>
              <tr> 
                <td width="35%" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Designer:</b></td>
                <td width="65%" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
                {DESIGNER}</td>
              </tr>
              <tr> 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Slicer:</b></td>
 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
                {SILCER}</td>
              </tr>
              <tr> 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Anpasser:</b></td>
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
                {ANPASSER}</td>
              </tr>
              <tr> 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Code:</b></td>
 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
                {CODE}</td>
              </tr>
              <tr> 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>
                Preis:</b></td>
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
                {PREIS}</td>
              </tr>
              <tr> 
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Homepage Link:</b></td>
                <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
                <a href="http://{HP}" target="_blank">{HP}</a></td>
              </tr>
            </table></td>
          <td width="7">&nbsp;&nbsp;</td>
 
          <td width="150" valign="top">
            <table width="100%" cellpadding="2" cellspacing="1" bgcolor="#F8F8F8" id="table19">
              <tr> 
                <td class="title" bgcolor="#F8F8F8">&nbsp; <b>&raquo; </b> Screenshot:</td>
              </tr>
              <tr> 
                <td bgcolor="#F8F8F8"></td>
              </tr>
              <tr> 
                <td align="center" bgcolor="#F8F8F8"><a href="{SCREEN}" target="_blank" >
                <img src="{SCREEN}" alt="" border="0" width="150" height="148"></a></td>
 
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td width="100%" valign="top">&nbsp;&nbsp; </td>
  </tr>
  <tr> 
    <td width="100%" valign="top"> 
    <table width="100%" cellspacing="1" cellpadding="2" bgcolor="#F8F8F8" id="table20">
 
        <tr> 
          <td class="title" bgcolor="#F8F8F8"> &nbsp;<b>&raquo; </b> Anmerkungen</td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8"></td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8">{ANMERKUNG}</td>
        </tr>
      </table></td>
  </tr>
 
  <tr> 
    <td width="100%" valign="top"> &nbsp;&nbsp; </td>
  </tr>
  <tr> 
    <td width="100%" valign="top"> 
    <table width="100%" cellspacing="1" cellpadding="2" bgcolor="#F8F8F8" id="table21">
        <tr> 
          <td colspan="2" class="title" bgcolor="#F8F8F8">&nbsp; <b>&raquo; </b> Sonstige 
            Informationen</td>
 
        </tr>
        <tr> 
          <td colspan="2" bgcolor="#F8F8F8"></td>
        </tr>
        <tr> 
          <td width="35%" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Verwendete 
            Programme:</b></td>
          <td width="65%" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
            {VPROGRAMME}</td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Zeit:</b></td>
 
          <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
            {ZEIT}</td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Release:</b></td>
          <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1">
            {RELEASE}</td>
        </tr>
        </table></td>
  </tr>
  <tr> 
    <td width="100%" valign="top"> &nbsp;&nbsp; </td>
  </tr>
  <tr> 
    <td width="100%" valign="top"> 
    <table width="100%" cellspacing="1" cellpadding="2" bgcolor="#F8F8F8" id="table22">
 
        <tr> 
          <td colspan="2" class="title" bgcolor="#F8F8F8" width="1221">&nbsp; 
            <b>&raquo; </b> Auftraggeber Details</td>
        </tr>
        <tr> 
          <td colspan="2" bgcolor="#F8F8F8" width="1221"></td>
        </tr>
        <tr> 
          <td width="198" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Name, 
            Vorname:</b></td>
 
          <td width="1015" align="center" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;" size="1"> 
            <p align="left">{NAME}</p></td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8" width="198" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Nickname:</b></td>
          <td bgcolor="#F8F8F8" align="center" width="1015" style="border-bottom: 1px dashed #DEDEDE;" size="1"> 
            <p align="left">{NNAME}</td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8" width="198" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Email 
            Adresse:</b></td>
 
          <td bgcolor="#F8F8F8" align="center" width="1015" style="border-bottom: 1px dashed #DEDEDE;" size="1"> 
            <p align="left"><a href="mailto:{EMAIL}">{EMAIL}</a></p></td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8" width="198" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>ICQ 
            Nummer:</b></td>
          <td bgcolor="#F8F8F8" align="center" width="1015" style="border-bottom: 1px dashed #DEDEDE;" size="1"> 
            <p align="left">{ICQ}</p></td>
        </tr>
        <tr> 
          <td bgcolor="#F8F8F8" width="198" style="border-bottom: 1px dashed #DEDEDE;" size="1"><b>Homepage:</b></td>
 
          <td bgcolor="#F8F8F8" align="center" width="1015" style="border-bottom: 1px dashed #DEDEDE;" size="1"><p align="left">
                <a href="http://{HP}" target="_blank">{HP}</a></p></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td width="100%" valign="top"></td>
  </tr>
</table>
 
<p>&nbsp;</p>
<table class="border" width="100%" cellpadding="5" cellspacing="1" border="0" id="table23">
     
  <tr> 
    <td height="25" bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;">{_lang_commentsfor} {NAME}</td>
  </tr>
  <tr>
    <td bgcolor="#F8F8F8" style="border-bottom: 1px dashed #DEDEDE;">
     
        {EXPLODE}
        <form action="index.php?referenzen-{NID}" method="POST">
        <fieldset>
          <legend>{_lang_writecomment}</legend>
          <input type="text" name="name" value="{uname}" /> &nbsp; {ANTISPAM} &nbsp; <input type="submit" value="{_lang_enter}"><br />
          <textarea style="width: 98%" cols="50" rows="2" name="txt"></textarea><br />
        </fieldset>
      </form>
      <br />
      {EXPLODE}
       
      <span class="Cmite"># <b>{ZAHL}</b> von {NAME}</span>
      <br />{TEXT}<br /><br />
       
      {EXPLODE}
      <br />
      <a href="index.php?referenzen"><b>&laquo;</b> {_lang_back}</a>
       
    </td>
  </tr>
</table>
 
{EXPLODE}
 
<table width="100%" border="0" cellspacing="0" cellpadding="5" class="rand" id="table24">
  <tr class="mite"> 
    <td width="65%"><b>{NAME}</b></td>
    <td width="15%">{FUER}</td>
    <td width="20%" align="right">{DATE}</td>
  </tr><tr class="norm"> 
    <td valign="top" colspan="2">{TEXT}{MEHR}</td>
    <td valign="top" rowspan="2" align="center">{KATE}</td>
  </tr><tr class="norm"> 
    <td valign="bottom" height="20" colspan="2" align="center"> 
      <b>{_lang_from} {UNAME}</b> &nbsp; &nbsp; &nbsp; [ {KOM} <a href="index.php?referenzen-1&amp;nid={ID}">{_lang_comments}</a> ] 
    </td>
  </tr>
</table>

include/admin

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

<?php 
#   Copyright by: Manuel Staechele
#   Support: www.ilch.de
 
 
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
 
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
 
//-----------------------------------------------------------|
 
##
###
####
##### F u n k t i o n e n 
 
function getKats ( $akt ) {
  $katAR = array();
    $kats = '';
    $erg = db_query("SELECT DISTINCT referenzen_kat FROM `prefix_referenzen`");
    while ($row = db_fetch_object($erg)) {
        $katAr[] = $row->referenzen_kat;
    }
  $katAr[] = 'Allgemein';
    $katAr = array_unique($katAr);
    foreach($katAr as $a) {
      if (trim($a) == trim($akt)) {
          $sel = ' selected';
        } else {
          $sel = '';
        }
      $kats .= '<option'.$sel.'>'.$a.'</option>';
    } 
  return ($kats);
}
 
##### F u n k t i o n
####
###
##
#
##
###
####
##### A k t i o n e n
 
if ( !empty($_REQUEST['um']) ) {
  $um = $_REQUEST['um'];
  if ( $um == 'insert' ) {
       
# insert
        $text  = escape($_POST['txt'], 'textarea');
        if ( $_POST['katLis'] == 'neu' ) {
          $_POST['katLis'] = $_POST['kat'];
        }
        db_query("INSERT INTO `prefix_referenzen` (referenzen_title,user_id,referenzen_time,referenzen_recht,referenzen_kat,referenzen_text,referenzen_designer,referenzen_slicer,referenzen_anpasser,referenzen_code,referenzen_preis,referenzen_anmerkung,referenzen_vprogramme,referenzen_zeit,referenzen_release,referenzen_name,referenzen_nname,referenzen_email,referenzen_icq,referenzen_hp,referenzen_screen)
        VALUES ('".$_POST['titel']."',".$_SESSION['authid'].",NOW(),".escape($_POST['grecht'],'integer').",'".$_POST['katLis']."','".$text."','".$_POST['designer']."','".$_POST['slicer']."','".$_POST['anpasser']."','".$_POST['code']."','".$_POST['preis']."','".$_POST['anmerkung']."','".$_POST['vprogramme']."','".$_POST['zeit']."','".$_POST['release']."','".$_POST['name']."','".$_POST['nname']."','".$_POST['email']."','".$_POST['icq']."','".$_POST['hp']."','".$_POST['screen']."')");
      echo mysql_error();
# insert        
         
    } elseif ( $um == 'change' ) {
 
# edit
      $text  = escape($_POST['txt'],'textarea');
         
        if ( $_POST['katLis'] == 'neu' ) {
          $_POST['katLis'] = $_POST['kat'];
        }
        db_query('UPDATE `prefix_referenzen` SET
                referenzen_title = "'.$_POST['titel'].'",
                user_id  = "'.$_SESSION['authid'].'",
                referenzen_recht = "'.$_POST['grecht'].'",
                referenzen_kat   = "'.$_POST['katLis'].'",
                referenzen_designer  = "'.$_POST['designer'].'",
        referenzen_slicer  = "'.$_POST['slicer'].'",
        referenzen_anpasser  = "'.$_POST['anpasser'].'",
        referenzen_code  = "'.$_POST['code'].'",
        referenzen_preis  = "'.$_POST['preis'].'",
        referenzen_anmerkung  = "'.$_POST['anmerkung'].'",
        referenzen_vprogramme  = "'.$_POST['vprogramme'].'",
        referenzen_zeit  = "'.$_POST['zeit'].'",
        referenzen_release  = "'.$_POST['release'].'",
        referenzen_name  = "'.$_POST['name'].'",
        referenzen_nname  = "'.$_POST['nname'].'",
        referenzen_email  = "'.$_POST['email'].'",
        referenzen_icq  = "'.$_POST['icq'].'",
        referenzen_hp  = "'.$_POST['hp'].'",
        referenzen_screen  = "'.$_POST['screen'].'",
                referenzen_text  = "'.$text.'" WHERE referenzen_id = "'.$_POST['referenzenID'].'" LIMIT 1');
                      echo mysql_error();
      $edit = $_POST['referenzenID'];
  }
}
# edit
 
 
# del
if ( $menu->get(1) == 'del' ) {
  db_query('DELETE FROM `prefix_referenzen` WHERE referenzen_id = "'.$menu->get(2).'" LIMIT 1');
}
#del
 
 
##### A k t i o n e n
####
###
##
#
##
###
####
##### h t m l   E i n g a b e n
 
 
 
 
if ( empty ($doNoIn) ) {
    
    $limit = 20;  // Limit 
  $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
  $MPL = db_make_sites ($page , '' , $limit , "?referenzen" , 'referenzen' );
  $anfang = ($page - 1) * $limit;
    if ( $menu->get(1) != 'edit' ) {
      $FreferenzenID = '';
        $Faktion = 'insert';
        $Fueber  = '';
            $Fueber1  = '';
    $Fueber2  = '';
    $Fueber3  = '';
    $Fueber4  = '';
    $Fueber5  = '';
    $Fueber6  = '';
    $Fueber7  = '';
    $Fueber8  = '';
    $Fueber9  = '';
    $Fueber10  = '';
    $Fueber11  = '';
    $Fueber12  = '';
    $Fueber13  = '';
    $Fueber14  = '';
    $Fueber15  = '';
        $Fstext  = '';
        $Ftxt    = '';
        $Fgrecht = '';
        $FkatLis = '';
        $Fsub    = 'Eintragen';
    } else {
      $row = db_fetch_object(db_query("SELECT * FROM `prefix_referenzen` WHERE referenzen_id = ".$menu->get(2)));
      $FreferenzenID = $row->referenzen_id;
        $Faktion = 'change';
        $Fueber  = $row->referenzen_title;
        $Ftxt    = stripslashes($row->referenzen_text);
    $Fueber1  = $row->referenzen_designer;
    $Fueber2  = $row->referenzen_slicer;
    $Fueber3  = $row->referenzen_anpasser;
    $Fueber4  = $row->referenzen_code;
    $Fueber5  = $row->referenzen_preis;
    $Fueber6  = $row->referenzen_anmerkung;
    $Fueber7  = $row->referenzen_vprogramme;
    $Fueber8  = $row->referenzen_zeit;
    $Fueber9  = $row->referenzen_release;
    $Fueber10  = $row->referenzen_name;
    $Fueber11  = $row->referenzen_nname;
    $Fueber12  = $row->referenzen_email;
    $Fueber13  = $row->referenzen_icq;
    $Fueber14  = $row->referenzen_hp;
    $Fueber15  = $row->referenzen_screen;
        $Fgrecht = $row->referenzen_recht;
        $FkatLis = $row->referenzen_kat;
        $Fsub    = '&Auml;ndern';
    }
$tpl = new tpl ( 'referenzen', 1);
 
  $ar = array
              (
                'referenzenID' => $FreferenzenID,
                    'AKTION' => $Faktion,
                    'MPL'    => $MPL,
                    'UEBER'  => $Fueber,
                    'txt'    => $Ftxt,
                    'UEBER1'  => $Fueber1,
'UEBER2'  => $Fueber2,
'UEBER3'  => $Fueber3,
'UEBER4'  => $Fueber4,
'UEBER5'  => $Fueber5,
'UEBER6'  => $Fueber6,
'UEBER7'  => $Fueber7,
'UEBER8'  => $Fueber8,
'UEBER9'  => $Fueber9,
'UEBER10'  => $Fueber10,
'UEBER11'  => $Fueber11,
'UEBER12'  => $Fueber12,
'UEBER13'  => $Fueber13,
'UEBER14'  => $Fueber14,
'UEBER15'  => $Fueber15,
          'SMILIS' => getsmilies(),
                    'grecht' => dbliste($Fgrecht,$tpl,'grecht',"SELECT id,name FROM prefix_grundrechte ORDER BY id DESC"),
                    'KATS'   => getKats($FkatLis),
                    'FSUB'   => $Fsub
                             
      );
         
        $tpl->set_ar_out($ar,0);
         
     
    # e d i t , d e l e t e
  $abf = 'SELECT referenzen_id,referenzen_title,referenzen_designer,referenzen_slicer,referenzen_anpasser,referenzen_code,referenzen_preis,referenzen_anmerkung,referenzen_vprogramme,referenzen_zeit,referenzen_release,referenzen_name,referenzen_nname,referenzen_email,referenzen_icq,referenzen_hp,referenzen_screen
            FROM `prefix_referenzen` 
                    ORDER BY referenzen_time DESC 
                    LIMIT '.$anfang.','.$limit;
                     
  $erg = db_query($abf);
  $class = '';
    while ($row = db_fetch_object($erg) ) {
    $class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
        $tpl->set_ar_out( array ( 'ID' => $row->referenzen_id, 'class' => $class, 'TITEL' => $row->referenzen_title,    'DESIGNER'  => $row-> referenzen_designer,    'SILCER'  => $row-> referenzen_slicer,    'ANPASSER'  => $row-> referenzen_anpasser,    'CODE'  => $row-> referenzen_code,    'PREIS'  => $row-> referenzen_preis,    'ANMERKUNG'  => $row-> referenzen_anmerkung,    'VPROGRAMME'  => $row-> referenzen_vprogramme,    'ZEIT'  => $row-> referenzen_zeit,    'RELEASE'  => $row-> referenzen_release,    'NAME'  => $row-> referenzen_name,    'NNAME'  => $row-> referenzen_nname,    'EMAIL'  => $row-> referenzen_email,    'ICQ'  => $row-> referenzen_icq,    'HP'  => $row-> referenzen_hp,    'SCREEN'  => $row-> referenzen_screen) , 1 );
    }
  # e d i t , d e l e t e
 
  $tpl->set_ar_out( array ('MPL' => $MPL ) , 2 );
 
}
 
$design->footer();
?>

include/admin/templates

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

<script language="JavaScript" type="text/javascript"><!--
function delcheck ( DELID ) {
    var frage = confirm ( "Willst du diesen Eintrag wirklich l&#65533;schen?" );
    if ( frage == true ) {
      document.location.href="?referenzen-del-"+DELID;
    }
}
 
function delKcheck ( DELID , NID) {
    var frage = confirm ( "Willst du dieses Kommentar wirklich l&#65533;schen?" );
    if ( frage == true ) {
      document.location.href="?referenzen-sKoms-"+NID+"-Kdel-"+DELID+"#"+NID;
    }
}
 
function sichtbar(){
    if( document.form.katLis.value=="neu"){
      document.form.kat.style.visibility="visible";
    } else {
      document.form.kat.style.visibility="hidden";
  }
}
//--></script>
 
<script type='text/javascript' src='include/includes/js/bbcode.js'></script>
 
<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/referenzen.png" /></td><td width="30"></td><td valign="bottom"><h1>Referenzen</h1></td></tr></table>
<hr style="width: 400px; margin: 0px;" >
<br /><br />
 
<table border="0" cellspacing="0" cellpadding="0"><tr><td valign="top">
 
<form method="POST" name="form" action="?referenzen">
  <input type="hidden" name="um"     value="{AKTION}">
  <input type="hidden" name="referenzenID" value="{referenzenID}">
    <table cellpadding="2" cellspacing="1" border="0" class="border">
    <tr> 
      <td class="Cmite" align="right"><strong>Titel : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="titel" value="{UEBER}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Referenzen : </strong></td>
      <td rowspan="2" class="Cnorm">
       
      <!-- BB Code START -->
        <a href="javascript:simple('b')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.bold.gif" alt="b" title="{_lang_bold}" border="0"></a>
      <a href="javascript:simple('i')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.italic.gif" alt="i" title="{_lang_italic}" border="0"></a>
      <a href="javascript:simple('u')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.underline.gif" alt="u" title="{_lang_underlined}" border="0"></a>
      <a href="javascript:simple('code')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.code.gif" alt="Code" title="{_lang_code}" border="0"></a>
        <a href="javascript:simple_liste()"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.insertunorderedlist.gif" alt="{_lang_list}" title="{_lang_list}" border="0"></a>
      <a href="javascript:simple('url')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.link.gif" alt="Url" title="{_lang_link}" border="0"></a>
      <a href="javascript:simple('img')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.image.gif" alt="{_lang_picture}" title="{_lang_picture}" border="0"></a>
      <!-- BB Code ENDE -->
 
      </td>
    </tr><tr>
      <td rowspan="2" align="center" valign="top" class="Cmite"><br>{SMILIS}</td>
    </tr><tr>
      <td class="Cnorm"><textarea name="txt" rows="15" cols="65" tabindex="2">{txt}</textarea></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Designer : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="designer" value="{UEBER1}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Slicer : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="slicer" value="{UEBER2}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Anpasser : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="anpasser" value="{UEBER3}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Code : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="code" value="{UEBER4}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Preis : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="preis" value="{UEBER5}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong></strong></td>
      <td class="Cnorm"><strong>Anmerkungen</strong></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Anmerkung : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="anmerkung" value="{UEBER6}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong></strong></td>
      <td class="Cnorm"><strong>Sonstige Informationen</strong></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>verwendete Programme : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="vprogramme" value="{UEBER7}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Zeit : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="zeit" value="{UEBER8}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Release : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="release" value="{UEBER9}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong></strong></td>
      <td class="Cnorm"><strong>Auftraggeber Details</strong></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Name : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="name" value="{UEBER10}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Nickname : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="nname" value="{UEBER11}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>E-Mail : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="email" value="{UEBER12}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>ICQ : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="icq" value="{UEBER13}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Homepage : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="hp" value="{UEBER14}"></td>
    </tr><tr> 
      <td class="Cmite" align="right"><strong>Screenshot-Link : </strong></td>
      <td class="Cnorm"><input size="50" type="text" name="screen" value="{UEBER15}"></td>
    </tr><tr class="Cdark"> 
      <td></td>
      <td><input type="submit" value="{FSUB}" name="submit"></td>
    </tr>
  </table>
</form>
<br /><br />
 
<div class="info_box">
            <b>Merke (Kategorie Bild)</b>
            <br />
            <span class="smalfont">
            Das Kategorie Bild muss in den Ordner include/images/referenzen/
            <br />
            Das Bild muss genau wie die Kategorie heissen z.B. wenn die Kategorie
            Allgemein heisst dann muss das Bild Allgemein heissen;)...
            <br />
            Die Endung muss entweder .jpg oder .gif sein bei uns also z.B. Allgemein.jpg
            </span>
</div>
 
<div class="info_box">
                <b>Merke (Vorschau Funktion)</b>
                <br />
                <span class="smalfont">
                Soll nur ein kleinerer Vorschautext angezeigt werden, einfach erst die Vorschau
                eingeben und nach der Vorschau dann <b>[PREVIEWENDE]</b> schreiben. Dann den langen
                Text eintragen.
                </span>
</div>
 
</td><td width="75">&nbsp;</td><td valign="top">
 
{MPL}
<table cellpadding="3" cellspacing="1" border="0" class="border">
  {EXPLODE}<tr class="{class}">
      <td><a href="#" name="{ID}"></a><a href="javascript:delcheck({ID})"><img src="include/images/icons/del.gif" alt="L&ouml;schen" title="L&ouml;schen" border="0"></a></td>
    <td><a href="?referenzen-edit-{ID}"><img src="include/images/icons/edit.gif" alt="Ver&auml;ndern" title="Ver&auml;ndern" border="0"></a></td>
        <td>{TITEL}</td>
 </tr>{EXPLODE}
</table>
{MPL}
 
</td></tr></table>
 
<script language="JavaScript" type="text/javascript">
<!--
  sichtbar();
//-->
</script>

vil schreibt ja jemand die install dazu

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » referenzen modul