(Link to AcmlmWiki) Offline: thank ||bass
Register | Login
Views: 13,040,846
 Main | Memberlist | Active users | Calendar | Chat | Online users
Ranks | FAQ | ACS | Stats | Color Chart | Search | Photo album 		05-18-24 02:31 AM
0 users currently in Programming.
Acmlm's Board - I3 Archive - Programming - blargh (PHP) New poll | | Thread closed
Add to favorites | Next newer thread | Next older thread
User Post
Xkeeper
Took the board down in a blaze of glory, only to reveal how truly moronical ||bass is.


 





Since: 11-17-05
From: Henderson, Nevada

Last post: 6298 days
Last view: 6298 days
Skype
Posted on 07-15-06 02:55 PM Link 
case "ipsearch":
$ret	= mysql_query("SELECT `name`, `lastip` FROM `users` WHERE `lastip` LIKE '$data[1]%'");
if ($e	= mysql_error()) echo $e;
	else {
		echo k(9) ."100 ok, sending list\r\n";
		$txt	= "";
		while($d	= mysql_fetch_array($ret)) {
			$txt	.= k(8) . $d['name'] . k(7) ." (". $d['lastip'] .")   ";
		}
	}
	if (!$txt) $txt = k(4)."299 no data". k(5)." - no matches to send";
	echo "$txt\r\n";
break;


For some reason, this fails to work properly -- giving it an IP that has 5 matches returns 2 and seems to die on a name with spaces

however, interestingly, the query works fine in PMA and returns all 5 results
this makes no sense as it seems as if $d['name'] has no spaces and only 2 results even without the fancy formatting

(edited by Xkeeper on 07-15-06 01:56 PM)
Xkeeper
Took the board down in a blaze of glory, only to reveal how truly moronical ||bass is.


 





Since: 11-17-05
From: Henderson, Nevada

Last post: 6298 days
Last view: 6298 days
Skype
Posted on 07-15-06 03:11 PM Link
nevermind, I'm a fucking moron
Add to favorites | Next newer thread | Next older thread
Acmlm's Board - I3 Archive - Programming - blargh (PHP) | Thread closed


ABII

Acmlmboard 1.92.999, 9/17/2006
©2000-2006 Acmlm, Emuz, Blades, Xkeeper

Page rendered in 0.004 seconds; used 355.27 kB (max 415.16 kB)