Strolen's Citadel: Matze's Profile

Submission Name	Rating
Teenager in love	3.69

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	17	Subs Honoured 1+
Hall of Heroes 10	35	Subs Honoured 10+
Hall of Heroes 5	2	Subs Honoured 5+

BENCHMARKS

Loading Time: Base Classes	0.0073
Code	0.0950
Controller Execution Time ( Author / Index )	0.1653
Total Execution Time	0.1727

GET DATA

$_GET['action']

lockmor

MEMORY USAGE

10,025,728 bytes

POST DATA

No POST data exists

URI STRING

author/Matze

CLASS/METHOD

author/index

DATABASE: strolen_lockmor QUERIES: 40 (Show)

0.0006	SELECT `id_member` FROM (`smf_members`) WHERE `member_name` = 'Matze'
0.0001	`SELECT cat_id, cat_title FROM lockmor_categories`
0.0006	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` = '490'
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_content`) WHERE `author_id` = '490' AND `cond` = '1'
0.0003	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '490'
0.0001	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '490'
0.0005	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '490' AND `comment_scroll` = '1'
0.0003	SELECT COUNT(*) AS `numrows` FROM (`lockmor_ideas`) WHERE `idea_author` = '490' AND `idea_cond` = '1'
0.0006	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` = '490' AND `cond` = '1' GROUP BY `type_id`
0.0005	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '490' AND `show_content` = '1' ORDER BY `avg` DESC, `title` ASC LIMIT 20
0.0007	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` = '490' ORDER BY `title` ASC
0.0005	SELECT `title`, `title_link`, count(*) as count FROM (`lockmor_content`) JOIN `lockmor_hoh` ON `hoh_content_id` = `content_id` WHERE `hoh_voter` = '490' AND `show_content` = '1' AND hoh >= 1 GROUP BY `hoh_content_id` ORDER BY `count` DESC, `title` ASC
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_hoh`) WHERE `hoh_voter` = '490'
0.0003	SELECT `title`, `title_link`, `hoh` FROM (`lockmor_content`) WHERE `author_id` = '490' AND hoh >= 1 ORDER BY `hoh` DESC, `title` ASC
0.0005	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '490' AND `golden` > 2 ORDER BY `title` ASC
0.0003	SELECT SUM(`golden`) AS golden FROM (`lockmor_content`) WHERE `author_id` = '490'
0.0006	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` = '490' 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.0113	SELECT * FROM (`lockmor_xp_track`) WHERE `active_auth_id` = '490' ORDER BY `xp_date` desc LIMIT 15
0.0101	SELECT * FROM (`lockmor_xp_track`) WHERE `auth_id` = '490' AND `active_auth_id` <> '490' ORDER BY `xp_date` desc LIMIT 15
0.0001	SELECT * FROM (`lockmor_xp_type`)
0.0059	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 = 490 ORDER BY RAND()LIMIT 20
0.0001	SELECT * FROM (`lockmor_quest`) WHERE `quest_suggest` = '1' ORDER BY `quest_name` ASC
0.0006	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` = '490' AND `show_content` = '1'
0.0164	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '490' AND `date_voted` > 1366776817
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '490' AND `date_voted` > 1366776817 AND `comment_XP` > 0
0.0002	SELECT `title`, `title_link`, `votes`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '490' AND `show_content` = '1' AND `date_submitted` > 1366776817 ORDER BY `avg` DESC, `title` ASC
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '490' AND `comment_date` > 1366776817
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '490' AND `date_voted` > '1369320884'
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '490' AND `date_voted` > '1369320884' AND `comment_XP` > 0
0.0002	SELECT `title`, `title_link`, `votes`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '490' AND `show_content` = '1' AND `date_submitted` > '1369320884' ORDER BY `avg` DESC, `title` ASC
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '490' AND `comment_date` > '1369320884'
0.0001	SELECT * FROM (`lockmor_fav_cats`) WHERE `cat_author_id` = '490'
0.0001	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '490' AND `cond` = '7' ORDER BY `title` ASC
0.0002	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '490' AND `cond` = '5' ORDER BY `title` ASC
0.0001	SELECT `title`, `title_link` FROM (`lockmor_content`) WHERE `author_id` = '490' 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.0020	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	54.242.188.217
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

Matze

Quest Logging

Experience/Leveling

His Grandest of Low Scribblers

HoHs available (0)

Votes Available (3)

30

XP

1

Submissions

2

Comments

0

HoH Earned

0

Golden's Earned

Author Submissions

Plots

Co-Authored Subs: 0

Comments: 2

Scrolls: 0

Idea Seeds: 0

Browse Matze's Submissions

Top Rated

Official Citadel Quest Listing

Unfinished Quests

Recent Citadel Activity of Matze

Recent Citadel Activity on Matze

Unvoted by Author

Random Idea Seed View All Idea Seeds