Unload ALL your Posts by request

[Chip (OP)]

ref. at: http://www.simplemachines.org/community/index.php?topic=548761

if you want me to email you a copy of all your posts (and only your posts -- think of the Opiophile fiasco) then i will do so - just reply to this, email or PM me. Here is the SQL/php code i wrote for you, should you want or need it:

Code: [Select]

<?php
$servername = "localhost";
$username = "root";
$password = "xxxx"; // <- modify
$dbname = "smf209";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT *
        FROM  `smf209_messages` WHERE poster_name =  'uuuu' ORDER BY id_topic, poster_time"; // <-modify poster_name
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        print "<strong>".$row['subject']."</strong> by ". $row['poster_name']. "<br/>";
        echo "Dated: ". date("d/m/Y H:i:s", $row['poster_time']);
        echo " ". PHP_EOL. "<br/>";
        echo $row['body']. PHP_EOL. "<br/>";
        echo " ". PHP_EOL. "<br/>";
    }
} else {
        echo "0 results";
}
$conn->close();
?>

the output looks like this:

Re: Cut in Methamphet. Causes Small Necrotic Spot by uuuu
Dated: 15/12/2014 18:55:41
... that eventually almost fully healed. immune system must be ok, yeah ?

Re: IV use almost all used up. ~ Very Limited Venous Real Estate by uuuu
Dated: 15/12/2014 18:54:45
stopped shooting ... the smart thing to do.

Re: logo by uuuu
Dated: 22/12/2014 19:50:47
i added a logo today, your critique is sought ...

Re: logo by uuuu
Dated: 23/12/2014 02:17:41
i will be getting around to different Themes a bit later, i would like colour changes too.

etc. etc. etc.

[Chip (OP)]

*bump*