Jump to content

[Odigos] Pws Na Perasoume Ena .SQL Arxeio Xeirokinita + Eikones


Recommended Posts

Geia se ola ta members tou mxc

eipa na ftiaksw auton ton odigo giati se kapoia Npc pou theloume na perasoume ston server mas sto Execute SQL File mas bgazei Error

auto den simainei omws oti to .SQL arxeio einai gia petama

polu apla to pairname xeirokinita kai tote tha douleuei. Ithela na perasw auto edwpera to NPC NPC

kai epeidi sto execute sql file me ebgale error to perasa xeirokinita kai doulepse (se kapoious mporei na bgazei error se kapoious omws oxi)

kai epeidi mporei na bgazei kai se alous error kai den kseroun pws na to pairasoun xeirokinita eipa na ftiaksw ton odigo

 

as arxisoume lupon

 

anoigoume to navicat meta to localhost meta pame sto l2jdb tables kai meta sto npc

 

2wf21jn.png

 

afou patisoume ekei tha mas anoiksei ena kainourio parathuro katw katw exei ena + Insert record legete

 

sgljwg.png

 

afou patisoume kai sto insert record terma epanw sto parathuro pou exoume anoikto tha mas bgalei mia kainouria sura

 

tha einai etsi

 

2mxn5lg.png

 

afou kanoume ta pragmata pou lew parapanw anoigoume to .SQL arxeio me to notepad

 

2ps0pjd.png

 

afou anoksoume kai to .SQL arxeio tha exoume 2 parathura anoikta to ena to table npc kai to sql anoigmeno me to notepad

ta kanoume opws mas boleuoun stin epeifania ergasias kai arxeizoume na to pairname

 

width=1024 height=347http://i54.tinypic.com/wtxhtj.png[/img]

 

kanoume auto edwpera mexri telos

 

afou teleiwsoume patame to Update record

 

width=1024 height=353http://i54.tinypic.com/152fcxd.png[/img]

 

auto eitan exoume teleiwsei

den einai tpt to duskolo apla kapoia kainouria members mporei na min kseroun isws na tous boeithisw me auton ton odigo

 

xrusimoipoieisa to npc tou BloodDevil

 

o sigkekrimenos odigos den einai mono gia to npc tou BloodDevil einai gia otidipote npc sto opoio mas bgazei Error sto execute sql file

 

credits DragonGr ( me )

 

 

tha ftiaksw kai 1 videaki na balw otan exw xrono

 

 

 

Link to comment
Share on other sites

poly swstos file m :)

sinexise etc gia na kratisoume to forum anoixto kai zwntano :)

episis 8a i8ela na pros8esw oti 8a mporouses na kanes edit to title, kai na valeis kai ton aytomato tropo, select db, right-click, execute batch file.

pali well done k kali sinexeia ;)

Link to comment
Share on other sites

poly swstos file m :)

sinexise etc gia na kratisoume to forum anoixto kai zwntano :)

episis 8a i8ela na pros8esw oti 8a mporouses na kanes edit to title, kai na valeis kai ton aytomato tropo, select db, right-click, execute batch file.

pali well done k kali sinexeia ;)

ama to diabaseis olo tha katalabeis oti se merikous to execute sql file den douleuei se olous

kai bgazei kapoios error

 

thanks pantos

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.
Note: Your post will require moderator approval before it will be visible.

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.



  • Posts

    • MidnightSell team WTB/WTS GOLD TWW EU/US all servers Cataclysm all servers Payment Visa/Master/Btc/Eth/Trc-20/Erc-20 (all payments within 10 min) For all question pls dm Discord https://discord.gg/h8AN57qJjK Or Telegram @MidnightSell
    • GOSTEI MUITO DO VIASUAL DO SERVE COMO POSSO ADQUIRI ESSA REV PACK   
    • Helly everyone . I use L2jmobius interlude , i did everything , installed the db compiled the Build in eclipse Gameserver seems to lead OK , but it fails to connect to loginserver When i click to start the loginserver it says  "Loginserver terminated abnormally" This is wheat gameserver shows me :    [05/10 17:25:12] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:12] LoginServerThread: LoginServer not available, trying to reconnect... [05/10 17:25:17] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:17] LoginServerThread: LoginServer not available, trying to reconnect... [05/10 17:25:22] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:22] LoginServerThread: LoginServer not available, trying to reconnect...   And This is my login config file:   # --------------------------------------------------------------------------- # Login Server Settings # --------------------------------------------------------------------------- # This is the server configuration file. Here you can set up the connection information for your server. # This was written with the assumption that you are behind a router. # Dumbed Down Definitions... # LAN (LOCAL area network) - typically consists of computers connected to the same router as you. # WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet). # x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # --------------------------------------------------------------------------- # Networking # --------------------------------------------------------------------------- # Bind ip of the LoginServer, use 0.0.0.0 to bind on all available IPs # WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u> # WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u> # Default: 0.0.0.0 LoginserverHostname = 0.0.0.0 # Default: 2106 LoginserverPort = 2106 # The address on which login will listen for GameServers, use * to bind on all available IPs # WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u> # WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u> # Default: 127.0.0.1 LoginHostname = 127.0.0.1 # The port on which login will listen for GameServers # Default: 9014 LoginPort = 9014 # --------------------------------------------------------------------------- # Database # --------------------------------------------------------------------------- # Specify the JDBC driver class for your database. # Default: org.mariadb.jdbc.Driver Driver = org.mariadb.jdbc.Driver # Database URL # Default: jdbc:mariadb://localhost/l2jmobiusinterlude?useUnicode=true&characterEncoding=utf-8&useSSL=false&connectTimeout=10000&interactiveClient=true&sessionVariables=wait_timeout=600,interactive_timeout=600&autoReconnect=true URL = jdbc:mariadb://localhost/l2jmobiusinterlude?useUnicode=true&characterEncoding=utf-8&useSSL=false&connectTimeout=10000&interactiveClient=true&sessionVariables=wait_timeout=600,interactive_timeout=600&autoReconnect=true # Database user info. Default is "root" but it's not recommended. Login = root # Database user password, leave empty for no password. Password = root # Maximum number of database connections to maintain in the pool. # Default: 5 MaximumDatabaseConnections = 5 # Determine whether database connections should be tested for availability. # Default: False TestDatabaseConnections = False # --------------------------------------------------------------------------- # Automatic Database Backup Settings # --------------------------------------------------------------------------- # Generate database backups when server restarts or shuts down.  BackupDatabase = False # Path to MySQL bin folder. Only necessary on Windows. MySqlBinLocation = C:/xampp/mysql/bin/ # Path where MySQL backups are stored. BackupPath = ../backup/ # Maximum number of days that backups will be kept. # Old files in backup folder will be deleted. # Set to 0 to disable. BackupDays = 30 # --------------------------------------------------------------------------- # Thread Configuration # --------------------------------------------------------------------------- # Defines the number of threads in the scheduled thread pool. # If set to -1, this will be determined by available processors divided by 2. ScheduledThreadPoolSize = 2 # Defines the number of threads in the instant thread pool. # If set to -1, this will be determined by available processors divided by 2. InstantThreadPoolSize = 2 # --------------------------------------------------------------------------- # Security # --------------------------------------------------------------------------- # How many times you can provide an invalid account/pass before the IP gets banned. # Default: 5 LoginTryBeforeBan = 5 # Time you won't be able to login back again after LoginTryBeforeBan tries to login. # Default: 900 (15 minutes) LoginBlockAfterBan = 900 # If set to True any GameServer can register on your login's free slots # Default: True AcceptNewGameServer = True # Flood Protection. All values are in milliseconds. # Default: True EnableFloodProtection = True # Default: 15 FastConnectionLimit = 15 # Default: 700 NormalConnectionTime = 700 # Default: 350 FastConnectionTime = 350 # Default: 50 MaxConnectionPerIP = 50 # --------------------------------------------------------------------------- # Misc Login Settings # --------------------------------------------------------------------------- # If False, the license (after the login) will not be shown. # Default: True ShowLicence = True # Default: True AutoCreateAccounts = True # Datapack root directory. # Defaults to current directory from which the server is started. DatapackRoot = . # --------------------------------------------------------------------------- # Scheduled Login Restart # --------------------------------------------------------------------------- # Enable disable scheduled login restart. # Default: False LoginRestartSchedule = False # Time in hours. # Default: 24 LoginRestartTime = 24    
  • Topics

×
×
  • Create New...