View Full Version : whats wrong with this line
neutek
01-26-2006, 05:30 AM
$DB->query("
INSERT INTO `irc_channel`
(handle, server, icon, nick_style, act0, act1, act2, act3, act4, act5)
VALUES
('" . addslashes($channel['handle']) . "', '" . addslashes($channel['server']) . "',
'" . addslashes($channel['icon']) . "', '" . addslashes($channel['nickstyle']) . "',
'" . addslashes($channel['act0']) . "', '" . addslashes($channel['act1']) . "',
'" . addslashes($channel['act2']) . "', '" . addslashes($channel['act3']) . "',
'" . addslashes($channel['act4']) . "', '" . addslashes($channel['act5']) . "')
");
harmor19
01-26-2006, 12:10 PM
What version of vbulletin are you using?
If it's 3.5.x then do
$db->query_write("
INSERT INTO `irc_channel`
(handle, server, icon, nick_style, act0, act1, act2, act3, act4, act5)
VALUES
('" . addslashes($channel['handle']) . "', '" . addslashes($channel['server']) . "',
'" . addslashes($channel['icon']) . "', '" . addslashes($channel['nickstyle']) . "',
'" . addslashes($channel['act0']) . "', '" . addslashes($channel['act1']) . "',
'" . addslashes($channel['act2']) . "', '" . addslashes($channel['act3']) . "',
'" . addslashes($channel['act4']) . "', '" . addslashes($channel['act5']) . "')
");
For 3.0.x try
$DB_site->query("
INSERT INTO `irc_channel`
(handle, server, icon, nick_style, act0, act1, act2, act3, act4, act5)
VALUES
('" . addslashes($channel['handle']) . "', '" . addslashes($channel['server']) . "',
'" . addslashes($channel['icon']) . "', '" . addslashes($channel['nickstyle']) . "',
'" . addslashes($channel['act0']) . "', '" . addslashes($channel['act1']) . "',
'" . addslashes($channel['act2']) . "', '" . addslashes($channel['act3']) . "',
'" . addslashes($channel['act4']) . "', '" . addslashes($channel['act5']) . "')
");
neutek
01-26-2006, 05:11 PM
its 3.5.2
thanks.. that worked.. now this line?
while ($channel = $DB->fetch_array($channels))
{
$nick_style = explode('||', $channel['nick_style']);
$ops = explode(' ', $channel['operators']);
$halfops = explode(' ', $channel['halfops']);
$voiced = explode(' ', $channel['voiced']);
$users = explode(' ', $channel['users']);
Guest190829
01-26-2006, 05:49 PM
Just a note:
For 3.5, $db->escape_string() Is used instead of addslashes().
What version of vbulletin are you using?
If it's 3.5.x then do
$db->query_write("
INSERT INTO `irc_channel`
(handle, server, icon, nick_style, act0, act1, act2, act3, act4, act5)
VALUES
('" . addslashes($channel['handle']) . "', '" . addslashes($channel['server']) . "',
'" . addslashes($channel['icon']) . "', '" . addslashes($channel['nickstyle']) . "',
'" . addslashes($channel['act0']) . "', '" . addslashes($channel['act1']) . "',
'" . addslashes($channel['act2']) . "', '" . addslashes($channel['act3']) . "',
'" . addslashes($channel['act4']) . "', '" . addslashes($channel['act5']) . "')
");
For 3.0.x try
$DB_site->query("
INSERT INTO `irc_channel`
(handle, server, icon, nick_style, act0, act1, act2, act3, act4, act5)
VALUES
('" . addslashes($channel['handle']) . "', '" . addslashes($channel['server']) . "',
'" . addslashes($channel['icon']) . "', '" . addslashes($channel['nickstyle']) . "',
'" . addslashes($channel['act0']) . "', '" . addslashes($channel['act1']) . "',
'" . addslashes($channel['act2']) . "', '" . addslashes($channel['act3']) . "',
'" . addslashes($channel['act4']) . "', '" . addslashes($channel['act5']) . "')
");
neutek
01-26-2006, 06:37 PM
nevermind :)
thanks alot i got it
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.