New topic icons for bugs, please use them. (and rules)

Put your bugs you find in osRose here

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

New topic icons for bugs, please use them. (and rules)

Postby lmame on Fri Jan 02, 2009 11:33 am

I've added new topic icons, please use them when you report a bug:
New bug: Image

Those are "for me" or devs to tell if the bug is:
Beeing reviewed / some bugs in the thread done: Image
Bugs needed to be tested again: Image
solved: Image

Asking for new features: Image

Now for the rules for posting a bug:
1°) in the title:
-> please specify the version of the server you're using, like:
"[dev rev 296] my problem is...."

2°) in the thread:
-> please post the client you are using (naRose) AND the version of the cilent, for example:
"I'm using naRose 196"
-> please post your OS (Windows XP, Vista...),
-> explain in English what is the problem, completly, with all the details,
-> explain a way to reproduce it,

3°) documents:
-> please check if you have a warning or error message server side as well and post it into your thread,
-> if you want to post your log file, please ZIP or RAR it before and post only the interesting part,
-> you can post screenshots if you want as well, add them to the thread,


Note:
To enable the logs on your server, just create a folder "log" into your "binary" folder, to have :"/binary/log" and the logs files will be written here.
To enable the packet logs on your server, just create a folder "plog" into your "binary" folder, to have :"/binary/plog" and the packet logs files will be written here (only for dev rev, NOT for rev 80).
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: New topic icons for bugs, please use them. (and rules)

Postby lmame on Sat Jan 03, 2009 9:16 pm

To run a server in debug mode:
-> open the server in codeblocks (like worldserver.cbp),
-> do menu "Debug"->"Start",

Of course don't run the .exe when you run a server in debug mode.
For example if you want to run worldserver in debug mode:
-> launch loginserver.exe, then charserver.exe like usual,
-> run worldserver in debug mode using codeblocks,


And wait for the crash.
To see the information windows (stack and so on):
Debug->Debugging Windows->Call Stack (and others),


See this thread for more details on debugging:
viewtopic.php?f=18&t=2189
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: New topic icons for bugs, please use them. (and rules)

Postby lmame on Fri Jan 30, 2009 9:18 am

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. :roll:


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".
SNAG2G-real_0001.png


Then simply check "Transmit" (or whatever) so PhpMyAdmin exports a FILE, then click "Execute".
SNAG2G-real_0026.png


It makes you download a file only with the "good" avatar, magic :)
SNAG2G-real_0003.png

SNAG2G-real_0004.png
SNAG2G-real_0004.png (27.75 KiB) Viewed 28754 times

SNAG2G-real_0005.png



2°) "items" table:
Open "items" table and click on "Search" tab.
SNAG2G-real_0023.png


As "owner", enter the Avatar's Id (2 in my example, remember?) and "execute".
SNAG2G-real_0024.png


You only have the avatar's items. Select them all and click on the "export" icon.
SNAG2G-real_0025.png


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.
SNAG2G-real_0027.png


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".
SNAG2G-real_0006.png


This way only the line you selected is left, then click on the "Export" button.
SNAG2G-real_0009.png
SNAG2G-real_0009.png (10.9 KiB) Viewed 28744 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
SNAG2G-real_0010.png (7.9 KiB) Viewed 28742 times


Select SQL file format:
SNAG2G-real_0011.png


Then tell where you want to save the sql file:
SNAG2G-real_0012.png
SNAG2G-real_0012.png (9.69 KiB) Viewed 28743 times

SNAG2G-real_0013.png

SNAG2G-real_0014.png
SNAG2G-real_0014.png (11.42 KiB) Viewed 28739 times


Leave the rest default:
SNAG2G-real_0015.png

SNAG2G-real_0016.png
SNAG2G-real_0016.png (11.47 KiB) Viewed 28737 times


The click on "Start" to export:
SNAG2G-real_0017.png
SNAG2G-real_0017.png (10.08 KiB) Viewed 28738 times


When it's done you see it has exported only one record :) Magic all over the place again.
SNAG2G-real_0018.png



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".
SNAG2G-real_0019.png


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
SNAG2G-real_0021.png (18.49 KiB) Viewed 28737 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?
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City


Return to Bugs

Who is online

Users browsing this forum: No registered users and 6 guests