oregon core webshop issue

[ak47sigh]

Hello im using oregon core 2.4.3 last rev, I got webwow cms, and my vote shop doesnt send the item ingame:

I get this error:

Mail is not sent! Error returned: Unknown column 'sender' in 'field list'
INSERT INTO mail_external(sender, receiver, subject, message, money, stationery, sent) VALUES("23","23", "WebsiteVoteShopREF412195530", "Enjoy your new reward! Item costed 1 points. Time sent: 12-04-2011, 07:55 Item ID:25", "0", 0, 1)

the trinity_Sendmail.php file looks like:
or pastebin here: [PHP] 123123123123 - Pastebin.com

$query_string ='INSERT INTO mail_external(sender, receiver, subject, message, money, stationery, sent) VALUES("'.$playerguid.'","'.$playerguid.'", "'.$subject.'", "'.$text.'", "'.$money.'", 0, 1)';
        $sendmail=false;
    $db->query($query_string) or ($sendmail=mysql_error());
    //find mail id and add item
    $sql1 = $db->query("SELECT id FROM mail_external WHERE subject='".$subject."' AND receiver='".$playerguid."' LIMIT 1")or ($sendmail.=mysql_error());
    $sql2=$db->fetch_array($sql1);
    if($sendmail==false && $sql2[0]<>'')
        $db->query("INSERT INTO mail_external_items (mail_id,item) VALUES ('".$sql2[0]."','".$item."')") or ($sendmail.=mysql_error());
    if($sendmail==false)
        return  "<!-- success --><span class=\"colorgood\">Mail is sent! <br>All done!</span>";
    else
        return  "<span class=\"colorbad\">Mail is not sent! Error returned: ".$sendmail."<br>".$query_string;
    

}
function sendmail_secondpatch($playername,$playerguid, $subject, $text, $item, $shopid=0, $money=0, $realmid=false) //returns, IMPORTANT: do not remove <!-- success --> if success
{
    //send normal, item only 
    global $db,$a_user,$db_translation;
    $subject = preg_replace( "/[^A-Za-z0-9]/", "", $subject); //no whitespaces
    $item = preg_replace( "/[^0-9]/", "", $item); //item id
    $playerguid = preg_replace( "/[^0-9]/", "", $playerguid); //item id
    $text = preg_replace( "/[^A-Za-z0-9!-:.? ]/", "", $text); //no whitespaces
    $money= preg_replace( "/[^0-9]/", "", $money);
    


    if ($item=='')//send item
        $item="0";
    if ($money=='')
        $money=0;
    
    
    $insert_data = array(
            '%reciver%'     => $playerguid,
            '%subject%'     => $db->escape($subject),
            '%message%'     => $db->escape($text),
            '%money%'       => $money,
            '%item%'        => $item,
            '%item_count%'  => 1
        );
        $query_string = strtr('INSERT INTO mail_external(receiver, subject, message, money, item, item_count) VALUES("%reciver%", "%subject%", "%message%", "%money%", %item%, %item_count%)', $insert_data);
        $sendmail=false;
    $db->query($query_string) or ($sendmail=mysql_error());
    if($sendmail==false)
        return  "<!-- success --><span class=\"colorgood\">Mail is sent! <br>All done!</span>";
    else
        return  "<span class=\"colorbad\">Mail is not sent! Error returned: ".$sendmail."<br>".$query_string; 

the mailbox databases & tables looks like:

mail:

id ++ messageType ++ stationery ++ mailTemplateId ++ sender ++ receiver ++ subject ++ itemTextId ++ has_items e++ expire_time ++ deliver_time ++ money ++ cod ++ checked





mail_external:

id ++ receiver ++ subject ++ message ++ money ++ item ++ item_count






mail_items:

mail_id || item_guid ++ item_template ++ receiver

If someone whish to help me or contact me at [email protected] Thank you

sorry Im not a good php coder, I know what the error tries to tell me but the php codes appears to be strange to me :P

[JD]

Make a sender column in the mail_external table.

[ak47sigh]

didnt help sorry

[Druzil]

didnt help sorry

Your mail_external table is entirely wrong compared to the PHP Code - you should have the following columns:

sender,
receiver,
subject,
message,
money,
stationery,
sent

Rebuild your mail_external table to reflect those columns, in that order, and it should work correctly.

[LilleCarl]

No people he should not rebuild his table, then the oregoncore mail_external function will not be able to read the data, he should recode the php application, which should not be to hard. BUT you have to give your time to do it, a basic explanation is: You must match the php script mysql insertion with your database table.