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
Re: BcStorm Chatlog not working...
Do you get any Mysql errors?
Re: BcStorm Chatlog not working...
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
Re: BcStorm Chatlog not working...
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?
Re: BcStorm Chatlog not working...
Yep, but no rows... Do i need to place it somewere else?
Re: BcStorm Chatlog not working...
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.
Re: BcStorm Chatlog not working...
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
Re: BcStorm Chatlog not working...
I think it has more to do with dbClient.setQuery, because it never actually runs the query, only sets it.
Re: BcStorm Chatlog not working...
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
Re: BcStorm Chatlog not working...
English:
Put dbClient.runQuery(); under your query.
Dutch:
Zet dbClient.runQuery(); onder je query.
Re: BcStorm Chatlog not working...
English:
I did it, but nothing hapened after it, same :/
Dutch:
Heb ik gedaan, maar niks anders gebeurde na het, het zelfde :/
Re: BcStorm Chatlog not working...
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.
Re: BcStorm Chatlog not working...
Well, then I've the same problem, not working query's and I've no idea to make that... Any ideas?
- Jasler
Re: BcStorm Chatlog not working...
Maybe I place it on the wrong place (.cs files)? Where should I place it?
- Jasler
Re: BcStorm Chatlog not working...