[Gesior Acc] Last joined, Free Houses and other! v2

BioHazard94 · Mar 28, 2010

Hello !
I edit script by Aleh:
http://otland.net/f118/gesior-acc-last-joined-free-houses-other-70272/

Add to yor database this code!

Code:

ALTER TABLE `accounts` ADD `accounts` INT( 11 ) NOT NULL DEFAULT '0',
ALTER TABLE `players` ADD `players` INT( 11 ) NOT NULL DEFAULT '0';

And to latestnews.php add this code !

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` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC, `players`.`id` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$query3 = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$query4 = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `konto`=0;')->fetch();
$query5 = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `players`=0;')->fetch();
    $main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>
    <tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Welcome to '.$config['server']['serverName'].'</b></td></tr>
    <tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>. Welcome and wish you a nice game!</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> '.$query['text'].'</center></td></tr> 
      <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$query3[0].'</center></td></tr>
      <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts:</b> '.$query4[0].'</center></td></tr>
      <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Players:</b> '.$query5[0].'</center></td></tr>
   

    

</table></td></tr></table><br />';

Screen:

Look in practice:
HERE

Deavz · Mar 28, 2010

Approved.

Aleh · Mar 28, 2010

Nothing special. Copied the query and changed name of the table... Do it in one query.

BugaS · Mar 28, 2010

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'konto' in 'where clause'' in /home/www/www.legendary-ot.pl/latestnews.php:50 Stack trace: #0 /home/www/www.legendary-ot.pl/latestnews.php(50): PDO->query('SELECT COUNT(*)...') #1 /home/www/www.legendary-ot.pl/index.php(160): include('/home/www/www.l...') #2 {main} thrown in /home/www/www.legendary-ot.pl/latestnews.php on line 50

gl..

zakius · Mar 28, 2010

maybe just count by worldid or WHERE account_id IN (SELECT id FROM accounts) or something instead of making new fields

sorcerers king · Mar 28, 2010

good job

Kask · Mar 28, 2010

PHP:

$query4 = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `konto`=0;')->fetch();

konto? 0o
can be...

PHP:

$query4 = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `account_id`=0;')->fetch();

?

zakius · Mar 28, 2010

no, nowhere account_id is equal 0 so it will show 0 as result

BioHazard94 · Mar 28, 2010

ALTER TABLE `accounts` ADD `accounts` INT( 11 ) NOT NULL DEFAULT '0',
ALTER TABLE `players` ADD `players` INT( 11 ) NOT NULL DEFAULT '0';

When you add these codes to the base, each account will get a ticket 0, thanks to it be known how many accounts are established.
Each player also gets a ticket thanks to him we will know if the form!

BioHazard94 · Mar 28, 2010

$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, `players`.`id` desc limit 1;')->fetch();
$query2 = $sql->query('select `id`, `name` from `players` order by `id` desc limit 1;')->fetch();
$query3 = $sql->query('select count(*) from `houses` where `owner`=0;')->fetch();
$query4 = $sql->query('select count(*) from `accounts` where `accounts`=0;')->fetch();
$query5 = $sql->query('select count(*) from `players` where `players`=0;')->fetch();
$main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>welcome to '.$config['server']['servername'].'</b></td></tr>
<tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>

<tr bgcolor='. $config['site']['lightborder'] .'><td><center>last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>. Welcome and wish you a nice game!</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center>currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>server motd:</b> '.$query['text'].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>free houses:</b> '.$query3[0].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>accounts:</b> '.$query4[0].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>players:</b> '.$query5[0].'</center></td></tr>

</table></td></tr></table><br />';

fixed !

adek23 · Mar 28, 2010

Parse error: syntax error, unexpected T_LNUMBER in /home/admin/domains/nevoria.com/public_html/latestnews.php on line 24

ddddddd

adek23 said:
Parse error: syntax error, unexpected T_LNUMBER in /home/xxxxxx/latestnews.php on line 24

hodleo · Mar 29, 2010

BioHazard94 said:
When you add these codes to the base, each account will get a ticket 0, thanks to it be known how many accounts are established.
Each player also gets a ticket thanks to him we will know if the form!

lol that's a waste of resources really unnecessary. Can be done just by counting # of fields

Kavvson · Mar 29, 2010

Really this is going in a bad way... In the future the script will have like 20 <TR> this is lame: /

Zonet · Mar 29, 2010

You've made like 5 threads for just a improved script, you could always edit your thread. <_<

Paxton · Mar 29, 2010

Kavvson said:
Really this is going in a bad way... In the future the script will have like 20 <TR> this is lame: /

What?

Kask · Mar 29, 2010

Kavvson said:
Really this is going in a bad way... In the future the script will have like 20 <TR> this is lame: /

take this if ur dont want 20 "<TR></TR>"

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` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC, `players`.`id` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$query3 = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$query4 = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `konto`=0;')->fetch();
$query5 = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `players`=0;')->fetch();
    $main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>
    <tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Welcome to '.$config['server']['serverName'].'</b></td></tr>
    <tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>. Welcome and wish you a nice game!</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> '.$query['text'].'</center></td></tr> 
      <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$query3[0].'</center></td>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts:</b> '.$query4[0].'<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Players:</b> '.$query5[0].'</center></td></tr>
   

    

</table></td></tr></table><br />';

xD

LaloHao · Mar 29, 2010

no need to edit database to do this

PHP:

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

Lava Titan · Mar 31, 2010

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'konto' in 'where clause'' in C:\xampp\htdocs\latestnews.php:22 Stack trace: #0 C:\xampp\htdocs\latestnews.php(22): PDO->query('SELECT COUNT(*)...') #1 C:\xampp\htdocs\index.php(69): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 22

gz...

Sorry for double post

just to say that i fixed it

Rep+ for ya

BioHazard94 · Apr 2, 2010

ALTER TABLE `accounts` ADD `konto` INT( 11 ) NOT NULL DEFAULT '0';

Add this to database

Aleh · Apr 2, 2010

Here you have a working script: http://otland.net/f118/gesior-acc-last-joined-free-houses-other-70272/ There are no problems.

[Gesior Acc] Last joined, Free Houses and other! v2

P[r]oland

Global Moderator

Active Member

Donżuan

Enter the Ninja!

spo

Banned User

Enter the Ninja!

P[r]oland

P[r]oland

New Member

Formerly cbrm -Crypto enthusiast, Retired scripter

Gdy boli cie glowa wez

Web Developer

Banned User

Banned User

Member

Developer

P[r]oland

Active Member

Similar threads