Php Acc Script

[JAKuT]

cd \
cd ceļš\uz\php\skriptu\
C:\ceļš\uz\php.exe skripts.php

jaizskatas apmeram taa??

cd \
cd C:\AppServ\www\skripts.php
C:\AppServ\php5 skripts.php

[RaaapuLis]

Ne jāizskatās šādi

cd \
cd C:\AppServ\www\skripts.php
C:\AppServ\php5\php.exe skripts.php

[wap1337]

cd \
cd ceļš\uz\php\skriptu\
C:\ceļš\uz\php.exe skripts.php

jaizskatas apmeram taa??

cd \
cd C:\AppServ\www\skripts.php
C:\AppServ\php5 skripts.php

A KUR uzrakstiiji linku uz php5 exutable failu?

vajadžēja

cd \

cd C:\AppServ\www\skripts.php

C:\AppServ\php5.exe skripts.php

vai arī

cd \

cd C:\AppServ\www\skripts.php

C:\AppServ\php5\php5.exe skripts.php

[RaaapuLis]

100% ka C:\AppServ\php5\php.exe skripts.php nevis C:\AppServ\php5.exe skripts.php

jo appserv mape jau ir iedaliita. mysql, www, php, apache

[JAKuT]

Jauna, problema..

Parse error: parse error, unexpected T_STRING in C:\AppServ\www\acc.php on line 30

$end_date=date("Y-m-d", strtotime(+30 days));

Site

[Norek]

sorry, trūkst pēdiņās +30 days

$end_date=date("Y-m-d", strtotime("+30 days"));

un pareizi ir

cd \

cd C:\AppServ\www\

C:\AppServ\php\php.exe skripts.php

[JAKuT]

tagad problema tada..:

PHP

<Center><form name="LOGIN" action="mvipacc.php" method="post">

<center><a href='http://62.63.181.143/?page=donate'>Назад!</a></center>

 

<center><b> Отправь смс с текстом <font color="red">"PAY DPMVIPACC"</font> на номер <font color="green">"1897"</font> и ждите когда придет вам КОД. SMS Цена 2.50 Ls</b></center>

<center><b> MONTH V.I.P-ACCESS</b></center>

<center><b> Дает вам возможность захадить на наш сервер без задержки</b></center>

<center><b> Ненадо ждать не каких мест когда сервер переполнен, вы можете захадить и эта услуга даетса вам на 30дней!</b></center>

 

<table class="table" border="0">

<tr><td align="left">Ник: </td> <td><input size="40" style="width:124px" maxlength="64" name="playername" type="text" value="" /></td></tr>

<tr><td align="left">Пароль(Который будете водить в игре): </td> <td><input size="40" style="width:124px" maxlength="64" name="pass" type="password" value="" /></td></tr>

<tr><td align="left">Пароль(Еше раз): </td> <td><input size="40" style="width:124px" maxlength="64" name="pw_coniform" type="password" value="" /></td></tr>

<tr><td align="left">Код(который получили в SMS): </td> <td><input size="40" style="width:124px" maxlength="64" type="txt" name="code" value="" /></td></tr>

<tr>

<td><center><input type="submit" name="submit1" value="Зарегистрировать" /></center></td>

</tr>

</table>

<?php

$nikreg 

= $_GET['nikreg'];

$kodinsh = $_POST['code'];

$kods = 23;

$playername = $_POST['playername'];

$nick = $_POST['playername'];

$pass = $_POST['pass'];

$pass2 = $_POST['pw_coniform'];

$access = "abz"; // Sheit ievadam accesa flagus.

$flags = "a"; 

$nickname = "regnick";

$end_date=date("Y-m-d", strtotime("+30 days"));  TE IRAKSTIJU, TO KODU KURU LIKI n0r3k

$ip 

= $_SERVER['REMOTE_ADDR'];

mysql_connect('localhost','root','');

mysql_select_db('amxbans'); 

$result = mysql_fetch_assoc(mysql_query("SELECT code FROM code WHERE code = '$kodinsh'"));

$kodinsh2 = $result['code'];

