o ·ôjj ã@sddlZGdd„dƒZdS)éNc@sXeZdZdejfdd„Zdefdd„Zdd„Zdd ed e fd d „Z ddd„Z dd„Z dS)Ú PointsManagerÚconncCs||_| ¡|_dS)N)rÚcursorÚcur)Úselfr©rú+/home/dore/onebot/Bot_Ero/core/db/points.pyÚ__init__szPointsManager.__init__ÚreturncCs:|j d|f¡|j ¡}|r|dS|j d|f¡dS)NzR SELECT points FROM user_assets WHERE user_id = ? rze INSERT INTO user_assets (user_id, points) VALUES (?, 0) )rÚexecuteÚfetchone)rÚuser_idÚrowrrrÚget sý ýzPointsManager.getcCs |j d||f¡|j ¡dS)NzŸ INSERT INTO user_assets (user_id, points) VALUES (?, ?) ON CONFLICT(user_id) DO UPDATE SET points=excluded.points )rr rÚcommit)rr ÚvaluerrrÚsetsüzPointsManager.setTÚdeltarcCsHt|ƒ}t|ƒ}|j d|f¡|j d||f¡|r"|j ¡dSdS)Nzc INSERT OR IGNORE INTO user_assets (user_id, points) VALUES (?, 0) z^ UPDATE user_assets SET points = points + ? WHERE user_id = ? )ÚstrÚintrr rr)rr rrrrrÚadjust sýýÿzPointsManager.adjusté cCs|j d|f¡|j ¡S)Nzœ SELECT user_id, points FROM user_assets ORDER BY points DESC, CAST(user_id AS INTEGER) ASC LIMIT ? )rr Úfetchall)rÚlimitrrrÚ leaderboard.sû zPointsManager.leaderboardcCsZt|ƒ}|j d¡dd„|j ¡Dƒ}|D] }|j dt|ƒ|f¡q|j ¡t|ƒS)Naë SELECT DISTINCT user_id FROM user_assets UNION SELECT DISTINCT CAST(user_id AS TEXT) FROM checkin_records UNION SELECT DISTINCT CAST(user_id AS TEXT) FROM user_titles UNION SELECT DISTINCT user_id FROM user_title_state UNION SELECT DISTINCT user_id FROM user_equipped_titles UNION SELECT DISTINCT CAST(user_id AS TEXT) FROM group_daily_message_stats cSs g|] }|ddur|d‘qS)rNr)Ú.0rrrrÚ Fs z+PointsManager.grant_all..zº INSERT INTO user_assets (user_id, points) VALUES (?, ?) ON CONFLICT(user_id) DO UPDATE SET points = points + excluded.points )rrr rrrrÚlen)rÚamountÚuser_idsÚuidrrrÚ grant_all7s   ü zPointsManager.grant_allN)T)r) Ú__name__Ú __module__Ú __qualname__Úsqlite3Ú Connectionr rrrÚboolrrr!rrrrrs  r)r%rrrrrÚs