mjst Posted November 18, 2010 Posted November 18, 2010 (edited) . Edited September 11, 2015 by Majestic12
Daunt Posted November 21, 2010 Posted November 21, 2010 Not that useful, require a server restart to take effect.
Anarchy Posted November 22, 2010 Posted November 22, 2010 People with basic knowledge of the inner workings of l2off seem to be a dying breed these days... There was a time when what I'm posting was common knowledge... ohwell... <?php // Configuration variables $CONFIG['dbaddr'] = 'localhost'; $CONFIG['dbuser'] = 'sa'; $CONFIG['dbpass'] = 'pass'; $CONFIG['worlddb'] = 'lin2world'; $CONFIG['aio_prefix'] = '[AIO]'; $CONFIG['aio_class'] = 98; $CONFIG['cached_ip'] = '127.0.0.1'; $CONFIG['cached_port'] = '2012'; $CONFIG['admin_name'] = 'aio_maker'; // function used for CacheD strings function tounicode($string) { $rs = ""; for($i = 0; $i < strlen($string); $i++) $rs .= $string[$i].chr(0); return($rs.chr(0).chr(0)); } // function to send CacheD data function CacheDSend($data) { $fp=fsockopen($CONFIG['cached_ip'], $CONFIG['cached_port'], $errno, $errstr, 1); if (!$fp) { echo "Error connecting to CacheD socket."; } else { fwrite($fp, pack("s", (strlen($data)+2)).$data); fclose($fp); } } if (!isset($_POST['char_name'])) { echo "<html> <head> <title>AIO Maker ~ Anarchy</title> </head> <body><center> <form action=\"aio.php\" method=POST> <table border=1> <tr> <td align=right>Char Name -> </td> <td><input type=text name=char_name></td> </tr> <tr> <td COLSPAN=2 align=center><input type=submit value=\"Make AIO\"></td> </tr> </table> </form> </center></body> </html>"; } else { $char_name = str_replace(array("'", ",", ";", "--"), "", $_POST['char_name']); // anti-injection $sql = mssql_connect($CONFIG['dbaddr'], $CONFIG['dbuser'], $CONFIG['dbpass']); mssql_select_db($CONFIG['worlddb'], $sql); $result = mssql_query("SELECT TOP 1 * FROM user_data with (nolock) WHERE char_name = '$char_name'", $sql); if (mssql_num_rows($result) != 0) { $row = mssql_fetch_assoc($result); $char_id = $row['char_id']; // kick character from game CacheDSend(pack("cV", 5, $char_id).tounicode($CONFIG['admin_name'])); // Change character name CacheDSend(pack("cV", 4, $char_id).tounicode($CONFIG['aio_prefix'].$row['char_name']).tounicode($CONFIG['admin_name'])); // Set level CacheDSend(pack("cVVVVVVV", 15, $char_id, 0, 2099325834, 0, 0, 0, 0).tounicode($CONFIG['admin_name'])); // Change character class CacheDSend(pack("cVVVVVVV", 16, $char_id, $row['gender'], $row['race'], $CONFIG['aio_class'], $row['face_index'], $row['hair_shape_index'], $row['hair_color_index']).tounicode($CONFIG['admin_name'])); // Reset skills $result = mssql_query("SELECT * FROM user_skill with (nolock) WHERE char_id = $char_id", $sql); while ($skill_row = mssql_fetch_assoc($result)) { CacheDSend(pack("cVV", 7, $char_id, $skill_row['skill_id']).tounicode($CONFIG['admin_name'])); } // Set skills CacheDSend(pack("cVVV", 6, $char_id, 1085, 3).tounicode($CONFIG['admin_name'])); // Acumen CacheDSend(pack("cVVV", 6, $char_id, 1304, 3).tounicode($CONFIG['admin_name'])); // Advanced Block CacheDSend(pack("cVVV", 6, $char_id, 1087, 3).tounicode($CONFIG['admin_name'])); // Agility CacheDSend(pack("cVVV", 6, $char_id, 1354, 1).tounicode($CONFIG['admin_name'])); // Arcana Protection CacheDSend(pack("cVVV", 6, $char_id, 1062, 2).tounicode($CONFIG['admin_name'])); // Berserker Spirit CacheDSend(pack("cVVV", 6, $char_id, 1005, 3).tounicode($CONFIG['admin_name'])); // Blessings of Pa'agrio CacheDSend(pack("cVVV", 6, $char_id, 1243, 6).tounicode($CONFIG['admin_name'])); // Bless Shield CacheDSend(pack("cVVV", 6, $char_id, 1045, 6).tounicode($CONFIG['admin_name'])); // Bless the Body CacheDSend(pack("cVVV", 6, $char_id, 1048, 6).tounicode($CONFIG['admin_name'])); // Bless the Soul CacheDSend(pack("cVVV", 6, $char_id, 1311, 6).tounicode($CONFIG['admin_name'])); // Body of Avatar CacheDSend(pack("cVVV", 6, $char_id, 168, 3).tounicode($CONFIG['admin_name'])); // Boost Attack Speed CacheDSend(pack("cVVV", 6, $char_id, 213, 8).tounicode($CONFIG['admin_name'])); // Boost Mana CacheDSend(pack("cVVV", 6, $char_id, 1007, 3).tounicode($CONFIG['admin_name'])); // Chant of Battle CacheDSend(pack("cVVV", 6, $char_id, 1309, 3).tounicode($CONFIG['admin_name'])); // Chant of Eagle CacheDSend(pack("cVVV", 6, $char_id, 1552, 3).tounicode($CONFIG['admin_name'])); // Chant of Evasion CacheDSend(pack("cVVV", 6, $char_id, 1006, 3).tounicode($CONFIG['admin_name'])); // Chant of Fire CacheDSend(pack("cVVV", 6, $char_id, 1229, 15).tounicode($CONFIG['admin_name'])); // Chant of Life CacheDSend(pack("cVVV", 6, $char_id, 1308, 3).tounicode($CONFIG['admin_name'])); // Chant of Predator CacheDSend(pack("cVVV", 6, $char_id, 1253, 3).tounicode($CONFIG['admin_name'])); // Chant of Rage CacheDSend(pack("cVVV", 6, $char_id, 1284, 3).tounicode($CONFIG['admin_name'])); // Chant of Revenge CacheDSend(pack("cVVV", 6, $char_id, 1009, 3).tounicode($CONFIG['admin_name'])); // Chant of Shielding CacheDSend(pack("cVVV", 6, $char_id, 1310, 4).tounicode($CONFIG['admin_name'])); // Chant of Vampire CacheDSend(pack("cVVV", 6, $char_id, 1363, 1).tounicode($CONFIG['admin_name'])); // Chant of Victory CacheDSend(pack("cVVV", 6, $char_id, 1362, 1).tounicode($CONFIG['admin_name'])); // Chant of Spirit CacheDSend(pack("cVVV", 6, $char_id, 1397, 3).tounicode($CONFIG['admin_name'])); // Clarity CacheDSend(pack("cVVV", 6, $char_id, 1292, 6).tounicode($CONFIG['admin_name'])); // Clear Mind CacheDSend(pack("cVVV", 6, $char_id, 1078, 6).tounicode($CONFIG['admin_name'])); // Concentration CacheDSend(pack("cVVV", 6, $char_id, 307, 1).tounicode($CONFIG['admin_name'])); // Dance of Aqua Guard CacheDSend(pack("cVVV", 6, $char_id, 276, 1).tounicode($CONFIG['admin_name'])); // Dance of Concentration CacheDSend(pack("cVVV", 6, $char_id, 309, 1).tounicode($CONFIG['admin_name'])); // Dance of Earth Guard CacheDSend(pack("cVVV", 6, $char_id, 274, 1).tounicode($CONFIG['admin_name'])); // Dance of Fire CacheDSend(pack("cVVV", 6, $char_id, 275, 1).tounicode($CONFIG['admin_name'])); // Dance of Fury CacheDSend(pack("cVVV", 6, $char_id, 272, 1).tounicode($CONFIG['admin_name'])); // Dance of Inspiration CacheDSend(pack("cVVV", 6, $char_id, 277, 1).tounicode($CONFIG['admin_name'])); // Dance of Light CacheDSend(pack("cVVV", 6, $char_id, 273, 1).tounicode($CONFIG['admin_name'])); // Dance of Mystic CacheDSend(pack("cVVV", 6, $char_id, 311, 1).tounicode($CONFIG['admin_name'])); // Dance of Protection CacheDSend(pack("cVVV", 6, $char_id, 366, 1).tounicode($CONFIG['admin_name'])); // Dance of Shadow CacheDSend(pack("cVVV", 6, $char_id, 365, 1).tounicode($CONFIG['admin_name'])); // Dance of Siren CacheDSend(pack("cVVV", 6, $char_id, 310, 1).tounicode($CONFIG['admin_name'])); // Dance of Vampire CacheDSend(pack("cVVV", 6, $char_id, 271, 1).tounicode($CONFIG['admin_name'])); // Dance of Warrior CacheDSend(pack("cVVV", 6, $char_id, 1242, 3).tounicode($CONFIG['admin_name'])); // Death Whisper CacheDSend(pack("cVVV", 6, $char_id, 1257, 3).tounicode($CONFIG['admin_name'])); // Decrease Weight CacheDSend(pack("cVVV", 6, $char_id, 1353, 3).tounicode($CONFIG['admin_name'])); // Divine Protection CacheDSend(pack("cVVV", 6, $char_id, 1391, 3).tounicode($CONFIG['admin_name'])); // Earth Chant CacheDSend(pack("cVVV", 6, $char_id, 1352, 1).tounicode($CONFIG['admin_name'])); // Elemental Protection CacheDSend(pack("cVVV", 6, $char_id, 229, 7).tounicode($CONFIG['admin_name'])); // Fast Mana Recovery CacheDSend(pack("cVVV", 6, $char_id, 228, 3).tounicode($CONFIG['admin_name'])); // Fast Spell Casting CacheDSend(pack("cVVV", 6, $char_id, 239, 5).tounicode($CONFIG['admin_name'])); // Expertise S CacheDSend(pack("cVVV", 6, $char_id, 1077, 3).tounicode($CONFIG['admin_name'])); // Focus CacheDSend(pack("cVVV", 6, $char_id, 1218, 33).tounicode($CONFIG['admin_name'])); // Greater Battle Heal CacheDSend(pack("cVVV", 6, $char_id, 1059, 3).tounicode($CONFIG['admin_name'])); // Greater Empower CacheDSend(pack("cVVV", 6, $char_id, 1219, 33).tounicode($CONFIG['admin_name'])); // Greater Group Heal CacheDSend(pack("cVVV", 6, $char_id, 1217, 33).tounicode($CONFIG['admin_name'])); // Greater Heal CacheDSend(pack("cVVV", 6, $char_id, 1388, 3).tounicode($CONFIG['admin_name'])); // Greater Might CacheDSend(pack("cVVV", 6, $char_id, 1389, 3).tounicode($CONFIG['admin_name'])); // Greater Shield CacheDSend(pack("cVVV", 6, $char_id, 1240, 3).tounicode($CONFIG['admin_name'])); // Guidance CacheDSend(pack("cVVV", 6, $char_id, 1086, 2).tounicode($CONFIG['admin_name'])); // Haste CacheDSend(pack("cVVV", 6, $char_id, 1374, 1).tounicode($CONFIG['admin_name'])); // Heroic Valor CacheDSend(pack("cVVV", 6, $char_id, 285, 27).tounicode($CONFIG['admin_name'])); // Higher Mana Gain CacheDSend(pack("cVVV", 6, $char_id, 1043, 1).tounicode($CONFIG['admin_name'])); // Holy Weapon CacheDSend(pack("cVVV", 6, $char_id, 1032, 3).tounicode($CONFIG['admin_name'])); // Invigor CacheDSend(pack("cVVV", 6, $char_id, 1073, 2).tounicode($CONFIG['admin_name'])); // Kiss of Eva CacheDSend(pack("cVVV", 6, $char_id, 1036, 2).tounicode($CONFIG['admin_name'])); // Magic Barrier CacheDSend(pack("cVVV", 6, $char_id, 1035, 4).tounicode($CONFIG['admin_name'])); // Mental Shield CacheDSend(pack("cVVV", 6, $char_id, 1068, 3).tounicode($CONFIG['admin_name'])); // Might CacheDSend(pack("cVVV", 6, $char_id, 1003, 3).tounicode($CONFIG['admin_name'])); // Pa'agrian Gift CacheDSend(pack("cVVV", 6, $char_id, 1282, 2).tounicode($CONFIG['admin_name'])); // Pa'agrian Haste CacheDSend(pack("cVVV", 6, $char_id, 21, 3).tounicode($CONFIG['admin_name'])); // Poison Recovery CacheDSend(pack("cVVV", 6, $char_id, 1356, 1).tounicode($CONFIG['admin_name'])); // Prophecy of Fire CacheDSend(pack("cVVV", 6, $char_id, 1355, 1).tounicode($CONFIG['admin_name'])); // Prophecy of Water CacheDSend(pack("cVVV", 6, $char_id, 1357, 33).tounicode($CONFIG['admin_name'])); // Prophecy of Wind CacheDSend(pack("cVVV", 6, $char_id, 1044, 3).tounicode($CONFIG['admin_name'])); // Regeneration CacheDSend(pack("cVVV", 6, $char_id, 1182, 3).tounicode($CONFIG['admin_name'])); // Resist Aqua CacheDSend(pack("cVVV", 6, $char_id, 1191, 3).tounicode($CONFIG['admin_name'])); // Resist Fire CacheDSend(pack("cVVV", 6, $char_id, 1033, 3).tounicode($CONFIG['admin_name'])); // Resist Poison CacheDSend(pack("cVVV", 6, $char_id, 1189, 3).tounicode($CONFIG['admin_name'])); // Resist Wind CacheDSend(pack("cVVV", 6, $char_id, 1259, 4).tounicode($CONFIG['admin_name'])); // Resist Shock CacheDSend(pack("cVVV", 6, $char_id, 1306, 6).tounicode($CONFIG['admin_name'])); // Ritual of Life CacheDSend(pack("cVVV", 6, $char_id, 234, 23).tounicode($CONFIG['admin_name'])); // Robe Mastery CacheDSend(pack("cVVV", 6, $char_id, 1040, 3).tounicode($CONFIG['admin_name'])); // Shield CacheDSend(pack("cVVV", 6, $char_id, 364, 1).tounicode($CONFIG['admin_name'])); // Song of Champion CacheDSend(pack("cVVV", 6, $char_id, 264, 1).tounicode($CONFIG['admin_name'])); // Song of Earth CacheDSend(pack("cVVV", 6, $char_id, 306, 1).tounicode($CONFIG['admin_name'])); // Song of Flame Guard CacheDSend(pack("cVVV", 6, $char_id, 269, 1).tounicode($CONFIG['admin_name'])); // Song of Hunter CacheDSend(pack("cVVV", 6, $char_id, 270, 1).tounicode($CONFIG['admin_name'])); // Song of Invocation CacheDSend(pack("cVVV", 6, $char_id, 265, 1).tounicode($CONFIG['admin_name'])); // Song of Life CacheDSend(pack("cVVV", 6, $char_id, 363, 1).tounicode($CONFIG['admin_name'])); // Song of Meditation CacheDSend(pack("cVVV", 6, $char_id, 349, 1).tounicode($CONFIG['admin_name'])); // Song of Renewal CacheDSend(pack("cVVV", 6, $char_id, 308, 1).tounicode($CONFIG['admin_name'])); // Song of Storm Guard CacheDSend(pack("cVVV", 6, $char_id, 305, 1).tounicode($CONFIG['admin_name'])); // Song of Vengeance CacheDSend(pack("cVVV", 6, $char_id, 304, 1).tounicode($CONFIG['admin_name'])); // Song of Vitality CacheDSend(pack("cVVV", 6, $char_id, 267, 1).tounicode($CONFIG['admin_name'])); // Song of Warding CacheDSend(pack("cVVV", 6, $char_id, 266, 1).tounicode($CONFIG['admin_name'])); // Song of Water CacheDSend(pack("cVVV", 6, $char_id, 268, 1).tounicode($CONFIG['admin_name'])); // Song of Wind CacheDSend(pack("cVVV", 6, $char_id, 1390, 3).tounicode($CONFIG['admin_name'])); // War Chant CacheDSend(pack("cVVV", 6, $char_id, 1303, 2).tounicode($CONFIG['admin_name'])); // Wild Magic CacheDSend(pack("cVVV", 6, $char_id, 1204, 2).tounicode($CONFIG['admin_name'])); // Wind Walk CacheDSend(pack("cVVV", 6, $char_id, 1268, 4).tounicode($CONFIG['admin_name'])); // Vampiric Rage CacheDSend(pack("cVVV", 6, $char_id, 1323, 1).tounicode($CONFIG['admin_name'])); // Blessing Nobless } else { echo "Character '$char_name' does not exist."; } } ?> BTW its POC code only, so I haven't tested it, but it should work... Known issues - CacheDSend function should keep connection open instead of making a new one every time - will spam the CacheD console. If your server doesn't have auto-learn skills enabled then you need to send a SetSkillAll packet after resetting the skills otherwise basic skills like weight-limit will not be set on the AIO.
SoRa Posted December 21, 2010 Posted December 21, 2010 On 11/19/2010 at 2:56 AM, piotress said: thanks jokers , hahaha
Batman1118 Posted April 9, 2012 Posted April 9, 2012 On 11/18/2010 at 6:27 PM, xryskom said: Gredits:to Jokers from 1 forum and me for post :D QUERY AIO -- Create AIO ------------------------------------------------------------------------------------------------------------------------ DECLARE @title VARCHAR(30) SET @title = 'Lineage -leeching-' -- Tittle of AIO DECLARE @accountname VARCHAR(30) SET @accountname = 'root' -- Account of user DECLARE @charname VARCHAR(30) SET @charname = 'jokers' -- Nick of AIO DECLARE @job INT SET @job = 98 -- Hierophant ---------------------------------------------------------------------------------------------------------------------------------------- DECLARE @charid INT SET @charid = (SELECT char_id FROM lin2world.dbo.user_data WHERE char_name = @charname AND account_name = @accountname) -- Config of CHAR ----------------------------------------------------------------------------------------------------------------- UPDATE lin2world.dbo.user_data SET char_name = '['+@prefix+']'+@charname, class= @job, exp = 2099325834, lev = 80, nickname = @title WHERE char_id = @charid DELETE FROM lin2world.dbo.user_skill WHERE char_id = @charid -- Buffs ------------------------------------------------------------------------------------------------------------------------------- INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1085, 3, 0, 0); -- Acumen INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1304, 3, 0, 0); -- Advanced Block INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1087, 3, 0, 0); -- Agility INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1354, 1, 0, 0); -- Arcana Protection INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1062, 2, 0, 0); -- Berserker Spirit INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1005, 3, 0, 0); -- Blessings of Pa'agrio INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1243, 6, 0, 0); -- Bless Shield INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1045, 6, 0, 0); -- Bless the Body INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1048, 6, 0, 0); -- Bless the Soul INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1311, 6, 0, 0); -- Body of Avatar INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 168, 3, 0, 0); -- Boost Attack Speed INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 213, 8, 0, 0); -- Boost Mana INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1007, 3, 0, 0); -- Chant of Battle INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1309, 3, 0, 0); -- Chant of Eagle INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1552, 3, 0, 0); -- Chant of Evasion INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1006, 3, 0, 0); -- Chant of Fire INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1229, 15, 0, 0); -- Chant of Life INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1308, 3, 0, 0); -- Chant of Predator INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1253, 3, 0, 0); -- Chant of Rage INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1284, 3, 0, 0); -- Chant of Revenge INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1009, 3, 0, 0); -- Chant of Shielding INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1310, 4, 0, 0); -- Chant of Vampire INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1363, 1, 0, 0); -- Chant of Victory INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1362, 1, 0, 0); -- Chant of Spirit INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1397, 3, 0, 0); -- Clarity INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1292, 6, 0, 0); -- Clear Mind INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1078, 6, 0, 0); -- Concentration INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 307, 1, 0, 0); -- Dance of Aqua Guard INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 276, 1, 0, 0); -- Dance of Concentration INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 309, 1, 0, 0); -- Dance of Earth Guard INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 274, 1, 0, 0); -- Dance of Fire INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 275, 1, 0, 0); -- Dance of Fury INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 272, 1, 0, 0); -- Dance of Inspiration INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 277, 1, 0, 0); -- Dance of Light INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 273, 1, 0, 0); -- Dance of Mystic INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 311, 1, 0, 0); -- Dance of Protection INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 366, 1, 0, 0); -- Dance of Shadow INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 365, 1, 0, 0); -- Dance of Siren INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 310, 1, 0, 0); -- Dance of Vampire INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 271, 1, 0, 0); -- Dance of Warrior INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1242, 3, 0, 0); -- Death Whisper INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1257, 3, 0, 0); -- Decrease Weight INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1353, 3, 0, 0); -- Divine Protection INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1391, 3, 0, 0); -- Earth Chant INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1352, 1, 0, 0); -- Elemental Protection INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 229, 7, 0, 0); -- Fast Mana Recovery INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 228, 3, 0, 0); -- Fast Spell Casting ,0); INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 239, 5, 0, 0); -- Expertise S INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1077, 3, 0, 0); -- Focus INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1218, 33, 0, 0); -- Greater Battle Heal INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1059, 3, 0, 0); -- Greater Empower INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1219, 33, 0, 0); -- Greater Group Heal INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1217, 33, 0, 0); -- Greater Heal INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1388, 3, 0, 0); -- Greater Might INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1389, 3, 0, 0); -- Greater Shield INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1240, 3, 0, 0); -- Guidance INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1086, 2, 0, 0); -- Haste INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1374, 1, 0, 0); -- Heroic Valor INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 285, 27, 0, 0); -- Higher Mana Gain INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1043, 1, 0, 0); -- Holy Weapon INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1032, 3, 0, 0); -- Invigor INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1073, 2, 0, 0); -- Kiss of Eva INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1036, 2, 0, 0); -- Magic Barrier INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1035, 4, 0, 0); -- Mental Shield INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1068, 3, 0, 0); -- Might INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1003, 3, 0, 0); -- Pa'agrian Gift INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1282, 2, 0, 0); -- Pa'agrian Haste INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 21, 3, 0, 0); -- Poison Recovery INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1356, 1, 0, 0); -- Prophecy of Fire INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1355, 1, 0, 0); -- Prophecy of Water INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1357, 33, 0, 0); -- Prophecy of Wind INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1044, 3, 0, 0); -- Regeneration INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1182, 3, 0, 0); -- Resist Aqua INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1191, 3, 0, 0); -- Resist Fire INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1033, 3, 0, 0); -- Resist Poison INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1189, 3, 0, 0); -- Resist Wind INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1259, 4, 0, 0); -- Resist Shock INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1306, 6, 0, 0); -- Ritual of Life INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 234, 23, 0, 0); -- Robe Mastery INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1040, 3, 0, 0); -- Shield INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 364, 1, 0, 0); -- Song of Champion INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 264, 1, 0, 0); -- Song of Earth INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 306, 1, 0, 0); -- Song of Flame Guard INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 269, 1, 0, 0); -- Song of Hunter INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 270, 1, 0, 0); -- Song of Invocation INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 265, 1, 0, 0); -- Song of Life INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 363, 1, 0, 0); -- Song of Meditation INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 349, 1, 0, 0); -- Song of Renewal INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 308, 1, 0, 0); -- Song of Storm Guard INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 305, 1, 0, 0); -- Song of Vengeance INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 304, 1, 0, 0); -- Song of Vitality INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 267, 1, 0, 0); -- Song of Warding INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 266, 1, 0, 0); -- Song of Water INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 268, 1, 0, 0); -- Song of Wind INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1390, 3, 0, 0); -- War Chant INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1303, 2, 0, 0); -- Wild Magic INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1204, 2, 0, 0); -- Wind Walk INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1268, 4, 0, 0); -- Vampiric Rage INSERT INTO lin2world.dbo.user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id) VALUES (@charid, 1323, 1, 0, 0); -- Blessing Nobless I get this error some know why ? Msg 137, Level 15, State 2, Line 29 Must declare the scalar variable "@prefix". this problem fixed now I have one question how I can do the same way without restart server ... ?
Batman1118 Posted April 10, 2012 Posted April 10, 2012 On 4/10/2012 at 3:42 AM, niko001 said: really usefully! thx for share :D not cause need make a rr and that is not good after waiting 10-15 min for loading npc any another way ?
Batman1118 Posted April 11, 2012 Posted April 11, 2012 On 4/11/2012 at 1:45 PM, sticky said: yes and its easy its called CacheD can U explain me this thing ?
Recommended Posts