Daten im Nutzerkonto:
';
fwrite($myfile, $file);
$sql = "SELECT
*
FROM
`VokabelBox2Users`
WHERE
`userid` = '$userid'";
$result_articles = $conn->query($sql);
while ($articleDb = mysqli_fetch_object($result_articles))
{
$file = "Benutzername: $articleDb->username
";
fwrite($myfile, $file);
$file = "Registrierte E-Mail: $articleDb->email
";
fwrite($myfile, $file);
$file = "Konto erstellt: $articleDb->create_date
";
fwrite($myfile, $file);
$file = "Letzter Kontozugriff: $articleDb->lastedit
";
fwrite($myfile, $file);
$file = "Sontige Einstellungen: $articleDb->settings
";
fwrite($myfile, $file);
}
$file = 'Vokabellisten
';
fwrite($myfile, $file);
$sql = "SELECT
*
FROM
`VokabelBox2Content`
WHERE
`path` LIKE '$userid/%' AND `type` = 'lang'";
$result_articles1 = $conn->query($sql);
while ($articleDb1 = mysqli_fetch_object($result_articles1))
{
$file = "Sprache:$articleDb1->value
";
fwrite($myfile, $file);
$actual_lang = $articleDb1->id;
$sql2 = "SELECT
*
FROM
`VokabelBox2Content`
WHERE
`path` LIKE '$userid/$actual_lang/%' AND `type` = 'list'";
$result_articles2 = $conn->query($sql2);
while ($articleDb2 = mysqli_fetch_object($result_articles2))
{
$file = "Liste:$articleDb2->value
";
fwrite($myfile, $file);
$actual_list = $articleDb2->id;
$file = "| Sprache 1 | Sprache 2 | Zul. geändert am/um | Erstellt am/um |
";
fwrite($myfile, $file);
$sql3 = "SELECT
*
FROM
`VokabelBox2Content`
WHERE
`path` = '$userid/lang/$actual_list/' AND `type` = 'voc'";
$result_articles3 = $conn->query($sql3);
while ($articleDb3 = mysqli_fetch_object($result_articles3))
{
$file = "";
fwrite($myfile, $file);
$voc = json_decode($articleDb3->value, true);
$file = "| " . $voc[0]['1'] . " | " . $voc[0]['2'] . " | " . $articleDb3->lastedit . " | " . $articleDb3->create_timestamp . " |
";
fwrite($myfile, $file);
}
$file = "
";
fwrite($myfile, $file);
}
}
$file = "