23.02.2012, 15:10 (Dieser Beitrag wurde zuletzt bearbeitet: 26.08.2014, 09:54 von MyBB.de Bot.)
Eine neue Erweiterung wurde veröffentlicht: WoW Data
Zitat:This mod allows users to include links with tooltips in their forum posts, PMs etc. Usage is simple and robust. Simply use standard bracketed "tags" to include different data types. The currently supported tags are; character, guild, arena, and item. For example, to link a guild you can easily assume that the guild is on your server (which is a mod setting available in admin > settings > WoW Data) you simply type [guild]This Guild is Awesome[/guild] into a message and it is converted to a link to the guild page on battle.net and when the mouse is over the link a tooltip is displayed showing some basic guild information. To specify a different server (or "realm" as Blizzard calls them) you give the guild tag a parameter of "realm" and set it. E.g. [guild realm=Thrall]This Guild is Awesome[/guild].
Unique (so far) to this mod is the ability to specify a specific item when multiple items share the same name. This is done by passing an "ilevel" or difficulty. This is a little more complicated and I'd suggest using one or the other to avoid confusion among your users. The syntax for each is as follows: [item=Heroic]Hand of Morchok[/item] or [item ilevel=410]Hand of Morchok[/item]. These examples will result in identical output. Both were included as a precaution against Blizzard introducing more items with the same name not linked specifically to a difficulty level. Use whichever seems easier to explain to your users.
Feedback is appreciated! You can find us at the following link:
This software is provided 'as-is', without any express or implied
warranty. In no event will the authors be held liable for any damages
arising from the use of this software.
Permission is granted to anyone to use this software for any purpose,
including commercial applications, and to alter it and redistribute it
freely, subject to the following restrictions:
1. The origin of this software must not be misrepresented; you must not
claim that you wrote the original software. If you use this software
in a product, an acknowledgment in the product documentation would be
appreciated but is not required.
2. Altered source versions must be plainly marked as such, and must not be
misrepresented as being the original software.
3. This notice may not be removed or altered from any source distribution.
bin absolut neu bei MyBB zum ersten mal nutze ich die Software welche mir bei der Installation große Probleme bereitet hat. Aber habe es geschafft und alles läuft so, ganz gut.
Wollte nun ein Plugin installieren bekomme aber immer eine fehlermeldung:
Code:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1214 - The used table type doesn't support FULLTEXT indexes
Query:
CREATE TABLE IF NOT EXISTS `mybb_wowdata_cache` ( `wowdata_id` int(16) NOT NULL AUTO_INCREMENT COMMENT 'Primary key; numeric, auto increment', `code` varchar(75) NOT NULL COMMENT 'there are many [thing] codes which can be handled, they are stored here', `text_key` varchar(75) NOT NULL COMMENT 'between the [thing] codes comes text, this is where it is stored', `attribute_keys` varchar(75) NOT NULL COMMENT 'sometimes things aren`t 1:1, extended matching criteria go here', `external_id` int(16) DEFAULT NULL COMMENT 'items have an ID shared by wowhead and blizzard. This ID is stored here', `url` varchar(255) DEFAULT NULL COMMENT 'URL requested', `data` text COMMENT 'Cached Response', PRIMARY KEY (`wowdata_id`), UNIQUE KEY `code_keys` (`code`,`text_key`,`attribute_keys`,`external_id`), FULLTEXT KEY `data` (`data`) ) AUTO_INCREMENT=1
Hab es eben mal Local installiert und bekomme auch diese Meldung. Verwende mal meinen Anhang und lade diese Datei in den plugin Ordner, danach wie gewohnt F5 ggf installieren drücken.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1214 - The used table type doesn't support FULLTEXT indexes
Query:
CREATE TABLE`mybb_wowdata_cache` ( `wowdata_id` int(16) NOT NULL AUTO_INCREMENT COMMENT 'Primary key; numeric, auto increment', `code` varchar(75) NOT NULL COMMENT 'there are many [thing] codes which can be handled, they are stored here', `text_key` varchar(75) NOT NULL COMMENT 'between the [thing] codes comes text, this is where it is stored', `attribute_keys` varchar(75) NOT NULL COMMENT 'sometimes things aren`t 1:1, extended matching criteria go here', `external_id` int(16) DEFAULT NULL COMMENT 'items have an ID shared by wowhead and blizzard. This ID is stored here', `url` varchar(255) DEFAULT NULL COMMENT 'URL requested', `data` text COMMENT 'Cached Response', PRIMARY KEY (`wowdata_id`), UNIQUE KEY `code_keys` (`code`,`text_key`,`attribute_keys`,`external_id`), FULLTEXT KEY `data` (`data`) ) AUTO_INCREMENT=1
So funktioniert alles. Nur sobald ich in einem Thema einen gültigen verweiß poste komm ich nicht mehr in das Thema da immer folgende fehlermeldung kommt.
Code:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1146 - Table 'thewinneris_mybb.mybb_wowdata_cache' doesn't exist
Query:
SELECT `wowdata_id` ,`code`, `text_key`, `attribute_keys`, `external_id`, `url`, `data` FROM mybb_wowdata_cache WHERE `code` = 'character' AND `text_key` = 'Veneficus' AND `attribute_keys` LIKE 'realm=Ysera%'
Im Beitrag steht [character]Name[/character], sobald solch ein gültiger verweiß existiert keine zugriff mehr auf das Thema .
28.07.2013, 11:12 (Dieser Beitrag wurde zuletzt bearbeitet: 28.07.2013, 11:13 von MrBrechreiz.)
ja hab auch dies eben mal getestet. Ich denke dieses Plugin steckt noch in den Kinderschuhen, gehe ins ACP und deaktiviere + deinstalliere es. Dann doch lieber darauf verzichten als sich auf eine Odysee einzulassen.
Naja, würde das schon gern haben :x. Sehr gern sogar. Eigentlich scheitert alles daran das kein db eintrag getätigt wird. Kann man den nicht Manuel eintragen oder diesesn Code irgendwie umschreiben o.a?
Code:
function wowdata_installtables() {
global $mybb, $db;
// create cache table
$db->write_query("DROP TABLE IF EXISTS `".TABLE_PREFIX."wowdata_cache`");
$db->write_query("
CREATE TABLE`".TABLE_PREFIX."wowdata_cache` (
`wowdata_id` int(16) NOT NULL AUTO_INCREMENT COMMENT 'Primary key; numeric, auto increment',
`code` varchar(75) NOT NULL COMMENT 'there are many [thing] codes which can be handled, they are stored here',
`text_key` varchar(75) NOT NULL COMMENT 'between the [thing] codes comes text, this is where it is stored',
`attribute_keys` varchar(75) NOT NULL COMMENT 'sometimes things aren`t 1:1, extended matching criteria go here',
`external_id` int(16) DEFAULT NULL COMMENT 'items have an ID shared by wowhead and blizzard. This ID is stored here',
`url` varchar(255) DEFAULT NULL COMMENT 'URL requested',
`data` text COMMENT 'Cached Response',
PRIMARY KEY (`wowdata_id`),
UNIQUE KEY `code_keys` (`code`,`text_key`,`attribute_keys`,`external_id`),
FULLTEXT KEY `data` (`data`)
) AUTO_INCREMENT=1");
}
.