Just so you get an idea of what I'm dealing with, here's an example you might wish to peruse: There are about 30 pages of this stuff which you have to correct every error (ignore the smileys, this will pick up any keystroke sequence that correspondes to a smiley.


-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- Host: db550.oneandone.co.uk
-- Generation Time: Aug 17, 2006 at 10:36 PM
-- Server version: 5.0.24
-- PHP Version: 4.3.10-200.schlund.1
--
-- Database: `db157796827`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpbb_topics`
--

CREATE TABLE `phpbb_topics` (
`topic_id` mediumint(8) unsigned NOT NULL auto_increment,
`forum_id` smallint(8) unsigned NOT NULL,
`topic_title` char(60) collate latin1_german2_ci NOT NULL,
`topic_poster` mediumint(8) NOT NULL,
`topic_time` int(11) NOT NULL,
`topic_views` mediumint(8) unsigned NOT NULL,
`topic_replies` mediumint(8) unsigned NOT NULL,
`topic_status` tinyint(3) NOT NULL,
`topic_vote` tinyint(1) NOT NULL,
`topic_type` tinyint(3) NOT NULL,
`topic_first_post_id` mediumint(8) unsigned NOT NULL,
`topic_last_post_id` mediumint(8) unsigned NOT NULL,
`topic_moved_id` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_moved_id` (`topic_moved_id`),
KEY `topic_status` (`topic_status`),
KEY `topic_type` (`topic_type`)
) ENGINE=MyISAM AUTO_INCREMENT=3008 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=3008 ;

--
-- Dumping data for table `phpbb_topics`
--

INSERT INTO `phpbb_topics` VALUES (2, 2, 'The Bunker', 2, 1141008194, 202, 6, 0, 0, 0, 2, 191, 0);
INSERT INTO `phpbb_topics` VALUES (3, 2, 'Lets Get this Party Started', 3, 1141022885, 115, 2, 0, 0, 0, 3, 137, 0);
INSERT INTO `phpbb_topics` VALUES (4, 2, 'Morning everyone.', 7, 1141029175, 92, 0, 0, 0, 0, 12, 12, 0);
INSERT INTO `phpbb_topics` VALUES (5, 2, 'nomads', 8, 1141029497, 68, 2, 0, 0, 0, 8, 11, 0);
INSERT INTO `phpbb_topics` VALUES (6, 2, 'nudge nudge', 8, 1141030725, 92, 3, 0, 0, 0, 13, 26, 0);
INSERT INTO `phpbb_topics` VALUES (7, 2, 'Avatar', 11, 1141031038, 185, 10, 0, 0, 0, 16, 334, 0);
INSERT INTO `phpbb_topics` VALUES (8, 2, 'win a player', 8, 1141031199, 2820, 47, 0, 0, 0, 19, 12961, 0);
INSERT INTO `phpbb_topics` VALUES (9, 12, 'Quick vote...', 10, 1141031340, 60, 7, 0, 1, 0, 20, 30, 0);
INSERT INTO `phpbb_topics` VALUES (10, 2, 'begining', 8, 1141031355, 48, 0, 0, 0, 0, 21, 21, 0);
INSERT INTO `phpbb_topics` VALUES (11, 2, 'The new Pools Bar', 12, 1141032930, 334, 11, 0, 0, 0, 31, 13883, 0);
INSERT INTO `phpbb_topics` VALUES (12, 2, 'Guess Who?', 10, 1141034294, 171, 3, 0, 0, 0, 32, 30588, 0);
INSERT INTO `phpbb_topics` VALUES (76, 2, 'New boy', 45, 1141136690, 112, 7, 0, 0, 0, 306, 482, 0);
INSERT INTO `phpbb_topics` VALUES (14, 4, 'BIG WELL DONE', 10, 1141035460, 253, 1, 0, 0, 0, 35, 405, 0);
INSERT INTO `phpbb_topics` VALUES (15, 2, 'NEW MEMBERS', 10, 1141035900, 141, 1, 0, 0, 0, 38, 167, 0);
INSERT INTO `phpbb_topics` VALUES (16, 2, 'So This Is Our New Home!!!!', 17, 1141036236, 131, 4, 0, 0, 0, 39, 156, 0);
INSERT INTO `phpbb_topics` VALUES (17, 2, 'I''m here', 20, 1141036945, 99, 1, 0, 0, 0, 43, 53, 0);
INSERT INTO `phpbb_topics` VALUES (18, 2, 'SBF', 10, 1141037023, 105, 2, 0, 0, 0, 44, 140, 0);
INSERT INTO `phpbb_topics` VALUES (19, 2, 'How Do I Get My....', 17, 1141037402, 96, 5, 0, 0, 0, 45, 61, 0);
INSERT INTO `phpbb_topics` VALUES (20, 2, 'Greetings Pop Pickers!', 9, 1141038246, 106, 1, 0, 0, 0, 52, 7765, 0);
INSERT INTO `phpbb_topics` VALUES (75, 2, 'Ebay Item and message for Mr I', 14, 1141136422, 190, 20, 0, 0, 0, 305, 435, 0);
INSERT INTO `phpbb_topics` VALUES (22, 2, 'We''ve arrived!', 9, 1141039320, 82, 0, 0, 0, 0, 55, 55, 0);
INSERT INTO `phpbb_topics` VALUES (24, 2, 'I''m here too.....', 14, 1141040786, 59, 1, 0, 0, 0, 66, 69, 0);
INSERT INTO `phpbb_topics` VALUES (30, 2, 'Womens Thread', 3, 1141041624, 357, 11, 0, 0, 0, 78, 594, 0);
INSERT INTO `phpbb_topics` VALUES (26, 2, 'Avatars', 3, 1141040918, 85, 2, 0, 0, 0, 68, 98, 0);
INSERT INTO `phpbb_topics` VALUES (27, 2, 'Top Ten Posters', 3, 1141041338, 70, 0, 0, 0, 0, 73, 73, 0);
INSERT INTO `phpbb_topics` VALUES (31, 4, 'Mid-Summer Ball', -1, 1141043091, 764, 9, 0, 0, 0, 84, 2767, 0);
INSERT INTO `phpbb_topics` VALUES (29, 2, 'BUGS AND SUGGESTIONS', 2, 1141041395, 113, 7, 0, 0, 0, 75, 90, 0);
INSERT INTO `phpbb_topics` VALUES (121, 2, '5 Scunny things', 12, 1141382227, 139, 14, 0, 0, 0, 699, 764, 0);
INSERT INTO `phpbb_topics` VALUES (33, 2, 'Pst,Pst', 8, 1141045248, 104, 1, 0, 0, 0, 88, 89, 0);
INSERT INTO `phpbb_topics` VALUES (34, 2, 'SOAPS', -1, 1141047050, 103, 1, 0, 0, 0, 94, 177, 0);
INSERT INTO `phpbb_topics` VALUES (35, 2, 'WHY', 4, 1141047460, 123, 2, 0, 0, 0, 99, 188, 0);
INSERT INTO `phpbb_topics` VALUES (74, 12, 'Signature', 7, 1141135028, 124, 2, 0, 0, 0, 319, 739, 0);
INSERT INTO `phpbb_topics` VALUES (37, 6, 'To get us started...', 10, 1141049345, 211, 0, 0, 0, 0, 108, 108, 0);
INSERT INTO `phpbb_topics` VALUES (73, 4, 'A Quick Vote', 10, 1141130267, 392, 5, 0, 1, 1, 286, 322, 0);
INSERT INTO `phpbb_topics` VALUES (39, 6, 'Parentage', 10, 1141049662, 218, 0, 0, 0, 0, 110, 110, 0);
INSERT INTO `phpbb_topics` VALUES (40, 2, 'HOUSE RULES', 10, 1141050154, 255, 13, 0, 0, 0, 111, 1683, 0);
INSERT INTO `phpbb_topics` VALUES (41, 2, 'Violent Femmes', 18, 1141050595, 78, 1, 0, 0, 0, 116, 117, 0);
INSERT INTO `phpbb_topics` VALUES (42, 2, 'do u think', 28, 1141051606, 174, 4, 0, 0, 0, 121, 15492, 0);
INSERT INTO `phpbb_topics` VALUES (43, 2, 'Oi, You! C. Atweazle', 3, 1141053034, 45, 0, 0, 0, 0, 128, 128, 0);
INSERT INTO `phpbb_topics` VALUES (44, 6, 'Sombrero Song', 18, 1141053516, 291, 2, 0, 0, 0, 132, 214, 0);

Me too for most of today!

Self-explanatory isnt it?

what would Spock and Captain Kirk make of all this, eh??

John, I get the impression that you might have some knowledge of SQL and MYPHPADMIN. Wanna help ?

what use can I be? Shall I get the beer?? :D

PM 'en route.

I must say Mr I...i dont know how you got through all that in 18 hours

Well done like....labour of love and all that.

now then mr 3 quid!! Are you going to Mutley's wedding party bash on Saturday night ?

Errrr....i thought he'd been married?

he has - this is the Hartlepool version of the piss-up!!!!!!!!!

I put an invite up for everyone in the IS a few weeks ago!!!!

I'll put another up!!!! :D

post the details and I'll make it a sticky announcement.

Cheers Mr.I!!!! :D

I didn't get invited :cry:

You've only been amember since today anyways!! :lol:

That's not the point.

Can I have an invitation please?

A personal one asking me to come along?

What's the IS?

We never got the answer!

I was there.

I was completely trolleyed.

It was in the clippy club wasn't it?

And I seem to recall sitting with Mr & Mrs BP.

And according to Mrs R I threatened to slap some lad she used to go to school with in Church Square on the way home for talking to her.

A good night all in all.

Yes it was a good night, I even got up and danced, I think!!

What did you do when he stopped laughing?

Ran away and got Mrs R to call an ambulance probably. laughter and hyper-ventilation sound about the same....

I was that drunk I could barely stand up straight, however even when that drunk I still generally know not to shout my gob off to people the same size or bigger than me. I've learned that lesson the hard way in the past.

Do you remember who it was like Ripper, if I know them I will tell you if you could have taken him or not

Not a clue.

I barely recollect it never mind recall details like that!