All pastes #513252 Raw Edit

Mine

public text v1 · immutable
#513252 ·published 2007-05-27 05:46 UTC
rendered paste body
Index: game/RecallCommands.cpp
===================================================================
--- game/RecallCommands.cpp	(revision 72)
+++ game/RecallCommands.cpp	(working copy)
@@ -19,7 +19,7 @@
 	if(!*args)
 		return false;
 
-	QueryResult *result = sDatabase.Query( "SELECT * FROM recall" );
+	QueryResult *result = sDatabase.Query( "SELECT * FROM recall WHERE locname LIKE '%s'", args );
 
 	do
 	{
@@ -48,7 +48,7 @@
 	if(!*args)
 		return false;
 	
-	QueryResult *result = sDatabase.Query( "SELECT locname FROM recall" );
+	QueryResult *result = sDatabase.Query( "SELECT locname FROM recall WHERE locname LIKE '%s'", args );
 	do
 	{
 		Field *fields = result->Fetch();
@@ -89,7 +89,7 @@
 	   if(!*args)
 		return false;
 
-	QueryResult *result = sDatabase.Query( "SELECT id,locname FROM recall" );
+	QueryResult *result = sDatabase.Query( "SELECT id,locname FROM recall WHERE locname LIKE '%s'", args );
 
 	do
 	{
@@ -153,7 +153,7 @@
 	Player * plr = objmgr.GetPlayer(player, false);
 	if(!plr) return false;
 
-	QueryResult *result = sDatabase.Query( "SELECT * FROM recall" );
+	QueryResult *result = sDatabase.Query( "SELECT * FROM recall  WHERE locname LIKE '%s'", args  );
 
 	do
 	{