Version: , by ladyfire (Guest)
Developer Last Online: Jan 1970
Version: Unknown
Rating:
Released: 09-14-2001
Last Update: Never
Installs: 0
No support by the author.
First and foremost, i apologize for sounding a bit dull here...but this is my first adventure into php.....
I have written a hack for UBB (in cgi of course), which allows my users to post reviews in a preset format (using a very specific form i designed). I am hoping that by explaining what i did to make it work in cgi, one of you will be able to help point me into the right direction to to make it work here.
here is the link to the thread where i got a bit of help when i had to rewrite it for 6.x UBB (and that change, and it's killer impact on my server, brings me here )
If anyone can either help me write it, or help explain how this scripts processes new posts so that i can rewrite it myself, i would be VERY grateful, and will to compensate you for your time as well.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
I have a script that can post a message to the board. I think if you took this script and tweaked it a bit, you would have what you want.
Code:
<?php
require ("global.php");
$foruminfo=getforuminfo(33);
//$subject = date ("M-d-Y", mktime (0,0,0,date("m") ,date("d")+1,date("Y")));
$subject = vbdate("l, F d Y",time());
$puser = "Justin";
$open = 1;
$message = ("Please post links to your new and revised reviews in this thread.\n Make sure to list the title and topic of your review.\n");
$id = $DB_site->query_first("SELECT userid AS id FROM user WHERE username='$puser' LIMIT 1");
$a = $DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','33','".iif($open,1,0)."','0','".addslashes($puser)."','$id[id]','".addslashes($puser)."','".time()."','1','1','0')");
$threadid=$DB_site->insert_id();
$b = $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($puser)."','$id[id]','".time()."','0','$message','1','1','0','1','1')");
$c = $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='".time()."',lastposter='".addslashes($puser)."' WHERE forumid IN ($foruminfo[parentlist])");
//$d = $DB_site->query("UPDATE user SET ".iif($foruminfo[countposts],"posts=posts+1","")." WHERE userid='$id[id]'");
?>
This script posts in a specific user name - Justin. In addition, it posts a very specific post - the subject is the day's date, and the message is "Please post today's...."
I run this script every day at midnight.
This script could be tweaked to take the info from a form that you create. Your form should pass all the info you want, the username, and the forum number. Then, you just combine the info and drop it in the database. A very simple hack actually if you already have your form created.