Vote Reward V0.1

Printable View

15-09-11
Acnathon

5 Attachment(s)

Vote Reward V0.1

Hi all.
First of all i want to tell you that the code is not made by me i just modded to fit on cabal servers also im not that really good in php so i just played abit with the code but i tought some people may find usefull and could improve it.

Note that this code allows only 1 vote/12 hours/IP adress.

So lets see:

Files:
database.php -> fill with ur db infos
index.php
links.php -> i left there 4 links u will understand how to add more :-)
security.php
vote.php

What it does?
It checks if there any vote already in the past 12 hours with the users ID and IP.
If there is then it will tell you to check back when u can vote again.
Also theres an Acc/PW autentication.
If everything is ok then it will update the users Cash + Votes and it sends the user to the vote link.

Ok first run this on your db.

Code:

USE [CabalCash] GO /****** Object: Table [dbo].[votes] Script Date: 09/15/2011 01:03:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[votes]( [accName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [lastVoteDate] [datetime] NOT NULL, [voteLink] [int] NULL, [ip] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF alter table CashAccount add votes int not null default 0

Then just create a vote folder on ur webserver copy there the contents of the .rar and fill in the database.php with ur infos and links.php with ur vote links.

Vote Reward V0.2+Design:
Attachment 92296

Screens:
Attachment 92293 Attachment 92294 Attachment 92295

Note: I didnt tested too much so backup everything before trying out!

Credits: PsychoJr (Coding)
Me: Modding the code.

Edit: I modded also Alphakilo's Standalone ranking to show Top Voters.
Note that the top voters may be dangerous cos it shows the account name with the votes so use at your own risk... still u can use it for yourself like statistics or kind of.
Maybe later i could add some stuff to it so it wont show the account name but a character name or something... i just didnt had time yet to do it.
Here's:
Attachment 92289

Edit: Updated with Alphakilo's code + added some design.
15-09-11
Xc0deRed93

Re: Vote Reward V0.1

let me be the one to say my appreciation. Thank you very much for releasing your work. great job :thumbup1:
15-09-11
allocen

Re: Vote Reward V0.1

Very nice job.
15-09-11
Acnathon

Re: Vote Reward V0.1

Thanks for replies and if theres any bug or problem with the code please let me know.
Also check first post. (Updated)
15-09-11
Xc0deRed93

Re: Vote Reward V0.1

Quote:

Originally Posted by Acnathon

Thanks for replies and if theres any bug or problem with the code please let me know.
Also check first post. (Updated)

Im going to keep update on this. I'm still using the vote-reward you modded from Millenial code. And it works fine till now but I gonna change with this :)
15-09-11
Alphakilo23

Re: Vote Reward V0.1

Hi! Awesome script, haven't seen it in action, but went through the code. I appreciate that you left the credits intact.

Now to the fun part. I noticed major SNAFUs in your table:

Quote:

Originally Posted by Acnathon

USE [CabalCash]
GO
/****** Object: Table [dbo].[votes] Script Date: 09/15/2011 01:03:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[votes](
[accName] [varchar](14) COLLATE Modern_Spanish_CI_AS NOT NULL,
[lastVoteDate] [datetime] NOT NULL,
[voteLink] [int] NULL,
[ip] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

alter table CashAccount add votes int not null default 0

First of all, assuming votes.accName is cabal_auth_table.ID:
cabal_auth_table.ID is varchar(50), so you need to accName varchar(50), too, so all account names fit into your vote table.
Imagine a player that created an account with a f.e. 15 characters long account name, your script won't work for him.

And what's up with your collation? Spanish? Bullshit! Chinese? What is his I don't even...
In most western countries we use Latin1_General_CI_AS per default.
Also you can't to JOINs that way, which you'll have to do if you want character names instead of account names in the top list.
The default collation for the cabal_character_table is Chinese_PRC_CI_AS so use this as the collation for votes.accName

And I noticed some of the code PHP could be optimized, like a small redundancy in the vote.php

Instead of:

PHP Code:

q = mssql_query("SELECT * FROM dbo.votes WHERE ip = '".$data['ip']."'"); $get = mssql_num_rows($q); $r=mssql_fetch_array($q); $votetime = $r[lastVoteDate]; if ($r[ip] == $data['ip']) { echo "You already voted. Check back at $votetime."; } else { $q = mssql_query("SELECT * FROM dbo.votes WHERE accName = '".$data['accountName']."'"); $get = mssql_num_rows($q); $r=mssql_fetch_array($q); if ($r[accName] == $data['accountName']) { echo "You already voted. Check back at $votetime."; }

Why not do this:

PHP Code:

//Instead of querying for * let's just query the ip and accountame to avoid overhead. $q = mssql_query("SELECT ip, accName FROM dbo.votes WHERE ip = '".$data['ip']." OR accName = '".$data['accountName']."'"); //Never used. So why even bother? //$get = mssql_num_rows($q); $r=mssql_fetch_array($q); $votetime = $r[lastVoteDate]; //Keep in mind, this is an array you're checking against. This will only check the first record ($r[0]) if ($r[ip] == $data['ip'] || $r[accName] == $data['accountName']) { echo "You already voted. Check back at $votetime."; }

Quote:

Originally Posted by Acnathon

Note that the top voters may be dangerous cos it shows the account name with the votes so use at your own risk... still u can use it for yourself like statistics or kind of.
Maybe later i could add some stuff to it so it wont show the account name but a character name or something... i just didnt had time yet to do it.

I nearly finished the query, but I have to go now. Expect it to be in the post later today.
15-09-11
Acnathon

Re: Vote Reward V0.1

Thank you for the infos and ill w8 for ur script then.
Also dont forget that i really dont know to much in php (im just learning) so that may cause some of my mistakes >< also thanks for tha collations stuff i didnt even checked that :O
I just toke the original SQL and it was like this by default.
Ill update the script with your code and also ill add some design to it.

Edit: Updated first post.
17-09-11
Drav3n

Re: Vote Reward V0.1

Quote:

Originally Posted by Acnathon

Thank you for the infos and ill w8 for ur script then.
Also dont forget that i really dont know to much in php (im just learning) so that may cause some of my mistakes >< also thanks for tha collations stuff i didnt even checked that :O
I just toke the original SQL and it was like this by default.
Ill update the script with your code and also ill add some design to it.

Edit: Updated first post.

i saw some bugs, after i vote on 1st vote site, when i vote to 2nd vote site, it said, Voted already
17-09-11
Acnathon

Re: Vote Reward V0.1

Quote:

Originally Posted by mikkomoley

i saw some bugs, after i vote on 1st vote site, when i vote to 2nd vote site, it said, Voted already

Well yeah thats because of IP check. I wanted to change that later and i just put more links like demonstration.
17-09-11
Drav3n

Re: Vote Reward V0.1

its is good if there's an IP check but it didn't it will not reflect on vote links.
17-09-11
Xc0deRed93

Re: Vote Reward V0.1

Quote:

Originally Posted by Acnathon

Well yeah thats because of IP check. I wanted to change that later and i just put more links like demonstration.

can you add also an option to vote per account not per IP. Cause the players in a Internet shop, if one player already use the IP to vote the others can't vote or receive points anymore.
17-09-11
Acnathon

Re: Vote Reward V0.1

Quote:

Originally Posted by prime23

can you add also an option to vote per account not per IP. Cause the players in a Internet shop, if one player already use the IP to vote the others can't vote or receive points anymore.

Well you know if IP check is removed then a player from home he could use 30 diferent accounts to get cc but u will get only once the vote on the vote site.
17-09-11
Xc0deRed93

Re: Vote Reward V0.1

Quote:

Originally Posted by Acnathon

Well you know if IP check is removed then a player from home he could use 30 diferent accounts to get cc but u will get only once the vote on the vote site.

Yes its ok.
17-09-11
Drav3n

Re: Vote Reward V0.1

Quote:

Originally Posted by prime23

Yes its ok.

in that case, Multi account. :))

it can easily eliminate the multi account. just search the IP = Ban :thumbup:
17-09-11
Acnathon

Re: Vote Reward V0.1

Quote:

Originally Posted by mikkomoley

in that case, Multi account. :))

it can easily eliminate the multi account. just search the IP = Ban :thumbup:

Well thats a way too but i prefer to try to prevent them do that. :cool:
18-09-11
Drav3n

Re: Vote Reward V0.1

Quote:

Originally Posted by Acnathon

Well thats a way too but i prefer to try to prevent them do that. :cool:

yes, but some of players playing in computer shop will complain about that. :))
21-09-11
Acnathon

Re: Vote Reward V0.1

Quote:

Originally Posted by mikkomoley

yes, but some of players playing in computer shop will complain about that. :))

I didnt had too much time to work on these but ill give a look to do something with it. But also u can just remove the IP check from the code and it will allow to vote multiple times / IP.

Edit: Also wanted ask Alphakilo if u finished that script u were speaking about?
21-09-11
Drav3n

Re: Vote Reward V0.1

Quote:

Originally Posted by Acnathon

I didnt had too much time to work on these but ill give a look to do something with it. But also u can just remove the IP check from the code and it will allow to vote multiple times / IP.

Edit: Also wanted ask Alphakilo if u finished that script u were speaking about?

how to remove? can you post the script the already removed the IP check?

sorry for my ignorance, im not good in PHP
21-09-11
Acnathon

Re: Vote Reward V0.1

Quote:

Originally Posted by mikkomoley

how to remove? can you post the script the already removed the IP check?

sorry for my ignorance, im not good in PHP

In vote.php change this part:

Code:

$q = mssql_query("SELECT ip, accName, lastVoteDate FROM dbo.votes WHERE ip = '".$data['ip']."' OR accName = '".$data['accountName']."'"); //Never used. So why even bother? //$get = mssql_num_rows($q); $r=mssql_fetch_array($q); $votetime = $r[lastVoteDate]; //Keep in mind, this is an array you're checking against. This will only check the first record ($r[0]) if ($r[ip] == $data['ip'] || $r[accName] == $data['accountName']) { die("You already voted. Check back at $votetime. <a href='javascript:history.go(-1)'>Go back.</a>"); }

To this:

Code:

$q = mssql_query("SELECT accName, lastVoteDate FROM dbo.votes WHERE accName = '".$data['accountName']."'"); //Never used. So why even bother? //$get = mssql_num_rows($q); $r=mssql_fetch_array($q); $votetime = $r[lastVoteDate]; //Keep in mind, this is an array you're checking against. This will only check the first record ($r[0]) if ($r[accName] == $data['accountName']) { die("You already voted. Check back at $votetime. <a href='javascript:history.go(-1)'>Go back.</a>"); }

I hope i didnt messed up cos im in hurry (lol) :thumbup1:
02-12-11
xXxAxXx

i will try to make this load in the iron site.
Wish me luck.If i succked i will post here how i did it.

Have you ever thought how we can prevent users from reciving the reward untill they enter the security code on the voting site?
09-03-12
hatibudak

Re: Vote Reward V0.1

the script cant vote (example : 4link) because limit 1user/1ip per vote..

how to vote 4 link in 1 id/ip?
09-03-12
Acnathon

Re: Vote Reward V0.1

Quote:

Originally Posted by hatibudak

the script cant vote (example : 4link) because limit 1user/1ip per vote..

how to vote 4 link in 1 id/ip?

Here is a newer version of the vote script:

http://forum.ragezone.com/f458/vote-...v0-3-a-798843/