Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

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

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

Guest
This topic is now closed to further replies.
 Share
Go to topic listing


  • Posts

    • Nighter
      LF Extending GF Vanganth to run modern client

      By Nighter · Posted

      Still looking for adaption on Vanganth GF extender adapted for modern client.
    • Splicho
      SphereWeb CMS

      By Splicho · Posted

      Why the fuck would u implement russian / polak memes into a codebase a customer uses..   Jesus christ grow up
    • SocNet
      ⭐SOCNET BOOST⭐ is a new solution among all SMM panels

      By SocNet · Posted

      ➡ Discount for your purchase: APRIL (10% discount) ➡ Our Online Shop: https://socnet.store  ➡ Our SMM-Boosting Panel: https://socnet.pro  ➡ Telegram Shop Bot: https://socnet.shop  ➡ Telegram Support: https://t.me/solomon_bog  ➡ Telegram Channel: https://t.me/accsforyou_shop  ➡ Discord Support: @AllSocialNetworksShop  ➡ Discord Server: https://discord.gg/y9AStFFsrh  ➡ WhatsApp Support: https://wa.me/79051904467 ➡ WhatsApp Channel: https://whatsapp.com/channel/0029Vau0CMX002TGkD4uHa2n  ➡ Email Support: solomonbog@socnet.store 
    • SocNet
      SOCNET | The Social Media acocunts at low prices!

      By SocNet · Posted

      ➡ Discount for your purchase: APRIL (10% discount) ➡ Our Online Shop: https://socnet.store  ➡ Our SMM-Boosting Panel: https://socnet.pro  ➡ Telegram Shop Bot: https://socnet.shop  ➡ Telegram Support: https://t.me/solomon_bog  ➡ Telegram Channel: https://t.me/accsforyou_shop  ➡ Discord Support: @AllSocialNetworksShop  ➡ Discord Server: https://discord.gg/y9AStFFsrh  ➡ WhatsApp Support: https://wa.me/79051904467 ➡ WhatsApp Channel: https://whatsapp.com/channel/0029Vau0CMX002TGkD4uHa2n  ➡ Email Support: solomonbog@socnet.store 
    • zambog420
      Junior developer, looking to intern on a non-profit project.

      By zambog420 · Posted

      Okay, I understand. First, to get started by contributing to open projects and learning along the way. Then, when you mention starting my own project privately, do you mean taking a free datapack like L2jMobius and trying to make it functional for an online server? Great, thank you very much — all this information is really helpful. I’ve been reaching out to several server admins here in Argentina, but it seems like none of them have the time or interest to take on an intern or assistant. xd   P.S.: Are you the creator of Hopzone? Brings back memories of when I was a kid, downloading servers at the cyber café. For two dollars, I could spend the whole day playing and eating candy like crazy.   Another question: between L2jMobius, L2jServer, and aCis, which one has ALL of its code free? As you probably noticed, I'm using ChatGPT to help me translate things, lol, and it suggested the following: Project Status Open Source Accepts Juniors? Difficulty L2JMobius Very active Semi-closed Partially (with patches) Medium-High L2JServer Active Fully open Yes (directly on GitHub) Medium aCis Semi-active Unofficial Not very clear Low

  • Topics

×
×
  • Create New...