[ dozetfkvsv @ 05.05.2013. 16:27 ] @
juce sam ustanovio da je vise od 100.000 artikala ubacno u korpu za kupovinu. na mom sajtu koji mi sluzi kao foto arhiva i nema korisnike. obrisao sam upise i video da se svake sekunde povecava njihov broj za nekoliko upisa. sve adrese su 66.249.64.0 - 66.249.95.255 kao i gomila adresa iy kine. ovo mi deo fajla koji se odnosi na korpu. primetite li gresku u kodu? Code: //The function adds an item to the shopping cart function shopping_cart_add($params) { global $_SESSION; global $global_settings; global $db; global $rs; global $ds; $cart_id=shopping_cart_id(); //Remove old carts $sql="select id from carts where id<>".$cart_id." and data<".(mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y"))-2*3600); $rs->open($sql); while(!$rs->eof) { $sql="select id_parent from carts_content where id_parent=".$rs->row["id"]; $ds->open($sql); if($ds->eof) { $sql="delete from carts where id=".$rs->row["id"]; $db->execute($sql); } $rs->movenext(); } if($cart_id!=0) { //Files if($params["item_id"]!=0) { $sql="select id_parent from carts_content where id_parent=".$cart_id." and item_id=".$params["item_id"]; $rs->open($sql); if($rs->eof) { $sql="insert into carts_content (id_parent,item_id,prints_id,publication_id,quantity,option1_id,option1_value,option2_id,option2_value,option3_id,option3_value) values (".$cart_id.",".$params["item_id"].",".$params["prints_id"].",".$params["publication_id"].",".$params["quantity"].",".$params["option1_id"].",'".$params["option1_value"]."',".$params["option2_id"].",'".$params["option2_value"]."',".$params["option3_id"].",'".$params["option3_value"]."')"; $db->execute($sql); } } //Prints if($params["prints_id"]!=0) { $sql="insert into carts_content (id_parent,item_id,prints_id,publication_id,quantity,option1_id,option1_value,option2_id,option2_value,option3_id,option3_value) values (".$cart_id.",".$params["item_id"].",".$params["prints_id"].",".$params["publication_id"].",".$params["quantity"].",".$params["option1_id"].",'".$params["option1_value"]."',".$params["option2_id"].",'".$params["option2_value"]."',".$params["option3_id"].",'".$params["option3_value"]."')"; $db->execute($sql); } } return $cart_id; } //End. The function adds an item to the shopping cart |