I just need a place to discuss with mike about converting something and give examples.
Don't mind this thread
Something like this
i r just bought renegade|^||^|open|^|10|^|74-1013713906|^|1019980847|^|77-1021795865|^|1021980640|^|0|^|JFK|^|Michael-Corleone|^|0|^|0|^|60|^|12|^|1|^|1|^|0|^|
Needs to be changed into something like this:
INSERT INTO `ibf_topics` ( `tid` , `title` , `description` , `state` , `posts` , `starter_id` , `start_date` , `last_poster_id` , `last_post` , `icon_id` , `starter_name` , `last_poster_name` , `poll_state` , `last_vote` , `views` , `forum_id` , `approved` , `author_mode` , `pinned` , `moved_to` , `rating` , `total_votes` )
VALUES (
'', 'i r just bought renegade', NULL , NULL , NULL , '0', '1019980847', '0', '1021980640', NULL , 'JFK', 'Michael-Corleone', NULL , NULL , '0', '0', '0', NULL , '0', NULL , NULL , '0'
);
See where the data is placed? Theres a lot more instances that need to be converted in a single text file though. Everything else is junk that isn't needed and can be discarded.