SQL:
Tablolar oluşturuluyor => common
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1 (HY000) at line 17: Can't create/write to file '/var/db/mysql/common/gmlist.MYI' (OS errno 13 - Permission denied)ayrıyetten harici sysler var
C++:
SYSERR: Sep 14 20:23:07 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.107')
SYSERR: Sep 14 20:23:12 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.107')
SYSERR: Sep 14 20:23:17 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.107')
SYSERR: Sep 14 20:25:31 :: Process: FDWATCH: peer null in event: ident 32
SYSERR: Sep 14 20:25:34 :: Process: FDWATCH: peer null in event: ident 35
SYSERR: Sep 14 20:25:34 :: Process: FDWATCH: peer null in event: ident 33
SYSERR: Sep 14 20:25:35 :: Process: FDWATCH: peer null in event: ident 34
SYSERR: Sep 14 20:25:38 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Sep 14 20:25:38 :: pid_deinit:
End of pidsql olarak yüklenmiyor ve karakterler gm olmuyor cözemedim
C#:
SYSERR: Sep 14 20:23:07 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.107')
SQL:
-- Metin2 Sıfırdan Altyapı Server Files Oluşturma Rehberi --
-- MMO Tutkunları | Whistle | mmotutkunlari.com --
-- Bu komutlar common tablolarını oluşturacak --
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `gmhost`;
CREATE TABLE `gmhost` (
`mIP` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`mIP`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `gmhost` VALUES ('127.0.0.1');
DROP TABLE IF EXISTS `gmlist`;
CREATE TABLE `gmlist` (
`mID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`mAccount` varchar(16) NOT NULL DEFAULT '',
`mName` varchar(16) NOT NULL DEFAULT '',
`mContactIP` varchar(16) NOT NULL DEFAULT '',
`mServerIP` varchar(16) NOT NULL DEFAULT 'ALL',
`mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') NOT NULL DEFAULT 'PLAYER',
PRIMARY KEY (`mID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `locale`;
CREATE TABLE `locale` (
`mKey` varchar(255) NOT NULL DEFAULT '',
`mValue` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`mKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `locale` VALUES ('LOCALE', 'turkey');
INSERT INTO `locale` VALUES ('DB_NAME_COLUMN', 'locale_name');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE0', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE1', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE2', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE3', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE4', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE5', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE6', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL_TYPE7', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
INSERT INTO `locale` VALUES ('SKILL_DAMAGE_BY_LEVEL_UNDER_90', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0');
INSERT INTO `locale` VALUES ('SKILL_DAMAGE_BY_LEVEL_UNDER_45', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0');
INSERT INTO `locale` VALUES ('SKILL_POWER_BY_LEVEL', '0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125');
DROP TABLE IF EXISTS `spam_db`;
CREATE TABLE `spam_db` (
`word` varchar(255) NOT NULL,
`score` int(3) NOT NULL DEFAULT '1',
`type` enum('SPAM','MAPS') NOT NULL DEFAULT 'SPAM',
PRIMARY KEY (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
Son düzenleme:
