`a2) Patent Application Publication 0) Pub. No.: US 2003/0001965 Al
`(43) Pub. Date: Jan. 2, 2003
`
`Caoet al.
`
`US 20030001965A1
`
`(54) SYSTEM AND METHOD FOR
`COORDINATING COMMUNICATIONS
`NETWORK ADVERTISING MATERIAL
`
`(75)
`
`Inventors: XiWei Cao, Chicago, IL (US); Edwin
`C. Price, Chicago, IL (US); Mike H.
`Kim, Naperville, IL (US); John S.
`Walsh, Chicago, IL (US)
`
`Correspondence Address:
`FOLEY HOAG LLP
`PATENT GROUP, WORLD TRADE CENTER
`WEST
`155 SEAPORT BOULEVARD
`BOSTON, MA 02110-2600 (US)
`
`(73) Assignee: Radiowave.Com Inc.
`
`(21) Appl. No.:
`
`10/114,424
`
`(22)
`
`Filed:
`
`Apr. 1, 2002
`
`Related U.S. Application Data
`
`(63) Continuation of application No. 09/163,288, filed on
`Sep. 29, 1998, now abandoned.
`
`Publication Classification
`
`Inte C17 oacecceccesscssne HO4N 7/173; HO4N 9/475
`(51)
`(52) US. Ch.
`cecescssessesscssvee 348/515; 348/512; 725/110
`
`(57)
`
`ABSTRACT
`
`Asystem and method of coordinating a visual display with
`audio advertisements broadcast over a communicationsnet-
`
`worksuchas the Internet is provided. A run-time procedure
`in which the visual display is retrieved and concurrently
`displayed at about
`the time the audio advertisement
`is
`broadcast is described. In addition, a set-up procedure, in
`which scheduled broadcast times for the audio advertise-
`
`ments are captured and provided for use in scheduling the
`broadcasts of the corresponding visual displays,
`is also
`described. The system and method can be beneficially
`employed in other environments, such as the case in which
`a first audio, visual, or audiovisual segment or stream is
`coordinated with a predetermined second audio, visual, or
`audiovisual segmentor stream, and a selected oneofthe first
`and second segments or streams includes or comprises
`advertising material.
`
`6
`
`7
`/
`
`,
`
`2
`
`/
`
`9
`
`
`
`
`
`|_AUDIO |
`ON-AIR
`SYSTEM|pata !
`
`7
`
`SUPPORT
`SERVER
`
`
`
`/
`
`
`PLAYER
`
`
`
`FULFILLMENT
`PROVIDER
`SERVER
`
`VW EX1019
`VW v.StratosAudio
`
`IPR2021-00721
`
`VW EX1019
`VW v. StratosAudio
`IPR2021-00721
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 1 of 75
`
`US 2003/0001965 Al
`
`el
`
`OL
`
`TN
`
`UHAVTd
`
`LuaOddns
`
`MAAS
`
`INSNTWATINA
`
`YACIAOUd
`
`UHAMAS
`
`TdaNol
`
`MAAS
`
`
`
`LOM
`ae|SASae|
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 2 of 75
`
`US 2003/0001965 Al
`
`Li
`
`
`
`IVGLSVA]ELAR
`
`
`
`WOGTVY|ISILYyYFOVWI|ANdivNaCIAO’d
`FIAVNaAVN2INTTSAWVNdi
`
`
`
`
`HTEaVLYACIAOUd
`ONOSWNGTV|LSILUv|WoT
`
`
`
`qAVNSAVNAWNgi
` ATaVL
`ONOS|oT 4,
`._
`dqd0Ddl
`IND|NOILVILS
`
`1000
`
`¢FUND
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 3 of 75
`
`US 2003/0001965 Al
`
`ABUOWUB!OY?Hb1twinge
`
`ANGWed
`
`
`
`GOOMATIOH/d9d
`
`0¢iBuos
`«4eiaaUL.
`
`——|IPGIse4
`
`13sye
`
`
`
`YooyAqyencs
`
`eenasl
`
`eoLean
`
`€HANOI
`
`qsz
`
`i
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 4 of 75
`
`US 2003/0001965 Al
`
`WODYaTIA
`HoxPEcIV
`
`INIT
`
`#a
`
`WVN
`
`LOFMIaY
`OVWLNo
`
`
`
`
`SHTGV.LLNAWASILYAAGV
`NOLLVIS
` #‘TIOODLONGO)WASILYAACY|LOVALLNOD
`
`
`ONISLIMAACY
`
`96-01-9|96-9-9ANOZ
`CNA|LUVLs
`IHOrlt
`
`qLle
`
`BLE
`
`vTaN
`
`TWEAOTD
`
`SaLVd
`
`di
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 5 of 75
`
`US 2003/0001965 Al
`
`AWIL-NMOF
`
`11'it4i‘tt
`
`¢FaNOIA
`
`dQ-LdsTr
`
`Of
`
`ONISILYSACY
`
`MaAMAS
`
`tr
`
`ce
`
`OdAVaL
`
`WSLSAS
`
`aSvavVIVG
`
`ALINNIZNOOD
`
`NOILV.ILSAYOM
`
`BSE
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 6 of 75
`
`US 2003/0001965 Al
`
`
`
`
`
`
`
`
`
`
`
`9Fano
`
`
`
`
`:B8pBosR6/OL/9IPAs8bubSHINS
`HlUohoniysuy
`—_aa|iaftm4vEewy4way
`i2ae01g>Ee
`op”PUBOHEWPAPOAAIVIUODaopeuIpran>/s)060CUSRHIpPIOO>Dqo}uesraApy
`
`
`
`S6/9/9“ABRsCesccsaILAaEpOn
`|PeHodang
`Boe
`
`AlnuipuesteDOEESTEabta,Ved
`Ramap02«
`jods
`Jo1ofAXJOU]YoOso131y-saweljua7ygE,
`
`
`
`
`PTNy
`|raf|
`
`LIDDSBARAAGIIES
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 7 of 75
`
`US 2003/0001965 Al
`
`ad09LADLOaLya
`
`40FJALLVOIGNI
`
`INAAASILYSACV
`
`HATTALA
`
`NOILVAWROANI
`
`HLIMGHLVIDOSSVY
`
`
`
`H#do0o0INO
`
`INA)
`
`
`
`NIHLIMdLvVG
`
`GaTNGsHOs
`
`JHDITA
`
`éSHLVE
`
`09
`
`
`
`CNVAOVIIFCIAOUd
`
`
`
`OLANTLOMMICaY
`
`WHAVId
`
`LAaandl
`
`
`
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 8 of 75
`
`US 2003/0001965 Al
`
`S$
`
`
`
`ONISLLYHACVONIGUVDAY
`
`LOVYINOD
`
`
`
`NOILVWYOANILOdNI
`
`bs
`
`
`
`HLIMONILVNIGHOODYor
`
`
`
`NOILVWYOANIHLIMLNAWONV
`
`
`
`AVTdSIGTVNSIA
`
`gs
`
`9S
`
`
`
`TIVOSIADONILVNIGYOOO
`
`SAVTdSIG
`
`
`
`UaANASOLASVAVIVGACIAOUd
`
`HTEISSHOOVSIHOIHM
`
`UHAVTdWOU
`
`8HANOI
`
`
`
`
`
`YOdASVEVLVALVaNO
`
`
`
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 9 of 75
`
`US 2003/0001965 Al
`
`inuity
`cont
`
`»CoordinateSpot
`
`=UpdateSpot
`
`»CreateSpot
`
`in
`
`eranSoaal
`atestec =!
`
`Sereeee
`
`FIGURE9
`
`
`ternetradiostation
`r
`
`a
`
`Br £
`
`bes
`ee
`%
`ms,
`aN
`eee
`
`r
`
`:
`:
`
`-
`
`z&
`»
`5
`z
`a
`x
`5a
`3
`>
`@
`
`ai
`
`ai:
`
`a
`rg
`=
`or
`
`a
`a
`wo
`
`Tots!
`
`
`
`Jan. 2, 2003 Sheet 10 of 75
`
`US 2003/0001965 Al
`
`SIRE,
`
`(a|5i
`
`:NyH[faiHiHy
`
`NameorNCSRETYN
`
`Kerra,
`
`
`
`
`
`Patent Application Publication
`
`pausapeeBvO. iaeSe!
`
`v9Serague
`FIEBUOD105YDAvaS
`
`
`s9UX\yodang
`ceUOROMAASU]
`—_Aumuyues_MTBOEESTTCFEteWAS
`UOILEISOpesJat
`
`
`
`1s10}0x3JauayzuyYossi-sa
`
`te
`
`wetu07
`
`
`
`—_aepdn|
`
`SIPUIPICOS
`
`
`HEI
`
`
`
`
`
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 11 of 75
`
`US 2003/0001965 Al
`
`Deesonee
`
`
`
`
`
`Buneyeyy(eqo[)saescoapy
`
`‘R6/9/9Maes
`
`
`
`S6/OL/sIPu®
`
`Ld
`
`eaapd
`
`
`
`FIBROIDWeuUIPICSG>
`
`
`
`azepdyyods
`
`J3PDI3
`
`
`
`
`Aimunu08sfre08Oda.“NAE
`WONLHISO1rpyei.‘10>
`
`yaUsFTUTBO;
`
`
`
`Seeery
`
`11ANNA
`
`kLi
`
`eonTONSMSU]
`
`
`
` xyoypods
`
`
`
`
`
`wol4>ByereLeerLEIDLega3000
`
`
`
`
`
`PoeiSasvuascipneyqinunuoakg2000
`
`
`
`
`
`WanIsaPIy
`
`
`
`re.S-uoseynysnaunugd\:oees/suDGawyny
`
`
`
`
`
`
`
`
`
`
`89ae
`
`
`HuROWeLY(EGO)sswesqusapyFORDAIUAZODDELIPICO>
`
`crecrprea4/S6/9/9LESeeeLeraMnunealmepdy
`osonSa
`
`S6/OL/9pugager
`SUSIaieoaRTsmy:TaeUseeekaeaa7eSeeeS)BraeS|“a{ya10
`
`JAN3422PI69aapeofay4n3
`~~pday**OSPOYMVPINUUO£000
`
`
`
`
`
`
`
`
`
`
`~~gedpy"ZUpAyNUnUogy:S000
`i—-aSe
`
`-spday~soIpneyAINURuOsaL:S
`
`US 2003/0001965 Al
`
`
`
`suczsslient|_|:
`
`clPUNO
`
`
`
`20L6v902e0L1xSts
`
`LOYBARAAGHIMES
`
`yousoyl
`
`WoesOpes
`
`AwnurypuossedtedESTEptSda,VS
`
`
`
`asaCopy)Sypowr
`
`
`
`
`
`aepdryyards
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 12 of 75
`
`
`
`
`
`(deyyaUlaqUyGSO-~SaUle1J{U0E
`
`
`
`
`
`
`
`Patent Application Publication
`
`APbeeMEDOEEEaeHRS
`
`
`
`Bupayeyy|eqO])vwesqcapy
`
`BeSemanoirea8)(clcascae
`
` pday“OSPEYAAUNUUODLSsooo
`
` ppdaySyZUpVaINUBUOgYyS9000fT
`raEreDMeCrs)©peersCLLoeSc)Oo
`
` Aynuruosfet
`Ceeroe
`<>pew=Aypow
`6Ppoddig
`
`ralojdxyusa]YoOsosp]-sawesjuE]Ey
`PEReeeee
`
`aeperyjode
`
`RGE/OLIO1/WPS,<<wepdry
`
`
`
`
`
`'S6fO/9AwaULFINALIVIN?MeuIpscS>
`
`Jan. 2, 2003 Sheet 13 of 75
`
`
`
`Fpday“SoIpneyAyNURUOgYS
`
` Ol
`
` OTS]
`
`US 2003/0001965 Al
`
`eerRee
`
`elqWNOld
`
`wa
`
`
`
`
`
`STUNIRWIPIYropawoeuynDNN
`
`ZL
`
`
`
`REDD
`
`
`
`CL
`
`
`
`
`
`
`
`
`
`
`
`YOsSoId1py-SowWeLUOTE
`cecePEMD,yoeg|nq.|sjaueug“AloystySaOARIi.n
`
`UGILEISOFPes&IOP.
`Seaee
`
`Talojdsyawa]
`
`eeeeC
`
`btaNold
`
`ARS
`
`TSSrnnysty
`
`podans
`
`x4
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 14 of 75
`
`US 2003/0001965 Al
`
`mad]
`
`yourapyl
`
`
`
`WeerOgi)bead
`
`WhbadCAELOTSae4S
`
`
`
`TEDpPISoD|
`
`yods
`
`ee23F213
`
`nepdon|
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 15 of 75
`
`US 2003/0001965 Al
`
`a[f
`
`Le
`
`
`
`Sepipeyasnoapy
`
`
`
`SGf0S/9aUIS
`
`TEETeosSesIeCS]|LB
`
`eras
`
`
`
`SC/SCiLspuz
`
`yauzsjur
`
`UGljeIsOres
`
`Aynuryuos
`
`mBGeEMT11452“DT
`
`FRUIPICND
`
`zods
`
`StWand
`
`aepdhy
`
`awiraip
`
`UdIONASU]
`
`voddng
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 16 of 75
`
`US 2003/0001965 Al
`
`contmark
`.
`{****** Object: Table dbo,ContinuityMarketron Script Date: 9/25/98 10:27:12 AM *
`EKA/
`.
`if exists (select * from sysobjects where id = object_id (’dbo.ContinuityMarketron’)
`and sysstat & Oxf= 3)
`drop table dbo,ContinuityMarketron
`
`GO
`
`Script Date: 9/25/98 10:27:12 AM *
`
`/***#* Object: Table dbo.ContinuityMarketron
`RHRAKEK/
`CREAT TABLEdbo. ContinuityMarketron (
`StationID int NOT NULL ,
`ContractID varchar (20) NOT NULL,
`SpotTitle varchar (100) NOT NULL,
`StartTime datetime NULL
`Endfime datetime NULL ;
`Advertiser varchar (50) NULL ,
`Coordinated bit NOT NULL ,
`CutID int IDENTITY (1, 1) NOT NULL
`
`Fig. 16a
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 17 of 75
`
`US 2003/0001965 Al
`
`contcuts
`/****4* Object: Table dbo.ContinuityCuts Script Date: 9/25/98 10:24:41 AM *****
`
`t i
`
`f exists (select * from sysobjects where id = object_id (‘'dbo.ContinuityCuts’) and s
`ysstat & Oxf= 3
`drop table. dbo.ContinuityCuts
`
`GO
`
`/****** Object: Table dbo.ContinuityCuts
`
`Script Date: 9/25/98 10:24:41 AM ****#**
`
`/ C
`
`REATE TABLEdbo.ContinuityCuts (
`CUTID int NOT NULL ,
`CutNumbervarchar (12) NOT NULL,
`StationImageURL varchar (100) NULL ,
`AudiosenselmageURL varchar (100) NULL,
`RedirectURL varchar (100) NULL ,
`UpdateStatus varchar (12) NULL,
`UpdateTime datetime NULL,
`NGUpdateTime datetime NULL
`
`Fig. 16b
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 18 of 75
`
`US 2003/0001965 Al
`
`<HTML>
`<HEAD>
`
`<META NAME = "GENERATOR" Content-"Microsoft Developer Studio">
`<META HTTP-EQUIV-"Content-Type" content-"texthtml; charset=iso-8859-1 ">
`<TITLE>ContUtil</TITLE>
`</HEAD>
`<BODYbgColor-"black">
`<FORM name-"formi">
`Value="_"><p>
`StationID:
`<INPUT type-"text" Name="stationID"
`Value="_ "><p>
`CallLetters:
`<INPUTtype-“text" Name="callLetters"
`Value=" "><p>
`Action:
`<INPUTtype-"text" Name="action"
`Value=" *><p>
`LoginName: <INPUT type-"text" Name="loginName"
`Value="_ ‘><p>
`ContractID:
`<INPUT type-"text™ Name="contractlD”
`Value=" “><p>
`SpotTitle:
`<INPUT type-"text” Name="spotTitle"
`Value=""_‘"><p>
`StartTime:
`<INPUT type-"text" Name="startTime"
`Value=""_"><P>
`EndTime:
`<INPUT type-“text™ Name="endTime"
`Value=" "><P>
`Advertisor:
`<INPUTtype-"text" Name="advertiser”
`Value="_‘"><P>
`CutID:
`<INPUT type-“text" Name="cutID"
`Value=" "><p>
`UpdateMode: <INPUT type-"text" Name="updateMode"
`Value=" "><p>
`AppletACK: <INPUTtype-"text" Name="appletACK"
`CutDuplicateStatus: <INPUT type-"text" Name="cutDuplicateStatus" Value=" "><p>
`</FORM>
`
`<script language="JavaScript" src=" .. ‘ScriptLibrary/rs.htm"></script>
`<script language="JavaScript">RSEnableRemoteScripting("./_ScriptLibrary");</script>
`<SCRIPT Language="Javascript">
`<!--hide
`var current SelectionIndex;
`var browseElementindex;
`var defaultLocalGIFDir;
`var appleLaunchNumber;
`
`ff for product drop down list
`4 for cut Imagefile browse
`4 for autofill station local image filename
`
`function myCallBack(co)
`{
`
`alert(“CALLBACK\n\n" +
`“status = " + co.status + "\n\n" +
`“message =“ + co.message + “\n\n" +
`“context = " + co.context + “\aln" +
`“data = "+ co.data+ “\nln" +
`“return_value = "+ co.retum_value);
`'
`
`}
`
`s
`
`function processNGAd(sAdvertiserNanio, SFamilyName, SAdName, nCutID)
`{
`var co;
`
`action = document.forml.action,value;
`if (action == "Coordinate" |
`| action = "Create")
`
`/prompt(“create ad:" + sAdName);<—
`co =RSExecute("./cont_ng.asp","CreateAd"sAdvertiserName,sFamilyName,sAdNamenCutID);
`/myCallBack(co);
`
`100
`
`:
`
`lse if (action == "Update")
`
`updateMode = document.forml.updateMode.value;
`if (updateMode == "Add")
`
`10
`
`}e
`
`/prompt("create ad;" + sAdName);
`co-RSExecute("./cont_ng.asp","CreateAd",sAdvertiserName,sFamilyName,sAdName,nCutlD);
`‘4myCallBack(co);
`
`else if {updateMode == "Modify")
`(
`
`102
`
`Mprompt{“create ad;" + sAdName);
`co=RSExecute("./cont_ng.asp*,"UpdateAd''sAdvertiserName,sFamilyName,sAdName,nCutID);
`fimyCallBack(co);
`
`103
`
`else if {updateMode == "Delete")
`Legend
`]
`[Leg
`‘prompt(“delete ad;" + sAdName);
`co=RSExecute("./cont_ng.asp","DeleteAd"sAdvertiserName,sAdName,nCutID);
`fieayCaliBack(co);|176|}
`;
`}
`function processNGRun(sFamilyName,SProfileName,sStartTame,sEndTime,nlmpGoal,,sPriorityLevel,
`ScampaignName,sTotalCost)
`{
`var nRunID;
`prompt(“create run for thbe family");
`co=RSExecute("./cont ng.asp",CreateFamilyRun",sFamtlyName,sProfileName,sStartTime,
`sEndTime,nlmpGoal,sPriorityLevel,SCampaignName, sTotalCost);
`nRunld =
`co.
`return_value;
`ienyCallBack(oo),
`
`FIGURE 17a
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 19 of 75
`
`US 2003/0001965 Al
`
`<%@ LANGUAGE-VBSCRIPT%>
`<% RSDispatch %>
`
`<SCRIPT RUNAT=SERVERLanguage=javascript>
`<!--4INCLUDE FILE="// ScriptLibrary/rs.asp" -- >
`<{--#INCLUDE FILE="// ScriptLibrary/Asp/dbconnection.asp" -- >
`<1--#INCLUDE FILE="/ cont_ng,js" -- >
`
`public_description - new cont_ng();
`
`</SCRIPT>
`
`Fig. 17b
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 20 of 75
`
`US 2003/0001965 Al
`
`<SCRIPT RUNAT=SERVER Language="vbscript>
`
`Function cont ng ConvertQuotes(oldStr)
`Nim newStr, SingleQuote, DoubleQuote
`
`SingleQuote = Che(39) & Chr (43) & “char(39)" & Chr (43) & Chr (39)
`DoubleQuote = Chr(39) & Chr (43) & “char(34)" & Chr (43) & Chr (39)
`
`newSTR = Replace(oldStr. Chr(39), SingleQuote)
`newSTR = Replace(newSt. Chr(34), DoubleQuote)
`
`cont ng ConvertQuotes = newStr
`End Futiction
`
`<(SCRIPT>
`
`<SCRIPT RUNAT=SERVERLanguage=javascript>
`<!--#INCLUDE FILE="/ ScriptLibrary/Asp/ng advertisers..js* - >
`<!--#INCLUDE FILE="/ ScriptLibrary/Asp/ng families..js” ~ >
`<!-#INCLUDE FILE="J SeriptLibrary/Asp/ng profiles,.js" -- >
`<!-#INCLUDE FILE="/ SeriptLibrary/Asp/ng dimensions..js" —~- >
`~<I-#INCLUDEFILE="/ SoriptLibrary/Asp/ig ads.,js" ~ >
`<!--4INCLUDE FILE="J/ ScriptLibrary/Asp/ng runs..js" —~ >
`<t-.#INCLUDE FILE="/ ScriptLibrary/Asp/ng properties..js" —~ >
`<I-#INCLUDE FILE="/ ScriptLibrary/Asp/ng values..js" -- >
`<|—-#INCLUDE FILE="/ ScriptLibrary/Asp/ng targets..js" ~ >
`<{--#INCLUDE FPILE="/ ScriptLibrary/Asp/ng_familytargets..js" -- >
`function cont_ng{ }
`{
`
`this.CreateAd
`this.UpdateAd
`this.DeleteAd
`this.CreateFamilyRua
`
`= cont ng CreateAd;
`= cont og UpdateAd;
`= cont ng DeleteAd;
`= cont_ng_CreateFamilyRun;
`
`
`
`104
`o
`
`105
`
`} f
`
`unction cont_ng_CreateAd(sAdvertiseName, sFamilyName, sAdname, sCutld)
`{
`.
`var sCutNumber;
`var sContent;
`var sClickURL;
`var sAltText;
`var nContentType
`‘var 183
`var sQSAdName
`var sQSAdvertiserName
`df contenttype is image
`aContentType = 3;
`sAltText =--;
`var count = 0;
`sSqll = “select CufNumber- AudiosencelmageURL, RedirectURL from CONTINUITYCUTS;
`sSqli = sSqlt +* where CutlD = " + nCuthd;
`sSqll =sSqli +" and NGUpdateTime < UpdateTime";
`rs = idaDBCont.Execute(sSqlf};
`
`= cont ng ConvertQuotes(sAdName);
`=cont_ngConvertQuotes(sAdvertiserName);
`
`var ads = new ng_adis( );
`var nAdvertiserld== cont ng CresteAdvertiser(sAdvertisesName);
`
`var nFamilyld
`=
`cont_ngCreateFamily(sFamilyName);
`
`if(ts,EOF = false)
`c
`
`while (rs.EOF == false)
`{
`count = count + 1
`sCutNumber== ts.FieldsItem(0).Value;
`
`sFiteName
`=
`18Fields.ltem(!).Value;
`sContent
`=
`“hetp://continuityeq.audiosense.com/" + escape(sFileName);
`sClickURL
`=
`rs.Rields.Jtem(2).Value;
`sNewAdName =
`sQSAdName + *-" + sCutNumber;
`
`var nid=ads,Create(nAdvertiserld,nFamilyld,sNewAdName,nContentType,sContent,
`sClickURL, sAltText);
`
`var nYalueld = cont ng AddDimensionValue (“Item ID", "String", sCutNumber, SCutNumber);
`cont_ngSetFamilyTarget(ild, nValueld);
`
`nValueld = cont ng ReadDimensionValue (“Item Type", "Traffic";
`cont_ng_SetFamilyTarget(nld, nValueld);
`rts.MoveNext();,
`
`FIGURE 18a
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 21 of 75
`
`US 2003/0001965 Al
`
`cont_ng_SetnGipdateTime(nCutId):
`return count;
`
`106m
`
`function Cont_ng_UpdateAd(sAdvertiserName, sFamtlyName, sAdName, nCutId)
`var sCutNumber;
`var sContent:
`var $CHIckURL:
`var £S:
`var sOSAdName
`var sQSAdvertiserNané
`var count = 0;
`sSali ~ “select Cuttunber AudiosenselmaaclRL. RedirectlRL from CONTIMUITYCUTS":
`sSoll = sSall + * were
`CutID = * + noulld:
`SSal1 = sSobl ¢ * tNNalpcateTine < Updateline*:
`rs ~ idabiConn. txecute(sSqil)
`
`= cont na ConvertOuctes( sAdName
`== contng.convertouotessAdverEigerlane)
`
`it (rs.EOF — false)
`var ads - new ng_ads():
`white (rs.£0F — false)
`count = court + 1:
`sCuthurber
`= rs.Fields. Iten(0),Yalue:
`sFileNane
`= TS.Fields.Tten(])Valve:
`sContent
`“htto:/‘continuityimo .audiosense. coms” + escape(siteName}:
`sChickURL
`= FS.Fields.Itemt2}.Value:
`sNewAdName
`» sQSAdName + “_" + sCuthumber;
`ads.SotInaceSce'sOSAtvertisertiane. SNewAdName. sContent):
`Ads. SetCl ickURL(sQSAdvertiserName. sNewkiName. sCTickURL):
`rs Hovelext():
`
`}
`}
`cont_ngSetnGUpdateTime(nCutId):
`return count:
`
`«107
`
`function cont_ngDeleteAd(sAdvertiserName, sAdName. nCutTd)
`var rs:
`var sOSAdvertiserttame
`= cont na ConvertQuotes(sAdvert{serName) ;
`ver sOSAdHoneFi
`- cont_ng_ConvertQuotes{sAdNamne} ;
`var cout
`=
`Q;
`seolt - “select fathanbor fron CONTEmaTNCOs"
`= sSoll + ° where CutID =°+ nCutl
`eal = SSqil +" and NodateTine < tdTine":
`rs — idaDBConn txecute(s$qll);
`i (rs,€0F e~ false)
`vat_ads = new na ads{
`wile (rs.£0F == fise)
`
`count = count + 1:
`sCuthumber
`«rs, Ftelds.Than(0) Value:
`SRewAdHame
`= sOSAdtiane + * * +” sCuttonbe
`ads Delete(sOSAdvertiserName, sNew\dName):
`ts HoveNext(};
`
`}
`i
`cont_ng_ScthaodateTtme(nCutId)-
`return count;
`
`108
`
`/
`
`iwiclton cont_ngCreateFam{lyRun(slamtiytame. sProfileName, sStertOate, sEndDate, nimpGoal, sPriority, sCampaignName. sRunCost)
`yar nProfiteld:
`var nfamilvid:
`var nAdOrFanily:
`var MPitority;
`var nRunid:
`var sOSCampaigaliase== cont_ngConvertQuotes(sCampa tontlare}:
`
`FIGURE 18b
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 22 of 75
`
`US 2003/0001965 Al
`
`nProfileld = cont nq ReadProfile(sProfileNane).
`nfamilyld
`=» cont_ng_ReadFamily(sFami]yNare) :
`it (nFamityld !~ -1 8% nProfilald t= -1)
`nédQrFamily = 4;
`gwitch (sPriority}
`case “Highest’:
`
`nriocity = 1:
`bredk:
`
`fase “High’:
`nPriority = 25:
`break:
`
`qe "Nordal':
`aPriority = 50:
`break:
`
`case ‘Low’:
`
`nPriority = 75:
`break:
`
`gase *Lowest':
`nPriority =~ 160:
`break:
`default:
`return -1:
`
`runs ~ new na runs(}:
`nuald - runs.Create(nFamilyld. néddrrantly, nProfileld, sStartOate, stndbate. nlmpGoal. nPriority}:
`if (nRumld > 0)
`Oraoerties = néw nq properties ():
`sOSCampaignName) :
`oronerties Create¢“CAMPATGR®. nkunid. “NG RURS*.
`properties Create("COST". nRunid.
`“NG_RUMS". sRunCast):
`
`return nRunld;
`
`return -1:
`
`}e
`
`lse
`
`function cont_ng_CresteAdvertiser(sNane)
`yar advertisers:
`var nid.
`== cont, nq_ConvertQuotes(sName):
`var sOSFamilyNamé
`advertisers + new ma advertisers();
`nig ~ advertisers .Create( sQ6Fami tyNene,
`retuen nid:
`
`a6 ma any.
`
`} f
`
`} f
`
`unction cont_pg_CreateFamily(sName)
`yar families:
`var nid:
`~ cont_ngConvertQuates(sName);
`var sQSfamilyName
`families — new m4 families):
`nid ~ families Create (sQSFamilyNane);
`return nid;
`
`unccn cont_ng_CreateProfile(stane)
`yar profiles:
`var nid:
`var sOSProfileName ~ cont_ng_ConvertQuates(sNane}:
`oroftles = nes na orotilest):
`ald = profiles .createcsOSProfitename, 1, 0. ““}:
`return nid:
`“
`
`FIGURE 18c
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 23 of 75
`
`US 2003/0001965 Al
`
`function cont_ng_CreateDimension(sDimName, aAttName, sDimType, SSource)
`{
`var nDimType;
`;
`var nd;
`var sQSDimensionName = cont_nig.ConvertQuotes(sDimName);
`switch (sDimType)}
`{
`case ‘Number;
`{
`
`nDimType = 0;
`break
`
`}c
`
`ase ‘Number Range’;
`{
`
`aDimType = 1;
`break
`
`case ‘String’;
`
`nDimType = 2;
`break
`
`}c
`
`}c
`
`ase ‘String Range’;
`{
`
`aDimType = 3;
`break;
`
`ase 'String Prefix’;
`
`aDimType = 4;
`break;
`
`aso ‘String Prefix Range’;
`
`}c
`
`aDimType = 5
`break;
`
`case Expression’;
`
`nDimType = 6;
`break;
`
`ase ‘Daypart;
`
`aDimType = 75
`break;
`
`efault;
`
`return -1;
`
`}d
`
`{
`
`}c
`
`{
`
`dimensions = new ng dimensions();
`ald = dimensions.Crea
`imensi
`retum ant
`te{sQSDimensionName, sAttName, iDimType, sSource);
`
`} f
`
`unction cont_ng_AddDimensi
`is
`i
`‘
`ensionValue(sDimName, sDimType, sValueName, sValue)
`
`FIGURE 18d
`
`* cont ng ConvertQuotes(sDimName);
`= contng_ConvertQuotes(sValueNare);
`
`var nDimType;
`var dimensions;
`var ld;
`var sQSDimensionName
`var sQSValueName
`ne (SDimType)
`:” ‘Number;
`aDimType = 0;
`break;
`
`‘String’
`
`nDimType = 2;
`api
`default;
`é
`
`Tetura ~1;
`
`sValue);
`
`} d
`
`imensions = new ng dimensions( );
`nid = dimensions.AddV;
`i
`i
`i
`7
`ream ns
`‘alue(sQSDimensionName, uDimType, sQSValueName,
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 24 of 75
`
`US 2003/0001965 Al
`
`) f
`
`unction cont_ng_ReadFamily(sName)
`
`var nid;
`var SQFamilyName
`
`= cont_ng_ConvertQuotes(sName);
`
`families = new ng families();
`ald = familiesRead(sQSFamilyName);
`return nid;
`
`} f
`
`unction cont_ng_ReadProfile(sName)
`{
`
`var nid;
`var QSProfileName
`
`= cont_ng_ConvertQuotes(sName);
`
`profiles = new ng profiles( );
`tld = profiles.Read(sQSProfileName);
`return nid;
`
`unction cont_ngReadDimensionValue(sDimName, sValueName)
`
`var nid;
`var sQSDimensionName
`var sQSValueName
`
`= cont ng ConvertQuotes(sDimName);
`= cont_ng_ConvertQuotes(sValueName);
`
`} f
`
`.
`values = new ng values( );
`old = values.Read(sQSDimensionName, sQSValueName);
`return ald;
`
`} f
`
`unction cont_ng_SetProfileTarget(sProfileName, sDimName, sValueName)
`{
`
`var profiles;
`var nid;
`= cont ng ConvertQuotes(sProfileName);
`yar sQSProfileName
`var sQSDimensionName = cont ng ConvertQuotes(sDimName);
`var sQSValueName
`=cont_ngConvertQuotes(sValueName);
`
`profiles = new ng profiles( );
`nld = profilesSetTarget(sQSProfileName, sQSDimensionName, sQSValueName);
`return nid;
`
`} f
`
`unction cont_ngSetFamilyTarget(nAdld, nValueld)
`
`var ads;
`var nid;
`
`ads = new ng ads();
`ald = adsSetfamifuTormet(nAdid, nValueld);
`return nid;
`
`} a
`
`=cont ng ConvertQuotes(sAdvertiserName);
`=cont_ngConvertQuotes(sAdName);
`
`ction cont_ng_SetFrequencyLimit(sAdvertiserName, sAdName, oFrequencyLimit)
`var ads;
`var sQSAdvertiser(Name
`var sQSAdName
`ads = new ng ads();
`adsSetFrequencyLimit(sQSAdvertiserName, sQSAdName, oFrequencyLimit);
`)
`cation cont_ng_SetClickURL(sAdvertiserName, sAdName, sClickURL)
`var ads;
`var sQSAdvertiserName
`yar sQSAdName
`ads = new ng ads();
`ads.SetClickURL (sQSAdvertiserName, sQSAdName, sClickURL);
`
`FIGURE 18e
`
`= cont ng ConvertQuotes(sAdvertiserName);
`=cont_ng_ConvertQuotes(sAdName);
`
`} f
`
`unction cont_ng_SetimageSre(sAdvertiserName, sAdNamte, simageSre}
`var ads;
`var sQSAdvertiserName
`var sQSAdName
`ads = new ng ads( );
`ads.SetlmageSro(sQS.Advertise:Name, sQSAdName, slmageSro);
`
`= cont ng ConvertQuotes(sAdvertiserName);
`= cont_ng_ConvertQuotes(sAdName);
`
`} f
`
`unction cont_ng_DeleteAdvertiser(sName)
`{
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 25 of 75
`
`US 2003/0001965 Al
`
`var sQSAdvertiserName
`
`= cont_ng_ConvertQuotes(sName);
`
`advertisers = new ng advertisers();
`advertisers.Delete(sQSAdvertiserName);
`
`function cont_ng_DeleteFamily(sName)
`
`var sQSFamilyName
`
`= cont_ng_ConvertQuotes(sName);
`
`families = new ng families( );
`families.Delete(sQSFamilyName);
`
`} f
`
`unction cont_ngDeleteProfile(sName)
`
`var sQSProfileName = cont_ngConvertQuotes(sName);
`
`profiles = new ng profiles( )
`profilesDelete(sQSProfileName);
`
`} f
`
`unction cont_ng_DeleteDimension(sName)
`
`var sQSDimensionName = cont_ng_ConvertQuotes(sName);
`
`dimensions = new ng dimensions( );
`dimensions.Delete(sQSDimensionName);
`
`} f
`
`unction cont_ngDeleteDimensionValue(sDimName, sValueName)
`{
`
`var sQSDimensionName =cont ag ConvertQuotes(sDimName);
`var sQSValueName
`=cont_ngConvertQuotes(sValueName);
`
`dimensions = new ng dimensions();
`dimensions.DeleteValue(sQSDimensionName, sQSValueName);
`
`} f
`
`unction cont_ng_SetNGUpdateTime(nCudd)
`{
`
`var Ts;
`
`sSqit = "update CONTINUITYCUTS";
`sSqli = sSql1 + “ set NGUpdateTime = getDate()";
`sSqll = sSqll +" where CulD =" + nCutid;
`sSqll =sSqil + " and NGUpdateTime < UpdateTime";
`ts = idaDBConn.Execute(sSql1);
`.
`
`}
`
`<{SCRIPT>
`
`FIGURE 18f
`
`
`
`Patent Application Publication
`
`SlavAnaeagiayl
`
`US 2003/0001965 Al
`
`®6l
`
`Jan. 2, 2003 Sheet 26 of 75
`
`WANDA =speppeSu
`
`Tosplaapesity03SIuOpaqTpPPaigos|aq"
`soneaSucounauseenlsiasys94ps/sasa4peBaoeaiSEO
`
`
`
`
`Jan. 2, 2003 Sheet 27 of 75
`
`US 2003/0001965 Al
`
`ISTXSLOUTTaBAypureywaywarsy°
`
`CyPoriAjongapmay
`
`‘VeROJCtLonsywimaxpueyoureeg-|
`
`
`
`I~GnjalSSMi0INd
`
`
`JaySityJoyPoyeoussumAojaql"Eg
`
`
`
`AYTOIGYSiqpJownspycacy+z
`
`CL283gopuy73SpOJOUOHItoye“1
`
`1tanosmIOTIO
`
`Sx9JtCYesReApea]aIpoeyaresg“7SuLyssureN--OUENG
`
`
`mesatuMOY~Z=
`
`Patent Application Publication
`
`
`TORY
`
`SERIOnopeaporomsyTaPeSipso}podeatssoamATronyoy;[JeST-g-
`
`
`
`SOSTHOADESTMOFSugaqspeaq[TeIq
`PUSIRsoyporwsroSanuseppeowpIq«*z
`
`
`
`
`
`
`‘ISIXGJICT198mApruneyayyWerpunyIesg“7
`
`
`
`[-walaastauromo
`
`461FANS
`
`
`
`SKDUUNSoeary"]T
`
`
`
`mispumsy-z
`
`
`
`~ARUEOPYN
`
`~Mayyorrn
`
`
`
`—dsBQUEISS
`
`
`
`oworDsumaysoniShy
`
`PimAmeyadye4cao
`
`
`
`
`
`Baie[AUeIPVSAOURjp
`
`
`
`
`
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 28 of 75
`
`US 2003/0001965 Al
`
`
`
`
`
`
`
`intaifyOFPayealdsotyacoldoyTeselscr
`
`
`
`
`
`petq)10}payeorssuNISHHTessfsqU_
`
`
`
`yerxeJousTopzoudores”
`
`
`
`Mayonmummy|
`
`UISIJoyIpesys*}
`
`tropaedI
`
`
`
`OSIMIOINO4sIKSHCTUNayWIMPURRS
`
`q>tomes
`
`
`
`~AareztOPVN
`
`—(sGQdWIN
`
`—AUOUdN
`
`'ysrxoITC1]styoadscpuamyoapuwyng
`
`
`
`anjeapudopryordsiqyJoyJOBE?MaDeOWI*
`
`CrivswesyumMse“2
`
`
`
`ToTMIALSEIALAIO
`
`%61HANOI
`
`UMtpJO}PoreedsSatPHOTO
`AproreyST}10}payeawssonsOtTeSete*
`
`~HEQPUgs
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 29 of 75
`
`
`
`
`
`ToUmyalasLniso*yS1x9
`
`1StXOJOOJLuoystumpBoyar¢
`
`CIvorsnewrpomwsy
`
`
`
`HOISUSUNpSI)0]SULSHOOSANYVAFTEs1ojOCT
`
`WOISUSUNDonysIOTaCy
`
`
`
`HOSUSUypsityJoyoxjearpoy°
`
`
`
`onIEDLOIsTanncy
`
`CISnRAayumiy*
`
`odymorsuaoncy
`
`OWEONE,
`
`ane,
`
`
`
`TOYSUATpSTH}JOSKIBAWhsepa]*
`
`
`
`18Ixa101ytefgoenyeaBsyeRT*
`
`caronjesopwmey*
`
`‘ISTXOJfCTLHWToTWatpovonjeastptoyyorweg
`
`
`
`TEinjes“astArayyo
`
`
`
`SULTUOISDSIOTC]j
`
`AIUBNOneA:
`
`US 2003/0001965 Al
`
`
`
`P6tdaNOW
`
`—CINaAigaaomay
`
`JICYsttwumnsrpusAyradarday.myqarmag=~
`
`astxatougtAvedoud2oyess*],
`
`-od{p399190$
`
`—aefon
`
`
`
`—IWENS
`
`~320RNS
`
`-adhpalagg
`
`—CBIGON
`
`~staeNS
`
`
`
`sotpadordssoiuadosd“Sy
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 30 of 75
`
`US 2003/0001965 Al
`
`
`
`
`
`=StaeEg
`
`SNeAWolsusuucyancurayy
`
`anyeaarpaq“]Coo
`SdTBASITOSWinHacreAitunRyIfeqaleqzr
`-_39afgo
`polgoanyenapaysiaqe+]
`
`acy
`961TANOI
`
`
`
`—seNIONPS
`
`
`
`
`
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 31 of 75
`
`US 2003/0001965 Al
`
`ADVERTISERS
`ID
`
`OBJECT ID PROFILE ID
`
`PROPERTIES
`ID
`
`
`
`
`ID
`
`
`
`
`TARGETS
`1D
`PROFILE ID
`
`VALUE ID
` DIMENSION ID
`
`
`
`ADS
`ADVERTISERID
`
`FAMILY ID
`
`
`
`PROFILES
`
`
`FAMILIES
`GROUP !D
`iD
`
`
`
`
`FAMILY TARGETS
`ID
`AD 10
`VALUE ID
`
`‘DIMENSIONS
`ID
`
`STYLES
`ID
`
`FIG. 20
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 32 of 75
`
`US 2003/0001965 Al
`
`<%@ LANGUAGE=VBSCRIPT %>
`<% RSDispatch %>
`
`<SCRIPT RUNAT=SERVER Language=javascript>
`<!--#INCLUDE FILE="../rs.aasp"-->
`<!--#INCLUDE FILE="dbconnection.asp"~-->
`<{~-#INCLUDE FILE="ng_ads.js"-->
`
`publicdescription = new ng_ads();
`
`</SCRIPT>
`
`Fig. 217
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 33 of 75
`
`US 2003/0001965 Al
`
`<SCRIPT RUNAT=SERVER Language="JavaScript">
`
`function ng_ads()
`{
`
`= ng_ads_Create;
`this.Create
`= ng_ads_Read;
`this.Read
`= ng_ads_Update;
`this.Update
`
`this.Delete. = ng_ads_Delete;
`this.SetFamilyTarget
`= ng_ads_SetFamilyTarget;
`this.SetFamily
`= ng_ads_SetFamily;
`this.GetFamily
`= ng_ads_GetFamily;
`
`this.SetFrequencyLimit
`this.SetClickURL
`this .SetImageSre
`
`= ng_ads_SetFrequencyLimit;
`= ng_ads_SetClickURL;
`= ngadsSetImageSrc;
`
`this.RemoveAdvertiserAd = ngads_RemoveAdvertiserad;
`this.RemoveFamilyAd
`= ng_ads_RemoveFamilyAd;
`
`} /
`
`/create a new instance from the supplied parameters
`function ng_ads_Create (nAdvertiserId, nFamilyId,
`sName,
`nContentType, sContent,
`sClickURL, sAltText)
`{
`
`var nid;
`
`if (nAdvertiserId <= 0}
`return -1;
`
`nId = ng_adsRead(nAdvertiserId,
`if (nId > 0)
`return nid;
`
`sName) ;
`
`else
`{
`
`sSqli = "insert into admanager.admanager.
`:
`Ng_
`ads ";
`sCols = "(";
`3
`sSql2 = " values ";
`sValues = "(";
`
`sCols += "ADVERTISERID";
`sValues += nAdvertiserId;
`
`sCols += ",NAME";
`sValues += ", ";
`sValues += "tN
`sValues += sName;
`
`Fig. 22a
`
`[Legend]
`
`
`
`
`
`Patent Application Publication
`f
`
`Jan. 2, 2003 Sheet 34 of 75
`
`US 2003/0001965 Al
`
`sValues += "Ff";
`
`switch (nContentType)
`
`/f/text
`case 1:
`
`sCols += ",ADTEXT";
`break;
`-
`
`}/
`
`/naeml
`case 2:
`
`sCols += ",HTML";
`break;
`
`{/image
`case 3:
`{
`
`sCols += ",IMAGESRC";
`break;
`
`default:
`{
`
`return -1;
`
`}
`
`} s
`
`WW.
`"
`f
`f
`NeW,f
`
`Values +=
`sValues t=
`sValues += sContent;
`sValues += "'";
`
`sCols += ",MAXFREQUENCY";
`sValues t= %,"j
`sValues += "0";
`
`sCols += ",CLICKURL";
`sValues += ",";
`sValues += "'";
`sValues += sClickURL;
`sValues += "'";
`
`rs = dbconn.Execute("select max{ID)
`admanager. admanager.ng_ads") ;
`nid = rs.Pields.Item(0) .Value + 1;
`
`from
`
`sColis t= ",ID";
`sValues--+= ",";
`sValues += nId;
`
`sCols += ")";
`
`Fig. 22b
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 35 of 75
`
`US 2003/0001965 Al
`
`sValues += ")";
`
`sSql = sSql1 + sCols + sSql2 + sValues;
`rs = dbconn.Execute(sSql) ;
`
`// set the family id for the ad
`ng_adsSetFamily(nId, nFamilyId) ;
`
`return nid;
`
`sName)
`
`} /
`
`/returns the id for the name
`function ng_ads_Read(nAdvertiserlId,
`{
`
`var nid;
`
`sSqlil = "select ID from admanager .admanager.NG_ADS where
`ADVERTISERID = " + nAdvertiserId + " and NAME = '" + sName + wid,
`rs = dbconn.Execute (sSql11) ;
`if (rs.EOF == false)
`‘nId = rs.Fields.Item(0) .Value;
`
`else
`
`nid = -i;
`
`return nid;
`
`unction ng_ads_Update ()
`
`} f
`
`.
`
`{} f
`
`{
`
`unction ng_ads_Delete (sAdvertiserName,
`
`sName)
`
`var nid;
`var nAdvertiserId;_
`
`advertisers = new ng_advertisers();
`nAdvertiserId = advertisers.Read (sAdvertiserName) ;
`
`nid = ng_ads_Read(nAdvertiserId,
`if (nId > 0)
`
`sName) ;
`
`sSqll = “delete admanager.admanager.NG_ADS
`where ID =.
`dbconn. Execute (sSql1) ;
`
`runs
`familytargefs
`
`tt
`
`new ng_runs () ;
`new ng_familytargets() ;
`
`runs .RemoveAdRun (nId) ;
`familytargets .RemoveAdFamilyTarget (nId) ;
`
`" + nid;
`
`Fig. 22c
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 36 of 75
`
`US 2003/0001965 Al
`
`}
`
`unction ng_ads_SetFamilyTarget (nId, nValueId)
`
`var nFamilyTargetIid;
`
`if (nId <=0 |[{ nValueId <= 0)
`return -1;
`
`//Relate ad to the value
`familytarget = new ng_familytargets() ;
`nFamilyTargetId = familytarget.Create(nId,
`NValueID})
`; return nFamilyTargetId;
`
`} f
`
`{
`
`} /
`
`/function ng_ads_SetFamily(nId, nContractId)
`function ng_ads_SetFamily(nId, nFamilyId)
`{
`
`var Xs;
`var nFamilyOrder;
`
`if (nId <=0 || nFamilyId <= 0)
`return ~-1;
`
`f/fcontractFamily = new as_contractFamily();
`//nFamilyid = contractFamily.Create (nContractId) ;
`
`if (nFamilyiId > 0)
`
`// set the family id that this ad belongs
`to sSqll = "update admanager.admanager.ng_
`ads set FAMILYID = " + nFamilyId;
`sSqll = sSqll + " where ID = " 4 nId;
`dbconn.Execute (sSq1i1) ;
`
`// determine the number of ads belonging to
`
`the family
`
`from
`sSql2 = “select count(*)
`admanager.admanager.ng_ads where FAMILYID = " + nFamilyId;
`rs = dbtonn.Execute(sSql12) ;
`nFamilyOrder = rs.Fields.Item(0) .Value - 1;
`
`// set the family order number for this ad
`sSql3 = "update admanager.admanager.ng_ads
`set FAMILYORDER = " + nFamilyOrder;
`sSql3 = sSql3 + " where ID = " + nid;
`dbconn. Execute (sSql3) ;
`
`}r
`
`eturn nFamilyId;
`Fig. 22d
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 37 of 75
`
`US 2003/0001965 Al
`
`function ng_ads_GetFamily (nId)
`{
`
`if (nId <s 0)
`return -1i;
`
`sSqll = “select FAMILYID from admanager .admanager.
`NG_ADS where ID = " 4 nid;
`rs = dbconn. Execute (sSq11) ;
`
`Lf
`
`else
`
`(rs.EOF == false)
`nid = rs.Fields.Item(0) .Value;
`
`nId = -1;
`
`return nid;
`
`function ng_ads_SetFrequencyLimit (sAdvertiserName,
`nFrequencyLimit)
`
`sName,
`
`var nid;
`var nAdvertiserId;
`
`advertisers = new ng_advertisers();
`nAdvertiserlId = advertisers. Read (sAdvertiserName);
`nid = ng_ads_Read (nAdvertiserid,
`sName) ;
`if (nId > 0)
`SSqll = “update admanager .admanager.NG_ADS set
`MAXFREQUENCY = " 4 nFrequencyLimit;
`sSqll = sSqli + " where ID = " 4 nid;
`dbconn. Execute (s$q11) ;
`
`sClickURL)
`{
`
`Function ng_ads_SetClickURL (sAdvertiserName,
`~
`
`sName,
`
`var nid;
`var nAdvertiserid;
`
`= new ng_advertisers ();
`advertisers
`= advertisers. Read (sAdvertiserName);
`nAdvertiserId
`nId = ng_ads_Read (nAdvertiserId,
`sName};
`if (nId > 0)
`
`sSqll = “update admanager.admanager.NG_ADS set
`CLICKURL = '" 4 sClickURL, + Wen;
`sSqil = sSqlil + " where Ip = 4 + nid;
`dbconn. Execute (sSql11) ;
`Fig 22¢
`
`}
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 38 of 75
`
`US 2003/0001965 Al
`
`} f
`
`unction ng_ads_SetImageSrc (sAdvertiserName, sName, sImageSrc)
`
`var nid;
`var nAdvertiserId;
`
`advertisers
`nAdvertiserid
`
`il
`
`new ng_advertisers({);
`advertisers.Read (sAdvertiserName) ;
`
`nid = ng_ads_Read(nAdvertiserId,
`if (nId > 0)
`{
`
`sName) ;
`
`IMAGESRC =
`
`sSqli = "update admanager.admanager.NGADS set
`' + sImageSre + "'%;
`sSqli = sSqll + " where ID = " + nid;
`dbconn.Execute (sSq11) ;
`
`}
`
`function ng_ads_RemoveAdvertiserAd (nAdvertiserId)
`{
`
`var rs;
`var nid;
`
`runs
`familytargets
`
`= new ng_runs();
`= new ngfamilytargets();
`
`sSqll = “select ID from admanager.admanager.NG_ADS
`where ADVERTISERID = " + nAdvertiserId;
`rs = dbconn. Execute (sSql1);
`
`while (rs.EOF == false)
`{
`
`nid = rsi.Fields.Item(0) .Value;
`sSqi2 = "delete admanager.admanager.NG_ADS where
`
`ID =" + nid;
`
`dbconn.Execute (sSq12) ;
`
`runs .RemoveAdRun (nId) ;
`familytargets.RemoveAdFamilyTarget (nId) ;
`
`rs.MoveNext ();
`
`}
`
`function ng_ads_RemoveFamilyAd (nFamilyId)
`{
`
`sSqli = "update admanager.admanager.NG_ADS set FAMILYID
`=1 where FAMILYID = " + nFamilyId;
`dbconn. Execute (sSql11) ;
`
`}
`
`"Fig. 22f
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 39 of 75
`
`US 2003/0001965 Al
`
`</SCRIPT>
`
`Fig. 229
`
`
`
`Patent Application Publication
`
`Jan. 2, 2003 Sheet 40 of 75
`
`US 2003/0001965 Al
`
`<%@ LANGUAGE=VBSCRIPT ¢>
`<% RSDispatch %>
`<SCRIPT RUNAT=SERVER Language=javascript>
`<!--#INCLUDE FILE="../rs -asp"-->
`<!--#INCLUDE FILE="dbconnection.asp"-->
`<!--#INCLUDE FILE="ngadvertisers.js"-->
`
`publicdescription = new ng_advertisers();
`
`</SCRIPT>
`
`Fig. 23
`
`
`
`Patent Application Publication
`
`Jan. 2,