ZEXP4((U OFS.FolderqUFolderqtqNt.}q(UidqU OnePoundAdqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_objectsq (}q (U meta_typeqU OPA FolderqUidqUOPA1qutUOPA1q(U6eq(UProducts.OPAFolder.OPAqU OPAFolderqttQUtitleqU OnePoundAdqU_ownerq(]qU acl_usersqah tu.6e ((UProducts.OPAFolder.OPAqU OPAFolderqtqNt.}q(Ustandard_html_headerq(U6mq(UOFS.DTMLMethodqU DTMLMethodqttQU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asU_objectsq(}q(U meta_typeqUZ MySQL Database ConnectionqUidqUMySQL_database_connectionqu}q(U meta_typeqU DTML MethodqUidqUstandard_html_headerqu}q(hUFolderqhUImagesqu}q(hhhUstandard_html_footerqu}q(hhhU index_htmlqu}q (hU DTML Documentq!hUstylesheet.cssq"u}q#(hhhU first_choiceq$u}q%(hhhUcategories_previewq&u}q'(hhhUplaceadq(u}q)(hhhU categoriesq*u}q+(U meta_typeq,UFolderq-Uidq.UDB_adminq/u}q0(h,h-h.UAdministrationq1u}q2(U meta_typeq3UFolderq4Uidq5Ufindadq6u}q7(h3h4h5UDBAPIq8u}q9(U meta_typeq:UScript (Python)q;Uidq(U meta_typeq?UFolderq@UidqAUHelpqBu}qC(U meta_typeqDUFolderqEUidqFU PhotoViewerqGu}qH(U meta_typeqIUFolderqJUidqKUSupportqLuth(U6nqM(U OFS.FolderqNUFolderqOttQU _propertiesqP(}qQ(UidqRUtitleqSUmodeqTUwUtypeqUUstringqVu}qW(hRU photo_webbaseqXhTUwhUhVu}qY(hRUphoto_filebaseqZhTUwhUhVu}q[(hRUphoto_tempwebbaseq\hTUwhUhVu}q](hRUphoto_tempfilebaseq^hTUwhUhVu}q_(hRUmaxlength_short_descriptionq`hUUintqau}qb(hRUmaxlength_long_descriptionqchUUintqdu}qe(hRUmaxlength_titleqfhUUintqgu}qh(UidqiUthumbnail_widthqjUtypeqkUintqlu}qm(hiUthumbnail_heightqnhkUintqou}qp(hiUphoto_max_widthqqhkUintqru}qs(hiUphoto_max_heightqthkUintquu}qv(UidqwUphoto_max_bytesqxUtypeqyUintqzuth((U6xq{(hNUFolderq|ttQUphoto_filebaseq}UD:\Zope\Zope251_2\photosq~h8(U8 q(hNUFolderqttQU index_htmlq(U6qq(hU DTMLMethodqttQh$(U6sq(hU DTMLMethodqttQUphoto_tempwebbaseqU file:///D:/Zope/Zope251_2/photosqUtitleqU OnePoundAd 1qhxJhtMXh"(U6rq(UOFS.DTMLDocumentqU DTMLDocumentqttQUstandard_html_footerq(U6pq(hU DTMLMethodqttQU categoriesq(U6wq(hNUFolderqttQUidqUOPA1qh6(U8q(hNUFolderqttQUthumbnail_heightqK2hcMU photo_webbaseqU file:///D:/Zope/Zope251_2/photosqUHelpq(U9 q(hNUFolderqttQh&(U6vq(hU DTMLMethodqttQhG(U9q(hNUFolderqttQhfKh`KUthumbnail_widthqK2h1(U6zq(hNUFolderqttQUSupportq(U9(q(hNUFolderqttQh(U6gq(UProducts.ZMySQLDA.DAqU ConnectionqttQh=(U8q(U#Products.PythonScripts.PythonScriptqU PythonScriptqttQUphoto_tempfilebaseqUD:\Zope\Zope251_2\photosqUDB_adminq(U6fq(hNUFolderqttQhqM u.6mt((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUgrahameq]qUOwnerq asU__name__q Ustandard_html_headerq Utitleq UUglobalsq }qUrawqT <dtml-var title_or_id> ">

qU_varsq}qu.6n((U OFS.FolderqUFolderqtqNt.}q(UidqUImagesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asUplaceadheads-on_1.gifq (U8Cq (U OFS.ImageqUImageqttQU_objectsq(}q(U meta_typeqUImageqhU weblogo1.gifqu}q(U meta_typeqUImageqUidqU edit_icon.gifqu}q(hhhUdelete_icon.gifqu}q(U meta_typeqUImageqUidqUwhitepointer.gifq u}q!(U meta_typeq"UImageq#Uidq$Uplaceadheads-off_1.gifq%u}q&(h"h#h$Uplaceadheads-off_2.gifq'u}q((h"h#h$Uplaceadheads-off_3.gifq)u}q*(h"h#h$Uplaceadheads-off_4.gifq+u}q,(h"h#h$h u}q-(h"h#h$Uplaceadheads-on_2.gifq.u}q/(h"h#h$Uplaceadheads-on_3.gifq0u}q1(h"h#h$Uplaceadheads-on_4.gifq2u}q3(U meta_typeq4UImageq5Uidq6Ugo_back_button.gifq7u}q8(U meta_typeq9UImageq:Uidq;Ulittle_photo_icon.gifqttQh2(U8Fq?(hUImageq@ttQh (U8%qA(hUImageqBttQh%(U8?qC(hUImageqDttQh)(U8AqE(hUImageqFttQh.(U8DqG(hUImageqHttQh(U7qI(hUImageqJttQh<(U8vqK(hUImageqLttQh7(U8KqM(hUImageqNttQh+(U8BqO(hUImageqPttQUtitleqQUh(U7qR(hUImageqSttQh0(U8EqT(hUImageqUttQh'(U8@qV(hUImageqWttQu.6x((U OFS.FolderqUFolderqtqNt.}q(Uphotos_add_formq(U8q(UOFS.DTMLMethodqU DTMLMethodqttQU init_htmlq (U8q (hU DTMLMethodq ttQU__ac_local_roles__q }q Ugrahameq]qUOwnerqasU_objectsq(}q(U meta_typeqU DTML MethodqUidqU place_ad_formqu}q(U meta_typeqU DTML MethodqUidqh u}q(hhhUlist_categories_selectionqu}q(U meta_typeqU DTML MethodqUidq U index_htmlq!u}q"(U meta_typeq#UScript (Python)q$Uidq%Uplacead_image_progressbarq&u}q'(U meta_typeq(UScript (Python)q)Uidq*U goBackButtonq+u}q,(U meta_typeq-U DTML Methodq.Uidq/U ad_detailsq0u}q1(h-h.h/U extra_formq2u}q3(h-h.h/U finish_formq4u}q5(U meta_typeq6U DTML Methodq7Uidq8hu}q9(h6UScript (Python)q:h8U previewadq;u}q<(U meta_typeq=U DTML Methodq>Uidq?U show_ad_fullq@u}qA(U meta_typeqBU DTML MethodqCUidqDUcontact_details_warningqEu}qF(U meta_typeqGU DTML MethodqHUidqIUexplain_submit_errorsqJu}qK(U meta_typeqLUScript (Python)qMUidqNUsubmitadqOu}qP(U meta_typeqQU DTML MethodqRUidqSUsubmit_ad_formqTu}qU(hQUScript (Python)qVhSUhide_ad_request_dataqWu}qX(hQhRhSUidentification_loginqYu}qZ(U meta_typeq[U DTML Methodq\Uidq]Uterms_and_conditionsq^u}q_(U meta_typeq`U DTML MethodqaUidqbUmake_payment_formqcuth&(U8Gqd(U#Products.PythonScripts.PythonScriptqeU PythonScriptqfttQh@(U8qg(hU DTMLMethodqhttQhY(U9$qi(hU DTMLMethodqjttQhJ(U8qk(hU DTMLMethodqlttQU index_htmlqm(U8$qn(hU DTMLMethodqottQh4(U8qqp(hU DTMLMethodqqttQhW(U9!qr(heU PythonScriptqsttQUsubmitadqt(U9qu(heU PythonScriptqvttQh0(U8nqw(hU DTMLMethodqxttQU goBackButtonqy(U8Lqz(heU PythonScriptq{ttQUidq|Uplaceadq}h2(U8pq~(hU DTMLMethodqttQh;(U8q(heU PythonScriptqttQhc(U9>q(hU DTMLMethodqttQh^(U9'q(hU DTMLMethodqttQh(U8q(hU DTMLMethodqttQh(U8q(hU DTMLMethodqttQhE(U8q(hU DTMLMethodqttQUtitleqU Place an adqhT(U9q(hU DTMLMethodqttQu.8 y((U OFS.FolderqUFolderqtqNt.}q(U Categoriesq(U8 q(hUFolderqttQUidqUDBAPIq U__ac_local_roles__q }q Upetbeq ]q UOwnerqasU_objectsq(}q(U meta_typeqUFolderqhhu}q(U meta_typeqUFolderqUidqU TempAdvertsqu}q(U meta_typeqUFolderqUidqU TempPhotosqu}q(U meta_typeqUFolderqUidq UPhotosq!u}q"(U meta_typeq#UFolderq$Uidq%UUsersq&u}q'(U meta_typeq(UFolderq)Uidq*UAdvertsq+uth(U8q,(hUFolderq-ttQUAdvertsq.(U9;q/(hUFolderq0ttQU_ownerq1(]q2U acl_usersq3ah tUPhotosq4(U9q5(hUFolderq6ttQh(U8q7(hUFolderq8ttQUtitleq9Uh&(U96q:(hUFolderq;ttQu.6q"((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUgrahameq]qUOwnerq asU__name__q U index_htmlq Utitleq UUglobalsq }qUrawqUx qU_varsq}qu.6s((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U6tq(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asU__name__qU first_choiceqUtitleqUUglobalsq}qUrawqU
">Place an ad ">Find an ad ">About
qU_varsq}qu.6r((UOFS.DTMLDocumentqU DTMLDocumentqtqNt.}q(U_dav_writelocksq(U8q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asU__name__qUstylesheet.cssqUtitleqUUglobalsq}qUrawqTbody { font-family: Lucida console, Courier New, monospace; font-size: 12px; } div.copyright { font-size: 80%; } h1, h2, h3, h4 { font-family: Arial, Helvetica, sans-serif; } a.categorytab { font-family: Arial, Helvetica, sans-serif; font-weight: bolder; font-size: 120%; color: #000000; } a.categorysubtab { font-family: Arial, Helvetica, sans-serif; font-weight: bold; color: #000000; } a.ad_title { font-weight: bold; } a.ad_title_bold { font-weight: bold; font-size: 110%; } .step_number { font-weight: 600%; } .formcaption { font-family: Arial, Helvetica, sans-serif; font-weight: bold; } .help-text { font-family: Arial, Helvetica, sans-serif; font-style: italic; } div.previewad { background-color: #eff7ff; border:1px solid #CCCCCC; padding: 0.5em 0.5em 0.5em 0.5em; } div.contactdetailswarning { background-color: pink; border:1px dashed red; } div.previewad_framed { background-color: #eff7ff; border:2px dashed black; padding: 0.5em 0.5em 0.5em 0.5em; } div.submiterror { background-color: #FF3333; border:2px solid black; margin:0em 1em 0em 1em; padding:0em 1em 0em 1em; } .framed_table { border:2px dashed black; } .strongbutton { font-weight: bold; }qU_varsq}qu.6p>((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUgrahameq]qUOwnerq asU__name__q Ustandard_html_footerq Utitleq UUglobalsq }qUrawqU
qU_varsq}qu.6wA((U OFS.FolderqUFolderqtqNt.}q(UidqU categoriesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_objectsq (}q (U meta_typeqUFolderqhUSQLqu}q(U meta_typeqU DTML MethodqUidqU root_viewqutUSQLq(U6yq(hUFolderqttQUtitleqU Categoriesqh(U8q(UOFS.DTMLMethodqU DTMLMethodqttQu.8((U OFS.FolderqUFolderqtqNt.}q(UtitleqU Find an adqUidqUfindadqU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU_ownerq(]qU acl_usersqah tu.9 ((U OFS.FolderqUFolderqtqNt.}q(UidqUHelpqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU_objectsq (}q (U meta_typeqUFolderqhU DocumentsqutUtitleqUh(U9 q(hUFolderqttQU_ownerq(]qU acl_usersqah tu.6v((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUgrahameq]qUOwnerq asU__name__q Ucategories_previewq Utitleq UUglobalsq }qUrawqUU_varsq}qu.9((U OFS.FolderqUFolderqtqNt.}q(U index_htmlq(U9q(UOFS.DTMLMethodqU DTMLMethodqttQUidq U PhotoViewerq U__ac_local_roles__q }q Upetbeq ]qUOwnerqasU_objectsq(}q(U meta_typeqU DTML Methodqh U index_htmlqu}q(hUScript (Python)qh UgetPhotoInformationqutUtitleqU Photo viewerqh(U9q(U#Products.PythonScripts.PythonScriptqU PythonScriptqttQU_ownerq(]qU acl_usersqah tu.6z%((U OFS.FolderqUFolderqtqNt.}q(UidqUAdministrationqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_objectsq (}q (U meta_typeqUFolderqhUManageCategoriesqu}q(U meta_typeqUFolderqUidqUPhotosquth(U6{q(hUFolderqttQUtitleqUh(U8q(hUFolderqttQu.9(N((U OFS.FolderqUFolderqtqNt.}q(UidqUSupportqU SendPasswordq(U9)q(hUFolderq ttQU__ac_local_roles__q }q Upetbeq ]q UOwnerqasU_objectsq(}q(U meta_typeqUFolderqhU SendPasswordqu}q(U meta_typeqUFolderqUidqUTCqutUtitleqUSupportqUTCq(U9/q(hUFolderqttQU_ownerq(]qU acl_usersq ah tu.6g((UProducts.ZMySQLDA.DAqU ConnectionqtqNt.}q(UtitleqUZ MySQL Database ConnectionqUidqUMySQL_database_connectionqU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asUconnection_stringqU -onepoundadqu.8 a((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (Ukeyq U _getitem_q U_getitemq U _getattr_q U_getattrqUkeysqtU co_argcountqKubU_paramsqUkeyqUidqUTranslateVariableNameqU__ac_local_roles__q}qUpetbeq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq}q(Uname_containerq U containerq!U name_subpathq"Utraverse_subpathq#U name_contextq$Ucontextq%U name_m_selfq&Uscriptq'usbU_ownerq((]q)U acl_usersq*ahtq+U_codeq,TcsdZdS(Ncst}t}hdd<dd<dd<dd<d d <d d <d d<dd<dd<dd<dd<dd<dd<dd<dd<dd <}||d!||d"o ||||d"Sn|SdS(#NsTitles adverttitlesPricespricesShort descriptionsshort_descriptionsLong descriptionslong_descriptionsPhoto 1sphoto1sPhoto 2sphoto2sPhoto 3sphoto3sError with Photo 1s photo1_errorsError with Photo 2s photo2_errorsError with Photo 3s photo3_errorsGIFs image/gifsJPEGs image/pjpegsTerms and conditionssterms_and_conditionss Email addresss email_addresssPasswordspasswordsCategorys subcategoryidshas_keysstrip(s _getitem_s_getitems _getattr_s_getattrskeysskey(skeys _getitem_s_getitems _getattr_s_getattrskeys((sScript (Python)sTranslateVariableNames" (sTranslateVariableName(sTranslateVariableName((sScript (Python)ssq-U_bodyq.T&keys={'adverttitle':"Title", 'price':"Price", 'short_description':"Short description", 'long_description':"Long description", 'photo1':"Photo 1", 'photo2':"Photo 2", 'photo3':"Photo 3", 'photo1_error':"Error with Photo 1", 'photo2_error':"Error with Photo 2", 'photo3_error':"Error with Photo 3", 'image/gif':"GIF", 'image/pjpeg':"JPEG", 'terms_and_conditions':"Terms and conditions", 'email_address':"Email address", 'password':"Password", 'subcategoryid':"Category"} if keys.has_key(key.strip()): return keys[key.strip()] else: return key q/U Script_magicq0KUwarningsq1)U func_defaultsq2NUerrorsq3)U Python_magicq4U* q5u.6f((U OFS.FolderqUFolderqtqNt.}q(UtitleqUDatabase administrationqU CreateTablesq(U6hq(hUFolderq ttQUidq UDB_adminq U__ac_local_roles__q }q Ugrahameq]qUOwnerqasU_objectsq(}q(U meta_typeqUFolderqh hutqu.8C((U OFS.ImageqUImageqtqNt.}q(UsizeqMUheightqKUdataqTGIF89a"""fff333UUUwwwDDD̙!,I8ͻ`(dihl0$q7BX 0EZ(V˺p-G4 # N<BIA0~<)% 4ow ~|oqsfhj~ tl {n OeVEMs  V5 R n oEVÞ@ B= 8 eo_E8% RNA MH (Ї&R-x&B ("? &;uE*9)`@aŴ LT*(4,9Sח UwONV(@ۤÎX@q%|AM2`@ g`~.ƙ>BT9JH8s< l ỷP3S8@'*/zMǍIm5JW = |OEa vwz @˸p5gLC@j4Wէ{-פ2wwu73ǀPDphQ5F8*TA$/$0\IPF)TVIA;qU preconditionq UU__name__q Uplaceadheads-on_1.gifq Utitleq USelect main categoryq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqKU__ac_local_roles__q}qh]qUOwnerqasu.6oW((U OFS.ImageqUImageqtqNt.}q(UsizeqMmUheightqK(UdataqTmGIF89aG(㉉EEgg$$皚55VVxx뫫\!,G(I8ͻ`(dihlp,tmx|@A8`CPPrf`6 V`zP@k\vY@{E/r:=s sdF,m(hzzytj5emU+f#~m3ne {t 0Oe)›t  Ǭ *tv s swm6{g+ Ӡʁ_e]X0G0p EƋ5(4b2A/,0N޲ h"\E=BeYFZ$ $"Y,Idd( Y-ZM E> >IWd 7 R0p6ӂ.J аBPCܩUpy9za =44 Z{l(hvo(o)Ԯ3b\u÷+~7Y W݂L~_LKHﵑQ߁RPyZGuS@m=4~0URlVT4t g~8a `Ab H8NjhmB5ú#Q 8@l 47AjC:$JV֐YYrol΁j} EY}:pb)gbDZP8p>`BeZu:Pˉ_shJAq $&z'9zAlY̑j)#+fW`̥NPX!5w5eEzFSP8R$,&lAyү: _f`j8j ^Bk#Zj,±Hj"+rOPӞFyqlF}Wn)ak| /3˱d2*M@Ddm5@;V4ȫ( "gL1Ll? oRpj t ^ga퓞1*ۚYjD>mv;k)w;\p֯r @ | Q8fw-)ZNڜ1i{0 w<0Lxr|?K9Vgc \0dUcXVKkG  C   z B\  aB8 TeI U ^ ^?8FU N،e4I(g % Yu:A0"i2B|`{aK t8åCF뗬y'b$d @ UX:L5%ބx1#}YaRwb!Gʅcӫr ugӧ8 |~ _[`WNMKӨM\f,@`ZapGb|j:Ҁ(AK9 VqAӜORgԷs#5$  |P_ËO<;qU preconditionq UU__name__q Uplaceadheads-on_4.gifq Utitleq UConfirm and payq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqKqU__ac_local_roles__q}qh]qUOwnerqasu.8%((U OFS.ImageqUImageqtqNt.}q(UsizeqKUheightqKUdataqUGIF89a>>>}}}XXXՐoooKKK...333!,hI8t^BYKUi0xG9A$*? kAh6IdQZi'u@hU"ѰEgfpϓ;-m3|%1;qU preconditionq UU__name__q Uwhitepointer.gifq Utitleq U Main categoryq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtUwidthqKU__ac_local_roles__q}qh]qUOwnerqasu.8?((U OFS.ImageqUImageqtqNt.}q(UsizeqMUheightqKUdataqTGIF89a泳ջݢ!,I8ͻ`(dihl0*,6q;FCX! Ej0V˺p-FG8C ^<II b~<1%4ow~|oqsfhj~tl { n Oe VEMs  V5 R noEVÞ@ B=  8 eo_ E(% RNA MH (Ї&R- x&B 0? &;uE*9)@aŴN\T*(449Sח UwONV(@ۤÎX@q%|AM2$`@ g`~.ƙ>BT9JH8s< l$ỷP3S&8@'*/zMǍIm5JW = |AEa vqwzP˸p5gLS@j4WCէ{-פ2wwu73ǀPDphQ5F8*T$/,@\IPF)TVIA;qU preconditionq UU__name__q Uplaceadheads-off_1.gifq Utitleq USelect main categoryq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqKU__ac_local_roles__q}qh]qUOwnerqasu.8A;((U OFS.ImageqUImageqtqNt.}q(UsizeqM#UheightqKUdataqT#GIF89al摑ժ!,lI8ͻ`(dihlL*)K3. i$[]AW34A( h$E( $AQI8>ɝQw2  oeg\h_  g  o t _W} < b C|: |>`I tFya  }<X> MI)# mm ` ' FP xqH] .h@#[cK IB d5D: uH ,JIK$(PpгFF{o8(I*ƭHItgL(6P{xhKs 0Q;(j#Q`H Lȍ d3_(_μУKN;qU preconditionq UU__name__q Uplaceadheads-off_3.gifq Utitleq UEnter ad detailsq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqKlU__ac_local_roles__q}qh]qUOwnerqasu.8D((U OFS.ImageqUImageqtqNt.}q(UsizeqMUheightqKUdataqTGIF89aDDD"""wwwUUU333fff!, $dihlp,tmx|AP#r)J4PAꡐiܕr4 * 3,jdM&ƂqM'  R$ay"J Ur &x|  T }# bw#DrJ&N _f" a# lz% DpOƹ #)NMѮ\ys⁞:(#c2E4LL܃A "3j"Ta<ېqH4a %2 E@Ls  ( *grb|`<@.{5 SNpJqYŸ.q#! ,K+n+[@gX0R p 9S2G{bM$@#PujQ=/J%4& g虃# E J UQG ύ&[N(qEYnp8c Z]T"0@& @,הeKg'E`F (D ␇#%UH HJ\&d(P%G*4W@u@]A& o>CC??LLNNAAVVII[[QQ__bbYYggjjccnniirrttwwyy}}́ n s ρςjcndЂ҃4%1{$rdӃԄӄweyfՄ}fׅY?hgنhڇۇ܇݈݈zވމc߉⋵ኸ㋺䌶ኜ䋼䋿匬s¿!,׭Ǯ)To_=i7ŋhȱGIɓ'˗0apפ 6p؁f ;JtSTiK@Bիׯ`TB, ]˶-["R-|wCpH@x@>-Z,ENJPB Hȏ2`8ei'GHg8 1hpIh5|6ˆC~eȀ=i^Wx )'4h $q@45ˆ.`,@XJ)pxat%P"$b@ 4 ԣ%qwāk 'l%bL! 1t94i(b@KzaH cXJ pG|\J%+B )x&sis"aR覥4GrǨzajvw-3:@?wQ+s;{α5sN:訣!-غFnrbM9䌳l:в.kim"K/tN8kNEB.K0<3M5\6t7SQ+R.SL283c6xsqE+q,,20S 283@,1%L;q U__name__q Ulittle_photo_icon.gifqUtitleqUPhotoqU content_typeqU image/gifqU preconditionqUUwidthqKU__ac_local_roles__q}qh ]qUOwnerqasu.8K((U OFS.ImageqUImageqtqNt.}q(UsizeqMvUheightqKU_ownerq(]qU acl_usersq aUpetbeq tUdataq TvGIF89a[R"4W%aLϼ`)N 1(vM[ kHg, 9*'*eqok»**(975USPV}xca]GEC" /# ޑOF@1+! %}E̼r9ΰ=<Bd :.xCG~k/Ɨݎ r)'T#zNlRf\7~ߖ×c738t3 +'}d63̣leف~Lk`⢶6ڂ^(me G n1o44 VȰFFʊN [& iߒߓIޑ xݒİ`DdAP!U%~ݏ܌# &˼HIK-E i.ȼ!  Rc+X&+'ۇl E@n }R|L- w vZY*LJ3QL~Qͼ܍~T$TJ@zEt;ʰL`Yfߔ _Y糗ڈ܋ ld+metkLke%U!RL/_)T5B"?\':*'[leė@Y&j.܌c$ 宕sw|Zl/!,[#H*\Ȱ# x|&2LǏ CIurЫ.c$h]ɛ8s4eqC5,fE+d !c6BD~XEe$ rB&;&*RSlNՅ؏%̀q0(χi|Wj<>! _Gmy`=POw#  !H?Cy7'9!y" D')u"(Gd?%FG|ЁxxAtZl!tH)ac~S*}AD<GeB| HA7;[(̳:|Is1ǡr&dPBOdFyxE((%IsM` 40D(| xBOR S3c| I= B(p=ZRpDJaq"J'ptCư lk&B"Ž'&Dr )GhMc?Gdc pX L'36BdTQ'n81g*GO@ U+4@A"}3Hȍ)mI?bqh҇9P *z_@ʪ)4@@bbmT`,PS2P@;tav'n$ wHc34R.-Q#Ϙ6\2 2C.nD<9{@;q U__name__q Ugo_back_button.gifqUtitleqUGo backqU content_typeqU image/gifqU preconditionqUUwidthqK[U__ac_local_roles__q}qh ]qUOwnerqasu.8BJ((U OFS.ImageqUImageqtqNt.}q(UsizeqM3UheightqKUdataqT3GIF89aq戈̻ժ݀ę!,qI8ͻ`(dihl B.%0K Xr 9Đ`{UE4a $PpKA >KAVgc \0dUcXVKkG  C     z B\  aB8 TeI U ^ ^? 8FU N،e4I(g % Yu:I0"i2B|p{K t8åCF뗬y'b$d(` UX:L5%ބx1#}YaRwb!Gʅcӫr ugӧ8 |~ _[ `WNMKӨM\f4`ZqpG|j:Ҁ(AK9 VqAӜORgԷs#5(( |`_ËO<;qU preconditionq UU__name__q Uplaceadheads-off_4.gifq Utitleq UConfirm and payq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqKqU__ac_local_roles__q}qh]qUOwnerqasu.7f((U OFS.ImageqUImageqtqNt.}q(UsizeqK^U preconditionqUUdataqU^GIF89a !, # !sl!Dr&>)FV\E;qU__ac_local_roles__q }q Upeterbeq ]q UOwnerq asU__name__qU edit_icon.gifqU content_typeqU image/gifqUtitleqUEditqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqK UheightqK u.8E:((U OFS.ImageqUImageqtqNt.}q(UsizeqM#UheightqKUdataqT#GIF89al"""333fffwwwUUUDDD!,lI8ͻ`(dihlK*)N/: a$[a]AW30( `$( $AQI4>}Qw 2  oeg\h_  g o t _W} < b C |:|>`ItFya  }<X> MI)#p mm ` ' FP xqH] .h@#[K IB d5D: uH ,JIK$(PpгFF{o8(I*ƭHItgL(6P{xhKs 0Q;(j#QXH Lȍ d3_(_μУKN;qU preconditionq UU__name__q Uplaceadheads-on_3.gifq Utitleq UEnter ad detailsq U content_typeqU image/gifqU_ownerq(]qU acl_usersqaUpetbeqtqUwidthqKlU__ac_local_roles__q}qh]qUOwnerqasu.8@((U OFS.ImageqUImageqtqNt.}q(UsizeqMUheightqKUdataqTGIF89a滻̙!, $dihlp,tmx|RP#r)R<PAjiܕ"< * ;4jd[aM&GqM+   R$ay"J U r &x|  T }# bw#Dr J&N _f" a# lz%D pOƹ#)N MѮ\ysb:(#c2E4LL܂A E"3jTa<ې!XH4q %2 E@Ls  ( *grb|`,@.{5 SNpJqYŸ.q#! K+n+[gX0R p 9S2G{bM(@#P%jQ=/J%4& g# U@J UG ύ&[N( qEY~p8cZ]T"0@& @,הeKg'E`F (D ␇#%UH HJ\&d(P%G*<W@u@]A& o Extra photos "> "> " CHECKED>Keep =count"> Free Cost: 50p qU_varsq}qu.8Y((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8eq(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU init_htmlqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqTF

3.

2. Now select a sub category

1. Select main category for your ad

qU_varsq}qu.8G >((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U _getitem_q U_getitemq U _getattr_q U_getattrq UcontextqUrequestqUhkqUhtmlqUimageid_originalqUwhitepointer_objectqUidcountqUimageidqUchangeqUstrqUgetattrqtU co_argcountqKubU_paramsqUUidqUplacead_image_progressbarqU__ac_local_roles__q}qUpetbeq]q UOwnerq!asU_dav_writelocksq"(U8Iq#(U Persistenceq$UPersistentMappingq%ttQU _bind_namesq&(cShared.DC.Scripts.Bindings NameAssignments q'oq(}q)U_asgnsq*}q+(Uname_containerq,U containerq-U name_subpathq.Utraverse_subpathq/U name_contextq0Ucontextq1U name_m_selfq2Uscriptq3usbU_ownerq4(]q5U acl_usersq6ahtq7U_codeq8TcsdZdS(Ncst}t}|td}||d}d}d}||tdd} d} |dp|d p |d o! |d |td }n x5d dddgd r}  || }  d} |d o | djo d } n|do | djo d } n9| d jo|dp |d  o d } n| o8|| ddd} d|t | f}nd|}d|t|td| f}qW|d}|SdS(NsREQUESTshas_keyssplaceadheads-off_%s.gifsImagesswhitepointer.gifs' s subcategoryidsexpandcategoryidsadvertids s goBackButtoniiiiisreplacesoffsons %ss%s s%s s
%s%s  %s
(s _getitem_s_getitems _getattr_s_getattrscontextsrequestshkshtmlsimageid_originalswhitepointer_objectsidcountsimageidschangesstrsgetattr(s _getitem_s_getitems _getattr_s_getattrscontextsrequestshkshtmlsimageid_originalswhitepointer_objectsidcountsimageidschangesstrsgetattr((sScript (Python)splacead_image_progressbars.   *!!    +   ) (splacead_image_progressbar(splacead_image_progressbar((sScript (Python)ssq9U_bodyq:Trequest = context.REQUEST hk = request.has_key html = '' imageid_original = 'placeadheads-off_%s.gif' whitepointer_object = context.Images['whitepointer.gif'] html = """\n""" if hk('subcategoryid') or hk('expandcategoryid') or hk('advertid'): html = html + ""%context.goBackButton() for idcount in [1,2,3,4]: imageid = imageid_original%idcount change = 0 if hk('expandcategoryid') and idcount==2: change = 1 if hk('subcategoryid') and idcount==3: change = 1 elif idcount==1 and not (hk('subcategoryid') or hk('expandcategoryid')): change = 1 if change: imageid = imageid.replace('off','on') html = '%s'%(html, str(whitepointer_object)) else: html = '%s\n'%html html = '%s\n'%(html, getattr(context.Images, imageid)) html = html + """
%s%s  %s
""" return html q;U Script_magicqNUerrorsq?)U Python_magicq@U* qAu.8((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU show_ad_fullqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqT
class="previewad_framed"class="previewad">
ad_title_boldad_title" > style="font-weight:bold;" >
style="font-weight:bold;">
"><dtml-var " /> ">No thumbnail
qU_varsq}qu.9$!((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U9%q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qUidentification_loginqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqT
Email
Password
: qU_varsq}qu.8$((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q U index_htmlq Utitleq UUglobalsq }qU_ownerq(]qU acl_usersqahtqUrawqUV qU_varsq}qu.8q((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU finish_formqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqT 





qU_varsq}qu.9! n((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U _getattr_q U_getattrq U_print_q U_printq UcontextqUrequestqUman_varsqUopt_varsqUvarqtU co_argcountqKubUidqUhide_ad_request_dataqU__ac_local_roles__q}qUpetbeq]qUOwnerqasU_dav_writelocksq(U9"q(U PersistenceqUPersistentMappingqttQU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments q oq!}q"U_asgnsq#}q$(Uname_containerq%U containerq&U name_subpathq'Utraverse_subpathq(U name_contextq)hU name_m_selfq*Uscriptq+usbU_ownerq,(]q-U acl_usersq.ahtq/U_codeq0T csdZdS(Nc s t}t}|td}dddddddd g}d d d d g}x?|dr2} |d|| |d|dfIJqcW x\|d rO}| |d|o0|d|||d|dfIJnqW|SdS(NsREQUESTs adverttitlesshort_descriptionspriceslong_descriptionsns_boldsns_frames ns_highlights subcategoryidskeep_photo1_idskeep_photo2_idskeep_photo3_ids photo_folderis(sgetsshas_key( s _getattr_s_getattrs_print_s_printscontextsrequestsman_varssopt_varssvar( s _getattr_s_getattrs_print_s_printscontextsrequestsman_varssopt_varssvar((sScript (Python)shide_ad_request_datas!! $(shide_ad_request_data(shide_ad_request_data((sScript (Python)ssq1U_bodyq2Tlrequest = context.REQUEST man_vars = ['adverttitle','short_description','price','long_description', 'ns_bold','ns_frame','ns_highlight','subcategoryid'] opt_vars = ['keep_photo1_id','keep_photo2_id','keep_photo3_id', 'photo_folder'] for var in man_vars: print ''%(var, request.get(var,'')) for var in opt_vars: if request.has_key(var): print ''%(var, request.get(var,'')) return printed q3U Script_magicq4KUwarningsq5)U func_defaultsq6NUerrorsq7)U Python_magicq8U* q9u.9B((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U_write_q U_writeq U _getitem_q U_getitemq U _getattr_qU_getattrqUcontextqUrequestqU SubmitErrorqU all_photoidsqUfolderqUrandstrqUcountqUrangeqUiUphotoqUaskedqUkeepqUintqUgetattrqUNoneqUerr_msgqU p_descriptionqU tempphotoidq Uphoto_max_bytesq!Ustrq"U category_recq#U user_emailq$U user_passwordq%U user_recordsq&Ulenq'Upriceq(Usd_varq)Uld_varq*U email_addressq+Upasswordq,U user_recordq-Uuseridq.U categoryidq/U same_typeq0U adverttitleq1Ushort_descriptionq2Ulong_descriptionq3Uns_boldq4Uns_frameq5U ns_highlightq6Uadvertidq7UpUphoto_descriptionq8Uphoto_filenameq9U photo_widthq:U photo_heightq;Uthumbnail_filenameqtU co_argcountq?KubU_paramsq@UUidqAUsubmitadqBU__ac_local_roles__qC}qDUpetbeqE]qFUOwnerqGasU_dav_writelocksqH(U9qI(U PersistenceqJUPersistentMappingqKttQU _bind_namesqL(cShared.DC.Scripts.Bindings NameAssignments qMoqN}qOU_asgnsqP}qQ(Uname_containerqRU containerqSU name_subpathqTUtraverse_subpathqUU name_m_selfqVUscriptqWU name_contextqXUcontextqYusbU func_defaultsqZNU_codeq[TncsdZdS(s! Upload the photos temporarily c7_s t}t}t}d|td}h} g} | |ddo||ddjo ||d} n5|td} d| |tdf} d} xHt dd d r2}d | }d |}d |}||d|o||d|o^||d|t||||| dt|||| d7} n&|!tdt|||nM|#|dd|o#$t||d|ddjo %t}&y'||dd|d}(|td||d|)| *|}|+|dd | ||,| d|-| d7} Wn .dj o/d}n0dj o1d}n2dj o 3d|4td}n5dj o 6d|7td}n8d j o29d!|:td|;tdf}nI<d"j o=d#}n+>d$j o?d%@td&}nXB|o8|C|dd'||D|||d'|d?}|p|dd;|q|td@||d; ordA||d;sq\U_bodyq]TG""" Upload the photos temporarily """ request = context.REQUEST SubmitError = {} # # 1. Upload temp photos # all_photoids=[] if request.has_key('photo_folder') and request['photo_folder']!='': folder = request['photo_folder'] else: randstr=context.getTimestampStr() folder = '%s_%s'%(randstr, context.generateRandomNumberString()) #folder = context.TimeFolder(folder) count = 1 for i in range(1,4): # shortcuts photo = 'photo%s_id'%count asked = 'asked_keep_photo%s_id'%i keep = 'keep_photo%s_id'%i # did this exists as a photo? if request.has_key(asked): if request.has_key(keep): request.set(photo, int(request[keep])) all_photoids.append(int(request[keep])) count += 1 else: # Been asked to keep it but didn't want to context.deleteTempPhoto(int(request[asked])) elif request.has_key('photo%s'%i) and \ getattr(request['photo%s'%i], 'filename')!='': err_msg=None try: p_description = request.get('photo_description%s'%i,'') tempphotoid = context.createTempPhoto(request['photo%s'%i], folder, p_description) request.set('photo%s_id'%count, tempphotoid) all_photoids.append(tempphotoid) count += 1 except "FileNotFile": err_msg = "File uploaded not a file" except "FileNotImage": err_msg = "Type of the file is not recognized as an image" except "PhotoTooHigh": err_msg = """Photo too high. Max. %s pixels high"""%context.photo_max_height except "PhotoTooWide": err_msg = """Photo too wide. Max. %s pixels wide"""%context.photo_max_width except "PhotoTooLarge": err_msg = """Photo too wide and high. Max. (%s, %s) pixel"""%(context.photo_max_width, context.photo_max_height) except "PhotoAlreadyThere": err_msg = """A photo with that name has already been uploaded""" except "FileTooBig": err_msg = """Photo too big. It can only be %s at the most"""%(photo_max_bytes/1024) if err_msg: request.set('photo%s_error'%i, err_msg) SubmitError['photo%s_error'%i]= err_msg if all_photoids: request.set('photo_folder', folder) request.set('all_photoids', all_photoids) # # 2. Check some input # if str(request.get('subcategoryid','')).strip() == '': SubmitError['subcategoryid'] = "Category not defined" else: category_rec = context.getCategory(str(request['subcategoryid']).strip()) if not category_rec: SubmitError['subcategoryid'] = "Category not recognized" if request.get('user_password','').strip() == '': SubmitError['password'] = "Password can not be empty" if request.get('user_email','').strip() == '': SubmitError['email_address'] ="Email address can not be empty" elif request.get('user_password','').strip() != '': # Now, if this user exists check that the password is correct user_email = request['user_email'].strip() user_password = request['user_password'].strip() user_records = context.getUserByEmail(user_email) if user_records: # Notice the case INsensitivity! if user_records[0].password.lower() != user_password.lower(): SubmitError['password'] = "Incorrect password" if request.has_key('adverttitle') and request['adverttitle'].strip()!='': if len(request['adverttitle']) > context.maxlength_title: SubmitError['adverttitle']="""Title too long. Max %s characters"""%context.maxlength_title else: SubmitError['adverttitle']="The title can not be empty" if request.has_key('price') and request['price']!= '': price = str(request['price']).strip().replace(' ','').replace(',','.') request.set('price', price) if not context.validPrice(request['price']): SubmitError['price'] ="Price not a number" sd_var = 'short_description' if request.has_key(sd_var) and request[sd_var].strip()!='': if len(request[sd_var]) > context.maxlength_short_description: SubmitError[sd_var]="Short description too long. \ Max %s characters"%context.maxlength_short_description else: request.set(sd_var, context.RemoveTooManyLineBreaks(request[sd_var], max=8)) else: SubmitError[sd_var]="The short description can not be empty" ld_var = 'long_description' if request.has_key(ld_var) and request[ld_var].strip()!='': if len(request[ld_var]) > context.maxlength_long_description: SubmitError[ld_var]="""Long description too long. Max %s characters"""%context.maxlength_long_description if not request.has_key('agree_terms_and_conditions'): SubmitError['terms_and_conditions'] = "Terms and condition not agreed with" # # 3. Tune some data # if request.has_key('extra_bold'): request.set('ns_bold', 1) else: request.set('ns_bold', 0) if request.has_key('extra_frame'): request.set('ns_frame', 1) else: request.set('ns_frame', 0) if request.has_key('extra_highlight'): request.set('ns_highlight', 1) else: request.set('ns_highlight', 0) if SubmitError: return context.placead.index_html(context, request, SubmitError=SubmitError) else: # All checks passed, create advert # # 1. Create user if necessary # email_address = request['user_email'].strip() password = request['user_password'].strip() user_record = context.getUserByEmail(email_address) if user_record: userid = user_record[0].userid else: userid = context.createUser(email_address, password) # # 2. Create advert # categoryid = request['subcategoryid'] if same_type(categoryid, 's'): categoryid = categoryid.strip() adverttitle = request['adverttitle'].strip() short_description = request['short_description'].strip() price = request.get('price','').strip() long_description = request.get('long_description','').strip() ns_bold = request['ns_bold'] ns_frame = request['ns_frame'] ns_highlight = request['ns_highlight'] advertid = context.createAdvert(userid, categoryid, adverttitle, price, short_description, long_description, ns_bold, ns_frame, ns_highlight) # # 3. Move temporary photos to photos # for p in context.getPhotos(all_photoids, temp=1): # 3.1 Copy the db record tempphotoid = p.tempphotoid photo_description = p.photo_description folder = p.folder photo_filename = p.photo_filename photo_width = p.photo_width photo_height = p.photo_height thumbnail_filename = p.photo_filename thumbnail_width = p.thumbnail_width thumbnail_height = p.thumbnail_height # rename filename #photo_filename = photo_filename.replace('.temp','') #thumbnail_filename = thumbnail_filename.replace('.temp','') context.createPhotoRecord(advertid, photo_description, folder, photo_filename, photo_width, photo_height, thumbnail_filename, thumbnail_width, thumbnail_height) #context.renameTempPhoto(tempphotoid) context.deletePhotoRecord(tempphotoid, temp=1) request.set('advertid', advertid) return context.placead.index_html(context, request) q^U Script_magicq_KUwarningsq`)U_ownerqa(]qbU acl_usersqcahEtqdUerrorsqe)U Python_magicqfU* qgu.8n5((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8tq(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU ad_detailsqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqT!
Category    
 
Title   "> Make and model.
Maximum 30 charaters.
 
Price "> Include only if applicable.
 
Short description

" size=2>
Type in a short description (max. characters)
Include contact details.
 
Longer description

" size=2>
Longer more detailed description.
(max. characters)
qU_varsq}qu.8L((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U _getitem_q U_getitemq U _getattr_q U_getattrq UcontextqUimageqUstrqtU co_argcountqKubU_paramsqUUidqU goBackButtonqU__ac_local_roles__q}qUpetbeq]qUOwnerqasU_dav_writelocksq(U8hq(U PersistenceqUPersistentMappingqttQU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq }q!U_asgnsq"}q#(Uname_containerq$U containerq%U name_subpathq&Utraverse_subpathq'U name_m_selfq(Uscriptq)U name_contextq*husbU_ownerq+(]q,U acl_usersq-ahtq.U_codeq/TcsdZdS(Ncs?t}t}dS||tdd}t|SdS(NssImagessgo_back_button.gif(s _getitem_s_getitems _getattr_s_getattrscontextsimagesstr(s _getitem_s_getitems _getattr_s_getattrscontextsimagesstr((sScript (Python)s goBackButtons(s goBackButton(s goBackButton((sScript (Python)ssq0U_bodyq1UKreturn "" image = context.Images['go_back_button.gif'] return str(image) q2U Script_magicq3KUwarningsq4)U func_defaultsq5NUerrorsq6)U Python_magicq7U* q8u.8p((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8rq(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU extra_formqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqT
Select what extras you want
CHECKED> Bold typed Cost: 50p
CHECKED> Framed Cost: 50p

qU_varsq}qu.8)((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U_write_q U_writeq U _getitem_q U_getitemq U _getattr_qU_getattrqUcontextqUrequestqU SubmitErrorqU all_photoidsqUfolderqUstrqUintqUrandstrqUcountqUrangeqUiUphotoqUaskedqUkeepqUgetattrqUNoneqUerr_msgqU p_descriptionq U tempphotoidq!Uphoto_max_bytesq"Ulenq#Upriceq$Usd_varq%Uld_varq&tU co_argcountq'KubU_paramsq(UUidq)U previewadq*U__ac_local_roles__q+}q,Upetbeq-]q.UOwnerq/asU_dav_writelocksq0(U8q1(U Persistenceq2UPersistentMappingq3ttQU _bind_namesq4(cShared.DC.Scripts.Bindings NameAssignments q5oq6}q7U_asgnsq8}q9(Uname_containerq:U containerq;U name_subpathqUcontextq?U name_m_selfq@UscriptqAusbU func_defaultsqBNU_codeqCTzcsdZdS(sA Upload the photos temporarily and upload the temporary photos c/st}t}t}d|td}h} g} | |ddo||ddjo ||d} nAt t |td} d| |tdf} d}xHtdd d r2}d |}d |}d |}||d|o||d|o^||d|t ||||| dt ||||d7}n&|!tdt |||nM|#|dd|o#$t||d|ddjo %t}&y'||dd|d}(|td||d|)| *|}|+|dd |||,| d|-|d7}Wn .dj o/d}n0dj o1d}n2dj o 3d|4td}n5dj o 6d|7td}n8d j o29d!|:td|;tdf}nI<d"j o=d#}n+>d$j o?d%@td&}nXB|o8|C|dd'||D|||d'||ltd=|k||sqDU_bodyqET""" Upload the photos temporarily and upload the temporary photos """ request = context.REQUEST SubmitError = {} # # 1. Upload temp photos # all_photoids=[] if request.has_key('photo_folder') and request['photo_folder']!='': folder = request['photo_folder'] else: randstr=str(int(context.ZopeTime())) folder = '%s_%s'%(randstr, context.generateRandomNumberString()) #folder = context.TimeFolder(folder) count = 1 for i in range(1,4): # shortcuts photo = 'photo%s_id'%count asked = 'asked_keep_photo%s_id'%i keep = 'keep_photo%s_id'%i # did this exists as a photo? if request.has_key(asked): if request.has_key(keep): request.set(photo, int(request[keep])) all_photoids.append(int(request[keep])) count += 1 else: # Been asked to keep it but didn't want to context.deleteTempPhoto(int(request[asked])) elif request.has_key('photo%s'%i) and \ getattr(request['photo%s'%i], 'filename')!='': err_msg=None try: p_description = request.get('photo_description%s'%i,'') tempphotoid = context.createTempPhoto(request['photo%s'%i], folder, p_description) request.set('photo%s_id'%count, tempphotoid) all_photoids.append(tempphotoid) count += 1 except "FileNotFile": err_msg = "File uploaded not a file" except "FileNotImage": err_msg = "Type of the file is not recognized as an image" except "PhotoTooHigh": err_msg = """Photo too high. Max. %s pixels high"""%context.photo_max_height except "PhotoTooWide": err_msg = """Photo too wide. Max. %s pixels wide"""%context.photo_max_width except "PhotoTooLarge": err_msg = """Photo too wide and high. Max. (%s, %s) pixel"""%(context.photo_max_width, context.photo_max_height) except "PhotoAlreadyThere": err_msg = """A photo with that name has already been uploaded""" except "FileTooBig": err_msg = """Photo too big. It can only be %s at the most"""%(photo_max_bytes/1024) if err_msg: request.set('photo%s_error'%i, err_msg) SubmitError['photo%s_error'%i]= err_msg if all_photoids: request.set('photo_folder', folder) request.set('all_photoids', all_photoids) # # 2. Check some input # if request.has_key('adverttitle') and request['adverttitle'].strip()!='': if len(request['adverttitle']) > context.maxlength_title: SubmitError['adverttitle']="""Title too long. Max %s characters"""%context.maxlength_title else: SubmitError['adverttitle']="The title can not be empty" if request.has_key('price') and request['price']!= '': price = str(request['price']).strip().replace(' ','').replace(',','.') request.set('price', price) if not context.validPrice(request['price']): SubmitError['price'] ="Price not a number" sd_var = 'short_description' if request.has_key(sd_var) and request[sd_var].strip()!='': if len(request[sd_var]) > context.maxlength_short_description: SubmitError[sd_var]="Short description too long. \ Max %s characters"%context.maxlength_short_description else: request.set(sd_var, context.RemoveTooManyLineBreaks(request[sd_var], max=8)) else: SubmitError[sd_var]="The short description can not be empty" ld_var = 'long_description' if request.has_key(ld_var) and request[ld_var].strip()!='': if len(request[ld_var]) > context.maxlength_long_description: SubmitError[ld_var]="""Long description too long. Max %s characters"""%context.maxlength_long_description # # 3. Tune some data # if request.has_key('extra_bold'): request.set('ns_bold', 1) else: request.set('ns_bold', 0) if request.has_key('extra_frame'): request.set('ns_frame', 1) else: request.set('ns_frame', 0) if request.has_key('extra_highlight'): request.set('ns_highlight', 1) else: request.set('ns_highlight', 0) if SubmitError: return context.placead.index_html(context, request, SubmitError=SubmitError) else: request.set('preview_ad_now',1) return context.placead.index_html(context, request) qFU Script_magicqGKUwarningsqH)U_ownerqI(]qJU acl_usersqKah-tqLUerrorsqM)U Python_magicqNU* qOu.9>((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q Umake_payment_formq Utitleq UUglobalsq }qU_ownerq(]qU acl_usersqahtqUrawqUqU_varsq}qu.9'((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q Uterms_and_conditionsq Utitleq UUglobalsq }qU_ownerq(]qU acl_usersqahtqUrawqU I agree to the
">terms and conditionsqU_varsq}qu.8((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qUlist_categories_selectionqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqT
      " class="categorytab">
 
   ">     

 
qU_varsq}qu.8((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU place_ad_formqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqTi
" method="post" name="f" enctype="multipart/form-data">

qU_varsq}qu.8F((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q Ucontact_details_warningq Utitleq UUglobalsq }qU_ownerq(]qU acl_usersqahtqUrawqUp
! You didn't forget to give your contact details did you?
qU_varsq}qu.9((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U9q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qUsubmit_ad_formqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqU
">
qU_varsq}qu.8 ((U OFS.FolderqUFolderqtqNt.}q(USelectAllCategoriesq(U6q(UProducts.ZSQLMethods.SQLqUSQLqttQUidq U Categoriesq U__ac_local_roles__q }q Upetbeq ]qUOwnerqasU_objectsq(}q(U meta_typeqU Z SQL Methodqh UDeleteCategoryqu}q(hhh UInsertCategoryqu}q(hhh hu}q(hhh USelectCategoryqu}q(hhh USelectChildrenCategoriesqu}q(hhh USelectRootCategoriesqu}q(hhh UUpdateCategoryqutUUpdateCategoryq (U7q!(hUSQLq"ttQUSelectRootCategoriesq#(U6q$(hUSQLq%ttQUSelectCategoryq&(U6q'(hUSQLq(ttQUDeleteCategoryq)(U6q*(hUSQLq+ttQUtitleq,UUInsertCategoryq-(U6~q.(hUSQLq/ttQUSelectChildrenCategoriesq0(U6q1(hUSQLq2ttQu.8((U OFS.FolderqUFolderqtqNt.}q(U SelectPhotoq(U8q(UProducts.ZSQLMethods.SQLqUSQLqttQUidq U TempPhotosq U__ac_local_roles__q }q Upetbeq ]qUOwnerqasU InsertPhotoq(U8q(hUSQLqttQU_objectsq(}q(U meta_typeqU Z SQL Methodqh hu}q(U meta_typeqU Z SQL MethodqUidqhu}q(U meta_typeqU Z SQL MethodqUidqU SelectPhotosqu}q (U meta_typeq!U Z SQL Methodq"Uidq#U DeletePhotoq$utUtitleq%UU SelectPhotosq&(U8q'(hUSQLq(ttQh$(U8q)(hUSQLq*ttQu.9;((U OFS.FolderqUFolderqtqNt.}q(UtitleqUUidqUAdvertsqU__ac_local_roles__q}q Upetbeq ]q UOwnerq asU InsertAdvertq (U9
 
qU_varsq}qu.9 t((U OFS.FolderqUFolderqtqNt.}q(UtitleqUUidqU DocumentsqU__ac_local_roles__q}q Upetbeq ]q UOwnerq asu.9v((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U9q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU index_htmlqUtitleqUUglobalsq}qUrawqT


//" width="" height="" alt="" />

Error

No photo
qU_varsq}qu.9((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U _getitem_q U_getitemq U _getattr_q U_getattrq UcontextqUrequestqtqU co_argcountqKubU_paramsqUUidqUgetPhotoInformationqU__ac_local_roles__q}qUpetbeq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq}q(Uname_containerq U containerq!U name_subpathq"Utraverse_subpathq#U name_contextq$hU name_m_selfq%Uscriptq&usbU func_defaultsq'NU_codeq(TcsdZdS(NcsJt}t}|td}||td||ddSdS(NsREQUESTsgetPhotosphotoidi(s _getitem_s_getitems _getattr_s_getattrscontextsrequest(s _getitem_s_getitems _getattr_s_getattrscontextsrequest((sScript (Python)sgetPhotoInformations(sgetPhotoInformation(sgetPhotoInformation((sScript (Python)ssq)U_bodyq*UKrequest = context.REQUEST return context.getPhoto(request['photoid'])[0] q+U Script_magicq,KUwarningsq-)Uerrorsq.)U Python_magicq/U* q0u.6{((U OFS.FolderqUFolderqtqNt.}q(Umanage_addCategoryq(U6q(U#Products.PythonScripts.PythonScriptqU PythonScriptqttQUidq UManageCategoriesq U__ac_local_roles__q }q Ugrahameq ]qUOwnerqasU_objectsq(}q(U meta_typeqU DTML MethodqUidqU index_htmlqu}q(hhhUadd_category_formqu}q(hUScript (Python)qhhu}q(U meta_typeqU DTML MethodqUidqUlist_categoriesqu}q(U meta_typeq U DTML Methodq!Uidq"Udelete_category_formq#u}q$(U meta_typeq%UScript (Python)q&Uidq'Umanage_deleteCategoryq(u}q)(U meta_typeq*U DTML Methodq+Uidq,Uedit_category_formq-u}q.(U meta_typeq/UScript (Python)q0Uidq1Umanage_editCategoryq2utUmanage_deleteCategoryq3(U6q4(hU PythonScriptq5ttQh-(U7q6(UOFS.DTMLMethodq7U DTMLMethodq8ttQh2(U7q9(hU PythonScriptq:ttQU index_htmlq;(U6q<(h7U DTMLMethodq=ttQh#(U6q>(h7U DTMLMethodq?ttQh(U6q@(h7U DTMLMethodqAttQUtitleqBUManage categoriesqCh(U6qD(h7U DTMLMethodqEttQu.8!((U OFS.FolderqUFolderqtqNt.}q(UidqUPhotosqUClearAllPhotosq(U8q(U#Products.PythonScripts.PythonScriptq U PythonScriptq ttQU__ac_local_roles__q }q Upetbeq ]qUOwnerqasU_objectsq(}q(U meta_typeqUScript (Python)qhhutUtitleqUU_ownerq(]qU acl_usersqah tu.9)((U OFS.FolderqUFolderqtqNt.}q(Uexplain_submit_errorsq(U9-q(UOFS.DTMLMethodqU DTMLMethodqttQU index_htmlq (U9*q (hU DTMLMethodq ttQUidq U SendPasswordq U__ac_local_roles__q}qUpetbeq]qUOwnerqasU_objectsq(}q(U meta_typeqU DTML Methodqh U index_htmlqu}q(U meta_typeqU DTML MethodqUidqhu}q(hhhU password_formqutUtitleqUForgotten passwordqh(U9.q (hU DTMLMethodq!ttQu.9/((U OFS.FolderqUFolderqtqNt.}q(UtitleqUTerms and conditionsqU Submissionq(U90q(hUFolderq ttQUidq UTCq U__ac_local_roles__q }q Upetbeq]qUOwnerqasU_objectsq(}q(U meta_typeqUFolderqUidqU Submissionqutu.6h>((U OFS.FolderqUFolderqtqNt.}q(UidqU CreateTablesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_objectsq (}q (U meta_typeqU Z SQL MethodqhU UserTablequ}q(hhhU AdvertTablequ}q(hhhU CategoryTablequ}q(hhhU PhotoTablequ}q(U meta_typeqU Z SQL MethodqUidqUTempPhotoTablequ}q(U meta_typeqU Z SQL MethodqUidqUTempAdvertTableq uth(U6lq!(UProducts.ZSQLMethods.SQLq"USQLq#ttQh(U6kq$(h"USQLq%ttQh(U6iq&(h"USQLq'ttQh(U6jq((h"USQLq)ttQh(U8q*(h"USQLq+ttQUtitleq,Uh (U8q-(h"USQLq.ttQu.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8eB((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8IB((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.9%B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.9"B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.9B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8tB((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8hB((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8rB((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.9B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.6'((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUSelectAllCategoriesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqU6SELECT * FROM categories ORDER BY parent_id, nameqU_colq]q(}q(UnameqU categoryidqUtypeqUiUnullqKUwidthqKu}q(hUnameqhUthKhKu}q(hUurl_nameqhUthKhKu}q(hU parent_idqhUihKhKu}q(hUno_free_photosqhUihKhKu}q (hUns_require_agecheckq!hUthKhKu}q"(hU create_timeq#hUdhKhKu}q$(hU change_timeq%hUdhKhKueUtemplateq&cShared.DC.ZRDB.DA SQL q'NRq(}q)(U__name__q*Uq+Uglobalsq,}q-Urawq.hU_varsq/}q0ubUtitleq1UU_ownerq2(]q3U acl_usersq4aUgrahameq5tq6U_argq7(cShared.DC.ZRDB.Aqueduct Args q8oq9}q:(U_keysq;]qubU arguments_srcq?Uu.7((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUUpdateCategoryqU connection_idqUMySQL_database_connectionqU__ac_local_roles__q }q Upetbeq ]q UOwnerq asUtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqTUPDATE categories SET name = , parent_id = , color = , lightcolor = , no_free_photos = , ns_require_agecheck = , change_time = now() WHERE qU_varsq}qubUsrcqhU_ownerq(]qU acl_usersqah tqU_argq (cShared.DC.ZRDB.Aqueduct Args q!oq"}q#(U_keysq$]q%(Uidq&Unameq'U parent_idq(Uno_free_photosq)Uns_require_agecheckq*Ucolorq+U lightcolorq,eU_dataq-}q.(h&}q/h)}q0h+}q1h'}q2h,}q3h(}q4h*}q5uubU arguments_srcq6UKid name parent_id no_free_photos ns_require_agecheck color lightcolorq7u.6R((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUSelectRootCategoriesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqU`SELECT * FROM categories WHERE parent_id is NULL ORDER BY ns_require_agecheck, name ASCqU_colq]q(}q(UnameqU categoryidqUtypeqUiUnullqKUwidthqKu}q(hUnameqhUthKhKu}q(hUurl_nameqhUthKhKu}q(hU parent_idqhUihKhKu}q(hUno_free_photosqhUihKhKu}q (hUns_require_agecheckq!hUthKhKu}q"(hU create_timeq#hUdhKhKu}q$(hU change_timeq%hUdhKhKueUtemplateq&cShared.DC.ZRDB.DA SQL q'NRq(}q)(U__name__q*Uq+Uglobalsq,}q-Urawq.hU_varsq/}q0ubUtitleq1UU_ownerq2(]q3U acl_usersq4aUgrahameq5tq6U_argq7(cShared.DC.ZRDB.Aqueduct Args q8oq9}q:(U_keysq;]qubU arguments_srcq?Uu.6((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUSelectCategoryqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqU`SELECT * FROM categories WHERE qU_colq]q(}q(UnameqU categoryidqUtypeqUiUnullqKUwidthqKu}q(hUnameqhUthKhKu}q(hUurl_nameqhUthKhKu}q(hU parent_idqhUihKhKu}q(hUno_free_photosqhUihKhKu}q (hUns_require_agecheckq!hUthKhKu}q"(hU create_timeq#hUdhKhKu}q$(hU change_timeq%hUdhKhKu}q&(hUcolorq'hUthKhKu}q((hU lightcolorq)hUthKhKueUtemplateq*cShared.DC.ZRDB.DA SQL q+NRq,}q-(U__name__q.Uq/Uglobalsq0}q1Urawq2hU_varsq3}q4ubUtitleq5UU_ownerq6(]q7U acl_usersq8aUgrahameq9tq:U_argq;(cShared.DC.ZRDB.Aqueduct Args q(U_keysq?]q@UidqAaU_dataqB}qChA}qDsubU arguments_srcqEhAu.6((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUDeleteCategoryqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qUidqaU_dataq}qh}qsubU connection_idqUMySQL_database_connectionqUtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}q Urawq!U]DELETE FROM categories WHERE q"U_varsq#}q$ubU_ownerq%(]q&U acl_usersq'aUgrahameq(tq)Usrcq*h"U arguments_srcq+hu.6~.((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUInsertCategoryqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(UnameqUurl_nameqU parent_idqUno_free_photosqUns_require_agecheckqeU_dataq}q(h}qh}qh}qh}qh}quubU connection_idqUMySQL_database_connectionqUtitleq UUtemplateq!cShared.DC.ZRDB.DA SQL q"NRq#}q$(U__name__q%Uq&Uglobalsq'}q(Urawq)TINSERT INTO categories ( name, url_name, parent_id, no_free_photos, ns_require_agecheck, create_time, change_time ) VALUES ( , , NULL , 0 , 1 0 , now(), now() ) q*U_varsq+}q,ubU_ownerq-(]q.U acl_usersq/aUgrahameq0tq1Usrcq2h*U arguments_srcq3U>name url_name parent_id no_free_photos ns_require_agecheckq4u.6E((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUSelectChildrenCategoriesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU parent_idqaU_dataq}qh}qsubU connection_idqUMySQL_database_connectionqUtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}q Urawq!UwSELECT * FROM categories WHERE ORDER BY nameq"U_varsq#}q$ubU_ownerq%(]q&U acl_usersq'aUgrahameq(tq)Usrcq*h"U arguments_srcq+hu.8((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU SelectPhotoqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qUidqaU_dataq}qh}qsubU connection_idqUMySQL_database_connectionqU_colq]q(}q(UnameqU tempphotoidqUtypeqUiUnullqKUwidthqKu}q (hUphoto_descriptionq!hUthKhKu}q"(hUfolderq#hUthKhKu}q$(hUphoto_filenameq%hUthKhK u}q&(hU photo_widthq'hUihKhKu}q((hU photo_heightq)hUihKhKu}q*(hUthumbnail_filenameq+hUthKhKu}q,(hUthumbnail_widthq-hUihKhKu}q.(hUthumbnail_heightq/hUihKhKu}q0(hU create_timeq1hUdhKhKu}q2(hU change_timeq3hUdhKhKueUtemplateq4cShared.DC.ZRDB.DA SQL q5NRq6}q7(U__name__q8Uq9Uglobalsq:}q;Urawqq=U_varsq>}q?ubUtitleq@UU arguments_srcqAhUsrcqBh=u.8((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU InsertPhotoqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(Uphoto_descriptionqUfolderqUphoto_filenameqU photo_widthqU photo_heightqUthumbnail_filenameqUthumbnail_widthqUthumbnail_heightqeU_dataq}q(h}qh}qh}qh}qh}q h}q!h}q"h}q#uubU connection_idq$UMySQL_database_connectionq%Utitleq&UUtemplateq'cShared.DC.ZRDB.DA SQL q(NRq)}q*(U__name__q+Uq,Uglobalsq-}q.Urawq/TZINSERT INTO temp_photos SET photo_description = , folder = , photo_filename = , photo_width = , photo_height = , thumbnail_filename = , thumbnail_width = , thumbnail_height = , create_time = now(), change_time = now() SELECT tempphotoid FROM temp_photos WHERE photo_filename = AND folder = q0U_varsq1}q2ubU arguments_srcq3U{photo_description folder photo_filename photo_width photo_height thumbnail_filename thumbnail_width thumbnail_heightq4Usrcq5h0u.8((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU SelectPhotosqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqUSELECT * FROM temp_photos WHERE tempphotoid = OR qU_colq]q(}q(UnameqU tempphotoidqUtypeqUiUnullqKUwidthqKu}q(hU tempadvertidqhUihKhKu}q(hUphoto_descriptionqhUthKhKu}q(hU photo_pathqhUthKhKu}q(hU photo_widthqhUihKhKu}q (hU photo_heightq!hUihKhKu}q"(hUthumbnail_pathq#hUthKhKu}q$(hUthumbnail_widthq%hUihKhKu}q&(hUthumbnail_heightq'hUihKhKu}q((hU create_timeq)hUdhKhKu}q*(hU change_timeq+hUdhKhKueUtemplateq,cShared.DC.ZRDB.DA SQL q-NRq.}q/(U__name__q0Uq1Uglobalsq2}q3Urawq4hU_varsq5}q6ubUtitleq7UU arguments_srcq8Uidsq9U_argq:(cShared.DC.ZRDB.Aqueduct Args q;oq<}q=(U_keysq>]q?h9aU_dataq@}qAh9}qBsubu.8((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU DeletePhotoqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUJDELETE FROM temp_photos WHERE tempphotoid = qU_varsq}qubUsrcqhU arguments_srcqUidqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#haU_dataq$}q%h}q&subu.9<a((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU InsertAdvertqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(UuseridqU categoryidqU adverttitleqUpriceqUshort_descriptionqUlong_descriptionqUns_boldqUns_frameqU ns_highlightqU ns_moderatedqUpaidfor_until_timeqeU_dataq}q(h}qh}q h}q!h}q"h}q#h}q$h}q%h}q&h}q'h}q(h}q)uubU connection_idq*UMySQL_database_connectionq+Utitleq,UUtemplateq-cShared.DC.ZRDB.DA SQL q.NRq/}q0(U__name__q1Uq2Uglobalsq3}q4Urawq5TkINSERT INTO adverts ( userid, categoryid, adverttitle, price, short_description, long_description, ns_bold, ns_frame, ns_highlight, ns_moderated, paidfor_until_time, create_time, change_time ) VALUES ( , , , , , , '1' '0' , '1' '0' , '1' '0' , '1' '0' , '2000-01-01 00:00:01' , now(), now() ) SELECT advertid FROM adverts WHERE userid = AND categoryid = AND adverttitle = AND short_description = q6U_varsq7}q8ubU arguments_srcq9Uuserid categoryid adverttitle price short_description long_description ns_bold ns_frame ns_highlight ns_moderated paidfor_until_timeq:Usrcq;h6u.9((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU SelectPhotoqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUCSELECT * FROM photos WHERE photoid = qU_varsq}qubUsrcqhU arguments_srcqUidqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#haU_dataq$}q%h}q&subu.9P((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU InsertPhotoqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqT{INSERT INTO photos SET advertid = , photo_description = , folder = , photo_filename = , photo_width = , photo_height = , thumbnail_filename = , thumbnail_width = , thumbnail_height = , create_time = now(), change_time = now() SELECT photoid FROM photos WHERE photo_filename = AND folder = qU_varsq}qubUsrcqhU arguments_srcqUadvertid photo_description folder photo_filename photo_width photo_height thumbnail_filename thumbnail_width thumbnail_heightqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#(Uadvertidq$Uphoto_descriptionq%Ufolderq&Uphoto_filenameq'U photo_widthq(U photo_heightq)Uthumbnail_filenameq*Uthumbnail_widthq+Uthumbnail_heightq,eU_dataq-}q.(h+}q/h)}q0h$}q1h*}q2h&}q3h,}q4h%}q5h'}q6h(}q7uubu.9((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU SelectPhotosqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqUSELECT * FROM photos WHERE photoid = OR qU_colq]q(}q(UnameqU tempphotoidqUtypeqUiUnullqKUwidthqKu}q(hU tempadvertidqhUihKhKu}q(hUphoto_descriptionqhUthKhKu}q(hU photo_pathqhUthKhKu}q(hU photo_widthqhUihKhKu}q (hU photo_heightq!hUihKhKu}q"(hUthumbnail_pathq#hUthKhKu}q$(hUthumbnail_widthq%hUihKhKu}q&(hUthumbnail_heightq'hUihKhKu}q((hU create_timeq)hUdhKhKu}q*(hU change_timeq+hUdhKhKueUtemplateq,cShared.DC.ZRDB.DA SQL q-NRq.}q/(U__name__q0Uq1Uglobalsq2}q3Urawq4hU_varsq5}q6ubUtitleq7UU arguments_srcq8Uidsq9U_argq:(cShared.DC.ZRDB.Aqueduct Args q;oq<}q=(U_keysq>]q?h9aU_dataq@}qAh9}qBsubu.9((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU DeletePhotoqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUADELETE FROM photos WHERE photoid = qU_varsq}qubUsrcqhU arguments_srcqUidqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#haU_dataq$}q%h}q&subu.8G((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU InsertAdvertqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(UuseridqU categoryidqU adverttitleqUpriceqUshort_descriptionqUlong_descriptionqUns_boldqUns_frameqU ns_highlightqeU_dataq}q(h}qh}qh}qh}q h}q!h}q"h}q#h}q$h}q%uubU connection_idq&UMySQL_database_connectionq'U_colq()Utemplateq)cShared.DC.ZRDB.DA SQL q*NRq+}q,(U__name__q-Uq.Uglobalsq/}q0Urawq1TINSERT INTO temp_adverts SET userid=, categoryid = , adverttitle = , price = , short_description = , long_description = , ns_bold = 1, ns_bold = 0, ns_frame = 1, ns_frame = 0, ns_highlight = 1, ns_highlight = 0, create_time = now(), change_time = now() SELECT LAST_INSERT_ID(tempadvertid) FROM temp_adverts WHERE categoryid = AND adverttitle = q2U_varsq3}q4ubUtitleq5UU arguments_srcq6Uluserid categoryid adverttitle price short_description long_description ns_bold ns_frame ns_highlightq7Usrcq8h2u.8((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU SelectAdvertqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUNSELECT * FROM temp_adverts WHERE tempadvertid = qU_varsq}qubUsrcqhU arguments_srcqUidqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#haU_dataq$}q%h}q&subu.98v((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU SelectUserqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUSELECT * FROM users WHERE UPPER(email_address) = UPPER() userid = qU_varsq}qubUsrcqhU arguments_srcqUid email_addressqU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#(Uidq$U email_addressq%eU_dataq&}q'(h$}q(h%}q)uubu.97'((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU InsertUserqU__ac_local_roles__q}qUpetbeq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]q(U email_addressqUpasswordqeU_dataq}q(h}qh}quubU connection_idqUMySQL_database_connectionqUtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUq Uglobalsq!}q"Urawq#T`INSERT INTO users (email_address, password, create_time, change_time) VALUES ( , , now(), now() ) SELECT userid FROM users WHERE email_address = AND password = q$U_varsq%}q&ubU arguments_srcq'Uemail_address passwordq(Usrcq)h$u.6}((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqURootCategoriesqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU cache_time_q KU max_rows_q MU_colq]q(}q(UnameqU categoryidqUtypeqUiUnullqKUwidthqKu}q(hUnameqhUthKhKu}q(hUurl_nameqhUthKhKu}q(hU parent_idqhUihKhKu}q(hUno_free_photosqhUihKhKu}q(hUns_require_agecheckqhUthKhKu}q (hU change_timeq!hUdhKhKueUtemplateq"cShared.DC.ZRDB.DA SQL q#NRq$}q%(U__name__q&Uq'Uglobalsq(}q)Urawq*USELECT categoryid, name, url_name, parent_id, no_free_photos, ns_require_agecheck, create_time change_time FROM categories WHERE parent_id IS NULLq+U_varsq,}q-ubU max_cache_q.KdU class_name_q/UU_argq0(cShared.DC.ZRDB.Aqueduct Args q1oq2}q3(U_keysq4]q5U_dataq6}q7ubU connection_idq8UMySQL_database_connectionq9Utitleq:UU class_file_q;UU#allow_simple_one_argument_traversalqh+u.8 B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.9B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.6 ((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (Unameq U parent_idq Uno_free_photosq Uns_require_agecheckq UcolorqU lightcolorqU_write_qU_writeqU _getattr_qU_getattrqUcontextqUrequestqU SubmitErrorqUurl_nameqUurlqUparamsqtU co_argcountqKubU_paramsqUdname, parent_id=None, no_free_photos=0, ns_require_agecheck=0, color='#FFFFFF', lightcolor='#FFFFFF'qUidqUmanage_addCategoryqU__ac_local_roles__q}q Ugrahameq!]q"UOwnerq#asU_dav_writelocksq$(U6q%(U Persistenceq&UPersistentMappingq'ttQU _bind_namesq((cShared.DC.Scripts.Bindings NameAssignments q)oq*}q+U_asgnsq,}q-(Uname_containerq.U containerq/U name_subpathq0Utraverse_subpathq1U name_m_selfq2Uscriptq3U name_contextq4Ucontextq5usbU func_defaultsq6(NKKU#FFFFFFq7h7tq8U_codeq9Tkcs"tdddddZdS(Nis#FFFFFFcsot}t} | td} h} | td|} |  tdd|d| d |d |d |d |d || | td d }h}d ||d<| | ddd||d<| | ddd||d<| | ddd||d<| td||}| | | dd|dS(NsREQUESTsurl_encode_namescreateCategorysnamesurl_names parent_idsno_free_photossns_require_agecheckscolors lightcolorsManageCategoriess absolute_urlsCategory added.smsgsgetisgetRedirectURLsRESPONSEsredirect(s_write_s_writes _getattr_s_getattrscontextsrequests SubmitErrorsnamesurl_names parent_idsno_free_photossns_require_agecheckscolors lightcolorsurlsparams(snames parent_idsno_free_photossns_require_agecheckscolors lightcolors_write_s_writes _getattr_s_getattrscontextsrequests SubmitErrorsurl_namesurlsparams((sScript (Python)smanage_addCategorys     %%%!(sNonesmanage_addCategory(sNonesmanage_addCategory((sScript (Python)ssq:U_bodyq;Trequest = context.REQUEST SubmitError = {} url_name = context.url_encode_name(name) context.createCategory(name=name, url_name=url_name, parent_id=parent_id, no_free_photos=no_free_photos, ns_require_agecheck=ns_require_agecheck, color=color, lightcolor=lightcolor ) url = context.ManageCategories.absolute_url() params ={} params['msg']="Category added." params['parent_id'] = request.get('parent_id',0) params['no_free_photos'] = request.get('no_free_photos',0) params['ns_require_agecheck'] = request.get('ns_require_agecheck', 0) url = context.getRedirectURL(url, params) request.RESPONSE.redirect(url) #return context.ManageCategories(context, request) q)Uerrorsq?)U Python_magicq@U* qAu.6((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (Udelete_category_idq U_write_q U_writeq U _getattr_q U_getattrqUcontextqUurlqUparamsqtqU co_argcountqKubU_paramsqUdelete_category_idqUidqUmanage_deleteCategoryqU__ac_local_roles__q}qUgrahameq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}q U_asgnsq!}q"(Uname_containerq#U containerq$U name_subpathq%Utraverse_subpathq&U name_m_selfq'Uscriptq(U name_contextq)Ucontextq*usbU func_defaultsq+NU_codeq,TcsdZdS(Ncst}t}|td|||tdd}h}d||d<|td||}||| tddd |dS( NsdeleteCategorysManageCategoriess absolute_urlsCategory deletedsmsgsgetRedirectURLsREQUESTsRESPONSEsredirect(s_write_s_writes _getattr_s_getattrscontextsdelete_category_idsurlsparams(sdelete_category_ids_write_s_writes _getattr_s_getattrscontextsurlsparams((sScript (Python)smanage_deleteCategorys " $(smanage_deleteCategory(smanage_deleteCategory((sScript (Python)ssq-U_bodyq.Ucontext.deleteCategory(delete_category_id) url = context.ManageCategories.absolute_url() params={} params['msg']="Category deleted" url = context.getRedirectURL(url, params) context.REQUEST.RESPONSE.redirect(url) q/U Script_magicq0KUwarningsq1)Uerrorsq2)U Python_magicq3U* q4u.7((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U7q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qUedit_category_formqUtitleqUUglobalsq}qU_ownerq(]qU acl_usersqah tqUrawqTl
">
Name: " size="40">
Above category:
No. free photos: " size="1">
Require age check: CHECKED>
Color: " size="8">
Lightcolor: " size="8">
 
qU_varsq}qu.7((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U categoryidq Unameq U parent_idq Uno_free_photosq Uns_require_agecheckqUcolorqU lightcolorqUREQUESTqU_write_qU_writeqU _getitem_qU_getitemqU _getattr_qU_getattrqUcontextqUrequestqUNoneqUrecordqUurl_nameqUurlqUparamsqtqU co_argcountq KubU_paramsq!Ucategoryid, name=None, parent_id=None, no_free_photos=None, ns_require_agecheck=None, color=None, lightcolor=None, REQUEST=Noneq"Uidq#Umanage_editCategoryq$U__ac_local_roles__q%}q&Upetbeq']q(UOwnerq)asU_dav_writelocksq*(U7q+(U Persistenceq,UPersistentMappingq-ttQU _bind_namesq.(cShared.DC.Scripts.Bindings NameAssignments q/oq0}q1U_asgnsq2}q3(Uname_containerq4U containerq5U name_subpathq6Utraverse_subpathq7U name_m_selfq8Uscriptq9U name_contextq:Ucontextq;usbU_ownerq<(]q=U acl_usersq>ah'tq?U_codeq@Tcs(tttttttdZdS(Nc!st} t} t} | td}|t jo| |ddo d}n| | td|d}|t jo( | |d} | |d}n | td|}|t jo| |d }n|t jo| |d }n| td d |d|d|d |d |d |d|d|| | tdd}h}d| |d< | td||}"|t j o#| | #|dd|ndS(NsREQUESTshas_keysns_require_agecheck_askedis getCategorysnamesurl_namesurl_encode_names parent_idsno_free_photoss editCategorysidsns_require_agecheckscolors lightcolorsManageCategoriess absolute_urlsCategory edited.smsgsgetRedirectURLsRESPONSEsredirect(s_write_s_writes _getitem_s_getitems _getattr_s_getattrscontextsrequestsns_require_agechecksNones categoryidsrecordsnamesurl_names parent_idsno_free_photosscolors lightcolorsurlsparamssREQUEST(s categoryidsnames parent_idsno_free_photossns_require_agecheckscolors lightcolorsREQUESTs_write_s_writes _getitem_s_getitems _getattr_s_getattrscontextsrequestsNonesrecordsurl_namesurlsparams((sScript (Python)smanage_editCategorys0$& !      (sNonesmanage_editCategory(sNonesmanage_editCategory((sScript (Python)ssqAU_bodyqBTrequest = context.REQUEST if ns_require_agecheck is None and request.has_key('ns_require_agecheck_asked'): ns_require_agecheck = 0 record = context.getCategory(categoryid)[0] if name is None: name = record.name url_name = record.url_name else: url_name = context.url_encode_name(name) if parent_id is None: parent_id = record.parent_id if no_free_photos is None: no_free_photos = record.no_free_photos context.editCategory(id=categoryid, name=name, url_name=url_name, parent_id=parent_id, no_free_photos=no_free_photos, ns_require_agecheck=ns_require_agecheck, color=color, lightcolor=lightcolor ) url = context.ManageCategories.absolute_url() params={} params['msg'] = "Category edited." url = context.getRedirectURL(url, params) if REQUEST is not None: request.RESPONSE.redirect(url) qCU Script_magicqDKUwarningsqE)U func_defaultsqF(NNNNNNNtqGUerrorsqH)U Python_magicqIU* qJu.6((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUgrahameq]qUOwnerq asU__name__q U index_htmlq Utitleq UUglobalsq }qUrawqT!


qU_varsq}qu.6((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U8q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asU__name__qUdelete_category_formqUtitleqUUglobalsq}qUrawqT
Delete category: ?
qU_varsq}qu.6\((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U6q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asU__name__qUadd_category_formqUtitleqUUglobalsq}qUrawqT`
Name: " size="40">
Above category:
No. free photos: " size="1">
Require age check: CHECKED>
Color: " size="8">
Lightcolor: " size="8">
 
qU_varsq}qu.6c((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U7q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Ugrahameq ]q UOwnerq asU__name__qUlist_categoriesqUtitleqUUglobalsq}qUrawqTi bgcolor="#efefef">
  Name   URL name Free photos Age check Color Light color
           yes 
       
       
qU_varsq}qu.8B((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U _getattr_q U_getattrq U_print_q U_printq U containerqUrequestqURESPONSEqUcontextqtqU co_argcountqKubU_paramsqUUidqUClearAllPhotosqU__ac_local_roles__q}qUpetbeq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq }q!(Uname_containerq"hU name_subpathq#Utraverse_subpathq$U name_contextq%hU name_m_selfq&Uscriptq'usbU func_defaultsq(NU_codeq)TKcsdZdS(Ncsgt}t}|td}||d}||tdIJ|dIJ|SdS(NsREQUESTsRESPONSEsSecurityGetUsersa(s _getattr_s_getattrs_print_s_prints containersrequestsRESPONSEscontext(s _getattr_s_getattrs_print_s_prints containersrequestsRESPONSEscontext((sScript (Python)sClearAllPhotoss! (sClearAllPhotos(sClearAllPhotos((sScript (Python)ssq*U_bodyq+Utrequest = container.REQUEST RESPONSE = request.RESPONSE print context.SecurityGetUser() print "a" return printed q,U Script_magicq-KUwarningsq.)Uerrorsq/)U Python_magicq0U* q1u.9-P((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q Uexplain_submit_errorsq Utitleq UUglobalsq }qUrawqU
  • :
qU_varsq}qu.9*((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U9+q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU index_htmlqUtitleqUUglobalsq}qUrawqU

Have you forgotten your password? We can send your old one to you or you can set up a new one right now

qU_varsq}qu.9.z((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U_dav_writelocksq(U93q(U PersistenceqUPersistentMappingqttQU__ac_local_roles__q }q Upetbeq ]q UOwnerq asU__name__qU password_formqUtitleqUUglobalsq}qUrawqT
" method="post">
Email: ">
  or  
New password
New password again

qU_varsq}qu.90`((U OFS.FolderqUFolderqtqNt.}q(U index_htmlq(U91q(UOFS.DTMLMethodqU DTMLMethodqttQUidq U Submissionq U__ac_local_roles__q }q Upetbeq ]qUOwnerqasU_objectsq(}q(U meta_typeqU DTML MethodqUidqU index_htmlqu}q(hhhU$submission_terms_and_conditions_textqutUtitleqUAdvert submissionqh(U92q(hU DTMLMethodqttQu.6l>((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU PhotoTableqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqTCREATE TABLE photos ( photoid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, advertid INT NOT NULL REFERENCES adverts, photo_description TEXT NOT NULL DEFAULT '', folder VARCHAR(255) NOT NULL, photo_filename VARCHAR(255) NOT NULL, photo_width INT NOT NULL, photo_height INT NOT NULL, thumbnail_filename VARCHAR(255) NULL, thumbnail_width INT NULL, thumbnail_height INT NULL, create_time DATETIME NOT NULL, change_time DATETIME NOT NULL )qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqUU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#U_dataq$}q%ubu.6k=((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU CategoryTableqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU_dataq}qubU connection_idqUMySQL_database_connectionqU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqTCREATE TABLE categories ( categoryid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL DEFAULT '', url_name VARCHAR(100) NOT NULL DEFAULT '', parent_id INT NULL, no_free_photos INT NOT NULL DEFAULT "0", ns_require_agecheck ENUM("1","0") DEFAULT "0", color VARCHAR(20) NOT NULL DEFAULT '#FFFFFF', lightcolor VARCHAR(20) NOT NULL DEFAULT '#FFFFFF', create_time DATETIME NOT NULL, change_time DATETIME NOT NULL )q U_varsq!}q"ubUtitleq#UU arguments_srcq$UUsrcq%h u.6iL((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU UserTableqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UtitleqUUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUCREATE TABLE users ( userid INT AUTO_INCREMENT NOT NULL PRIMARY KEY, email_address VARCHAR(100) NOT NULL, password VARCHAR(100) NOT NULL, create_time DATETIME NOT NULL, change_time DATETIME NOT NULL ) qU_varsq}qubUsrcqhU arguments_srcqUU_argq(cShared.DC.ZRDB.Aqueduct Args qoq}q (U_keysq!]q"U_dataq#}q$ubu.6j((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU AdvertTableqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqT8CREATE TABLE adverts ( advertid INT AUTO_INCREMENT NOT NULL PRIMARY KEY, userid INT NOT NULL REFERENCES users, categoryid INT NOT NULL REFERENCES categories, adverttitle VARCHAR(255) NOT NULL DEFAULT '', price FLOAT(4) NULL, short_description TEXT NOT NULL DEFAULT '', long_description TEXT NOT NULL DEFAULT '', ns_bold ENUM('1','0') DEFAULT '0', ns_frame ENUM("1","0") DEFAULT "0", ns_highlight ENUM("1","0") DEFAULT "0", ns_moderated ENUM("1","0") DEFAULT "0", paidfor_until_time DATETIME DEFAULT '2000-01-01 00:00:01', create_time DATETIME, change_time DATETIME )qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU arguments_srcqUU_argq(cShared.DC.ZRDB.Aqueduct Args qoq }q!(U_keysq"]q#U_dataq$}q%ubu.8I((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUTempPhotoTableqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqTCREATE TABLE temp_photos ( tempphotoid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, photo_description TEXT NOT NULL DEFAULT '', folder VARCHAR(255) NOT NULL, photo_filename VARCHAR(255) NOT NULL, photo_width INT NOT NULL, photo_height INT NOT NULL, thumbnail_filename VARCHAR(255) NULL, thumbnail_width INT NULL, thumbnail_height INT NULL, create_time DATETIME NOT NULL, change_time DATETIME NOT NULL )qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU_ownerq(]qU acl_usersqaUpetbeq tq!U_argq"(cShared.DC.ZRDB.Aqueduct Args q#oq$}q%(U_keysq&]q'U_dataq(}q)ubU arguments_srcq*Uu.8((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUTempAdvertTableqU__ac_local_roles__q}qUgrahameq ]q UOwnerq asU connection_idq UMySQL_database_connectionq UsrcqTCREATE TABLE temp_adverts ( tempadvertid INT AUTO_INCREMENT NOT NULL PRIMARY KEY, userid INT NULL, categoryid INT NOT NULL REFERENCES categories, adverttitle VARCHAR(255) NOT NULL DEFAULT '', price FLOAT(4) NULL, short_description TEXT NOT NULL DEFAULT '', long_description TEXT NOT NULL DEFAULT '', ns_bold ENUM('1','0') DEFAULT '0', ns_frame ENUM("1","0") DEFAULT "0", ns_highlight ENUM("1","0") DEFAULT "0", ns_moderated ENUM("1","0") DEFAULT "0", create_time DATETIME, change_time DATETIME )qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUU_ownerq(]qU acl_usersqaUpetbeq tq!U_argq"(cShared.DC.ZRDB.Aqueduct Args q#oq$}q%(U_keysq&]q'U_dataq(}q)ubU arguments_srcq*Uu.6B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.7B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.7B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.8B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.6B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.7B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.9+B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.93B((U PersistenceqUPersistentMappingqtqNt.}qU _containerq}qs.91S((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q U index_htmlq Utitleq UUglobalsq }qUrawqU

qU_varsq}qu.92((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUpetbeq]qUOwnerq asU__name__q U$submission_terms_and_conditions_textq Utitleq UUglobalsq }qUrawqUBla bla bla bla bla bla bqU_varsq}qu.