[BETA] Scammer List

[caspert_ghost]

MOD Title: Scammer List
MOD Description: A way to maintain a list of trade scammers on your trade web site
MOD Version: this Mod is in Development stages

MOD Download: Scammer.zip
Last Stable version:version 0.1.0 Now in Beta release for bug, error, and security testing
Demo Board: http://www.mtgotraders.com//phpBB2/scam.php
Demo Username: N/A
Demo Password: N/A

This Mod is a mod specifically for online MTGO trading sites (can be used in conjunction with clans mods and items or online shops)
What it does is alows your members to post a trade scam with that users name (user name is the user name on MTGO)
I am placing it here in hopes to get some help on a few items I need to code yet.

{edited Feb 5} changed version to 0.0.2 as now the table list is working 50%
{edited Feb 6} I have now updated the zip file, the list is working and in order. Working now on the delete function 50% I have the code to delete but it deletes last post first even though I am clicking the delete on the table for that lited take a look and see if you can see something I cannot.
{edited Feb 6} uploaded new files with some new features, got the delete to work BUT it is only deleteing the most eldest post rather than the one I choose any ideas?
{edited Feb 7} updated files and changed status to ALPHA
{edited Feb 9} updated files, added paypal name and ebay name to list
{edited Feb 10} This update added the ability to upload files to the server I am still working on the size limit issue as it is stuck at 2k and I am also going to work on getting a link from the db when we output the list.
{edited Feb 11} version change 0.1.0 First Beta release for bug and security testing This update completed the ability to upload files to the server with a link from the db when we output the list.

[caspert_ghost]

Hello, anyone have a chance to look at this yet?
I am real intrested in your feedback on this mod as well as help me with getting the list to actually show up in on the page.
Thanks

[Prizem]

Unfortunately your script is pretty messy, making it more difficult to read.

In your db update, `description` mediumtext NOT NULL should be `scam_description` mediumtext NOT NULL

By not displaying the user, do you mean the reporter? If so, in your script, you have 'REPORTER_NAME' => $row['scam_reporter'], while in your template you have {scammers.SCAM_REPORTER}

[caspert_ghost]

Thank you, yes I see that now (the db was the first thing I did and changed its name mid stream and forgot to update the db updater)

I know it is messy (its in development ) thats why it is here hoping to get help in cleaning it up.

if you have it installed on your test board:

when you go to scam.php you should see a list page with an add button at the bottom.
As it is you can add to the db but the results are not showing up.

after clicking on the "add" you will go to the addnew part of the php and scam_add_body.tpl

this has:
the posters user name (must be a member of the boards)
scammers mtgo user name
posters mtgo user name (these 2 names are NOT members so it is a text input) on the out put "list" page I actually want both poster mtgo name AND poster user_id to appear in the "poster" row.
I also want to add upload ability of 3 screen shots of the scam taken place.

this is where I am having trouble (and it is messy).

in your pm you asked about the sql user_id... this will auto appear in the add new area.
Thank you and I will fix the db_updater now and re upload it.


ps... scammer.scam_reporter..... scammer is the "scammer" part of the php.. there are 2 parts to the list:
1: no scammers (if no scammers it will simply say "no scammers"
2: list of scammers (if there are scammers in the db they should appear and the above should go away)


pss:
I have added 3 screen shots for you to look at.
1: The List page:

2:Add new page:

3:sucessfully added confirmation

[Prizem]

scammer.scam_reporter..... scammer is the "scammer" part of the php

yes, I was mentioning that the key in your script, REPORTER_NAME, doesnt match what's in the template, SCAM_REPOTER, so that the reporter name will never be shown unless you change that.

Also, viewing the list was fixed in the link I gave in pm

[caspert_ghost]

heh, one thing at a time .
As of now neither name is showing up so changing thge code to accomodate both is pointless if I cant get the other to work yet.
I am still working on it however.
Yes I want both name top show on the list under poster:
user_id (reporter_name)
scam_reporter(reporter_mtgo)

[caspert_ghost]

Changed version to 0.0.2 today.
I am happy to report that I now have the list working at 50%

it shows the scammer, date (sorta), and description text.
I am still working on it showing the 2 names for the reporter (user_id and scam_reporter) ((2 different names 1 is the phpbb user_id, the other is the mtgo user name)



As you can see this is what I am working on now.

{edited Feb 6}

I got both names to work now
Working on the delete function. I want this to ONLY show for the admin and I want to be able to delete ONLY that scammer at which the delete tab is located.
As it is now it is not woirking correctly.
Thank you all for the support and help thus far.

[caspert_ghost]

updated the files today.
still working on the delete function and coding the upload function too.

take a look, any ideas?

[caspert_ghost]

This has made it to Alpha as it is a working mod that only needs a few tweaks now:

Database to store the list ==>100%
list ==> 100%
Add user ==>75% (still need the upload ability)
Delete single row ==> 50% (until upload ability this works)

[DiSpy]

I just wanted to say that i'm watching this topic closely... keep up the good work, this would be a great addition to the trading section of my site!!

-DiSpy

[martijn2]

I'm playing with a similar idea like this, but then for scam sites, and this mod could be adjusted for that purpose, I think this is a great mod! Keep up the good work!

[caspert_ghost]

updated files today.
Fixed the error in the tables (changed description to scam_description)

added sa\cammers paypal name and scammers ebay name to list also.

still working on upload functionality.

would like to ask which is prefered:
upload to server or upload into database?

thank you.

[martijn2]

I'd preffer upload to server, but you could offer a option to upload it to a database though...

[caspert_ghost]

Im finding it very difficult to upload to server and at the same time have a link within the scammer name row to show the screen shot for that user... if I upload to the database it is part of THAT row so the link is fairly simple...

I have found a few ways to do this, I am working the bugs out to get size limits, gif/jpg only, etc.

[caspert_ghost]

Made some excelent changes today.
Added the ability to upload a file from the form.
Stuck at 2k for the time being but still working at it.
I am also looking for a way to add a link to the image on the row that was posted (if anyone has any ideas about this please let me know.

An empty list


What the list now looks like


The new add a scammer form


successfuly added image


thank you and as always I am still working on this.