• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

Help editing 2010 FIFA World Cup {PS3} database

B

bebo

Club Supporter
im trying edit player attributes in the database of the game for sometime now
i appreciate and really want to thank @ramzidz15 who helped me alot with the required programs to decrypt data0.big.sdat then opening data0.big file and extracting the db and meta
i tried to open it by db master or converting it by db converter it gave me error
i tried to extract it by db master 11 and this time it worked!! data were there and i edited some of it
but there is a big problem now with the players table
- id's of the players in (playernames table) are not found in (players table), both have the same amount of records but with different id's
- player names in (players table) are in numbers and i have no idea how to convert it to words
- i tried to search for players by their in-game attributes but no results found
i don't know what to do anymore and it's giving me a headache, so if someone may help me with it please..
thank you
 
T

tokke001

Senior Squad
bebo said:
im trying edit player attributes in the database of the game for sometime now
i appreciate and really want to thank @ramzidz15 who helped me alot with the required programs to decrypt data0.big.sdat then opening data0.big file and extracting the db and meta
i tried to open it by db master or converting it by db converter it gave me error
i tried to extract it by db master 11 and this time it worked!! data were there and i edited some of it
but there is a big problem now with the players table
- id's of the players in (playernames table) are not found in (players table), both have the same amount of records but with different id's
- player names in (players table) are in numbers and i have no idea how to convert it to words
- i tried to search for players by their in-game attributes but no results found
i don't know what to do anymore and it's giving me a headache, so if someone may help me with it please..
thank you
Click to expand...
The ids for common name, first name, ... at table players are the ids found at table playernames
 
B

bebo

Club Supporter
tokke001 said:
The ids for common name, first name, ... at table players are the ids found at table playernames
Click to expand...
sorry i can't understand you
you mean the id's are the same? but in players table it's shown as numbers and in playername table it's shown as words
this is a preview of the 2 tables
as you can see i have no clue how to know the player in (player table)
Untitled.jpg
Untitled1.jpg
 
T

tokke001

Senior Squad
bebo said:
sorry i can't understand you
you mean the id's are the same? but in players table it's shown as numbers and in playername table it's shown as words
this is a preview of the 2 tables
as you can see i have no clue how to know the player in (player table)
View attachment 117636View attachment 117637
Click to expand...
Ah, i am wrong
I described earlier how it is at newer fifa games

But 1 thing i notice :
Some values at table players look weird,
I think the database is wrongly loaded maybe ?
Values like playerid and playerjointeamdate look weird
 
B

bebo

Club Supporter
tokke001 said:
Ah, i am wrong
I described earlier how it is at newer fifa games

But 1 thing i notice :
Some values at table players look weird,
I think the database is wrongly loaded maybe ?
Values like playerid and playerjointeamdate look weird
Click to expand...
yeah that's what i think too, i extracted it by db master 11 from 0data.big and that's the only time it loaded in db master
when extracted by fifa file explorer it doesn't load and gives me error
as i mentioned before i decrypted 0data.big.sdat by TrueAncestor_EDAT_Rebuilder_v1.65
you think i did anything wrong? can you help me with it, please?
if you want i will upload the original 0data.big.sdat or 0data.big for you to try it
 
T

tokke001

Senior Squad
bebo said:
yeah that's what i think too, i extracted it by db master 11 from 0data.big and that's the only time it loaded in db master
when extracted by fifa file explorer it doesn't load and gives me error
as i mentioned before i decrypted 0data.big.sdat by TrueAncestor_EDAT_Rebuilder_v1.65
you think i did anything wrong? can you help me with it, please?
if you want i will upload the original 0data.big.sdat or 0data.big for you to try it
Click to expand...
U can try export the tables to an excel sheet with the tool included here

Import isnt possible with that tool however
 
B

bebo

Club Supporter
it gives me this error

Untitled.jpg


when i click continue nothing exported and the tool closes
i think the db is corrupted or the 0data.big file got corrupted while decrypted
 
B

bebo

Club Supporter
tokke001 said:
Did u use the db and xml file directly extracted from the .big file ?
Dont use a tool like db converter
Click to expand...
yeah i opened db and xml by db master directly after extracting without using anything else
and as i replied to you yesterday i thought the db was corrupted so today i downloaded another version of the game (with different id to be sure i tried all available versions)
decrypted "0data.big.sdat" by "TrueAncestor_EDAT_Rebuilder_v1.65"
got "0data.big.dat"
extracted "db and xml file" by "db master", opened the db and it was exactly like the other version with the same strange values
then extracted "db and xml file" by "fifa file explorer" and "EA big tool 1.4", i had the same result
in the end extracted "db and xml file" by "big file extractor" and like what happened with the other version before it won't open by db master and gives me error
i don't know what to do anymore, the last hope i have that decrypting sdat is the cause of the corruption to db and xml file, but also i don't know what to do if it is the reason
 
B

bebo

Club Supporter
Rizzaldio said:
Easiest way is to create a cheat table. Let me know if you need me to create one for you
Click to expand...
yes please if you may, i would really appreciate it
i tried that but with no luck at all, i got some values for the players (it's in 2 byte big endian and 4 byte big endian) changed them in CE but in the game nothing changes
 
You must log in or register to reply here.


Top