Blancer.com Tutorials and projects

Restrictions With Php/mysql
Hello, I have a game where players get statistics such as wins and losses.

Let’s say Player1 wins a game against Player2, the Player1 will have a win to his profile, and Player2 will have a loss to his profile.
http://polargammon.com/stats.php?game=WAR3&type=solo
(You can click on a player to see his record)

All of this is already controlled by PHP and MySQL.

Though, let’s say Player1 is friends with Player2, and Player2 decides to give him “Freewins”, for example they will play 100 games on which Player2 will leave right at the start of the game.

I want to avoid this, and my idea is to simple add a restriction using the IP adresses of the players.

The IP adresses of each player are ALREADY recorded in MySQL.

The plan is, let’s say BOB plays against JACK one game, and Bob wins, he gets his win and Jack gets his loss. Then, any game they play afterwards WILL NOT BE COUNTED before let’s say 15 minutes.
They CAN play again for fun, but the record will not be counted, unless they play for real because a game lasts about 15 minutes.

Simple PHP/MySQL work, should be done fast and the price should be reasonable.

Template Customization – Css
Immediate need for customizing a Pligg template (Mystique), which is essentially a CSS template with callouts to Pligg modules. You must be superb at CSS, and able to work with Pligg V 1.0.3.

Ongoing, we will have needs for customization of Pligg, some Javascript and PHP work.

Optional but desirable is general Pligg expertise.

Whmcs Licensing Add On Install
We currently use WHMCS and have recently purchased and installed the Licensing Addon. It is successfully installed and it working via the admin. We now need it to work with a database in mySQL so that we can distribute scripts in a zip/rar file and have the licensing system generate a unique license for the install and call back to our database to verify that it is a valid install.

This is some of the info provided to us regarding the set up:

For database calls you would just use the regular PHP query functions. For example if you were to create a database table named “licensedata” with 2 text fields called licensekey and localkey then when you first install you would populate the licensekey value only, and then each time a license check needs to be performed, you would first use the Get Local Key section to retrieve the values then call the check_license function as in the sample code already provided, and then when that completes and is successful so you get a new local key returned, you would run the Update Local Key section of the below example:
[CODE]<?php

$whmcsmysql = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name) or die(“Could not connect to the database”);

# Get Local Key
$result = mysql_query(“SELECT licensekey,localkey FROM licensedata”);
$data = mysql_fetch_array($result);
$licensekey = $data[0];
$localkey = $data[1];

# Save Local Key
$result = mysql_query(“UPDATE licensedata SET localkey='”.mysql_real_escape_string($localkey).”‘”);

?>[/CODE]

We will test the finished product with a couple of scripts by generating the download and installing to a correct domain and an incorrect domain.

Vbulletin Lounge Addon
I’m building a website using vBulletin similar to www.fubar.com, but vBulletin doesn’t have an add-on that we would like created.
Lounge Add-on

• Create Lounge (Title/Name – Example: groupname)

• Users can join (subscribe) the lounge.

• Creator of Lounge “Known as: Owner” can set “Users” with admin privileges.

• Ban Users from Lounge (Owner Only)

• Users can leave (unsubscribe) the lounge.

• Ability to completely change the look and style of your lounge.

• Ability “Add Keywords, Privacy Setting, Add Music”.

• Customizable Lounge Page (Right/Left Blocks / Center Blocks)
Ability to enable/disable HTML/JavaScript.

• Add Music Add-on, Needs to have options; Drop-down menu: Flash
Player, Windows Media Player or Custom. Flash Player and Windows
Media Player will show options to set “Stream URL” and “Port” and Skinning options. Custom will show a text area box to place your own code.

• Ability to interact with User Level and Points/Cash System

• Store Options, Such as virtual gifts – Use Points/Cash System to by them – Even “Happy Hour” for buying “drinks” Customized by “SITE OWNER” and how much each gift/drink costs.

• Subscription Mod, Create plans or just set it for free (none would be free)

• Customized IRC Based Chat Room, (Main Settings->Connects to my main network) ‘Auto Sets’ admins as OWNER (~) and the admins with defined options in the admin center. (at – % – &) Joined Members will have (+Voice) – Settings

• Mod rewrite for lounge.

• Mass Mail option for Joined Members (to come back)

We’re using vBulletin 3.8.x – Going to be upgrading to 4.0.x
Test Forum, cPanel/FTP Access can be provided. (4.0)

NOTE: Possible NEW features, Upgrades (Newer for vBulletin) maybe required and after initial script is coded, possible small fee for doing NEW features/upgrades.

If I have any additional ideas after this post, please read the PMB.

Our budget is specified above, Please DO NOT bid more than the amount shown otherwise you will not be picked.

This script is a robust Fubar Clone like script an Lounge Addon using vBulletin Products/Plugin.

Thanks

Ecommerce For Marketplace
I am exploring a ecommece solution for a marketplace (ie multiple vendors/ sellers) selling and buying ebooks and physical products. The vendor can have their own storefront (ie their own website) to sell whatever products that are available in the main store. On top of selling own products, they get commission for selling other vendor’s products. The vendor’s storefront is a clone of the main storefront but can look entirely different that carries their own domain name. The storefront links to the main central database.

Remuneration structure:
60% of revenue will be given to sellers and 40% to go admin and affiliate.
Admin and Affiliates can earn from selling any of the products sold here with 50:50 revenue split.
For example, seller list a price say USD10
Admin & Affiliate takes 40% of every sale done. In this case, USD4
Admin and Affiliate have a 50% split.
If the sale is generated from an Affiliate, USD2 goes to Admin and USD2 goes to Affliate.
Need to have features such as:
1. When buyer buys a product, the system pay seller 60% of the fees instantly and the remaining 40% goes to Admin?
2. From revenue received, admin will then pay 50% to respective affiliate and remaining goes to admin.
3. When seller received order, seller will process order and update status in the system.
4. If it is a ebook, ebook will be instantly sent for download upon receipt of payment.
5. Sellers get to see sales report.
6. Affiliate report is available?