Odgovorov v temi: 1931

[MihaSkipster]

Ali kdo ve kaj manjka tej proizvedbi?

sql_query("INSERT INTO news (name,date,by,active,bes) VALUES ('".$news_name."' , '".$date."' , '".$by."' , '".$active."' , '".$news_bes."' )");

[cyberlukir]

MihaSkipster, ti javi kak error?

[MihaSkipster]

Jap:

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 'by,active,bes) VALUES ('Novica' , '05.05.2006 , 20:22:44' , 'Miha' , '1' , 'N' at line 1

[mlavta1]

$koda_baner = <IFRAME SRC='http://www.aegnor.net/prikaz.php?id=$id' width=468 height=60 marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling=no></IFRAME>;

Kako narediš, da se ti pti tem ne pokaže slika ampak koda? Takrat ko daš echo ,..
lp

[MihaSkipster]

Da se ti koda izpise na zaslon?

htmlspecialchars($koda_baner);

[HeXeR]

Pozdravljeni,

jaz pa imam kodo

<?php

$clanid="42575";

function startTag($parser, $name, $attrs) {
global $stack;

$tag = array("name"=>$name,"attrs"=>$attrs);
array_push($stack,$tag); ## NAPAČA
}









function cdata($parser, $cdata) {
global $stack;

$stack[count($stack)-1]['cdata'] .= $cdata;
}

function endTag($parser, $name) {
global $stack;

$stack[count($stack)-2]['children'][] = $stack[count($stack)-1];
array_pop($stack);
}


// Parse XML

$stack = array();
$claninfo = array();
$clanstats = array();
$playerstats = array();

$xml_parser = xml_parser_create();
xml_set_element_handler($xml_parser, "startTag", "endTag");
xml_set_character_data_handler($xml_parser, "cdata");

$xmllink="http://aaotracker.4players.de/livefeed/xml_clanprofile.php?clanid=$clanid";
$data = xml_parse($xml_parser,file_get_contents($xmllink));
if(!$data) die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser)));

xml_parser_free($xml_parser);


// Get Data

// Get Clan Profile Data
for($i = 0; $i < sizeof($stack[0][children][0][children]); $i++) {
$valname=$stack[0][children][0][children][$i][name];
$claninfo[$valname]=$stack[0][children][0][children][$i][cdata];
}

// Get Clan Stats Data
for($i = 0; $i < sizeof($stack[0][children][1][children]); $i++) {
$valname=$stack[0][children][1][children][$i][name];
$clanstats[$valname]=$stack[0][children][1][children][$i][cdata];
}

// Get Player Data
for($i = 0; $i < sizeof($stack[0][children][2][children]); $i++) {
for($x = 0; $x < sizeof($stack[0][children][2][children][$i][children]); $x++) {
$valname=$stack[0][children][2][children][$i][children][$x][name];
$value=$stack[0][children][2][children][$i][children][$x][cdata];
if($valname=="PLAYERID") $pid=$value;
$playerstats[$pid][$valname]=$value;
}
}

// Now we have 3 arrays with all stats and infos
// print_r($claninfo);
// print_r($clanstats);
// print_r($playerstats);

// Display Clan Info
#$content .= "Clan Info:<br>n";

#foreach($claninfo as $key => $value) {
# $content .= "$key: $value<br>n";
#}


// Display Clan Stats
#$content .= "<br><br>Clan Info:<br>n";

#foreach($clanstats as $key => $value) {
# $content .= "$key: $value<br>n";
#}

// Display Player Stats
# Edited by HeXeR

