BcStorm Chatlog not working...

Hello,

I use BcStorm (Fixed by Leon), but I want chatlog on it... I tried with a own script in some "chat" .cs files:

Code:

---

using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
            {
                dbClient.setQuery("INSERT INTO chatlogs (user_id,room_id,hour,minute,timestamp,message,user_name,full_date) VALUES ('" + userID + "','" + roomID + "','" + DateTime.Now.Hour + "','" + DateTime.Now.Minute + "','1273133831.41423','" + message + "','" + username + "','" + DateTime.Now.ToLongDateString() + "')");
            }

---

But it didn't work...

A lot people are searching for this problem, but nobody has it (Or post it). Maybe is it too good for them?

Any ideas to make this for BcStorm?

- Jasler

Do you get any Mysql errors?

I'm not a server developer, so I don't know... I just did something, for try only... And I don't know where to place it... Because there are some chat .cs'ses, like "chatcommander.cs", "ChatMessage.cs" etc.
- Jasler

Quote:

---

Originally Posted by jasler

I'm not a server developer, so I don't know... I just did something, for try only... And I don't know where to place it... Because there are some chat .cs'ses, like "chatcommander.cs", "ChatMessage.cs" etc.
- Jasler

---

Did you even debug your emu then?

Yep, but no rows... Do i need to place it somewere else?

Quote:

---

Originally Posted by jasler

Yep, but no rows... Do i need to place it somewere else?

---

Well.. you should view your error logs before you try something else.

Ow, okay, I'll check the error logs... But there are no results in the database, maybe I didn't placed it in the right place?...

- Jasler

I think it has more to do with

dbClient.setQuery, because it never actually runs the query, only sets it.

Oww... So, any idea wich query I need to use?

EDIT:
There were no errors in logs with "chatlogs"

Hmm... dbClient.runFastQuery(""); works too not, and dbClient.ExecuteQuery(""); even... Any idea? It will be nice if the chatlog finaly works, and other researchers also what to do :)

Ik zag dat je nederlands was, dus:
Hmm... dbClient.runFastQuery(""); werkt ook niet en dbClient.ExecuteQuery(""); hetzelfde... Enig idee? Zou leuk zijn als chatlog eindelijk werkt, en andere zoekers er ook wat aan hebben :)

- Jasler

English:
Put dbClient.runQuery(); under your query.

Dutch:
Zet dbClient.runQuery(); onder je query.

English:
I did it, but nothing hapened after it, same :/

Dutch:
Heb ik gedaan, maar niks anders gebeurde na het, het zelfde :/

Doing an insert query everytime someone chats something will give you an awful lagg.
You need to store about 100/150 messages then, insert them once it's gets to the amount of messages stored and empty stored messages.

Well, then I've the same problem, not working query's and I've no idea to make that... Any ideas?

- Jasler

Maybe I place it on the wrong place (.cs files)? Where should I place it?

- Jasler

Nobody?