Author |
Topic  |
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 07 December 2000 : 19:23:14
|
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. |
 |
|
mot
New Member

United Kingdom
70 Posts |
Posted - 07 December 2000 : 20:03:00
|
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
|
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 08 December 2000 : 09:15:51
|
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. |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 08 December 2000 : 16:01:32
|
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 |
 |
|
mot
New Member

United Kingdom
70 Posts |
Posted - 08 December 2000 : 21:47:44
|
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 |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 08 December 2000 : 22:01:02
|
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. |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
Posted - 09 December 2000 : 08:09:32
|
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. |
 |
|
isuru
Junior Member
 
464 Posts |
Posted - 09 December 2000 : 12:18:00
|
<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> |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 09 December 2000 : 13:25:07
|
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. |
 |
|
HuwR
Forum Admin
    
United Kingdom
20587 Posts |
Posted - 09 December 2000 : 14:06:41
|
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> |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 09 December 2000 : 14:13:42
|
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. |
 |
|
tilttek
Junior Member
 
Canada
333 Posts |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 11 December 2000 : 15:45:34
|
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. |
 |
|
tilttek
Junior Member
 
Canada
333 Posts |
Posted - 11 December 2000 : 16:02:46
|
<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 |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 11 December 2000 : 16:15:50
|
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. |
 |
|
Topic  |
|