Voting Box

[cpnm1]

This will be my first contribution to the forum.

What you need?

- A site connected to your MsSQL server
- ODBC
- Brain
- Computer

First, you need to execute these queries:

 Spoiler

USE [ACCOUNT_DBF]
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD votepoints int NOT NULL CONSTRAINT [DF_ACCOUNT_TBL_votepoints]  DEFAULT (0),
 lastvote1 DATETIME,
 lastvote2 DATETIME,
 lastvote3 DATETIME

 Spoiler

USE [WEBSITE_DBF]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_userpanel_log]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_userpanel_log](
	[SEQ] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](32) NOT NULL,
	[m_szName] [varchar](32) NOT NULL,
	[m_idPlayer] [varchar](7) NOT NULL,
	[action] [varchar](max) NOT NULL,
	[datetime] [datetime] NOT NULL,
 CONSTRAINT [PK_rev3_userpanel_log] PRIMARY KEY CLUSTERED 
(
	[SEQ] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_ukashlogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_ukashlogs](
	[ukashid] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](50) NOT NULL,
	[pincode] [varchar](19) NOT NULL,
	[worth] [varchar](10) NOT NULL,
	[datetime] [datetime] NOT NULL,
	[done] [int] NOT NULL CONSTRAINT [DF_rev3_ukashlogs_done]  DEFAULT ((0)),
	[key] [varchar](32) NOT NULL,
 CONSTRAINT [PK_rev3_ukashlogs] PRIMARY KEY CLUSTERED 
(
	[ukashid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_staff]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_staff](
	[SEQ] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](32) NOT NULL,
	[Rang] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_psclogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_psclogs](
	[pscid] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](50) NOT NULL,
	[pincode] [varchar](20) NOT NULL,
	[worth] [varchar](10) NOT NULL,
	[datetime] [datetime] NOT NULL,
	[done] [int] NOT NULL CONSTRAINT [DF_rev3_psclogs_done]  DEFAULT ((0)),
	[key] [varchar](32) NOT NULL,
 CONSTRAINT [PK_rev3_psclogs] PRIMARY KEY CLUSTERED 
(
	[pscid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_newscomments]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_newscomments](
	[ncid] [int] IDENTITY(1,1) NOT NULL,
	[nid] [int] NOT NULL,
	[author] [varchar](50) NOT NULL,
	[content] [text] NOT NULL,
	[ip] [varchar](50) NOT NULL,
	[datetime] [datetime] NOT NULL,
 CONSTRAINT [PK_rev3_newscomments] PRIMARY KEY CLUSTERED 
(
	[ncid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_newscategories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_newscategories](
	[ncatid] [int] IDENTITY(1,1) NOT NULL,
	[title] [varchar](50) NOT NULL,
	[icon] [varchar](50) NOT NULL,
 CONSTRAINT [PK_rev3_newscategories] PRIMARY KEY CLUSTERED 
(
	[ncatid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_news]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_news](
	[nid] [int] IDENTITY(1,1) NOT NULL,
	[title] [varchar](50) NOT NULL,
	[text] [text] NOT NULL,
	[category] [int] NOT NULL,
	[author] [varchar](50) NOT NULL,
	[datetime] [datetime] NOT NULL,
	[views] [int] NOT NULL CONSTRAINT [DF_rev3_news_views]  DEFAULT ((0)),
 CONSTRAINT [PK_rev3_news] PRIMARY KEY CLUSTERED 
(
	[nid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_mallcategories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_mallcategories](
	[mcatid] [int] IDENTITY(1,1) NOT NULL,
	[category] [varchar](50) NOT NULL,
 CONSTRAINT [PK_rev3_mallcategories] PRIMARY KEY CLUSTERED 
(
	[mcatid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_mallbasket]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_mallbasket](
	[mbid] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](50) NOT NULL,
	[item] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_mall]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_mall](
	[mid] [int] IDENTITY(1,1) NOT NULL,
	[itemid] [int] NULL,
	[name] [varchar](100) NULL,
	[description] [varchar](200) NULL,
	[price] [int] NULL,
	[count] [int] NULL,
	[category] [int] NULL,
	[icon] [varchar](100) NULL,
	[packet] [int] NULL,
	[Item_ID_1] [int] NULL,
	[Item_Count_1] [int] NULL,
	[Item_ID_2] [int] NULL,
	[Item_Count_2] [int] NULL,
	[Item_ID_3] [int] NULL,
	[Item_Count_3] [int] NULL,
	[Item_ID_4] [int] NULL,
	[Item_Count_4] [int] NULL,
	[job] [int] NULL,
 CONSTRAINT [PK_rev3_mall] PRIMARY KEY CLUSTERED 
(
	[mid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_giftlogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_giftlogs](
	[giftid] [int] IDENTITY(1,1) NOT NULL,
	[item] [int] NOT NULL,
	[accfrom] [varchar](50) NOT NULL,
	[accto] [varchar](50) NOT NULL,
	[charto] [varchar](50) NULL,
	[datetime] [datetime] NOT NULL,
 CONSTRAINT [PK_rev3_giftlogs] PRIMARY KEY CLUSTERED 
(
	[giftid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_faq]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_faq](
	[faqid] [int] IDENTITY(1,1) NOT NULL,
	[question] [varchar](200) NOT NULL,
	[answer] [varchar](200) NOT NULL,
 CONSTRAINT [PK_rev3_faq] PRIMARY KEY CLUSTERED 
(
	[faqid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_downloads]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_downloads](
	[dlid] [int] IDENTITY(1,1) NOT NULL,
	[title] [varchar](50) NOT NULL,
	[description] [varchar](200) NOT NULL,
	[link] [varchar](100) NOT NULL,
	[datetime] [datetime] NOT NULL,
	[clicks] [int] NOT NULL CONSTRAINT [DF_rev3_downloads_clicks]  DEFAULT ((0)),
 CONSTRAINT [PK_rev3_downloads] PRIMARY KEY CLUSTERED 
(
	[dlid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_counter]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_counter](
	[Website] [varchar](50) NOT NULL,
	[Count] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_config]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_config](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[col] [varchar](50) NOT NULL,
	[value] [varchar](100) NOT NULL,
 CONSTRAINT [PK_rev3_config] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_buylogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_buylogs](
	[bid] [int] IDENTITY(1,1) NOT NULL,
	[item] [int] NOT NULL,
	[account] [varchar](50) NOT NULL,
	[datetime] [datetime] NOT NULL,
 CONSTRAINT [PK_rev3_buylogs] PRIMARY KEY CLUSTERED 
(
	[bid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_banlogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_banlogs](
	[banid] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](50) NOT NULL,
	[byadmin] [varchar](50) NOT NULL,
	[reason] [text] NULL,
	[datetime] [datetime] NOT NULL,
 CONSTRAINT [PK_rev3_banlogs] PRIMARY KEY CLUSTERED 
(
	[banid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_xShop]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_xShop](
	[SEQ] [int] IDENTITY(1,1) NOT NULL,
	[Display] [int] NOT NULL,
	[ID] [int] NOT NULL,
	[Name] [varchar](128) NOT NULL,
	[Description] [varchar](256) NOT NULL,
	[Job] [int] NOT NULL,
	[Sex] [int] NOT NULL,
	[Category] [int] NOT NULL,
	[Price] [int] NOT NULL,
	[Discount] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[Purchase] [int] NOT NULL,
	[Icon] [varchar](100) NOT NULL,
	[Packet] [int] NOT NULL,
	[ID_1] [int] NULL,
	[Name_1] [varchar](128) NULL,
	[Amount_1] [int] NULL,
	[ID_2] [int] NULL,
	[Name_2] [varchar](128) NULL,
	[Amount_2] [int] NULL,
	[ID_3] [int] NULL,
	[Name_3] [varchar](128) NULL,
	[Amount_3] [int] NULL,
	[ID_4] [int] NULL,
	[Name_4] [varchar](128) NULL,
	[Amount_4] [int] NULL,
	[ID_5] [int] NULL,
	[Name_5] [varchar](128) NULL,
	[Amount_5] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_voteitems]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_voteitems](
	[vitemid] [int] IDENTITY(1,1) NOT NULL,
	[itemid] [int] NOT NULL,
	[name] [varchar](50) NOT NULL,
	[count] [int] NOT NULL,
	[price] [int] NOT NULL,
	[icon] [varchar](50) NOT NULL,
 CONSTRAINT [PK_rev3_voteitems] PRIMARY KEY CLUSTERED 
(
	[vitemid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_vote_log]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_vote_log](
	[SEQ] [int] IDENTITY(1,1) NOT NULL,
	[Account] [varchar](32) NOT NULL,
	[m_idPlayer] [varchar](7) NOT NULL,
	[IP] [varchar](15) NOT NULL,
	[Item_Name] [varchar](50) NOT NULL,
	[Item_Id] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[Datum] [datetime] NOT NULL,
 CONSTRAINT [PK_rev3_vote_log] PRIMARY KEY CLUSTERED 
(
	[SEQ] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_user_panel_log]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_user_panel_log]
	@account varchar(32),
	@m_szName varchar(32),
	@m_idPlayer varchar(7),
	@action varchar(MAX)
AS
BEGIN
	SET NOCOUNT ON;

    INSERT INTO [web_userpanel_log] ( [account], [m_szName], [m_idPlayer], [action], [datetime] )
    VALUES ( @account, @m_szName, @m_idPlayer, @action, GETDATE() )
END
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_LoguKash]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_LoguKash]
	@account varchar(32),
	@psc varchar(19),
	@worth varchar(10),
	@key varchar(32)
AS
BEGIN
	SET NOCOUNT ON;

	INSERT INTO [web_uKashlogs] ( [account], [pincode], [worth], [datetime], [done], [key] )
	VALUES ( @account, @psc, @worth, GETDATE(), 0, @key )
END
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_LogPSC]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_LogPSC]
	@account varchar(32),
	@psc varchar(19),
	@worth varchar(10),
	@key varchar(32)
AS
BEGIN
	SET NOCOUNT ON;

	INSERT INTO [web_psclogs] ( [account], [pincode], [worth], [datetime], [done], [key] )
	VALUES ( @account, @psc, @worth, GETDATE(), 0, @key )
END
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[xShop]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[xShop] 
	@SEQ int = 0,
	@Cat int = 0,
	@Account varchar(16) = '''',
	@Mode varchar(128) = ''''
AS
BEGIN
	SET NOCOUNT ON;
	
	-- Select Shop Content
	if( @Mode = ''S_Category'' )
		begin
			select * from web_mallcategories
		end
	-- Select Items from SEQ
	else if( @Mode = ''S_Items'' )
		begin
			select * from web_xShop where [Category] = @Cat and [Display] = 1 order by [Name] ASC
		end
END
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_AddVote]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_AddVote] 
	@account varchar(32),
	@m_idPlayer varchar(7),
	@ip varchar(15),
	@Item_Name varchar(50),
	@Item_Id int,
	@Amount int
AS
BEGIN
	SET NOCOUNT ON;

    INSERT INTO [web_vote_log]( [Account], [m_idPlayer], [IP], [Item_Name], [Item_Id], [Amount], [Datum] )
    VALUES ( @account, @m_idPlayer, @ip, @Item_Name, @Item_Id, @Amount, GETDATE() )
END
' 
END


GO

Now for the PHP codes:
The source was based from this files:
I forgot where I got this and who uploaded it but, I would love to give him credits =D

Anyway, his voting scripts we're finished and has a lots of bugs. To be honest, I don't know anything about PHP, SQL, or any website programming languages. I tried to ask if someone knows how to fix it. But unfortunately, no one does. So I studied PHP, ODBC and MsSQL languages. It took me 3 days to understand the algorithm of the script and another 3 days to debug it. Off with the story. Let's proceed =D

Create 4 files and name it ajax.php, config.inc.php and votebox.inc.php, function

use this code for ajax.php

 Spoiler

<?php
	include('config.inc.php');
	if(empty($_GET['page'])) $_GET['page'] = 1;
	
	/* VOTE BOX */
	if($_GET['a'] == 'showvotebox') {
		$_SESSION['votebox'] = 'showed';
	}
	
	if($_GET['a'] == 'hidevotebox') {
		$_SESSION['votebox'] = 'hidden';
	}
	
	if($_GET['a'] == 'voteitem') {
		$selecteditems = odbc_exec($mssql, 'SELECT * FROM [web_voteitems] WHERE vitemid=\''.mssql_escape_string($_GET['vid']).'\'');
		$selecteditem = odbc_fetch_array($selecteditems);
		odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
		$userselect = odbc_exec($mssql, 'SELECT * FROM [ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
		$user = odbc_fetch_array($userselect);
		
		if($user['votepoints'] < $selecteditem['price']) {
			echo '<span style="color: #f00;">You do not have enough Vote Points!</span><br/><br/>';
		} else {
			if(empty($_GET['char']) || !isset($_GET['char'])) {
				echo '<span style="color: #f00;">You need to have a character!</span><br/><br/>';
			} elseif($selecteditem == '') {
				echo '<span style="color: #f00;">The selected item does not exist!</span><br/><br/>';
			} else {
				odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
				$accountofchar = odbc_exec($mssql, 'SELECT account FROM [CHARACTER_TBL] WHERE m_idPlayer=\''.mssql_escape_string($_GET['char']).'\'');
				if(strtolower(odbc_result($accountofchar, 'account')) == strtolower($_SESSION['user'])) {
					send_item($_GET['char'], $selecteditem['name'], $selecteditem['count']);
					odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
					odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints-\''.mssql_escape_string($selecteditem['price']).'\' WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
					echo '<script type="text/javascript">Current Vote Points(\''.$user['votepoints'].'\', \''.$selecteditem['price'].'\');</script>';
					echo 'You bought the item successfully!<br/><br/>';
				}
			}
		}
	}
	if($_GET['a'] == 'voteitemspage') {
		echo '<table>';
		odbc_exec($mssql, 'USE [WEBSITE_DBF]');
		$items = odbc_exec($mssql, 'SELECT * FROM [web_voteitems]');
		
		$page = $_GET['page'];
		$perpage = 2;
		$resultset = array();
		$counter = 0;
		while($row = odbc_fetch_array($items)) {
			$resultset[$counter++] = $row;
		}
		$count = odbc_exec($mssql, 'SELECT COUNT(*) as i FROM [web_voteitems]');
		$countpages = odbc_result($count, 'i') / $perpage;
		
		for($i = $perpage * ($page-1);$i < $perpage*$page;$i++) {
			if(isset($resultset[$i])) {
				echo '<tr>
					<td style="vertical-align: top;"><img src="./img/'.$resultset[$i]['icon'].'" /></td>
					<td valign="top">
						<b>'.$resultset[$i]['name'].'</b><br/>
						<table><tr><td><img src="img/price.png" /></td><td>'.$resultset[$i]['price'].' Vote Points</td></tr></table>';
					if(isset($_SESSION['user'])) {
						echo '<a href="javascript:voteItem('.$resultset[$i]['vitemid'].')">Take it!</a>';
					}
					echo '</td>
				</tr>
				<tr><td colspan="2"><br/></td></tr>';
			}
		}
		echo '</table>';
		for($i=0; $i < $countpages; $i++) {
			$k = $i + 1;
			if($page == $k) {
				 echo '<span id="page"><b>'.$k.'</b></span>';
			} else {
				echo '<span id="page"><a href="javascript:voteItemsPage('.$k.');">'.$k.'</a></span>';
			}
		}
	}
	if($_GET['a'] == 'voteitems') {
		echo 'Here you can vote <by>to support the server and ger free gifts.<br/><br/>';
		if(isset($_SESSION['user'])) {
			odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
			$player = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE account=\''.mssql_escape_string($_SESSION['user']).'\' AND isblock=\'F\' ORDER BY playerslot');
			if(odbc_num_rows($player) >= 1) {
				echo 'Character: <form method="post"><select type="text_klein" name="character" id="character">';
				while($char = odbc_fetch_array($player)) {
					echo '<option value="'.$char['m_idPlayer'].'">'.$char['m_szName'].'</option>';
				}
				echo '</select></form><br/>';
			}
		}
		echo 'Available Gifts:<br/><br/>
		<div id="availgifts">
		<table>';
		odbc_exec($mssql, 'USE [WEBSITE_DBF]');
		$items = odbc_exec($mssql, 'SELECT * FROM [web_voteitems]');
		$page = $_GET['page'];
		if(!isset($page)) { $page = 1; }
		$perpage = 2;
		$resultset = array();
		$counter = 0;
		while($row = odbc_fetch_array($items)) {
			$resultset[$counter++] = $row;
		}
		$count = odbc_exec($mssql, 'SELECT COUNT(*) as i FROM [web_voteitems]');
		$countpages = odbc_result($count, 'i') / $perpage;
		
		for($i = $perpage * ($page-1);$i < $perpage*$page;$i++) {
			if(isset($resultset[$i])) {
				echo '<tr>
					<td style="vertical-align: top;"><img src="./img/'.$resultset[$i]['icon'].'" /></td>
					<td valign="top">
						<b>'.$resultset[$i]['name'].'</b><br/>
						<table><tr><td><img src="img/price.png" /></td><td>'.$resultset[$i]['price'].' Vote Points</td></tr></table>';
					if(isset($_SESSION['user'])) {
						echo '<a href="javascript:voteItem('.$resultset[$i]['vitemid'].');">Take it!</a>';
					}
					echo '</td>
				</tr>
				<tr><td colspan="2"><br/></td></tr>';
			}
		}
		echo '</table>';
		for($i=0; $i < $countpages; $i++) {
			$k = $i + 1;
			if($page == $k) {
				 echo '<span id="page"><b>'.$k.'</b></span>';
			} else {
				echo '<span id="page"><a href="javascript:voteItemsPage('.$k.');">'.$k.'</a></span>';
			}
		}
		echo '</div><br />';
		if(isset($_SESSION['user'])) {
			odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
			$votepoints = odbc_exec($mssql, 'SELECT [votepoints] FROM [ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_SESSION['account']).'\'');
			echo 'Current Vote Points: <b><span id="currvp">'.odbc_result($votepoints, 'votepoints').'</span></b><br/><br/>';
			echo '<span id="takeitem"></span>';
			echo '<a href="javascript:voteTab();"><b>Click here to Vote!</b></a>';
		} else {
			echo '<b>You need to login to vote!</b>';

		}
	}
	if($_GET['a'] == 'vote') { // Vote Box
		odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
		$userselect = odbc_exec($mssql, 'SELECT * FROM [ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
		$user = odbc_fetch_array($userselect);
		
		$time1 = $user['lastvote1'];
		$time2 = $user['lastvote2'];
		$time3 = $user['lastvote3'];
		
		$diff1 = diff1($user['lastvote1']);
		$diff2 = diff2($user['lastvote2']);
		$diff3 = diff3($user['lastvote3']);
		$votedtoday = 0;
		if($diff1['hours'] < 12)
			$votedtoday = $votedtoday + 1;
		if($diff2['hours'] < 12)
			$votedtoday = $votedtoday + 1;
		if($diff3['hours'] < 12)
			$votedtoday = $votedtoday + 1;
		echo 'Account: <b>'.$user['account'].'</b><br/><br/>';
		echo 'Account Vote Points: <b><span id="vpoints">'.$user['votepoints'].'</span></b><br/><br/>';
		echo 'You can still vote <b><span id="vtoday"> '.(3 - $votedtoday).' </span></b> times.<br/><br/>';
		if($diff1['hours'] >= 12 || $diff2['hours'] >= 12 || $diff3['hours'] >= 12) {
			if(isset($_GET['submit'])) {
				if($_GET['submit'] == 1) {
					if($diff1['hours'] >= 12) {
						odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints + 1 WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
						odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET lastvote1 =\''.date('m-d-Y H:i:s').'\' WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
						$_GET['submit'];
					}
				} elseif($_GET['submit'] == 2) {
					if($diff2['hours'] >= 12) {
						odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints + 1 WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
						odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET lastvote2 =\''.date('m-d-Y H:i:s').'\' WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
						$_GET['submit'];
						
					}
				} elseif($_GET['submit'] == 3) {
					if($diff3['hours'] >= 12) {
						odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints + 1 WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
						odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET lastvote3 =\''.date('m-d-Y H:i:s').'\' WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
						$_GET['submit'];
					}
				}
			}
			echo 'You get 1 vote point per page.<br>After the votes you can pick a gift!<br>Follow the instructions in order to vote for all 3 Topsites.<br/><br/><div id="topsite" style="text-align: center;">';
			if($diff1['hours'] >= 12) {
				// Top of Games
				echo '<img src="img/tog.gif" /><br/><br/>';
				echo '<span id="votetext"><a onclick="vote(1, '.$diff2['hours'].', \''.$votelist2.'\', \''.$votelist3.'\');" href="'.$votelist1.'" target="_blank">Click here to continue!</a></span>';
			} elseif($diff2['hours'] >= 12 ) {
				// Xtreme Top 100
				echo '<img src="img/xtop100.jpg" /><br/><br/>';
				echo '<span id="votetext"><a onclick="vote(2, '.$diff3['hours'].', \''.$votelist2.'\', \''.$votelist3.'\');" href="'.$votelist2.'" target="_blank">Click here to continue!</a></span>';
			} elseif($diff3['hours'] >= 12) {
				// G Top 100
				echo '<img src="img/gtop100.jpg" /><br/><br/>';
				echo '<span id="votetext"><a onclick="vote(2, '.$diff3['hours'].', \''.$votelist2.'\', \''.$votelist3.'\');" href="'.$votelist2.'" target="_blank">Click here to continue!</a></span>';
			}
			echo '</div>';
		} else {
			echo '<a href="javascript:voteItemTab();">Select an item!</a>';
		}
	}
	/* VOTE BOX END */
?>

For config.inc.php, use this code:

 Spoiler

<?php
	session_start();
	
	// SQL Data
	define('MSSQL_HOST', 'MYSERVER\SQLEXPRESS');	// MsSQL Host
	define('MSSQL_USER', 'sa');	// MsSQL Username
	define('MSSQL_PASS', 'mypass');	// MsSQL Password
	
	// Connecting to MsSQL (ODBC)
	$mssql = odbc_connect('Driver={SQL Server};Server='.MSSQL_HOST.';', MSSQL_USER, MSSQL_PASS);
	
	// Including Files
	include('functions.inc.php');
	
	// Config
	$_CONFIG['webtitle'] = getConfigValue('webtitle', 'myweb');
	$_CONFIG['forumlink'] = getConfigValue('forumlink', 'http://forum.myweb.com/');
	$_CONFIG['pwdsalt'] = getConfigValue('pwdsalt', 'mypwdsalt');
	$_CONFIG['noreply'] = getConfigValue('noreplymail', '');
	$_CONFIG['ppemail'] = getConfigValue('ppemail', '');
	
	// PaySafeCard: Euro => Points
	$psc_values = array('10,00' => '1500', '25,00' => '3000', '50,00' => '6000', '100,00' => '13000');
	
	// Vote Sites (must be 3!)
	$votelist1 = 'http://votelink1.com'; // Top of Games
	$votelist2 = 'http://votelink2.com'; // Xtreme Top 100
	$votelist3 = 'http://votelink3.com'; // G Top 100
?>

For functions.inc.php, use this code:

 Spoiler

<?php
	function mssql_escape_string($string) {
		$replaced_string = str_replace("'", "''", $string);
		return $replaced_string;
	}
	
	function diff1($time1) {
		$diff = strtotime(date('Y-m-d H:i:s')) - strtotime($time1);
		$minutes = $diff / 60;
		if($minutes >= 60) {
			$hours = $minutes / 60;
			$minutes = $minutes % 60;
		} else {
			$hours = 0;
		}
		return array('hours' => floor($hours), 'minutes' => $minutes);
	}
	
	function diff2($time2) {
		$diff = strtotime(date('Y-m-d H:i:s')) - strtotime($time2);
		$minutes = $diff / 60;
		if($minutes >= 60) {
			$hours = $minutes / 60;
			$minutes = $minutes % 60;
		} else {
			$hours = 0;
		}
		return array('hours' => floor($hours), 'minutes' => $minutes);
	}
	
	function diff3($time3) {
		$diff = strtotime(date('Y-m-d H:i:s')) - strtotime($time3);
		$minutes = $diff / 60;
		if($minutes >= 60) {
			$hours = $minutes / 60;
			$minutes = $minutes % 60;
		} else {
			$hours = 0;
		}
		return array('hours' => floor($hours), 'minutes' => $minutes);
	}
	
	function send_item($playerid, $itemid, $quantity) {
		global $mssql;
		odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
		odbc_exec($mssql, 'INSERT INTO [ITEM_SEND_TBL](
		m_idPlayer, serverindex, Item_Name, Item_count, idSender
		) VALUES(
		\''.mssql_escape_string($playerid).'\',
		\'01\',
		\''.mssql_escape_string($itemid).'\',
		\''.mssql_escape_string($quantity).'\',
		\'0000000\')');
	}
	
	function send_item_list($playerid, $itemidArray, $quantityArray) {
		global $mssql;
		for($i = 0;$i < count($itemidArray);$i++)
		{
			odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
			odbc_exec($mssql, 'INSERT INTO [ITEM_SEND_TBL](
			m_idPlayer, serverindex, Item_Name, Item_count, idSender
			) VALUES(
			\''.mssql_escape_string($playerid).'\',
			\'01\',
			\''.mssql_escape_string($itemidArray[$i]).'\',
			\''.mssql_escape_string($quantityArray[$i]).'\',
			\'0000000\')');
		}
	}
?>

For votebox.inc.php, use this code:

 Spoiler

Here you can vote<br/>
to support the server and get free <b>Gifts</b>.
<br/>
<?php
	if(empty($_GET['page'])) $_GET['page'] = 1;
	
	if(isset($_SESSION['user'])) {
		odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
		$player = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE account=\''.mssql_escape_string($_SESSION['user']).'\' AND isblock=\'F\' ORDER BY playerslot');
		if(odbc_num_rows($player) >= 1) {
			echo 'Character: <form method="post"><select name="character" id="character">';
			while($char = odbc_fetch_array($player)) {
				echo '<option value="'.$char['m_idPlayer'].'">'.$char['m_szName'].'</option>';
			}
			echo '</select></form><br/>';
		}
	}
?>
Available Gifts:<br/><br/>
<div id="availgifts">
<table>
<?php
	odbc_exec($mssql, 'USE [WEBSITE_DBF]');
	$items = odbc_exec($mssql, 'SELECT * FROM [web_voteitems]');
	
	$page = $_GET['page'];
	if(!isset($page)) { $page = 1; }
	$perpage = 2;
	$resultset = array();
	$counter = 0;
	while($row = odbc_fetch_array($items)) {
		$resultset[$counter++] = $row;
	}
	$count = odbc_exec($mssql, 'SELECT COUNT(*) as i FROM [web_voteitems]');
	$countpages = odbc_result($count, 'i') / $perpage;
	
	for($i = $perpage * ($page-1);$i < $perpage*$page;$i++) {
		if(isset($resultset[$i])) {
			echo '<tr>
				<td style="vertical-align: top;"><img src="./img/'.$resultset[$i]['icon'].'" /></td>
				<td valign="top">
					<b>'.$resultset[$i]['name'].'</b><br/>
					<table><tr><td><img src="img/price.png" /></td><td>'.$resultset[$i]['price'].' Vote Points</td></tr></table>';
				if(isset($_SESSION['user'])) {
					echo '<a href="javascript:voteItem('.$resultset[$i]['vitemid'].')">Take it!</a>';
				}
				echo '</td>
			</tr>
			<tr><td colspan="2"><br/></td></tr>';
		}
	}
?>
</table>
<?php
	for($i=0; $i < $countpages; $i++) {
		$k = $i + 1;
		if($page == $k) {
			 echo '<span id="page"><b>'.$k.'</b></span>';
		} else {
			echo '<span id="page"><a href="javascript:voteItemsPage('.$k.');">'.$k.'</a></span>';
		}
	}
	echo '</div><br />';
	if(isset($_SESSION['user'])) {
		odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
		$votepoints = odbc_exec($mssql, 'SELECT [votepoints] FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');
		echo 'Current Vote Points: <b><span id="votespoints">'.odbc_result($votepoints, 'votepoints').'</span></b><br/><br/>';
		echo '<span id="takeitem"></span>';
		echo '<a href="javascript:voteTab();"><b>Click here to Vote!</b></a>';
	} else {
		echo '<b>You need to login to vote!</b>';
	}
?>

That's all, now try to check if it's working...
Enjoy!



My code isn't professional, I'm just new to this programming languages. You could improve my code if you want.


Credits:
80% To the one who uploaded wwwroot.rar
20% To me for finishing his work.

If you used the wwwroot.rar, you need to change the language by yourself =D

[- DK]

This give 100000 in Elitepvpers ? Closerrequest .because this give in many Hompages from Stefan Pfeifer This Votebox is from Stefan Pfeifer All Credits go to Stefan Pfeifer

[cpnm1]

Originally Posted by Armageddon ™

This give 100000 in Elitepvpers ? Closerrequest .because this give in many Hompages from Stefan Pfeifer This Votebox is from Stefan Pfeifer All Credits go to Stefan Pfeifer

lol, but he didn't finish the work...there were a lot of bugs... so i fixed it and add some codes to it...and please read the last part of the post...

[- DK]

Originally Posted by cpnm1

lol, but he didn't finish the work...there were a lot of bugs... so i fixed it and add some codes to it...and please read the last part of the post...

o.O i dont see any Bugs `? All my Votebox in 3 Years work without problems ?

[cpnm1]

Originally Posted by Armageddon ™

o.O i dont see any Bugs `? All my Votebox in 3 Years work without problems ?

go ahead and search for his post...try to check the files your self and compare it with mine...and try to read the replies...

Learn to be mature, start reading and stop flaming!

and btw, it's not Stefan Pfeifer's code..

it's from Final Sensation, now I remember...please do more of this(obervation, work) than this(talking, flaming)

and i didn't ask for how long your voting box lasted...no one did ask...

[raventh1984]

Actualy every one is using this vote box. 80% of the websites coded by Stefan has this funtion. [Forsaken Flyff] Etc. dont know it all. I believe this was made by Stefan it self. And the reason you have this from an other website is cause its easy to have to vote box seperated from the website and implant it to an other website.

And he isn't Flaming. He just made his point in this matter. And for the bugs.
There where almost 0 buggs. The reason must players couldnt get it to work was of their own ignorence. They want it spoon feed rather then learn from it. Why do you think if we release something that we dont spoon feed it all. Then the whole dev part is dead cause no one learns from it.

With kind regards,

Loky.