Dalga mı geçiyorsun ?
Yardım isteyeceksen öncelikle üslubuna uygun ve ayrıntılı iste. Gördüğüm kadarıyla dosya "Metin2" için hazırlanmış. Yukarıda verdiğin kodlarda değişkenden başka bir halt yok. Buradan çıkarabileceğin max. sonuç budur;
`gold_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`silver_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`safebox_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`autoloot_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`fish_mind_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`marriage_fast_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`money_drop_rate_expire` datetime NOT NULL default '2015-01-01 00:00:00',
Dediğim gibi Metin2 içinse al buda tablo
CREATE TABLE `account` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(30) character set latin1 collate latin1_german1_ci NOT NULL default '',
`password` varchar(45) NOT NULL default '',
`real_name` varchar(16) NOT NULL default '',
`social_id` varchar(13) default '',
`email` varchar(64) NOT NULL default '',
`phone1` varchar(16) default NULL,
`phone2` varchar(16) default NULL,
`address` varchar(128) default NULL,
`zipcode` varchar(7) NOT NULL default '',
`create_time` datetime NOT NULL default '0000-00-00 00:00:00',
`question1` varchar(48) default NULL,
`answer1` varchar(48) default NULL,
`question2` varchar(48) default NULL,
`answer2` varchar(48) default NULL,
`is_testor` tinyint(1) NOT NULL default '0',
`status` varchar(8) NOT NULL default 'OK',
`securitycode` varchar(192) default '',
`newsletter` tinyint(1) NOT NULL default '0',
`empire` tinyint(4) NOT NULL default '0',
`name_checked` tinyint(1) NOT NULL default '0',
`availDt` datetime NOT NULL default '0000-00-00 00:00:00',
`mileage` int(11) NOT NULL default '0',
`cash` int(11) NOT NULL default '0',
`gold_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`silver_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`safebox_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`autoloot_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`fish_mind_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`marriage_fast_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`money_drop_rate_expire` datetime NOT NULL default '2015-01-01 00:00:00',
`ttl_cash` int(11) NOT NULL default '0',
`ttl_mileage` int(11) NOT NULL default '0',
`channel_company` varchar(30) NOT NULL default '',
`coins` int(11) NOT NULL default '0',
`web_admin` int(1) NOT NULL default '0',
`web_ip` varchar(15) NOT NULL,
`web_aktiviert` varchar(32) NOT NULL,
`last_play` datetime default NULL,
`ban_sure` varchar(30) NOT NULL,
`ban_neden` varchar(30) NOT NULL,
`ban_time` datetime NOT NULL,
`ticket_id` varchar(30) NOT NULL,
`kim_banlamis` varchar(30) NOT NULL,
`server` int(1) NOT NULL default '4',
`bilgi` int(11) NOT NULL default '1',
`email_onay` int(11) NOT NULL default '0',
`banacilis` varchar(25) NOT NULL,
`dost` varchar(25) NOT NULL,
`gecici` varchar(90) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`),
KEY `social_id` (`social_id`)
) ENGINE=MyISAM AUTO_INCREMENT=70007741 DEFAULT CHARSET=ascii;