PHP搞的一个虚假排行榜

1.数据库表
CREATE TABLE `bang` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(20) NOT NULL,
  `point` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `day` tinyint(4) NOT NULL,
  `createtime` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`createtime`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

2.函数

我做的是3个榜单,每个月都会更新一会榜单的name,榜单的point每天都会默认加上随机值。数据每天都会变化

	/*虚假排行榜*/
	function weblistpaihang($type){
		$datetime =$this -> getthemonth(date('Y-m-d'));
		$starttime = $datetime[0];//每月的第一天
		$redtime = $datetime[1];//每月的最后一天
		$day = date("d",time());
		$name = "";
		$point = "";
		$nameArray = array("1","2","3","4","e", "输","入","和","参","指","明","了","主","法","f","g","安","国","磊","h","i","j","k","l","m","n","o","安","国","磊","p","q","r","s","t","u","安","国","磊","v","w","x","y","z","A","B","C","D","安","国","磊","E","F","G","H","I","J","安","国","磊","K","L","O","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","安","国","磊","葡","糖","酒","爱","心","小","甜","点","亲","部","长","张","达","王","成","徐","大","也","你","5","6","7","8","9","0","a","b","c","d","干","旱","王","杨","在","你","想","从","o","p","q","r","s","t","u","v","w","x","y","z","A","B","数","组","中","取","出","一","个","或","多","个","随","机","的","单","元","时","相","当","有","用","它","接","受","输","入","和","参","指","明","了","主","法");
		switch ($type) {
			case 'pub_Count':
				$typenum=1;
				break;
			case 'rec_Count':			
				$typenum=2;
				break;
			case 'ref_Count':
				$typenum=3;
				break;
		}
		$sql = "select * from `bang` where type='".$typenum."' and createtime>'".$starttime."' and createtime<'".$redtime."' limit 10";
		$result = $db->query($sql);
		$arr_Count = $result->fetchAll();
		if(count($arr_Count) < 10){
			for($i=0;$i<10;$i++){
				foreach (array_rand($nameArray,5) as $value) {
					$name .= $nameArray[$value];			
				}
				switch ($type) {
					case 'pub_Count':
						$point = rand(800,1200);
						break;
					case 'rec_Count':			
						$point = rand(500,800);
						break;
					case 'ref_Count':
						$point = rand(100,300);
						break;
				}
				$sql = "insert into `bang` (name,point,type,day,createtime) values ('".$name."','".$point."',".$typenum.",'".$day."','".date("Y-m-d H:i:s",time())."')";
				$db->query($sql);
				$arr_Count[$i]["name"] = $name;
				$arr_Count[$i]["point"] = $point;
				$name = "";
			}
		}else{
			for($i=0;$i<10;$i++){
				if($arr_Count[$i]["day"] != $day){
					switch ($type) {
						case 'pub_Count':
						case 'rec_Count':			
							$rand = rand(100,200);
							break;
						case 'ref_Count':
							$rand = rand(50,100);
							break;
					}
					$arr_Count[$i]["point"] = $arr_Count[$i]["point"] + $rand;
					$sql = "update `bang` set point='".$arr_Count[$i]["point"]."',day='".$day."' where id=".$arr_Count[$i]["id"]." and type=".$typenum;
					$db->query($sql);
				}	
			}
		}
		return $arr_Count;
	}


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值