"; } // Om användare INTE klickat på spara-knapp else{ //radioknappar för val av data och sortering ?> Adminsidan " . $sql . " ";//skriver ut selectsatsen så man ser vad man valt ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; echo " " . mysql_field_name($result,$i) ." " . $minrad['medlemsID'] . " " . $minrad['anvnamn'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['fornamn'] . " " . $minrad['efternamn'] . " " . $minrad['adress'] . " " . $minrad['postnummer'] . " " . $minrad['postadress'] . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['epost'] . " " . $minrad['telefon'] . " " . $minrad['fodd'] . " " . $minrad['skapad'] . " " . $minrad['franip'] . " " . $minrad['inlogg'] . " " . $minrad['inloggSek'] . " " . $minrad['inloggip'] . " " . $minrad['inloggnr'] . " " . $minrad['profilertot'] . " " . $minrad['profiler'] . " " . $minrad['svar'] . " " . $minrad['svarat'] . " " . $minrad['brev'] . " " . $minrad['bepost'] . " " . $minrad['bild'] . " " . $minrad['mejllista'] . " " . $minrad['visaIL'] . " " . $minrad['IL'] . " " . $minrad['pwd_md5'] . " " . $minrad['pwd'] . " " . $minrad['grupp'] . " Ändra Radera " . mysql_field_name($result,$i) ." "; echo "Grupp = 0 raderad, grupp 1 = blockerad/avaktiverad, grupp 2 = ej aktiverad, grupp 3 = aktiveradf"; } //om användaren anget val 1 (osv på övriga) elseif($resultat=="12"){ $sql = "SELECT * FROM medlem ORDER BY efternamn, fornamn"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['medlemsID'] . " " . $minrad['anvnamn'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['fornamn'] . " " . $minrad['efternamn'] . " " . $minrad['adress'] . " " . $minrad['postnummer'] . " " . $minrad['postadress'] . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['epost'] . " " . $minrad['telefon'] . " " . $minrad['fodd'] . " " . $minrad['skapad'] . " " . $minrad['franip'] . " " . $minrad['inlogg'] . " " . $minrad['inloggSek'] . " " . $minrad['inloggip'] . " " . $minrad['inloggnr'] . " " . $minrad['profilertot'] . " " . $minrad['profiler'] . " " . $minrad['svar'] . " " . $minrad['svarat'] . " " . $minrad['brev'] . " " . $minrad['bepost'] . " " . $minrad['bild'] . " " . $minrad['mejllista'] . " " . $minrad['visaIL'] . " " . $minrad['IL'] . " " . $minrad['pwd_md5'] . " " . $minrad['pwd'] . " " . $minrad['grupp'] . " Ändra Radera "; echo "Grupp = 0 raderad, grupp 1 = blockerad/avaktiverad, grupp 2 = ej aktiverad, grupp 3 = aktiveradf"; } elseif($resultat=="13" OR $resultat=="14" OR $resultat=="311" OR $resultat=="312" OR $resultat=="313" OR $resultat=="314"){ if ($resultat=="13"){ $sql = "SELECT * FROM medlem ORDER BY inloggnr DESC"; } if ($resultat=="14"){ $sql = "SELECT * FROM medlem WHERE inloggnr>0 AND mejllista='on' ORDER BY medlemsID"; } if ($resultat=="311"){ $sql = "SELECT * FROM medlem WHERE grupp<10 ORDER BY medlemsID DESC"; } if ($resultat=="312"){ $sql = "SELECT * FROM medlemfel ORDER BY medlemsID DESC"; } if ($resultat=="313"){ $sql = "SELECT * FROM medlem WHERE grupp>9 ORDER BY medlemsID DESC"; } if ($resultat=="314"){ $sql = "SELECT * FROM medlemReserv ORDER BY medlemsID DESC"; } echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['medlemsID'] . " " . $minrad['anvnamn'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['fornamn'] . " " . $minrad['efternamn'] . " " . $minrad['adress'] . " " . $minrad['postnummer'] . " " . $minrad['postadress'] . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['epost'] . " " . $minrad['telefon'] . " " . $minrad['fodd'] . " " . $minrad['skapad'] . " " . $minrad['franip'] . " " . $minrad['inlogg'] . " " . $minrad['inloggSek'] . " " . $minrad['inloggip'] . " " . $minrad['inloggnr'] . " " . $minrad['profilertot'] . " " . $minrad['profiler'] . " " . $minrad['svar'] . " " . $minrad['svarat'] . " " . $minrad['brev'] . " " . $minrad['bepost'] . " " . $minrad['bild'] . " " . $minrad['mejllista'] . " " . $minrad['visaIL'] . " " . $minrad['IL'] . " " . $minrad['pwd_md5'] . " " . $minrad['pwd'] . " " . $minrad['grupp'] . " Ändra Radera "; echo "Grupp = 0 raderad, grupp 1 = blockerad/avaktiverad, (grupp 2 = ej aktiverad, grupp 3 = aktiverad) grupp 9 radera ngt men vad?"; } elseif($resultat=="31"){ $sql = "SELECT * FROM medlem WHERE IL='1' ORDER BY inlogg DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['medlemsID'] . " " . $minrad['anvnamn'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['fornamn'] . " " . $minrad['efternamn'] . " " . $minrad['adress'] . " " . $minrad['postnummer'] . " " . $minrad['postadress'] . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['epost'] . " " . $minrad['telefon'] . " " . $minrad['fodd'] . " " . $minrad['skapad'] . " " . $minrad['franip'] . " " . $minrad['inlogg'] . " " . $minrad['inloggSek'] . " " . $minrad['inloggip'] . " " . $minrad['inloggnr'] . " " . $minrad['profilertot'] . " " . $minrad['profiler'] . " " . $minrad['svar'] . " " . $minrad['svarat'] . " " . $minrad['brev'] . " " . $minrad['bepost'] . " " . $minrad['bild'] . " " . $minrad['mejllista'] . " " . $minrad['visaIL'] . " " . $minrad['IL'] . " " . $minrad['pwd_md5'] . " " . $minrad['pwd'] . " " . $minrad['grupp'] . " Ändra Radera "; echo "Grupp = 0 raderad, grupp 1 = blockerad/avaktiverad, grupp 2 = ej aktiverad, grupp 3 = aktiveradf"; } elseif($resultat=="20"){ $sql = "SELECT * FROM brev WHERE 1 ORDER BY datum DESC, brevID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['brevID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagareID'] . " " . $minrad['typ'] . " " . $minrad['svarat'] . " " . $minrad['rubrik'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; } elseif($resultat=="21"){ $sql = "SELECT * FROM brev WHERE aktiv='on' ORDER BY datum DESC, brevID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['brevID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagareID'] . " " . $minrad['typ'] . " " . $minrad['svarat'] . " " . $minrad['rubrik'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; } elseif($resultat=="22"){ $sql = "SELECT * FROM brev WHERE aktiv='on' ORDER BY mottagareID, typ, brevID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['brevID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagareID'] . " " . $minrad['typ'] . " " . $minrad['svarat'] . " " . $minrad['rubrik'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; } elseif($resultat=="27"){ $sql = "SELECT * FROM brev WHERE aktiv!='on' ORDER BY mottagareID, typ, brevID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['brevID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagareID'] . " " . $minrad['typ'] . " " . $minrad['svarat'] . " " . $minrad['rubrik'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; } elseif($resultat=="29"){ $sql = "SELECT * FROM brevlogg WHERE 1 ORDER BY datum DESC, brevloggID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['brevloggID'] . " " . $minrad['medlemsID'] . " " . $minrad['IP'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagareID'] . " " . $minrad['brevID'] . " " . $minrad['kopia'] . " " . $minrad['kontaktID'] . " Ändra Radera "; } elseif($resultat=="4"){//lista besökare $sql = "SELECT * FROM besokare WHERE 1 ORDER BY datum DESC, besokareNr DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 1 extracell echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['besokareNr'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['ipadress'] . " " . $minrad['agent'] . " " . $minrad['referer'] . " Radera "; } elseif($resultat=="401"){//lista besökare $sql = "SELECT * FROM kakbak WHERE 1 ORDER BY datum DESC, kakbakNr DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 1 extracell echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['kakbakNr'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['ipadress'] . " " . $minrad['agent'] . " " . $minrad['referer'] . " Radera "; } elseif($resultat=="402" OR $resultat=="403" OR $resultat=="404" OR $resultat=="405" OR $resultat=="406"){//lista aktiviteter if ($resultat == "402"){ $sql = "SELECT * FROM aktiviteter WHERE medlemsID>43 ORDER BY medlemsID, ipadress, datumSek DESC LIMIT 1000"; }elseif ($resultat == "403"){ $sql = "SELECT * FROM aktiviteter WHERE 1 ORDER BY besokareNr DESC LIMIT 1000"; }elseif ($resultat == "404"){ $sql = "SELECT * FROM aktiviteter WHERE ipadress NOT LIKE '213.114.33%' ORDER BY besokareNr DESC LIMIT 50"; }elseif ($resultat == "405"){ $sql = "SELECT * FROM aktiviteter WHERE 1 ORDER BY besokareNr LIMIT 20"; }elseif ($resultat == "406"){ $sql = "SELECT * FROM aktiviteter WHERE 1 ORDER BY medlemsID DESC LIMIT 1000"; } echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 1 extracell echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['besokareNr'] . " " . $minrad['medlemsID'] . " " . $minrad['sida'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['ipadress'] . " " . $minrad['agent'] . " " . $minrad['referer'] . " Radera "; } elseif($resultat=="9004"){//lista besökare $sql = "SELECT * FROM besokare WHERE 1 ORDER BY datum DESC, besokareNr DESC limit 30"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 1 extracell echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['besokareNr'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['ipadress'] . " " . $minrad['agent'] . " " . $minrad['referer'] . " Radera "; } elseif($resultat=="41"){//lista besökare max 25 st $sql = "SELECT DISTINCT referer, count(*) as antal FROM besokare GROUP BY referer ORDER BY antal DESC LIMIT 25"; //$sql = "SELECT * FROM besokare WHERE 1 ORDER BY datum DESC, besokareNr DESC"; echo "" . $sql . " "; ?> " . mysql_field_name($result,$i) .""; } // 1 extracell //echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; //echo ""; //echo ""; //echo ""; //echo ""; echo ""; echo ""; //echo ""; echo ""; } echo " " . $minrad['besokareNr'] . " " . $minrad['datum'] . " " . $minrad['ipadress'] . " " . $minrad['agent'] . " " . $minrad['referer'] . " " . $minrad['antal'] . " Radera "; } elseif($resultat=="5"){ $sql = "SELECT * FROM raknare WHERE 1 ORDER BY antalbesokare DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['antalbesokare'] . " "; } elseif($resultat=="48"){ $sql = "SELECT * FROM tipsalogg ORDER BY tipsaloggID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['tipsaloggID'] . " " . $minrad['medlemsID'] . " " . $minrad['avsEpost'] . " " . $minrad['avsNamn'] . " " . $minrad['IP'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['tillEpost'] . " " . $minrad['tillNamn'] . " " . $minrad['meddelande'] . " Radera "; } elseif($resultat=="6"){ $sql = "SELECT * FROM nyheter WHERE 1 ORDER BY datum DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; //echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['artikelID'] . " " . $minrad['datum'] . " " . $minrad['uppdaterad'] . " " . $minrad['rubrik'] . " " . $minrad['ingress'] . " " . substr($minrad['ingress'],0,40) . " " . $minrad['brodtext'] . " " . substr($minrad['brodtext'],0,40) . " " . $minrad['forfattare'] . " " . $minrad['bildtext'] . " " . substr($minrad['bildtext'],0,40) . " " . $minrad['fotobyline'] . " " . $minrad['bild'] . " " . $minrad['musik'] . " " . $minrad['aktiv'] . " " . $minrad['visad'] . " Ändra Radera "; } elseif($resultat=="7"){ $sql = "SELECT * FROM kontaktaoss WHERE 1 ORDER BY datum3 DESC, namn3 DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 1 extracell echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['kontaktID'] . " " . $minrad['medlemsID'] . " " . $minrad['datum3'] . " " . $minrad['ip3'] . " " . $minrad['namn3'] . " " . $minrad['rubrik3'] . " " . $minrad['meddelande3'] . " " . $minrad['epost3'] . " " . $minrad['telefon3'] . " Radera "; } //om användaren anget val 1 (osv på övriga) if($resultat=="71"){ $sql = "SELECT * FROM vinnbiobiljetter ORDER BY medlemsID";//se radioknappar isas för förklaring echo "" . $sql . " ";//skriver ut selectsatsen så man ser vad man valt ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; echo ""; } // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; echo " " . mysql_field_name($result,$i) ." " . $minrad['medlemsID'] . " " . $minrad['anvnamn'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['fornamn'] . " " . $minrad['efternamn'] . " " . $minrad['adress'] . " " . $minrad['postnummer'] . " " . $minrad['postadress'] . " " . $minrad['lan'] . " " . $minrad['epost'] . " " . $minrad['telefon'] . " " . $minrad['fodd'] . " " . $minrad['skapad'] . " " . $minrad['franip'] . " " . $minrad['inlogg'] . " " . $minrad['inloggSek'] . " " . $minrad['inloggip'] . " " . $minrad['inloggnr'] . " " . $minrad['profilertot'] . " " . $minrad['profiler'] . " " . $minrad['svar'] . " " . $minrad['svarat'] . " " . $minrad['brev'] . " " . $minrad['bild'] . " " . $minrad['mejllista'] . " " . $minrad['visaIL'] . " " . $minrad['IL'] . " " . $minrad['pwd_md5'] . " " . $minrad['pwd'] . " " . $minrad['grupp'] . " Ändra Radera " . mysql_field_name($result,$i) ." "; echo "Grupp = 0 raderad, grupp 1 = blockerad/avaktiverad, grupp 2 = ej aktiverad, grupp 3 = aktiveradf"; } if($resultat=="9071"){ $sql = "SELECT * FROM vinnbiobiljetter ORDER BY medlemsID DESC limit 30";//se radioknappar isas för förklaring echo "" . $sql . " ";//skriver ut selectsatsen så man ser vad man valt ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; echo ""; } // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; echo " " . mysql_field_name($result,$i) ." " . $minrad['medlemsID'] . " " . $minrad['anvnamn'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['fornamn'] . " " . $minrad['efternamn'] . " " . $minrad['adress'] . " " . $minrad['postnummer'] . " " . $minrad['postadress'] . " " . $minrad['lan'] . " " . $minrad['epost'] . " " . $minrad['telefon'] . " " . $minrad['fodd'] . " " . $minrad['skapad'] . " " . $minrad['franip'] . " " . $minrad['inlogg'] . " " . $minrad['inloggSek'] . " " . $minrad['inloggip'] . " " . $minrad['inloggnr'] . " " . $minrad['profilertot'] . " " . $minrad['profiler'] . " " . $minrad['svar'] . " " . $minrad['svarat'] . " " . $minrad['brev'] . " " . $minrad['bild'] . " " . $minrad['mejllista'] . " " . $minrad['visaIL'] . " " . $minrad['IL'] . " " . $minrad['pwd_md5'] . " " . $minrad['pwd'] . " " . $minrad['grupp'] . " Ändra Radera " . mysql_field_name($result,$i) ." "; echo "Grupp = 0 raderad, grupp 1 = blockerad/avaktiverad, grupp 2 = ej aktiverad, grupp 3 = aktiveradf"; } elseif($resultat=="8"){ $sql = "SELECT * FROM namnsdag WHERE 1 ORDER BY namndatum"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['namnsdagID'] . " " . $minrad['namndatum'] . " " . $minrad['namndag'] . " " . $minrad['namnnamn1'] . " " . $minrad['namnnamn2'] . " " . $minrad['namnnamn3'] . " Ändra Radera "; } elseif($resultat=="801" OR $resultat=="802"){ ?>Skriv in språktexter " . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['sprakID'] . " " . $minrad['sprakkod'] . " " . $minrad['sprak101'] . " " . $minrad['sprak102'] . " Ändra Radera "; } elseif($resultat=="81" OR $resultat=="82" OR $resultat=="83"){ if ($resultat == "81"){ $sql = "SELECT * FROM logginlogg WHERE 1 ORDER BY IP, medlemsID, datumSek DESC"; }elseif ($resultat == "82"){ $sql = "SELECT * FROM logginlogg WHERE 1 ORDER BY datumSek DESC, IP, medlemsID"; }else { $sql = "SELECT * FROM logginlogg WHERE 1 ORDER BY logginloggID DESC"; } echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 1 extracell echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "";//komplettering 20060614 echo " " . mysql_field_name($result,$i) ." " . $minrad['logginloggID'] . " " . $minrad['medlemsID'] . " " . $minrad['IP'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['grupp'] . " " . $minrad['epost'] . " " . $minrad['pwd'] . " Radera MedlemsID=ngt + grupp=ngt, Ok inloggad MedlemsID=0, epost=ngt, password=ngt, ogiltig inloggning MedlemsID=0, epost=ngt, begäran om lösenord för felaktig epostadress MedlemsID=ngt, epost=ngt, password=ngt, korrekt begäran om lösenord MedlemsID=ngt, grupp=0, inloggningsförsök av avslutad medlem. "; } elseif($resultat=="840"){ $sql = "SELECT * FROM mejllista WHERE 1 ORDER BY mejllistaID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['mejllistaID'] . " " . $minrad['medlemsID'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagare'] . " " . $minrad['rubrik'] . " " . $minrad['text'] . " " . $minrad['mottagare102'] . " " . $minrad['rubrik102'] . " " . $minrad['text102'] . " " . $minrad['byline'] . " " . $minrad['ip'] . " Ändra Radera "; } elseif($resultat=="9"){ $sql = "SELECT * FROM kontakt WHERE 1 ORDER BY datum DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['kontaktID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['uppdaterad'] . " " . $minrad['rubrik'] . " " . $minrad['typrel'] . " " . $minrad['text'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['status'] . " " . $minrad['laggning'] . " " . $minrad['barn'] . " " . $minrad['villbarn'] . " " . $minrad['arbete'] . " " . $minrad['flyttbar'] . " " . $minrad['religion'] . " " . $minrad['roker'] . " " . $minrad['alkohol'] . " " . $minrad['droger'] . " " . $minrad['harfarg'] . " " . $minrad['vikt'] . " " . $minrad['langd'] . " " . $minrad['musik'] . " " . $minrad['fritiden'] . " " . $minrad['personlighet'] . " " . $minrad['mat'] . " " . $minrad['annat'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; } elseif($resultat=="91" OR $resultat=="96"){ if ($resultat=="91"){ $sql = "SELECT * FROM kontakt WHERE aktiv = 'on' ORDER BY rubrik, datum"; } if ($resultat=="96"){ $sql = "SELECT * FROM kontakt WHERE aktiv = 'on' ORDER BY kontaktID DESC"; } //$sql = "SELECT * FROM kontakt WHERE aktiv = 'on' ORDER BY rubrik, datum"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['kontaktID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['uppdaterad'] . " " . $minrad['rubrik'] . " " . $minrad['typrel'] . " " . $minrad['text'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['status'] . " " . $minrad['laggning'] . " " . $minrad['barn'] . " " . $minrad['villbarn'] . " " . $minrad['arbete'] . " " . $minrad['flyttbar'] . " " . $minrad['religion'] . " " . $minrad['roker'] . " " . $minrad['alkohol'] . " " . $minrad['droger'] . " " . $minrad['harfarg'] . " " . $minrad['vikt'] . " " . $minrad['langd'] . " " . $minrad['musik'] . " " . $minrad['fritiden'] . " " . $minrad['personlighet'] . " " . $minrad['mat'] . " " . $minrad['annat'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; }elseif($resultat=="92"){ $sql = "SELECT * FROM kontakt WHERE aktiv != 'on' ORDER BY datum"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['kontaktID'] . " " . $minrad['medlemsID'] . " " . $minrad['signatur'] . " " . $minrad['kon'] . " " . $minrad['sprak'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['uppdaterad'] . " " . $minrad['rubrik'] . " " . $minrad['typrel'] . " " . $minrad['text'] . " " . substr($minrad['text'],0,40) . " " . $minrad['lan'] . " " . $minrad['land'] . " " . $minrad['ort'] . " " . $minrad['fodd'] . " " . $minrad['status'] . " " . $minrad['laggning'] . " " . $minrad['barn'] . " " . $minrad['villbarn'] . " " . $minrad['arbete'] . " " . $minrad['flyttbar'] . " " . $minrad['religion'] . " " . $minrad['roker'] . " " . $minrad['alkohol'] . " " . $minrad['droger'] . " " . $minrad['harfarg'] . " " . $minrad['vikt'] . " " . $minrad['langd'] . " " . $minrad['musik'] . " " . $minrad['fritiden'] . " " . $minrad['personlighet'] . " " . $minrad['mat'] . " " . $minrad['annat'] . " " . $minrad['bild'] . " " . $minrad['aktiv'] . " " . $minrad['ip'] . " " . $minrad['visad'] . " Ändra Radera "; echo "Aktiv: 0 betyder att den är raderad, '' ingenting betyder att den är tagen ur bruk av admin"; } elseif($resultat=="93"){//20060419, grundkod (omarbetad) från PHP-portateln, GoranTornqvist o fattarNull $get = mysql_query("SELECT COUNT(rubrik) AS counted, rubrik AS rubriker FROM kontakt WHERE aktiv = 'on' GROUP BY rubrik") or die(mysql_error()); //endast aktiva profiler //Tar reda på antalet poster som resultat av sökningen $antal_poster = @mysql_num_rows($get); echo "Summering antal aktiva profiler per rubrik"; echo " Antal aktiva rubriker: " . $antal_poster . " "; while($row = mysql_fetch_assoc($get)) { echo ""; echo ""; $tillf = $tillf + $row['counted']; echo ""; echo " " . $row['counted'] . " " . $row['rubriker'] . " "; } echo " Totalt antal (aktiva) profiler: " . $tillf . " "; $get = mysql_query("SELECT COUNT(lan) AS counted, lan AS rubriker FROM kontakt WHERE aktiv = 'on' GROUP BY lan") or die(mysql_error()); //endast aktiva profiler //Tar reda på antalet poster som resultat av sökningen $antal_poster = @mysql_num_rows($get); echo "Summering antal aktiva profiler per län"; echo " Antal aktiva län: " . $antal_poster . " "; while($row = mysql_fetch_assoc($get)) { echo ""; echo ""; $tillf = $tillf + $row['counted']; echo ""; echo " " . $row['counted'] . " " . $row['rubriker'] . " "; } echo " Totalt antal (aktiva) profiler: " . $tillf . " "; $get = mysql_query("SELECT COUNT(fodd) AS counted, fodd AS rubriker FROM kontakt WHERE aktiv = 'on' GROUP BY fodd") or die(mysql_error()); //endast aktiva profiler //Tar reda på antalet poster som resultat av sökningen $antal_poster = @mysql_num_rows($get); echo "Summering antal aktiva profiler per födelseår"; echo " Antal aktiva födelseår: " . $antal_poster . " "; while($row = mysql_fetch_assoc($get)) { echo ""; echo ""; $tillf = $tillf + $row['counted']; echo ""; echo " " . $row['counted'] . " " . $row['rubriker'] . " "; } echo " Totalt antal (aktiva) profiler: " . $tillf . " "; } elseif($resultat=="100"){ for($i=10; $i <257;$i = $i+1){ echo " " . $i . " --> " . chr($i). " ";} } elseif($resultat=="101"){ $sql = "SHOW TABLES FROM pusslink_se"; $result = mysql_query($sql); if (!$result) { echo "DB Error, could not list tables\n"; echo 'MySQL Error: ' . mysql_error(); exit; } echo ""; echo ""; while ($row = mysql_fetch_row($result)) { echo ""; #Get next auto_increment value: BY sindijs at apollo dot lv 06-Sep-2005 02:21 # mysql_connect("localhost", "login", "passwd") or #die("Cannot connect: " . mysql_error()); #mysql_select_db("db_name"); $res = mysql_query("SHOW TABLE STATUS LIKE '$row[0]' ") or die(mysql_error()); $row_res = mysql_fetch_array($res); echo " Tabell Nästa postnr {$row[0]} \n " . ($row_res[Auto_increment]-0); } echo " "; ##Anonymous 15-Dec-2005 03:38 // Get database status by DtTvB // Connect first #mysql_connect ('*********', '*********', '********'); #mysql_select_db ('*********'); // Get the list of tables $sql = 'SHOW TABLES FROM pusslink_se'; if (!$result = mysql_query($sql)) { die ('Error getting table list (' . $sql . ' :: ' . mysql_error() . ')'); } // Make the list of tables an array $tablerow = array(); while ($row = mysql_fetch_array($result)) { $tablerow[] = $row; } // Define variables... $total_tables = count($tablerow); $statrow = array(); $total_rows = 0; $total_rows_average = 0; $sizeo = 0; // Get the status of each table for ($i = 0; $i < count($tablerow); $i++) { // Query the status... $sql = "SHOW TABLE STATUS LIKE '{$tablerow[$i][0]}';"; if (!$result = mysql_query($sql)) { die ('Error getting table status (' . $sql . ' :: ' . mysql_error() . ')'); } // Get the status array of this table $table_info = mysql_fetch_array($result); // Add them to the total results $total_rows += $table_info[3]; $total_rows_average += $table_info[4]; $sizeo += $table_info[5]; } // Function to calculate size of the file function c2s($bs) { if ($bs < 964) { return round($bs) . " Bytes"; } else if ($bs < 1000000) { return round($bs/1024,2) . " KB" ; } else { return round($bs/1048576,2) . " MB" ; } } // Echo the result!!!!!!!!! echo " "; echo "{$total_rows} rows in {$total_tables} tables"; echo " Average size in each row: " . c2s($total_rows_average/$total_tables); echo " Average size in each table: " . c2s($sizeo/$total_tables); echo " Database size: " . c2s($sizeo); echo " Storleken är ngt större enligt sql-admin"; echo " "; ## } elseif($resultat=="102"){ echo "Finns även i filen phpinfo.php"; phpinfo(); } elseif($resultat=="94"){ $sql = "SELECT * FROM kontaktlogg ORDER BY kontaktloggID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['kontaktloggID'] . " " . $minrad['medlemsID'] . " " . $minrad['IP'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['mottagareID'] . " " . $minrad['kontaktID'] . " " . $minrad['kopia'] . " Radera "; } elseif($resultat=="970" OR $resultat =="971" OR $resultat =="972"){ if ($resultat=="970"){ $sql = "SELECT * FROM profillogg ORDER BY profilloggID DESC limit 500"; } if ($resultat=="971"){ $sql = "SELECT * FROM profillogg ORDER BY kontaktID DESC, IP, medlemsID limit 500"; } if ($resultat=="972"){ $sql = "SELECT * FROM profillogg ORDER BY medlemsID DESC, IP, kontaktID limit 500"; } //$sql = "SELECT * FROM profillogg ORDER BY profilloggID DESC limit 500"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." " . $minrad['profilloggID'] . " " . $minrad['kontaktID'] . " " . $minrad['medlemsID'] . " " . $minrad['IP'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['sokstrang'] . " Radera "; } elseif($resultat=="103"){ $sql = "SELECT * FROM logginmeddelande WHERE 1 ORDER BY limID DESC"; echo "" . $sql . " "; ?> Antal funna poster: " . $antal_poster; // Skriv först ut fältnamnen for ($i=0; $i < mysql_num_fields($result); $i++) { echo ""; } // 2 extraceller echo ""; while($minrad = mysql_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; } echo " " . mysql_field_name($result,$i) ." Förfaller 86400sek=24h " . $minrad['limID'] . " " . $minrad['medlemsID'] . " " . $minrad['datum'] . " " . $minrad['datumSek'] . " " . $minrad['forfaller'] . " " . $minrad['meddelande'] . " " . ($minrad['forfaller']-date('U')) . " sekunder (1 dygn=86400 sek) " . ($minrad['forfaller']-date('U')) . " sekunder Ändra Radera "; } elseif($resultat=="950"){ $mapp2 = 'kontaktbilder'; function mappstorlek($mapp = 'kontaktbilder/') { $dir = dir($mapp); $size = 0; while($file = $dir->read()) { if ($file != '.' && $file != '..') { if (is_dir($file)) { $size += mappstorlek($mapp . '/' . $file); } else { $size += filesize($mapp . '/' . $file); } } } $dir->close(); return $size; } $bytes = mappstorlek(); // Räkna om bytes till MegaBytes (2 decimaler) $MB = round(($bytes / 1048576), 2); // Räkna om bytes till kiloBytes (inga decimaler) $kB = round(($bytes / 1024), 0); echo "Mappen " . $mapp2 . " är på $MB MB ($kB kB) "; } elseif($resultat=="951"){ $mapp2 = 'tumnaglar'; function mappstorlek($mapp = 'tumnaglar/') { $dir = dir($mapp); $size = 0; while($file = $dir->read()) { if ($file != '.' && $file != '..') { if (is_dir($file)) { $size += mappstorlek($mapp . '/' . $file); } else { $size += filesize($mapp . '/' . $file); } } } $dir->close(); return $size; } $bytes = mappstorlek(); // Räkna om bytes till MegaBytes (2 decimaler) $MB = round(($bytes / 1048576), 2); // Räkna om bytes till kiloBytes (inga decimaler) $kB = round(($bytes / 1024), 0); echo "Mappen " . $mapp2 . " är på $MB MB ($kB kB) "; } elseif($resultat=="952"){ $mapp2 = 'personbilder'; function mappstorlek($mapp = 'personbilder/') { $dir = dir($mapp); $size = 0; while($file = $dir->read()) { if ($file != '.' && $file != '..') { if (is_dir($file)) { $size += mappstorlek($mapp . '/' . $file); } else { $size += filesize($mapp . '/' . $file); } } } $dir->close(); return $size; } $bytes = mappstorlek(); // Räkna om bytes till MegaBytes (2 decimaler) $MB = round(($bytes / 1048576), 2); // Räkna om bytes till kiloBytes (inga decimaler) $kB = round(($bytes / 1024), 0); echo "Mappen " . $mapp2 . " är på $MB MB ($kB kB) "; } //om inget val har gjorts men submitknappen aktiverats else{?> Du har inte gjort något sorterings och utskriftsval. Gå till adminmenyn och försök igen. Till adminmenyn Skriv ut Till Jourreporter.se Logga ut Din nuvarande ip-adress är " . $ipadress2 . " "; //text som skrivs ut enbart för högste admin echo ""; echo ""; $ipadress2 = $_SERVER['REMOTE_ADDR'];//sätter ip-adressen echo ""; $ipadress2 = $_SERVER['HTTP_USER_AGENT'];//sätter ip-adressen echo ""; $ipadress2 = $_SERVER['HTTP_REFERER'];//sätter ip-adressen echo ""; echo " Jourreporter.se Lista vinn biobiljetter senast först Lista besökare senast först (max 30) Lista aktviteter (max 50) Lista aktiva användare (sorterat på ID-nummer DESC) Lista användare (sorterat på ID-nummer) Lista användare (sorterat på efternamn, förnamn) Lista användare (sorterat på antal inloggningar) Lista användare (inloggade>0 mejllista=on) Lista användare (inloggade, sorterat på tidpunkt DESC) Lista ej aktiva användare (sorterat på ID-nummer DESC) Lista medlem reserv (DESC) Lista ej fullbordade nya medlemmar (DESC) Lista brev (alla, sorterat på datum DESC) Lista brev (aktiva, sorterat på datum DESC) Lista brev (aktiva, sorterat på mottagare, brevID DESC) Lista brev (inaktiva, sorterat på mottagare, brevID DESC) Lista brevlogg Lista alla profiler Lista aktiva profiler (senast först) Lista aktiva profiler (rubrik/datum) Lista inaktiva profiler Lista antal profiler grupperat Lista kontaktlogg (epostlogg) Lista profillogg Lista profillogg sorterad kontakt, medlemsID, IP Lista profillogg sorterad medlemsID, IP, kontakt Lista mappstorlek bilder profiler Lista mappstorlek bilder tumnaglar Lista mappstorlek bilder personbilder Lista kontakta oss Lista vinn biobiljetter Lista besökare Lista besökare - referens topp 25 Lista aktiviteter sorterat Lista aktiviteter löpnummerordning Lista aktiviteter löpnummerordning/medlemsnummer Lista aktiviteter löpnummerordning från början Lista kakbak Lista antalbesokare Lista tipsalogg Lista namnsdagar Lista språktexter (språkID) Lista språktexter (löpnummer) Lista nyhetsartiklar Lista ASCII-tecken Lista tabeller i databasen Visa PHP-info Visa logginmeddelanden Lista logginlogg (IP, medlemsID, datumSek DESC) Lista logginlogg (datumSek DESC, IP, medlemsID) Lista logginlogg (logginloggID DESC) Lista mejllista (DESC) Mejlfunktion admin Mejla mejllista Kalender Visa PHP-ini filen med data Lägg till användare Skriv in språktexter Justera automatprocesser Lägg till användare Till Jourreporter.se Logga ut Om användares gruppkod ändras träder den ikraft först när användaren loggat ut och in igen. Användare med grupp 96 eller högre kan redigera uppdateringsdatumet. Din nuvarande ip-adress är " . $ipadress2 . " Din nuvarande agent är " . $ipadress2 . " Din nuvarande referer är " . $ipadress2 . " "; } ?>