New Script Database

Started by Blizzard, May 11, 2012, 02:06:13 am

Previous topic - Next topic

Blizzard

May 11, 2012, 02:06:13 am Last Edit: October 25, 2015, 02:44:33 am by Blizzard
Quote from: winkio on May 11, 2012, 12:40:06 am
Also, my second job is getting blocked by my university, so I may have more time to spend around here starting next week :D


I should totally get you to redesign the Script Database to be inside the forum's skin instead on the homepage.
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Boba Fett Link

Quote from: Blizzard on May 11, 2012, 02:06:13 am
I should totally get you to redesign the Script Database to be inside the forum's skin instead on the homepage.


Great idea.

Quote from: Blizzard on May 11, 2012, 12:17:14 am
I'm like the blood of this community. When I'm gone, everything starts to wither and die.


Next time you're sick (which could happen any time) we should all volunteer to give blood to Chaos Project. :V:
This post will self-destruct in 30 seconds.

Blizzard

Quote from: Boba Fett Link on May 11, 2012, 06:35:30 pm
Quote from: Blizzard on May 11, 2012, 02:06:13 am
I should totally get you to redesign the Script Database to be inside the forum's skin instead on the homepage.


Great idea.


He'd even have a couple of good resources beforehand. I can give him the Shoutbox Archive PHP file and the SQL queries I used to obtain the data. All he had to do would be add drop-down menus to select the RM and script category and then generate the content with links using those settings.

Quote from: Boba Fett Link on May 11, 2012, 06:35:30 pm
Quote from: Blizzard on May 11, 2012, 12:17:14 am
I'm like the blood of this community. When I'm gone, everything starts to wither and die.


Next time you're sick (which could happen any time) we should all volunteer to give blood to Chaos Project. :V:


:V:
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

winkio

If you send it to me within the next 12 hours, I will have it done within the next 24 hours.

Blizzard

May 12, 2012, 03:23:09 am #4 Last Edit: May 12, 2012, 03:28:31 am by Blizzard
Sent. As I already said, if you can't finish it and if you can get things working at least in concept, I can take it from there. That would still reduce my workload a lot.
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Blizzard

Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

winkio

July 30, 2012, 01:10:53 pm #6 Last Edit: August 10, 2012, 11:49:32 am by winkio
Lol, I can't believe I've forgot about this!  I've even had the time to do it recently!

I'll work on it today, and hopefully have it done.

EDIT: work came up.  Will finish.

nathmatt

Join Dead Frontier
Sorry, I will no longer be scripting for RMXP. I may or may not give support for my scripts. I don't have the will to script in RGSS anymore.
My script


winkio


Blizzard

Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

winkio

Thanks.  Not lacking motivation, plan on finishing this and being more active soon.

Boba Fett Link

This post will self-destruct in 30 seconds.

Blizzard

Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

winkio


Blizzard

Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Ryex

I no longer keep up with posts in the forum very well. If you have a question or comment, about my work, or in general I welcome PM's. if you make a post in one of my threads and I don't reply with in a day or two feel free to PM me and point it out to me.<br /><br />DropBox, the best free file syncing service there is.<br />

winkio

Yay.  One project down, two to go (Blizz-ABS 2.85 and Blizz-ABS 3.0 are the other two).

G_G


Blizzard

October 27, 2012, 04:05:39 am #18 Last Edit: October 27, 2012, 04:07:01 am by Blizzard
winkio probably saved me hours of work. I still had to edit the template's PHP/HTML to get a nice grid like this (which isn't something he could have done blindly), but it was simply trial and error because I had the right data to work with from the beginning. :)

THE NEW DATABASE! - brought to you by your admins
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Memor-X

ooooooo, i'm having a spasm from seeing the new database, it's a lot better than the old one, easier to read to with it now being in a visible table (i think the old one was in a table but was hidden)

Blizzard

There were no borders before and now all topics are aligned globally. The old database aligned only the scripts from the same category in a table. Plus, this one is completely integrated with the forum skin.
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Ryex

from a programming aspect it's implemented as a forum action in much the same way your profile pages is an action. where as the old database was a standalone php page.
I no longer keep up with posts in the forum very well. If you have a question or comment, about my work, or in general I welcome PM's. if you make a post in one of my threads and I don't reply with in a day or two feel free to PM me and point it out to me.<br /><br />DropBox, the best free file syncing service there is.<br />

Blizzard

Previously it wasn't so much a standalone PHP page as it actually was a custom component in the Joomla CMS.
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Magus

I can't believe I haven't noticed this. Epic --just as I was finally thinking I should get back into Rmxp one time and actually start a serious project.
LEVEL ME DOWN. THE ANTI-BLIZZ GROUP IS AMONG YOU... Do it for the chick below...She watches..<br />

Apidcloud

November 15, 2012, 07:46:07 pm #24 Last Edit: November 15, 2012, 07:52:33 pm by Apidcloud
May I ask if "everything" you did was look all the topics' titles and organize them according to its tags? (With "everything" I'm not being sarcastic, I'm just asking if that is the "only" thing that had to be done)



Instead of wanting to be somebody else, rather become somebody else



"I will treasure the knowledge like a squirrel treasures acorns."


Gibbo Glast 2D Engine - The sky is no longer a limit

Ryex

the script database is automated, there is a php script that analyses topics in the database board and pulls the needed information to sort them in the list.
I no longer keep up with posts in the forum very well. If you have a question or comment, about my work, or in general I welcome PM's. if you make a post in one of my threads and I don't reply with in a day or two feel free to PM me and point it out to me.<br /><br />DropBox, the best free file syncing service there is.<br />

Apidcloud

Ah yes, I forgot about the automated system  :haha:

So yeah, when you create a new thread, that php script automatically picks the needed information(by using tags) in order to add it to the database and sort them categorically.
So nice  :)

I wonder if this actually one of the only forums that actually use a fully automated script database..

Also, couldn't we make a database for everything - not everything - ? Including event tutorials 'n stuff
Instead of wanting to be somebody else, rather become somebody else



"I will treasure the knowledge like a squirrel treasures acorns."


Gibbo Glast 2D Engine - The sky is no longer a limit

Ryex

we could, but do you have time to make it? non of us do :P
I no longer keep up with posts in the forum very well. If you have a question or comment, about my work, or in general I welcome PM's. if you make a post in one of my threads and I don't reply with in a day or two feel free to PM me and point it out to me.<br /><br />DropBox, the best free file syncing service there is.<br />

Apidcloud

November 15, 2012, 09:54:17 pm #28 Last Edit: November 15, 2012, 10:25:05 pm by Apidcloud
Well, I never programmed in php but it doesn't seem that difficult(issue-wise)

Edit:
Can I take a look on that php script that winkio made?
Instead of wanting to be somebody else, rather become somebody else



"I will treasure the knowledge like a squirrel treasures acorns."


Gibbo Glast 2D Engine - The sky is no longer a limit

Blizzard

That's why it's important that the topic header fits the template. The PHP script expects the to be in a specific format and analyzes them for the necessary data (that includes [XP] and similar tags as well).

Quote from: Ryex on November 15, 2012, 09:48:22 pm
we could, but do you have time to make it? non of us do :P


Honestly? It would probably take me half an hour as I can simply copy-paste and edit some code. But that isn't the reason why we haven't done it so far. There simply aren't so many tutorials/event systems that it really makes sense. Scripts on the other side, we have currently a few hundred of those so the situation is a bit different and it's difficult to find what you need. Also, event systems are usually harder to categorize.
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Apidcloud

Well, its true that it may be hearder to categorize event systems, but they are pretty much the same as scripts...internally, they are eventually the same :p I think that it would be nice to have an event automated database. No1 would stop us from adding more tags or what not, and yes, tags are really essencial  :)
Instead of wanting to be somebody else, rather become somebody else



"I will treasure the knowledge like a squirrel treasures acorns."


Gibbo Glast 2D Engine - The sky is no longer a limit

Blizzard

What really would need work is editing all topics and making sure all headers are correctly set up.
Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

Apidcloud

November 16, 2012, 02:33:51 pm #32 Last Edit: November 16, 2012, 03:03:25 pm by Apidcloud
Quote from: Blizzard on November 16, 2012, 10:15:18 am
What really would need work is editing all topics and making sure all headers are correctly set up.


Indeed :) But after that, it would be easy to have a complete automated database ^^  :)
Instead of wanting to be somebody else, rather become somebody else



"I will treasure the knowledge like a squirrel treasures acorns."


Gibbo Glast 2D Engine - The sky is no longer a limit

G_G

Quick necro to mention that we should probably add MV scripts to the actual database button up top.

Blizzard

Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

G_G

Would it be possible to use regexp and sub out the tab "\t" and replace with like 4 spaces "&nbsp;"?

Blizzard

Check out Daygames and our games:

King of Booze 2      King of Booze: Never Ever
Drinking Game for Android      Never have I ever for Android
Drinking Game for iOS      Never have I ever for iOS


Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

ForeverZer0

I personally prefer the tab. If you don't like the formatting, it is always possible to change the tab space, but not the other way around.
I am done scripting for RMXP. I will likely not offer support for even my own scripts anymore, but feel free to ask on the forum, there are plenty of other talented scripters that can help you.

G_G

Quote from: Blizzard on October 25, 2015, 08:22:57 am
I guess. But what for?


LOL Wrong topic. Meant to post this in the syntax highlighting topic. xD