| | @@ -541,11 +541,10 @@ |
| 541 | 541 | blob_zero(&body); |
| 542 | 542 | blob_zero(&prompt); |
| 543 | 543 | } |
| 544 | 544 | else if( strncmp(zCmd, "settings", nCmd)==0 ){ |
| 545 | 545 | int isGlobal = find_option("global",0,0)!=0; |
| 546 | | - int i; |
| 547 | 546 | int nSetting; |
| 548 | 547 | const Setting *pSetting = setting_info(&nSetting); |
| 549 | 548 | db_open_config(1, 0); |
| 550 | 549 | verify_all_options(); |
| 551 | 550 | if( g.argc!=3 && g.argc!=5 ) usage("setting [NAME VALUE]"); |
| | @@ -667,11 +666,11 @@ |
| 667 | 666 | */ |
| 668 | 667 | void subscribe_page(void){ |
| 669 | 668 | int needCaptcha; |
| 670 | 669 | unsigned int uSeed; |
| 671 | 670 | const char *zDecoded; |
| 672 | | - char *zCaptcha; |
| 671 | + char *zCaptcha = 0; |
| 673 | 672 | char *zErr = 0; |
| 674 | 673 | int eErr = 0; |
| 675 | 674 | |
| 676 | 675 | login_check_credentials(); |
| 677 | 676 | if( !g.perm.EmailAlert ){ |
| | @@ -840,15 +839,12 @@ |
| 840 | 839 | Stmt q; |
| 841 | 840 | int sa, sc, st, sw; |
| 842 | 841 | int sdigest, sdonotcall, sverified; |
| 843 | 842 | const char *ssub; |
| 844 | 843 | const char *semail; |
| 845 | | - const char *sctime; |
| 846 | | - const char *smtime; |
| 847 | 844 | const char *smip; |
| 848 | 845 | const char *suname; |
| 849 | | - int i; |
| 850 | 846 | int eErr = 0; |
| 851 | 847 | char *zErr = 0; |
| 852 | 848 | |
| 853 | 849 | login_check_credentials(); |
| 854 | 850 | if( !g.perm.EmailAlert ){ |
| | @@ -917,12 +913,10 @@ |
| 917 | 913 | " semail," |
| 918 | 914 | " sverified," |
| 919 | 915 | " sdonotcall," |
| 920 | 916 | " sdigest," |
| 921 | 917 | " ssub," |
| 922 | | - " datetime(sctime)," |
| 923 | | - " datetime(smtime)," |
| 924 | 918 | " smip," |
| 925 | 919 | " suname" |
| 926 | 920 | " FROM subscriber WHERE subscriberCode=hextoblob(%Q)", zName); |
| 927 | 921 | if( db_step(&q)!=SQLITE_ROW ){ |
| 928 | 922 | db_finalize(&q); |
| | @@ -937,14 +931,12 @@ |
| 937 | 931 | ssub = db_column_text(&q, 4); |
| 938 | 932 | sa = strchr(ssub,'a')!=0; |
| 939 | 933 | sc = strchr(ssub,'c')!=0; |
| 940 | 934 | st = strchr(ssub,'t')!=0; |
| 941 | 935 | sw = strchr(ssub,'w')!=0; |
| 942 | | - sctime = db_column_text(&q, 5); |
| 943 | | - smtime = db_column_text(&q, 6); |
| 944 | | - smip = db_column_text(&q, 7); |
| 945 | | - suname = db_column_text(&q, 8); |
| 936 | + smip = db_column_text(&q, 5); |
| 937 | + suname = db_column_text(&q, 6); |
| 946 | 938 | if( !g.perm.Admin && !sverified ){ |
| 947 | 939 | db_multi_exec( |
| 948 | 940 | "UPDATE subscriber SET sverified=1 WHERE subscriberCode=hextoblob(%Q)", |
| 949 | 941 | zName); |
| 950 | 942 | @ <h1>Your email alert subscription has been verified!</h1> |
| 951 | 943 | |