[ alexandarciric @ 04.05.2007. 12:07 ] @
Dragi forumasi potrebna mi je pomoc. Kako da ovo izvedem, tj kojom komandom....ovo mi je tabela Code: -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 03, 2007 at 11:44 PM -- Server version: 4.1.21 -- PHP Version: 4.4.2 -- -- Database: `politic_pol` -- -- -------------------------------------------------------- -- -- Table structure for table `long2_players` -- CREATE TABLE `long2_players` ( `username` tinytext character set cp1250 collate cp1250_croatian_ci NOT NULL, `password` varchar(32) character set cp1250 collate cp1250_croatian_ci NOT NULL default '', `rsalt` int(11) NOT NULL default '0', `name` tinytext NOT NULL, `email` tinytext NOT NULL, `IP` tinytext NOT NULL, `signedup` int(11) NOT NULL default '0', `ismulti` tinyint(3) unsigned NOT NULL default '0', `disabled` tinyint(3) unsigned NOT NULL default '0', `online` tinyint(3) unsigned NOT NULL default '0', `vacation` smallint(5) unsigned NOT NULL default '0', `idle` int(11) NOT NULL default '0', `free` int(11) NOT NULL default '0', `style` tinyint(3) unsigned NOT NULL default '1', `empire` tinytext NOT NULL, `num` mediumint(8) unsigned NOT NULL auto_increment, `race` tinyint(3) unsigned NOT NULL default '1', `era` tinyint(3) unsigned NOT NULL default '1', `rank` mediumint(8) unsigned NOT NULL default '0', `clan` smallint(5) unsigned NOT NULL default '0', `forces` tinyint(3) unsigned NOT NULL default '0', `allytime` int(11) NOT NULL default '0', `attacks` int(10) unsigned NOT NULL default '0', `offsucc` int(10) unsigned NOT NULL default '0', `offtotal` int(10) unsigned NOT NULL default '0', `defsucc` int(10) unsigned NOT NULL default '0', `deftotal` int(10) unsigned NOT NULL default '0', `kills` int(10) unsigned NOT NULL default '0', `turns` int(10) unsigned NOT NULL default '0', `turns_last` int(11) NOT NULL default '0', `hour_last` int(11) NOT NULL default '0', `turnsstored` int(10) unsigned NOT NULL default '0', `turnsused` int(10) unsigned NOT NULL default '0', `networth` bigint(20) unsigned NOT NULL default '0', `cash` bigint(20) unsigned NOT NULL default '100000', `food` bigint(20) unsigned NOT NULL default '10000', `peasants` int(10) unsigned NOT NULL default '500', `troops` varchar(210) NOT NULL default '', `health` tinyint(3) unsigned NOT NULL default '100', `wizards` int(10) unsigned NOT NULL default '0', `runes` int(10) unsigned NOT NULL default '500', `shield` int(11) NOT NULL default '0', `gate` int(11) NOT NULL default '0', `production` varchar(30) NOT NULL default '', `land` int(10) unsigned NOT NULL default '250', `shops` int(10) unsigned NOT NULL default '5', `homes` int(10) unsigned NOT NULL default '20', `industry` int(10) unsigned NOT NULL default '0', `barracks` int(10) unsigned NOT NULL default '5', `labs` int(10) unsigned NOT NULL default '0', `farms` int(10) unsigned NOT NULL default '15', `towers` int(10) unsigned NOT NULL default '0', `freeland` int(10) unsigned NOT NULL default '205', `tax` tinyint(3) unsigned NOT NULL default '10', `savings` bigint(20) unsigned NOT NULL default '0', `loan` bigint(20) unsigned NOT NULL default '0', `pvmarket` varchar(210) NOT NULL default '', `pvmarket_last` int(11) NOT NULL default '0', `pmkt_food` bigint(20) unsigned NOT NULL default '100000', `bmper` varchar(60) NOT NULL default '', `bmper_last` int(11) NOT NULL default '0', `aidcred` tinyint(3) unsigned NOT NULL default '5', `aidcred_got` int(11) NOT NULL default '0', `msgcred` tinyint(3) unsigned NOT NULL default '10', `msgcred_got` int(11) NOT NULL default '0', `msgtime` int(11) NOT NULL default '0', `newstime` int(11) NOT NULL default '0', `notes` text, `loggedin` tinyint(2) NOT NULL default '0', `hero_war` tinyint(4) NOT NULL default '0', `hero_peace` tinyint(4) NOT NULL default '0', `hero_special` tinyint(4) NOT NULL default '0', `heroes_used` int(11) NOT NULL default '0', `warset` int(11) NOT NULL default '0', `warset_time` int(11) NOT NULL default '0', `peaceset` int(11) NOT NULL default '0', `peaceset_time` int(11) NOT NULL default '0', `profile` text NOT NULL, `igname` text NOT NULL, `aim` mediumtext NOT NULL, `msn` mediumtext NOT NULL, `stocks` text NOT NULL, `l_attack` mediumint(9) NOT NULL default '0', `num_bounties` int(11) NOT NULL default '0', `hide` tinyint(2) NOT NULL default '0', `condense` tinyint(2) NOT NULL default '1', `atkforstruct` tinyint(2) NOT NULL default '1', `folders` text NOT NULL, `menu_lite` tinyint(2) NOT NULL default '0', `validated` tinyint(2) NOT NULL default '1', `vote` tinyint(4) NOT NULL default '0', `newssort` tinyint(2) NOT NULL default '0', `std_bld` tinyint(2) NOT NULL default '1', PRIMARY KEY (`num`,`signedup`), KEY `networth` (`networth`), KEY `rank` (`rank`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=503 ; -- -- Dumping data for table `long2_players` -- INSERT INTO `long2_players` VALUES ('admin', '5f4dcc3b5aa765d61d8327deb882cf99', 20093, 'Administrative Officer', '[email protected]', '87.116.141.36', 1124054137, 0, 2, 0, 0, 1178227788, 0, 1, 'Administrator', 1, 1, 2, 199, 52, 0, 0, 0, 0, 0, 0, 0, 19, 250, 1178226000, 1178226000, 400, 10, 613051, 194471, 58095, 6775, '0|0|0|0', 100, 0, 500, 0, 0, '25|25|25|25', 995, 5, 20, 0, 5, 0, 15, 0, 950, 10, 0, 0, '2581667|1548167|774083|516055', 1177794000, 2020000, '0|0|0|0', 0, 5, 1176152400, 10, 1178226000, 1178227783, 1124054137, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'Admin', '', '', '1000|1000|1000|1000|1000|1000|1000|1000|1000|1000', 0, 0, 1, 1, 1, 'Inbox|Sent', 0, 1, 0, 0, 0); INSERT INTO `long2_players` VALUES ('coadmin', '4674e635cead9aac66b6984e49ceaad9', 26719, 'CO Administratior', '[email protected]', '87.116.176.114', 1175723946, 0, 2, 0, 0, 1178217009, 0, 1, 'CO-Administrator', 2, 1, 1, 199, 52, 0, 0, 0, 0, 0, 0, 0, 0, 250, 1178215200, 1178215200, 400, 0, 147036, 26469, 10000, 500, '0|0|0|0', 100, 0, 500, 0, 0, '25|25|25|25', 250, 5, 20, 0, 5, 0, 15, 0, 205, 10, 0, 0, '10033|6020|3010|2007', 1176217200, 113250, '0|0|0|0', 0, 5, 0, 10, 1177974000, 1177974294, 1177962482, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'CO-Administrator', '', '', '1000|1000|1000|1000|1000|1000|1000|1000|1000|1000', 0, 0, 0, 1, 1, 'Inbox|Sent', 0, 1, 0, 1, 1); INSERT INTO `long2_players` VALUES ('nesch', 'aa65c74751de899d65f32fec2399558c', 23102, 'Nenad Mijatovic', '[email protected]', '89.216.145.98', 1175724102, 0, 0, 0, 0, 1178221273, 0, 1, 'Vracar', 6, 7, 2, 18, 14, 11, 1175767986, 0, 820, 866, 28, 681, 0, 22, 1178226000, 1178226000, 232, 7234, 23357411, 0, 0, 66564, '3210243|1207965|373970|62533', 86, 1515485, 53413, 1176747057, 1178246139, '100|0|0|0', 26688, 0, 0, 5718, 0, 18770, 2200, 0, 0, 5, 0, 0, '6658789|10479859|6757277|6729763', 1178200800, 35816000, '0|7500|7500|7500', 1177959600, 5, 1175824800, 10, 1178211600, 1178212666, 1178214617, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'Vracar', '', '', '1000|1000|1000|1000|1000|1000|1000|1000|1000|1000', 325, 0, 0, 1, 1, 'Inbox|Sent', 0, 1, 0, 0, 0); a zelim da u toj tabeli se u svim VALUES-ima menja sledece u: Code: online=0, era=1, rank=0, attacks=0, offsucc=0, offtotal=0, defsucc=0, deftotal=0, kills=0, turns=$config[initturns], turnsstored=0, turnsused=0, networth=147810, cash=100000, food=10000, peasants=500, armtrp=100, lndtrp=15, flytrp=10, seatrp=0, health=100, wizards=0, runes=500, shield=0, gate=0, ind_armtrp=25, ind_lndtrp=25, ind_flytrp=25, ind_seatrp=25, land=250, shops=5, homes=20, industry=0, barracks=5, labs=0, farms=15, towers=0, freeland=205, tax=10, savings=0, loan=0, pmkt_armtrp=5000, pmkt_lndtrp=5000, pmkt_flytrp=5000, pmkt_seatrp=5000, pmkt_food=100000, bmperarmtrp=0, bmperlndtrp=0, bmperflytrp=0, bmperseatrp=0, aidcred=5, msgcred=5"); |