BcStorm Chatlog not working...

[jasler]

Hello,

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

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

[MentaL]

[Gaby]

Do you get any Mysql errors?

[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

[Gaby]

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?

[jasler]

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

[Gaby]

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

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

[jasler]

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

[Gaby]

I think it has more to do with

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

[jasler]

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

[Gaby]

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

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

[jasler]

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

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

[Clawed]

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.

[jasler]

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

- Jasler

[jasler]

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

- Jasler

[jasler]

Nobody?