History Community ~ All Empires Homepage

Welcome to The Archive on All Empires

Forum Home Forum Home > Regional History or Period History > East Asia
  New Posts New Posts
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login


Forum Lockednewbie question regarding sengoku daimyo?
 Post Reply Post Reply
Author
Message
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Topic: newbie question regarding sengoku daimyo?
    Posted: 23-Mar-2009 at 21:50
Hi I am new user to this forum and wanted to try this out after I found this site in a search on google.
 
I am looking for a complete list of (famous and maybe not so famous) daimyo and samurai of Japan's sengoku jidai era (with particular focus on the early part of the sengoku jidai era just after the onin war 1467-1477).
 
The reason that I am looking for such a list is because I want to use for my hobby game site (www.shugo.nl) and I was wondering if you were able to help me fill in the historical details and correct me where I am wrong. I think I already made a mistake on the map regarding the town of Hirado.
 
I currently have a list of 70 daimyo clans and 130 samurai clans and a list of 150 japanese towns containing such things as the ownership of the town and its wealth in koku, but I am not sure wether the list is correct. I also would like to hear your thoughts as to what is Daimyo and what is Samurai. The list of clans needs to be limited to 200 clans, this is mainly because 1 clan corresponds to 1 player in the game and the site has limited bandwidth. The towns need to have some distance between eachother because they have to fit on a relatively small map. I appreciate to hear your opinion as to what towns and what clans you think should be in the list and why.
 
The next post shows the two sql tables used at the start.
Back to Top
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Posted: 23-Mar-2009 at 21:52

persons (PlayerID, Clan, Playerrank)
VALUES ('1', 'Adachi', 'ronin')");
VALUES ('2', 'Akagawa', 'ronin')");
VALUES ('3', 'Akamatsu', 'buke')");
VALUES ('4', 'Akechi', 'ronin')");
VALUES ('5', 'Akita', 'buke')");
VALUES ('6', 'Akiyama', 'ronin')");
VALUES ('7', 'Akizuki', 'ronin')");
VALUES ('8', 'Amako', 'buke')");
VALUES ('9', 'Amakusa', 'ronin')");
VALUES ('10', 'Anegakoji', 'buke')");
VALUES ('11', 'Arakawa', 'ronin')");
VALUES ('12', 'Arima', 'buke')");
VALUES ('13', 'Asahina', 'ronin')");
VALUES ('14', 'Asai', 'buke')");
VALUES ('15', 'Asakura', 'buke')");
VALUES ('16', 'Asano', 'buke')");
VALUES ('17', 'Ashikaga', 'buke')");
VALUES ('18', 'Ashina', 'buke')");
VALUES ('19', 'Aso', 'ronin')");
VALUES ('20', 'Atagi', 'ronin')");
VALUES ('21', 'Atobe', 'ronin')");
VALUES ('22', 'Awaya', 'ronin')");
VALUES ('23', 'Ayukai', 'ronin')");
VALUES ('24', 'Baba', 'buke')");
VALUES ('25', 'Bessho', 'buke')");
VALUES ('26', 'Bito', 'ronin')");
VALUES ('27', 'Chiba', 'buke')");
VALUES ('28', 'Chosokabe', 'buke')");
VALUES ('29', 'Chokei', 'buke')");
VALUES ('30', 'Daidoji', 'ronin')");
VALUES ('31', 'Date', 'buke')");
VALUES ('32', 'Dodo', 'ronin')");
VALUES ('33', 'Fukubara', 'ronin')");
VALUES ('34', 'Fuwa', 'ronin')");
VALUES ('35', 'Gamo', 'ronin')");
VALUES ('36', 'Goto', 'ronin')");
VALUES ('37', 'Hachisuka', 'buke')");
VALUES ('38', 'Haga', 'ronin')");
VALUES ('39', 'Hara', 'ronin')");
VALUES ('40', 'Hashiba', 'ronin')");
VALUES ('41', 'Hatakeyama', 'buke')");
VALUES ('42', 'Hatano', 'buke')");
VALUES ('43', 'Hayashi', 'ronin')");
VALUES ('44', 'Hirada', 'ronin')");
VALUES ('45', 'Hiraiwa', 'ronin')");
VALUES ('46', 'Hoida', 'ronin')");
VALUES ('47', 'Hojo', 'buke')");
VALUES ('48', 'Honda', 'ronin')");
VALUES ('49', 'Hongo', 'ronin')");
VALUES ('50', 'Honma', 'buke')");
VALUES ('51', 'Hori', 'ronin')");
VALUES ('52', 'Horiuchi', 'ronin')");
VALUES ('53', 'Hosokawa', 'buke')");
VALUES ('54', 'Ichijo', 'ronin')");
VALUES ('55', 'Ii', 'ronin')");
VALUES ('56', 'Ijuin', 'ronin')");
VALUES ('57', 'Ikeda', 'buke')");
VALUES ('58', 'Ikoma', 'ronin')");
VALUES ('59', 'Imagawa', 'buke')");
VALUES ('60', 'Imai', 'ronin')");
VALUES ('61', 'Inaba', 'ronin')");
VALUES ('62', 'Inoue', 'ronin')");
VALUES ('63', 'Inomata', 'ronin')");
VALUES ('64', 'Irobe', 'ronin')");
VALUES ('65', 'Ishikawa', 'ronin')");
VALUES ('66', 'Ishida', 'buke')");
VALUES ('67', 'Ishimaki', 'ronin')");
VALUES ('68', 'Isshiki', 'buke')");
VALUES ('69', 'Itakura', 'ronin')");
VALUES ('70', 'Ito', 'buke')");
VALUES ('71', 'Iwamatsu', 'buke')");
VALUES ('72', 'Jinbo', 'buke')");
VALUES ('73', 'Jo', 'ronin')");
VALUES ('74', 'Kagawa', 'ronin')");
VALUES ('75', 'Kakizaki', 'ronin')");
VALUES ('76', 'Kamei', 'ronin')");
VALUES ('77', 'Kano', 'ronin')");
VALUES ('78', 'Kasahara', 'ronin')");
VALUES ('79', 'Kasai', 'ronin')");
VALUES ('80', 'Kato', 'ronin')");
VALUES ('81', 'Kawazoe', 'ronin')");
VALUES ('82', 'Katsura', 'ronin')");
VALUES ('83', 'Kiire', 'ronin')");
VALUES ('84', 'Kikkawa', 'buke')");
VALUES ('85', 'Kikuchi', 'buke')");
VALUES ('86', 'Kiso', 'buke')");
VALUES ('87', 'Kitabatake', 'buke')");
VALUES ('88', 'Kitajo', 'ronin')");
VALUES ('89', 'Kobayakawa', 'buke')");
VALUES ('90', 'Kodama', 'ronin')");
VALUES ('91', 'Koide', 'ronin')");
VALUES ('92', 'Konishi', 'ronin')");
VALUES ('93', 'Kono', 'buke')");
VALUES ('94', 'Koriki', 'ronin')");
VALUES ('95', 'Kuchiba', 'ronin')");
VALUES ('96', 'Kuroda', 'buke')");
VALUES ('97', 'Kurushima', 'ronin')");
VALUES ('98', 'Kyogoku', 'ronin')");
VALUES ('99', 'Maeda', 'buke')");
VALUES ('100', 'Matsuda', 'buke')");
VALUES ('101', 'Matsudaira', 'buke')");
VALUES ('102', 'Matsumae', 'ronin')");
VALUES ('103', 'Matsunaga', 'ronin')");
VALUES ('104', 'Matsuura', 'buke')");
VALUES ('105', 'Menju', 'ronin')");
VALUES ('106', 'Mikumo', 'ronin')");
VALUES ('107', 'Miura', 'ronin')");
VALUES ('108', 'Miyake', 'ronin')");
VALUES ('109', 'Miyoshi', 'buke')");
VALUES ('110', 'Mizuno', 'buke')");
VALUES ('111', 'Mochizuki', 'ronin')");
VALUES ('112', 'Mogami', 'buke')");
VALUES ('113', 'Moji', 'ronin')");
VALUES ('114', 'Moniwa', 'ronin')");
VALUES ('115', 'Mori', 'buke')");
VALUES ('116', 'Murakami', 'buke')");
VALUES ('117', 'Nabeshima', 'ronin')");
VALUES ('118', 'Nagao', 'buke')");
VALUES ('119', 'Naito', 'ronin')");
VALUES ('120', 'Nakajo', 'ronin')");
VALUES ('121', 'Nambu', 'buke')");
VALUES ('122', 'Naoe', 'ronin')");
VALUES ('123', 'Narita', 'ronin')");
VALUES ('124', 'Neshima', 'ronin')");
VALUES ('125', 'Niiro', 'ronin')");
VALUES ('126', 'Niki', 'buke')");
VALUES ('127', 'Niwa', 'ronin')");
VALUES ('128', 'Nomi', 'ronin')");
VALUES ('129', 'Nukui', 'ronin')");
VALUES ('130', 'Numata', 'ronin')");
VALUES ('131', 'Obata', 'ronin')");
VALUES ('132', 'Oda', 'buke')");
VALUES ('133', 'Ogasawara', 'buke')");
VALUES ('134', 'Okabe', 'ronin')");
VALUES ('135', 'Okada', 'ronin')");
VALUES ('136', 'Okubo', 'ronin')");
VALUES ('137', 'Okudaira', 'ronin')");
VALUES ('138', 'Omori', 'ronin')");
VALUES ('139', 'Omura', 'ronin')");
VALUES ('140', 'Osaki', 'ronin')");
VALUES ('141', 'Ota', 'buke')");
VALUES ('142', 'Otomo', 'buke')");
VALUES ('143', 'Ouchi', 'buke')");
VALUES ('144', 'Rusu', 'ronin')");
VALUES ('145', 'Ryuzoji', 'ronin')");
VALUES ('146', 'Saigo', 'buke')");
VALUES ('147', 'Saito', 'buke')");
VALUES ('148', 'Saka', 'ronin')");
VALUES ('149', 'Sakai', 'ronin')");
VALUES ('150', 'Sakikabara', 'ronin')");
VALUES ('151', 'Sakuma', 'ronin')");
VALUES ('152', 'Sanada', 'ronin')");
VALUES ('153', 'Sasaki', 'buke')");
VALUES ('154', 'Sase', 'ronin')");
VALUES ('155', 'Satake', 'buke')");
VALUES ('156', 'Satomi', 'buke')");
VALUES ('157', 'Shiba', 'buke')");
VALUES ('158', 'Shibata', 'ronin')");
VALUES ('159', 'Shiji', 'ronin')");
VALUES ('160', 'Shimazu', 'buke')");
VALUES ('161', 'Shimizu', 'ronin')");
VALUES ('162', 'Shoni', 'buke')");
VALUES ('163', 'So', 'ronin')");
VALUES ('164', 'Sogo', 'buke')");
VALUES ('165', 'Soma', 'ronin')");
VALUES ('166', 'Sugihara', 'ronin')");
VALUES ('167', 'Suwa', 'buke')");
VALUES ('168', 'Tachibana', 'ronin')");
VALUES ('169', 'Tachihara', 'ronin')");
VALUES ('170', 'Takahashi', 'ronin')");
VALUES ('171', 'Takayama', 'ronin')");
VALUES ('172', 'Takanashi', 'ronin')");
VALUES ('173', 'Takato', 'buke')");
VALUES ('174', 'Takeda', 'buke')");
VALUES ('175', 'Takenaka', 'ronin')");
VALUES ('176', 'Takigawa', 'ronin')");
VALUES ('177', 'Tako', 'ronin')");
VALUES ('178', 'Tamura', 'ronin')");
VALUES ('179', 'Tendo', 'ronin')");
VALUES ('180', 'Terazawa', 'buke')");
VALUES ('181', 'Todo', 'buke')");
VALUES ('182', 'Toki', 'buke')");
VALUES ('183', 'Tomono', 'ronin')");
VALUES ('184', 'Torii', 'ronin')");
VALUES ('185', 'Tsugaru', 'buke')");
VALUES ('186', 'Tsutsui', 'buke')");
VALUES ('187', 'Udono', 'ronin')");
VALUES ('188', 'Uesugi', 'buke')");
VALUES ('189', 'Ukita', 'ronin')");
VALUES ('190', 'Ushio', 'ronin')");
VALUES ('191', 'Urakami', 'buke')");
VALUES ('192', 'Utsunomiya', 'buke')");
VALUES ('193', 'Uyama', 'ronin')");
VALUES ('194', 'Uwai', 'ronin')");
VALUES ('195', 'Wada', 'buke')");
VALUES ('196', 'Watanabe', 'ronin')");
VALUES ('197', 'Yamana', 'buke')");
VALUES ('198', 'Yamanaka', 'ronin')");
VALUES ('199', 'Yamanouchi', 'buke')");
VALUES ('200', 'Yasuda', 'ronin')");



Edited by shugo - 24-Mar-2009 at 13:44
Back to Top
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Posted: 23-Mar-2009 at 21:53

Castles (CastleID, CastleName, ProvinceID, ProvinceName, Castellan, Wealth, Minewealth, Silks, Tea, Terrain)


VALUES ('1', 'Akita', '2', 'Dewa', 'Akita', '200', '400', '0', '0', 'yama')");
VALUES ('2', 'Ako', '40', 'Harima', 'Asano', '100', '0', '0', '1', 'hari')");
VALUES ('3', 'Dazaifu', '60', 'Chikuzen', 'Shoni', '100', '0', '0', '2', 'hari')");
VALUES ('4', 'Edo', '12', 'Musashi', 'Ota', '1000', '0', '0', '2', 'hari')");
VALUES ('5', 'Fujidera', '31', 'Kawachi', 'Hosokawa', '100', '0', '0', '0', 'hari')");
VALUES ('6', 'Fuchu', '37', 'Bingo', 'Mori', '200', '0', '0', '0', 'yama')");
VALUES ('7', 'Fukui', '18', 'Echizen', 'Asakura', '200', '0', '0', '0', 'hari')");
VALUES ('8', 'Fukuoka', '58', 'Buzen', 'Otomo', '500', '0', '0', '6', 'mori')");
VALUES ('9', 'Fukuyama', '37', 'Bingo', 'Mizuno', '100', '0', '0', '0', 'yama')");
VALUES ('10', 'Gifu', '26', 'Mino', 'Toki', '200', '0', '2', '3', 'hari')");
VALUES ('11', 'Hachigata', '12', 'Musashi', 'Hojo', '100', '0', '1', '0', 'mori')");
VALUES ('12', 'Hachinohe', '5', 'Mutsu', 'Nambu', '100', '100', '0', '0', 'mori')");
VALUES ('13', 'Hachioji', '12', 'Musashi', 'Ashikaga', '100', '0', '0', '0', 'yama')");
VALUES ('14', 'Hagi', '46', 'Nagato', 'Ouchi', '100', '200', '0', '0', 'yama')");
VALUES ('15', 'Hamada', '43', 'Iwami', 'Kikkawa', '200', '0', '0', '1', 'mori')");
VALUES ('16', 'Hamamatsu', '17', 'Totomi', 'Imagawa', '100', '0', '0', '4', 'mori')");
VALUES ('17', 'Hidaka', '12', 'Musashi', 'Uesugi', '200', '0', '0', '1', 'hari')");
VALUES ('18', 'Hidaka', '48', 'Tajima', 'Yamana', '100', '0', '0', '0', 'hari')");
VALUES ('19', 'Hikone', '27', 'Omi', 'Asai', '400', '0', '0', '2', 'mori')");
VALUES ('20', 'Himeji', '40', 'Harima', 'Bessho', '900', '0', '0', '0', 'mori')");
VALUES ('21', 'Hirado', '62', 'Hizen', 'Matsuura', '100', '0', '0', '1', 'hari')");
VALUES ('22', 'Hirosaki', '5', 'Mutsu', 'Tsugaru', '100', '50', '0', '0', 'mori')");
VALUES ('23', 'Hiroshima', '36', 'Aki', 'Mori', '800', '0', '0', '0', 'hari')");
VALUES ('24', 'Hofu', '47', 'Suwa', 'Ouchi', '100', '0', '0', '0', 'hari')");
VALUES ('25', 'Homoyama', '33', 'Settsu', 'Miyoshi', '100', '0', '0', '0', 'yama')");
VALUES ('26', 'Ibaraki', '33', 'Settsu', 'Miyoshi', '100', '0', '0', '0', 'hari')");
VALUES ('27', 'Imabari', '54', 'Iyo', 'Todo', '400', '0', '0', '0', 'hari')");
VALUES ('28', 'Ina', '15', 'Shinano', 'Takato', '100', '0', '0', '0', 'yama')");
VALUES ('29', 'Inuyama', '28', 'Owari', 'Oda', '200', '0', '0', '0', 'yama')");
VALUES ('30', 'Ishioka', '4', 'Hitachi', 'Satake', '300', '0', '0', '0', 'hari')");
VALUES ('31', 'Iwakuni', '47', 'Suwa', 'Ouchi', '100', '0', '0', '0', 'yama')");
VALUES ('32', 'Iwamura', '26', 'Mino', 'Toki', '100', '0', '0', '0', 'yama')");
VALUES ('33', 'Iwatsuki', '12', 'Musashi', 'Hojo', '100', '0', '0', '2', 'mori')");
VALUES ('34', 'Izumi', '30', 'Izumi', 'Hosokawa', '100', '0', '0', '0', 'hari')");
VALUES ('35', 'Kagoshima', '65', 'Satsuma', 'Shimazu', '700', '0', '0', '20', 'yama')");
VALUES ('36', 'Kakegawa', '17', 'Totomi', 'Imagawa', '100', '0', '0', '4', 'mori')");
VALUES ('37', 'Kamakura', '13', 'Sagami', 'Hojo', '100', '0', '0', '0', 'mori')");
VALUES ('38', 'Kameyama', '24', 'Ise', 'Kitabatake', '100', '0', '0', '0', 'mori')");
VALUES ('39', 'Kameyama', '49', 'Tamba', 'Hatano', '200', '0', '0', '5', 'mori')");
VALUES ('40', 'Kamiizumi', '9', 'Kai', 'Takeda', '100', '0', '2', '0', 'yama')");
VALUES ('41', 'Kanayama', '11', 'Kozuke', 'Iwamatsu', '100', '0', '1', '0', 'yama')");
VALUES ('42', 'Kanazawa', '21', 'Kaga', 'Maeda', '900', '0', '0', '0', 'numa')");
VALUES ('43', 'Karasawayama', '6', 'Shimotsuke', 'Utsunomiya', '100', '0', '0', '0', 'yama')");
VALUES ('44', 'Karatsu', '60', 'Chikuzen', 'Terazawa', '100', '0', '0', '0', 'mori')");
VALUES ('45', 'Kawagoe', '12', 'Musashi', 'Yamanouchi', '300', '100', '0', '0', 'mori')");
VALUES ('46', 'Kiso', '15', 'Shinano', 'Kiso', '200', '0', '1', '0', 'hari')");
VALUES ('47', 'Kiyosu', '28', 'Owari', 'Shiba', '300', '0', '0', '2', 'hari')");
VALUES ('48', 'Kochi', '56', 'Tosa', 'Chosokabe', '100', '0', '0', '1', 'mori')");
VALUES ('49', 'Kofu', '9', 'Kai', 'Takeda', '500', '400', '0', '0', 'mori')");
VALUES ('50', 'Koka', '27', 'Omi', 'Ishida', '200', '0', '0', '0', 'yama')");
VALUES ('51', 'Kokokufu', '57', 'Bungo', 'Otomo', '200', '0', '0', '1', 'hari')");
VALUES ('52', 'Kokubu', '64', 'Osumi', 'Shimazu', '200', '0', '0', '20', 'mori')");
VALUES ('53', 'Kokura', '58', 'Buzen', 'Ogasawara', '400', '0', '0', '0', 'hari')");
VALUES ('54', 'Komatsu', '21', 'Kaga', 'Maeda', '200', '0', '0', '0', 'hari')");
VALUES ('55', 'Komoro', '15', 'Shinano', 'Murakami', '100', '0', '1', '0', 'mori')");
VALUES ('56', 'Kumagaya', '12', 'Musashi', 'Ashikaga', '200', '0', '1', '0', 'hari')");
VALUES ('57', 'Kumamoto', '61', 'Higo', 'Kikuchi', '500', '0', '2', '2', 'mori')");
VALUES ('58', 'Kurayoshi', '41', 'Hoki', 'Amako', '100', '0', '0', '0', 'yama')");
VALUES ('59', 'Kurume', '59', 'Chikugo', 'Arima', '400', '0', '0', '2', 'hari')");
VALUES ('60', 'Kururi', '10', 'Kazusa', 'Satomi', '100', '0', '0', '0', 'yama')");
VALUES ('61', 'Kuwabara', '15', 'Shinano', 'Suwa', '100', '0', '1', '0', 'yama')");
VALUES ('62', 'Kyoto', '34', 'Yamashiro', 'Hosokawa', '900', '0', '0', '10', 'hari')");
VALUES ('63', 'Maizuru', '50', 'Tango', 'Isshiki', '200', '0', '0', '0', 'hari')");
VALUES ('64', 'Marugame', '55', 'Sanuki', 'Sogo', '100', '0', '0', '0', 'mori')");
VALUES ('65', 'Maruoka', '18', 'Echizen', 'Asakura', '100', '0', '0', '0', 'mori')");
VALUES ('66', 'Matsue', '44', 'Izumo', 'Amako', '500', '0', '0', '0', 'mori')");
VALUES ('67', 'Matsumoto', '15', 'Shinano', 'Ogasawara', '200', '400', '1', '0', 'hari')");
VALUES ('68', 'Matsuyama', '54', 'Iyo', 'Kono', '500', '100', '0', '0', 'yama')");
VALUES ('69', 'Mihara', '36', 'Aki', 'Kobayakawa', '400', '0', '0', '0', 'hari')");
VALUES ('70', 'Minakuchi', '27', 'Omi', 'Sasaki', '200', '0', '0', '2', 'hari')");
VALUES ('71', 'Minami', '52', 'Awaji', 'Miyoshi', '100', '0', '0', '0', 'mori')");
VALUES ('72', 'Minowa', '15', 'Shinano', 'Takato', '100', '0', '1', '0', 'mori')");
VALUES ('73', 'Mito', '4', 'Hitachi', 'Baba', '600', '0', '0', '0', 'mori')");
VALUES ('74', 'Miyoshi', '7', 'Awa', 'Satomi', '200', '0', '0', '0', 'hari')");
VALUES ('75', 'Morioka', '5', 'Mutsu', 'Nambu', '200', '0', '2', '0', 'mori')");
VALUES ('76', 'Nagahama', '27', 'Omi', 'Sasaki', '200', '0', '0', '1', 'hari')");
VALUES ('77', 'Nagaoka', '3', 'Echigo', 'Nagao', '100', '0', '0', '0', 'mori')");
VALUES ('78', 'Nagasaki', '62', 'Hizen', 'Shoni', '300', '0', '0', '2', 'hari')");
VALUES ('79', 'Nagoya', '28', 'Owari', 'Oda', '600', '0', '0', '3', 'hari')");
VALUES ('80', 'Nakatsu', '58', 'Buzen', 'Otomo', '400', '0', '0', '0', 'hari')");
VALUES ('81', 'Nanao', '22', 'Noto', 'Hatakeyama', '200', '0', '0', '0', 'yama')");
VALUES ('82', 'Nankoku', '56', 'Tosa', 'Chosokabe', '400', '0', '0', '0', 'hari')");
VALUES ('83', 'Nara', '35', 'Yamato', 'Tsutsui', '300', '0', '0', '20', 'hari')");
VALUES ('84', 'Niigata', '3', 'Echigo', 'Nagao', '300', '0', '0', '0', 'hari')");
VALUES ('85', 'Nikko', '6', 'Shimotsuke', 'Utsunomiya', '100', '0', '0', '0', 'yama')");
VALUES ('86', 'Nobeoka', '63', 'Hyuga', 'Ito', '100', '0', '0', '5', 'mori')");
VALUES ('87', 'Obama', '51', 'Wakasa', 'Isshiki', '200', '0', '0', '0', 'hari')");
VALUES ('88', 'Obi', '63', 'Hyuga', 'Ito', '300', '0', '0', '10', 'hari')");
VALUES ('89', 'Odawara', '13', 'Sagami', 'Hojo', '200', '0', '2', '0', 'mori')");
VALUES ('90', 'Ogaki', '26', 'Mino', 'Saito', '200', '0', '0', '2', 'hari')");
VALUES ('91', 'Okayama', '39', 'Bizen', 'Akamatsu', '800', '0', '0', '0', 'yama')");
VALUES ('92', 'Okazaki', '25', 'Mikawa', 'Saigo', '100', '0', '0', '4', 'mori')");
VALUES ('93', 'Ono', '18', 'Echizen', 'Asakura', '100', '0', '0', '0', 'yama')");
lVALUES ('94', 'Osaka', '33', 'Settsu', 'Miyoshi', '300', '0', '0', '0', 'hari')");
VALUES ('95', 'Oshi', '12', 'Musashi', 'Ashikaga', '200', '0', '1', '0', 'hari')");
VALUES ('96', 'Otaki', '10', 'Kazusa', 'Satomi', '100', '0', '0', '0', 'mori')");
VALUES ('97', 'Ozu', '54', 'Iyo', 'Kono', '100', '0', '0', '0', 'numa')");
VALUES ('98', 'Sado', '1', 'Sado', 'Honma', '100', '0', '0', '0', 'mori')");
VALUES ('99', 'Saiki', '57', 'Bungo', 'Otomo', '100', '0', '0', '0', 'mori')");
VALUES ('100', 'Saito', '63', 'Hyuga', 'Ito', '200', '0', '0', '5', 'hari')");
VALUES ('101', 'Sakai', '30', 'Izumi', 'Hosokawa', '100', '0', '0', '0', 'hari')");
VALUES ('102', 'Sakasai', '4', 'Hitachi', 'Satake', '100', '0', '0', '0', 'mori')");
VALUES ('103', 'Sakata', '2', 'Dewa', 'Mogami', '200', '0', '0', '0', 'hari')");
VALUES ('104', 'Sakura', '14', 'Shimousa', 'Chiba', '200', '0', '0', '1', 'mori')");
VALUES ('105', 'Sano', '6', 'Shimotsuke', 'Utsunomiya', '100', '0', '0', '0', 'mori')");
VALUES ('106', 'Sekiyado', '14', 'Shimousa', 'Chiba', '200', '0', '2', '0', 'hari')");
VALUES ('107', 'Sendai', '5', 'Mutsu', 'Date', '500', '50', '3', '0', 'numa')");
VALUES ('108', 'Shimabara', '62', 'Hizen', 'Arima', '100', '0', '0', '2', 'hari')");
VALUES ('109', 'Shimonoseki', '46', 'Nagato', 'Ouchi', '200', '0', '0', '0', 'hari')");
VALUES ('110', 'Shinpu', '9', 'Kai', 'Takeda', '100', '0', '1', '0', 'mori')");
VALUES ('111', 'Soja', '38', 'Bitchu', 'Matsuda', '200', '0', '0', '0', 'hari')");
VALUES ('112', 'Sumpu', '16', 'Suruga', 'Imagawa', '200', '0', '0', '0', 'hari')");
VALUES ('113', 'Suzuka', '24', 'Ise', 'Kuroda', '200', '0', '0', '5', 'hari')");
VALUES ('114', 'Tagata', '8', 'Izu', 'Hojo', '100', '0', '0', '0', 'mori')");
VALUES ('115', 'Takada', '3', 'Echigo', 'Nagao', '100', '0', '0', '0', 'hari')");
VALUES ('116', 'Takamatsu', '55', 'Sanuki', 'Miyoshi', '400', '0', '0', '0', 'hari')");
VALUES ('117', 'Takaoka', '19', 'Etchu', 'Jinbo', '200', '0', '0', '0', 'hari')");
VALUES ('118', 'Takasaki', '11', 'Kozuke', 'Wada', '300', '0', '2', '0', 'hari')");
VALUES ('119', 'Takashima', '15', 'Shinano', 'Suwa', '100', '0', '1', '0', 'hari')");
VALUES ('120', 'Takashima', '62', 'Hizen', 'Shoni', '100', '0', '0', '0', 'mori')");
VALUES ('121', 'Takayama', '20', 'Hida', 'Anegakoji', '100', '50', '0', '0', 'yama')");
VALUES ('122', 'Takenoya', '25', 'Mikawa', 'Matsudaira', '200', '0', '0', '4', 'hari')");
VALUES ('123', 'Tanabe', '32', 'Kii', 'Hatakeyama', '100', '0', '0', '0', 'mori')");
VALUES ('124', 'Tanaka', '16', 'Suruga', 'Imagawa', '100', '0', '0', '0', 'mori')");
VALUES ('125', 'Tatebayashi', '11', 'Kozuke', 'Uesugi', '400', '0', '1', '0', 'numa')");
VALUES ('126', 'Toba', '29', 'Shima', 'Kitabatake', '100', '0', '0', '5', 'hari')");
VALUES ('127', 'Toda', '44', 'Izumo', 'Amako', '100', '0', '0', '0', 'mori')");
VALUES ('128', 'Tokushima', '53', 'Awa', 'Hachisuka', '500', '0', '2', '1', 'hari')");
VALUES ('129', 'Tottori', '42', 'Inaba', 'Ikeda', '300', '0', '0', '0', 'hari')");
VALUES ('130', 'Toyama', '19', 'Etchu', 'Maeda', '200', '0', '0', '0', 'hari')");
VALUES ('131', 'Tsu', '24', 'Ise', 'Kitabatake', '600', '0', '0', '5', 'hari')");
VALUES ('132', 'Tsuchiura', '4', 'Hitachi', 'Satake', '200', '0', '0', '0', 'hari')");
VALUES ('133', 'Tsuruga', '51', 'Wakasa', 'Ashina', '200', '0', '0', '0', 'hari')");
VALUES ('134', 'Tsuyama', '45', 'Mimasaka', 'Urakami', '200', '0', '0', '0', 'yama')");
VALUES ('135', 'Ueda', '15', 'Shinano', 'Murakami', '200', '0', '2', '0', 'hari')");
VALUES ('136', 'Uehara', '15', 'Shinano', 'Suwa', '100', '0', '1', '0', 'yama')");
VALUES ('137', 'Ueno', '23', 'Iga', 'Niki', '100', '0', '0', '0', 'yama')");
VALUES ('138', 'Uji', '34', 'Yamashiro', 'Chokei', '100', '0', '0', '10', 'hari')");
VALUES ('139', 'Urado', '56', 'Tosa', 'Chosokabe', '100', '0', '0', '0', 'hari')");
VALUES ('140', 'Usuki', '57', 'Bungo', 'Otomo', '100', '0', '0', '0', 'mori')");
VALUES ('141', 'Utsunomiya', '6', 'Shimotsuke', 'Utsunomiya', '400', '0', '0', '0', 'hari')");
VALUES ('142', 'Uwajima', '54', 'Iyo', 'Kono', '100', '0', '0', '0', 'mori')");
VALUES ('143', 'Wakamatsu', '5', 'Mutsu', 'Ashina', '300', '0', '0', '0', 'mori')");
VALUES ('144', 'Wakayama', '32', 'Kii', 'Hatakeyama', '700', '0', '0', '0', 'mori')");
VALUES ('145', 'Yamagata', '2', 'Dewa', 'Mogami', '200', '0', '0', '0', 'hari')");
VALUES ('146', 'Yamaguchi', '47', 'Suwa', 'Ouchi', '300', '0', '0', '1', 'hari')");
VALUES ('147', 'Yamato', '62', 'Hizen', 'Shoni', '100', '0', '0', '20', 'mori')");
VALUES ('148', 'Yatsushiro', '61', 'Higo', 'Kikuchi', '100', '400', '0', '3', 'mori')");
VALUES ('149', 'Yokohama', '13', 'Sagami', 'Hojo', '400', '0', '0', '0', 'hari')");
VALUES ('150', 'Yoshida', '25', 'Mikawa', 'Matsudaira', '200', '0', '0', '4', 'hari')");


Edited by shugo - 24-Mar-2009 at 13:36
Back to Top
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Posted: 23-Mar-2009 at 22:00
I realize the table looks complicated in this form, which I apologize for, but I only showed it to give people a rough idea. I hope it doesn't shy you away. Its not as complicated as it looks CastleName for instance is the name of the towns in the list, while ProvinceName is the name of the province.
 
So what towns and which clans do you think should be in it? Or in others words who or what do you think was famous/good/wealthy/important enough to warrant to be in it?
Back to Top
Leonidas View Drop Down
Immortal Guard
Immortal Guard
Avatar

Joined: 01-Oct-2005
Location: Australia
Online Status: Offline
Posts: 4617 		Post Options Post Options   Quote Leonidas Quote  Post ReplyReply Direct Link To This Post Posted: 24-Mar-2009 at 09:55
Ill give you another attempt at cleaning that up, I cant see anything but queries.

If you cant fix it then forget about those posts
Back to Top
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Posted: 24-Mar-2009 at 13:47
Took out the queries, hopefully its more intelligible now. Took the liberty of keeping in the ID's as I think that makes it easier to respond to. Anyway thanks for the response and I apologize for the way it is written, but I'm only new at this.

Edited by shugo - 24-Mar-2009 at 13:51
Back to Top
Temujin View Drop Down
Immortal Guard
Immortal Guard
Avatar
Sirdar Bahadur

Joined: 02-Aug-2004
Location: Eurasia
Online Status: Offline
Posts: 5237 		Post Options Post Options   Quote Temujin Quote  Post ReplyReply Direct Link To This Post Posted: 24-Mar-2009 at 19:17
this is for a Total War modification?
Back to Top
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Posted: 24-Mar-2009 at 20:32
It is sort of a browser based modification of shogun total war yes.
Back to Top
oxeight View Drop Down
Immortal Guard
Immortal Guard


Joined: 08-Apr-2009
Online Status: Offline
Posts: 0 		Post Options Post Options   Quote oxeight Quote  Post ReplyReply Direct Link To This Post Posted: 08-Apr-2009 at 07:44
oh...that's detailed...
Back to Top
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Online Status: Offline
Posts: 19 		Post Options Post Options   Quote shugo Quote  Post ReplyReply Direct Link To This Post Posted: 10-Apr-2009 at 18:11
it is, but not detailed enough I think. Plus some of the values, I really am not sure about, though some are modified for balance. There's a couple of anachronisms in it too.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.140 seconds.