The Arcive of Official vBulletin Modifications Site.

Jujubins Lottery · **Released**: 01-10-2009

Coder(s): jujubins (Nando)

Compatibility: 3.6.x, 3.7.x, 3.8.x

Product Info:
Files to upload - 2
Files to import - 1
Templates - 8
Plugins - 2
Phrases - 33

Languages:
English
Portuguese

Purpose: Drawn awards for your forum users or if you want, just to one usergroup.

How it works: The users whom have permission to participate, those who have more than "x" posts, registered before "y" and members of "z" group, can take one ticket for day, until the day you set your scheduled tasks of your forum to close the lottery and drawn. As soon as drawn, there will be a congratulation message to the winner and disseminating him.

Demo: http://forum.glords.com/lottery.php

Installing:

Upload the files in the forum folder to your vBulletin root.
Import the product_jlottery.xml via Product Manager system.

Upgrading:

Upload the files in the forum folder to your vBulletin root.
Import the product_jlottery.xml via Product Manager system.

Setting:
Go to Admin CP > vBulletin Options > Jujubins Lottery and type in the fields:

Enable: Set this option to yes to enable Jujubins Lottery.
Topic: Topic ID with details of the lottery.
Members Allowed: This option prevent new users to participate in the lottery. Only users before the date chosen could participate. Use Unix time.
Posts Required: Number of posts required to participate.
Usergroups Allowed: Usergroups allowed to participate. Separate with comma the usergroups.
Round tickets:Example:
14 tickets will appear 20 tickets.
34 tickets will appear 40 tickets.
Moderators: Now you can choose the moderator's group to reset in the lottery's page
Post the winner? Automatically post the winner in thread.
Poster userid: The userid that will post the congratulations.
Post message: Post message.
Variables: {winner}, {ticket}, {hour} and {date}

To change the date of the lottery go to Admin CP> Scheduled Taks> Scheduled Task Manager> Jujubins Lottery and modify the fields of the Day of month, Hour and Minute.

Requirements:
PHP 4.3.3 and MySQL 4.0.16 or later.

History:
v0.5.0 - Dec 29. 2008
First Release
v0.7.0 - Dec 31. 2008

Added Phrases
Added option to reset when repeated the scheduled task

v0.7.1 - Jan 01. 2009
Correction in the variables of phrases
Correction in pharses
Added language in Portuguese
v0.8.0 - Jan 10. 2009
Added option to choose which usergroups can participate
Compatible with version 3.8.0
v1.0.0 - Jan 11. 2009

Added auto-link in the quick links, pop-up of community and navbar

Added option of types of drawn, "per day", "per drawn", "without limits"
v1.1.0 - Jan 12. 2009
Fixed: SQL table prefix
v1.2.0 - Jan 12. 2009
Added "see all" tickets link
Added option to enable link to see all tickets
v1.2.5 - Feb 1. 2009
Fixed: Show winners
v1.2.6 - Feb 6. 2009
Fixed: Winner link (member.php)
v1.2.6 - Feb 6. 2009
Fixed: Winner link (member.php)
v2.0.0 - Out 27. 2009
Re-writted the mod's intire code
Simplified code
SQL with fewer fields
2 new settings: Round tickets and moderators
Now you reset in lottery's page
Fixed: All known bugs
v2.1.0 - Out 29. 2009
Added: Automatic congratulations post in the thread (editable) (thanks paul41598)
Fixed: Some insignificant bugs
v2.1.1 - Out 30. 2009
Fixed: Posts limit (thanks pipibunny)
v2.1.3 - Out 30. 2009
Fixed: Usergroups colors in "See all" (thanks kalisekj)
Fixed: Links in menu (thanks kalisekj)
Fixed: Reset link to moderators (thanks kalisekj)
Fixed: Update version 2.0.0 to above will not reset your lottery (thanks kalisekj)

Quick support in english/portuguese: http://forum.glords.com/showthread.php?t=8927

Mark as Installed
Nominate for MOTM

