Moving to better URLs

5 years ago by b1ind

Peter, it turns out that mod_rewrite works on this server. However, to use it, all relative urls (for css, images, etc) must be made absolute. Otherwise, the browser has a difficult time finding the appropriate resources.

I made a temporary hack to allow css to work. I just put '/'s before each css url.

Another thing I did is what I said I would do a while back, which is to move everything to a safer (more secure) dir structure on the server. I made a dir /onelobby to hold exports from the svn repo. I also made the dir dev.onelobby.com into a symlink pointing to onelobby/upload/wwwroot/. That way, nothing outside the upload/wwwroot/ dir is accessible from the browser. This (I think) is the proper way of laying things out.

Tags: dev
OneLobby
QueryQuery TimeAffected Rows
SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1  AND u.role_id=r.role_id  AND p.role_id=r.role_id  AND o.object_id=p.object_id ORDER BY r.perm_level ASC

 0.7289 

 3 

 
SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.thread_id=11 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id LIMIT 1

 0.7396 

 1 

 
UPDATE `k4_threads` SET views=113 WHERE thread_id=11

 0.0563 

 1 

 
SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=11 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC

 0.8301 

 1