rekur puse no skripta, un kad ieeju uz majas apu, ievadu kodu, nick un paroli.. man rakstas

Column count doesn't match value count at row 1

Edited July 18, 2008 by JAKuT

[Norek]

eh, tur tak ir NOW()

nu ok, rakstīsim šādi :

mysql_query("INSERT INTO amx_amxadmins SET username=$nick, password=$pass, access=$access, flags=$flags, nickname=$nickname, reg_date=NOW(), end_date=$end_date");

[X ID]

Nu jau ~ pusgadu neesmu uzrakstijis nevienu kveriju bez mysql_real_escape_string() - protams, ja runa nav tikai par cipariem.

[JAKuT]

n0r3k, a kur vinu likt??? to mysql

sitaa vieta?? nomainit vnk??

$register = "INSERT INTO amx_amxadmins ( username, password, access, flags, nickname)

izskatiisies taa??

$register = mysql_query("INSERT INTO amx_amxadmins SET username=$nick, password=$pass, access=$access, flags=$flags, nickname=$nickname, reg_date=NOW(), end_date=$end_date");

vai ari

peec $register vinu vnk ielikt??

[Norek]

jā

$register = "INSERT INTO amx_amxadmins SET username=$nick, password=$pass, access=$access, flags=$flags, nickname=$nickname, reg_date=NOW(), end_date=$end_date";

[JAKuT]

nu tagad problema ir tada...

ievadiju visu nepieciesamo un raksta..

kad nospiedu register paradijas sii rindina:

Fatal error: Call to undefined function VALUES() in C:\AppServ\www\mvipacc.php on line 74

$register = "INSERT INTO amx_amxadmins SET username=$nick, password=$pass, access=$access, flags=$flags, nickname=$nickname, reg_date=NOW(), end_date=$end_date";
VALUES('$nick', '$pass', '$access', '$flags', '$nickname', '$end_date=date'); //74
mysql_query($register) or die(mysql_error());
mysql_query($q2) or die(mysql_error());
mysql_close();

Edited July 18, 2008 by JAKuT

[Norek]

Nevajag to VALUES rindu.

[JAKuT]

Unknown column 'Hansol' in 'field list'

Hansol ievadiju, rindina.. kur rakstit Nick

[X ID]

PHP

$register="INSERT INTO `amx_amxadmins` SET username='".mysql_real_escape_string($nick)."', password='".mysql_real_escape_string($pass)."', access='".mysql_real_escape_string($access)."', flags='".mysql_real_escape_string($flags)."', nickname='".mysql_real_escape_string($nickname)."', reg_date=NOW(), end_date='".mysql_real_escape_string($end_date)."'";

[JAKuT]

Laikam, viss strada

[JAKuT]

Un tagad, veel viens, jautajums..

vai tas taa jabut??

kad ieeju uz to localhost/skripts.php

un raksta man

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\AppServ\www\skript.php on line 3

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\AppServ\www\skript.php on line 3

taa jabut?

ieks skripts.php

<?php

mysql_query("DELETE FROM amx_amxadmin WHERE DATEDIFF(end_date, CURRDATE()) < 0");

?>

[X ID]

Konekcija datubāzei kautkur pazudusi, aka:

PHP

mysql_connect("hosts","lietotājvārds","parole");

mysql_select_db("datubāzes_nosaukums");

[RaaapuLis]

PHP

<?php 

mysql_connect

("hosts", "lietotajs", "parole") or die(mysql_error()); 

mysql_select_db("datubaze") or die(mysql_error()); 

?>

p.s. psc X ID pasteidzās

Edited July 18, 2008 by RaaapuLis

[Norek]

autoram derētu mazliet palasīt, ne tikai uzdot jautājumus. vismaz iekopē errora galveno daļu googlē - tur ir daudz informācijas.

[RaaapuLis]

arī, ne vienmēr errors tev sagādā problēmas, man gan patīk domāt kas un kāpēc, kur un kā...

JAKuT pamēģini šito

Edited July 18, 2008 by RaaapuLis