dswp.de
http://www.dswp.de/old/

Need help!!! RunB3 under windows
http://www.dswp.de/old/installation-updates-bugs/need-help-runb3-under-windows-t1162-30.html		 Page 4 of 4
Author:  JackAv [ 09.28.09 ]
Post subject:  Re: Need help!!! RunB3 under windows
achso hmm... Was würdest du mir dann empfehlen?
Author:  Unclefragger [ 09.28.09 ]
Post subject:  Re: Need help!!! RunB3 under windows
sperate Datenbanken, eventuell per IP matchen
Author:  JackAv [ 09.28.09 ]
Post subject:  Re: Need help!!! RunB3 under windows
ok was meinst du mit ips matchen? Bzw wie mach ich das?
Author:  wurst [ 10.18.09 ]
Post subject:  Re: Need help!!! RunB3 under windows
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:
-- 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;
 
Page 4 of 4 All times are UTC + 1 hour
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/