I copied that piece from habbo ;o
---------- Post added at 08:35 PM ---------- Previous post was at 07:13 PM ----------
http://img684.imageshack.us/img684/4678/knipselym.png
Printable View
I copied that piece from habbo ;o
---------- Post added at 08:35 PM ---------- Previous post was at 07:13 PM ----------
http://img684.imageshack.us/img684/4678/knipselym.png
Finaly, It tooks me some miniut for the query but it works x]
http://img35.imageshack.us/img35/9210/knipselr.png
Able to add friends with the search tool!
Not the best query x]PHP Code:SELECT `users`.*,
IFNULL((SELECT `user_friendships`.`id`
FROM `user_friendships`
WHERE CASE WHEN `user_friendships`.`user_id` = "'.USER_ID.'"
THEN `users`.`id` = `user_friendships`.`friend_id`
ELSE `users`.`id` = `user_friendships`.`user_id`
END LIMIT 1), 0) AS `is_friends`
FROM `users`
WHERE `users`.`username` LIKE "%'.$searchString.'%"
OMG, I'm on the screen :')
Good job joopie ;D
Omg : Its me, and i love it :P
A little preview of the Home catalogus `Uber converted to my own`
http://img69.imageshack.us/img69/3043/knipselw.png
I like it. No doubt! It's awesome, but the mysql query of the friends\ could be easier, but it doesn't matter :)
You know in housekeeping, when you post news, could you maybe add another option or something, with a text box, and you can type in a URL (locally?) and it uses a thumbnail (like Habbo has)
This looks fantastic so far joopie, keep up the fantastic work!
You have a hotel test?