site kurma...

merhaba arkadaşlar ben bir tane script buldum bayaa büyük. site bu http:\\piratequest.net
indirdiğim yerde burası
Pirate Quest browser online game script indir Download » File TURK - TÜRKİYENİN Dev Paylaşım Ağı..!

dosyalara baktım siteyle uyuşuyor yani sahte değil ama kurmakta sıkıntı çektim.Sitenin database sini kuracam hata veriyor

database.sql dosyası bu

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `ab_historical_data` (
`ip_address` varchar(15) NOT NULL,
`referral_page` varchar(255) NOT NULL,
`converted` int(5) NOT NULL,
`time_started` int(30) NOT NULL,
`time_ended` int(15) NOT NULL,
`test_id` int(15) NOT NULL,
`step` int(15) NOT NULL,
`page_id` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `ab_pages` (
`id` int(12) NOT NULL,
`page_impressions` varchar(255) NOT NULL,
`test_id` int(12) NOT NULL,
`active` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `banned` (
`id` int(15) NOT NULL,
`ip` varchar(15) NOT NULL,
`reason` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `daily_actions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`active` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `daily_actions` (`id`, `name`, `active`) VALUES
(1, 'test', 1);

CREATE TABLE `daily_current_tracking` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `game_settings` (
`game_active` int(1) NOT NULL,
`game_inactive_message` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `game_settings` (`game_active`, `game_inactive_message`) VALUES
(1, '');

CREATE TABLE `inactive_users` (
`login_name` varchar(100) NOT NULL,
`password` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `ships` (
`owner_id` int(12) NOT NULL,
`navigation_max` int(12) NOT NULL,
`navigation` int(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `staff_ip` (
`ip` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `stats` (
`online` int(15) NOT NULL,
`onlinetoday` int(15) NOT NULL,
`totalusers` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `users` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`active` int(5) NOT NULL,
`login_name` varchar(100) NOT NULL,
`password` varchar(32) NOT NULL,
`user_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`user_level` int(5) NOT NULL,
`sessionkey` varchar(50) NOT NULL,
`last_ip` varchar(20) NOT NULL,
`last_useragent` varchar(32) NOT NULL,
`gender` int(5) NOT NULL,
`last_ip2` varchar(15) NOT NULL,
`reg_ip` varchar(15) NOT NULL,
`join_date` int(15) NOT NULL,
`referedby` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`ad_refer` varchar(100) NOT NULL,
`notifications` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `user_levels` (
`id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

acaba burada düzenleme mi yapmam gerekiyor nasıl düzenleyeceğim bir yardımcı olursanız sevinirim bu arada kuracağım site funpic.de