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