>>70990
>Pico's shirt.jpg

hi

For an updated suggestion:
Remove the functionality that automatically deletes images and thumbs from the /src/ and /thumb/ folders when their posts are deleted (I've tested this and it's pretty much the only thing on this list I can implement myself)

Then:

-Find sets of rows in the posts table that have non-zero parentid fields and matching file_md5 and boardid fields
-Choose one of the posts to keep the attached file of, it doesn't really matter which
-Look at the the file, file_type and boardid fields of the posts you didn't choose, and use those fields to write to a list of files that need to be deleted by their paths (and the paths of their thumbnails)
-Change all the file fields of all the posts you didn't choose the the same value as the one you did

Then:

-Delete the files on the list
-Run a script that sages every thread and then deletes every post, in order to rebuild them all. Or make a better way to rebuild the html files in smaller batches so it actually works

Later:
-Change posting functionality so that if a new post's file_md5 matches another file_md5 from the posts table, and the parentid fields are either both non-zero or both zero, the newly uploaded file is deleted and the file field is copied over to the new post from the old one
-Change posting functionality so that *c.* thumbs are only created for posts that have a parentid of zero
-Add some way to query for files that are no longer listed in any post's file field, and delete them

If anyone has some suggestions or sees problems with this process please point them out. This is all just in theory, though.

Edited:
Functionality should be changed so that when threads are moved from boards to boards, they do not delete the original files in the original board's src and thumb folders. This will probably be easy.

>>70994
wat

http://www.livestream.com/fortknox

mh3u

So many bullets

>>71000
hi

>>71001
Yo. I managed to purge all the catalog thumbnails, so that's a start.

>>71002
So you are working in this? Oh well, tell me if I can help you.

>>71003
I'm trying to, anyway. Right now I'm trying to figure out how to stop catalog thumbnails from being generated in non-OP posts. Or at least trying to find a way to delete them automatically just after they are.

>>71004
From what I'm reading that should be managed in the Upload class, let me see what needs to be commented.

>>71005
Yoroshiku.

>>71006
Try this, on the next code:

if (!$this->isreply) {

if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_THUMBWIDTH, KU_THUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}

} else {

if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_REPLYTHUMBWIDTH, KU_REPLYTHUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}

}

Comment the first if inside of the if brackets, in other words, replace it for:

if (!$this->isreply) {

/*if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_THUMBWIDTH, KU_THUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}*/

} else {

if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_REPLYTHUMBWIDTH, KU_REPLYTHUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}

}

No wait, it's the opposite, change it for this:


if (!$this->isreply) {

if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_THUMBWIDTH, KU_THUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}

} /*else {

if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_REPLYTHUMBWIDTH, KU_REPLYTHUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}

}*/

>>71008
Warning: md5_file(): Filename cannot be empty in C:\dev\www\board\inc\classes\posting.class.php on line 162

Did you leave the first if normal and only commented this?

/*else {

if (!createThumbnail($this->file_location.".tmp", $this->file_thumb_location, KU_REPLYTHUMBWIDTH, KU_REPLYTHUMBHEIGHT)) {

exitWithErrorPage(_gettext('Could not create thumbnail.'));

}

}*/

>>71010
I must have done something wrong, since now it's not giving that error.

But either way, it doesn't get rid of the catalog thumbnails on replies.

>>71011
Did it do anything at all?

>>71012
If it did do anything, I don't really know what.

It looks like file_thumb_cat_location is the variable that stores the full path of the catalog thumb and then that is called to actually make the file later.

It's done.

I changed it from this:
if (!createThumbnail($this->file_location, $this->file_thumb_location, $this->imgWidth, $this->imgHeight)) {
exitWithErrorPage(_gettext('Could not create thumbnail.'));
}
}

