BAD_AL

You can get TSBTool from the uploads section http://www.tecmobowl.org/forum/viewtopic.php?t=6941 .

You can use Lutz Roeder's 'Reflector' tool to view the 'disassembeled' source code (in either C# or VB.net) http://www.aisto.com/roeder/dotnet/ .

If you wanted to interact with TSBTool you could do either of the following:

1. Reference 'TSBTool.exe' and create the objects, subclass objects, call static functions ect...

2. Construct string input for it to read and just 'exec' it, feeding it the input via standard in.

One of it's little used functions is the 'SET' command.

SET( , )

SET( 0x3456B, 0x55AB)

It's a very simple command, but it can be used to accomplish any hex edit (which can be useful when writing/generating scripts).

If you wanted to use a DLL instead of the .exe I could go through the code and make the functionality easier for outside apps to use.

If you'd like I could give you a .NET dll with all of the functionality of TSBTool.

By doing that you would get the following:

1. Player Attribute editing (name, jerseyNumber, abilities, face, sim data).

2. Schedule editing.

3. Text input parsing.

4. Kick/Punt Return men assignment.

5. Team Sim editing (along with offensive preference).

Then you could concentrate on the stuff that hasn't yet been done ( at least not done in TSBTool).

Or you could go ahead and re-invent the wheel..

If you want to do an all-in-one program, that's going to be a pretty big project (unless you omit graphic hacking).

