[Release] PHP Vote Reward System

[Hazious]

!important Alright guys I've fixed all the issues that i know of please let me know if you find any more.

Well here is an epic release for elitepvpers I've spent a few hours coding this so I really hope you guys enjoy it.

So what does this PHP Vote Reward System do well if you know Shaiya Invasions Shaiya Vote Reward system well this is almost a complete copy players don't get the points until they click the link back to the website from the vote site.

Also FYI this script can't be exploited by players since it checks if the player has voted with the same ip then just uses the info from that.

Credits to Nubness from Shaiya Invasion for the Vote Images some html and css thank you very much and Thank you abrasive for the function that protects people from sql injection.

For this release to work you need to create a new Database and call is PS_Website

Then execute this Query to add the required table to the database

PHP Code:

USE [PS_Website]
GO

/****** Object:  Table [dbo].[votes]    Script Date: 4/25/2015 9:41:43 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[votes](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [UserID] [varchar](max) NOT NULL,
    [UserIp] [varchar](max) NOT NULL,
    [topDate] [datetime] NULL,
    [topLink] [varchar](max) NULL,
    [xtremeDate] [datetime] NULL,
    [xtremeLink] [varchar](max) NULL,
    [oxigenDate] [datetime] NULL,
    [oxigenLink] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 


Then just edit the vote.php with your database information and set your vote links.

Then edit includeVote.php with your reward_points for each vote.

Now you need to include this file in your index page for your website.

PHP Code:

include 'includes/includeVote.php'; 


note you need to add your website vote links to all the vote sites you will need them in this format

if you can't get this working then idk lol but yea it's not hard to work it out just read through it.

please read urlsetup.txt

Here is a test link


To use the demo you will need to be registered with Eleaf Shaiya.

[Hazious]

Replace index.php with

<?php
include 'includes/db.php';
include 'includes/includeVote.php';
?>
Redirecting....<meta http-equiv="refresh" content="3;url=login.php">

[Cansas59]

you have a script to create the table?

[_Diavolino_]

Hello,
what does it means ?

all the vote sites you will need them in this format

as you present it here ?

PHP Code:

http://topofgames.com/
http://www.shaiyaserver.net/index************top

http://www.xtremetop100.com/
http://www.shaiyaserver.net/index************xtreme

http://www.oxigen-top100.com/
http://www.shaiyaserver.net/index************oxigen 


Or, How ?

Regards ! and Thank You

[SkuulCandy]

Thanks but the ip bug (ip by user blocked) is here ?
Regards,

[Hazious]

you need to read the urlsetup.txt and replace with your domain name or server ip.

[kalib.32]

Hazious is working on IIS ?

[Twitch.Tv]

Originally Posted by kalib.32

Hazious is working on IIS ?

Yes it does work with IIS.

[Big_]

any chance you can get this working on MSSQL_connect insted of pdo ?

[kalib.32]

Originally Posted by Twitch.Tv

Yes it does work with IIS.

Which kind of php version required?

[_Diavolino_]

Why are we needed to created the new database ? we could use an exiting one ? (in this case replace in the code php the right name of database)
Regards

[Hazious]

Originally Posted by _Diavolino_

Why are we needed to created the new database ? we could use an exiting one ? (in this case replace in the code php the right name of database)
Regards

Well since i have already done this as a project for someone else i already had it setup to use PS_Website but feel free to make any changes that you desire.

[_Diavolino_]

Hye,
i got an issue,
i can log in ! i can see the Working way between site and database and table, BUT
just about the referral thing i got

Fatal error: Call to a member function prepare() on a non-object in : includes\includeVote.php on line 8

i put the include at start of the page, i was use the link as present in ReadMe :

could you tell me from where can come this issue ?(without the space)

Kind regards ! and thankyou in advance

and i was verify the driver are well installing Mssql Odbc and PDO driver xD

[Hazious]

Originally Posted by _Diavolino_

Why are we needed to created the new database ? we could use an exiting one ? (in this case replace in the code php the right name of database)
Regards

Originally Posted by _Diavolino_

Hye,
i got an issue,
i can log in ! i can see the Working way between site and database and table, BUT
just about the referral thing i got

i put the include at start of the page, i was use the link as present in ReadMe :

could you tell me from where can come this issue ?(without the space)

Kind regards ! and thankyou in advance

and i was verify the driver are well installing Mssql Odbc and PDO driver xD

Sorry i forgot to include db.php as well as includeVote.php

<?php
include 'includes/db.php';
include 'includes/includeVote.php';
?>
Redirecting....<meta http-equiv="refresh" content="3;url=login.php">

paste this over the contents of index.php and it should fix the issue.

[SkuulCandy]

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in C:\xampp2\htdocs\ShaiyaVote\includes\db.php:7 Stack trace: #0 C:\xampp2\htdocs\ShaiyaVote\includes\db.php(7): PDO->__construct('sqlsrv:Server=1...', 'my_sql_username', 'my_sql_password') #1 C:\xampp2\htdocs\ShaiyaVote\index.php(2): include('C:\\xampp2\\htdoc...') #2 {main} thrown in C:\xampp2\htdocs\ShaiyaVote\includes\db.php on line 7

I have this error. Do not find the PDO Driver :/