if (!createThumbnail($this->file_location, $this->file_thumb_cat_location, KU_CATTHUMBWIDTH, KU_CATTHUMBHEIGHT)) {
exitWithErrorPage(_gettext('Could not create thumbnail.'));
}
$imageDim_thumb = getimagesize($this->file_thumb_location);
$this->imgWidth_thumb = $imageDim_thumb[0];
$this->imgHeight_thumb = $imageDim_thumb[1];
$imageused = true;
}


To this:
if (!$this->isreply){
if (!createThumbnail($this->file_location, $this->file_thumb_cat_location, KU_CATTHUMBWIDTH, KU_CATTHUMBHEIGHT)) {
exitWithErrorPage(_gettext('Could not create thumbnail.'));
}
$imageDim_thumb = getimagesize($this->file_thumb_location);
$this->imgWidth_thumb = $imageDim_thumb[0];
$this->imgHeight_thumb = $imageDim_thumb[1];
$imageused = true;
}

else {
$imageDim_thumb = getimagesize($this->file_thumb_location);
$this->imgWidth_thumb = $imageDim_thumb[0];
$this->imgHeight_thumb = $imageDim_thumb[1];
$imageused = true;
}}

>>71014
Oh, good job. I'm a little tired so I didn't even bother too read too much into the code...

>>71015
Can't be helped.

Now I just need to back all the catalogs up, purge the c thumbs again, then reupload.

I'll do it for all the boards the this time.




Oops. I broke it.

hi

>>71017

>>71018
lol i wonder what went wrong

http://www.livestream.com/sonozakidungeon

>>71019
Test?

Looks like the one from my board works but it's still making the catalog thumbnails now.

What a conundrum.

Oh, that's because I was copying the copy.

It works now.

A bit lower quality but still better than the GBA version~

>>71025
And here's the ending theme~

>>70996

How do I twitch, might wanna try streaming dota 2 and tera

>>71025

>kill diablos
>get 6 horns in rewards

>>71030
You're supposed to do it on infernal difficulty. Which I did. I beat the stupid out of him.

hi piece did u change more code

>>71028
Twich more like bich

>>71030

>>71034

WHITE WHALE
HOLY GRAIL

>>71035

>>71029
>length: 6:06
Nope.

So I 1cc'ed Gundemonium Recollection. Why didn't I unlock anything new?

>>71026
I download it, but the site says it doesn't support the file type

I sing this song every time I hear that theme

>duplicate file error

I don't care who made this mistake, but
SOMONE
FUCKING
FIX IT
NOW!

>>71040
My guess would be that Piece applied the "fixes" to catalog thumbnails to the file on his own private server and uploaded that file to replace the one we had, but naturally his file didn't have the changes that ours had that allowed the posting of duplicate images. I think the file is posting.php? Of course I can't access any of that stuff.

theres a lime that needs to be commented, I will fix that later, sorry im a little busy

>>71042

>>71042
>>71043

>>71043
>>71044
>line*

ok that should do it

>>71046
Good.

hi

>>71041
>fixes in quotation marks
But yes, that's exactly what happened.


Originally I just changed a few lines of the upload.php, but that stopped working entirely. Then I replaced it with my own, which worked, but didn't have that. Likely, when I changed the lines the first time I must have deleted or added one bracket too many, otherwise both would have been working simultaneously. They are right now though, thanks to anon.

>>71049
Well, it's not really a "fix", more of a band-aid right~? I remember you saying that it wasn't going to put us under the limit on its own anyway.

>>71050
Well to the catalog thumbnail problem it is a fix, but to the overall problem of having too many files it isn't.

What did was delete around 1/3 of the images from the server and prevent around 1/3 of them from being created, but even if every file was an image, that wouldn't solve the problem of us having double the allowed files.

>>71050

lood

I just realized Chupon/Tyhpon has two faces. Never noticed the second one before~

>>71052
y would u even use dat thing its so ugry omg

>>71020
Might stream something like Starcraft 2 campaign if people are interested~!

>>71054

Through a combination of it and the dpad I can reach almost claw-level camera control!!

>>71056

yass

Outsmarting bullet hard.

>>71051
That's actually rather good, now if only we could do something smart about the repeated files...

