Need help!!! RunB3 under windows

[JackAv]

achso hmm... Was würdest du mir dann empfehlen?

[Unclefragger]

sperate Datenbanken, eventuell per IP matchen

[JackAv]

ok was meinst du mit ips matchen? Bzw wie mach ich das?

[wurst]

hi jack, im glad that u found ur way through windows install.
i myself didnt have any internet, else i could hav helped maybe better.
first of it all one thing: thx for thank dswp in other forums, maybe better put a link on this topic there...

oki what belongs to the penalty prob on many b3 installs:
uncle said it, the client is set by default to this very lol behaviour.
sure clients have the same IP sometimes when connecting to both servers.
theres the point where we can "match" them.
for this issue, we run scripts every minute that check IP in clients table, for the last some hours.
ah btw: we dont sync penalties, but we sync user rights from phpbb db to the b3s on tdm and bomb...

heres an example, u can exec it on sql command line, in win and linux.

Code: Select all

-- B3 Moderatoren Group (8) zum TDM Server updaten

UPDATE
clients c,
phpbb_users ph

SET c.group_bits = 16
WHERE c.id = ph.b3_id
AND ph.group_id = 8
AND ph.locked = 0;

-- B3 Moderatoren Group (8) zum BOMB Server updaten

UPDATE

bot22223.clients c,
phpbb_users ph

SET c.group_bits = 16
WHERE c.id = ph.b3_id_22223
AND ph.group_id = 8
AND ph.locked = 0;