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)
 Add/Edit/Delete Smile code (Updated Dec 8- Done)
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 5

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 December 2000 :  19:23:14  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I added smiles_mod.txt in the top thread for those of you that wish to test it around other mods.

I warn you though, make sure you back up your files! I'm not responsible.

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page

mot
New Member

United Kingdom
70 Posts

Posted - 07 December 2000 :  20:03:00  Show Profile  Visit mot's Homepage
Getting there I think, now have error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'id' must include a data type.

/forumtest/create_smile_table.asp, line 53


Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 08 December 2000 :  09:15:51  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
thats wierd... I'm pretty **** sure I made it work the way it should....

I'll have to look at it when I get home from school, I think I might know what it is. (maybe I spelled it wrong LOL)

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 08 December 2000 :  16:01:32  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Okey dokey, I forgot to specify a field type (like the error said, SQL server needs more details than access I guess)

It should work now, The new code I replaced is below (I also added it to the download, but I dont know if you wanna re-download the entire thing for just these few lines of code)<img src=icon_smile.gif border=0 align=middle>

If any of you guys spots an error, let me know.

<font color=red>Replace:</font id=red>
<pre id=code><font face=courier size=2 id=code>
if strDBType="access" then
strsql = "CREATE TABLE admin_smiles (id COUNTER, smile_url VARCHAR(25), smile_code VARCHAR(10), smile_name VARCHAR(20))"
my_conn.execute(strsql)
elseif strDBType="sqlserver" then
strsql = "CREATE TABLE admin_smiles (id IDENTITY(1, 1), smile_url VARCHAR(25), smile_code VARCHAR(10), smile_name VARCHAR(20))"
my_conn.execute(strsql)
end if
</font id=code></pre id=code>
<font color=red>with this</font id=red>
<pre id=code><font face=courier size=2 id=code>
if strDBType="access" then
strsql = "CREATE TABLE admin_smiles (id COUNTER, smile_url VARCHAR(25), smile_code VARCHAR(10), smile_name VARCHAR(20))"
my_conn.execute(strsql)
elseif strDBType="sqlserver" then
strsql = "CREATE TABLE admin_smiles (id int IDENTITY (1, 1), smile_url VARCHAR(25), smile_code VARCHAR(10), smile_name VARCHAR(20))"
my_conn.execute(strsql)
end if
</font id=code></pre id=code>

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.

Edited by - da_stimulator on 08 December 2000 16:04:33
Go to Top of Page

mot
New Member

United Kingdom
70 Posts

Posted - 08 December 2000 :  21:47:44  Show Profile  Visit mot's Homepage
Geting further dorwn the script <img src=icon_smile.gif border=0 align=middle>
New error <img src=icon_smile_sad.gif border=0 align=middle>
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

/forumtest/create_smile_table.asp, line 151




Edited by - mot on 08 December 2000 21:50:53
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 08 December 2000 :  22:01:02  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Shoulda seen that one coming...

Trying to enter more data than allowed into the table. Ok, this should be the final Fix, download http://forums.aokingdom.com/fix_SQL.zip and execute the file in it, ONLY ONCE. It deletes the table (since it was already created) and fixes the problem, hopefully this will work, if Not I will need to consent my very helpful Huwr on some coding help :)

Good luck.

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 09 December 2000 :  08:09:32  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
If you enter a full url e.g. http://www.edevboards.com/images/smilies/viking.gif will the corresponding image be shown?

I tried on the test board but the text box was limited in size.

Podge
-----------------------
www.thehungersite.com
Click to donate free food.
Go to Top of Page

isuru
Junior Member

464 Posts

Posted - 09 December 2000 :  12:18:00  Show Profile
<img src=icon_smile_cool.gif border=0 align=middle> WOW. I checked out the test site.

This mood is COOL

-=-=-=-=-=-=-=-
Isuru Amarasena <img src=icon_smile_big.gif border=0 align=middle>
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 09 December 2000 :  13:25:07  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I put a limit on it so the images must be local, That way there wont be any 'broken' images if the site you link to is down or they delete the smile <img src=icon_smile.gif border=0 align=middle>

Thx isuru :)

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20587 Posts

Posted - 09 December 2000 :  14:06:41  Show Profile  Visit HuwR's Homepage
Nice one,

I only have one comment, it may be better to page the table and nest the add smilie table underneath the other one, it looks a bit odd sitting at the side like that.


Also the script error has come back on your site. I think it may be IE5.0 specific.

<font color=blue>'Resistance is futile'</font id=blue>
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 09 December 2000 :  14:13:42  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
No, I removed it on my main forums, Just didnt take it off my test forums :)

Thats a good Idea, People with 800x600 probably cant see that one pretty well...

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page

tilttek
Junior Member

Canada
333 Posts

Posted - 11 December 2000 :  15:42:01  Show Profile  Visit tilttek's Homepage
If you could hade Category... It sould be nice... Adding speed when you load the Smilly page.


Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 11 December 2000 :  15:45:34  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
what do you mean by category<img src=icon_smile_question.gif border=0 align=middle>

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page

tilttek
Junior Member

Canada
333 Posts

Posted - 11 December 2000 :  16:02:46  Show Profile  Visit tilttek's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
what do you mean by category<img src=icon_smile_question.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Some configurable categories. So we can divide the smily in pop_icon_legend.asp.
Exemple:
Normal
Animated
War
Frendly
Sci-Fi
Big

So when we have MANY smile you don't display all at the same time.


You can refer to http://forum.snitz.com/forum/link.asp?TOPIC_ID=2259




Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 11 December 2000 :  16:15:50  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I hadnt thought of that... I honestly see no point in adding categories to it.

Thoughts anyone?

<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07