[ThatOneGuy]

As far as your results, you still have %s for IPs in the query. Additionally, as explained above, parts of your query are redundant (namely checking authid's in both tables, since the resulting table of the join is based on authid, thus all authid's match). To add to that, what is expected of data? Will the steam ID always be in one, but not the other, can both have IDs that are not in the other? Will they have the same IDs? What columns will always be the same (this question will help us cut redundancy out of the query)? Important columns are those in the query: Will 'type' and the clients IP always be the same between the two DBs?

INNER JOIN: Only return rows where the ID is in BOTH
LEFT JOIN: The ID must be in the first DB, and if found in 2nd, the info is appended to it.
FULL OUTER JOIN: Returns all rows, regardless of where or not it is in the other DB.

I'm guessing you want LEFT JOIN, since I'd guess that SB tbl has all bans, and some of those also appear in bandisconnected. As a start, run the join query in phpmyadmin with no WHERE statements to see what it returns.

Potentially what you're looking for, although I'd guess you need to change several AND operators to OR operators in your WHERE statement to get what you want, but you havent said much about your data and tables to this point:

Spoiler

SELECT A.bid
FROM sb_bans AS A
LEFT JOIN sb_bansdisconect AS B
ON B.authid = A.authid
WHERE ((A.type = 0 AND A.authid REGEXP '^STEAM_[0-9]:%s$' AND B.type = 0) OR (A.type = 1 AND A.ip = '%s' AND B.type = 1 AND B.ip = '%s'))
	AND ((A.length = '0' OR A.ends > UNIX_TIMESTAMP()) AND (B.length = '0' OR B.ends > UNIX_TIMESTAMP()))
	AND (A.RemoveType IS NULL)
	AND (B.RemoveType IS NULL)

[pepe_thugs]

Thank you for all the attention and help.
I run the query but does not return me any value.
Only returns me value if it is the same "authid" in both tables.
I tried this:

Spoiler

SELECT A.bid
FROM sb_bans AS A
LEFT JOIN sb_bansdisconect AS B
ON B.authid = A.authid
WHERE ((A.type = 0 AND A.authid = 'STEAM_0:0:123456' AND B.type = 0) OR (A.type = 1 AND A.ip = '%s' AND B.type = 1 AND B.ip = '%s'))
AND ((A.length = '0' OR A.ends > UNIX_TIMESTAMP()) AND (B.length = '0' OR B.ends > UNIX_TIMESTAMP()))
AND (A.RemoveType IS NULL)
AND (B.RemoveType IS NULL)

This authid initially had only one of the database and not returned me no value.
Then I added the same authid in another database and has returned me a value.

I did some tests in the plugin and added another query and it looks like it worked but do not know if it will work forever.
You can see me the way I did is reliable?

[ThatOneGuy]

If you want them banned via either DB, then that is fine, although it will double you client connection queries. I would still work on getting your query right. That will work though, and will block the client if theyre banned via either DB.

[pepe_thugs]

Originally Posted by ThatOneGuy If you want them banned via either DB, then that is fine, although it will double you client connection queries. I would still work on getting your query right. That will work though, and will block the client if theyre banned via either DB.

And yesterday I had a mistake on my website saying that there were many connections databases. I wanted to do it otherwise.
Is it possible to create a "timer" to go run the second query a few minutes later to not create two connections simultaneously in the database?


This is all because I wanted to use the plugin "MatchBan" and I wanted these bans went to another database. The plugin uses "addban" command and I wanted to create another command (myban) for these bans are separated.

[pepe_thugs]

Hello Guys.
I was able to return me values with this query in phpmyadmin:

PHP Code:

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 


And it worked very well.
But the plugin not worked.
Dont kick the player when he connects.
It gives me an error in the logs:

[sourcebans.smx] Query Failed: Column 'bid' cannot be null

Someone can help me please?