Fehler Anzeige im Admin Menü

Gehe zu Seite:

Geschlossen

Fr. 28.04.2017 14:19 Uhr #1

xRebellx Mitglied

Registriert seit
07.08.2012

Beiträge
579

Beitragswertungen

Hay Leute,

So einen kleinen fehler habe ich noch gefunden und zwar im Admin Bereich

Da wird mir folgender Fehler angezeigt regist; $regday = round($regsek / 86400); $user = $row->name; echo'';} ?>
'.$user.' Registriert am "'.date('d.m.Y',$row->regist).'"
';} ?>
'.$row->news_title.' Siehe Bild

Habe schon PimpmyilchAdminI noch mal hoch geladen aber das brachte auch keine Lösung und wenn da jemand eine Lösung weis dann immer her damit :-)

verwendete ilch Version: 1.1 P

betroffene Homepage: freiezocker.de/

freiezocker.de/
0 Mitglieder finden den Beitrag gut.
- zitieren
Fr. 28.04.2017 15:27 Uhr #2

Lord|Schirmer Administrator

Registriert seit
21.03.2007

Beiträge
7.680

Beitragswertungen

Du hast eine Modifikation des Admin-Bereiches drauf.
Deshalb kann der Fehler schwer nachvollzogen werden.

Prüfe mal den Code der include/admin/admin.php evtl. fehlt hier nur ein echo

rules :: doku :: faq :: linkus
0 Mitglieder finden den Beitrag gut.
- zitieren

Fr. 28.04.2017 16:06 Uhr #3

xRebellx Mitglied

Zitat geschrieben von Lord|Schirmer

Du hast eine Modifikation des Admin-Bereiches drauf.
Deshalb kann der Fehler schwer nachvollzogen werden.

Prüfe mal den Code der include/admin/admin.php evtl. fehlt hier nur ein echo

Hallo Lord Schirmer hier mal der Code

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

<?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();
 
# script version
$scriptVersion = 11;
$scriptUpdate = 'M';
 
# statistik wird bereinigt.
$mon = date('n');
$lastmon = $mon - 1;
$jahr = date('Y');
$lastjahr = $jahr;
if ( $lastmon <= 0 ) { $lastmon = 12; $lastjahr = $jahr - 1; }
 
db_query("DELETE FROM prefix_stats WHERE NOT ((mon = $mon OR mon = $lastmon) AND (yar = $jahr OR yar = $lastjahr))");
db_query("OPTIMIZE TABLE prefix_stats");
 
 
    $um = $menu->get(1);
    switch($um)
    {
 
        default :
                {
           ?>
<table class="border" cellspacing="1" cellpadding="0" width="100%" border="0">
 <tr>
  <td class="Chead" height="20">&nbsp;Info</td>
 </tr>
    <td>
  <table  cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td class="Cnorm" align="center" width="20%">
<?php echo getCalendar($mon, $jahr, $url, $urlod, $data, $cellpadding=2);?>
</td>
<td class="Cnorm" align="center" valign="top" width="60%">N&auml;chsten Geburtstage<hr style="height: 0px; border: dotted #444444 0px; border-top-width: 1px; " /><br>
<? include ('include/boxes/geburtstag.php');?>
</td>
<td class="Cnorm" align="center" width="20%">
<embed src="http://www.clocklink.com/clocks/0008-Orange.swf?TimeZone=WET" width="150" height="150" wmode="transparent" type="application/x-shockwave-flash">
</td>
 
</tr>
</table>
 
  </td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="4">Statistik</td>
 </tr>
    <tr>
  <td class="Cnorm" width="25%"><font class="smalfont">Design</font></td>
  <td class="Cnorm" width="25%" nowrap><font class="smalfont">
<? echo $allgAr['gfx']; ?>
  </font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">Installierte Version</font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">
<?php echo ''.$scriptVersion.'&nbsp; Update: '.$scriptUpdate.''; ?>
  </font></td>
  </tr>
  <tr>
  <td class="Cnorm"><font class="smalfont">Datenbankgr&ouml;&szlig;e</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
// gibt die groesse der Datenbank  aus
$result = db_query("SHOW TABLE STATUS");
    $dbsize = 0;
    while($row = mysql_fetch_assoc($result)) {
        $dbsize += $row['Data_length'];
    }echo nicebytes($dbsize);
?>
  </font></td>
  <td class="Cnorm"><font class="smalfont">Downloads</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  echo nicebytes(dirsize('include/downs/'));
?>
 </font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">Benutzer &amp; G&auml;ste online</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php echo '<b>'.ges_online().'</b> Benutzer und <b>'.ges_gast_online().'</b> G&auml;ste';?>
  &nbsp; <a class="smalfont" href="admin.php?admin-userOnline">&#187; anzeigen</a></font></td>
 
  <td class="Cnorm" nowrap><font class="smalfont">Web Status</font></td>
  <td class="Cnorm"><font class="smalfont">
<?
  if ($allgAr['wartung'] == 0){
     echo 'Seite &Ouml;ffentlich';
  }else
    echo '<b>Wartungs Modus</b>&nbsp;<img src="include/images/icons/wartung.png">';
?>
  </a></font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">nicht aktivierte Accounts</font></td>
  <td class="Cnorm"><font class="smalfont">
<?
  $gesuser  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 1"),0);
  echo '<b>'.$gesuser.'</b>';
?>
  &nbsp; <a class="smalfont" href="admin.php?puser">&#187; anzeigen</a>
  </font></td>
 
  <td class="Cnorm"nowrap><font class="smalfont">nicht aktivierte Join Us</font></td>
  <td class="Cnorm"><font class="smalfont">
  <?
 $joinus  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 4"),0);
  echo '<b>'.$joinus.'</b>';
  ?>
  &nbsp; <a class="smalfont" href="admin.php?groups-joinus">&#187; anzeigen</a>
  </font></td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="2">Die neusten Mitglieder</td>
  <td class="Chead" colspan="2">Die letzten Artikel, News ...</td>
 </tr>
 <tr>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?
  $abf = 'SELECT * FROM prefix_user ORDER BY regist DESC LIMIT 5';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
  $regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') )  - $row->regist;
  $regday = round($regsek / 86400);
  $user = $row->name;
  echo'<tr class="Cnorm"><td><a href="?user-1-'.$row->id.'"><b>'.$user.'</b></a></td><td> Registriert am "'.date('d.m.Y',$row->regist).'"</td></tr>';}
?>
   </table>
  </td>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?
  $abf = 'SELECT news_id,news_title FROM `prefix_news` ORDER BY news_time DESC LIMIT 5';
    $erg = db_query($abf);
    while ($row = db_fetch_object($erg) ) {
        echo'<tr class="Cnorm"><td><a href="?news-edit-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';}
?>
   </table>
  </td>
 </tr>
 <tr>
  <td class="Chead" colspan="4" align="right"><a class="Chead" href="admin.php?about">Systeminformationen</a></td>
 </tr>
</table>
 
 
 
 
           <?php
                   break;
        }
 
                case 'versionsKontrolle' :
        {
 
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/version_check.png" /></td><td width="30"></td><td valign="bottom"><h1>Versionskontrolle</h1></td></tr></table>';
 
 
                        echo 'Scripte Version: '.$scriptVersion.'<br />Update Version: '.$scriptUpdate.'<br /><br />';
                        echo '<script language="JavaScript" type="text/javascript" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></script>';
                        #echo '<iframe width="100%" height="60" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></iframe>';
 
                        break;
        }
 
                #####################################
 
                case 'besucherStatistik' :
                {
            function echo_admin_site_statistik ($title, $col, $smon, $ges, $orderQuery ) {
              $sql = db_query("SELECT COUNT(*) AS wert, $col as schl FROM  `prefix_stats` WHERE mon = ".$smon." GROUP BY schl ORDER BY ".$orderQuery);
              $max = @db_result(db_query("SELECT COUNT(*) as wert, $col as schl FROM prefix_stats WHERE mon = ".$smon." GROUP BY schl ORDER BY wert DESC LIMIT 1"),0,0);
              if ( empty($max) ) { $max = 1; }
              if ( empty($ges) ) { $ges = 1; }
              echo '<tr><th align="left" colspan="4">'.$title.'</th></tr>';
              while ( $r = db_fetch_assoc($sql) ) {
                $wert = ( empty($r['wert']) ? 1 : $r['wert'] );
                $weite = ($wert / $max) * 200;
                          $prozent = ($wert * 100) / $ges;
                          $prozent = number_format(round($prozent,2), 2, ',', '');
                $name = $r['schl'];
                if ( strlen ( $name ) >= 50 ) {
                  $name = substr($name,0,50).'<b>...</b>';
                }
                echo '<tr class="norm"><td width="150" title="'.$r['schl'].'">'.$name.'</td><td width="250">';
                echo '<hr width="'.$weite.'" align="left" /></td>';
                echo '<td width="50" align="right">'.$prozent.'%</td>';
                echo '<td  width="50" align="right">'.$wert.'</td></tr>';
              }
            }
 
            // ICON Anzeige...
            echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
 
            echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
            $smon  = $menu->get(2);
            if ( empty($smon) ) { $smon = $mon; }
 
 
            $ges = db_result(db_query("SELECT COUNT(*) FROM prefix_stats WHERE mon = ".$smon),0,0);
            echo '<br /><br /><b>Gesamt diesen Monat: '.$ges.'</b>';
            echo '<table cellpadding="2" border="0" cellspacing="0">';
 
            echo_admin_site_statistik ('Besucher nach Tagen', 'day', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Wochentagen', 'DAYNAME(FROM_UNIXTIME((wtag+3)*86400))', $smon, $ges, "wtag DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Uhrzeit', 'stunde', $smon, $ges, "schl ASC LIMIT 50");
            echo_admin_site_statistik ('Besucher nach Browsern', 'browser', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Betriebssytemen', 'os', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Herkunft', 'ref', $smon, $ges, "wert DESC LIMIT 50" );
 
                    echo '</table>';
 
 
                    break;
                }
 
 
 
 
                case 'userOnline' :
        {
 
          ?>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_online.png" /></td><td width="30"></td><td valign="bottom"><h1>Online Statistik</h1></td></tr></table>
       <br>
       <table cellpadding="0" cellspacing="0" border="0"><tr><td></td><td width="30"></td><td valign="bottom"><h2>Online</h2></td></tr></table>
 
       <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Username</th>
            <th>Letzte aktivitaet</th>
            <th>IP-Adresse</th>
            <th>Anbieter</th>
          </tr>
 
          <?php
          echo user_admin_online_liste();
          ?>
          </table>
          <br><br>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td widht="48"></td><td width="30"></td><td valign="bottom"><h2>Last log Member List</h2></td></tr></table>
         <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Letzte aktivitaet</th>
            <th>Username</th>
         </tr>
 
         <?php
           $abf = 'SELECT * FROM prefix_user where recht <= -3 ORDER BY llogin DESC';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
    $datum = date('d.m.y-H:m:s',$row->llogin);
$user = $row->name;
 
echo'<tr class="Chead"><td>'.$datum.'</td><td>&nbsp;&nbsp;<a href="?user-1-'.$row->id.'">'.$user.'</a></td></tr>';}
            ?>
 
          </table>
 
          <?php
          break;
                }
                case 'besucherUebersicht' :
        {
            function get_max_from_x ($q) {
              $q = db_query($q);
              $m = 0;
              while($r = db_fetch_row($q)) {
                if ($r[0] > $m) { $m = $r[0]; }
              }
              return ($m);
            }
 
            function echo_admin_site_uebersicht ($schl, $wert, $max, $ges) {
              $wert = ( empty($wert) ? 1 : $wert );
              $weite = ($wert / $max ) * 100;
                        $prozent = ($wert * 100) / $ges;
                        $prozent = number_format(round($prozent,2), 2, ',', '');
              $name = $schl;
              if ( strlen ( $name ) >= 50 ) {
                $name = substr($name,0,50).'<b>...</b>';
              }
              echo '<tr class="norm"><td width="150" title="'.$schl.'">'.$name.'</td><td width="250">';
              echo '<hr width="'.$weite.'" align="left" /></td>';
              echo '<td width="50" align="right">'.$prozent.'%</td>';
              echo '<td  width="50" align="right">'.$wert.'</td></tr>';
            }
 
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
 
 
          echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
 
          echo '<br /><br /><table cellpadding="0" border="0" cellspacing="0" width="100%">';
          echo '<tr><td valign="top" width="33%"><b>Nach Tagen (letzten 5 Monate):</b><br />';
 
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = db_result(db_query("SELECT MAX(`count`) FROM prefix_counter"),0);
          $ges = db_result(db_query("SELECT SUM(`count`) FROM prefix_counter"),0);
          $erg = db_query("SELECT `count` as sum, DATE_FORMAT(`date`, '%d.%m.%Y') as datum FROM prefix_counter ORDER BY `date` DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['datum'], $r['sum'], $max, $ges);
          }
          echo '</table>';
 
          echo '</td><td valign="top" width="33%"><b>Nach Monaten:</b><br />';
 
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY MONTH(`date`), YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, MONTH(`date`) as monat, YEAR(`date`) as jahr FROM prefix_counter GROUP BY monat, jahr ORDER BY jahr DESC, monat DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ((strlen($r['monat'])==1?'0':'').$r['monat'].'.'.$r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
 
          echo '</td><td valign="top" width="33%"><b>Nach Jahren:</b><br />';
 
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, YEAR(`date`) as jahr FROM prefix_counter GROUP BY jahr ORDER BY jahr DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
 
          echo '</td></tr></table>';
          break;
 
        }
                case 'siteStatistik' :
                {
##########################################
function forum_statistic_show ($sql,$ges) {
  $erg = db_query($sql);
  echo '<table border="0" cellpadding="0" cellspacing="0">';
  while ($r = db_fetch_row($erg)) {
#    str_repeat('|',abs($row['regs'] / 2))
    echo '<tr><td>'.$r[1].'</td><td>'.str_repeat('|',$r[0]).' '.$r[0].'</td></tr>';
  }
  echo '</table>';
}
 
 
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_site.png" /></td><td width="30"></td><td valign="bottom"><h1>Seiten Statistik</h1></td></tr></table>';
 
echo '<table><tr><td valign="top">';
$heute = mktime(0,0,0,date('m'),date('d'),date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute),0,0);
echo 'Gesamt Posts heute: '.$anzheute.'<br /><hr>';
 
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User heute</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen heute</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren heute</b><br />';
forum_statistic_show($sql,$anzheute);
 
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User heute</b><br />';
forum_statistic_show($sql,$gsh);
 
echo '</td><td valign="top">';
$heute1 = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute),0,0);
echo 'Gesamt Posts gestern: '.$anzheute.'<br /><hr>';
 
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql,$anzheute);
 
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql,$gsh);
echo '</td></tr></table>';
 
echo '<h1>Es ist ganz erlich noch mehr geplant :P</h1>';
 
##########################################
                    break;
                }
 
        }
 
$design->footer();
?>

freiezocker.de/

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 28.04.2017 17:19 Uhr #4

Lord|Schirmer Administrator

Registriert seit
21.03.2007

Beiträge
7.680

Beitragswertungen

OK ... mach mal aus allen <? folgendes <?php

Zeilen: 46, 66, 100, 111, 120, 137, 150

rules :: doku :: faq :: linkus
1 Mitglieder finden den Beitrag gut.
- zitieren

Fr. 28.04.2017 17:28 Uhr #5

xRebellx Mitglied

Zitat geschrieben von Lord|Schirmer

OK ... mach mal aus allen <? folgendes <?php

Zeilen: 46, 66, 100, 111, 120, 137, 150

Dann bekomme ich folgenden Fehler
Parse error: syntax error, unexpected end of file in /var/www/vhosts/freiezocker.de/httpdocs/include/admin/admin.php on line 429

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

<?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();
 
# script version
$scriptVersion = 11;
$scriptUpdate = 'M';
 
# statistik wird bereinigt.
$mon = date('n');
$lastmon = $mon - 1;
$jahr = date('Y');
$lastjahr = $jahr;
if ( $lastmon <= 0 ) { $lastmon = 12; $lastjahr = $jahr - 1; }
 
db_query("DELETE FROM prefix_stats WHERE NOT ((mon = $mon OR mon = $lastmon) AND (yar = $jahr OR yar = $lastjahr))");
db_query("OPTIMIZE TABLE prefix_stats");
 
 
    $um = $menu->get(1);
    switch($um)
    {
 
        default :
                {
           ?>
<table class="border" cellspacing="1" cellpadding="0" width="100%" border="0">
 <tr>
  <td class="Chead" height="20">&nbsp;Info</td>
 </tr>
    <td>
  <table  cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td class="Cnorm" align="center" width="20%">
<?phpphp echo getCalendar($mon, $jahr, $url, $urlod, $data, $cellpadding=2);?>
</td>
<td class="Cnorm" align="center" valign="top" width="60%">N&auml;chsten Geburtstage<hr style="height: 0px; border: dotted #444444 0px; border-top-width: 1px; " /><br>
<?php include ('include/boxes/geburtstag.php');?>
</td>
<td class="Cnorm" align="center" width="20%">
<embed src="http://www.clocklink.com/clocks/0008-Orange.swf?TimeZone=WET" width="150" height="150" wmode="transparent" type="application/x-shockwave-flash">
</td>
 
</tr>
</table>
 
  </td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="4">Statistik</td>
 </tr>
    <tr>
  <td class="Cnorm" width="25%"><font class="smalfont">Design</font></td>
  <td class="Cnorm" width="25%" nowrap><font class="smalfont">
<?php echo $allgAr['gfx']; ?>
  </font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">Installierte Version</font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">
<?php echo ''.$scriptVersion.'&nbsp; Update: '.$scriptUpdate.''; ?>
  </font></td>
  </tr>
  <tr>
  <td class="Cnorm"><font class="smalfont">Datenbankgr&ouml;&szlig;e</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
// gibt die groesse der Datenbank  aus
$result = db_query("SHOW TABLE STATUS");
    $dbsize = 0;
    while($row = mysql_fetch_assoc($result)) {
        $dbsize += $row['Data_length'];
    }echo nicebytes($dbsize);
?>
  </font></td>
  <td class="Cnorm"><font class="smalfont">Downloads</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  echo nicebytes(dirsize('include/downs/'));
?>
 </font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">Benutzer &amp; G&auml;ste online</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php echo '<b>'.ges_online().'</b> Benutzer und <b>'.ges_gast_online().'</b> G&auml;ste';?>
  &nbsp; <a class="smalfont" href="admin.php?admin-userOnline">&#187; anzeigen</a></font></td>
 
  <td class="Cnorm" nowrap><font class="smalfont">Web Status</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  if ($allgAr['wartung'] == 0){
     echo 'Seite &Ouml;ffentlich';
  }else
    echo '<b>Wartungs Modus</b>&nbsp;<img src="include/images/icons/wartung.png">';
?>
  </a></font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">nicht aktivierte Accounts</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  $gesuser  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 1"),0);
  echo '<b>'.$gesuser.'</b>';
?>
  &nbsp; <a class="smalfont" href="admin.php?puser">&#187; anzeigen</a>
  </font></td>
 
  <td class="Cnorm"nowrap><font class="smalfont">nicht aktivierte Join Us</font></td>
  <td class="Cnorm"><font class="smalfont">
  <?php
 $joinus  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 4"),0);
  echo '<b>'.$joinus.'</b>';
  ?>
  &nbsp; <a class="smalfont" href="admin.php?groups-joinus">&#187; anzeigen</a>
  </font></td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="2">Die neusten Mitglieder</td>
  <td class="Chead" colspan="2">Die letzten Artikel, News ...</td>
 </tr>
 <tr>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?php
  $abf = 'SELECT * FROM prefix_user ORDER BY regist DESC LIMIT 5';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
  $regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') )  - $row->regist;
  $regday = round($regsek / 86400);
  $user = $row->name;
  echo'<tr class="Cnorm"><td><a href="?user-1-'.$row->id.'"><b>'.$user.'</b></a></td><td> Registriert am "'.date('d.m.Y',$row->regist).'"</td></tr>';}
?>
   </table>
  </td>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?php
  $abf = 'SELECT news_id,news_title FROM `prefix_news` ORDER BY news_time DESC LIMIT 5';
    $erg = db_query($abf);
    while ($row = db_fetch_object($erg) ) {
        echo'<tr class="Cnorm"><td><a href="?news-edit-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';}
?>
   </table>
  </td>
 </tr>
 <tr>
  <td class="Chead" colspan="4" align="right"><a class="Chead" href="admin.php?about">Systeminformationen</a></td>
 </tr>
</table>
 
 
 
 
           <?phpphp
                   break;
        }
 
                case 'versionsKontrolle' :
        {
 
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/version_check.png" /></td><td width="30"></td><td valign="bottom"><h1>Versionskontrolle</h1></td></tr></table>';
 
 
                        echo 'Scripte Version: '.$scriptVersion.'<br />Update Version: '.$scriptUpdate.'<br /><br />';
                        echo '<script language="JavaScript" type="text/javascript" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></script>';
                        #echo '<iframe width="100%" height="60" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></iframe>';
 
                        break;
        }
 
                #####################################
 
                case 'besucherStatistik' :
                {
            function echo_admin_site_statistik ($title, $col, $smon, $ges, $orderQuery ) {
              $sql = db_query("SELECT COUNT(*) AS wert, $col as schl FROM  `prefix_stats` WHERE mon = ".$smon." GROUP BY schl ORDER BY ".$orderQuery);
              $max = @db_result(db_query("SELECT COUNT(*) as wert, $col as schl FROM prefix_stats WHERE mon = ".$smon." GROUP BY schl ORDER BY wert DESC LIMIT 1"),0,0);
              if ( empty($max) ) { $max = 1; }
              if ( empty($ges) ) { $ges = 1; }
              echo '<tr><th align="left" colspan="4">'.$title.'</th></tr>';
              while ( $r = db_fetch_assoc($sql) ) {
                $wert = ( empty($r['wert']) ? 1 : $r['wert'] );
                $weite = ($wert / $max) * 200;
                          $prozent = ($wert * 100) / $ges;
                          $prozent = number_format(round($prozent,2), 2, ',', '');
                $name = $r['schl'];
                if ( strlen ( $name ) >= 50 ) {
                  $name = substr($name,0,50).'<b>...</b>';
                }
                echo '<tr class="norm"><td width="150" title="'.$r['schl'].'">'.$name.'</td><td width="250">';
                echo '<hr width="'.$weite.'" align="left" /></td>';
                echo '<td width="50" align="right">'.$prozent.'%</td>';
                echo '<td  width="50" align="right">'.$wert.'</td></tr>';
              }
            }
 
            // ICON Anzeige...
            echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
 
            echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
            $smon  = $menu->get(2);
            if ( empty($smon) ) { $smon = $mon; }
 
 
            $ges = db_result(db_query("SELECT COUNT(*) FROM prefix_stats WHERE mon = ".$smon),0,0);
            echo '<br /><br /><b>Gesamt diesen Monat: '.$ges.'</b>';
            echo '<table cellpadding="2" border="0" cellspacing="0">';
 
            echo_admin_site_statistik ('Besucher nach Tagen', 'day', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Wochentagen', 'DAYNAME(FROM_UNIXTIME((wtag+3)*86400))', $smon, $ges, "wtag DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Uhrzeit', 'stunde', $smon, $ges, "schl ASC LIMIT 50");
            echo_admin_site_statistik ('Besucher nach Browsern', 'browser', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Betriebssytemen', 'os', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Herkunft', 'ref', $smon, $ges, "wert DESC LIMIT 50" );
 
                    echo '</table>';
 
 
                    break;
                }
 
 
 
 
                case 'userOnline' :
        {
 
          ?>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_online.png" /></td><td width="30"></td><td valign="bottom"><h1>Online Statistik</h1></td></tr></table>
       <br>
       <table cellpadding="0" cellspacing="0" border="0"><tr><td></td><td width="30"></td><td valign="bottom"><h2>Online</h2></td></tr></table>
 
       <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Username</th>
            <th>Letzte aktivitaet</th>
            <th>IP-Adresse</th>
            <th>Anbieter</th>
          </tr>
 
          <?phpphp
          echo user_admin_online_liste();
          ?>
          </table>
          <br><br>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td widht="48"></td><td width="30"></td><td valign="bottom"><h2>Last log Member List</h2></td></tr></table>
         <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Letzte aktivitaet</th>
            <th>Username</th>
         </tr>
 
         <?phpphp
           $abf = 'SELECT * FROM prefix_user where recht <= -3 ORDER BY llogin DESC';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
    $datum = date('d.m.y-H:m:s',$row->llogin);
$user = $row->name;
 
echo'<tr class="Chead"><td>'.$datum.'</td><td>&nbsp;&nbsp;<a href="?user-1-'.$row->id.'">'.$user.'</a></td></tr>';}
            ?>
 
          </table>
 
          <?phpphp
          break;
                }
                case 'besucherUebersicht' :
        {
            function get_max_from_x ($q) {
              $q = db_query($q);
              $m = 0;
              while($r = db_fetch_row($q)) {
                if ($r[0] > $m) { $m = $r[0]; }
              }
              return ($m);
            }
 
            function echo_admin_site_uebersicht ($schl, $wert, $max, $ges) {
              $wert = ( empty($wert) ? 1 : $wert );
              $weite = ($wert / $max ) * 100;
                        $prozent = ($wert * 100) / $ges;
                        $prozent = number_format(round($prozent,2), 2, ',', '');
              $name = $schl;
              if ( strlen ( $name ) >= 50 ) {
                $name = substr($name,0,50).'<b>...</b>';
              }
              echo '<tr class="norm"><td width="150" title="'.$schl.'">'.$name.'</td><td width="250">';
              echo '<hr width="'.$weite.'" align="left" /></td>';
              echo '<td width="50" align="right">'.$prozent.'%</td>';
              echo '<td  width="50" align="right">'.$wert.'</td></tr>';
            }
 
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
 
 
          echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
 
          echo '<br /><br /><table cellpadding="0" border="0" cellspacing="0" width="100%">';
          echo '<tr><td valign="top" width="33%"><b>Nach Tagen (letzten 5 Monate):</b><br />';
 
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = db_result(db_query("SELECT MAX(`count`) FROM prefix_counter"),0);
          $ges = db_result(db_query("SELECT SUM(`count`) FROM prefix_counter"),0);
          $erg = db_query("SELECT `count` as sum, DATE_FORMAT(`date`, '%d.%m.%Y') as datum FROM prefix_counter ORDER BY `date` DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['datum'], $r['sum'], $max, $ges);
          }
          echo '</table>';
 
          echo '</td><td valign="top" width="33%"><b>Nach Monaten:</b><br />';
 
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY MONTH(`date`), YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, MONTH(`date`) as monat, YEAR(`date`) as jahr FROM prefix_counter GROUP BY monat, jahr ORDER BY jahr DESC, monat DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ((strlen($r['monat'])==1?'0':'').$r['monat'].'.'.$r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
 
          echo '</td><td valign="top" width="33%"><b>Nach Jahren:</b><br />';
 
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, YEAR(`date`) as jahr FROM prefix_counter GROUP BY jahr ORDER BY jahr DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
 
          echo '</td></tr></table>';
          break;
 
        }
                case 'siteStatistik' :
                {
##########################################
function forum_statistic_show ($sql,$ges) {
  $erg = db_query($sql);
  echo '<table border="0" cellpadding="0" cellspacing="0">';
  while ($r = db_fetch_row($erg)) {
#    str_repeat('|',abs($row['regs'] / 2))
    echo '<tr><td>'.$r[1].'</td><td>'.str_repeat('|',$r[0]).' '.$r[0].'</td></tr>';
  }
  echo '</table>';
}
 
 
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_site.png" /></td><td width="30"></td><td valign="bottom"><h1>Seiten Statistik</h1></td></tr></table>';
 
echo '<table><tr><td valign="top">';
$heute = mktime(0,0,0,date('m'),date('d'),date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute),0,0);
echo 'Gesamt Posts heute: '.$anzheute.'<br /><hr>';
 
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User heute</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen heute</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren heute</b><br />';
forum_statistic_show($sql,$anzheute);
 
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User heute</b><br />';
forum_statistic_show($sql,$gsh);
 
echo '</td><td valign="top">';
$heute1 = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute),0,0);
echo 'Gesamt Posts gestern: '.$anzheute.'<br /><hr>';
 
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql,$anzheute);
 
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql,$anzheute);
 
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql,$gsh);
echo '</td></tr></table>';
 
echo '<h1>Es ist ganz erlich noch mehr geplant :P</h1>';
 
##########################################
                    break;
                }
 
        }
 
$design->footer();
?>

freiezocker.de/

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 28.04.2017 18:13 Uhr #6

Nex4T Moderator

Registriert seit
28.02.2007

Beiträge
3.414

Beitragswertungen

Ändere mal <?phpphp in <?php z.b zeile 279

while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu
1 Mitglieder finden den Beitrag gut.
- zitieren

Fr. 28.04.2017 18:56 Uhr #7

xRebellx Mitglied

Zitat geschrieben von Nex4T

Ändere mal <?phpphp in <?php z.b zeile 279

Super das funktioniert

Aber jetzt habe ich unten Fehler, wo muß ich das noch einfügen?

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

<?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();
  
# script version
$scriptVersion = 11;
$scriptUpdate = 'M';
  
# statistik wird bereinigt.
$mon = date('n');
$lastmon = $mon - 1;
$jahr = date('Y');
$lastjahr = $jahr;
if ( $lastmon <= 0 ) { $lastmon = 12; $lastjahr = $jahr - 1; }
  
db_query("DELETE FROM prefix_stats WHERE NOT ((mon = $mon OR mon = $lastmon) AND (yar = $jahr OR yar = $lastjahr))");
db_query("OPTIMIZE TABLE prefix_stats");
  
  
    $um = $menu->get(1);
    switch($um)
    {
  
        default :
                {
           ?>
<table class="border" cellspacing="1" cellpadding="0" width="100%" border="0">
 <tr>
  <td class="Chead" height="20">&nbsp;Info</td>
 </tr>
    <td>
  <table  cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td class="Cnorm" align="center" width="20%">
<?phpphp echo getCalendar($mon, $jahr, $url, $urlod, $data, $cellpadding=2);?>
</td>
<td class="Cnorm" align="center" valign="top" width="60%">N&auml;chsten Geburtstage<hr style="height: 0px; border: dotted #444444 0px; border-top-width: 1px; " /><br>
<?php include ('include/boxes/geburtstag.php');?>
</td>
<td class="Cnorm" align="center" width="20%">
<embed src="http://www.clocklink.com/clocks/0008-Orange.swf?TimeZone=WET" width="150" height="150" wmode="transparent" type="application/x-shockwave-flash">
</td>
  
</tr>
</table>
  
  </td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="4">Statistik</td>
 </tr>
    <tr>
  <td class="Cnorm" width="25%"><font class="smalfont">Design</font></td>
  <td class="Cnorm" width="25%" nowrap><font class="smalfont">
<?php echo $allgAr['gfx']; ?>
  </font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">Installierte Version</font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">
<?php echo ''.$scriptVersion.'&nbsp; Update: '.$scriptUpdate.''; ?>
  </font></td>
  </tr>
  <tr>
  <td class="Cnorm"><font class="smalfont">Datenbankgr&ouml;&szlig;e</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
// gibt die groesse der Datenbank  aus
$result = db_query("SHOW TABLE STATUS");
    $dbsize = 0;
    while($row = mysql_fetch_assoc($result)) {
        $dbsize += $row['Data_length'];
    }echo nicebytes($dbsize);
?>
  </font></td>
  <td class="Cnorm"><font class="smalfont">Downloads</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  echo nicebytes(dirsize('include/downs/'));
?>
 </font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">Benutzer &amp; G&auml;ste online</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php echo '<b>'.ges_online().'</b> Benutzer und <b>'.ges_gast_online().'</b> G&auml;ste';?>
  &nbsp; <a class="smalfont" href="admin.php?admin-userOnline">&#187; anzeigen</a></font></td>
  
  <td class="Cnorm" nowrap><font class="smalfont">Web Status</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  if ($allgAr['wartung'] == 0){
     echo 'Seite &Ouml;ffentlich';
  }else
    echo '<b>Wartungs Modus</b>&nbsp;<img src="include/images/icons/wartung.png">';
?>
  </a></font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">nicht aktivierte Accounts</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  $gesuser  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 1"),0);
  echo '<b>'.$gesuser.'</b>';
?>
  &nbsp; <a class="smalfont" href="admin.php?puser">&#187; anzeigen</a>
  </font></td>
  
  <td class="Cnorm"nowrap><font class="smalfont">nicht aktivierte Join Us</font></td>
  <td class="Cnorm"><font class="smalfont">
  <?php
 $joinus  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 4"),0);
  echo '<b>'.$joinus.'</b>';
  ?>
  &nbsp; <a class="smalfont" href="admin.php?groups-joinus">&#187; anzeigen</a>
  </font></td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="2">Die neusten Mitglieder</td>
  <td class="Chead" colspan="2">Die letzten Artikel, News ...</td>
 </tr>
 <tr>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?php
  $abf = 'SELECT * FROM prefix_user ORDER BY regist DESC LIMIT 5';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
  $regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') )  - $row->regist;
  $regday = round($regsek / 86400);
  $user = $row->name;
  echo'<tr class="Cnorm"><td><a href="?user-1-'.$row->id.'"><b>'.$user.'</b></a></td><td> Registriert am "'.date('d.m.Y',$row->regist).'"</td></tr>';}
?>
   </table>
  </td>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?php
  $abf = 'SELECT news_id,news_title FROM `prefix_news` ORDER BY news_time DESC LIMIT 5';
    $erg = db_query($abf);
    while ($row = db_fetch_object($erg) ) {
        echo'<tr class="Cnorm"><td><a href="?news-edit-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';}
?>
   </table>
  </td>
 </tr>
 <tr>
  <td class="Chead" colspan="4" align="right"><a class="Chead" href="admin.php?about">Systeminformationen</a></td>
 </tr>
