[DiscordArchive] If it works it works, right?
[DiscordArchive] If it works it works, right?
Original source
If it works it works, right?
rektbyfaith
08-12-2023, 08:35 AM #1Archived author: ReynoldsCahoon • Posted: 2023-08-12T08:35:47.790000+00:00
Original source
If it works it works, right?
Original source
How many queries are you running to get all that data in the server info article?
rektbyfaith
08-12-2023, 08:36 AM #2Archived author: ReynoldsCahoon • Posted: 2023-08-12T08:36:21.995000+00:00
Original source
How many queries are you running to get all that data in the server info article?
Original source
true <a:FeelsFactsMan:739287341063077979> its like tricking the client and getting it to load a php script, if it works then it works <:TopKek:594160319862145034>
rektbyfaith
08-12-2023, 08:37 AM #3Archived author: MobCat • Posted: 2023-08-12T08:37:15.080000+00:00
Original source
true <a:FeelsFactsMan:739287341063077979> its like tricking the client and getting it to load a php script, if it works then it works <:TopKek:594160319862145034>
Original source
and 4. probs could be better but its okie
```sql
SELECT * FROM uptime ORDER BY starttime DESC LIMIT 1
SELECT online FROM account
SELECT * FROM realmlist WHERE id = 1
SELECT totaltime FROM characters
```
It still does all the query stuff basically instantly anyways. and I know I should narrow my searches and not use use `*` wildcards..
rektbyfaith
08-12-2023, 08:40 AM #4Archived author: MobCat • Posted: 2023-08-12T08:40:08.760000+00:00
Original source
and 4. probs could be better but its okie
```sql
SELECT * FROM uptime ORDER BY starttime DESC LIMIT 1
SELECT online FROM account
SELECT * FROM realmlist WHERE id = 1
SELECT totaltime FROM characters
```
It still does all the query stuff basically instantly anyways. and I know I should narrow my searches and not use use `*` wildcards..
Original source
Leaderboard worked too but its a bit squished as its just a copy paste from my news script where I had limited character space (32 chars per line)
![[Image: image.png?ex=690c6058&is=690b0ed8&hm=26d...45171ed2f&]](https://cdn.discordapp.com/attachments/1086807686571642900/1139842280811921408/image.png?ex=690c6058&is=690b0ed8&hm=26def2914f08c54330d42a9498b4523933f93ea9ab8a078a5e1f77245171ed2f&)
![[Image: image.png?ex=690c6059&is=690b0ed9&hm=610...5f47dfe3f&]](https://cdn.discordapp.com/attachments/1086807686571642900/1139842281055195157/image.png?ex=690c6059&is=690b0ed9&hm=610bff5644d1a3a6de199f842562c8bcc157f810632f9f34f63956b5f47dfe3f&)
rektbyfaith
08-12-2023, 08:46 AM #5Archived author: MobCat • Posted: 2023-08-12T08:46:17.108000+00:00
Original source
Leaderboard worked too but its a bit squished as its just a copy paste from my news script where I had limited character space (32 chars per line)
Original source
I have better code for it, but I have to do a csv lookup for the achievement points and map names. Just have to work out how to do all that in php.
no rush though, im still testing the knoladge base article viewer to see what I can and can't render in there. so far `\n` is the only formatting I've found so far. Wish there was more legit screenshots so I could see what a real article looked like so I can get more ideas for what to try.
![[Image: image.png?ex=690c615a&is=690b0fda&hm=31b...1208e8811&]](https://cdn.discordapp.com/attachments/1086807686571642900/1139843360119599104/image.png?ex=690c615a&is=690b0fda&hm=31b56d028aa5c2ffa6d301537ee70dcf58ddfff61d34dd0554c12d01208e8811&)
rektbyfaith
08-12-2023, 08:50 AM #6Archived author: MobCat • Posted: 2023-08-12T08:50:34.371000+00:00
Original source
I have better code for it, but I have to do a csv lookup for the achievement points and map names. Just have to work out how to do all that in php.
no rush though, im still testing the knoladge base article viewer to see what I can and can't render in there. so far `\n` is the only formatting I've found so far. Wish there was more legit screenshots so I could see what a real article looked like so I can get more ideas for what to try.
1 Guest(s)
1 Guest(s)