Manually add number of votes

Find out what does your audience think

Manually add number of votes

New postby s3life » Fri Apr 12, 2013 9:26 am

hello dear

i want add manually number of vote in result . sample result my vote for "ID Answer 5" = 20

how i change number 20 sample to 120 ?

thank you
s3life
 
Posts: 5
Joined: Fri Apr 12, 2013 9:20 am

Re: add manually number of vote in result

New postby Simon » Fri Apr 12, 2013 12:50 pm

Hi,

Please see this discussion - sexypolling/add-votes-manually-t1176.html
User avatar
Simon
Site Admin
 
Posts: 1306
Joined: Wed Jul 13, 2011 8:53 pm

Re: add manually number of vote in result

New postby s3life » Fri Apr 12, 2013 1:18 pm

I See it but i dont know step 3 and i dont find field for change this number .

please More details with photo .

Thank you very much
s3life
 
Posts: 5
Joined: Fri Apr 12, 2013 9:20 am

Re: add manually number of vote in result

New postby Simon » Fri Apr 12, 2013 2:07 pm

There is no field to change the number of votes. You need to do it from MySql

1. Go to `dbprefix_sexy_answers` table.
2. Get the `id` of desired answer.
3. Run the following query. (one run will add one vote for desired answer. If you need more, copy the query as many times as you need.) If your answer has id = 3, then the query will be
Code: Select all
INSERT INTO `dbprefix_sexy_votes` (`id_answer`, `ip`, `date`, `country`, `city`, `region`, `countrycode`) VALUES ('3', '127.0.0.1', NOW(), 'Unknown', 'Unknown', 'Unknown', 'Unknown');
User avatar
Simon
Site Admin
 
Posts: 1306
Joined: Wed Jul 13, 2011 8:53 pm

Re: add manually number of vote in result

New postby s3life » Fri Apr 12, 2013 11:53 pm

Simon wrote:There is no field to change the number of votes. You need to do it from MySql

1. Go to `dbprefix_sexy_answers` table.
2. Get the `id` of desired answer.
3. Run the following query. (one run will add one vote for desired answer. If you need more, copy the query as many times as you need.) If your answer has id = 3, then the query will be
Code: Select all
INSERT INTO `dbprefix_sexy_votes` (`id_answer`, `ip`, `date`, `country`, `city`, `region`, `countrycode`) VALUES ('3', '127.0.0.1', NOW(), 'Unknown', 'Unknown', 'Unknown', 'Unknown');


i following query but dont see change !

can you shomw me this step with photo ?
s3life
 
Posts: 5
Joined: Fri Apr 12, 2013 9:20 am

Re: add manually number of vote in result

New postby Simon » Sat Apr 13, 2013 12:09 am

What kind of photo do you need? I do not see the meaning of creating a screenshot of phpMyAdmin interface or command line.

i following query but dont see change !


Could you see the votes parameter changed after running the query?
Image
User avatar
Simon
Site Admin
 
Posts: 1306
Joined: Wed Jul 13, 2011 8:53 pm

Re: Manually add number of votes

New postby s3life » Sat Apr 13, 2013 12:42 am

Thnak you dear but my Joomla Versian is 2.5.9

are of this version way to change Manually vote ?
s3life
 
Posts: 5
Joined: Fri Apr 12, 2013 9:20 am

Re: Manually add number of votes

New postby Simon » Sat Apr 13, 2013 1:37 am

You can do it same way! There is no difference for Sexy Polling between Joomla 2.5.9 and Joomla 3.0
User avatar
Simon
Site Admin
 
Posts: 1306
Joined: Wed Jul 13, 2011 8:53 pm

Re: Manually add number of votes

New postby s3life » Sat Apr 13, 2013 2:32 am

Simon wrote:You can do it same way! There is no difference for Sexy Polling between Joomla 2.5.9 and Joomla 3.0


yes i know is no difference but i want change Manually number of vote . sample : number vote now is 50 . i want change this now to 410 . how way for change this ?
s3life
 
Posts: 5
Joined: Fri Apr 12, 2013 9:20 am

Re: Manually add number of votes

New postby Simon » Sat Apr 13, 2013 2:50 am

1. Go to `dbprefix_sexy_answers` table.
2. Get the `id` of desired answer.
3. Run the following query. (one run will add one vote for desired answer. If you need more, copy the query as many times as you need.) If your answer has id = 3, then the query will be
Code: Select all
INSERT INTO `dbprefix_sexy_votes` (`id_answer`, `ip`, `date`, `country`, `city`, `region`, `countrycode`) VALUES ('3', '127.0.0.1', NOW(), 'Unknown', 'Unknown', 'Unknown', 'Unknown');


If now votes are 40, but you need 410, copy this query 370 times.
Unfortunately there is no way to do it.
User avatar
Simon
Site Admin
 
Posts: 1306
Joined: Wed Jul 13, 2011 8:53 pm


Return to Sexy Polling

Who is online

Users browsing this forum: No registered users and 1 guest

cron