Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
http://viva-l2.xz.lt/l2jstatus.php
cia uzejus meta errora
Stai kodas,padekit kas nors
?>php
#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";
#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";
#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";
?>
<?php
#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
$lstat = "<font color=#00FF00>ONLINE</font>";
else
$lstat = "<font color=#FF0000>OFFLINE</font>";
#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
$gstat2 = "<font color=#00FF00>ONLINE</font>";
else
$gstat2 = "<font color=#FF0000>OFFLINE</font>";
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");
$result = mysql_query($query) or die(mysql_error());
$num2=mysql_numrows($result);
$sum=$sum+$num2;
//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");
$result = mysql_query($query) or die(mysql_error());
$alliance2=mysql_numrows($result);
//all characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");
$result = mysql_query($query) or die(mysql_error());
$char2=mysql_numrows($result);
//all GM characters
$query = ("SELECT * FROM characters Where accesslevel > 99");
$result = mysql_query($query) or die(mysql_error());
$gmchar2=mysql_numrows($result);
//all accounts
$query = ("SELECT * FROM accounts WHERE access_level>=0");
$result = mysql_query($query) or die(mysql_error());
$accounts2=mysql_numrows($result);
//Clan
$get_config_data="SELECT clan_id FROM clan_data";
$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");
$result = mysql_query($query) or die(mysql_error());
$clan2=mysql_numrows($result);
//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
$gmname2 = $gmtitle2["char_name"];
}
//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
$titanname2 = $titantitle2["char_name"];
}
mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
?>
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
MAnjack
Garbės narys
Legenda

Pranešimai: 11821
Įstojęs: 2006 Kov. 2 20:03:58
|
?>php
Keisk į:
<?php
|
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
visus?
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
mXt
Narys
Viršesnis už Dievą

Pranešimai: 5775
Įstojęs: 2006 Bir. 9 16:06:09
|
As tai tik viena matau Sakyk tiesiai, ka rukei?
ex best admin! |
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
pigius vitaminus
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
RuP3r
VIP narys
Tankas

Pranešimai: 2016
Įstojęs: 2007 Lie. 15 20:07:25
|
<?php
#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";
#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";
#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";
?>
<?php
#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
$lstat = "<font color=#00FF00>ONLINE</font>";
else
$lstat = "<font color=#FF0000>OFFLINE</font>";
#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
$gstat2 = "<font color=#00FF00>ONLINE</font>";
else
$gstat2 = "<font color=#FF0000>OFFLINE</font>";
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");
$result = mysql_query($query) or die(mysql_error());
$num2=mysql_numrows($result);
$sum=$sum+$num2;
//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");
$result = mysql_query($query) or die(mysql_error());
$alliance2=mysql_numrows($result);
//all characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");
$result = mysql_query($query) or die(mysql_error());
$char2=mysql_numrows($result);
//all GM characters
$query = ("SELECT * FROM characters Where accesslevel > 99");
$result = mysql_query($query) or die(mysql_error());
$gmchar2=mysql_numrows($result);
//all accounts
$query = ("SELECT * FROM accounts WHERE access_level>=0");
$result = mysql_query($query) or die(mysql_error());
$accounts2=mysql_numrows($result);
//Clan
$get_config_data="SELECT clan_id FROM clan_data";
$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");
$result = mysql_query($query) or die(mysql_error());
$clan2=mysql_numrows($result);
//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
$gmname2 = $gmtitle2["char_name"];
}
//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
$titanname2 = $titantitle2["char_name"];
}
mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
?>
|
Fanio
Garbės narys
Viršesnis už Dievą

Pranešimai: 5675
Įstojęs: 2006 Sau. 27 23:01:47
|
Vaje vaje, nejaugi tiek nesimato..
<?php
#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";
#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";
#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";
?>
<?php
#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
$lstat = "<font color=#00FF00>ONLINE</font>";
else
$lstat = "<font color=#FF0000>OFFLINE</font>";
#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
$gstat2 = "<font color=#00FF00>ONLINE</font>";
else
$gstat2 = "<font color=#FF0000>OFFLINE</font>";
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");
$result = mysql_query($query) or die(mysql_error());
$num2=mysql_numrows($result);
$sum=$sum+$num2;
//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");
$result = mysql_query($query) or die(mysql_error());
$alliance2=mysql_numrows($result);
//all characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");
$result = mysql_query($query) or die(mysql_error());
$char2=mysql_numrows($result);
//all GM characters
$query = ("SELECT * FROM characters Where accesslevel > 99");
$result = mysql_query($query) or die(mysql_error());
$gmchar2=mysql_numrows($result);
//all accounts
$query = ("SELECT * FROM accounts WHERE access_level>=0");
$result = mysql_query($query) or die(mysql_error());
$accounts2=mysql_numrows($result);
//Clan
$get_config_data="SELECT clan_id FROM clan_data";
$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");
$result = mysql_query($query) or die(mysql_error());
$clan2=mysql_numrows($result);
//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
$gmname2 = $gmtitle2["char_name"];
}
//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
$titanname2 = $titantitle2["char_name"];
}
mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
?>
Redagavo Fanio 2008 Lie. 28 11:07:34 |
mXt
Narys
Viršesnis už Dievą

