[GUIDE]Server sided problems? Come & Ask.

Quote:

Originally Posted by MR ! HЄRO SR_GameServer error some screen shot [Only registered and activated users can see links. Click Here To Register...] And Shard [Only registered and activated users can see links. Click Here To Register...]

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

Quote:

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.

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.?

Quote:

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

Quote:

Originally Posted by MR ! HЄRO SR_GameServer error some screen shot [Only registered and activated users can see links. Click Here To Register...] And Shard [Only registered and activated users can see links. Click Here To Register...]

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

Quote:

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

Quote:

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

Can someone help me?

Got a problem with the sr_GameServer..
[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Exo Code: 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?

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

Quote:

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.

Quote:

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.

Quote:

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.

Quote:

Originally Posted by Nami_ Can someone help me? Got a problem with the sr_GameServer.. [Only registered and activated users can see links. Click Here To Register...]

This is normal, it can be safely ignored :)

Quote:

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)

Quote:

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.

Quote:

Originally Posted by Exo Code: 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

Quote:

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.

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

Quote:

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.