Posts

For more information, see the search syntax documentation. Search results are sorted by creation date.

Search Results

Site and Policy » The Event: Aftermath » Post 462

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
join me on my adventure to plot
The top 100 ranked players’ points. Red is Solar Imperialists, and blue is Lunar Revolutionaries. I fitted a curve to it.
points = 50000/rank^0.9
This is a close fit, once again showing 1/f scaling (such as the Zipf’s law).
General statistics:
import matplotlib.pyplot as plt

# data
dates = ['Mar.30', 'Mar.31', 'Apr.1', 'Apr.2', 'Apr.3', 'Apr.4', 'Apr.5', 'Apr.6', 'Apr.7']
images = [677, 615, 4166, 3665, 3284, 3386, 3286, 4777, 6786]
comments = [903, 1229, 10094, 5768, 4482, 4648, 4321, 4402, 4429]
posts = [421, 734, 10386, 6123, 8934, 8426, 7674, 9474, 12038]

# plot
plt.plot(dates, images, label='Images')
plt.plot(dates, comments, label='Comments')
plt.plot(dates, posts, label='Posts')

# add labels and legend
plt.title('General statistics')
plt.xlabel('Date')
plt.ylabel('Number')
plt.legend()

# show plot
plt.show()

data = ['red flux', '42069', 'Solar Empire', 'WatermelonRat', '13415', 'Solar Empire', 'Moon Flower', '10000', 'New Lunar Republic', 'Wing', '8369', 'New Lunar Republic', 'The Smiling Pony', '7802', 'Solar Empire', 'Mr.Myoozik', '7660', 'Solar Empire', 'FliegerFaustToP47', '7636', 'Solar Empire', 'Twiny', '7548', 'Solar Empire', 'LightningBolt', '7523', 'New Lunar Republic', 'AndwhatIseeisme', '7425', 'Solar Empire', 'CORDZ2000', '7254', 'Solar Empire', 'Credus', '6969', 'Solar Empire', 'NLR Acid Flask', '6839', 'New Lunar Republic', 'Modera', '6081', 'New Lunar Republic', 'miky94c', '6010', 'New Lunar Republic', 'Rainboom Dash', '6000', 'New Lunar Republic', 'Orbita', '5704', 'New Lunar Republic', '☬ ᏝᏆᏁᏨᎾᏝᏁᏰᏒᎬᎳᏕᎿᎬᏒᎱᎯᏁ ☬', '5424', 'New Lunar Republic', 'Awkward Segway', '5263', 'New Lunar Republic', 'ZONESS', '4715', 'New Lunar Republic', 'Dark', '4699', 'New Lunar Republic', 'Mellow Rhythm', '4051', 'New Lunar Republic', '🙂', '3370', 'Solar Empire', 'ItsMGH1203', '3350', 'Solar Empire', 'Jbond', '3115', 'New Lunar Republic', 'Grey the First', '3078', 'Solar Empire', 'Brainiac', '3051', 'Solar Empire', 'backgroundpony#F352', '2599', 'New Lunar Republic', 'OtherFritz', '2574', 'New Lunar Republic', 'BlueYoshi', '2528', 'New Lunar Republic', 'flutteryaylove', '2327', 'Solar Empire', 'djpup3', '2318', 'Solar Empire', 'Lunadorable', '2232', 'New Lunar Republic', 'Sollace', '2226', 'New Lunar Republic', 'made_by_Franch', '2222', 'New Lunar Republic', 'Galestorm', '2150', 'New Lunar Republic', 'TwilyIsBestPone', '2100', 'New Lunar Republic', 'icicle wicicle 1517', '2076', 'New Lunar Republic', 'Starless', '2019', 'New Lunar Republic', 'EpicGamer10075', '2006', 'New Lunar Republic', 'Hoofless', '2002', 'New Lunar Republic', 'Saelor', '2000', 'New Lunar Republic', 'Litrojia', '1935', 'Solar Empire', 'The Really Very Wery LAST UNICORN For Real, Bro!', '1878', 'New Lunar Republic', 'Jewellier', '1872', 'Solar Empire', 'ukbdesr', '1754', 'New Lunar Republic', 'Dragonpone', '1744', 'Solar Empire', 'HazyFire', '1636', 'New Lunar Republic', 'Sixes&Sevens', '1551', 'Solar Empire', 'LemonDrop', '1549', 'New Lunar Republic', 'JustForUploading', '1541', 'New Lunar Republic', 'happyb0y95', '1541', 'Solar Empire', 'Toastypk', '1500', 'Solar Empire', 'Lunar Warrior', '1482', 'New Lunar Republic', 'Watermelon Changeling', '1400', 'New Lunar Republic', 'LeoNero', '1337', 'New Lunar Republic', 'ThatOneGib', '1337', 'New Lunar Republic', 'Ghostpikachu', '1337', 'New Lunar Republic', 'Mildgyth', '1337', 'New Lunar Republic', 'Chopsticks', '1301', 'Solar Empire', 'Pizza split', '1300', 'Solar Empire', 'lonewolf', '1282', 'New Lunar Republic', 'Flutterio', '1267', 'New Lunar Republic', 'PonyCor', '1264', 'New Lunar Republic', 'Those Kids In The Corner', '1213', 'New Lunar Republic', 'Rarizzy!', '1200', 'Solar Empire', 'Moonatik', '1195', 'New Lunar Republic', 'WaynePonePone', '1182', 'Solar Empire', 'Rosa Birb', '1162', 'New Lunar Republic', 'Nebbie', '1151', 'New Lunar Republic', 'Dripponi', '1121', 'New Lunar Republic', 'Roserado', '1116', 'New Lunar Republic', 'Wheatley R.H.', '1111', 'New Lunar Republic', 'JP', '1104', 'Solar Empire', 'Jamin-P-Rose', '1063', 'New Lunar Republic', 'MonochromeWallflower', '1045', 'Solar Empire', 'Melisareb', '1042', 'Solar Empire', 'eagc7', '1040', 'Solar Empire', 'GalaxyLatte', '1033', 'New Lunar Republic', 'Republicball', '1000', 'New Lunar Republic', 'malte279', '1000', 'New Lunar Republic', 'PawelS', '1000', 'Solar Empire', 'Jade the bat', '998', 'New Lunar Republic', 'Lil’ Pegasus', '980', 'Solar Empire', 'Sff', '971', 'Solar Empire', 'RealityReaperNSFWC', '954', 'New Lunar Republic', 'Andyxdr', '944', 'Solar Empire', 'Valuable Ashes', '938', 'New Lunar Republic', 'CountDerpy', '911', 'New Lunar Republic', 'zero two', '890', 'Solar Empire', 'Zerowinger', '867', 'Solar Empire', 'ApplejackFan204', '842', 'New Lunar Republic', 'Hopeful_Ink_Hoof', '835', 'New Lunar Republic', 'Korora', '811', 'New Lunar Republic', 'apic86', '790', 'New Lunar Republic', 'Khamzat Chimaev', '780', 'New Lunar Republic', 'Small Brooke', '748', 'New Lunar Republic', 'JinxLynx785', '744', 'New Lunar Republic', 'Shimmering Spectacle', '725', 'New Lunar Republic', 'Elidiotadelaesquina', '723', 'New Lunar Republic']
data = [[data[i], int(data[i+1]), data[i+2]]for i in range(0, len(data), 3)]

