Jump to content

pollux

Honorable Member
  • Posts

    264
  • Joined

  • Days Won

    23
  • Feedback

    0%

Posts posted by pollux

  1. Try to add some more vegetation. It looks a bit boring.

     

    Examples:

    8f559c2559.jpg

    c65934aa94.jpg

     

    • Love 1
  2. Hello,

    like the old topic ( >here< ) this topic is reserved for SHARES ONLY. If you're searching some specific files use our file request topic >here<.

    Additionally to this you can search for your files in the latest fully unpacked client:

     

    • Metin2 Dev 21
    • Eyes 1
    • Sad 1
    • Think 1
    • Lmao 1
    • Good 9
    • Love 6
    • Love 69
  3. Hi,

    i have a problem with a query...

     

    This is my working query:

    SELECT l.id AS id, l.login_time AS login, l.logout_time AS logout, p.name AS name 
    	FROM log.loginlog2 AS l 
    	LEFT JOIN player.player AS p ON (p.id = l.pid) 
    	WHERE DATE_SUB(NOW(), INTERVAL 14 DAY) < l.logout_time
    	ORDER BY l.id DESC;

     

    This is my non-working query:

    SELECT l.id AS id, l.login_time AS login, l.logout_time AS logout, p.name AS name 
    	FROM log.loginlog2 AS l 
    	LEFT JOIN player.player AS p ON (p.id = l.pid) 
    	WHERE DATE_SUB(NOW(), INTERVAL 14 DAY) < l.logout_time
    	AND WHERE l.is_gm = 'Y'
    	ORDER BY l.id DESC;

     

    This is the error i get:

    Quote

    [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE l.is_gm = 'Y'  ORDER BY l.id DESC' at line 5

     

    Can you tell me why? Or provide me a solution? I really don't want to do a work-around in php... <_<

     

    Thank you,

    .PolluX

  4. Dear metin2dev community,

    please don't bother us for taking down the forum for ~2 hours. We wanted to implement some changes which were discussed here.

    Please excuse that we didn't have time for everything - more changes (eg. changes to our rules) will follow soon.

     


     

    Changes to our sections:

    • Questions & Answers (link)
      • You now have the ability to up-vote answers to every question. The topic creator now can set a "best answer" which will be shown first. All other answers are ordered by their up-votes.
      • Added predefined prefixes "open" & "solved" to show other members the state of your question. Please set them according to your question state.

     

    • Tech Section (link)
      • We're removing this section completely. As you can see we started with this in this maintenance but because we want to clear everything inside this section and put every topic at its proper place, this will take some more time. You can help us by reporting questions which are still in the remaining sections. But please don't post new stuff there, we created the appropriate sections in the Release Section.

     

    • Private Servers (link)
      • We removed the ability to receive points on your overall content count.

     

    • Releases (link)
      • We removed the sub-section "Scripts". Why? Keep reading!
      • As mentioned before, we're removing the Tech Section. In the course of this we added three new sub-sections to the Release Section.
        • General
          • Moved all topics of "Maps", "Hosting" & "Security" to "General"
        • Programming / Scripts
          • Moved all topics of "Scripts" to "Programming". We also had the idea to move "Quests" there, but it will stay where it was/is.
        • Operating Systems
          • Moved all topics of "Linux" and "FreeBSD" of the old Tech Section to the new Section.

     

      • Notice: We changed the order of the sub-sections and might do this again in the future.

     


     

    The front page

    • We added some blocks to the sidebar so you can see better if there is something new:
      • Rules
      • News
    • We extended the statistics footer with post and topic counts.
    • We now have more languages than english!
      • English
      • Polish
      • Romanian
      • German
      • French
      • Spanish
        • If you want to help us: We need someone which is able to translate our rules to those languages and also some front end strings like our section names and descriptions. Write us a private message if you're interested!

     


     

    Introducing: the Advanced Tags- and Prefixes-System

    Because we want to improve the forum, we bought the "Advanced Tags & Prefixes" add-on which got installed in this maintenance.
    With it you now should have a better overview over topics inside a specific section. Also you can easily filter for a specific prefix by clicking on it.

    We removed to add custom tags in some sections so you're forced to set an appropriate prefix. All prefixes for one section are now shown on the main page of metin2dev - additionally to this the current prefix which is set for a specific topic will be shown next to its name on every page of metin2dev.

    All changes mentioned here will be done in another maintenance for other sections too.

    If you want to know more about this add-on please don't hesitate to ask us or visit the plugins' page here.

     


     

    If you encounter any problems/errors after this maintenance please send us a private message so we can fix that. Please also write us if you have any idea to improve this site - or even if you don't like something here. We would be happy to hear from you!

     

    Sincerely,

    the metin2dev administration

    @.PolluX & @DevChuckNorris

    • Love 14
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / 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.