Example #1
0
     if (!$row) {
         $sql = "INSERT INTO " . PROFILE_FIELDS_DATA_TABLE . " (user_id, pf_meeting_auth) VALUES ({$meeting_user}, 1)";
         $db->sql_query($sql);
     } else {
         $count_auth = $row['pf_meeting_auth'] + 1;
         $sql = "UPDATE " . PROFILE_FIELDS_DATA_TABLE . "\n\t\t\t\tSET pf_meeting_auth = {$count_auth}\n\t\t\t\tWHERE user_id = {$meeting_auth}";
         $db->sql_query($sql);
     }
     //------------------------------------
     if ($meeting_coorg != 1) {
         $sql2 = 'UPDATE ' . USERS_TABLE . "\n\t\t\t\tSET user_meeting_coauth = user_meeting_coauth + 1\n\t\t\t\tWHERE user_id = " . $meeting_coorg;
         $db->sql_query($sql2);
     }
 } else {
     //Ïðîâåðÿåì, åñëè èçìåíåíî íà àíîíñ ëè íàîáîðîò, òî èçìåíÿåì çíà÷åíèÿ ó àâòîðîâ
     $meeting->change_autor_anonce($meeting_anonce, $meeting_auth, $id);
     if ($meeting_coorg) {
         $sql = "SELECT meeting_coorg FROM " . MEETING_DATA_TABLE . "\n\t\t\t\tWHERE meeting_id = " . $id;
         $result = $db->sql_query($sql);
         $row = $db->sql_fetchrow($result);
         $db->sql_freeresult($result);
         $old_coorg = $row['meeting_coorg'];
         if (!$row || $old_coorg == 1) {
         } else {
             $sql = 'UPDATE ' . USERS_TABLE . "\n\t\t\t\t\tSET user_meeting_coauth = user_meeting_coauth-1\n\t\t\t\t\tWHERE user_id = " . $old_coorg;
             $db->sql_query($sql);
         }
         //??????
         if ($meeting_coorg != $old_coorg) {
             $sql2 = 'UPDATE ' . USERS_TABLE . "\n\t\t\t\t\tSET user_meeting_coauth = user_meeting_coauth+1\n\t\t\t\t\tWHERE user_id = " . $meeting_coorg;
             $db->sql_query($sql2);