spALky Posted September 5, 2010 Report Share Posted September 5, 2010 Lieta sekojoša man vajag dabūt, lai sms scriptā acc dodas tikai uz mēnesi, kā to dabūt gatavu, jo acc dodas uz neierobežotu laiku. <? // KONEKTEJAM PIE MYSQL $host = "localhost"; $db = "amxbans"; $mysql_user = "*****"; $mysql_pw = "*****"; mysql_connect ($host, $mysql_user, $mysql_pw)or die("neizdevas piekonekteeties: ".mysql_error()); mysql_select_db($db) or die(mysql_error()); // DB CONNECT $cena = "0.95"; // CENA PAR NIKA REG $nr = "157"; // NUMMURS ( DEF. 157 SOLAR-F ) $user_id = "979"; // SOLAR-F ID ( no http://stats.solarf.lv ) $code = "slr095"; // Ja 1,50 Ls tad 150. ?> <center><b>LMT/Tele2/Bite</b> <br> <b>SMS Numurs: <font color=red><? echo "$nr"; ?></font> <br> SMS Teksts: <font color=red><? echo "$code"; ?></font><br> <b>Summa: <font color=red><? echo "$cena"; ?> Ls</font><br> <form action="" method="post"> <b>Niks:</b><br><input type="text" name="nickname"><br> <b>Serveris:</b><br> <select name='server_id'> <? $select = mysql_query("SELECT * FROM `amx_serverinfo`"); while($arr = mysql_fetch_array($select)) { $serv_id = $arr["id"]; $serv_name = $arr["hostname"]; echo " <option value='$serv_id' name='$serv_id'> $serv_name</option> "; } ?> </select><br> <b>Parole:</b><br><input type="text" name="password"><br> <b>Atkartot paroli:</b><br><input type="text" name="pw_coniform"><br> <b>SMS KODS:</b><br><input type="text" name="slr"><br><br> <input type="submit" name="submit" value="Registret"> </form> </center> <center> Acc registracija: Slots, kick, ban, slap, slay, xchat, vote </center> <center> Atceries!!!Atceries acc vienmer var nonemt. Uzvedies un lieto to pareizi.Necito un nelauj to citiem darit. </center> <center> Nepamatota banu liksana: warn un acc remove. </center> <center> Doma divreiz pirms ko dari</center> <? if($_POST["submit"]){ $slr = mysql_escape_string($_POST["slr"]); if (! is_numeric($_POST['slr'])) { die ("<center><font color=green><b>TOD Niku reģistracijas sistema by DyC.Lv </b></font><br><br><br><br><br><br><br><br><b><font color=red>Kods nederigs!</font></b></center>"); } $answer = join('', file("http://sms.solarf.lv/confirm.php?code=$slr&id=$user_id&price=$code")); if ($answer != "key_ok" ) { die ("<div class=msg-error>Kļuda! Kods nav pareizs, meģini vēlāk.</div>"); } if ($answer=="key_ok") { $nick = $_POST['nickname']; $pass = $_POST['password']; $pass2 = $_POST['pw_coniform']; $access = "bcdeijm"; $flags = "ab"; $nickname = "smsreg"; $ip = $_SERVER['REMOTE_ADDR']; if($pass == $pass2){ echo ""; }else{ die ("<script>alert('Paroles nesakrit!');window.back()</script>"); } $check = mysql_query("SELECT username FROM amx_amxadmins WHERE username='$nick'"); $exist = mysql_num_rows($check); if($exist > 0){ echo "<script>alert('Tads niks ir jau registrets!');window.back()</script>"; unset($nick); exit(); } if(empty($nick)){ die ("<script>alert('Ieraksti niku!'); window.back()</script>"); } if(empty($pass)){ die ("<script>alert('Ieraksti paroli!'); window.back()</script>"); } $register = "INSERT INTO amx_amxadmins ( username, password, access, flags, nickname) VALUES('$nick', '$pass', '$access', '$flags', '$nickname')"; mysql_query($register) or die(mysql_error()); $id = mysql_insert_id(); mysql_query("INSERT INTO amx_admins_servers (admin_id, server_id) VALUES ($id, $server_id)"); mysql_close(); echo "<div class=msg-ok><br>Reģistrācija pagāja veiksmīgi!Access tev tiks piešķirts pēc mapes maiņas<br> Konsolē ieraksti:<br> <u>setinfo $pass</u></div>"; } } //header('location: index.php'); ?> Link to comment Share on other sites More sharing options...
ANALGINS Posted September 7, 2010 Report Share Posted September 7, 2010 tabulā ieliec kādu timestampu, pēc kura tiktu aprēķināts beigu datums, kad ieraksts tiktu dzēsts no db, atiecīgi šo ielikt crontab un darīts.. Link to comment Share on other sites More sharing options...
X ID Posted September 7, 2010 Report Share Posted September 7, 2010 Neklausi ANALGĪNAM, liec DATETIME, nevis TIMESTAMP!! Un lasi šo linku - http://dev.mysql.com/doc/refman/5.1/en/dat...-functions.html Link to comment Share on other sites More sharing options...
Recommended Posts