Changeset 207:09e1aad6ac77

Timestamp:

05/12/2008 07:49:55 PM (4 years ago)

Author:

Dmitry Nezhevenko <dion@…>

Branch:

default

Message:

!word: list of all known words

Location:

src/plugins/word

Files:

• wordlist.cpp (modified) (2 diffs)
• wordlist.h (modified) (1 diff)
• wordplugin.cpp (modified) (2 diffs)

src/plugins/word/wordlist.cpp

@@ -116 +116 @@
                 return 0;
         QSqlQuery query=DataStorage::instance()
-                ->prepareQuery("SELECT COUNT(DISTINCTROW name) FROM words WHERE plugin=? AND storage=?");
+                ->prepareQuery("SELECT COUNT(*) FROM (SELECT name FROM words WHERE plugin=1 AND storage=1 GROUP BY NAME) AS ul");
         query.addBindValue(storage[0]);
         query.addBindValue(storage[1]);
@@ -138 +138 @@
 }
 
+QStringList WordList::getNames(const QList<int>& storage)
+{
+        if (storage.count()!=2)
+                return QStringList();
+        QSqlQuery query=DataStorage::instance()
+                ->prepareQuery("select name from words where plugin=? and storage=? group by name ORDER BY name");
+        query.addBindValue(storage[0]);
+        query.addBindValue(storage[1]);
+        if (!query.exec())
+                return QStringList();
+        QStringList res;
+        while (query.next())
+                res.append(query.value(0).toString());
+        return res;
+}

src/plugins/word/wordlist.h

@@ -17 +17 @@
         int count(const QList<int>& storage);
         bool remove(const QList<int>& storage, const QString& name);
+        QStringList getNames(const QList<int>& storage);
 };
 

src/plugins/word/wordplugin.cpp

@@ -10 +10 @@
         BasePlugin(parent)
 {
-        commands << "ADD" << "COUNT" << "CLEAR" << "SHOW" << "SHOWPRIV" << "SHOWJID" << "DEL";
+        commands << "ADD" << "COUNT" << "NAMES" << "CLEAR" << "SHOW" << "SHOWPRIV" << "SHOWJID" << "DEL";
 }
 
@@ -27 +27 @@
         {
                 reply(s, QString("Currently I know %1 words").arg(words.count(bot()->getStorage(s))));
+                return true;
+        }
+        
+        if (cmd=="NAMES")
+        {
+                QStringList list=words.getNames(bot()->getStorage(s));
+                if (list.isEmpty())
+                        reply(s,"I don't know any words");
+                else
+                        reply(s, QString("I know followed words: %1").arg(list.join(", ")));
                 return true;
         }