Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Greeting Card Mod 3.6 (RC1)
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 6

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 30 June 2008 :  22:37:37  Show Profile  Reply with Quote
Rolling on from this MOD over 6 years ago: Greeting Card Mod

I have re-written the Greeting Card to now work off the Forum database and a few other things including easy to install (being 1 out 10 and 1 being the easiest). I have included 10 Greeting Cards to get you started and all appears to work fine on Access & MSSQL.

I have also made it work using the forums inc_mail.asp so there is no need for a special mail component.

You can download it from: Greeting Card Mod 3.6

Enjoy... <

Cheers,

David Greening

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 01 July 2008 :  04:40:48  Show Profile  Visit HuwR's Homepage  Reply with Quote
I have removed the link until the code for this mod is sanitised against SQL injection, currently it is not. I found several request variables in the _preview.asp file that were not being sanitised prior to using in a query.<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 01 July 2008 :  06:59:30  Show Profile  Reply with Quote
HuwR,

I have rechecked the code and made the changes now it should be right on all the files. Do you want to put the link back up?
<

Cheers,

David Greening
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 01 July 2008 :  07:03:41  Show Profile  Visit HuwR's Homepage  Reply with Quote
did you also check greeting_cards_get.asp ? I think that had some vulnerabilities too<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 01 July 2008 :  07:17:12  Show Profile  Reply with Quote
All files where chaecked and the zip updated...<

Cheers,

David Greening
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 01 July 2008 :  07:28:32  Show Profile  Visit HuwR's Homepage  Reply with Quote
ok great feel free to put the link back up<
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 01 July 2008 :  18:50:44  Show Profile  Reply with Quote
Hi,

I am getting this error message when I click on "Cards" in the Admin Section.

Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near '*'.
/greeting_cards_clean.asp, line 92

line 92: set rs = conn.execute (strsql)

The two lines above it are:

strSQL = "DELETE * FROM " & strTablePrefix & "GREETING_SENT WHERE SENTDATE" _
& "< #" & rev & "#;"

Any idea what the problem is?
Thanks
<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 July 2008 :  18:51:57  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Remove the '*', so that the SQL statement is "DELETE FROM " &...<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

mdelcour2000
Junior Member

United States
133 Posts

Posted - 01 July 2008 :  19:18:21  Show Profile  Visit mdelcour2000's Homepage  Reply with Quote
VERY IMPRESSIVE!<

http://lacledeforum.com/

"Never get so busy doing the work of the kingdom that you forget who the King is"
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 01 July 2008 :  20:27:04  Show Profile  Visit leatherlips's Homepage  Reply with Quote
When I go into General Settings and click "Send Config" I get this error:

You need to put in a SMTP Server
Back
Please enter the greetings URL!
Back

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forumtest/greeting_cards_docard.asp, line 188
<

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 01 July 2008 :  20:37:08  Show Profile  Reply with Quote
quote:
Originally posted by ruirib

Remove the '*', so that the SQL statement is "DELETE FROM " &...



Thanks ruirib
Tried that but still gives the same error <
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 01 July 2008 :  21:01:37  Show Profile  Reply with Quote
quote:
Originally posted by leatherlips

When I go into General Settings and click "Send Config" I get this error:

You need to put in a SMTP Server
Back
Please enter the greetings URL!
Back

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forumtest/greeting_cards_docard.asp, line 188




In greeting_cards_docard.asp, lines 166-170, replace with:


Sub general
mailserver = strMailServer
url = strForumURL
myname = Request.Form("myname")
days = Request.form("days")


lines 188-191, replace with:


rs("mailserver") = strMailServer
rs("url") = strForumURL
rs("myname") = Request.Form("myname")
rs("days") = Request.form("days")


That should fix your problem.<
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 01 July 2008 :  21:07:38  Show Profile  Visit leatherlips's Homepage  Reply with Quote
It took out some of the error. Now it only says this:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forumtest/greeting_cards_docard.asp, line 188

Line 188 is:

rs("mailserver") = strMailServer<

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

mdelcour2000
Junior Member

United States
133 Posts

Posted - 01 July 2008 :  21:46:48  Show Profile  Visit mdelcour2000's Homepage  Reply with Quote
ok, when I try to delete a card, that I added, I am getting this error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/default/greeting_cards_remcardcat.asp, line 109

cat = trim(chkStringRequest("catid"),"SQLString"))
-------------------------------------------------^
<

http://lacledeforum.com/

"Never get so busy doing the work of the kingdom that you forget who the King is"
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 01 July 2008 :  22:34:58  Show Profile  Reply with Quote
quote:
Originally posted by leatherlips

It took out some of the error. Now it only says this:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forumtest/greeting_cards_docard.asp, line 188

Line 188 is:

rs("mailserver") = strMailServer



Try this one, think it'll do it.

greeting_cards_docard.txt<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 01 July 2008 :  22:37:29  Show Profile  Reply with Quote
quote:
Originally posted by mdelcour2000

ok, when I try to delete a card, that I added, I am getting this error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/default/greeting_cards_remcardcat.asp, line 109

cat = trim(chkStringRequest("catid"),"SQLString"))
-------------------------------------------------^




That one's rather obvious, there are differing quantities of opening and closing parentheses. Eliminate the final closing parenthesis.<
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07