} else { //if rollback, I should change the default checked radio button //find userid $target_user = $db->get_row("SELECT user_id FROM colfusion_users WHERE user_login = '******'"); $target_user_id = $target_user->user_id; //echo $target_user_id; $sql_update = "UPDATE wiki_history "; $sql_update .= "SET checked = true "; $sql_update .= "WHERE sid = {$link_id} and field = 'tags' and timestamp = '{$modified_date}' and user_id = {$target_user_id} "; $db->query($sql_update); } } } //added by Jason $notificationDAO = new NotificationDAO(); $notificationDAO->addEditNTFtoDB($link_id); //echo $str."<br/>"; /* error_reporting(E_ALL ^ E_DEPRECATED); $con = mysql_connect($servername,$username,$password); if (!$con){ die('Could not connect: ' . mysql_error()); //echo 'fail to connect'; } else { mysql_select_db($database,$con); $sql_select = " SELECT content FROM description WHERE id=(SELECT MAX(id) FROM description)"; if (!mysql_query($sql_select,$con)) { die('Error: ' . mysql_error());
function addEditNTFtoDB() { $notificationDAO = new NotificationDAO(); $link_id = $_GET["link_id"]; echo $notificationDAO->addEditNTFtoDB($link_id); }