Profile

Geomancer

Strolenati ID: 683
Initiated: 2003-12-15 04:14 PM
Last Sojourn: 2013-01-24 10:44 AM

Quest Logging

Last 30 Days
Number Authour Upvoted: 0
Number Received Upvoted: 0
Number Comments: 0
Sub (votes / avg):

Since May 23, 2013 Number Authour Upvoted: 0
Number Received Upvoted: 0
Number Comments: 0
Sub (votes / avg):

Experience/Leveling

Level 1

His Grandest of Low Scribblers

For Next Level - 24xp of 60xp complete

36 xp to go

For Next Level - 1 of 2 complete

1 to go

HoHs available (0)

Votes Available (3)

24

XP

1

Submissions

1

Comments

0

HoH Earned

0

Golden's Earned

Author Submissions

Top Rated

Submission Name	Rating
The Ancient Mariner	3.75

Recent Citadel Activity of Geomancer

Recent Citadel Activity on Geomancer

This is a listing of ALL available Citadel Badges and how many have earned each. This is NOT associated with the user you are currently browsing.

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+

Join Now!!

Unvoted by Author

The Ancient Mariner

Random Idea Seed View All Idea Seeds

An enhanted purse that provides money, but at the cost of luck..
By: valadaar | Visit | UpVote 0xp

Individual submissions, unless otherwise noted by the author, are licensed under the
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License
and requires a link back to the original.

We would love it if you left a comment when you use an idea!

BENCHMARKS

Loading Time: Base Classes	0.0124
Code	0.0545
Controller Execution Time ( Author / Index )	0.1583
Total Execution Time	0.1708

GET DATA

$_GET['action']

lockmor

MEMORY USAGE

10,004,952 bytes

POST DATA

No POST data exists

URI STRING

author/Geomancer

CLASS/METHOD

author/index

DATABASE: strolen_lockmor QUERIES: 40 (Show)

0.0003	SELECT `id_member` FROM (`smf_members`) WHERE `member_name` = 'Geomancer'
0.0001	`SELECT cat_id, cat_title FROM lockmor_categories`
0.0053	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` = '683'
0.0003	SELECT COUNT(*) AS `numrows` FROM (`lockmor_content`) WHERE `author_id` = '683' AND `cond` = '1'
0.0002	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '683'
0.0000	SELECT count(distinct collab_sub) as counter FROM (`lockmor_collab`) WHERE `collab_author` = '683'
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '683' AND `comment_scroll` = '1'
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_ideas`) WHERE `idea_author` = '683' 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` = '683' AND `cond` = '1' GROUP BY `type_id`
0.0002	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '683' AND `show_content` = '1' ORDER BY `avg` DESC, `title` ASC LIMIT 20
0.0006	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` = '683' 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` = '683' 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` = '683'
0.0002	SELECT `title`, `title_link`, `hoh` FROM (`lockmor_content`) WHERE `author_id` = '683' AND hoh >= 1 ORDER BY `hoh` DESC, `title` ASC
0.0002	SELECT `title`, `title_link`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '683' AND `golden` > 2 ORDER BY `title` ASC
0.0001	SELECT SUM(`golden`) AS golden FROM (`lockmor_content`) WHERE `author_id` = '683'
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` = '683' 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.0019	SELECT * FROM (`lockmor_xp_track`) WHERE `active_auth_id` = '683' ORDER BY `xp_date` desc LIMIT 15
0.0003	SELECT * FROM (`lockmor_xp_track`) WHERE `auth_id` = '683' AND `active_auth_id` <> '683' ORDER BY `xp_date` desc LIMIT 15
0.0000	SELECT * FROM (`lockmor_xp_type`)
0.0030	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 = 683 ORDER BY RAND()LIMIT 20
0.0001	SELECT * FROM (`lockmor_quest`) WHERE `quest_suggest` = '1' ORDER BY `quest_name` ASC
0.0046	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` = '683' AND `show_content` = '1'
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '683' AND `date_voted` > 1366789739
0.0003	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '683' AND `date_voted` > 1366789739 AND `comment_XP` > 0
0.0002	SELECT `title`, `title_link`, `votes`, (ratings/votes) as avg FROM (`lockmor_content`) WHERE `author_id` = '683' AND `show_content` = '1' AND `date_submitted` > 1366789739 ORDER BY `avg` DESC, `title` ASC
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '683' AND `comment_date` > 1366789739
0.0001	SELECT COUNT(*) AS `numrows` FROM (`lockmor_votes`) WHERE `author_id` = '683' AND `date_voted` > '1369320884'
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) JOIN `lockmor_votes` ON `lockmor_comment`.`comment_id` = `lockmor_votes`.`comment_id` WHERE `comment_author` = '683' 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` = '683' AND `show_content` = '1' AND `date_submitted` > '1369320884' ORDER BY `avg` DESC, `title` ASC
0.0002	SELECT COUNT(*) AS `numrows` FROM (`lockmor_comment`) WHERE `comment_author` = '683' AND `comment_date` > '1369320884'
0.0001	SELECT * FROM (`lockmor_fav_cats`) WHERE `cat_author_id` = '683'
0.0002	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '683' AND `cond` = '7' ORDER BY `title` ASC
0.0001	SELECT `title`, `title_link`, `date_submitted`, `date_updated` FROM (`lockmor_content`) WHERE `author_id` = '683' AND `cond` = '5' ORDER BY `title` ASC
0.0002	SELECT `title`, `title_link` FROM (`lockmor_content`) WHERE `author_id` = '683' 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.0016	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.0002	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.235.20.17
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

Geomancer

Quest Logging

Experience/Leveling

His Grandest of Low Scribblers

HoHs available (0)

Votes Available (3)

24

XP

1

Submissions

1

Comments

0

HoH Earned

0

Golden's Earned

Author Submissions

Plots

Co-Authored Subs: 0

Comments: 1

Scrolls: 0

Idea Seeds: 0

Browse Geomancer's Submissions

Top Rated

Official Citadel Quest Listing

Unfinished Quests

Recent Citadel Activity of Geomancer

Recent Citadel Activity on Geomancer

Unvoted by Author

Random Idea Seed View All Idea Seeds