function MailGonder($KimeMail,$KimeAdi,$Konu,$Mesaj,$BCC=false) { $Mesaj='
'.$Mesaj.' |
'.SiteBilgi('Mailimza',true).' '.$_SERVER['HTTP_HOST'].' |
"; echo "Mailer Error: " . $mail->ErrorInfo;} else echo "Mesaj Gönderildi";*/
}
function KullaniciMi($LogID=0){
$KullaniciID=0;
@session_start();
@$KullaniciID=intval($_SESSION['KullaniciID']);
if($KullaniciID>0) return $KullaniciID;
elseif(intval(@$_COOKIE['HatirlaID'])>0 and intval(@$_COOKIE['HatirlaRnd'])>0)
{
$sonuc=mysql_query('SELECT * FROM kullanici WHERE ID="'.intval($_COOKIE['HatirlaID']).'" AND HatirlaRnd="'.intval($_COOKIE['HatirlaRnd']).'" AND Onay="1"');
if(mysql_num_rows($sonuc)==1)
{
@session_start();
$KullaniciID=mysql_result($sonuc,0,'ID');
$_SESSION['KullaniciID']=$KullaniciID;
$_SESSION['eposta']=mysql_result($sonuc,0,'eposta');
$_SESSION['Ad']=mysql_result($sonuc,0,'Ad');
$_SESSION['Firma']=mysql_result($sonuc,0,'Firma');
@mysql_query('UPDATE kullanici SET SonGirisTarih="'.date("Y-m-d G:i:s").'", SifreUnuttum="" WHERE ID="'.$KullaniciID.'"');
@mysql_query('UPDATE girislog SET KullaniciID="'.$KullaniciID.'" WHERE ID="'.$LogID.'" AND KullaniciID=0');
return $KullaniciID;
}else return 0;
}else return 0;
}
function KullaniciBilgi($KullaniciID=0){
@session_start();
$Kullanici['KullaniciID']=$_SESSION['KullaniciID'];
$Kullanici['eposta']=$_SESSION['eposta'];
$Kullanici['Ad']=$_SESSION['Ad'];
$Kullanici['Firma']=$_SESSION['Firma'];
return $Kullanici;
}
function KullaniciFiyat($KullaniciID=0){
if($KullaniciID==0) return 0;
else return mysql_result(mysql_query('SELECT SUM(Fiyat) FROM kullanici WHERE ID='.$KullaniciID),0);
}
function UrunLink($Dil,$ID,$Marka,$Model,$UrunKodu,$OEMNo,$UrunAdi)
{return str_replace(chr(13),'',str_replace('&','&','Urun.php?Dil='.$Dil.'&ID='.$ID.'&Marka='.cevir($Marka.'&Model='.str_replace('
',',',$Model).'&UrunKodu='.$UrunKodu.'&OEMNo='.$OEMNo.'&UrunAdi='.$UrunAdi)));}
function SiparisNoOlustur($Kullanici,$ID){
$SipNo=null;
for($i=0;$i<(3-strlen($Kullanici));$i++) $SipNo.='0';
$SipNo.=$Kullanici.'.';
for($i=0;$i<(5-strlen($ID));$i++) $SipNo.='0';
$SipNo.=$ID;
return $SipNo;
}
function OEMYaz($OEMNo,$Link=false,$Dil='TR',$Marka=null,$Model=null,$SiteMap=false){
$OEMNo=str_replace(',','
',str_replace(chr(10),'
',$OEMNo));
if($Link)
{
$OEMNolar=explode('
',$OEMNo);
$OEMNo=null;
foreach($OEMNolar as $OEM)
{
$Link='Urun.php?Dil='.$Dil.'&L&OEMNoBul='.$OEM.'&Marka='.cevir($Marka).'&Model='.cevir($Model);
if($SiteMap) return $Link; else $OEMNo.=''.$OEM.'
';
}
}return $OEMNo;
}
function OEMSorgu($OEMNo){return str_replace('.','',str_replace(' ','',str_replace('-','',$OEMNo)));}
function SiteBilgi($Baslik){
$sonuc=mysql_query('SELECT Detay FROM ayarlar WHERE Baslik="'.$Baslik.'"');
if(mysql_num_rows($sonuc)>0) return mysql_result($sonuc,0,'Detay'); else return null;
}
function YaziGetir($DilID){
$sonuc=mysql_query('SELECT Numara,Yazi FROM dilyazi WHERE DilID="'.$DilID.'" ORDER BY Numara');
while($sorgu=mysql_fetch_array($sonuc)) $Yazi[$sorgu['Numara']]=$sorgu['Yazi'];
return $Yazi;
}
function DilOgren($Dil){
@$DilID=mysql_result(mysql_query('SELECT ID FROM dil WHERE Dil="'.$Dil.'" AND Yayin=1'),0);
if($DilID==null) $DilID=1; return $DilID;
}
function Sorgu($convertStr)
{return str_replace("
","
",str_replace('\\','',mysql_real_escape_string(str_replace(chr(13),"
",str_replace("\r\n","
",str_replace('"',"'",$convertStr))))));}
function TarihSorgu($convertStr){
$convertStr=Sorgu($convertStr);
if(strpos($convertStr,'.')<1) return $convertStr;
else
{
$Tarih=explode('.',$convertStr);
return $Tarih[2].'-'.$Tarih[1].'-'.$Tarih[0];
}
}
function GirisLog($Link=null,$Yer=false){
$Tarayici=null;
@$Tarayici=$_SERVER['HTTP_USER_AGENT'];
if(strpos($Tarayici,'acebookexternalhit')>0) return 0;
if(strpos($Tarayici,'bot')>0 or strpos($Tarayici,'Google Web Preview')>0 or strpos($Tarayici,'www.baidu.com/search')>0) $Yer='Arama Motoru'; else $Yer=null;
$Ip=$_SERVER['REMOTE_ADDR'];
$KullaniciID = KullaniciMi();
$Tarih=date('Y-m-d H:i:s');
$Tarih2 = mktime(date('H'),date('i')-30,date('s'),date('m'),date('d'),date('Y'));
$Tarih2 = date('Y-m-d H:i:s', $Tarih2);
if($KullaniciID>0)$sonuc=mysql_query('SELECT ID FROM girislog WHERE IP="'.$Ip.'" AND KullaniciID="'.$KullaniciID.'" AND SonSorgu > "'.$Tarih2.'" LIMIT 1');
else $sonuc=mysql_query('SELECT ID FROM girislog WHERE IP="'.$Ip.'" AND SonSorgu > "'.$Tarih2.'" LIMIT 1');
if(($sonuc!=NULL) && (mysql_num_rows($sonuc)>0))
{
$LogID = mysql_result($sonuc,0);
mysql_query('UPDATE girislog SET SonSorgu="'.$Tarih.'" WHERE ID="'.$LogID.'"');
}else{
$sorgu='INSERT INTO girislog(ilkTarih,KullaniciID,IP,Ulke,Sehir,SonSorgu,Tarayici,Geldigi,Ziyaret)
VALUES("'.$Tarih.'","'.$KullaniciID.'","'.$Ip.'","'.$Yer.'","","'.$Tarih.'","'.$Tarayici.'","'.@$_SERVER['HTTP_REFERER'].'","'.$_SERVER['SCRIPT_NAME'].'?'.$_SERVER['QUERSTRING'].'")';
mysql_query($sorgu);
$sonuc=mysql_query('SELECT ID FROM girislog ORDER BY ID DESC LIMIT 1');
$LogID=mysql_result($sonuc,0);
}return $LogID;
}
function cevir($convertStr){
$search=array('ç','Ç','ğ','Ğ','ı','İ','ö','Ö','ş','Ş','ü','Ü');
$replace=array('c','C','g','G','i','i','o','O','s','S','u','U');
$convertStr=str_replace($search,$replace,$convertStr);
$find=array('é','è','ë','ê','É','È','Ë','Ê');
$convertStr=str_replace($find,'e',$convertStr);
$find=array('í','ì','î','ï','I','Í','Ì','Î','Ï');
$convertStr=str_replace($find,'i',$convertStr);
$find=array('ó','ò','ô','Ó','Ò','Ô');
$convertStr=str_replace($find,'o',$convertStr);
$find=array('á','ä','â','à','â','Ä','Â','Á','À','Â');
$convertStr=str_replace($find,'a',$convertStr);
$find=array('ú','ù','û','Ú','Ù','Û');
$convertStr=str_replace($find,'u',$convertStr);
$find=array('%','&','?');
$convertStr=str_replace($find,'-',$convertStr);
$find=array('.',',','!','?','/','"','\'','$',':',';');
$convertStr=str_replace($find,'',$convertStr);
$convertStr=strtolower($convertStr);
$convertStr=str_replace('[^a-zA-Z0-9[:space:]]','',$convertStr);
$convertStr=str_replace('[[:space:]]{1,}',' ',$convertStr);
$convertStr=str_replace(' ','-',$convertStr);
$convertStr=str_replace('--','-',$convertStr);
return $convertStr;
}
?>
$vtserver = 'localhost';
$veritabani = 'umi7939_db';
$vtkadi = 'umi7939_us';
$vtsifre = 'O2UFSlsw4@n';
mysql_connect($vtserver,$vtkadi,$vtsifre) or die ('MySQL Baglantisi Saglanamiyor');
mysql_select_db($veritabani) or die ('Veritabani Baglantisi Saglanamiyor');
mysql_query("SET NAMES 'utf8'");
?>