chamilo / chamilo-lms

                $group_table = Database::get_course_table(TABLE_GROUP);

                $sql = "SELECT * FROM $group_table WHERE c_id = " . $_course['real_id'] . " AND id = '$group_id'";

                $result = Database::query($sql);

                if (Database::num_rows($result) > 0) { // This group has recorded status related to this course

                    $gpData = Database::fetch_array($result);

                    $_gid = $gpData ['id'];

                    Session::write('_gid', $_gid);

                } else {

                    Session::erase('_gid');

                }

            } elseif (isset($_SESSION['_gid']) or isset($_gid)) { // Keys missing => not anymore in the group - course relation

                Session::erase('_gid');

            }

		$result = Database::query($sql);

		// We will create an array of days on which there are posts.

		if( Database::num_rows($result) > 0) {

			while($blog_post = Database::fetch_array($result)) {

				// If the day of this post is not yet in the array, add it.

				if (!in_array($blog_post['post_day'], $posts))

					$posts[] = $blog_post['post_day'];

			}

		}

		// Get tasks for this month

		if ($_user['user_id']) {

                                WHERE login_user_id = '".$_user['user_id']."'

                                ORDER BY login_date DESC LIMIT 1";

        $result_last_login = Database::query($sql_last_login);

        if (!$result_last_login) {

            if (Database::num_rows($result_last_login) > 0) {

                $user_last_login_datetime = Database::fetch_array($result_last_login);

                $user_last_login_datetime = $user_last_login_datetime[0];

                Session::write('user_last_login_datetime',$user_last_login_datetime);

            }

        }

        //Event::event_login();

    }

    // End login -- if ($_POST['submitAuth'])

        }

        $result = Database::query($sql);

        if (Database::num_rows($result) > 0) {

            while ($row = Database::fetch_array($result)) {

                $sql = "DELETE FROM $userRelUserTable 

                        WHERE 

                          user_id = {$row['user_id']} AND 

                          friend_user_id = $userId AND 

                          relation_type = $relationType";

                Database::query($sql);

            }

        }

        if ($deleteUsersBeforeInsert) {

            $sql = "DELETE FROM $userRelUserTable