mysql_db_setup_program_filesname.php

广告交换系统,详细的内容,请参见代码,没有加密的!

<?php
require("yanet_ads_config_file_inc.php");

	$id = mysql_connect($MYSQL_HOST,$MYSQL_USER,$MYSQL_PASS);
	$tab_c=mysql_create_db($DAT_NAME,$id);
	mysql_select_db($DAT_NAME,$id);
	$userdat_c=mysql_query("CREATE TABLE userdat (user varchar(10) NOT NULL,pass varchar(15),email1 varchar(100), email2 varchar(100),webtype varchar(20),about varchar(255),webbt varchar(100),web1 varchar(100),web2 varchar(100),name varchar(10),sex varchar(6),old varchar(10),adss varchar(255),pos varchar(10),adsdisped INTEGER DEFAULT '0' NOT NULL,adsclicked INTEGER DEFAULT '0' NOT NULL,money DOUBLE DEFAULT '0',disped INTEGER DEFAULT '0' NOT NULL,clicked INTEGER DEFAULT '0' NOT NULL,odisped INTEGER DEFAULT '0' NOT NULL,oclicked INTEGER DEFAULT '0' NOT NULL,ip1 varchar(20),ip2 varchar(20),ip3 varchar(20),ip4 varchar(20),ip5 varchar(20),ip6 varchar(20),ip7 varchar(20),ip8 varchar(20),ip9 varchar(20),ip10 varchar(20),ip11 varchar(20),ip12 varchar(20),ip13 varchar(20),ip14 varchar(20),ip15 varchar(20),ip16 varchar(20),ip17 varchar(20),ip18 varchar(20),ip19 varchar(20),ip20 varchar(20),ip21 varchar(20),ip22 varchar(20),ip23 varchar(20),ip24 varchar(20),ip25 varchar(20),ip26 varchar(20),ip27 varchar(20),ip28 varchar(20),ip29 varchar(20),ip30 varchar(20),ip31 varchar(20),ip32 varchar(20),ip33 varchar(20),ip34 varchar(20),ip35 varchar(20),ip36 varchar(20),ip37 varchar(20),ip38 varchar(20),ip39 varchar(20),ip40 varchar(20),userok INTEGER,addtime INTEGER,nowdate CHAR(10),paiming INTEGER DEFAULT '0' NOT NULL,depiao INTEGER DEFAULT '0' NOT NULL,linktype INTEGER DEFAULT '0' NOT NULL,adstype INTEGER DEFAULT '0' NOT NULL,emailtype INTEGER DEFAULT '0' NOT NULL,sendemail INTEGER DEFAULT '0' NOT NULL,openemail INTEGER DEFAULT '0' NOT NULL,PRIMARY KEY (user),zhiwu varchar(20),call varchar(50),phone varchar(30),corp varchar(100),idcard varchar(20))",$id);
	$ggdat_c=mysql_query("CREATE TABLE ggdat (user varchar(10) NOT NULL,pass varchar(15),email varchar(100), webtype varchar(20),about varchar(255),web varchar(100),ggbt varchar(100),name varchar(10),adss varchar(255),pos varchar(10),phone varchar(25) NOT NULL,idcard varchar(18),sex varchar(6),disped INTEGER DEFAULT '0' NOT NULL,clicked INTEGER DEFAULT '0' NOT NULL,odisped INTEGER DEFAULT '0' NOT NULL,oclicked INTEGER DEFAULT '0' NOT NULL,userok INTEGER,PRIMARY KEY (user))",$id);
	$picdat_c=mysql_query("CREATE TABLE picdat (user varchar(10) NOT NULL,pass varchar(15),idcard varchar(18),phone varchar(30),corp varchar(30),call varchar(40),email varchar(100), webtype varchar(20),about varchar(255),web varchar(100),ggbt varchar(100),name varchar(10),adss varchar(255),pos varchar(10),sex varchar(6),disped INTEGER DEFAULT '0' NOT NULL,clicked INTEGER DEFAULT '0' NOT NULL,odisped INTEGER DEFAULT '0' NOT NULL,oclicked INTEGER DEFAULT '0' NOT NULL,userok INTEGER,PRIMARY KEY (user))",$id);
	$ipdat_c=mysql_query("CREATE TABLE dispipdat (ip varchar(15) NOT NULL,time INTEGER  DEFAULT '0',PRIMARY KEY (ip))",$id);
	$ipdat_c=mysql_query("CREATE TABLE clickipdat (ip varchar(15) NOT NULL,time INTEGER  DEFAULT '0',PRIMARY KEY (ip))",$id);
	$admin_c=mysql_query("CREATE TABLE admin (user varchar(10) NOT NULL,pass varchar(15),ip varchar(15),time INTEGER  DEFAULT '0',PRIMARY KEY (user))",$id);

	$lll=mysql_query("INSERT INTO admin (user,pass) VALUES ('admin','666030')",$id);

	echo "设定已经完成！";
	mysql_close($id);
?>