>>71060
I'm going to try changing it so newly uploading duplicated files just reference old ones first.

>>71061
Maybe if you could help me to set the board locally I could work more easily on this.

>If repeated file, then don't upload, take the already uploaded picture url and place it into the new post. Server space is reduced dramatically and so posting time.

btw, to all SMT fans:

Should I play Devil Survivor 1 first, or should I play the second one right away?

>>71062
How can the server check the md5 of a file it doesn't have?

Anyway, the md5 is already checked at upload time, and it's compared to the ones already in the database in the part commented out to allow for duplicate files.

Also, we better not change any of the server files until we have the full fix, like the part about unlinking attachment deletion with post deletion.

Try using this guide: http://www.1stwebdesigner.com/tutorials/how-to-setup-local-web-server-with-latest-apache-php-and-mysql-packages/

>>71064
Oh welp, it would be the same.
Anyway, I think my problem was setting kusabax database, I don't remember finding how to export it.

>>71065
What do you mean exactly? You already have a database and a web server working, just not kusabax?

Did you follow the guide here?
http://kusabax.cultnet.net/wiki/installation_guide

>>71063

1 tabun

wat since when did lances have a counter attack how is it even possible to die with this

>>71068
derp

Dota 2 later?

>>71070

ya

I've gotten my local board to reference the old filename of a file instead of creating a new one if a duplicate is uploaded.

大勝利

>>71072
>>71073

>>71074
On my server, not here yet.

>>71075
Oh, my bad.

>>71072
Did you made it delete the new picture?

>>71077
When the new file is uploaded, it's given the name of the old file. So at the end of the process, only one file exists.

Also, I just got done making it so that on my local board, when a post is deleted, instead of deleting the attached image automatically, it checks the posts table to make sure only one post is using the image. If only one post is using it (the post being deleted), then it deletes the image along with the thumbnails. If it isn't, then the image isn't deleted, just the post. This still works if the "file only" checkbox is ticked, it will just remove the post in question's link to the file if it's not the only one using it.

With that, I should have all the functionality we need ready to go live. Now the only problem left is actually getting rid of the duplicate files that have already been created.

Also, the new functionality only treats files as duplicates if they are on the same board and they are the same type of post, type being either OP or reply.

This is because OP and reply posts create different size thumbnails so copying OP posts which have duplicate images that are attached to replies will cause resizing issues. It's also so we don't get cross-board links. And because it's a lot more difficult to do otherwise for what's likely a small payoff.

Now I've made it so the same delete functionality works on moving threads. If a thread is moved along with its images, each post's images will be checked to see if there's another post using it. If there is, the images won't be moved, they will just be copied. Otherwise, they will be moved as usual. This is all still on my local board. It can't really implemented here until the already existing duplicate files are fixed, otherwise I think there are problems that can occur.

I can't think of any more problems with the functionality right now, and I'm too tired. Good night.

>>71078
>>71079
>>71080
That's pretty impressive, get some rest man.

gud morning

>>71082
Gud evening.

I guess I could stream some boollet outsmarting craziness later on.

>>71057
If anyone's here and no one else is streaming I'll stream more SC2 campaign~

http://www.livestream.com/rothspad
imma go out guns blazing

F/E CCC better get localized!

hi

I'll try to stream again, glory for the swarm if people actually show up~
>>71090

>>71091
>>71088
lewd seiba is lewd

well, starting on monday I will start taking sign up for the Digimon RPG, why not now? Well, I am not on the city right now~

>>71094

>>71095

>>71093
I'll probably only sign up if two other people do so, since I don't want to waste my time doing all the work if no one else will play.

game of thrones more like everyone is incest

hi

>>71099
Hi. I just finished mien final solution.

I've got one function that backs up the posts table, one that goes through the table and sets all the file fields of the rows with duplicate file md5 values to the same value, and a final one that goes through the image folders of a board and checks the names against the database then deletes them if they aren't being used.

