Kanji
ねえ、ちょっとおかしなこと言ってもいい？
そういうの大好きだ！
どこにも出口のない日々が
突然に変わりそう
僕も同じこと考えてた！だって
どこにも居場所のない日々で
探し続けていたこんな人を
変わる（君と出会えて）すべてが
初めてのときめきだわ（初めてのときめきだよ）
二人だから
とびら開けて
飛び出せるよ
今（今）もう（もう）
二人だから
教えてよ
え？
なにが好きか？
サンドイッチ
僕と同じじゃないか
私たちはよく似てるね
あ！またそろった！
考えてること
感じていること
そう（本当）に
似てるね
ひとり（ひとり）寂しい日々に
もうお別れしよう
二人だから
とびら開けて
飛び出せるの
今（今）もう（もう）
二人だから
おかしなこと言ってもいい？
ふふふ
僕と結婚してくれ！
もっとおかしなこと言ってもいい？もちろん！
Romaji
nee, chotto okashi na koto ittemo ii?
souiu no daisuki da!
dokonimo deguchi no nai hibi ga
totsuzen ni kawarisou
boku mo onaji koto kangaeteta! datte,
dokonimo ibasho no nai hibi de
sagashi tsudzuketeita konna hito wo
kawaru (kimi to deaete) subete ga
hajimete no tokimeki da wa (hajimete no tokimeki da yo)
futari dakara
tobira akete
tobidaseru yo
ima (ima) mou (mou)
futari dakara
oshiete te yo
e?
nani ga suki ka?
sandoicchi
boku to onaji janai ka!
watashitachi ha yoku niteru ne
a! mata sorotta!
kangaeteru koto
kanjiteiru koto
sou (hontou) ni
niteru ne
hitori (hitori) sabishii hibi ni
mou owakareshiyou
futari dakara
tobira akete
tobidaseru no
ima (ima) mou (mou)
futari dakara
okashi na kotto ittemo ii?
fufufu
boku to kekkonshitekure!
motto okashi na koto ittemo ii? mochiron!
English
Anna: Hey, can I say something a little weird?
Hans: I love things like that!
Anna: Those days with no exit anywhere
suddenly seem like they’re about to change
Hans: I was the thinking the same thing! I mean,
During those days I had no place to belong,
I’d continued searching for someone like you
Anna: Everything’s changing,
Hans: Once I met you,
Together: Everything’s making my heart excited for the first time
Together: Because there’s the two of us,
Open up the door
I can jump out
Right now (right now)
Since there’s the two of us
Hans: Tell me…
Anna: Huh?
Hans: What do you like?
Anna: Sandwiches.
Hans: Hey, isn’t that the same as me?
Together: We suit each other well, don’t we?
Oh! We matched each other again!
Together: The things we’re thinking,
and the things we’re feeling
Hans: Yes,
Anna: they
Hans: really
Together: suit each other, don’t they?
Together: To those lonely (lonely) days,
let’s say farewell already
Together: Because there’s the two of us,
Open up the door
I can jump out
Right now (right now)
Since there’s the two of us
Hans: Can I say something a little weird? Please marry me!
Anna: Can I say something even weirder? Of course!
if use_new_lookup_system == false
sites = Array.new
if controller.controller_name == "site"
#sites = Site_slave.find_by_sql(["SELECT * FROM sites, (SELECT id FROM sites WHERE (category_id = ? AND ext_type IN (5,6,7) AND id <= ?) ORDER BY id DESC LIMIT #{mobile_page_size}) as x WHERE sites.id = x.id", @site.category_id, @site.id])
if @permalink_site.ext_type == 4
if false # this loads same type of content after the permalink
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 4 AND id <= ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC, id DESC", :limit=>numshowing, :offset=>array_start)
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type = 4 AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 4 AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC, id DESC", :limit=>numshowing, :offset=>array_start)
end
else
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) and id <= ?", @category.id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
end
end
elsif @permalink_site.is_image?
if false # this loads same type of content after the permalink
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (5,6,7) AND id <= ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC, id DESC", :limit=>numshowing, :offset=>array_start)
if sites.length == 0 # wrap to newest if no results were found going back in time
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type IN (5,6,7) AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (5,6,7) AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC, id DESC", :limit=>numshowing, :offset=>array_start)
end
else # this loads any type of content after the permalink
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) and id <= ?", @category.id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
end
end
elsif @permalink_site.is_video?
if false # this loads same type of content after the permalink
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (9,10) AND id <= ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type IN (9,10) AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (9,10) AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
end
else # this loads any type of content after the permalink
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) and id <= ?", @category.id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
end
end
end
elsif controller.controller_name == "search"
sites = @site_results #@site_results is the array of site objects returned by sphinx
elsif controller.controller_name == "collection"
sites = @sites_collections2D##.collect {|site| site[0]} Special case below to bundle site and collection_site together for display later
elsif controller.controller_name == "welcome"
sites = Popculture_slave.find(:all, :order=>"publish_date desc", :limit=>numshowing, :offset=>array_start)
elsif controller.controller_name == "soapbox" && controller.action_name == "show"
if false # this loads same type of content after the permalink
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 1 AND id <= ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type = 1 AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 1 AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
end
else # this loads any type of content after the permalink
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) and id <= ?", @category.id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
if sites.length == 0
offset_count = Site_slave.count(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id <= ?", @permalink_site.category_id, @permalink_site.id])
new_current_page = current_page - ((offset_count+numshowing-1) / numshowing) # page number starting from 0 is going to be the current page minus the number of pages it took to show from permalink to end
array_start = numshowing * (new_current_page - 1)
# sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ?", @permalink_site.category_id, @permalink_site.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
sites = Site_slave.find_by_sql(["SELECT sites.* FROM sites, (SELECT id FROM sites WHERE category_id = ? AND ext_type IN (1,5,6,7,9,10) AND id > ? ORDER BY datecreated DESC LIMIT ?, ?) AS x WHERE x.id = sites.id", @permalink_site.category_id, @permalink_site.id, array_start, numshowing])
end
end
elsif controller.controller_name == "soapbox" && controller.action_name == "list"
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 1", @category.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
elsif controller.controller_name == "category" && controller.action_name == "home"
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (1,5,6,7,9,10)", @category.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
if false && @luser && @luser.id < 10
if sites.length > 0
if current_page.to_i == 1
wall_entries = Wall_entry_slave.find(:all, :conditions=>["category_id = ? AND timestamp > ? AND deleted_by = 0", @category.id, sites[sites.length - 1].datecreated], :order=>"timestamp DESC")
else
wall_entries = Wall_entry_slave.find(:all, :conditions=>["category_id = ? AND timestamp < ? and timestamp > ? AND deleted_by = 0", @category.id, sites[0].datecreated, sites[sites.length - 1].datecreated], :order=>"timestamp DESC")
end
begin
wall_entries.each do |wall_entry|
wall_site_hash = {:card_type=>"chatter", :datecreated=>wall_entry.timestamp, :chatter_data=>wall_entry}
site_counter = 0
sites.each do |site_object|
if site_object.is_a? Site_slave
if site_counter == 0 && wall_site_hash[:datecreated] > site_object.datecreated #wall post is newer than the newest site in the array
sites.insert(0, wall_site_hash)
break
end
if site_counter > 0 && site_object.datecreated < wall_site_hash[:datecreated]
sites.insert(site_counter, wall_site_hash)
break
end
end
site_counter = site_counter + 1
end
end
rescue StandardError => kaboom
Notifier::deliver_email_alert_request("Cliff Szu", "theclifbar@gmail.com", "Error: chatter card error", "#{kaboom.inspect}")
puts "################################### _viewer_main_viewer_body_cardcontainer Error: #{__LINE__} #{kaboom.inspect} :::: #{session.inspect.to_s}, #{params.to_s}, #{request.env.to_s}"
end
end
end
site = sites[0]
# commented following line out - there should not be a @permalink_site on club home; the first card should not be treated differently on club home
# @permalink_site = sites[0]
else
#I also need to change pagination to pull from a different set... maybe we should just pass in a parameter or object like @site or site_id, and if that is not nil, then use similar queries to pull the subsequent pages for sites
if params[:show_only].to_s != ""
show_only = params[:show_only].to_s
case show_only
when "images"
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (5,6,7)", @category.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
when "videos"
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type IN (9,10)", @category.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
when "trivia"
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 3", @category.id], :order=>"datecreated DESC", :limit=>numshowing, :offset=>array_start)
when "polls"
sites = Site_slave.find(:all, :conditions=>["category_id = ? AND ext_type = 2", @category.id], :order=>"datecreated DESC", :limit=>numshowing, :off
