Life is Feudal Official Forum

[Darkbouzouf]

Hi guys,

I'm trying to create a tournament on the island, with dedicated characters created with same stats.


I created 64 characters, i want to give them all skills lvl 70 and refresh it evry time server restarts so i add this in dump.sql
(the boring number list are the ID of the charac i created)

Spoiler

UPDATE `skills` SET `SkillAmount`= 700000000 WHERE `CharacterID` IN (1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438);

My problem is that when you create a char, skills table don't create all skills but only the first ones like this


so i tried to add this in dump.sql but nothing happened

Spoiler

if(NOT EXISTS (SELECT * FROM `skills` WHERE `CharacterID`= 1368 AND `SkillTypeID`= 3)) then
CALL f_addSkill(1368,3,70000000,1);
end if;

UPDATE `skills` SET `SkillAmount`= 700000000 WHERE `CharacterID` IN (1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438);

1- As you can see, i tried to check if skill exists, and then to create it if it does not.

Probably syntax error somewhere.

2- I like to check and create all skills (more or less 65 as far as i remember) for all my 64 created chars, so if someone can show me how to create a loop
CALL f_addSkill(loop_with_all_char_id,loop_all_skill_id_from1_to65,70000000,1);