vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Members Choice voting hack - V2 with usergroup permissions (https://vborg.vbsupport.ru/showthread.php?t=74183)

trafix 02-14-2005 10:09 PM

interesting ... it looks like the script hasnt added the field to teh usergroup table for some reason

PHP Code:

ALTER TABLE `usergroupADD `mcpollingboothINT12 UNSIGNED NOT NULL 


TTG 02-14-2005 10:20 PM

Thanks .. that solved the usergroup permissions update problem.
admincp shows "Members Choice" but no drop down options to edit !?

trafix 02-14-2005 10:24 PM

Yep its all in the readme file, there is 1 option to add to the quick drop down list and a couple to the postbit templates

TTG 02-14-2005 10:34 PM

I think you misunderstand .. admincp shows "Members Choice", but nothing else and the usergroups now show 4 additional yes / no options with no explanation of what they are or what the yes / no options provide.

trafix 02-14-2005 11:14 PM

ahh, ok find a phrase in the admincp phrasegroup ... search for "mc_" and select edit .... then save it without changing any of the data

TTG 02-14-2005 11:28 PM

That did the trick .. thanks for your help trafix.
Clicked install and all is now working well.

trafix 02-15-2005 12:10 AM

Wootness .... ENJOY!

TTG 02-15-2005 07:53 PM

When someone clicks to vote for a nominee,box opens asking for 'Reason'.
Header of box shows "You are voting for" .. should the name of the nominee be shown alongside this header message ?

trafix 02-15-2005 09:59 PM

yeah it should .... ill look at it

Vizionz 02-16-2005 04:12 PM

i can never get this thing to work i get errors bigtime. when it gets to the stles. then if i skip that part and try to install the file edits errors maybe because i am using 3.06 but this system should of been made manually instead of with that hack installer or wrote your own because it aint bug free in anyway.

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE " . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 )

Code:

Warning: halt(): Unable to access ./includes/functions_log_error.php in includes/db_mysql.php on line 389

Warning: halt(./includes/functions_log_error.php): failed to open stream: No such file or directory in includes/db_mysql.php on line 389

Warning: halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/lib/php/:/usr/share/pear/') in includes/db_mysql.php on line 389


shadiguy1 02-18-2005 03:36 PM

i keep getting this error when i try and install it right after it says it changed all my stykes and i click done i get thsi error ill post a pic

shadiguy1 02-20-2005 02:25 PM

Bump

MR-2ZZ 02-22-2005 06:58 AM

I too get the same error

Marco van Herwaarden 02-22-2005 07:33 AM

In file install/hacks/Members Choice/2/queries.php change
PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
)'


into (remove the closing ")"):
PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
'



MR-2ZZ 02-22-2005 09:26 AM

Great now I cant update any of my usergroups :(

MR-2ZZ 02-22-2005 09:29 AM

Quote:

Originally Posted by MarcoH64
In file install/hacks/Members Choice/2/queries.php change
PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
)'


into (remove the closing ")"):
PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
'



same error occured

MR-2ZZ 02-22-2005 06:47 PM

Ok here is what I did, I removed from the queries the first 2 and the last query, and removed all mc_xxx from my db. Install went through, I then manually enterered this:

Code:

ALTER TABLE `usergroup` ADD `mcpollingbooth` INT( 12 ) UNSIGNED NOT NULL ;
and now everything is back working on my site. I can give user group permissions and what not. I added a booth and it went fine, but nothing else seems to work. I am also going to have to figure out why there is no title for the drop down in the admincp.

MR-2ZZ 02-22-2005 09:27 PM

It appears that it is working as normal after I did the above.

shadiguy1 02-23-2005 08:10 PM

trying everything damn thing will not install i keep getting the database error

MR-2ZZ 02-23-2005 08:47 PM

Do This...

* Make necessary changes per Readme
* Go into your DB and drop all mc_ tables
* Find the /Members choice v2/upload/install/hacks/Members Choice/2/quieries.sql, and change it to the below form.

PHP Code:

<?php

$query
['new'][] = 'CREATE TABLE 'TABLE_PREFIX .'mc_nominee (
`mc_nomineeid` int(11) unsigned NOT NULL auto_increment,
`boothid` int( 11 ) NOT NULL default \'0\',
`userid` int( 11 ) NOT NULL default \'0\',
`username` varchar( 225 ) default \'0\',
`nominatorid` smallint( 5 ) default \'0\',
`nominatorname` varchar( 50 ) NOT NULL default \'\',
`votes` smallint( 6 ) default \'0\',
`nomreason` mediumtext NOT NULL ,
`acceptspeach` mediumtext NOT NULL ,
`datestamp` int( 10 ) NOT NULL default \'0\',
PRIMARY KEY ( `mc_nomineeid` ) 
) TYPE = MYISAM ;'
;

$query['new'][] = 'CREATE TABLE 'TABLE_PREFIX .'mc_pollbooth (
  `mc_pollboothid` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default \'\',
  `status` smallint(2) default \'0\',
  `statusreason` varchar(255) NOT NULL default \'\',
  `startdate` int(11) unsigned NOT NULL default \'0\',
  `enddate` int(11) unsigned NOT NULL default \'0\',
  `qty_nominees` smallint(3) default \'0\',
  `qty_votes` int(11) NOT NULL default \'0\',
  PRIMARY KEY  (`mc_pollboothid`))'
;

