cdks.php 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. <?php
  2. ini_set('date.timezone','Asia/Shanghai');
  3. date_default_timezone_set ( 'PRC' );//时区
  4. header("Content-type:text/html;charset=utf-8");
  5. error_reporting(0);
  6. $sqm = $_POST['sqm'];
  7. $num = $_POST['num'];
  8. include "config.php";
  9. $zame = 'PAY_';
  10. $sqm != $d_gmrz && (die("<script>alert('授权码错误');window.history.back(-1); </script>"));
  11. $num > 1000 && (die("<script>alert('单次最多生成100条');window.history.back(-1); </script>"));
  12. $num == '' && ($num = 1);
  13. $root=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(50) CHARACTER SET utf8 NULL,
  26. `type` int(11) NULL DEFAULT '0',
  27. `status` int(11) NULL DEFAULT '0',
  28. `uid` varchar(50) CHARACTER SET utf8 NULL DEFAULT '0',
  29. `pass` varchar(50) CHARACTER SET utf8 NULL,
  30. `qid` varchar(50) CHARACTER SET utf8 NULL,
  31. PRIMARY KEY (id ))ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
  32. $db->close();
  33. exit("<script>alert('在线福利数据表创建成功');window.location.reload();</script>");
  34. }
  35. if($root->connect_error){
  36. exit("数据库连接失败,请检查数据库密码是否正确!");
  37. }
  38. if (!$root->set_charset("utf8")) {
  39. printf("设置数据库编码utf8错误: %s\n", $root->error);
  40. exit();
  41. }
  42. for($i=1;$i<=$num;$i++){
  43. $cdk = cdkey('iguozicc');
  44. $txt .= $cdk."\n";
  45. if(!$root->query("INSERT INTO cdk (cdk) VALUES ('{$cdk}');")){die("<script>alert('生成失败,请查看数据库连接是否正常');window.history.back(-1); </script>");}
  46. }
  47. $root->close();
  48. $ts = time().'.txt';
  49. Header ( "Content-type: application/octet-stream" );
  50. Header ( "Accept-Ranges: bytes" );
  51. Header ( "Content-Disposition: attachment; filename=".$zame.$ts);
  52. die($txt);
  53. function cdkey($namespace = null) {
  54. static $guid = '';
  55. $uid = uniqid ( "", true );
  56. $data = $namespace;
  57. $data .= $_SERVER ['REQUEST_TIME'];
  58. $data .= $_SERVER ['HTTP_USER_AGENT'];
  59. $data .= $_SERVER ['SERVER_ADDR'];
  60. $data .= $_SERVER ['SERVER_PORT'];
  61. $data .= $_SERVER ['REMOTE_ADDR'];
  62. $data .= $_SERVER ['REMOTE_PORT'];
  63. $hash = strtoupper (substr(md5($uid.$data), 8, 16));
  64. $guid = substr ( $hash, 0, 4 ) . '-' . substr ( $hash, 4, 4 ) . '-' . substr ( $hash, 8, 4 ) . '-' . substr ( $hash, 12, 4 );
  65. return $guid;
  66. }
  67. ?>