Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[Collection][Share]AIO Freya Npc's

`NeverMore
 Share

Recommended Posts

asdf0rakos Newbie

asdf0rakos

Posted
Posted

hey nice share! npc's are great but i have a problem when i am trying to execute the sql file:

 

[Err] INSERT INTO `npc` VALUES ('36600', '20845', 'Augument Manager', '1', '[server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
`NeverMore Enthusiast

`NeverMore

Posted
  • Author
Posted

Thanks all of you guys...! Soon UPDATE with more...! ^^ I am working ..!

 

hey nice share! npc's are great but i have a problem when i am trying to execute the sql file:

 

 

I will see what causes this to you...! I will edit later ...! maybe wrong colums but i will check it..!

 

 

Wunderkind Newbie

Wunderkind

Posted
Posted

Just a suggestion, I was crashing when I opened some of the pages due to some seriously long .htm files

 

Where I found :

 

<html>
 <head>
   <title> GM Shop</title>
 </head>
<body>
<center><img src="L2UI_CH3.herotower_deco" width=256 height=32>
<center><br1>
<table cellspacing=-1>
<tr>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
</tr>
</table>
<center><img src="L2UI.SquareWhite" width=200 height=1></center>
<table bgcolor=FF00FF width=204>
<tr>
<td><center><font color="FFFF00">Shop</font></center></td>
</tr>
</table>
<center><img src="L2UI.SquareWhite" width=200 height=1></center>
<table cellspacing=-1>
<tr>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
</tr>
</table>

 

I replaced it with :

 

<html>
 <head>
   <title>GM Shop</title>
 </head>
<body>
<center><img src="L2UI_CH3.herotower_deco" width=256 height=32>
<br>
<img src="L2UI.SquareWhite" width=200 height=1>
<table bgcolor=FF00FF width=204>
<tr>
<td align=center><font color="FFFF00">Shop</font></td>
</tr>
</table>
<img src="L2UI.SquareWhite" width=200 height=1>
<br>
<br>
<br>

 

It has the same exact appearance but it uses much less space.

`NeverMore Enthusiast

`NeverMore

Posted
  • Author
Posted

Just a suggestion, I was crashing when I opened some of the pages due to some seriously long .htm files

 

Where I found :

 

<html>
  <head>
    <title> GM Shop</title>
  </head>
<body>
<center><img src="L2UI_CH3.herotower_deco" width=256 height=32>
<center><br1>
<table cellspacing=-1>
<tr>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
</tr>
</table>
<center><img src="L2UI.SquareWhite" width=200 height=1></center>
<table bgcolor=FF00FF width=204>
<tr>
<td><center><font color="FFFF00">Shop</font></center></td>
</tr>
</table>
<center><img src="L2UI.SquareWhite" width=200 height=1></center>
<table cellspacing=-1>
<tr>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=32 height=20></td>
<td><img src="L2UI.SquareBlank" width=40 height=20></td>
</tr>
</table>

 

I replaced it with :

 

<html>
  <head>
    <title>GM Shop</title>
  </head>
<body>
<center><img src="L2UI_CH3.herotower_deco" width=256 height=32>
<br>
<img src="L2UI.SquareWhite" width=200 height=1>
<table bgcolor=FF00FF width=204>
<tr>
<td align=center><font color="FFFF00">Shop</font></td>
</tr>
</table>
<img src="L2UI.SquareWhite" width=200 height=1>
<br>
<br>
<br>

 

It has the same exact appearance but it uses much less space.

 

Thanks Btw Man...! ;)

 

 

any solution to my problem?

i have version 4521

 

Ok i am checking right now ... w8 ... ! I will edit in some minutes ^^

 

 

 

EDIT:    Test this man http://www.4shared.com/document/fSecsAsC/npcs_sql.html

 

asdf0rakos Newbie

asdf0rakos

Posted
Posted

1st of all, i would like to say a big THANK YOU ! You deserve it cuz you replied so early :)

 

2nd, i am sorry i have to say this but it's not working :(

 

[Err] 1264 - Out of range value for column 'mp' at row 3

[Err] INSERT INTO `npc` VALUES

('36600', '20845', 'Augument Manager', '1', '[server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'),

('36601', '13087', 'PvP-Pk Manager', '1', '[server Name]', '1', 'LineageMonster4.Divine_Rogue', '8.00', '30.00', '80', 'male', 'L2Npc', '40', '523.000000000000000', '87238.000000000000000', '378378.000000000000000', '378.000000000000000', '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'),

('36602', '25542', 'Pk Protector', '1', '[server Name]', '1', 'LineageNPC.a_guard_MHuman', '8.00', '30.00', '85', 'male', 'L2Guard', '1500', '500000000.000000000000000', '50000000000.000000000000000', '5000000000.000000000000000', '50000000000.000000000000000', '40', '40', '40', '40', '40', '40', '0', '0', '9999999.00000', '9999999.00000', '9999999.00000', '9999999.00000', '1200', '2', '2000', '333', '0', '0', '0', '60.00000', '220.00000', '1', '1', '0', '0'),

('36603', '25286', 'Gm Shop', '1', '[server Name]', '1', 'LineageMonster4.Divine_Rogue', '8.00', '23.00', '80', 'male', 'L2Merchant', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'),

('36604', '10', 'Gatekeeper', '1', '[server Name]', '1', 'LineageNpc2.br_aga_ball_kick', '8.00', '26.00', '80', 'male', 'L2Teleporter', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'),

('36605', '13116', 'WareHouse Manager', '1', '[server Name]', '1', 'LineageNPC.a_warehouse_keeper_MDwarf', '8.00', '25.00', '80', 'male', 'L2Warehouse', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0'),

('36606', '31651', 'Npc Server Informer', '1', '[server Name]', '1', 'LineageNpcEV.Advance_quarters', '8.00', '23.00', '45', 'male', 'L2Npc', null, null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

`NeverMore Enthusiast

