RMXP Pool Beta-The Easy Way to Find RMXP Resources

Started by Nerd101, October 17, 2009, 05:11:09 am

Previous topic - Next topic

Blizzard

It can be done with just using some sort of index in files, but MySQL is much more convenient. The earlier to decide to switch, the easier it will be (imagine 1000 resources that need to be added to the MySQL database in a few months).

If you decide using files, you can simply use 1 file per submission. You just need to find a way to separate the entries of the different values (author name, resource name, forum link, etc) with a specific character in the file since \n is being used as normal. I used \t (tab character) to separate values in RMX-OS server-client messages so it could work out here as well. Before the actual saving of a submission you could simply replace all tab characters in the submitted text with normal spaces and that way you could use the tab character as separator without fearing that it will mess up anything.

Example: Blizzard\tBlizz-ABS\thttp://LINK_HERE\t

As filenames you can just use numbers. Of course this isn't as convenient or efficient as using an actual database.
If you decide on using MySQL, I can give you a hand. Which programming language did you make this application in?
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.

Nerd101

RMXP Pool was not made in a programming language at all. It was made with a 'drag and drop' editor and programming program called Multimedia Fusion 2 - Developer (www.clickteam.com). To be honest, I could spend millions of hours learning a programming language, but this program provides me with all the functionality I need (there are currently loads of commercial games and apps created with it).

Thanks for the offer of help with MySQL. Besides creating the database, there is also the problem of actually accessing it via the program; as the downloadable SQL object is rather complicated and it also shows a firewall dialog whenever someone attempts to connect to an SQL database. By the way Blizzard, all of your scripts have now been integrated. To take a look at this, install the BETA of v0.1 (if you have not already) and launch the RMXP Pool Updater shortcut from your desktop. It will download an update patch which will install of your scripts into the database. You may wish to check over them and see if there is anything you want changed, in terms of descriptions, etc (I know that I forgot to change the description when I made the .exe for Stormtronics CMS; so it has the description from Blizz-ABS. This WILL be fixed in the final version).

Nerd101

I can now compress each resource .exe into a .CCN file which can be displayed through an .exe. .ccn s are extrememly small (the minimum size being 4kbs) so this will make this size of RMXP Pool much, much smaller :)