Hello everybody.
I made a function for my community reagding friends and realtions and sow on!
The thing is now is there a beter way to code my function.
Here is it.
<?php
function editrel() {
$maketime = 1;
$timestamp = gmdate("Y-m-d H:i:s", time() + 3600 + $maketime * 3600);
$new_comment = htmlspecialchars($_POST['fed_comment']);
$new_friendship = htmlspecialchars($_POST['fed_rel']);
$fed_bfe = isset($_POST['fed_bfe']) ? 'yes' : 'no';
$result1 = mysql_query("
SELECT ID,fd_type FROM
friend_list
WHERE
fd_accID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]' AND ID='$_GET[fdID]'");
$update_accID = mysql_fetch_assoc($result1);
$result2 = mysql_query("
SELECT ID,fd_type FROM
friend_list
WHERE
fd_accID='$_GET[usernameID]' AND fd_reqID='$_SESSION[regid]' AND ID='$_GET[fdID]'");
$update_reqID = mysql_fetch_assoc($result2);
if(mysql_num_rows($result1) == 1 && $update_accID['fd_type'] != $new_friendship){
mysql_query("
UPDATE friend_list SET
fd_valid='no', fd_accID_value='yes', fd_reqID_value='no', fd_accID_irl='$fed_bfe',
fd_accID_cmt='$new_comment', fd_type='$new_friendship', fd_reqstamp='$timestamp'
WHERE
(fd_accID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]') AND ID='$_GET[fdID]'");
if (mysql_error() != "") {
echo mysql_error();
exit;
}
}elseif(mysql_num_rows($result1) == 1 && $update_accID['fd_type'] == $new_friendship){
mysql_query("
UPDATE friend_list SET
fd_accID_irl='$fed_bfe', fd_accID_cmt='$new_comment'
WHERE
(fd_accID='$_SESSION[regid]' AND fd_reqID='$_GET[usernameID]') AND ID='$_GET[fdID]'");
if (mysql_error() != "") {
echo mysql_error();
exit;
}
}
if(mysql_num_rows($result2) == 1 && $update_reqID['fd_type'] != $new_friendship){
mysql_query("
UPDATE friend_list SET
fd_valid='no', fd_reqID_value='yes', fd_accID_value='no', fd_reqID_irl='$fed_bfe',
fd_reqID_cmt='$new_comment', fd_type='$new_friendship'fd_reqstamp='$timestamp'
WHERE
(fd_reqID='$_SESSION[regid]' AND fd_accID='$_GET[usernameID]') AND ID='$_GET[fdID]'");
if (mysql_error() != "") {
echo mysql_error();
exit;
}
}elseif(mysql_num_rows($result2) == 1 && $update_reqID['fd_type'] == $new_friendship){
mysql_query("
UPDATE friend_list SET
fd_reqID_irl='$fed_bfe', fd_reqID_cmt='$new_comment'
WHERE
(fd_reqID='$_SESSION[regid]' AND fd_accID='$_GET[usernameID]') AND ID='$_GET[fdID]'");
if (mysql_error() != "") {
echo mysql_error();
exit;
}
}
}?>
