make all AI's allied

Valandil · #1 October 27th, 2007, 07:28 PM

Um. Copy+paste, and increase the numbers by one each time. How hard could it be?

Endoperez · #2 October 27th, 2007, 08:35 PM

Not hard, but boring. Achieving a boring thing is actually much harder than achieving a hard one.

Eljay · #3 October 29th, 2007, 09:09 AM

Quote:

Valandil said:
Um. Copy+paste, and increase the numbers by one each time. How hard could it be?

Even easier; put it into excel. It has an auto increment feature which allows you to drag down a list of cells and increment the contents. You could then manually delete the lines which you did not want.

Wikd Thots · #4 October 29th, 2007, 12:28 PM

Quote:

Eljay said:

Quote:

Valandil said:
Um. Copy+paste, and increase the numbers by one each time. How hard could it be?

Even easier; put it into excel. It has an auto increment feature which allows you to drag down a list of cells and increment the contents. You could then manually delete the lines which you did not want.

Cool. Export the whole list to a text file and attach it to this thread please

Edi · #5 October 29th, 2007, 12:39 PM

Quote:

Wikd Thots said:

Quote:

Eljay said:

Quote:

Valandil said:
Um. Copy+paste, and increase the numbers by one each time. How hard could it be?

Even easier; put it into excel. It has an auto increment feature which allows you to drag down a list of cells and increment the contents. You could then manually delete the lines which you did not want.

Cool. Export the whole list to a text file and attach it to this thread please

I don't know about everyone else, but to me this line here sounds like a demand/order that others produce what you need for you, even after you have been provided with instructions, even fairly extensive ones that allow automating a lot of it. That sort of thing gets on the nerves fairly quickly. How about trying your own hand at it?

llamabeast · #6 October 29th, 2007, 01:20 PM

Agreed that Wikd Thots is rude (habitually). However, I can't think that this could be done so easily in Excel - but I could do it in a minute or so in Perl. All I'd need is the highest nation number in the game. Do you know what it is Edi (don't have the database here)?

Edratman · #7 October 29th, 2007, 01:32 PM

The nation numbers range from 0 to 70.

Edi · #8 October 29th, 2007, 02:06 PM

It is actually very easy to do in Excel. Just add "#allies 1 " to two cells, select, drag down until you have 70, then "#allies 2 " and so forth. Then the next column gets 1, dragged down so it autoincrements, then repeat for others. Copy paste the whole lot to a text editor and replace all tabs with a single space and eliminate the rest. Done.

Still a lot more work than with a script.
Nation numbers go from 0 to 70, with 23, 24 and 25 as special monsters and several others currently not in use. You need to refer to the DB to see which lines need to be eliminated.