| Author |  Topic  | 
              
                | rick7165Senior Member
 
     
 
                USA1094 Posts
 | 
                    
                      |  Posted - 15 May 2001 :  21:03:30     
 |  
                      | Submit New Link Email This will send you a Email when someone submits a URL.
 
 In links_add_url.asp on line 77 you will see this:
 my_Conn.Execute (strSQL)
 %>
 
 add this between 	my_Conn.Execute (strSQL) and %>
 
 my_Conn.Execute (strSQL)
 Body = "A new link has arrived for you to approve."
 Body = Body & vbCrLf & "go to http://www.yourdomain.com/forums/admin_links_main.asp to approve."
 
 Set Mailer = Server.CreateObject("CDONTS.NewMail")
 Mailer.To = "links@yourdomain.com"
 Mailer.From = "links@yourdomain.com"
 Mailer.Subject = "New link to approve"
 Mailer.Body = Body
 
 Mailer.Send
 Set Mailer = nothing
 %>
 
 Test Site
 www.eastpasco.com
 HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
 
 Edited by - rick7165 on 15 May 2001  21:06:43
 |  
                      |  |  | 
              
                | ahimanikyaStarting Member
 
 
 
                22 Posts | 
                    
                      |  Posted - 16 May 2001 :  12:49:46   
 |  
                      | quote:
 well, there is something like a slash mod add-on thing for links manager that i wrote but it works differently than what you're suggesting.  It actually displays the whole categories and subcategories alogn with the links_menu.  Kinda like how many site have it.
 
 
 
 check out : http://63.219.181.102/forum/link.asp?TOPIC_ID=9629
 
 This will allow you to put the link manager even in other web site, in case you want to share the same link manager for both site. This script sends back a javascript output to the browser.
 
 Thanks
 Ahimanikya
 |  
                      |  |  | 
              
                | philbozeStarting Member
 
 
 
                12 Posts | 
                    
                      |  Posted - 17 May 2001 :  11:46:03   
 |  
                      | Cool MOD, but I can't get it to work....I'm getting a bunch of error messages.  I've copied two of them below... -------------------
 Creating table(s)...
 CREATE TABLE LINKS_CATEGORIES( CAT_ID COUNTER CONSTRAINT Primary , CAT_NAME text (100) NULL )
 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
 
 --------------------------------------------------------------------------------
 
 Creating table(s)...
 CREATE TABLE LINKS_SUBCATEGORIES( SUBCAT_ID COUNTER CONSTRAINT Primary , SUBCAT_NAME text (100) NULL , CAT_ID int NULL )
 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
 
 --------------------------------------------------------------------------------
 
 
 I'm using Acess 97....any ideas?
 
 
 |  
                      |  |  | 
              
                | dethfireStarting Member
 
 
 
                20 Posts | 
                    
                      |  Posted - 03 June 2001 :  16:46:31   
 |  
                      | same here, my db_setup.asp   didn't work at all 
 
 
 Edited by - dethfire on 03 June 2001  16:51:03
 |  
                      |  |  | 
              
                | sevenSenior Member
 
     
 
                USA1037 Posts
 | 
                    
                      |  Posted - 04 June 2001 :  00:55:01     
 |  
                      | I changed this mod slightly. If anyone is interested in what I did, I'll post the code. 
 Added an "enabled or disabled" radio button to set the sub-category status. This will make some sub-categories not able to be posted to by normal users.
 I did this so I can add index pages for my site that can also be searched.
 Administrators will still be able to post in any sub-category.
 |  
                      |  |  | 
              
                | AznknightSenior Member
 
     
 
                USA1373 Posts
 | 
                    
                      |  Posted - 04 June 2001 :  14:19:44   
 |  
                      | quote:
 same here, my db_setup.asp   didn't work at all
 
 
 
 Edited by - dethfire on 03 June 2001  16:51:03
 
 
 
 if you're using access 97 db, use the access 2000 connection string.  the access 97 connection string doesn't like some of the statements in the db setup.
 
 - Alan
 www.iamviet.com
 www.calvsa.net
 Snitz Resource
 |  
                      |  |  | 
              
                | Rob PorettiJunior Member
 
   
 
                Canada435 Posts
 | 
                    
                      |  Posted - 06 June 2001 :  06:36:08     
 |  
                      | quote:
 <SNIP>...
 
 I think the people using this will like the new features.  I've been working pretty hard on this mod.
  
 
 
 - Alan
 www.iamviet.com
 www.calvsa.net
 Snitz Resource
 
 
 
 Hey Alan,
 
 Thanks for the version 2 update -- your hard work really shows!
 
 Cheers!
 
 
 
 Rob Poretti
  Sascom Marketing Group ~ Toronto
 vox.905.825.5373        fax.905.825.5960
 |  
                      |  |  | 
              
                | Freeman IIJunior Member
 
   
 
                232 Posts | 
                    
                      |  Posted - 06 June 2001 :  20:43:17   
 |  
                      | i noticed links_popular.asp if 2 or more links have the same number of hits it will display all of them not only the top 10 
 
 |  
                      |  |  | 
              
                | AznknightSenior Member
 
     
 
                USA1373 Posts
 | 
                    
                      |  Posted - 06 June 2001 :  22:24:09   
 |  
                      | quote:
 i noticed links_popular.asp if 2 or more links have the same number of hits it will display all of them not only the top 10
 
 
 
 i don't get what you mean?
 
 if two links have same number of hits then the code will display whichever one it find first, first.  but it'll will only display top 10 because of the TOP keyword in the strSQL.
 
 
 a different problem i noticed is with links_toprated.asp.  if two sites have both ratings of 10 and one site have 5 votes and the other has 4 it'll display the one with 4 votes first....don't know why.  looks like it should display the one with 5 votes first because this is what the sql string looks like for the order by part:
 "ORDER BY ROUND(RATING/VOTES, 0) DESC, VOTES DESC"
 
 
 
 - Alan
 www.iamviet.com
 www.calvsa.net
 Snitz Resource
 |  
                      |  |  | 
              
                | wspaakStarting Member
 
 
 
                10 Posts | 
                    
                      |  Posted - 08 June 2001 :  10:28:41   
 |  
                      | Alan, Great job!! 
 But, My zip doesn't contain the links_readme.txt (I don't know why, but it definatly doesn't.)
 
 Could you please mail it to me? wspaak@hotmail.com
 
 
 |  
                      |  |  | 
              
                | ZER0C00LStarting Member
 
 
 
                1 Posts | 
                    
                      |  Posted - 09 June 2001 :  06:23:40   
 |  
                      | Eheueh 
 
 |  
                      |  |  | 
              
                | wspaakStarting Member
 
 
 
                10 Posts | 
                    
                      |  Posted - 09 June 2001 :  06:32:45   
 |  
                      | That really sucks!!!    
 
 |  
                      |  |  | 
              
                | Freeman IIJunior Member
 
   
 
                232 Posts | 
                    
                      |  Posted - 09 June 2001 :  20:14:30   
 |  
                      | Alan 
 on links_goto.asp i think you forgot to close the connection
 
 don;t you have to put <!-- #INCLUDE FILE="inc_footer_short.asp" --> ?
 
 
 |  
                      |  |  | 
              
                | pvspadeStarting Member
 
 
 
                5 Posts | 
                    
                      |  Posted - 16 June 2001 :  21:37:58   
 |  
                      | Hey Aznknight, this is a super mod! 
 I did notice a curious thing. When I go to the "Links Manager" from my main Forums page, and then click on a category and subcategory, I see a display that seems to be arranged in the order in which items were entered. But when I log-on as the Admin and go to the Admin Options page, click on Links Manager and then Browse Links, I see a display of entries arranged alphabetically by title, not in the order in which items were originally entered!
 
 Is there any quick and easy way to make the alphabetical ordering the default, so that users see things alphabetically when they click on Links Manager, then Category and SubCagtegory?
 
 Thanks again for a great mod!
 
 
 
 Edited by - pvspade on 16 June 2001  21:39:52
 |  
                      |  |  | 
              
                | SalmanKhanaAverage Member
 
    
 
                USA961 Posts
 | 
                    
                      |  Posted - 17 June 2001 :  03:45:18   
 |  
                      | looks great in the demo .. thanx azk!! 
 but hey i wonder whaz the difference between link manager and classifieds !! ??
 
 once again.. good job Aznknight !!
  
 
 |  
                      |  |  | 
              
                
                |  Topic  |  |