panquetofobia
-
Content Count
29 -
Joined
-
Last visited
Everything posted by panquetofobia
-
the problem is with the count(*) query. everything else works fine. @MC what's the difference in performance between header('Location: main.php'); and header("Location: main.php"); ??? i know there r some easy ways... but i learned php using google. it doesn't please read my comments below. hope u'll find out the solution .. $code = md5($code); // IS THIS CORRECT?-> yes it is. no problem with this line.if(@$codigo != $code) header('Location: main.php');elseif($deporte . $rama . $enc_reg . $centro_trabajo == '') header("Location: reg1.php?codigo=$code&\x3benc_reg=$enc_reg");else{ //PRINCIPAL - MAIN?><link href="/css/base.css" rel="stylesheet" type="text/css" /><body style="background: url(/img/regbg.gif) no-repeat fixed top right;"><p><img src="./imgs/paso3.gif" border="0" alt=""></p><p>Gracias por identificarse <strong><?php echo $enc_reg; ?></strong></p><p>Registro de Jugadores de <?php echo $deporte . ' ' . $rame; ?> para el Centro de Trabajo <?php echo $centro_trabajo; ?></p><?php }$fecha = date('Y-m-d');$sqlcheck = "SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'";$querycheck = mysql_query($sqlcheck) or die(mysql_error());$A = mysql_fetch_object($querycheck);@$merror .= "Hasta $A -> integrantes_restantes jugadores por registrar.";if(@$ddok) // enviado - submitted{ if(@$ape1 . $ape2 . $nombre . $no_ficha . @$sit_cont . @$sub_sit_cont . $anios . $talla == '')  @$merror .= '<p style="color: #990000' . "\x3b" . ' font-weight: bold' . "\x3b" . '">Por Favor Llene el Formulario completamente.</p>'; else // lleno - filled {  // sql ya registrado ó sancionado?? - sql registered or punished??  $sqlcheck = "SELECT COUNT(*) FROM sancionados, participantes WHERE sancionados.No_Ficha = '$no_ficha' AND participantes.No_Ficha = '$no_ficha'"; // here's the problem.  $querycheck = mysql_query($sqlcheck) or die(mysql_error());  // IS THERE SUPPOSE TO BE $A = mysql_fetch_object($querycheck); HERE? -> no, i take the object from the first mysql_fetch object. works fine. no problem here.  if($A -> integrantes_restantes == 0) // no hay lugares libres? - no positions left?  {  @$merror .= '<p style="color: #990000' . "\x3b" . 'font-weight: bold' . "x3b" . '">JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src="/imgs/error.gif" alt=""></p>';  echo '<meta http-equiv="refresh" content="3' . "\x3b" . 'url=index.php" />';  }  else // no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables  {  $situancionc = $sit_cont . ' ' . $sub_sit_cont;  $sql = "INSERT INTO participantes VALUES (0, '$nombre', '$ape1', '$ape2', '$no_ficha', '$situancionc', '$talla', '$anios', '$deporte', '$rama', '$centro_trabajo', '$enc_reg', '$fecha')"; this query works, but its function depends on the count(*) query above.....  $query = mysql_query($sql) or die(mysql_error()); // registro de jugador - storing player info  $sql = "UPDATE equipos SET integrantes_restantest = (integrantes_restantest - 1) WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'"; //works fine.  $query = mysql_query($sql) or die(mysql_error());  @$merror .= '<p>Jugador ' . $nombre . ' ' . $ape1 . ' ' . $ape2 . ' <strong>Registrado</strong> <img src="/imgs/oki.gif" alt=""></p>';  } }}form_jugadores(@$desp, $code, @$enc_reg, @$merror, @$deporte, @$rama, @$centro_trabajo);} // WHAT IS THIS CLOSING?- the end of the firt 'else'// FIN PRINCIPAL - END MAIN // <{POST_SNAPBACK}> greetings from MÊxico.
-
hello guys. the problem with this script is that the insert query dosen't function properly as it depends on the result of a count(*) query. the update query works fine.... here's some code: $code=md5($codea);if(@$codigo!=$code)// no autenticado - not authenticated{ header ("Location: main.php");}elseif($deporte=="" || $rama=="" || $enc_reg=="" || $centro_trabajo==""){ header ("Location: reg1.php?codigo=$code&enc_reg=$enc_reg");}else //todo bien - everything is ok{// PRINCIPAL - MAIN // echo "<link href=\"./css/base.css\" rel=\"stylesheet\" type=\"text/css\" />"; echo "<body style=\"background-image:url(./imgs/regbg.gif)\x3b background-repeat: no-repeat\x3b background-position: top right\x3b background-attachment:fixed\x3b \">"; echo "<p><img src=\"./imgs/paso3.gif\" border=\"0\" alt=\"\"></p>"; echo "<p>Gracias por identificarse <b>$enc_reg</b></p><p>Registro de Jugadores de $deporte $rama para el Centro de Trabajo $centro_trabajo </p>"; $fecha=date("Y-m-d"); $sqlcheck="SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'"; $querycheck=mysql_query($sqlcheck); $A=mysql_fetch_object($querycheck); @$merror.="Hasta $A->integrantes_restantes jugadores por registrar."; if (@$ddok)//enviado - submitted { if(@$ape1=="" || $ape2=="" || $nombre=="" || $no_ficha=="" || @$sit_cont=="" || @$sub_sit_cont=="" || $anios=="" || $talla=="") { @$merror.="<p style=\"color:#990000\x3b font-weight:bold\">Por Favor Llene el Formulario completamente.</p>"; } else //lleno - filled { //sql ya registrado Ăł sancionado?? - sql registered or punished ?? $sqlcheck="SELECT COUNT(*) FROM sancionados,participantes WHERE sancionados.No_Ficha='$no_ficha' AND participantes.No_Ficha='$no_ficha'"; $querycheck=mysql_query($sqlcheck) || die(mysql_error()); if($A->integrantes_restantes==0)//no hay lugares libres? - no positions left? { @$merror.="<p style=\"color:#990000\x3b font-weight:bold\">CENTRO DE TRABAJO COMPLETO. NO HAY REGISTROS DISPONIBLES. <img src=\"./imgs/error.gif\" alt=\"\"></p>"; echo "<meta http-equiv=\"refresh\" content=\"3\x3burl=index.php\">"; } elseif(@mysql_result($querycheck,0,0)>0) //ya registrado Ăł sancionado?? - registered or punished ?? { $merror.="<p style=\"color:#990000\x3b font-weight:bold\">JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src=\"./imgs/error.gif\" alt=\"\"></p>"; } else //no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables { $situacionc="$sit_cont $sub_sit_cont"; $sql="INSERT INTO participantes VALUES ( 0 , '$nombre','$ape1','$ape2','$no_ficha','$situacionc','$talla','$anios','$deporte','$rama','$centro_trabajo','$enc_reg','$fecha')"; $query=mysql_query($sql) || die(mysql_error()); // registro de jugador - storing player info $sql="UPDATE equipos SET integrantes_restantes=(integrantes_restantes - 1) where Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'"; $query=mysql_query($sql) || die(mysql_error()); // una posiciĂłn menos - minus one position @$merror.="<p>Jugador $nombre $ape1 $ape2 <strong>Registrado</strong> <img src=\"./imgs/oki.gif\" alt=\"\"></p>"; } } }form_jugadores(@$desp,$code,@$enc_reg,@$merror,@$deporte,@$rama,@$centro_trabajo);}// FIN PRINCIPAL - END MAIN // thank u very much for your help
-
note:macromedia and winamp run in linux
-
a part of my code... $sqlcheck="SELECT count(*) FROM participantes AS a, sancionados AS b WHERE a.No_Ficha = '$no_ficha' OR b.No_Ficha='$no_ficha';"; $querycheck=mysql_query($sqlcheck) || die(mysql_error());; if(@mysql_result($querycheck,0,0)>0) { $merror.="<p style=\"color:#990000; font-weight:bold\">JUGADOR YA REGISTRADO Ó SANCIONADO <img src=\"./imgs/error.gif\" alt=\"\"></p>"; } else { $sql="UPDATE equipos SET integrantes_restantes='$integrantesr' where Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'";$query=mysql_query($sql); $sql="INSERT INTO participantes VALUES (0,'$nombre','$ape1','$ape2','$no_ficha','$situacionc','$talla','$anios','$deporte','$rama','$centro_trabajo','$enc_reg','$fecha'"; $query=mysql_query($sql); @$merror.="<p>Jugador ".$nombre." ".$ape1." ".$ape2." <strong>Registrado</strong> <img src=\"./imgs/oki.gif\" alt=\"\"></p>"; } the insert query doesn't function either ... thank u guys ... greetings from MĂŠxico City
-
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
no... i design on a generic pc with windows xp, and sometimes linux mandrake 10.p4 2ghz, 256mb ram, 64mb video, 60 g hd... and..... i use flash mx 2004 progreetings from méxico -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
it seems that theres' no possible solution.i'll make the menu in fireworks........ -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
i have re generated the swf lots of times.... the web page is the index.php in my local server and in http://participantes.co.nr/ loads properly... i have talked to opaque about this and he said it was sth on my side. -
doesn't function....but thank u so much avalon
-
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
damn...i've just tried both....no succes :)this is very weird, cuz the code functions in other hosts...thanx anyway.... -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
didn't function.............!!!!!1 any other idea??greetings from México -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
Thanx a lot!!!let me try... -
i dunno why this query doesn't function.. $sql="SELECT count(*) FROM participantes,sancionados WHERE participantes.No_Ficha = '$no_ficha' or sancionados.No_Ficha='$no_ficha'";$query=($sql); any suggestion???
-
hello guys... i have this problen since i signed up. my website has a flash menu which never loads. <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="180" height="160" id="menu" align="middle"><param name="movie" value="./swf/menu.swf"><param name="quality" value="high"><param name="bgcolor" value="#ffffff"><embed src="./swf/menu.swf" quality="high" bgcolor="#ffffff" width="180" height="160" name="menu" align="middle" type="application/x-shockwave-flash" pluginspage="https://get.adobe.com/flashplayer/otherversions/;the file name is ''menu.swf'' in the 'swf' directory. have u ever had any similar problem??? greetings from MĂŠxico City
-
can't load a .SWF need some help please
panquetofobia replied to panquetofobia's topic in Web Hosting Support
opaque...the problem is with the server... u have to know what the misconfiguration is.i host my site in another server and it works. (now the server everywebhost.com is down).i like Xisto and would like to find out what the problem is so that i can host my site here. i really like the forums....saludos desde méxico -
anyway... thank u very much for your help !!
-
hello... the problem wasn't my code... the problem is the server.. Xisto.com i had to change my hosting to everywebhost.com and it works properly, but that server has been down for 3 hours so far.. My Website greetings from mĂŠxico
-
can't load a .SWF need some help please
panquetofobia replied to panquetofobia's topic in Web Hosting Support
<table style="width:100%"><tr><td align="left"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="150" height="112"> <param name="movie" value="./swf/ernest.swf"> <param name=quality value=high> <embed src="./swf/ernest.swf" quality=high pluginspage="https://get.adobe.com/flashplayer/otherversions/; type="application/x-shockwave-flash" width="150" height="112"></embed> </object></td><td align="center"> <img src="./imgs/emba.gif" width="312" height="56" align="absmiddle"> </td><td align="right"><img src="./imgs/nube.jpg" width="237" height="112"></td></tr><tr><td colspan="3" background="./imgs/fondobarra.gif"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="770" height="45"> <param name="movie" value="./swf/barnav.swf"> <param name=quality value=high> <embed src="./swf/barnav.swf" quality=high pluginspage="https://get.adobe.com/flashplayer/otherversions/; type="application/x-shockwave-flash" width="770" height="45"></embed> </object></td></tr></table> hello... my swf files are correctly written.... i don't know what to do..... ... -
hello... my .swf files (navigation bar and logo) don't load... the paths r ok. it works on my pc... is it a misconfiguration of the server? i would really appreciate if sb could help me... nice greetings from México... ernest::
-
hello... i got a problem... i used flash, dreamweaver, photoshop, fireworks and of course..html with php scripting....... the problem is that the .swf files don't load properly. i changed the paths and permissions and the website is still working umproperly... DOES ANYBODY KNOW HOW CAN I WORK IT OUT? my website.... still under construction... thanks greetings from MĂXICO....
-
hello!... i wonder if somebody could help me... my website has a flash logo and navigation bar , but they don't load properly... i have changed the paths but it still doesn't..... any idea??
-
hello!i read some months ago that illegal copies of the beta version have been stored on universities servers without permission..i searched for it on the kazaa network and i found a lot of files.it is also available in some warez sites.it was supposed to be released on 2005 right? i really like windows and i can wait....greetings from MÉXICO
-
doesn't it slows down the connection ??
-
business:oscommercecms:postnukeforum: vbbserver manage:cpaneleditor: phpeditgreetings from MÉXICO
-
i use dreamweaver mx 2004 pro, phpEdit, and sometimes fireworks mx 2004 pro, for coding.and of course photoshop cs for the graphics.
-
hello!sothink swf decompiler mx 2005 supports exporting the whole movie in *.fla format..... u can find out more info at sothink.com/flashdecompilergreetings from MÉXICO !!