Skip to main content

Lineage: Jak snížit počet guardů na castle siege?

Pokud máte na serveru problém s velkým počtem guardů v hradech, které vlastní NPC a nechce se vám je manuálně promazávat, tak tady máte jednoduchý SQL příkaz, který jich pro daný hrad (v tomto případě č.1) polovinu smaže:
UPDATE `castle_siege_guards` SET isHired = 1 WHERE (`castleId` = '1') AND MOD(id,2) = 0;

Labels:

Comments

Post a Comment

Popular posts from this blog

IBUS with CC3D and CleanFlight/BetaFlight - Eachine 250 Racer

I finally managed to get IBUS working on my Eachine 250 Racer (ER250) and here's how! IBUS is digital communication protocol of FlySky/Turnigy controllers. I'm using FlySky FS-i6 with FS-iA6B receiver, but I guess you can use this guide also for SBUS and others. Connecting to CC3D  First, you need to use different connector. If you are currently using PWM or PPM on your receiver, you probably use 8 pin connector. For IBUS you need 4 pin FLEX or MAIN connector. Note: I don't use default ER250 position of CC3D, i rotated it -90°so I can access USB from the side. With ER250 you'll get the all needed cables. I already switched the connector on the receiver side so instead of 4 separate cables I have only 2 (blue is not connected). I'm using MAIN port, as FLEX port is on the side of battery tray in my settup. Black is GND, Red +5V, Yellow RX, Blue TX (not connected)  CleanFlight setup Note :  On older versions of CF/BF there is no...
4 comments
Read more

Betaflight resource remapping with DSHOT

Since Betaflight 3.x.x there is possibility to remap your motor outputs. This allows you to use different pins in case some of them are broken. There are few tutorials on youtube how to remap your outputs, but I found only one, which takes into account DSHOT. Problem with remapping with DSHOT is that, not every flight controller output can be used as a DSHOT output. But how to find which output can be used for DSHOT? First, if you already made some changes to resources in CLI, revert them or re-flash your flight controller. Depending on your board, select the quadcopter type with same amount of motors as yours. I'm using SPRACINGF3EVO which has 8 motor outputs, so I selected "Octo Flat +" Go to the CLI and run command "resource" and then "resource list" Copy and whole output to the notepad You should get something as follows, with importrant parts in BOLD. # resource resource BEEPER 1 C15 resource MOTOR 1 A00 resource MOTOR 2 A01 ...
1 comment
Read more