Blancer.com Tutorials and projects

Need someone to turn a photoshop template for a website into a wordpress site. All .psd files will be provided. I need this project completed asap so only bid if you are ready to start now. Site requires strong wordpress experience, JQuery, Javascript, and CSS. Attention to detail is very important.
Hompage (with slider, dropdown menus)
Innerpage (with sub-navigation bar)
Blog Page

Build Your Own Ring-Design Your Own Ring

.net
.aspx
javascript
css

================================================
need functioning module

Go to link and you will see a ring, under it there are stones;when you click on one of the stones it connects to a javascriptfile for functional command and to only top over-lay picture of diamond and prong setting.

http://www.mondera.com/DYO/RingSettingProduct.aspx?partno=3004327&diamtype=&Back=&metal=19,20,34&set=120,0,0,0

It is easy to copy any item page by simply going to webpage, going to file save page as and save web page,complete or using software but cannot seem to be able to copy javascript file associated with function and pictures attached to it.

function changesetting
javascript:changesetting(‘Shape’);
images-need for categories;have all product images but not sure if design your own feature only loads stone, stone with prong setting.

approx amount of stone settings for feature:
I estimate about 20 images

categories…
-Traditional Solitaire Setting
-Matching Sets
-Diamond Side Stones

PLEASE ONLY BID IF YOU UNDERSTAND WHAT I’M ASKING FOR.

I’m using 68 Classifieds and the script automatically generates a query when a user performs a search on the site. A sample search generates the following query:

SELECT pID FROM class_products_fields WHERE fID=26 AND sValue LIKE ‘%Bay Ridge|%’ AND sValue LIKE ‘%Bed-Stuy|%’

That query doesn’t return any values because I need an OR statement on the THIRD CONDITION. I need my query to read like this:

SELECT pID FROM class_products_fields WHERE fID=26 AND sValue LIKE ‘%Bay Ridge|%’ OR sValue LIKE ‘%Bed-Stuy|%’

The code that’s generating the SQL is this:

$option=str_replace(‘opt’,”,$objItem);
$option = (int)$option;
$search=”;
foreach($objValue as $key)
{
$search2 = $key.’|’;
$search .= “AND sValue LIKE ‘%”. safeAddSlashes($search2) .”%’ “;
}

This project is to modify the code so that each pass after the first AND will use an OR statement instead of just writing AND statements.

I am looking for someone who can do this 2-3 times a month
I need 10 accounts made at each module forsenuke
Each must have different info used
Each must have a yahoo email made with it make the yahoo email username the same as the user name made for the account
Make the passwords the same for the account and the email

Each account name and password will be completely different
IF these are made badly and all of them are terminated with in a few days I will never use you again

If you are not sure what sites they have accounts for pm me and ill send you a picture of all the different sites per module
This prodject is for EVERY module and site in senuke

I am in need a of a custom designed Vbulletin 4.0 Publishers suite template. This will for an news site forum so the design should be related to the field. Vbulletin 4.0 is the newest cms software version out from them so designing a template requires special detail please be sure to research vbulletin 4.0 design specifications as well.I prefer to have the bidders present me with some current vbulletin work they have performed. I am not here to play games or get ripped off.

I am looking for someone with strong IT networking knowledge /background to assist me on the research below.

Scenario

An online seller (selling pirated/copy items) through auction sites.
To avoid ip address being tracked . This is how the network diagram looks like :

Place A – Location which he work from / situated .
Place B – Location of 2 remote PC
2 PC connected to 2 different ADSL broadband connection
All auction listings are listed from Place B through remote connection (logmein.com) from Place A.

He works from PLACE A. He connects to the internet from PLACE A using wireless broadband and uses the remote connection (logmein.com) to connect to PCs
at Place B to list auction items.

Need someone who can advise and assist on the following :

1)Advise on the best possible method to avoid IP ADDRESS on being tracked?

2)AS connecting to PCs at Place B using remote tools such as (logmein.com) , it is very slow.
As he list using different auction accounts , there is a need to disconnect and reconnect the ADSL broadband at PLACE B to change ip address when logging in to
different auction account.
Advise on other possible ways to connect to connect to PCs at Place B.
Is it possible to use VPN??? If yes , assist in setting up of VPN at Place B .

To ensure bidders capability,for those are interested in this research solution and wish to bid, please message me what you think about the above scenario, what
are the weakness / flaw of this PLACE A and PLACE B ip address tracking avoidance technique and propose what you can do to best to advice and implement a
better ip address tracking avoidance technique.