| Author |  Topic  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 13 December 2003 :  16:46:03   
 |  
                      | Advert Rotator 1.0 
 uses the MSWC.AdRotator object
 requires a directory with write permissions
 
 Allows full administration of banner advertisement and storage of click-through, eg, member name and date
 
 Although statistics are stored there is no display feature for them at present, I will add this at a later stage.
 Form validation is a bit dodgy also, ensure that the Frequency field when adding an advert is a number (see MSWC.AdRotator documentation for details on what this does)
 
 
 Demo
 Download here
 |  
                      | The UK MkIVs Forum
 |  
                      | Edited by - DavidRhodes on 13 December 2003  16:49:11
 |  | 
              
                | EtymonAdvanced Member
 
      
 
                United States2396 Posts
 | 
                    
                      |  Posted - 14 December 2003 :  02:30:18     
 |  
                      | Thank you for the code!  
 Looking forward to how the code develops. Let someone know if you need any help on this.
 
 Cheers,
 
 Etymon
 
 |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 14 December 2003 :  15:54:33   
 |  
                      | BUG + FIX 
 admin_advert.asp line 167
 replace
 Response.Write("<br><img name=""imgFilePath"" src="""& strARUploadPath & sImage &""">")withResponse.Write("<br><img name=""imgFilePath"" src="""& strARUploadPath & "/" & sImagePath &""">") |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 17 December 2003 :  18:47:57   
 |  
                      | Has anyone installed this yet? Just want to make sure it works okay before I do the stats page for advert hits |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | ClassicmotorcyclingDevelopment Team Leader
 
      
 
                Australia2085 Posts
 | 
                    
                      |  Posted - 17 December 2003 :  19:59:00   
 |  
                      | I gave it a shot, and there was files missing or calling the wrong pages and db errors when adding items. quote:As I was extreamly busy on the day I was trying, I put it a side and have not looked at it since.Originally posted by DavidRhodes
 
 Has anyone installed this yet? Just want to make sure it works okay before I do the stats page for advert hits
 
 
 
 Shall look on the week-end if I get a chance...
  |  
                      | Cheers,
 
 David Greening
 |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 18 December 2003 :  04:23:26   
 |  
                      | Cheers, let me know what the db errors were. I just checked the zip and all the required files are there |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | EtymonAdvanced Member
 
      
 
                United States2396 Posts
 | 
                    
                      |  Posted - 18 December 2003 :  11:52:34     
 |  
                      | Hi David, 
 I got tangled up in a mess with my own MOD this week. Still trying to get to yours. Sorry. Will try it after work tonight.
  
 |  
                      |  |  | 
              
                | ImageAverage Member
 
    
 
                Canada574 Posts
 | 
                    
                      |  Posted - 18 December 2003 :  16:57:29     
 |  
                      | For the error in db, I replace 
 IMAGE#varchar(50)#NULL#
 
 for
 
 IMAGE_URL#varchar(50)#NULL#
 
 [CREATE]
 ADVERT
 ADVERT_ID
 COMPANY#varchar(50)#NULL#
 TITLE#varchar(255)#NULL#
 URL#varchar(255)#NULL#
 IMAGE_URL#varchar(50)#NULL#
 FREQ#int#NULL#
 [END]
 
 and I rename all files who contains IMAGE whit IMAGE_URL
 
 
 have cannot see this in admin_advert_home.asp
 if Len(Trim(strARUploadPath))> 0 then
Response.Write	"				<LI><a href=""admin_advert.asp?Mode=Add"">Add Advert</a>    </LI>" & vbNewLine & _
		"				<LI><a href=""admin_advert.asp?Mode=Edit"">Edit/Delete Advert</a>    </LI>" & vbNewLine
end if
 Demo: http://www.forums2001.com/forum/adverts.asp?sectionid=5
 
 |  
                      | Edited by - Image on 30 December 2003  15:26:56
 |  
                      |  |  | 
              
                | EtymonAdvanced Member
 
      
 
                United States2396 Posts
 | 
                    
                      |  Posted - 30 December 2003 :  15:24:39     
 |  
                      | Demo looks nice, Image. Good job!
 
 Still haven't gotten untangled David. My apologies. Will try it soon on my newest forum though.
  |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 30 December 2003 :  18:40:26   
 |  
                      | Cheers for the demo Image, i'll fix the zip with your changes |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 30 December 2003 :  18:46:01   
 |  
                      | Image, apart from the fields name in the database, did it work ok? I'm embarassed to say I couldn't test it fully as FSO didn't seem to work on my laptop, didn't do bad though  |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 20 January 2004 :  15:53:18   
 |  
                      | Bugs fixed and new zip added, see original download link in first post |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | ImageAverage Member
 
    
 
                Canada574 Posts
 | 
                    
                      |  Posted - 20 January 2004 :  20:35:30     
 |  
                      | Microsoft VBScript runtime error '800a0035' 
 File not found
 
 /forum/inc_func_advert.asp, line 126
 
 
 
 
 	Set oFSO = Server.CreateObject("Scripting.FileSystemObject")	
	Set oFile = oFSO.OpenTextFile(sFile, 2) 'ForWriting  <-----------126   
	With oFile |  
                      | Edited by - Image on 20 January 2004  20:38:03
 |  
                      |  |  | 
              
                | DavidRhodesSenior Member
 
     
 
                United Kingdom1222 Posts
 | 
                    
                      |  Posted - 21 January 2004 :  04:17:02   
 |  
                      | Did you set the upload path in the config page? |  
                      | The UK MkIVs Forum
 |  
                      |  |  | 
              
                | ImageAverage Member
 
    
 
                Canada574 Posts
 | 
                    
                      |  Posted - 21 January 2004 :  19:00:45     
 |  
                      | Of course  
 I made some modification on your first Mod for my forum.
 But for this one, I don't have time to check it.
 I just made a fast test.
 |  
                      |  |  | 
              
                | johnhappy3Starting Member
 
 
 
                5 Posts | 
                    
                      |  Posted - 02 February 2004 :  14:06:32     
 |  
                      | Installed latest version of the forum three days ago.  Installed Advert Rotator and tested today. After installing the files and making the code changes per the ReadMe file, I started testing the installation. I got to the page where I entered the path to the image, its height, width, and border size and submitted.  The form action wants to go to a file named admin_config_cms.asp. See the following code from the admin_config_advert.asp file: 
 Response.Write	"      <form action=""admin_config_cms.asp"" method=""post"" id=""Form1"" name=""Form1"">" & vbNewLine & _
 
 
 I don't have a file named admin_config_cms.asp.  Does the new forum version rename that file?
 
 Also, when I unzipped the latest version of the Advert Rotator the readme file says there are 10 new files and mentions a file named admin_cms_home.asp.  I did not see a file with that name in the group of files I unzipped.
 
 Where can I get these files?
 |  
                      | John Happy, Spokane, WA
 |  
                      | Edited by - johnhappy3 on 02 February 2004  14:09:35
 |  
                      |  |  | 
              
                
                |  Topic  |  |