| Author |
 Topic  |
|
|
laser
Advanced Member
Australia
3859 Posts |
 Posted - 10 July 2004 : 21:00:19
|
I'm sure I've had this code before, but I just can't find it now.
Does anyone have some Snitz code that lists all the IPs a member has ever used ? It uses the IP from the reply table, but does anyone have the code ? (just saves me some time rewriting it  ) |
|
|
Chuck McB
Junior Member
WooYay
196 Posts |
Posted - 15 July 2004 : 10:04:11
|
Something like this?
Search by IP (partial and exact) or member name, lists all topics/replies matching as well. |
Edited by - Chuck McB on 15 July 2004 10:04:28 |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 July 2004 : 03:40:38
|
Thanks  I've been offline for a few days because of a HDD failure, but I'll check it out soon(ish) |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 02 August 2004 : 06:29:31
|
argh!! ... i thought I posted this error. I tested out the page, but got this error :
quote:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/snitz3403/admin_search_ip2.asp, line 277
Line 277 is the typical :
set rs = my_Conn.Execute (strSql)
The strsql variable contains :
SELECT FORUM_TOPICS.T_IP, FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_MESSAGE, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_AUTHOR FROM FORUM_TOPICS WHERE FORUM_TOPICS.T_AUTHOR = '1173' ORDER BY T_IP
Any tips ?? I'm working on this now. |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 02 August 2004 : 06:46:13
|
| Got it the odd ' and font color definition out of place, but it's working great now |
|
|
| |
Topic |
|
Topic Locked
