PDA

View Full Version : How would I auto post a thread?

joebob
06-30-2001, 02:52 PM
Ok here is what I want to do:
After a member registers I want an auto post to post and have the subject be his user name?
I have no idea how to do this and I would greatly appreciate any help! Thanx!
dwh
06-30-2001, 04:02 PM
Great question, tough answer, but I think perhaps the same question in the code hacking forum would give you better results...
G0D
06-30-2001, 04:17 PM
the auto post is just a mysql query. You have to put it in the script that makes a member.
joebob
06-30-2001, 04:28 PM
Originally posted by G0D
the auto post is just a mysql query. You have to put it in the script that makes a member.

I have no idea what any of that means, sorry I am still learning php and mysql, could you explain this in more detail?
joebob
07-01-2001, 04:40 AM
come on people, help me out
joebob
07-02-2001, 04:03 AM
somebody has to know this!
G0D
07-02-2001, 10:18 AM
bleh
see my next reply
joebob
07-02-2001, 06:29 PM
Thanx for replying, butI get this error:

Database error in vBulletin: Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad
dress,iconid,visible) VALUES (NULL,'10','Hi! I\'m new here','amber','5','994101591','','','1','0','24.22 .128.147','0','1')
mysql error: You have an error in your SQL syntax near 'dress,iconid,visible) VALUES (NULL,'10','Hi! I\'m new here','amber','5','9941015' at line 2
mysql error number: 1064
Date: Monday 02nd of July 2001 03:19:51 PM
Script: /td/register.php
Referer: http://www.copyforum.com/td/register.php
G0D
07-02-2001, 06:39 PM
i'll look at it tommorow..I'm to tired now.
dwh
07-02-2001, 11:17 PM
I bet your problem is related to the text you trying to insert. I'm more used to perl but the word "I'm" contains an embedded single quote ' and that is probably causing your problem, if I remember correctly, php like perl wants you to precede single quotes, double quotes, or other reserved letters with a backslash \, so change it to Hi! I\'m here! and the same for any other "special characters". Let me know if it helps..
G0D
07-03-2001, 11:04 AM
he're it is, I tested it and it works perfectly (in vbb 2.0)
joebob
07-03-2001, 06:31 PM
thanx man, I'll set it up later
joebob
07-14-2001, 05:41 PM
worked great!