Google
Web alhem.net
Main Page | Namespace List | Class Hierarchy | Alphabetical List | Class List | File List | Class Members | File Members

dbd.h File Reference

#include <stdio.h>
#include <string>
#include <mysql/mysql.h>
#include <libmysqlwrapped.h>
#include <libfd.h>
#include "ExecSocket.h"

Include dependency graph for dbd.h:

Include dependency graph

This graph shows which files directly or indirectly include this file:

Included by dependency graph

Go to the source code of this file.

Defines

#define LIVEDB
#define TITLE   "fd"
#define APACHEDLPATH   "/usr/local/apache/www.alhem.net/htdocs/download"
#define COOKIE_DOMAIN   ".alhem.net"
#define COOKIE_PATH   "/cgi-bin/dbd"
#define MYSQLADMIN   "/usr/local/mysql/bin/mysqladmin --user=root"
#define MYSQL_program   "/usr/local/mysql/bin/mysql --user=root"
#define MYSQLDUMP   "/usr/local/mysql/bin/mysqldump --user=root"
#define APACHEPATH   "/download"
#define UF_AUTOCREATENUM   1
#define UF_SHOWLINKED   2
#define FF_ALLOWNULL   1
#define FF_AUTO_INCREMENT   2
#define FF_BINARY   4
#define FF_UNSIGNED   8
#define FF_ZEROFILL   16
#define CF_EXPAND_DB   1
#define CF_EXPAND_TBL   2
#define CF_EXPAND_FLD   4
#define CF_EXPAND_INDEX   8
#define CF_EXPAND_APP   16

Functions

void post_form (Database &db, Query &q, char *sql, db::Item *=NULL)
void search (Database &, Query &, char *, Form *, Cookies *)
void run (Database &, FILE *, const std::string &input_data="")

Variables

FILE * out
ExecSocket * g_pSocket
char tmp_path [1000]
bool g_bSize

Define Documentation

#define APACHEDLPATH   "/usr/local/apache/www.alhem.net/htdocs/download"
 

Definition at line 44 of file dbd.h.

#define APACHEPATH   "/download"
 

Definition at line 60 of file dbd.h.

#define CF_EXPAND_APP   16
 

Definition at line 77 of file dbd.h.

#define CF_EXPAND_DB   1
 

Definition at line 73 of file dbd.h.

#define CF_EXPAND_FLD   4
 

Definition at line 75 of file dbd.h.

#define CF_EXPAND_INDEX   8
 

Definition at line 76 of file dbd.h.

#define CF_EXPAND_TBL   2
 

Definition at line 74 of file dbd.h.

#define COOKIE_DOMAIN   ".alhem.net"
 

Definition at line 52 of file dbd.h.

Referenced by pack_and_set_cookies().

#define COOKIE_PATH   "/cgi-bin/dbd"
 

Definition at line 53 of file dbd.h.

Referenced by pack_and_set_cookies().

#define FF_ALLOWNULL   1
 

Definition at line 65 of file dbd.h.

#define FF_AUTO_INCREMENT   2
 

Definition at line 66 of file dbd.h.

#define FF_BINARY   4
 

Definition at line 67 of file dbd.h.

#define FF_UNSIGNED   8
 

Definition at line 68 of file dbd.h.

#define FF_ZEROFILL   16
 

Definition at line 69 of file dbd.h.

#define LIVEDB
 

Definition at line 41 of file dbd.h.

#define MYSQL_program   "/usr/local/mysql/bin/mysql --user=root"
 

Definition at line 57 of file dbd.h.

#define MYSQLADMIN   "/usr/local/mysql/bin/mysqladmin --user=root"
 

Definition at line 56 of file dbd.h.

#define MYSQLDUMP   "/usr/local/mysql/bin/mysqldump --user=root"
 

Definition at line 58 of file dbd.h.

#define TITLE   "fd"
 

Definition at line 43 of file dbd.h.

