a %i%@sdZddlmZddlmZddlmZmZddlZddlZddl Z e e dddZ e ed d d Ze eed d d Ze e edddZe e edddZe ed ddZe eeddddZe eddddZe eeddddZdS)zy Tutorial State Tracking System Manages tutorial progress, onboarding completion, and tooltip tracking for new players. )datetime)get_database_connection)CallableOptionalN) tooltip_idreturncCsttd|S)z1Validate tooltip ID contains only safe charactersz^[a-zA-Z0-9_-]+$)boolrematch)rr 3/var/www/lichun.app/lichun/ws/retention/tutorial.pyvalidate_tooltip_idsr ) player_idrc Cst|tr|dkrdddSd}d}zHzt}|jdd}|d|f|}|rd|d t|d d WW|r|||r|S|d |f|t d |dddd WW|r||r|St yN}z^|r| t j d|d|dddt|dWYd}~W|r6||rD|Sd}~00W|r`||r|n|r~||r|0dS)z Initialize tutorial tracking for new player Returns: {'success': bool, 'tutorial_step': int, 'onboarding_complete': bool} rF+Invalid player_id: must be positive integersuccesserrorNT dictionary;SELECT * FROM player_tutorial_progress WHERE player_id = %s tutorial_steponboarding_complete)rrrzINSERT INTO player_tutorial_progress (player_id, tutorial_step, onboarding_complete, first_session_date, tooltips_seen) VALUES (%s, 0, FALSE, NOW(), '{}')z Initialized tutorial for player z'Error initializing tutorial for player : exc_info) isinstanceintrcursorexecutefetchonerclosecommitlogginginfo Exceptionrollbackrstr)rconnrexistinger r r initialize_tutorialsn     r*c Cszt|tr|dkr&td|dSd}d}z&zt}|jdd}|d|f|}|sWW|rp||r||dS|drt |dni}|dt |d |t |d d WW|r||r|St y6}zFtjd |d |ddWYd}~W|r||r*|dSd}~00W|rH||rv|n|rf||rt|0dS)z(Get current tutorial progress for playerrzInvalid player_id: NTrr tooltips_seenrr skip_tutorial)rrr+r,z+Error getting tutorial progress for player rr) rrr"rrrrrr jsonloadsrr$)rr'rresultr+r)r r r get_tutorial_progressNs^      r0)rnew_steprc Cst|tr|dkrdddSt|tr6|dks6|dkr@dddSd}d}zz|t}|}|d||f|d |td |if|t d |d |d |dWW|r| |r| St y@}z^|r| tj d|d|d ddt|dWYd}~W|r(| |r6| Sd}~00W|rR| |r| n|rp| |r~| 0dS)z^ Advance player to next tutorial step Returns: {'success': bool, 'new_step': int} rFrrdz*Invalid new_step: must be between 0 and 99NzKUPDATE player_tutorial_progress SET tutorial_step = %s WHERE player_id = %szINSERT INTO tutorial_milestones (player_id, milestone_type, milestone_data) VALUES (%s, 'step_complete', %s)stepPlayer z advanced to tutorial step T)rr1z(Error updating tutorial step for player rr)rrrrrr-dumpsr!r"r#r r$r%rr&)rr1r'rr)r r r update_tutorial_stepysZ    r6)rrrc Cst|tr|dkrdddSt|tr.|s8dddSt|sPdd|dSd}d}zHzt}|}|d||f|jdkrdd dWW|r| |r| S|d |t d |if| t d |d |ddiWW|r| |r| Sty}z`|r(|t jd|d|dddt|dWYd}~W|rj| |rx| Sd}~00W|r| |r| n|r| |r| 0dS)zI Mark a tooltip as seen by player Returns: {'success': bool} rFrrz,Invalid tooltip_id: must be non-empty stringzInvalid tooltip_id format: NzUPDATE player_tutorial_progress SET tooltips_seen = JSON_SET( COALESCE(tooltips_seen, '{}'), CONCAT('$.', %s), TRUE ) WHERE player_id = %szPlayer tutorial not initializedzINSERT INTO tutorial_milestones (player_id, milestone_type, milestone_data) VALUES (%s, 'tooltip_seen', %s)rr4z saw tooltip: rTz!Error marking tooltip for player rr)rrr&stripr rrrrowcountr r-r5r!r"r#r$r%r)rrr'rr)r r r mark_tooltip_seensh      r9c CsZt|tr|dkrdddSd}d}zzvt}|}|d|fddlm}||d||}|t d |d d d d WW|r| |r| St y}z^|r| tj d|d|d ddt|dWYd}~W|r| |r | Sd}~00W|r(| |rV| n|rF| |rT| 0dS)zr Mark onboarding as complete and award achievement Returns: {'success': bool, 'reward_diamonds': int} rFrrNzUPDATE player_tutorial_progress SET onboarding_complete = TRUE, onboarding_completed_date = NOW() WHERE player_id = %s)check_and_unlock first_stepsr4z completed onboardingT)rreward_diamondsz'Error completing onboarding for player rr)rrrrrZretention.achievementsr:r!r"r#r r$r%rr&)rr'rr:Zachievement_resultr)r r r complete_onboardingsR    r>)r message_datasend_to_clientrcCs0|d}t||}|dr,||d|ddS)z/Handle tutorialStepComplete message from clientr3rZtutorialStepUpdated)typer3N)getr6)rr?r@r3r/r r r handle_tutorial_step_complete!s  rC)rr?rcCs|d}t||dS)z&Handle tooltipSeen message from clientZ tooltipIdN)rBr9)rr?rr r r handle_tooltip_seen,s rDcCs(t|}|dr$||d|dddS)z-Handle completeOnboarding message from clientrZonboardingCompleter=)rArewardN)r>)rr?r@r/r r r handle_complete_onboarding1s rF)__doc__r functionsrtypingrrr-r"r r&rr rdictr*r0r6r9r>rCrDrFr r r r s  ;+4@4