[PHP, OOP, MySQLi] sulakeWEB

Read on mysql: inner join

Much better !
Posted via Mobile Device

Make it so Phoenix Emulator works with it too.

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.

Quote:

---

Originally Posted by Pure

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 ;)
Posted via Mobile Device

Quote:

---

Originally Posted by Matthew

Use APC.

---

APC will not be included in PHP 5.4.0, so he shouldn't use it.

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 ;)

Quote:

---

Originally Posted by Tr0ll.™

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

Quote:

---

Originally Posted by Law

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

---

Funny enough, I was just about to post that. You beat me to it :glare:

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...

https://github.com/Makarovich/CMSula...fault/main.css

You see? Just wanted to let you know.

Quote:

---

Originally Posted by Law

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 ----------

Quote:

---

Originally Posted by Kryptos

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...

https://github.com/Makarovich/CMSula...fault/main.css

You see? Just wanted to let you know.

---

Didn't know, It's old now anyways I'm not updating that till release.

Taking a break. I'll start posting updates in a week with a brand new more habbo-ish style!

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 (Blog.ME-Index) I will be implementing a lot of javascript and jQuery in CMSulake now. Lessen the front end pages and it'll look sexy too.

http://screensnapr.com/e/4j8xDB.png

Anyone likey?

Quote:

---

Originally Posted by Makarov

http://screensnapr.com/e/4j8xDB.png

Anyone likey?

---

Alot better, let's just see how the main site turns out!

I'm re-writing it from the ground up.
Index's Template
http://screensnapr.com/e/CJSMtI.png
The Index's PHP Code
http://screensnapr.com/e/V8yiB3.png
Global
http://screensnapr.com/e/pxRAXF.png
http://screensnapr.com/e/qYtanf.png