]> git.ipfire.org Git - thirdparty/sarg.git/blobdiff - siteuser.c
Don't report clickable link for aliased url
[thirdparty/sarg.git] / siteuser.c
index 52cb2bd59b256c4ba6aba5e210d3019fced86662..09c220b4a17c2332d61019e9ccd8a472d73d8e7b 100644 (file)
@@ -1,10 +1,11 @@
 /*
- * AUTHOR: Pedro Lineu Orso                         pedro.orso@gmail.com
- *                                                            1998, 2008
  * SARG Squid Analysis Report Generator      http://sarg.sourceforge.net
+ *                                                            1998, 2011
  *
  * SARG donations:
  *      please look at http://sarg.sourceforge.net/donations.php
+ * Support:
+ *     http://sourceforge.net/projects/sarg/forums/forum/363374
  * ---------------------------------------------------------------------
  *
  *  This program is free software; you can redistribute it and/or modify
  */
 
 #include "include/conf.h"
+#include "include/defs.h"
 
-void siteuser()
+void siteuser(void)
 {
-
-   FILE *fp_in, *fp_ou;
-      
-   char user[MAXLEN];
-   char url[MAXLEN];
-   char wuser[MAXLEN];
-   char ourl[MAXLEN];
-   char nacc[20];
-   char nbytes[20];
-   char csort[255];
-   char geral[MAXLEN];
-   char geral2[MAXLEN];
-   char per[MAXLEN];
-   char html[MAXLEN];
-   char sites[MAXLEN];
-   char report[MAXLEN];
-   char periodo[100];
-   char ftime[128];
-   int regs=0;
-   int ucount=0;
-   char *users;
-
-   sprintf(geral,"%s/geral",dirname);
-   sprintf(sites,"%s/sites",dirname);
-   sprintf(geral2,"%s/geral2",dirname);
-   sprintf(per,"%s/periodo",dirname);
-   sprintf(report,"%s/siteuser.html",dirname);
-
-   if ((fp_in = fopen(per, "r")) == 0) {
-      fprintf(stderr, "SARG: (topuser) %s: %s\n",text[45],per);
-      exit(1);
-   }
-
-   fgets(periodo,sizeof(periodo),fp_in);
-   fclose(fp_in);
-
-   sprintf(csort,"sort -k 4,4 -k 1,1 -o '%s' '%s'",geral2,geral);
-   system(csort);
-
-   if((fp_in=fopen(geral2,"r"))==NULL) {
-     fprintf(stderr, "SARG: (topsite) %s: %s\n",text[8],geral2);
-     exit(1);
-   }
-
-   if((fp_ou=fopen(report,"w"))==NULL) {
-     fprintf(stderr, "SARG: (topsite) %s: %s\n",text[8],report);
-     exit(1);
-   }
-
-   fputs("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"",fp_ou);
-   fputs(" \"http://www.w3.org/TR/html4/loose.dtd\">\n",fp_ou);
-   fputs("<html>\n",fp_ou);
-   fputs("<head>\n",fp_ou);
-   sprintf(html,"  <meta http-equiv=\"Content-Type\" content=\"text/html; charset=%s\">\n",CharSet);
-   fputs(html,fp_ou);
-   css(fp_ou);
-   fputs("</head>\n",fp_ou);
-
-   if(strlen(FontFace) > 0) {
-      sprintf(url,"<font face=%s>\n",FontFace);
-      fputs(url,fp_ou);
-   }
-
-   sprintf(url,"<body bgcolor=%s text=%s background='%s'>\n",BgColor,TxColor,BgImage);
-   fputs(url,fp_ou);
-
-   if(strlen(LogoImage) > 0) {
-      fputs("<center><table cellpadding=\"0\" cellspacing=\"0\">\n",fp_ou);
-      sprintf(url,"<tr><th class=\"logo\"><img src='%s' border=0 align=absmiddle width=%s height=%s>&nbsp;%s</th></tr>\n",LogoImage,Width,Height,LogoText);
-      fputs(url,fp_ou);
-      fputs("<tr><td height=\"5\"></td></tr>\n",fp_ou);
-      fputs("</table>\n",fp_ou);
-   }
-
-   if(strcmp(IndexTree,"date") == 0)
-      show_sarg(fp_ou, "../../..");
-   else
-      show_sarg(fp_ou, "..");
-
-   fputs("<center><table cellpadding=0 cellspacing=0>\n",fp_ou);
-   sprintf(url,"<tr><th class=\"title\">%s</th></tr>\n",Title);
-   fputs(url,fp_ou);
-
-   sprintf(url,"<tr><td class=\"header3\">%s: %s</td></tr>\n",text[89],periodo);
-   fputs(url,fp_ou);
-   sprintf(url,"<tr><td class=\"header3\">%s</td></tr>\n",text[85]);
-   fputs(url,fp_ou);
-   fputs("</table></center>\n",fp_ou);
-
-   fputs("<center><table cellpadding=0 cellspacing=2>\n",fp_ou);
-   fputs("<tr><td></td></tr>\n",fp_ou);
-   fputs("<tr><td></td></tr>\n",fp_ou);
-   fputs("<tr><td></td></tr>\n",fp_ou);
-   sprintf(url,"<tr><th class=\"header\">%s</th><th class=\"header\">%s</th><th class=\"header\">%s</th></tr>\n",text[100],text[91],text[103]);
-   fputs(url,fp_ou);
-  
-   user[0]='\0';
-   ourl[0]='\0';
-
-   if((users=(char *) malloc(204800))==NULL){
-      fprintf(stderr, "SARG: ERROR: %s",text[87]);
-      exit(1);
-   }
-   strcat(users," ");
-
-   while(fgets(buf,sizeof(buf),fp_in)!=NULL) {
-      getword(user,buf,' ');
-      if(strcmp(user,"TOTAL") == 0)
-         continue;
-      if(userip)
-         fixip(user);
-
-      if(UserTabFile[0] != '\0') {
-         sprintf(warea,":%s:",user);
-        if((str=(char *) strstr(userfile,warea)) != (char *) NULL ) {
-            z1=0;
-            str2=(char *) strstr(str+1,":");
-            str2++;
-            bzero(name, MAXLEN);
-            while(str2[z1] != ':') {
-               name[z1]=str2[z1];
-              z1++;
-            }
-         } else strcpy(name,user);
-      } else strcpy(name,user);
-
-      if(dotinuser && strstr(name,"_")) {
-         str2=(char *)subs(name,"_",".");
-         strcpy(name,str2);
-      }
-
-      if(strcmp(Ip2Name,"yes") == 0)
-         ip2name(user);
-
-      if(strcmp(Ip2Name,"yes") == 0)
-         ip2name(user);
-
-      getword(nacc,buf,' ');
-      getword(nbytes,buf,' ');
-      getword(url,buf,' ');
-
-      if(!regs) {
-         strcpy(ourl,url);
-         regs++;
-      }
-      
-      sprintf(wuser," %s ",name);
-      if(strstr(users,wuser) == 0 && strcmp(url,ourl) == 0) {
-         strcat(users,name);
-         strcat(users," ");
-         ucount++;
-         if(ucount>4) {
-            strcat(users,"<br>");
-            ucount=0;
-         }
-      }
-
-      if(SiteUsersReportLimit) {
-         if(regs >= SiteUsersReportLimit)
-            continue;
-      }
-
-      if(strlen(BlockIt) > 0)
-         sprintf(BlockImage,"<a href=\"%s%s?url=%s\"><img src=\"../images/sarg-squidguard-block.png\" border=\"0\"></a>&nbsp;",wwwDocumentRoot,BlockIt,ourl);
-      else BlockImage[0]='\0';
-
-      if(strcmp(url,ourl) != 0) {
-         sprintf(html,"<tr><td class=\"data\">%d</td><td class=\"data2\">%s<a href=\"http://%s\">%s</td><td class=\"data2\">%s</td></tr>\n",regs,BlockImage,ourl,ourl,users);
-         fputs(html,fp_ou);
-         regs++;
-         ucount=0;
-        strcpy(users,name);
-         strcat(users," ");
-         strcpy(ourl,url);
-      }
-   }
-
-   sprintf(html,"<tr><td class=\"data\">%d</td><td class=\"data2\"><a href=\"http://%s\">%s</td><td class=\"data2\">%s</td></tr>\n",regs,ourl,ourl,users);
-   fputs(html,fp_ou);
-
-   unlink(geral2);
-
-   fputs("</table></center>\n",fp_ou);
-
-   show_info(fp_ou);
-
-   fputs("</body>\n</html>\n",fp_ou);
-   
-   fclose(fp_in);
-   fclose(fp_ou);
-
-   if(users)
-      free(users);
-
-   return;
-
+       FILE *fp_in, *fp_ou;
+
+       char *buf;
+       char wuser[MAXLEN];
+       char *ourl;
+       char csort[255];
+       char general[MAXLEN];
+       char general2[MAXLEN];
+       char sites[MAXLEN];
+       char report[MAXLEN];
+       int regs=0;
+       int ucount=0;
+       int ourl_size;
+       int url_len;
+       char *users;
+       long long int obytes;
+       int cstatus;
+       longline line;
+       struct generalitemstruct item;
+       const struct userinfostruct *uinfo;
+
+       if(Privacy)
+               return;
+
+       nsitesusers = 0;
+       sprintf(general,"%s/sarg-general",outdirname);
+       sprintf(sites,"%s/sarg-sites",outdirname);
+       sprintf(general2,"%s/sarg-general2",outdirname);
+       sprintf(report,"%s/siteuser.html",outdirname);
+
+       if (snprintf(csort,sizeof(csort),"sort -t \"\t\" -k 4,4 -k 1,1 -o \"%s\" \"%s\"",general2,general)>=sizeof(csort)) {
+               debuga(_("Sort command too long when sorting file \"%s\" to \"%s\"\n"),general,general2);
+               exit(EXIT_FAILURE);
+       }
+       cstatus=system(csort);
+       if (!WIFEXITED(cstatus) || WEXITSTATUS(cstatus)) {
+               debuga(_("sort command return status %d\n"),WEXITSTATUS(cstatus));
+               debuga(_("sort command: %s\n"),csort);
+               exit(EXIT_FAILURE);
+       }
+
+       if((fp_in=fopen(general2,"r"))==NULL) {
+               debuga(_("(siteuser) Cannot open log file %s\n"),general2);
+               debuga(_("sort command: %s\n"),csort);
+               exit(EXIT_FAILURE);
+       }
+
+       if((fp_ou=fopen(report,"w"))==NULL) {
+               debuga(_("(siteuser) Cannot open log file %s\n"),report);
+               exit(EXIT_FAILURE);
+       }
+
+       write_html_header(fp_ou,(IndexTree == INDEX_TREE_DATE) ? 3 : 1,_("Sites & Users"),HTML_JS_SORTTABLE);
+       fputs("<tr><td class=\"header_c\">",fp_ou);
+       fprintf(fp_ou,_("Period: %s"),period.html);
+       fputs("</td></tr>\n",fp_ou);
+       fprintf(fp_ou,"<tr><th class=\"header_c\">%s</th></tr>\n",_("Sites & Users"));
+       close_html_header(fp_ou);
+
+       fputs("<div class=\"report\"><table cellpadding=\"0\" cellspacing=\"2\"",fp_ou);
+       if (SortTableJs[0]) fputs(" class=\"sortable\"",fp_ou);
+       fprintf(fp_ou,">\n<thead><tr><th class=\"header_l\">%s</th><th class=\"header_l",_("NUM"));
+       if (SortTableJs[0]) fputs(" sorttable_alpha",fp_ou);
+       fprintf(fp_ou,"\">%s</th>",_("ACCESSED SITE"));
+       if(BytesInSitesUsersReport)
+               fprintf(fp_ou,"<th class=\"header_l\">%s</th>",_("BYTES"));
+       fputs("<th class=\"header_l",fp_ou);
+       if (SortTableJs[0]) fputs(" sorttable_alpha",fp_ou);
+       fprintf(fp_ou,"\">%s</th></tr></thead>\n",_("USERS"));
+
+       ourl=NULL;
+       ourl_size=0;
+       obytes=0;
+
+       if((users=(char *) malloc(204800))==NULL){
+               debuga(_("ERROR: Cannot load. Memory fault\n"));
+               exit(EXIT_FAILURE);
+       }
+       strcpy(users," ");
+
+       if ((line=longline_create())==NULL) {
+               debuga(_("Not enough memory to read file %s\n"),general2);
+               exit(EXIT_FAILURE);
+       }
+
+       while((buf=longline_read(fp_in,line))!=NULL) {
+               ger_read(buf,&item,general2);
+               if(item.total) continue;
+               uinfo=userinfo_find_from_id(item.user);
+               if (!uinfo) {
+                       debuga(_("Unknown user ID %s in file %s\n"),item.user,general2);
+                       exit(EXIT_FAILURE);
+               }
+
+               if (item.nacc > 0) nsitesusers = 1;
+               if(!regs) {
+                       url_len=strlen(item.url);
+                       if (!ourl || url_len>=ourl_size) {
+                               ourl_size=url_len+1;
+                               ourl=realloc(ourl,ourl_size);
+                               if (!ourl) {
+                                       debuga(_("Not enough memory to store the url\n"));
+                                       exit(EXIT_FAILURE);
+                               }
+                       }
+                       strcpy(ourl,item.url);
+                       obytes=item.nbytes;
+                       regs++;
+               }
+
+               sprintf(wuser," %s ",uinfo->label);
+               if(strstr(users,wuser) == 0 && strcmp(item.url,ourl) == 0) {
+                       strcat(users,uinfo->label);
+                       strcat(users," ");
+                       ucount++;
+                       if(ucount>4) {
+                               strcat(users,"<br>");
+                               ucount=0;
+                       }
+               }
+
+               if(SiteUsersReportLimit) {
+                       if(regs >= SiteUsersReportLimit)
+                               continue;
+               }
+
+               if(strcmp(item.url,ourl) != 0 && nsitesusers) {
+                       fprintf(fp_ou,"<tr><td class=\"data\">%d</td><td class=\"data2\">",regs);
+                       if(BlockIt[0]!='\0' && ourl[0]!=ALIAS_PREFIX) {
+                               fprintf(fp_ou,"<a href=\"%s%s?url=",wwwDocumentRoot,BlockIt);
+                               output_html_url(fp_ou,ourl);
+                               fputs("\"><img src=\"../images/sarg-squidguard-block.png\"></a>&nbsp;",fp_ou);
+                       }
+                       output_html_link(fp_ou,ourl,100);
+                       fputs("</td>",fp_ou);
+
+                       if (BytesInSitesUsersReport) {
+                               fputs("<td class=\"data\"",fp_ou);
+                               if (SortTableJs[0]) fprintf(fp_ou," sorttable_customkey=\"%"PRId64"\"",(int64_t)obytes);
+                               fprintf(fp_ou,">%s</td>",fixnum(obytes,1));
+                       }
+                       fprintf(fp_ou,"<td class=\"data2\">%s</td></tr>\n",users);
+
+                       regs++;
+                       ucount=0;
+                       strcpy(users,uinfo->label);
+                       strcat(users," ");
+                       url_len=strlen(item.url);
+                       if (url_len>=ourl_size) {
+                               ourl_size=url_len+1;
+                               ourl=realloc(ourl,ourl_size);
+                               if (!ourl) {
+                                       debuga(_("Not enough memory to store the url\n"));
+                                       exit(EXIT_FAILURE);
+                               }
+                       }
+                       strcpy(ourl,item.url);
+                       obytes=item.nbytes;
+               }
+       }
+       fclose(fp_in);
+       longline_destroy(&line);
+
+       if(nsitesusers) {
+               fprintf(fp_ou,"<tr><td class=\"data\">%d</td><td class=\"data2\">",regs);
+               if(BlockIt[0]!='\0' && ourl[0]!=ALIAS_PREFIX) {
+                       fprintf(fp_ou,"<a href=\"%s%s?url=",wwwDocumentRoot,BlockIt);
+                       output_html_url(fp_ou,ourl);
+                       fputs("\"><img src=\"../images/sarg-squidguard-block.png\"></a>&nbsp;",fp_ou);
+               }
+               output_html_link(fp_ou,ourl,100);
+               fputs("</td>",fp_ou);
+               if (BytesInSitesUsersReport) {
+                       fputs("<td class=\"data\"",fp_ou);
+                       if (SortTableJs[0]) fprintf(fp_ou," sorttable_customkey=\"%"PRId64"\"",(int64_t)obytes);
+                       fprintf(fp_ou,">%s</td>",fixnum(obytes,1));
+               }
+               fprintf(fp_ou,"<td class=\"data2\">%s</td></tr>\n",users);
+       }
+       if (ourl) free(ourl);
+
+       if (unlink(general2)) {
+               debuga(_("Cannot delete %s - %s\n"),general2,strerror(errno));
+               exit(EXIT_FAILURE);
+       }
+
+       fputs("</table></div>\n",fp_ou);
+       if (write_html_trailer(fp_ou)<0)
+               debuga(_("Write error in file %s\n"),report);
+       if (fclose(fp_ou)==EOF)
+               debuga(_("Failed to close file %s - %s\n"),report,strerror(errno));
+
+       if(users)
+               free(users);
+
+       return;
 }