Thread: [SQL] Auth Voting Not removing ip after 24 hrs

Page 1 of 2 12 LastLast
Results 1 to 10 of 17
  1. #1 [SQL] Auth Voting Not removing ip after 24 hrs 
    OoO Donor <3
    Rockstar Jax's Avatar
    Join Date
    Mar 2011
    Age
    27
    Posts
    608
    Thanks given
    77
    Thanks received
    78
    Rep Power
    21
    Alrighty my auth voting system isnt removing the persons ip after 24 hours so the person cant revote.

    Here is the SQL structure

    Code:
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `tempvotes`
    --
    
    CREATE TABLE IF NOT EXISTS `tempvotes` (
      `id` int(5) NOT NULL,
      `time` int(9) NOT NULL,
      `ipaddress` varchar(15) collate utf8_unicode_ci NOT NULL,
      `voted` int(1) NOT NULL default '0'
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `votes`
    --
    
    CREATE TABLE IF NOT EXISTS `votes` (
      `id` int(11) NOT NULL auto_increment,
      `time` int(9) NOT NULL,
      `ipaddress` varchar(15) collate utf8_unicode_ci NOT NULL,
      `authcode` varchar(6) collate utf8_unicode_ci NOT NULL,
      `used` int(1) NOT NULL default '0',
      `username` varchar(14) collate utf8_unicode_ci NOT NULL,
      `guid` varchar(45) collate utf8_unicode_ci NOT NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
    If anything else needed i will post it

    <-- amateur sig skills dont hate
    Reply With Quote  
     

  2. #2  
    Banned

    Join Date
    Nov 2010
    Age
    29
    Posts
    2,682
    Thanks given
    824
    Thanks received
    404
    Rep Power
    0
    Use RuneTopList voting system. 100% better.
    Reply With Quote  
     

  3. #3  
    OoO Donor <3
    Rockstar Jax's Avatar
    Join Date
    Mar 2011
    Age
    27
    Posts
    608
    Thanks given
    77
    Thanks received
    78
    Rep Power
    21
    I dont want to use that. If i wanted to I would have it on my server wouldnt u think?

    <-- amateur sig skills dont hate
    Reply With Quote  
     

  4. #4  
    Banned

    Join Date
    Sep 2009
    Posts
    904
    Thanks given
    139
    Thanks received
    55
    Rep Power
    0
    i need this too.
    Reply With Quote  
     

  5. #5  
    Banned

    Join Date
    Nov 2010
    Age
    29
    Posts
    2,682
    Thanks given
    824
    Thanks received
    404
    Rep Power
    0
    Quote Originally Posted by fogle7 View Post
    I dont want to use that. If i wanted to I would have it on my server wouldnt u think?
    Don't be a smartass, you wouldn't be having problems like this if only you would take suggestions and turn them into a checklist.
    Reply With Quote  
     

  6. #6  
    Registered Member
    Join Date
    Sep 2011
    Posts
    327
    Thanks given
    130
    Thanks received
    17
    Rep Power
    6
    I need this as well.
    Reply With Quote  
     

  7. #7  
    Registered Member
    Join Date
    Sep 2011
    Posts
    100
    Thanks given
    5
    Thanks received
    5
    Rep Power
    29
    I'm pretty sure there isn't an option in MySql that allows something to removed in a certain amont of time. Make it so when people view your voting page(which should be a php file) that it checks the database for ips that have a voting time of more than 24 hours ago and make it drop those rows.
    Reply With Quote  
     

  8. #8  
    Registered Member Gretar's Avatar
    Join Date
    Sep 2011
    Posts
    289
    Thanks given
    69
    Thanks received
    12
    Rep Power
    7
    I also need this
    Owner of Roat Pkz
    Reply With Quote  
     

  9. #9  
    Respected Member


    Join Date
    Jan 2009
    Posts
    5,743
    Thanks given
    1,162
    Thanks received
    3,603
    Rep Power
    5000
    It's the cron job which removes the ips from the table.
    Reply With Quote  
     

  10. #10  
    Registered Member
    Join Date
    Sep 2011
    Posts
    327
    Thanks given
    130
    Thanks received
    17
    Rep Power
    6
    Quote Originally Posted by 1776 View Post
    It's the cron job which removes the ips from the table.
    which is?
    Reply With Quote  
     

Page 1 of 2 12 LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 7
    Last Post: 12-15-2011, 12:06 PM
  2. Buying auth voting system
    By SoulXile in forum Buying
    Replies: 0
    Last Post: 12-13-2011, 07:17 AM
  3. [PI] Auth Code Voting Killing my server
    By Rockstar Jax in forum Help
    Replies: 5
    Last Post: 12-07-2011, 06:40 AM
  4. Replies: 7
    Last Post: 10-02-2010, 04:49 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •