phpbb_copy_users

Advertise a phpBB hack or request help with an existing one.

Moderator: TerraFrost

Postby 19_Chevelle_69 » Wed Jan 05, 2005 3:55 am

I'm glad I could help, even in such a small way.

Take care, and I look forward to seeing a nice resource-light content transfer hack in the future.

Don
http://www.chevylegends.com
Don

19_Chevelle_69
http://www.chevylegends.com
19_Chevelle_69
Traveler
 
Posts: 19
Joined: Mon Jan 03, 2005 12:28 am

Postby TerraFrost » Thu Jan 06, 2005 7:00 am

for all zero people who care, heh, the problem in copy_users.php was caused by the fact that array_diff kept the original indexes. this meant that when going through the array with a for loop (as opposed to a foreach loop) wouldn't result in every element being hit upon. the following php script demonstrates the problem:

Code: Select all
<?
  $test1 = array('a','b','c');
  $test2 = array('b');
  $test3 = array_diff($test1,$test2);
  for ($num=1;$num<=count($test3);$num++)
    echo "$num. {$test3[$num-1]}<br>";
  print_r($test3);
?>

the output is as follows:

Code: Select all
1. a
2.
Array ( [0] => a [2] => c )
TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby 19_Chevelle_69 » Fri Jan 07, 2005 12:49 am

OK, so for people who don't know coding, like me, what does this mean for your copy_users, and is it fixable?
Don

19_Chevelle_69
http://www.chevylegends.com
19_Chevelle_69
Traveler
 
Posts: 19
Joined: Mon Jan 03, 2005 12:28 am

Postby TerraFrost » Fri Jan 07, 2005 6:19 am

yup - it's fixable. i'll have a new version out later today, in fact :)

EDIT: and the new version is out. it can be downloaded here.
TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby ~HG~ » Tue Jan 11, 2005 8:25 pm

I get this error message when I try to run copy users. What does this mean please ???

Code: Select all
Error 1064: You have an error in your SQL syntax near 'user_custitle,user_specmsg,user_effects,user_privs) VALUES ( '4','1','~HG~','2f3' at line 1 with the following SQL query:
INSERT INTO phpbb_users (user_id,user_active,username,user_password,user_session_time,user_session_page,user_lastvisit,user_regdate,user_level,user_posts,user_timezone,user_style,user_lang,user_dateformat,user_new_privmsg,user_unread_privmsg,user_last_privmsg,user_emailtime,user_viewemail,user_attachsig,user_allowhtml,user_allowbbcode,user_allowsmile,user_allowavatar,user_allow_pm,user_allow_viewonline,user_notify,user_notify_pm,user_popup_pm,user_rank,user_avatar,user_avatar_type,user_email,user_icq,user_website,user_from,user_sig,user_sig_bbcode_uid,user_aim,user_yim,user_msnm,user_occ,user_interests,user_actkey,user_newpasswd,,user_custitle,user_specmsg,user_effects,user_privs) VALUES ( '4','1','~HG~','2f393e758324ec86b03d27d30a8a9cd1','0','441','0','1105475098','0','0','10.00','2','english','D M d, Y g:i a','0','0','0','0','1','1','1','1','1','1','1','1','0','0','1','0','Staff/HG01.gif','3','admin@angells-au.com','','http://www.galahscorner.com','The BEST bloody Gumtree in the Land','[color=chocolate:7f2f358de5]Galahs Corner is your site that makes winning [b:7f2f358de5]EASY,[/b:7f2f358de5] freebies [b:7f2f358de5]FREE,[/b:7f2f358de5] forums[b:7f2f358de5] FUN[/b:7f2f358de5] and rewards [b:7f2f358de5]REWARDABLE!!![/b:7f2f358de5][/color:7f2f358de5]','7f2f358de5','','','rodangell@hotmail.com','Webmaster','Web Design','','','','ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0','','ßnoÞ0ßnoÞ0ßnoÞ0','ßnoÞ0ßnoÞ0ßnoÞ0'),( '5','1','CrocMan','0542d0e2da8a3909374055e2b9b9ac0f','0','-1','0','1105475098','0','0','10.00','2','english','D M d, Y g:i a','0','0','0','0','0','1','1','1','1','1','1','1','0','0','1','0','','0','basho22@excite.com','','','','','','','','','','','','','','ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0','','ßnoÞ0ßnoÞ0ßnoÞ0','ßnoÞ0ßnoÞ0ßnoÞ0'),( '6','1','Petes','478a23ed7d3b6a80cf6f7138b519ee5d','0','0','0','1105475098','0','0','10.00','2','english','D M d, Y g:i a','0','0','0','0','0','1','1','1','1','1','1','1','0','1','1','0','','0','... QUERY TRUNCATED
Terminating Script.
~HG~
~HG~
Traveler
 
Posts: 7
Joined: Sun Jan 02, 2005 4:23 am
Location: Australia

Postby TerraFrost » Tue Jan 11, 2005 9:59 pm

off hand, i don't know. i'll get back to you, though, after my job (which begins in about 1 minute).
TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby HeRCuL70 » Mon May 16, 2005 12:32 am

i have some problem at phpbb 2.0.14

Code: Select all
Warning: mysql_connect(): Unknown MySQL Server Host 'dbhost' (0) in /home/pcdgorg/public_html/adult/db/mysql4.php on line 48

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 110

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 118

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 118

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 118

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 118

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 118

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/pcdgorg/public_html/adult/db/mysql4.php on line 118

Warning: Cannot modify header information - headers already sent by (output started at /home/pcdgorg/public_html/adult/db/mysql4.php:48) in /home/pcdgorg/public_html/adult/includes/page_header.php on line 665

Warning: Cannot modify header information - headers already sent by (output started at /home/pcdgorg/public_html/adult/db/mysql4.php:48) in /home/pcdgorg/public_html/adult/includes/page_header.php on line 667

Warning: Cannot modify header information - headers already sent by (output started at /home/pcdgorg/public_html/adult/db/mysql4.php:48) in /home/pcdgorg/public_html/adult/includes/page_header.php on line 668


How can i fix it?

Tanks for your helps.
HeRCuL70
Traveler
 
Posts: 1
Joined: Mon May 16, 2005 12:29 am

Postby TerraFrost » Mon May 16, 2005 3:00 am

hmmm. i have no idea if i ever helped ~HG~ fix his problem...

anyway, in your case, HeRCuL70, is your database really dbhost? localhost usually works, but if it doesn't, whatever's assigned to $dbhost in config.php should be it.
TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby Anthony.B » Mon May 23, 2005 5:50 pm

I am getting the following message:

Code: Select all
Error 1054: Unknown column 'user_points' in 'field list' with the following SQL query:
INSERT INTO nuke_users (user_id,user_active,username,user_password,user_session_time,user_session_page,user_lastvisit,user_regdate,user_level,user_posts,user_timezone,user_style,user_lang,user_dateformat,user_new_privmsg,user_unread_privmsg,user_last_privmsg,user_emailtime,user_viewemail,user_attachsig,user_allowhtml,user_allowbbcode,user_allowsmile,user_allowavatar,user_allow_pm,user_allow_viewonline,user_notify,user_notify_pm,user_popup_pm,user_rank,user_avatar,user_avatar_type,user_email,user_icq,user_website,user_from,user_sig,user_sig_bbcode_uid,user_aim,user_yim,user_msnm,user_occ,user_interests,user_actkey,user_newpasswd,user_points,user_custitle,user_specmsg,user_effects,user_privs,user_firstpost) VALUES ( '4','1','bowescol','81dc9bdb52d04dc20036dbd8313ed055','0','0','0','May 23, 2005','0','0','0.00','1','english','D M d, Y g:i a','0','0','0','0','0','1','0','1','1','1','1','1','0','1','1','0','http://img.photobucket.com/albums/v27/crocodilehuntrfan/creepy2.gif','2','lvurobbie@aol.com','','http://www.customhomedecorations.com','Utah','[img:c41369d5ce]http://img.photobucket.com/albums/v27/crocodilehuntrfan/Bowescols-TB.gif[/img:c41369d5ce]','c41369d5ce','','','','Mother to my kiddos, and wife to my wonderful husband!','Steve and Terri Irwin, wildlife, football, and collecting.','','','0','ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0','','ßnoÞ0ßnoÞ0ßnoÞ0','ßnoÞ0ßnoÞ0ßnoÞ0','0'),( '5','1','lynn','dc420563e5dd1c2f8f04c3e08993e948','0','7','0','May 23, 2005','0','0','-5.00','1','english','D M d, Y g:i a','0','0','0','0','0','1','1','1','1','1','1','0','1','1','1','0','','0','seisho@tampabay.rr.com','','','tampabay florida','','','','','','','','','','0','ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0','','ßnoÞ0ßnoÞ0ßnoÞ0','ßnoÞ0ßnoÞ0ßnoÞ0','0'),( '6','1','dizzygizzy','c6c208bc5982936664074fa700da348c','0','0','0','May 23, 2005','0','0','-4.00','1','english','D M d, Y g:i a','0','0','0','0','0','1','0','1','1','1','1','1','0','1','1','0','http... QUERY TRUNCATED
Terminating Script.


Can you tell me what I did wrong please?
Anthony.B
Traveler
 
Posts: 1
Joined: Mon May 23, 2005 5:42 pm
Location: FL

Postby TerraFrost » Mon May 23, 2005 8:02 pm

Are you using the latest verson of Copy Users? You can download it here:

http://www.frostjedi.com/terra/scripts/ ... _users.zip

If not, then could you provide me with a temp. FTP account that I could use to diagnose / fix this?
TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby Drop-Forged » Sat Nov 05, 2005 11:32 pm

This is the error I got..


Error 1054: Unknown column 'user_custitle' in 'field list' with the following SQL query:
INSERT INTO phpbb_users (user_id,user_active,username,user_password,user_session_time,user_session_page,user_lastvisit,user_regdate,user_level,user_posts,user_timezone,user_style,user_lang,user_dateformat,user_new_privmsg,user_unread_privmsg,user_last_privmsg,user_emailtime,user_viewemail,user_attachsig,user_setbm,user_allowhtml,user_allowbbcode,user_allowsmile,user_allowavatar,user_allow_pm,user_allow_viewonline,user_notify,user_notify_pm,user_notify_donation,user_popup_pm,user_rank,user_avatar,user_avatar_type,user_email,user_icq,user_website,user_from,user_sig,user_sig_bbcode_uid,user_aim,user_yim,user_msnm,user_occ,user_interests,user_actkey,user_newpasswd,user_realname,user_gender,user_birthday,user_last_birthday,user_home_phone,user_home_fax,user_work_phone,user_work_fax,user_cellular,user_pager,user_summer_time,user_list_option,user_allow_email,user_allow_website,user_allow_real,user_allow_sig,user_viewpm,user_viewwebsite,user_viewreal,user_viewavatar,user_viewsig,user_viewimg,user_buddy_friend_display,user_buddy_ignore_display,user_buddy_friend_of_display,user_buddy_ignored_by_display,user_watched_topics_per_page,user_privmsgs_per_page,user_sub_forum,user_split_cat,user_last_topic_title,user_sub_level_links,user_display_viewonline,user_announcement_date_display,user_announcement_display,user_announcement_display_forum,user_announcement_split,user_announcement_forum,user_calendar_display_open,user_calendar_header_cells,user_calendar_nb_row,user_calendar_birthday,user_calendar_forum,user_last_topics_from_started,user_last_topics_from_replied,user_last_topics_from_ended,user_last_topics_from_split,user_last_topics_from_forum,user_split_global_announce,user_split_announce,user_split_sticky,user_split_topic_split,user_points,user_unread_topics,user_topics_last_per_page,user_flag,user_holidays,user_warnings,user_rules,rating_status,user_photo,phpBBSecurity_answer,phpBBSecurity_question,phpBBSecurity_login_tries,php... QUERY TRUNCATED
Terminating Script.
Drop-Forged
Traveler
 
Posts: 3
Joined: Sat Nov 05, 2005 11:28 pm

Postby TerraFrost » Sat Nov 05, 2005 11:39 pm

TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby Drop-Forged » Sat Nov 05, 2005 11:39 pm

LOL, I deleted:

// the following few items are for the point system, and associated hacks.
'user_points' => 0,
'user_custitle' => 'ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0ßoffÞ0',
'user_specmsg' => NULL,
'user_effects' => 'ßnoÞ0ßnoÞ0ßnoÞ0',
'user_privs' => 'ßnoÞ0ßnoÞ0ßnoÞ0',

'user_firstpost' => 0 // for my Hide Zero Posters phpBB hack


And it copied the users fine…:lila
Drop-Forged
Traveler
 
Posts: 3
Joined: Sat Nov 05, 2005 11:28 pm

Postby TerraFrost » Sat Nov 05, 2005 11:42 pm

Glad you got it working :)
TerraFrost
Legendary Guard
 
Posts: 12357
Joined: Wed Dec 04, 2002 6:37 am

Postby Drop-Forged » Sat Nov 05, 2005 11:47 pm




I tried that one, no errors…

Great job man… ;)
Drop-Forged
Traveler
 
Posts: 3
Joined: Sat Nov 05, 2005 11:28 pm

PreviousNext

Return to phpBB Hacks and MODs

Who is online

Users browsing this forum: No registered users and 1 guest

cron