Admin: create/delete student also needs to hit 'current' table

[nwarmenh]

Whatever function is used in the admin section to add and delete students from the student_data table -- well, actually sets student_data.active to 0, not deletes them -- needs to also add/remove records for that student in the current table.

It's an open question for me about what to do with the history table when a student is deactivated (or activated).

[nwarmenh]

Here's a possibility:

function make_current($user_id) {
	$query = 'SELECT * FROM current WHERE student_id = '.$user_id;
	if (!$db->query($query)) {
	$query_insert = 'INSERT INTO current (student_id, status_id) VALUES ('.$user_id.', 0)';
	$db->query($query_insert);
	}
}

function remove_current($user_id) {
	$query = 'SELECT * FROM current WHERE student_id = '.$user_id;
	if ($db->query($query)) {
	$query_remove = 'DELETE FROM current WHERE student_id = '.$user_id;
	$db->query($query_remove);
	}
}