Die Codes :
Sql:
Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Palvelin: localhost
-- Luontiaika: 30.06.2010 klo 17:22
-- Palvelimen versio: 5.1.41
-- PHP:n versio: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Tietokanta: `ubercms`
--
-- --------------------------------------------------------
--
-- Rakenne taululle `furniture`
--
CREATE TABLE IF NOT EXISTS `furniture` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`public_name` text NOT NULL COMMENT 'temp only',
`item_name` varchar(100) NOT NULL,
`type` enum('s','i','e','h') NOT NULL DEFAULT 's',
`width` int(11) NOT NULL DEFAULT '1',
`length` int(11) NOT NULL DEFAULT '1',
`stack_height` double NOT NULL DEFAULT '1',
`can_stack` enum('0','1') NOT NULL DEFAULT '1',
`can_sit` enum('0','1') NOT NULL DEFAULT '0',
`is_walkable` enum('0','1') NOT NULL DEFAULT '0',
`sprite_id` int(11) NOT NULL,
`allow_recycle` enum('0','1') NOT NULL DEFAULT '1',
`allow_trade` enum('0','1') NOT NULL DEFAULT '1',
`allow_marketplace_sell` enum('0','1') NOT NULL DEFAULT '1',
`allow_gift` enum('0','1') NOT NULL DEFAULT '1',
`allow_inventory_stack` enum('0','1') NOT NULL DEFAULT '1',
`interaction_type` enum('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet') NOT NULL DEFAULT 'default',
`interaction_modes_count` int(11) NOT NULL DEFAULT '1',
`vending_ids` varchar(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29917 ;
--
-- Vedos taulusta `furniture`
--
INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`) VALUES
(20335, 'bw_boat name', 'bw_boat', 's', 2, 2, 1, '1', '1', '0', 3527, '1', '1', '1', '1', '1', 'default', 1, '0'),
(20336, 'bw_jaws', 'bw_jaws', 'i', 1, 1, 1, '1', '0', '0', 38959, '1', '1', '1', '1', '1', 'default', 1, '0'),
(20337, 'bw_shower', 'bw_shower', 's', 1, 1, 0, '0', '0', '1', 3540, '1', '1', '1', '1', '1', 'default', 2, '0'),
(20338, 'bw_tele', 'bw_tele', 's', 1, 1, 0, '0', '0', '1', 3550, '1', '1', '1', '1', '1', 'teleport', 1, '0'),
(20339, 'bw_water_2', 'bw_water_2', 's', 2, 2, 0, '1', '0', '1', 3541, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29901, 'bw_lgchair', 'bw_lgchair', 's', 1, 1, 3, '0', '1', '1', 3529, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29902, 'bw_sofa', 'bw_sofa', 's', 1, 2, 1, '0', '0', '1', 3533, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29903, 'bw_sboard', 'bw_sboard', 's', 1, 2, 1, '1', '0', '1', 3543, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29904, 'bw_chair', 'bw_chair', 's', 1, 1, 1, '1', '1', '0', 3544, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29905, 'bw_ccnuts', 'bw_ccnuts', 's', 1, 1, 1, '0', '0', '0', 3539, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29906, 'bw_table', 'bw_table', 's', 2, 2, 1, '1', '0', '0', 3545, '1', '1', '1', '1', '1', 'default', 2, '0'),
(29907, 'bw_bball', 'bw_bball', 's', 1, 1, 1, '1', '0', '0', 3547, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29908, 'bw_croc', 'bw_croc', 's', 1, 1, 1, '1', '1', '0', 3542, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29909, 'bw_fnc', 'bw_fnc', 's', 1, 1, 1, '1', '0', '0', 3552, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29910, 'bw_water_1', 'bw_water_1', 's', 2, 2, 0, '1', '0', '1', 3541, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29911, 'prison_dvdr2', 'prison_dvdr2', 's', 2, 1, 3, '1', '0', '0', 3532, '1', '1', '1', '1', '1', 'default', 4, '0'),
(29912, 'prison_gate', 'prison_gate', 's', 1, 1, 1, '0', '0', '0', 3526, '1', '1', '1', '1', '1', 'gate', 1, '0'),
(29913, 'prison_dvdr1', 'prison_dvdr1', 's', 1, 1, 3, '1', '0', '0', 3534, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29914, 'prison_stone', 'prison_stone', 's', 1, 1, 1, '0', '0', '0', 3537, '1', '1', '1', '1', '1', 'default', 1, '0'),
(29915, 'prison_tower', 'prison_tower', 's', 1, 1, 3, '1', '0', '1', 3531, '1', '1', '1', '1', '1', 'default', 2, '0'),
(29916, 'prison_crnr', 'prison_crnr', 's', 1, 1, 1, '1', '0', '0', 3528, '1', '1', '1', '1', '1', 'default', 1, '0');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Sql Catalog Code :
Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Palvelin: localhost
-- Luontiaika: 30.06.2010 klo 17:25
-- Palvelimen versio: 5.1.41
-- PHP:n versio: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Tietokanta: `ubercms`
--
-- --------------------------------------------------------
--
-- Rakenne taululle `catalog_items`
--
CREATE TABLE IF NOT EXISTS `catalog_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`page_id` int(11) NOT NULL,
`item_ids` varchar(120) NOT NULL,
`catalog_name` varchar(100) NOT NULL,
`cost_credits` int(11) NOT NULL,
`cost_pixels` int(11) NOT NULL,
`amount` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57024 ;
--
-- Vedos taulusta `catalog_items`
--
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(4964, 158, '20339', 'bw_water_1', 3, 0, 1),
(4965, 158, '20338', 'bw_tele', 5, 0, 1),
(4969, 158, '20339', 'bw_water_1', 60, 0, 100),
(29910, 158, '29910', 'bw_water_2', 5, 0, 1),
(57009, 158, '29904', 'bw_chair', 4, 0, 1),
(57010, 158, '29903', 'bw_sboard', 2, 0, 1),
(57011, 158, '29909', 'bw_fnc', 2, 0, 1),
(57012, 158, '29901', 'bw_lgchair', 5, 0, 1),
(57013, 158, '29908', 'bw_croc', 4, 0, 1),
(57014, 158, '29907', 'bw_bball', 2, 0, 1),
(57015, 158, '29906', 'bw_table', 3, 0, 1),
(57016, 159, '29916', 'prison_crnr', 4, 0, 1),
(57017, 159, '29913', 'prison_dvdr1', 5, 0, 1),
(57018, 159, '29912', 'prison_gate', 4, 0, 1),
(57019, 159, '29911', 'prison_dvdr2', 5, 0, 1),
(57020, 159, '29914', 'prison_stone', 1, 0, 1),
(57021, 159, '29915', 'prison_tower', 10, 0, 1),
(57022, 159, '29913', 'prison_dvdr1', 20, 0, 10),
(57023, 159, '29911', 'prison_dvdr2', 20, 0, 10);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Sql Katalog Page:
Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Palvelin: localhost
-- Luontiaika: 30.06.2010 klo 17:27
-- Palvelimen versio: 5.1.41
-- PHP:n versio: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Tietokanta: `ubercms`
--
-- --------------------------------------------------------
--
-- Rakenne taululle `catalog_pages`
--
CREATE TABLE IF NOT EXISTS `catalog_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '-1',
`caption` varchar(100) NOT NULL,
`icon_color` int(11) NOT NULL DEFAULT '1',
`icon_image` int(11) NOT NULL DEFAULT '1',
`visible` enum('0','1') NOT NULL DEFAULT '1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`min_rank` int(10) unsigned NOT NULL DEFAULT '1',
`club_only` enum('0','1') NOT NULL DEFAULT '0',
`coming_soon` enum('0','1') NOT NULL DEFAULT '0',
`order_num` int(11) NOT NULL,
`page_layout` enum('default_3x3','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_items','pets','club_gifts','pets2') NOT NULL DEFAULT 'default_3x3',
`page_headline` text NOT NULL,
`page_teaser` text NOT NULL,
`page_special` text NOT NULL,
`page_text1` text NOT NULL,
`page_text2` text NOT NULL,
`page_text_details` text NOT NULL,
`page_text_teaser` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=160 ;
--
-- Vedos taulusta `catalog_pages`
--
INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `coming_soon`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES
(158, 3, 'Beach', 1, 57, '1', '1', 1, '0', '0', 0, 'default_3x3', 'catalog_sports_headline1', 'ctlg_pet_teaser1', '', 'Ennenjulkaisemattomia tavaroita!', '', '', ''),
(159, 3, 'Prison', 2, 14, '1', '1', 1, '0', '0', 0, 'default_3x3', 'catalog_extra_headline1', 'catalog_extra_teaser1', 'catalog_special_txtbg2', 'Ennenjulkaisemattomat kamat!', '', 'Klikkaa tuotteen kuvaa niin näet lisätiedot', '');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Thema: R54 Sommer Furnis ! KOSTENLOOOS!!!! 
Mo Aug 16, 2010 3:50 pm
