hi all i am sorting out a chapel for one my sites and when i go to send a request it dont send it here is the request part
and this is the db i am trying to use with it
i have got every thing else working its just the request will not send please help me with this i am 99% done with this its just this 1% that not done i will share it when i have finished with it i am using wapdesire v_2 script
Code:
addonline(getuid_sid($sid),"The Chapel",""); echo head_tag(getnick_sid($sid)."@The Chapel",1,getnick_sid($sid)); $title="<b>Welcome To The Online Chapel!</b>"; $main="<p align=".align().">"; if($wid==0 OR $wid=="") { $main.="<img src=\"../images/error.gif\" alt=\"\"/><br/>"; $main.="UserName Doesn't Exist!<br/>Please Check Spelling & Try Again<br/>----<br/>\n"; $main.="<a href=\"chapel.php?sid=$sid\">Chapel Menu</a><br/>\n"; }else{ $iswhom = mysql_fetch_array(mysql_query("SELECT ismd FROM ibwf_chapel WHERE mid='".$wid."'")); if (!$iswhom) { $iswhom = mysql_fetch_array(mysql_query("SELECT ismd FROM ibwf_chapel WHERE uid='".$wid."'")); } if($iswhom[0]=='1') { $main.="Shame On You! You Cant Get Married To 2 People At Any One Time<br/>\n"; }else{ $iswhor = mysql_fetch_array(mysql_query("SELECT rpen FROM ibwf_chapel WHERE mid='".$wid."'")); if (!$iswhor) { $iswhor = mysql_fetch_array(mysql_query("SELECT rpen FROM ibwf_chapel WHERE uid='".$wid."'")); } if($iswhor[0]=='1') { echo "$who Already Has A Request Pending!<br/>If This Seems To Be A Problem<br/> Then Kindly Ask $who To Reject The Other Offer<br/>"; }else{ echo "<img src=\"../phpThumb/phpThumb.php?src=../images/ok.gif\" alt=\"\"/>A Request Has Been Sent To $who"; mysql_query("INSERT INTO ibwf_chapel SET rpen='1', mid='".$wid."', uid='".$uid."'"); mysql_query("INSERT INTO inbox SET text='Hi Gorgeous I Love You $who Therefore I Ask If You Will Wappied Me. Please Visit The Chapel To Accept *Auto Message*', byuid='".$uid."', touid='".$wid."', timesent='".$tm."'");
Code:
-- Table structure for table `ibwf_chapel` -- CREATE TABLE IF NOT EXISTS `ibwf_chapel` ( `id` int(100) NOT NULL auto_increment, `ismd` char(1) NOT NULL default '0', `uid` int(100) NOT NULL default '0', `mid` int(100) NOT NULL default '0', `rpen` char(1) NOT NULL default '0', `mdy` int(100) NOT NULL default '0', PRIMARY KEY (`id`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `ibwf_chapel` --
Comment