ALTER TABLE `link_clicks` ADD `user_ip` VARCHAR(16) NOT NULL DEFAULT '0' CREATE TABLE `system_email_templates` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `subject` varchar(255) NOT NULL default '', `content` text NOT NULL, `comment` varchar(255) NOT NULL default '', `from_name` varchar(255) NOT NULL default '', `from_email` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) );;; /*19*/ ALTER TABLE `form_fields` CHANGE `name` `name` VARCHAR(255) NOT NULL /*20*/ ALTER TABLE `email_campaigns` ADD `monitor_links` TINYINT NOT NULL DEFAULT '1';;; INSERT INTO `system_email_templates` VALUES (1, 'bounce notify', 'Bounce notify: {email}', 'This email is to notify you that the following email bounced\r\nwhen it was sent off from your etools:\r\n\r\n{email}\r\n\r\nPlease check your support desk under\r\ncontact manager -> bounce email manager to see how this email\r\nwas handled.', 'lib/bounce.php', '', 'noreply@{EMAIL_DOMAIN}');;; INSERT INTO `system_email_templates` VALUES (2, 'New user', 'New user signed up at mailer', 'See details at this page:\r\nhttp://{WWW_ROOT}/admin/contacts.php?form_id={form_id}&op=edit&id={contact_id}', 'users/thankyou.php', '', 'noreply@{EMAIL_DOMAIN}');;; INSERT INTO `system_email_templates` VALUES (3, 'profile modified', '{username} has modified their profile', '{username} has modified their profile.\r\nYou may get details here: http://{WWW_ROOT}/admin/contacts.php?op=edit&id={contact_id}&form_id={form_id}', 'users/profile.php', '', 'noreply@{EMAIL_DOMAIN}');;; INSERT INTO `system_email_templates` VALUES (4, 'profile modified2', '{username} has modified their profile', '{username} has modified their profile.\r\nYou may get details here: http://{WWW_ROOT}/admin/contacts.php?op=edit&id={contact_id}&form_id={form_id}', 'users/profile2.php', '', 'noreply@{EMAIL_DOMAIN}');;; INSERT INTO `system_email_templates` VALUES (5, 'statistics', 'Statistics from mail campaign', 'The campaign {campaign_name} has finished sending at {end}.\r\n Below are the statistics.\r\n\r\n Campaign Name: {campaign_name}\r\n Campaign ID: {id}\r\n Interest Group: {intgroups}\r\n Start Time: {start}\r\n Finish Time: {end}\r\n The total recipients: {sent}', 'admin/thread.php', '', 'noreply@{EMAIL_DOMAIN}');;; INSERT INTO `system_email_templates` VALUES (6, 'un-subscribed email', '{email} un-subscribed', 'The {email} has un-subscribed\r\nfrom your mailing system. You can review the following link at:\r\n\r\nhttp://{WWW_ROOT}/admin/contacts.php?form_id={form_id}&op=edit&id={contact_id}&user={adm_user}&password={pw}', 'users/unsubscribe.php', '', 'noreply@{WWW_ROOT}');;; INSERT INTO `system_email_templates` VALUES (7, 'validate email', 'Validate your email', '{f_text}\\n\\nhttp://{WWW_ROOT}/users/validate.php?id={hash}', 'admin/advanced_mgmt.php', '', '{f_from}');;; alter table config add admin_header_align varchar(32) not null default 'left' after admin_header, add admin_footer_align varchar(32) not null default 'left' after admin_footer;;; update navlinks set header='\0JFIF\0\0H\0H\0\0\0C\0\0C\0\0L\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0  \0I\0\0 \0\0\0!Q \"1#2AR$ab3BCc%4Sq&)D\0\0\0\0\0\0\0\0\0\0\0\0\0\0K\0 \0\0\0\0\0!A1Q\"2aq#R3BCSbr$4TsѣDc\0 \0\0?\0\0>49q>-8@v0nmF#oP+^ҩ{\0\0VZ5SZd{N}J{w=뫧|}\0 \0w;C@!|Hh?4\0 \0w;C@!|Hh?4\0 \0w;Cr^;o\0v^e\0ߠRy\'xNU,尥q̔#\"\"CeO\0\\c垊On@2!P% M]ؗg֋\"*sz]MVsj7\\tN-jRn&9ԋ(xزhԉ w.xc-F0 LGkW~!AWo/ ^ѧYj9EjY1T[Gq@ɜ\"MA\',Ɍ(\0UKP&@cZ~ъhmovQoog{3~zs׿,m)wje60iV@<#tVj :dňE\\{Fk\"QoUW-\'i[66.^oM1́f7x-pL\\Sī YT 6@\'NEo[#m`THw7=SzБͦϪn\0})W@n9떘hؗ;JOTﲠ:~fM7Rd8G&273P+W%V/!Ⱦ]\0r/@\"tȾ]\0r/@\"tȾ]\0r/@\"tȾ]\0r/@\"tȾ]\0r/@\"ts\0Oh*n$A[5OE1T;KKz}(\'%0Ǽ \"D&d!:nrn:clGdF~qZwoU#nj+P[qlNo=E\',&[O),X/x:iF:|%w/7):rʪ_cHlQe9(D՞ ]i%8(m8M(Z{*4ؙ?H_>J%_fUp-5LڐE3!Un\0nGZĖTjkGV*\"o⿆7>M-zr5^xnض?ʅ] J?>`W?.<ؘ R(k|[!bU?VܼR..tޔ591?3ڗo ) 7_U Ff#2ng`R(AQ%j0ƦT^T$Pm]i~5){,YxRǷ#!\"D򑍷?Ung/&Ype~/.l.`Q U4ԽU[#5??,]l]詊,S;FS/j4I3 }槉VYsjn<d&Vn]5ȪdF-νBʑXMnK$/_A`̋}UH:!߿]U\' :\"\0!R#ufJ}*\'o0eI-;0rkYoWH\"&Xߌ:M#h%iDTZCd,KzmjX$އ\0u-Cԋޡ0$z_(>*iA(B޸@qP_CX-c[W۟r$l=1lYp=mPJMPGy?%b\0X)~ZS#TTS0̢br\'8s(Co@E}tȾ\0_]\0r 7÷ߋo]\0ހ\"8 w!~b!L)6昉vUv!]\0@s1a :.\0e \0 JbNn)S @۟;0ۉT:_hcU O{g\"0:2Che!>\0h gr1~<|`h-t|JdTJs \0 ;rɘR:%g*WI^ҩxg8|?1h 2t<@fG \0(t@ y@GN:7H+%/.1Z7?xe\"%q%Wq @{$Ԩ\\|j fؔ^LG.Y]_uT]^Àp>%I;4yz[0MlxN!M9 F4f)xU;r~(/tafWh,xwzD|#}r9_ܺJۖE\'Eb>3㡞7PYWx6GIzDi7P5[S&umY$5 ̽dḼ +:,\09ZC͹ua d c$:PBix2v~½zi{zdzbijbn]usVY׍b8SH1KؗOsצ.m&\':l2ݓcC1fS*ܔ$ryTmBba[2sUӻDwR$%\\b1=d_Ȫ.zHu@\0 rUr(y% إB)I\"PUʪ rb)Pq! oYogf2uR^ŭ/_O O wܿ`oDzuJ e4\\MR! mq/(dR3meT\"d7=m!֏K1x/4Δ\"cIFEY (E=( 1 ;@P*DH9fjG0JA|@+; ĦVɑc$`QĂe8;*$u^\\gB` >}\"S3t,b+;\" ( ;﷞ C)c mcf`WM.HS jLL%Q3j`(@!w*vұ27\'%:勛U j (/%Ie$8 ;L,gj5ڬc!8Uk:@فP߃c},^|O ,f571YKNQ]Y 8hZndR .Pd~9ڏl\"\0G@]\0~\"н3}aLq=b26\"}l8T&xYs)ckx$mL0j;#gnG,o T8 dH:U޾HI2Q_9RJA?-AZ@WM̧t*ګ.}\'&MZ\'JN_!%Ȩ`97)R7@RP܃\'i HLô`+ 0- $_KVEn;Z\'8٩M#ј> _OaΗW28F-Oj@ KL#M)L\"S(:whXܲ jstJ QP ~ysuUr֩DwP7ٗKElD)ܑD[b( R.@ kvcQsU9Zw%bF=SM \'L\"˙j3cr˓KsvHRt ܟejaඹCE]muZ8QX/$ߊ][s®G.:`qvh ƌ3r쉤*COX p[wmkM^]CYomFÔ}dp8,..E\"7p[p m\0ya~Krҫ ZRu;=,WW]:C^/m WuiĤAe,۹QH6`.PJ\"1]^ljcl}jUin]Ͽ )V:%D\0\0w8 ՎeW i|TNt5ҚJ3J5rՠ5e4M% )TP*4i9f*;zzyC15jf)-V*M$Mv9/)A54Li~J0ښc,#G\"t$82HN}@hT?z%<\05Rףd2 fWٺ d3G%א>`Wv~aj\\ˆEK\\lK~ o vb@$ED `\'ONV銹^\'l3pYjPpB;Vb?=Uu?+>t?GQصRfilz:ic  /Unْ)*N$U]ie!gY5bUX\\JvYA1r nO qI=٨?t{IJ6!+EUe!hxTLwHZ.]øS&\" 5ցy(RY}ᣫ=CFμQ$XfƮG˓c6RHQkNx>|`eU/(#)\\;htڙ9R ҠĚN@U 0?R˧,+lSZFS.ѫym\0V+ozM}r{ h U)&s&-58[>,HT,|YJT~-IOvnȵVja>*L{vdeaaʔ7]8rNȪA})8G(91H~}rt ([ SG3 \0ZU~bt(ܻd\00q*.JwG/P饿1\\; c&m# u-H?tw eg69 6ʆ\0/.`>as^H#0̔nZ_5YWOW fp-۵E4 pp~Q@6 tiۑ^殡Ia+eP>\'@/R jfUya +bQC O\0F+tY}oekS4L5PyK3 ℱQVxۧwM3~[q>!UMqӴ0o.Z\0|uFZl IPp2-ZxڭdB˕[* ~Ԛ& =[\\+Xo~pT\'=u&uެ:U>y8nJ(G\"a\\l+.Q-B)7~N^#JM.dZt|) mhF Taaq6_X,7W8j.ABFZq3i]6ȴq܄ W*ֆSIt.e#K) fIЖ7ӄ{#Dh:U ?fxsى1;J U^%z&\".*UmM*)]޴,M[{Ln1J4j&iFjZ*Tbry$rQ2UF\\c͖?k&,T>׏oNTy5 zҏ.$ ˹? U^`r2qzSղu@fcH Mn8]R`} J>t&\"\"9S<SL\'t˜X\'!a-!զARn~`_/Ū#0ZZKzJ7\\N#P-qsS3Ư9ؾ֓$B1>u$ c\0v5)qeJ=N:UoTm[VXY\')%-8`mGox67>E\"6;}U;{D=u-z/odlm{ eBI5/u]j\"$WdJ9\'`b?g^K4Y1LWo\'xJXD&a>qUr27xdus `qU=.us[}8kDHΙ lc*3(Kڠ$½ O:3釩>} ٩KKc-8ڛɇ׋&F_=~߰#忐MBE}`ߞ]hU@KUpqm/ *Qv p -_ĆG,KKM،G3O.}y N\'gY_v!\" #/tUr\0 =O{=>V4̜܎UcUFwh_bݻUoBe< o@8 W cȧ;yݑ?Tm忄!>Sm[J?y,yf7;/\0-Qk8mYb7b=Z3dmM$P\"Ei\"]<& JO ʵ^1*N_,VwIݸljDP-[IUl6U}=/xО\\ \0o5ŝNq0n`C^cy\"O; \0\0 S\'̧O~>~oߠL2w.O\0R#\0!bD1:\\0rb Ѷ~A@bHoŠL^;;bP), >@ۏ!/7ZвVS/lGT N6 T+Ԫ%+NGK(>>bDžv*֘꺜̵ *f7y:4\"A\'6Pؑ`d F+6vFPX+\0WW/S32=2 zDbIc4L|$~ّp^?g/g=_~ei1Zrz=fO *cy2|>t\'af8vb4&8/1L\"(+I89w)Ϸ0W,/DΈ\\|[%PvR.SNS4Z!\\J-o+.yG(BCƨG; dz\018P*MoZ}Wiq,5]=Ey_)Șk9 M}tö[?W`֕N[\0 kC u\0(P6c6Jz2=JQT~b<Ȏv. &T#XܵZ[^jɖ*F0fVDMAUQnBݓ0S ٘1)S3խ߱S+Gi;^6Yh6N/.\'_ QRQQ+.) O4cFOK$*VD2*&VGfysC{;2܏ y;sוX!Pcgέ >W# r͜q);`%Lxm )\"s.ZSϗaУF4Y# ,\'tn~5^w~57F\0o\0xhltՄnjdu]J#F +׊f?t\'/p;j,xD>Ok0\"䢓U~ù`VU /\'B7]g°QNĺBe5TT_ߒ[ly%qZQ (6>wN$UELxtEC \'Ai@mSZ:vmZAHͺ]vr\0HQ:b֝UUi@,d