vb.org Archive - Add-On Releases

Page 3 of 62

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Add-On Releases - vBulletin Raffles (https://vborg.vbsupport.ru/showthread.php?t=262901)

mitch84

05-01-2011 02:55 PM

hi, the sql data don't run, I can have them in a text file please? because when I click on link in "community" this database error appear,

Quote:

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM raffle

ORDER BY id DESC;

MySQL Error : Table '413.raffle' doesn't exist
Error Number : 1146
Request Date : Sunday, May 1st 2011 @ 05:54:23 PM
Error Date : Sunday, May 1st 2011 @ 05:54:24 PM
Script : http://localhost/413/raffles.php
Referrer : http://localhost/413/forum.php
IP Address : 127.0.0.1
Username : mitch
Classname : vB_Database
MySQL Version : 5.5.9-log

but in acp mod work fine, what's wrong?
thx

nhawk

05-01-2011 02:57 PM

Quote:

Originally Posted by Britmovie (Post 2190694)

http://www.britmovie.net/britforum/raffles.php

If you look on the above link you will see the is a text overlap....any way to fix this?:up:

Yes

1) Style Manager->Edit Templates->CSS Templates
Edit raffle.css

Change the value shown for width in this area to 90%:

Code:

.raffledata {

        float: {vb:stylevar left};

        clear: {vb:stylevar right};

        color: {vb:stylevar rafflebits_text_color};

        padding: 0;

        width: 100%;

}

nhawk

05-01-2011 03:18 PM

Quote:

Originally Posted by mitch84 (Post 2190709)

hi, the sql data don't run, I can have them in a text file please? because when I click on link in "community" this database error appear, but in acp mod work fine, what's wrong?
thx

There's no reason it shouldn't run on the main page (no matter where it's linked from) because both admincp and raffles use the same sql query with only one minor difference.

In both admincp and raffles if "Show Raffles Already Drawn" is set to 'Yes':

Code:

"SELECT * FROM " . TABLE_PREFIX . "raffle ORDER BY id DESC"

In raffles if "Show Raffles Already Drawn" is set to 'No':

Code:

"SELECT * FROM " . TABLE_PREFIX . "raffle WHERE enddate > $timenow ORDER BY id DESC"

Britmovie

05-01-2011 03:57 PM

Worked a treat many thanks.

mitch84

05-01-2011 04:21 PM

I checked in phpmyadmin and table raffle & raffle entries don't exist

nhawk

05-01-2011 04:32 PM

Quote:

Originally Posted by mitch84 (Post 2190735)

I checked in phpmyadmin and table raffle & raffle entries don't exist

Silly question..

Did you do this?

Quote:

2) Import the product XML file (product-raffles.xml) into the Product Manager in AdminCP.

If not, that is when the tables are created.

nhawk

05-01-2011 04:52 PM

Quote:

Originally Posted by Britmovie (Post 2190728)

Worked a treat many thanks.

There is one thing I noticed with your raffle...

If you aren't experimenting with the system, you have user entries set to 1 and a time limit of 7 days.

If you want your members to be able to enter every 7 days, increase the number of entries to the maximum total entries you want each member to have.

Either that of set the time limit to zero and your members will only be able to enter once.

It boils down to there's no need to set a time limit if the maximum entries allowed is set to 1.

(I also noticed something I need to fix for our friends outside of north america.. the date format is wrong on the raffle pages for you folks. I'll release a fix for that tomorrow.)

NoCo7

05-01-2011 06:07 PM

Nice plugin, good work!

mikem164

05-02-2011 12:15 AM

Installed, tested and works terrific, one thing though. When a user purchases a chance, nothing is traded, for example, cash, credit. Can you incorporate paypal into this so a user can buy a chance for $5 or whatever price the ticket is? Also, can you make the current raffles appear in the sidebar(forumbllock), and maybe current raffles at footer, just so users know there is actually a raffle going on when they see forumhome? Other then that, it's fundamentally perfect!

biggeorge

05-02-2011 12:42 AM

I've been running raffles for 5 years on my forum and have raffled at over $40,000 worth of products. I've been anxious to see a mod come out, but I would have liked to see some other features - most importantly, the ability for members to actually purchase tickets; perhaps setup with various payment processors. Is this possible? I would be willing to pay for this option. This is also mentioned by mikem164 in the above post.

And please, before anyone mentions it... I know my state laws pertaining to raffles and I know my merchant account rules pertaining to raffles. And I would strongly suggest the same for anyone planning to run raffles on their website.

All times are GMT. The time now is 05:17 PM.

Page 3 of 62

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01532 seconds Memory Usage 1,745KB 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 (3)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages: