MySql Retrieve

Beffic

Ok so my check system uses mysql/php.... duh! But for some reason I can't keep the guild messages private. And it broadcast it like a normal message just in style. I believe it's the mysql_query and now I am brining it to you guys for help =)

So is there something I am doing wrong because my private messages are not broadcasting...

mysql_query("select * from chat where owner='0' || owner='$User[ID]' || guild='$User[Guild]' order by id desc limit 20") or die("Could not get user stats");

laserlight

You probably intend the condition to be: WHERE (owner='0' OR owner='$User[ID]') AND guild='$User[Guild]'

Beffic

So how would this be written out because it doesn't makes sense to put AND and OR statements in there...?

laserlight

So how would this be written out because it doesn't makes sense to put AND and OR statements in there...?

What do you mean?

Beffic

In a mysql statement like mysql_query();

laserlight

In a mysql statement like mysql_query();

AND and OR are standard SQL keywords. The query should be:

$result = mysql_query("SELECT * FROM chat
    WHERE (owner='0' OR owner='$User[ID]') AND guild='$User[Guild]'
    ORDER BY id DESC LIMIT 20")
    or die("Could not get user stats");

Beffic

It's still broadcasting the Guild chat to everyone. Even if they are not in the guild.

laserlight

It's still broadcasting the Guild chat to everyone. Even if they are not in the guild.

That implies that something else is wrong, or perhaps everything is correct but your interpretation of it is incorrect. For example, are you sure that not everyone belongs to the same guild?

Beffic

I made a new character not in the guild and I was still able to see what people were writing...

laserlight

I made a new character not in the guild and I was still able to see what people were writing...

hmm... that does not make sense. I suggest that you come up with the smallest and simplest script that demonstrates the problem. As far as I can tell, your SQL query is being ignored, so perhaps you have some junk code that is being executed.

Beffic

If you would like you can check out the problem your self at www.erylith.com But I can do for demonstrating because I don't understand how I can explain it any better.

laserlight

If you would like you can check out the problem your self at www.erylith.com But I can do for demonstrating because I don't understand how I can explain it any better.

The problem lies with your server side code, so unless that is an invitation to break into your server, that will not help. This is why I say that you should come up with the smallest and simplest script that demonstrates the problem. The information that you are giving now simply is not enough. Besides, while coming up with that example script, you may just discover and fix the problem yourself.