wurst
24-07-2007, 18:36
hey folx, im trying around with the teamspeak a bit.
i got the following up and running:
-phpbb3 (debian sarge, mysql 4.1)
-quake<3 gameserver (winxp)
-teamspeak server (win 2k3 dc)
i write that here in this forums cause all three are platform independent and that what i wanna do too.
i installed the sql mode for teamspek and modded the tables so that im able now to run it with phpbb_users.
installation walkthrough i posted here: http://q3ana.de/viewtopic.php?f=16&t=226
now i wanna connect it to the gameserver. the gameserver has 2 teams. (noobs and beginners lol)
what i wanna do is to switch the user in the fitting channel for his team.
oh said me some gamer, that should be difficult.
hm je. for the quake server i worked some out. i get team and ip, called by php, if needed sure in db.
now i could compare that with the clients in teamspeak. both times i have the ip as a primary key. (thats like serial number entry for databases...)
i have the sql db there inside my phpbb, so anyways i can access that isi. otherwise i have the way over the telnet-php-sql (just read nout again...)
this sound weired but the most is written i think.
so im sure in the end and with the help of google i get:
QUAKE3 TSServer
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
the rest is easy. just compare fitting TeamNr to CHANNEL, then switch.
ui.
je and thats my prob. i cant switch somehow from outside.
sombody an idea?
btw, this table here is just ideal example.
sure theres one table first, i would take the teamspeak server. against that i must check then all the playerdata. all must run with a chron, taskplanner, whatever. i wont have a table where every user has a quake identity, but thats not needed.
one bug has the thing, its when 2 players use the same ip eg. through nat.
for this case i see no sollution, so i must check a workaround. but anyways before i cant switch players from outside its senseless.
btw i found a thing in google called TSTOOL.rar (http://www.google.de/search?hl=de&newwindow=1&safe=off&q=TSTOOL.rar&btnG=Suche&meta=)
has anyone expirience with this? when i klick it it just fucks hehe...
thx for your help, maybe theres a way to make TEAMspeak for TEAMS hehe lol :D
i got the following up and running:
-phpbb3 (debian sarge, mysql 4.1)
-quake<3 gameserver (winxp)
-teamspeak server (win 2k3 dc)
i write that here in this forums cause all three are platform independent and that what i wanna do too.
i installed the sql mode for teamspek and modded the tables so that im able now to run it with phpbb_users.
installation walkthrough i posted here: http://q3ana.de/viewtopic.php?f=16&t=226
now i wanna connect it to the gameserver. the gameserver has 2 teams. (noobs and beginners lol)
what i wanna do is to switch the user in the fitting channel for his team.
oh said me some gamer, that should be difficult.
hm je. for the quake server i worked some out. i get team and ip, called by php, if needed sure in db.
now i could compare that with the clients in teamspeak. both times i have the ip as a primary key. (thats like serial number entry for databases...)
i have the sql db there inside my phpbb, so anyways i can access that isi. otherwise i have the way over the telnet-php-sql (just read nout again...)
this sound weired but the most is written i think.
so im sure in the end and with the help of google i get:
QUAKE3 TSServer
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
TeamNr IP CLIENT ID CHANNEL
------------------------------------------------------------------------------------------------
the rest is easy. just compare fitting TeamNr to CHANNEL, then switch.
ui.
je and thats my prob. i cant switch somehow from outside.
sombody an idea?
btw, this table here is just ideal example.
sure theres one table first, i would take the teamspeak server. against that i must check then all the playerdata. all must run with a chron, taskplanner, whatever. i wont have a table where every user has a quake identity, but thats not needed.
one bug has the thing, its when 2 players use the same ip eg. through nat.
for this case i see no sollution, so i must check a workaround. but anyways before i cant switch players from outside its senseless.
btw i found a thing in google called TSTOOL.rar (http://www.google.de/search?hl=de&newwindow=1&safe=off&q=TSTOOL.rar&btnG=Suche&meta=)
has anyone expirience with this? when i klick it it just fucks hehe...
thx for your help, maybe theres a way to make TEAMspeak for TEAMS hehe lol :D