[Collection][Share]AIO Freya Npc's

asdf0rakos · April 10, 2011

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');

Rzeszut · April 11, 2011

Super npc , thank's for share , nice design npc !!!

`NeverMore · April 11, 2011

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 · April 11, 2011

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.

asdf0rakos · April 13, 2011

any solution to my problem?

i have version 4521

`NeverMore · April 13, 2011

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 · April 13, 2011

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 · April 13, 2011

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 · April 13, 2011

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

`NeverMore · April 24, 2011

__________UPDATE_________

*Added 1 More Npc

Tested and Have Fun...

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

TheVoR · April 25, 2011

very nice and useful

gl ;)

marwan · April 25, 2011

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

`NeverMore · April 25, 2011

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

Gootzy · May 2, 2011

Great share, downloading

marwan · May 2, 2011

you forget to add the download link for the new npc

[Collection][Share]AIO Freya Npc's

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Posts

Topics