-
Notifications
You must be signed in to change notification settings - Fork 1
/
todo.txt
46 lines (34 loc) · 1.05 KB
/
todo.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
erro 404{
content not found. Sorry...
Were you looking for a specific build? Try the search www...
Or are you trying to check a user profile? Then look at www...
If something went wrong, you can contact me at wwww....
}
Suporte para multiplas imagens por build
mostrar mods usados no template
mostrar mais builds do mesmo autor
mostrar builds com as mesmas tags
tags sugeridas pelos usuarios
------------
remover zips de builds já deletadas
quantidade de cada item{
SELECT item, count(item), sum(quantidade), nome
FROM `itens_nos_templates`
left join itens on itens.id=itens_nos_templates.item
group by item
}
lista de templates com mod, ou atualizar templates pra modded=true{
/*
UPDATE templates
*/
select itens_nos_templates.template, templates.nome, templates.modded
from templates
/**/
inner join itens_nos_templates on itens_nos_templates.template=templates.id
inner join itens on itens.id=itens_nos_templates.item
/*
set templates.modded='true'
*/
WHERE itens.nome not like "stonehearth:%"
group by itens_nos_templates.template
}