[Release] Bonistufen automatisch ver�ndern beim �ndern der item

Funktion:
Werden die Bonistufen in der item_attr ge�ndert, werden die Boni der Items in der item-Tabelle automatisch an die neuen Bonistufen angepasst.

Ist z.B. zuerst in lv3 bei MAX_HP 1000 eingetragen und ihr �ndert lv3 auf 800, wird automatisch bei allen Items mit 1000 TP der Wert auf 800 TP ge�ndert.

Einf�gen:
Den nachfolgenden Trigger auf die player Datenbank laden:

Code:

delimiter //
CREATE TRIGGER update_boni
AFTER UPDATE ON item_attr
FOR EACH ROW
BEGIN
	DECLARE applyType INT;
	SET applyType = NEW.apply + 0;
	
	UPDATE item SET
		applyvalue0 = CASE
			WHEN applytype0 = applyType THEN CASE
				WHEN applyvalue0 = OLD.lv1 THEN
					NEW.lv1
				WHEN applyvalue0 = OLD.lv2 THEN
					NEW.lv2
				WHEN applyvalue0 = OLD.lv3 THEN
					NEW.lv3
				WHEN applyvalue0 = OLD.lv4 THEN
					NEW.lv4
				WHEN applyvalue0 = OLD.lv5 THEN
					NEW.lv5
				ELSE
					applyvalue0
				END
			ELSE
				applyvalue0
			END,
		applyvalue1 = CASE
			WHEN applytype1 = applyType THEN CASE
				WHEN applyvalue1 = OLD.lv1 THEN
					NEW.lv1
				WHEN applyvalue1 = OLD.lv2 THEN
					NEW.lv2
				WHEN applyvalue1 = OLD.lv3 THEN
					NEW.lv3
				WHEN applyvalue1 = OLD.lv4 THEN
					NEW.lv4
				WHEN applyvalue1 = OLD.lv5 THEN
					NEW.lv5
				ELSE
					applyvalue1
				END
			ELSE
				applyvalue1
			END,
		applyvalue2 = CASE
			WHEN applytype2 = applyType THEN CASE
				WHEN applyvalue2 = OLD.lv1 THEN
					NEW.lv1
				WHEN applyvalue2 = OLD.lv2 THEN
					NEW.lv2
				WHEN applyvalue2 = OLD.lv3 THEN
					NEW.lv3
				WHEN applyvalue2 = OLD.lv4 THEN
					NEW.lv4
				WHEN applyvalue2 = OLD.lv5 THEN
					NEW.lv5
				ELSE
					applyvalue2
				END
			ELSE
				applyvalue2
			END,
		applyvalue3 = CASE
			WHEN applytype3 = applyType THEN CASE
				WHEN applyvalue3 = OLD.lv1 THEN
					NEW.lv1
				WHEN applyvalue3 = OLD.lv2 THEN
					NEW.lv2
				WHEN applyvalue3 = OLD.lv3 THEN
					NEW.lv3
				WHEN applyvalue3 = OLD.lv4 THEN
					NEW.lv4
				WHEN applyvalue3 = OLD.lv5 THEN
					NEW.lv5
				ELSE
					applyvalue3
				END
			ELSE
				applyvalue3
			END,
		applyvalue4 = CASE
			WHEN applytype4 = applyType THEN CASE
				WHEN applyvalue4 = OLD.lv1 THEN
					NEW.lv1
				WHEN applyvalue4 = OLD.lv2 THEN
					NEW.lv2
				WHEN applyvalue4 = OLD.lv3 THEN
					NEW.lv3
				WHEN applyvalue4 = OLD.lv4 THEN
					NEW.lv4
				WHEN applyvalue4 = OLD.lv5 THEN
					NEW.lv5
				ELSE
					applyvalue4
				END
			ELSE
				applyvalue4
			END;
END;//
delimiter ;

[Release] Bonistufen automatisch ver�ndern beim �ndern der item_attr