module_groups.php

来自「ATutor是一个学习管理系统(LCMS/LMS), 为教师和学生建立一个网络教」· PHP 代码 · 共 31 行

<?php

// create group
function forums_create_group($group_id) {
	global $db;

	$sql	= "INSERT INTO ".TABLE_PREFIX."forums VALUES (NULL,'', '', 0, 0, NOW(), 0)";
	$result = mysql_query($sql,$db);

	$sql	= "INSERT INTO ".TABLE_PREFIX."forums_groups VALUES (LAST_INSERT_ID(),  $group_id)";
	$result = mysql_query($sql,$db);
}


// delete group
function forums_delete_group($group_id) {
	global $db;

	require_once(AT_INCLUDE_PATH . 'lib/forums.inc.php');

	$sql = "SELECT forum_id FROM ".TABLE_PREFIX."forums_groups WHERE group_id=$group_id";
	$result = mysql_query($sql, $db);
	while ($row = mysql_fetch_assoc($result)) {
		delete_forum($row['forum_id']);
	}

	$sql = "DELETE FROM ".TABLE_PREFIX."forums_groups WHERE group_id=$group_id";
	$result = mysql_query($sql, $db);
}

?>