View Full Version : [SOLVED] Arena Season Set by level
02-02-2014, 06:51 AM
hello guys i need help how to make Arena Season Set by level
Arena Season Set 1 = 10 Level
Arena Season Set 2 = 20 Level
Arena Season Set 3 = 30 Level
Arena Season Set 4 = 40 Level
Arena Season Set 5 = 50 Level
Arena Season Set 6 = 60 Level
Arena Season Set 7 = 70 Level
Arena Season Set 8 = 80 Level
please help someone :/ :rain:
02-02-2014, 07:35 AM
So like .. make them require a certain level or something?
02-02-2014, 08:04 AM
yes set it requeires level arena set 1 - 10 level arena set 2 - 20 level
02-02-2014, 09:11 AM
Set the required levels to http://collab.kpsn.org/display/tc/Item+template+tc2#Itemtemplatetc2-RequiredLevel
Unfortunately I dont know a good way to distinct which item belongs to certain set.
02-02-2014, 09:24 AM
yes i know but here is more than 200 item and it's very hard to make :/ do you know some easy method ?
02-02-2014, 11:02 AM
The easiest way to do it would be to separate all the seasons by their title, like savage gladiator, relentless gladiator, etc. Once you have a list of all the season titles, you can use an sql query to update the item level based on the season title :)
02-02-2014, 11:04 AM
UPDATE `Item_template` SET requiredLevel = 10 WHERE `Name` LIKE '%Marshal's Lamellar%';
' < in item name don't working on SQL
02-02-2014, 11:13 AM
LIKE "%Marshal's Lamellar%"
or use ' twice like so: Marshal''s Lamellar
or use escape \'
02-03-2014, 05:33 AM
thanks i hope this will work
Powered by vBulletin® Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.