[pepe_thugs]

Hello guys
It is possible to check two tables in the database with the same query?
If so can you help me?

PHP Code:

FormatEx(Query, sizeof(Query), "SELECT bid FROM %s_bans AND sb_bansdisconect WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL", DatabasePrefix, auth[8], ip); 


EDIT:

This should Work?

PHP Code:

FormatEx(Query, sizeof(Query), "SELECT bid FROM %s_bans WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL UNION SELECT bid FROM %s_bansdisconect WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL", DatabasePrefix, auth[8], ip, DatabasePrefix, auth[8], ip); 


[Neuro Toxin]

http://dev.mysql.com/doc/refman/5.7/en/join.html

[pepe_thugs]

Originally Posted by Neuro Toxin http://dev.mysql.com/doc/refman/5.7/en/join.html

I will realized?
It's simple just do this:

PHP Code:

FormatEx(Query, sizeof(Query), "SELECT bid FROM %s_bans, sb_bansdisconect WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL", DatabasePrefix, auth[8], ip); 


The tables are completely equal with the same structure.
I just wanted to separate some bans to not appear in the same database.
I'll now create different commands to ban for both database and separate these bans.

[pepe_thugs]

Please someone can help please?
Sorry for bump

[ThatOneGuy]

Neuro toxin already explained what you need. Use SQL join to join two tables on an identifier in a select statement. Here is a diagram to help you pick the correct kind of join: http://www.codeproject.com/KB/databa...JOINS_orig.jpg

If the columns are the exact same, you will need to include which tbl it is from when you specify a column. e.g.
sb_bansdisconect.authid

[pepe_thugs]

Originally Posted by ThatOneGuy Neuro toxin already explained what you need. Use SQL join to join two tables on an identifier in a select statement. Here is a diagram to help you pick the correct kind of join: http://www.codeproject.com/KB/databa...JOINS_orig.jpg If the columns are the exact same, you will need to include which tbl it is from when you specify a column. e.g. sb_bansdisconect.authid

Like This:

PHP Code:

FormatEx(Query, sizeof(Query), "SELECT bid FROM sb_bans AS bans INNER JOIN sb_bansdisconect AS bansdisc ON bansdisc.authid = bans.authid WHERE ((bans.type = 0 AND bans.authid REGEXP '^STEAM_[0-9]:%s$' AND bansdisc.type = 0 AND bansdisc.authid REGEXP '^STEAM_[0-9]:%s$') OR (bans.type = 1 AND bans.ip = '%s' AND bansdisc.type = 1 AND bansdisc.ip = '%s')) AND (bans.length = '0' OR bans.ends > UNIX_TIMESTAMP() AND bansdisc.length = '0' OR bansdisc.ends > UNIX_TIMESTAMP()) AND bans.RemoveType IS NULL AND bansdisc.RemoveType IS NULL", auth[8], auth[8], ip, ip) 


This should Work?

[ThatOneGuy]

Look ok...try running the query first in your phpmyadmin, but it looks right (be sure to replace the SM formatting with some values in the database for testing). Also, if the DBs are near identical, any field that are going to contain the same value in both only need to be checked in one of them. e.g. the join is on authid, therefor just check once and no need to check both.

[pepe_thugs]

Originally Posted by ThatOneGuy Look ok...try running the query first in your phpmyadmin, but it looks right (be sure to replace the SM formatting with some values in the database for testing). Also, if the DBs are near identical, any field that are going to contain the same value in both only need to be checked in one of them. e.g. the join is on authid, therefor just check once and no need to check both.

I try to run this in phpmyadmin :

PHP Code:

SELECT * FROM sb_bans AS bans INNER JOIN sb_bansdisconect AS bansdisc ON bansdisc.authid = bans.authid WHERE ((bans.type = 0 AND bans.authid = 'STEAM_1:1:xxxxx' AND bansdisc.type = 0 AND bansdisc.authid = 'STEAM_1:1:xxxxx' ) OR (bans.type = 1 AND bans.ip = '%s' AND bansdisc.type = 1 AND bansdisc.ip = '%s')) AND (bans.length = '0' OR bans.ends > UNIX_TIMESTAMP() AND bansdisc.length = '0' OR bansdisc.ends > UNIX_TIMESTAMP()) AND bans.RemoveType IS NULL AND bansdisc.RemoveType IS NULL 


I insert one steam id I have in the database and did not return me any value says that there is none.

[DarkDeviL]

Originally Posted by pepe_thugs I insert one steam id I have in the database and did not return me any value says that there is none.

Well, you could try elaborating on what exactly you are trying to do, and what you expect the results to be.

1. Provide us a full table structure of both SQL tables you are selecting from.

2. Provide the names of fields from each of them that you want to receive.

3. Provide a example data set of how things looks in both tables.

4. What do you want to do when table A has items, but table B doesn't? (or the other way around)?

.. etc etc. The more details you give about what you are trying to do / what you expect, the better others outside can help you.

As you don't really provide any details except saying you want to check two tables at once; you are most likely to get completely ignored. "Can you help me?"-like questions doesn't get you help. Details about the problem does!

[pepe_thugs]

I'm trying to change the query's SourceBans to check two tables.
The original query is this:

PHP Code:

FormatEx(Query, sizeof(Query), "SELECT bid FROM %s_bans  WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL", DatabasePrefix, auth[8], ip) 


Now I created another database to separate some bans the databases have the same structure (structure attached).

Now I wanted to create a query that checks first if there was any record in the database "sb_bans" and if not, check the database "sb_bansdisconect"
And I do not know if I can do everything in the same query.
I'll attach the plugin edited but that did not work I created a command to separate the bans for another database (line 174).
The command worked well, but did not work the query to see if the player is banned.