Cod: Selectaţi tot
# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 46.28.204.61
# Database: rs_player
# Server version: 5.5.30-log
# Server OS: FreeBSD8.3
# Target compatibility: Same as source (5.5.30)
# Target max_allowed_packet: 1048576
# HeidiSQL version: 4.0
# Date/time: 2013-07-02 20:30:16
# --------------------------------------------------------
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/
#
# Database structure for database 'rs_player'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rs_player` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `rs_player`;
#
# Table structure for table 'auction_house_chronology'
#
CREATE TABLE `auction_house_chronology` (
`id_account` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Id account',
`data` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Data',
`transaction_id` bigint(15) unsigned NOT NULL DEFAULT '0' COMMENT 'Id della transazione dove è avvenuta l''azione',
`item_name` varchar(25) NOT NULL DEFAULT '' COMMENT 'Nome dell''oggetto',
`yang_before_buying` bigint(15) NOT NULL DEFAULT '0' COMMENT 'Yang prima dell''acquisto',
`yang_after_buying` bigint(15) NOT NULL DEFAULT '0' COMMENT 'Yang dopo dell''acquisto',
`item_price` varchar(20) NOT NULL DEFAULT '' COMMENT 'Costo operazione (o dell''oggetto)',
`what` enum('RIT_ITEM_WIN','RIT_GOLD_WIN','RIT_ITEM_NSELL','RIT_GOLD_OFFERED','OFFER','BUY_NOW','ND') NOT NULL DEFAULT 'ND' COMMENT 'Cosa è stato eseguito',
`status` enum('OK','FAIL') NOT NULL DEFAULT 'FAIL' COMMENT 'Status dell''azione',
`why` varchar(100) NOT NULL DEFAULT '' COMMENT 'Descrizione dell''accaduto',
PRIMARY KEY (`id_account`,`data`,`transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table 'auction_house_chronology'
#
LOCK TABLES `auction_house_chronology` WRITE;
/*!40000 ALTER TABLE `auction_house_chronology` DISABLE KEYS;*/
INSERT INTO `auction_house_chronology` (`id_account`, `data`, `transaction_id`, `item_name`, `yang_before_buying`, `yang_after_buying`, `item_price`, `what`, `status`, `why`) VALUES
('25887','2013-04-17 12:08:39','3','Coltello del Drago+8','0','0','100000000','BUY_NOW','FAIL','Yang insufficenti.'),
('15131','2013-04-18 17:38:10','6','Spada del Rancore+7','0','0','100000000','BUY_NOW','FAIL','Yang insufficenti.'),
('10622','2013-06-16 12:45:44','82','Spada del Rancore+9','0','0','0','RIT_ITEM_NSELL','OK','Ritiro oggetto non venduto, deposito in posizione 30.'),
('2900','2013-06-25 01:04:09','94','Pugnali Divini','600000000','600000000','0','RIT_ITEM_NSELL','OK','Ritiro oggetto non venduto, deposito in posizione 0.');
/*!40000 ALTER TABLE `auction_house_chronology` ENABLE KEYS;*/
UNLOCK TABLES;
#
# Table structure for table 'auction_house_items'
#
CREATE TABLE `auction_house_items` (
`transaction_id` bigint(15) unsigned NOT NULL AUTO_INCREMENT,
`data_insert` datetime NOT NULL,
`data_remove` datetime NOT NULL,
`riferimento` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
`base` bigint(15) unsigned NOT NULL DEFAULT '0',
`compra_subito` bigint(15) unsigned NOT NULL DEFAULT '0',
`comprato` tinyint(1) unsigned NOT NULL DEFAULT '0',
`offerta_attuale` bigint(15) unsigned NOT NULL DEFAULT '0',
`offerte_totali` int(5) unsigned NOT NULL DEFAULT '0',
`acquirente` int(11) unsigned NOT NULL DEFAULT '0',
`ritiro_denaro` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ritiro_item` tinyint(1) unsigned NOT NULL DEFAULT '0',
`id` bigint(15) unsigned NOT NULL,
`owner_id` int(11) unsigned NOT NULL DEFAULT '0',
`window` enum('MALL') NOT NULL DEFAULT 'MALL',
`pos` smallint(5) unsigned NOT NULL DEFAULT '0',
`count` tinyint(3) unsigned NOT NULL DEFAULT '0',
`vnum` int(11) unsigned NOT NULL DEFAULT '0',
`socket0` int(10) unsigned NOT NULL DEFAULT '0',
`socket1` int(10) unsigned NOT NULL DEFAULT '0',
`socket2` int(10) unsigned NOT NULL DEFAULT '0',
`socket3` int(10) unsigned NOT NULL DEFAULT '0',
`socket4` int(10) unsigned NOT NULL DEFAULT '0',
`socket5` int(10) unsigned NOT NULL DEFAULT '0',
`attrtype0` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue0` smallint(6) NOT NULL DEFAULT '0',
`attrtype1` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue1` smallint(6) NOT NULL DEFAULT '0',
`attrtype2` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue2` smallint(6) NOT NULL DEFAULT '0',
`attrtype3` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue3` smallint(6) NOT NULL DEFAULT '0',
`attrtype4` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue4` smallint(6) NOT NULL DEFAULT '0',
`attrtype5` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue5` smallint(6) NOT NULL DEFAULT '0',
`attrtype6` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue6` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;
#
# Dumping data for table 'auction_house_items'
#
LOCK TABLES `auction_house_items` WRITE;
/*!40000 ALTER TABLE `auction_house_items` DISABLE KEYS;*/
INSERT INTO `auction_house_items` (`transaction_id`, `data_insert`, `data_remove`, `riferimento`, `ip`, `base`, `compra_subito`, `comprato`, `offerta_attuale`, `offerte_totali`, `acquirente`, `ritiro_denaro`, `ritiro_item`, `id`, `owner_id`, `window`, `pos`, `count`, `vnum`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `attrtype0`, `attrvalue0`, `attrtype1`, `attrvalue1`, `attrtype2`, `attrvalue2`, `attrtype3`, `attrvalue3`, `attrtype4`, `attrvalue4`, `attrtype5`, `attrvalue5`, `attrtype6`, `attrvalue6`) VALUES
('1','2013-04-15 01:07:24','2013-04-17 01:07:24','Cive','93','10000000','0',0,'0','0','0',0,0,'270000104','25731','MALL',0,1,'13044','0','0','0','0','0','0',0,0,0,0,0,0,0,0,0,0,80,3,0,0),
('55','2013-05-26 17:55:36','2013-05-28 17:55:36','Cuzzata','79.56.105.10','50000000','60000000',0,'0','0','0',0,1,'630015588','6056','MALL',0,1,'12240','0','0','0','0','0','0',0,0,0,0,0,0,0,0,0,0,0,0,0,0),
('111','2013-06-22 14:36:53','2013-06-24 14:36:53','Crisu','94','1200000000','1400000000',0,'0','0','0',0,0,'710009981','10622','MALL',0,1,'3169','1','1','1','0','0','0',72,48,71,-18,22,20,13,3,5,6,0,0,0,0);
/*!40000 ALTER TABLE `auction_house_items` ENABLE KEYS;*/
UNLOCK TABLES;
#
# Table structure for table 'auction_house_option_settings'
#
CREATE TABLE `auction_house_option_settings` (
`opzione` varchar(50) NOT NULL,
`valore` int(2) unsigned NOT NULL DEFAULT '10',
PRIMARY KEY (`opzione`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table 'auction_house_option_settings'
#
LOCK TABLES `auction_house_option_settings` WRITE;
/*!40000 ALTER TABLE `auction_house_option_settings` DISABLE KEYS;*/
INSERT INTO `auction_house_option_settings` (`opzione`, `valore`) VALUES
('aggiornamento_menu_principale','10'),
('aggiornamento_menu_acquisti','10'),
('aggiornamento_menu_vendite','10'),
('aggiornamento_menu_preferiti','10'),
('aggiornamento_menu_oggetto','10');
/*!40000 ALTER TABLE `auction_house_option_settings` ENABLE KEYS;*/
UNLOCK TABLES;
#
# Table structure for table 'auction_house_preferred_items'
#
CREATE TABLE `auction_house_preferred_items` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_account` int(11) NOT NULL DEFAULT '0',
`preferred_item` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=big5;
#
# Dumping data for table 'auction_house_preferred_items'
#
LOCK TABLES `auction_house_preferred_items` WRITE;
/*!40000 ALTER TABLE `auction_house_preferred_items` DISABLE KEYS;*/
INSERT INTO `auction_house_preferred_items` (`id`, `id_account`, `preferred_item`) VALUES
('1',14409,'17'),
('3',26603,'18'),
('4',27682,'19'),
('5',3856,'19'),
('6',27415,'19'),
('7',15610,'19'),
('8',27741,'23'),
('9',15131,'22'),
('12',27956,'29'),
('13',25051,'34'),
('15',27456,'46'),
('16',28269,'47'),
('18',29816,'56'),
('19',30396,'65'),
('22',25551,'64'),
('24',30396,'73'),
('26',30737,'99');
/*!40000 ALTER TABLE `auction_house_preferred_items` ENABLE KEYS;*/
UNLOCK TABLES;
#
# Table structure for table 'auction_house_settings'
#
CREATE TABLE `auction_house_settings` (
`vnum` int(11) unsigned NOT NULL DEFAULT '0',
`name` varchar(24) NOT NULL DEFAULT 'Noname',
`category` enum('ARMI','CORAZZE','ELMI','SCUDI','BRACCIALI','SCARPE','COLLANE','ORECCHINI','MOUNT','PET','OTHER','ND') NOT NULL DEFAULT 'ND',
`up` varchar(2) NOT NULL,
`size` tinyint(1) unsigned NOT NULL DEFAULT '0',
`show_level` tinyint(1) unsigned NOT NULL,
`socket_type` tinyint(1) unsigned NOT NULL,
`mineral_vnum` smallint(5) unsigned NOT NULL,
`icon` varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table 'auction_house_settings'
#
LOCK TABLES `auction_house_settings` WRITE;
/*!40000 ALTER TABLE `auction_house_settings` DISABLE KEYS;*/
INSERT INTO `auction_house_settings` (`vnum`, `name`, `category`, `up`, `size`, `show_level`, `socket_type`, `mineral_vnum`, `icon`) VALUES
('11495','Abito del Vento Oscuro+5','CORAZZE','5',2,1,1,0,'11490.png'),
('11494','Abito del Vento Oscuro+4','CORAZZE','4',2,1,1,0,'11490.png'),
('11493','Abito del Vento Oscuro+3','CORAZZE','3',2,1,1,0,'11490.png'),
('16309','Collana Predatore+9','COLLANE','9',1,1,2,50638,'16300.png'),
('80278','Gattina beige','PET','ND',1,0,0,0,'80278.png'),
('80277','Gattina bianca','PET','ND',1,0,0,0,'80277.png'),
/*!40000 ALTER TABLE `auction_house_settings` ENABLE KEYS;*/
UNLOCK TABLES;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/
Cod: Selectaţi tot
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
#
# Database structure for database 'rs_player'
#
CREATE DATABASE /' at line 1
[Err] # HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 46.28.204.61
# Database: rs_player
# Server version: 5.5.30-log
# Server OS: FreeBSD8.3
# Target compatibility: Same as source (5.5.30)
# Target max_allowed_packet: 1048576
# HeidiSQL version: 4.0
# Date/time: 2013-07-02 20:30:16
# --------------------------------------------------------
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/
#
# Database structure for database 'rs_player'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rs_player` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `rs_player`;
#
# Table structure for table 'auction_house_chronology'
#
CREATE TABLE `auction_house_chronology` (
`id_account` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Id account',
`data` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Data',
`transaction_id` bigint(15) unsigned NOT NULL DEFAULT '0' COMMENT 'Id della transazione dove è avvenuta l''azione',
`item_name` varchar(25) NOT NULL DEFAULT '' COMMENT 'Nome dell''oggetto',
`yang_before_buying` bigint(15) NOT NULL DEFAULT '0' COMMENT 'Yang prima dell''acquisto',
`yang_after_buying` bigint(15) NOT NULL DEFAULT '0' COMMENT 'Yang dopo dell''acquisto',
`item_price` varchar(20) NOT NULL DEFAULT '' COMMENT 'Costo operazione (o dell''oggetto)',
`what` enum('RIT_ITEM_WIN','RIT_GOLD_WIN','RIT_ITEM_NSELL','RIT_GOLD_OFFERED','OFFER','BUY_NOW','ND') NOT NULL DEFAULT 'ND' COMMENT 'Cosa è stato eseguito',
`status` enum('OK','FAIL') NOT NULL DEFAULT 'FAIL' COMMENT 'Status dell''azione',
`why` varchar(100) NOT NULL DEFAULT '' COMMENT 'Descrizione dell''accaduto',
PRIMARY KEY (`id_account`,`data`,`transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table 'auction_house_chronology'
#
LOCK TABLES `auction_house_chronology` WRITE;
/*!40000 ALTER TABLE `auction_house_chronology` DISABLE KEYS;*/
INSERT INTO `auction_house_chronology` (`id_account`, `data`, `transaction_id`, `item_name`, `yang_before_buying`, `yang_after_buying`, `item_price`, `what`, `status`, `why`) VALUES
('25887','2013-04-17 12:08:39','3','Coltello del Drago+8','0','0','100000000','BUY_NOW','FAIL','Yang insufficenti.'),
('15131','2013-04-18 17:38:10','6','Spada del Rancore+7','0','0','100000000','BUY_NOW','FAIL','Yang insufficenti.'),
('15131','2013-04-19 20:50:26','6','Spada del Rancore+7','0','0','0','OFFER','FAIL','Offerta rifiutata: yang disponibili insufficenti.'),
('15131','2013-04-19 20:50:33','6','Spada del Rancore+7','0','0','100000000','BUY_NOW','FAIL','Yang insufficenti.'),
('15131','2013-04-19 20:52:01','6','Spada del Rancore+7','0','0','0','OFFER','FAIL','Offerta rifiutata: yang disponibili insufficenti.'),
('15131','2013-04-19 21:27:59','6','Spada del Rancore+7','0','0','100000000','BUY_NOW','FAIL','Yang insufficenti.'),
('26468','2013-04-20 13:25:28','6','Spada del Rancore+7','0','0','0','OFFER','FAIL','Offerta rifiutata: yang disponibili insufficenti.'),
('8654','2013-04-20 14:19:44','6','Spada del Rancore+7','0','0','0','OFFER','FAIL','Offerta rifiutata: offerta non numerica.'),
('26462','2013-04-23 00:31:52','9','Corazza della Magia+6','0','0','0','OFFER','FAIL','Offerta rifiutata: offerta inferiore rispetto alla base.'),
('25051','2013-04-24 22:03:07','11','Campana Orchidea+7','6000000','6000000','10000000','BUY_NOW','FAIL','Yang insufficenti.'),
('25051','2013-04-24 22:03:50','11','Campana Orchidea+7','10000000','0','10000000','BUY_NOW','OK','Acquisto effettuato.'),
('11487','2013-04-25 00:30:37','11','Campana Orchidea+7','0','10000000','10000000','RIT_GOLD_WIN','OK','Yang derivanti dall\'asta ritirati!'),
('26487','2013-04-26 01:18:20','13','Abito del Vento Oscuro+0','0','0','0','OFFER','FAIL','Offerta rifiutata: offerta inferiore rispetto alla base.'),
('27516','2013-04-26 12:23:36','14','Scudo di Tigre+4','0','0','2','BUY_NOW'
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Stie ceneva cum sa rezolv????
de 
de