[Arianne-bugs] [ arianne-Bugs-2896877 ] [Stendhal] Gag-status stored as quest

[SourceForge.net <no...@so...>]

Bugs item #2896877, was opened at 2009-11-12 22:15
Message generated for change (Comment added) made by nhnb
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101111&aid=2896877&group_id=1111

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Katie (kymara)
Assigned to: Nobody/Anonymous (nobody)
>Summary: [Stendhal] Gag-status stored as quest

Initial Comment:
The gag event is logged to have event being quest and param1 is gag
+--------+---------------------+------------+-------+--------+----------------+
| id     | timedate            | source     | event | param1 | param2         |
+--------+---------------------+------------+-------+--------+----------------+
|  29987 | 2009-08-17 20:44:05 | XXX   | quest | gag    | 1250534945642  |

with no record of the admin, as source is the player who was gagged. it should be that source is the admin, the event is gag and param1 is the player


----------------------------------------------------------------------

>Comment By: Hendrik Brummermann (nhnb)
Date: 2009-11-28 09:26

Message:
So the logging is okay, as explained by kymara. The gag status is stored as
a quest which is a bit 	weird.

----------------------------------------------------------------------

Comment By: Katie (kymara)
Date: 2009-11-25 21:14

Message:
Oh it actually logs it twice!


mysql> select * from gameEvents where event='gag' limit 1;
+-------+---------------------+------------+-------+--------+---------------------+
| id    | timedate            | source     | event | param1 | param2      
       |
+-------+---------------------+------------+-------+--------+---------------------+
| 29986 | 2009-08-17 20:44:05 | madmetzger | gag   | xxx | 5 spamming in
bank  |
+-------+---------------------+------------+-------+--------+---------------------+
1 row in set (0.01 sec)

mysql> select * from gameEvents where param1='gag' limit 1;
+-------+---------------------+--------+-------+--------+----------------+
| id    | timedate            | source | event | param1 | param2        
|
+-------+---------------------+--------+-------+--------+----------------+
| 29987 | 2009-08-17 20:44:05 | xxx | quest | gag    | 1250534945642  |
+-------+---------------------+--------+-------+--------+----------------+
1 row in set (0.28 sec)


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101111&aid=2896877&group_id=1111