Wysiwyg

[PaulSonny]

Hello Everyone,

I'm trying to get text from the WYSIWYG and place it in a database field. I have got all the other information to store like username and userid but I cant get the message to store.

$message = $vbulletin->input->clean_gpc('WYSIWYG_HTML', 'message', TYPE_STR);
	if (isset($WYSIWYG_HTML))
	{
		require_once('./includes/functions_wysiwyg.php');
		$message = convert_wysiwyg_html_to_bbcode($WYSIWYG_HTML, $vboptions['allowhtml']);
	}
	else
	{
		$message = trim($message);
	}
	$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX ."helpcenter_ticket(title, departmentid, postusername, 
	postuserid, lastposter, lastupdate, dateline) VALUES ('" . addslashes(htmlspecialchars_uni($_REQUEST['title'])) . "',
	'" . intval($_REQUEST['departmentid']) . "','" . addslashes($vbulletin->userinfo['username']) . "',
	'" . intval($vbulletin->userinfo['userid']) . "','" . addslashes($vbulletin->userinfo['username']) . "'," . TIMENOW . ",
	" . TIMENOW . ")");
	$ticketid = $vbulletin->db->insert_id();
	$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "helpcenter_ticketreply(ticketid, username, userid, 
	dateline, pagetext, ipaddress) VALUES (" . intval($ticketid) . ",'" . addslashes($vbulletin->userinfo['username']) . "',
	" . intval($vbulletin->userinfo[userid]) . "," . TIMENOW . ",'" . addslashes($message) . "',	'" . addslashes(IPADDRESS) . "'
	)");

Can anyone see anything wrong?

Thanks, Paul.

[Dismounted]

You are using the clean_gpc() function wrong.

mixed &clean_gpc (array $source, string $varname, [integer $vartype = TYPE_NOCLEAN])

[PaulSonny]

Still not working, and I dont know what i'm doing wrong. All the other information goes into the DB but not the contents of the message box.

if ($_REQUEST['do'] == 'submitnewticket'){
	$vbulletin->input->clean_array_gpc('r', array('message' => TYPE_STR));
	$message = $vbulletin->GPC['message'];
	if (isset($WYSIWYG_HTML))
	{
		require_once('./includes/functions_wysiwyg.php');
		$message = convert_wysiwyg_html_to_bbcode($WYSIWYG_HTML, $vboptions['allowhtml']);
	}
	else
	{
		$message = trim($message);
	}
	$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX ."helpcenter_ticket(title, departmentid, postusername, 
	postuserid, lastposter, lastupdate, dateline) VALUES ('" . addslashes(htmlspecialchars_uni($_REQUEST['title'])) . "',
	'" . intval($_REQUEST['departmentid']) . "','" . addslashes($vbulletin->userinfo['username']) . "',
	'" . intval($vbulletin->userinfo['userid']) . "','" . addslashes($vbulletin->userinfo['username']) . "'," . TIMENOW . ",
	" . TIMENOW . ")");
	$ticketid = $vbulletin->db->insert_id();
	$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "helpcenter_ticketreply(ticketid, username, userid, 
	dateline, pagetext, ipaddress) VALUES (" . intval($ticketid) . ",'" . addslashes($vbulletin->userinfo['username']) . "',
	" . intval($vbulletin->userinfo['userid']) . "," . TIMENOW . ",'" . addslashes($message) . "',	'" . addslashes(IPADDRESS) . "'
	)");
	//Insert AutoResponse Mail Here
	$vbulletin->url = "helpcenter.php?$session[sessionurl]do=ticket&tid=".$ticketid;
	eval(print_standard_redirect('redirect_postthanks'));
}

Thanks, Paul.

[Marco van Herwaarden]

PHP Code:

$vbulletin->input->clean_array_gpc('r', array('message' => TYPE_STR)); 


Not sure, but i think this is a post variable, so:

PHP Code:

$vbulletin->input->clean_array_gpc('p', array('message' => TYPE_STR)); 


[PaulSonny]

Nope still not storing in the database. Starting to drive me insane lol.

Thanks, Paul.

[Dismounted]

Check that the variable actually has something in it...

[PaulSonny]

globalize($_POST, array('WYSIWYG_HTML', 'message' => STR));

How can I convert this line?

Thanks, Paul.