[Tool] Query for AIO

mjst · November 18, 2010

.

Edited September 11, 2015 by Majestic12

piotress · November 19, 2010

thanks jokers , hahaha

Daunt · November 21, 2010

Not that useful, require a server restart to take effect.

Anarchy · 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 · December 21, 2010

thanks jokers , hahaha

Syndrome69 · February 26, 2012

thx anarchy ;D

Batman1118 · April 9, 2012

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 · April 9, 2012

bump

niko001 · April 10, 2012

really usefully! thx for share :D

Batman1118 · April 10, 2012

up

Batman1118 · April 10, 2012

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 ?

sticky · April 11, 2012

yes and its easy its called CacheD

Batman1118 · April 11, 2012

yes and its easy its called CacheD

can U explain me this thing ?

Batman1118 · April 13, 2012

bump

sublimityL2 · April 19, 2012

awesome

thx

[Tool] Query for AIO

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Posts

Topics