[Guide]Server stats sto site

[xMrPwN]

Ok, den 3erw an exi 3anaginei kt tetio post ala egw 8a t kanw pl leptomerws ;)

As arxisoume...

 

orea, as ipo8esoume oti sta arxeia tou site kanoume ena fakelo /config/ k mesa kanoume ena arxeio stats.php

k mesa grafoume auta:

<?php

   $db_user = "USER"; 
   $db_pass = "PSW"; 
   $db_name = "DATABASE"; 
   $db_serv = "HOST(ip)"; 

   $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); 
   $resdb = mysql_select_db ( "$db_name",$res ); 

   return $res; 

?>

ta siblirwnoume opos prepei

eki 8a ine ta info gia na sindeode auta p 8a dixnoun ta stats me tin database

--------------------------------------------------------------------------------------------

meta, se opia selida valoume stats, 8a prepei na exei mesa auto to code(sto top):

<?php include "config/stats.php" ?>

kai auta:

<?php

mysql_connect($db_serv,$db_user,$db_pass) or die(mysql_error());

mysql_select_db($db_name) or die(mysql_error());

 

istera grafoume ti 8eloume na diavazei apo tin database

oriste merika paradeigmata:

//Total Accounts
$query = ("SELECT * FROM accounts WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$acc2=mysql_numrows($result);

//GMs Online
$query = ("SELECT * FROM characters WHERE accesslevel=200 and online=1");

$result = mysql_query($query) or die(mysql_error());

$GM=mysql_numrows($result);

//Online Players
$query = ("SELECT * FROM characters WHERE accesslevel<=0 and online=1");

$result = mysql_query($query) or die(mysql_error());

$online=mysql_numrows($result);

//Total Characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//Total clans
$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);

auta p ine stin teleutea seira ka8e code px sto "$clan2=mysql_numrows($result);" to clan2 ine to name m t opio 8a grafete to ka8eti sto file, auto to alazoume an 8eloume...

telos klinoume to code tou connect me:

mysql_close();

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

mysql_select_db($db_name) or die(mysql_error());
?>

 

k afou ine ola gramena, gia na di3oume px sto site tous total characters grafoume:

Total Characters: <?php print ("$char2"); ?>

(//Total characters(to script) 8a prepei na ine stin idia selida p 8a 8es na t di3oume, an ine alou apla vazoume eki p 8a ta dixnoume ena:

<?php include "ToFilePouTaExeis.php" ?>

 

Elpizw na voi8isa :)

 

PS: to karma m sto 0 opios borei ;p

[OverMe]

kalo share alla apoklietai kaneis na s doseis +1 karma einai polu diskolo kai to topic sou einai idi share to exw dei alou tecpa klh prospa8ia/

[kas23]

kalo share alla apoklietai kaneis na s doseis +1 karma einai polu diskolo kai to topic sou einai idi share to exw dei alou tecpa klh prospa8ia/

sinfono me ton OverMe gia to karma gt exei 3anagini post ala mia xara einai p mas to 3ana8imises :D

[Belzebul]

Αναλυτικό φένεται, αν και δεν έχω ξανασχοληθεί με website, μπράβο σου.

 

 

Υ.Γ: Ζητώντας karma πετυχένεις το αντίθετο ;)

[Snoopi]

poli orea skepsi apla prospa8ise na to kanis analikotero emena pandos me boi8ises moni mou aporia einia $db_serv = "SQL_SERVER";  edo ti bazo?

[xMrPwN]

poli orea skepsi apla prospa8ise na to kanis analikotero emena pandos me boi8ises moni mou aporia einia $db_serv = "SQL_SERVER";  edo ti bazo?

to ip tou sql server (;

[Snoopi]

dld localhost?

i to no-ip tou server?

[xMrPwN]

dld localhost?

i to no-ip tou server?

eki p vriskete o server

[Snoopi]

dld C://ktlp?

[xMrPwN]

dld C://ktlp?

Ip

dn ginete na valeis c:/ an ipo8eseis oti t site dn vriskete st idio pc me tin database

[Loren]

sinfono me ton OverMe gia to karma gt exei 3anagini post ala mia xara einai p mas to 3ana8imises :D

c/p?dose link tote..

ty for share

[xForsak3n]

8a to testarw na dw

[ileclipse]

kani gia ucoz?

[xMrPwN]

kani gia ucoz?

dunno, testare to....

[vladimiros]

Oreo guide file sinexise etci :)