| Author |
 Topic  |
|
gpspassion
Junior Member
260 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
gpspassion
Junior Member
260 Posts |
 Posted - 18 June 2003 : 18:42:04
|
yes figured that out, probably because the printer_friendly.asp doesn't have it build in ;-)
I guess there are two options:
1. Feeding that info somehow
2. Creating a post_info_pda.asp that doesn't "need" that info
Any suggestion on what's easiest? |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 June 2003 : 18:56:42
|
You can make a simple query to the topics table, to get the category info, since you know the topic id. Just do it before it is needed in post_info.asp.
You cannot create a post_info that does not need that info, since the reply table currently needs that field to be filled in. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 18 June 2003 18:58:00 |
|
|
|
wizard
Junior Member
208 Posts |
|
|
gpspassion
Junior Member
260 Posts |
Posted - 22 June 2003 : 06:45:16
|
wizard - Sure, do you want what I was sent for v3.3 or the pda_qr.asp I created? The latter is here: http://www.gpspassion.com/upload/pda_qr.zip
ruirib - Sorry for being clueless :-( Any pointers on how I would go about doing a "simple query to the topics table before it is needed in post_info.asp" ? I guess that wouldn't be a problem for the normal version of the forums? Also is there a way I can put a check to see whether the post comes from pda.asp, in which case I would go back to pda.asp and not to the normal (bandwidth comsuming) version? TIA!
|
Edited by - gpspassion on 22 June 2003 06:50:52 |
|
|
|
wizard
Junior Member
208 Posts |
Posted - 23 June 2003 : 00:54:14
|
| I'm using V3.4. Can I have the complete mobile 3.4 version? |
|
|
|
wizard
Junior Member
208 Posts |
Posted - 23 June 2003 : 01:14:56
|
| One more question. Can I just upload the scripts to a new folder, maybe called "mobile" and then change the config.asp for the mobile version to the exact same database. Will it work this way or will I need to employ the dreaded "2 forums, 1 db" method. |
|
|
|
gpspassion
Junior Member
260 Posts |
Posted - 23 June 2003 : 07:07:57
|
wizard I can end you the .zip I received, but like I said it's based on v3.3 so it doesn't work properly with v3.4, check the current thread.
[b]At this point my plan would be to allow browsing with that version (3.3 based) and posting with my pda_qr.asp, BUT that would require getting posting to work and someone helping out with my previous questions:
"Sorry for being clueless :-( Any pointers on how I would go about doing a "simple query to the topics table before it is needed in post_info.asp" ? I guess that wouldn't be a problem for the normal version of the forums? Also is there a way I can put a check to see whether the post comes from pda.asp, in which case I would go back to pda.asp and not to the normal (bandwidth comsuming) version? TIA!"
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2003 : 18:40:34
|
gpspassion, I am a profound believer in learning by yourself. So I will just post the code to fix the CAT_ID problem and I suggest that you look at the solution GauravBhabu posted for the HTTP_REFERER problem (do a search on this term) and you will have a solution to the proper redirection problem.
strSql = "SELECT CAT_ID FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & Request.Form("TOPIC_ID")
set rsQr = my_conn.execute (strSql)
If not rsQr.EOF Then
CAT_ID = rsQr("CAT_ID"
End If
rsQr.Close
set rsQr = nothing
Thinking better I would suggest that you insert this code at the top of pda_qr.asp, before the definition of the QuickReply sub. Let me warn you that you have duplicate definitions for the QuickReply sub. Better erase one of them. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Pouyan
New Member
91 Posts |
Posted - 23 June 2003 : 18:45:38
|
gpspassion,
It's interesting how I posted a Mobile Mod idea on Server Hacker's site today:
http://www.shnforum.com/forum/topic.asp?TOPIC_ID=2425 
Then I come here and see your topic...very very interesting!
Can you zip up the version you're working on once you are done for everyone to use ?
and one more question... is it possible to have the mobile version and a regular forum running off of the same database ? how is it possible to have two different font/color configurations for the same forum ? I thought that information was tored in the database ?
Also, what do you guys think it would take to make the events calendar available on the mobile version as well ?
pretty amazing stuff... |
Edited by - Pouyan on 23 June 2003 18:48:11 |
|
|
|
gpspassion
Junior Member
260 Posts |
Posted - 24 June 2003 : 10:39:26
|
Pouayan - I'll be happy to oblige, but let's get to the bottom of this posting problem first ;-)
ruirib - I agree a 100% about learning by yourself, the learning curve is a bit steep for someone who's never touched .asp before though ;-)
On the CAT_ID thing, I think there was a ")" missing in CAT_ID = rsQr("CAT_ID" so I fixed that ;-)
It's now complaining of a syntax error in line 50 ( set rsQr = my_conn.execute (strSql) ) and says an "operator" is missing in the expression " 'TOPIC_ID=' "...I'll try to figure it out, but if you see what the problem might be, let me know ;-)
Updated link - http://www.gpspassion.com/forumsen/pda_qr.asp?TOPIC_ID=2236
Updated code - http://www.gpspassion.com/forumsen/pda_qr.zip
PS - Thanks for pointing out that I had the sub twice, I'd fixed that in the meantime. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 June 2003 : 10:59:54
|
quote:
Originally posted by gpspassion
On the CAT_ID thing, I think there was a ")" missing in CAT_ID = rsQr("CAT_ID" so I fixed that ;-)
It's now complaining of a syntax error in line 50 ( set rsQr = my_conn.execute (strSql) ) and says an "operator" is missing in the expression " 'TOPIC_ID=' "...I'll try to figure it out, but if you see what the problem might be, let me know ;-)
Updated link - http://www.gpspassion.com/forumsen/pda_qr.asp?TOPIC_ID=2236
Updated code - http://www.gpspassion.com/forumsen/pda_qr.zip
PS - Thanks for pointing out that I had the sub twice, I'd fixed that in the meantime.
Sorry about the missing parenthesis, man. It's so obvious, I can't see how I did it.
I apologize as well about the other problem. I built this code for post_info.asp and only then I decided that you should use it in pdq_qr.asp, and that's where the code fails.
Change the code to this:
strSql = "SELECT CAT_ID FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & CLng(Request.QueryString("TOPIC_ID"))
set rsQr = my_conn.execute (strSql)
If not rsQr.EOF Then
CAT_ID = rsQr("CAT_ID")
End If
rsQr.Close
set rsQr = nothing
Try this and let me know how it goes.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
gpspassion
Junior Member
260 Posts |
Posted - 25 June 2003 : 06:48:45
|
Gotta run, but yes it works, thanks so much!
It even redirects me to the pda_qr. I just need to get it to skip the "New Reply Posted" screen and maybe add a little login box and also lighten up the QR code and it's done,
thanks again! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