Pranešimai: 5775
Įstojęs: 2006 Bir. 9 16:06:09
|
ir abu smailus palikot 
ex best admin! |
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
na dabar dar kitoki errora meta
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
mXt
Narys
Viršesnis už Dievą

Pranešimai: 5775
Įstojęs: 2006 Bir. 9 16:06:09
|
<?php
#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";
#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";
#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";
?>
<?php
#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
$lstat = "<font color=#00FF00>ONLINE</font>";
else
$lstat = "<font color=#FF0000>OFFLINE</font>";
#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
$gstat2 = "<font color=#00FF00>ONLINE</font>";
else
$gstat2 = "<font color=#FF0000>OFFLINE</font>";
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");
$result = mysql_query($query) or die(mysql_error());
$num2=mysql_numrows($result);
$sum=$sum+$num2;
//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");
$result = mysql_query($query) or die(mysql_error());
$alliance2=mysql_numrows($result);
//all characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");
$result = mysql_query($query) or die(mysql_error());
$char2=mysql_numrows($result);
//all GM characters
$query = ("SELECT * FROM characters Where accesslevel > 99");
$result = mysql_query($query) or die(mysql_error());
$gmchar2=mysql_numrows($result);
//all accounts
$query = ("SELECT * FROM accounts WHERE access_level>=0");
$result = mysql_query($query) or die(mysql_error());
$accounts2=mysql_numrows($result);
//Clan
$get_config_data="SELECT clan_id FROM clan_data";
$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");
$result = mysql_query($query) or die(mysql_error());
$clan2=mysql_numrows($result);
//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
$gmname2 = $gmtitle2["char_name"];
}
//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
$titanname2 = $titantitle2["char_name"];
}
mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());
mysql_select_db($databaseName) or die(mysql_error());
?>
ex best admin! |
Fanio
Garbės narys
Viršesnis už Dievą

Pranešimai: 5675
Įstojęs: 2006 Sau. 27 23:01:47
|
lovefiefka parašė:
na dabar dar kitoki errora meta
Naudok kur pataisiau dabar ir nemes 
|
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
zmones vistiek neveikia http://viva-l2.xz.lt/l2jstatus.php
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
MAnjack
Garbės narys
Legenda

Pranešimai: 11821
Įstojęs: 2006 Kov. 2 20:03:58
|
Taigi sql lentelė nesukurta, o čia jau mes niekuo nepadėsim, nes nežinom struktūros.
|
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
kokios strukturos reikia sakyk gal pasakysiu padesit tada
as noriu kad rodytu kiek zaideju siuo metu losia ,kiek serve prisijungusiu ir pns
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą.
Redagavo Child 2008 Lie. 28 11:07:04 |
Žmogus
Narys
Viršesnis už Dievą
Pranešimai: 5621
Įstojęs: 2006 Gru. 8 17:12:08
|
Iš kur tu šita gavai?
|
Poker
Narys
Terminatorius

Pranešimai: 1451
Įstojęs: 2008 Sau. 28 10:01:55
|
Visu pirma tu turi imti viska ne ish kokio savo db,o ish serverio db...ten yra lentele characters .
Draugus laikyk arčiau o priešus dar arčiau. |
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
paziurekit db ka ten meta
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
Poker
Narys
Terminatorius

Pranešimai: 1451
Įstojęs: 2008 Sau. 28 10:01:55
|
Ir nesupranti kodel? 
Draugus laikyk arčiau o priešus dar arčiau. |
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
nea
 
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |
MAnjack
Garbės narys
Legenda

Pranešimai: 11821
Įstojęs: 2006 Kov. 2 20:03:58
|
Prisijungimas blogas. Mokinkis saito kūrimo poagrindų.
|
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
man cia reikia ne saio o servo
Warkion jei zinai kas yra tai pasakyk
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą.
Redagavo Child 2008 Lie. 28 12:07:04 |
Child
Narys
Tankas

Pranešimai: 1719
Įstojęs: 2008 Vas. 14 19:02:16
|
padesi?
www.stylingparts.eu-viskas jūsų automobiliams už geriausią kainą. |