[DiscordArchive] this oke?
[DiscordArchive] this oke?
Original source
It is absolutely necessary to have the exact item because let's say I have the vendor I want to have a few items I want to make free
rektbyfaith
03-29-2023, 04:58 PM #11Archived author: Kokiahegyrol • Posted: 2023-03-29T16:58:01.831000+00:00
Original source
It is absolutely necessary to have the exact item because let's say I have the vendor I want to have a few items I want to make free
Original source
if your lucky and there all in a numeric line you can do between x and y
rektbyfaith
03-29-2023, 05:00 PM #12Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-03-29T17:00:09.404000+00:00
Original source
if your lucky and there all in a numeric line you can do between x and y
Original source
or itemid1 or itemid2 ...
rektbyfaith
03-29-2023, 05:00 PM #13Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-03-29T17:00:23.320000+00:00
Original source
or itemid1 or itemid2 ...
Original source
im also sure someone who knows sql better then me will come in with some magic formula that does this in 1 entry
rektbyfaith
03-29-2023, 05:02 PM #14Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-03-29T17:02:25.646000+00:00
Original source
im also sure someone who knows sql better then me will come in with some magic formula that does this in 1 entry
Original source
if its the pvp honor gear you want to drop, and want to hit all of it you could do where extendedcost = {whatever the id of that specific cost is} cause iirc all the pvp gear has the same cost per slot
rektbyfaith
03-29-2023, 05:05 PM #15Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-03-29T17:05:50.467000+00:00
Original source
if its the pvp honor gear you want to drop, and want to hit all of it you could do where extendedcost = {whatever the id of that specific cost is} cause iirc all the pvp gear has the same cost per slot
Original source
like al lweapons are 1500 honor or whatever
rektbyfaith
03-29-2023, 05:05 PM #16Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-03-29T17:05:56.798000+00:00
Original source
like al lweapons are 1500 honor or whatever
Original source
Wait, what? Do they not use a router or anything? That's weird.
rektbyfaith
03-29-2023, 05:06 PM #17Archived author: Revision • Posted: 2023-03-29T17:06:18.152000+00:00
Original source
Wait, what? Do they not use a router or anything? That's weird.
Original source
So if I'm to summarize according to these discussion we've had here regarding how to run server safely my take would be this:
1. Empty the computer from any personal data that you might have there.
2. Make backups of the server databases.
3. Change World server port and Authserver port from the default values to something random as <@234784691608092682> said. This seems to reduce malformed packet messages due to port scanners for some reason?
4. You do not need to use an IP-whitelisting system for 20-30 person server that is constantly on?
These steps should make running a server safe enough? Anything to add or change?
Also if I wanted to keep the IP whitelisting system on, there is no way to avoid having to constantly add new IPs since dynamic IPs are a thing and ISPs change those as they feel like. I tried to make my friend setup no-ip service but UFW complained that the source was bad.
rektbyfaith
03-29-2023, 05:07 PM #18Archived author: Scortas • Posted: 2023-03-29T17:07:16.172000+00:00
Original source
So if I'm to summarize according to these discussion we've had here regarding how to run server safely my take would be this:
1. Empty the computer from any personal data that you might have there.
2. Make backups of the server databases.
3. Change World server port and Authserver port from the default values to something random as <@234784691608092682> said. This seems to reduce malformed packet messages due to port scanners for some reason?
4. You do not need to use an IP-whitelisting system for 20-30 person server that is constantly on?
These steps should make running a server safe enough? Anything to add or change?
Also if I wanted to keep the IP whitelisting system on, there is no way to avoid having to constantly add new IPs since dynamic IPs are a thing and ISPs change those as they feel like. I tried to make my friend setup no-ip service but UFW complained that the source was bad.
Original source
Not like it's hard to automatically ban a mac or IP if hit x number of times - not to mention the person has to have a higher bandwidth than you unless they pay premium to do it.
rektbyfaith
03-29-2023, 05:07 PM #19Archived author: Revision • Posted: 2023-03-29T17:07:19.765000+00:00
Original source
Not like it's hard to automatically ban a mac or IP if hit x number of times - not to mention the person has to have a higher bandwidth than you unless they pay premium to do it.
Original source
3. Change World server port and Authserver port from the default values to something random as <@234784691608092682> - noisiver said. This seems to reduce malformed packet messages due to port scanners for some reason?
No need to do this
rektbyfaith
03-29-2023, 05:07 PM #20Archived author: Foe • Posted: 2023-03-29T17:07:36.965000+00:00
Original source
3. Change World server port and Authserver port from the default values to something random as <@234784691608092682> - noisiver said. This seems to reduce malformed packet messages due to port scanners for some reason?
No need to do this