Simpler Hack, ersetzt die Titel in der Common.php mit denen in der Datenbank...
SQL:
$this->bbcode_second_pass_code('', ' -- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 04. März 2006 um 13:50 -- Server Version: 5.0.15 -- PHP-Version: 5.0.5 -- -- Datenbank: `lotgd` --
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `titles` --
CREATE TABLE `titles` ( `t_id` int(11) NOT NULL auto_increment, `neededdk` int(11) NOT NULL, `m_title` varchar(255) collate latin1_general_ci NOT NULL, `f_title` varchar(255) collate latin1_general_ci NOT NULL, PRIMARY KEY (`t_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=52 ;
-- -- Daten für Tabelle `titles` --
INSERT INTO `titles` VALUES (1, 0, 'Bauernjunge', 'Bauernmädchen'); INSERT INTO `titles` VALUES (2, 1, 'Knecht', 'Magd'); INSERT INTO `titles` VALUES (3, 2, 'Bauer', 'Bäuerin'); INSERT INTO `titles` VALUES (4, 3, 'Grossbauer', 'Grossbäuerin'); INSERT INTO `titles` VALUES (5, 4, 'Spurenleser', 'Spurenleserin'); INSERT INTO `titles` VALUES (6, 5, 'Jäger', 'Jägerin'); INSERT INTO `titles` VALUES (7, 6, 'Gutshofverwalter', 'Gutshofverwalterin'); INSERT INTO `titles` VALUES (8, 7, 'Gutsherr', 'Gutsherrin'); INSERT INTO `titles` VALUES (9, 8, 'Bürger', 'Bürgerin'); INSERT INTO `titles` VALUES (10, 9, 'Gladiator', 'Gladiatorin'); INSERT INTO `titles` VALUES (11, 10, 'Legionär', 'Legionärin'); INSERT INTO `titles` VALUES (12, 11, 'Centurio', 'Centurioness'); INSERT INTO `titles` VALUES (13, 12, 'Meister', 'Meisterin'); INSERT INTO `titles` VALUES (14, 13, 'Ratsherr', 'Ratsherrin'); INSERT INTO `titles` VALUES (15, 14, 'Verwalter', 'Verwalterin'); INSERT INTO `titles` VALUES (16, 15, 'Bürgermeister', 'Bürgermeisterin'); INSERT INTO `titles` VALUES (17, 16, 'Major', 'Major'); INSERT INTO `titles` VALUES (18, 17, 'General', 'General'); INSERT INTO `titles` VALUES (19, 18, 'Edler', 'Edle'); INSERT INTO `titles` VALUES (20, 19, 'Ritter', 'Ritterin'); INSERT INTO `titles` VALUES (21, 20, 'Junker', 'Junkerin'); INSERT INTO `titles` VALUES (22, 21, 'Freiherr', 'Freifrau'); INSERT INTO `titles` VALUES (23, 22, 'Baron', 'Baronin'); INSERT INTO `titles` VALUES (24, 23, 'Fürst', 'Fürstin'); INSERT INTO `titles` VALUES (25, 24, 'Grossfürst', 'Grossfürstin'); INSERT INTO `titles` VALUES (26, 25, 'Herzog', 'Herzogin'); INSERT INTO `titles` VALUES (27, 26, 'Graf', 'Gräfin'); INSERT INTO `titles` VALUES (28, 27, 'Prinz', 'Prinzessin'); INSERT INTO `titles` VALUES (29, 28, 'Kronprinz', 'Kronprinzessin'); INSERT INTO `titles` VALUES (30, 29, 'König', 'Königin'); INSERT INTO `titles` VALUES (31, 30, 'Kaiser', 'Kaiserin'); INSERT INTO `titles` VALUES (32, 31, 'Drachentöter', 'Drachentöterin'); INSERT INTO `titles` VALUES (33, 32, 'Bischof', 'Bischöfin'); INSERT INTO `titles` VALUES (34, 33, 'Papst', 'Päpstin'); INSERT INTO `titles` VALUES (35, 34, 'Seele', 'Seele'); INSERT INTO `titles` VALUES (36, 35, 'Seliger', 'Selige'); INSERT INTO `titles` VALUES (37, 36, 'Heiliger', 'Heilige'); INSERT INTO `titles` VALUES (38, 37, 'Engel', 'Engel'); INSERT INTO `titles` VALUES (39, 38, 'Erzengel', 'Erzengel'); INSERT INTO `titles` VALUES (40, 39, 'Kraft', 'Kraft'); INSERT INTO `titles` VALUES (41, 40, 'Macht', 'Macht'); INSERT INTO `titles` VALUES (42, 41, 'Herrschaft', 'Herrschaft'); INSERT INTO `titles` VALUES (43, 42, 'Thron', 'Throness'); INSERT INTO `titles` VALUES (44, 43, 'Seraphim', 'Seraphim'); INSERT INTO `titles` VALUES (45, 44, 'Cherubim', 'Cherubim'); INSERT INTO `titles` VALUES (46, 45, 'Titan', 'Titanin'); INSERT INTO `titles` VALUES (47, 46, 'Erztitan', 'Erztitanin'); INSERT INTO `titles` VALUES (48, 47, 'Unsterblicher', 'Unsterbliche'); INSERT INTO `titles` VALUES (49, 48, 'Halbgott', 'Halbgöttin'); INSERT INTO `titles` VALUES (50, 49, 'Untergott', 'Untergöttin'); INSERT INTO `titles` VALUES (51, 50, 'Gott', 'Göttin');
')
dann, öffne common.php, suche (kann anders sein!):
[php]
$titles = array(
0=>array("Bauernjunge","Bauernmädchen"),
1=>array("Knecht", "Magd"),
2=>array("Bauer", "Bäuerin"),
3=>array("Grossbauer", "Grossbäuerin"),
4=>array("Spurenleser","Spurenleserin"),
5=>array("Jäger","Jägerin"),
6=>array("Gutshofverwalter","Gutshofverwalterin"),
7=>array("Gutsherr","Gutsherrin"),
8=>array("Bürger","Bürgerin"),
9=>array("Gladiator","Gladiatorin"),
10=>array("Legionär","Legionärin"),
11=>array("Centurio","Centurioness"),
12=>array("Meister","Meisterin"),
13=>array("Ratsherr", "Ratsfrau"),
14=>array("Verwalter","Verwalterin"),
15=>array("Bürgermeister", "Bürgermeisterin"),
16=>array("Major", "Major"),
17=>array("General", "General"),
18=>array("Edler", "Edle"),
19=>array("Ritter", "Ritterin"),
20=>array("Junker", "Junkerin"),
21=>array("Freiherr", "Freifrau"),
22=>array("Baron", "Baronin"),
23=>array("Fürst", "Fürstin"),
24=>array("Grossfürst", "Grossfürstin"),
25=>array("Herzog", "Herzogin"),
26=>array("Graf", "Gräfin"),
27=>array("Prinz", "Prinzessin"),
28=>array("Kronprinz", "Kronprinzessin"),
29=>array("König", "Königin"),
30=>array("Kaiser", "Kaiserin"),
31=>array("Drachentöter","Drachentöterin"),
32=>array("Bischof","Bischöfin"),
33=>array("Papst", "Päpstin"),
34=>array("Seele", "Seele"),
35=>array("Seliger", "Selige"),
36=>array("Heiliger", "Heilige"),
37=>array("Engel", "Engel"),
38=>array("Erzengel", "Erzengel"),
39=>array("Kraft", "Kraft"),
40=>array("Macht", "Macht"),
41=>array("Herrschaft", "Herrschaft"),
42=>array("Thron", "Thron"),
43=>array("Seraphim", "Seraphim"),
44=>array("Cherubim", "Cherubim"),
45=>array("Titan","Titanin"),
46=>array("Erztitan","Erztitanin"),
47=>array("Halbgott", "Halbgöttin"),
48=>array("Untergott","Untergöttin")
);
[/php]
, ersetze vollständig mit:
[php]
/* Titles *\
\* by Hadriel */
$titles = array();
define('SQL_CACHE','*'); // '*' or 'SQL_CACHE *'
$titlequery = "SELECT ".SQL_CACHE." FROM titles";
$titleres = mysql_query($titlequery);
while($ttrow = mysql_fetch_assoc($titleres)){
$titles[$ttrow['neededdk']] = array($ttrow['m_title'],$ttrow['f_title']);
//output($ttrow[neededdk]." => ".$ttrow[m_title].",".$ttrow[f_title]."`n");
}
/* *\
\* Ende */
[/php]
kann evtl datenbanklastig sein, je nach ort.
mfg Hadriel
_________________ R.I.P.
†26.7.2004 - 20.3.2006†
†MeteorA†
|