`NeverMore

Posted
  • Author
Posted

1st of all, i would like to say a big THANK YOU ! You deserve it cuz you replied so early :)

 

2nd, i am sorry i have to say this but it's not working :(

 

 

well now i am sure that we have deferent revisios ^^ .... ( that is the main prob ) For me it works perfect ...!

 

 

Check this 1 again http://www.4shared.com/document/Bv04b_pO/npcs_sql_2.html

 

 

If problem remains send me PM so i can Help you Private :p !

asdf0rakos Newbie

asdf0rakos

Posted
Posted

YOU  are awsome!!!!!!!!!!!!!!!!!

+1 karma :D you deserve it again :)

It's working now and i finally can spawn the npc's ingame and they are working properly!

 

100000000 thanks ;)

  • 2 weeks later...
`NeverMore Enthusiast

`NeverMore

Posted
  • Author
Posted

__________UPDATE_________

 

 

 

*Added 1 More Npc

Tested and Have Fun...

 

 

 

More Updates In some Days... (More Npc's Are Coming)

 

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


  • Posts

    • Onroid
      WTB Epics / Gear On L2 Elixir

      By Onroid · Posted

      Buying Epics/ S Gear on Elixir Whisper me
    • leehyungsoo
      Hello everyone,

      By leehyungsoo · Posted

      Hello everyone, I am looking to purchase a Premium Lineage 2 High Five server pack. My main requirements are: Stability & Quality (Most Important): The pack must be highly stable with no system errors or major bugs. Custom Features: It must include ready-to-use custom features such as a fully functional Community Board, custom NPC Buffers, and Custom Item Sellers (GM Shops), etc. Complete Files: It is absolutely necessary that the full source code (src) and complete Geodata are included. If you are selling a pack that meets these criteria, please send me a PM or leave a reply with the following information: Brief details and key features of the pack Price Test server availability (I would like to test it before buying) Thank you!
    • vasilachykikol
      L2jmobiusDevClon

      By vasilachykikol · Posted

      L2jmobiusDevClon — Classic Interlude p110 Emulator L2jmobiusDevClon is actively developing a Lineage 2 Classic Interlude p110 emulator. Development is done in free time with a strong focus on: • Stability • Authentic Classic mechanics • Clean and optimized architecture The project is based on the L2jMobius source and is continuously evolving and improving. System Requirements: • Java 25 • MariaDB 12.0 • Client p110 Current Revision: 3.0 Development Status: Active Distribution: Free Official Website: https://www.l2jmobiusdevclon.pp.ua Discord Server: https://discord.gg/23a9S8g4Bn Contact: Telegram — @L2jmobiusDevClon Also available via private messages Project Goals: ✔ Improved stability ✔ Maximum Classic accuracy ✔ Core optimization We are currently looking for: • Testers • Server administrators Suggestions, bug reports, and ideas are always welcome. Contact us via: ✔ Discord ✔ Telegram ✔ Private Messages
    • puredemonsss
      Lineage2 Freya High Five @ Reshade

      By puredemonsss · Posted

      i guess loading only the effects that are needed it will maybe work, like removing from reshade shader folder the ones that are not needed, depends on the pc also i guess, also limithing the game at 30fps can be better maybe
    • L2 TokTil
      Unprotected Interface.u+xdat Soviet Comrade Voices P338

      By L2 TokTil · Posted

      do you have protocol 311?

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..