[Archive] help with the data base
[Archive] help with the data base
Original source
hi, i would like to know if there is in any place of the BD where the area that the player is, the name of that area.
the reason is, the web i've made, i have an online info, where you can see how many people is at the server, and the players playing at the server, the level, and the area that is at, but i don't know how to put the name of the area instead of the number.
i've tried to find it at the data base were that id is associated with a name, but i could.
Do you know were i can find the name of each id area?
thanks.
rektbyfaith
11-04-2025, 05:19 PM #1Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
hi, i would like to know if there is in any place of the BD where the area that the player is, the name of that area.
the reason is, the web i've made, i have an online info, where you can see how many people is at the server, and the players playing at the server, the level, and the area that is at, but i don't know how to put the name of the area instead of the number.
i've tried to find it at the data base were that id is associated with a name, but i could.
Do you know were i can find the name of each id area?
thanks.
Original source
Hey there,
I honestly have a really hard time understand what you mean, could you maybe try to explain it a little bit further?
I'm not sure if it's only me who has a hard time understanding what you mean.
rektbyfaith
11-04-2025, 05:19 PM #2Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
Hey there,
I honestly have a really hard time understand what you mean, could you maybe try to explain it a little bit further?
I'm not sure if it's only me who has a hard time understanding what you mean.
Original source
If I understood it correctly, you want to know which part of database holds the info about characters' info, am I right? Because you have a website which shows that info and you want to see actual data instead of numbers, etc.
In conclusion, you want to know how to connect your website with database to see characters' info on specific page. Is that correct?
rektbyfaith
11-04-2025, 05:19 PM #3Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
If I understood it correctly, you want to know which part of database holds the info about characters' info, am I right? Because you have a website which shows that info and you want to see actual data instead of numbers, etc.
In conclusion, you want to know how to connect your website with database to see characters' info on specific page. Is that correct?
Original source
Database : emucoachw -> instance_template this table gives the instance zone id's inc names.
But i dont have any luck in finding the ZoneId conversion table. When i find it ill post it here.
rektbyfaith
11-04-2025, 05:19 PM #4Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
Database : emucoachw -> instance_template this table gives the instance zone id's inc names.
But i dont have any luck in finding the ZoneId conversion table. When i find it ill post it here.
Original source
well let me try to explain better, sorry if i cant, my english is not that good... :S
well when you are playing in the game, you can see players that are online and in what zone they are at, i would like to do the same with my website, but i don't know where i can find that info in the DB.
something like this, but in my website:
View attachment who_list.2.jpg
website:
View attachment web.jpg
thankx alot for all you help.
rektbyfaith
11-04-2025, 05:19 PM #5Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
well let me try to explain better, sorry if i cant, my english is not that good... :S
well when you are playing in the game, you can see players that are online and in what zone they are at, i would like to do the same with my website, but i don't know where i can find that info in the DB.
something like this, but in my website:
View attachment who_list.2.jpg
website:
View attachment web.jpg
thankx alot for all you help.
Original source
Sorry for my slow reply, I totally forgot to answer this.
Are you still in need of help, or have you solved the issue yourself?
rektbyfaith
11-04-2025, 05:19 PM #6Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
Sorry for my slow reply, I totally forgot to answer this.
Are you still in need of help, or have you solved the issue yourself?
Original source
yes please, i still would like to know if there is any way to do it.
thanks
rektbyfaith
11-04-2025, 05:19 PM #7Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
yes please, i still would like to know if there is any way to do it.
thanks
Original source
Have you considered changing website?
I know for example that FusionCMS and AzerCMS has this added in their websites.
It's something they have created and you would need to know PHP to create it yourself on the website, if it doesn't have it added already.
Hope I was clear enough.
rektbyfaith
11-04-2025, 05:19 PM #8Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
Have you considered changing website?
I know for example that FusionCMS and AzerCMS has this added in their websites.
It's something they have created and you would need to know PHP to create it yourself on the website, if it doesn't have it added already.
Hope I was clear enough.
Original source
Information like map, zone and area ids comes from WoW's internal database files, the dbc files. All emulators use these files to extract information from, since it would be mostly useless to duplicate it in their own databases.
If you need information from dbcs, you could either program your website to actually read from those dbcs (relatively slow and probably quite some work) or you could extract the information you need from the dbc files yourself (google for a dbc extractor/viewer) and then add it to a mysql database yourself.
More information on this specific dbc file: http://collab.kpsn.org/display/tc/AreaTable.dbc
rektbyfaith
11-04-2025, 05:19 PM #9Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
Information like map, zone and area ids comes from WoW's internal database files, the dbc files. All emulators use these files to extract information from, since it would be mostly useless to duplicate it in their own databases.
If you need information from dbcs, you could either program your website to actually read from those dbcs (relatively slow and probably quite some work) or you could extract the information you need from the dbc files yourself (google for a dbc extractor/viewer) and then add it to a mysql database yourself.
More information on this specific dbc file: http://collab.kpsn.org/display/tc/AreaTable.dbc
Original source
Quote:Pewz said:I thought about that option, but i'm kind of having fun making the page with PHP.
Have you considered changing website?
I know for example that FusionCMS and AzerCMS has this added in their websites.
It's something they have created and you would need to know PHP to create it yourself on the website, if it doesn't have it added already.
Hope I was clear enough.
Click to expand...
Quote:chocochaos said:i'll try to do it with the dbc extractor/viewer.
Information like map, zone and area ids comes from WoW's internal database files, the dbc files. All emulators use these files to extract information from, since it would be mostly useless to duplicate it in their own databases.
If you need information from dbcs, you could either program your website to actually read from those dbcs (relatively slow and probably quite some work) or you could extract the information you need from the dbc files yourself (google for a dbc extractor/viewer) and then add it to a mysql database yourself.
More information on this specific dbc file: http://collab.kpsn.org/display/tc/AreaTable.dbc
Click to expand...
thanks a lot for all your help.
rektbyfaith
11-04-2025, 05:19 PM #10Archived author: gui113r • Posted: 2025-11-04T18:19:04.776652
Original source
Quote:Pewz said:I thought about that option, but i'm kind of having fun making the page with PHP.
Have you considered changing website?
I know for example that FusionCMS and AzerCMS has this added in their websites.
It's something they have created and you would need to know PHP to create it yourself on the website, if it doesn't have it added already.
Hope I was clear enough.
Click to expand...
Quote:chocochaos said:i'll try to do it with the dbc extractor/viewer.
Information like map, zone and area ids comes from WoW's internal database files, the dbc files. All emulators use these files to extract information from, since it would be mostly useless to duplicate it in their own databases.
If you need information from dbcs, you could either program your website to actually read from those dbcs (relatively slow and probably quite some work) or you could extract the information you need from the dbc files yourself (google for a dbc extractor/viewer) and then add it to a mysql database yourself.
More information on this specific dbc file: http://collab.kpsn.org/display/tc/AreaTable.dbc
Click to expand...
thanks a lot for all your help.
1 Guest(s)
1 Guest(s)