ama bence hata burdan kaynaklanmıyo cünkü hiç bi sql dosyası yukleyemedim 3 tanedene gerçi hepside ***** script belki sql dosyası bozuk verilmişti bileme tabi işin ehli değiliz


-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 12, 2007 at 03:26 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `MyScript`
--

-- --------------------------------------------------------

--
-- Table structure for table `banned`
--

CREATE TABLE `banned` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(20) NOT NULL default '',
`date` int(50) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

--
-- Dumping data for table `banned`
--

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
`id` int(10) NOT NULL auto_increment,
`title` text NOT NULL,
`location` int(2) NOT NULL,
`code` text NOT NULL,
`active` int(1) NOT NULL,
`addon` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` (`id`, `title`, `location`, `code`, `active`, `addon`) VALUES
(1, 'Scout', 3, 'scout.php?tru=$tru', 1, '0'),
(2, 'The Lab', 3, 'produce.php?tru=$tru', 1, '0'),
(3, 'Discipline', 3, 'collect.php?tru=$tru', 1, '0'),
(4, 'Pimp Store', 3, 'purchase.php?tru=$tru', 1, '0'),
(5, 'Travel', 3, 'travel.php?tru=$tru', 1, '0'),
(6, 'Bank', 3, 'bank.php?tru=$tru', 1, '0'),
(7, 'Attack', 3, 'attack.php?tru=$tru', 1, '0'),
(8, 'Purchase Credits', 3, '../credits.php', 1, '0'),
(9, 'Home', 2, 'index.php', 1, '0'),
(10, 'Play', 2, 'play.php', 1, '0'),
(11, 'My Account', 2, 'myaccount.php', 1, '0'),
(12, 'Purchase Credits', 2, 'credits.php', 1, '0'),
(13, 'Winners', 2, 'winners.php', 1, '0'),
(14, 'logout', 2, 'logout.php', 1, '0'),
(15, 'Home', 1, 'index.php', 1, '0'),
(16, 'Login', 1, 'login.php', 1, '0'),
(17, 'Register', 1, 'signup.php', 1, '0'),
(18, 'Guide', 1, 'guide.php', 1, '0'),
(19, 'Winners', 1, 'winners.php', 1, '0'),
(20, 'Rules', 1, 'rules.php', 1, '0'),
(21, 'Ranks', 5, 'ranks.php?tru=$tru', 1, '0'),
(22, 'Crew Ranks', 5, 'cranks.php?tru=$tru', 1, '0'),
(23, 'Supporter Ranks', 5, 'sranks.php?tru=$tru', 1, '0'),
(24, 'Free Ranks', 5, 'franks.php?tru=$tru', 1, '0'),
(25, 'Global Ranks', 5, 'granks.php?tru=$tru', 1, '0'),
(26, 'Pimp Awards', 5, 'awards.php?tru=$tru', 1, '0'),
(27, 'Find a Pimp', 6, 'pimp.php?tru=$tru', 1, '0'),
(28, 'Find/Create Crew', 6, 'crew.php?tru=$tru', 1, '0'),
(29, 'Who is Online', 6, 'whosonline.php?tru=$tru', 1, '0'),
(30, 'Message Board', 7, 'forum.php?tru=$tru', 1, '0'),
(31, 'Recruiting Board', 7, 'board.php?tru=$tru', 1, '0'),
(32, 'Guide', 8, '../guide.php', 1, '0'),
(33, 'Rules', 8, '../rules.php', 1, '0'),
(34, 'Transfer Credits', 8, 'bank.php?tru=$tru', 1, '0'),
(35, 'Refer Pimps', 8, 'refer.php?tru=$tru', 1, '0'),
(36, 'Exit Round', 8, 'logout.php?tru=$tru', 1, '0'),
(37, 'Home', 4, 'index.php?tru=$tru', 1, '0'),
(38, 'My Settings', 4, 'options.php?tru=$tru', 1, '0'),
(39, 'Mailbox', 4, 'mailbox.php?tru=$tru', 1, '0'),
(40, 'Free Ranks', 4, 'franks.php?tru=$tru', 1, '0'),
(41, 'Global Ranks', 4, 'granks.php?tru=$tru', 1, '0'),
(42, 'Crew Management', 4, 'crew.php?tru=$tru', 1, '0');

-- --------------------------------------------------------

--
-- Table structure for table `cronjobs`
--

CREATE TABLE `cronjobs` (
`cronjob` varchar(32) NOT NULL default '',
`lastran` int(12) NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Dumping data for table `cronjobs`
--
--
-- Table structure for table `bans`
--

CREATE TABLE `bans` (
`banned` varchar(255) NOT NULL default '',
`reason` text NOT NULL,
`expires` int(11) NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Dumping data for table `bans`
--


-- --------------------------------------------------------


--
-- Table structure for table `games`
--

CREATE TABLE `games` (
`round` int(11) NOT NULL auto_increment,
`type` varchar(12) NOT NULL default '',
`speed` tinyint(4) NOT NULL default '2',
`maxbuild` int(11) NOT NULL default '0',
`reserves` int(11) NOT NULL default '0',
`credits` int(11) NOT NULL default '0',
`crewmax` tinyint(4) NOT NULL default '0',
`starts` int(11) NOT NULL default '0',
`ends` int(11) NOT NULL default '0',
`status` varchar(10) NOT NULL default 'normal',
`prize` varchar(255) NOT NULL default '',
`other` varchar(255) NOT NULL default '',
`startjackpot` int(10) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`pause` int(15) NOT NULL default '0',
`first` int(15) NOT NULL default '0',
`second` int(15) NOT NULL default '0',
`third` int(15) NOT NULL default '0',
`auto` int(15) NOT NULL default '0',
`endjackpot` varchar(15) NOT NULL default '0',
`jplock` int(1) NOT NULL default '0',
PRIMARY KEY (`round`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `games`
--


-- --------------------------------------------------------


--
-- Table structure for table `addons`
--

CREATE TABLE `addons` (
`id` int(5) NOT NULL auto_increment,
`addonname` varchar(255) NOT NULL default '',
`code` varchar(255) NOT NULL default '',
`installed` int(1) NOT NULL default '0',
`enable` int(1) NOT NULL default '1',
`type` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `games`
--


-- --------------------------------------------------------
--
-- Table structure for table `html`
--

CREATE TABLE `html` (
`rules` text NOT NULL,
`description` text NOT NULL,
`tos` text NOT NULL,
`guide` text NOT NULL
) ENGINE=MyISAM;

--
-- Dumping data for table `html`
--

INSERT INTO `html` VALUES ('Your Site Rules Here', 'Your Site Description Here, This will show on the front page', 'Your Terms Of Service', 'Your Site Guide');

-- --------------------------------------------------------

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
`id` int(10) NOT NULL auto_increment,
`time` int(11) NOT NULL default '0',
`round` int(10) NOT NULL default '0',
`pimpname` varchar(255) NOT NULL default '',
`action` text NOT NULL,
`ip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `logs`
--


-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
`id` bigint(20) NOT NULL auto_increment,
`news` text NOT NULL,
`posted` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `news`
--

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
`id` int(20) NOT NULL auto_increment,
`tranid` varchar(255) NOT NULL default '',
`amount` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`date` int(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

-- --------------------------------------------------------
--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
`sitename` varchar(255) NOT NULL default '',
`adminemail` varchar(255) NOT NULL default '',
`adminpaypal` varchar(255) NOT NULL default '',
`fullurl` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`refpercent` int(12) NOT NULL default '10',
`refcredits` int(10) NOT NULL default '0',
`licensekey` varchar(255) NOT NULL default '',
`adverts` text NOT NULL,
`withdrawturns` varchar(255) NOT NULL default '',
`depositturns` varchar(255) NOT NULL default '',
`maxdep` varchar(255) NOT NULL default '',
`jackpotper` int(10) NOT NULL default '0',
`bottomadverts` text NOT NULL,
`block` text NOT NULL,
`showblock` varchar(255) NOT NULL default '',
`numbernews` int(10) NOT NULL default '0',
`pimpversion` varchar(255) NOT NULL default '',
`confirm` int(1) NOT NULL default '1'
) ENGINE=MyISAM;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES ('Your Site Name', 'admin@yoursite.com', 'yourpaypal@yoursite.com', 'http://www.yoursite.com/', 'yoursite.com', 10, 100, '', '', '10', '10', 10000000, 10, '', '', '', 5, '3.0RC2','1');

-- --------------------------------------------------------

--
-- Table structure for table `stats`
--

CREATE TABLE `stats` (
`user` char(18) NOT NULL default '',
`round` bigint(20) NOT NULL default '0',
`credits` bigint(20) NOT NULL default '0',
`code` varchar(25) NOT NULL default ''
) ENGINE=MyISAM;

--
-- Dumping data for table `stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(18) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`credits` bigint(20) NOT NULL default '0',
`email` varchar(100) NOT NULL default '',
`fullname` varchar(100) NOT NULL default '',
`age` tinyint(4) NOT NULL default '0',
`messager` varchar(50) NOT NULL default '',
`online` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '0.0.0.0',
`lastip` varchar(15) NOT NULL default '0.0.0.0',
`host` varchar(100) NOT NULL default '',
`code` varchar(32) NOT NULL default '',
`membersince` int(11) NOT NULL default '0',
`status` varchar(12) NOT NULL default 'unverified',
`statusexpire` int(11) NOT NULL default '0',
`reason` varchar(200) NOT NULL default '',
`ref_by` varchar(255) NOT NULL default '',
`ref_amount` bigint(20) NOT NULL default '0',
`ref_credits` bigint(20) NOT NULL default '0',
`ads` varchar(5) NOT NULL default 'yes',
`hitmancon` int(5) NOT NULL default '0',
`thiefcon` int(5) NOT NULL default '0',
`robberycon` int(5) NOT NULL default '0',
`newsletter` ENUM('yes', 'no') NOT NULL DEFAULT 'yes',
PRIMARY KEY (`id`),
KEY `ip` (`ip`),
KEY `lastip` (`lastip`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 0, 'admin@yoursite.com', 'First Lastname', 22, 'N/A:', 1141322544, '88.152.22.182', '88.152.22.182', 'bzq-88-152-22-182.red.bezeqint.net', '6d1777a6e42946d5175a6182bc0f4adb', 1141253352, 'admin', 0, '', '', 0, 0, 'yes', 0, 0, 0,'yes');