Netweasel Antfarm
Freund/in des Forums
sind aber 15 stück in dem ordner "sql_update" die müssen alle importiert werden
Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature may not be available in some browsers.
ok, muss ich dann in der config.php eine Pfadangabe bezüglich der opensim datenbank machen ???
Database error: Invalid SQL: SELECT regionName,regionHandle FROM regions ORDER BY regionName ASC
MySQL error: 1146 (Table 'meineDBname.regions' doesn't exist)
Session halted.
Database error: Invalid SQL: SELECT count(*) FROM regions
MySQL error: 1146 (Table 'meinDBname.regions' doesn't exist)
Session halted.
--
-- Tabellenstruktur für Tabelle `regions`
--
CREATE TABLE IF NOT EXISTS `regions` (
`uuid` varchar(36) NOT NULL,
`regionHandle` bigint(20) unsigned NOT NULL,
`regionName` varchar(32) DEFAULT NULL,
`regionRecvKey` varchar(128) DEFAULT NULL,
`regionSendKey` varchar(128) DEFAULT NULL,
`regionSecret` varchar(128) DEFAULT NULL,
`regionDataURI` varchar(255) DEFAULT NULL,
`serverIP` varchar(64) DEFAULT NULL,
`serverPort` int(10) unsigned DEFAULT NULL,
`serverURI` varchar(255) DEFAULT NULL,
`locX` int(10) unsigned DEFAULT NULL,
`locY` int(10) unsigned DEFAULT NULL,
`locZ` int(10) unsigned DEFAULT NULL,
`eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`regionAssetURI` varchar(255) DEFAULT NULL,
`regionAssetRecvKey` varchar(128) DEFAULT NULL,
`regionAssetSendKey` varchar(128) DEFAULT NULL,
`regionUserURI` varchar(255) DEFAULT NULL,
`regionUserRecvKey` varchar(128) DEFAULT NULL,
`regionUserSendKey` varchar(128) DEFAULT NULL,
`regionMapTexture` varchar(36) DEFAULT NULL,
`serverHttpPort` int(10) DEFAULT NULL,
`serverRemotingPort` int(10) DEFAULT NULL,
`owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
`originUUID` varchar(36) DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `regionName` (`regionName`),
KEY `regionHandle` (`regionHandle`),
KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
--
-- Daten für Tabelle `regions`
--
CREATE TABLE IF NOT EXISTS `regions` (
`uuid` varchar(36) NOT NULL,
`regionHandle` bigint(20) unsigned NOT NULL,
`regionName` varchar(32) DEFAULT NULL,
`regionRecvKey` varchar(128) DEFAULT NULL,
`regionSendKey` varchar(128) DEFAULT NULL,
`regionSecret` varchar(128) DEFAULT NULL,
`regionDataURI` varchar(255) DEFAULT NULL,
`serverIP` varchar(64) DEFAULT NULL,
`serverPort` int(10) unsigned DEFAULT NULL,
`serverURI` varchar(255) DEFAULT NULL,
`locX` int(10) unsigned DEFAULT NULL,
`locY` int(10) unsigned DEFAULT NULL,
`locZ` int(10) unsigned DEFAULT NULL,
`eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
`regionAssetURI` varchar(255) DEFAULT NULL,
`regionAssetRecvKey` varchar(128) DEFAULT NULL,
`regionAssetSendKey` varchar(128) DEFAULT NULL,
`regionUserURI` varchar(255) DEFAULT NULL,
`regionUserRecvKey` varchar(128) DEFAULT NULL,
`regionUserSendKey` varchar(128) DEFAULT NULL,
`regionMapTexture` varchar(36) DEFAULT NULL,
`serverHttpPort` int(10) DEFAULT NULL,
`serverRemotingPort` int(10) DEFAULT NULL,
`owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
`originUUID` varchar(36) DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `regionName` (`regionName`),
KEY `regionHandle` (`regionHandle`),
KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
CREATE TABLE `wi_users` (
`UUID` varchar(36) NOT NULL default '',
`username` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`passwordHash` varchar(32) NOT NULL,
`passwordSalt` varchar(32) NOT NULL,
`realname1` varchar(255) NOT NULL,
`realname2` varchar(255) NOT NULL,
`adress1` varchar(255) NOT NULL,
`zip1` varchar(255) NOT NULL,
`city1` varchar(255) NOT NULL,
`country1` varchar(255) NOT NULL,
`emailadress` varchar(255) NOT NULL,
`agentIP` varchar(255) NOT NULL,
`active` varchar(255) NOT NULL default '1',
PRIMARY KEY (`UUID`),
UNIQUE KEY `usernames` (`username`,`lastname`)
) TYPE=MyISAM;
CREATE TABLE `wi_startscreen_infowindow` (
`gridstatus` varchar(255) NOT NULL,
`active` varchar(30) NOT NULL,
`color` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`message` text NOT NULL
) TYPE=MyISAM;
INSERT INTO `wi_startscreen_infowindow` (`gridstatus`, `active`, `color`, `title`, `message`) VALUES
('1', '1', 'yellow', 'Info system Works very well ;-)', 'Today we''ve built a new loginscreen info system and it works very well. You can now see Info windows on the startup screen.');
CREATE TABLE `wi_codetable` (
`UUID` varchar(36) NOT NULL,
`code` varchar(255) NOT NULL,
`info` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL
) TYPE=MyISAM;
CREATE TABLE `wi_pagemanager` (
`id` int(15) NOT NULL auto_increment,
`code` varchar(255) NOT NULL,
`sitename` varchar(255) NOT NULL,
`content` text NOT NULL,
`rank` varchar(30) NOT NULL,
`type` varchar(30) NOT NULL,
`active` varchar(30) NOT NULL,
`url` text NOT NULL,
`target` varchar(255) NOT NULL,
`display` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
INSERT INTO `wi_pagemanager` (`id`, `code`, `sitename`, `content`, `rank`, `type`, `active`, `url`, `target`, `display`) VALUES
(1, '1211831857', 'Home', '<p> </p>\r\n<table height="100%" cellspacing="0" cellpadding="0" width="100%" border="0">\r\n <tbody>\r\n <tr>\r\n <td valign="top" width="63%" height="204">\r\n <table height="195" cellspacing="0" cellpadding="5" width="90%" align="center" bgcolor="#ffffff" border="0">\r\n <tbody>\r\n <tr>\r\n <td valign="top">\r\n <p><strong>Welcome to the new Opensimwi Redux !</strong><br />\r\n <br />\r\n Create an Free Account today and Play in our World.<br />\r\n Our World is created by its Residents, you can build everything in here.<br />\r\n Meet Peoples, Chat, Play, Everything is possible in our brandnew 3D World.</p>\r\n <p>Beside you see the Status of our System -> <br />\r\n <br />\r\n Enjoy it. :-)</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td valign="top" colspan="2"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td width="33%"> </td>\r\n <td width="3%"> </td>\r\n </tr>\r\n </tbody>\r\n</table>', '1', '1', '1', 'index.php?page=home', '_self', '2'),
(2, '1211831897', 'Change Account', '', '2', '1', '1', 'index.php?page=change', '_self', '1'),
(3, '1211831925', 'Gridstatus', '', '3', '1', '1', 'index.php?page=gridstatus', '_self', '2'),
(4, '1211832121', 'Transaction History', '', '4', '1', '1', 'index.php?page=transactions', '_self', '1'),
(5, '1213729504', 'Region List', '', '5', '1', '1', 'index.php?page=regions', '_self', '2'),
(6, '1213811351', 'World Map', '', '6', '1', '1', 'index.php?page=map', '_self', '2'),
(7, '1211832149', 'Create Account', '', '7', '1', '1', 'index.php?page=create', '_self', '0'),
(8, '1211832173', 'Logout', '', '8', '1', '1', 'index.php?page=logout', '_self', '1');
CREATE TABLE `wi_statistics` (
`serverIP` varchar(64) NOT NULL,
`serverPort` int(11) NOT NULL,
`version` varchar(255) NOT NULL,
`lastcheck` int(10) NOT NULL,
`failcounter` int(11) NOT NULL,
UNIQUE KEY `serverIP` (`serverIP`,`serverPort`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `wi_adminsetting` (
`id` int(11) NOT NULL auto_increment,
`startregion` varchar(255) NOT NULL,
`userdir` varchar(255) NOT NULL,
`griddir` varchar(255) NOT NULL,
`assetdir` varchar(255) NOT NULL,
`lastnames` varchar(10) NOT NULL,
`adress` varchar(32) NOT NULL,
`region` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `wi_adminsetting` (`id`, `startregion`, `userdir`, `griddir`, `assetdir`, `lastnames`, `adress`, `region`) VALUES
(1, '', '', '', '', '0', '0', '0');
CREATE TABLE `wi_banned` (
`UUID` varchar(36) NOT NULL,
`agentIP` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL
) TYPE=MyISAM;
CREATE TABLE `wi_lastnames` (
`name` varchar(255) NOT NULL,
`active` varchar(255) NOT NULL default '1'
) TYPE=MyISAM;
INSERT INTO `wi_lastnames` (`name`, `active`) VALUES
('Binder', '1'),
('Noel', '1'),
('Young', '1'),
('Roux', '1'),
('Allen', '1'),
('Heron', '1'),
('Mansworld', '1'),
('Babbi', '1'),
('Crazys', '1'),
('Linden', '1'),
('Machlam', '1'),
('Notringham', '1'),
('Opus', '1'),
('Hausermann', '1'),
('McLachlan', '1'),
('McKinsey', '1'),
('Pohl', '1'),
('Schwarzenegger', '1'),
('Mueller', '1'),
('Nosemann', '1'),
('Obolus', '1'),
('Himbaer', '1'),
('Nala', '1'),
('Kandee', '1'),
('Bauer', '1'),
('Simons', '1'),
('Raptor', '1'),
('Maek', '1'),
('Huss', '1'),
('Mondial', '1'),
('Moondancer', '1'),
('Sweetheart', '1'),
('Schnuggy', '1'),
('Swindlehurst', '1'),
('Baumeister', '1'),
('Bloomberg', '1'),
('Dredd', '1'),
('Gridlock', '1'),
('Bohlen', '1'),
('Snapper', '1'),
('Tickle', '1'),
('Ewing', '1'),
('Schwinge', '1'),
('Nonsito', '1');
CREATE TABLE `wi_admin` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `wi_admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '84e78b596fa8e391c49f3c4df7b9c57f'); -- No, we dont know what the default admin password is. You'll have to change it when you get logged in ;)
CREATE TABLE `wi_economy_transactions` (
`id` int(11) NOT NULL auto_increment,
`sourceId` varchar(36) NOT NULL,
`destId` varchar(36) NOT NULL,
`amount` int(11) NOT NULL default '0',
`flags` int(11) NOT NULL default '0',
`aggregatePermInventory` int(11) NOT NULL default '0',
`aggregatePermNextOwner` int(11) NOT NULL default '0',
`description` varchar(256) default NULL,
`transactionType` int(11) NOT NULL default '0',
`timeOccurred` int(11) NOT NULL,
`RegionGenerated` varchar(36) NOT NULL,
`IPGenerated` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `wi_startscreen_news` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`message` text NOT NULL,
`time` int(10) unsigned NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `wi_startscreen_news` (`id`, `title`, `message`, `time`) VALUES
(1, '[COMPLETE] The new loginscreen is done and works fine so far', '<P>We built a new loginscreen which will inform you about Grid updates or changes. Also you can now see how many users and regions are online, and more. Also, you may from time to time see an infowindow, which informs you about important news. Have Fun !</P>', 1211321439);
CREATE TABLE `wi_regions` (
`serverIP` varchar(64) NOT NULL,
`serverPort` int(11) NOT NULL,
`regionMapTexture` varchar(255) NOT NULL,
`locX` int(11) NOT NULL,
`locY` int(11) NOT NULL,
`lastcheck` int(10) NOT NULL,
`failcounter` int(11) NOT NULL,
UNIQUE KEY `serverURI` (`serverIP`,`regionMapTexture`)
) TYPE=MyISAM;
CREATE TABLE `wi_economy_money` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CentsPerMoneyUnit` float NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `wi_economy_money` (`id`, `CentsPerMoneyUnit`) VALUES (1, 0.386);
CREATE TABLE `wi_country` (
`name` varchar(100) NOT NULL
) TYPE=MyISAM;
INSERT INTO `wi_country` (`name`) VALUES
('Albania'),
('Belgium'),
('Bosnia'),
('Bulgaria'),
('Germany'),
('Denmark'),
('Estonia'),
('Finland'),
('France'),
('Georgia'),
('Greece'),
('United Kingdom'),
('Ireland'),
('Iceland'),
('Italy'),
('Croatia'),
('Latvia'),
('Lithuania'),
('Luxembourg'),
('Malta'),
('Macedonia'),
('Moldova'),
('Netherlands'),
('Norway'),
('Poland'),
('Portugal'),
('Romania'),
('Russia'),
('Sweden'),
('Switzerland'),
('Serbia & Montenegro'),
('Slovakia'),
('Slovenia'),
('Espana'),
('Czech Rep.'),
('Turkey'),
('Ukraine'),
('Hungary'),
('Belarus'),
('Cyprus'),
('Austria'),
('Afghanistan'),
('Armenia'),
('Azerbaijan'),
('Bangladesh'),
('Bhutan'),
('Brunei'),
('India'),
('Indonesia'),
('Japan'),
('Cambodia'),
('Kazakhstan'),
('Kyrgyzstan'),
('Laos'),
('Malaysia'),
('Maldives'),
('Mongolia'),
('Myanmar'),
('Nepal'),
('North Korea'),
('Pakistan'),
('Philippines'),
('Singapore'),
('Sri Lanka'),
('South Korea'),
('Tajikistan'),
('Taiwan'),
('Thailand'),
('Turkmenistan'),
('Uzbekistan'),
('Viet Nam'),
('Canada'),
('Mexico'),
('USA'),
('Antigua und Barbuda'),
('Aruba'),
('Bahamas'),
('Barbados'),
('Belize'),
('Bermuda'),
('Cayman Islands'),
('Costa Rica'),
('Curacao'),
('Dominica'),
('Dominican Rep.'),
('El Salvador'),
('Grenada'),
('Guadeloupe'),
('Guatemala'),
('Haiti'),
('Honduras'),
('Jamaica'),
('Virgin Islands'),
('Cuba'),
('Martinique'),
('Nicaragua'),
('Panama'),
('Puerto Rico'),
('St. Kitts und Nevis'),
('St. Lucia'),
('St. Maarten'),
('St. Vincent & Grenadin'),
('Trinidad & Tobago'),
('Argentina'),
('Bolivia'),
('Brazil'),
('Chile'),
('Ecuador'),
('Guyana'),
('Colombia'),
('Paraguay'),
('Peru'),
('Suriname'),
('Uruguay'),
('Venezuela'),
('Australia'),
('Fiji'),
('Marshall Islands'),
('Micronesia'),
('Nauru'),
('New Zealand'),
('Palau'),
('Papua New Guinea'),
('Samoa'),
('Tonga'),
('Tuvalu'),
('Vanuatu'),
('Bahrain'),
('Iraq'),
('Iran'),
('Israel'),
('Yemen'),
('Jordan'),
('Quatar'),
('Kuwait'),
('Lebanon'),
('Oman'),
('Palestinian authority'),
('Saudi Arabia'),
('Syria'),
('U.A.E.'),
('Algeria'),
('Angola'),
('Benin'),
('Botswana'),
('Burkina Faso'),
('Burundi'),
('Dem. Rep. of the Congo'),
('Djibouti'),
('Céte d''Ivoire'),
('Eritrea'),
('Gabun'),
('Gambia'),
('Ghana'),
('Guinea'),
('Guinea-Bissau'),
('Cameroon'),
('Cape Verde'),
('Kenya'),
('Lesotho'),
('Liberia'),
('Libya'),
('Madagascar'),
('Malawi'),
('Mali'),
('Morocco'),
('Mauritania'),
('Mauritius'),
('Mozambique'),
('Namibia'),
('Niger'),
('Nigeria'),
('Dem. Rep. of the Congo'),
('Zambia'),
('Sao Tomé and Principe'),
('Senegal'),
('Seychelles'),
('Sierra Leone'),
('Simbabwe'),
('Somalia'),
('Sudan'),
('Swaziland'),
('South Africa'),
('Tanzania'),
('Togo'),
('Chad'),
('Tunisia'),
('Uganda'),
('Central African Rep.'),
('Egypt'),
('Guinea Equatorial'),
('Ethiopia'),
('La Réunion'),
('Solomon Islands'),
('French Guiana');
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE `wi_offline_msgs` (
`uuid` varchar(36) NOT NULL,
`message` text NOT NULL,
KEY `uuid` (`uuid`)
) ENGINE=MyISAM
mysql -p -u root opensim < c:\wi_tabellen.sql
Re: the interface on a standalone
Postby nebadon on Wed Jul 29, 2009 11:16 am
This interface only works on grid mode running along side the UGAIM services, and is not designed for and will not work with Standalone mode, as of right now there are no web interface modules that work with standalone.