How to export SQL records for a specific player?When you got problems with an avatar, it's possible I ask you the bugged avatar.
For that, you need to export the data from the Mysql tables "characters", "items" and "list_quest_new" ONLY for this avatar.
Characters handles the data for your avatar (level, zuly...), items... the items, and list_quest_new the quest informations.
Note:If you can't do it with that guide, I suggest you find a rope and hang yourself, or jump in front of a bus (or subway) or a railway or just die.
I°) With PhpMyAdmin:I give only the full explanation once, it's the same process for the other tables.
The avatar (name in game) I want to export here is
LGally2.
1°) "characters" table:Open "characters" table in PhpMyAdmin, and select the avatar "LGally2". You can see that his "
id" is
2, NOTE it for later.
Once you selected (checked) the line, just click on the icon "export".
Then simply check "Transmit" (or whatever) so PhpMyAdmin exports a FILE, then click "Execute".
It makes you download a file only with the "good" avatar, magic
- SNAG2G-real_0004.png (27.75 KiB) Viewed 28841 times
2°) "items" table:Open "items" table and click on "Search" tab.
As "owner", enter the Avatar's Id (2 in my example, remember?) and "execute".
You only have the avatar's items. Select them all and click on the "export" icon.
Then simply check "Transmit" (or whatever) so PhpMyAdmin exports a FILE, then click "Execute".
It makes you download a file only with the "good" avatar, magic
3°) "list_quest_new" table:Open "list_quest_new" and select the line where the "owner" is your avatar's id (2 in my example, remember?) and click on the "export" icon.
Then simply check "Transmit" (or whatever) so PhpMyAdmin exports a FILE, then click "Execute".
It makes you download a file only with the "good" avatar, magic
II°) With Navicat:It's quite easy too. The aim of the game is only to select the good data before export...
The avatar (name in game) I want to export here is LGally2.
1°) "characters" table:Open "characters" table, select the line that you want to export (
LGally2). Note that the avatar's "
id" is
2.
Then put your mouse on the "id" field and right click to go to: "Filter"->"Field=Value".
This way only the line you selected is left, then click on the "Export" button.
- SNAG2G-real_0009.png (10.9 KiB) Viewed 28831 times
When it asks you if you want to export ALL data, say NO, since you only want to export the one you selected.
- SNAG2G-real_0010.png (7.9 KiB) Viewed 28829 times
Select SQL file format:
Then tell where you want to save the sql file:
- SNAG2G-real_0012.png (9.69 KiB) Viewed 28830 times
- SNAG2G-real_0014.png (11.42 KiB) Viewed 28826 times
Leave the rest default:
- SNAG2G-real_0016.png (11.47 KiB) Viewed 28824 times
The click on "Start" to export:
- SNAG2G-real_0017.png (10.08 KiB) Viewed 28825 times
When it's done you see it has exported only one record
Magic all over the place again.
2°) "items" table:Open "items" table.
Select a line where the owner of an item is "2" (remember, it's the avatar's od), then put your mouse on the "owner" field and right click to go to: "Filter"->"Field=Value".
Only the items from the "owner" 2 should remain.
Click on the export button.
When it asks you if you want to export ALL data, say NO, since you only want to export the one you selected.
Select SQL file format.
Then tell where you want to save the sql file.
Leave the rest default.
The click on "Start" to export.
3°) "list_quest_new" table:Open "list_quest_new" table.
Select the line where the owner is "2" (remember, it's the avatar's od), then put your mouse on the "owner" field and right click to go to: "Filter"->"Field=Value".
- SNAG2G-real_0021.png (18.49 KiB) Viewed 28824 times
Only the quest informations from the "owner" 2 should remain.
Click on the export button.
When it asks you if you want to export ALL data, say NO, since you only want to export the one you selected.
Select SQL file format.
Then tell where you want to save the sql file.
Leave the rest default.
The click on "Start" to export.
Ok after that, you rar or zip the files and post them into forum
Simple, right?