Strolen's Citadel: Megamet's Profile

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+

Submission Name	Since Submitted	Since Updated
Marissa Freya	1378 days	1378 days

BENCHMARKS

Loading Time: Base Classes	0.0072
Code	0.0898
Controller Execution Time ( Author / Index )	0.1594
Total Execution Time	0.1667

GET DATA

$_GET['action']

lockmor

MEMORY USAGE

10,024,208 bytes

POST DATA

No POST data exists

URI STRING

author/Megamet

CLASS/METHOD

author/index

DATABASE: strolen_lockmor QUERIES: 40 (Show)

0.0006	SELECT `id_member` FROM (`smf_members`) WHERE `member_name` = 'Megamet'
0.0002	`SELECT cat_id, cat_title FROM lockmor_categories`
0.0004	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` = '3490'
0.0003	SELECT COUNT(*) AS `numrows` FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `cond` = '1'
0.0003	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '3490'
0.0001	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '3490'
0.0003	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '3490' AND `comment_scroll` = '1'
0.0003	SELECT COUNT(*) AS `numrows` FROM (`lockmor_ideas`) WHERE `idea_author` = '3490' AND `idea_cond` = '1'
0.0005	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` = '3490' AND `cond` = '1' GROUP BY `type_id`
0.0004	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `show_content` = '1' ORDER BY `avg` DESC, `title` ASC LIMIT 20
0.0008	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` = '3490' ORDER BY `title` ASC
0.0149	SELECT `title`, `title_link`, count(*) as count FROM (`lockmor_content`) JOIN `lockmor_hoh` ON `hoh_content_id` = `content_id` WHERE `hoh_voter` = '3490' 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` = '3490'
0.0004	SELECT `title`, `title_link`, `hoh` FROM (`lockmor_content`) WHERE `author_id` = '3490' AND hoh >= 1 ORDER BY `hoh` DESC, `title` ASC
0.0004	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `golden` > 2 ORDER BY `title` ASC
0.0003	SELECT SUM(`golden`) AS golden FROM (`lockmor_content`) WHERE `author_id` = '3490'
0.0008	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` = '3490' 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.0004	SELECT * FROM (`lockmor_xp_track`) WHERE `active_auth_id` = '3490' ORDER BY `xp_date` desc LIMIT 15
0.0004	SELECT * FROM (`lockmor_xp_track`) WHERE `auth_id` = '3490' AND `active_auth_id` <> '3490' ORDER BY `xp_date` desc LIMIT 15
0.0001	SELECT * FROM (`lockmor_xp_type`)
0.0058	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 = 3490 ORDER BY RAND()LIMIT 20
0.0002	SELECT * FROM (`lockmor_quest`) WHERE `quest_suggest` = '1' ORDER BY `quest_name` ASC
0.0004	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` = '3490' AND `show_content` = '1'
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '3490' AND `date_voted` > 1366748155
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '3490' AND `date_voted` > 1366748155 AND `comment_XP` > 0
0.0005	SELECT `title`, `title_link`, `votes`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `show_content` = '1' AND `date_submitted` > 1366748155 ORDER BY `avg` DESC, `title` ASC
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '3490' AND `comment_date` > 1366748155
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '3490' AND `date_voted` > '1369320884'
0.0005	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '3490' AND `date_voted` > '1369320884' AND `comment_XP` > 0
0.0004	SELECT `title`, `title_link`, `votes`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `show_content` = '1' AND `date_submitted` > '1369320884' ORDER BY `avg` DESC, `title` ASC
0.0004	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '3490' AND `comment_date` > '1369320884'
0.0003	SELECT * FROM (`lockmor_fav_cats`) WHERE `cat_author_id` = '3490'
0.0004	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `cond` = '7' ORDER BY `title` ASC
0.0004	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `cond` = '5' ORDER BY `title` ASC
0.0004	SELECT `title`, `title_link` FROM (`lockmor_content`) WHERE `author_id` = '3490' AND `cond` = '9' ORDER BY `title` ASC
0.0001	SELECT `level_title`, `level_vote`, `level_hoh`, `level_post_min`, `level_xp_min` FROM (`lockmor_level`) WHERE `level_id` = '1'
0.0001	SELECT `level_post_min`, `level_xp_min` FROM (`lockmor_level`) WHERE `level_id` = 2
0.0042	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.0003	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	184.72.184.104
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

Megamet

Quest Logging

Experience/Leveling

His Grandest of Low Scribblers

HoHs available (0)

Votes Available (3)

137

XP

1

Submissions

7

Comments

0

HoH Earned

0

Golden's Earned

Author Submissions

Co-Authored Subs: 0

Comments: 7

Scrolls: 3

Idea Seeds: 0

Browse Megamet's Submissions

Top Rated

Official Citadel Quest Listing

Unfinished Quests

Recent Citadel Activity of Megamet

Recent Citadel Activity on Megamet

In Work Public

Unvoted by Author

Random Idea Seed View All Idea Seeds