[VBDev]

Originally Posted by kronnos

There seems to be an error when trying to import from Dream Chat. It always stops at the same chat 12000~ish and gives the following sql error:

Database error in vBulletin 3.8.1:

Invalid SQL:

INSERT INTO bl_mgc_cb_evo_chat
SET
dateline='1203541396',
fromuid='738',
touid='0',
name='96'Blaster240',
ctext='my blaster just got spark! ',
chanid='0',
userip='95.272.104.81',
coidentifier='0';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Blaster240',
ctext='my blaster just got spark! ',
chanid='0',
' at line 6
Error Number : 1064
Request Date : Tuesday, February 17th 2009 @ 04:26:17 PM
Error Date : Tuesday, February 17th 2009 @ 04:26:18 PM
Script : http://mystite/admincp/mgc_cb_evo.ph...=10500&teamid=
Referrer : http://mysite/admincp/mgc_cb_evo.php...=10400&teamid=
IP Address : 95.132.221.101
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-community

Well yeah my fault, here is a fix for all the imports :

Search for :

name='" . $cchatbox_chats['username'] . "',

Replace it by :

name='" . $vbulletin->db->escape_string($cchatbox_chats['username']) . "',

Search for :

name='" . $dream_chats['username'] . "',

Replace it by :

name='" . $vbulletin->db->escape_string($dream_chats['username']) . "',

Search for :

name='" . $diondev_chats['username'] . "',

Replace it by :

name='" . $vbulletin->db->escape_string($diondev_chats['username']) . "',