Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[PHP, OOP, MySQLi] sulakeWEB

Status
Not open for further replies.
Master Summoner
Joined
Jul 12, 2009
Messages
530
Reaction score
655
Re: [PHP, OOP]CMSulake

To me that's the hardest part of this whole project for me because I don't have any creativity what so ever, but designing my own CSS is helping me understand a lot more.

But i like you're creating one yourself. :D:
 
Joined
Apr 28, 2010
Messages
2,794
Reaction score
1,178
Re: [PHP, OOP]CMSulake

I'm about to start Minimail. I wanted to make it nice so I'm adding Dominic Gunn's script to it

Makarov - [PHP, OOP, MySQLi] sulakeWEB - RaGEZONE Forums


It's a pretty basic idea of inserting into a database/reading from the database. I should be done in 10 minutes or so, I'll show you all after I finish some homework :]

---------- Post added at 08:58 PM ---------- Previous post was at 06:13 PM ----------

Ok Minimail is pretty much done minus the submission.

Mail.tpl
PHP:
<div class="Big-Left">
<div class="bhead" id="red">Minimail</div>
<?php
global $db,$users,$funcs;
    $result = $db->Select("SELECT * FROM mail WHERE reciever = '".$_SESSION['username']."' ORDER BY timestamp DESC LIMIT 5");
     
    while($r = $db->Fetch_Array($result)){
        $user = $db->Select("SELECT * FROM users WHERE username = '".$r['sender']."'");
        while($u = $db->Fetch_Array($user)){
            echo $users->RetrieveHead($u['look']).' <b>From:</b> '.$r['sender'].' <b>Title:</b> '.$r['title'].'<div style="float: right"><a href="#" class="Show">Show/hide</a>
'.$r['date'].'</div><br />';
            echo '<div class="Mail">'.$r['message'].'</div>';
        }
    }
?>
</div>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.js" type="text/javascript"></script>
<script type="text/javascript">
# You'll see on release #
</script>

Image(Hidden)
Makarov - [PHP, OOP, MySQLi] sulakeWEB - RaGEZONE Forums


Image(Shown)
Makarov - [PHP, OOP, MySQLi] sulakeWEB - RaGEZONE Forums
 
Newbie Spellweaver
Joined
Aug 26, 2011
Messages
42
Reaction score
2
Re: [PHP, OOP]CMSulake

Make it so Phoenix Emulator works with it too.
 
Joined
May 11, 2008
Messages
513
Reaction score
99
Re: [PHP, OOP]CMSulake

Dude, I would only grab what you need and also in one query.. for instance..

Code:
 SELECT u.username, u.look, m.id, m.message 

   FROM minimail AS m, users AS u

 WHERE 

 u.id = m.id_user

 ORDER BY m.posted_timestamp DESC

 LIMIT 0, 10

That is just an example, do some research into multi table queries.
 
Joined
Jun 23, 2010
Messages
2,357
Reaction score
2,198
Dude, I would only grab what you need and also in one query.. for instance..

Code:
 SELECT u.username, u.look, m.id, m.message 

   FROM minimail AS m, users AS u

 WHERE 

 u.id = m.id_user

 ORDER BY m.posted_timestamp DESC

 LIMIT 0, 10

That is just an example, do some research into multi table queries.

Inner join is better for that ;)
 
Joined
Apr 28, 2010
Messages
2,794
Reaction score
1,178
Re: [PHP, OOP]CMSulake

I'm not sure why but Minimail is lagging the hell out of the me page even though it's the last thing loaded, so I will be commenting it out and if anyone still wants it it will be there and you can un-comment it ;)
 

Law

Garry's Mod is addictive!
Joined
Dec 11, 2009
Messages
697
Reaction score
171
Re: [PHP, OOP]CMSulake

I'm not sure why but Minimail is lagging the hell out of the me page even though it's the last thing loaded, so I will be commenting it out and if anyone still wants it it will be there and you can un-comment it ;)

Enable and disable minimail in config file, problem solved for now? xdd
 
Joined
Feb 5, 2010
Messages
415
Reaction score
244
Re: [PHP, OOP]CMSulake

I just looked at the GitHub, and noticed how you deleted the main.css -- I think you don't know know but GitHub has histories, so you can get the first commit whenever...



You see? Just wanted to let you know.
 
Joined
Apr 28, 2010
Messages
2,794
Reaction score
1,178
Re: [PHP, OOP]CMSulake

Enable and disable minimail in config file, problem solved for now? xdd

It isn't that big of a deal to make a whole configuration value for it.

---------- Post added at 09:03 PM ---------- Previous post was at 08:58 PM ----------

I just looked at the GitHub, and noticed how you deleted the main.css -- I think you don't know know but GitHub has histories, so you can get the first commit whenever...



You see? Just wanted to let you know.

Didn't know, It's old now anyways I'm not updating that till release.
 
Joined
Apr 28, 2010
Messages
2,794
Reaction score
1,178
Re: [PHP, OOP]CMSulake

Ok guys, I've been researching a lot with jQuery and I'm going to start re-coding the front end of CMSulake. If you want to see some of my jQuery skills ( ) I will be implementing a lot of javascript and jQuery in CMSulake now. Lessen the front end pages and it'll look sexy too.
 
Status
Not open for further replies.
Back
Top