Deleting games

[Dillon]

Well im deleting alot of games off my site that i dont want. and i was wondering if when i delete the game off the site does it also delete the file from my host or do i have to do that myself?

[Adam LaCombe]

From what I see it does not.
I should put that in the next version though.

If you want, gimme like mmm half hour at most and I will post the code you need to edit and add.

[Adam LaCombe]

This code is not tested, but it looks perfectly fine to me.

ftp or ssh your way into /pages/admin/
and edit the file: managegames.php

Find the function: delete
and replace it with this:

Code: [Select]

function delete(){
global $directorypath, $gamesfolder;
$ID = abs((int) $_GET['ID']);

$query = mysql_query("SELECT `file` FROM `dd_games` WHERE `ID`='$ID'");
$row = mysql_fetch_array($query);

if($row['type'] == "1"){
unlink("$directorypath/$gamesfolder/".$row['file']."");
}

mysql_query(sprintf('DELETE FROM dd_games WHERE ID=\'%u\'', $ID));
echo '<div class=\'msg\'>Game Deleted.
<br />
<A href="#" onclick="history.go(-1)">Back</a></div>';
}

just gotta make sure you have your permissions set to allow this to work. Don't anyone yell at me lol
I say set everything to 777
others don't like to.. they say its a security issue and blah blah blah 
If you're afraid of all that just set the games directory to 777 and leave everything else to your settings, thats fine.

EDIT: Before editing anything, back it up.
EDIT2: Fixed a mistake in the code

[Adam LaCombe]

Missed the if($row['type'] == 1) lol sorry about that. its fixed now though so go ahead and use that code I posted above

[Dillon]

Thanks for the help!

[Adam LaCombe]

Not a problem :-)

[Frank]

Nice one Adam - Can't wait for the Beta2 to see what else you have created or added.

[Adam LaCombe]

Yeah we need to get that thing finished like now lol its long over due.
But I am glad we haven't released it just yet because I got some other ideas to add in.
I think I am gunna re-do the language files a little different also. Its such a pain but I suppose it needs to be done lol

[Frank]

Sorry Adam - I can't get your script to work?

Try this by replacing the whole of the delete function.

Code: [Select]

function delete(){
global $domain, $db, $gamesfolder, $thumbsfolder, $template, $directorypath;

$ID = abs((int) $_GET['ID']);
$query = mysql_query("select * FROM `dd_games` WHERE `ID`='$ID'");
$row = mysql_fetch_array($query);

if($row["type"] == "1")
{

$file = $row["file"];

$myFile = "$domain/$directorypath/$gamesfolder/$file";
unlink($myFile);
}

if($row["type"] == "1")
{

$thumb = $row["thumb"];

$myThumb = "$domain/$directorypath/$thumbsfolder/$thumb";
unlink($myThumb);
}

mysql_query(sprintf('DELETE FROM dd_games WHERE ID=\'%u\'', $ID));

echo '
<div class=\'msg\'>Game Deleted <a href="javascript:void(0)" onclick="history.go(-1)"> Go Back</a></div>

';
}



Edit: Shortened up the script and renamed a VAR.
Edit 2: Replaced ./../ with $domain because of seo problems.

[Adam LaCombe]

Oh yeah I forgot about the thumbnail.
Dunno why you used: ./../ ?
Your directory path var is all you need I would think.
What did you set for the directory path?

Internet is being shut off I guess for me. Not enough money to pay for it so I will be gone again. Hopefully not for too long.

[Frank]

Oh yeah I forgot about the thumbnail.
Dunno why you used: ./../ ?
Your directory path var is all you need I would think.
What did you set for the directory path?

Internet is being shut off I guess for me. Not enough money to pay for it so I will be gone again. Hopefully not for too long.

I used ./../ because the process is being called from two levels down and one has to get back to the root. Real path -> http:// ($domain) is not allowed.

My dir path is "/arcade" because I re-wrote every file to include all the missing global db strings, and fixed up all the missing/wrong path variables so that the programme is not forced to  be in the root only.

As for delete not working - This is more likely the problem.

unlink("$directorypath/$gamesfolder/".$row['file']."");

Hopefully not for too long.

You probably have plenty to do to FAS as it is. And while we have XAMPP etc - I doubt that you will just be doing nothing.

[Adam LaCombe]

Your dir path should look something like: /var/www/arcade.com/htdocs

You start from the root of the server and go into the www directory to where the fas script is installed.

You probably have plenty to do to FAS as it is. And while we have XAMPP etc - I doubt that you will just be doing nothing.

We who? lol I don't use XAMPP.. and I mean gone like from the internet for week or more. Any min now Comcast is gunna shut off the phone tv and internet

[Dillon]

Ok well i couldnt get either of yours to work without sql errors and i just now finally got around to making it delete and give no errors. Heres the code.

Code: [Select]

function delete(){
global $domain, $db, $gamesfolder, $thumbsfolder, $template, $directorypath;

$ID = abs((int) $_GET['ID']);
$query = mysql_query("select * FROM `dd_games` WHERE `ID`='$ID'");
$row = mysql_fetch_array($query);

if($row["type"] == "1")
{

$file = $row["file"];

$myFile = "$directorypath/$gamesfolder/$file";
unlink($myFile);
}

if($row["type"] == "1")
{

$thumb = $row["thumb"];

$myThumb = "$directorypath/$thumbsfolder/$thumb";
unlink($myThumb);
}

mysql_query(sprintf('DELETE FROM dd_games WHERE ID=\'%u\'', $ID));

echo '
<div class=\'msg\'>Game Deleted <a href="javascript:void(0)" onclick="history.go(-1)"> Go Back</a></div>

';
}




[Frank]

I think that this was the real problem?

Edit 2: Replaced ./../ with $domain because of seo problems.

Thanks for fixing it up, because I found other path problems when testing seo and had to replace all of the Unix paths I had created.