Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord

aCis - another CRAPPY interlude server

Tryskell

By Tryskell
in Server Shares & Files [L2J]

 Share

Recommended Posts

Tryskell Rising Star

Tryskell

Posted
  • Author
Posted

Vhalior evil noob don't hunt posts on my topic :D (that decreases my own post count).

 

Changeset 201

 

Doormen, misc

 

Doormen

- castle doormen are now retail-like (possibility to teleport in and out, drop of "open/close all doors" function).

- addition of 56 teleports location.

- unhardcode all CHDoormen HTMs.

- addition of many missing Doormen (Siegable CHs ones, 2 at Frontier Border) and fix some templates (Doormen of Hell were bugged as hell).

- drop of all useless HTMs.

 

Misc

- GmListTable is moved on datatable section.

- 2 spawns of Squashs have been dropped (in 4s...) Ty Vonak.

- TaskPriority is dropped (useless crap).

 

This commit doesn't fix yet CH doors issue.

Link to comment
Share on other sites
dpbBryan Newbie

dpbBryan

Posted
Posted

I can't help but notice the IRC channel is empty :C

 

Also, I switched from the l2j nightlies to this svn, however I noticed when trying to manually edit sql data:

CREATE TABLE `spawnlist` (
  `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `locx` mediumint(6) NOT NULL DEFAULT '0',
  `locy` mediumint(6) NOT NULL DEFAULT '0',
  `locz` mediumint(6) NOT NULL DEFAULT '0',
  `heading` mediumint(6) NOT NULL DEFAULT '0',
  `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',
  `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'
);

 

The spawnlist table has no key fields. Is this intentional or was it something that was over-looked:

7wTJz.jpg

 

Link to comment
Share on other sites
Tryskell Rising Star

Tryskell

Posted
  • Author
Posted

IRC has been deserted since a long time (months ago). Basically it has never been populated, to be honest, lol. 3 max isn't a * real* success, but an honorable fail :P.

 

Spawnlist doesn't have primary key from basic. So far, I think it's a generic L2J mark (correct me if I'm wrong), from IL (and surely before) to current times. You have to add one column only for that if you really need.

Link to comment
Share on other sites
dpbBryan Newbie

dpbBryan

Posted
Posted

IRC has been deserted since a long time (months ago). Basically it has never been populated, to be honest, lol. 3 max isn't a * real* success, but an honorable fail :P.

 

Spawnlist doesn't have primary key from basic. So far, I think it's a generic L2J mark (correct me if I'm wrong), from IL (and surely before) to current times. You have to add one column only for that if you really need.

 

I guess it's not actually needed, though I know it can really hurt the performance in some cases:

 

"1) Since you are not using an explicit primary key, the mysqld node will end up randomly connecting to whatever ndbd node it happens to choose, from which the transaction is re-routed to the right data nodes. This unnecessary adds (doubles!) network latency.

 

2) When inserting, fetching the unique autoincrement value acts like a global lock for all inserts. You can parallelize all you want, but it doesn't get any faster. (There is ndb_autoincrement_prefetch_sz to prefetch a number of keys in a batch, but still, always always use primary key.)"

 

Though since it's only a fetch during the load of the server, I guess it's not a big deal.

Link to comment
Share on other sites
Tryskell Rising Star

Tryskell

Posted
  • Author
Posted

You're right, that's only during server loading. And you can find on inet 100+ tips about how to make mySQL faster :P. That's a project itself...

Link to comment
Share on other sites
Tryskell Rising Star

Tryskell

Posted
  • Author
Posted

non?

or all, depends of PoV. Project is project, there isn't "stable" version. We move on, each commit corrects bugs. If you miss 10 revisions, you got between 20 and 40 bugs and/or less content for sure compared to latest version (average quests commited per commit is 3, you calculate).

 

Use latest revision each time. The only bug I introduced those days are CH doors. Previous bug was inventory refactor, 3 months ago and knownlist refactor, 5-6 months ago.

Link to comment
Share on other sites
gRfd` Newbie

gRfd`

Posted
Posted

or all, depends of PoV. Project is project, there isn't "stable" version. We move on, each commit corrects bugs. If you miss 10 revisions, you got between 20 and 40 bugs and/or less content for sure compared to latest version (average quests commited per commit is 3, you calculate).

 

Use latest revision each time. The only bug I introduced those days are CH doors. Previous bug was inventory refactor, 3 months ago and knownlist refactor, 5-6 months ago.

Ok, thanks.

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.

×
 Share
Go to topic listing


  • Posts

    • mecknoz
      [L2J] L2Custom

      By mecknoz · Posted

      GOSTEI MUITO DO VIASUAL DO SERVE COMO POSSO ADQUIRI ESSA REV PACK   
    • tynotgamer
      WIP Free Assasins Interface for Interlude

      By tynotgamer · Posted

      no free? i cant see link :(
    • Guarder
      Loginserver terminated abnormally!

      By Guarder · Posted

      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    
    • Morrison2102
      Morison Store Cheap Torrent Trackers/NZB Indexers

      By Morrison2102 · Posted

      bump
    • Banshee Garnet
      [Report] Celsas, Interface (Re)-Seller

      By Banshee Garnet · Posted

      or at least to tell you an update that sorry but still not at home.. 10 days is suspisious.. but he is long time offline from discord indeed... maybe something happened?

  • Topics

×
×
  • Create New...