help redux source

[adarelk2]

hey guys
i try write a new command and i need to Select data
from my table
how can i do this?
i mean
SELECT *FROM Character where online=1
and i'll get all rows where online=1(with client.SendMessage)

[Spirited]

I know my honesty isn't always welcome here, but you should either figure this out on your own by using "Ctrl + F" and finding examples in your source, or giving up completely. Because this post scares me. People who can't help themselves with the simplest of problems like this have no chance in the world on hosting a private server (which poses a lot more difficult problems - such as Redux's monster AI). Other servers can always use support...

[adarelk2]

Originally Posted by Spirited

I know my honesty isn't always welcome here, but you should either figure this out on your own by using "Ctrl + F" and finding examples in your source, or giving up completely. Because this post scares me. People who can't help themselves with the simplest of problems like this have no chance in the world on hosting a private server (which poses a lot more difficult problems - such as Redux's monster AI). Other servers can always use support...

bro i'm not idiot... i tried finding examples in my source and i told you i didn't find it... i didn't see any line with "SELECT " query, It's very strange
can you help me and tell me one file with SELECT query?

[Spirited]

Originally Posted by adarelk2

bro i'm not idiot... i tried finding examples in my source and i told you i didn't find it... i didn't see any line with "SELECT " query, It's very strange
can you help me and tell me one file with SELECT query?

You're not going to find that... It uses NHibernate. You need to either look for examples of other things happening or follow the code. You can't just search for one keyword and then give up. Learning how to read, cross reference, and search through code is important. It's an essential skill... Something you really shouldn't be asking a board for. It's like asking use how to read as an author.

[zakkwilde_17]

I suggest you use another source, do not waste time with this ... It is a very stable source, but the public version has many problems and can be a good time wasted ...

The function to know whether or not the player is online is this one. Search the source for examples

        public static Player GetUser(string name)
        {
            if (string.IsNullOrEmpty(name)) return null;
            name = name.ToLower();
            return Players.Values.FirstOrDefault(user => user.Character.Name.ToLower() == name);
        }

If it returns null, is because it is not online ... '-'

[puzzleop]

You do not access the database directly from the command class in Redux. Import the data that you want to check using NHIbernate(see how they imported Stats,Level,CP,Money etc) and just check it in the code afterwards. If you want to check players online the code in redux would be:

foreach(var player in Managers.PlayerManager.Players.Values)
{
client.SendMessage(player.Name, ChatType.Talk2);
}