Context Navigation

Changeset 68

Timestamp:

10/29/07 11:41:39 (6 years ago)

Author:

d0nut

Message:

optimized the tagging wbb package (especially the system tagger)

Location:

taggingreloaded/optionals/de.easy-coding.wbb.taggingreloaded

Files:

r59	r68
74	74	JOIN wbb".WBB_N."_post p
75	75	ON wbb.postID = p.postID
76		WHERE userID = -1
	76	WHERE userID = {$systemTaggerUserID}
77	77	AND p.threadID = {$threadID};";
78	78
…	…
80	80
81	81	if(count($tags) > 0) {
82		// INSERT tagging<->post
83		$sql = "INSERT INTO wbb".WBB_N."_taggingreloaded
84		(postID)
85		VALUES ({$first_post});";
	82	$sql = "SELECT taggingID
	83	FROM wbb".WBB_N."_taggingreloaded
	84	WHERE postID = {$first_post};";
	85	$row = WCF::getDB()->getFirstRow($sql);
	86
	87	// is there an tagging entry?
	88	if(isset($row['taggingID'])) {
	89	$taggingID = $row['taggingID'];
	90	} else {
	91	// INSERT tagging<->post
	92	$sql = "INSERT INTO wbb".WBB_N."_taggingreloaded
	93	(postID)
	94	VALUES ({$first_post});";
86	95
87		WBBCore::getDB()->sendQuery($sql);
88		$taggingID = WBBCore::getDB()->getInsertID();
	96	WBBCore::getDB()->sendQuery($sql);
	97	$taggingID = WBBCore::getDB()->getInsertID();
	98	}
89	99
90	100	// save tags
…	…
94	104	}
95	105	}
96
97		$sql = "UPDATE wbb1_1_post SET systemTagged = 1 WHERE threadID IN (".implode(',', $threadIDs)."); ";
	106
	107	$sql = "UPDATE wbb1_1_post
	108	SET
	109	systemTagged = 1
	110	WHERE threadID IN (".implode(',', $threadIDs)."); ";
	111	WBBCore::getDB()->sendQuery($sql);
98	112
99	113	$this->executed();

r59	r68
1	1	<?php
2	2	require_once(WCF_DIR.'lib/data/cronjobs/Cronjob.class.php');
3		require_once(W~~CF_DIR.'lib/util/MapDiscover~~.class.php');
	3	require_once(WBB_DIR.'lib/acp/action/UpdateTaggingReloaded.class.php');
4	4
5	5	/**

r59	r68
18	18	<requiredpackage minversion="1.0.0">com.woltlab.wcf</requiredpackage>
19	19	<requiredpackage minversion="3.0.0">com.woltlab.wbb</requiredpackage>
20		<requiredpackage minversion="0.4.0">de.easy-coding.wcf.taggingreloaded</requiredpackage>
	20	<requiredpackage minversion="0.3.0">de.easy-coding.wcf.taggingreloaded</requiredpackage>
21	21	</requiredpackages>
22	22
…	…
28	28	<cronjobs>cronjobs.xml</cronjobs>
29	29	</instructions>
	30
	31	<instructions type="update" fromversion="0.0.3">
	32	<files>files.tar</files>
	33	<templates>templates.tar</templates>
	34	<sql>update.sql</sql>
	35	<eventlistener>eventlistener.xml</eventlistener>
	36	<cronjobs>cronjobs.xml</cronjobs>
	37	</instructions>
30	38	</package>