Where in TFS are outfits saved?
- Thread starter trans
- Start date
They are saved in the players table. Table fields in the players table: id, name, group_id, account_id, level, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, redskull, redskulltime, rank_id, guildnick, lastlogout, blessings, direction, loss_experience, loss_mana, loss_skills, premend, online
But where are stored the player addons? Oo
slaw
Software Developer
But what you want exactly do? I think it isnt easy to edit it as storage values becouse it arent standard values. I created new character, added him first citizen addon, and in db i saw 2 storage values, when i added second addon then still was 2 storages, but only 'value` was changed.
@up
I think the storage values for addons are treated like the flags (2 ^ x).
I think the storage values for addons are treated like the flags (2 ^ x).
rockseller
Lua & .NET Programmer
Yes i will. I've got some time, hope u got it aswell to read it 
.
If you are using MySQL.
Enter localhost/phpmyadmin/
Enter username/pass (IF required)
Enter your OTserv database (i.e forgottenserver)
Ok now let's do this.
Look for Players table, and clic on it (In the left part of the screen menu)
Then look for a button called "Examine", Clic on it, now, look for a player name, then clic on Edit on the one you want to know the addons he has.
The first field is "id".
Writte down his ID.
Now go to "player_storage"
The same way you entered Players table.
Clic on "Examine".
Now clic on "Search".
scroll down abit, and look for "player_id", then right next to it, type the "id" of the player you writted down.
Press continue.
Now you will get something like this:
Let me explain you a bit.
"Player_storage" table, is used for quests, such as the chests you open to get an item, once you open a chest for an item, you recieve the item, and you get a storage value, so you cannot get that item again.
Ok now let's continue with what we want.
You want to know where are the addons stored.
The easiest way to know what storage value are they stored in, is to look at the search results, and look for something like this:
So as you can see, for a the player with the ID 1299, those starting with 1000xxxx are the ones of Addons.
What i did with this, was deleting those 1000xxxx storage IDS and then that player lost the addons.
And that's it, this is why people prefeer XML instead SQL, tho SQL is way better imo. EASY access, you just need to be patient to learn about it, you can delete EVERY PLAYER_STORAGE ADDONS with just some clics.
.If you are using MySQL.
Enter localhost/phpmyadmin/
Enter username/pass (IF required)
Enter your OTserv database (i.e forgottenserver)
Ok now let's do this.
Look for Players table, and clic on it (In the left part of the screen menu)
Then look for a button called "Examine", Clic on it, now, look for a player name, then clic on Edit on the one you want to know the addons he has.
The first field is "id".
Writte down his ID.
Now go to "player_storage"
The same way you entered Players table.
Clic on "Examine".
Now clic on "Search".
scroll down abit, and look for "player_id", then right next to it, type the "id" of the player you writted down.
Press continue.
Now you will get something like this:
Code:
player_id key value
189 300 0
Borrar 189 2158 1
Borrar 189 2487 1
Borrar 189 2495 1
Editar Borrar 189 7390 1
Editar Borrar 189 10085 1Let me explain you a bit.
"Player_storage" table, is used for quests, such as the chests you open to get an item, once you open a chest for an item, you recieve the item, and you get a storage value, so you cannot get that item again.
Ok now let's continue with what we want.
You want to know where are the addons stored.
The easiest way to know what storage value are they stored in, is to look at the search results, and look for something like this:
Code:
1299 10001001 8388611
1299 10001002 8454147
1299 10001003 8519683
1299 10001004 8585219
1299 10001005 8650755
1299 10001006 8716291
1299 10001007 8781827
1299 10001008 9371651
1299 10001009 9437187
1299 10001010 9502723
1299 10001011 9568259
1299 10001012 9895939
1299 10001013 9961475
1299 10001014 10027011
1299 10001015 10092547
1299 10001016 16449539
1299 10001017 17563651
1299 10001018 17891331
1299 10001019 18219011
1299 10001020 3
1299 10001021 8912899
1299 10001022 8978435
1299 10001023 9043971
1299 10001024 9109507
1299 10001025 9175043
1299 10001026 9240579
1299 10001027 9306115So as you can see, for a the player with the ID 1299, those starting with 1000xxxx are the ones of Addons.
What i did with this, was deleting those 1000xxxx storage IDS and then that player lost the addons.
And that's it, this is why people prefeer XML instead SQL, tho SQL is way better imo. EASY access, you just need to be patient to learn about it, you can delete EVERY PLAYER_STORAGE ADDONS with just some clics.
kaspertje100
Member
- Joined
- May 8, 2008
- Messages
- 236
- Reaction score
- 7
ey hi,
is there a program that edit SQLite Storage?
is there a program that edit SQLite Storage?
