1
planetexcel
Re: HELP: Fatal error - Captcha problem

Problem solved... xoops 2.4 I just enabled GD2 and now everything is fine..



2
planetexcel
Re: HELP: Fatal error - Captcha problem

I realised also that the captcha icon in amcontact module doesnt show. I must have deleted something by error i guess but i dont know what...



3
planetexcel
Re: HELP: Fatal error - Captcha problem

A programmer I used to have made this so I can avoid spam registering.. Although its been a long time ago.
Is there a way to fix or even unistall it so the registration works?



4
planetexcel
HELP: Fatal error - Captcha problem

Friends I got this error when someone is trying to register at my website www.planetexcel.gr

Fatal error: Call to undefined function imageCreate() in /----/---/public_html/class/captcha/hn_captcha.class.php on line 544

Can you help me please??



5
planetexcel
Re: wf-section w/pdf and Xoops 2.4 problems

I have the same initial problem. Did you fix it? Can you please tell me witch files you changed and how?



6
planetexcel
Re: Is there a query to add users in a batch?

I finaly inserted the file through phpadmin import feature. But all members inserted are inactive and without group. Is there an MySQL statement that could fix that?



7
planetexcel
Re: Is there a query to add users in a batch?

// Add real name 
$name $liste[0]; 
// End 

// Add real name 
$uname $liste[1]; 
// End 

// Add real name 
$email $liste[2]; 
// End 

// Add website 
$url $liste[3]; 
// End 

// Add website 
$user_regdate $liste[4]; 
// End

// Add Password 
$passmd5(trim($liste[5]));  
// End 

// Add avatar 
$user_avatar "blank.gif"
// End 

$rank "1"// Choose rank 

$attachsig "1";

$user_mailok "1"// Choose 1 if you allow administrator to send email 


// Add user in xoops_users table 
$query "insert into ".$prefix."_users (name, uname, email, url,user_regdate, pass, user_avatar, rank, attachsig, user_mailok) VALUES ('".$name."','".$uname."', '".$email."','".$url."', '".$user_regdate."', '".$pass."', '".$user_avatar."', '".$rank."', '".$attachsig."', '".$user_mailok."')"

$resultmysql_query($query); 
$uid mysql_insert_id(); 

//Add user in group : registered users per default 
$numgroup ='2';// choose Group number 
$query "insert into ".$prefix."_groups_users_link (groupid, uid) VALUES('".$numgroup."', '".$uid."')"
$resultmysql_query($query); 

if (
mysql_error()){ 
echo 
"Error in database : ".mysql_error(); 
echo 
"</table><br /><br /><b>Importation stoppee.</b><br /><br />"
fclose($fp); 
exit(); 
}else{ 
echo 
"<tr><td> ".$uid." </td><td> ".$uname." </td></tr> "



echo 
"</table><br />Import finished successfully.";// That's ok ! 

fclose($fp); 
?>


I believe this is the right order, but i still get a succesful upload without password, email, and name. Any help?? When i do an import the uid is keep updating. Can i reset it to 2? 1 is the admin user.



8
planetexcel
Re: XOOPS 2.4.x Translations

I did the translation and the rebuild but when i try my language as default the translated content doesnt show up correctly. I believe i have to turn the translated files as a utf-8 but i dont know how.



9
planetexcel
Re: Is there a query to add users in a batch?

I believe also the passwords was not imported..



10
planetexcel
Re: Is there a query to add users in a batch?

Quote:
<?php
// christian@frxoops.org - http://www.frxoops.org
// Import users from a csv or text file into XOOPS 2.3.2
// variables
$bdd= "----";
$host= "localhost";
$user= "-------";
$pass= "-----";
$prefix= "-----"; // tables prefix, without _
$separator = ";";//separator used in original file
$regdate=time();
$fichier = "myimp.csv"; // file name to read


// IMPORTANT : DO NOT LEAVE AN EMPTY LINE IN YOUR ORIGINAL DOCUMENT (file-name.csv)

mysql_connect($host,$user,$pass) or die("Unable to connect Database");
mysql_select_db($bdd);

//Open file for read
if (file_exists($fichier))
$fp = fopen("$fichier", "r");
else{ // unknown file
echo "File not found !<br />Import stopped.";
exit();
}
echo 'Begin file import : <b>'.$fichier.'</b><br /><br />';
echo '<table border="1" cellspacing="3">';
echo '<tr><td>UID</td><td>Pseudo</td>';
// import line by line
while (!feof($fp)){
$ligne = fgets($fp,4096);
$liste = explode($separator,$ligne); //create array


// Add real name
$name = $liste[0];
// End

// Add real name
$uname = $liste[1];
// End

// Add real name
$email = $liste[2];
// End

// Add Password
$pass= md5(trim($liste[5]));
// End

// Add website
$url = $liste[3];
// End

// Add website
$user_regdate = $liste[4];
// End

// Add avatar
$user_avatar = "blank.gif";
// End

$rank = "1"; // Choose rank

$attachsig = "1";

$user_mailok = "1"; // Choose 1 if you allow administrator to send email


// Add user in xoops_users table
$query = "insert into ".$prefix."_users (name, uname, url, user_avatar, user_regdate, user_from, user_sig, pass, rank, user_occ, user_mailok, email) VALUES ('".$name."','".$uname."', '".$email."','".$url."', '".$user_avatar."', '".$regdate."', '".$user_from."', '".$user_sig."', '".$pass."', '".$rank."', '".$user_occ."', '".$user_mailok."')";

$result= mysql_query($query);
$uid = mysql_insert_id();

//Add user in group : registered users per default
$numgroup ='2';// choose Group number
$query = "insert into ".$prefix."_groups_users_link (groupid, uid) VALUES('".$numgroup."', '".$uid."')";
$result= mysql_query($query);

if (mysql_error()){
echo "Error in database : ".mysql_error();
echo "</table><br /><br /><b>Importation stoppee.</b><br /><br />";
fclose($fp);
exit();
}else{
echo "<tr><td> ".$uid." </td><td> ".$uname." </td></tr> ";
}
}

echo "</table><br />Import finished successfully.";// That's ok !

fclose($fp);
?>


I used this. It succesfully entered the unames BUT without the emails and without the regdate, and without the name. What did i did wrong?




TopTop
(1) 2 »



Login

Username:
Password:

Lost Password? Register now!

Who's Online

52 user(s) are online (39 user(s) are browsing Support Forums)


Members: 0


Guests: 52


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits