Eh... I felt like it needed a new topic since the move. As always, appreciate any feedback, suggestions, bug reports, whatever is on your mind. The less you tell me the problems, the less the probability of me fixing them. [U][SIZE=18]What's new:[/SIZE][/U] - Better searching - Removal search terms - Categories on the left side of splash ------------------------------------------------------------ - Portal system - Automatic image generation for maps - SC version for Mods - Images are clickable again, though not how I intended. The will open a new browser tab. - Favorites work again - Reviews are now shown + has link to write a review ------------------------------------------------------------ - A file can now have multiple SEN members as authors. - The tab interface. - File edit history. - Upgrading files now works. [U][SIZE=18]What's broken, being worked on:[/SIZE][/U] - Images sometimes gets messed up, apparently sometimes image dimensions can't be processed and it screws up everything ------------------------------------------------------------ [s]- Since authors got rewritten, all displays of author needs to be fixed.[/s] - On the same note, clean up of code. Copy and pasted too many times since I started revamping. [s]- Links will be full info[/s] - Mod / reports. [U][SIZE=18]What's coming (near or far):[/SIZE][/U] - Non-sen authors - Possibly SEN editors & non-sen editors [s]- A store item! LOL oh no. Nothing serious. Simply the ability to put your file on the front page in an advertising section. For the lulz.[/s] [s]- SC version for mods.[/s] [s]- Better search.[/s] - Tag stats. - Exploded file stats: Who favorited and who downloaded this file - Recommended files: With individual favorites, downloads, ratings being track, there's a possibility of thing such as "people who loved this file, also loves this..." or a customized category of files, built automatically by other member's apparent preferences according to yours. - Possibly better history (only what's changed on tags, side by side view of descriptions).

Eh... I felt like it needed a new topic since the move.
As always, appreciate any feedback, suggestions, bug reports, whatever is on your mind. The less you tell me the problems, the less the probability of me fixing them.

What's new:
- Better searching
- Removal search terms
- Categories on the left side of splash
------------------------------------------------------------
- Portal system
- Automatic image generation for maps
- SC version for Mods
- Images are clickable again, though not how I intended. The will open a new browser tab.
- Favorites work again
- Reviews are now shown + has link to write a review
------------------------------------------------------------
- A file can now have multiple SEN members as authors.
- The tab interface.
- File edit history.
- Upgrading files now works.

What's broken, being worked on:
- Images sometimes gets messed up, apparently sometimes image dimensions can't be processed and it screws up everything
------------------------------------------------------------
- Since authors got rewritten, all displays of author needs to be fixed.
- On the same note, clean up of code. Copy and pasted too many times since I started revamping.
- Links will be full info
- Mod / reports.


What's coming (near or far):
- Non-sen authors
- Possibly SEN editors & non-sen editors
- A store item! LOL oh no. Nothing serious. Simply the ability to put your file on the front page in an advertising section. For the lulz.
- SC version for mods.
- Better search.
- Tag stats.
- Exploded file stats: Who favorited and who downloaded this file
- Recommended files: With individual favorites, downloads, ratings being track, there's a possibility of thing such as "people who loved this file, also loves this..." or a customized category of files, built automatically by other member's apparent preferences according to yours.
- Possibly better history (only what's changed on tags, side by side view of descriptions).

Great, gotta upload em all again.. Once again, no apostrophes in the names... Here's the error I got: A Staredit Network error has occured: [COLOR=#86EE59]Query failed : INSERT INTO db_files (`db_filename`, `db_time`, `db_ext`, `db_views`, `db_current_editor`, `db_edit_open_time`, `db_files`, `db_submitter`, `db_size`, `db_title`, `db_opensource`, `db_id`, `db_file_location`) VALUES ('Falkoner's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| Ash World/Random Ash World #2.scm| Ash World/Random Ashworld #1.scm| Badlands/| Badlands/Random Badlands #1.scx| Badlands/Random Badlands #2.scm| Badlands/Random Badlands #3.scm| Desert/| Desert/Desert Ramps.scx| Desert/Random Desert #1.scx| Desert/Random Desert #2.scx| Ice/| Ice/Ice Custom Cliffs.scx| Ice/Random Ice #1.scx| Ice/Random Ice #2.scx| Installation/| Installation/Random Installation #1.scm| Installation/Random Installation #2.scx| Jungle/| Jungle/Cliff Brushes.scmdbrh| Jungle/Jungle Bone Database.scm| Jungle/Jungle Cannal.scm| Jungle/Jungle Custom Cliffs.scx| Jungle/Jungle Custom Doodad Database.scm| Jungle/Jungle Custom Doodads.scx| Jungle/Jungle Custom Ramps.scx| Jungle/Jungle Doodad Database.scx| Jungle/Jungle Interiors.scx| Jungle/Jungle Ramp Database.scx| Jungle/Jungle Rocky Dirt Database.scx| Jungle/Jungle Terrain Pallete.scx| Jungle/meh.scmdbrh| Jungle/Random Jungle #1.scx| Jungle/Random Jungle #10.scx| Jungle/Random Jungle #11.scm| Jungle/Random Jungle #12.scm| Jungle/Random Jungle #2.scx| Jungle/Random Jungle #3.scx| Jungle/Random Jungle #4.scx| Jungle/Random Jungle #5.scx| Jungle/Random Jungle #6.scx| Jungle/Random Jungle #7.scx| Jungle/Random Jungle #8.scm| Jungle/Random Jungle #9.scx| Jungle/Scm3.tmp| Other/| Other/3-D Buildings.scx| Space/| Space/Space Backwards Ramps.scm| Space/Space to High Platform.scm| Twilight/| Twilight/Random Twilight #1.scx| Twilight/Twilight Platforms.scx', 31, 3166852, 'unknown', 1, 13, 'ace69cfb') 1064[/COLOR] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| ' at line 1 Please contact administration with all the details.

Great, gotta upload em all again..

Once again, no apostrophes in the names... Here's the error I got:

A Staredit Network error has occured:
Query failed : INSERT INTO db_files (`db_filename`, `db_time`, `db_ext`, `db_views`, `db_current_editor`, `db_edit_open_time`, `db_files`, `db_submitter`, `db_size`, `db_title`, `db_opensource`, `db_id`, `db_file_location`) VALUES ('Falkoner's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| Ash World/Random Ash World #2.scm| Ash World/Random Ashworld #1.scm| Badlands/| Badlands/Random Badlands #1.scx| Badlands/Random Badlands #2.scm| Badlands/Random Badlands #3.scm| Desert/| Desert/Desert Ramps.scx| Desert/Random Desert #1.scx| Desert/Random Desert #2.scx| Ice/| Ice/Ice Custom Cliffs.scx| Ice/Random Ice #1.scx| Ice/Random Ice #2.scx| Installation/| Installation/Random Installation #1.scm| Installation/Random Installation #2.scx| Jungle/| Jungle/Cliff Brushes.scmdbrh| Jungle/Jungle Bone Database.scm| Jungle/Jungle Cannal.scm| Jungle/Jungle Custom Cliffs.scx| Jungle/Jungle Custom Doodad Database.scm| Jungle/Jungle Custom Doodads.scx| Jungle/Jungle Custom Ramps.scx| Jungle/Jungle Doodad Database.scx| Jungle/Jungle Interiors.scx| Jungle/Jungle Ramp Database.scx| Jungle/Jungle Rocky Dirt Database.scx| Jungle/Jungle Terrain Pallete.scx| Jungle/meh.scmdbrh| Jungle/Random Jungle #1.scx| Jungle/Random Jungle #10.scx| Jungle/Random Jungle #11.scm| Jungle/Random Jungle #12.scm| Jungle/Random Jungle #2.scx| Jungle/Random Jungle #3.scx| Jungle/Random Jungle #4.scx| Jungle/Random Jungle #5.scx| Jungle/Random Jungle #6.scx| Jungle/Random Jungle #7.scx| Jungle/Random Jungle #8.scm| Jungle/Random Jungle #9.scx| Jungle/Scm3.tmp| Other/| Other/3-D Buildings.scx| Space/| Space/Space Backwards Ramps.scm| Space/Space to High Platform.scm| Twilight/| Twilight/Random Twilight #1.scx| Twilight/Twilight Platforms.scx', 31, 3166852, 'unknown', 1, 13, 'ace69cfb')
1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| ' at line 1

Please contact administration with all the details.

I think we need another category in the DLDB. Basically, a modding resources category, where we put all our GRP's, Consoles, and other crap. If we shoved all these under the normal mods catagory, it would get really cramped, and be hard to find an actual mod, due to the resources are in greater numbers then actual mods. So, just something for you to consider, I think it would be a decent idea.

I think we need another category in the DLDB. Basically, a modding resources category, where we put all our GRP's, Consoles, and other crap. If we shoved all these under the normal mods catagory, it would get really cramped, and be hard to find an actual mod, due to the resources are in greater numbers then actual mods.

So, just something for you to consider, I think it would be a decent idea.

Can you make the database categorized? Instead of looking for tags or searching for a users name, why not just have the maps sent to different categorys so that one could search for all the maps in that category. I know you can already do this by searching for the tag bound or defense, but it would [I]spice up[/I] the map database page alot. Yeah I know it sounds like maplantis, but it worked, and it was more user freindly. :D

Can you make the database categorized? Instead of looking for tags or searching for a users name, why not just have the maps sent to different categorys so that one could search for all the maps in that category. I know you can already do this by searching for the tag bound or defense, but it would spice up the map database page alot. Yeah I know it sounds like maplantis, but it worked, and it was more user freindly.

delete (Hey IP, admins should really be able to delete their own posts... Seriously, I just edit it anyway. :P)

delete

(Hey IP, admins should really be able to delete their own posts... Seriously, I just edit it anyway. )

List tags in order of popularity, instead of some random order. For example: I should be able to click "Database", Portal: "Maps", and tag "defense" to get defense maps. Except, that "defense" often doesn't show up in the list. -_- (Even if the "More..." link is fixed, I should not have to click it to view a popular tag.)

List tags in order of popularity, instead of some random order.

For example:
I should be able to click "Database", Portal: "Maps", and tag "defense" to get defense maps.
Except, that "defense" often doesn't show up in the list. -_-
(Even if the "More..." link is fixed, I should not have to click it to view a popular tag.)

Is it me or when you download a file, the overall file size doesn't show up. This is handy when people don't put how big their file is. ( Because its a waste of space ) Can you also place it somewhere near the map? Thanks. :D

Is it me or when you download a file, the overall file size doesn't show up. This is handy when people don't put how big their file is. ( Because its a waste of space ) Can you also place it somewhere near the map? Thanks.

[quote=name:azala]List tags in order of popularity, instead of some random order. For example: I should be able to click "Database", Portal: "Maps", and tag "defense" to get defense maps. Except, that "defense" often doesn't show up in the list. -_- (Even if the "More..." link is fixed, I should not have to click it to view a popular tag.)[/quote] Nicely done IP :) The latest iteration is better than I expected.

Quote from azala

List tags in order of popularity, instead of some random order.

For example:
I should be able to click "Database", Portal: "Maps", and tag "defense" to get defense maps.
Except, that "defense" often doesn't show up in the list. -_-
(Even if the "More..." link is fixed, I should not have to click it to view a popular tag.)

Nicely done IP
The latest iteration is better than I expected.

When I view any item in the DB i get [code]Warning: Invalid argument supplied for foreach() in /home/starlite/public_html/scripts/database/view.php on line 282[/code] Then most of the text on the page becomes really big.

When I view any item in the DB i get

Code

Then most of the text on the page becomes really big.

fixed poiuy?

fixed poiuy?

fixed.

fixed.

When I click on [i][u]more[/u][/i] in the DLDB, I get directed to this link: [URL]http://www.staredit.net/?p=database&area=tags[/URL], which turns up an error.

When I click on more in the DLDB, I get directed to this link: http://www.staredit.net/?p=database&area=tags, which turns up an error.

Reverse Article Changes so latest shows first.

Reverse Article Changes so latest shows first.

This is DLDB feedback, not wiki feedback. :P

This is DLDB feedback, not wiki feedback.

Bug/issue: The ' character is represented by #039; in the "Download _____.scx" file name in the DLDB. I can still upload the file, though. It's a problem if you take that map, and the map is already floating around b.net - then you've got to download the file twice unnecessarily. Plus, "Azala#039;s Self Defense.scx" just kinda looks bad. I can understand if its an unavoidable issue because of ' being a string delimiter, etc...

Bug/issue:
The ' character is represented by #039; in the "Download _____.scx" file name in the DLDB. I can still upload the file, though.

It's a problem if you take that map, and the map is already floating around b.net - then you've got to download the file twice unnecessarily. Plus, "Azala#039;s Self Defense.scx" just kinda looks bad.

I can understand if its an unavoidable issue because of ' being a string delimiter, etc...

The first time I go to the database after logging on (and possibly other times, im not sure exactly when it happens), trying to switch from one catagory to another with the dropdown gives the error: [quote] Not Found The requested URL /download.php&portal=maps was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. [/quote]

The first time I go to the database after logging on (and possibly other times, im not sure exactly when it happens), trying to switch from one catagory to another with the dropdown gives the error:

Quote

Not Found

The requested URL /download.php&portal=maps was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Hey, I remember there being a thread about pictures, but here's two I made really quick: +1 Global Space: [img=http://img117.imageshack.us/img117/3981/globalspace1ix2.png] +3 Global Space: [img=http://img186.imageshack.us/img186/3070/globalspace3ut3.png] Enjoy :P

Hey, I remember there being a thread about pictures, but here's two I made really quick:

+1 Global Space:


+3 Global Space:


Enjoy

On Category Melee:, Competition, Non-competition, and melee style. Please fix the categories into League, Non-league, Alternative and Melee Style.

On Category Melee:, Competition, Non-competition, and melee style. Please fix the categories into League, Non-league, Alternative and Melee Style.

The comments on the DLDB portal have a problem with the truncation. It is truncating the html and not the text of the comment, so for example you get (the red part is a smilies img tag being truncated): <div style="padding:4px 10px 2px 10px"> Most likely one of the best concepts out there. [color=#CE091D]<img src="/images/smilies/1/smile.gif" alt=":)" style="vertical-align:[/color]... [<a href="http://www.staredit.net/files/422/&load=comments">more</a>]</div>

The comments on the DLDB portal have a problem with the truncation. It is truncating the html and not the text of the comment, so for example you get (the red part is a smilies img tag being truncated):

<div style="padding:4px 10px 2px 10px"> Most likely one of the best concepts out there. <img src="/images/smilies/1/smile.gif" alt=":)" style="vertical-align:... [<a href="http://www.staredit.net/files/422/&load=comments">more</a>]</div>

A Staredit Network error has occured: [COLOR=#86EE59]Query failed : INSERT INTO db_files (`db_filename`, `db_time`, `db_ext`, `db_views`, `db_current_editor`, `db_edit_open_time`, `db_files`, `db_submitter`, `db_size`, `db_title`, `db_opensource`, `db_id`, `db_file_location`) VALUES ('Falkoner's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| Ash World/Random Ash World #2.scm| Ash World/Random Ashworld #1.scm| Badlands/| Badlands/Random Badlands #1.scx| Badlands/Random Badlands #2.scm| Badlands/Random Badlands #3.scm| Desert/| Desert/Desert Ramps.scx| Desert/Random Desert #1.scx| Desert/Random Desert #2.scx| Ice/| Ice/Ice Custom Cliffs.scx| Ice/Random Ice #1.scx| Ice/Random Ice #2.scx| Installation/| Installation/Random Installation #1.scm| Installation/Random Installation #2.scx| Jungle/| Jungle/Cliff Brushes.scmdbrh| Jungle/Jungle Bone Database.scm| Jungle/Jungle Cannal.scm| Jungle/Jungle Custom Cliffs.scx| Jungle/Jungle Custom Doodad Database.scm| Jungle/Jungle Custom Doodads.scx| Jungle/Jungle Custom Ramps.scx| Jungle/Jungle Doodad Database.scx| Jungle/Jungle Interiors.scx| Jungle/Jungle Ramp Database.scx| Jungle/Jungle Rocky Dirt Database.scx| Jungle/Jungle Terrain Pallete.scx| Jungle/meh.scmdbrh| Jungle/Random Jungle #1.scx| Jungle/Random Jungle #10.scx| Jungle/Random Jungle #11.scm| Jungle/Random Jungle #12.scm| Jungle/Random Jungle #2.scx| Jungle/Random Jungle #3.scx| Jungle/Random Jungle #4.scx| Jungle/Random Jungle #5.scx| Jungle/Random Jungle #6.scx| Jungle/Random Jungle #7.scx| Jungle/Random Jungle #8.scm| Jungle/Random Jungle #9.scx| Jungle/Scm3.tmp| Other/| Other/3-D Buildings.scx| Space/| Space/Space Backwards Ramps.scm| Space/Space to High Platform.scm| Twilight/| Twilight/Random Twilight #1.scx| Twilight/Twilight Platforms.scx', 31, 3166852, 'unknown', 1, 13, 'ace69cfb') 1064[/COLOR] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| ' at line 1 Please contact administration with all the details. From poiuy_qwert: The comments on the DLDB portal have a problem with the truncation. It is truncating the html and not the text of the comment, so for example you get (the red part is a smilies img tag being truncated): <div style="padding:4px 10px 2px 10px"> Most likely one of the best concepts out there. [color=#CE091D]<img src="/images/smilies/1/smile.gif" alt=":)" style="vertical-align:[/color]... [<a href="http://www.staredit.net/files/422/&load=comments">more</a>]</div> This is all to do with PHP! There is a fix, however. When databases came into the world many years ago, they needed a method to 'escape' characters. But on a database level. Thus, PHP came up with addslashes($string) and stripslashes($string) [code] <?php $str = "Is your name O'reilly?"; echo addslashes($str); ?> [/code] Which returns : [code]Is your name O\'reilly?[/code] And... [code] <?php $str = "Is your name O\'reilly?"; echo stripslashes($str); ?> [/code] Returns... [code] Is your name O'reilly? [/code] Simple but effective. This is one of the many usable methods available to PHP programmers.

A Staredit Network error has occured:
Query failed : INSERT INTO db_files (`db_filename`, `db_time`, `db_ext`, `db_views`, `db_current_editor`, `db_edit_open_time`, `db_files`, `db_submitter`, `db_size`, `db_title`, `db_opensource`, `db_id`, `db_file_location`) VALUES ('Falkoner's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| Ash World/Random Ash World #2.scm| Ash World/Random Ashworld #1.scm| Badlands/| Badlands/Random Badlands #1.scx| Badlands/Random Badlands #2.scm| Badlands/Random Badlands #3.scm| Desert/| Desert/Desert Ramps.scx| Desert/Random Desert #1.scx| Desert/Random Desert #2.scx| Ice/| Ice/Ice Custom Cliffs.scx| Ice/Random Ice #1.scx| Ice/Random Ice #2.scx| Installation/| Installation/Random Installation #1.scm| Installation/Random Installation #2.scx| Jungle/| Jungle/Cliff Brushes.scmdbrh| Jungle/Jungle Bone Database.scm| Jungle/Jungle Cannal.scm| Jungle/Jungle Custom Cliffs.scx| Jungle/Jungle Custom Doodad Database.scm| Jungle/Jungle Custom Doodads.scx| Jungle/Jungle Custom Ramps.scx| Jungle/Jungle Doodad Database.scx| Jungle/Jungle Interiors.scx| Jungle/Jungle Ramp Database.scx| Jungle/Jungle Rocky Dirt Database.scx| Jungle/Jungle Terrain Pallete.scx| Jungle/meh.scmdbrh| Jungle/Random Jungle #1.scx| Jungle/Random Jungle #10.scx| Jungle/Random Jungle #11.scm| Jungle/Random Jungle #12.scm| Jungle/Random Jungle #2.scx| Jungle/Random Jungle #3.scx| Jungle/Random Jungle #4.scx| Jungle/Random Jungle #5.scx| Jungle/Random Jungle #6.scx| Jungle/Random Jungle #7.scx| Jungle/Random Jungle #8.scm| Jungle/Random Jungle #9.scx| Jungle/Scm3.tmp| Other/| Other/3-D Buildings.scx| Space/| Space/Space Backwards Ramps.scm| Space/Space to High Platform.scm| Twilight/| Twilight/Random Twilight #1.scx| Twilight/Twilight Platforms.scx', 31, 3166852, 'unknown', 1, 13, 'ace69cfb')
1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Terrain Compilation.zip', 1203537900, 'zip', 0, 31, 1203537900, ' Ash World/| ' at line 1

Please contact administration with all the details.

From poiuy_qwert: The comments on the DLDB portal have a problem with the truncation. It is truncating the html and not the text of the comment, so for example you get (the red part is a smilies img tag being truncated):

<div style="padding:4px 10px 2px 10px"> Most likely one of the best concepts out there. <img src="/images/smilies/1/smile.gif" alt=":)" style="vertical-align:... [<a href="http://www.staredit.net/files/422/&load=comments">more</a>]</div>


This is all to do with PHP! There is a fix, however.
When databases came into the world many years ago, they needed a method to 'escape' characters. But on a database level. Thus, PHP came up with addslashes($string) and stripslashes($string)

Code

Which returns :

Code

And...

Code

Returns...

Code

Simple but effective. This is one of the many usable methods available to PHP programmers.