• Welcome to Final Fantasy Hacktics. Please login or sign up.
 
March 28, 2024, 04:47:09 am

News:

Don't be hasty to start your own mod; all our FFT modding projects are greatly understaffed! Find out how you can help in the Recruitment section or our Discord!


Patching Excel stuff

Started by Xifanie, September 30, 2007, 12:00:11 am

Xifanie

September 30, 2007, 12:00:11 am Last Edit: January 05, 2008, 10:33:44 am by Xifanie
Required Tools:
Hex Editor (http://www.fileden.com/files/436/WH.rar ; pass is fft)
Excel 2000 or higher
Analyst Toolpak (found on the site if you don't have it already)
CD Mage Beta (http://ftp.uevora.pt/pub/Mirrors/CDmage/CDmage1-02-1B5.rar)

To Patch:
- Make all the modifications you want to make in Excel. If auto-calculation is manual, go in
Tools/Options.../Calculation/ and press "calc now".
- Select the given area called "Hex ASCII" in the "END" sheet. Copy it.
- Open notepad and paste the data. Save with any name you wish (let's call it file X).
- Open the Hex Editor, then open your newly saved file & the file to patch with it (let's call it file Y).
// 0x64 is an example of a number in HEX. During the following procedures, don't type the "0x"; you'll simply get an error.
- Take file X and go in
Search/Replace Hex Values
Search for: 0x0D0A
Replace with: <Empty field>
Press OK, then Yes.
- Press Ctrl + R and select Hex ASCII -> Binary.
- Select all data (Ctrl+a or Edit/Select All). and copy it.
- Now take file Y and select the corresponding byte depending on your file:
for SCUS_942.21 (US version): 0x4F3F0
for SLPS_007.70 (JP version): 0x4C744
- Press Ctrl + B then click OK in the message box.
- Save

To Insert back the file using CD Mage Beta:

Open CD Mage Beta.
Open your ROM Image.
Right click on the corresponding file, click Import... and track down your file you just saved. It might be a good idea to keep an original copy of your file.
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Xifanie

October 12, 2007, 07:40:52 pm #1 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
Updated: simpler method.
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Julian

October 15, 2007, 10:16:23 pm #2 Last Edit: December 31, 1969, 07:00:00 pm by Julian
Sorry for the noobness, but I'm stuck at this step:

Quote from: "Zodiac"- Now take file Y and select the corresponding byte depending on your file:
for SCUS_942.21 (US version): 0x4F3F0
for SLPS_007.70 (JP version): 0x4C744

I'm trying to edit ENTD4.ENT, so I assume the "Y" file is the original ENTD4.ENT, but it only goes up to 13FFF.  Not too sure if I've been doing it right, but I can't get through this part with trial and error, so thought I'd ask.

again, sorry for the noobness :/

Xifanie

October 15, 2007, 11:00:10 pm #3 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
QuoteSelect the Hex ASCII column and copy it in notepad. Save the file with any                           
name. Use your favorite Hex Editor to Replace word 0x0D0A to nothing or remove all line                           
breaks manually. Simply convert from Hex ASCII -> Binary and save the file with the                           
right name. There you go! No patching. Just reinsert the new file in your ROM image.         

Directly from the workbook.
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Julian

October 18, 2007, 10:42:05 pm #4 Last Edit: December 31, 1969, 07:00:00 pm by Julian
Quote from: "Zodiac"
QuoteSelect the Hex ASCII column and copy it in notepad. Save the file with any                           
name. Use your favorite Hex Editor to Replace word 0x0D0A to nothing or remove all line                           
breaks manually. Simply convert from Hex ASCII -> Binary and save the file with the                           
right name. There you go! No patching. Just reinsert the new file in your ROM image.         

Directly from the workbook.

Ah, damn.  My mind skipped over those directions because they looked to be the same as the one on the forums which I was already following >.<

Thanks a lot, worked like a charm

Christopher Robin

October 19, 2007, 03:38:08 am #5 Last Edit: December 31, 1969, 07:00:00 pm by Christopher Robin
When I do this, my SCUS_942.21 file ends up bigger than it used to be.  It just adds the new stuff instead of overwriting anything, and you've removed the instructions for taking out the stuff using UltraEdit.

Xifanie

October 19, 2007, 06:15:31 am #6 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
Err are you sure you're pressing Ctrl + B and not Ctrl + C?

Ctrl + B = Write and will only expand the file if your clipboard data is wider than your byte position to the last one. Which is not really possible in this case. :roll:
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Xifanie

October 19, 2007, 06:22:05 am #7 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
Crap, I forgot to add the Hex ASCII -> Binary part...

Fix'd
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

VincentCraven

October 24, 2007, 07:31:54 pm #8 Last Edit: December 31, 1969, 07:00:00 pm by VincentCraven
Where can I change the range of brave and faith randomly generated? Is that known currently?
I changed jobs and that has made all the difference.

Xifanie

October 24, 2007, 07:57:27 pm #9 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
No, but I'll add that to my search list. I was actually wondering of what assembly instructions to find. ;o
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

karsten

October 25, 2007, 06:52:09 am #10 Last Edit: December 31, 1969, 07:00:00 pm by karsten
Quote from: "Zodiac"No, but I'll add that to my search list. I was actually wondering of what assembly instructions to find. ;o

nice idea, really. also you might see if it is possible to randomize the level too :D that might be too funny!

Xifanie

October 25, 2007, 10:53:23 am #11 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
It is already possible. Randomly generated level = Highest char level - [1..5].

I can probably change that (if I search enough) but I doubt there is any usable space out there for me to add purely random levels like 60 to 75.
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Selius2

October 30, 2007, 07:23:00 pm #12 Last Edit: December 31, 1969, 07:00:00 pm by Selius2
How can I modify in Excel the 1.2 patch?

The file in the downloads section is the base stuff. (i.e. no thief with innate Concentrate) I want to work from the 1.2 changes instead of having to manually enter all the changes.

Xifanie

October 30, 2007, 08:06:50 pm #13 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
I am not affiliated in any way with philsov's project.
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Selius2

October 30, 2007, 09:38:55 pm #14 Last Edit: December 31, 1969, 07:00:00 pm by Selius2
- Select the given area called "Hex ASCII" in the "END" sheet. Copy it.

How do I do this step? There's nothing to copy. I already did the Calculate Now.


VincentCraven

October 30, 2007, 11:32:54 pm #15 Last Edit: December 31, 1969, 07:00:00 pm by VincentCraven
You didn't try copying the 3 lines of zeros into a notepad?
I changed jobs and that has made all the difference.

Xifanie

October 31, 2007, 06:48:59 am #16 Last Edit: December 31, 1969, 07:00:00 pm by Xifanie
And I thought it was obvious. X_X

Geez, don't use jpg, they are so long to load, looks like crap, and seem extremely unprofessional.
  • Modding version: PSX
Love what you're seeing? https://supportus.ffhacktics.com/ 💜 it's really appreciated

Anything is possible as long as it is within the hardware's limits. (ie. disc space, RAM, Video RAM, processor, etc.)
<R999> My target market is not FFT mod players
<Raijinili> remember that? it was awful

Selius2

October 31, 2007, 09:23:58 am #17 Last Edit: December 31, 1969, 07:00:00 pm by Selius2
Why the hell does it only work after someone says it. I look stupid even after I tried it no less than 10 times.

Every time I would try to copy it into notepad, nothing would happen.

Anyway, I got it working.  Thank you Vincent.

Idot

November 07, 2007, 03:02:13 pm #18 Last Edit: December 31, 1969, 07:00:00 pm by Idot
Quote- Now take file Y and select the corresponding byte depending on your file:
for SCUS_942.21 (US version): 0x4F3F0
for SLPS_007.70 (JP version): 0x4C744
- Press Ctrl + B then click OK in the message box.
- Save

I can get there, but I assume that file Y is the SCUS_942.21 file in the FFT iso...
Well, selecting the 0x4F3F0 byte would mean the line that has this number, is it? because I've done everything else and the game won't run properly... lets say that the only thing i've changed was the Ramza's Wish to All-Ultima... then when i play the game i see knights using Lose Voice, Agirias and Gafgarion freezed and many other bugs....


I can only think that i'm only using the Ctrl+B in the worng place, so, can anyone tell me what to do?[/quote]

Selius2

November 08, 2007, 09:19:09 pm #19 Last Edit: December 31, 1969, 07:00:00 pm by Selius2
In WinHex:

Position>Go to Offset > 4F3F0

then hit ctrl b