location @ forum
Asked Modified Viewed 2,383 times
asked
how to add a location?
Hi what php fusion version are you using ?
answered
v7.02.04
Okey open forum/viewthread.php and find (line 216)
Replace with
Find this (line 284)
Add this after
Code Download source
$result = dbquery(
"SELECT p.forum_id, p.thread_id, p.post_id, p.post_message, p.post_showsig, p.post_smileys, p.post_author,
p.post_datestamp, p.post_ip, p.post_ip_type, p.post_edituser, p.post_edittime, p.post_editreason,
u.user_id, u.user_name, u.user_status, u.user_avatar, u.user_level, u.user_posts, u.user_groups, u.user_joined,
".($user_field['user_sig'] ? " u.user_sig," : "").($user_field['user_web'] ? " u.user_web," : "")."
u2.user_name AS edit_name, u2.user_status AS edit_status
FROM ".DB_POSTS." p
LEFT JOIN ".DB_USERS." u ON p.post_author = u.user_id
LEFT JOIN ".DB_USERS." u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='".$_GET['thread_id']."' AND post_hidden='0'
ORDER BY post_datestamp LIMIT ".$_GET['rowstart'].",$posts_per_page"
);
Replace with
Code Download source
$result = dbquery(
"SELECT p.forum_id, p.thread_id, p.post_id, p.post_message, p.post_showsig, p.post_smileys, p.post_author,
p.post_datestamp, p.post_ip, p.post_ip_type, p.post_edituser, p.post_edittime, p.post_editreason,
u.user_id, u.user_name, u.user_status, u.user_avatar, u.user_level, u.user_posts, u.user_groups, u.user_joined, u.user_location
".($user_field['user_sig'] ? " u.user_sig," : "").($user_field['user_web'] ? " u.user_web," : "")."
u2.user_name AS edit_name, u2.user_status AS edit_status
FROM ".DB_POSTS." p
LEFT JOIN ".DB_USERS." u ON p.post_author = u.user_id
LEFT JOIN ".DB_USERS." u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='".$_GET['thread_id']."' AND post_hidden='0'
ORDER BY post_datestamp LIMIT ".$_GET['rowstart'].",$posts_per_page"
);
Find this (line 284)
Code Download source
echo "<span class='small'><strong>".$locale['504']."</strong> ".showdate("shortdate", $data['user_joined'])."</span><br />\n";
Add this after
Code Download source
include LOCALE.LOCALESET."user_fields/user_location.php";
echo ($data['user_location'] != "" ? "<span class='small'><strong>".$locale['uf_location']."</strong> ".$data['user_location']."</span><br />\n" : "");
Edited by DrunkeN on 09-12-2011 19:26,
answered
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.user_sig, u.user_web, u2.user_name AS edit_name, u2.user_status AS edit_s' at line 4
Opps sorry i forgave one thing
Code Download source
$result = dbquery(
"SELECT p.forum_id, p.thread_id, p.post_id, p.post_message, p.post_showsig, p.post_smileys, p.post_author,
p.post_datestamp, p.post_ip, p.post_ip_type, p.post_edituser, p.post_edittime, p.post_editreason,
u.user_id, u.user_name, u.user_status, u.user_avatar, u.user_level, u.user_posts, u.user_groups, u.user_joined, u.user_location,
".($user_field['user_sig'] ? " u.user_sig," : "").($user_field['user_web'] ? " u.user_web," : "")."
u2.user_name AS edit_name, u2.user_status AS edit_status
FROM ".DB_POSTS." p
LEFT JOIN ".DB_USERS." u ON p.post_author = u.user_id
LEFT JOIN ".DB_USERS." u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='".$_GET['thread_id']."' AND post_hidden='0'
ORDER BY post_datestamp LIMIT ".$_GET['rowstart'].",$posts_per_page"
);
answered
— 5 months later —
cheap homecoming dressescheap homecoming dresses homework a that youare able to keep tabs without having to ask a single question. Your kids learn table manners lace wedding dresseslace wedding dresses . . . This is kind of a minor benefit, but itas nice when it happens cheap homecoming dressescheap homecoming dresses lace dresseslace dresses . . It starts out naturally, as youare teaching them to eat with forks when theyare 2 and how to use a knife when theyare 8ish. But if you want to step it up a notch, you can always light candles and use cloth napkins from time to time, simply so that your children wonat find it uncomfortable or act like barbarians when you go out to restaurants sexy prom dressessexy prom dresses . Your kids will learn to make great table conversation. This is my favorite part. Did you know that kids have no understanding of how to jump into a conversationThey have to be taught that when theyare about 5. Itas a slow learning process from about 5 years on, cute dressescute dresses . but when you have several people sitting around a table, all trying to tell their
Category Forum
Modifications and Requests - 8Labels
None yet
Statistics
- Views 0 views
- Posts 7 posts
- Votes 0 votes
- Topic users 2 members
2 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions