vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - Jujubins Lottery (https://vborg.vbsupport.ru/showthread.php?t=201437)

jujubins 01-10-2009 10:00 PM

Jujubins Lottery
 
1 Attachment(s)
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:
  1. Upload the files in the forum folder to your vBulletin root.
  2. Import the product_jlottery.xml via Product Manager system.
Upgrading:
  1. Upload the files in the forum folder to your vBulletin root.
  2. 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


Quote:

Originally Posted by jujubins (Post 1907194)
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.



:)

GlamRockTalk 01-11-2009 08:38 PM

Demo has no permission for visitors.

Also, can you share in English?

jujubins 01-11-2009 09:17 PM

The default language is English.

Added screenshot in English.

cafenetland 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 01-12-2009 10:02 AM

great but i have problem in SQL

PHP Code:

Invalid SQL:
SELECT FROM `jlotteryWHERE `userid` = 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 01-12-2009 10:17 AM

Not Supported !!!

RedeemedWarrior 01-12-2009 10:37 AM

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

R-D 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 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 01-12-2009 05:07 PM

Congrats jujubins!
Installed ! :)
all the best
beduino


All times are GMT. The time now is 09:58 PM.

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.01580 seconds
  • Memory Usage 1,763KB
  • 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_code_printable
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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