Jump to content

Recommended Posts

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

 

 

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.

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

 

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

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

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 !

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

__________UPDATE_________

 

 

 

*Added 1 More Npc

Tested and Have Fun...

 

 

 

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

 

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.



  • Posts

    • That domainn tho :_D
    • Perfect way to experience L2 without the brutal official grind. The progression here is so much smoother and faster, you get to the fun PvP and epic raids way quicker. The custom stuff keeps it fresh too. Definitely worth diving into!
    • L2-Getwork server highly customized with high-stats https://l2server.eu/ https://discord.gg/SsVhm7R Rates: L2 High Five fully customized Getwork Style with High Stats and Enchant ExP/Sp: 75x (custom) Drop/Spoil: 1x (custom) Safe: 500 Max: 50 000   Enchant System: Normal Scrolls: 93% - fail - decrease enchant by 20 Blessed Scrolls: 96% - fail - decrease enchant by 10   Armor Max Enchant D-Grade: +1000 Max Enchant C-Grade: +2000 Max Enchant B-Grade: +3000 Max Enchant A-Grade: +4000 Max Enchant S-Grade: +5000   Weapons Max Enchant D-Grade: +5000 Max Enchant C-Grade: +10000 Max Enchant B-Grade: +15000 Max Enchant A-Grade: +20000 Max Enchant S-Grade: +25000 - 50000   Fir Tree Branch (Weapon): +100 into Weapons (max 50 000) Fir Tree Branch (Armor): +15 into Armor (max 5000) Road to Dvc Cloak Enchant: +1 into cloak (max +1000) Masks of Spirit/Demon Horns Enchants: +1 into Masks (max +10) Each accessories has different max enchant and chances Daily Missions (.missions) Collections (ALT + B) Gambling System(.gamble) - each pack cost different amount Gamble Points, different items How to get gambling points? - by killing Raid Bosses/Events or Completing Daily Missions. Clan Bonus VIP Bonuses (maximum level 10) Battlepass (maximum level 100) - by killing monsters Rebirth (starting in Parnassus) Everything in ALT+B Master's Buffs - 100 Small Glass Box (1 buff) Farm Zones: Custom Farm Zones: Ruin of Agony (Exp Zone) Underground Coliseum (Safe Exp Zone) DVC,Brigand,Frost are similiar farm zones with same monsters Dvc Brigand Stronghold Frost Lake Parnassus - TOP ZONE some of our features: .gamble,collections,battlepass,talent tree, rebirth        
    • https://www.mediafire.com/file/l905r1sd84hnovf/FileEdit.rar/file
  • 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