Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Star in forum.asp
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

zbenggg
Junior Member

Israel
227 Posts

Posted - 07 January 2003 :  19:52:36  Show Profile
Hello,

I know that I all the time only requests a help and help me wonderful.
I know a chef once is not my help to the no One here in the forums (maybe twice in the little things are uncomplicated)

This much to my regret before I do not know English and you all the announcements I write with the help of software
And also on account of that I do not know
Asp...

What holds me and factor me not to be embarrassed to be helped much it that I know because surf other can be helped in reply that I receive

Then this time I have question maybe a little complex but those who will succeed to help me will thank him very, and I know that my english not something then I am sure that there will be me a great deal of a spelling mistaks

I did that to the all the users will be only one star alongside the name,

Now I want to do that also in the page Forum.asp In the names was represented the star
I am sure that it is very hard and I do not expect the crowd of reactions but if Someone will succeed an I thank him very and to me personal there is a friend that also want to do it (Kipod.net)

Thank you very much

I love Israel

Edited by - zbenggg on 07 January 2003 19:55:13

zbenggg
Junior Member

Israel
227 Posts

Posted - 07 January 2003 :  20:16:28  Show Profile
I to think in Forum.asp line 43:

Select Case strtopicsortfld
	Case "topic"
		strSortCol = "T_SUBJECT" & strSortOrd
	Case "author"
		strSortCol = "M_NAME" & strSortOrd
	Case "replies"
		strSortCol = "T_REPLIES" & strSortOrd
	Case "views"
		strSortCol = "T_VIEW_COUNT" & strSortOrd
	Case "lastpost"
		strSortCol = "T_LAST_POST" & strSortOrd
	Case Else
		strtopicsortfld = "lastpost"
		strSortCol = "T_LAST_POST" & strSortOrd
End Select


Somebody can help me ?

I love Israel
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts

Posted - 09 January 2003 :  04:17:08  Show Profile
Please help me...

I love Israel
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 09 January 2003 :  06:32:20  Show Profile
I can't understand what you are wanting to do. Can you try explaining it again? Also, you might try posting in your own language and maybe someone here can translate it for us.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts

Posted - 09 January 2003 :  08:02:29  Show Profile
Forbidden to talk here in the other languages
It is hard me to explain myself, will tell me what you think that you understood

I love Israel
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 09 January 2003 :  08:14:54  Show Profile  Visit Gremlin's Homepage

Maybe we can make an exception in this case, the language translater your using just doesn't work all that well.


Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts

Posted - 09 January 2003 :  08:28:18  Show Profile
I can write in Hebrew the explanation ?
And later I will request from my father that will formulate me letter in English

I love Israel

Edited by - zbenggg on 09 January 2003 08:28:39
Go to Top of Page

beznas
Starting Member

Morocco
23 Posts

Posted - 09 January 2003 :  13:04:33  Show Profile
Great Idea



Free Palestine!
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts

Posted - 09 January 2003 :  14:27:57  Show Profile
zbenggg do you mean stars under the author name on forum.asp like this


Edited by - Hamlin on 09 January 2003 15:23:56
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts

Posted - 09 January 2003 :  18:01:37  Show Profile
Yes. Thanks.

I love Israel
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts

Posted - 09 January 2003 :  18:06:23  Show Profile
Forum.ASP

In true Blue Peter style here are some instructions I prepared earlier.

Step 1:

Line 37-44 add the code in red.



'## Harpswell, ME 04079
'#################################################################################
%>
<!--#INCLUDE FILE="config.asp"-->  
<!--#INCLUDE FILE="inc_func_member.asp"-->
<%
Dim ArchiveView
Dim HeldFound, UnApprovedFound, UnModeratedPosts, UnModeratedFPosts



Step 2:

Line 236-239 approx add the code in red.



'## Forum_SQL - Get all topics from DB
strSql ="SELECT T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_VIEW_COUNT, T.T_SUBJECT, " 
strSql = strSql & "T.T_AUTHOR, T.T_STICKY, T.T_REPLIES, T.T_UREPLIES, T.T_LAST_POST, T.T_LAST_POST_AUTHOR, "  
strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, M.M_LEVEL, M.M_POSTS "



EDIT - Make sure that you do not miss the , just before M.M_LEVEL it is hard to see in red.

Step 3:

Line 466-466 approx add the code in red.



tM_NAME = 13
tLAST_POST_AUTHOR_NAME = 14
t_MLevel = 15
t_MPost = 16



Step 4:

Line 488-489 approx add the code in red.



Topic_MName = arrTopicData(tM_NAME, iTopic)
Topic_LastPostAuthorName = arrTopicData(tLAST_POST_AUTHOR_NAME, iTopic)
Member_Level = arrTopicData(t_MLevel, iTopic) 
Member_Posts = arrTopicData(t_MPost, iTopic)



Step 5:

Line 537 approx replace the following line




				"                <td bgcolor=""" & strForumCellColor & """ valign=""middle"" align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText"">" & profileLink(chkString(Topic_MName,"display"),Topic_Author) & "</span></font></td>" & vbNewLine & _



with this code




				"                <td bgcolor=""" & strForumCellColor & """ valign=""middle"" align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText"">" & profileLink(chkString(Topic_MName,"display"),Topic_Author) & "</span></font>"
				if Cint(strShowRank) = 2 or Cint(strShowRank) = 3 then Response.Write("<br />" & getStar_Level(Member_Level, Member_Posts) & "")			
		response.write	"		</td>" & vbNewLine & _



Enjoy!

Edited by - Hamlin on 09 January 2003 18:20:11
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts

Posted - 09 January 2003 :  18:35:02  Show Profile
Thank you very much it is wonderful

I love Israel
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07