[DiscordArchive] anyone done this before?
[DiscordArchive] anyone done this before?
Original source
there are large gaps
rektbyfaith
01-04-2021, 10:40 AM #11Archived author: Chaz • Posted: 2021-01-04T10:40:47.170000+00:00
Original source
there are large gaps
Original source
did someone find a flaw in buy/sell prices and make a script to create items by buying and sold them right away? or sth similar? id check gold raises from your backups when this occured.
rektbyfaith
01-04-2021, 10:41 AM #12Archived author: Honey • Posted: 2021-01-04T10:41:45.613000+00:00
Original source
did someone find a flaw in buy/sell prices and make a script to create items by buying and sold them right away? or sth similar? id check gold raises from your backups when this occured.
Original source
they did ye i fixed that
rektbyfaith
01-04-2021, 10:42 AM #13Archived author: Chaz • Posted: 2021-01-04T10:42:19.187000+00:00
Original source
they did ye i fixed that
Original source
so someone knows how to fix?
rektbyfaith
01-04-2021, 10:43 AM #14Archived author: Chaz • Posted: 2021-01-04T10:43:01.330000+00:00
Original source
so someone knows how to fix?
Original source
well it looks like the server decides what the next item guid should be based on what "SELECT MAX(guid) FROM item_instance" returns on startup, so if you just delete the items that have a very high guid and restart the server the new ones should have lower I guess
rektbyfaith
01-04-2021, 10:51 AM #15Archived author: MaloW • Posted: 2021-01-04T10:51:20.320000+00:00
Original source
well it looks like the server decides what the next item guid should be based on what "SELECT MAX(guid) FROM item_instance" returns on startup, so if you just delete the items that have a very high guid and restart the server the new ones should have lower I guess
Original source
seems incredible that some people managed to buy+sell 1 billion items with a script lol, how long did they do this for haha
rektbyfaith
01-04-2021, 10:51 AM #16Archived author: MaloW • Posted: 2021-01-04T10:51:58.813000+00:00
Original source
seems incredible that some people managed to buy+sell 1 billion items with a script lol, how long did they do this for haha
Original source
actually I think the core should probably have a check that if a player creates more than maybe 1000 items in a minute it gets kicked/tempbanned. On a server that sells an item for 0cp one could set up 100+ characters using a script to buy + delete items to potentially cause the server to reach the 4.3 billion cap on item_instance guid making the server incapable of creating new items. Some sort of item_instance guid cleanup process that modifies guids to reduce them to fill gaps that runs on server startup if the guid is higher than ~3 billion could be useful too I guess
rektbyfaith
01-04-2021, 11:02 AM #17Archived author: MaloW • Posted: 2021-01-04T11:02:44.181000+00:00
Original source
actually I think the core should probably have a check that if a player creates more than maybe 1000 items in a minute it gets kicked/tempbanned. On a server that sells an item for 0cp one could set up 100+ characters using a script to buy + delete items to potentially cause the server to reach the 4.3 billion cap on item_instance guid making the server incapable of creating new items. Some sort of item_instance guid cleanup process that modifies guids to reduce them to fill gaps that runs on server startup if the guid is higher than ~3 billion could be useful too I guess
Original source
if such a check is added, it should also cover characters created/deleted per account and possibly also per IP. that is for the same reason, scripts could potentially do that pretty often and pretty fast.
rektbyfaith
01-04-2021, 11:17 AM #18Archived author: Honey • Posted: 2021-01-04T11:17:44.126000+00:00
Original source
if such a check is added, it should also cover characters created/deleted per account and possibly also per IP. that is for the same reason, scripts could potentially do that pretty often and pretty fast.
Original source
I don't think you could ever get more than 1 character created + deleted per like 2-3 seconds, whereas with items you can probably do 50+ per second, so I don't think it would be a problem for characters. The item_instance guid problem is already pretty unlikely tbh
rektbyfaith
01-04-2021, 11:31 AM #19Archived author: MaloW • Posted: 2021-01-04T11:31:17.851000+00:00
Original source
I don't think you could ever get more than 1 character created + deleted per like 2-3 seconds, whereas with items you can probably do 50+ per second, so I don't think it would be a problem for characters. The item_instance guid problem is already pretty unlikely tbh
Original source
if and how bad the problem is, depends largely on the number of involved accounts. one, or even a handful of accounts cant cause seriuos trouble that way ofc.
but with e.g. discord bots acting as a client and passing warden checks, it doesnt seem too hard do create and delete thousands of toons in parallel ♀️
rektbyfaith
01-04-2021, 11:43 AM #20Archived author: Honey • Posted: 2021-01-04T11:43:35.267000+00:00
Original source
if and how bad the problem is, depends largely on the number of involved accounts. one, or even a handful of accounts cant cause seriuos trouble that way ofc.
but with e.g. discord bots acting as a client and passing warden checks, it doesnt seem too hard do create and delete thousands of toons in parallel ♀️