cdks.php 2.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?php ?><?php
  2. error_reporting(0);
  3. $sqm = $_POST['sqm'];
  4. $num = $_POST['num'];
  5. $lv = $_POST['lv'];
  6. include "../gm/user/config.php";
  7. $zame = 'wch123.cn_1_';
  8. $lv == 0 && (die("<script>alert('请选择类型');window.history.back(-1); </script>"));
  9. $lv == 2 && ($zame = 'wch123.cn_2_');
  10. $sqm != $gmcodeb && (die("<script>alert('授权码错误');window.history.back(-1); </script>"));
  11. $num > 100 && (die("<script>alert('单次最多生成100条');window.history.back(-1); </script>"));
  12. $num == '' && ($num = 1);
  13. $yzf=new mysqli($PZ['DB_HOST'],$PZ['DB_USER'],$PZ['DB_PWD'],$PZ['DB_NAME'],$PZ['DB_PORT']);
  14. if (mysqli_connect_errno()){
  15. $db=new mysqli($PZ['DB_HOST'],$PZ['DB_USER'],$PZ['DB_PWD'],'',$PZ['DB_PORT']);
  16. $db->autocommit(true); //不使用事物
  17. if (mysqli_connect_errno()) {
  18. exit('数据库连接错误!错误代码:' . mysqli_connect_error());
  19. }
  20. $db->query("CREATE DATABASE IF NOT EXISTS `{$PZ['DB_NAME']}`;");
  21. $db->query("use `{$PZ['DB_NAME']}`");
  22. $db->set_charset("utf8");
  23. $rs = $db->query("CREATE TABLE IF NOT EXISTS cdk (
  24. id int(11) NOT NULL AUTO_INCREMENT,
  25. `cdk` varchar(32) NOT NULL,
  26. `lv` tinyint(4) DEFAULT NULL,
  27. `qid` int(8) DEFAULT NULL,
  28. `uid` varchar(32) DEFAULT NULL,
  29. `pass` varchar(32) DEFAULT NULL,
  30. `status` tinyint(4) DEFAULT '0',
  31. PRIMARY KEY (id ))ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
  32. $db->close();
  33. exit("<script>alert('CDKEY数据表创建成功');window.location.reload();</script>");
  34. }
  35. if($yzf->connect_error){
  36. exit("数据库连接失败,请检查数据库密码是否正确!");
  37. }
  38. if (!$yzf->set_charset("utf8")) {
  39. printf("设置数据库编码utf8错误: %s\n", $yzf->error);
  40. exit();
  41. }
  42. for($i=1;$i<=$num;$i++){
  43. $cdk = cdkey('LengYuZe');
  44. $txt .= $cdk."\r\n";
  45. if(!$yzf->query("INSERT INTO cdk (cdk,lv) VALUES ('{$cdk}','{$lv}');")){die("<script>alert('生成失败,请查看数据库连接是否正常');window.history.back(-1); </script>");}
  46. }
  47. $yzf->close();
  48. $ts = time().'.txt';
  49. file_put_contents('cdks/'.$zame.$ts,$txt);
  50. Header ( "Content-type: application/octet-stream" );
  51. Header ( "Accept-Ranges: bytes" );
  52. Header ( "Content-Disposition: attachment; filename=".$zame.$ts);
  53. die($txt);
  54. function cdkey($namespace = null) {
  55. static $guid = '';
  56. $uid = uniqid ( "", true );
  57. $data = $namespace;
  58. $data .= $_SERVER ['REQUEST_TIME'];
  59. $data .= $_SERVER ['HTTP_USER_AGENT'];
  60. $data .= $_SERVER ['SERVER_ADDR'];
  61. $data .= $_SERVER ['SERVER_PORT'];
  62. $data .= $_SERVER ['REMOTE_ADDR'];
  63. $data .= $_SERVER ['REMOTE_PORT'];
  64. $hash = strtoupper (substr(md5($uid.$data), 8, 16));
  65. $guid = substr ( $hash, 0, 4 ) . '-' . substr ( $hash, 4, 4 ) . '-' . substr ( $hash, 8, 4 ) . '-' . substr ( $hash, 12, 4 );
  66. return $guid;
  67. }
  68. ?><?php