hektorss Posted November 7, 2009 Report Share Posted November 7, 2009 Sveiki... vai kads newaretu palidzet uzstadit sho monitoru visu salieku bet radaas Nesanaca izpildit vaicajumu #1 P.S paroli lietotaju,db esmu salicis <?php //db shits $hosts = "localhost"; $lietotajs = "lietotajs"; $parole = "manaparole"; $db = "monitor"; //Viss pareejais shits (iipashiem pro ieteicams neko nelabot) $konekcija = mysql_connect($hosts,$lietotajs,$parole) or die("Nesanaca piekonekteties db"); mysql_select_db($db,$konekcija) or die("Nesanaca izveleties db"); $vaicajums1="SELECT * FROM details"; $rezultats1=mysql_query($vaicajums1,$konekcija) or die ("Nesanaca izpildit vaicajumu #1"); $aile = mysql_fetch_array($rezultats1); $nakamamape=$aile['nextmap']; $laiksatlicis=$aile['timeleft']; $laikalimits=$aile['timelimit']; $mape=$aile['mapname']; $maxplayers=$aile['maxplayers']; $rezultatst=$aile['scoret']; $rezultatsct=$aile['scorect']; $vaicajums2ct="SELECT * FROM players WHERE team='CT'"; $rezultats2ct=mysql_query($vaicajums2ct,$konekcija) or die ("Nesanaca izpildit vaicajumu #2"); $speletajict=mysql_num_rows($rezultats2ct); $vaicajums2t="SELECT * FROM players WHERE team='TERRORIST'"; $rezultats2t=mysql_query($vaicajums2t,$konekcija) or die ("Nesanaca izpildit vaicajumu #2"); $speletajit=mysql_num_rows($rezultats2t); $vaicajums2unknow="SELECT * FROM players WHERE team='SPECTATOR' OR team='UNASSIGNED'"; $rezultats2unknow=mysql_query($vaicajums2unknow,$konekcija) or die ("Nesanaca izpildit vaicajumu #2"); $speletajiunknow=mysql_num_rows($rezultats2unknow); $speletaji=mysql_num_rows($rezultats2ct)+mysql_num_rows($rezultats2t)+mysql_num_rows($rezultats2unknow); $brivisloti=$maxplayers-$speletaji; echo "<font color=\"green\">» Server monitor</font><br />"; echo "Statuss: "; if($brivisloti=="0") { echo "nav brîvu slotu"; } elseif($brivisloti=="1") { echo "1 brîvs slots"; } else { echo $brivisloti." brîvi sloti"; } echo "<br />Spçlçtâji: $speletaji/$maxplayers"; echo "<br />Karte: $mape"; echo "<br />Laiks: $laiksatlicis/$laikalimits:00"; echo "<br />Nâkamâ mape: $nakamamape"; echo "<br />"; echo "<br /><font color=\"blue\">» CT komanda ($rezultatsct)</font><br />"; while($aile2ct = mysql_fetch_array($rezultats2ct)) { echo $aile2ct['name']." (".$aile2ct['frags']."/".$aile2ct['deaths'].")<br />"; } echo "<br />"; echo "<font color=\"red\">» T komanda ($rezultatst)</font><br />"; while($aile2t = mysql_fetch_array($rezultats2t)) { echo $aile2t['name']." (".$aile2t['frags']."/".$aile2t['deaths'].")<br />"; } echo "<br />"; echo "<font color=\"gray\">» Skatîtâji</font><br />"; while($aile2unknow = mysql_fetch_array($rezultats2unknow)) { echo $aile2unknow['name']; } mysql_free_result($rezultats1); mysql_free_result($rezultats2ct); mysql_free_result($rezultats2t); mysql_free_result($rezultats2unknow); mysql_close($konekcija); ?> Link to comment Share on other sites More sharing options...
RaaapuLis Posted November 7, 2009 Report Share Posted November 7, 2009 Tā, manuprāt, ir problēma, tātad arī pei attiecīās sadaļas raksti ko tādu! Pamēģini: PHP <?php $hosts = "localhost"; // localhost $lietotajs = "lietotajs"; // db lietotajs $parole = "manaparole"; // db parole $db = "monitor"; // db nosaukums $konekcija = mysql_connect($hosts,$lietotajs,$parole) or die("Nesanaca piekonekteties db"); mysql_select_db($db,$konekcija) or die("Nesanaca izveleties db"); $rezultats1=mysql_query("SELECT * FROM details") or die ("Nesanaca izpildit vaicajumu #1"); $aile = mysql_fetch_array($rezultats1); $nakamamape=$aile['nextmap']; $laiksatlicis=$aile['timeleft']; $laikalimits=$aile['timelimit']; $mape=$aile['mapname']; $maxplayers=$aile['maxplayers']; $rezultatst=$aile['scoret']; $rezultatsct=$aile['scorect']; $vaicajums2ct="SELECT * FROM players WHERE team='CT'"; $rezultats2ct=mysql_query($vaicajums2ct,$konekcija) or die ("Nesanaca izpildit vaicajumu #2"); $speletajict=mysql_num_rows($rezultats2ct); $vaicajums2t="SELECT * FROM players WHERE team='TERRORIST'"; $rezultats2t=mysql_query($vaicajums2t,$konekcija) or die ("Nesanaca izpildit vaicajumu #2"); $speletajit=mysql_num_rows($rezultats2t); $vaicajums2unknow="SELECT * FROM players WHERE team='SPECTATOR' OR team='UNASSIGNED'"; $rezultats2unknow=mysql_query($vaicajums2unknow,$konekcija) or die ("Nesanaca izpildit vaicajumu #2"); $speletajiunknow=mysql_num_rows($rezultats2unknow); $speletaji=mysql_num_rows($rezultats2ct)+mysql_num_rows($rezultats2t)+mysql_num_rows($rezultats2unknow); $brivisloti=$maxplayers-$speletaji; echo "<font color=\"green\">» Server monitor</font><br />"; echo "Statuss: "; if( $brivisloti=="0") { echo "nav brīvu slotu"; } elseif($brivisloti=="1") { echo "1 brīvs slots"; } else { echo $brivisloti." brīvi sloti"; } echo "<br />Spēlētāji: $speletaji/$maxplayers"; echo "<br />Karte: $mape"; echo "<br />Laiks: $laiksatlicis/$laikalimits:00"; echo "<br />Nākamā mape: $nakamamape"; echo "<br />"; echo "<br /><font color=\"blue\">» CT komanda ($rezultatsct)</font><br />"; while( $aile2ct = mysql_fetch_array($rezultats2ct)) { echo $aile2ct['name']." (".$aile2ct['frags']."/".$aile2ct['deaths'].")<br />"; } echo "<br />"; echo "<font color=\"red\">» T komanda ($rezultatst)</font><br />"; while( $aile2t = mysql_fetch_array($rezultats2t)) { echo $aile2t['name']." (".$aile2t['frags']."/".$aile2t['deaths'].")<br />"; } echo "<br />"; echo "<font color=\"gray\">» Skatītāji</font><br />"; while( $aile2unknow = mysql_fetch_array($rezultats2unknow)) { echo $aile2unknow['name']; } mysql_free_result($rezultats1); mysql_free_result($rezultats2ct); mysql_free_result($rezultats2t); mysql_free_result($rezultats2unknow); mysql_close($konekcija); ?> Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now