Menu
What's new
By:
Filters

Account Maker Licznik kont i graczy

Status
Not open for further replies.
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Witam potrzebuje licznik kont i graczy polega na tym, ?e pisze 0 graczy na 0 kontach i gdy ktos zalozy konto pisze 0 graczy na 1 koncie i gdy zalozy ktos postac to pisz? 1 gracz na 1 koncie taka opcja jest na telania.net dam du?o reput za pomoc!!
 
DenZ

DenZ

Zasłużony
Joined
Feb 23, 2011
Messages
868
Reaction score
30
Age
28
Odp: Licznik kont i graczy

Mo?esz sobie przerobi? ten kod.

Code: 
/////////////////////////////////////////////////////////////////////////////////////////
//The new edition of my script: Best Player, Last joined and something new Server Motd.//
/////////////////////////Everything in the new appearance.///////////////////////////////
//////////////////////////////////////by  Aleh///////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////
///Queries ///
$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
///End Queries ///




$main_content .= '<center><div class="NewsHeadline">
	<div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
		<table border="0">
			<tr>
				<td style="text-align: center; font-weight: bold;">
					<font color="white">WELCOME to ' . $config['server']['serverName'] . ' !</font>
				</td>
			</tr>
		</table>
	</div>
</div></center>


';



$kutas = $accounts[0] + 0;
$kutas1 = $players[0] + 0;
$kutas2 = $guilds[0] + 0;

    $main_content .= '
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Ostatnio dolaczyl do nas: <b><a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a></b>, gracz numer '.$kutas1.'.</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Obecnie najlepszym graczem na serwerze jest: <b><a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).')</b>.</center></td></tr>
    <table border=0 cellpadding=0 cellspacing=1 width=100%>    
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$kutas.'.</center></td>
    <td><center><b>Players</b> in database: '.$kutas1.'.</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>House</b> in game: 514.</center></td>
    <td><center><b>Guilds</b> in databese: '.$kutas2.'.</center></td></tr>

</table></td></tr></b></table>';
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

a gdzie to wklei? ? I co to jest to co ty wys?a?e? ?
 
DenZ

DenZ

Zasłużony
Joined
Feb 23, 2011
Messages
868
Reaction score
30
Age
28
Odp: Licznik kont i graczy

to jest to co masz np na Roxon.pl
Wklej to do latestnews.php
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

po wgraniu wychodzi b??d Fatal error: Call to a member function fetch() on boolean in /var/xxxxt/home/xxxxx/www/pages/latestnews.php on line 160

---------- Tre?? dodana o 18:11 ----------

Pomo?e kto? ??
 
DenZ

DenZ

Zasłużony
Joined
Feb 23, 2011
Messages
868
Reaction score
30
Age
28
Odp: Licznik kont i graczy

Podaj to co znajduj? si? pod numerem 160
 
buchaLL

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Licznik kont i graczy

Wklej w odpowiednie dla Ciebie miejsce w latestnews.php

[LUA]$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();

$main_content .= ' '.$players[0].' graczy na '.$accounts[0].' kontach.';[/LUA]
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

