vb.org Archive
Page 22 of 23 « First 122021 22 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   News & Email Community Bulletin Generator (https://vborg.vbsupport.ru/showthread.php?t=32517)

MaxScript 10-22-2003 08:04 PM
vb3 b7 ?

can we get it to work there ?

vfxtalk 03-07-2004 06:17 AM
any chance we could revive this hack for vB 3 ?? would be a fantastic hack!!

diettalk 03-07-2004 10:06 AM
Here...

Quote:
Originally Posted by vfxtalk
any chance we could revive this hack for vB 3 ?? would be a fantastic hack!!

memobug 03-08-2004 09:22 PM
I am pretty sure there is a bug in this hack that prevents you from adding new members!

1) Whenever I try a to manually add a new user with admin cp, I get a MYSQL error that says

"Column count doesn't match value count at row 1"

It dumps the terms, which I compared and they don't add up.

I looked at step 2
PHP Code:
2 of 4
Then Find This:
    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')");

Replace With:
    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,receivebulletin,receivebulletin_type,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$receivebulletin',      (THERE SHOULD BE A '$receivebulletin_type', here!!!!!)                                    '$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')"); 
And it looks like '$receivebulletin_type', is missing from the REPLACE WITH section. I added it back in and everything seems to be fine.

Could someone verify this, please?

Gary King 03-08-2004 11:06 PM
[QUOTE=memobug]I am pretty sure there is a bug in this hack that prevents you from adding new members!

1) Whenever I try a to manually add a new user with admin cp, I get a MYSQL error that says

"Column count doesn't match value count at row 1"

It dumps the terms, which I compared and they don't add up.

I looked at step 2
PHP Code:
2 of 4
Then Find This:
    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')");

Replace With:
    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,receivebulletin,receivebulletin_type,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$receivebulletin',      (THERE SHOULD BE A '$receivebulletin_type', here!!!!!)                                    '$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')"); 
And it looks like '$receivebulletin_type', is missing from the REPLACE WITH section. I added it back in and everything seems to be fine.

Could someone verify this, please?

memobug 03-08-2004 11:19 PM
I would appreciate it if you would take another look Gary. I just downloaded the hack again from Post #1 in this thread for comparison with what I installed months ago and that parameter($receivebulletin_type) is definitely missing from the VALUES portion of the replacement string.

Whether you do or don't have it - can you verify that you can add a forum member manually - from admin cp USER->ADD - without getting a PHP error on submit?

Thanks & regards,

Matt

Gary King 03-08-2004 11:38 PM
[QUOTE=memobug]I would appreciate it if you would take another look Gary. I just downloaded the hack again from Post #1 in this thread for comparison with what I installed months ago and that parameter($receivebulletin_type) is definitely missing from the VALUES portion of the replacement string.

Whether you do or don't have it - can you verify that you can add a forum member manually - from admin cp USER->ADD - without getting a PHP error on submit?

Thanks & regards,

Matt

Highlander 04-03-2004 05:11 AM
WHHOOOOPSS .. great great HACK .. *installed*

memobug 04-03-2004 06:23 AM
Highlander, would you verify whether YOU can use the Admin panel to manually add a member without having an SQL error?

(Maybe it is just the version of SQL I am running that wants the term count to match the values)

Regards,

Matt

P.S. For some odd reason, I got three copies of the notification email for your post!

Highlander 04-06-2004 03:01 AM
.. threa mails?
i get no errors when i start a bulletin and write a username in the file dof the Comm Generator ..did you mean that?

or where else i can write a username in a field?

Wich version do you have? Maybe PHP Version problem.. i have 4.06 thats very old.. and i have to change very often manually some things.. you see the string and error in his exact place..so you can locate the string who do this error..so you can look for changing it to make it right

greating


All times are GMT. The time now is 05:04 AM.
Page 22 of 23 « First 122021 22 23
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01521 seconds
  • Memory Usage 1,796KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete