rendered paste bodyIndex: 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
{