Jump to content

Recommended Posts

Posted

Why are you being so generous? :D

Why not ? Knowledge is free for everyone who want to learn, it did not cost me anything to learn so i will not charge anyone a penny for showing/teaching/helping/supporting.

Posted

Soon some new uploads will be set.

A russian ACP that the project got abandoned. And now some random people are trying to sell it.

Also my own panel with P design (copyrighted)

Keep an eye on this topic as i will share for free more stuff that other people are trying to sell and it is not their work.

Posted

l2revenge was slimshadow howardstern project with titanium armor/ revenge armor/ dynasty armor and weapons (dynastys were named epic) does that reminds u something?

Posted

Pretty sure i played it if i remember right.

If anyone could dig up a feature list/page or something i could sort it out.

With a old patch it would be even easier.

Posted

Soon some new uploads will be set.

A russian ACP that the project got abandoned. And now some random people are trying to sell it.

Also my own panel with P design (copyrighted)

Keep an eye on this topic as i will share for free more stuff that other people are trying to sell and it is not their work.

by chance,you got vanganth IL source for share  ::) ?

Posted

Not fair for those who payed & to see such amazing work available to all "kids"...

Why are you afraid of kids? They couldn't do anything worthy. And if they would, some of them might upload it for free as well. Better have 95% / 5% shitty/worth opened code, then doesn't have it at all, no? 

I've started contributing L2 C1 code, mainly because of L2 community (xeL, smeli, Outlaw who played on my server :D  and other). Would you like to see it closed in private repo and being available for purchase only? 

 

Amazing work should be available for everyone. And only amazing team might create amazing server, all other will create one-week servers, but learn something.

Posted

Not fair for those who payed & to see such amazing work available to all "kids"...

 

That's pretty rich, considering the forum we're on and the origin of the files we're talking about.

Posted

Why are you afraid of kids? They couldn't do anything worthy. And if they would, some of them might upload it for free as well. Better have 95% / 5% shitty/worth opened code, then doesn't have it at all, no? 

I've started contributing L2 C1 code, mainly because of L2 community (xeL, smeli, Outlaw who played on my server :D  and other). Would you like to see it closed in private repo and being available for purchase only? 

 

Amazing work should be available for everyone. And only amazing team might create amazing server, all other will create one-week servers, but learn something.

 

Because people who didn't spend a single penny will get access to such hard worked project. Then we will see tons of new server using those sources from people without knowledge & they will destroy even more the rest of L2 community. And the worst thing is probably that it will be those kids that will put & earn donations.

Those sources are precious and extremely powerful, so yeah it should be purchase only... It's sad that so much guys are now selling it and it should have remain very closed.

Posted

hi,

after long long time and very much trying/testing ive got the server running and can connect.

But when i want to create a Character, i get the message "This Name already exist" and the cachedD write something from Error 42000 lin_GetUserDataByCharId wasnt found.

Can some1 Help plz?

I already tryed to Reinstall / Import SQL files but it doesnt work. And i have to say that i get on some files some errors or warning when i import the sql files.

i also tryed other use with other user rights but same error...

Posted

Without knowing the chronicle, server pack or datapack, I can say it looks like your sql files are missing some parts. You should look for some better sql files.

Posted

