[ Dead Download Link ] MT2-CMS - FORK [ We Need You ]

Pudge · December 25, 2014

Ahhhh, FRESH MEAT

Ayaka · January 3, 2015

My auction house has the following features:

- Detailed log of auctions for SAs

- SA options in the AP

- Auction display with real-time countdown

- Display of auctions

- Storage of Items

- Replacement of unsold items to IS stock

- Definition of ID section. Its a feature to prevent double entrys because of ingamedrop IDs (hope i understood this right):

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

Denis · January 3, 2015

PNGs You can convert tga to png using IrfanView

Ayaka · January 3, 2015

PNGs You can convert tga to png using IrfanView

Already know this but it takes so much time to convert file by file. is there any other solution (application) to convert all files by one click?

Denis · January 3, 2015

There's an option there called Batch Conversion/Rename you can find it at File tab.

Aemon · January 3, 2015

PNGs You can convert tga to png using IrfanView

Already know this but it takes so much time to convert file by file. is there any other solution (application) to convert all files by one click?

:main
@echo OFF
@echo ¯ Aemon, metin2dev.;
@echo   metin2dev.com.
@echo ---


:rename
set OLD=
set /P OLD=Choose the old extension : %=%
if "%OLD%" == "" GOTO error
set NEW=
set /P NEW=Choose new extension   : %=%
if "%NEW%" == "" GOTO error
@ren *.%OLD% *.%NEW%
@echo .%OLD% files have been renamed to .%NEW%
@echo ---
GOTO fine
:errore
@echo Error!
@echo Choose a valid extension!
@echo Restart the program and try again.
@echo ---
GOTO Exit
:fine
@echo You change the extension, good job...
:Exit
@pause

Paste it in a notepad, and save it with .bat extension.

Ayaka · January 3, 2015

:main
@echo OFF
@echo ¯ Aemon, metin2dev.;
@echo   metin2dev.com.
@echo ---


:rename
set OLD=
set /P OLD=Choose the old extension : %=%
if "%OLD%" == "" GOTO error
set NEW=
set /P NEW=Choose new extension   : %=%
if "%NEW%" == "" GOTO error
@ren *.%OLD% *.%NEW%
@echo .%OLD% files have been renamed to .%NEW%
@echo ---
GOTO fine
:errore
@echo Error!
@echo Choose a valid extension!
@echo Restart the program and try again.
@echo ---
GOTO Exit
:fine
@echo You change the extension, good job...
:Exit
@pause

Paste it in a notepad, and save it with .bat extension.

is this realy a good solution? by just renaming a file you didnt change the image compression

Denis · January 3, 2015

PNGs You can convert tga to png using IrfanView

Already know this but it takes so much time to convert file by file. is there any other solution (application) to convert all files by one click?
:main
@echo OFF
@echo ¯ Aemon, metin2dev.;
@echo   metin2dev.com.
@echo ---


:rename
set OLD=
set /P OLD=Choose the old extension : %=%
if "%OLD%" == "" GOTO error
set NEW=
set /P NEW=Choose new extension   : %=%
if "%NEW%" == "" GOTO error
@ren *.%OLD% *.%NEW%
@echo .%OLD% files have been renamed to .%NEW%
@echo ---
GOTO fine
:errore
@echo Error!
@echo Choose a valid extension!
@echo Restart the program and try again.
@echo ---
GOTO Exit
:fine
@echo You change the extension, good job...
:Exit
@pause
Paste it in a notepad, and save it with .bat extension.

rename != conversion..

Ayaka · January 3, 2015

Add some basic settings:

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

Stefan · January 3, 2015

Looks amazing waiting for next info

Ayaka · January 3, 2015

Add CMS Installer:

I did this simple and effective as fuck:

install/index.php:

<?php
// include config
include_once("../lib/config.php");

//connect to account database with mysqli
function getConnected($db) {
    //get config data
    global $config_host;
    global $config_user;
    global $config_pw;
    global $config_db_account;
    global $config_db_player;

    if ($db == "account") {
        $mysqli = mysqli_connect($config_host, $config_user, $config_pw, $config_db_account);
    } elseif ($db == "player") {
        $mysqli = mysqli_connect($config_host, $config_user, $config_pw, $config_db_player);
    }
    // error?
    if (mysqli_connect_errno($mysqli)) {
        die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
    }
    return $mysqli;
}
// Variables
$action = $_GET['action'];
// Set hideform to 0
$hideform = 0;

// ################################
// ### Install CMS
// ################################
if ($action == "install") {
    // Set hideform to 1
    $hideform = 1;
    // Connect to MySQL server
    $mysqli = getConnected(account);
    if ($mysqli) {
        echo "install process (Connect to mysql) ...<br>";
    }
    // Temporary variable, used to store current query
    $templine = '';
    // Read in entire file
    $a = file("install.sql");
    // Loop through each line
    $queryline = 0;
    foreach ($a as $ {
        // Skip it if it's a comment
        if (substr($b, 0, 2) == '--' || $b == '')
            continue;
        // Add this line to the current segment
        $templine .= $b;
        // If it has a semicolon at the end, it's the end of the query
        if (substr(trim($, -1, 1) == ';') {
            // Perform the query
            $sql = mysqli_query($mysqli, $templine);
            if ($sql) {
                echo "install process (Query $queryline) ...<br>";
                $queryline++;
            } else {
                $hideform = 2;
                //echo 'Error performing query '<strong>' . $templine . '': ' . mysqli_error($mysqli) . '<br /><br />';
            }
            // Reset temp variable to empty
            $templine = '';
        }
    }
    $closemysql = mysqli_close($mysqli);
    if ($closemysql) {
        echo "install process (Close connection) ...<br>";
    }
    if ($hideform != 2) {
        echo "<br><b><font style="color:green;">INSTALL COMPLETE!</font> PLEASE DELETE THE INSTALL FOLDER!</b>";
    }
    if ($hideform == 2) {
        echo "<br><b>INSTALL FAILED RIGHT AFTER <font style="color:red;">QUERY $queryline</font> ! FOR SUPPORT VISIT: Metin2dev.org</b>";
    }
}
if ($hideform <= 0) {
    echo "<a href="index.php?action=install">CLICK HERE</a> to install the CMS.";
}
?>

install/install.sql

-- Install table `cms_answers`
CREATE TABLE IF NOT EXISTS `cms_answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` varchar(10) NOT NULL,
  `ticketid` varchar(10) NOT NULL DEFAULT '',
  `message` varchar(900) NOT NULL DEFAULT '',
  `time` datetime NOT NULL,
  `ufrom` varchar(30) NOT NULL,
  `userlevel` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Install table `cms_cat`
CREATE TABLE IF NOT EXISTS `cms_cat` (
  `catid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL DEFAULT '',
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`catid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Install table `cms_settings`
CREATE TABLE IF NOT EXISTS `cms_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option_title` varchar(150) NOT NULL DEFAULT '',
  `value` varchar(500) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Install table `cms_statistik_day`
CREATE TABLE IF NOT EXISTS `cms_statistik_day` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` varchar(10) NOT NULL DEFAULT '',
  `user` int(10) NOT NULL DEFAULT '0',
  `view` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Install table `cms_statistik_ips`
CREATE TABLE IF NOT EXISTS `cms_statistik_ips` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL DEFAULT '',
  `time` int(20) NOT NULL DEFAULT '0',
  `online` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Install table `cms_statistik_referer`
CREATE TABLE IF NOT EXISTS `cms_statistik_referer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` varchar(7) NOT NULL DEFAULT '',
  `host` varchar(255) NOT NULL DEFAULT '',
  `referer` varchar(255) NOT NULL DEFAULT '',
  `view` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Install table `cms_tickets`
CREATE TABLE IF NOT EXISTS `cms_tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticketid` varchar(10) NOT NULL,
  `subject` varchar(150) NOT NULL DEFAULT '',
  `message` varchar(900) NOT NULL DEFAULT '',
  `priority` varchar(150) NOT NULL DEFAULT '',
  `ufrom` varchar(150) DEFAULT NULL,
  `usermail` varchar(150) NOT NULL DEFAULT '',
  `status` varchar(150) NOT NULL DEFAULT '',
  `categorie` varchar(150) NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

-- Insert data for `cms_cat`
INSERT INTO `cms_cat` (`catid`, `name`, `email`) VALUES
(1, 'General', '[email protected]'),
(2, 'Tecnical Support', '[email protected]'),
(3, 'Other', '[email protected]');

-- Insert data for `cms_settings`
INSERT INTO `cms_settings` (`id`, `option_title`, `value`) VALUES
(1, 'titel_page', 'SERVERNAME'),
(2, 'titel_slogan', 'This is a slogan'),
(3, 'url', 'http://localhost/mt2cms_fork/'),
(4, 'server_ip', ''),
(5, 'register_on', '1'),
(6, 'mail_activation', '1'),
(7, 'page_entries', '5'),
(8, 'pagination_entries', '4'),
(9, 'admin_mail', '[email protected]'),
(10, 'language', 'english.php'),
(11, 'reg_coins', '0'),
(12, 'addon_reg', '1'),
(13, 'addon_stats', '1'),
(14, 'addon_ticket', '1'),
(15, 'addon_auction', '1'),
(16, 'addon_shop', '1');

--------------------------------------------------------------------------------------------------------------------------

successful installation:

--------------------------------------------------------------------------------------------------------------------------

installation failed:

--------------------------------------------------------------------------------------------------------------------------

As you can see, i can extend the SQL every time. When im finished with the whole CMS i will write a little help doc for every Query Fail Number. So user can find a way without asking me or other people

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

Andres · January 4, 2015

I can help you with the spanish translation

Ayaka · January 4, 2015

Add Logs for AP (you can disable this feature if you think this will overload your database):

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

Aemon · January 4, 2015

Add Logs for AP (you can disable this feature if you think this will overload your databas

Awesome.

I have an idea, maybe you could make a trade log. So you can check if somebody reported that his account has been hacked. So you can check trades made from his account Sorry for my english, I know it's pretty bad.

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

Ayaka · January 4, 2015

Awesome.

I have an idea, maybe you could make a trade log. So you can check if somebody reported that his account has been hacked. So you can check trades made from his account Sorry for my english, I know it's pretty bad.

Great idea! I will add this feature. Thanks!

you gave me another idea. I will add a trace button for logins with the IP to check which accounts used with the "hackers" ip

SoNiice · January 4, 2015

The log about logins aren't that good. If someone try to login with "password123" but the password is "password1234" it's easy to crack it for admin panel users :-P

Ayaka · January 5, 2015

The log about logins aren't that good. If someone try to login with "password123" but the password is "password1234" it's easy to crack it for admin panel users :-P

hm thats true. Im thinking about it.

What about censoring ~50%?

example password: Th1s1smyPw

censored password: Th1s******

the main reason is to show APmembers when a user tries to get accounts from other people with (for examle) the same pw or other pws but the same login id

i have coded login attemps but with a little bit knowlege everyone can avoid this so the log makes sense.

edit:// or i will output the used pw crypted (example): *4ACFE3202A5FF5CF467898FC58AAB1D615029441

but thats the badest idea i think

edit:// i wrote a little dev doc:

Edited January 5, 2015 by Ayaka

Aemon · January 6, 2015

I give you another idea, referal system

Aurora · January 6, 2015

Are you gonna release this CMS?

Shang · January 6, 2015

Are you gonna release this CMS?

Important:

I will kick your ass if you post shit like: "This is not necessary". It is my intention to do this because I want to do this! You can bring ideas or constructive feedback but no bullshit. I will release this ONLY here (metin2dev) when I'm done. epvp can suck my **** and if someone releases this there, I will report that.

Andres · January 6, 2015

Another idea, add a vote 4 coins system (if you can and want to, obviously)

Ayaka · January 6, 2015

Another idea, add a vote 4 coins system (if you can and want to, obviously)

Already posted

Votefunction:

SAs can choose a toplist for voting support on "metin2pserver.info", "topliste.top-pserver.com", "pservertoplist.pw". ranksec.net is offline but I hope it will come back. I will support only toplists with an API because of getting coins correctly without cheating. SAs have only to enable a toplist and input necessary data in the ACP.

It will be possible that you can choose more than one toplist to vote in this system. And you can decide how much coins the user will get for each toplist.

I give you another idea, referal system

Can you explain what exactly a referal system is? I dont know ^^

Andres · January 6, 2015

Another idea, add a vote 4 coins system (if you can and want to, obviously)

Already posted

Votefunction:

SAs can choose a toplist for voting support on "metin2pserver.info", "topliste.top-pserver.com", "pservertoplist.pw". ranksec.net is offline but I hope it will come back. I will support only toplists with an API because of getting coins correctly without cheating. SAs have only to enable a toplist and input necessary data in the ACP.

It will be possible that you can choose more than one toplist to vote in this system. And you can decide how much coins the user will get for each toplist.

I give you another idea, referal system

Can you explain what exactly a referal system is? I dont know ^^

The referral system is a link that every user have, example: metin2example.com/ref=andres and when the user registers using that referral link the referral in this case "andres" gets a new referral, you can add coins per referral or things like that

SoNiice · January 7, 2015

It's the "Freunde werben" function in german if that helps you =P

Ayaka · January 7, 2015

Ahh thats a cool feature! I will add this, too

Sign In

[ Dead Download Link ] MT2-CMS - FORK [ We Need You ]

Recommended Posts

Pudge 12

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Ayaka

Ayaka

Ayaka

Ayaka 291

Link to comment

Share on other sites

Denis 1462

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Denis 1462

Link to comment

Share on other sites

Aemon 7

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Denis 1462

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Stefan 90

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Andres 4

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Aemon 7

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

SoNiice 14

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Aemon 7

Link to comment

Share on other sites

Aurora 46

Link to comment

Share on other sites

Shang 360

Link to comment

Share on other sites

Andres 4

Link to comment

Share on other sites

Ayaka 291

Link to comment

Share on other sites

Andres 4

Link to comment

Share on other sites