Printable View
hi guy ,here is the setting for
AuditionGameServer\Data\ServerInfo.ini
[ServerConnection]
DBAgentServerIP2 = 127.0.0.1
MessengerServerIP = 127.0.0.1
itemDBServerIP = 127.0.0.1
ServerID = 1
all can be running(except game shop)....but still need to add more table on ur Database "itemdb"
easy :clap_1:
nice ..but me have this info and crash same..how can do it?.THANKS
just try it ,and add some lost data in ur databse (itemdb)
can share ur itemdb.sql. can enter?
share u later.....
thanks man only need to get the error in item db that is arrive_stat table dunno what to do to fix hehe..
/*
SQLyog Community Edition- MySQL GUI v6.0 RC 2
Host - 5.0.41-community-nt : Database - itemdb
*********************************************************************
Server version : 5.0.41-community-nt
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
create database if not exists `itemdb`;
USE `itemdb`;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*Table structure for table `admininfo` */
DROP TABLE IF EXISTS `admininfo`;
CREATE TABLE `admininfo` (
`UserSN` int(10) unsigned NOT NULL auto_increment,
`UserIP` varchar(16) NOT NULL default '',
`UserID` varchar(22) NOT NULL default '',
`Password` varchar(23) NOT NULL default '',
`Power` tinyint(2) unsigned NOT NULL default '0',
PRIMARY KEY (`UserSN`),
UNIQUE KEY `UserID` (`UserID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `admininfo` */
insert into `admininfo`(`UserSN`,`UserIP`,`UserID`,`Password`,`Power`) values (1,'127.0.0.1','slickone','123456',0);
/*Table structure for table `arrive_stat` */
DROP TABLE IF EXISTS `arrive_stat`;
CREATE TABLE `arrive_stat` (
`UserSN` int(11) default NULL,
`UpdateTime` time default NULL,
`Type` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `arrive_stat` */
insert into `arrive_stat`(`UserSN`,`UpdateTime`,`Type`) values (1,NULL,NULL);
/*Table structure for table `avatar_default` */
DROP TABLE IF EXISTS `avatar_default`;
CREATE TABLE `avatar_default` (
`avatar` int(11) NOT NULL,
`UserSN` int(11) NOT NULL,
`CurrentType` int(11) NOT NULL,
`OriginalType` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_default` */
insert into `avatar_default`(`avatar`,`UserSN`,`CurrentType`,`OriginalType`) values (0,1,0,0);
/*Table structure for table `avatar_equip` */
DROP TABLE IF EXISTS `avatar_equip`;
CREATE TABLE `avatar_equip` (
`hair` int(11) NOT NULL,
`face` int(11) NOT NULL,
`pants` int(11) NOT NULL,
`shoes` int(11) NOT NULL,
`sets1` int(11) NOT NULL,
`sets2` int(11) NOT NULL,
`jacket` int(11) NOT NULL,
`pet` int(11) NOT NULL,
`hairdate` date NOT NULL,
`facedate` date NOT NULL,
`jacketdate` date NOT NULL,
`pantsdate` date NOT NULL,
`shoesdate` date NOT NULL,
`setsdate1` date NOT NULL,
`setsdate2` date NOT NULL,
`petdate` date NOT NULL,
`UserSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_equip` */
insert into `avatar_equip`(`hair`,`face`,`pants`,`shoes`,`sets1`,`sets2`,`jacket`,`pet`,`hairdate`,`facedate`,`jacketdate`,`pantsdate`,`shoesdate`,`setsdate1`,`setsdate2`,`petdate`,`UserSN`) values (65535,65535,65535,65535,65535,65535,65535,65535,'2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22','2007-11-22',1);
/*Table structure for table `avatar_inventory_face` */
DROP TABLE IF EXISTS `avatar_inventory_face`;
CREATE TABLE `avatar_inventory_face` (
`UserSN` int(11) NOT NULL auto_increment,
`ExpiredDate` int(11) NOT NULL,
`itemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL,
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_face` */
/*Table structure for table `avatar_inventory_hair` */
DROP TABLE IF EXISTS `avatar_inventory_hair`;
CREATE TABLE `avatar_inventory_hair` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`itemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_hair` */
/*Table structure for table `avatar_inventory_items` */
DROP TABLE IF EXISTS `avatar_inventory_items`;
CREATE TABLE `avatar_inventory_items` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`AI_ID` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`UseItem` int(11) NOT NULL,
`RemainCount` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_items` */
/*Table structure for table `avatar_inventory_jacket` */
DROP TABLE IF EXISTS `avatar_inventory_jacket`;
CREATE TABLE `avatar_inventory_jacket` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_jacket` */
/*Table structure for table `avatar_inventory_pants` */
DROP TABLE IF EXISTS `avatar_inventory_pants`;
CREATE TABLE `avatar_inventory_pants` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_pants` */
/*Table structure for table `avatar_inventory_pet` */
DROP TABLE IF EXISTS `avatar_inventory_pet`;
CREATE TABLE `avatar_inventory_pet` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_pet` */
/*Table structure for table `avatar_inventory_sets` */
DROP TABLE IF EXISTS `avatar_inventory_sets`;
CREATE TABLE `avatar_inventory_sets` (
`UserSN` int(11) NOT NULL auto_increment,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL,
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_sets` */
/*Table structure for table `avatar_inventory_shoes` */
DROP TABLE IF EXISTS `avatar_inventory_shoes`;
CREATE TABLE `avatar_inventory_shoes` (
`UserSN` int(11) NOT NULL,
`ExpiredDate` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`BuyNick` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `avatar_inventory_shoes` */
/*Table structure for table `basket` */
DROP TABLE IF EXISTS `basket`;
CREATE TABLE `basket` (
`UserSN` int(10) NOT NULL auto_increment,
`ItemID` int(255) NOT NULL,
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `basket` */
/*Table structure for table `board_item_info` */
DROP TABLE IF EXISTS `board_item_info`;
CREATE TABLE `board_item_info` (
`UserSN` int(11) NOT NULL,
`Type` varchar(10) NOT NULL,
`Color` varchar(10) NOT NULL,
`BeforeMoney` int(10) NOT NULL,
`Price` varchar(255) NOT NULL,
`AfterMoney` int(10) NOT NULL,
`BoardMsg` varchar(255) default NULL,
`DestServer` varchar(255) default NULL,
`UserTime` time NOT NULL default '00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `board_item_info` */
insert into `board_item_info`(`UserSN`,`Type`,`Color`,`BeforeMoney`,`Price`,`AfterMoney`,`BoardMsg`,`DestServer`,`UserTime`) values (1,'0','4294506744',9999969,'30',9999939,'hihi','1','00:00:00'),(1,'0','4294506744',9999909,'30',9999879,'hihi','1','00:00:00'),(1,'0','4294506744',9999879,'30',9999849,'hihi','1','00:00:00'),(1,'0','4294506744',9999849,'30',9999819,'hiohikjlhjkhgjk','1','00:00:00'),(1,'0','4294506744',9999819,'30',9999789,'hihi','1','00:00:00'),(1,'0','4294506744',9999789,'30',9999759,'hihi','1','00:00:00'),(1,'0','4294506744',9999759,'30',9999729,'hihihi','1','00:00:00');
/*Table structure for table `board_item_point` */
DROP TABLE IF EXISTS `board_item_point`;
CREATE TABLE `board_item_point` (
`Point` varchar(255) NOT NULL,
`UserSN` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`UserSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `board_item_point` */
insert into `board_item_point`(`Point`,`UserSN`) values ('10026',1);
/*Table structure for table `color_pen` */
DROP TABLE IF EXISTS `color_pen`;
CREATE TABLE `color_pen` (
`PenColor` int(11) NOT NULL,
`UserSN` int(11) NOT NULL,
`Usecount` int(11) NOT NULL,
`LastTime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `color_pen` */
insert into `color_pen`(`PenColor`,`UserSN`,`Usecount`,`LastTime`) values (1,1,1,0);
/*Table structure for table `coordi` */
DROP TABLE IF EXISTS `coordi`;
CREATE TABLE `coordi` (
`CoordiNum` int(11) NOT NULL,
`CoordiName` varchar(255) NOT NULL,
`UserSN` int(11) NOT NULL,
`Hair` varchar(255) NOT NULL,
`Face` varchar(255) NOT NULL,
`Shirts` varchar(255) NOT NULL,
`Pants` varchar(255) NOT NULL,
`Shoes` varchar(255) NOT NULL,
`Sets1` varchar(255) NOT NULL,
`Sets2` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `coordi` */
/*Table structure for table `present_list` */
DROP TABLE IF EXISTS `present_list`;
CREATE TABLE `present_list` (
`PresentID` int(11) NOT NULL,
`ItemID` int(11) NOT NULL,
`Period` varchar(255) NOT NULL,
`SendDate` time NOT NULL,
`RecvDate` time NOT NULL,
`SendNick` varchar(255) NOT NULL,
`UseCount` int(11) NOT NULL,
`RecvSN` int(11) NOT NULL,
`RecvNick` varchar(255) NOT NULL,
`SendSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `present_list` */
/*Table structure for table `usercash` */
DROP TABLE IF EXISTS `usercash`;
CREATE TABLE `usercash` (
`cash` int(11) NOT NULL,
`UserSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `usercash` */
insert into `usercash`(`cash`,`UserSN`) values (9999729,1);
/*Table structure for table `userden` */
DROP TABLE IF EXISTS `userden`;
CREATE TABLE `userden` (
`den` int(11) NOT NULL,
`UserSN` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `userden` */
insert into `userden`(`den`,`UserSN`) values (999999,1);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Thanks alot man =D
still got error when Data insert into BASKET
(colomn count doesn't match value count at row 1)
thank a lot......great.....