hi, its interlude and i also think its the sql. i tryed now .sql files from 2 different server files and also the depmax64 trail sql files didnt work without errors :(

Posted (edited)

ok, i have taken a look into the lin2db.sql and i cant find the command create lin_GetUserDataByCharId ...so i think its simply missing..

can some1 send me working sql files?

 

edit: i saw its in lin2world.sql, but i cant get it running anyway :(

 

edit: here is a error message from lin2world.sql (translated with google :) )

Message 207, level 16, status 1, procedure dp_adena_rank, line 5305
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure dp_GetItemListByAccount, line 5320
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure dp_GetItemListByPledge, line 5331
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure dp_GetItemListByUserID, line 5342
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure give_lotto_price, line 5408
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AdenaChange, line 5907
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AdenaChange, line 5918
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AmountChange, line 5992
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AmountChange, line 5994
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_BetaAddItem, line 6114
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_CopyChar, line 7169
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_CopyChar, line 7168
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_CreateItem, line 7848
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DepositBank, line 9432
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DepositBank, line 9435
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DropItem, line 9597
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DropItem, line 9604
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure Lin_EnchantItem, line 9723
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetItem, line 10802
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetItem, line 10816
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetItemType, line 10906
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetPledgeAdena, line 11573
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12108
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12109
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12110
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12111
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12112
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12113
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12114
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12115
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12116
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12117
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12118
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12119
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12120
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12121
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12122
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_LoadItemByItemId, line 13075
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_LoadItems, line 13120
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_LoadPetItems, line 13474
Invalid column name 'amount'.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPJoinSSQMember'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSSQSealSelection'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSnapSSQData'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSnapSSQJoinData'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSnapTimeAttackRecord'. The module is still created. However, it can only be executed successfully if the object exists.
Message 207, level 16, state 1, procedure LIN_MakeNewBlankItem, line 14005
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewAll, line 18693
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewAll, line 18717
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18768
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18787
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18789
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18801
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_UpdateUserItem, line 19512
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_UpdateWarehouseItem, line 19567
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure STAT_ITEM_ACC, line 19928
Invalid column name 'AMOUNT'.
Edited by Levitate
Guest
This topic is now closed to further replies.



  • Posts

    • Verify if following is supposed to be the way to handle movement npc.getAI().setIntention(CtrlIntention.AI_INTENTION_MOVE_TO, new Location(point.getX(), point.getY(), point.getZ())); For me, it's not enough. And if it's the case, whole AI system is probably buggy.
    • hello, i want to wtt my charracter in l2elmorelab 1x harbor for 1.5kkk adena in l2reborn 10x new. Or if you interested tell me your offer. :)) Clean Mail 30 lvl Cleric Naked   Updated.
    • package ai.npc.NFWalker; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Random; import l2r.gameserver.enums.CtrlIntention; import l2r.gameserver.model.Location; import l2r.gameserver.model.actor.L2Npc; import l2r.gameserver.model.quest.Quest; import l2r.gameserver.network.clientpackets.Say2; import l2r.gameserver.network.serverpackets.NpcSay; public class NFWalkerAI extends Quest { private static final int WALKER_NPC_ID = 20116; private final Map<String, Route> routes = new HashMap<>(); private final Map<Integer, Integer> npcIndexes = new HashMap<>(); private final Map<Integer, Boolean> npcReverse = new HashMap<>(); private final Map<Integer, String> npcCurrentRoute = new HashMap<>(); public NFWalkerAI() { super(-1, NFWalkerAI.class.getSimpleName(), "ai/npc/NFWalker"); loadRoutes(); addSpawnId(WALKER_NPC_ID); } private void loadRoutes() { // Route 1 Data Route route1 = new Route("route1"); route1.addPoint(new RoutePoint(0, 149363, 172341, -941, 0, false, "")); route1.addPoint(new RoutePoint(1, 148568, 172328, -980, 5, true, "Puff")); route1.addPoint(new RoutePoint(2, 148536, 172792, -980, 0, false, "")); // Route 2 Data Route route2 = new Route("route2"); route2.addPoint(new RoutePoint(0, 149363, 172341, -941, 0, false, "")); route2.addPoint(new RoutePoint(1, 150248, 172328, -980, 5, true, "Rise my children! Bring me the servants of the god! Let them be offered to our god Bifrons!")); route2.addPoint(new RoutePoint(2, 150248, 172776, -980, 0, false, "")); // Add routes to the map routes.put("route1", route1); routes.put("route2", route2); } @Override public String onSpawn(L2Npc npc) { if (npc.getId() == WALKER_NPC_ID) { selectInitialRouteForNpc(npc); } return super.onSpawn(npc); } @Override public String onAdvEvent(String event, L2Npc npc, l2r.gameserver.model.actor.instance.L2PcInstance player) { if (event.equalsIgnoreCase("move")) { moveNpc(npc); } else if (event.equalsIgnoreCase("check_reached")) { checkIfReached(npc); } return null; } private void moveNpc(L2Npc npc) { String routeName = npcCurrentRoute.get(npc.getObjectId()); Route route = routes.get(routeName); Integer pointIndex = npcIndexes.get(npc.getObjectId()); if (route != null && pointIndex != null) { RoutePoint point = route.getPoints().get(pointIndex); if (point.isRun()) { npc.setRunning(); } else { npc.setWalking(); } if (!point.getChat().isEmpty()) { npc.broadcastPacket(new NpcSay(npc.getObjectId(), Say2.NPC_ALL, npc.getId(), point.getChat())); } npc.getAI().setIntention(CtrlIntention.AI_INTENTION_MOVE_TO, new Location(point.getX(), point.getY(), point.getZ())); // Log movement intention System.out.println("NPC " + npc.getObjectId() + " moving to " + point.getX() + ", " + point.getY() + ", " + point.getZ()); // Schedule a check to see if the NPC has reached its destination startQuestTimer("check_reached", 1000, npc, null); } } private void checkIfReached(L2Npc npc) { String routeName = npcCurrentRoute.get(npc.getObjectId()); Route route = routes.get(routeName); Integer pointIndex = npcIndexes.get(npc.getObjectId()); if (route != null && pointIndex != null) { RoutePoint point = route.getPoints().get(pointIndex); Location currentLocation = npc.getLocation(); Location targetLocation = new Location(point.getX(), point.getY(), point.getZ()); // Check if the NPC has reached the target location if (currentLocation.equals(targetLocation)) { // Log that the NPC has reached the target System.out.println("NPC " + npc.getObjectId() + " reached target " + targetLocation); // Schedule the next movement startQuestTimer("move", point.getDelay() * 1000, npc, null); if (!npcReverse.get(npc.getObjectId())) { pointIndex++; if (pointIndex >= route.getPoints().size()) { npcReverse.put(npc.getObjectId(), true); pointIndex = route.getPoints().size() - 1; } } else { pointIndex--; if (pointIndex < 0) { npcReverse.put(npc.getObjectId(), false); pointIndex = 0; // Choose a new route after completing the current one in both directions switchRouteForNpc(npc); return; } } npcIndexes.put(npc.getObjectId(), pointIndex); } else { // Check again after 1 second startQuestTimer("check_reached", 1000, npc, null); } } } private void selectInitialRouteForNpc(L2Npc npc) { // Randomly select either route1 or route2 String selectedRouteName = "route" + (new Random().nextInt(2) + 1); npcCurrentRoute.put(npc.getObjectId(), selectedRouteName); npcIndexes.put(npc.getObjectId(), 0); npcReverse.put(npc.getObjectId(), false); startQuestTimer("move", 5000, npc, null); // Log initial route selection System.out.println("NPC " + npc.getObjectId() + " selected initial route " + selectedRouteName); } private void switchRouteForNpc(L2Npc npc) { String currentRoute = npcCurrentRoute.get(npc.getObjectId()); String newRoute = currentRoute.equals("route1") ? "route2" : "route1"; npcCurrentRoute.put(npc.getObjectId(), newRoute); npcIndexes.put(npc.getObjectId(), 0); npcReverse.put(npc.getObjectId(), false); startQuestTimer("move", 5000, npc, null); // Log route switching System.out.println("NPC " + npc.getObjectId() + " switched to route " + newRoute); } private static class Route { private List<RoutePoint> points = new ArrayList<>(); public Route(String name) { } public void addPoint(RoutePoint point) { points.add(point); } public List<RoutePoint> getPoints() { return points; } } private static class RoutePoint { private int id; private int x, y, z, delay; private boolean run; private String chat; public RoutePoint(int id, int x, int y, int z, int delay, boolean run, String chat) { this.id = id; this.x = x; this.y = y; this.z = z; this.delay = delay; this.run = run; this.chat = chat; } public int getId() { return id; } public int getX() { return x; } public int getY() { return y; } public int getZ() { return z; } public int getDelay() { return delay; } public boolean isRun() { return run; } public String getChat() { return chat; } } } I looking for help, with this, the npc not start to move. Im trying to create, an NPC wich have multiple walk routes basic logic is  random pick a route complite the route  like Route 1 start form zero (0 -> 1 -> 2(or more) -> 1 -> 0) When the npc return to 0, the script should pic the other route and start again.  And if there is a message like point 1 here     "route1.addPoint(new RoutePoint(1, 148568, 172328, -980, 5, true, "Puff"));" The npc should display the chat message. Currently my problem is the npc not moving, but if I manage it to start moving its randomly move between the route 1 and 2 set of coordinates. Currently for me its  a nightmare. I hope anyone can help somhow.
    • We are certainly not an ambulance, but we will definitely cure you of blacklists and empty pockets. Live freely with SX! Each of you will receive a trial version of SX to familiarize yourself with the product, all you have to do is post in this thread
  • Topics

×
×
  • Create New...