The IPtoCountry mod creates a new variable "strLocale" which holds the name of the country someone connects from.
This will not affect the flag mod you're using unless you choose to display the flag of the users' real location in "topic.asp" (instead of the one they reported when they registered). To do so, there is one change to "inc_locale.asp":
"inc_locale.asp"
Look for the following line (appx 40):
Set rsLocale = Nothing
Below that, insert these:
If MemberID>0 Then
strSql="UPDATE " & strMemberTablePrefix & "MEMBERS SET M_COUNTRY='" & strLocale & "' WHERE MEMBER_ID=" & MEMBERID
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
End If
<%
strSql="SELECT IPSTART, IPEND, IPCOUNTRY FROM " & strTablePrefix & "IPTOCOUNTRY WHERE IPSTART <= '" & Request.ServerVariables("Remote_Addr") & "' AND IPEND >= '" & Request.ServerVariables("Remote_Addr") & "'"
Set rsLocale= my_Conn.Execute(strSql)
If NOT (rsLocale.BOF or rsLocale.EOF) Then
strLocale=rsLocale("IPCOUNTRY")
rsLocale.Close
End If
Set rsLocale = Nothing
%>
Cordially, Maxime
Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)
Posted - 10 January 2014 : 04:21:09
