diff --git a/ruoyi-admin/src/main/resources/mapper/system/SysActivityMapper.xml b/ruoyi-admin/src/main/resources/mapper/system/SysActivityMapper.xml
new file mode 100644
index 0000000..c09494d
--- /dev/null
+++ b/ruoyi-admin/src/main/resources/mapper/system/SysActivityMapper.xml
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ruoyi.authentication.mapper.SysActivityMapper">
+    <resultMap id="ActivityMap" type="com.ruoyi.authentication.domain.SysActivity">
+        <id property="activityId" column="activity_id"/>
+        <result property="activityName" column="activity_name"/>
+        <result property="rewardBonus" column="reward_bonus"/>
+        <result property="conditionValue" column="condition_value"/>
+        <result property="startTime" column="start_time"/>
+        <result property="endTime" column="end_time"/>
+        <result property="status" column="status"/>
+        <result property="activityType" column="activity_type"/>
+    </resultMap>
+
+    <resultMap id="LeaderboardMap" type="com.ruoyi.authentication.domain.SysActivity$LeaderboardEntry">
+        <result property="userId" column="user_id"/>
+        <result property="userName" column="user_name"/>
+        <result property="score" column="score"/>
+    </resultMap>
+
+    <select id="selectActivityList" resultMap="ActivityMap">
+        select activity_id, activity_name, reward_bonus, condition_value, start_time, end_time, status, activity_type
+        from activity
+        where 1=1
+        <if test="activityType != null and activityType != ''">and activity_type = #{activityType}</if>
+        <if test="status != null">and status = #{status}</if>
+    </select>
+
+    <select id="selectActivityById" resultMap="ActivityMap">
+        select activity_id, activity_name, reward_bonus, condition_value, start_time, end_time, status, activity_type
+        from activity
+        where activity_id = #{activityId}
+    </select>
+
+    <select id="selectLeaderboard" resultMap="LeaderboardMap">
+        select u.user_id, u.user_name, s.score
+        from sys_user u
+                 join user_score s on u.user_id = s.user_id
+        order by s.score desc
+            limit 100
+    </select>
+</mapper>
\ No newline at end of file
diff --git a/ruoyi-admin/src/main/resources/mapper/system/SysActivityRecordMapper.xml b/ruoyi-admin/src/main/resources/mapper/system/SysActivityRecordMapper.xml
new file mode 100644
index 0000000..f260cd1
--- /dev/null
+++ b/ruoyi-admin/src/main/resources/mapper/system/SysActivityRecordMapper.xml
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ruoyi.authentication.mapper.SysActivityRecordMapper">
+    <resultMap id="ActivityRecordMap" type="com.ruoyi.authentication.domain.SysActivityRecord">
+        <id property="recordId" column="record_id"/>
+        <result property="activityId" column="activity_id"/>
+        <result property="userId" column="user_id"/>
+        <result property="rewardBonus" column="reward_bonus"/>
+        <result property="completeTime" column="complete_time"/>
+    </resultMap>
+
+    <select id="checkParticipation" resultMap="ActivityRecordMap">
+        select record_id, activity_id, user_id, reward_bonus, complete_time
+        from activity_record
+        where activity_id = #{activityId} and user_id = #{userId}
+    </select>
+
+    <insert id="insertActivityRecord">
+        insert into activity_record (activity_id, user_id, reward_bonus, complete_time)
+        values (#{activityId}, #{userId}, #{rewardBonus}, sysdate())
+    </insert>
+
+    <select id="checkTorrentDownload" resultType="int">
+        select count(*) from torrent_download
+        where user_id = #{userId} and torrent_id = #{torrentId}
+    </select>
+</mapper>
\ No newline at end of file
diff --git a/ruoyi-admin/src/main/resources/mapper/system/SysUserInviteMapper.xml b/ruoyi-admin/src/main/resources/mapper/system/SysUserInviteMapper.xml
new file mode 100644
index 0000000..5059af0
--- /dev/null
+++ b/ruoyi-admin/src/main/resources/mapper/system/SysUserInviteMapper.xml
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ruoyi.system.mapper.SysUserInviteMapper">
+    <resultMap id="SysUserInviteMap" type="com.ruoyi.authentication.domain.SysUserInvite">
+        <id property="codeId" column="code_id"/>
+        <result property="code" column="code"/>
+        <result property="userId" column="user_id"/>
+    </resultMap>
+
+    <select id="selectInviteByUserId" resultMap="SysUserInviteMap">
+        select code_id, code, user_id
+        from invite_codes
+        where user_id = #{userId}
+    </select>
+
+    <select id="selectInviteByCode" resultMap="SysUserInviteMap">
+        select code_id, code, user_id
+        from invite_codes
+        where code = #{code}
+    </select>
+</mapper>
\ No newline at end of file