spermer_co

Sveiki. Variet luudzu kads palabot sho mysql kveriju. Probleema taaada, ka tas nevis atjauno jau esoshos datus, kur niks = $niks, bet gan izveido velvienu taadu rindu. Kapec tas taa ir? $result = mysql_query("UPDATE `db_cup_players` SET `points` = '".$points."', `x1x1played4` = '".$x1x1played4."', `x1x1played8` = '".$x1x1played8."', `meleeplayed6` = '".$meleeplayed6."', `meleeplayed8` = '".$meleeplayed8."', `totalplayed` = '".$totalplayed."', `x1x1final4` = '".$x1x1final4."', `x1x1final8` = '".$x1x1final8."', `meleefinal6` = '".$meleefinal6."', `meleefinal8` = '".$meleefinal8."', `totalfinal` = '".$totalfinal."', `x1x1win4` = '".$x1x1win4."', `x1x1win8` = '".$x1x1win8."', `meleewin6` = '".$meleewin6."', `meleewin8` = '".$meleewin8."', `totalwin` = '".$totalwin."', `firstcup` = '".$firstcup."', `lastcup` = '".$lastcup."' WHERE niks = '".$niks."'"); if (mysql_affected_rows() == 0) { // No records updated, so add it $result = mysql_query("INSERT INTO `db_cup_players` (niks, points, x1x1played4, x1x1played8, meleeplayed6, meleeplayed8, totalplayed, x1x1final4, x1x1final8, meleefinal6, meleefinal8, totalfinal, x1x1win4, x1x1win8, meleewin6, meleewin8, totalwin, firstcup, lastcup) VALUES ('".$niks."', '".$points."', '".$x1x1played4."', '".$x1x1played8."', '".$meleeplayed6."', '".$meleeplayed8."', '".$totalplayed."', '".$x1x1final4."', '".$x1x1final8."', '".$meleefinal6."', '".$meleefinal8."', '".$totalfinal."', '".$x1x1win4."', '".$x1x1win8."', '".$meleewin6."', '".$meleewin8."', '".$totalwin."', '".$firstcup."', '".$lastcup."')"); } echo Done; Paldies.

Taatad, problemina taada, ka mans kverijs nevis atjauno jau esoshus lietotaja datus, bet gan velreiz pievieno identisku ierakstu datubaazee, tapeec ludzu palidziet man atrisinat sho problemu. Tada sajuta ka vins neatpazist to ka "niks" ailiitee esoshie dati ir tadi pashi kaa $niks $result = mysql_query("UPDATE `db_players` SET points='".$points."', x1x1played4='".$x1x1played4."'' WHERE niks='".$niks."'"); if (mysql_affected_rows() == 0) { $result = mysql_query("INSERT INTO db_cup_players (niks, points, x1x1played4) VALUES ('".$niks."', '".$points."', '".$x1x1played4."')"); }

Sveicinaati. Veeleejos jums paluugt, vai kaads nevareetu izveidot vienkaarshu formu, kuraa lietotaaji var ierakstiit kaadu lamuvaardu, un to pievienot mysql datubaazei, kuraa glabaajaas visi lamuvaardi. Protams, ja shaads vaards jau eksistee, tad lietotaajam paraadaa, ka shads vards jau eksistee un to nepievieno sarakstam. Liels paldies!

OK shis straadaa <?php $arr = file('points.dat'); $top = array(); for($i = 0; $i < count($arr); $i++) { if ($i % 2 == 0) { $score = (integer)$arr[$i + 1]; if(!isset($top[$score])) { $top[$score] = $arr[$i]; } else { $top[$score] .= ' / '.$arr[$i]; } } } krsort($top); $top = array_slice($top, 0, 5, true); foreach($top as $k => $v) { echo $v.' - '.$k.'<br />'; } ?>

cool. tas straadaa :) paldies

nu jaa taa es sapratu.. pieliku. un kas notiek? Warning: Invalid argument supplied for foreach() in C:\blabla\tram.php on line 3

hmm es pastijos no cita piemeeram php.net un tur bija taapat fwrite($file, $text); fclose($file);

nevari paliidzeet? ^^

bet kaa izlabot .. patiesiibaa man vairak nevajag skriptu shito jo izdariju to manuaali ar ieprieksheja skripta palidzibu bet tikuntaa.. varetu piebeigt vinu

njaa.. viss bija labi liidz kaads sasniedza 10 punktus.. ja punkti ir vairak par 10 (parbaudits uz 10 un 11) tad vinsh uztver to kaa zemaaku vietu un manaa top5 vispar neparadijas.. iespejams vinsh buutu kautkur top10 vai top20.. EDIT: nomainiju lai raada top20 un es sapratu to ka 10 un 11 ir mazaaks par 2 Fobz - 9 WyB - 5 SSJGoku - 4 xrusts - 3 ^D3v1L^ / liiv` - 2 Kzlv`spermis - 11 icky - 10 ayck - 1 Te man nav top20 jo tik daudz cilveku anv

varbuut no shejienes? fwrite($handle, $output); fclose($handle);

jaa tomeer sakaarto.. nu bet taa la vinsh atbalsta vairaakus cilveekus ar vienaadu rezultatu?

nu vaidzeetu lai vareetu, bet pilnigi vienalga kursh ir augstaak ar vienadiem punktu skaitiem. ak jaa.. un lai vinsh sakaarto taa ka tas kuram ir vairaak ir 1 vietaa, un taa.. 1. niks 10 2. niks 9 3. niks 8 4. niks 7 5. niks 6

nevar atkaartoties.. Punkti vinam pieskaitaas klaat un ja sakuma bija Niks 5 Tad peec 2 punktu pievienoshanas Niks 7

Parse error: syntax error, unexpected T_STRING in C:/blabla/tram.php on line 10