Best Studio 1
Best Studio
Bvural41 1
Bvural41
noisiv 1
noisiv
Manwe Work 1
Manwe Work
Hikaye Ekle

Yeni Log Dartbasesi Sql'leri,

  • Konuyu başlatan Konuyu başlatan xxmehmetcc
  • Başlangıç tarihi Başlangıç tarihi
  • Cevaplar Cevaplar 5
  • Görüntüleme Görüntüleme 2K
Tarihe Göre Sırala Reaksiyona göre sırala

HERAKLES Otomatik Avlı kalıcı sunucu. 19 Haziran'da açılıyor. Atius & Wizard güvencesiyle hemen kayıt ol, ön kayıt ödülleri aktif. HEMEN TIKLA!

Merhaba,
Eski sql 'lere göre yenilikleri neler? Eski Sql dosyalarınıza nazaran speed hack açanları kaydeder,Hack shield log kaydı ,servere verdiginiz komutları kaydeder,isim değişikligi yapanları kaydeder.
Yapılış;


Masaüstüne log_table.sql isminde dosya açın içine girin (nodpad++ önerilir) içine aşagıdaki kodları yapıstırın.Ardından mysql bağlanın log dartbasesine giriş yapın içindeki tabloları silin ve bu sql yi yükleyin.


Kod: 
SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------
-- Table structure for `bootlog`
-- ----------------------------
DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
  `time` int(11) DEFAULT NULL,
  `hostname` int(11) DEFAULT NULL,
  `channel` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of bootlog
-- ----------------------------


