Jump to content
  • 0

Question

Posted

Hello there fellows members,

 

i am new in l2 gamserver developing, and i am trying to add custom npc's to my server, the thing is that i have the sql file that needs to be imported but it gives me an error as there is no custom npc table in my database. i cant seem to find how can i create on that works with the right values for it to then be able to accept my custom sql file. could someone please assist me? 

 

thanks in advance 

5 answers to this question

Recommended Posts

  • 0
Posted

Most of the times, when it comes to sql side npcs it's better to port them manually. In this occasion where custom_npc table is missing, try executing this in npc.sql instead. Although it would help a lot if you provide more information such as client/pack (consider doing this in any related topic) and a possible stacktrace. 

  • 0
Posted
3 hours ago, immortal12 said:

Hello there fellows members,

 

i am new in l2 gamserver developing, and i am trying to add custom npc's to my server, the thing is that i have the sql file that needs to be imported but it gives me an error as there is no custom npc table in my database. i cant seem to find how can i create on that works with the right values for it to then be able to accept my custom sql file. could someone please assist me? 

 

thanks in advance 

 

No project info, no SQL info, no code info yet you want help.

 

zLpoT1O.gif

  • 0
Posted

gameserver/config/functions/l2jfrozen/~>

 

#  Custom Tables -
# --------------------------
# Enable / Disable custom tables.
# The rest of the custom tables are already activated.

# Custom Spawnlist Table
CustomSpawnlistTable = True <-------------set it True!

# Gm Spawn gets saved on custom_spawnlist Table?
SaveGmSpawnOnCustom = False

# Gm Spawn gets deleted on custom_spawnlist Table?
DeleteGmSpawnOnCustom = False

  • 0
Posted

@Irrelevant he says he get error because he try add automatically sql into database. Why you show him configuration to enable custom NPC ?

 

He need post database info and the SQL he use to 

  • 0
Posted
12 minutes ago, Kara said:

@Irrelevant he says he get error because he try add automatically sql into database. Why you show him configuration to enable custom NPC ?

 

He need post database info and the SQL he use to 

oh i didn't realise what he exactly meant ,hahah i just remember that l2jfrozen have bug with sql /npc table

Guest
This topic is now closed to further replies.
  • Posts

    • Hi everyone, Since I’m no longer interested in L2 servers, if anyone is willing to continue the project, let me know. I’m currently selling the entire project. DM me for more information if you’re genuinely interested. I can offer limited free support for the first couple of months. It is not cheap. The sale includes the domain, the recently fully redesigned website, the updater, the interface, server files with Lucera ext source, and the database (excluding account passwords, emails, and other private information; character data can remain).   Server for test: https://lineage2.gold/download Server Info: https://lineage2.gold/info Over 110 videos YouTube playlist: https://www.youtube.com/watch?v=HO7BZaxUv2U&list=PLD9WZ0Nj-zstZaYeWxAxTKbX7ia2M_DUu&index=113  
    • You invent yourself a life - bad for you, one of the inner core dev, fernandopm, which worked hard over aCis quests from 2011 to 2016 is argentinian. I teached him back in time to work and make proper quests. My dev team comes from 10+ countries and I'm myself french. "Racist/nationalist" card ? Not working bro.   Not sure why I should thank you to send me questions, and regarding bug reports, so far, I got none of yours in either discord, gitlab, or forums. I'm sorry if you feel "ignored", but that's more a psychanalyst you need to speak with if you put emotions towards someones' appreciation over a forum. I never ignore a bug report, and if so (like skills reports), it's because I got a bigger plan (skills refactor, in that case). In any case, I delivered cookies for the bug report/fix, even if it dated of months, with proper credits over changesets. "Victim card" ? Not really working, but ok, maybe you're "emotional".   I barely make money out of aCis, for the spent time - simply selling my services, or even coding/administrating a minecraft/L2J server would make far more money. Breaking intentionally things would be stupid. If you don't understand I'm not the only one working on that pack, I can't help you. Also, the scale of edits is sometimes extreme - AI L2OFF ? 1800 files added. How do you want everything works in a single shot ? "Exploiting noobz for money" card ? Still not working, or I'm a terrible businessman.   Meanwhile - you shadow advertise your project, L2JOne (since 2017 btw) - you should maybe start by the beginning saying you're a competitor and aCis is actually a spike in your foot. That also explains why you act like that. RusAcis got the exact same strategy, speaking bad of me, saying they got unique fixes (you speak about I break things, they break and recode things 4 times sometimes, btw), but successfully reselling latest revision with poorly executed stuff. "aCis is good, Tryskell is ok, but I solve all issues in extreme low time so I can piss over him" card ? Mmmmhhhh.   Our conversation ends here if you want, I don't force ppl to speak with me if they don't want - hopefully, people would understand I'm not the arrogant one and the one who doesn't want to talk, or even collaborate. :). I understand you got your own project and got no will to improve aCis.   NOTE : I'm extremely happy for your call of ExShowServerPrimitive with getValidGeoLocation, extremely impressive. Arrogant, no. Sarcastic ? Maybe.   Good night everyone.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..

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