← All changes | functions.php +12 -14 8.6.0 → 8.3.8 View file →

		@@ -65,9 +65,9 @@
65	65	?>
66	66	<style>
67	67	<?php if(get_option('wp_chatbot_custom_css')!="") {
68	68
69		- echo wp_strip_all_tags( get_option('wp_chatbot_custom_css') );// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
	69	+ echo wp_strip_all_tags( get_option('wp_chatbot_custom_css') );
70	70	}
71	71	?>
72	72	</style>
73	73
		@@ -1592,9 +1592,9 @@
1592	1592
1593	1593	if(class_exists('Qcformbuilder_Forms_Admin')){
1594	1594
1595	1595
1596		- $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM ". $wpdb->prefix."wfb_forms WHERE type= %s",'primary')); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	1596	+ $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM ". $wpdb->prefix."wfb_forms WHERE type= %s",'primary')); //DB Call OK, No Caching OK
1597	1597
1598	1598	if(!empty($results)){
1599	1599
1600	1600	foreach($results as $result){
		@@ -1762,22 +1762,22 @@
1762	1762	$tableuser = $wpdb->prefix.'wpbot_sessions';
1763	1763	$response = array();
1764	1764
1765	1765
1766		- $session_exists = $wpdb->get_row($wpdb->prepare("select * from {$tableuser} where 1 and id = %d",1)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter
	1766	+ $session_exists = $wpdb->get_row($wpdb->prepare("select * from $tableuser where 1 and id = %d",1)); //DB Call OK, No Caching OK
1767	1767
1768	1768	if(empty($session_exists)){
1769		- $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
	1769	+ $wpdb->insert(
1770	1770	$tableuser,
1771	1771	array(
1772	1772	'session' => 1,
1773	1773	)
1774		- );
	1774	+ ); //DB Call OK, No Caching OK
1775	1775	}else{
1776	1776
1777	1777	$session_id = $session_exists->id;
1778	1778
1779		- $wpdb->update( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	1779	+ $wpdb->update(
1780	1780	$tableuser,
1781	1781	array(
1782	1782	'session'=>($session_exists->session+1),
1783	1783	),
		@@ -1785,9 +1785,9 @@
1785	1785	array(
1786	1786	'%d',
1787	1787	),
1788	1788	array('%d')
1789		- );
	1789	+ ); //DB Call OK, No Caching OK
1790	1790
1791	1791	}
1792	1792
1793	1793	wp_send_json($response);
		@@ -1795,9 +1795,9 @@
1795	1795
1796	1796	/* WPBot Chat History Addon check */
1797	1797	function qcld_wpbot_is_active_chat_history(){
1798	1798
1799		- if(function_exists('qcwp_chat_session_menu_fnc') || function_exists('qcwp_chat_session_menu_fnc_free') || function_exists( 'qcpdcs_chat_session_menu_fnc' ) ){
	1799	+ if(function_exists('qcwp_chat_session_menu_fnc') || function_exists( 'qcpdcs_chat_session_menu_fnc' ) ){
1800	1800	return 1;
1801	1801	}else{
1802	1802	return 0;
1803	1803	}
		@@ -1823,10 +1823,9 @@
1823	1823	$csvFile = file(QCLD_wpCHATBOT_PLUGIN_DIR_PATH . 'small_talk.csv');
1824	1824
1825	1825	foreach ($csvFile as $line) {
1826	1826	$line = str_getcsv($line, ',', '"');
1827		- $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
1828		- $table, array(
	1827	+ $wpdb->insert($table, array(
1829	1828	'query' => $line[0],
1830	1829	'keyword' => $line[1],
1831	1830	'response' => $line[2],
1832	1831	'category'=> $line[3],
		@@ -1831,17 +1830,16 @@
1831	1830	'response' => $line[2],
1832	1831	'category'=> $line[3],
1833	1832	'intent'=> '',
1834	1833	//'lang'=> 'en_US',
1835		- ));
	1834	+ )); //DB Call OK, No Caching OK
1836	1835	}
1837	1836
1838	1837	$table2 = $wpdb->prefix.'wpbot_response_category';
1839	1838
1840		- $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
1841		- $table2, array(
	1839	+ $wpdb->insert($table2, array(
1842	1840	'name' => 'smalltalk',
1843		- ));
	1841	+ )); //DB Call OK, No Caching OK
1844	1842
1845	1843	update_option( 'qcld_small_talk_imported', 'yes' );
1846	1844
1847	1845	}