NukeCoder

Code Authors · Joined: Dec 09, 2006 Posts: 333

Just curious why you chose this particular method over using something like mootools ?

Site Admin Joined: Oct 25, 2004 Posts: 920

I didn't really feel the need to use a library to do something so simple. I'd rather not have ~10,000 lines of code when it can be done with 200. Though I admit I've never even looked at mootools, I'm guessing it is similar to alot of the other js frameworks(You can do so many things with the framework, but if you only need one little thing it ends up being overkill)

Code Authors · Joined: Dec 09, 2006 Posts: 333

Yes thats a good point. The compressed version of the mootools framework is about 100kb so even with js caching it is still a fair amount of overhead.

If/when you have time, would you mind posting your altered sql code? I'm assuming you had to alter it to retrieve the post text?

Site Admin Joined: Oct 25, 2004 Posts: 920

I sure will, but I just did a fresh install of ubuntu 8.04 so I don't have all my files back on here yet. As soon as I get things back in order I'll post the code.

PS. The new ubuntu is really sweet, about 20x easier to install and set up then the previous install I had of 7.04.

Code Authors · Joined: Dec 09, 2006 Posts: 333

No worries Smile

I have still not got the video driver working. I'm sure it is telling me lies as I installed Envyng through Synaptic but it does appear any where. If I use the terminal and do a
nvidia-settings it says not installed. If I unstall from the terminal with sudo apt-get envyng -tgk it says no repository <sigh> so I'm going to try xconfig.
Not overly worried though as I'm learning as I go along Smile

Site Admin Joined: Oct 25, 2004 Posts: 920

That is strange, envyNg installed the drivers for me without problem and it showed up in the menu under "System Tools". If you can't see it, you can try running this command from the terminal...

Code:

/usr/share/envy/launcher

After you run envy and get drivers installed reboot and then go back to the terminal and run...

Code:

sudo apt-get install nvidia-settings

Once installed, you can try nvidia-settings in the term. again and it should run.

Code Authors · Joined: Dec 09, 2006 Posts: 333

OK I'll try that on the laptop.
I'm running it on my PC now with the 'restricted' 3D driver without a problem but I will check to make sure it is the right driver in use.

The only issue I'm having with the PC is the damn wireless connection argh!!
From the top menu button I can see the option to 'manally configure' wireless network but when I hit it, the options available all seem to be related to a dial-up connection lol.
The network uses WEP encryption so I think I need to something else. The wireless card uses (under windows) an ndis driver so I have found the wireless utility 'ndiswarapper' which I think I need and installed it but when I run the config utility it asks me for an .inf file and of course I have no darn idea where that is.
It's all good fun Wink

Site Admin Joined: Oct 25, 2004 Posts: 920

Guardian wrote:

If/when you have time, would you mind posting your altered sql code? I'm assuming you had to alter it to retrieve the post text?

Just happened to open my block and remembered this post... Here is my sql, but keep in mind I have alot of non-standard things in this block to parse bbcode and smilies Wink

Code:

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, f.forum_name, f.forum_id, pt.post_text, pt.bbcode_uid
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2, ".FORUMS_TABLE." f, " . POSTS_TEXT_TABLE . " pt
WHERE t.topic_poster = u.user_id
AND t.forum_id=f.forum_id AND f.auth_view=0
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND p2.post_id = pt.post_id
AND u2.user_id = p2.poster_id
AND t.topic_type <> 3
ORDER BY p2.post_time DESC, t.topic_last_post_id DESC
LIMIT 10";

Code Authors · Joined: Dec 09, 2006 Posts: 333

Thanks for that! I'll try it out when I get back from my vacation Smile