Referenced by header(), and nullheader().

#define UF_AUTOCREATENUM   1
 

Definition at line 62 of file dbd.h.

#define UF_SHOWLINKED   2
 

Definition at line 63 of file dbd.h.

Function Documentation

void post_form (  Database &  db,
Query &  q,
char *  sql,
db::Item *  = NULL
) 
 

Definition at line 252 of file dbd.cpp.

References db::Item::category, db::Tag::name, db::Category::name, db::Item::name, db::Tag::num, db::Category::num, out, and db::Item::typ.

Referenced by run(). 

00253 {
00254         fprintf(out,"<form action='/cgi-bin/exec' method='post' enctype='multipart/form-data'>");
00255         fprintf(out,"<input type=hidden name=post_form value=1>");
00256   if (p)
00257   {
00258     fprintf(out,"<input type=hidden name=typ value='Again'>");
00259     fprintf(out,"<input type=hidden name=itemnr value=%ld>", p -> num);
00260           fprintf(out,"<p style='font-weight: bold;'>Send item again</p>");
00261     fprintf(out,"<p><u>%s</u>: %s</p>",p->typ.c_str(),p->name.c_str());
00262   }
00263   else
00264   {
00265           fprintf(out,"<p style='font-weight: bold;'>Item type</p>");
00266           fprintf(out,"<table cellspacing=5><tr>");
00267           fprintf(out,"<td><input type=radio name=typ value='File'>File</td>");
00268           fprintf(out,"<td><input type=file name=the_file></td>"
00269                   "</tr><tr>");
00270           fprintf(out,"<td><input type=radio name=typ value='URL' checked>URL</td>");
00271           fprintf(out,"<td><input type=text size=40 name=the_url value='http://'></td>");
00272           fprintf(out,"</tr></table>");
00273   }
00274 
00275         fprintf(out,"<p style='font-weight: bold;'>Category</p>");
00276 
00277         q.get_result("select * from category order by name");
00278         if (q.num_rows())
00279         {
00280                 fprintf(out,"<select name=category><option>");
00281                 while (q.fetch_row())
00282                 {
00283                         db::Category tag(&db, &q);
00284       fprintf(out,"<option value=%ld%s>%s", tag.num, (p && p->category == tag.num) ? " selected" : "",tag.name.c_str() );
00285                 }
00286                 fprintf(out,"</select> or ");
00287         }
00288         q.free_result();
00289         fprintf(out,"new category <input type=text name=newcategory><br>");
00290 
00291         fprintf(out,"<p style='font-weight: bold;'>Tags (optional)</p>");
00292 
00293         q.get_result("select * from tag order by name");
00294         if (q.num_rows())
00295         {
00296                 fprintf(out,"<select name=tag1><option>");
00297                 while (q.fetch_row())
00298                 {
00299                         db::Tag tag(&db, &q);
00300                         fprintf(out,"<option value=%ld>%s", tag.num, tag.name.c_str() );
00301                 }
00302                 fprintf(out,"</select> or ");
00303         }
00304         q.free_result();
00305         fprintf(out,"new tag <input type=text name=newtag1><br>");
00306 
00307         q.get_result("select * from tag order by name");
00308         if (q.num_rows())
00309         {
00310                 fprintf(out,"<select name=tag2><option>");
00311                 while (q.fetch_row())
00312                 {
00313                         db::Tag tag(&db, &q);
00314                         fprintf(out,"<option value=%ld>%s", tag.num, tag.name.c_str() );
00315                 }
00316                 fprintf(out,"</select> or ");
00317         }
00318         q.free_result();
00319         fprintf(out,"new tag <input type=text name=newtag2><br>");
00320 
00321         q.get_result("select * from tag order by name");
00322         if (q.num_rows())
00323         {
00324                 fprintf(out,"<select name=tag3><option>");
00325                 while (q.fetch_row())
00326                 {
00327                         db::Tag tag(&db, &q);
00328                         fprintf(out,"<option value=%ld>%s", tag.num, tag.name.c_str() );
00329                 }
00330                 fprintf(out,"</select> or ");
00331         }
00332         q.free_result();
00333         fprintf(out,"new tag <input type=text name=newtag3><br>");
00334 
00335   if (p)
00336   {
00337           fprintf(out,"<p><input type=submit name=submit value=' Send again '></p>");
00338   }
00339   else
00340   {
00341           fprintf(out,"<p><input type=submit name=submit value=' Submit new item '></p>");
00342   }
00343         //
00344         fprintf(out,"</form>");
00345 }

