[Znote Acc] Template

kimokimo · Sep 9, 2012

This is znote acc default template edited and this is the first time i edite a template i don't know anything about html or css i made it logicly and with some help from w3schools.com.

I used some resources from old templates like freeq template.

1 -Open Znote folder and replace layout folder with my layout.
2 -Replace index.php with the one below.

PHP:

<?php require_once 'engine/init.php'; include 'layout/overall/header.php'; ?>



<div id="menu-top"></div>
<div id="menu-bar">



<?PHP
echo '<table border="1" cellspacing="1"><tr class="yellow"><td><center>Server Information</center></td></tr>
<tr><td>';
$getshit11 = mysql_query("SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1"); 
$fetchshitt = mysql_fetch_assoc($getshit11); 
$getshit1 = mysql_query("SELECT COUNT(*) as `shit` FROM `players` ");
$fetchshit = mysql_fetch_assoc($getshit1);
$getshit2 = mysql_query("SELECT `name`, `level` FROM `players` ORDER BY `level` DESC LIMIT 1");
$fetchshit2 = mysql_fetch_assoc($getshit2);
$getshit3 = mysql_query("SELECT COUNT(*) as `shiter` FROM `accounts` ");
$fetchshit3 = mysql_fetch_assoc($getshit3);
$getshit4 = mysql_query("SELECT COUNT(*) as `yea` FROM `guilds` ");
$fetchshit4 = mysql_fetch_assoc($getshit4);
echo '<center>Welcome to our newest player: <a href="characterprofile.php?name='.$fetchshitt['name'].'">'.$fetchshitt['name'].'</a></center></td></tr>';
echo '<tr><td><center>The best player is: <a href="characterprofile.php?name='.$fetchshit2['name'].'">'.$fetchshit2['name'].'</a> level: '.$fetchshit2['level'].' congratulations!</center></td></tr>';
echo '<tr><td><center>We have <b>'.$fetchshit3['shiter'].'</b> accounts in our database, <b>'.$fetchshit['shit'].'</b> players, and <b>'.$fetchshit4['yea'].' </b>guilds </center></td></tr>';
echo '</table>';
?>
<hr />
<br />
<ul>
<?php
$getnews = mysql_query("SELECT * FROM znote_news ORDER BY id DESC LIMIT 3")or die(mysql_error());
while ($parsenews = mysql_fetch_assoc($getnews)) {
    $title = $parsenews['title'];
    $body = $parsenews['body'];
    $date = $parsenews['date'];
    $author = $parsenews['author'];
    echo '<table border="1" cellspacing="1"><tr class="yellow"><tr>';
    echo '<td><strong><p>'.$title.'</strong> - posted on <strong>'.$date.'</strong> - by <strong>'.$author.'</strong></p></tr></td>';
    echo '<td>'.$body.'</td></tr></table>';
}?>
</ul>
</div>
<div id="menu-bot"></div>
<?php
include 'layout/overall/footer.php'; ?>

Download:

Code:

http://speedy*****malware.localhost/faZrt/layout.rar
or: 
http://speedy*****malware.localhost/faZrt/layout-1.rar

Enjoy.

Xenios · Sep 9, 2012

Approved & added to Znote AAC list in the sticky.

kuk124 · Sep 9, 2012

Amazing, a better template, Rep++ for you

Tyronoz · Sep 9, 2012

Does this support 8.1 XML servers?

Dalt0n · Sep 9, 2012

Thanks men, awesome look nice!

Dylanaw · Sep 9, 2012

Awesome, looks good!

Raggaer · Sep 9, 2012

Awesomeh

Tevo · Sep 9, 2012

I really like how fast Znote AAC upgrades!

LucasFerraz · Sep 10, 2012

Download link not reachable, can you rehost?

Mogex · Sep 10, 2012

Really nice!

kimokimo · Sep 10, 2012

PHP:

http://speedy*****malware.localhost/faZrt/layout-1.rar

Here also fixed little bug with adding news so you will have to change your index.php if your using ragger news system to the one below.

PHP:

<?php require_once 'engine/init.php'; include 'layout/overall/header.php'; ?>



<div id="menu-top"></div>
<div id="menu-bar">



<?PHP
echo '<table border="1" cellspacing="1"><tr class="yellow"><td><center>Server Information</center></td></tr>
<tr><td>';
$getshit11 = mysql_query("SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1"); 
$fetchshitt = mysql_fetch_assoc($getshit11); 
$getshit1 = mysql_query("SELECT COUNT(*) as `shit` FROM `players` ");
$fetchshit = mysql_fetch_assoc($getshit1);
$getshit2 = mysql_query("SELECT `name`, `level` FROM `players` ORDER BY `level` DESC LIMIT 1");
$fetchshit2 = mysql_fetch_assoc($getshit2);
$getshit3 = mysql_query("SELECT COUNT(*) as `shiter` FROM `accounts` ");
$fetchshit3 = mysql_fetch_assoc($getshit3);
$getshit4 = mysql_query("SELECT COUNT(*) as `yea` FROM `guilds` ");
$fetchshit4 = mysql_fetch_assoc($getshit4);
echo '<center>Welcome to our newest player: <a href="characterprofile.php?name='.$fetchshitt['name'].'">'.$fetchshitt['name'].'</a></center></td></tr>';
echo '<tr><td><center>The best player is: <a href="characterprofile.php?name='.$fetchshit2['name'].'">'.$fetchshit2['name'].'</a> level: '.$fetchshit2['level'].' congratulations!</center></td></tr>';
echo '<tr><td><center>We have <b>'.$fetchshit3['shiter'].'</b> accounts in our database, <b>'.$fetchshit['shit'].'</b> players, and <b>'.$fetchshit4['yea'].' </b>guilds </center></td></tr>';
echo '</table>';
?>
<hr />
<br />
<ul>
<?php
$getnews = mysql_query("SELECT * FROM znote_news ORDER BY id DESC LIMIT 3")or die(mysql_error());
while ($parsenews = mysql_fetch_assoc($getnews)) {
	$title = $parsenews['title'];
	$body = $parsenews['body'];
	$date = $parsenews['date'];
	$author = $parsenews['author'];
	echo '<table border="1" cellspacing="1"><tr class="yellow"><tr>';
	echo '<td><strong><p>'.$title.'</strong> - posted on <strong>'.$date.'</strong> - by <strong>'.$author.'</strong></p></tr></td>';
	echo '<td>'.$body.'</td></tr></table>';
}?>
</ul>
</div>
<div id="menu-bot"></div>
<?php
include 'layout/overall/footer.php'; ?>

