Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //DB Information
- $host = '127.0.0.1';
- $db = 'swgemu';
- $user = 'root';
- $pass = '<your_password>';
- $charset = 'utf8';
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- $pdo = new PDO($dsn, $user, $pass, $opt);
- //SWGEmu information
- $dbsecret = '<YOUR_SECRET>';
- $sql = 'SELECT * FROM register';
- foreach ($pdo->query($sql) as $row) {
- $reg = bin2hex(openssl_random_pseudo_bytes(16));
- $username = $row['username'];
- $stmt = $pdo->prepare("UPDATE register SET reghash = ? where username = ?");
- $stmt->execute(array($reg,$username));
- print $row['username'] . " Updated" . "\n";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement