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)
 Gold/Reputation Points i Got Somthing...
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 11 June 2003 :  15:19:05  Show Profile  Visit MaD2ko0l's Homepage
Hi all,
i have got a mod where u have/can get gold and reputation points and stuff liek that but i need someone to convert some code to work with the current version (3.4.03)...it is a bank sort of thing where u can give ur gold to people. here is the code.



<%
CurPageInfoChk = "1"
function CurPageInfo ()
	PageName = "Wire Transfer"
	PageAction = "Viewing<br>" 
	CurPageInfo = PageAction & PageName
end function
%>
<!--#INCLUDE FILE="config.asp" --> 
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<% if not strDBNTUserName = "" then%>
<%
mwpThemeTitle= "Wire Transfer"
mwpThemeBlock_open()%>

        <tr>
          <td valign="top" align="center" width="75%" bgcolor="<%=strForumCellColor%>">
                  <%
	strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_TITLE, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_LEVEL, " 
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_GOLD, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_REP, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_RTOTAL, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_PAGE_VIEWS, "
	strSql = strSql & strMemberTablePrefix & "MEMBERS.M_AVATAR_URL "	
	strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
	strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & getMemberNumber(STRdbntUserName)
	set rs = my_Conn.Execute (strSql)
                  %>
            <table border="1" cellpadding="0" cellspacing="0" width="95%" style="border-collapse: collapse" bordercolor="<% =strHeadCellColor %>">
              <tr>
                <td width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>" color="<% =strDefaultFontColor %>"><b>Your
                  current Gold: </b><% =rs("M_GOLD")%></font></td>
              </tr>
            </table>
            <br>
            <form name="bank" action="bank1.asp" method="POST">
              <p align="center">Transfer : <input type="value" name="gold" size="20"> 
              gold(s)  to   <input name="member" size="14">   <input type="Submit" value="Transfer" </form>               </p>
            </form>
            <script language="JavaScript">
<!-- hide from JavaScript-challenged browsers
function pmmembers() { var MainWindow = window.open ("pop_memberlist.asp?pageMode=pm", "","toolbar=no,location=no,menubar=no,scrollbars=yes,width=300,height=500,top=100,left=100,status=no");
}
// done hiding -->
</script><a href="JavaScript:pmmembers();">Memberlist</a>
      
   
<%mwpThemeBlock_close()%>
 <% else%> 
    <%response.write "You need to sign in to view/use this page. Else register for free."%>
    <%end if %>
<!--#INCLUDE FILE="inc_footer.asp" -->


is there any chnace that some one can get this to work.

i get errors trying to the the member id

strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & getMemberNumber(STRdbntUserName)

that line is most of the error.

thankx

MaD2ko0l

© 1999-2010 MaD2ko0l

serritzlev
Junior Member

Denmark
291 Posts

Posted - 11 June 2003 :  15:27:08  Show Profile  Visit serritzlev's Homepage
Try on MaxWebPortal this is an mpw mod to v1.30 http://www.maxwebportal.com/

Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 11 June 2003 :  16:13:08  Show Profile  Visit MaD2ko0l's Homepage
i know but they wont be fimilar with the 3.4.03 code because they still run an older version of the base snitz forums i think they r using 3.3.03.

© 1999-2010 MaD2ko0l
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 11 June 2003 :  16:58:49  Show Profile  Visit Ez4arab's Homepage
I think this code is part of maxwebportal. I am working now on this mod when member read topic i will increas 1 gold per topic read. because i don't have portal i put this Gold when member read or post topic.
to let the number to gold increas use this function in file inc_func_member.asp


sub DoRepAdd(sUser_Name)

	'## Forum_SQL - Update Total Reputation for user ADD
	strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
	strSql = strSql & " SET " & strMemberTablePrefix & "MEMBERS.M_REP = " & strMemberTablePrefix & "MEMBERS.M_REP + 1 "
	strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & sUser_Name & "'"
'
	my_Conn.Execute (strSql)

end sub


after that put this code in the post_info.asp

	DoRepAdd Request.Form("UserName") '++++++++

this code is coming after
DoULastPost Request.Form("UserName")



Ez4arab web site Ez4arab |
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 11 June 2003 :  17:47:59  Show Profile  Visit MaD2ko0l's Homepage

reward = "2"
reward = cint(reward)
		if not strDBNTUserName = "" then
			strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
			strSql = strSql & " SET M_GOLD = M_GOLD + " & reward
			strSql = strSql & " WHERE MEMBER_ID=" & getMemberID(strDBNTUserName)
			my_Conn.Execute (strSql)
		end if	


i use this code for my pages

© 1999-2010 MaD2ko0l
Go to Top of Page

jeffery
Junior Member

USA
176 Posts

Posted - 30 June 2003 :  15:18:00  Show Profile
Ez4arab
Any code ready to try for this?

www.thomasforum.com
Go to Top of Page

jeffery
Junior Member

USA
176 Posts

Posted - 07 July 2003 :  23:50:36  Show Profile
** bump **

www.thomasforum.com
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.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07