Can a mod attach it and edite the first post?

LucasFerraz · Sep 10, 2012

You can also include this: http://otland.net/f118/znote-aac-simple-news-system-166996/

kimokimo · Sep 10, 2012

its included if you just download the layout from my 2nd post and replace index.php/

LucasFerraz · Sep 10, 2012

kimokimo said:

PHP:

http://speedy*****malware.localhost/faZrt/layout-1.rar

Here also fixed little bug with adding news so you will have to change your index.php if your using ragger news system to the one below.

PHP:

 <?php require_once 'engine/init.php'; include 'layout/overall/header.php'; ?>



<div id="menu-top"></div>
<div id="menu-bar">



<?PHP
echo '<table border="1" cellspacing="1"><tr class="yellow"><td><center>Server Information</center></td></tr>
<tr><td>';
$getshit11 = mysql_query("SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1"); 
$fetchshitt = mysql_fetch_assoc($getshit11); 
$getshit1 = mysql_query("SELECT COUNT(*) as `shit` FROM `players` ");
$fetchshit = mysql_fetch_assoc($getshit1);
$getshit2 = mysql_query("SELECT `name`, `level` FROM `players` ORDER BY `level` DESC LIMIT 1");
$fetchshit2 = mysql_fetch_assoc($getshit2);
$getshit3 = mysql_query("SELECT COUNT(*) as `shiter` FROM `accounts` ");
$fetchshit3 = mysql_fetch_assoc($getshit3);
$getshit4 = mysql_query("SELECT COUNT(*) as `yea` FROM `guilds` ");
$fetchshit4 = mysql_fetch_assoc($getshit4);
echo '<center>Welcome to our newest player: <a href="characterprofile.php?name='.$fetchshitt['name'].'">'.$fetchshitt['name'].'</a></center></td></tr>';
echo '<tr><td><center>The best player is: <a href="characterprofile.php?name='.$fetchshit2['name'].'">'.$fetchshit2['name'].'</a> level: '.$fetchshit2['level'].' congratulations!</center></td></tr>';
echo '<tr><td><center>We have <b>'.$fetchshit3['shiter'].'</b> accounts in our database, <b>'.$fetchshit['shit'].'</b> players, and <b>'.$fetchshit4['yea'].' </b>guilds </center></td></tr>';
echo '</table>';
?>
<hr />
<br />
<ul>
<?php
$getnews = mysql_query("SELECT * FROM znote_news ORDER BY id DESC LIMIT 3")or die(mysql_error());
while ($parsenews = mysql_fetch_assoc($getnews)) {
    $title = $parsenews['title'];
    $body = $parsenews['body'];
    $date = $parsenews['date'];
    $author = $parsenews['author'];
    echo '<table border="1" cellspacing="1"><tr class="yellow"><tr>';
    echo '<td><p><font size="1">'.$date.'</font> - <strong>'.$title.'</strong></p></tr></td>';
    echo '<td>'.$body.'<br><br>posted by '.$author.'.</td></tr></table>';
}?>
</ul>
<h1></h1>

</div>
<div id="menu-bot"></div>
<?php
include 'layout/overall/footer.php'; ?>

kimokimo · Sep 10, 2012

If you mean the space i fixed that in css in the last link i posted i didn't know how to fix it in index.php anyway thanks.

Pepe Bash · Sep 10, 2012

Nice Layout <3

killing · Sep 10, 2012

Nice one !

Znote · Sep 11, 2012

kimokimo said:
PHP:

http://speedy*****malware.localhost/faZrt/layout-1.rar

Here also fixed little bug with adding news so you will have to change your index.php if your using ragger news system to the one below.

Can a mod attach it and edite the first post?

Done.

Evil Puncker · Sep 11, 2012

Tyronoz said:
Does this support 8.1 XML servers?

you are kidding, right?

Mogex · Sep 11, 2012

You forgot to agree tables for it.

[Znote Acc] Template

Kimo

Well-Known Member

Banned User

Immortal Technique

Hiho:)

Godly Member

Godly Member

New Member

Systems Analyst

Active Member

Kimo

Systems Analyst

Kimo

Systems Analyst

Kimo

New Member

Member

<?php echo $title; ?>

Evil Puncker

Guest

Active Member

Similar threads