[GUIDE]Server sided problems? Come & Ask.

[Royalblade*]

Originally Posted by MR ! HЄRO

SR_GameServer error

some screen shot




And Shard

Seriously your so arab. Cannot help you without having more information. The GS and/or shard timeout can happen due to gazillions of reasons.

Originally Posted by its.soul

- i know how exploits works ..etc but i wonder that there is a special packets make overflow
so my question " is any packet flood cuz that or only the released packets .. For ex. if we take the login packet that sending the account informations and start flood agent with it .. that will cuz the same effect ?"
regards

Technically speaking yes. Practically no. If you flood enough, with any kind of packet the server files will overload.

The art in flood based exploits is malforming the packet in a way, that it creates a serious load on the module.

[blapanda]

Question (vSRO 188): Latest added itemshop items do show the silkprice as 0, no matter what. Adding those items, exact the same string (unchanged values ID & Link on ObjCommon, Index on ScrapOfPackageItem, and so on) on a clean server - will result in a flawless display of X Silk, as it should used to be.
No server errors given. Client causes no troubles.
Any clue? Maybe a procedure issue? Or a "cap" of the gameserver/etc.?

[thebate1]

Originally Posted by Royalblade*

I felt like helping the community a little bit. So go ahead, ask questions and we might end up developing awesome new stuff.

What you can ask?:

