BadgerBOT mis-returning quotes

[FauxFaux]

See this conversation in PM:
{{{
13:31:37 Laurence|Tov >> getquote 3812
13:31:37 BadgerBOT >> zx64|HoG: What are you doing here? One at a time we agreed!
13:31:37 BadgerBOT >> zx64|HoG: Just get out of here before the space-time continuum notices.
}}}
{{{
13:31:48 Laurence|Tov >> getquote 3812
13:31:50 BadgerBOT >> zx64|HoG: What are you doing here? One at a time we agreed!
13:31:50 BadgerBOT >> zx64|HoG: Just get out of here before the space-time continuum notices.
}}}
{{{
13:32:01 Laurence|Tov >> jb getquote 3812
13:32:02 BadgerBOT >> <zx64|HoG> It's my turn bitch
13:32:03 BadgerBOT >> zx64|HoG: Just get out of here before the space-time continuum notices.
13:32:03 BadgerBOT >> zx64|HoG: What are you doing here? One at a time we agreed!
}}}
{{{
13:32:06 Laurence|Tov >> jb getquote 3812
13:32:08 BadgerBOT >> zx64|HoG: What are you doing here? One at a time we agreed!
13:32:08 BadgerBOT >> <zx64|HoG> It's my turn bitch
13:32:08 BadgerBOT >> zx64|HoG: Just get out of here before the space-time continuum notices.
}}}

The last one of the JB requests is correct quote. (JB's mis-return of the quote is due to bug #182 (passthru.send returns messages in the wrong order)). For some reason BadgerBOT is leaving out an entire line in the quote.

[FauxFaux]

Author: faux
Cleanup the desc.

[FauxFaux]

Author: faux
And, this doesn't appear to be a bug with the bot, the line is missing from the database (despite the fact that the line-numbers agree there should be an extra line):

{{{
id quoteid line nick text action?
5063 3812 1 zx64 zx64|HoG: What are you doing here? One at a time w... 0
5065 3812 3 zx64 zx64|HoG: Just get out of here before the space-ti... 0
}}}

The line that'd be expected to be the middle line is:
{{{
5064 0 0 0
}}}

Transition error?

[FauxFaux]

Author: faux
By the wonders of SQL HAX, it has been determined that (at least) 3132, 3812, 3775 and 6949 have been mis-copied, and there are 14 "corrupt" lines (ie. with a quoteid of 0).

For reference:
{{{
SELECT quoteid,count(linenumber)-max(linenumber) as diff FROM _objectdb_plugins_quote_quoteline where quoteid < 9536 GROUP BY quoteid having diff!=0; SELECT quoteid,count(linenumber)-max(linenumber) as diff FROM _objectdb_plugins_quote_quoteline where quoteid >= 9536 GROUP BY quoteid having diff!=1;
}}}

[FauxFaux]

Author: faux
It seems that all the quotes that have been mis-copied are invalid, ie. contain |s.

Are we going to allow such evilness?

[FauxFaux]

Author: silver
Having a | in the nick is not invalid. It actually makes some of the older quotes ''work''.

[FauxFaux]

Ticket imported from Trac:
http://trac.uwcs.co.uk/choob/ticket/246