void run (  Database &  ,
FILE *  ,
const std::string &  input_data = ""
) 
 

Definition at line 69 of file dbd.cpp.

References db::Item::data, error(), form_input(), g_bSize, g_pSocket, db::Item::name, db::Item::num, out, pack_and_set_cookies(), post_form(), search(), searchcat, searchtag, set_cookie(), tmp_path, unpack_cookie(), and valflik().

Referenced by ExecSocket::Exec(). 

00070 {
00071 #ifdef WIN32
00072         ::GetTempPath(1000, tmp_path);
00073         strcat(tmp_path, "\\");
00074 #else
00075         strcpy(tmp_path, "/tmp/");
00076 #endif
00077 
00078         // output file, stdout or file on disk
00079         out = o;
00080         Query q(db);
00081         Form *form = NULL;
00082         Cookies *cs;
00083 //      char *r_h = getenv("REMOTE_HOST");
00084         char *q_s = getenv("QUERY_STRING");
00085 //      char *c_l = getenv("CONTENT_LENGTH");
00086         char *r_m = getenv("REQUEST_METHOD");
00087         char *http_cookie = getenv("HTTP_COOKIE");
00088         char sql[1000];
00089         char slask[1000];
00090 
00091 // before calling Form(), check how we are called - code from webmud@home
00092 
00093         if (!r_m)
00094         {
00095                 printf("This program is part of a cgi script, and should not be\n");
00096                 printf("be called from the command line\n");
00097                 exit(0);
00098         }
00099 
00100         if (!strcasecmp(r_m,"get"))
00101         {
00102                 if (q_s)
00103                         form = new Form(q_s,strlen(q_s));
00104                 else
00105                         form = new Form("", 0); // empty query string...
00106         }
00107         else
00108         if (input_data.size()) // from ExecSocket
00109         {
00110                 FILE *fil = fopen(input_data.c_str(),"rb");
00111                 form = new Form(fil);
00112                 fclose(fil);
00113         }
00114         else
00115         {
00116                 if (!strcasecmp(r_m,"post"))
00117                         form = new Form();
00118                 else
00119                         error("unknown request_method");
00120         }
00121 
00122   // reset
00123   g_bSize = false;
00124 
00125   // retreive cookie(s)
00126         cs = new Cookies(http_cookie ? http_cookie : (char *)"");
00127         unpack_cookie(cs);
00128 
00129         cs -> getvalue("flik",slask,20);
00130         int flik = atoi(slask);
00131 
00132         // receive form data
00133         form_input(db, q, sql, form, cs, flik);
00134         if (form -> getvalue("flik",slask,20))
00135         {
00136                 flik = atoi(slask);
00137         }
00138   searchtag = searchcat = 0;
00139   if (form -> getvalue("tag",slask,20))
00140   {
00141     searchtag = atol(slask);
00142   }
00143   if (form -> getvalue("cat",slask,20))
00144   {
00145     searchcat = atol(slask);
00146   }
00147   long again = 0;
00148   if (form -> getvalue("again",slask,20) && *slask && atoi(slask))
00149   {
00150      again = atol(slask);
00151      flik = 2;
00152   }
00153 
00154         // get file
00155         long get_file = 0;
00156         if (form -> getvalue("get_file",slask,20) && *slask && atoi(slask))
00157         {
00158                 get_file = atol(slask);
00159         }
00160         if (get_file)
00161         {
00162                 db::Item item(db, get_file);
00163                 if (item.num)
00164                 {
00165                         cgi::Base64 b('@');
00166                         std::string mime = static_cast<FinderHandler&>(g_pSocket->Handler()).GetMimeFromFile(item.name);
00167       std::string data;
00168       for (std::vector<std::string>::iterator it = item.data.begin(); it != item.data.end(); it++)
00169       {
00170         data += *it;
00171       }
00172                         fprintf(out, "Content-type: %s\r\n", mime.c_str());
00173       fprintf(out, "Content-length: %d\r\n", b.decode_length(data));
00174 //      fprintf(out, "Content-disposition: attachment; filename=%s\r\n", item.name.c_str());
00175       fprintf(out, "Content-disposition: filename=%s\r\n", item.name.c_str());
00176                         fprintf(out, "\r\n");
00177                         b.decode_to_stdout(data, out);
00178       return;
00179                 }
00180         }
00181 
00182         // http header
00183         set_cookie(cs,"flik",flik);
00184         {
00185                 pack_and_set_cookies(cs);
00186                 fprintf(out,"Content-type: text/html; charset=ISO-8859-1\r\n");
00187 
00188                 // End of http header
00189                 fprintf(out,"\r\n");
00190                 fflush(out);
00191         }
00192 
00193         // Create page
00194         fprintf(out,"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd\">\n");
00195         fflush(out);
00196 
00197   fprintf(out,"<html><head><title>fd</title>");
00198         fprintf(out,"<link rel='SHORTCUT ICON' href='/favicon.ico'>");
00199   fprintf(out,
00200     "<style type='text/css'>"
00201     "th.x { background: #c0c0c0; padding-left: 8px; padding-right: 8px; }\n"
00202     "td.x { background: #e0e0e0; padding-left: 8px; padding-right: 8px; }\n"
00203     "body { margin: 0; padding: 0; font-family: sans-serif; }\n"
00204     "</style>");
00205         fprintf(out,"</head>");
00206 
00207   // body
00208         fprintf(out,"<body>");
00209 
00210   // logo
00211   fprintf(out, "<table cellspacing=5 cellpadding=5><tr><td valign='top'>"
00212     "<a href='http://www.alhem.net/duct/'>"
00213     "<img src='/ahl.png' border=0>"
00214     "</a><br>");
00215         valflik(1,"Search",flik);
00216         valflik(2,"Post",flik);
00217   fprintf(out,
00218     "</td><td valign='top'>");
00219 
00220   if (g_bSize)
00221   {
00222     fprintf(out,"<h3 style='color: #800000'>Largest file size allowed is 400000 bytes</h3>");
00223   }
00224 
00225   switch (flik)
00226         {
00227         case 1:
00228                 search(db, q, sql, form, cs);
00229                 break;
00230         case 2:
00231     if (again)
00232     {
00233       db::Item item(db, again);
00234       post_form(db, q, sql, &item);
00235     }
00236     else
00237     {
00238                   post_form(db, q, sql);
00239     }
00240                 break;
00241         }
00242 
00243         // footer
00244         fprintf(out,"</body></html>\n");
00245 
00246         // cleanup      
00247         delete form;
00248         delete cs;
00249 }

