PDA

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