Jump to content
MaxCheaters Official Group at Discord
--> Place your ad text here <--
ad: Discord - Global Boosts - 14 server boosts (3 months) for 14$ - 14 server boosts for (1 Month) 6$

[Share][Updated]SQL Manager for Npc!Updated GUI Version!

Stealth

By Stealth
in Server Shares & Files [L2J]

 Share

Recommended Posts

Stealth Newbie

Stealth

Posted
Posted

SQL Manager Updated

Information:

This program creates your sql for your custom npc. Usable on all database types . Quick , Easy and attractive is the aio you have been searching for. Give it a try!

Latest Version

 

SQL Manager v1.4

 

Older Versions

 

SQL Manager v1.0 - Dead

SQL Manager v1.1 - Dead

SQL Manager v1.2

 

 

 

 

Report Bugs

 

sparda-x@hotmail.com

 

 

 

 

Link to comment
Share on other sites
Stealth Newbie

Stealth

Posted
  • Author
Posted

Thank You all , I will update this software with a new version so that it supports L2jFree Database type...

 

First Post updated - Added v1.1 with L2JFree Support and other stuff :D

Link to comment
Share on other sites
zunix Newbie

zunix

Posted
Posted

With this program its faster and easier (if you don't have an sql file to edit)...

 

Open Notepad => save is as xxx.sql?

 

yeah its nice for beginners but better they learn it what it stands for, so they will understand how mysql works.

Link to comment
Share on other sites
Stealth Newbie

Stealth

Posted
  • Author
Posted

@Zunix  I Agree with you , but if someone has no time and wants the job done quickly?( I hope you see what I mean)

 

@Stefoulis15 You are wrong , I Created it and works fine! Maybe there is something wrong with your antivirus...I can send you the source code if you want and it doesn't contain any Trojan (I use the best antivirus Kaspersky 2009 Security Suite)

And It hasn't detected anything...

Link to comment
Share on other sites
Hax0r Newbie

Hax0r

Posted
Posted

Yeh, works fine.Nice job.

sp4rd4, you should add a list of the types of npcs. Like:

echo Type in the type your npc wants to be(eg L2merchant, L2pet, L2Monster...etc[the whole list])

 

You can improve this even more.

Link to comment
Share on other sites
Anghel Newbie

Anghel

Posted
Posted

Nice job mate... also teh scripts are working 100% :) thx

 

btw what does the .exe do???

 

i cant understant... as i saw.. it just CALLs default.bat ... to be used for the script... does it do anything else? xD

 

PS. useless for me..but extremely usefull for new users i can say.. since some get confused in the differences between every packs db...but this helps em out.. ;D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

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

×
 Share