I've tested them all on my local board but I better test them on a new board here first.

>>71100
>I thought for a second you were George
Wow, and you did it all by yourself? Would you mind if I give a look to the code?

>>71101
Of course, I had the internet's help as well. There's no question it can't answer.

Send me a message and I can show you the code if you want.

>>71102
The internet is basically the right hand of any programmer, so it still counts all for you.

>>71104
dw the board's still up

I should volunteer at an animal shelter.

omg gs so much fun idk if i want to switch to hammer and just bap monsters

>>71107

hammer cant even cut off tail gs superior

>>71108
how to cut off tail with lance huh???

>>71109

mostly you poke at it!!

>not using superior switch-axe to axe these niggas a question

BRISTLEBACK

No dessert for you.

>>71113
Nice try, but I already had dessert.

do you guys evefn wiiu multiplayer

>>71114

>>71092
How dare you call my empress lewd!

>>71117
kanonheh.png

>>71118
?!

nero > artoria

Is anyone here?! Let's see!
>>71121

>>71112
i remember when he was called rigwarl :p

bristleback more like keep noob alive

is this fully working now

The board's gonna get nuked, run for your lives.

Keikaku doori! Keikaku doori! Keikaku doori!

wow, did this really work?

>>71142
gratz

>>71143
I did nothing.

Another /seacats/ dream. Get out of my head Charles.

>>71148

>>71150
If there's anyone around I'll stream some glory for the swarm~

>>71151
Better than me streaming Gandammu.

the new jojo art book is 20000 yen wadafak

hi

>>71156
is it holographic

gudmorn

>>71159

>>71159
lewd

>>71161
u r

Nasu what are you even doing

>>71163
I don't get it. What's going on?

>>71164
If you can't figure out by looking I don't think explaining will help matters~!

>>71163

>>71163
Maybe I'll play Gil instead of Caster.

>>71167
From what I've heard you need to play the game at least twice to get the True End, and Gil isn't recommended for the first run~

>>71168
B-But it's so shiny!

>>71168
Made any progress on that crusader class I asked about?

>>71170
I had forgotten all about that~ I'd have to think about it some more, and not tonight my head hurts.

>>71153

>>71169
Always the pervert, huh?

>>71171
Fair enough.

>too cute : fluffiest kittens special
Help, the TV is trying to kill me.

>>71173
It can't be helped. :3c

>>71176

hiyooh.xcf

hi

>>71178
>>71179

Happy Easter

>>71181

>>71181
Happy Easter~!

Happy Easter to everyone and happy birthday to Cirno!

Happy Easter.

>>71184

>>71183
~

>>71184
It's Cirno's birthday too, huh? Well, happy birthday then, Cirno.

>>71184
Cirno's birthday? Then happy birthday~!

>>71187
~

>>71186

Happy birthday Cirno.

>>71189

happy easter

Happy Birthday!

>>71193
You're beautiful. :>

Happy Easter!

I rabu meta~

>>71195
mfw Kinjo posing as Gogo to seduce meta lol.

Feliz cumpleaños.

Fuck. I was aiming for table 7 and got table 8. Baka Monhun.

>>71198
I mean 6 and got 8. Still sucks.

>>71198
>be SA user
>find out about charm tables
>get scared as I check my table
>table 14, the best for SA users
>my face

>not playing master race hunting horn

>>71200
I guess it doesn't matter THAT much since I'm playing on 3DS and can't netplay but if I get a WiiU I'll go for perfect tables. Still a tad annoying though, oh well.

Episode 5 and then some
>>71203

So it's officially that day today, huh?

>>71205
And it started early this year

>>71206
http://thenextweb.com/google/2013/03/31/round-up-all-of-googles-jokes-for-april-fools-2013-from-google-maps-treasure-hunting-to-youtube-closing/

Happy late Easter and happy belated birthdays to those who have had them recently, or I wasn't around that day so I didn't notice. Happy April Fools, and happy birthday to those who are having them this week.

>>71209
New tea party~