Jump to content
  • 0

erwtiseis giat ton santa


Question

Posted

hi paidia 8elo na rotiso kati brika ayto pou i8ela alla to 8ema einai oti einai mono gia l2jfree kai den mporo na to peraso se l2emu pack mporei kapoios na mou pei pos na to peraso einai mono to sql..

 

edo einai to link na to dite kai na mou pei kapoios ama mpore

 

http://www.maxcheaters.com/forum/index.php?topic=42735.msg292376#msg292376

 

kai otan to pernao mou petaei ayto to error

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, l' at line 2

[Err] INSERT INTO npc

  (id, idTemplate, name, serverSideName, title, serverSideTitle, class, collision_radius, collision_height, level, sex, type, attackrange, hp, mp, hpreg, mpreg, str, con, dex, int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, lhand, armor, walkspd, runspd, faction_id, faction_range, isUndead, absorb_level, absorb_type, ss, bss, ss_rate, AI, drop_herbs)

VALUES

  (1, 1, "Thomas D. Turkey", 1, "Misguided Holiday Scrooge", 1, "LineageMonster4.br_crazy_turkey", 15, 100, 99, "male", "L2Npc", 40, 1000, 1000, "3,95", "1,21", 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false");

[Msg] Finished - Unsuccessfully

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

 

6 answers to this question

Recommended Posts

  • 0
Posted

Aytes edw einai oi diorthwseis m

INSERT INTO `npc` VALUES

  (1, 1, "Thomas D. Turkey", 1, "Misguided Holiday Scrooge", 1, "LineageMonster4.br_crazy_turkey", 15, 100, 99, "male", "L2Npc", 40, 1000, 1000, "3,95", "1,21", 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),

  (2, 2, "NoName", 0, "", 0, "LineageNPC.clear_npc", 15, 15, 99, "male", "L2Npc", 40, 1000, 1000, 4, 2, 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),

  (3, 3, "Santa's Helper", 1, "", 0, "LineageNPC.e_smith_master_MDwarf", 15, 18, 78, "male", "L2Npc", 40, 1000, 4000, 4, "1,24", 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),

  (4, 4, "Holiday Santa", 1, "Happy Holidays!", 1, "LineageNPC2.br_xmas08_santa", 15, 18, 78, "male", "L2Npc", 40, 1000, 4000, 3, 2, 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),

  (5, 5, "Holiday Santa", 1, "Happy Holidays!", 1, "LineageNPC2.br_xmas08_santa", 15, 18, 78, "male", "L2Npc", 40, 1000, 4000, 3, 2, 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),

  (6, 6, "Holiday Sled", 1, "Happy Holidays!", 1, "LineageNPC2.br_xmas08_sled", 15, 17, 78, "male", "L2Npc", 40, 1000, 4000, 3, 2, 40, 43, 30, 21, 20, 25, 0, 0, 0, 0, 0, 0, 0, 0, 333, 0, 0, 0, 80, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false");

 

tha tis kaneis mesw tis kartelas queries sto navicat copy+paste k run

  • 0
Posted

to perasa alla pali to idio.. kai opos to  les to kano alla den  kanei  kan spawn.. kai den 3ero ti allo na kano re paidia  den den 3erei kaneis allos ti mporo na kano  na ta peraso ston server mou.. plz opoios mporei  na kanei post..ty

  • 0
Posted

Ta eida ta sql gia emu den kanei ...twra gia l2jfree einai mallon tha s po ton logo apla des ayto 'LineageMonster4.br_crazy_turkey'

San npc den yparxei...i monster...twra ean ksereis compile na pareis to teleyteo revesion emu kalos alios ...lypamai.

 

Kai o syngekrimenos p to ekane share edwse mono ta sql??? den to katalaveno...tespa...!!

  • 0
Posted

Geia se olous! Exo l2jumbrella rev.1027 tin faction! otan mpeno in game kai patao "//spawn 50000" i "//spawn 50001" m leei sto game server:NPC id:50000 class not found:null! kai dn to kanis spawn! kserei kanis na m pei ti mporo na kano? stin DB ine os L2FactionManager to allaksa se L2Faction kai pali to idio kani..mporei kapios na me voithisei?sas parakalo

  • 0
Posted

Geia se olous! Exo l2jumbrella rev.1027 tin faction! otan mpeno in game kai patao "//spawn 50000" i "//spawn 50001" m leei sto game server:NPC id:50000 class not found:null! kai dn to kanis spawn! kserei kanis na m pei ti mporo na kano? stin DB ine os L2FactionManager to allaksa se L2Faction kai pali to idio kani..mporei kapios na me voithisei?sas parakalo

 

min asxolise me l2jumbrella

min asxolise me l2emu

 

exoun pethani san project!

  • 0
Posted

min asxolise me l2emu

 

exoun pethani san project!

syggnwmh???h emu pethane san project?tha diafwnisw katheta mazi s.....aplws kaneis dn kserei pws h emu einai i pio clean apo bug dev team....gt apla exei atoma p exoun gnwseis k asxolounte...dn kserw esy g pia ekdosh emu m milas...alla xeiroterh apo umbrella k l2jfree dn einai////syggnwmh g to offtopic

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



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