/[LeafOK_CVS]/innwebd/base_active.cpp
ViewVC logotype

Diff of /innwebd/base_active.cpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.4 by sysadm, Sun Jul 4 08:04:08 2004 UTC Revision 1.8 by sysadm, Thu Nov 17 15:31:50 2005 UTC
# Line 1  Line 1 
1  /*******************************************************/  /*******************************************************/
2  /*                                                     */  /*                                                     */
3  /*  LeafOK Innbbsd                                     */  /*  LeafOK Innbbsd                                     */
4  /*  Copyright (C) LeafOK.com, 2003-2004                */  /*  Copyright (C) LeafOK.com, 2003-2005                */
5  /*                                                     */  /*                                                     */
6  /*  Programmed by Leaf                                 */  /*  Programmed by Leaf                                 */
7  /*  E-mail:leaflet@leafok.com  QQ:6049044              */  /*  E-mail:leaflet@leafok.com  QQ:6049044              */
# Line 533  int base_active::post_article(const char Line 533  int base_active::post_article(const char
533          {          {
534                  //Begin post                  //Begin post
535                  sql.Format("select bbs.*,innd_conf.group,innd_todo.ID,innd_todo.SID as doSID,"                  sql.Format("select bbs.*,innd_conf.group,innd_todo.ID,innd_todo.SID as doSID,"
536                          "user_list.username,subdate(bbs.sub_dt, interval '8' hour)"                          "subdate(bbs.sub_dt, interval '8' hour)"
537                          " as sub_gmt from innd_todo inner join innd_conf on"                          " as sub_gmt from innd_todo inner join innd_conf on"
538                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"
539                          " innd_todo.AID=bbs.AID inner join user_list on"                          " innd_todo.AID=bbs.AID where innd_conf.out=1 and"
                         " bbs.UID=user_list.UID where innd_conf.out=1 and"  
540                          " innd_conf.passive_mode=0 and innd_conf.server='%s' and"                          " innd_conf.passive_mode=0 and innd_conf.server='%s' and"
541                          " bbs.visible and innd_todo.op='P' order by bbs.AID",news_server);                          " bbs.visible and innd_todo.op='P' order by bbs.AID",news_server);
542    
# Line 652  int base_active::post_cancel(const char* Line 651  int base_active::post_cancel(const char*
651          try          try
652          {          {
653                  //Begin post                  //Begin post
654                  sql.Format("select bbs.nickname,innd_todo.ID,innd_conf.group,innd_todo.SID as doSID,"                  sql.Format("select bbs.username,bbs.nickname,innd_todo.ID,innd_conf.group,"
655                          "user_list.username,innd_todo.AID,"                          "innd_todo.SID as doSID,innd_todo.AID,"
656                          "subdate(innd_todo.dt,interval '8' hour) as dt,"                          "subdate(innd_todo.dt,interval '8' hour) as dt,"
657                          "innd_log.msg_id from innd_todo inner join innd_conf on"                          "innd_log.msg_id from innd_todo inner join innd_conf on"
658                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"
659                          " innd_todo.AID=bbs.AID inner join user_list on"                          " innd_todo.AID=bbs.AID inner join innd_log on"
                         " bbs.UID=user_list.UID inner join innd_log on"  
660                          " innd_todo.AID=innd_log.AID where innd_conf.out=1 and"                          " innd_todo.AID=innd_log.AID where innd_conf.out=1 and"
661                          " innd_conf.passive_mode=0 and innd_conf.server='%s' and"                          " innd_conf.passive_mode=0 and innd_conf.server='%s' and"
662                          " innd_todo.op='C' and innd_log.cancel=0 order by innd_todo.AID",news_server);                          " innd_todo.op='C' and innd_log.cancel=0 order by innd_todo.AID",news_server);
# Line 919  int base_active::ihave_article(const cha Line 917  int base_active::ihave_article(const cha
917          {          {
918                  //Begin ihave                  //Begin ihave
919                  sql.Format("select bbs.*,innd_todo.ID,innd_conf.group,innd_todo.SID as doSID,"                  sql.Format("select bbs.*,innd_todo.ID,innd_conf.group,innd_todo.SID as doSID,"
920                          "user_list.username,subdate(bbs.sub_dt, interval '8' hour)"                          "subdate(bbs.sub_dt, interval '8' hour)"
921                          " as sub_gmt from innd_todo inner join innd_conf on"                          " as sub_gmt from innd_todo inner join innd_conf on"
922                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"
923                          " innd_todo.AID=bbs.AID inner join user_list on"                          " innd_todo.AID=bbs.AID where innd_conf.out=1 and"
                         " bbs.UID=user_list.UID where innd_conf.out=1 and"  
924                          " innd_conf.passive_mode=1 and innd_conf.server='%s' and"                          " innd_conf.passive_mode=1 and innd_conf.server='%s' and"
925                          " bbs.visible and innd_todo.op='P' order by bbs.AID",news_server);                          " bbs.visible and innd_todo.op='P' order by bbs.AID",news_server);
926    
# Line 1045  int base_active::ihave_cancel(const char Line 1042  int base_active::ihave_cancel(const char
1042          try          try
1043          {          {
1044                  //Begin ihave                  //Begin ihave
1045                  sql.Format("select bbs.nickname,innd_todo.ID,innd_conf.group,innd_todo.SID as doSID,"                  sql.Format("select bbs.username,bbs.nickname,innd_todo.ID,innd_conf.group,"
1046                          "user_list.username,innd_todo.AID,"                          "innd_todo.SID as doSID,innd_todo.AID,"
1047                          "subdate(innd_todo.dt,interval '8' hour) as dt,"                          "subdate(innd_todo.dt,interval '8' hour) as dt,"
1048                          "innd_log.msg_id from innd_todo inner join innd_conf on"                          "innd_log.msg_id from innd_todo inner join innd_conf on"
1049                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"                          " innd_todo.server=innd_conf.server and innd_todo.SID=innd_conf.SID left join bbs on"
1050                          " innd_todo.AID=bbs.AID inner join user_list on"                          " innd_todo.AID=bbs.AID inner join innd_log on"
                         " bbs.UID=user_list.UID inner join innd_log on"  
1051                          " innd_todo.AID=innd_log.AID where innd_conf.out=1 and"                          " innd_todo.AID=innd_log.AID where innd_conf.out=1 and"
1052                          " innd_conf.passive_mode=1 and innd_conf.server='%s' and"                          " innd_conf.passive_mode=1 and innd_conf.server='%s' and"
1053                          " innd_todo.op='C' and innd_log.cancel=0 order by innd_todo.AID",news_server);                          " innd_todo.op='C' and innd_log.cancel=0 order by innd_todo.AID",news_server);
# Line 1217  bool base_active::check_todo_list(void) Line 1213  bool base_active::check_todo_list(void)
1213    
1214          try          try
1215          {          {
1216                  syslog << logfile::log_head << "Searching article to send ..." << endl;  //              syslog << logfile::log_head << "Searching article to send ..." << endl;
1217    
1218                  sql = "select count(*) as cc from innd_todo";                  sql = "select count(*) as cc from innd_todo";
1219    
# Line 1275  DWORD base_active::SendThread(LPVOID pPa Line 1271  DWORD base_active::SendThread(LPVOID pPa
1271                  delete(p);                  delete(p);
1272    
1273                  base_active::uThreadCount--;                  base_active::uThreadCount--;
1274                  syslog << logfile::log_head << "Delete send thread ... OK" << endl;  //              syslog << logfile::log_head << "Delete send thread ... OK" << endl;
1275          }          }
1276          catch(CException* e)          catch(CException* e)
1277          {          {
# Line 1285  DWORD base_active::SendThread(LPVOID pPa Line 1281  DWORD base_active::SendThread(LPVOID pPa
1281          }          }
1282    
1283          return 0;          return 0;
1284  }  }

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1