设为首页收藏本站

LinuxSir.cn，穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
LinuxSir.cn，穿越时空的Linuxsir!»论坛 › Linux 综合讨论区 —— LinuxSir.cn › Linux 基础讨论区（新手速成） › proftpd+mysql+quota+vbb完善实现根据金钱购买的流量来 ...
返回列表 发新帖
查看: 2229|回复: 4

proftpd+mysql+quota+vbb完善实现根据金钱购买的流量来下载FTP资源

[复制链接]
夜客
发表于 2003-12-21 19:05:04 | 显示全部楼层 |阅读模式
这里是我学习xNix的好地方，把自己这些天搞的东东奉献给大家，当然，还有很多东东要完善和改进。希望朋友们共同努力。
回复

使用道具 举报

夜客
 楼主| 发表于 2003-12-21 19:05:58 | 显示全部楼层

具体内容：

proftpd+mysql+quota+vbb完善实现根据金钱购买的流量来下载FTP资源

1　引用材料：
A　现在网上流行的proftpd+mysql+quota教程。
B　www.plusxp.net提供的vbb结合的HACK。

2　proftpd+mysql+quota可以参考：
http://www.avfox.com/forumdisplay.php?s=&forumid=11

3　和VBB结合的HACK，可以参考：
http://www.plusxp.net/cgi-bin/download1.cgi

4　我的proftpd.conf的配置文档，当然可能以后会改进：
ServerName "www.avfox.com"
ServerType standalone
DefaultServer on
ServerIdent off
Port 21
Umask 022
MaxLoginAttempts 3
TimeoutLogin 120
TimeoutIdle 600
TimeoutNoTransfer 900
TimeoutStalled 3600
RootLogin on
MaxClients 500
MaxClientsPerHost 1
MaxClientsPerUser 20
AllowOverwrite on
AllowStoreRestart on
AllowRetrieveRestart on
UseReverseDNS off
RequireValidShell off
DefaultRoot ~ FTPUSR
DefaultRoot ~ FTPGRP
MaxInstances 30
User FTPUSR
Group FTPGRP

SQLConnectInfo FTP@localhost root ********
SQLAuthTypes Backend Plaintext
SQLUserInfo FTPUSERS userid passwd uid gid homedir shell
SQLGroupInfo FTPGRPS groupname gid members
SQLAuthenticate users groups usersetfast groupsetfast
SQLHomedirOnDemand on
QuotaDirectoryTally on
QuotaDisplayUnits "Kb"
QuotaEngine on
QuotaLog "/var/log"
QuotaShowQuotas on
SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail,files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally


3 我的buy_byte.php文档：

  2. <?php

  4. $myver = "v1.00";
  5. $version = "返回论坛";
  6. $PlusName = "FTP中心";
  7. $MaxAllowIP = 2;  # 最多允许的IP
  8. $PerGBSize = 1024 * 1024 * 1000; # 每GB文件的大小(Bytes)
  9. $BuyMaxGB = 1000; # 允许购买下载量的最多GB数
  10. $NameAddStr = "avfox_";

  12. mt_srand ((double) microtime() * 1000000);
  13. $newpass = mt_rand(11111111,99999999);

  15. error_reporting(7);

  17. require("./global.php");

  19.   $postinfo=getpostinfo($postid);
  20.   $threadinfo=getthreadinfo($postinfo[threadid]);
  21.   $foruminfo=getthreadinfo($threadinfo[forumid]);

  23.   // check moderator permissions for getting ip
  24. if ($bbuserinfo[userid]==0) {
  25.   show_nopermission();
  26. }
  27. $postinfo[hostaddress]=gethostbyaddr($ipaddress);
  28. // ############################### list FTP   ###############################

  30. if ($action=="") {
  31. //  $postid=verifyid("post",$postid);
  32. //  updateftpforum($threadinfo['forumid']);

  34. //查FTP数据
  35.   $ftplistbits = "";
  36.   $perpage = 20;
  37.   $limitlower=($pagenumber-1)*$perpage+1;
  38.   $limitupper=($pagenumber)*$perpage;
  39.   $counter=0;

  41.   $ftpcount=$DB_site->query_first("SELECT COUNT(*) AS ftps FROM FTP_info");
  42.   $ftptotal=$ftpscount[ftps];

  44.   if ($limitupper>$totalftps) {
  45.     $limitupper=$totalftps;
  46.     if ($limitlower>$totalftps) {
  47.       $limitlower=$totalftps-$perpage;
  48.     }
  49.   }
  50.   if ($limitlower<=0) {
  51.     $limitlower=1;
  52.   }

  54.   $ftps=$DB_site->query("SELECT * FROM FTP_info ORDER BY FTP_ItemName");

  56.   $counter=0;

  58.   while ($ftpinfo=$DB_site->fetch_array($ftps) and $counter++<$perpage) {
  59.       eval("\$ftp_listbits .= "".gettemplate("ftp_listbits")."";");
  60.   }  // end while

  62.   eval("dooutput("".gettemplate("ftp_list")."");");
  63. }

  65. // ############################### 修改密码 ###############################
  66. if ($action=="buy_pass") {
  67.   $ftps=$DB_site->query("SELECT * FROM FTP_info where FTP_ID=$ftpid");
  68.   $ftpinfo=$DB_site->fetch_array($ftps);

  70. $f_server=Trim($ftpinfo[FTP_SQLIP]).":".Trim($ftpinfo[FTP_SQLPort]);
  71. //$f_server=Trim($ftpinfo[FTP_SQLIP]);

  73. $DB_ftp=new DB_Sql_vb;
  74. $DB_ftp->appname='vbb_ftp';
  75. $DB_ftp->appshortname='vbb_ftp (forum)';
  76. $DB_ftp->database=Trim($ftpinfo[FTP_SQLDatabase]);
  77. $DB_ftp->server=$f_server;
  78. $DB_ftp->user=Trim($ftpinfo[FTP_SQLUser]);
  79. $DB_ftp->password=Trim($ftpinfo[FTP_SQLPass]);

  81. $DB_ftp->connect();

  83. $ftpuser=$NameAddStr.$bbuserinfo[username];

  85.   $ftps2=$DB_ftp->query("SELECT * FROM quotalimits where name='$ftpuser'");
  86.   $DB_ftp->query("UPDATE FTPUSERS SET passwd=$newpass WHERE userid='$ftpuser'");

  88.   $buyerror="$ftpinfo[FTP_ItemName]上的密码已经改为【<normalfont color='blue'>".$newpass."</normalfont>】，请牢记！ （注：密码是【】内8位蓝色数字,密码一分钟后生效）";
  89.   eval("dooutput("".gettemplate("buy_error")."");");


  92. }

  94. // ############################### start 购买流量 ###############################
  95. if ($action=="buy_byte") {

  97. //  $postid=verifyid("post",$postid);

  99.   $ftps=$DB_site->query("SELECT * FROM FTP_info where FTP_ID=$ftpid");
  100.   $ftpinfo=$DB_site->fetch_array($ftps);

  102. if($ftpinfo[FTP_Enable]==0) {
  103.   $buyerror=$ftpinfo[FTP_ItemName]."目前关闭，无法购买流量！";
  104.   eval("dooutput("".gettemplate("buy_error")."");");
  105.   exit();
  106. }

  108. $f_server=Trim($ftpinfo[FTP_SQLIP]).":".Trim($ftpinfo[FTP_SQLPort]);
  109. //$f_server=Trim($ftpinfo[FTP_SQLIP]);

  111. $DB_ftp=new DB_Sql_vb;
  112. $DB_ftp->appname='vbb_ftp';
  113. $DB_ftp->appshortname='vbb_ftp (forum)';
  114. $DB_ftp->database=Trim($ftpinfo[FTP_SQLDatabase]);
  115. $DB_ftp->server=$f_server;
  116. $DB_ftp->user=Trim($ftpinfo[FTP_SQLUser]);
  117. $DB_ftp->password=Trim($ftpinfo[FTP_SQLPass]);

  119. $DB_ftp->connect();

  121. $ftpuser=$NameAddStr.$bbuserinfo[username];

  123.   $ftps2=$DB_ftp->query("SELECT * FROM quotalimits where name='$ftpuser'");
  124.   $ftpinfo2=$DB_ftp->fetch_array($ftps2);
  125.   $ftps3=$DB_ftp->query("SELECT * FROM quotatallies where name='$ftpuser'");
  126.   $ftpinfo3=$DB_ftp->fetch_array($ftps3);  

  128. $GB_downover = intval($ftpinfo3[bytes_out_used] / $PerGBSize);
  129. $GB_down = intval($ftpinfo2[bytes_out_avail] / $PerGBSize);

  131. $GB_moneycheck = $DB_site->query_first("SELECT money FROM user WHERE userid=$bbuserinfo[userid]");
  132. $GB_money = $GB_moneycheck[money];
  133. $GB_buy = intval($GB_money / $ftpinfo[FTP_BuyPrice]);

  135. if($GB_buy>($BuyMaxGB-$GB_down)){$GB_buy=($BuyMaxGB-$GB_down);}

  137. $ipaddress=getenv("REMOTE_ADDR");
  138. $ipadd=explode(".",trim($ipaddress));
  139.   
  140. //  updateftpforum($threadinfo['forumid']);
  141.   eval("dooutput("".gettemplate("buy_byte")."");");
  142. }

  144. // ###################### 购买确认 #######################

  146. if ($action=="buy_bytechanged") {

  148.   $ftps=$DB_site->query("SELECT * FROM FTP_info where FTP_ID=$ftpid");
  149.   $ftpinfo=$DB_site->fetch_array($ftps);

  151. $f_server=Trim($ftpinfo[FTP_SQLIP]).":".Trim($ftpinfo[FTP_SQLPort]);

  153. $DB_ftp=new DB_Sql_vb;
  154. $DB_ftp->appname='vbb_ftp';
  155. $DB_ftp->appshortname='vbb_ftp (forum)';
  156. $DB_ftp->database=Trim($ftpinfo[FTP_SQLDatabase]);
  157. $DB_ftp->server=$f_server;
  158. $DB_ftp->user=Trim($ftpinfo[FTP_SQLUser]);
  159. $DB_ftp->password=Trim($ftpinfo[FTP_SQLPass]);
  160. $DB_ftp->connect();

  162. $ftpuser=$NameAddStr.$bbuserinfo[username];

  164.   $ftps2=$DB_ftp->query("SELECT * FROM quotalimits where name='$ftpuser'");
  165.   $ftpinfo2=$DB_ftp->fetch_array($ftps2);
  166.   $ftps3=$DB_ftp->query("SELECT * FROM quotatallies where name='$ftpuser'");
  167.   $ftpinfo3=$DB_ftp->fetch_array($ftps3);

  169. $GB_downover = intval($ftpinfo3[bytes_out_used] / $PerGBSize);
  170. $GB_down = intval($ftpinfo2[bytes_out_avail] / $PerGBSize);

  172. $GB_moneycheck = $DB_site->query_first("SELECT money,usergroupid FROM user WHERE userid=$bbuserinfo[userid]");
  173. //$GB_moneycheck=$DB_site->fetch_array($GB_moneychecks);
  174. $GB_money = $GB_moneycheck[money];
  175. $GB_buy = intval($GB_money / $ftpinfo[FTP_BuyPrice]);

  177. if($GB_buy>($BuyMaxGB-$GB_down)){$GB_buy=($BuyMaxGB-$GB_down);}
  178. $donate=$donate+0;

  180. if($donate=='' or $donate<=0) {
  181.   $buyerror="你没有输入任何数字！";
  182.   eval("dooutput("".gettemplate("buy_error")."");");
  183.   exit();
  184. }

  186. if(!is_int($donate)) {
  187.   $buyerror="你输入的不是整数！";
  188.   eval("dooutput("".gettemplate("buy_error")."");");
  189.   exit();
  190. }

  192. if($donate > $GB_buy) {
  193.   $buyerror="资金不足，或你已超过购买量，无法购买！";
  194.   eval("dooutput("".gettemplate("buy_error")."");");
  195.   exit();
  196. }

  198. if($donate > $BuyMaxGB) {
  199.   $buyerror="对不起，FTP最多只允许购买 $BuyMaxGB GB的流量！";
  200.   eval("dooutput("".gettemplate("buy_error")."");");
  201.   exit();
  202. }

  204. $f_server=Trim($ftpinfo[FTP_SQLIP]).":".Trim($ftpinfo[FTP_SQLPort]);
  205. //$f_server=Trim($ftpinfo[FTP_SQLIP]);

  207. $ftpuser=$NameAddStr.$bbuserinfo[username];

  209. //  $ftpcount=$DB_ftp->query_first("SELECT COUNT(*) AS usercc,bytes_out_avail FROM quotalimits where name='$ftpuser'");
  210. //  $usercount=$ftpcount[usercc];
  211.   $ftpcount=$DB_ftp->query_first("SELECT name,bytes_out_avail FROM quotalimits where name='$ftpuser'");
  212.   $username=$ftpcount[name];
  213.   $userdown=$ftpcount[bytes_out_avail];

  215. $ftpgroups=$DB_site->query_first("SELECT Group_ftpname FROM FTP_group WHERE Group_vbbid='$GB_moneycheck[usergroupid]' and Group_ftpid='$ftpid' ");
  216. $ftpgroup=$ftpgroups[Group_ftpname];

  218. if($ftpgroup==''){
  219.   $buyerror="你没有权利购买密码！可能是你的帐号还没有被激活！";
  220.   eval("dooutput("".gettemplate("buy_error")."");");
  221.   exit();
  222. }

  224. //$DB_sice->query("UPDATE FTP_info SET FTP_Click='$ftpinfo[FTP_Click]+1',FTP_BuyTotal='$ftpinfo[FTP_BuyTotal]+$donate' WHERE FTP_ID='$ftpid'");
  225. $DB_site->query("UPDATE FTP_info SET FTP_Click=FTP_Click+1,FTP_BuyTotal=FTP_BuyTotal+$donate WHERE FTP_ID='$ftpid'");

  227. if($username==''){
  228. $ipaddress=getenv("REMOTE_ADDR");
  229. $ipadd=explode(".",trim($ipaddress));

  231.   $DB_ftp->query("INSERT INTO FTPUSERS (userid,passwd,uid, gid, homedir, shell) VALUES ('$ftpuser', '$newpass','2001','2001','/home/FTP/film','')");
  232.   $DB_ftp->query("INSERT INTO quotalimits (`name` , `quota_type` , `per_session` , `limit_type` , `bytes_in_avail` , `bytes_out_avail` , `bytes_xfer_avail` , `files_in_avail` , `files_out_avail` , `files_xfer_avail`) VALUES ('$ftpuser', 'user', 'false', 'soft', '0', $donate*$PerGBSize, '0', '0', '0', '0')");
  233.   $eventid = $DB_ftp->insert_id();
  234.   $passmessage="<b>【<normalfont%20color=blue>".$newpass."</normalfont>】</b>请牢记此密码，此密码只能在本FTP上使用，为确保您的FTP密码不被盗用，此密码今后将只能修改不能查询！（注：密码是【】内8位蓝色数字）";
  235.   $DB_site->query("UPDATE user SET money=(money-$donate*$ftpinfo[FTP_BuyPrice]) WHERE userid=$bbuserinfo[userid]");


  238. }else{

  240.   $DB_ftp->query("UPDATE quotalimits SET bytes_out_avail=($userdown+$donate*$PerGBSize) WHERE name='$ftpuser'");
  241.   $passmessage="<normalfont%20color=blue>您的FTP密码为您以前使用的密码，如您忘记该密码，请在前一窗口修改！";
  242.   $DB_site->query("UPDATE user SET money=(money-$donate*$ftpinfo[FTP_BuyPrice]) WHERE userid=$bbuserinfo[userid]");

  244. }

  246. $GB_money=$GB_money-$donate*$ftpinfo[FTP_BuyPrice];

  248.   $ftps2=$DB_ftp->query("SELECT * FROM quotalimits where name='$ftpuser'");
  249.   $ftpinfo2=$DB_ftp->fetch_array($ftps2);
  250.   $ftps3=$DB_ftp->query("SELECT * FROM quotatallies where name='$ftpuser'");
  251.   $ftpinfo3=$DB_ftp->fetch_array($ftps3);
  252.   
  253. $GB_downover = intval($ftpinfo3[bytes_out_used] / $PerGBSize);
  254. $GB_down = intval($ftpinfo2[bytes_out_avail] / $PerGBSize);

  256. Header("Location: buy_byte.php?action=buy_bytemessage&s=$session[sessionhash]&ftpid=$ftpinfo[FTP_ID]&donate2=$donate&GB_money=$GB_money&passmessage=$passmessage");
  257. }
  258. // ############################### 显示购买成功！ ###############################
  259. if ($action=="buy_bytemessage") {
  260.   $ftps=$DB_site->query("SELECT * FROM FTP_info where FTP_ID=$ftpid");
  261.   $ftpinfo=$DB_site->fetch_array($ftps);

  263. $f_server=Trim($ftpinfo[FTP_SQLIP]).":".Trim($ftpinfo[FTP_SQLPort]);

  265. $DB_ftp=new DB_Sql_vb;
  266. $DB_ftp->appname='vbb_ftp';
  267. $DB_ftp->appshortname='vbb_ftp (forum)';
  268. $DB_ftp->database=Trim($ftpinfo[FTP_SQLDatabase]);
  269. $DB_ftp->server=$f_server;
  270. $DB_ftp->user=Trim($ftpinfo[FTP_SQLUser]);
  271. $DB_ftp->password=Trim($ftpinfo[FTP_SQLPass]);
  272. $DB_ftp->connect();

  274. $ftpuser=$NameAddStr.$bbuserinfo[username];

  276.   $ftps2=$DB_ftp->query("SELECT * FROM quotalimits where name='$ftpuser'");
  277.   $ftpinfo2=$DB_ftp->fetch_array($ftps2);
  278.   $ftps3=$DB_ftp->query("SELECT * FROM quotatallies where name='$ftpuser'");
  279.   $ftpinfo3=$DB_ftp->fetch_array($ftps3);
  280.   
  281. $GB_downover = intval($ftpinfo3[bytes_out_used] / $PerGBSize);
  282. $GB_down = intval($ftpinfo2[bytes_out_avail] / $PerGBSize);

  284.        
  285.   eval("dooutput("".gettemplate("buy_message")."");");       
  286.        
  287.        
  288. }

  290. // ############################### 修改IP地址 ###############################
  291. if ($action=="buy_ipchanged") {

  293. if($allowip==''){
  294.   $buyerror="你没有输入任何IP地址！";
  295.   eval("dooutput("".gettemplate("buy_error")."");");
  296.   exit();
  297. }


  300. $allowip2=explode("\n",$allowip);
  301. $counter=-1;
  302.   while (++$counter < $MaxAllowIP){
  303.       $allowip3=explode(".",trim($allowip2[$counter]));
  304.                   $allowip4=$allowip4.trim($allowip2[$counter])."\n";

  306.       if (!($allowip3[0]>=0 and $allowip3[0]<=255) or !($allowip3[1]>=0 and $allowip3[1]<=255) or $allowip3[0]=='*' or $allowip3[1]=='*'){
  307.       $buyerror="你输入的IP地址不正确或范围有误！";
  308.       eval("dooutput("".gettemplate("buy_error")."");");
  309.                   exit();
  310.              }
  311.   }
  312.   $ftps=$DB_site->query("SELECT * FROM FTP_info where FTP_ID=$ftpid");
  313.   $ftpinfo=$DB_site->fetch_array($ftps);

  315. $f_server=Trim($ftpinfo[FTP_SQLIP]).":".Trim($ftpinfo[FTP_SQLPort]);

  317. $DB_ftp=new DB_Sql_vb;
  318. $DB_ftp->appname='vbb_ftp';
  319. $DB_ftp->appshortname='vbb_ftp (forum)';
  320. $DB_ftp->database=Trim($ftpinfo[FTP_SQLDatabase]);
  321. $DB_ftp->server=$f_server;
  322. $DB_ftp->user=Trim($ftpinfo[FTP_SQLUser]);
  323. $DB_ftp->password=Trim($ftpinfo[FTP_SQLPass]);

  325. $DB_ftp->connect();

  327. $ftpuser=$NameAddStr.$bbuserinfo[username];

  329.   $ftps2=$DB_ftp->query("SELECT * FROM quotalimits where name='$ftpuser'");
  330.   $DB_ftp->query("UPDATE FTPUSERS SET FAllow_IP='$allowip4' WHERE userid='$ftpuser'");

  332.   $buyerror="$ftpinfo[FTP_ItemName]上允许的 IP 段已改为：<textarea cols=60 rows=$MaxAllowIP  name='allowip'>$allowip4</textarea>";
  333.   eval("dooutput("".gettemplate("buy_error")."");");


  336. }

  338. ?>

复制代码

4　相关改变的模板请自选修改

5　演示站点
http://www.avfox.com

6　还有很多功能需要更多的人来完善。
回复 支持 反对

使用道具 举报

夜客
 楼主| 发表于 2003-12-27 22:00:47 | 显示全部楼层
看样子没有人支持。
回复 支持 反对

使用道具 举报

cx6445
发表于 2003-12-28 12:53:15 | 显示全部楼层
能不能给兄弟一点金子呀，嘻嘻！
不过在此论坛有兄弟如此实力的人着实不多，所以回的人也就少了，很正常的。
看了兄弟的论坛，感觉管理有点混乱，希望贵坛越办越好。
回复 支持 反对

使用道具 举报

发表于 2003-12-28 21:58:25 | 显示全部楼层
好帖子，看来做论坛的兄弟不多。
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表