New Flash Poll System!! NOW AVAILABEL

[msimonds]

okay it is ready for download!





1)You can download this package by clicking on the following link!



http://www.freeimagebrowser.com/trk.php?fileID=29






2)unzip the package and go into the upload folder; look for the howtoinstall.txt, follow the instructions and install the system, create a new poll





3)then in your admincp create a new template (ie adv_portal_flashpoll)



with the following code:



<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">

<tr>

<td class="tcat" align="center"><span class="smallfont"><b>New Poll Test</b></span></td>

</tr>

<tr>

<td class="$getbgrow" width="100%">



<!-- Begin custom code -->

<embed src="http://www.sportsrant.com/boomedia/poll/poll.swf" quality="high" width="160" height="300"></embed>

<!-- End custom code -->

</td>

</tr>

</table><br />MAKE SURE TO REPLACE THIS LINE



<embed src="http://www.sportsrant.com/boomedia/poll/poll.swf" quality="high" width="160" height="300"></embed>

with the code from your new poll's settings



then go to your vba CPMS and add a module



OR Template to Include: flashpoll



then activate the and you should see it on your home page



*****DONT FORGET TO ACTIVE YOUR POLL IN THE ADMIN AREA OR IT WILL NOT SHOW ON THE PAGE THAT YOU PLACED IT ON********

**note all questions and support will be here, please do not PM or email me, I will not respond, but I will answer questions here, I am also going to release this on vb.org





This was an expensive undertaking, if you feel that you would like to dontate to make this a better system, please donate to sportsrant@sportsrant.com


Thanks



Mike

UPDATE 11/1/2004: I have updated the package completely with better install instructions. I changed the tables for the database to have a prefix: flash_poll & flash_access. Please download the package again from the link above and it will not conflict with your vbulletin tables what so ever. There is a new install.htm in the package to make it easier to read once you have the install in place.

[TTG]

Mmmm ..
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
FROM thread AS thread
INNER JOIN poll AS poll USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 1)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> 10 AND thread.pollid != 0 AND visible = 1 AND deletionlog.primaryid IS NULL AND forumid IN(25) ORDER BY poll.pollid DESC
LIMIT 1

mysql error: Unknown column 'poll.dateline' in 'field list'

mysql error number: 1054

Date: Sunday 31st of October 2004 10:47:21 PM

[Our Sponsors]

[msimonds]

that is an error and a mistake, you over layed your poll database table with this one,

I SAID THAT THIS WAS A SERPERATE SYSTEM FROM VB.

You need to fix your vbulletin database and load this poll system into a new database!!

[TTG]

Thanks .. now lost my portal

[Our Sponsors]

[memobug]

Hmmm. It might be safer to include some table prefixes, even if it's designed for a different database. I could see where that would be confusing, since it uses vB's admincp and vBadvanced Templates, but not the vbulletin database, it's a little odd.

I have way too many databases I need to consolidate, because stuff like Photopost and links system (not vbLinks), well I never trusted them when they were brand new and PPost at the time didn't support prefixes, so I wound up with a seven databases.

Better safe than sorry, I guess.

Regards,

Matt

[msimonds]

Thanks .. now lost my portal
You can fix this to easy: all you need to do it run the sql for the poll table for VB!


DROP TABLE IF EXISTS poll;
CREATE TABLE poll (
pollid int(10) unsigned NOT NULL auto_increment,
question varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
options text NOT NULL,
votes text NOT NULL,
active smallint(6) NOT NULL default '1',
numberoptions smallint(5) unsigned NOT NULL default '0',
timeout smallint(5) unsigned NOT NULL default '0',
multiple smallint(5) unsigned NOT NULL default '0',
voters smallint(5) unsigned NOT NULL default '0',
public smallint(6) NOT NULL default '0',
lastvote int(10) unsigned NOT NULL default '0',
PRIMARY KEY (pollid)
) TYPE=MyISAM;

that will restore your poll for your vb site

and please do not blame me, I stated in this thread and the other thread that this was a seperate system from VB.

But this will fix your forums, or I will be glad to give you a hand

[msimonds]

Thanks .. now lost my portal

TTG,

sorry about the not clearing this up, I will help you restore anyhting you wish or even install the poll system if need be.

Just let me know if I can

[TTG]

TTG,

sorry about the not clearing this up, I will help you restore anyhting you wish or even install the poll system if need be.

Just let me know if I can

NP m8 .. cleared it up myself.

