Post here your Solarose frontpage (competition)

Solarose frontpage (1 page).

Competition will be divided into 2 catagories :

1. Design (Reward Fashion Set). The most beautiful design but efficient (in term of bandwidth).

2.
Function (Typhoon Set). Function must has working Server Status Checker
(online or not), how many player online, and which GM currently online.
All in one page. Additional info, creative design, link and text are bonus.

Dateline : 30 September 2008

Sir, could you give any example? Somehow.. I dont understand

Yes sir, even Though im Dumb... This is my Limit...

I think he means
1. http://solarose.niceboard.org/portal.htm
Design for that.

And 2. http://solarose.myftp.org/solarose/
See the server status?
He wants that.
Except with the number of GMs online included.

That's what I think, anyways =/

I can't get the osrose to work because it has deadlinks -- so I'm out of this competition. We need smarty people who have at least ran a server to do the 2nd part.

Pseudien wrote:

I think he means
1. http://solarose.niceboard.org/portal.htm
Design for that.

And 2. http://solarose.myftp.org/solarose/
See the server status?
He wants that.
Except with the number of GMs online included.

That's what I think, anyways =/

I can't get the osrose to work because it has deadlinks -- so I'm out of this competition. We need smarty people who have at least ran a server to do the 2nd part.

i Still dont understand..

Admin, could you explain for us?

I think for number 1 he means the website http://solarose.myftp.org

http://img29.picoodle.com/data/img29/3/8/31/f_SolaroseDesm_90dfd92.jpg
http://img33.picoodle.com/data/img33/3/8/31/f_SolaroseDesm_63fb775.jpg


Is this what you mean sir? I cant make a good one, couse i dont understand what u need.. lol

or u mean this :

Deleted.. Big Image.. Lol

Big images.. lol

However..

Could that 'Template' use some things?

Like Screenshots, How to connect, Server Info ( Rates, Staff, etc. )

http://img28.picoodle.com/data/img28/3/9/8/f_SolaroseDesm_f5e8510.jpg

Hows This One?

I will delete Design by Prefix later.. Some of here can use it (bandit)

mhm.. Making New One Design At the moment..

The design will be from brushes ^^

Undone Version of my Design :

http://img28.picoodle.com/data/img28/3/9/11/f_123456789m_54c9f0d.jpg

Feel free to comment. I need to know mistakes

@ Gravit :

Heres the code for the Who is online function. Try it.

1. 
   
2. <?php
   
3. /* Who is online script by Rifke for OsRose Comunity
   
4. */
   
5. echo '<h1> Who is online? </h1>';
   
6. $sql = "SELECT lastchar FROM accounts WHERE online=1 AND accesslevel < 300";
   
7. $query = mysql_query($sql);
   
8. if ( $query === false ) {
   
9. echo 'Could not check who is online due a database issue';
   
10. // If you see this line uncomment this line below
    
11. //echo '<br />MySQL error: '.mysql_error().' in query: '.nl2br($sql).'<br />';
    
12. } elseif ( mysql_num_rows($query) == 0 ) {
    
13. // Checks if there are players online. Saves a while loop ^^
    
14. echo 'There are no players online';
    
15. } else {
    
16. // You could add your own layout to it
    
17. echo '<ul>';
    
18. while ( $data = mysql_fetch_assoc($query) ) {
    
19. echo '<li>'.$data['lastchar'].'</li>';
    
20. }
    
21. echo '</ul>';
    
22. }
    
23. /* This is very simple it would output something like:
    
24. * Rescudo
    
25. * Miltown
    
26. * Rifke
    
27. * Lmame
    
28. * Geobot
    
29. */
    
30. ?>
    
31. 
    

i think with numbers or without it.. lol..

I have no experience in CMS

Done Version :

http://img29.picoodle.com/data/img29/3/9/11/f_SolaDesignm_8861097.jpg




Not so good x_x

@ Gravit :

My next entry ^^ Its better

http://img33.picoodle.com/data/img33/3/9/11/f_123copym_b8ab7d9.jpg

Working 'How many GMs online':


Function:

Quote :

function gmon() {
$result = mysql_query("SELECT online FROM accounts WHERE online = '1' AND accesslevel = 300");
$rows = mysql_num_rows($result);
echo $rows ;
}

and to add the value of GMs online just type in

Quote :

<?php gmon(); ?>

wherever you want the value to show up.


Working 'Who is online'(in alphabetical order):

Code:

Quote :

<?php
$result = mysql_query("SELECT lastchar FROM accounts WHERE online = '1' ORDER BY lastchar ASC")
or die(mysql_error());
echo "<table border='0' class='b01'>";
echo "<tr> <th>Character Name</th> </tr>";
while($row = mysql_fetch_array( $result )) {
echo "<tr><td bgcolor=''>";
echo $row['lastchar'];
echo "</td><td bgcolor=''>";
echo "</td></tr>";
}
echo "</table>";
?>

Working Which GM is online:
Looks like the Who is online.
Code:

Quote :

<?php
$result = mysql_query("SELECT lastchar FROM accounts WHERE online = '1' AND accesslevel = '300' ORDER BY lastchar ASC")
or die(mysql_error());
echo "<table border='0' class='b01'>";
echo "<tr> <th>Character Name</th> </tr>";
while($row = mysql_fetch_array( $result )) {
echo "<tr><td bgcolor=''>";
echo $row['lastchar'];
echo "</td><td bgcolor=''>";
echo "</td></tr>";
}
echo "</table>";
?>

I can change it around to include GGs, too, if you wish.

Uhhuhu wrote:

Config.php for all


$dbhost = "localhost"; // Change this to your database server
$dbname = "roseon"; // Change this to your database name
$dbuser = "roseon"; // Change this to your database username
$dbpswd = "roseon"; // Change this to your database password
?>



Online Players


include("config.php");
// Connect to the database
$db = mysql_connect($dbhost, $dbuser, $dbpswd) or die("Could not connect to server database");
mysql_select_db($dbname, $db);
// Select all the banned users and display them
$result = mysql_query("SELECT * FROM accounts WHERE online = '1'", $db) or die(mysql_error());

while($row = mysql_fetch_array( $result )) {
echo "".$row['lastchar']."
";
}
mysql_close($db);
?>

Try that

Also Try This :

if(stristr($_SERVER['PHP_SELF'], "ponline.php")) die('Do not open without inlcude!');
?>
Online Stats


$result = mysql_query("SELECT
username,
online,
accesslevel
FROM
accounts
WHERE
online = 1
ORDER BY
username ASC") or die(mysql_error());
if(mysql_num_rows($result)) {
?>
Online: ( GM 1) { echo "s"; } ?>)






while($row = mysql_fetch_array($result)) {
?>



}
?>
Name

if($row['accesslevel'] > 100) { echo "".htmlentities($row['username'],ENT_QUOTES).""; } else { echo htmlentities($row['account_name'],ENT_QUOTES); } ?>

} else {
echo "No Players Online!";
}
?>

CMS

Is that OLD Solarose CMS? xD

I think, that online stats are in that thingy ^^

Could Someone delete all my Posts, related with Who is online function? x_x

Dont wanna spam it.

Better i will leave Who is Online funtion to arrr.


Next Design :

https://2img.net/r/ihimizer/img55/6446/88044941lf8.jpg