• Any kind of DB/SQL errors.
• Any kind of DB tuning issues, ideas, suggestions, possible solutions et cetera.
• Server files communication and/or general networking.
• Packet related things. Parsing, understanding joymax' (non-existing) logic.
• Basic to advanced PK2 related things. (Keep in mind, I'm not a PK2 person, when i need to do something, i find out how to do it and do it.)
• Advanced certification issues. Multiple divisions using one actual server only etc.
• Exploits & Protection

What you should NOT ask?:

• Server setup related problems.
• Basic problems.
• Things which are answered already.

Now, go ahead and ask. Let's see what you guys can come up with.

C10 Explanation:

 Spoiler

If you're good at what you do, you can join Ela maybe
Disclaimer:
This thread is NOT meant for recruitment. It's explicitly to help out others in need with guides.

@Portal & Callum
Asking why this is here?
The thread will become a collection of guides in the end. I'll be answering questions and posting this in the first post. Thus, it is here. As you know, the "Ask the experts" section is BS. If you really want to help the community, leave this here.

Royalblade* Can u tell me how to can remove captcha from servers and get notice welcome.. exchange delay?... i need this services.. thanx

[WickedNite.]

Originally Posted by MR ! HЄRO

SR_GameServer error

some screen shot




And Shard

I know that 90% of shard cases like that, are because of heavy logs.

[Pure3viL]

Originally Posted by Leonius*

How can i improve my queries performance? xD especially in update,select,insert statements.



There are many possible solutions, i will write some of them below.
1st:-It is probably buffalo cos trade pet, it is bugged in many vsro based servers.
1st fix:-I usually fix it by removing it xD
2nd:- Your grab pets have 5 pages or higher.
2nd fix:- Set them to below 5.
3rd:- Buffalo cos transport bugs a character when this char teleports to alexandria and crashes it, and whenever the char tries to login again your gameserver will crash/ popup a c++ error.
3rd fix(1) :- fix buffalo inventory size, level through _refobjchar and chardata_xxxxx
3rd fix(2)(temporary fix):- remove buffalo

I have had this problem before and i did everything above to get it working, and it worked, yea it did[after fixing the bugged characters]

4th: trade pets lvl 20 (there is a bugg around it witch can crash the gameserver)
fix: change trade pets lvl from 20 to to more
and there is some more i dont remember its an old problem

[Aaron*]

Originally Posted by thebate1

Royalblade* Can u tell me how to can remove captcha from servers and get notice welcome.. exchange delay?... i need this services.. thanx

Can you program in any programming language, e.g(c,c#,c++,python)? If yes then take these things from DetGuard or SROGuard. If not then buy torque/SquirrelProtector

[Nami_]

Can someone help me?

Got a problem with the sr_GameServer..

[blackdiana]

Originally Posted by Exo

1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	1797.000	-70.038	389.999	0	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#1
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	1797.000	-70.038	200.999	0	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#1
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	1797.000	-70.038	60.999	-0.05	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#1

1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	815.000	-70.038	806.000	-0.78	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#2
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	700.000	-70.038	687.000	-0.78	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#2
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	590.000	-70.038	580.000	-0.78	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#2

1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	400.000	-70.038	1789.000	-1.5445	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#3
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	222.000	-70.038	1783.000	-1.5445	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#3
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	52.000	-70.038	1780.000	-1.5445	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#3

sry akasch ;(

thx this info, i need know yet, in which txt file need put this lines?

[caosfox]

if im not wrong (and if i remember right, ofc) is at force_addobject.txt

[Royalblade*]

Originally Posted by blapanda

Question (vSRO 188): Latest added itemshop items do show the silkprice as 0, no matter what. Adding those items, exact the same string (unchanged values ID & Link on ObjCommon, Index on ScrapOfPackageItem, and so on) on a clean server - will result in a flawless display of X Silk, as it should used to be.
No server errors given. Client causes no troubles.
Any clue? Maybe a procedure issue? Or a "cap" of the gameserver/etc.?

99% Sure. You are using the same package already and have added a price of 0. The line is there and is being read FIRST. Then second one is then ignored.

Originally Posted by thebate1

Royalblade* Can u tell me how to can remove captcha from servers and get notice welcome.. exchange delay?... i need this services.. thanx

Buy torque or the squirrelfilter. However, I don't recommend buying from cherno, he sometimes disappears for weeks until he answers again.

All of those things need to be done via a packet filter though.

Originally Posted by bissag

What is the reason of this weird error?
Searching for this reference text in ollydbg show nothing.
Fatal [SR_GameServer] [Master:26265-1160.223877--106.069305-960.790466] update ÇÏ´Ù°¡ ¸À°¡¹ö·È¾î!!
Fatal [SR_GameServer] [Master:26265-1160.223877--106.069305-960.790466] update ÇÏ´Ù°¡ ¸À°¡¹ö·È¾î!!
It looks like it fails to update/sync the char movement or something like that.
It will spam this error like 20 times in 1 second then the game server crash instantly after this error. This error happens randomly could be after 1 day or 1 week.

1.
This would require quite some work to backtrack the actual problem. Try installing a korean language pack on your server first so that you'll be able to "read" the korean error message properly. Just translate it with google translator and see what it comes up with. it should be givnig you a good hint.

2. (dungeon == instance, i.e. FGW, Medusa place, jobcave...)
Also convert those positions to a warps statement and warp there. See if that area is a dungeon. If it IS a dungeon, then you have problem somewhere. However, find out what position it is first, if it truly is a dungeon, I can help you fix it up. They are fairly easy to do.

3. Get a new clean data folder on the server. Just to be sure.

Originally Posted by Nami_

Can someone help me?

Got a problem with the sr_GameServer..

This is normal, it can be safely ignored

Originally Posted by blackdiana

thx this info, i need know yet, in which txt file need put this lines?

media serverdep silkroad textdata forceaddobj

Requirement: Bandit fortress must be available in the client. (You should have it by default. But telling you, just so you can be sure)

[bissag]

Originally Posted by Royalblade*

1. This would require quite some work to backtrack the actual problem. Try installing a korean language pack on your server first so that you'll be able to "read" the korean error message properly. Just translate it with google translator and see what it comes up with. it should be givnig you a good hint.

2. (dungeon == instance, i.e. FGW, Medusa place, jobcave...)
Also convert those positions to a warps statement and warp there. See if that area is a dungeon. If it IS a dungeon, then you have problem somewhere. However, find out what position it is first, if it truly is a dungeon, I can help you fix it up. They are fairly easy to do.

3. Get a new clean data folder on the server. Just to be sure.

1. I will try , sometimes it throws this error before showing the korean message
CGObj::GetTID() GetDataPermanent Error
2. It happens in towns.
3. Tried several data and no difference.

[ILowe]

Originally Posted by Exo

1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	1797.000	-70.038	389.999	0	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#1
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	1797.000	-70.038	200.999	0	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#1
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	1797.000	-70.038	60.999	-0.05	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#1

1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	815.000	-70.038	806.000	-0.78	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#2
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	700.000	-70.038	687.000	-0.78	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#2
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	590.000	-70.038	580.000	-0.78	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#2

1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	400.000	-70.038	1789.000	-1.5445	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#3
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	222.000	-70.038	1783.000	-1.5445	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#3
1	res\bldg\arabia\bagh_city\bagh_city_bridge02.bsr	247	124	52.000	-70.038	1780.000	-1.5445	0	3	FORTRESS_BIJEOKDAN	// Garden Bridge#3

sry akasch ;(

Thank you

[Royalblade*]

Originally Posted by bissag

1. I will try , sometimes it throws this error before showing the korean message
CGObj::GetTID() GetDataPermanent Error
2. It happens in towns.
3. Tried several data and no difference.

CGObj::GetTID() => A method call to get something.

TID => TypeID.

TypeID => Triggers or dbo._RefObjCommon.TypeID1 - dbo._RefObjCommon.TypeID4

Unknown item?


Run this query:

SELECT IT.*, R.Codename128 FROM dbo._Items IT
JOIN dbo._RefObjCommon R
ON IT.RefItemID = R.ID
WHERE R.Service = 0

Screenshot the result.

[hancook1st]

how to set reward for Job ?
anyone can help me ?

[Royalblade*]

Originally Posted by hancook1st

how to set reward for Job ?
anyone can help me ?

Create new contribution table for chars Contribution column => BIGINT;

At logout, check how much contribution.
Set a min amount.

UPDATE
SET CONTRIBUTION %= @MinAmountFor1Reward

_ADD_ITEM_EXTERN ...

Pretty simple.