History Community ~ All Empires Homepage


This is the Archive on WORLD Historia, the old original forum.

 You cannot post here - you can only read.

 

Here is the link to the new forum:

  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum Lockednewbie question regarding sengoku daimyo?

 Post Reply Post Reply
Author
shugo View Drop Down
Janissary
Janissary


Joined: 23-Mar-2009
Location: groningen
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 4617
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 5237
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   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
Status: Offline
Points: 19
Post Options Post Options   Thanks (0) Thanks(0)   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
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.

This page was generated in 0.064 seconds.