</table>
  
  
  
  
           <?phpphp
                   break;
        }
  
                case 'versionsKontrolle' :
        {
  
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/version_check.png" /></td><td width="30"></td><td valign="bottom"><h1>Versionskontrolle</h1></td></tr></table>';
  
  
                        echo 'Scripte Version: '.$scriptVersion.'<br />Update Version: '.$scriptUpdate.'<br /><br />';
                        echo '<script language="JavaScript" type="text/javascript" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></script>';
                        #echo '<iframe width="100%" height="60" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></iframe>';
  
                        break;
        }
  
                #####################################
  
                case 'besucherStatistik' :
                {
            function echo_admin_site_statistik ($title, $col, $smon, $ges, $orderQuery ) {
              $sql = db_query("SELECT COUNT(*) AS wert, $col as schl FROM  `prefix_stats` WHERE mon = ".$smon." GROUP BY schl ORDER BY ".$orderQuery);
              $max = @db_result(db_query("SELECT COUNT(*) as wert, $col as schl FROM prefix_stats WHERE mon = ".$smon." GROUP BY schl ORDER BY wert DESC LIMIT 1"),0,0);
              if ( empty($max) ) { $max = 1; }
              if ( empty($ges) ) { $ges = 1; }
              echo '<tr><th align="left" colspan="4">'.$title.'</th></tr>';
              while ( $r = db_fetch_assoc($sql) ) {
                $wert = ( empty($r['wert']) ? 1 : $r['wert'] );
                $weite = ($wert / $max) * 200;
                          $prozent = ($wert * 100) / $ges;
                          $prozent = number_format(round($prozent,2), 2, ',', '');
                $name = $r['schl'];
                if ( strlen ( $name ) >= 50 ) {
                  $name = substr($name,0,50).'<b>...</b>';
                }
                echo '<tr class="norm"><td width="150" title="'.$r['schl'].'">'.$name.'</td><td width="250">';
                echo '<hr width="'.$weite.'" align="left" /></td>';
                echo '<td width="50" align="right">'.$prozent.'%</td>';
                echo '<td  width="50" align="right">'.$wert.'</td></tr>';
              }
            }
  
            // ICON Anzeige...
            echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
  
            echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
            $smon  = $menu->get(2);
            if ( empty($smon) ) { $smon = $mon; }
  
  
            $ges = db_result(db_query("SELECT COUNT(*) FROM prefix_stats WHERE mon = ".$smon),0,0);
            echo '<br /><br /><b>Gesamt diesen Monat: '.$ges.'</b>';
            echo '<table cellpadding="2" border="0" cellspacing="0">';
  
            echo_admin_site_statistik ('Besucher nach Tagen', 'day', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Wochentagen', 'DAYNAME(FROM_UNIXTIME((wtag+3)*86400))', $smon, $ges, "wtag DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Uhrzeit', 'stunde', $smon, $ges, "schl ASC LIMIT 50");
            echo_admin_site_statistik ('Besucher nach Browsern', 'browser', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Betriebssytemen', 'os', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Herkunft', 'ref', $smon, $ges, "wert DESC LIMIT 50" );
  
                    echo '</table>';
  
  
                    break;
                }
  
  
  
  
                case 'userOnline' :
        {
  
          ?>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_online.png" /></td><td width="30"></td><td valign="bottom"><h1>Online Statistik</h1></td></tr></table>
       <br>
       <table cellpadding="0" cellspacing="0" border="0"><tr><td></td><td width="30"></td><td valign="bottom"><h2>Online</h2></td></tr></table>
  
       <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Username</th>
            <th>Letzte aktivitaet</th>
            <th>IP-Adresse</th>
            <th>Anbieter</th>
          </tr>
  
          <?phpphp
          echo user_admin_online_liste();
          ?>
          </table>
          <br><br>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td widht="48"></td><td width="30"></td><td valign="bottom"><h2>Last log Member List</h2></td></tr></table>
         <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Letzte aktivitaet</th>
            <th>Username</th>
         </tr>
  
         <?phpphp
           $abf = 'SELECT * FROM prefix_user where recht <= -3 ORDER BY llogin DESC';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
    $datum = date('d.m.y-H:m:s',$row->llogin);
$user = $row->name;
  
echo'<tr class="Chead"><td>'.$datum.'</td><td>&nbsp;&nbsp;<a href="?user-1-'.$row->id.'">'.$user.'</a></td></tr>';}
            ?>
  
          </table>
  
          <?php
          break;
                }
                case 'besucherUebersicht' :
        {
            function get_max_from_x ($q) {
              $q = db_query($q);
              $m = 0;
              while($r = db_fetch_row($q)) {
                if ($r[0] > $m) { $m = $r[0]; }
              }
              return ($m);
            }
  
            function echo_admin_site_uebersicht ($schl, $wert, $max, $ges) {
              $wert = ( empty($wert) ? 1 : $wert );
              $weite = ($wert / $max ) * 100;
                        $prozent = ($wert * 100) / $ges;
                        $prozent = number_format(round($prozent,2), 2, ',', '');
              $name = $schl;
              if ( strlen ( $name ) >= 50 ) {
                $name = substr($name,0,50).'<b>...</b>';
              }
              echo '<tr class="norm"><td width="150" title="'.$schl.'">'.$name.'</td><td width="250">';
              echo '<hr width="'.$weite.'" align="left" /></td>';
              echo '<td width="50" align="right">'.$prozent.'%</td>';
              echo '<td  width="50" align="right">'.$wert.'</td></tr>';
            }
  
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
  
  
          echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
  
          echo '<br /><br /><table cellpadding="0" border="0" cellspacing="0" width="100%">';
          echo '<tr><td valign="top" width="33%"><b>Nach Tagen (letzten 5 Monate):</b><br />';
  
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = db_result(db_query("SELECT MAX(`count`) FROM prefix_counter"),0);
          $ges = db_result(db_query("SELECT SUM(`count`) FROM prefix_counter"),0);
          $erg = db_query("SELECT `count` as sum, DATE_FORMAT(`date`, '%d.%m.%Y') as datum FROM prefix_counter ORDER BY `date` DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['datum'], $r['sum'], $max, $ges);
          }
          echo '</table>';
  
          echo '</td><td valign="top" width="33%"><b>Nach Monaten:</b><br />';
  
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY MONTH(`date`), YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, MONTH(`date`) as monat, YEAR(`date`) as jahr FROM prefix_counter GROUP BY monat, jahr ORDER BY jahr DESC, monat DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ((strlen($r['monat'])==1?'0':'').$r['monat'].'.'.$r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
  
          echo '</td><td valign="top" width="33%"><b>Nach Jahren:</b><br />';
  
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, YEAR(`date`) as jahr FROM prefix_counter GROUP BY jahr ORDER BY jahr DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
  
          echo '</td></tr></table>';
          break;
  
        }
                case 'siteStatistik' :
                {
##########################################
function forum_statistic_show ($sql,$ges) {
  $erg = db_query($sql);
  echo '<table border="0" cellpadding="0" cellspacing="0">';
  while ($r = db_fetch_row($erg)) {
#    str_repeat('|',abs($row['regs'] / 2))
    echo '<tr><td>'.$r[1].'</td><td>'.str_repeat('|',$r[0]).' '.$r[0].'</td></tr>';
  }
  echo '</table>';
}
  
  
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_site.png" /></td><td width="30"></td><td valign="bottom"><h1>Seiten Statistik</h1></td></tr></table>';
  
echo '<table><tr><td valign="top">';
$heute = mktime(0,0,0,date('m'),date('d'),date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute),0,0);
echo 'Gesamt Posts heute: '.$anzheute.'<br /><hr>';
  
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User heute</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen heute</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren heute</b><br />';
forum_statistic_show($sql,$anzheute);
  
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User heute</b><br />';
forum_statistic_show($sql,$gsh);
  
echo '</td><td valign="top">';
$heute1 = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute),0,0);
echo 'Gesamt Posts gestern: '.$anzheute.'<br /><hr>';
  
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql,$anzheute);
  
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql,$gsh);
echo '</td></tr></table>';
  
echo '<h1>Es ist ganz erlich noch mehr geplant :P</h1>';
  
##########################################
                    break;
                }
  
        }
  
$design->footer();
?>

freiezocker.de/

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 28.04.2017 19:07 Uhr #8

xRebellx Mitglied

Okay habe es hin bekommen :-) Besten besten dank für Eure Hilfe :-)

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

<?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();
  
# script version
$scriptVersion = 11;
$scriptUpdate = 'M';
  
# statistik wird bereinigt.
$mon = date('n');
$lastmon = $mon - 1;
$jahr = date('Y');
$lastjahr = $jahr;
if ( $lastmon <= 0 ) { $lastmon = 12; $lastjahr = $jahr - 1; }
  