if (eregi("block-aa.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}



$content .= "<center><table align="center"><tr align="center"><td align="center">";

$content .= "Leaders:<br>n";

foreach($playerstats as $key => $value) {
$playername=$playerstats[$key][PLAYERNAME];
$playerhonor=$playerstats[$key][PLAYERHONOR];
$playerurl=$playerstats[$key][PLAYERSTATSURL];

if($playerstats[$key][PLAYERSTATUS]=="1") {
$statuspic="ponline.gif";
} else {
$statuspic="poffline.gif";
}

if ($playername == "-=[USS]=-Godfather"){
$content .= "<img border='0' src='./images/clan_leader.jpg'> <a target='_blank' href='$playerurl'><font size='2' color='#000000'>$playername <img border='0' src='./images/$statuspic'></font></a><br>";
}

if ($playername == "-=[USS]=-Pretorian"){
$content .= "<img border="0" src="./images/clan_leader.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
}







$content .= "<br>Members:<br>n";

foreach($playerstats as $key => $value) {
$playername=$playerstats[$key][PLAYERNAME];
$playerhonor=$playerstats[$key][PLAYERHONOR];
$playerurl=$playerstats[$key][PLAYERSTATSURL];

if($playerstats[$key][PLAYERSTATUS]=="1") $statuspic="ponline.gif";
else $statuspic="poffline.gif";

if ($playername == "-=[USS]=-SilentGun"){
$content .= "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
if ($playername == "-=[USS]=-General_"){
$content .= "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
if ($playername == "-=[USS]=-Calimero"){
$content .= "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
if ($playername == "-=[USS]=-]ExTrEmE[!"){
$content .= "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
if ($playername == "-=[USS]=-Razparac"){
$content .= "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
if ($playername == "-=[USS]=-}jst{"){
$content .= "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";
}
}










$content .= "</td></tr>";
$content .= "<tr align="center"><td align="center">";
$content .= "</td></tr>";
$content .= "</table></center>";
$content .= "<center><TABLE align="center">";
$content .= "<TR align="center"><TD align="center">";
$content .= "</TD></TR>";

$content .= "</TABLE></center><br>";


?>

zaradi 9 vrstice dobim to napako

Warning: array_push() [function.array-push]: First argument should be an array in /usr/home/users/1a/hexer/www/unknowhost.up.md/blocks/block-aa.php on line 9

9 vrstica

array_push($stack,$tag); ## NAPAČA

koda deluje čisto ok brez napak, ko pa jod dam v PHP-Nuke block pa mi javi tole .... kar sem zgoraj opisal, ve kdo zakaj in kako rešit ta problem ?

[Pimqek]

HeXeR, preprosti prevod, prvi argument mora biti polje.

[HeXeR]

zakaj pa koda deluje ko je sama ko je v php nuke bloku pa ne ? Pa povej mi prosim kaj bi moral spremenit ker nisem razumel čisto ....

koda ko ni v PHPNuke blocku

<?php

#$clanid="1";

$clanid="42575";



function startTag($parser, $name, $attrs) {

 global $stack;



 $tag=array("name"=>$name,"attrs"=>$attrs); 

 array_push($stack,$tag);

}



function cdata($parser, $cdata) {

 global $stack;



 $stack[count($stack)-1]['cdata'] .= $cdata;   

}



function endTag($parser, $name) {

 global $stack;



 $stack[count($stack)-2]['children'][] = $stack[count($stack)-1];

 array_pop($stack);

}





// Parse XML



$stack = array();

$claninfo = array();

$clanstats = array();

$playerstats = array();



$xml_parser = xml_parser_create();

xml_set_element_handler($xml_parser, "startTag", "endTag");

xml_set_character_data_handler($xml_parser, "cdata");



$xmllink="http://aaotracker.4players.de/livefeed/xml_clanprofile.php?clanid=$clanid";

$data = xml_parse($xml_parser,file_get_contents($xmllink));

if(!$data) die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser)));



xml_parser_free($xml_parser);





// Get Data



 // Get Clan Profile Data

 for($i = 0; $i < sizeof($stack[0][children][0][children]); $i++) {

  $valname=$stack[0][children][0][children][$i][name];

  $claninfo[$valname]=$stack[0][children][0][children][$i][cdata];

 }



 // Get Clan Stats Data

 for($i = 0; $i < sizeof($stack[0][children][1][children]); $i++) {

  $valname=$stack[0][children][1][children][$i][name];

  $clanstats[$valname]=$stack[0][children][1][children][$i][cdata];

 }



 // Get Player Data

 for($i = 0; $i < sizeof($stack[0][children][2][children]); $i++) {

  for($x = 0; $x < sizeof($stack[0][children][2][children][$i][children]); $x++) {

   $valname=$stack[0][children][2][children][$i][children][$x][name];

   $value=$stack[0][children][2][children][$i][children][$x][cdata];

   if($valname=="PLAYERID") $pid=$value;

   $playerstats[$pid][$valname]=$value;

  }

 }



// Now we have 3 arrays with all stats and infos

// print_r($claninfo);

// print_r($clanstats);

// print_r($playerstats);



// Display Clan Info

#echo "<b>Clan Info:</b><br>n";



#foreach($claninfo as $key => $value) {

# echo "$key: $value<br>n";

#}





// Display Clan Stats

#echo "<br><br><b>Clan Info:</b><br>n";



#foreach($clanstats as $key => $value) {

# echo "$key: $value<br>n";

#}



// Display Player Stats

# Edited by HeXeR







echo "<b>Leaders:</b><br>n";



foreach($playerstats as $key => $value) {

 $playername=$playerstats[$key][PLAYERNAME];

 $playerhonor=$playerstats[$key][PLAYERHONOR];

 $playerurl=$playerstats[$key][PLAYERSTATSURL];



 if($playerstats[$key][PLAYERSTATUS]=="1") $statuspic="ponline.gif";

 else $statuspic="poffline.gif";



 if ($playername == "-=[USS]=-Godfather"){

  echo "<img border="0" src="./images/clan_leader.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

 

 if ($playername == "-=[USS]=-Pretorian"){

  echo "<img border="0" src="./images/clan_leader.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

}















echo "<br><b>Members:</b><br>n";



foreach($playerstats as $key => $value) {

 $playername=$playerstats[$key][PLAYERNAME];

 $playerhonor=$playerstats[$key][PLAYERHONOR];

 $playerurl=$playerstats[$key][PLAYERSTATSURL];



 if($playerstats[$key][PLAYERSTATUS]=="1") $statuspic="ponline.gif";

 else $statuspic="poffline.gif";



 if ($playername == "-=[USS]=-SilentGun"){

  echo "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

  if ($playername == "-=[USS]=-General_"){

  echo "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

  if ($playername == "-=[USS]=-Calimero"){

  echo "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

  if ($playername == "-=[USS]=-]ExTrEmE[!"){

  echo "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

  if ($playername == "-=[USS]=-Razparac"){

  echo "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

  if ($playername == "-=[USS]=-}jst{"){

  echo "<img border="0" src="./images/clan_trial.jpg"> <a target="_blank" href="$playerurl"><font size="2" color="#000000">$playername <img border="0" src="./images/$statuspic"></font></a><br>";

 }

}

?>

in DELUJE !!!

tak da mi ni več čitso jasno tole

[mcgusto]

Lp mene zanima s kakssno kodo povezem dve strani da bo v tejle strani
www.trb-folk.net/slike.html se tale stran http://www.trb-folk.net/minigal/
ne pridem nikakor skupaj vse sem ze poskusil prebral tudi kar nekaj vendar ni in ni :S

aja in slike.html je prejsnja sedaj je www.trb-folk.net/slike.php



hvala za odgovore


edit: dodati sem mislil s tem
<?PHP
include("/minigal/index.php");
?></p>

je prav ??

[mlavta1]

V bazi imam vpisane razne točke,.. Ena vrstica je zaradi prijave v sistem, drzga zaradi povabila,.. Kako bi naredil da mi vse skupaj sešteje. Se pravi sešteje vse točke pod id-jem ena,..
Kako?
LP

[Pimqek]

mlavta1, http://dev.mysql.com...nting-rows.html

[mlavta1]

Sej sm res zabit! :joj: :joj:
To sm že nevemkolkrat uporablu,... Samo kaj naj bi s tistim uporablju GROUP BY?
Hvala

[joe14]

Oj!

Zanima me, če obstaja kakšen atribut (al nevem kako bi se temu reklo), ki bi bil enak "a" le, da bi kazalec (pointer -> slovenski izrazi mi ne grejo najbolje ) bil na začetku dokumenta......

Če me ne razumete prosim poglejte http://www.w3schools...hp/php_file.asp in vam bo vse jasno, kaj me zanima ......

Hvala

joe14

[publikum]

Seveda obstaja, samo prebrati moraš: to je parameter x.

File pointer at the beginning of the file.

[MihaSkipster]

Imam en problem.. Imam polje, iz mysql baze:

$site_settings = sql_array(sql_query("SELECT * FROM site_settings"));

Torej to gre, vredi, pol pa dam:

echo $site_settings['welcome'];

In mi ven vrze to:

<

Ve kdo v čem je problem?

[joe14]

Seveda obstaja, samo prebrati moraš: to je parameter x.

File pointer at the beginning of the file.

Težava je v tem:

Create and open for write only. File pointer at the beginning of the file. If the file already exists, the fopen() call will fail and generate an error. If the file does not exist, try to create it

, ker jaz vem, da bo dototeka že obstajala.......

[bujes]

<?

//Skripta za naključno šalo



			//poezava z bazo

include('povezava1.php');

mysql_select_db("kozolec_portal") or die();

			

//Preverjanje števila vpisov	

$poizvedba1 = mysql_query("SELECT * FROM 'smeh'");

$stevilo = mysql_num_rows($poizvedba1);	

			

//Pridobivanje naključnega IDja

$id=rand(0,$stevilo);



//Poizvedba o šali

$sala=mysql_query("SELECT * FROM `smeh` WHERE id='$id'");



$naslov = $sale['naslov'];

$vic = $sale['vic'];



//Izpis šale

echo "<b>".$naslov."</b><br>".$vic."<a href='http://smeh.kozolec.net'>Več šal...</a>";

?>

A mi lahko kdo pove, zakaj ne dela?

Vrže pa error v tej vrsti:
$stevilo = mysql_num_rows($poizvedba1);

[joe14]

Mogoče dvojni narekovaji? Ugibam!

[mlavta1]

Kakšen error ti pa vrže?

[publikum]

bujes, najprej preveri, če je sploh poizvedba uspela, preden dalje operiraš z njenimi rezultati...

To je tako, kot da bi v tovarni delali izdelke in če enega vmes ne bi uspeli narediti, bi kar lepo zapakirali prazno škatlo, brez da bi pogledali, kaj bodo sploh dali notri...