Go to topic listing


  • Posts

    • L2DamageCom
      [L2J] L2DAMAGE

      By L2DamageCom · Posted

      GRAND START TOMORROW !!! OPENING FROM - 1 DECEMBER 2023, FRIDAY, 20:00 +2GMT.
    • SmurfsZone
      SmurfsZone.com | Best LoL Unranked Smurf & Handleveled Accs

      By SmurfsZone · Posted

      This is a bump
    • Noveria
      [L2OFF] Elmorelab x5

      By Noveria · Posted

      A-grade stage   01.12 at 09:00 we will have a long-awaited transition to a new stage.   What awaits you at the A-grade stage: - The maximum level is 75. - New locations: Goddart and Rune territory, TOI 5+, Silent Valley, LOA (66+ mobs), Catacombs - Witch, Dark Omens, Necropolis - Martyrdom, Saint's, Devotion, Captains rift, Commanders Rift, 60+ festival zones, Wall of Argos, ToI 8-14, Silent Valley, Blazing Swamp, Hot Springs, Varka, Ketra, Stakato Nest; - Added new epic raid bosses Zaken, Core, Orfen (will spawn randomly from 17:00 to 21:00 server time); - Recipes / keys / whole items of S grade  are not available (quests for them as well); - The Grand Olympiad will take place at: 12.12, 14.12, 15.12, 17.12, 19.12, 20.12, 21.12; - To participate in Olympiad, a minimum of level 61 is required; - It will be possible to receive rewards for the B-grade stage on 01.12 from 00:00 server time and hero status from 12:00 server time - Stage duration: 21 days
    • Rodolfo01
      WTS Adena L2 EVE interlude x1 25KK in stock

      By Rodolfo01 · Posted

      WTS adena Serious trade 25+ KK in stock 6 USD / KK
    • usedy07
      Help Repeatable Quest Timer

      By usedy07 · Posted

      Hello, I edited a quest for the interlude server. However, I want to add a timer to this quest so that it will be reset every 24 hours or at a certain time of the day. I could not do this because my Java knowledge is not very sufficient. If anyone can help me with this, I would be very happy. Note:I created it by editing the existing kill all sphys task.   ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- # Made by Mr. - Version 0.3 by DrLecter import sys from l2jorion.game.model.quest import State from l2jorion.game.model.quest import QuestState from l2jorion.game.model.quest.jython import QuestJython as JQuest qn = "263_KillAllSylphs1" ORB_OF_WATER = 9998 ORB_OF_FIRE = 9999 ORB_OF_WIND = 10000 ORB_OF_EARTH = 10001 STONE_OF_VALOR = 10002 DROPLIST={ 57000:[ORB_OF_WIND,100], 57001:[ORB_OF_EARTH,100], 57002:[ORB_OF_FIRE,100], 57003:[ORB_OF_WATER,100], } class Quest (JQuest) :  def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)  def onEvent (self,event,st) :     htmltext = event     if event == "70737-03.htm" :       st.set("cond","1")       st.setState(STARTED)       st.playSound("ItemSound.quest_accept")     elif event == "70737-06.htm" :       st.exitQuest(1)       st.playSound("ItemSound.quest_finish")     return htmltext  def onTalk (self,npc,player):    htmltext = "<html><body>You are either not carrying out your quest or don't meet the criteria.</body></html>    st = player.getQuestState(qn)    if not st : return htmltext    npcId = npc.getNpcId()    id = st.getState()    if id == CREATED :      st.set("cond","0")    if st.getInt("cond")==0 :      if player.getLevel()<76 :        htmltext = "70737-01.htm"        st.exitQuest(1)      else :        htmltext = "70737-02.htm"    else :      water = st.getQuestItemsCount(ORB_OF_WATER)      fire = st.getQuestItemsCount(ORB_OF_FIRE)      wind = st.getQuestItemsCount(ORB_OF_WIND)      earth = st.getQuestItemsCount(ORB_OF_EARTH)      if water == fire == wind == earth == 0 :        htmltext = "70737-04.htm"      if npcId == 70737 and st.getQuestItemsCount(ORB_OF_WATER) and st.getQuestItemsCount(ORB_OF_FIRE) and st.getQuestItemsCount(ORB_OF_WIND) and st.getQuestItemsCount(ORB_OF_EARTH) :        htmltext = "70737-05.htm"        st.giveItems(STONE_OF_VALOR,1)        st.takeItems(ORB_OF_WATER,-1)        st.takeItems(ORB_OF_FIRE,-1)        st.takeItems(ORB_OF_WIND,-1)        st.takeItems(ORB_OF_EARTH,-1)    return htmltext  def onKill(self,npc,player,isPet):    st = player.getQuestState(qn)    if not st : return     if st.getState() != STARTED : return         item,chance=DROPLIST[npc.getNpcId()]    if st.getRandom(100)>1 :      st.giveItems(item,1)      st.playSound("ItemSound.quest_itemget")    return QUEST       = Quest(263,qn,"Kill All Sylphs1") CREATED     = State('Start', QUEST) STARTING    = State('Starting', QUEST) STARTED     = State('Started', QUEST) COMPLETED   = State('Completed', QUEST) QUEST.setInitialState(CREATED) QUEST.addStartNpc(70737) QUEST.addTalkId(70737) QUEST.addKillId(57000) QUEST.addKillId(57001) QUEST.addKillId(57002) QUEST.addKillId(57003) STARTED.addQuestDrop(57002,ORB_OF_FIRE,1) STARTED.addQuestDrop(57003,ORB_OF_WATER,1) STARTED.addQuestDrop(57000,ORB_OF_WIND,1) STARTED.addQuestDrop(57001,ORB_OF_EARTH,1)

  • Topics

×
×
  • Create New...