Jump to content
GIGN Forum

hektorss

Mirstīgais
 View Profile  See their activity

  • Posts

    6

  • Joined

  • Last visited

 Content Type 

Posts posted by hektorss

  2. Help Ar Monitoringu

    in Programmēšana

    Posted

    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);
?>

  4. Palidzat Ar Ipb Login Script

    in Programmēšana

    Posted · Edited by hektorss

    Sveiki...

    vai kads varetu palidzet ar IPB login script

    metas shads error

    OMG, mana oo.lv datubāze atkal nosprāga

    '); mysql_select_db("forums")or die('

    OMG, mana oo.lv datubāze atkal nosprāga

    ');

    function draw_login(){

    echo '

    <?

    mysql_connect("localhost", "lietotājs", "parole")or die('<pre>OMG, mana oo.lv datubāze atkal nosprāga</p>');

    mysql_select_db("datubāze")or die('<pre>OMG, mana oo.lv datubāze atkal nosprāga</p>');

    function draw_login(){

    echo '

    <form method="post" action="/mans/superforums/index.php?act=Login&CODE=01">

    <p>

    <b>Lietotājvārds:</b><br />

    <input name="UserName" type="text" /><br />

    <b>Parole:</b><br />

    <input name="PassWord" type="password" /><br />

    <input name="CookieDate" value="1" type="checkbox" />?<b>acerēties mani?</b><br />

    <input value="Ienākt" type="submit" />?<a href="/mans/superforums/index.php?act=Reg&CODE=00">Reģistrēties</a>

    </p>

    </form>

    ';

    }

    if(!empty($_COOKIE['member_id']) && is_numeric($_COOKIE['member_id']) && !empty($_COOKIE['pass_hash'])){

    $sql = sprintf("SELECT m.id, m.email, m.member_login_key, m.joined, e.avatar_location FROM `ibf_members` m, `ibf_member_extra` e WHERE m.id=%d AND m.member_login_key='%s' AND e.id=m.id LIMIT 1", (int)$_COOKIE['member_id'], mysql_real_escape_string($_COOKIE['pass_hash']));

    $res = mysql_query($sql);

    if(mysql_num_rows($res)>0){

    $row = mysql_fetch_object($res);

    printf('

    <p style="text-align:center;">

    Sveiks %s%s

    </p>

    <ul>

    <li><a href="/mans/superforums/index.php?act=UserCP&CODE=00">Labot Profilu</a></li>

    <li><a href="/mans/superforums/index.php?act=Msg&CODE=01">Vēstules</a></li>

    <li><a href="/mans/superforums/index.php?act=Members">Lietotāji</a></li>

    <li><a href="/mans/superforums/index.php?act=Search&f=0">Meklēt forumā</a></li>

    <li><a href="/mans/superforums/index.php?act=Login&CODE=03&k=%s">[iZIET]</a></li>

    </ul>

    ', $row->member_login_key, !empty($row->avatar_location) ? '<br /><img src="'.$row->avatar_location.'" alt="" />' : '', md5($row->email.'&'.$row->member_login_key.'&'.$row->joined));

    }else{

    draw_login();

    }

    }else{

    draw_login();

    }

    ?>

×
×
  • Create New...