Quote:

Originally Posted by jujubins

I apologize to everybody who have donwloaded and waited for the Jujubins Lottery's updates. Today, I've re-writted the mod's intire code, making it simplier and with an easy lecture. I've tested it and no bug was found, I ask for help for everyone of you to make it better.
I promise that, starting from today, I'll be giving support about the mod.

The version 2.0.0 have been lauched, and it's in the topic.

Please help my keep supporting the project by donating in Paypal

GlamRockTalk · #2 01-11-2009, 08:38 PM

Demo has no permission for visitors.

Also, can you share in English?

jujubins · #3 01-11-2009, 09:17 PM

The default language is English.

Added screenshot in English.

cafenetland · #4 01-12-2009, 09:55 AM

Você não tem permissão para participar.

yeah i got that ??

do i have to register to see ur demo ?

adhmwagde · #5 01-12-2009, 10:02 AM

great but i have problem in SQL

PHP Code:


			
Invalid SQL:
SELECT * FROM `jlottery` WHERE `userid` = 1 AND `winner` = '1';

MySQL Error   : Table '3omda.jlottery' doesn't exist
Error Number  : 1146
Request Date  : Monday, January 12th 2009 @ 02:01:20 PM
Error Date    : Monday, January 12th 2009 @ 02:01:20 PM
Script        : http://localhost/vb/lottery.php
Referrer      : http://localhost/vb/index.php

adhmwagde · #6 01-12-2009, 10:17 AM

Not Supported !!!

RedeemedWarrior · #7 01-12-2009, 10:37 AM

15 minutes between your two posts? and you declare it unsupported?

R-D · #8 01-12-2009, 11:00 AM

Oh man, that's funny. I doubt even a paid modification would manage 15 minute support.

Looks like he just forgot to use the tableprefix when initially installing (and also uninstalling) the database table. A simple edit should fix it.

Note: It's probably best to uninstall before you make this change, then re-install the product again, otherwise the old db table probably won't be removed.

Open the product and find:

Code:

<codes>
		<code version="1.0.0">
			<installcode><![CDATA[$db->reporterror = false;
$db->query("CREATE TABLE `jlottery` (
  `ticket` int(8) NOT NULL AUTO_INCREMENT,
  `userid` varchar(500) NOT NULL,
  `username` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `usertitle` varchar(500) NOT NULL,
  `time` int(10) NOT NULL,
  `day` int(2) NOT NULL,
  `winner` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ticket`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1");
$db->reporterror = true;]]></installcode>
			<uninstallcode><![CDATA[$db->reporterror = false;
$db->query("DROP TABLE `jlottery`");
$db->reporterror = true;]]></uninstallcode>
		</code>
	</codes>

Replace with:

Code:

<codes>
		<code version="1.0.0">
			<installcode><![CDATA[$db->reporterror = false;
$db->query("CREATE TABLE " . TABLE_PREFIX . "jlottery (
  ticket int(8) NOT NULL AUTO_INCREMENT,
  userid varchar(500) NOT NULL,
  username varchar(500) NOT NULL,
  email varchar(500) NOT NULL,
  usertitle varchar(500) NOT NULL,
  time int(10) NOT NULL,
  day int(2) NOT NULL,
  winner int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (ticket)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1");
$db->reporterror = true;]]></installcode>
			<uninstallcode><![CDATA[$db->reporterror = false;
$db->query("DROP TABLE " . TABLE_PREFIX . "jlottery");
$db->reporterror = true;]]></uninstallcode>
		</code>
	</codes>

jujubins · #9 01-12-2009, 12:29 PM

@cafenetland:
My demo is being used in a draw. If someone who has installed and doesn't use the Jujubins Lottery, please post a demo link for me to post here.

@adhmwagde:
Fixed.

beduino · #10 01-12-2009, 05:07 PM

Congrats jujubins!
Installed !

all the best
beduino

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07711 seconds Memory Usage 2,345KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (6)postbit_attachment (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!