buchaLL dzi?ki dzia?a ale to s?abo wygl?da troche :/ Mi potrzebne takie co? jak na roxon.pl masz reput ale prosz? o lepsze :(

---------- Tre?? dodana o 19:11 ----------

A je?eli nie da?oby rad? zrobi? tak jak na roxon.pl to mo?ecie mi zrobi? ?eby ten kod
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();

$main_content .= ' '.$players[0].' graczy na '.$accounts[0].' kontach.';
Click to expand...
Zrobi? tak ?eby on by? na ?rodku bo chc? doda? <center> </center> ale nie wiem, w kt?rym miejscu a jak dam w z?ym to b??d :/
 
Ciamciaj Bigos

Ciamciaj Bigos

&#3585;&#3657;&#3657;&#3657;&#3657;&#3657;&#3657;&
Joined
Jun 6, 2013
Messages
2,081
Reaction score
192
Odp: Licznik kont i graczy

kod z roxon
HTML: 
<table border="0" cellpadding="0" cellspacing="1" width="100%">    
    <tbody><tr bgcolor="#F1E0C6"><td><center><b>Accounts</b> in database: 606.</center></td>
    <td><center><b>Players</b> in database: 900.</center></td></tr>
    <tr bgcolor="#F1E0C6"><td><center><b>House</b> in game: 514.</center></td>
    <td><center><b>Guilds</b> in databese: 1.</center></td></tr>

</tbody></table>
wstaw do tego tylko php
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

co gdzie mam wstawi? te php ?

---------- Tre?? dodana o 19:11 ----------

//Ja was prosz? o ten kod chc? ino go wklei? ?eby dzia?a? :/
 
buchaLL

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Licznik kont i graczy

PHP: 
	$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` ORDER BY `players`.`level` DESC, `players`.`experience` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();

$main_content .= ' 
<center>
Ostatnio dolaczyl do nas: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>, gracz numer '.$query2['id'].'.
Obecnie najlepszym graczem na serwerze jest: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).').
</center>
<table border="0" cellpadding="0" cellspacing="1" width="100%"> 
    <tbody><tr bgcolor="grey"><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>
    <td><center><b>Players</b> in database: '.$players[0].'</center></td></tr>
    <tr bgcolor="grey"><td><center><b>House</b> in game: '.$housesfree[0].'</center></td>
    <td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr>
 
</tbody></table>

';
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

Parse error: syntax error, unexpected '2' (T_LNUMBER) in /var/xxx/home/xxx/www/pages/latestnews.php on line 164 a jest to b??d: Ostatnio dolaczyl do nas: <a href="?subtopic=characters&name='.urlencode($query 2['name']).'">'.$query2['name'].'</a>, gracz numer '.$query2['id'].'. po wgraniu tego co mi wyslales do latesnews.
 
buchaLL

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Licznik kont i graczy

Code: 
	    	$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` ORDER BY `players`.`level` DESC, `players`.`experience` DESC LIMIT 1;')->fetch();
    $query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
    $housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
    $players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
    $accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
    $guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
     
    $main_content .= ' 
    <center>
    Ostatnio dolaczyl do nas: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>, gracz numer '.$query2['id'].'.
    Obecnie najlepszym graczem na serwerze jest: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).').
    </center>
    <table border="0" cellpadding="0" cellspacing="1" width="100%"> 
        <tbody><tr bgcolor="grey"><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>
        <td><center><b>Players</b> in database: '.$players[0].'</center></td></tr>
        <tr bgcolor="grey"><td><center><b>House</b> in game: '.$housesfree[0].'</center></td>
        <td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr>
     
    </tbody></table>
     
    ';
 
Last edited:
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

Po wgraniu tego kodu jest b??d w 164 linijce i jest nim ona : Ostatnio dolaczyl do nas: <a href="?subtopic=characters&name='.urlencode($query 2['name']).'">'.$query2['name'].'</a>, gracz numer '.$query2['id'].'.
 
buchaLL

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Licznik kont i graczy

Zedytowa?em ostatni post.
Znaczniki
PHP: 
, [LUA] doda?y sobie spacje w 100 i 101 linii.
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

Dzia?a dobrze jest, ale czy nie da?oby rad? zrobi? to lepiej chodzi mi o wygl?d bo troch? dzwignie to wygl?da?? Na roxon.pl wygl?da to lepiej ten kolor itd :D + Dam wam zdj?cie
You do not have permission to view link please Log in or Register
 
buchaLL

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Licznik kont i graczy

Nie wiem jaki kolor Ci odpowiada, wi?c edytuj sobie grey na w?asny kolor:
HTML: 
<tr bgcolor="grey">

Je?li chcia?by? zmieni? kolor tekstu to dodajesz style.
HTML: 
<tr bgcolor="grey" style="color:red;">
 
V

Venaria

Active User
Joined
Sep 29, 2016
Messages
62
Reaction score
0
Odp: Licznik kont i graczy

a roxon.pl jaki ma kolor ?
 
DenZ

DenZ

Zasłużony
Joined
Feb 23, 2011
Messages
868
Reaction score
30
Age
28
Odp: Licznik kont i graczy

<tr bgcolor="grey"> - Taki ma roxon kolor.
 
Status
Not open for further replies.
Top