db_query("DELETE FROM prefix_stats WHERE NOT ((mon = $mon OR mon = $lastmon) AND (yar = $jahr OR yar = $lastjahr))");
db_query("OPTIMIZE TABLE prefix_stats");
  
  
    $um = $menu->get(1);
    switch($um)
    {
  
        default :
                {
           ?>
<table class="border" cellspacing="1" cellpadding="0" width="100%" border="0">
 <tr>
  <td class="Chead" height="20">&nbsp;Info</td>
 </tr>
    <td>
  <table  cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td class="Cnorm" align="center" width="20%">
<?php echo getCalendar($mon, $jahr, $url, $urlod, $data, $cellpadding=2);?>
</td>
<td class="Cnorm" align="center" valign="top" width="60%">N&auml;chsten Geburtstage<hr style="height: 0px; border: dotted #444444 0px; border-top-width: 1px; " /><br>
<?php include ('include/boxes/geburtstag.php');?>
</td>
<td class="Cnorm" align="center" width="20%">
<embed src="http://www.clocklink.com/clocks/0008-Orange.swf?TimeZone=WET" width="150" height="150" wmode="transparent" type="application/x-shockwave-flash">
</td>
  
</tr>
</table>
  
  </td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="4">Statistik</td>
 </tr>
    <tr>
  <td class="Cnorm" width="25%"><font class="smalfont">Design</font></td>
  <td class="Cnorm" width="25%" nowrap><font class="smalfont">
<?php echo $allgAr['gfx']; ?>
  </font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">Installierte Version</font></td>
  <td class="Cnorm" width="25%"><font class="smalfont">
<?php echo ''.$scriptVersion.'&nbsp; Update: '.$scriptUpdate.''; ?>
  </font></td>
  </tr>
  <tr>
  <td class="Cnorm"><font class="smalfont">Datenbankgr&ouml;&szlig;e</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
// gibt die groesse der Datenbank  aus
$result = db_query("SHOW TABLE STATUS");
    $dbsize = 0;
    while($row = mysql_fetch_assoc($result)) {
        $dbsize += $row['Data_length'];
    }echo nicebytes($dbsize);
?>
  </font></td>
  <td class="Cnorm"><font class="smalfont">Downloads</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  echo nicebytes(dirsize('include/downs/'));
?>
 </font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">Benutzer &amp; G&auml;ste online</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php echo '<b>'.ges_online().'</b> Benutzer und <b>'.ges_gast_online().'</b> G&auml;ste';?>
  &nbsp; <a class="smalfont" href="admin.php?admin-userOnline">&#187; anzeigen</a></font></td>
  
  <td class="Cnorm" nowrap><font class="smalfont">Web Status</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  if ($allgAr['wartung'] == 0){
     echo 'Seite &Ouml;ffentlich';
  }else
    echo '<b>Wartungs Modus</b>&nbsp;<img src="include/images/icons/wartung.png">';
?>
  </a></font></td>
 </tr>
 <tr>
  <td class="Cnorm"><font class="smalfont">nicht aktivierte Accounts</font></td>
  <td class="Cnorm"><font class="smalfont">
<?php
  $gesuser  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 1"),0);
  echo '<b>'.$gesuser.'</b>';
?>
  &nbsp; <a class="smalfont" href="admin.php?puser">&#187; anzeigen</a>
  </font></td>
  
  <td class="Cnorm"nowrap><font class="smalfont">nicht aktivierte Join Us</font></td>
  <td class="Cnorm"><font class="smalfont">
  <?php
 $joinus  = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 4"),0);
  echo '<b>'.$joinus.'</b>';
  ?>
  &nbsp; <a class="smalfont" href="admin.php?groups-joinus">&#187; anzeigen</a>
  </font></td>
  </tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
 <tr>
  <td class="Chead" colspan="2">Die neusten Mitglieder</td>
  <td class="Chead" colspan="2">Die letzten Artikel, News ...</td>
 </tr>
 <tr>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?php
  $abf = 'SELECT * FROM prefix_user ORDER BY regist DESC LIMIT 5';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
  $regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') )  - $row->regist;
  $regday = round($regsek / 86400);
  $user = $row->name;
  echo'<tr class="Cnorm"><td><a href="?user-1-'.$row->id.'"><b>'.$user.'</b></a></td><td> Registriert am "'.date('d.m.Y',$row->regist).'"</td></tr>';}
?>
   </table>
  </td>
  <td class="Cnorm" colspan="2" valign="top">
   <table border="0" cellspacing="0" cellpadding="2" width="100%">
<?php
  $abf = 'SELECT news_id,news_title FROM `prefix_news` ORDER BY news_time DESC LIMIT 5';
    $erg = db_query($abf);
    while ($row = db_fetch_object($erg) ) {
        echo'<tr class="Cnorm"><td><a href="?news-edit-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';}
?>
   </table>
  </td>
 </tr>
 <tr>
  <td class="Chead" colspan="4" align="right"><a class="Chead" href="admin.php?about">Systeminformationen</a></td>
 </tr>
</table>
  
  
  
  
           <?php
                   break;
        }
  
                case 'versionsKontrolle' :
        {
  
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/version_check.png" /></td><td width="30"></td><td valign="bottom"><h1>Versionskontrolle</h1></td></tr></table>';
  
  
                        echo 'Scripte Version: '.$scriptVersion.'<br />Update Version: '.$scriptUpdate.'<br /><br />';
                        echo '<script language="JavaScript" type="text/javascript" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></script>';
                        #echo '<iframe width="100%" height="60" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></iframe>';
  
                        break;
        }
  
                #####################################
  
                case 'besucherStatistik' :
                {
            function echo_admin_site_statistik ($title, $col, $smon, $ges, $orderQuery ) {
              $sql = db_query("SELECT COUNT(*) AS wert, $col as schl FROM  `prefix_stats` WHERE mon = ".$smon." GROUP BY schl ORDER BY ".$orderQuery);
              $max = @db_result(db_query("SELECT COUNT(*) as wert, $col as schl FROM prefix_stats WHERE mon = ".$smon." GROUP BY schl ORDER BY wert DESC LIMIT 1"),0,0);
              if ( empty($max) ) { $max = 1; }
              if ( empty($ges) ) { $ges = 1; }
              echo '<tr><th align="left" colspan="4">'.$title.'</th></tr>';
              while ( $r = db_fetch_assoc($sql) ) {
                $wert = ( empty($r['wert']) ? 1 : $r['wert'] );
                $weite = ($wert / $max) * 200;
                          $prozent = ($wert * 100) / $ges;
                          $prozent = number_format(round($prozent,2), 2, ',', '');
                $name = $r['schl'];
                if ( strlen ( $name ) >= 50 ) {
                  $name = substr($name,0,50).'<b>...</b>';
                }
                echo '<tr class="norm"><td width="150" title="'.$r['schl'].'">'.$name.'</td><td width="250">';
                echo '<hr width="'.$weite.'" align="left" /></td>';
                echo '<td width="50" align="right">'.$prozent.'%</td>';
                echo '<td  width="50" align="right">'.$wert.'</td></tr>';
              }
            }
  
            // ICON Anzeige...
            echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
  
            echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
            $smon  = $menu->get(2);
            if ( empty($smon) ) { $smon = $mon; }
  
  
            $ges = db_result(db_query("SELECT COUNT(*) FROM prefix_stats WHERE mon = ".$smon),0,0);
            echo '<br /><br /><b>Gesamt diesen Monat: '.$ges.'</b>';
            echo '<table cellpadding="2" border="0" cellspacing="0">';
  
            echo_admin_site_statistik ('Besucher nach Tagen', 'day', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Wochentagen', 'DAYNAME(FROM_UNIXTIME((wtag+3)*86400))', $smon, $ges, "wtag DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Uhrzeit', 'stunde', $smon, $ges, "schl ASC LIMIT 50");
            echo_admin_site_statistik ('Besucher nach Browsern', 'browser', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Betriebssytemen', 'os', $smon, $ges, "schl DESC LIMIT 50" );
            echo_admin_site_statistik ('Besucher nach Herkunft', 'ref', $smon, $ges, "wert DESC LIMIT 50" );
  
                    echo '</table>';
  
  
                    break;
                }
  
  
  
  
                case 'userOnline' :
        {
  
          ?>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_online.png" /></td><td width="30"></td><td valign="bottom"><h1>Online Statistik</h1></td></tr></table>
       <br>
       <table cellpadding="0" cellspacing="0" border="0"><tr><td></td><td width="30"></td><td valign="bottom"><h2>Online</h2></td></tr></table>
  
       <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Username</th>
            <th>Letzte aktivitaet</th>
            <th>IP-Adresse</th>
            <th>Anbieter</th>
          </tr>
  
          <?phpphp
          echo user_admin_online_liste();
          ?>
          </table>
          <br><br>
          <table cellpadding="0" cellspacing="0" border="0"><tr><td widht="48"></td><td width="30"></td><td valign="bottom"><h2>Last log Member List</h2></td></tr></table>
         <table border="0" cellpadding="2" cellspacing="1" class="border">
          <tr class="Chead">
            <th>Letzte aktivitaet</th>
            <th>Username</th>
         </tr>
  
         <?php
           $abf = 'SELECT * FROM prefix_user where recht <= -3 ORDER BY llogin DESC';
    $erg = db_query($abf);
  while ($row = db_fetch_object($erg)) {
    $datum = date('d.m.y-H:m:s',$row->llogin);
$user = $row->name;
  
echo'<tr class="Chead"><td>'.$datum.'</td><td>&nbsp;&nbsp;<a href="?user-1-'.$row->id.'">'.$user.'</a></td></tr>';}
            ?>
  
          </table>
  
          <?php
          break;
                }
                case 'besucherUebersicht' :
        {
            function get_max_from_x ($q) {
              $q = db_query($q);
              $m = 0;
              while($r = db_fetch_row($q)) {
                if ($r[0] > $m) { $m = $r[0]; }
              }
              return ($m);
            }
  
            function echo_admin_site_uebersicht ($schl, $wert, $max, $ges) {
              $wert = ( empty($wert) ? 1 : $wert );
              $weite = ($wert / $max ) * 100;
                        $prozent = ($wert * 100) / $ges;
                        $prozent = number_format(round($prozent,2), 2, ',', '');
              $name = $schl;
              if ( strlen ( $name ) >= 50 ) {
                $name = substr($name,0,50).'<b>...</b>';
              }
              echo '<tr class="norm"><td width="150" title="'.$schl.'">'.$name.'</td><td width="250">';
              echo '<hr width="'.$weite.'" align="left" /></td>';
              echo '<td width="50" align="right">'.$prozent.'%</td>';
              echo '<td  width="50" align="right">'.$wert.'</td></tr>';
            }
  
          // ICON Anzeige...
          echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
  
  
          echo '<a href="admin.php?admin-besucherUebersicht">&Uuml;bersicht</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a>&nbsp;<b>|</b>&nbsp;<a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
  
          echo '<br /><br /><table cellpadding="0" border="0" cellspacing="0" width="100%">';
          echo '<tr><td valign="top" width="33%"><b>Nach Tagen (letzten 5 Monate):</b><br />';
  
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = db_result(db_query("SELECT MAX(`count`) FROM prefix_counter"),0);
          $ges = db_result(db_query("SELECT SUM(`count`) FROM prefix_counter"),0);
          $erg = db_query("SELECT `count` as sum, DATE_FORMAT(`date`, '%d.%m.%Y') as datum FROM prefix_counter ORDER BY `date` DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['datum'], $r['sum'], $max, $ges);
          }
          echo '</table>';
  
          echo '</td><td valign="top" width="33%"><b>Nach Monaten:</b><br />';
  
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY MONTH(`date`), YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, MONTH(`date`) as monat, YEAR(`date`) as jahr FROM prefix_counter GROUP BY monat, jahr ORDER BY jahr DESC, monat DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ((strlen($r['monat'])==1?'0':'').$r['monat'].'.'.$r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
  
          echo '</td><td valign="top" width="33%"><b>Nach Jahren:</b><br />';
  
          echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
          $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY YEAR(`date`)");
          $erg = db_query("SELECT SUM(`count`) as sum, YEAR(`date`) as jahr FROM prefix_counter GROUP BY jahr ORDER BY jahr DESC");
          while ($r = db_fetch_assoc($erg)) {
            echo_admin_site_uebersicht ($r['jahr'], $r['sum'], $max, $ges);
          }
          echo '</table>';
  
          echo '</td></tr></table>';
          break;
  
        }
                case 'siteStatistik' :
                {
##########################################
function forum_statistic_show ($sql,$ges) {
  $erg = db_query($sql);
  echo '<table border="0" cellpadding="0" cellspacing="0">';
  while ($r = db_fetch_row($erg)) {
#    str_repeat('|',abs($row['regs'] / 2))
    echo '<tr><td>'.$r[1].'</td><td>'.str_repeat('|',$r[0]).' '.$r[0].'</td></tr>';
  }
  echo '</table>';
}
  
  
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_site.png" /></td><td width="30"></td><td valign="bottom"><h1>Seiten Statistik</h1></td></tr></table>';
  
echo '<table><tr><td valign="top">';
$heute = mktime(0,0,0,date('m'),date('d'),date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute),0,0);
echo 'Gesamt Posts heute: '.$anzheute.'<br /><hr>';
  
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User heute</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen heute</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren heute</b><br />';
forum_statistic_show($sql,$anzheute);
  
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User heute</b><br />';
forum_statistic_show($sql,$gsh);
  
echo '</td><td valign="top">';
$heute1 = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute),0,0);
echo 'Gesamt Posts gestern: '.$anzheute.'<br /><hr>';
  
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql,$anzheute);
  
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql,$anzheute);
  
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql,$gsh);
echo '</td></tr></table>';
  
echo '<h1>Es ist ganz erlich noch mehr geplant :P</h1>';
  
##########################################
                    break;
                }
  
        }
  
$design->footer();
?>

freiezocker.de/

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 28.04.2017 19:24 Uhr #9

xRebellx Mitglied

Registriert seit
07.08.2012

Beiträge
579

Beitragswertungen

Noch ne kleine Frage, bei 1 Benutzer und 0 Gäste » anzeigen wenn ich da auf anzeigen gehe zeigt er mir null user an obwohl eben 3 Gäste und ich drauf waren ? Ist jetzt kein großes Problem aber wäre doch cool wenn das auch noch geht :-)

Zuletzt modifiziert von xRebellx am 28.04.2017 - 19:24:41

freiezocker.de/
0 Mitglieder finden den Beitrag gut.
- zitieren

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » Fehler Anzeige im Admin Menü