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

    • l2naylondev
      L2naylonDev

      By l2naylondev · Posted

      Lineage 2 Interlude Developer – Cliente + Datapack Hola, soy developer especializado en Lineage 2 Interlude con experiencia tanto en cliente como datapack/core. ✔ Desarrollo datapack (Java, scripts, quests, balance PvP/PvE) ✔ Fixes core / geodata / exploits ✔ Sistemas custom (events, Olympiad, instancias, mods PvP) ✔ Cliente: interface mods, system patches, .dat edits, UI personalizada ✔ Optimización y estabilidad de servidor ✔ Trabajo freelance o colaboración fija Si necesitáis soporte dev o mejoras para vuestro servidor Interlude, podéis contactarme por DM. Portfolio y ejemplos disponibles bajo petición.
    • bomarket
      ⭐️BUYING CSGO SKINS⭐️INSTANT CRYPTO / BANK

      By bomarket · Posted

      Bump
    • drakenn
      I need help i pay lucera

      By drakenn · Posted

      pmed
    • NeoPacket0041
      HQ Photoshop | Verify Accs KYC, AML | Antiban 100% | PSD Tem

      By NeoPacket0041 · Posted

      THEY DON’T COME BACK FOR NO REASON. HERE’S WHY Our clients come from different countries and with very different tasks. But the strongest indicator of quality is simple — when a client comes back **for a second time**. This case is exactly that. The client returned with a request for a **German ID**. The requirement was clear: a document **in a male hand**, with a natural live scene and correct geographic context. What we did: ▪ accepted source files and data without unnecessary bureaucracy ▪ selected a **real street**, not a generic background ▪ built a print-ready mockup with correct scene logic ▪ sent it for approval ▪ after confirmation, delivered the **final file for printing** No templates. No “good enough”. Only solutions tailored to a specific task. Result: ▪ mockup approved on the first try ▪ client fully satisfied ▪ stays in touch We work **worldwide** — and that’s exactly why clients return. Contact us › TG: @mustang_service ( https:// t.me/ mustang_service ) › Channel: Mustang Service ( https:// t.me/ +6RAKokIn5ItmYjEx ) *All data is published with the client’s consent.* #redraw #verification #documents #case #ID
    • l2naylondev
      I need help i pay lucera

      By l2naylondev · Posted

      Lineage 2 Interlude Developer – Cliente + Datapack Hola, soy developer especializado en Lineage 2 Interlude con experiencia tanto en cliente como datapack/core. ✔ Desarrollo datapack (Java, scripts, quests, balance PvP/PvE) ✔ Fixes core / geodata / exploits ✔ Sistemas custom (events, Olympiad, instancias, mods PvP) ✔ Cliente: interface mods, system patches, .dat edits, UI personalizada ✔ Optimización y estabilidad de servidor ✔ Trabajo freelance o colaboración fija Si necesitáis soporte dev o mejoras para vuestro servidor Interlude, podéis contactarme por DM. Portfolio y ejemplos disponibles bajo petición.

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