Find Jobs
Hire Freelancers

Need PHP SQL Code Snippet / Patch for website.

$10-30 USD

完了済み
投稿日: 約8年前

$10-30 USD

完了時にお支払い
I have a PHP script running with mysql 4.5. I need to fix a small security hole. The PHP program handles file uploads from users. A user signs up and is assigned a primary ID number in the database. Users upload files through a CMS to the site administrator. Each time a user send a file, the file and its details are saved in a separate database table. For clarity, user details are saved to one table, and the files they upload are saved, along with notes etc, to another table. A user can log into their user control panel and view a page that lists the details about the users upload. Here's the problem. When a user is logged in and clicks the details of their own uploaded file via the user control panel provided in the PHP script, the URL in the address bar reveals the ID number of the file uploaded. That's OK. But, if the user changes the ID number in the browser (add a number to it or take away a number), they will then view files uploaded by other users. This is undesirable. Currently the CMS simply checks to be certain users are logged in with a valid account but doesn't check to see which files the user is allowed to view. The table that the file details are saved to contains the unique file ID and the user ID. I want the system to check to be sure the user viewing a file is the one that the file belongs to. If not, it should give them an error.
プロジェクト ID: 10393521

プロジェクトについて

3個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hello, If you provide me ftp or cpanel details, I can fix this problem immediately. Basicly, I'll modify sql query. It should read: file_id=X AND user_id=Y.. I think it's file_id=X now and causing problem. I'm online now. Thank you v much.
$25 USD 1日以内
4.9 (393 レビュー)
7.7
7.7
この仕事に3人のフリーランサーが、平均$36 USDで入札しています
ユーザーアバター
Dear sir I understand your requirement please message me to discuss further
$30 USD 0日以内
4.9 (16 レビュー)
4.7
4.7

クライアントについて

UNITED STATESのフラグ
Mishawaka, United States
5.0
94
お支払い方法確認済み
メンバー登録日:10月 1, 2006

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。