<?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);
?>