#!/usr/bin/perl -w use DBI; require 'cookie.lib'; if ($ENV{"REQUEST_METHOD"} eq 'GET') { $Buffer=$ENV{QUERY_STRING} } else { read(STDIN, $Buffer, $ENV{'CONTENT_LENGTH'}) } $Buffer =~ s/\%20/ /g; @pairs = split(/&/,$Buffer); foreach $par (@pairs) { ($name,$value) = split(/=/,$par); $FORM{$name} = $value; } $Buffer =~ s/\%26/\&/g; $Buffer =~ s/\%27/\'/g; #------------------------ $redirect_id = $FORM{'id'} || ""; $redirect_st = $FORM{'st'} || ""; $redirect_pl = $FORM{'pl'} || ""; $redirect_br = $FORM{'br'} || ""; #$nr = $FORM{'nr'} || ""; $nr = "0"; $nb = $FORM{'nb'} || ""; $nopopup = "0"; #1-800-Usa-Hotels if ($FORM{'style'} eq "6") { $nopopup = "1"; } $redirect_script = $ENV{'SCRIPT_NAME'}; $redirect_usersip = $ENV{'REMOTE_ADDR'}; if ($nr ne "1") { if ( $redirect_script =~ /radissondynamic2?/i) { #RedirectToPhase1Radisson("id=$redirect_id"); } elsif ( $redirect_script =~ /starwood2/i) { #RedirectToPhase1Starwood("id=$redirect_id&br=$redirect_br"); } else { #if ($redirect_usersip eq "66.46.250.226" & $redirect_st eq "234") { if ($redirect_st eq "234") { #234 = Orbitz, 306 = Apple Vacations $nopopup = "1"; #print "OK!"; #exit; } #generic elsif ($redirect_st eq "0" | $redirect_st eq "") { RedirectToTheASP("command=invoke&ids=40317&ipid=" . $redirect_id . "&rids=40317"); } #1-800-Usa-Hotzels elsif ($redirect_st eq "6") { #RedirectToTheASP("command=redirectp2j&oids=" . $redirect_st . "&opid=" . $redirect_id . "&tpl=50"); $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40321&ipid=" . $redirect_id . "&rids=40317"); } #hotels.com #elsif ($redirect_st eq "190") { #RedirectToTheASP("command=invoke&ids=40348&ipid=" . $redirect_id . "&rids=40317"); #} #elsif ($redirect_usersip eq "66.46.250.226" & $redirect_st eq "190") { #a hit from the office IP with hotels.com style code #RedirectToInternal("command=redirectp2j&oids=" . $redirect_st . "&opid=" . $redirect_id . "&tpl=02"); #} # elsif ($redirect_st eq "190") { # #RedirectToTheASP("command=redirectp2j&oids=" . $redirect_st . "&opid=" . $redirect_id . "&tpl=50"); # #$nopopup = "1"; # RedirectToTheASP("command=invoke&ids=40348&ipid=" . $redirect_id . "&rids=40317"); # } # elsif ($redirect_st eq "190") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40348&ipid=" . $redirect_id . "&rids=40317"); } # created using the following query from the ASP # select # concat('elsif ($redirect_st eq "', legacy_style_number, '") { '), # if(popup_default='N',' $nopopup = "1";','' ), # concat( 'RedirectToTheASP("command=invoke&ids=', oid_ids_client, '&ipid=" . $redirect_id . "&rids=40317"); } ') # from ids_client # where legacy_style_number is not null; # elsif ($redirect_st eq "0") { RedirectToTheASP("command=invoke&ids=40317&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "208") { RedirectToTheASP("command=invoke&ids=40318&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "1") { RedirectToTheASP("command=invoke&ids=40319&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "248") { RedirectToTheASP("command=invoke&ids=40320&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "6") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40321&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "164") { RedirectToTheASP("command=invoke&ids=40322&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "2") { RedirectToTheASP("command=invoke&ids=40323&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "142") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40324&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "152") { RedirectToTheASP("command=invoke&ids=40325&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "13") { RedirectToTheASP("command=invoke&ids=40326&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "160") { RedirectToTheASP("command=invoke&ids=40327&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "244") { RedirectToTheASP("command=invoke&ids=40328&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "230") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40329&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "262") { RedirectToTheASP("command=invoke&ids=40330&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "261") { RedirectToTheASP("command=invoke&ids=40331&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "176") { RedirectToTheASP("command=invoke&ids=40332&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "34") { RedirectToTheASP("command=invoke&ids=40333&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "170") { RedirectToTheASP("command=invoke&ids=40334&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "9") { RedirectToTheASP("command=invoke&ids=40335&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "33") { RedirectToTheASP("command=invoke&ids=40336&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "56") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40337&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "58") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40338&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "254") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40339&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "104") { RedirectToTheASP("command=invoke&ids=40340&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "252") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40341&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "70") { RedirectToTheASP("command=invoke&ids=40342&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "134") { RedirectToTheASP("command=invoke&ids=40343&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "136") { RedirectToTheASP("command=invoke&ids=40344&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "229") { RedirectToTheASP("command=invoke&ids=40345&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "238") { RedirectToTheASP("command=invoke&ids=40346&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "228") { RedirectToTheASP("command=invoke&ids=40347&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "190") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40348&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "260") { RedirectToTheASP("command=invoke&ids=40349&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "172") { RedirectToTheASP("command=invoke&ids=40352&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "7") { RedirectToTheASP("command=invoke&ids=40353&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "50") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40354&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "259") { RedirectToTheASP("command=invoke&ids=40355&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "226") { RedirectToTheASP("command=invoke&ids=40356&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "266") { RedirectToTheASP("command=invoke&ids=40357&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "154") { RedirectToTheASP("command=invoke&ids=40358&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "54") { RedirectToTheASP("command=invoke&ids=40359&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "144") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40360&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "276") { RedirectToTheASP("command=invoke&ids=40361&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "108") { RedirectToTheASP("command=invoke&ids=40362&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "180") { RedirectToTheASP("command=invoke&ids=40363&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "23") { RedirectToTheASP("command=invoke&ids=40364&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "140") { RedirectToTheASP("command=invoke&ids=40365&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "49") { RedirectToTheASP("command=invoke&ids=40366&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "130") { RedirectToTheASP("command=invoke&ids=40367&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "20") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40368&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "272") { RedirectToTheASP("command=invoke&ids=40369&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "273") { RedirectToTheASP("command=invoke&ids=40370&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "274") { RedirectToTheASP("command=invoke&ids=40371&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "8") { RedirectToTheASP("command=invoke&ids=40372&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "250") { RedirectToTheASP("command=invoke&ids=40373&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "14") { RedirectToTheASP("command=invoke&ids=40375&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "45") { RedirectToTheASP("command=invoke&ids=40376&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "47") { RedirectToTheASP("command=invoke&ids=40377&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "90") { RedirectToTheASP("command=invoke&ids=40378&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "100") { RedirectToTheASP("command=invoke&ids=40379&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "102") { RedirectToTheASP("command=invoke&ids=40380&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "128") { RedirectToTheASP("command=invoke&ids=40381&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "146") { RedirectToTheASP("command=invoke&ids=40382&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "148") { RedirectToTheASP("command=invoke&ids=40383&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "174") { RedirectToTheASP("command=invoke&ids=40384&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "178") { RedirectToTheASP("command=invoke&ids=40385&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "184") { RedirectToTheASP("command=invoke&ids=40386&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "185") { RedirectToTheASP("command=invoke&ids=40387&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "188") { RedirectToTheASP("command=invoke&ids=40388&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "195") { RedirectToTheASP("command=invoke&ids=40389&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "199") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40390&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "212") { RedirectToTheASP("command=invoke&ids=40391&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "224") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40392&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "232") { RedirectToTheASP("command=invoke&ids=40393&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "220") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40394&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "222") { RedirectToTheASP("command=invoke&ids=40395&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "234") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40396&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "216") { RedirectToTheASP("command=invoke&ids=40397&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "237") { RedirectToTheASP("command=invoke&ids=40398&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "214") { RedirectToTheASP("command=invoke&ids=40399&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "256") { RedirectToTheASP("command=invoke&ids=40400&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "258") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40401&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "263") { RedirectToTheASP("command=invoke&ids=40402&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "264") { RedirectToTheASP("command=invoke&ids=40403&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "257") { RedirectToTheASP("command=invoke&ids=40404&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "267") { RedirectToTheASP("command=invoke&ids=40405&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "268") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40406&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "270") { RedirectToTheASP("command=invoke&ids=40407&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "271") { RedirectToTheASP("command=invoke&ids=40408&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "275") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40409&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "280") { RedirectToTheASP("command=invoke&ids=40411&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "281") { RedirectToTheASP("command=invoke&ids=40412&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "282") { RedirectToTheASP("command=invoke&ids=40413&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "162") { RedirectToTheASP("command=invoke&ids=40414&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "165") { RedirectToTheASP("command=invoke&ids=40415&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "10") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40416&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "283") { RedirectToTheASP("command=invoke&ids=40417&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "283") { RedirectToTheASP("command=invoke&ids=40418&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "210") { RedirectToTheASP("command=invoke&ids=40419&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "206") { RedirectToTheASP("command=invoke&ids=40420&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "284") { RedirectToTheASP("command=invoke&ids=40421&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "286") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40424&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "182") { RedirectToTheASP("command=invoke&ids=40425&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "16") { RedirectToTheASP("command=invoke&ids=40426&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "156") { RedirectToTheASP("command=invoke&ids=40427&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "41") { RedirectToTheASP("command=invoke&ids=40428&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "279") { RedirectToTheASP("command=invoke&ids=40429&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "114") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40430&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "288") { RedirectToTheASP("command=invoke&ids=40431&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "289") { RedirectToTheASP("command=invoke&ids=40432&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "290") { RedirectToTheASP("command=invoke&ids=40433&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "291") { RedirectToTheASP("command=invoke&ids=40434&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "293") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40435&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "292") { RedirectToTheASP("command=invoke&ids=40436&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "294") { RedirectToTheASP("command=invoke&ids=40437&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "0") { RedirectToTheASP("command=invoke&ids=41388&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "296") { RedirectToTheASP("command=invoke&ids=40441&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "297") { RedirectToTheASP("command=invoke&ids=40442&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "298") { RedirectToTheASP("command=invoke&ids=40443&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "299") { RedirectToTheASP("command=invoke&ids=40444&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "300") { RedirectToTheASP("command=invoke&ids=40445&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "301") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40446&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "302") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40447&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "303") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40448&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "304") { RedirectToTheASP("command=invoke&ids=40449&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "305") { RedirectToTheASP("command=invoke&ids=40450&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "269") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40451&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "132") { RedirectToTheASP("command=invoke&ids=40452&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "40") { RedirectToTheASP("command=invoke&ids=40453&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "306") { RedirectToTheASP("command=invoke&ids=40454&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "22") { RedirectToTheASP("command=invoke&ids=40457&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "167") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40459&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "msn") { RedirectToTheASP("command=invoke&ids=40460&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "regent") { RedirectToTheASP("command=invoke&ids=40461&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "145") { RedirectToTheASP("command=invoke&ids=40462&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "19") { RedirectToTheASP("command=invoke&ids=40463&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "59") { RedirectToTheASP("command=invoke&ids=40464&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "157") { RedirectToTheASP("command=invoke&ids=40465&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "where") { RedirectToTheASP("command=invoke&ids=40466&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "52") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=40468&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "323") { RedirectToTheASP("command=invoke&ids=40470&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "328") { RedirectToTheASP("command=invoke&ids=40472&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "327") { RedirectToTheASP("command=invoke&ids=40473&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "329") { RedirectToTheASP("command=invoke&ids=40474&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "330") { RedirectToTheASP("command=invoke&ids=40475&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "336") { RedirectToTheASP("command=invoke&ids=40581&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "339") { RedirectToTheASP("command=invoke&ids=40728&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "319") { RedirectToTheASP("command=invoke&ids=40739&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "324") { RedirectToTheASP("command=invoke&ids=40972&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "15") { RedirectToTheASP("command=invoke&ids=40975&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "278") { RedirectToTheASP("command=invoke&ids=40989&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "240") { RedirectToTheASP("command=invoke&ids=40999&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "277") { RedirectToTheASP("command=invoke&ids=41000&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "287") { RedirectToTheASP("command=invoke&ids=41001&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "295") { RedirectToTheASP("command=invoke&ids=41002&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "308") { RedirectToTheASP("command=invoke&ids=41003&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "309") { RedirectToTheASP("command=invoke&ids=41004&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "285") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=41005&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "332") { RedirectToTheASP("command=invoke&ids=41007&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "318") { RedirectToTheASP("command=invoke&ids=41008&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "326") { RedirectToTheASP("command=invoke&ids=41188&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "316") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=41361&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "310") { RedirectToTheASP("command=invoke&ids=41200&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "325") { RedirectToTheASP("command=invoke&ids=41202&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "307") { RedirectToTheASP("command=invoke&ids=41203&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "321") { RedirectToTheASP("command=invoke&ids=41208&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "331") { RedirectToTheASP("command=invoke&ids=41220&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "320") { RedirectToTheASP("command=invoke&ids=41221&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "340") { RedirectToTheASP("command=invoke&ids=41275&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "338") { RedirectToTheASP("command=invoke&ids=41378&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "265") { RedirectToTheASP("command=invoke&ids=41300&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "341") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=41362&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "334") { RedirectToTheASP("command=invoke&ids=41376&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "314") { RedirectToTheASP("command=invoke&ids=41377&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "335") { RedirectToTheASP("command=invoke&ids=41379&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "313") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=41380&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "333") { RedirectToTheASP("command=invoke&ids=41381&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "315") { RedirectToTheASP("command=invoke&ids=41382&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "322") { RedirectToTheASP("command=invoke&ids=41383&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "317") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=41384&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "311") { RedirectToTheASP("command=invoke&ids=41385&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "312") { $nopopup = "1"; RedirectToTheASP("command=invoke&ids=41386&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "337") { RedirectToTheASP("command=invoke&ids=41387&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "5") { RedirectToTheASP("command=invoke&ids=41558&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "18") { RedirectToTheASP("command=invoke&ids=41559&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "207") { RedirectToTheASP("command=invoke&ids=41560&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "43") { RedirectToTheASP("command=invoke&ids=41561&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "171") { RedirectToTheASP("command=invoke&ids=41562&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "21") { RedirectToTheASP("command=invoke&ids=41563&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "217") { RedirectToTheASP("command=invoke&ids=41564&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "101") { RedirectToTheASP("command=invoke&ids=41565&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "183") { RedirectToTheASP("command=invoke&ids=41566&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "211") { RedirectToTheASP("command=invoke&ids=41567&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "189") { RedirectToTheASP("command=invoke&ids=41568&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "48") { RedirectToTheASP("command=invoke&ids=41569&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "177") { RedirectToTheASP("command=invoke&ids=41570&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "209") { RedirectToTheASP("command=invoke&ids=41571&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "169") { RedirectToTheASP("command=invoke&ids=41572&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "181") { RedirectToTheASP("command=invoke&ids=41573&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "11") { RedirectToTheASP("command=invoke&ids=41574&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "143") { RedirectToTheASP("command=invoke&ids=41575&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "4") { RedirectToTheASP("command=invoke&ids=41576&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "51") { RedirectToTheASP("command=invoke&ids=41577&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "30") { RedirectToTheASP("command=invoke&ids=41578&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "213") { RedirectToTheASP("command=invoke&ids=41579&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "46") { RedirectToTheASP("command=invoke&ids=41580&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "225") { RedirectToTheASP("command=invoke&ids=41581&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "253") { RedirectToTheASP("command=invoke&ids=41582&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "17") { RedirectToTheASP("command=invoke&ids=41583&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "135") { RedirectToTheASP("command=invoke&ids=41584&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "3") { RedirectToTheASP("command=invoke&ids=41585&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "106") { RedirectToTheASP("command=invoke&ids=41586&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "155") { RedirectToTheASP("command=invoke&ids=41587&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "239") { RedirectToTheASP("command=invoke&ids=41588&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "175") { RedirectToTheASP("command=invoke&ids=41589&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "151") { RedirectToTheASP("command=invoke&ids=41590&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "153") { RedirectToTheASP("command=invoke&ids=41591&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "1642234") { RedirectToTheASP("command=invoke&ids=41592&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "123") { RedirectToTheASP("command=invoke&ids=41593&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "198") { RedirectToTheASP("command=invoke&ids=41594&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "161") { RedirectToTheASP("command=invoke&ids=41595&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "235") { RedirectToTheASP("command=invoke&ids=41596&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "197") { RedirectToTheASP("command=invoke&ids=41597&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "159") { RedirectToTheASP("command=invoke&ids=41598&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "192") { RedirectToTheASP("command=invoke&ids=41599&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "223") { RedirectToTheASP("command=invoke&ids=41600&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "42") { RedirectToTheASP("command=invoke&ids=41601&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "38") { RedirectToTheASP("command=invoke&ids=41602&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "64") { RedirectToTheASP("command=invoke&ids=41603&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "163") { RedirectToTheASP("command=invoke&ids=41604&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "32") { RedirectToTheASP("command=invoke&ids=41605&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "168") { RedirectToTheASP("command=invoke&ids=41606&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "44") { RedirectToTheASP("command=invoke&ids=41607&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "25") { RedirectToTheASP("command=invoke&ids=41608&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "109") { RedirectToTheASP("command=invoke&ids=41609&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "115") { RedirectToTheASP("command=invoke&ids=41610&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "29") { RedirectToTheASP("command=invoke&ids=41611&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "200") { RedirectToTheASP("command=invoke&ids=41612&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "141") { RedirectToTheASP("command=invoke&ids=41613&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "105") { RedirectToTheASP("command=invoke&ids=41614&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "221") { RedirectToTheASP("command=invoke&ids=41615&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "243") { RedirectToTheASP("command=invoke&ids=41616&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "196") { RedirectToTheASP("command=invoke&ids=41617&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "57") { RedirectToTheASP("command=invoke&ids=41618&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "27") { RedirectToTheASP("command=invoke&ids=41619&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "127") { RedirectToTheASP("command=invoke&ids=41620&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "194") { RedirectToTheASP("command=invoke&ids=41621&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "205") { RedirectToTheASP("command=invoke&ids=41622&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "12") { RedirectToTheASP("command=invoke&ids=41623&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "131") { RedirectToTheASP("command=invoke&ids=41624&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "215") { RedirectToTheASP("command=invoke&ids=41625&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "133") { RedirectToTheASP("command=invoke&ids=41626&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "147") { RedirectToTheASP("command=invoke&ids=41627&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "1900") { RedirectToTheASP("command=invoke&ids=41628&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "173") { RedirectToTheASP("command=invoke&ids=41629&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "201") { RedirectToTheASP("command=invoke&ids=41630&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "218") { RedirectToTheASP("command=invoke&ids=41631&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "219") { RedirectToTheASP("command=invoke&ids=41632&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "179") { RedirectToTheASP("command=invoke&ids=41633&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "187") { RedirectToTheASP("command=invoke&ids=41634&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "245") { RedirectToTheASP("command=invoke&ids=41635&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "241") { RedirectToTheASP("command=invoke&ids=41636&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "110") { RedirectToTheASP("command=invoke&ids=41637&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "117") { RedirectToTheASP("command=invoke&ids=41638&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "28") { RedirectToTheASP("command=invoke&ids=41639&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "120") { RedirectToTheASP("command=invoke&ids=41640&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "60") { RedirectToTheASP("command=invoke&ids=41641&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "126") { RedirectToTheASP("command=invoke&ids=41642&ipid=" . $redirect_id . "&rids=40317"); } elsif ($redirect_st eq "31") { RedirectToTheASP("command=invoke&ids=41643&ipid=" . $redirect_id . "&rids=40317"); } } } sub RedirectToPhase1Viewer { my ($parameters) = @_; $baseurl = "http://www.visualfrenzy.com/vf/Viewer90?"; MetaRefresh($baseurl . $parameters); } sub RedirectToPhase1Radisson { my ($parameters) = @_; $baseurl = "http://www.visualfrenzy.com/vf/radissondynamic2?"; MetaRefresh($baseurl . $parameters); } sub RedirectToPhase1Starwood { my ($parameters) = @_; $baseurl = "http://www.visualfrenzy.com/vf/starwood2?"; MetaRefresh($baseurl . $parameters); } sub RedirectToInternal { my ($parameters) = @_; $baseurl = "http://192.168.253.36/exc/aspquery?"; MetaRefresh($baseurl . $parameters); } sub RedirectToASP { my ($parameters) = @_; $baseurl = "http://192.168.253.36/exc/aspquery?"; MetaRefresh($baseurl . $parameters); } sub RedirectToTheASP { my ($parameters) = @_; $baseurl = "http://www.vfmii.com/exc/aspquery?"; MetaRefresh($baseurl . $parameters); } sub MetaRefresh { my ($base,$params) = @_; print "Content-type:text/html\n\n"; print ""; exit; } #------------------------ $thetime = localtime; $usersip = $ENV{REMOTE_ADDR}; $videotoplay = $FORM{id}; $vidspeed = $FORM{sp}; $playertype = $FORM{pl}; $playstyle = $FORM{style}; #$referer = $ENV{HTTP_REFERER}; $referer = $FORM{'rf'} || ""; $linkedfromshort = $FORM{'rf'} || ""; #if it's blank then use the HTTP referer and strip it down to just the domain if ($linkedfromshort eq "") { #$linkedfromshort = $referer; $linkedfromshort =~ s/http:\/\///i; $linkedfromshort =~ s{((/[^/]+){0}/).*}{$1}; $linkedfromshort =~ s/\///i; $linkedfromshort =~ s/www.//i; } if ($playstyle eq "") { $playstyle = $FORM{st}; } else { $FORM{'st'} = $playstyle; } #if no style code is entered then default to the VFM Generic Viewer if ($FORM{'st'} eq "") { $FORM{'st'} = "0"; } $formid = $FORM{'id'}; #$servertouse = $FORM{server}; #$usercookie = $ENV{HTTP_COOKIE}; #$http_user_agent = $ENV{HTTP_USER_AGENT}; #$querystring = $ENV{QUERY_STRING}; $activitytype = "VID"; $st = $FORM{'st'}; $servertouse = $FORM{server} || ""; $usercookie = $ENV{HTTP_COOKIE} || ""; $http_user_agent = $ENV{HTTP_USER_AGENT} || ""; $querystring = $ENV{QUERY_STRING} || ""; $userbooking = $FORM{booking} || ""; $streamfrom = "mms://wmd31sea.activate.net/visiontrip/asf/"; if ($FORM{'st'} eq "wynpopup") { #wyndham print "Content-type:text/html\n\n"; print ""; exit; } if ($FORM{'st'} eq "4") { #Radisson old-style links print "Content-type:text/html\n\n"; print ""; exit; } elsif ($FORM{'st'} eq "22") { #marriott print "Content-type:text/html\n\n"; print ""; exit; } elsif ($FORM{'st'} eq "52") { #wyndham print "Content-type:text/html\n\n"; print ""; exit; } elsif ($FORM{'st'} eq "msn") { #windowsmedia print "Content-type:text/html\n\n"; print ""; exit; } elsif ($FORM{'st'} eq "regent") { #Regent Wall Street print "Content-type:text/html\n\n"; print ""; exit; } if ($FORM{'st'} ne "") { $dbh = DBI-> connect('dbi:Pg:dbname=visualfrenzy','postgres','B1ng0s'); $sqltosend = "select * from darlingtemplates where id='$FORM{'st'}'\;"; $sth = $dbh -> prepare($sqltosend); $sth -> execute(); $Flag=0; $counter=0; $numrows = $sth->rows; if ($numrows > 0) { $Flag=1; } else { $Flag=0; } $username = $FORM{'username'}; $password = $FORM{'password'}; if ($Flag eq 0) { print "nothing to display"; } elsif ($Flag eq 1) { while(@dat=$sth->fetchrow_array()) { $id = $dat[0]; $description = $dat[1]; $pagebg = $dat[2]; $normaltext = $dat[3]; $buttonnormal = $dat[4]; $buttonhighlighted = $dat[5]; $buttontext = $dat[6]; $showphone = $dat[7]; $resstring = $dat[8]; $showblackbar = $dat[9]; $showpoweredby = $dat[10]; $usepropertylink = $dat[11]; $usetemplatelink = $dat[12]; $exituponselection = $dat[13]; $templatelink = $dat[14]; $defaultcolours = $dat[15]; $showreserve = $dat[16]; $defaultrf = $dat[17]; if ($linkedfromshort eq "") { $referer = $defaultrf; $linkedfromshort = $defaultrf; } if ($defaultcolours eq "1") { $pagebg = "FFFFFF"; $normaltext = "000000"; $buttonnormal = "FFFFFF"; $buttonhighlighted = "EEEEEE"; $buttontext = "333333"; } } } } else { $id = $dat[0]; $description = ""; $pagebg = "FFFFFF"; $normaltext = "000000"; $buttonnormal = "0000FF"; $buttonhighlighted = "00FFFF"; $buttontext = "FFFFFF"; $showphone = "n"; $defaultcolours = "n"; $showreserve = "y"; } if ($FORM{'dt'} eq "") { $ratesstring = $resstring; } else { $ratesstring = $FORM{'dt'}; $ratesstring =~ tr/+/ /; $ratesstring =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",hex($1))/eg; $ratesstring =~ s///g; $ratesstring =~ tr/%26/&/; } $idnum = $FORM{'id'}; $sqltosend = "select * from properties where video='$idnum'\;"; $dbh= DBI-> connect('dbi:Pg:dbname=visualfrenzy','postgres','B1ng0s'); $sth = $dbh -> prepare($sqltosend); $sth -> execute(); $Flag=0; $counter=0; $numrows = $sth->rows; if ($numrows > 0) { $Flag=1; } else { $Flag=0; } if ($Flag eq 0) { print "nothing to display"; } elsif ($Flag eq 1) { while(@dat=$sth->fetchrow_array()) { $videonumber = $dat[0]; $propertyname = $dat[4]; $propertyname =~ s/\%26/\&/g; $propertyname =~ s/\%27/\'/g; $mailingaddr = $dat[5]; $city = $dat[6]; $state = $dat[7]; $zipcode = $dat[8]; $country = $dat[9]; $phonenum = $dat[10]; $tollfree = $dat[11]; $fax = $dat[12]; if ($usepropertylink eq "1" | ($FORM{'dl'} ne "") | ($FORM{'dt'} ne "")) { if ($FORM{'dl'} eq "") { $bookingurl2 = ""; #$bookingurl = $dat[14]; #$bookingurl =~ s/http:\/\///i; #$bookingurl =~ s/https:\/\///i; #$bookingurl = "$bookingurl"; } else { $bookingurl = $FORM{'dl'}; $bookingurl =~ tr/+/ /; $bookingurl =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",hex($1))/eg; $bookingurl =~ s///g; #$bookingurl =~ s/http:\/\///i; #$bookingurl =~ s/https:\/\///i; $bookingurl = "$bookingurl"; } } if ($usetemplatelink eq "1") { $bookingurl = $templatelink; #$bookingurl =~ s/http:\/\///i; #$bookingurl =~ s/https:\/\///i; $bookingurl = "$bookingurl"; } if ( $exituponselection eq "1" && ($FORM{'dl'} eq "") ) { $bookingurl = "javascript:window.close()"; } $approved = $dat[18]; $notes = $dat[24]; } } print "Content-type:text/html\n\n"; if ($approved eq "x") { print "
";
print "![]() | ";
print "|
The video for this property is no longer available, press Exit to continue. | |
| ";
print " | |
| $propertyname | |
";
if ($FORM{'pl'} eq "") {
if ($FORM{'sp'} eq "") {
print " ";
}
}
elsif ($FORM{'pl'} eq "W300") {
$vidspeed = "300";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print q[];
}
elsif ($FORM{'pl'} eq "W100") {
$vidspeed = "100";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print q[];
}
elsif ($FORM{'pl'} eq "W56") {
$vidspeed = "56";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print q[];
}
elsif ($FORM{'pl'} eq "R300") {
$vidspeed = "300";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print "
];
}
elsif ($FORM{'pl'} eq "R100") {
$vidspeed = "100";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print "
];
}
elsif ($FORM{'pl'} eq "R56") {
$vidspeed = "56";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print "
];
}
elsif ($FORM{'pl'} eq "Q300") {
$vidspeed = "300";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print q[
];
}
elsif ($FORM{'pl'} eq "Q56") {
$vidspeed = "56";
$sth=$dbh-> prepare('INSERT into newdata4 values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$sth->execute($thetime,$usersip,$name,$referer,$videotoplay,$vidspeed,$playertype,$userbooking,$playerstyle,$usercookie,$http_user_agent,$querystring,$videosessionid,$sessionid,$viewerid,$linkedfromshort,$activitytype,$st) or die "can not execute";
print q[
];
}
print "
|
$mailingaddr $city, $state"; #print LongStateToShort($state); print " $zipcode "; if ($showphone eq "1") { print " $tollfree"; } print " "; if ($showreserve eq "1" | ($FORM{'dl'} ne "") | ($FORM{'dt'} ne "")) { print "$ratesstring"; } print " |
];
print " ";
print " ";
}
else {
print "";
print " ";
print " ";
}
}
if ($playertype eq "W300" || $playertype eq "W100" || $playertype eq W56 || $playertype eq "R300" || $playertype eq "R100" || $playertype eq "R56") {
print q[
$mailingaddr ";
print "$city, $state"; #print LongStateToShort($state); print " $zipcode "; if ($showphone eq "1") { print " $tollfree"; } print " $propertyname ";
if ($showblackbar eq "1") { print ""; }
print q[ |
|||||||||||
| ];
print "";
print q[ |
|||||||||||
];
if ($FORM{'frame'} eq "") {
print "![]() ![]() |
![]() |
||||||||||
| ];
if ($playertype eq "W300" || $playertype eq "W100" || $playertype eq "W56") {
print q[ |
];
if ($playertype eq "W300" || $playertype eq "W100" || $playertype eq "W56") {
print q[ |
||||||||||
| ];
if ($showpoweredby eq "1") {
print q[ |
|||||||||||