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

    • Logan22
      SphereWeb CMS

      By Logan22 · Posted

      You're talking complete nonsense. The source code of SphereAPI, which handles all requests, is closed and has never been published anywhere.     That return $this doesn't affect anything, PHP just ignores it. Why are you showing it?     Yes, of course I want that, and I’m asking you — go ahead and hack it, I’d even be thankful. The most you can probably do is launch a DDoS attack, but that’s not hacking. The IP you see is just a public one, used by default to handle requests. There are many other IPs involved, which aren’t disclosed for privacy reasons. So, when should I expect your hacker attack? If you fail, it means you talked big for nothing. I hope you're not all talk and can actually back up your words. UPD: To make your task easier, I have disabled limits on incorrect and failed requests, so your site/IP won't get blocked.
    • djvogans
      [L2OFF ]Lineage2DEX.com Spring Season x50

      By djvogans · Posted

      Lineage2Dex Interlude+ x50 Server launches TODAY!       The wait is over – the Lineage2Dex Interlude+ x50 Server launches TODAY! Grand Opening - April 26 at 19:00 (UTC+3) Over 10,000 registered accounts are ready to dive in! Beta with massive activity over, thx all who participate on it! It's time to begin your real Jorney! 👉 Read full roadmap 👉 Full server description 👉 Download and registration The server will be split into 3 stages, each featuring multiple content episodes. Stage 1: April 26 – May 18 Welcome to the Classic Interlude Phase. This stage is built with minimal custom content, focused on delivering that pure Interlude experience. It’s perfect for both new players unfamiliar with our project and veterans who enjoy a traditional start. Expect a smooth and nostalgic journey with familiar mechanics. Stage 2: May 19 – June 22 Time to expand the world! As most Interlude content gets completed, we gradually introduce new elements. Hellbound will open first, followed by weekly content updates. Midway through this stage, the Isle of Prayer will become available — a new zone featuring Dynasty Gear and fresh challenges. Stage 3: From June 23 Welcome to full content access! Some location become to High-level location, offering great reward! Once this phase concludes, a full merge with Union server will take place — and yes, all your characters and items will carry over safely. We wish everyone a smooth start, fair play, and tons of fun on the new x50 server! See you in-game!
    • K9gash
      L2J development services - aCis focused

      By K9gash · Posted

      Hello everyone! I'm offering professional L2J development services, specialized for aCis projects.   🔹 What I offer: Ready-to-implement existing systems (events, features, gameplay improvements). Custom development: I can create new systems based on your specific requests and ideas. Bug fixing, optimization, and enhancement of your server's code. Professional, clean, and organized Java coding. Support after delivery to ensure smooth integration.   🔹 Some examples of available systems: PvP and PvE Mini-Events (fully automated). Custom Raid Boss Events. Advanced Clan Utilities (regroup features, clan ranking, etc). Reward Systems (based on kills, damage, objectives, etc). Achievements Subscription system Arena Fights (1v1 tournament, scratch made). Advanced event engine (12 events, many features). multi-client aCis project, progressive gameplay C4 to C6   🔹 Why work with me? Years of experience working directly with aCis pack. Fast, reliable communication. I care about performance and long-term stability. I can adjust the systems to fit your server's style and balance.   🔹 Pricing: Flexible depending on the complexity (fixed price per project or per system). Discounts for multiple systems or long-term collaboration.   🔹 Contact: MaxCheaters PM Discord: @Luminous   Serious and passionate about your project? Let's make your server unique!
    • Nanju
      Interface Textures [Client 388 - Master Class, PNG Format]

      By Nanju · Posted

      Could you please make a 502 version too?
    • Nightw0lf
      SphereWeb CMS

      By Nightw0lf · Posted

      The hardest part for anyone is to reverse engineer your server but you're handing the code out for free. At that point, there's no real challenge.   you want facts?   public function __construct(?int $userId = null) { if ($userId == null) { return $this; } // you know that constructs does not return values in php?   🤏just 1 file bad code.   you want to be hacked? show your customers websites that run that code 167.235.*.* api.spherewe***** stop writing chatgt, and dont challenge me again i tried to help you, but if you want me i can share everything even guide users how to hack every client you have even your server

  • Topics

×
×
  • Create New...