mysql error

[AN-net]

need some help with this one, ive been tinkering and still cant get it to work>_<

Originally Posted by server

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO chat_messages (channel_id,chatter,chatter_id,chat_msg,msg_dateli ne,receiver,msg_private) VALUES (, '', , '', 1099709379, , )
mysql error: 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 ' '', , '', 1099709379, , )' at line 1

mysql error number: 1064

Date: Friday 05th of November 2004 09:49:39 PM
Script: http://www.animationation.net/commun...o=getmsgs&ch=1
Referer: http://www.animationation.net/community/chat.php
Username: Antonbomb22

query:

PHP Code:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."chat_messages (channel_id,chatter,chatter_id,chat_msg,msg_dateline,receiver,msg_private) VALUES (".$msginsert['ch'].", '".addslashes($msginsert['chatter'])."', ".$msginsert['chatter_id'].", '".addslashes($msginsert['message'])."', ".TIMENOW.", ".$msginsert['receiver'].", ".$msginsert['private'].")"); 


[EvilLS1]

What kind of value will be inserted for receiver? An ID or a username?
Try this:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."chat_messages (channel_id,chatter,chatter_id,chat_msg,msg_dateline,receiver,msg_private) VALUES (" . intval($msginsert['ch']) . ", '".addslashes($msginsert['chatter'])."'," . intval($msginsert['chatter_id']) . ", '".addslashes($msginsert['message'])."', ".TIMENOW.", '$msginsert[receiver]', '$msginsert[private]')");

[AN-net]

Originally Posted by EvilLS1

What kind of value will be inserted for receiver? An ID or a username?
Try this:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."chat_messages (channel_id,chatter,chatter_id,chat_msg,msg_dateline,receiver,msg_private) VALUES (" . intval($msginsert['ch']) . ", '".addslashes($msginsert['chatter'])."'," . intval($msginsert['chatter_id']) . ", '".addslashes($msginsert['message'])."', ".TIMENOW.", '$msginsert[receiver]', '$msginsert[private]')");

an id

[EvilLS1]

Originally Posted by AN-net

an id

Try this then:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."chat_messages (channel_id,chatter,chatter_id,chat_msg,msg_dateline,receiver,msg_private) VALUES (" . intval($msginsert['ch']) . ", '".addslashes($msginsert['chatter'])."'," . intval($msginsert['chatter_id']) . ", '".addslashes($msginsert['message'])."', ".TIMENOW.", " . intval($msginsert['receiver']) . ", '$msginsert[private]')");

[AN-net]

fixed it

[AN-net]

ok well it runs the query but my function isnt working

here is my code:

PHP Code:

            if($_POST['action']=="msginsert")
            {
                globalize($_POST, array(
                    'message' => TEXT,
                    'ch' => INT
                ));
                require_once('./includes/functions_chat.php');
                parse_commands($message);
                $DB_site->query("INSERT INTO ".TABLE_PREFIX."chat_messages (channel_id,chatter,chatter_id,chat_msg,msg_dateline,receiver,msg_private) VALUES (" . intval($msginsert['ch']) . ", '".addslashes($msginsert['chatter'])."'," . intval($msginsert['chatter_id']) . ", '".addslashes($msginsert['message'])."', ".TIMENOW.", " . intval($msginsert['receiver']) . ", ".intval($msginsert[private]).")");
            } 


and functions_chat.php i have attached

[AN-net]

anyone.....