Jump to content
The Best Lineage 2 Mods – Free & Custom
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

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

 

`NeverMore Enthusiast

`NeverMore

Posted
  • Author
Posted

you forget to add script.cfg for the new npc oO

 

Yes I am Sory U are Right ...! Here U are 

custom/36607_TitlecolorNvM/__init__.py

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


  • Posts

    • CerusL2
      I’m having a problem connecting the website to the server’s

      By CerusL2 · Posted

      What webhosting are you using? You'll need to talk with administrators of the webhosting to open outgoing connections to port 1433, maybe they won't open it for you, instead, you should get a webhosting for mu online since they always have 1433 port open for outgoing connections. Also, make sure you have your 1433 TCP port open for incoming connections, for security, I suggest you exclusively add the cPanel IP Address to connect to your port 1433 in your firewall, so no one else can try to connect to your database. Let me know if you have any questions, happy to help.
    • CerusL2
      Salvation-H5 L2jEternity Files

      By CerusL2 · Posted

      He just doesn't answer, I've tried everything, Telegram, his own forum, everything, I don't know what's his deal, but I've tried for months
    • Celestine
      purchase Premium using USDT

      By Celestine · Posted

      Send direct message to @Maxtor
    • hamoda taha
      Files needed

      By hamoda taha · Posted

      Hello guys , does anyone know what files needed to use those cloaks for H5 client? I’m not using an interface and I don’t want to use one so there are any way to use them without interface? 
    • SwarmHerald
      [L2OFF] L2Swarm

      By SwarmHerald · Posted

      Closed beta testing starts in early October!        We’re looking for the most active and attentive players to help fine-tune the project before launch. This is your chance to be among the first to try out our new features and directly influence how the server develops.   What beta testers will do: — Check the client and core mechanics — Find bugs, errors, and inconsistencies — Evaluate the convenience and practicality of current solutions — Share detailed, constructive suggestions for improvement      Your feedback will be key to making the project balanced and comfortable for everyone.   Requirements: — Willingness to complete specific tasks — Experience playing on Interlude (PTS, clean client) — Experience with the HF client is a plus   Ready to help? The server launch is planned for early December, so now is the perfect time to join the test and make your contribution. To participate, you must send a direct message (DM) to one of the following: - Send a DM to our Telegram channel - Send a DM to our forum moderators: PrintF or EchØ - Send a DM to our Discord server admin @EchØ

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock