Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // This solution isn't elegant but works fine.
- // CONFIGURATION ---------------------------------------------------
- // set memory limit
- ini_set('memory_limit', '-1');
- // raw TPB file
- $tpb_file = "complete";
- // mySQL config ------------------------------
- $mysql_host = "HOST";
- $mysql_user = "USER";
- $mysql_password = "PASSWORD";
- $mysql_database = "DATABASE";
- // CREATE THE TABLE BEFORE START THAT SCRIPT!
- $mysql_table = "tpb"; //dafault
- /* create the new table
- $query = "CREATE TABLE `my_onlinemanga`.`tpb` (
- `ID` DOUBLE NOT NULL ,
- `name` TEXT NOT NULL ,
- `size` DOUBLE NOT NULL ,
- `seeders` INT NOT NULL ,
- `leechers` INT NOT NULL ,
- `magnet` TEXT NOT NULL
- )";
- */
- // ------------------------------------------
- // ----------------------------------------------------------------
- // Connecting, selecting database
- $link = mysql_connect($mysql_host, $mysql_user, $mysql_password)
- or die('Could not connect: ' . mysql_error());
- echo 'Connected successfully to MySQL';
- mysql_select_db($mysql_database) or die('Could not select database');
- // Performing SQL query
- $query = "SELECT * FROM $mysql_table";
- $result = mysql_query($query) or die('Query failed: ' . mysql_error());
- // read file into array
- $file_array = file($tpb_file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
- $file_row_num = count($file_array);
- // start with code manipulation--------
- for($i=0; $i < $file_row_num; $i++){
- $original = $file_array[$i];
- // string lengh -1
- $len = strlen($original);
- $tpbid = substr($original, 0, 7); // TPD ID for database
- $original = substr($original, 8, $len); // eliminate ID
- $reverse = strrev($original); //reverse the string for check '|'
- $pos = strpos($reverse, '|'); // last '|' [reversed]
- $magnetlink = substr($reverse, 0, $pos); // magnet link [reversed]
- $magnetlink = strrev($magnetlink); // MAGNET LINK for database
- $len = strlen($reverse);
- $reverse = substr($reverse, $pos + 1, $len);
- $pos = strpos($reverse, '|'); // last '|' [reversed]
- $leechers = substr($reverse, 0, $pos); // leechers [reversed]
- $leechers = strrev($leechers); // LEECHERS for database
- $len = strlen($reverse);
- $reverse = substr($reverse, $pos + 1, $len);
- $pos = strpos($reverse, '|'); // last '|' [reversed]
- $seeders = substr($reverse, 0, $pos); // seeders [reversed]
- $seeders = strrev($seeders); // SEEDERS for database
- $len = strlen($reverse);
- $reverse = substr($reverse, $pos + 1, $len);
- $pos = strpos($reverse, '|'); // last '|' [reversed]
- $size = substr($reverse, 0, $pos); // size [reversed]
- $size = strrev($size); // SIZE for database
- $len = strlen($reverse);
- $name = substr($reverse, $pos + 1, $len); //name [reversed]
- $name = strrev($name); // NAME for database
- // test
- // echo ("ID: $tpbid\nName: $name\nSize: $size\nSeed: $seeders\nLeech: $leechers\nMagnet link: $magnet_header$magnetlink\n\n");
- // insert to sql
- $query = "INSERT INTO tpb VALUES ('$tpbid','$name','$size','$seeders','$leechers','$magnetlink')";
- $result = mysql_query($query) or die('Query failed: ' . mysql_error());
- }
- // Closing connection
- mysql_close($link);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement