LordT Posted August 7, 2003 Report Share Posted August 7, 2003 I was thinking about the name's database and how it's going to be done.My thought is that maybe I could make a web-based app where everyone (read: every project member) can submit names for different countries/languages into a database when they feel like it. Then the xml-doc can be generated on a weekly or so basis by someone. Should I go ahead with this? Do you have any suggestions as for what kind of features that should be availible? Did we have a final structure on the file? Link to comment Share on other sites More sharing options...
Breunor Posted August 7, 2003 Report Share Posted August 7, 2003 (edited) If so make sure to include a validator to prevent repeat names. Also would need a case checker, unless the names will be reformatted to prevent bOb SmItH type entries. That's probably a given I guess. Last I heard the names were divided by language, so there would need to be a list box for that. Edit: I think Mikker mentioned that russian last names vary depending on gender too. Didn't know if this is a widespread issue, but I don't think that last names were split out by gender like the first names. It could be implemented though, just duplicating names for both where it's not an issue. Edited August 7, 2003 by Breunor Link to comment Share on other sites More sharing options...
Guest Jim69 Posted August 7, 2003 Report Share Posted August 7, 2003 A suggestion? 4 each name collect first and last names, sex and location. Then u could just have a list box 4 each gender, and collect them that way. If 30 peeps know 30 names of peeps, their sex and country of birth then thats 900 names. And I'm sure there is more than 30 peeps out there, and they probably know more than 30 peeps. Link to comment Share on other sites More sharing options...
mamutas Posted August 7, 2003 Report Share Posted August 7, 2003 Edit: I think Mikker mentioned that russian last names vary depending on gender too.I believe that was me. And it is not only with Russian, but with most Eastern Europe countries. I think that it is better to collect first and last name separately. Each name would have an attribute, indicating gender (male/female/both), country or nationality, etc.Then those 2 lists will be used together to generate a name. The uniqueness need to be ensured in the game itself. As for the lower/upper case: some last name have them both. McDonald, LePeep, etc. So, the names should be casesensitive and someone will need to do an occasional proofread to fix any 'bOb' kind of spellings. Link to comment Share on other sites More sharing options...
Guest Jim69 Posted August 7, 2003 Report Share Posted August 7, 2003 (edited) Well, if u collect the whole names and gender's then u can split the lists pretty easily l8r. Or even program the form 2 create 2 lists, 1 with 1st name sex and nationality, the other with last name etc. Edit: Not sure that post corresponds with what u just said, but I'm tired so I'm goin 2 sleep Edited August 7, 2003 by Jim69 Link to comment Share on other sites More sharing options...
LordT Posted August 7, 2003 Author Report Share Posted August 7, 2003 So I could do it this way: [choose]* Male* Female[/choose] [choose]* Forename* Lastname[/choose] Entry:[textbox] Country/language <- we need to assemble this list soon[drop-down] Link to comment Share on other sites More sharing options...
red knight Posted August 7, 2003 Report Share Posted August 7, 2003 Last names and First names should be added separatly, take a look at the DB I posted ages ago... the only thing I didnt include was Eastern Europe strange issues with last names :: ... Seriously I didnt know that by then, so take a look at it and see how to improve it. GreetingsRed Knight Link to comment Share on other sites More sharing options...
mamutas Posted August 7, 2003 Report Share Posted August 7, 2003 [choose]* Male* Female[/choose] [choose]* Forename* Lastname[/choose]Some names (and first and last) could be applied to both male and female, so i think we need a 'both' choice too. Eastern Europe strange issues with last namesYou should visit Eastern Europe. The name issue will be the least 'strange', I promise. Link to comment Share on other sites More sharing options...
demich Posted August 7, 2003 Report Share Posted August 7, 2003 rk: in Poland the lastname depends on gender (mostly). E.G Male is "Jan Kowalski" but famale is "Anna Kowalska". As you can see it's quite simple . "-ski" from male lasname changes into "-ska" for famale lastname. However I don't know how it is in other eastern europe countries but it's similar probably. Link to comment Share on other sites More sharing options...
LordT Posted August 8, 2003 Author Report Share Posted August 8, 2003 I set up a little place-holder form here: http://xenocide.ru/temp/names/ Link to comment Share on other sites More sharing options...
Puasonen Posted August 8, 2003 Report Share Posted August 8, 2003 I set up a little place-holder form here: http://xenocide.ru/temp/names/k, good.. Now you only need to make it work and probably it would be a good idea to put the link to your sig too. Like RK is advertising his topic in his sig.. Link to comment Share on other sites More sharing options...
LordT Posted August 8, 2003 Author Report Share Posted August 8, 2003 Not yet... i want it working first Anyway, you can now submit names and languages to it. However this is just a test and any info you post will likely have to be re-entered but DO try it out and search for bugs If you don't want to scroll upwards 1-2 posts then here's the URL again: http://xenocide.ru/temp/names/ Link to comment Share on other sites More sharing options...
LordT Posted August 8, 2003 Author Report Share Posted August 8, 2003 Oh! And it checks for duplicates on submit so you won't have to worry about that. Link to comment Share on other sites More sharing options...
j'ordos Posted August 8, 2003 Report Share Posted August 8, 2003 (edited) Hmm, I tried it by adding the language 'French', and then tried to enter a first name. I try to pick the language, but there's only Swedish as an option OK, back to submit language, and try again to add French, but it says 'language already in datafile'. So I try to enter a name again, but still no French there. Eventually it shows up and lets me enter a name, but when I tried a second one the only option was Swedish again Is this some scheme you put up so 99% of the entered xcom soldier names will be Swedish?? edit: also, view database doesn't work... or is that normal? edit2: What's wrong is: when adding a name you can only select 'Swedish', or 'select a language'. When you leave it at 'select a language' when submitting a name, it erases the form but suddenly you can pick the other languages... Edited August 8, 2003 by j'ordos Link to comment Share on other sites More sharing options...
mamutas Posted August 8, 2003 Report Share Posted August 8, 2003 rk: in Poland the lastname depends on gender (mostly). E.G Male is "Jan Kowalski" but famale is "Anna Kowalska". As you can see it's quite simple . "-ski" from male lasname changes into "-ska" for famale lastname. However I don't know how it is in other eastern europe countries but it's similar probably.It is not just 'ski' and 'ska', there are much more variations to that. I was able to add a language and the name, so far without any problems. Link to comment Share on other sites More sharing options...
LordT Posted August 8, 2003 Author Report Share Posted August 8, 2003 (edited) New big update Deletions and viewing added. j'ordos: try it again, there shouldn't be any problems... Edited August 8, 2003 by LordT Link to comment Share on other sites More sharing options...
j'ordos Posted August 8, 2003 Report Share Posted August 8, 2003 Ok, it works fine now :happybanana: Link to comment Share on other sites More sharing options...
Aosar Posted August 8, 2003 Report Share Posted August 8, 2003 Woo! Entered my own name(and languake)there! So, if I spend an evening adding Finnish names there, will that somehow actually be useful or will it be as constructive, as other acts of ultimate boredom? Link to comment Share on other sites More sharing options...
mamutas Posted August 8, 2003 Report Share Posted August 8, 2003 Actually, it should be changed from 'language' to 'country'. For, now I suggest to use only those countries which were listed in original game (so, add country/delete country feature must be removed).on the other hand, same names could be used in several different countries, for example, US, UK, AU. We need a mechanizm to deal with that too. Link to comment Share on other sites More sharing options...
Aosar Posted August 8, 2003 Report Share Posted August 8, 2003 Hmm, make a list of all the relevant countries and then all the relevant languakes, then link those together and them into the names and you're set. What I mean is, that you connect to the country all the languakes that are present there. Then you check from those languakes what names are appropriate... Link to comment Share on other sites More sharing options...
LordT Posted August 9, 2003 Author Report Share Posted August 9, 2003 (edited) Hmm, make a list of all the relevant countries and then all the relevant languakes, then link those together and them into the names and you're set. What I mean is, that you connect to the country all the languakes that are present there. Then you check from those languakes what names are appropriate...Yep, that's how it was structured in the xml-file so that's how I made it. Look again, big update, everything works (should anyway) except for file generation. edit: btw I need more suggestions for the list of continents, my geography isn't what it should be... Edited August 9, 2003 by LordT Link to comment Share on other sites More sharing options...
j'ordos Posted August 9, 2003 Report Share Posted August 9, 2003 I think that list of continents is OK, there won't be many recruits from Antarctica One question though: Why is 'Europe' listed twice as a continent? Link to comment Share on other sites More sharing options...
LordT Posted August 9, 2003 Author Report Share Posted August 9, 2003 (edited) I think that list of continents is OK, there won't be many recruits from Antarctica One question though: Why is 'Europe' listed twice as a continent?Because.. uh... my bad? Edit: so, there, *fixed* Edited August 9, 2003 by LordT Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 It seems that noone has dared to try out the countries language probabilities yet? Link to comment Share on other sites More sharing options...
j'ordos Posted August 10, 2003 Report Share Posted August 10, 2003 Possibly because no one here knows the percentage of foreigners in any country? Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 Possibly because no one here knows the percentage of foreigners in any country? Then look up ye old statistics bureau Link to comment Share on other sites More sharing options...
miceless Posted August 10, 2003 Report Share Posted August 10, 2003 This is testing right? Can I make some stuff up to test it? Link to comment Share on other sites More sharing options...
miceless Posted August 10, 2003 Report Share Posted August 10, 2003 Ive just been having a mess with it. Can I make a suggestion? The ability to add more than one name at a time would be nice. Perhaps youve already done this and Ive not noticed, but can you use a delimiter to make a list, or have a multi line entry box? If I have more than one name it would speed things up. Oh, and the 'delete a name' bit should probably be check boxes not radio buttons, so that you can delete more than one at a time. Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 Ive just been having a mess with it. Can I make a suggestion? The ability to add more than one name at a time would be nice. Perhaps youve already done this and Ive not noticed, but can you use a delimiter to make a list, or have a multi line entry box? If I have more than one name it would speed things up. Oh, and the 'delete a name' bit should probably be check boxes not radio buttons, so that you can delete more than one at a time.I dont know... I could try but I can't promise anything Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 This is testing right? Can I make some stuff up to test it?Just blast away... Link to comment Share on other sites More sharing options...
miceless Posted August 10, 2003 Report Share Posted August 10, 2003 Going home now. Ill test it some when i get there as my connection is faster. Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 I dont know... I could try but I can't promise anything *Done* ... (hmm, wasn't that tough) Link to comment Share on other sites More sharing options...
miceless Posted August 10, 2003 Report Share Posted August 10, 2003 Much better! Input the name(s): (Newlines seperat)Spelling mistake? Wordings a tad strange too. Link to comment Share on other sites More sharing options...
[dipstick] Posted August 10, 2003 Report Share Posted August 10, 2003 (edited) For stats in England: 50% African45% Middle Eastern5% Causican..... About right isn't it? Seriously though, it seems exceedingly good... Edited August 10, 2003 by dipstick Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 Much better! Input the name(s): (Newlines seperat)Spelling mistake? Wordings a tad strange too. Bah, I just added (s):es for most words I'll look into language later. Link to comment Share on other sites More sharing options...
miceless Posted August 10, 2003 Report Share Posted August 10, 2003 Fair enough. Its looking good though. Link to comment Share on other sites More sharing options...
hythloday Posted August 10, 2003 Report Share Posted August 10, 2003 Mamutas: With the new names.xml format, the mechanism for multi-ethnic (UK, US, Australai) is to make a fake country called something like "english-sounding" and add the names to that. Names groups are no longer tied to continents for exactly this reason. Link to comment Share on other sites More sharing options...
LordT Posted August 10, 2003 Author Report Share Posted August 10, 2003 Another update!Bug fixes:* Fixed an error with whitespaces on multiple name adds (doh!) Updates:* Table contents are now visible on the add sections Link to comment Share on other sites More sharing options...
LordT Posted August 11, 2003 Author Report Share Posted August 11, 2003 Yet another update...* Better sorting on name listings Link to comment Share on other sites More sharing options...
mamutas Posted August 12, 2003 Report Share Posted August 12, 2003 Mamutas: With the new names.xml format, the mechanism for multi-ethnic (UK, US, Australai) is to make a fake country called something like "english-sounding" and add the names to that. Names groups are no longer tied to continents for exactly this reason.Well, I guess you can call it 'language', not 'english-sounding'For example, country = USlanguages = english, spanish, french, chinese, japanese umm, i guess i need to check that structure first...nevermind Link to comment Share on other sites More sharing options...
LordT Posted September 13, 2003 Author Report Share Posted September 13, 2003 Everything is done and the Names Database Interface is up for use at http://www.projectxenocide.com/namesdatabase/ Enjoy I made one miniscule change though, I scrapped the either attribute in the xml-file, instead, names that's marked as "either" will be placed in both male and female groups. It's easy to change it back if you don't like it. Link to comment Share on other sites More sharing options...
mamutas Posted September 14, 2003 Report Share Posted September 14, 2003 Looks cool! One note: should we have empty groups in XML? I think not. Link to comment Share on other sites More sharing options...
LordT Posted September 14, 2003 Author Report Share Posted September 14, 2003 Looks cool! One note: should we have empty groups in XML? I think not.Hopefully, they'll all be filled I've added password protection for deletions now. Link to comment Share on other sites More sharing options...
[[Micah]] Posted September 14, 2003 Report Share Posted September 14, 2003 I've added password protection for deletions now.Good. I started wondering about who would wonder onto the page after you added the announcement to the calender. I think I'll add the great country of Micona, which speaks American Link to comment Share on other sites More sharing options...
LordT Posted September 14, 2003 Author Report Share Posted September 14, 2003 I'm calling out to the person who posted polish names: Do they look correct (have the right chars) when you view them in the XML-file? I'm a little concerned about character encoding and how it will import into the game.... Link to comment Share on other sites More sharing options...
Guest Jim69 Posted September 14, 2003 Report Share Posted September 14, 2003 And just as important: Do they view correctly using Xenocides font? I can't remember if it is a custom font or not. If it is, there may not even be the characters that are being referred to in it. And even if there are it may not be the same character when the font is changed. A solution is to not include special characters, but to replace them with the standard characters. Link to comment Share on other sites More sharing options...
LordT Posted September 14, 2003 Author Report Share Posted September 14, 2003 I'm currently using UTF-8 for encoding (http://www.w3.org/International/O-charset.html) but I don't know if they're sent TO the database in that format. If the Xenocide font supports that encoding, we should be fine. Link to comment Share on other sites More sharing options...
Guest Jim69 Posted September 14, 2003 Report Share Posted September 14, 2003 (edited) I just checked, the Xenocide font doesn't support any special characters save from :;?()'. So we could have a problem Edit: Ignore, it was just the way I was looking at them. Here's a pic of all the special characters supported. Edited September 14, 2003 by Jim69 Link to comment Share on other sites More sharing options...
LordT Posted September 14, 2003 Author Report Share Posted September 14, 2003 Well thats good, but I'm still at a loss on how the mysql database stores/recieves the characters.We'll have to see, until then, don't post any names with any characters outside of the Western ISO-8859-1 standard. Link to comment Share on other sites More sharing options...
demich Posted September 14, 2003 Report Share Posted September 14, 2003 There are no special characters on this picture that are specific for polish lenguage . If you tell me how, I can make them Link to comment Share on other sites More sharing options...
Recommended Posts