| Author |
 Topic  |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 24 December 2000 : 19:15:48
|
for now... I dont know whats causing that..... or..... YES I DO, it just popped into my head.
I have it paging them wrong, after the first row, it starts again with the last record of the first row into the second row... hold on a second, gettin the fix :)
<font color=red>Da_Stimulator</font id=red>
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me |
 |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 24 December 2000 : 19:19:57
|
okey dokey... I dunno whats gonna fix this, but try the following...
Replace
<pre id=code><font face=courier size=2 id=code> If totalrecordcount mod 2 = 0 then
strCount1 = totalrecordcount / 2
strCount2 = strCount1
else
strCount1 = (totalrecordcount / 2) + 0.5
strCount2 = strCount1 - 1
end if</font id=code></pre id=code>
With
<pre id=code><font face=courier size=2 id=code><s>
If totalrecordcount mod 2 = 0 then
strCount1 = totalrecordcount / 2
strCount2 = strCount1
else
strCount1 = (totalrecordcount / 2) + 1.5
strCount2 = (totalrecordcount / 2) - 0.5
end if
</s></font id=code></pre id=code>
<font color=red>Da_Stimulator</font id=red>
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me
[edited by admin on 01/04/2001] |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 24 December 2000 : 19:21:09
|
No, dont do that, try this instead
<pre id=code><font face=courier size=2 id=code>
If totalrecordcount mod 2 = 0 then
strCount1 = totalrecordcount / 2
strCount2 = strCount1
else
strCount1 = (totalrecordcount / 2) - 1.5
strCount2 = strCount1 + 1
end if
</font id=code></pre id=code>
<font color=red>Da_Stimulator</font id=red>
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 29 December 2000 : 15:48:00
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Try changing
if not (drs.eof or drs.bof) then
To
if not(drs.eof or strCount2 = 0) then
<font color=red>Da_Stimulator</font id=red>
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The solution is
here
ô¿~
Edited by - frankie on 29 December 2000 15:52:34
[edited by admin on 01/04/2001] |
|
|
|
master of puppets
Junior Member
Canada
117 Posts |
Posted - 09 January 2001 : 23:24:41
|
When I put that code into inc_top.asp the bar at the bottom of the screen with the copyright on it, goes to the right side of the screen, squashing everything. What's going on?
"If I close my mind in fear, Please pry it open" - Metallica |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 January 2001 : 05:17:10
|
Does anyone have the complete code for this - with bug fixes ??????
|
|
|
|
Hari Seldon
New Member
Italy
67 Posts |
Posted - 10 January 2001 : 15:48:16
|
Hello, I've installed the 3.1 SR4 (with all mod - post by HuwR) and the "Manage Smilies" is great, but I've added a new category with 27 new smile.
Now when I post a message and I open the smile legend window I receive this message :
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/fond2/forum/pop_icon_legend.asp, line 168
this message is for the new category, and this message is for the default category :
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/fond2/forum/pop_icon_legend.asp, line 133
You can try my board at http://www.larry.it/fodn2/forum/default.asp
THANK YOU
P.S. : Where I can find the release with all bug fixes  ?
Edited by - hari seldon on 10 January 2001 15:49:33 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 January 2001 : 16:02:32
|
Use the bug fix that was posted previously to fix that, I still have to put it into the final code...
Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me |
|
|
|
Hari Seldon
New Member
Italy
67 Posts |
Posted - 10 January 2001 : 16:33:51
|
I've look the bug fix of Frankie.(replace drs.PageSize = strCount2 to
drs.PageSize = strCount1 but in my version I've just drs.PageSize= strCount1) but I've this error message first of smile display :
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/fond2/forum/pop_icon_legend.asp, line 133
What can I do to fix ?
Edited by - hari seldon on 10 January 2001 17:43:45 |
|
|
|
Hari Seldon
New Member
Italy
67 Posts |
Posted - 11 January 2001 : 09:13:26
|
Anyone can visit my site, try to post with icon smile, look the error in icon_post_legend.asp and tell me the solution ?
http://www.larry.it/fond2/forum
THANK YOU !!!
Edited by - hari seldon on 11 January 2001 12:03:01
Edited by - hari seldon on 11 January 2001 17:13:07 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 12 January 2001 : 18:34:24
|
Ok, I found Hari's problem, don't know why it has not been noticed, anyway in pop_icon_legend.asp look for this line
strsql = strsql & "WHERE " & strTablePrefix & "SMILES.CAT_ID>" & 0
This is wrong, it uses this count to work out the page size for your smilies, so lets say you have 40 smilies, 30 in cat1 and 10 in cat2 it sets the column sizes for both categories to 15 ? not correct.
change the line to read
strsql = strsql & "WHERE " & strTablePrefix & "SMILES.CAT_ID=" & request.querystring("cat_id")
Next problem, if you have only 1 smilie in a category, it will error when trying to write the second column.
To fix this, find this code
drs.AbsolutePage = 2
Do until strTempCount = strCount2
smile_name = drs("smile_name")
smile_url = drs("smile_url")
smile_code = drs("smile_code")
%>
<tr>
<td bgcolor="<% =strForumCellColor %>"><a href="Javascript:insertsmilie('[<%=smile_code%>]');"><img border="0" hspace="10" src="images/<%=smile_url%>"></a></td>
<td bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><%=smile_name%></font></td>
<td bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">[<%=smile_code%>]</font></td>
</tr>
<%
strTempCount = strTempCount + 1
drs.movenext
loop
and change it to this
if strcount2 > 0 then
drs.AbsolutePage = 2
Do until strTempCount = strCount2
smile_name = drs("smile_name")
smile_url = drs("smile_url")
smile_code = drs("smile_code")
%>
<tr>
<td bgcolor="<% =strForumCellColor %>"><a href="Javascript:insertsmilie('[<%=smile_code%>]');"><img border="0" hspace="10" src="images/<%=smile_url%>"></a></td>
<td bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><%=smile_name%></font></td>
<td bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">[<%=smile_code%>]</font></td>
</tr>
<%
strTempCount = strTempCount + 1
drs.movenext
loop
end if
'Resistance is futile' |
|
|
|
Hari Seldon
New Member
Italy
67 Posts |
Posted - 12 January 2001 : 19:07:34
|
Tnx Huwr, now works very well 
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 12 January 2001 : 19:51:04
|
Ok... sorry I havnt been keeping up with this, but I've been rather busy. Thx huwr for supplying support :)
Anyway, over this weekend, or if I dont have time with work and all (I'm off sunday, so I should have time), I'll Put all the bug fixes in and re-release it.
I recommend waiting for me to re-do it before downloading it if you havnt already.
Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me |
|
|
|
Hari Seldon
New Member
Italy
67 Posts |
Posted - 14 January 2001 : 13:36:11
|
No, I'm here another time !!! I'm the nightmare of this mod !!
Ok guys, I use a lot of smiles and I made 2 new categories, but ... BUT ... yes another BUT  ... another bug I found on this mod (please Huwr don't kill me  ).
Some smiles in smile legend was display two times instead one 
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 14 January 2001 : 13:39:35
|
Thats not really a bug. all the default smiles are entered in the database twice for compatibility... for example, so the will work with both lowercase :p and uppercase :P
Da_Stimulator
Stimmy's Forums - Using 3.1 SR3
"We all die someday, but your goin down before I do" - Me |
|
|
|
Topic |
|
Topic Locked
