Our new forums are now active and these forums will remain online to serve as an archive.


Unfortunately we were unable to import everyone's profiles however, registration is very simple and can be done at: www.vikefans.com/alt-register/


From there on the nav bar click on the Interact menu button and check into the new forums.


If you need assistance with registering, please email us at [email protected]


Please update your bookmarks for the following: http://vikefans.com/forums/the-longship/



Jump to content

Photo

The Official Member Map, v2.0


  • Please log in to reply
94 replies to this topic

#1 OFFLINE   Aesirblood

Aesirblood

    Skald

  • Members
  • PipPipPip
  • 1,761 posts

Posted 17 February 2017 - 12:24 PM

All VikeFan members: There seems to be enough interest in re-creating the member map that once existed but was painful to maintain. I've offered to re-do and caretake version 2.0. If you'd like to participate, the required info is minimal.

 

Users can also remain anonymous if they want to show a location but have privacy concerns. The username will be replaced by Anonymous. You do need to provide City and State either way. Giving only your State will pin the state capital by default, which kind of defeats the purpose.

 

If you're interested, please reply to this post with the following:

  • Username
  • City
  • State
  • Country - Only needed if outside the US
  • Anonymous? y/n

I'm working with Mike to embed the map somewhere on the site and will let everyone know.

 

 

BUT WAIT! THERE'S MORE!

 

Have or know of a great Viking bar in your neck of the woods? Let's build out that map too. Once you get outside MN, it's nice to stumble across a purple place of sanctity.

  • Name of bar
  • City
  • State
  • Any comments (URL, phone number, gameday specials, etc)

Let me know if any questions/concerns.



#2 OFFLINE   Canthony Re: The Official Member Map, v2.0

Canthony

    Berserker

  • Members
  • PipPipPip
  • 10,057 posts
  • LocationBlaine, MN

  • VikeFans Tailgater

Posted 17 February 2017 - 12:33 PM

Canthony

 

Blaine

 

MN

 

 

We have a good Vikings bar when they are playing well of course lol

 

2 Stooges Sports Bar and Billiards

 

Fridley

 

MN

 

http://twostooges.com/


"You need a side of Rice to go along with the sloppy Joe, if you know what I mean"

 

20130513__vikings%20stad%20overhead.jpg


#3 OFFLINE   ArizonaViking Re: The Official Member Map, v2.0

ArizonaViking

    Berserker

  • Members
  • PipPipPip
  • 2,164 posts
  • LocationBuffalo, Minnesota & Tucson, Arizona

Posted 17 February 2017 - 01:43 PM

​ArizonaViking

 

​Tucson

 

Arizona



#4 OFFLINE   JimmyinSD Re: The Official Member Map, v2.0

JimmyinSD

    Chief Cook and Bottle Washer

  • Members
  • PipPipPip
  • 14,180 posts
  • LocationState of Confusion, or is it Delusion?

  • VikeFans Tailgater
    Training Camper 2016

Posted 17 February 2017 - 02:08 PM

I would suggest that for those that arent from a large area that want to be involved but still maintain some level of privacy,  just do a general area?

 

JimmyinSD

NE SD  (kind of along hwy 12 and south of Fargo, ND) ;)


Why Isn't Chuck Foreman
In the Hall Of Fame???

 

My faith is strong, my faith is unwavering and my vision is clear. My purpose will not be denied.


#5 OFFLINE   Fanopurple Re: The Official Member Map, v2.0

Fanopurple

    Berserker

  • Moderators
  • 4,939 posts
  • LocationSo Cal

  • Hammer Head

Posted 17 February 2017 - 02:16 PM

This is a really good idea Aesir....thanks for doing this...

 

Fanopurple......Moorpark....CA


  • Canthony likes this

images_zpspnkfqdhs.jpg

 

"Good is the enemy of great"----Mike Zimmer


#6 OFFLINE   Mike Olson - Admin Re: The Official Member Map, v2.0

Mike Olson - Admin

    Berserker

  • Administrators
  • 1,644 posts

Posted 17 February 2017 - 02:55 PM

Yo Edina MN

 

 

 

But I still represent the East Side of Saint Peezy! Straight outta Hillcrest!


  • Poiple Viking and SkolVikings44 like this

"%20alt=


#7 OFFLINE   Zanary Re: The Official Member Map, v2.0

Zanary

    Profane Philosopher and Bard

  • Members
  • PipPipPip
  • 5,062 posts
  • LocationKent, WA

  • Hammer Head

Posted 17 February 2017 - 03:24 PM

Zanary
Kent

WA

As far as a good Vikings bar...there's one in the Ballard section of Seattle:
Zayda Buddy's
(they pride themselves on Minnesota-themed food...lots of stuff available with gravy and cheese curds)
The one problem: it's not a huge place, so getting a seat means being there more than two hours before game time.




 


OK, now that the dust has settled hereabouts...is 2017 our year?

 

 


#8 OFFLINE   pikvikes Re: The Official Member Map, v2.0

pikvikes

    Warrior

  • Members
  • PipPipPip
  • 253 posts
  • LocationPickstown, SD

Posted 17 February 2017 - 03:27 PM

pikvikes

 

Pickstown

 

South Dakota

 

Closest Viking bar would be the "Blue Moon" in Armour, SD 



#9 OFFLINE   Al (The Lochstar) Heurung Re: The Official Member Map, v2.0

Al (The Lochstar) Heurung

    The other white meat

  • ContentCollaborator
  • PipPipPip
  • 4,021 posts

  • VikeFans Tailgater
    Hammer Head
    Training Camper 2014
    Training Camper 2015
    Training Camper 2016

Posted 17 February 2017 - 03:35 PM

Lochstar

Stewartville (Rochester)

MN

Vikings bars here suck. In fact I think they demolished the building of the old viking lounge in a hotel now.


I am the Lochstar!

www.radioriff.com - The Temple of ROCK

Twitter - @IamTheLochstar

Join me here Fridays at 7 PM Central for the LochNess Chronicles! Requests taken in the chat room and be sure to post in the OBM Friday Drinking Thread!

 

"My faith is strong, my faith is unwavering and my vision is clear. My purpose will not be denied." -- Teddy B


#10 OFFLINE   Tom Moore Re: The Official Member Map, v2.0

Tom Moore

    Berserker

  • ContentProviders
  • 7,922 posts
  • LocationPlano, Texas

  • Hammer Head
    Training Camper 2014
    Training Camper 2015
    Training Camper 2016

Posted 17 February 2017 - 03:38 PM

All VikeFan members: There seems to be enough interest in re-creating the member map that once existed but was painful to maintain. I've offered to re-do and caretake version 2.0. If you'd like to participate, the required info is minimal.

 

Users can also remain anonymous if they want to show a location but have privacy concerns. The username will be replaced by Anonymous. You do need to provide City and State either way. Giving only your State will pin the state capital by default, which kind of defeats the purpose.

 

If you're interested, please reply to this post with the following:

  • Username
  • City
  • State
  • Country - Only needed if outside the US
  • Anonymous? y/n

I'm working with Mike to embed the map somewhere on the site and will let everyone know.

 

 

BUT WAIT! THERE'S MORE!

 

Have or know of a great Viking bar in your neck of the woods? Let's build out that map too. Once you get outside MN, it's nice to stumble across a purple place of sanctity.

  • Name of bar
  • City
  • State
  • Any comments (URL, phone number, gameday specials, etc)

Let me know if any questions/concerns.

 

Tom Moore

Prosper (Dallas)

Texas



#11 OFFLINE   MagnusEugeneHefeweizen Re: The Official Member Map, v2.0

MagnusEugeneHefeweizen

    Warrior

  • Members
  • PipPipPip
  • 505 posts
  • LocationCalifornia

Posted 17 February 2017 - 03:50 PM

Magnus

Folsom

California



#12 OFFLINE   Aesirblood Re: The Official Member Map, v2.0

Aesirblood

    Skald

  • Members
  • PipPipPip
  • 1,761 posts

Posted 17 February 2017 - 03:58 PM

I would suggest that for those that arent from a large area that want to be involved but still maintain some level of privacy,  just do a general area?

 

JimmyinSD

NE SD  (kind of along hwy 12 and south of Fargo, ND) ;)

 

That's not going to work. The map leverages geo-coordinates tied to known locations, much in the same way Google maps does. There is no location established for general direction, so it wouldn't know where to pin NE anyplace.



#13 OFFLINE   JimmyinSD Re: The Official Member Map, v2.0

JimmyinSD

    Chief Cook and Bottle Washer

  • Members
  • PipPipPip
  • 14,180 posts
  • LocationState of Confusion, or is it Delusion?

  • VikeFans Tailgater
    Training Camper 2016

Posted 17 February 2017 - 03:59 PM

That's not going to work. The map leverages geo-coordinates tied to known locations, much in the same way Google maps does. There is no location established for general direction, so it wouldn't know where to pin NE anyplace.

 

put me down as Summit, SD....close enough.


Why Isn't Chuck Foreman
In the Hall Of Fame???

 

My faith is strong, my faith is unwavering and my vision is clear. My purpose will not be denied.


#14 OFFLINE   eckman Re: The Official Member Map, v2.0

eckman

    Warrior

  • Members
  • PipPipPip
  • 542 posts
  • LocationMinneapolis

Posted 17 February 2017 - 04:21 PM

eckman
Minneapolis
MN

#15 OFFLINE   BigAl99 Re: The Official Member Map, v2.0

BigAl99

    Berserker

  • Members
  • PipPipPip
  • 1,548 posts
  • LocationCentral Iowa

Posted 17 February 2017 - 05:08 PM

BigAl99

Ames

IA

Earth

Seminonomus ( view at your own risk)

 

Wallaby's (Good Food, Beer, Cyclone Nation, lots of Harrison Barnes, Freddy "The Mayor" Hoiberg and Johnny Orr stuff, )

http://www.wallabysbarandgrille.com/

 

Best Little Tap room  around

 

http://www.alluvialbrewing.com/brews/

 

Both within walking distance of the Estate

 

Hillcrest, what, that the Bedroom community for Hayden Heights.  ;)



#16 OFFLINE   Hidalgo Re: The Official Member Map, v2.0

Hidalgo

    Warrior

  • Members
  • PipPipPip
  • 550 posts
  • LocationHidalgo, IL

Posted 17 February 2017 - 06:17 PM

  • Username: Hidalgo
  • City: Hidalgo
  • State: IL
  • Country - Only needed if outside the US
  • Anonymous? N
  • Not a Viking bar within 120 miles that I'm aware of. If I go to a local bar for a Thursday/Sunday night game, they usually kick me out at halftime so they can close up and go home


#17 OFFLINE   GeorgiaVike Re: The Official Member Map, v2.0

GeorgiaVike

    Berserker

  • Members
  • PipPipPip
  • 7,684 posts
  • LocationAtlanta, GA

  • Hammer Head
    VikeFans Tailgater

Posted 17 February 2017 - 06:34 PM

GeorgiaVike
McDonough
GA

#18 OFFLINE   fessvike Re: The Official Member Map, v2.0

fessvike

    Oarsman

  • Members
  • PipPip
  • 41 posts

Posted 17 February 2017 - 06:38 PM

fessvike

 

fessenden

 

nd



#19 OFFLINE   Caactorvike Re: The Official Member Map, v2.0

Caactorvike

    Berserker

  • ContentCollaborator
  • PipPipPip
  • 2,048 posts
  • LocationLos Angeles

  • Hammer Head

Posted 17 February 2017 - 07:40 PM

Caactorvike (Ivar Brogger)
Sherman Oaks (Los Angeles)
CA.

#20 OFFLINE   BrickVike Re: The Official Member Map, v2.0

BrickVike

    Warrior

  • Members
  • PipPipPip
  • 533 posts
  • LocationHobart, IN

Posted 17 February 2017 - 07:48 PM

BrickVike

 

Hobart

 

Indiana


  • Riphawkins likes this




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Debug Information (Toggle Debug Information)

IPSDebug Messages
Retreiving user agent information from the DB
Creating GUEST session: 3b257f48eeeae72d9d03f7d1cee37f51
makeSeoTitle (guest) called
Gateway file confirmed: html
Skin set not found, setting default. Using set #4
Setting current module to: forums and current section to: topics

IPSMember Cache Actions
ADDED: Member ID: 6 with tables pfields_content,profile_portal,groups key (df28af09ab8ba146fbf4f722a6e192c4)
ADDED: Member ID: 36 with tables pfields_content,profile_portal,groups key (df28af09ab8ba146fbf4f722a6e192c4)
ADDED: Member ID: 1806 with tables pfields_content,profile_portal,groups key (df28af09ab8ba146fbf4f722a6e192c4)
ADDED: Member ID: 535 with tables pfields_content,profile_portal,groups key (df28af09ab8ba146fbf4f722a6e192c4)

(99) Included Files
/home/vfroot/public_html/forum/index.php
/home/vfroot/public_html/forum/initdata.php
/home/vfroot/public_html/forum/admin/sources/base/ipsRegistry.php
/home/vfroot/public_html/forum/admin/sources/base/ipsController.php
/home/vfroot/public_html/forum/admin/sources/base/core.php
/home/vfroot/public_html/forum/admin/sources/base/ipsMember.php
/home/vfroot/public_html/forum/admin/extensions/coreVariables.php
/home/vfroot/public_html/forum/conf_global.php
/home/vfroot/public_html/forum/ips_kernel/classDbMysql.php
/home/vfroot/public_html/forum/ips_kernel/classDb.php
/home/vfroot/public_html/forum/ips_kernel/classDbMysqliClient.php
/home/vfroot/public_html/forum/cache/furlCache.php
/home/vfroot/public_html/forum/admin/applications/forums/extensions/coreVariables.php
/home/vfroot/public_html/forum/cache/globalCaches.php
/home/vfroot/public_html/forum/admin/sources/classes/session/publicSessions.php
/home/vfroot/public_html/forum/admin/sources/classes/session/ssoPublicSessions.php
/home/vfroot/public_html/forum/admin/applications/forums/extensions/coreExtensions.php
/home/vfroot/public_html/forum/admin/sources/classes/useragents/userAgentFunctions.php
/home/vfroot/public_html/forum/admin/sources/classes/class_localization.php
/home/vfroot/public_html/forum/admin/sources/classes/class_public_permissions.php
/home/vfroot/public_html/forum/hooks/tapatalk_permissions_8c9c8c8dfb96adbafc0b71adf25c4623.php
/home/vfroot/public_html/forum/admin/applications/forums/app_class_forums.php
/home/vfroot/public_html/forum/admin/applications/forums/sources/classes/forums/class_forums.php
/home/vfroot/public_html/forum/admin/sources/classes/tags/bootstrap.php
/home/vfroot/public_html/forum/admin/sources/classes/tags/abstract.php
/home/vfroot/public_html/forum/admin/applications/forums/extensions/tags/topics.php
/home/vfroot/public_html/forum/admin/applications/forums/sources/classes/topics.php
/home/vfroot/public_html/forum/admin/sources/classes/class_reputation_cache.php
/home/vfroot/public_html/forum/admin/sources/classes/itemmarking/classItemMarking.php
/home/vfroot/public_html/forum/admin/sources/classes/output/publicOutput.php
/home/vfroot/public_html/forum/hooks/tapatalk_output_3fb5ba8c1d6544eb389cbe21a36d66aa.php
/home/vfroot/public_html/forum/hooks/galleryLightbox_ad5725e344e9977727a3dfc622c27ac9.php
/home/vfroot/public_html/forum/admin/sources/classes/output/formats/coreOutput.php
/home/vfroot/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php
/home/vfroot/public_html/forum/cache/lang_cache/1/core_public_global.php
/home/vfroot/public_html/forum/admin/applications/forums/modules_public/forums/topics.php
/home/vfroot/public_html/forum/hooks/MiserableThreads_e6e00de5c76f1bd211fd6852457f6f48.php
/home/vfroot/public_html/forum/hooks/dp3_BanFromTopicFunctions_763cd8f86b0b363e95ac10c8322681ed.php
/home/vfroot/public_html/forum/cache/lang_cache/1/forums_public_topic.php
/home/vfroot/public_html/forum/admin/applications/forums/sources/classes/moderate.php
/home/vfroot/public_html/forum/admin/sources/classes/like/composite.php
/home/vfroot/public_html/forum/admin/applications/forums/extensions/like/topics.php
/home/vfroot/public_html/forum/cache/lang_cache/1/forums_public_forums.php
/home/vfroot/public_html/forum/cache/skin_cache/cacheid_4/skin_global.php
/home/vfroot/public_html/forum/cache/skin_cache/cacheid_4/skin_global_other.php
/home/vfroot/public_html/forum/cache/lang_cache/1/forums_public_boards.php
/home/vfroot/public_html/forum/cache/lang_cache/1/core_public_editors.php
/home/vfroot/public_html/forum/admin/sources/classes/customfields/profileFields.php
/home/vfroot/public_html/forum/ips_kernel/classCustomFields.php
/home/vfroot/public_html/forum/cache/skin_cache/cacheid_4/skin_topic.php
/home/vfroot/public_html/forum/admin/sources/classes/text/parser.php
/home/vfroot/public_html/forum/admin/sources/classes/text/parser/bbcode.php
/home/vfroot/public_html/forum/admin/sources/classes/text/parser/html.php
/home/vfroot/public_html/forum/admin/sources/classes/text/parser/bbcode/defaults.php
/home/vfroot/public_html/forum/admin/sources/classes/ads.php
/home/vfroot/public_html/forum/admin/sources/classes/session/api.php
/home/vfroot/public_html/forum/admin/sources/classes/tags/search/bootstrap.php
/home/vfroot/public_html/forum/admin/sources/classes/tags/search/sql.php
/home/vfroot/public_html/forum/admin/applications/core/sources/classes/reportLibrary.php
/home/vfroot/public_html/forum/cache/lang_cache/1/forums_simple_tag.php
/home/vfroot/public_html/forum/admin/sources/classes/editor/composite.php
/home/vfroot/public_html/forum/ips_kernel/HTMLPurifier/HTMLPurifier.auto.php
/home/vfroot/public_html/forum/ips_kernel/HTMLPurifier/HTMLPurifier/Bootstrap.php
/home/vfroot/public_html/forum/ips_kernel/HTMLPurifier/HTMLPurifier.autoload.php
/home/vfroot/public_html/forum/admin/sources/classes/text/parser/legacy.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/sources/hooks.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/app_class_ccs.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/sources/functions.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/extensions/furlTemplates.php
/home/vfroot/public_html/forum/cache/skin_cache/cacheid_4/skin_ccs_global.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/sources/pages.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/sources/blocks/adminInterface.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/sources/blocks/custom/admin.php
/home/vfroot/public_html/forum/ips_kernel/classTemplateEngine.php
/home/vfroot/public_html/forum/admin/sources/handlers/han_login.php
/home/vfroot/public_html/forum/admin/sources/loginauth/login_core.php
/home/vfroot/public_html/forum/admin/sources/loginauth/login_interface.php
/home/vfroot/public_html/forum/admin/sources/loginauth/internal/auth.php
/home/vfroot/public_html/forum/hooks/miserablemessage_01bf86440b41a58fe91cfb3900aa4e53.php
/home/vfroot/public_html/forum/hooks/tapatalk_banner_body_3ea79c9aeb6a6d409799b6cf0d1e1cce.php
/home/vfroot/public_html/forum/hooks/tapatalk_banner_head_8e9f3363fdb6f43141664c922fb37783.php
/home/vfroot/public_html/forum/mobiquo/smartbanner/head.inc.php
/home/vfroot/public_html/forum/hooks/newMembers_message_a00cab2b2efb7afa6bb4acaf455ef1e6.php
/home/vfroot/public_html/forum/hooks/chatTabCount_1dd7ef87093d950cb1a90e8db84c8250.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ipchat/sources/hooks.php
/home/vfroot/public_html/forum/cache/skin_cache/cacheid_4/skin_ipchat.php
/home/vfroot/public_html/forum/hooks/chatNewWindow_f124959d7a650eb71301803c52d35b80.php
/home/vfroot/public_html/forum/hooks/dp3_BanFromTopicButton_255c6175145ec022c234a4116cbc6b26.php
/home/vfroot/public_html/forum/hooks/blogsBlogThisShow_4da047d4922a6bb7986c2de7dd00b429.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/blog/sources/classes/hooks/gateway.php
/home/vfroot/public_html/forum/cache/lang_cache/1/blog_public_blog.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/blog/sources/classes/blogFunctions.php
/home/vfroot/public_html/forum/hooks/blogsBlogThisLink_9a6c020448d76db2bf37828020346e60.php
/home/vfroot/public_html/forum/cache/skin_cache/cacheid_4/skin_blog_hooks.php
/home/vfroot/public_html/forum/hooks/onlineStatusInTopics_81aef8a17612c3b792ab7cef872a2af8.php
/home/vfroot/public_html/forum/hooks/topicReplies_d548d2204f5458a8a6c279c3560ec88b.php
/home/vfroot/public_html/forum/hooks/contentPromoteToArticle_8b86c803651d16e9fe16472b53bd36b7.php
/home/vfroot/public_html/forum/admin/applications_addon/ips/ccs/sources/promote.php
/home/vfroot/public_html/forum/cache/lang_cache/1/ccs_public_lang.php

Loaded Caches
TOTAL: 0bytes

Loaded Classes In ipsRegistry::getClass()

FORM and GET Input
module = forums
section = topics
request_method = get
showtopic = 58579
app = forums
t = 58579
last_visit = 1544535451
f = 2
start =
page =
view =
selectedpids =
selectedpidcount = 0
_isDatabase =

SKIN, MEMBER & TASK Info
set_id = 4
set_name = VikeFans
set_key =
set_parent_id = 0
set_parent_array = a:0:{}
set_child_array = a:0:{}
set_permissions = *
set_is_default = 1
set_author_name = VikeFans
set_author_url =
set_image_dir = master
set_emo_dir = default
set_css_inline = 1
set_css_groups = a:26:{s:6:"1.3940";a:2:{s:9:"css_group";s:15:"calendar_select";s:12:"css_position";s:1:"1";}s:5:"0.422";a:2:{s:9:"css_gr...
set_added = 1369922274
set_updated = 1491923257
set_output_format = html
set_locked_uagent = a:2:{s:6:"groups";a:0:{}s:7:"uagents";a:0:{}}
set_hide_from_list = 0
set_minify = 1
set_master_key = root
set_order = 1
set_by_skin_gen = 0
set_skin_gen_data =
_youCanUse = 1
_gatewayExclude =
_skincacheid = 4
_csscacheid = css_4
Next task = 09 December 2018 - 10:13 AM
Time now = Today, 07:37 AM
Timestamp Now = 1544535452

MEMBER: last_visit: 1544535451 / Today, 07:37 AM

MEMBER: uagent_key: __NONE__

MEMBER: uagent_type:

MEMBER: uagent_version: 0


Loaded PHP Templates
skin_global, skin_global_other, skin_topic, skin_ccs_global, skin_ccs, skin_ipchat, skin_blog_hooks
skin_global_4, skin_global_other_4, skin_topic_4, skin_ccs_global_4, skin_ipchat_4, skin_blog_hooks_4
core_public_global, forums_public_topic, forums_public_forums, forums_public_boards, core_public_editors, forums_simple_tag, blog_public_blog, ccs_public_lang

Queries Used

SELECT * FROM ibps_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','chatting','ccs_menu' )

DELETE FROM ibps_sessions WHERE ip_address='162.158.79.254'

SELECT t.*,xxx.* FROM ibps_topics t LEFT JOIN ibps_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=58579

SELECT f.*,p.* FROM ibps_forums f LEFT JOIN ibps_permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )

SELECT * FROM ibps_skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')

SELECT banned_members FROM ibps_topics WHERE tid = 58579

SELECT * FROM ibps_topic_ratings WHERE rating_tid=58579 and rating_member_id=0

SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM ibps_posts WHERE topic_id=58579 AND queued=0 ORDER BY pid asc LIMIT 0,20 ) z LEFT JOIN ibps_posts p ON ( p.pid=z.pid ) LEFT JOIN ibps_members m ON ( m.member_id=p.author_id ) LEFT JOIN ibps_profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN ibps_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN ibps_pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN ibps_reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=0 ) LEFT JOIN ibps_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN ibps_content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN ibps_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590868,'<p>All VikeFan members: There seems to be enough interest in re-creating the member map that once existed but was painful to maintain. I\'ve offered to re-do and caretake version 2.0. If you\'d like to participate, the required info is minimal.</p>\n<p>&nbsp;</p>\n<p>Users can also remain anonymous if they want to show a location but have privacy concerns. The username will be replaced by Anonymous. You do need to provide City and State either way. Giving only your State will pin the state capital by default, which kind of defeats the purpose.</p>\n<p>&nbsp;</p>\n<p>If you\'re interested, please reply to this post with the following:</p>\n<ul><li>Username</li>\n<li>City</li>\n<li>State</li>\n<li>Country - Only needed if outside the US</li>\n<li>Anonymous? y/n</li>\n</ul><p>I\'m working with Mike to embed the map somewhere on the site and will let everyone know.</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p><strong>BUT WAIT! THERE\'S MORE!</strong></p>\n<p>&nbsp;</p>\n<p>Have or know of a great Viking bar in your neck of the woods? Let\'s build out that map too. Once you get outside MN, it\'s nice to stumble across a purple place of sanctity.</p>\n<ul><li>Name of bar</li>\n<li>City</li>\n<li>State</li>\n<li>Any comments (URL, phone number, gameday specials, etc)</li>\n</ul><p>Let me know if any questions/concerns.</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590868'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590868,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590870,'<p>Canthony</p>\n<p>&nbsp;</p>\n<p>Blaine</p>\n<p>&nbsp;</p>\n<p>MN</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>We have a good Vikings bar when they are playing well of course lol</p>\n<p>&nbsp;</p>\n<p>2 Stooges Sports Bar and Billiards</p>\n<p>&nbsp;</p>\n<p>Fridley</p>\n<p>&nbsp;</p>\n<p>MN</p>\n<p>&nbsp;</p>\n<p><a href=\'http://twostooges.com/\' class=\'bbc_url\' title=\'External link\' rel=\'nofollow external\'>http://twostooges.com/</a></p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590870'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590870,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590892,'<p><span style=\"font-family:tahoma, geneva, sans-serif\"><span style=\"font-size:18px\">​ArizonaViking</span></span></p>\n<p>&nbsp;</p>\n<p><span style=\"font-family:tahoma, geneva, sans-serif\"><span style=\"font-size:18px\">​Tucson</span></span></p>\n<p>&nbsp;</p>\n<p><span style=\"font-family:tahoma, geneva, sans-serif\"><span style=\"font-size:18px\">Arizona</span></span></p>',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590892'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590892,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590908,'<p>I would suggest that for those that arent from a large area that want to be involved but still maintain some level of privacy, &nbsp;just do a general area?</p>\n<p>&nbsp;</p>\n<p>JimmyinSD</p>\n<p>NE SD &nbsp;(kind of along hwy 12 and south of Fargo, ND) <img src=\'http://vikefans.com/forum/public/style_emoticons/default/wink.png\' class=\'bbc_emoticon\' alt=\';)\' /></p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590908'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590908,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590914,'<p>This is a really good idea Aesir....thanks for doing this...</p>\n<p>&nbsp;</p>\n<p>Fanopurple......Moorpark....CA</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590914'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590914,1,1544535451,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"590914\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:516;a:2:{s:1:\"n\";s:8:\"Canthony\";s:1:\"s\";s:8:\"canthony\";}}s:9:\"memberIds\";a:1:{i:0;s:3:\"516\";}}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590928,'<p>Yo Edina MN</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>But I still represent the East Side of Saint Peezy! Straight outta Hillcrest!</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590928'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590928,2,1544535451,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"590928\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:24;a:2:{s:1:\"n\";s:13:\"Poiple Viking\";s:1:\"s\";s:13:\"poiple-viking\";}i:34;a:2:{s:1:\"n\";s:13:\"SkolVikings44\";s:1:\"s\";s:13:\"skolvikings44\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"24\";i:1;s:2:\"34\";}}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590939,'<p>Zanary<br>\nKent</p>\n<p>WA</p>\n<p>\nAs far as a good Vikings bar...there\'s one in the Ballard section of Seattle:<br>\nZayda Buddy\'s<br>\n(they pride themselves on Minnesota-themed food...lots of stuff available with gravy and cheese curds)<br>\nThe one problem: it\'s not a huge place, so getting a seat means being there more than two hours before game time.<br><br><br><br><br>\n&nbsp;</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590939'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590939,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590942,'<p>pikvikes</p>\n<p>&nbsp;</p>\n<p>Pickstown</p>\n<p>&nbsp;</p>\n<p>South Dakota</p>\n<p>&nbsp;</p>\n<p>Closest Viking bar would be the \"Blue Moon\" in Armour, SD&nbsp;</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='590942'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590942'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590942,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('e9da851862df6e80344f0f2002ceb621','a17de1b4e5015b2ca6ba5cb6ca3b488d',590942,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590942'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590942,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590943,'<p>Lochstar</p>\n<p>Stewartville (Rochester)</p>\n<p>MN</p>\n<p>Vikings bars here suck. In fact I think they demolished the building of the old viking lounge in a hotel now.</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590943'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590943,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590945,'<blockquote class=\"ipsBlockquote\" data-author=\"Aesirblood\" data-cid=\"590868\" data-time=\"1487355847\">\n<div>\n<p>All VikeFan members: There seems to be enough interest in re-creating the member map that once existed but was painful to maintain. I\'ve offered to re-do and caretake version 2.0. If you\'d like to participate, the required info is minimal.</p>\n<p>&nbsp;</p>\n<p>Users can also remain anonymous if they want to show a location but have privacy concerns. The username will be replaced by Anonymous. You do need to provide City and State either way. Giving only your State will pin the state capital by default, which kind of defeats the purpose.</p>\n<p>&nbsp;</p>\n<p>If you\'re interested, please reply to this post with the following:</p>\n<ul><li>Username</li>\n<li>City</li>\n<li>State</li>\n<li>Country - Only needed if outside the US</li>\n<li>Anonymous? y/n</li>\n</ul><p>I\'m working with Mike to embed the map somewhere on the site and will let everyone know.</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p><strong>BUT WAIT! THERE\'S MORE!</strong></p>\n<p>&nbsp;</p>\n<p>Have or know of a great Viking bar in your neck of the woods? Let\'s build out that map too. Once you get outside MN, it\'s nice to stumble across a purple place of sanctity.</p>\n<ul><li>Name of bar</li>\n<li>City</li>\n<li>State</li>\n<li>Any comments (URL, phone number, gameday specials, etc)</li>\n</ul><p>Let me know if any questions/concerns.</p>\n</div>\n</blockquote>\n<p>&nbsp;</p>\n<p>Tom Moore</p>\n<p>Prosper (Dallas)</p>\n<p>Texas</p>',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590945'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590945,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590949,'<p>Magnus</p>\n<p>Folsom</p>\n<p>California</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590949'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590949,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590957,'<blockquote class=\"ipsBlockquote\" data-author=\"JimmyinSD\" data-cid=\"590908\" data-time=\"1487362121\">\n<div>\n<p>I would suggest that for those that arent from a large area that want to be involved but still maintain some level of privacy, &nbsp;just do a general area?</p>\n<p>&nbsp;</p>\n<p>JimmyinSD</p>\n<p>NE SD &nbsp;(kind of along hwy 12 and south of Fargo, ND) <img src=\'http://vikefans.com/forum/public/style_emoticons/default/wink.png\' class=\'bbc_emoticon\' alt=\';)\' /></p>\n</div>\n</blockquote>\n<p>&nbsp;</p>\n<p>That\'s not going to work. The map leverages geo-coordinates tied to known locations, much in the same way Google maps does. There is no location established for general direction, so it wouldn\'t know where to pin NE anyplace.</p>',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590957'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590957,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590958,'<blockquote class=\"ipsBlockquote\" data-author=\"Aesirblood\" data-cid=\"590957\" data-time=\"1487368705\">\n<div>\n<p>That\'s not going to work. The map leverages geo-coordinates tied to known locations, much in the same way Google maps does. There is no location established for general direction, so it wouldn\'t know where to pin NE anyplace.</p>\n</div>\n</blockquote>\n<p>&nbsp;</p>\n<p>put me down as Summit, SD....close enough.</p>',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590958'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590958,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590966,'eckman<br>\nMinneapolis<br>\nMN',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590966'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590966,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590983,'<p>BigAl99</p>\n<p>Ames</p>\n<p>IA</p>\n<p>Earth</p>\n<p>Seminonomus ( view at your own risk)</p>\n<p>&nbsp;</p>\n<p>Wallaby\'s (Good Food, Beer, Cyclone Nation, lots of Harrison Barnes, Freddy \"The Mayor\" Hoiberg and Johnny Orr stuff, )</p>\n<p><a href=\'http://www.wallabysbarandgrille.com/\' class=\'bbc_url\' title=\'External link\' rel=\'nofollow external\'>http://www.wallabysbarandgrille.com/</a></p>\n<p>&nbsp;</p>\n<p>Best Little Tap room&nbsp; around</p>\n<p>&nbsp;</p>\n<p><a href=\'http://www.alluvialbrewing.com/brews/\' class=\'bbc_url\' title=\'External link\' rel=\'nofollow external\'>http://www.alluvialbrewing.com/brews/</a></p>\n<p>&nbsp;</p>\n<p>Both within walking distance of the Estate</p>\n<p>&nbsp;</p>\n<p>Hillcrest, what, that the Bedroom community for Hayden Heights.&nbsp; <img src=\'http://vikefans.com/forum/public/style_emoticons/default/wink.png\' class=\'bbc_emoticon\' alt=\';)\' /></p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='590983'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',590983,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591004,'<ul><li><span style=\"font-size:18px\">Username: Hidalgo</span></li>\n<li><span style=\"font-size:18px\">City: Hidalgo</span></li>\n<li><span style=\"font-size:18px\">State: IL</span></li>\n<li><span style=\"font-size:18px\">Country - Only needed if outside the US</span></li>\n<li><span style=\"font-size:18px\">Anonymous? N</span></li>\n<li><span style=\"font-size:18px\">Not a Viking bar within 120 miles that I\'m aware of. If I go to a local bar for a Thursday/Sunday night game, they usually kick me out at halftime so they can close up and go home</span></li>\n</ul>',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='591004'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',591004,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591006,'GeorgiaVike<br>\nMcDonough<br>\nGA',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='591006'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',591006,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591007,'<p>fessvike</p>\n<p>&nbsp;</p>\n<p>fessenden</p>\n<p>&nbsp;</p>\n<p>nd</p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='591007'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',591007,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591024,'Caactorvike (Ivar Brogger)<br>\nSherman Oaks (Los Angeles)<br>\nCA.',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='591024'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',591024,0,1544535451,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

INSERT INTO ibps_content_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591029,'<p><sub><span style=\"font-size:14px\"><span style=\"font-size:18px\">BrickVike</span></span></sub></p>\n<p>&nbsp;</p>\n<p><sub><span style=\"font-size:14px\"><span style=\"font-size:18px\">Hobart</span></span></sub></p>\n<p>&nbsp;</p>\n<p><sub><span style=\"font-size:18px\">Indiana</span></sub></p>\n',1544535451) ON DUPLICATE KEY UPDATE cache_content_id=VALUES(cache_content_id),cache_content=VALUES(cache_content),cache_updated=VALUES(cache_updated)

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='591029'

INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',591029,1,1544535451,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"591029\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:1484;a:2:{s:1:\"n\";s:10:\"Riphawkins\";s:1:\"s\";s:10:\"riphawkins\";}}s:9:\"memberIds\";a:1:{i:0;s:4:\"1484\";}}s:12:\"cache_expire\";i:1544621851;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)

SELECT s.*, s.id as row_session_id,m.* FROM ibps_sessions s LEFT JOIN ibps_members m ON ( m.member_id=s.member_id ) WHERE s.id='3b257f48eeeae72d9d03f7d1cee37f51' OR (s.current_appcomponent='forums' AND s.running_time > 1544534551 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=58579)

SELECT * FROM ibps_core_like_cache WHERE like_cache_id='e313f6c7d381253a1b00c5ba1f824993'

SELECT f.*,p.* FROM ibps_forums f LEFT JOIN ibps_permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0

SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM ibps_core_tags tg LEFT JOIN ibps_topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN ibps_members m ON (last_poster_id=m.member_id) LEFT JOIN ibps_profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN ibps_core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=58579 AND tg.tag_text IN ('on topic') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM ibps_core_tags_perms WHERE ( ( FIND_IN_SET(2,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibps_members m LEFT JOIN ibps_pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN ibps_profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN ibps_groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN ibps_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (6,36,1806)

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibps_members m LEFT JOIN ibps_pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN ibps_profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN ibps_groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN ibps_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=535

SELECT b.*,t.tpb_name FROM ibps_ccs_blocks b LEFT JOIN ibps_ccs_template_blocks t ON ( t.tpb_id=b.block_template ) WHERE b.block_active=1

SELECT * FROM ibps_ccs_template_blocks WHERE tpb_name='block__custom_50'

UPDATE ibps_ccs_template_blocks SET tpb_content='<php>ob_start();\n$this->DB->query( \"SELECT * from ibps_topics where ibps_topics.forum_id in (2,15) and ibps_topics.starter_id = 58 order by start_date DESC limit 15\" );\r\n\r\nprint \"\r\n\r\n <style>\r\n #newsMarquee A{\r\n color: #ffffff;\r\n }\r\n\r\n </style>\r\n <marquee id=\'newsMarquee\' behavior=\'scroll\' direction=\'left\' \r\n onmouseover=\'this.stop();\' \r\n onmouseout=\'this.start();\'\r\n SCROLLamount=3\r\n \r\n bgcolor=\'#000000\'\r\n>\r\n\";\r\n\r\nwhile( $r = $this->DB->fetch() )\r\n{\r\n\r\n $url=\"http://{parse block=\'siteurl\'}/index.php?/topic/\".$r[\'tid\'].\"-\".$r[\'title_seo\'];\r\n print \"<a href=\'\".$url.\"\' target=\'_blank\'>\".$r[\'title\'].\"</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\";\r\n}\r\nprint \"\r\n </marquee>\r\n\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();</php>' WHERE tpb_id=64

INSERT INTO ibps_ccs_template_cache (`cache_type`,`cache_type_id`,`cache_content`) VALUES('block',64,'/* -- block__custom_50 --*/\nfunction block__custom_50($title=\"\",$content=\"\") {\n$IPBHTML = \"\";\n\nob_start();\n$this->DB->query( \"SELECT * from ibps_topics where ibps_topics.forum_id in (2,15) and ibps_topics.starter_id = 58 order by start_date DESC limit 15\" );\r\n\r\nprint \"\r\n\r\n <style>\r\n #newsMarquee A{\r\n color: #ffffff;\r\n }\r\n\r\n </style>\r\n <marquee id=\'newsMarquee\' behavior=\'scroll\' direction=\'left\' \r\n onmouseover=\'this.stop();\' \r\n onmouseout=\'this.start();\'\r\n SCROLLamount=3\r\n \r\n bgcolor=\'#000000\'\r\n>\r\n\";\r\n\r\nwhile( $r = $this->DB->fetch() )\r\n{\r\n\r\n $url=\"http://{parse block=\'siteurl\'}/index.php?/topic/\".$r[\'tid\'].\"-\".$r[\'title_seo\'];\r\n print \"<a href=\'\".$url.\"\' target=\'_blank\'>\".$r[\'title\'].\"</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\";\r\n}\r\nprint \"\r\n </marquee>\r\n\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();\n$IPBHTML .= \"\";\nreturn $IPBHTML;\n}\n') ON DUPLICATE KEY UPDATE cache_type=VALUES(cache_type),cache_type_id=VALUES(cache_type_id),cache_content=VALUES(cache_content)

SELECT cache_content FROM ibps_ccs_template_cache WHERE cache_type='full'

SELECT * from ibps_topics where ibps_topics.forum_id in (2,15) and ibps_topics.starter_id = 58 order by start_date DESC limit 15

SELECT * FROM ibps_ccs_template_blocks WHERE tpb_name='block__custom_53'

UPDATE ibps_ccs_template_blocks SET tpb_content='<php>ob_start();\necho\"www.vikefans.com\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();</php>' WHERE tpb_id=67

INSERT INTO ibps_ccs_template_cache (`cache_type`,`cache_type_id`,`cache_content`) VALUES('block',67,'/* -- block__custom_53 --*/\nfunction block__custom_53($title=\"\",$content=\"\") {\n$IPBHTML = \"\";\n\nob_start();\necho\"www.vikefans.com\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();\n$IPBHTML .= \"\";\nreturn $IPBHTML;\n}\n') ON DUPLICATE KEY UPDATE cache_type=VALUES(cache_type),cache_type_id=VALUES(cache_type_id),cache_content=VALUES(cache_content)

SELECT * FROM ibps_cache_store WHERE cs_key IN ( 'blogmods' )

SELECT * FROM ibps_blog_this WHERE bt_app='forums' AND bt_id1=58579

SHUTDOWN: INSERT INTO ibps_sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('3b257f48eeeae72d9d03f7d1cee37f51','',0,2,0,1544535451,'162.158.79.254','CCBot/2.0 (https://commoncrawl.org/faq/)',0,'forums','forums','topics','topic',58579,'forum',0,'',0,'__NONE__',0,'',0)

SHUTDOWN: INSERT INTO ibps_topic_views (`views_tid`) VALUES(58579)