You need to ammend in the instructions for anyone else that doesn't read all the threads related to this addition to "Add a new database" .. There is no mention in the present instructions.

[msimonds]

Your right I will and I am going to go through the code this morning and see if I can add a prefix to the tables themselves

[Earl Grey]

Woo Hoo! Can't wait to get home and set this bad boy up!

Thanks a ton MS! I'll be tossin something into the kitty ASAP.

Will be instaled here --> Tea Boy's Pad (http://www.lobo.net/~rbf/forum/guild_forum/)

[msimonds]

Woo Hoo! Can't wait to get home and set this bad boy up!

Thanks a ton MS! I'll be tossin something into the kitty ASAP.

Will be instaled here --> Tea Boy's Pad (http://www.lobo.net/~rbf/forum/guild_forum/)

It has been updated! Make sure that you have downloaded the new package

[-peace-]

Ok, here we go again.

I reinstalled it and this is still what i get.

Here are some shot of me trying to log in. The left side frame says :

Notice: Undefined index: MM_Username in c:\inetpub\wwwroot\newpoll\menu.php on line 50

Notice: Undefined index: MM_UserGroup in c:\inetpub\wwwroot\newpoll\menu.php on line 50
You are not authorized to view this page



After I log in I get the second picture and in the right frame I get this:
Flash Poll System






Notice: Undefined variable: row in c:\inetpub\wwwroot\newpoll\main.php on line 69

Notice: Undefined variable: id in c:\inetpub\wwwroot\newpoll\main.php on line 70
There are curently polls stored in the database;

Notice: Undefined variable: q in c:\inetpub\wwwroot\newpoll\main.php on line 71

Notice: Undefined variable: v in c:\inetpub\wwwroot\newpoll\main.php on line 71
The current poll is : and has a total of votes.

Now after creating a poll and hitting submit i get this:

Notice: Undefined variable: id in c:\inetpub\wwwroot\newpoll\main.php on line 65
There are curently 1 polls stored in the database;

Notice: Undefined variable: q in c:\inetpub\wwwroot\newpoll\main.php on line 71

Notice: Undefined variable: v in c:\inetpub\wwwroot\newpoll\main.php on line 71
The current poll is : and has a total of votes.

Now I click settings - i get this:

Notice: Undefined index: passn1 in c:\inetpub\wwwroot\newpoll\settings.php on line 61

Notice: Undefined index: passn2 in c:\inetpub\wwwroot\newpoll\settings.php on line 62

Notice: Undefined index: address in c:\inetpub\wwwroot\newpoll\settings.php on line 92


The funny part about all these errors - IS THAT IT WORKS NOW!! Go Figure. :confused: :eek: :eek:


Just an FYI.

[msimonds]

maybe it has something to do with your version of php! I am not sure. you are the only one that is having these problems!

Can you make a phpinfo() for public view so I can take a look at it or also catch me on one of my im's

Link me to your site


Mike

[rapheal]

maybe it has something to do with your version of php! I am not sure. you are the only one that is having these problems!

Can you make a phpinfo() for public view so I can take a look at it or also catch me on one of my im's

Link me to your site


Mike


Mike

what is ur version of php?

[rapheal]

how can I make the poll support different languages?

do u still have the gold'sh style?

what is the file "flash source" ? what do we do with it ?

[msimonds]

Mike

what is ur version of php?
my version is 4.3.6 but that should not matter, I was wondering if you had a real old version

The FLA is for the people that can modify flash to make a skin to match their site

The other languague is not supported! I dont have the means

The gold skin is #2 I believe

and if you think that this is worth a rating, can you go here

http://www.hotscripts.com/Detailed/40751.html

[rapheal]

about the languague part. can it be done ?

and hell ya its worth rating it :)

[msimonds]

I am sure the language can be worked on, but It would need some large changes, something that I do not have the time or the knowledge to do

and thanks for the rating

[msimonds]

There was a problem that we have corrected. This involved the use of more than 8 options. This is ready for download at the follwing link

http://www.freeimagebrowser.com/trk.php?fileID=29

if you have tried to download this and it had errors, please download the package again and replace all the files except for the Connections/poll.php

Thanks Mike

[Danny W]

EDIT: Sorted

[Nathan]

Did anyone get their install working? Sounds cool.

[ptmuldoon]

I tried to install, but all I seem to get is a blank box on the vba homepage. I made and 'opened' up a poll as well.


***EDIT***

Nevermind, got it.

[Predator72]

Thx, works great and looks very nice. *INSTALLED* ;)

[axi]

any demos?