| T O P I C R E V I E W |
| Zuel |
Posted - 19 October 2005 : 16:23:39
heheheh I'm soo excited. After a few weeks of programming this thing I finally got my little add-on to work.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=52
This mod is not independent and it needs Avatar MOD VERSION 1.3 by Hamlin.
I'll post the code if I get some people who actually want to use it.
Doesn't modify any current Snitz files except the inc_header.asp to link to the page.
Screenshot #1 - http://www.twistingshadows.com/userimages/GeneralPreview.jpg
First screen people go to. Shows a default category and automatically generates the HTML to show the avatars.
Screenshot #2 - http://www.twistingshadows.com/userimages/UploadingPreview.jpg
Users can upload up to 4 images simentanously to a category.
Screenshot #3 - http://www.twistingshadows.com/userimages/DeletedPreview.jpg
Only Admins and moderators can see the Delete button to instantly delete any image or file that doesn't meet the requirments.
Screenshot #4 - http://www.twistingshadows.com/userimages/HoverPreview.jpg
Alt tag to tell people what stuff does.
Screenshot #5 - http://www.twistingshadows.com/userimages/CategoryPreview.jpg
Just more avatars under a different category.
Screenshot #6 - http://www.twistingshadows.com/userimages/ChoosingPreview.jpg
Users select the image they want and it adds the values to the DB so they can select their avatar within their profile. The form fields in the pop up are readonly so nothing can be messed around with.
This is just a preview of what I am working on. I won't release it yet because it is mainly spaghetti code. I want to put everything within Private Subs instead of inline code.
Trial:
http://www.twistingshadows.com/forum/avatars.asp
Account: tester
Password: tester
Things are buggy and can be tweaked and they will. I was just excited I got everything to work.  < |
| 15 L A T E S T R E P L I E S (Newest First) |
| Zuel |
Posted - 08 November 2005 : 14:35:12
Once permission errors are fixed, then I will setup another test forum along with the posted code. ETA is 2 days, November 10th, 2005.
Avatar Admin Page:
http://www.twistingshadows.com/userimages/Avatar_Admin.jpg
Admins have full control over settings. They can specify file size, along with disable and enabling avatar uploading.
Category settings means when they create a new category, a new folder will automatically be created within the avatar folder. (Directory Write Permissions MUST BE ENABLED!) Similiar with the Delete Diretory. Deleting a directory will delete all avatars within the folder.
Avatar Main Page:
http://www.twistingshadows.com/userimages/Avatars_Main.jpg
This page got a little tweaked. Now all images under the size limits (Admin Specifies in the Original Admin Panel) show up as their original size. Anything over just gets cut off, there plenty of free tools for users to crop themselves.
Also the button above the avatar is the delete function that only Admins and Moderators can see. Can control any inappropraite content or just an avatar in the wrong category.
Moving files feature coming after release.
No Folder:
http://www.twistingshadows.com/userimages/No_Folder_Exists.jpg
If an Admin chooses to disable the Automatically create a new folder when a category is created, then a user tries to access the page it will throw an error to inform them to create the folder.
Once permissions are fixed then I need to update the Pop_Profile, admin_review_avatar.asp and Private Messages avatar piece and a clean up sweep through the code.< |
| Zuel |
Posted - 08 November 2005 : 14:04:27
Gah, I am ready to give up. I just logged on this morning and my whole snitz board was down. Internal server, 500 errors left and right.
I found the error log and checked through it. Over 5000 internal server errors from 6 am to 11 am.
I contacted my host which is my co worker and we saw the hosting company has been going under some maintence. After going through we found the problems. My board no longer errors out and if it does, I can isolate the problem.
Debugging was enabled and I found the bugs that I couldn't find before. I shall attempt finish this tonight.
I won't give up that easy.< |
| vynsane |
Posted - 07 November 2005 : 14:01:19
wish i could help you there, but just following directions on mods makes my palms sweat. debugging ain't my strong suit...< |
| Zuel |
Posted - 07 November 2005 : 10:06:23
After looking through everything and failing at everything trying to fix it, I am going to ZIP up everything and post on Snitz forums for more testing.
I need testers. This MOD will crash in two instances that I am aware of. I need someone who has debugging enabled on their server to relay the error messages back to me.
I tested:
OS: Windows 2003 Server
DB: Access 2003
I need these tested:
OS: W/e Else
DB: MySQL and SQLServer
It should fail on Assigning Avatars and Uploading. Funny thing is, Uploading fails but still uploads. Assigning is just broke period on the server.
Everything works perfect on my localhost. Get ready for a link on Wednesdayish.< |
| ruirib |
Posted - 04 November 2005 : 17:17:52
No, the code is correct.< |
| Zuel |
Posted - 04 November 2005 : 15:39:03
Do I need to open a connection?
< |
| ruirib |
Posted - 04 November 2005 : 14:33:41
The SQL shown is correct. I don't see how it would cause an error.< |
| Zuel |
Posted - 04 November 2005 : 14:26:53
On the server:
Internal Server Error
On my Localhost:
Nothing, works fine.
If I can't get it to work tonight then I'll zip it up and host it up here so you guys can give it a try.< |
| ruirib |
Posted - 04 November 2005 : 13:00:09
What error do you get when you remove the code I suggested?< |
| Zuel |
Posted - 04 November 2005 : 10:17:48
INSERT INTO FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID) VALUES ('http://www.twistingshadows.com/forum/avatars/Blizzard/MaleGnome.gif', 'MaleGnome.gif', 1)< |
| ruirib |
Posted - 04 November 2005 : 04:19:13
Before that line, add this:
Response.Write strSql
Response.End
Tell us what is shown.< |
| Zuel |
Posted - 03 November 2005 : 23:27:34
I have no **** debugging, makes it just impossible for me to determine the exact error. But with Response.Writes and Ends I think the problem is displayed in red below. All is good until it hits the red line.
Public Sub checkForErrors()
'=== Clear Error Message ===
Err_Msg = ""
'=== Get Form Fields Values ===
avatarURL = ChkString(Request.Form("AvatarURL"),"url")
avatarName = ChkString(Request.Form("AvatarName"),"")
'=== No Avatar URL ===
if avatarURL = " " then
Err_Msg = Err_Msg & "<li>You Must Enter a URL for your Avatar!</li>"
end if
'=== No Avatar Name ===
if avatarName = " " then
Err_Msg = Err_Msg & "<li>You Must Enter a Name for your Avatar!</li>"
end if
'=== Error Present - Inform User ===
If Err_Msg <> "" then
StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """>There Was A Problem With The Submission</font></p>" & vbNewLine & _
"<table align=""center"" border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><ul>" & vbNewLine & _
" " & Err_Msg & " " & vbNewLine & _
" </ul></font></td>" & vbNewLine & _
" </tr>" & vbNewLine & _
"</table>" & vbNewLine & _
"<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""JavaScript:history.go(-1)"">Go Back To Enter Data</a></font></p>"
else
'=== No Errors - Build SQL Query ===
strSql = "INSERT INTO " & strTablePrefix & "AVATAR ("
strSql = strSql & "A_URL"
strSql = strSql & ", A_NAME"
strSql = strSql & ", A_MEMBER_ID"
strSql = strSql & ") VALUES ("
strSql = strSql & "'" & avatarURL & "'"
strSql = strSql & ", '" & avatarName & "'"
if Request.Form("AvatarMemberID") <> "" or Request.Form("AvatarMemberID") <> " " then
strSql = strSql & ", " & ChkString(Request.Form("AvatarMemberID"),"")
else
strSql = strSql & ", " & 0
end if
strSql = strSql & ")"
'=== Execute SQL Query ===
my_Conn.Execute (strSql)
'=== Insert Complete - Print Results to User ===
StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>Avatar " & avatarName & " Added!</font></p>" & vbCRLF
StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>To start using your new avatar,<br>go to your profile and choose the new avatar!</font></p>" & vbCRLF
StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><A href='javascript: self.close ()'>Close this Window</A></p><BR>" & vbCRLF
end if
Exit Sub
End Sub
< |
| Zuel |
Posted - 03 November 2005 : 23:06:06
Server failed at two spots.
Assigning and Uploading. Cry.< |
| Zuel |
Posted - 03 November 2005 : 20:58:38
quote:
Originally posted by MarkJH
quote:
i'm really excited by this, BTW... thanks for your hard work.
Yes, can't wait to see what you've accomplished with this.
I'm getting scared to release it. My biggest fear is having you guys install it and it crashes everything or it doesn't work period.
Remote debugging isn't my speciality.
Having said that, I have been coding in semi failsafes so users should never get an Internal Server Error. Every Database Request and every File System Object Request has been tested and coated with customized error messages.
Update: I am currently building my temporary forum on my local host. If I can install the avatars mod with no problems then my mod with no problems then I shall test on my server. If that passes then I will release for user tests.
Update # 2
Localhost temporary forum passed!< |
| Zuel |
Posted - 03 November 2005 : 19:21:38
quote:
Originally posted by vynsane
i take care of my folders independently of the admin home anyway, so it wouldn't bother me to not include it. also, i wouldn't want to delete the folder unless there was nothing in it anyway, and i would do that through FTP, so i guess that's my ten cents.
i'm really excited by this, BTW... thanks for your hard work.
Based on that, I made variables in the config above it whether or not to create and delete the folders when creating/deleteing the category in the Database.< |
