Hier ein PHP Script um die Datenbank vollzuspamen mit uid + guid 
Ich generiere derzeit mit 230k Entries / Minute
Spoiler anzeigen
PHP
<?php
function s64toGuid($int) {
$temp = '';
for ($i = 0; $i < 8; $i++) {
$temp .= chr($int & 0xFF);
$int >>= 8;
}
$guid = md5('BE' . $temp);
return $guid;
}
$conn = new mysqli('127.0.0.1', 'DATABASE_USERNAME', 'DATABASE_PASSWORD', 'DATABASE_NAME');
if ($conn->connect_error) {
echo "Could not create Database Connection: ".$conn->connect_error;
die();
}
$result = $conn->query("SELECT MAX(steamId64) as maxid FROM guid");
$steamid = $result->fetch_assoc()['maxid'];
if ($result->num_rows != 1 || $steamid < 76561197960265730) {
$steamid = 76561197960265730;
} else {
$steamid++;
}
$i = 0;
echo "Starting at ".$steamid."\n";
$stopwatch = time();
$last = 0;
while ($steamid <= 9223372036854775807) {
if ($stopwatch < (time() - 60)) {
echo "Generating with ".($i - $last)." Entries per Minute!\n";
$stopwatch = time();
$last = $i;
}
if ($i % 10000 == 0) echo "Generated ".$i." UIDs!\n";
if ($conn->query("INSERT INTO guid (steamId64, guid) VALUES (".$conn->escape_string($steamid).", '".$conn->escape_string(s64toGuid($steamid))."')") !== TRUE) {
echo "Insert Error! ".$conn->error;
die();
}
$i++;
$steamid++;
}Datenbank Struktur:
Spoiler anzeigen
SQL
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `guid` (
`id` int(11) NOT NULL,
`steamId64` bigint(17) NOT NULL,
`guid` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `guid`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `steamId64` (`steamId64`);
ALTER TABLE `guid`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;Erstellt nur Tabelle mit dazugehöriger Struktur