$query['new'][] = 'CREATE TABLE 'TABLE_PREFIX .'mc_whovoted (
  `mc_whovotedid` int(11) unsigned NOT NULL auto_increment,
  `boothid` int(11) NOT NULL default \'0\',
  `nomuserid` int(11) default \'0\',
  `nomusername` varchar(255) NOT NULL default \'\',
  `voteruserid` int(11) default \'0\',
  `votername` varchar(255) NOT NULL default \'\',
  `votereason` mediumtext NOT NULL,
  `votedate` int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (`mc_whovotedid`)
)'
;

?>

* Re-Run the Install script.
* Manuall enter this code into your DB

Code:

ALTER TABLE `usergroup` ADD `mcpollingbooth` INT( 12 ) UNSIGNED NOT NULL ;
* Next goto AdminCP, goto Languages and Phrases, select any phrase (edit) and save without changing anything.

* That should work now

MR-2ZZ 02-23-2005 08:48 PM

BTW: I am using 3.0.6 patched to 3.0.7

shadiguy1 02-23-2005 11:26 PM

im runnin 3.0.3 patched to 3.0.7 hit me on aim shadiguy1 maybe we can work somethig out if you can get it working for me.

MR-2ZZ 02-24-2005 03:18 AM

Okie I walked shadiguy1 through the same process I followed and it worked!

shadiguy1 02-24-2005 04:00 AM

working greta now thanks.

MR-2ZZ 02-24-2005 04:27 AM

No Problemo :)

shadiguy1 02-24-2005 11:08 AM

change file Edit to This to fix problem with Button being blank for members choice in Admins Cp . Change file edit in adminCP/index.php to The Following

if (can_administer('canadminstyles'))
{
$printhr = true;
construct_nav_option($vbphrase['mc_polling_booth_manager'], 'vb_memberschoice_admin.php', '<br />');
construct_nav_group("Members Choice", '<hr />');

EDDIE! 02-26-2005 08:12 PM

I've installed this hack already and it's working nice, but I'd like to make it possible to nominate Administrators. How is this possible?

SiFor 02-27-2005 07:14 AM

I just upgraded to vb3.0.7 and now all my polls dont show. The data is still there in the adminCP but not in the polling station. How can I fix this?

h75 02-27-2005 06:43 PM

i got an error @ install thos message

Code:

Updating style information for each style

Standard-Style ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
images ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
radio (expanded)-neu ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
images_red-neu ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
radio_dream (expanded)-neu ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
Blue-Life ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
radio (expanded) ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
radio_dream (expanded) ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.
 
images_red ... (Templates) (Stylevariablen) (CSS) (Replacement Variables) (Einstellungen) Erledigt.

then next page this :disappointed:
Quote:

!--
Datenbankfehler in vBulletin 3.0.6:

Ungueltige SQL-Abfrage: ALTER TABLE vb3_language ADD `phrasegroup_members_choice` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_members_choice'

mysql error number: 1060

Datum: 27.02.2005 21:42:22
Skript: /install/hack_install.php?do=install&amp;step=dodatabaseque ries&amp;hacks=Members%20Choice
Referer:
Benutzername: H75
IP-Adresse:
-->

Draddog 03-02-2005 04:25 AM

I installed the latest version, but have a couple of questions.
How do I prevent admins from being nominated?
Also, have you given any thought for a custom module for vbAdvanced index page so that the results show up on the front page?

Lizard King 03-04-2005 01:34 AM

Cron job is now working for me. I get the following error :

Quote:

Warning: main(./includes/cron/mc_cron_autoendpollphp): failed to open stream: No such file or directory in /admincp/cronadmin.php on line 56

Fatal error: main(): Failed opening required './includes/cron/mc_cron_autoendpollphp' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/serenity/public_html/forum/admincp/cronadmin.php on line 56

Lionel 03-04-2005 10:28 AM

hi, the hack is working fine, but for the acceptance email, i get
subject:Could not find phrase 'mc_nomination_email'. (it's in there in custom phrase

has nominated you for Best Poster ever.

Please take the time to add your acceptance speech Array.

Click Here

Lionel 03-04-2005 10:50 AM

in template mc_vote_reason, why would $nominfo[username] return blank?

Protoman 03-04-2005 02:01 PM

got it manually installed after the installer failed..

now I try to nominate a member and it takes me to the login screen.. saying no permission.. any ideas?

MR-2ZZ 03-04-2005 10:08 PM

Quote:

Originally Posted by corollasbest
got it manually installed after the installer failed..

now I try to nominate a member and it takes me to the login screen.. saying no permission.. any ideas?


Follow the install guide I posted a page or two back, and it will solve everything.

Protoman 03-05-2005 01:38 AM

fixed. maybe we should add something in the install that tells you to set up the permissions in the usergroup page. cause I just spent 3 hours tracing through my database and the code to find the problem and solution.. set the permissions :ermm:

Detomah 03-05-2005 11:27 AM

Quote:

Originally Posted by MR-2ZZ
*snipped*

* That should work now

Super job, works a treat for me after applying those changes, so thanks. :)

MR-2ZZ 03-05-2005 04:25 PM

Awesome.

Scerina 03-06-2005 09:29 PM

err...I think something is seriously wrong with mines...if someone who has experince with installing this, can you please contact me or post here to help me out???? thanx in advance

MR-2ZZ 03-06-2005 11:28 PM

Whats wrong? Did you follow the instructions I posted 2 pages back?


All times are GMT. The time now is 02:47 AM.

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.01547 seconds
  • Memory Usage 1,838KB
  • 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
  • (5)bbcode_code_printable
  • (6)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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