[PHP][MYSQL]LOCK TABLES Opcje

[sitak]

[PHP] pobierz, plaintext 
<?php
function SendSimpleMessage ( $Owner, $Sender, $Time, $Type, $From, $Subject, $Message) {
    global $messfields;
 
    if ($Time == '') {
        $Time = time();
    }
 
    $QryInsertMessage  = "INSERT INTO {{table}} SET ";
    $QryInsertMessage .= "`message_owner` = '". $Owner ."', ";
    $QryInsertMessage .= "`message_sender` = '". $Sender ."', ";
    $QryInsertMessage .= "`message_time` = '" . $Time . "', ";
    $QryInsertMessage .= "`message_type` = '". $Type ."', ";
    $QryInsertMessage .= "`message_from` = '". addslashes( $From ) ."', ";
    $QryInsertMessage .= "`message_subject` = '". addslashes( $Subject ) ."', ";
    $QryInsertMessage .= "`message_text` = '". addslashes( $Message ) ."';";
    doquery( $QryInsertMessage, 'messages' );
    
    
 
    $QryUpdateUser  = "UPDATE {{table}} SET ";
    $QryUpdateUser .= "`".$messfields[$Type]."` = `".$messfields[$Type]."` + 1, ";
    $QryUpdateUser .= "`".$messfields[100]."` = `".$messfields[100]."` + 1 ";
    $QryUpdateUser .= "WHERE ";
    $QryUpdateUser .= "`id` = '". $Owner ."';";
    doquery( $QryUpdateUser, 'users');
    
    
 
}
?>
[PHP] pobierz, plaintext 

Po dopisaniu do powyższej funkcji kodu:

[PHP] pobierz, plaintext 
<?php
$QryInsertMessage  = "INSERT INTO {{table}} SET ";
    $QryInsertMessage .= "`message_owner` = '". $Owner ."', ";
    $QryInsertMessage .= "`message_sender` = '". $Sender ."', ";
    $QryInsertMessage .= "`message_time` = '" . $Time . "', ";
    $QryInsertMessage .= "`message_type` = '". $Type ."', ";
    $QryInsertMessage .= "`message_from` = '". addslashes( $From ) ."', ";
    $QryInsertMessage .= "`message_subject` = '". addslashes( $Subject ) ."', ";
    $QryInsertMessage .= "`message_text` = '". addslashes( $Message ) ."';";
    doquery( $QryInsertMessage, 'messages1' );
?>
[PHP] pobierz, plaintext 

dostaje błąd
Table 'game_messages1' was not locked with LOCK TABLES
INSERT INTO game_messages1 SET `message_owner` = '1', `message_sender` = '', `message_time` = '1249030741', `message_type` = '5', `message_from` = 'Kontrola lotu', `message_subject` = 'Transport Floty', `message_text` = 'Jedna z Twoich flot osiągneła Kolonia [1:1:1]. Dostarczyła 1 jednostek Metal, 0 jednostek Kryształ i 0 jednostek Deuter.';

Da sie to zrobić w jakiś prosty sposób (IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif)

Ten post edytował sitak 31.07.2009, 10:04:36

[Fifi209]

Liczb nie daje się w apostrofy to po pierwsze. Po drugie message_id ma auto_increment ?