View Single Post
  #469  
Old 10-14-2006, 03:30 AM
OrangeFlea OrangeFlea is offline
 
Join Date: Aug 2004
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by amykhar
my code is so totally different that I can't begin to tell you what line or even what function to look for. But, to fix your apostrophe problems, all you have to do is use trim and addslashes on any text input that's going to be put in the database. Find where the quiz name or title variable is. Before it goes into the database, do something like this (appropriate variables of course)
Code:
$title = $trim(addslashesa($title));
Do the same thing for the questions, descriptions and the options - ANY text that's going to be inserted in the database.
Code:
	$to             = $DB->query_first("select username, userid from ".TABLE_PREFIX."user where userid='{$to}'");
	$DataManager_PM =& datamanager_init('PM', $vbulletin, ERRTYPE_ARRAY); 
	$DataManager_PM->set('fromuserid', $to['userid']); 
	$DataManager_PM->set('fromusername', $to['username']); 
	$DataManager_PM->set('title', $title = trim(addslashes($title)); 
	$DataManager_PM->set('message', $message = trim(addslashes($message)); 
	$DataManager_PM->set_recipients($to['username'],$to['permissions']); 
	$DataManager_PM->set('dateline', TIMENOW); 
	$DataManager_PM->save();
	}
Thanks for the assist, Amy. I did as you have said but I get a syntax error. Is this right?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01304 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete