Get a Freelance Job

I need someone to change code…first autobid it random

but i want asc by create date

assume a to z

function butler($form,$to) //ฟังชั่น Auto Bid
{

$r=rand($form,$to);
$bittype = “bidbutler”;

ReturnButler();

$res=mysql_query(“SELECT distinct(b.uid),b.id,b.min_price, t.pid,SUM(b.no_bids) AS no_bids
FROM product t INNER JOIN butler b ON b.pid = t.pid AND t.bider_id <> b.uid
WHERE max_price > bid_price AND min_price <= bid_price
AND TIME_TO_SEC( TIMEDIFF( end_time,NOW() ) ) <= $r and end_time > NOW() and no_bids > 0
group by b.min_price,b.uid,b.pid order by t.pid,rand()”);

I need help understanding how to link variables to multiple landing pages for my Clickbank product.

I have created several different landing pages for my Clickbank product, and now would like to assign a variable to the end of a Clickbank hoplink so it redirects to each of my landing pages.

For a concrete example of what I’m talking about, look at this page: http://www.truthaboutabs.com/affiliate-alternate-landing-pages.html

On that page, they say this:

“Optional pages you can choose:

1. Truth About Abs Order page: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=139

2. Truth About Abs Testimonials page: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=33

3. Truth About Abs FAQ page: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=136

4. Mens Lean Abs sales letter: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=249

5. Womens Flat Stomach sales letter: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=251

6. Free Fat Loss Bonus page: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=30

7. Truth about Abs Trial Offer page: http://YourCBid.mikegeary1.hop.clickbank.net/?pid=157″

I would like to know how to set up my landing pages so they are linked to my Clickbank hoplink via a pid.

We have two excel sheets with data:
1. holds data of current dbase, with this setup:
pID,EAN,name,image

2. holds this data
EAN,name,image-url

What we need is this output:
pID, EAN, name, image
in this format:
pID, EAN, name, /pID.jpg

Extra information:
- Fields to match are the EAN’s.
- images must be stored into a (given) folder.
- if the image field is not empty for current record, skip it as we clearly have the image already.

We can use two separate csv files for this too, either way is fine and shouldn’t take too long.

MUST be done within 1 day, as it should be easy for a good programmer.

If you can automate it so we can use it again and again, that sure has prio over manually do this once for the current files.

What you use for programming is fine either way, desktop app or webserver (php) script.

I am looking for a programmer familiar with the MyBB forum script to make a minor modification to the reputation system.

I want to associate reputations with the pid instead of using the rid, as the script does now. The pid is in the posts table, while the rid is generated sequentially by the script and posted to the reputation table.

This should be a quick and easy modification. I have made several other mods to the script, but I’m not an experienced programmer and this ones a little beyond my capabilities.

I am including an attached copy of the php file that needs to be modified, as well two admin template files that may need to be modified.

I have already created a pid column in the reputation table of the database, and manually inserted a pid value, then successfully echoed it into the reputation details page, which is called from the reputation template, but will need to be changed to echo back the subject field in the posts table.

I have a simple problem. I need a php/mysql page done.

What we are working on: A file called send_messages.php that checks “prights” for that user and checks to see if they have rights to send messages. If they do it checks to see how many messages they have sent per month / per day. Problem is that my default member rights are not added to a table called “prights”. I need a workaround.

Here is my problem. I have a table called “prights” that has all the user rights. I had a programmer do a script that looks in the table for a specific rights. Problem happened that default rights are not added to the prights table, only if I modify the rights. So when my script looks at prights, the user does not have the right that they need (even though it is default).

My thinking is adding it to my send_message.php file since that is where the script looks at those values. You can either change the script to do a default value of 4 (messages per day and messages per month). But if i change the value to 10 for that user, it would have to see 10 messages max. Problem with doing a default of 4, people that are not registered should not be allowed to send a message.

If you choose we could do a cron file that changes the table. How we do it is up to you, the programmer. All I know is I need it done. Not a hard project, but I tried explaining everything here.

I have added send_message.php to the download file on this project for you to take a look.

Let me try to explain it.

Table “members” has member ID – Each user
Table prights has “PID” which equals “ID”

Under “prights” table
ID = PID
If RID = “53″ exists do nothing

If RID = 53 does exist, adds following lines (example PID=100). PID is the constant. RID 3 & 4 are also constants.

PID=100
RID=53 (53 = per day)
Value=4 (Able to send 4 messages per day

PID=100
RID=54 (54 = messages per month)
VALUE=4 (Able to send 4 messages per month)

Other problem might be that the script looks at the table right off the bat and if they don’t have the correct rights, it tells them they don’t. So you will have to make a modification to the script that changes it before it tells them that they have sent too many messages.

Bonus: If you add to the page where it tells them how many messages they have sent in last 30 days and how many they have left, I will add a bonus.