Administratorius
Reputacija:
1
Pranešimai: 2108
Įstojo: 2008-02-27
|
Slenkantis tekstas ant tinklapis.net registruodavosi mysql meginu daryt as su mokejimai.lt bet gaunu klaida sql ir nezinau kaip istaisyti nenuskaito mysql ir kai issiunciu sms gaunu atsakyma
 Code \"You have an error in your sql syntax; check manual that corresponds to your MySQL server version for the right syntax to use near 'to,sms,from,operator,amou\"
o paneles klaida
Code \"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 'key='zodis' AND amount='1' ORDER BY id DESC LIMIT 5' at line 1 TIK1 zodis TAVO TEKSTAS Numeriu 1371 (kaina 1Lt)
?inui nra.
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 'key='zodis' AND amount='1' ORDER BY id DESC LIMIT 5' at line 1\"
Kurgi bda gal kas padtumte
Paneles kodas:
Code ?>
//DEMESIO!!! NEDAROM NIEKO, PIRMA NEPASKAITE README!!!
//konfiguracija
$msgs = 5;//kiek zinuciu rodyti
$raktazodis = \"zodis\";//raktazodis, kuri nurodete tinklalapis.net administravime
$kaina = 1;//zinutes kaina litais (1,2,3,4,5,7,10)
$skirtukas1 = \"\";//zenklas kiekvienos zinutes pradzioje
$skirtukas2 = \"\";//zenklas kiekvienos zinutes pabaigoje
$skirtukas3 = \"||\";//zenklas tarp zinuciu
$infomsg = \"TIK$kaina $raktazodis TAVO TEKSTAS Numeriu 1371 (kaina \".$kaina.\"Lt)\";//zinute
function parseurl($str) {
$str = preg_replace('#(^|[\n ])((http|https|ftp|ftps)://[\w\#$%&~/.\-;:=,?@\[\]\(\)+]*)#sie', \"'\\1'.trimlink('\\2', 20).(strlen('\\2')>30?substr('\\2', strlen('\\2')-10, strlen('\\2')):'').''\", $str);
$str = preg_replace(\"#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]\(\)+]*)#sie\", \"'\\1'.trimlink('\\2', 20).(strlen('\\1')>30?substr('\\2', strlen('\\2')-10, strlen('\\2')):'').''\", $str);
return $str;
}
echo \"\";
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"parama WHERE key='$raktazodis' AND amount='\".$kaina.\"' ORDER BY id DESC LIMIT $msgs\");
echo \"
$infomsg
\";
if ($msgs > 1)
echo \">\";
if (dbrows($result)) {
$i=0;
while($data = dbarray($result)) {
echo ($i!=0?$skirtukas3:\"\").\" $skirtukas1 \".parseurl($data['sms']).\" $skirtukas2 \";
$i++;
}
} else echo \"?inui nra.\";
if ($msgs > 1) echo \"\";
echo \" \";
SMS failas
Code
#nustatymai
require_once \"maincore.php\";
include \"config.php\"; // adresas turi buti teisingas, iki tikrojo config.php
$slaptazodis = 'slaptazodis'; //ira?yk mokjimai.lt slapta?od
#nustatymai
if (trans( $_GET['transaction'], $slaptazodis, $_GET['id'])) {
$result = dbquery(\"INSERT INTO \".$db_prefix.\"parama (dt,to,sms,from,operator,amount,key,country) VALUES ('\".time().\"', '\".stripinput($_GET['to']).\"', '\".stripinput($_GET['sms']).\"', '\".stripinput($_GET['from']).\"', '\".stripinput($_GET['operator']).\"', '\".intval($_GET['amount']).\"', '\".stripinput($_GET['key']).\"', '\".stripinput($_GET['country']).\"')\");
echo \"Dkojame u?sakymas priimtas\";
} else { echo \"Ivyko klaida\"; }
function trans($transaction, $userPassword, $ordeID, $test = 0, $status = 1 ) {
return ( $transaction == md5(\"{$userPassword}|{$_SERVER['REMOTE_ADDR']}|{$ordeID}|{$test}|{$status}\") ); }
?>
Redagavo Wyciokazz 2010-03-07 13:08
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img] |
