This update fixes repost/quote UI and referral code registration logic, strengthens points system and payment security with database locking and wallet validation, optimizes follow queries for better performance, and adds unique index on post codes to ensure data integrity.
Hey Pickful community!
We've made a series of important updates to the Pickful platform to provide a more stable and secure user experience.
✨ UI Improvements
IMG_5360.jpeg221.2 KB
Repost & Quote Features
Fixed vertical alignment of repost icon to match like and comment icons
Improved quote modal layout with dark mode support
Replaced blocking success modal with lightweight toast notification
Notification Cards
Fixed notification card display issues in dark mode
🔐 Security Enhancements
Admin Permission System Upgrade
Migrated admin authentication from hardcoded IDs to database field management
Points System Transaction Safety
Implemented database locking mechanism for points operations to prevent race conditions
Payment Verification Strengthened
Added wallet address format validation for VIP payment flow
Improved error handling for better system stability
Push Notification Security
Migrated VAPID keys to secure credentials storage
⚡ Performance Optimization
Query Efficiency
Optimized user follow relationship queries, significantly reducing database load
Improved feed loading speed for better browsing experience
Data Write Optimization
Optimized post content sync mechanism to reduce unnecessary database writes
Points changes now execute after transaction commit to ensure data consistency
🛠 Bug Fixes
Registration Flow
Fixed referral code logic to distinguish between "referrer's code" and "user's own code"
Made referral code validation optional for smoother registration
Draft Feature
Fixed draft list display issue
Added parameter validation for draft auto-save
🗃 Data Integrity
Added unique index on post short codes to prevent collision in edge cases
Added idempotency check for registration bonus to prevent duplicate rewards
Thank you for using Pickful! If you have any questions, please don't hesitate to contact us. #product
回复