[JBGO]

Hello !

Help me, please !! It's driving me mad !

I've got that code here :

<?php
require ('database_site.php');
 
 
$monde ='ALPHA'; //database name
$nom_url_fichiers = array(  
					array(  'Index' => "fichier1", 
							'Nom_Table' => "alpha_alliances",
							'Url_Fichier' => "/home/a6536850/public_html/fr/stats/cron/alliances.txt" 
					),
					array(  'Index' => "fichier2", 
							'Nom_Table' => "alpha_towns",
							'Url_Fichier' => "fr/stats/mondes/$monde/data/towns.txt" 
					),   
					array(  'Index' => "fichier3", 
							'Nom_Table' => "alpha_players",
							'Url_Fichier' => "../mondes/$monde/data/players.txt" 
					),
					array(  'Index' => "fichier4", 
							'Nom_Table' => "alpha_conquers",
							'Url_Fichier' => "../mondes/$monde/data/conquers.txt"
					),   
					array(  'Index' => "fichier5", 
							'Nom_Table' => "alpha_player_kills_att",
							'Url_Fichier' => "../mondes/$monde/data/player_kills_att.txt" 
					),   
					array(  'Index' => "fichier6", 
							'Nom_Table' => "alpha_player_kills_def",
							'Url_Fichier' => "../mondes/$monde/data/player_kills_def.txt" 
					),
					array(  'Index' => "fichier7", 
							'Nom_Table' => "alpha_player_kills_all",
							'Url_Fichier' => "../mondes/$monde/data/player_kills_all.txt"
					),   
					array(  'Index' => "fichier8", 
							'Nom_Table' => "alpha_alliance_kills_att",
							'Url_Fichier' => "../mondes/$monde/data/alliance_kills_att.txt" 
					),   
					array(  'Index' => "fichier9", 
							'Nom_Table' => "alpha_alliance_kills_def",
							'Url_Fichier' => "../mondes/$monde/data/alliance_kills_def.txt" 
					),
					array(  'Index' => "fichier10", 
							'Nom_Table' => "alpha_alliance_kills_all",
							'Url_Fichier' => "../mondes/$monde/data/alliance_kills_all.txt"
					),   
					);
 
 
foreach( $nom_url_fichiers as $fichiers ) {	
		$urlfichier = $fichiers['Url_Fichier'] or die('non mis à jour1'.mysql_error());
		$nomtable = $fichiers['Nom_Table'] or die('non mis à jour2'.mysql_error());
		mysql_query("TRUNCATE TABLE $nomtable") or die('non mis à jour3'.mysql_error());
		$sql = "LOAD DATA INFILE '$urlfichier' INTO TABLE $nomtable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\\\' LINES TERMINATED BY '\\n'" or die('non mis à jour4'.mysql_error());
        mysql_query($sql) or die('Problème avec LOAD DATA INFILE</br></br>'.mysql_error());
		}
 
		echo ' Rendez-vous dans 1 h pour la prochaine MAJ !';
		
		?>

And it returns me :

Problème avec LOAD DATA INFILE

Access denied for user 'a6536850_gt'@'10.1.1.17' (using password: YES)

The files exists, I tried the full path links ... nothing

Host, username, password is fine ! not localhost ... and the support told me that it was allowed ...

PLEASE HELP !!!!

[ShocK]

What are you using instead of localhost? Should look something like this - mysqlXX.000webhost.com

[JBGO]

I'm not ^^ That's why I don't understand ..

<?php
$host ='mysql4.000webhost.com'; //database location
$user ='a6536850_gt'; //database username
$pass ='XXXX'; //database password
$db ='a6536850_general'; //database name

$link_stats=mysql_connect($host, $user, $pass) or die ('Erreur : '.mysql_error());
mysql_select_db($db) or die ('Erreur : '.mysql_error());
?>

[tas]

Are you sure you specify Host correctly?

If you are then maybe check this instead,

http://dev.mysql.com/doc/refman/5.1/...ss-denied.html

[JBGO]

What is strange is when I change to Insert Into it works ...

[JBGO]

Ok ... I need a "LOCAL" because otherwise, it takes the file in the mysql file ....

non mis à jourFile 'c:\wamp\bin\mysql\mysql5.5.16\mondes\ALPHA\data\t owns.txt' not found (Errcode: 2)

In my localhost ...


But "local" is desactivated ... help !!

[JBGO]

"".$_SERVER['DOCUMENT_ROOT']."/stats/mondes/$monde/data/alliances.txt"

I know why ! I tried on my local host and I had to do that to have the file !!

But how to do it in 000webhost ...

[JBGO]

Please !!!

An idea ??

[JBGO]

Pleaseee I'm completly bloqued

[JBGO]

Is somebody going to find a solution ?? I'm getting a bit fed up of waiting 12 h to have at the end a copy/past reply of what I just said before !!

Can I have a solution OR have I just got to leave to another HOST ? It's NOT too difficult for you ... EVEN small hosts like olympe-network and azok offers that function !

Problème of GRANT ? If I've got to use a INSERT INTO, I will do it but your hosts are going to suffer !

I don't like to shout like that but my site is bloqued and It's getting on my nerves .. when the rest is ready !

Please ! Answer !