} elseif ($_GET['action'] === "redata") { db()->multi_execute(file_get_contents("data.sql")); echo "Data recreated.<br>"; } elseif ($_GET['action'] === "reset_psword") { $sql = file_get_contents("data.sql"); db()->query("UPDATE medlemmer SET salt = GET_RANDOM(4)"); db()->query("UPDATE medlemmer SET pass = MD5(CONCAT(salt, username))"); echo "All passwords set to the username.<br>"; } elseif ($_GET['action'] === "load_testnames") { $sql = file_get_contents("test_names.sql"); db()->multi_execute($sql); echo "Names loaded.<br>"; } elseif ($_GET['action'] === "connect") { $con = new ODBCWrapper("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:/dwork/Trafikstatistik 2000.mdb", "", ""); $dbf = new DatabaseFunctions($con); echo $dbf->implode_query("\tSELECT *\n\t\t\t\t\t\t\t\t\t\t\tFROM PersonOplysninger\n\t\t\t\t\t\t\t\t\t\t\t"); } elseif ($_GET['action'] === "gen_test_data") { db()->query("truncate table medlemmer"); $test_names = db()->query("SELECT name,email FROM test_names"); $con = new ODBCWrapper("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:/dwork/Trafikstatistik 2000.mdb", "", ""); $query = $con->query("SELECT * FROM PersonOplysninger ORDER BY navn"); while ($row = $query->fetch_row()) { $ano_row = $test_names->fetch_row(); $ano_name = $ano_row[0]; // out($row); $username = trim_name_to_username($ano_name); $sql = <<<ASDF t\t\t\t\tINSERT INTO medlemmer (`username`, `pass`, `salt`, `navn`, `adresse`, `kommune`, `email`, `nyhedsbrev`, `status`, `created`) t\t\t\t\t\tVALUES ('{$username}', t\t\t\t\t\t\t\t'', t\t\t\t\t\t\t\t'',