-- ----------------------------
-- Table structure for `change_name`
-- ----------------------------
DROP TABLE IF EXISTS `change_name`;
CREATE TABLE `change_name` (
  `pid` int(20) NOT NULL DEFAULT '0',
  `old_name` varchar(30) DEFAULT NULL,
  `new_name` varchar(30) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of change_name
-- ----------------------------


-- ----------------------------
-- Table structure for `command_log`
-- ----------------------------
DROP TABLE IF EXISTS `command_log`;
CREATE TABLE `command_log` (
  `userid` int(11) DEFAULT NULL,
  `server` int(11) DEFAULT NULL,
  `ip` text,
  `port` int(11) DEFAULT NULL,
  `username` varchar(18) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',
  `command` varchar(128) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of command_log
-- ----------------------------


-- ----------------------------
-- Table structure for `cube`
-- ----------------------------
DROP TABLE IF EXISTS `cube`;
CREATE TABLE `cube` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `pid` int(20) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `x` int(40) DEFAULT NULL,
  `y` int(40) DEFAULT NULL,
  `item_vnum` int(40) DEFAULT NULL,
  `item_uid` varchar(40) DEFAULT NULL,
  `item_count` int(20) DEFAULT NULL,
  `succes` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of cube
-- ----------------------------


-- ----------------------------
-- Table structure for `dragon_slay_log`
-- ----------------------------
DROP TABLE IF EXISTS `dragon_slay_log`;
CREATE TABLE `dragon_slay_log` (
  `1` varchar(255) NOT NULL,
  `2` varchar(255) NOT NULL,
  `3` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `4` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of dragon_slay_log
-- ----------------------------


-- ----------------------------
-- Table structure for `fish_log`
-- ----------------------------
DROP TABLE IF EXISTS `fish_log`;
CREATE TABLE `fish_log` (
  `1` int(11) DEFAULT NULL,
  `2` int(11) DEFAULT NULL,
  `3` int(11) DEFAULT NULL,
  `4` int(11) DEFAULT NULL,
  `5` int(11) DEFAULT NULL,
  `6` int(11) DEFAULT NULL,
  `7` int(11) DEFAULT NULL,
  `8` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of fish_log
-- ----------------------------


-- ----------------------------
-- Table structure for `gmhost`
-- ----------------------------
DROP TABLE IF EXISTS `gmhost`;
CREATE TABLE `gmhost` (
  `mIP` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`mIP`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;


-- ----------------------------
-- Records of gmhost
-- ----------------------------


-- ----------------------------
-- Table structure for `gmlist`
-- ----------------------------
DROP TABLE IF EXISTS `gmlist`;
CREATE TABLE `gmlist` (
  `mID` int(10) 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') DEFAULT 'PLAYER',
  PRIMARY KEY (`mID`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;


-- ----------------------------
-- Records of gmlist
-- ----------------------------


-- ----------------------------
-- Table structure for `goldlog`
-- ----------------------------
DROP TABLE IF EXISTS `goldlog`;
CREATE TABLE `goldlog` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `what` int(20) DEFAULT NULL,
  `how` varchar(20) DEFAULT NULL,
  `hint` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of goldlog
-- ----------------------------


-- ----------------------------
-- Table structure for `hack_crc_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_crc_log`;
CREATE TABLE `hack_crc_log` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `login` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  `server` int(20) DEFAULT NULL,
  `why` varchar(20) DEFAULT NULL,
  `crc` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of hack_crc_log
-- ----------------------------


-- ----------------------------
-- Table structure for `hack_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_log`;
CREATE TABLE `hack_log` (
  `time` time DEFAULT NULL,
  `login` longtext COLLATE big5_bin,
  `name` varchar(25) COLLATE big5_bin DEFAULT NULL,
  `ip` text CHARACTER SET latin1,
  `server` varchar(25) COLLATE big5_bin DEFAULT NULL,
  `why` varchar(25) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of hack_log
-- ----------------------------


-- ----------------------------
-- Table structure for `hackshield_log`
-- ----------------------------
DROP TABLE IF EXISTS `hackshield_log`;
CREATE TABLE `hackshield_log` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `account_id` int(20) DEFAULT NULL,
  `login` varchar(20) DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `reason` varchar(20) DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of hackshield_log
-- ----------------------------


-- ----------------------------
-- Table structure for `ingame_ban_log`
-- ----------------------------
DROP TABLE IF EXISTS `ingame_ban_log`;
CREATE TABLE `ingame_ban_log` (
  `ban_time` datetime DEFAULT NULL,
  `who` varchar(255) COLLATE big5_bin DEFAULT NULL,
  `GM` varchar(255) COLLATE big5_bin DEFAULT NULL,
  `cause` varchar(255) COLLATE big5_bin DEFAULT NULL,
  `until` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of ingame_ban_log
-- ----------------------------


-- ----------------------------
-- Table structure for `levellog`
-- ----------------------------
DROP TABLE IF EXISTS `levellog`;
CREATE TABLE `levellog` (
  `name` varchar(50) COLLATE big5_bin DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `pid` int(11) DEFAULT NULL,
  `playtime` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of levellog
-- ----------------------------


-- ----------------------------
-- Table structure for `locale`
-- ----------------------------
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;


-- ----------------------------
-- Records of locale
-- ----------------------------


-- ----------------------------
-- Table structure for `locale_bug`
-- ----------------------------
DROP TABLE IF EXISTS `locale_bug`;
CREATE TABLE `locale_bug` (
  `mKey` varchar(255) NOT NULL DEFAULT '',
  `mValue` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`mKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of locale_bug
-- ----------------------------


-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `type` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `who` int(20) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `what` int(20) DEFAULT NULL,
  `how` varchar(1024) COLLATE big5_bin DEFAULT NULL,
  `hint` varchar(1024) COLLATE big5_bin DEFAULT NULL,
  `ip` varchar(30) COLLATE big5_bin DEFAULT NULL,
  `vnum` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of log
-- ----------------------------


-- ----------------------------
-- Table structure for `loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `type` text,
  `time` datetime DEFAULT NULL,
  `channel` int(20) DEFAULT NULL,
  `account_id` int(20) DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `level` int(20) DEFAULT NULL,
  `job` int(20) DEFAULT NULL,
  `playtime` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of loginlog
-- ----------------------------


-- ----------------------------
-- Table structure for `loginlog2`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog2`;
CREATE TABLE `loginlog2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` text,
  `is_gm` int(11) DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `channel` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `client_version` text,
  `ip` text,
  `logout_time` datetime DEFAULT NULL,
  `playtime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60579 DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of loginlog2
-- ----------------------------


-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `time` datetime DEFAULT NULL,
  `DELAYED` int(11) DEFAULT NULL,
  `vnum` int(11) DEFAULT '0',
  `pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of money_log
-- ----------------------------


-- ----------------------------
-- Table structure for `pcbang_loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `pcbang_loginlog`;
CREATE TABLE `pcbang_loginlog` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `pcbang_id` int(20) DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `play_time` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of pcbang_loginlog
-- ----------------------------


-- ----------------------------
-- Table structure for `quest_reward_log`
-- ----------------------------
DROP TABLE IF EXISTS `quest_reward_log`;
CREATE TABLE `quest_reward_log` (
  `1` varchar(50) COLLATE big5_bin DEFAULT NULL,
  `2` int(11) DEFAULT NULL,
  `3` int(11) DEFAULT NULL,
  `4` int(11) DEFAULT NULL,
  `5` int(11) DEFAULT NULL,
  `6` int(11) DEFAULT NULL,
  `7` time DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of quest_reward_log
-- ----------------------------


-- ----------------------------
-- Table structure for `refinelog`
-- ----------------------------
DROP TABLE IF EXISTS `refinelog`;
CREATE TABLE `refinelog` (
  `Id` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `item_name` varchar(50) COLLATE big5_bin DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `step` int(11) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `is_success` int(11) DEFAULT NULL,
  `setType` varchar(50) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of refinelog
-- ----------------------------


-- ----------------------------
-- Table structure for `shout_log`
-- ----------------------------
DROP TABLE IF EXISTS `shout_log`;
CREATE TABLE `shout_log` (
  `1` time DEFAULT NULL,
  `2` int(11) DEFAULT NULL,
  `3` int(11) DEFAULT NULL,
  `4` varchar(2555) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of shout_log
-- ----------------------------


-- ----------------------------
-- Table structure for `speed_hack`
-- ----------------------------
DROP TABLE IF EXISTS `speed_hack`;
CREATE TABLE `speed_hack` (
  `pid` int(11) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `hack_count` varchar(20) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;


-- ----------------------------
-- Records of speed_hack
-- ----------------------------

Sql Alıntıdır.

İyi günler..
 
Cevap yazmak için giriş yap yada kayıt ol.

Şu an konuyu görüntüleyenler (Toplam : 0, Üye: 0, Misafir: 0)

Benzer konular

CoderPia
Pus için Gerekli Q.A Kodları
Cevaplar
1
Görüntüleme
25
Nizam-ı Alem
Jaguarz
  • Soru Soru
Cevaplanmadı Switchbot Reboot'dan Sonra İtem Kaybolması Sorunu
Cevaplar
2
Görüntüleme
137
ftyazilim
mistikaptal
lua offlineshop
Cevaplar
3
Görüntüleme
255
Enkazmt2
mistikaptal
% ye bağlı olarak bossların hp sp st dx sömürmesi
Cevaplar
0
Görüntüleme
192
mistikaptal
Nizam-ı Alem
XenForo Session.php Hatası
Cevaplar
1
Görüntüleme
40
Son1Dem
Geri
Üst