Jump to content


getMaNGOS Staff
  • Content Count

  • Donations

    0.00 GBP 
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MrFreak

  • Rank
    getMaNGOS Staff
  • Birthday 01/01/2010

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Why I ask for one repository is because there is basically no need for two. If someone looks for this project he/she doesn't have to remember two repos and all issues and commits are in one place. Additionally the jar file is enough - no need for the .class files because we got the source code.
  2. I thought about doing this job Corsol but I'm happy to see someone who did this. This gives more users a chance to use mangos! Please put source code and executable in the same repository on GitHub and I may check out the source code in the next days.
  3. OLD dbdocs used by accident and talked with Ants. The script_ids uniqueness refers to the id of each script. This is unique because it is calculated as id + delay which gives you a composite key between them. Delay field is responsible for the sequential execution of them.
  4. Hallo Fraggel, IP/Host und Port stimmen. Geht es mit Benutzername root und keiner Passwort-Eingabe? Allgemein empfehle ich jedem, statt repacks, den Source Code selber zu kompilieren und die Datenbank selber zu importieren. Dann hat man immer die neuste Version, direkt vom Entwicklerteam. Grüße MrFreak
  5. Table dbscripts_on_creature_movement has no unique ids for primary key If you look into table dbscripts_on_creature_movement you will notice a problem with the primary keys. To best honest, there are none. SELECT COUNT(ID) FROM dbscripts_on_creature_movement; tells you that there are 672 IDs found but this query SELECT COUNT(DISTINCT ID) FROM dbscripts_on_creature_movement; tells you that there are just 246 unique IDs so a lot of the primary keys are threefold or even more existing in the table. This could be because the primary key field id isn't set as a primary key too! According to this docs: [url]http://docs.getmangos.com/en/latest/database/world/creature-movement.html[/url] This ids are used for this purpose: [quote]script_id If a script should be executed, this references the “dbscripts_on_creature_movement” table tables unique ID for which the entry is valid. If not, set the value to zero.[/quote] You see that the IDs should be unique but in fact they are far away from this. I'm not sure what Mangos does when it tries to execute one of the ids which exist multiple times.
  6. Those are general/basic rules then. I thought we talk about custom rules to mitigate attacks which aren't filtered by pretty simple basic rules. On the other hand this is a trade off for the general webserver security because you can't disable certain PHP functions to execute commands on the server. Personally I prefer a more hardened webserver than saving a few minutes of work for creating some rules manually.
  7. What you say about loading a bash script is true but it isn't useful in a CMS. I can't determine anything network related with PHP. It can't create automatically rules to ban attacking IPs. The sysadmin has to create the rules him-/herself and so it doesn't help him much if he/she can execute these rules in the CMS, especially if he/she is already logged into the console to watch the network activity. Your plugin idea is great! I will have to check how I can realize it but I will try to realize that for sure! Thanks for your ideas!
  8. That isn't possible. You have to use a firewall for that on the server.
  9. [quote=Xenithar]Wiki page is wrong. Look at the "Nullable" column. Every item is set to "NOT NULL", but they default to NULL. Another problem is that a primary key should NEVER be NULL. Base don these two facts, you would be required to put in a zero for a PK, but you should also remember that a PK should not change once set. Seems like that table is in need of a refit![/quote] If you set NULL as the value for a primary key it will increment the value by 1 based on the previously highest number. You have to enable auto_increment for this. I also noticed that the primary keys are the IDs for the realm so they are multiple times occurring. Problem is that a primary key should be unique but we got a lot of rows with the primary key value 1 so that is invalid. There should be a column called uptimeID or something like that which is the primary key. The reference on selecting or deleting stuff would happen on that uptimeID then and not anymore on the realmid which isn't unique. I'm unsure why the column 'starttime' is a primary key. I don't see any use for that. It should be unique but not a primary key.
  10. change the '0' values to NULL in the database Look at the uptime table in the realmd db: [url]http://getmangos.eu/wiki/Reference%20Information/DB/realm/uptime.md[/url] The default values are '0' and NULL. We should use NULL because it's faster and it doesn't take space - it just exists virtually. If we use '0' it's a char that needs to be stored and it will take away space on the HDD.
  11. use timestamp instead of a string to store a date in the DB For example, look at the uptime table in the realmd db: [url]http://getmangos.eu/wiki/Reference%20Information/DB/realm/uptime.md[/url] [QUOTE] Field 'starttime' The time when the server was started, in Unix time. Field 'startstring' The time when the server started, formated as a readable string. [/QUOTE] Both fields contain the same: a date. But they are stored differently. Every date in the database should be either stored as a string or as a timestamp. It shouldn't be mixed so both exists. I think it is better to use everywhere in the database for a date a timestamp for performance reasons.
  12. A quick node on your fix: You have to remove the `mangos`. of your SQL queries so the changes don't apply to a specific database but to the one which is currently open/selected. This prevents issues for people who have more than one database with different names than 'mangos'.
  13. I really appreciate the feedback! Thanks guys! There has been some cool ideas which I couldn't have thought of myself. Awesome work !
  14. Thanks for your input. Security shouldn't be a problem in the CMS because it is being handled by the framework. Still - I like the plugin bridge idea. I will check it out too.
  15. You are on the right way. Just go on with any idea you might have and I will see if they are possible or not and if they will come soon or in the farer away future.

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions


The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
  • Create New...