Guest User

CrazyLogin Flat to MySQL

a guest
Sep 30th, 2012
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.77 KB | None | 0 0
  1. <?php
  2. $host = 'localhost';
  3. $linkuser = 'root';
  4. $linkpass = '';
  5. $database = 'login';
  6. $table = 'CrazyLogin_Players';
  7.  
  8. // Connect to Database
  9. $link = mysql_connect($host, $linkuser, $linkpass);
  10. if (!$link) {
  11. die('Could not connect: ' . mysql_error());
  12. }
  13. echo 'Connected successfully<br />';
  14. mysql_select_db($database, $link);
  15.  
  16. // Break apart the database and import it
  17. $urls="players.db";
  18. $page = join("",file("$urls"));
  19. $kw = explode("\n", $page);
  20. echo 'Importing now...<br />';
  21.  
  22. for($i=0;$i<count($kw);$i++){
  23. $data = $kw[$i];
  24. list($name, $pass, $ips, $lastAction) = explode("|", $data);
  25. mysql_query("INSERT INTO $table (name, password, ips, lastAction) VALUES ('$name', '$pass', '$ips', '$lastAction')");
  26. }
  27. echo '<br />Import successful.';
  28. mysql_close($link);
  29. ?>
Advertisement
Add Comment
Please, Sign In to add comment