Jump to content

PHP/SQL problem - affiliates script

vimixx

By vimixx
in Microsoft SQL - MSSQL

 Share

Recommended Posts

vimixx Newbie

vimixx

Posted
Posted

I have a website called vimixx.net. And I'm using an affiliates script called Uddabannerxchange.

And basically, people who want to affiliate with me, can fill out a form, below the already listed affiliates and their buttons. Everytime they apply, the form takes down their website address, image path to their banner, and their email address and they are issued a URL which stores the amount of traffic coming from their site and mine, all these are stored in the mysql database.

 

Now, my webhost, not so long ago, updated the SQL version to 5 or 6 and ever since then, when I've tried using the form, I get this displayed on the page:-

 

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 'out , ini , ok) VALUES ('http://', 'No Email', 'Undefined', 'No Title', 0, 0, 'n' at line 1

 

The script contains 5 php pages, the admin page, affin.php, affout.php, index.php (which the form is stored and affiliates are displayed) and data.php.

 

The index.php is the problem and here's the php code for it:-

 

<title>Vimix Designs - Thank you for your affiliation!</title>
<LINK REL="shortcut icon" HREF="favicon.ICO">
<link rel="stylesheet" href="stylev9.css" type="text/css">
<script src="noclick.js"></script>
<body>
<?
/*

http://www.udda.net
webmaster@udda.net
Copyright udda.net

You are most welcome to add a link to my site.
Thanks / Rikard at udda.net
*/
$url = $_POST['url'];
$title = $_POST['title'];
$email = $_POST['email'];
$burl = $_POST['burl']; 
include("data.php");
mysql_connect ($dbhost,$dbuser,$dbpass);
mysql_select_db ($db);

if ($_GET['create'] == "aff") { 
$url = $_POST['url'];
$title = $_POST['title'];
$email = $_POST['email'];
$burl = $_POST['burl']; 
if ($url == ""){ $url = "http://";}
if ($title == ""){ $title = "No Title";}
if ($email == ""){ $email = "No Email";}
if ($burl == ""){ $burl = "Undefined";}


$sql = "SELECT COUNT(*) FROM udBXchange WHERE title = '".$title."' AND url = '".$url."'";
$result = mysql_query($sql);
$antal = mysql_result($result, 0);

if ($antal == 0){
mysql_db_query($db, "INSERT INTO udBXchange (url , mail , burl , title , out , ini , ok) VALUES ('".$url."', '".$email."', '".$burl."', '".$title."', 0, 0, 'no')") or exit(mysql_error());
}
?>


<strong><font size=2><img src="imgs/09_n1.gif" width="8" height="10"> Linkage</font></strong><br>
Thank you for affiliating with us. Once checked and verified, we shall display your affiliation button on our affiliates page. <br>
<br>
<br>
<font size="1"><strong>Title of your site is:</strong> <a target="_blank" href="<?=$url;?>"><? echo $title; ?></a><br>
<?
$sql = "SELECT id FROM udBXchange WHERE title = '".$title."' AND url = '".$url."'";
$result = mysql_query($sql); 
?>
<br>
<strong>You must use this to link me with:<br>
</strong>(click 'Hightlight code' and select copy in your browser) <br>
</font>
<? $link = mysql_fetch_array ($result); ?>
<form name="copy">
  <div align="center">
    <textarea style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;' name="txt" rows="3" cols="50" wrap="VIRTUAL"><? echo $homepage;?>affin.php?id=<? echo $link['id']; ?></textarea>
    <br>
    <input style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/ value="Highlight code" src="..images/highlightall.gif" border="0" onclick="javascript:this.form.txt.focus();this.form.txt.select();" type="button">
  </div>
</form>
<div align="center"><br>
  <br>
    <?
}else {
  
$sql = "SELECT * FROM udBXchange WHERE ok = 'yes' ORDER BY title ASC";
$result = mysql_query($sql);
while ($links = mysql_fetch_array($result)){
?>
    <a title="<?=$links['title'];?>" target="_blank" href="<?=$homepage;?>affout.php?id=<?=$links['id'];?>"><img border="0" src="<?=$links['burl'];?>" width="88" height="31" title="<? echo $links['title']; ?> - Clicks: <? echo $links['ini']; ?>" class="gradualshine1" onMouseover="slowhigh(this)" onMouseout="slowlow(this)" style='BORDER-RIGHT: #232528 1px solid; BORDER-TOP: #232528 1px solid; font-size: 9px; BORDER-LEFT: #232528 1px solid; BORDER-BOTTOM: #232528 1px solid; color: #232528;'></a>  <? }?>
  <? }?>
  <br>
  <BR>
  <form action="affspage.php?create=aff" method="post">
    <div align="center"><span class="style3"><font color=white>Your Website address:</font><br>
          <input name="url" type="text" value="http://" size="35" maxlength="60" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/>
          <br>
          <font color=white>Path to 88x31 button:</font><br>
          <input name="burl" type="text" value="http://" size="35" maxlength="60" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/>
          <br>
          <font color=white>Name of your website:</font><br>
          <input name="title" type="text" size="35" maxlength="30" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/>
          <br>
          <font color=white>Your E-mail:</font><br>
          <input name="email" type="text" size="35" maxlength="30" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/>
          <br>
          <input type="submit" value="Apply!" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/>
          </span></div>
  </form>

</div>
</body>

 

 

If anybody could me with this problem, as I have already tried contacting the author of this script udda.net and he couldn't give a toss about it, I'd be really grateful. Thanks.

Link to comment
https://forums.phpfreaks.com/topic/38915-phpsql-problem-affiliates-script/
Share on other sites
vimixx Newbie

vimixx

Posted
  • Author
Posted

Problem solved by myself:-

 

All I did was put ` this little apostrohes in between like this:-

 

mysql_db_query($db, "INSERT INTO udBXchange (`url`,`mail`,`burl`,`title`,`out`,`ini`,`ok`) VALUES ('".$url."', '".$email."', '".$burl."', '".$title."', 0, 0, 'no')") or exit(mysql_error());

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • 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.