ó ¿È—Pc@s£dZddlZddlZddlZddlZddlZddlTddlmZm Z m Z ddl m Z ddl mZddlmZmZddlmZdd lmZdd lmZed d d ƒe d deƒe dƒe dddƒe dddƒe dƒe dddƒe dddƒe dƒe dƒe dƒe dƒe dƒe dddƒf gZd„Zdefd „ƒYZdS(!s÷A simple captcha to allow anonymous ticket changes as long as the user solves a math problem. I thought that the ITicketManipulator prepare_ticket method would be the place to add extra HTML stuff to the ticket page, but it seems to be for future use only. The only way I found that I could add to the HTML was by modifying the Genshi template using the ITemplateStreamFilter. I looked at http://trac-hacks.org/wiki/BlackMagicTicketTweaksPlugin for help trying to understand how the Genshi transformation stuff worked. Database setup borrowed from BSD licensed TicketModerator by John D. Siirola at Sandia National Labs. See http://trac-hacks.org/wiki/TicketModeratorPlugin Author: Rob McMullen License: Same as Trac itself iÿÿÿÿN(t*(tTabletColumntIndex(tIEnvironmentSetupParticipant(tITicketManipulator(tITemplateStreamFiltertIRequestHandler(tIWikiPageManipulator(ttag(t Transformertmathcaptcha_historytkeytidtauto_incrementtipt submittedttypetintt left_operandtoperatort right_operandtsolutiontincorrect_solutiontauthortsummaryttextthreftsolvedtbooleancCs:ddlm}|j|}|jƒd}|j|ƒS(sA Convenience function to get the to_sql for the active connector.iÿÿÿÿ(tDatabaseManageri(t trac.db.apiRt componentst_get_connectortto_sql(tenvttableRtdmtdc((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyR"6s tMathCaptchaPlugincBs eZeeeeeeƒdZdZ dZ dZ dZ d„Z d„Zd„Zd„Zd „Zd „Zd „Zd „Zd „Zd„Zd„Zd„Zd„Zd„Zdd„Zd„Zd„Zd„Zd„Z d„Z!d„Z"d„Z#d„Z$d„Z%d„Z&RS(iXiiiöXicCsHtjƒ}|j||jƒ|jdd|jfƒtjƒdS(NsINSERT INTO system VALUES s('mathcaptcha_version', '%s')(tdbtcursort_create_tablesR#texecutet db_versiontcommit(tselfR)((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pytenvironment_createdXs   cCs"|jƒ}|j|ƒ|jkS(s‡Called when Trac checks whether the environment needs to be upgraded. Returns `True` if upgrade is needed, `False` otherwise.(R)t _get_versionR,(R.R(R)((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pytenvironment_needs_upgrade`s cCs#|jƒ}|j|ƒ}||jkr.dS|dkrl|j||jƒ|jdd|jfƒdS|dkrítdddƒtdd tƒtd ƒtd d d ƒtdd d ƒtdƒtdd d ƒtdd d ƒtdƒtdƒtdƒtdƒtdƒtdd dƒf }|jddƒx't |j|ƒD]}|j|ƒqKWdj d d ddddddddg ƒ}dj d d ddddddddg ƒ}|jd||fƒ|jd ƒ|d7}n|jd!|fƒ||jkrt d"ƒ‚ndS(#sŒActually perform an environment upgrade, but don't commit as that is done by the common upgrade procedure when all plugins are done.NisINSERT INTO system VALUES s('mathcaptcha_version', '%s')iR R R RRRRRRRRRRRRRRRRs*ALTER TABLE mathcaptcha_history RENAME TO tmathcaptcha_history_OLDs, tincorrect_authortincorrect_summarytincorrect_textsKINSERT INTO mathcaptcha_history (%s) SELECT %s FROM mathcaptcha_history_OLDs"DROP TABLE mathcaptcha_history_OLDs;UPDATE system SET value=%s WHERE name='mathcaptcha_version's*MathCaptcha failed to upgrade environment.( R)R0R,R*R#R+RRtTrueR"tjoint TracError(R.R(R)tverttable_v2tstmtt old_fieldst new_fields((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pytupgrade_environmentfsT                  cCsTyEdd}|jj|ƒ|j|ƒt|jƒdp@dƒSWndSXdS(Ns$SELECT value FROM system WHERE name=s'mathcaptcha_version'i(tlogtdebugR+Rtfetchone(R.R)tsql((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyR0¢s cCs<x5tD]-}x$t||ƒD]}|j|ƒqWqWdS(s] Creates the basic tables as defined by schema. using the active database connector. N(tschemaR"R+(R.R)R#R$R;((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyR*¬s cCsbtjddƒ|d|d r>|d7}q>q>W||jkS(Ns6SELECT id, solved FROM mathcaptcha_history WHERE ip=%sii(R#RZR)R+RTtNonetban_after_failed_attempts(R.ReR(R)tfailedtrow((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyt is_bannedós  c CsÅt|jjdƒƒ|j}|j|ƒr…|jjjd|j|j |j |j |j fƒ|j ||dƒtdƒ‚n|jjƒ}ddddd d g}|jƒ}|jd d j|ƒ|fƒ|jƒ}|s |jjjd |fƒdgSi}x,tt|ƒƒD]}|||||%s s iÿÿÿÿs%s s s ssContent-length( t send_responset send_headerR#RZR)R+R7RmtappendRcR\t end_headerstwrite( R.ReR(RgR)thtmltlinesRpRz((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyRŸ»s     : c Cs\|jdƒ|jddƒ|jjƒ}dddddd d d g}|jƒ}|jd d j|ƒƒddj|d ƒ}g}x~|D]v}|dr”t|d ƒ}tj tj |dƒƒ|d<|j ddjg|D]} t | ƒ^qꃃq”q”W|dj|ƒd7}|jdt t |ƒƒƒ|jƒ|j|ƒdS(NiÈs Content-Types text/htmlRRRRRRRRs5SELECT %s FROM mathcaptcha_history ORDER BY submittedRJs# s s
%s
iÿÿÿÿis
%s
s s
sContent-length(R¢R£R#RZR)R+R7tlistRUtasctimet localtimeR¤RcR\R¥R¦( R.ReR(RgR)R§R¨RpRGRz((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyRžÎs$      : N('t__name__t __module__t implementsRRRRRRvR‚R,RdRnR/R1R>R0R*RHRiRlRqR|RwRsRyRXRmRxR…R“R”R–R—RšR¡RRŸRž(((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyR'>s@     <   '  3     '    (t__doc__R˜REtsysRUturllibt trac.corettrac.db.schemaRRRttrac.envRttrac.ticket.apiRt trac.web.apiRRt trac.wiki.apiRtgenshi.builderR tgenshi.filters.transformR R6RCR"t ComponentR'(((s1/var/www/trac/MetaModelica/plugins/MathCaptcha.pyts: