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);
-- 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");
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");