Jump to content
MaxCheaters Official Group at Discord
--> Place your ad text here <--

[Tool] Query for AIO

mjst

By mjst
in Server Shares & Files [L2OFF]

 Share

Recommended Posts

Anarchy Enthusiast

Anarchy

Posted
Posted

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.

Link to comment
Share on other sites
  • 5 weeks later...
  • 1 year later...
  • 1 month later...
Batman1118 Newbie

Batman1118

Posted
Posted

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  ... ?

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing


  • Posts

    • UTCHIHAmkt
      ✨FULL VERIFIED AGED DISCORD ACCOUNTS 2015–2024 Start at 0.4$

      By UTCHIHAmkt · Posted

      DISCORD : utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/hoodservices https://campsite.bio/utchihaamkt  
    • TOPsellers
      Selling announcement of lineage 2 servers

      By TOPsellers · Posted

      😎
    • optimousprime
      trinity files

      By optimousprime · Posted

      bro is any chance some one share compile pack and patch system for that one? is any chance here.... and client
    • layer0.ltd
      Hosting for spoofing, scanning and other solutions.

      By layer0.ltd · Posted

      Hello members of the forum! We offer hosting services for a different range of services: - ip spoofing; - scanning; - phishing; - botnets; - proxy; - gambling; - stealers; - legal adult; Prices: - VPS starting at $24; - Dedicated servers  starting at  $110; Contctats: layer0.ltd@gmail.com Telegram: @layer0_ltd Discord: layer0.ltd#6843 site: layer0.ltd
    • KaiMaster
      CS2 League Cheats • Faceit, Esportal, ESL • Fully Undetected

      By KaiMaster · Posted

      OUR OFFICIAL WEBSITE / FORUM - MILLENNIUM-HOOK.NET CHEAT DESCRIPTION: Our CS2 cheat is a premium cheat which provides a ton of features for legit gamplay. The cheat was created specifically for strong leagues and anti-cheats such as Faceit, 5EWin, Gamersclub, Esportal and many others. This cheat is perfect for players who want a safe undetected and reliable multi-hack while dominating their opponents and winning the game in their own style. To ensure maximum security of our cheat, we use more than 15+ methods of protection (for example, String Encryption, PE Header Erased, Code Mutation and much more that we cannot talk about for security reasons). Settings are directly configurable via a superb looking in-game menu or over our online «Cloud Panel». Our product is constantly receiving updates in collaboration with the our coders community and suggestions by you! SUPPORTED ANTI-CHEATS: (read more on official website) - VAC (Valve Anti-Cheat) - MM (Matchmaking) - FACEIT Server-Side - FACEIT Client - CEVO / Gfinity - EAC (Easy Anti-Cheat) - ESL Wire - 5EWin / 5EPlay - Perfect World - Gamersclub - Esportal - WePlay - ESEA Our CS2 cheat has a limited number of slots to ensure greater product security! (Available slots check on official website) FEATURES: AIMBOT: - Bone Aimbot (Legit aimbot that doesn't use any angle code that other competitors use. It aims in a legitimate fashion) - Bone and Multibone (Adjust which bone to aim at or select as many Bones as you want) - Smoothaim (Adjust how smooth the aimbot is in its human-like drag) - CloseAim (Toggle distance based aiming algorithm, for increased stickyness, or whoever is closest to the crosshair) - FoV (Adjust the Field of View of the aimbot or percentage of the screen that the aimbot will target enemies from) - Aimkey (Adjust which key the aimbot will use to aim) - AimDraw (Toggle the drawing of the aimspot on enemies (Visible/Always) - VisibleCheck (Visible checking on enemies with close enemy) - NoHop (Aim at One Target per press of the AimKey (Aimbot Doesn't Hop to Other Targets even after death) - RandomSpot (Randomizes the Spot around the target bones, making your aim look more humanized and legit) - Aimtime (Amount of time that the aimbot and Aimbot-RCS is active for, after you press the aimkey) - Ammo Management (Disable aimbot and TriggerBot when the gun clip is empty) - CloseFoV (Different FoV for players with in a certain distance (CloseFOV Distance) - AimOnShoot (Aim when shooting, aim when not shooting) - RecoilAfter (Start recoil after x bullets (Good for 1-2 Taps) - Recoil (Adjust the recoil counter while using the aimbot) - RecoilKey (Adjust which key the anti-recoil is set on (For all Aimbot Keys) - RecoilType (Control if recoil control is always on or only when using the Aimbot) - RecoilFOV (Adjust how long the Recoil will stay stuck to the target, very usable for when playing at a LAN) TRIGGERBOT: - TriggerBot (Automatically shoot at an enemy in a radius (usable with or without Aimbot) - TriggerKey (Control what key activates the TriggerBot (use with any key) - TriggerFov (Control the radius around the AimSpot which activates the TriggerBot) - TriggerDraw (Draw the bone spot that the TriggerBot is aiming at) - TriggerBone (Select the bone that the TriggerBot will target) - TriggerDelay (To add to the legitimacy of the TriggerBot, delays shooting for up to 0.5 seconds) - MonsterTrigger (Extremely Fast & Accurate TriggerBot with Fullbody Options Perfect TriggerBot) - VisCheck (Make sure you're only hitting enemies that you can see, or turn it off to get some sick wallbangs) - Random Delay (A random delay for your trigger bot to look even more legitimate) - Trigger Button (Use any button you like to control the triggerbot) ESP: - Name (Name of the player) - Health (Shows the current health of a player) - Armor (Shows the current amount of armor a player has) - ArmorType (Show if a player currently has a Kevlar vest, a helmet or both equipped) - Weapon (See what weapon a player is currently holding) - Weapon Ammo (See how much ammo you have left in the current clip) - Index (The internal index of the player based on the CSGO engine) - Distance (The distance of each player from you) - Box (A box around each players model, adjusting with distance (new rectangle box type) - Sequence (What action or stance the player is in (Running, Ducking, Jumping, Scoped etc) - Box Size & Box Multi (The size of the boxes around the players, adjustable to how you like) - Team ESP (Toggle ESP on your teammates) - Clean Draw ESP (Move ESP away from box) - Pixel ESP (Single Pixel ESP for legitimate play, shows one single pixel on the screen so it's not noticeable to any casual observers) - Visible ESP (Different color ESP for visible & non-visible players) - Entity ESP (See weapons, defusers, Bomb Location, and defusing players) - Entity Distance (Adjust how far away you will see different Entities for the ultimate in Player-Location assistance) - List ESP (The Ultimate Legit ESP, Listing Players that are not on your screen, or players anywhere in case you don't want to know where they are exactly) MISC: - Bunny Hop (Jumps automatically while the chosen key is being held) - Crosshair (When enabled it will draw a cross-hair on your screen, perfect for snipers, it also features an adjustable size) - Weapon Config System (Weapon configurations for each weapon group (pistols, deagle, snipers, SMG, Knife, rifles, etc) - Flash reduction (Make sure you can see enemies while you're supposed to be flashed) - Radar In Game (A radar is displayed where you see opponents) REQUIREMENTS: - Included HWID Spoofer: Yes - Stream Bypass: Yes - Supported game modes: Windowed, Borderless - Supported CPU: Intel & AMD - Supported OS: Windows 10 (1903,1909,2004,20H2,21H1, 22H2), Windows 11 (All version). Supported OS change and are added periodically. More check on official website.   IN-GAME SCREENSHOTS:   - Check on the official website.

  • Topics

×
×
  • Create New...