/[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.5 by sysadm, Thu Sep 16 15:41:14 2004 UTC Revision 1.6 by sysadm, Wed Dec 1 08:31:52 2004 UTC
# 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);

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