import pandas as pd
df = pd.DataFrame(data, columns=['Name', 'Points', 'Faction'])

import numpy as np

fig, ax = plt.subplots(figsize=(16, 10))


colors = {'Solar Empire':'#fb3b02', 'New Lunar Republic':'#938fbc'} # Define colors for each faction
bar_colors = [colors[df['Faction'][i]] for i in range(len(df))]

ax = df.plot(kind='bar', y='Points', legend=None, color=bar_colors, ax=ax, width=0.7)
ax.set_xticks([]) 
ax.set_yscale('log')

# groups = df.groupby('Faction')
# for name, group in groups:
#     ax.bar(group['Name'], group['Points'], color=colors[name], label=name)

xs = np.array(range(1, len(df)+1))
ax.plot(xs, 5e4/xs**0.9)
plt.title('Rank of points')
plt.xlabel('Rank')
plt.ylabel('Points')
plt.show()

Site and Policy » Derpibooru Community Collab 2022 - Badge Award Thread! » Post 126

Site and Policy » Derpibooru Community Collab 2021 - Badge Award Thread! » Post 326

Site and Policy » New Design Announcement - Discussion and Suggestions » Post 520

General Discussion » can somepony send a message to Laith Scure on Instagram » Topic Opener

Tagging Discussion » Request artist tag aliases here » Post 1487

Tagging Discussion » Request artist tag aliases here » Post 1483

Tagging Discussion » Request artist tag aliases here » Post 1482

Site and Policy » Feature suggestions and discussion [READ THE FIRST POST] » Post 5598

Site and Policy » Report site bugs here » Post 8491

Tagging Discussion » Request artist tag aliases here » Post 1266

Tagging Discussion » Request artist tag aliases here » Post 1263

Tagging Discussion » Request artist tag aliases here » Post 1258

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
artist:saipony -> artist:serendipity-kitty  
Both of them are admins of Ask Lesboloo, and also there are some images tagged with both of their tags.

Tagging Discussion » Request artist tag aliases here » Post 1201

Uploader Discussion » Tumblr NSFW Upload thread » Post 780

Uploader Discussion » Tumblr NSFW Upload thread » Post 774

Uploader Discussion » Tumblr NSFW Upload thread » Post 757

Uploader Discussion » Tumblr NSFW Upload thread » Post 744

Uploader Discussion » put your tumblr archives here » Topic Opener

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
bbolli python script  
Format: .tar files.  
Contents: medias and json files  
@aby-askblog  
agentsofheart  
anothertwilightsparkle  
ask-alice-liddell-pony  
askapplegloom  
ask-backy  
askbubblepop  
ask-closed-closets  
ask-depressed-twilight-sparkle  
ask-ink-blot  
askloona  
askmeaniebelle  
askmovieslate  
ask-princess-moe-lestia  
asksandypony  
ask-soda-pop  
ask-thaumaturge-pony  
battleseed  
blood-art-of-kopaleo  
cocoscabin  
drbdnv  
duckydash-blog  
fiddlesticks-answers  
hayshire  
herecomesberrypunch  
higburger  
honey-wound  
howdoponieswork  
justaskberrypunch  
kainesartstash  
loonadventure  
madmaxcomics-blog  
matzzacre  
monochromaticwinds  
overt-investigations  
paulpeopless  
pettankochanv  
smutpaws  
sockypockytrixie  
sweet-cherry-limeade  
theponyclonethatgotaway  
thiklestia  
unteddy  
urbanhoof  
viennasroom@
 
TumblThree  
Format: .tar files.  
Contents: media and html files.  
@aby-askblog  
ask-alice-liddell-pony  
ask-bladework  
ask-louvely  
askmovieslate  
ask-princess-moe-lestia  
ask-thaumaturge-pony  
atane18  
auroraprivatestash  
ayarel-art  
banthaart-nsfw  
blood-art-of-kopaleo  
cheezayballz  
closed-closets-mod  
dlcorner  
doggart  
dunkinponuts  
falluna  
fire-star-pone  
flutterthrash  
goodponygirl  
happyponyshow  
honey-wound  
Index  
lizbiedraw  
notsafeforhoofs  
open-up-your-thighs  
pettankochanv  
quiet-ala  
qweelinsfw  
rainbowscloset  
sfs-animation  
theclonethatgotaway  
thecreamyart  
thelunarmoonnsfw  
thensfwmaj  
theponyclonethatgotaway  
threewontoo  
urbanhoof  
viennasroom@

Uploader Discussion » Tumblr NSFW Upload thread » Post 724

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
@CMC Scootaloo  
Sorry, I left the effort last week after a frenzy of activities. I locked the spreadsheet because I thought it was complete.  
I have unlocked the spreadsheet now.

Uploader Discussion » Tumblr NSFW Upload thread » Post 537

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
@Garden Tinker  
StSyaN  
For that particular blog, I have indeed backed up all the swf files too.  
The way I did it was to grab it with bbolli python script, then parse the html files generated for all external url links to media files (jpg, jpeg, png, bmp, gif, mp3, mp4, swf), then wget these, then parse the html files again and change the external url links to local links.
 
See here
 
This trick should also work if you grabbed json files instead. Just parse the json files for external urls to media files, then compare these media file names to the media files you have already grabbed, then grab (wget or some other way) all the media files still not grabbed.

Uploader Discussion » Tumblr NSFW Upload thread » Post 523

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
@Xaxu-Slyph  
you could also write a shell script that reads in a text file of all the tumblrs you want to grab, line by line, and for each line, run the python script on it.
 
#!/bin/bash
filename=’tumblrs_to_download.txt’
echo Start
while read tumblr_name; do
python tumblr_backup.py –save-video-tumblr –save-audio tumblr_name
done < $filename
 
Note: please update your bbolli python script! 3 days ago it just got updated so that it can grab tumblr videos only. This saves the trouble of downloading ALL videos (including youtube ones) which was a major problem.

Uploader Discussion » Tumblr NSFW Upload thread » Post 507

Uploader Discussion » Tumblr NSFW Upload thread » Post 504

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
@MaresFillies  
@BigBuggyBastage  
Some problems I’ve encountered include the pictures not fully downloaded (like the png only contains the upper half), and when using bbolli’s python script, getting some images not downloaded at all (a workaround I detailed in the other post but basically I used shell to grab all external media urls in the generated html files and use wget on all of them, and manually examine the output to make sure it “makes sense” (really hard to automate that, there were many wtf moments), then after feeling satisfied that all those media files that still exists online are downloaded, run another script to change the external http urls to local urls).
 
Maybe the reason I’m getting these weird errors is just my internet connection is bad. I’m using a VPN and it sometimes gives up after I download through it too heavily.

Uploader Discussion » Tumblr NSFW Upload thread » Post 489

furrypony
Cosmia Nebula  - For Patreon supporters
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Elements of Harmony - Had an OC in the 2022 Community Collab
Twinkling Balloon - Took part in the 2021 community collab.
My Little Pony - 1992 Edition
Happy Derpy! - For Patreon supporters
Bronze Supporter - Bronze Patron
Friendship, Art, and Magic (2018) - Celebrated Derpibooru's six year anniversary with friends.
Not a Llama - Happy April Fools Day!
An Artist Who Rocks - 100+ images under their artist tag

hopelessly sad filly
@MaresFillies  
I encountered the same problem. I think it’s because tumblthree sometimes does not download all pictures, and sometimes estimates the total number of pictures wrong. For public tumblrs, it usually downloads more than estimated.

Default search

If you do not specify a field to search over, the search engine will search for posts with a body that is similar to the query's word stems. For example, posts containing the words winged humanization, wings, and spread wings would all be found by a search for wing, but sewing would not be.

Allowed fields

Field SelectorTypeDescriptionExample
authorLiteralMatches the author of this post. Anonymous authors will never match this term.author:Joey
bodyFull TextMatches the body of this post. This is the default field.body:test
created_atDate/Time RangeMatches the creation time of this post.created_at:2015
idNumeric RangeMatches the numeric surrogate key for this post.id:1000000
myMetamy:posts matches posts you have posted if you are signed in. my:posts
subjectFull TextMatches the title of the topic.subject:time wasting thread
topic_idLiteralMatches the numeric surrogate key for the topic this post belongs to.topic_id:7000
topic_positionNumeric RangeMatches the offset from the beginning of the topic of this post. Positions begin at 0.topic_position:0
updated_atDate/Time RangeMatches the creation or last edit time of this post.updated_at.gte:2 weeks ago
user_idLiteralMatches posts with the specified user_id. Anonymous users will never match this term.user_id:211190
forumLiteralMatches the short name for the forum this post belongs to.forum:meta