Online PHP editor | perf for gfv5i

@ 2014-09-14T21:05:10Z

<?php


/**
 * Loads thank'o'mat data for the Threadpage.
 *
 * @author Christian "Plunts" Grubert
 * @copyright 2010 Duetschi Kreativagentur
 * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @package de.wbb3mods.wbb.thankbot
 */
class ThreadPageThankBotListener implements EventListener {
	
	/**
	 * @see EventListener::execute()
	 * @param ThreadPage $eventObj
	 */
	public function execute($eventObj, $className, $eventName) {
		if (empty($eventObj->postList->postIDs)) return;

		$thankdata = array();
		$thankedFor = array();
		$sql = "SELECT	*
				FROM	wbb".WBB_N."_thank_guests
				WHERE	postID IN (".$eventObj->postList->postIDs.")";
		$result = WCF::getDB()->sendQuery($sql);
		while ($row = WCF::getDB()->fetchArray($result)) {
			if (isset($thankdata[$row['postID']]['guests']))
				$thankdata[$row['postID']]['guests']++;
			else
				$thankdata[$row['postID']]['guests'] = 1;
		}

		//$canUseOnlineMarking = version_compare(PACKAGE_VERSION, '3.1.0') >= 0;
		$sql = "SELECT		thank_user.*, user.username" . ($canUseOnlineMarking ? ", g.userOnlineMarking usernameStyle" : "") . "
				FROM		wbb" . WBB_N . "_thank_user	thank_user
				LEFT JOIN	wcf" . WCF_N . "_user user USING (userID)
				" . ($canUseOnlineMarking ? "LEFT JOIN wcf" . WCF_N . "_group g ON (user.userOnlineGroupID = g.groupID)" : "") . "
				WHERE thank_user.postID IN (" . $eventObj->postList->postIDs . ")
				ORDER BY	" . THANKS_SORT;
		$result = WCF::getDB()->sendQuery($sql);
		while ($row = WCF::getDB()->fetchArray($result)) {
			if ($row['username'] == null) {
				if (isset($thankdata[$row['postID']]['guests']))
					$thankdata[$row['postID']]['guests']++;
				else
					$thankdata[$row['postID']]['guests'] = 1;
			} else {
				if ($canUseOnlineMarking && !empty($row['usernameStyle']) && $row['usernameStyle'] != '%s') {
					$styledUsername = sprintf($row['usernameStyle'], StringUtil::encodeHTML($row['username']));
				} else {
					$styledUsername = StringUtil::encodeHTML($row['username']);
				}
				$thankdata[$row['postID']]['users'][$row['userID']] = array('userID' => $row['userID'], 
						'username' => $row['username'], 
						'styledUsername' => $styledUsername, 
						'time' => $row['time']);
			}
		}

		if ($eventObj->board->getPermission('canThank') && !WCF::getSession()->spiderID) {
			$sql = "SELECT
					post.postID,  post.userID,
					GROUP_CONCAT(DISTINCT thank_user.userID) AS userIDs,
					GROUP_CONCAT(DISTINCT thank_guests.iphash) AS iphashes
				FROM wbb".WBB_N."_post post
				LEFT JOIN	wbb".WBB_N."_thank_user thank_user ON (post.postID=thank_user.postID)
				LEFT JOIN	wbb".WBB_N."_thank_guests thank_guests ON (post.postID=thank_guests.postID AND thank_guests.time > ".(TIME_NOW-86400).")
				WHERE post.postID IN (".$eventObj->postList->postIDs.") AND post.hasThank = 1
				GROUP BY post.postID
				ORDER BY post.time";
			$result = WCF::getDB()->sendQuery($sql);

			$additionalSmallButtons = WCF::getTPL()->get('additionalSmallButtons');
			$showLargeThankLink = array();
			while ($row = WCF::getDB()->fetchArray($result)) {
				$row['userIDs'] = explode(',', $row['userIDs']);
				if ($row['userIDs'][0] == '') $row['userIDs'] = array();
				
				$row['iphashes'] = explode(',', $row['iphashes']);
				if ($row['iphashes'][0] == '') $row['iphashes'] = array();
				
				if ($row['userID'] != WCF::getUser()->userID) { // @todo autor = gast und user = gast sollte auch gehen
					$hasThanked = (in_array(WCF::getUser()->userID, $row['userIDs']) || in_array(sha1(UserUtil::getIpAddress()), $row['iphashes']));
					WCF::getTPL()->assign(array(
						'postID' => $row['postID'],
						'hasThanked' => $hasThanked
					));

					if (THANKS_BIGBUTTON && $row['postID'] == $eventObj->thread->firstPostID) {
						WCF::getTPL()->append('additionalLargeButtons', WCF::getTPL()->fetch('threadThankButton'));
					}
					elseif (THANKS_LINKPOS == 1) {
						$thankedFor[$row['postID']] = $hasThanked;
					}
					else {
						if (!isset($additionalSmallButtons[$row['postID']]))
							$additionalSmallButtons[$row['postID']] = '';
						$additionalSmallButtons[$row['postID']] .= WCF::getTPL()->fetch('postThankButton');
					}
				}
			}
			
			WCF::getTPL()->assign('additionalSmallButtons', $additionalSmallButtons);
		}

		if (THANKS_SHOWCOUNT) {
			$additionalSidebarUserCredits = WCF::getTPL()->get('additionalSidebarUserCredits');
			foreach ($eventObj->sidebarFactory->messageSidebars AS $sidebar) {
				if (!isset($additionalSidebarUserCredits[$sidebar->getMessageID()]))
					$additionalSidebarUserCredits[$sidebar->getMessageID()] = '';
				WCF::getTPL()->assign(array(
						'thanks_got' => $sidebar->getUser()->thanks_got,
						'thanks_given' => $sidebar->getUser()->thanks_given,
						'userID' => $sidebar->getUser()->userID,
						'postID' => $sidebar->getMessageID()
				));
				$additionalSidebarUserCredits[$sidebar->getMessageID()] .= WCF::getTPL()->fetch('postThankCredits');
			}
			WCF::getTPL()->assign('additionalSidebarUserCredits', $additionalSidebarUserCredits);
		}

		$additionalMessageFooter = WCF::getTPL()->get('additionalMessageFooter');
		foreach ($eventObj->postList->posts AS $key=>$post) {
			if ($post->hasThank) {
				WCF::getTPL()->assign(array(
						'postID' => $post->postID,
						'postThanks' => isset($thankdata[$post->postID]) ? $thankdata[$post->postID] : null,
						'isAuthor' => $post->userID == WCF::getUser()->userID && $post->userID != 0,
						'hasThanked' => isset($thankedFor[$post->postID]) ? $thankedFor[$post->postID] : false
				));
				$template = WCF::getTPL()->fetch('postThankStats');

				if (!isset($additionalMessageFooter[$post->postID])) {
					$additionalMessageFooter[$post->postID] = $template;
				} else {
					$additionalMessageFooter[$post->postID] .= $template;
				}
			}
		}
		WCF::getTPL()->assign('additionalMessageFooter', $additionalMessageFooter);
		WCF::getTPL()->append('specialStyles', "\n".'<script src="' . RELATIVE_WBB_DIR . 'js/ThankOmat.class.js" type="text/javascript"></script>'."\n");
	}

	private function isAuthor(Post $post) {
		if (WCF::getUser()->userID == 0) {
			return (UserUtil::getIpAddress() == $post->ipAddress && $post->userID == 0 && $post->time > TIME_NOW-86400);
		} else {
			return (WCF::getUser()->userID == $post->userID);
		}
	}
}
?>

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
8.3.7	0.013	0.007	16.75
8.3.6	0.007	0.007	18.15
8.3.5	0.013	0.005	22.93
8.3.4	0.010	0.006	19.10
8.3.3	0.011	0.003	19.31
8.3.2	0.005	0.003	20.32
8.3.1	0.004	0.004	23.28
8.3.0	0.008	0.000	19.38
8.2.18	0.010	0.007	18.29
8.2.17	0.003	0.012	22.96
8.2.16	0.006	0.009	20.47
8.2.15	0.008	0.000	24.18
8.2.14	0.008	0.000	24.66
8.2.13	0.004	0.004	26.16
8.2.12	0.004	0.004	20.98
8.2.11	0.007	0.003	20.65
8.2.10	0.003	0.009	18.22
8.2.9	0.003	0.005	19.37
8.2.8	0.003	0.005	17.97
8.2.7	0.003	0.007	17.75
8.2.6	0.000	0.009	17.91
8.2.5	0.004	0.008	18.07
8.2.4	0.000	0.008	18.41
8.2.3	0.000	0.007	18.12
8.2.2	0.009	0.000	17.76
8.2.1	0.000	0.008	18.24
8.2.0	0.006	0.003	17.88
8.1.28	0.011	0.007	25.92
8.1.27	0.009	0.000	23.73
8.1.26	0.007	0.000	26.35
8.1.25	0.004	0.004	28.09
8.1.24	0.006	0.003	23.79
8.1.23	0.004	0.008	19.30
8.1.22	0.000	0.008	17.74
8.1.21	0.006	0.003	18.77
8.1.20	0.006	0.003	17.48
8.1.19	0.000	0.009	17.48
8.1.18	0.005	0.003	18.10
8.1.17	0.010	0.000	18.71
8.1.16	0.000	0.008	22.15
8.1.15	0.000	0.007	18.88
8.1.14	0.000	0.008	17.53
8.1.13	0.007	0.000	17.96
8.1.12	0.008	0.000	17.54
8.1.11	0.004	0.004	17.44
8.1.10	0.004	0.004	17.49
8.1.9	0.000	0.008	17.58
8.1.8	0.000	0.007	17.53
8.1.7	0.000	0.007	17.55
8.1.6	0.006	0.003	17.61
8.1.5	0.000	0.009	17.43
8.1.4	0.004	0.004	17.63
8.1.3	0.004	0.004	17.70
8.1.2	0.000	0.008	17.73
8.1.1	0.006	0.003	17.53
8.1.0	0.004	0.004	17.56
8.0.30	0.000	0.008	18.77
8.0.29	0.000	0.008	16.88
8.0.28	0.003	0.003	18.58
8.0.27	0.000	0.007	17.32
8.0.26	0.000	0.007	17.30
8.0.25	0.007	0.000	17.10
8.0.24	0.005	0.002	17.14
8.0.23	0.007	0.000	17.19
8.0.22	0.000	0.007	17.11
8.0.21	0.000	0.008	17.07
8.0.20	0.000	0.006	17.04
8.0.19	0.000	0.008	16.99
8.0.18	0.009	0.000	17.12
8.0.17	0.003	0.006	17.11
8.0.16	0.004	0.004	17.16
8.0.15	0.004	0.007	16.87
8.0.14	0.003	0.006	17.01
8.0.13	0.009	0.000	13.48
8.0.12	0.005	0.005	16.98
8.0.11	0.000	0.008	17.04
8.0.10	0.000	0.007	17.04
8.0.9	0.007	0.000	17.02
8.0.8	0.016	0.000	17.08
8.0.7	0.004	0.004	16.96
8.0.6	0.000	0.007	17.15
8.0.5	0.007	0.000	17.03
8.0.3	0.011	0.008	17.23
8.0.2	0.013	0.010	17.40
8.0.1	0.004	0.004	17.01
8.0.0	0.009	0.010	16.92
7.4.33	0.006	0.000	15.05
7.4.32	0.003	0.003	16.45
7.4.30	0.004	0.004	16.68
7.4.29	0.003	0.003	16.61
7.4.28	0.005	0.005	16.66
7.4.27	0.007	0.003	16.71
7.4.26	0.008	0.000	16.68
7.4.25	0.003	0.005	16.59
7.4.24	0.006	0.002	16.64
7.4.23	0.003	0.005	16.58
7.4.22	0.011	0.011	16.70
7.4.21	0.013	0.006	16.54
7.4.20	0.000	0.007	16.56
7.4.16	0.012	0.008	16.57
7.4.15	0.009	0.009	17.40
7.4.14	0.009	0.012	17.86
7.4.13	0.014	0.003	16.69
7.4.12	0.004	0.012	16.62
7.4.11	0.011	0.006	16.79
7.4.10	0.006	0.012	16.61
7.4.9	0.011	0.007	16.69
7.4.8	0.006	0.016	19.39
7.4.7	0.009	0.012	16.65
7.4.6	0.007	0.010	16.48
7.4.5	0.003	0.005	16.42
7.4.4	0.007	0.010	16.62
7.4.3	0.013	0.003	16.53
7.4.0	0.007	0.011	15.08
7.3.33	0.003	0.003	13.40
7.3.32	0.003	0.003	13.35
7.3.31	0.004	0.004	16.27
7.3.30	0.000	0.008	16.24
7.3.29	0.008	0.006	16.37
7.3.28	0.007	0.009	16.34
7.3.27	0.010	0.008	17.40
7.3.26	0.009	0.009	16.57
7.3.25	0.012	0.007	16.50
7.3.24	0.008	0.008	16.42
7.3.23	0.000	0.017	16.61
7.3.21	0.013	0.006	16.39
7.3.20	0.013	0.003	19.39
7.3.19	0.010	0.007	16.62
7.3.18	0.015	0.006	16.38
7.3.17	0.013	0.003	16.57
7.3.16	0.007	0.013	16.34
7.3.12	0.000	0.016	14.88
7.3.11	0.010	0.010	15.13
7.3.10	0.009	0.006	14.66
7.3.9	0.009	0.000	14.89
7.3.8	0.007	0.010	15.21
7.3.7	0.000	0.011	14.97
7.3.6	0.010	0.006	14.96
7.3.5	0.000	0.016	14.56
7.3.4	0.000	0.012	14.76
7.3.3	0.003	0.007	14.71
7.3.2	0.007	0.007	16.54
7.3.1	0.009	0.006	16.65
7.3.0	0.006	0.006	16.52
7.2.33	0.008	0.009	16.58
7.2.32	0.010	0.007	16.75
7.2.31	0.013	0.006	16.57
7.2.30	0.007	0.010	16.41
7.2.29	0.007	0.010	16.43
7.2.25	0.009	0.010	15.17
7.2.24	0.009	0.009	14.90
7.2.23	0.013	0.006	14.87
7.2.22	0.004	0.008	14.92
7.2.21	0.006	0.006	14.69
7.2.20	0.013	0.003	14.89
7.2.19	0.012	0.003	15.08
7.2.18	0.007	0.003	15.04
7.2.17	0.006	0.009	15.02
7.2.0	0.003	0.006	19.46
7.1.33	0.006	0.009	15.52
7.1.32	0.012	0.000	15.67
7.1.31	0.007	0.007	15.75
7.1.30	0.011	0.003	15.64
7.1.29	0.000	0.010	15.56
7.1.28	0.006	0.009	15.66
7.1.27	0.008	0.008	15.47
7.1.26	0.004	0.008	15.73
7.1.10	0.004	0.007	18.13
7.1.7	0.000	0.016	17.01
7.1.6	0.007	0.017	19.46
7.1.5	0.007	0.014	16.89
7.1.0	0.003	0.077	22.54
7.0.20	0.000	0.010	16.36
7.0.14	0.013	0.063	22.01
7.0.10	0.050	0.073	20.16
7.0.9	0.050	0.063	20.17
7.0.8	0.043	0.080	20.13
7.0.7	0.050	0.073	20.05
7.0.6	0.067	0.073	20.06
7.0.5	0.047	0.077	20.50
7.0.4	0.010	0.073	20.00
7.0.3	0.007	0.050	20.15
7.0.2	0.000	0.080	20.13
7.0.1	0.010	0.077	20.10
7.0.0	0.010	0.077	20.13
5.6.28	0.003	0.073	21.17
5.6.25	0.013	0.070	20.63
5.6.24	0.000	0.090	20.61
5.6.23	0.017	0.073	20.68
5.6.22	0.010	0.077	20.77
5.6.21	0.007	0.083	20.57
5.6.20	0.007	0.083	21.10
5.6.19	0.023	0.060	21.12
5.6.18	0.010	0.083	21.12
5.6.17	0.007	0.083	21.13
5.6.16	0.007	0.040	21.21
5.6.15	0.000	0.080	21.15
5.6.14	0.010	0.077	21.02
5.6.13	0.007	0.080	21.20
5.6.12	0.017	0.050	21.12
5.6.11	0.007	0.070	21.24
5.6.10	0.017	0.073	21.01
5.6.9	0.013	0.077	21.18
5.6.8	0.010	0.077	20.59
5.6.7	0.010	0.047	20.39
5.6.6	0.013	0.043	20.40
5.6.5	0.007	0.050	20.63
5.6.4	0.003	0.087	20.44
5.6.3	0.010	0.083	20.60
5.6.2	0.010	0.077	20.54
5.6.1	0.017	0.070	20.48
5.6.0	0.013	0.053	20.46
5.5.38	0.003	0.043	20.52
5.5.37	0.010	0.050	20.42
5.5.36	0.010	0.083	20.48
5.5.35	0.003	0.083	20.53
5.5.34	0.017	0.063	20.94
5.5.33	0.020	0.070	20.94
5.5.32	0.013	0.077	20.95
5.5.31	0.010	0.077	20.90
5.5.30	0.007	0.083	20.99
5.5.29	0.010	0.077	20.95
5.5.28	0.007	0.083	20.81
5.5.27	0.010	0.077	20.90
5.5.26	0.013	0.073	20.90
5.5.25	0.013	0.063	20.75
5.5.24	0.003	0.083	20.34
5.5.23	0.010	0.077	20.23
5.5.22	0.007	0.077	20.21
5.5.21	0.007	0.073	20.25
5.5.20	0.007	0.063	20.31
5.5.19	0.010	0.080	20.36
5.5.18	0.010	0.077	20.23
5.5.16	0.017	0.067	20.30
5.5.15	0.007	0.073	20.23
5.5.14	0.007	0.070	20.25
5.5.13	0.013	0.077	20.07
5.5.12	0.007	0.083	20.32
5.5.11	0.000	0.070	20.34
5.5.10	0.007	0.080	20.19
5.5.9	0.007	0.070	20.02
5.5.8	0.010	0.063	20.14
5.5.7	0.017	0.067	20.23
5.5.6	0.003	0.050	20.01
5.5.5	0.003	0.080	20.23
5.5.4	0.013	0.070	20.16
5.5.3	0.010	0.050	20.21
5.5.2	0.007	0.080	20.13
5.5.1	0.010	0.077	20.12
5.5.0	0.007	0.073	20.16
5.4.45	0.003	0.067	19.37
5.4.44	0.007	0.077	19.23
5.4.43	0.010	0.067	19.19
5.4.42	0.007	0.080	19.18
5.4.41	0.003	0.040	19.24
5.4.40	0.013	0.070	18.86
5.4.39	0.007	0.083	19.04
5.4.38	0.007	0.073	19.14
5.4.37	0.013	0.070	19.13
5.4.36	0.003	0.083	19.04
5.4.35	0.007	0.077	19.23
5.4.34	0.010	0.070	19.05
5.4.32	0.007	0.073	19.05
5.4.31	0.013	0.070	19.17
5.4.30	0.003	0.080	18.91
5.4.29	0.007	0.073	19.19
5.4.28	0.013	0.080	18.96
5.4.27	0.013	0.073	19.21
5.4.26	0.007	0.077	18.86
5.4.25	0.003	0.077	19.09
5.4.24	0.003	0.083	18.89
5.4.23	0.010	0.073	19.24
5.4.22	0.003	0.053	19.12
5.4.21	0.010	0.070	18.89
5.4.20	0.010	0.073	18.95
5.4.19	0.007	0.080	19.21
5.4.18	0.000	0.083	19.22
5.4.17	0.007	0.073	19.09
5.4.16	0.007	0.073	19.04
5.4.15	0.017	0.053	19.20
5.4.14	0.003	0.057	16.46
5.4.13	0.007	0.070	16.41
5.4.12	0.010	0.070	16.34
5.4.11	0.000	0.070	16.39
5.4.10	0.007	0.050	16.52
5.4.9	0.010	0.077	16.45
5.4.8	0.010	0.070	16.43
5.4.7	0.010	0.053	16.39
5.4.6	0.020	0.063	16.52
5.4.5	0.007	0.060	16.38
5.4.4	0.007	0.060	16.53
5.4.3	0.020	0.053	16.48
5.4.2	0.003	0.037	16.38
5.4.1	0.000	0.080	16.38
5.4.0	0.007	0.040	15.86

preferences:dark modelive preview