Strolen's Citadel: HaroldWiggle's Profile

Submission Name	Rating
The Spirit of Urban flora	4.5
Chum Bucket	3.79

Submission Name	# HoHs
Chum Bucket	1

Name	# Awards	Description
Guardian of the Citadel	2	For actions and deeds in defense of the Citadel.
Article Guild	5	10 Article Submissions
Elite Article Guild	4	10 Article Submissions with 4+ average
Dungeon Guild	3	10 Dungeon Submissions
Elite Dungeon Guild	2	10 Dungeon Submissions with 4+ average
Item Guild	24	10 Item Submissions
Elite Item Guild	15	10 Item Submissions with 4+ average
Lifeforms Guild	15	10 Lifeform Submissions
Lifeforms Guild Elite	12	10 Lifeform Submissions with 4+ average
Locations Guild	11	10 Location Submissions
Locations Guild Elite	8	10 Location Submissions with 4+ average
NPC Guild	14	10 NPC Submissions
Elite NPC Guild	9	10 NPC Submissions with 4+ average
Plot Guild	7	10 Plot Submissions
Elite Plot Guild	3	10 Plot Submissions with 4+ average
Society Guild	6	10 Society Submissions
Elite Society Guild	3	10 Society Submissions with 4+ average
Systems Guild	5	10 System Submissions
Elite Systems Guild	5	10 System Submissions with 4+ average
Master Questor	10	Accomplished 10+ Quests with >3.0 avg
Elite Questor	4	Accomplished 5+ Quests in 1st or 2nd place
Questor	13	Accomplished 5+ Quests with >3.0 avg
Golden Creator	16	Golden Submissions 1+
Gold Creator 10	1	Golden Submissions 10+
Golden Creator 5	2	Golden Submissions 5+
Hall of Heroes	15	Subs Honoured 1+
Hall of Heroes 10	35	Subs Honoured 10+
Hall of Heroes 5	2	Subs Honoured 5+

The Spirit of Urban flora
Chum Bucket

BENCHMARKS

Loading Time: Base Classes	0.0072
Code	0.0355
Controller Execution Time ( Author / Index )	0.1010
Total Execution Time	0.1083

GET DATA

$_GET['action']

lockmor

MEMORY USAGE

9,578,640 bytes

POST DATA

No POST data exists

URI STRING

author/HaroldWiggle

CLASS/METHOD

author/index

DATABASE: strolen_lockmor QUERIES: 35 (Show)

0.0003	SELECT `id_member` FROM (`smf_members`) WHERE `member_name` = 'HaroldWiggle'
0.0001	`SELECT cat_id, cat_title FROM lockmor_categories`
0.0005	SELECT `a`.*, `b`.`member_name`, `b`.`date_registered`, `b`.`last_login`, `b`.`personal_text`, `b`.`website_title`, `b`.`website_url`, `b`.`location`, `b`.`signature`, `c`.`filename` FROM (`lockmor_user` as a) JOIN `smf_members` as b ON `a`.`author_id` = `b`.`id_member` LEFT JOIN `smf_attachments` as c ON `a`.`author_id` = `c`.`id_member` WHERE `author_id` = '3613'
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `cond` = '1'
0.0002	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '3613'
0.0000	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '3613'
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '3613' AND `comment_scroll` = '1'
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_ideas`) WHERE `idea_author` = '3613' AND `idea_cond` = '1'
0.0003	SELECT DISTINCT count(*) as total, (sum(ratings)/sum(votes)) as avg, sum(votes) as tot_votes, `ratings`, `votes`, `type_id`, `cond` FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `cond` = '1' GROUP BY `type_id`
0.0002	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `show_content` = '1' ORDER BY `avg` DESC, `title` ASC LIMIT 20
0.0004	SELECT DISTINCT `title`, `title_link`, `summary`, `author_id`, `date_submitted`, `date_updated`, `type_id`, `cond` FROM (`lockmor_content`) JOIN `lockmor_collab` ON `lockmor_collab`.`collab_sub` = `lockmor_content`.`content_id` WHERE `collab_author` = '3613' ORDER BY `title` ASC
0.0002	SELECT `title`, `title_link`, count(*) as count FROM (`lockmor_content`) JOIN `lockmor_hoh` ON `hoh_content_id` = `content_id` WHERE `hoh_voter` = '3613' AND `show_content` = '1' AND hoh >= 1 GROUP BY `hoh_content_id` ORDER BY `count` DESC, `title` ASC
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_hoh`) WHERE `hoh_voter` = '3613'
0.0002	SELECT `title`, `title_link`, `hoh` FROM (`lockmor_content`) WHERE `author_id` = '3613' AND hoh >= 1 ORDER BY `hoh` DESC, `title` ASC
0.0001	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `golden` > 2 ORDER BY `title` ASC
0.0001	SELECT SUM(`golden`) AS golden FROM (`lockmor_content`) WHERE `author_id` = '3613'
0.0003	SELECT `id_category`, `award_name`, `description`, `filename` FROM (`smf_awards`) LEFT OUTER JOIN `smf_awards_members` ON `smf_awards`.`id_award` = `smf_awards_members`.`id_award` WHERE `id_member` = '3613' ORDER BY `award_name` asc
0.0001	SELECT `smf_awards`.`id_award`, `id_category`, `award_name`, `description`, `filename`, count(*) as count FROM (`smf_awards`) JOIN `smf_awards_members` ON `smf_awards`.`id_award` = `smf_awards_members`.`id_award` WHERE `id_category` = 1 OR `id_category` = 3 GROUP BY `smf_awards`.`id_award` ORDER BY `id_category` asc, `description` asc
0.0002	SELECT * FROM (`lockmor_xp_track`) WHERE `active_auth_id` = '3613' ORDER BY `xp_date` desc LIMIT 15
0.0002	SELECT * FROM (`lockmor_xp_track`) WHERE `auth_id` = '3613' AND `active_auth_id` <> '3613' ORDER BY `xp_date` desc LIMIT 15
0.0000	SELECT * FROM (`lockmor_xp_type`)
0.0031	SELECT title, title_link FROM lockmor_content as n LEFT JOIN ( SELECT b.content_id FROM lockmor_comment as bp JOIN lockmor_content as b on bp.comment_parent = b.content_id WHERE bp.comment_author = -1 ) AS c ON n.content_id = c.content_id WHERE c.content_id IS NULL AND n.cond = 1 AND author_id = 3613 ORDER BY RAND()LIMIT 20
0.0001	SELECT * FROM (`lockmor_quest`) WHERE `quest_suggest` = '1' ORDER BY `quest_name` ASC
0.0003	SELECT `title`, `title_link`, `summary`, `author_id`, `date_submitted`, `type_id`, `content_id`, `cond`, `quest_win`, `quest_name`, `quest` FROM (`lockmor_content`) JOIN `lockmor_quest` ON `lockmor_quest`.`quest_id` = `lockmor_content`.`quest` WHERE `author_id` = '3613' AND `show_content` = '1'
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '3613' AND `date_voted` > 1366648723
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '3613' AND `date_voted` > 1366648723 AND `comment_XP` > 0
0.0002	SELECT `title`, `title_link`, `votes`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `show_content` = '1' AND `date_submitted` > 1366648723 ORDER BY `avg` DESC, `title` ASC
0.0001	SELECT * FROM (`lockmor_fav_cats`) WHERE `cat_author_id` = '3613'
0.0002	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `cond` = '7' ORDER BY `title` ASC
0.0002	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `cond` = '5' ORDER BY `title` ASC
0.0002	SELECT `title`, `title_link` FROM (`lockmor_content`) WHERE `author_id` = '3613' AND `cond` = '9' ORDER BY `title` ASC
0.0000	SELECT `level_title`, `level_vote`, `level_hoh`, `level_post_min`, `level_xp_min` FROM (`lockmor_level`) WHERE `level_id` = '1'
0.0000	SELECT `level_post_min`, `level_xp_min` FROM (`lockmor_level`) WHERE `level_id` = 2
0.0021	SELECT `idea_id`, `idea_text`, `idea_xp`, `member_name` as username FROM (`lockmor_ideas`) JOIN `smf_members` ON `id_member` = `idea_author` ORDER BY RAND() LIMIT 1
0.0001	SELECT `banner_link`, `banner_graphic` FROM (`lockmor_banner`) ORDER BY RAND() LIMIT 1

HTTP HEADERS (Show)

CONFIG VARIABLES (Show)

HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_USER_AGENT	CCBot/2.0
HTTP_CONNECTION
SERVER_PORT	80
SERVER_NAME	strolen.com
REMOTE_ADDR	23.22.76.170
SERVER_SOFTWARE	Apache
HTTP_ACCEPT_LANGUAGE	en-us,en-gb,en;q=0.7,*;q=0.3
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.0
QUERY_STRING
HTTP_ACCEPT_ENCODING	x-gzip, gzip, deflate
HTTP_X_FORWARDED_FOR

base_url	http://strolen.com/
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
permitted_uri_chars	a-z 0-9~%.:_\-
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	0
log_path
log_date_format	Y-m-d H:i:s
cache_path
encryption_key	ptmhfqNRdiaLRxvsaOwEEuDUuFiuqkbD
sess_cookie_name	ci_session
sess_expiration	7200
sess_expire_on_close
sess_encrypt_cookie
sess_use_database
sess_table_name	ci_sessions
sess_match_ip
sess_match_useragent	1
sess_time_to_update	300
cookie_prefix
cookie_domain
cookie_path	/
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
compress_output
time_reference	local
rewrite_short_tags
proxy_ips

Profile

HaroldWiggle

Experience/Leveling

His Grandest of Low Scribblers

HoHs available (0)

Votes Available (3)

53

XP

2

Submissions

1

Comments

0

HoH Earned

0

Golden's Earned

Quest Logging (last 30 days)

Author Submissions

Plots

Items

Co-Authored Subs: 0

Comments: 1

Scrolls: 0

Idea Seeds: 0

Browse HaroldWiggle's Submissions

Top Rated

Hall of Honour

Official Citadel Quest Listing

Unfinished Quests

Recent Citadel Activity of HaroldWiggle

Recent Citadel Activity on HaroldWiggle

Unvoted by Author

Random Idea Seed View All Idea Seeds