Staredit Network > Forums > Staredit Network > Topic: DLDB Feedback (part ii)
DLDB Feedback (part ii)
Feb 20 2008, 3:05 pm
By: Forsaken Archer  

Feb 20 2008, 3:05 pm Forsaken Archer Post #1



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).

Post has been edited 2 time(s), last time on Apr 10 2008, 5:07 pm by isolatedpurity.



None.

Feb 20 2008, 7:38 pm Falkoner Post #2



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.

Post has been edited 1 time(s), last time on Feb 20 2008, 8:06 pm by Falkoner.



None.

Mar 25 2008, 4:15 pm Polaris Post #3



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.



If anything cool is ever going on Skype me up under the name "blarghle"

Mar 28 2008, 3:20 pm Brontobyte Post #4



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. :D



None.

Mar 28 2008, 9:17 pm Moose Post #5



delete

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




Apr 5 2008, 6:17 pm azala Post #6



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.)



None.

Apr 9 2008, 11:59 pm Brontobyte Post #7



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



None.

Apr 10 2008, 3:28 am azala Post #8



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.



None.

Apr 10 2008, 4:00 am poiuy_qwert Post #9

PyMS and ProTRG developer

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

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




Apr 10 2008, 2:45 pm Forsaken Archer Post #10



fixed poiuy?



None.

Apr 10 2008, 9:46 pm poiuy_qwert Post #11

PyMS and ProTRG developer

fixed.




Apr 11 2008, 9:40 pm The_z0r Post #12



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.



None.

Apr 12 2008, 4:46 am Centreri Post #13

Relatively ancient and inactive

Reverse Article Changes so latest shows first.



None.

Apr 12 2008, 1:05 pm The_z0r Post #14



This is DLDB feedback, not wiki feedback. :P



None.

Apr 15 2008, 10:25 am azala Post #15



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...



None.

Apr 18 2008, 7:19 pm poiuy_qwert Post #16

PyMS and ProTRG developer

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.





Apr 25 2008, 1:16 am Falkoner Post #17



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

+1 Global Space:


+3 Global Space:


Enjoy :P



None.

May 12 2008, 10:19 pm BeDazed Post #18



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



None.

Jun 3 2008, 5:45 pm poiuy_qwert Post #19

PyMS and ProTRG developer

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>




Jun 6 2008, 4:21 am AfterLifeLochie Post #20



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
<?php
$str = "Is your name O'reilly?";
echo addslashes($str);
?>

Which returns :
Code
Is your name O\'reilly?

And...
Code
<?php
$str = "Is your name O\'reilly?";
echo stripslashes($str);
?>

Returns...
Code
Is your name O'reilly?

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



None.

Options
  Back to forum
Please log in to reply to this topic or to report it.
Members in this topic: None.
[06:23 am]
Ultraviolet -- :wob:
[10:26 pm]
O)FaRTy1billion[MM] -- :wob:
[05:11 pm]
MTiger156 -- :wob: athon
[03:06 pm]
NudeRaider -- :wob:amatic
[01:37 pm]
jjf28 -- :wob: de :wob:
[2020-7-01. : 8:48 am]
RdeRenato -- Xd
[2020-7-01. : 7:01 am]
O)FaRTy1billion[MM] -- 1 :wob: to :wob:
[2020-7-01. : 6:05 am]
Apos -- How many :wob: does it take to :wob: a :wob:
[2020-7-01. : 6:05 am]
Apos -- :wob:
[2020-7-01. : 5:25 am]
KrayZee -- RdeRenato Traitor
Please log in to shout.


Members Online: jun3hong, Roy