Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page whats wrong with this line
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2006, 05:30 AM
neutek neutek is offline
 
Join Date: Mar 2003
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default whats wrong with this line
$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']) . "')
");
Reply With Quote
  #2  
Old 01-26-2006, 12:10 PM
harmor19 harmor19 is offline
 
Join Date: Apr 2005
Posts: 1,324
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
What version of vbulletin are you using?

If it's 3.5.x then do

PHP Code:
$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
PHP Code:
$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']) . "')
"); 
Reply With Quote
  #3  
Old 01-26-2006, 05:11 PM
neutek neutek is offline
 
Join Date: Mar 2003
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
its 3.5.2
thanks.. that worked.. now this line?
Code:
			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']);
Reply With Quote
  #4  
Old 01-26-2006, 05:49 PM
Guest190829
Guest
  
Posts: n/a
Default
Just a note:

For 3.5,
PHP Code:
 $db->escape_string() 
Is used instead of addslashes().

Quote:
Originally Posted by harmor19
What version of vbulletin are you using?

If it's 3.5.x then do

PHP Code:
$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
PHP Code:
$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']) . "')
"); 
Reply With Quote
  #5  
Old 01-26-2006, 06:37 PM
neutek neutek is offline
 
Join Date: Mar 2003
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
nevermind
thanks alot i got it
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 07:54 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.09240 seconds
  • Memory Usage 2,243KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (5)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (4)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete