Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by techker

  1. lol i have been looking at that work for about 10 minutes now and i new something was wrong with it..and even and i got the confirmation in anather forum to. now if i rename it to x_check will it have any concequence's to my script? and another guy told me to need to normalize that table what does he mean? what about this? fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(' at line 61 mysql error number: 1064
  2. so i looked at the page and i can't find any words on my sql? its says on line fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(50), so basicly i wold have to `fax` and `cc`? maybe http://www.mysql.com/news-and-events/newsletter/2002-10/a0000000075.html
  3. so if i change these words will it mess up my script?
  4. hey guys i got this when installing a script..i can't seem to find the probleme? <!-- Database error in SunShop Installer: Invalid SQL: CREATE TABLE options ( title VARCHAR(100), hometitle VARCHAR(100), shopurl VARCHAR(100), homeurl VARCHAR(100), securepath VARCHAR(100), companyname VARCHAR(100), address TEXT, city VARCHAR(30), state VARCHAR(20), zip VARCHAR(20), country VARCHAR(30), phone VARCHAR(20), faxnumber VARCHAR(20), contactemail VARCHAR(100), taxrate VARCHAR(10), shipups VARCHAR(5), grnd VARCHAR(5), nextdayair VARCHAR(5), seconddayair VARCHAR(5), threeday VARCHAR(5), canada VARCHAR(5), worldwidex VARCHAR(5), worldwidexplus VARCHAR(5), fixedshipping VARCHAR(5), method VARCHAR(15), rate VARCHAR(20), productpath VARCHAR(50), catimage VARCHAR(50), catopen VARCHAR(50), viewcartimage VARCHAR(50), viewaccountimage VARCHAR(50), checkoutimage VARCHAR(50), helpimage VARCHAR(50), cartimage VARCHAR(50), tablehead VARCHAR(50), tableheadtext VARCHAR(50), tableborder VARCHAR(50), tablebg VARCHAR(50), shipchart VARCHAR(50), ship1p1 VARCHAR(50), ship1us VARCHAR(50), ship1ca VARCHAR(50), ship2 VARCHAR(50), ship2p1 VARCHAR(50), ship2p2 VARCHAR(50), ship2us VARCHAR(50), ship2ca VARCHAR(50), ship3 VARCHAR(50), ship3p1 VARCHAR(50), ship3p2 VARCHAR(50), ship3us VARCHAR(50), ship3ca VARCHAR(50), ship4p1 VARCHAR(50), ship4us VARCHAR(50), ship4ca VARCHAR(50), visa VARCHAR(50), mastercard VARCHAR(50), discover VARCHAR(50), amex VARCHAR(50), check VARCHAR(50), fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(50), payable VARCHAR(100), paypal VARCHAR(50), paypalemail VARCHAR(100), shopimage VARCHAR(100), centerborder VARCHAR(50), centerheader VARCHAR(50), centercolor VARCHAR(50), centerfont VARCHAR(50), centerbg VARCHAR(50), useheader VARCHAR(50), usefooter VARCHAR(50), myheader VARCHAR(50), myfooter VARCHAR(50), thumbheight VARCHAR(50), thumbwidth VARCHAR(50), picheight VARCHAR(50), picwidth VARCHAR(50), showstock VARCHAR(50), showitem VARCHAR(50), showintro VARCHAR(50), orderby VARCHAR(50), outofstock VARCHAR(50), cs VARCHAR(5), po VARCHAR(5), license VARCHAR(50), handling VARCHAR(20), imagel VARCHAR(1), showbestsellers varchar(5), showspecials varchar(5), language varchar(20), showcattotals varchar(5), shipcalc varchar(5), shipusps varchar(5), itemsperpage int(5), usesecurefooter varchar(5), mysecurefooter varchar(50), usesecureheader varchar(5), mysecureheader varchar(50), mustsignup varchar(5), uspsserver varchar(200), uspsuser varchar(100), uspspass varchar(100), catsdisplay VARCHAR(10), allwidth VARCHAR(10), centerwidth VARCHAR(10), tablewidth VARCHAR(10) ) 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 'VARCHAR(50), fax VARCHAR(50), moneyorder VARCHAR(50), cc VARCHAR(' at line 61 mysql error number: 1064
  5. i juste need to make it more user frendly and less messy. cause it looks bad .lol i wold like to make a form with all of that but separeded so it looks nicer and when you receive it as well.
  6. the thing is is that in the texte area i put item and qty. but the hoel script is there.
  7. il try it thanks this is what i get in my email Visitor mail Messsage: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# tie raps QTY:2 Item# me QTY:1 Item# QTY: Item# QTY: Item# tie QTY:2 Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Visior IP: Email techker@gmail.com Messsage: Please do not forget your phone number.thx #sgsdgasdg
  8. hey guys i have this order form http://techker.vipzone.biz/enligne.php <? // Enter your Email below $myemail = ""; $ipi = getenv("REMOTE_ADDR"); if ($Submit) { if(!trim($visitor_name)) { $message = "<font color=red>Ton nom?</font>"; } else if(!trim($visitor_email)) { $message = "<font color=red>Ton email?</font>"; } else if(!trim($visitor_message)) { $message = "<font color=red>Ton messages?</font>"; } else { $todayis = date("l, F j, Y, g:i a"); $subject = "Commende en ligne"; $email_message = "Visitor mail \r Messsage: \r $visitor_message \r Visior IP: $ip \r Email $visitor_email\r Messsage: \r $visitor_comments "; $from = "De: $visitor_name<$visitor_email>"; mail ($myemail,$subject,$email_message,$from); $status = "sent"; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>ORDER FORM</title><style type="text/css"> <!-- body { background-color: #FFFFFF; } .style1 {color: #0000FF} .style2 {color: #003399; } --> </style></head> <body> <table width="530" height="746" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#eaedef"> <tr> <td width="13" valign="top" bgcolor="#003399"> </td> <td width="507" height="19" valign="top" bgcolor="#003399"> </td> <td width="10" valign="top" bgcolor="#003399"> </td> </tr> <tr> <td width="13" valign="top" bgcolor="#003399"> </td> <td height="708" valign="top" background="finisht/members/images/feature_bg_bgw.gif"><table width="496" height="708" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="496" height="708" valign="top"><? if ($status == "sent") { ?> <div align="center"> <span class="style2">Merci <? echo $visitor_name ?></span>(<? echo $visitor_email?>)<span class="style2"><br> Votre commande à été envoyer!<br> <br> Votre IP: <? echo $ip ?> </span><br> </div> <? } else { ?> <div align="center"><? echo $message ?></div> <form method="post" action="<? echo $_SERVER['finisht/members/PHP_SELF'] ?>"> <input type=hidden name="ip" value="<?php echo $ipi ?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#FFFFFF" class="style1"><div align="center" class="style1"></div> <div align="center" class="style1"></div></td> </tr> <tr> <td><div align="center"></div></td> </tr> <tr> <td><div align="center" class="style2">Name</div></td> </tr> <tr> <td><div align="center"> <input name="visitor_name" type="text" id="visitor_name" value="<? echo $visitor_name ?>"> </div></td> </tr> <tr> <td><div align="center" class="style2">Email </div></td> </tr> <tr> <td><div align="center"> <input name="visitor_email" type="text" id="visitor_email" value="<? echo $visitor_email ?>"> </div></td> </tr> <tr> <td><div align="center" class="style2">Your order (Please don't forget the QTY) </div></td> </tr> <tr> <td height="179"><div align="center"> <textarea name="visitor_message" cols="50" rows="15" id="visitor_message"><? echo $visitor_message ?> Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY: Item# QTY:</textarea> </div></td> </tr> <tr> <td height="97" valign="middle"><label><span class="style2">COMMENTS</span> <textarea name="visitor_comments" cols="60" rows="5"id="textarea"><? echo $visitor_comments ?> Please do not forget your phone number.thx #</textarea> </label></td> </tr> <tr> <td><div align="center"> <input name="Submit" type="submit" id="Submit" value="SEND"> <input type="reset" value="RESET"> </div></td> </tr> </table> </form> <? } ?></td> </tr> </table></td> <td width="10" valign="top" bgcolor="#003399"> </td> </tr> <tr> <td width="13" valign="top" bgcolor="#003399"> </td> <td height="19" valign="top" bgcolor="#003399"> </td> <td width="10" valign="top" bgcolor="#003399"> </td> </tr> </table> </body> </html> se the probleme is that it is very ugly and hard to read when i receive it in my emails. i need help for the reason that i wold like to make this form in one.not seperated. or if there is one that is already made . any body have an idea how i could make it nicer? thx for the help. ???
  9. hey guys i have this login script and the signup confirmation email does not work for hotmail accounts? is there a code i have to add or something??lol thx
  10. perfect thx buddy how does this work?i did but i can't explain it?
  11. so i do this? DirectoryIndex login.php ErrorDocument 403 http://www.site.ca/forbidden.php
  12. well i have lots of directorys. that is why a htaccess would be better and the site is all done so it would be long to redo to incorporate the login script..
  13. hey guys my login systeme does not have a htaccess file in a directory that i need it the most.. is there a way to make a htaccess file to redirect twards the login.php file? i guess it wold need to have a access to the login systeme files???
  14. hey guys i was woundering if somebody could guide me in the write direction. im doing as fallowed: the person will write the info and chose an apropriate categorie to put the file in. so when he press submit it puts it in the categorie selected and you can view it. so im assuming it will use the methode post for the form it's ok but it is for the categorie and the post that im having a hard time grasping..lol is there anything out there that is similar?that i could modify?
  15. good question..i juste don't want the members to login from any where?and track there ips.
  16. hey guys i got this code but i need to add a code that you can't signup with the same ip? in my signup form. [code]<?php // ip_grab.php /* Note: You can also check against $_SERVER variables   not included in this script */ function ipGrabber() {     if(getenv('HTTP_CLIENT_IP')):         $ip = getenv('HTTP_CLIENT_IP');     elseif(getenv('HTTP_X_FORWARDED_FOR')):         $ip = getenv('HTTP_X_FORWARDED_FOR');     else:         $ip = getenv('REMOTE_ADDR');     endif;     return $ip; }    echo '<p>Your IP is: <b>'. ipGrabber() .'</b>.</p>'; ?>[/code] thx for the help
  17. hey guys i have installed a allready made php login script on my sever.(shared) no it asks fo an install of ioncube. i have read the site but its really fuzzy..lol so if i read correctly i have to download the installer for my pc and it will configure my sever(linux) confused..lol http://www.ioncube.com/loader_installation.php
  18. lol shureit hasnt been to long and i learnt every thing on my own ..no school yet.thx
  19. lets say i want to remove it.were do i start?like i said i grabe it of a site
  20. humm you maybe pin pointed something..what should i put as the rest?
  21. i did put it gives me more errors...
  22. that is the error i think.i found this part on a forum..
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.