What do you plan on writing this in (C, C++,C#, Java, VB, ...)?

I think the most useful thing would be a helmet manager program (for both large and small helmets).

Features:

1. extract each team's helmet (from a given ROM) to a bmp file.

2. ability to assign one of the bmp (helmet) files to a team in the ROM.

As far as Player name, and attribute editing go we already have TSBM and TSBTool to do these things.

Malfreds,

Could you also upload a ROM that doesn't exclude original teams?

Or perhaps post a TSBTool script that contains the data for all 32 teams?

You can use any programming language, as long as the program has the power to read and write files.

For instance 'Flash' [ActionScript] (as far as I can tell) cannot read files from a computer's file system.

I would suggest one of the following languages:

1. C#

2. C

3. Java

4. C++

5. Visual Basic

C#, Java and Visual Basic.NET will require your program users to have the required run time in order to run.

C and C++ typically compile to native code, but these languages are not as friendly to program in.

If you are looking for a free development enviornment I would suggest looking at the following:

1. C# Express ( http://msdn.microsoft.com/vstudio/expre ... fault.aspx )

2. Visual Basic Express ( http://msdn.microsoft.com/vstudio/expre ... fault.aspx )

3. Netbeans [for java]( http://www.netbeans.org/ )

4. Dev C++ ( http://www.bloodshed.net/devcpp.html )

They are in order from best to worst.

malfreds,

There's a feature in SNES_TSBTool that you may want to try out for assigning faces to players.

It's called 'Sanitize data for NES TSBTool'. It's under the 'View' menu. It aims to take out all of the SNES specific things, as well as re-do the faces for the NES version.

It relies on TSBSeasonGen's 'TSB_DATA/NumberFaceData.txt' file. Basically, it reads the player names and positions in the input text and looks for that player name/position combo in the 'NumberFaceData.txt' file. If it's not found, it will apply a face based on skincolor and the length of the player's name.

Try the following to use it:

1. Paste your data into SNES_TSBTool.

2. Apply the data to some SNES TSB ROM.

3. Select 'View Contents'.

4. Select View->Sanatize data for NES TSBTool.

5. Copy the player data and paste it into TSBTool (for the nes).

6. Load your base rom.

7. Apply to Rom.

Give it a try and let me know if you encounter any problems.

The player faces are based on the original rom, as well as many of Rod and SBlueman's.

If there's a rom you want to add more faces from you can run the following from the commandline:

C:\TSB_NFL> TSBTool -j -n -f romName.nes >> TSBData/NumberFaceData.txt

This assumes that you are in the 'TSB_NFL' directory (This is the directory that I placed TSBTool and TSBSeasonGen into when I released it).

Note the double 'greater than' symbol '>>', make sure there are no spaces between those 2 symbols.

If you find that it's a defect in SNES_TSBTool please zip up both the ROM and the input text file and upload it here.

I just downloaded one of his latest ROMs and applied the 1982 data to the ROM, everything came out fine.

The emulator file size (jar file) is about 200K.

The applet archive (jar file) would be downloaded to the client PC and run on the client PC. The only stress on the server comes from serving up the rom file and the archive(jar file) (in the example code provided the web requests would go through 'everyvideogame.com').

I've done a bit more research on the html needed to embed applets on web pages, and you can use the following code for XHTML, but it looks llike you could only embed it into a page that you controlled yourself. I havn't been able to get the applet to show up on a Wiki or in any forums. It appears that they do not allow APPLET or OBJECT tags. If you do find somewhere that allows APPLET or OBJECT tags, you could use the code provided.

    classid = "clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
    codebase = "http://java.sun.com/update/1.4.2/jinstall-1_4-windows-i586.cab#Version=1,4,0,0"
    WIDTH = 256 HEIGHT = 240 NAME = nescafe >









            type = "application/x-java-applet;version=1.4" \
            CODE = NESCafeApplet \
            ARCHIVE = "http://www.everyvideogame.com/hardware/nescafe070.jar" \
            NAME = nescafe \
            WIDTH = 256 \
            HEIGHT = 240 \
            ROMFILE ="http://www.everyvideogame.com/games/nes/Tecmo_Super_Bowl_(U).zip" \
            SOUND ="true" \
            LIGHTGUN ="false" \
	    scriptable = false \
	    pluginspage = "http://java.sun.com/products/plugin/index.html#download">

            You need to download and install [url="http://www.java.com/en/download/manual.jsp"]Java[/url] to play.

Then they've dis-allowed applet tags.

I looked at one of the Myspace pages with duck hunt, it has a reference to a swf (flash file). It looks like someone just ported duck hunt to flash.

[flash width=350 height=300]http://www.media.ebaumsworld.com/duckhunt.swf[/flash]

[flash width=350 height=300]http://www.media.ebaumsworld.com/duckhunt.swf

Try embedding this into the page.

<html>
    archive="http://www.everyvideogame.com/hardware/nescafe070.jar"
    width=256 
    height=240
    name=nescafe>



    You need to download and install [url="http://www.java.com/en/download/manual.jsp"]Java[/url] to play.

If you could find a (pure) Java based nes emulator this would be easy.

A quick google reveals http://www.davieboy.net/nescafe/ . So it shoud be totally easy to do. I 'll look into it more later.

Note: you would need to have the Java JRE installed in order to run this.

If you don't have java installed on your computer you can get it here:

http://java.sun.com/j2se/1.5.0/download.jsp

Use JRE 5.0 Update 7

If you have problems getting things to work, I can probably tell you what you need to do. I'v done a good bit of Java programming and am familiar with many common issues.

Have a look at http://www.everyvideogame.com/play-nes- ... er_Bowl_(U).htm

A Wiki is a website in which users can modify the content.

So if you wanted to add some content to the Tecmo Wiki, you could.

The largest Wiki (thit I'm aware of) is http://www.wikipedia.org. It's an online encyclopedia. If you are a registered user of that site you can add pages, and modify content.

Malfreds,

I had a look at you spreadsheet and I've concluded that it would take to long to automate the data download.

If you used stats from the team page, it wouldn't be so bad. But since you require stats from player pages the programming required would take a lot longer.

Sorry dude.

I'll enjoy playing with this roster edit.

Thank you for providing it.

larry,

I am getting a 403 "Forbidden" on the spreadsheet link.

Larry,

I'm not sure I understand your question, but I'll try to answer (based on what I think you are asking).

There is a "Even teams TIP" (3rd post) in the TSBTool thread where it talks about using spreadsheets with TSBTool.

You should checkout Malfred's spreadsheet.

When the spreadsheet is complete, you should be able to paste the 'Tool Output Rom' sheet into a text editor and replace all TABs with COMMAs, and then copy that data and paste into TSBTool, apply to ROM, then you are done.

Keep in mind that you need to make sure that you follow TSBTool's rules:

1. You need to assign a jersey number to a player.

2. You need to specify a team name before you can assign players to a team.

3. You need to assign every attribute to a player (sim data is optional).

VBA stands for 'Visual Basic for Applications'.

In each of Microsoft's Office programs (Word, Excel, PowerPoint, Outlook ...) you can create what are called 'Macros'. Macros are functions written by a user of the program.

Macros are used to automate repetitive tasks (like adding a sheet to a workbook and inserting some text in it).

The macros are written in VBA.

The easiest way to see what a macro is is to 'record' one.

In Excel

1. goto Tools->Macro->Record new macro.

2. You'll be promped with a little popup that asks you to name the macro, and perhaps add a keyboard shortcut.

3. Once you close the initial popup, all actions you do are 'Recorded' in VBA.

Try this:

Do the above (name the macro 'AddSheet') and then add a new sheet to a workbook, enter 'This is my new sheet' in cell A1. Press the 'Stop' button.

Then go to Tools->Macro->Macros [or press Alt+F8], select 'AddSheet'. You should get another sheet that says 'This is my new sheet' added to the workbook.

To view the VBA code that defines your macro, goto Tools->Macro->Visual Basic Editor (or press Alt+F11).

Macros are very powerful (It's basicly a fully functioning programming language embedded in your spreadsheet, word document, ect...), Macros can be written to cause damage to your computer (so only run macros if you trust the document author).

A Web Query in Excel is a command you can run to download tables of information from the internet, into your excel document.

1. Add a new sheet to an excel document.

2. Go to Data->Import External Data->New Web Query

3. enter some url that will have stats in the address bar of the browser you are presented with.

4. Click on one of the yellow boxes

5. click on 'Import'

6. Click 'OK' on the little popup.

7. The data in the table you selected is downloaded into your new sheet.

Back to your spreadsheet.

If you go to each player's page to get stats, then it may take a long time to automate the data retrieval. I'll check out your workbook and see what I can do with it.

By the way, what version of Excel do you use?

Malfreds,

I think I can automate the download of the stats you are after (by using web queries in VBA). Post your spreadsheet in the upload section and I'll code it up.

malfreds

You should be able to use the beta version of SNES_TSBTool if you want to calculate sim data (it's on page 6 of the TSBTool/TSBSeasonGen thread).

I think I've got all the bugs regarding 'simming' squashed.

I played around with simming on the SNES last night, and it seems to be working correctly.

Ok.

I uploaded beta 4. The 49ers/falcons sim data mixup is fixed.

The sim data seems like the only place that the order of the teams is inconsistent.

Epa1patine,

Thanks for finding those issues.

Wow, you're right.

It looks like I've got the falcons and 49ers mixed up.

After a quick glance at the source code, everything looks right.

But when I take another glance at the Sim value spreadsheet it looks like Tecmo didn't re-ordered the sim values for SNES TSB (they kept the order that they had in the nes version).

I'll special case the sim values and have this fixed soon.

The punt/kick offense/defense bytes are located right next to eachother.

I was off by 1 in my GetTeamSimData and SetTeamSimData functions.

Thanks for finding the issue.

I'm going to upload the new beta for more testing. It'll be in the same place (page 6).

I see the problem.

The punter and kicker sim data are overwriting the team sim data in the beta version of SNES_TSBTool. I'll have this fixed in the release version.