xMrPwN Posted March 2, 2010 Share Posted March 2, 2010 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 Quote Link to comment Share on other sites More sharing options...
OverMe Posted March 2, 2010 Share Posted March 2, 2010 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/ Quote Link to comment Share on other sites More sharing options...
kas23 Posted March 2, 2010 Share Posted March 2, 2010 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 Quote Link to comment Share on other sites More sharing options...
Belzebul Posted March 2, 2010 Share Posted March 2, 2010 Αναλυτικό φένεται, αν και δεν έχω ξανασχοληθεί με website, μπράβο σου. Υ.Γ: Ζητώντας karma πετυχένεις το αντίθετο ;) Quote Link to comment Share on other sites More sharing options...
Snoopi Posted March 3, 2010 Share Posted March 3, 2010 poli orea skepsi apla prospa8ise na to kanis analikotero emena pandos me boi8ises moni mou aporia einia $db_serv = "SQL_SERVER"; edo ti bazo? Quote Link to comment Share on other sites More sharing options...
xMrPwN Posted March 3, 2010 Author Share Posted March 3, 2010 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 (; Quote Link to comment Share on other sites More sharing options...
Snoopi Posted March 3, 2010 Share Posted March 3, 2010 dld localhost? i to no-ip tou server? Quote Link to comment Share on other sites More sharing options...
xMrPwN Posted March 3, 2010 Author Share Posted March 3, 2010 dld localhost? i to no-ip tou server? eki p vriskete o server Quote Link to comment Share on other sites More sharing options...
Snoopi Posted March 3, 2010 Share Posted March 3, 2010 dld C://ktlp? Quote Link to comment Share on other sites More sharing options...
xMrPwN Posted March 4, 2010 Author Share Posted March 4, 2010 dld C://ktlp? Ip dn ginete na valeis c:/ an ipo8eseis oti t site dn vriskete st idio pc me tin database Quote Link to comment Share on other sites More sharing options...
Loren Posted March 4, 2010 Share Posted March 4, 2010 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 Quote Link to comment Share on other sites More sharing options...
xForsak3n Posted March 5, 2010 Share Posted March 5, 2010 8a to testarw na dw Quote Link to comment Share on other sites More sharing options...
ileclipse Posted March 5, 2010 Share Posted March 5, 2010 kani gia ucoz? Quote Link to comment Share on other sites More sharing options...
xMrPwN Posted March 5, 2010 Author Share Posted March 5, 2010 kani gia ucoz? dunno, testare to.... Quote Link to comment Share on other sites More sharing options...
vladimiros Posted March 10, 2010 Share Posted March 10, 2010 Oreo guide file sinexise etci :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.