anpera.net

$this->bbcode_second_pass_code('', '
//20050708

/*
* Local changes:
*
# gold transfer:
INSERT INTO housemoduledata (moduleid, name, houseid, value)
SELECT {id-of-treasury}, 'gold', houseid, gold FROM houses WHERE status=1;
INSERT INTO housemoduledata (moduleid, name, houseid, value)
SELECT {id-of-treasury}, 'gems', houseid, gems FROM houses WHERE status=1;

INSERT INTO `houseconfig` ( `locid` , `location` , `locname` , `buy` , `sell` , `build` , `rob` , `defaultgoldprice` , `defaultgemprice` , `buildprice_increase` )
VALUES (
'', 'village.php', 'Wohnviertel', '1', '1', '1', '1', '30000', '50', '5'
);

ALTER TABLE `houses` CHANGE `status` `status` ENUM( 'build', 'ready', 'sell' ) DEFAULT 'build' NOT NULL,
CHANGE `gold` `goldprice` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
CHANGE `gems` `gemprice` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `location` `locid` INT( 10 ) UNSIGNED DEFAULT '1' NOT NULL;
UPDATE `houses` SET `locid`=1;
# this will delete all stored gold; warn the people! ;)
UPDATE `houses` SET `status`='ready' WHERE `status`='build';
UPDATE `houses` SET `status`='build' WHERE `status`='' OR owner=0;
UPDATE `houses` SET `goldprice`=0,`gemprice`=0 WHERE `status`!='build';
UPDATE `houses` SET `goldprice`=30000-`goldprice`, `gemprice`=50-`gemprice` WHERE `status`='build';
*
*
*/

/******************************************
*
* Author: Daniel Rathjen <webmaster@chaosonline.de>
* Version: 1.0
* Server: biosLoGD Experimental Server
* URL: http://logd.chaosonline.de
*
* This is a rewrite of anpera's houses script:
* Author: anpera
* Email:logd@anpera.de
* URL: http://www.anpera.net/forum/viewtopic.php?t=323
* This script still consists of his ideas and parts of his code, so all homages to him please ;)
*
* Purpose: Same as the old houses script...
*
* Features:
* - Build house (if allowed)
* - Buy house (if allowed)
* - Sell house (if allowed)
* - Sleeping in a house
* - Storing gold in a house (module 'treasury')
* - Adding useful modules (rooms)
*
* Some important information:
*
#
# Tabellenstruktur für Tabelle `houseconfig`
#
DROP TABLE IF EXISTS `houseconfig`;
CREATE TABLE `houseconfig` (
`locid` int(10) unsigned NOT NULL auto_increment,
`location` varchar(255) NOT NULL default 'village.php',
`locname` varchar(50) NOT NULL default 'Wohnviertel',
`buy` enum('0','1') NOT NULL default '0',
`sell` enum('0','1') NOT NULL default '0',
`build` enum('0','1') NOT NULL default '0',
`rob` enum('0','1') NOT NULL default '0',
`defaultgoldprice` int(10) unsigned NOT NULL default '30000',
`defaultgemprice` int(10) unsigned NOT NULL default '50',
`buildprice_increase` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`locid`)
) TYPE=MyISAM COMMENT='Konfiguration der Wohnanlagen - was ist erlaubt?';

#
# Tabellenstruktur für Tabelle `housemodules`
#
CREATE TABLE `housemodules` (
`moduleid` int(10) unsigned NOT NULL auto_increment,
`modulefile` varchar(50) NOT NULL default 'default.php',
`modulename` varchar(50) NOT NULL default 'living_room',
`moduleauthor` varchar(50) NOT NULL default '',
`moduleversion` varchar(20) NOT NULL default '',
`built_in` enum('0','1') NOT NULL default '1',
`linkcategory` varchar(50) NOT NULL default 'Räume',
`linktitle` varchar(50) NOT NULL default '',
`linkorder` smallint(3) unsigned NOT NULL default '1',
`showto` SET( 'owner', 'guest' ) DEFAULT 'owner,guest' NOT NULL,
PRIMARY KEY (`moduleid`),
UNIQUE `modulename` (`modulename`),
KEY `built_in` (`built_in`),
KEY `linkorder` (`linkorder`),
KEY `showto` (`showto`)
) TYPE=MyISAM COMMENT='Module der Häuser';
#
# Tabellenstruktur für Tabelle `housemoduledata`
#
# Predefined names:
# - #activated# (together with houseid: value=1 if module is built-in in the house
#
CREATE TABLE `housemoduledata` (
`moduleid` int(10) unsigned NOT NULL,
`name` varchar(50) NOT NULL default '',
`houseid` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NULL,
PRIMARY KEY (`moduleid`,`name`,`houseid`)
) TYPE=MyISAM COMMENT='Moduldaten für die Häuser';
#
# Tabellenstruktur für Tabelle `houses`
#
DROP TABLE IF EXISTS `houses`;
CREATE TABLE `houses` (
`houseid` int(10) unsigned NOT NULL auto_increment,
`owner` int(10) unsigned NOT NULL default '0',
`status` enum('build','sell','ready') NOT NULL default 'build',
`goldprice` int(10) unsigned NOT NULL default '30000',
`gemprice` int(10) unsigned NOT NULL default '50',
`housename` varchar(25) default NULL,
`description` text NOT NULL default '',
`locid` int(10) UNSIGNED NOT NULL default '1',
PRIMARY KEY (`houseid`),
KEY `locid` (`locid`),
KEY `owner` (`owner`)
) TYPE=MyISAM;
#
# Daten für Tabelle `settings`
#
INSERT INTO `settings` VALUES
('startbuild','0'),
('mindkbuild','1'),
('minlevelbuild','5'),
('defaulthousemodule','1');

*
*
* pet-update 20041212:
*

ALTER TABLE `accounts`
ADD `petid` INT UNSIGNED NOT NULL AFTER `hashorse`,
ADD `petfeed` DATETIME NOT NULL AFTER `petid` ;

INSERT INTO `items` (`id`, `name`, `class`, `owner`, `value1`, `value2`, `gold`, `gems`, `description`, `hvalue`, `buff`) VALUES (241, 'Kleiner Wachdackel', 'Haust.Prot', 0, 100, 0, 5000, 15, 'Ein niedlicher kleiner Dackel, der Einbrecher erschreckt.', 0, 'a:4:{s:4:"name";s:14:"Lautes Kläffen";s:6:"atkmod";s:2:"20";s:6:"defmod";s:2:"20";s:5:"regen";s:3:"100";}');
INSERT INTO `items` (`id`, `name`, `class`, `owner`, `value1`, `value2`, `gold`, `gems`, `description`, `hvalue`, `buff`) VALUES (242, 'Großer Haushund', 'Haust.Prot', 0, 0, 1, 15000, 30, 'Ein großer Wachhund, der Haus und Herrchen zu schützen weiß.', 0, 'a:4:{s:4:"name";s:11:"Bissattacke";s:6:"atkmod";s:2:"30";s:6:"defmod";s:2:"30";s:5:"regen";s:3:"150";}');
INSERT INTO `items` (`id`, `name`, `class`, `owner`, `value1`, `value2`, `gold`, `gems`, `description`, `hvalue`, `buff`) VALUES (243, 'Ausgewachsener Kampfhund', 'Haust.Prot', 0, 100, 1, 25000, 45, 'Ein riesiger Kampfhund, der bereit ist, jeden Eindringling sofort zu zerfleischen.', 0, 'a:4:{s:4:"name";s:21:"Wütendes Zerfleischen";s:6:"atkmod";s:2:"40";s:6:"defmod";s:2:"40";s:5:"regen";s:3:"200";}');

*
******************************************/')

ich komm dmait voll nich klar bei dme allerersten wa sganz oben steht kommt das die tabele nicht exestieren würde ....

_________________

ich würd vielleicht erstmal die tabellen erstellen...

_________________
R.I.P.
†26.7.2004 - 20.3.2006†
†MeteorA†

ja mit welchem teil sll ich anfnagen dem unteren oder dem oberen?

_________________

des gibt alles aber wir haben problem immer noch mit dem wohnviertel*gruml* daher manche sql befhele nit gehn -......-

_________________

so heir genau mein PRoblem


ch habe ein problem mit den Zeilen:

# gold transfer:
INSERT INTO housemoduledata (moduleid, name, houseid, value)
SELECT {id-of-treasury}, 'gold', houseid, gold FROM houses WHERE status=1;
INSERT INTO housemoduledata (moduleid, name, houseid, value)
SELECT {id-of-treasury}, 'gems', houseid, gems FROM houses WHERE status=1;

Mein SQL nimm diese zeile mit der Begründung:
SQL-Befehl: Dokumentation

# gold transfer:
INSERT INTO housemoduledata( moduleid, name, houseid, value )
SELECT {id - of - treasury}, 'gold', houseid, gold
FROM houses
WHERE STATUS =1

MySQL meldet: Dokumentation
#1054 - Unknown column 'of' in 'field list'

weiß jemand was wir da machen können?

_________________

omfg -.-

{id - of - treasury} musst du mit der modulid des schatzraummoduls ersetzen! learn english!

_________________
R.I.P.
†26.7.2004 - 20.3.2006†
†MeteorA†