void search (  Database &  ,
Query &  ,
char *  ,
Form *  ,
Cookies * 
) 
 

Definition at line 348 of file dbd.cpp.

References db::Item::category, db::Item::name, db::Tag::name, db::Category::name, db::Tag::num, db::Item::num, db::Category::num, out, searchcat, searchtag, db::Item::sz, db::Linkitemtag::tag, and db::Item::typ.

Referenced by run(). 

00349 {
00350   Query q2(db);
00351 
00352   if (searchtag)
00353   {
00354     sprintf(sql,"select item.* from item,linkitemtag where linkitemtag.tag=%ld and item.num=linkitemtag.item",searchtag);
00355     q.get_result(sql);
00356   }
00357   else
00358   if (searchcat)
00359   {
00360     sprintf(sql,"select * from item where category=%ld", searchcat);
00361     q.get_result(sql);
00362   }
00363   else
00364   {
00365     q.get_result("select * from item");
00366   }
00367         fprintf(out,"<table cellspacing=1>");
00368         fprintf(out,"<tr>");
00369         fprintf(out,"<th class='x'>Type</th>"
00370                 "<th class='x'>Category</th>"
00371     "<th class='x'>Tags</th>"
00372                 "<th class='x'>Link</th>"
00373     "<th class='x'>Size</th>");
00374 //    "<th class='x'>Checksum</th>");
00375         fprintf(out,"</tr>");
00376         while (q.fetch_row())
00377         {
00378                 db::Item item(&db, &q);
00379                 db::Category cat(db, item.category);
00380 
00381                 fprintf(out,"<tr>");
00382                 fprintf(out,"<td class='x'>%s</td>", item.typ.c_str());
00383                 fprintf(out,"<td class='x'><a href='/cgi-bin/exec?cat=%ld'>%s</a></td>", cat.num, cat.name.c_str());
00384     // tags
00385     fprintf(out,"<td class='x'>");
00386     sprintf(sql, "select * from linkitemtag where item=%ld", item.num);
00387     q2.get_result(sql);
00388     while (q2.fetch_row())
00389     {
00390       db::Linkitemtag x(&db, &q2);
00391       db::Tag tag(db, x.tag);
00392       fprintf(out,"&nbsp;<a href='/cgi-bin/exec?tag=%ld'>%s</a>",tag.num,tag.name.c_str());
00393     }
00394     q2.free_result();
00395     fprintf(out,"</td>");
00396     //
00397                 if (item.typ == "URL")
00398                 {
00399                         fprintf(out,"<td class='x'><a href='%s'>%s</a></td>", item.name.c_str(), item.name.c_str());
00400                 }
00401                 else
00402                 if (item.typ == "File")
00403                 {
00404                         fprintf(out,"<td class='x'><a href='/cgi-bin/exec?get_file=%ld'>%s</a></td>", item.num, item.name.c_str());
00405                 }
00406     fprintf(out,"<td class='x' align='right'>%ld</td>",item.sz);
00407 //    fprintf(out,"<td class='x'>%s</td>",item.sha1.c_str());
00408     fprintf(out,"<td><a href='/cgi-bin/exec?again=%ld'>send&nbsp;again</a></td>",item.num);
00409                 fprintf(out,"</tr>");
00410         }
00411         q.free_result();
00412         fprintf(out,"</table>");
00413 }

Variable Documentation

bool g_bSize
 

Definition at line 29 of file dbd.h.

Referenced by form_input(), and run().

ExecSocket* g_pSocket
 

Definition at line 27 of file dbd.h.

Referenced by ExecSocket::Exec(), form_input(), and run().

FILE* out
 

Definition at line 26 of file dbd.h.

Referenced by error(), ExecSocket::Exec(), footer(), ExecSocket::header(), header(), header0(), header_top(), ibranchcont(), ibranchend(), iclosed(), iempty(), iexpanded(), iglobe(), iglobe0(), iminus(), iminusend(), inotexpanded(), iopen(), ipascal(), iplus(), iplusend(), ithumbsdown(), ithumbsup(), ivertline(), nullheader(), pack_and_set_cookies(), post_form(), remove_br(), run(), search(), textareain(), and valflik().

char tmp_path[1000]
 

Definition at line 28 of file dbd.h.

Referenced by run().

Generated on Thu Feb 10 22:42:35 2005 for Distributed URL Classification Tool by doxygen 1.3.7