vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vBmoods 1.0 (https://vborg.vbsupport.ru/showthread.php?t=41883)

isman 09-30-2002 06:58 PM

Ok, I followed your directions to the letter and I'm also getting the SQL error when trying a new post.
Quote:

Database error in vBulletin 2.2.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,MOOD,allowsmilie,showsignature ,ipaddress,iconid,visible,usermoodid,usermoodpath, usermoodmessage) VALUES (NULL,'3024','Testing Mood Hack','Mr. Snuffaluffagus','25','1033415622','0','What does this look like?','','1','0','134.215.235.175','0','1','5','i mages/moods/smile.gif','')
mysql error: Unknown column 'MOOD' in 'field list'

mysql error number: 1054

Date: Monday 30th of September 2002 03:53:42 PM
Script: http://www.aparentsheart.com/bbtest/.../newthread.php
Referer: http://www.aparentsheart.com/bbtest/newthread.php
Any suggestions?

I verified the tables were created and modified correctly.

isman 10-01-2002 02:38 AM

Sorry, had some remnants of a previous mood hack in there.

*slinks over to hit the install button*

Pancreas Paul 10-07-2002 03:06 PM

umm, were is the mood icons? I dont have them. Help.

Velocd 10-08-2002 12:26 AM

There are none provided, you have to go through the incredible journey of finding them yourself :p

A good set to use is Dark Project Studios smilies for your moods, but you have to ask him permission first. Just click on the link in vBulletin.org footer.

yzztik 10-09-2002 06:28 PM

Could we just use some our current smilies? If I change the code to point to images/smilies instead of images/mood then I can use those, right? But my questions is, where it says "add modd" is that like the "add smilie" that even though there may be tons in the folder, you can still decide which to use, right? Because if that is the case I will just use some of my current smilies and not go hunting for more :)

Sinzar 10-09-2002 10:37 PM

Database error in vBulletin 2.2.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmili e,showsignature,ipaddress,iconid,visible,usermoodi d,usermoodpath,usermoodmessage
) VALUES (NULL,'267','','Matrix','1','1034206747','0','test ing','1','1',''24.103.236.179' ,'0','1','1','images/moods/cry2.gif',''
)
mysql error: You have an error in your SQL syntax near '24.103.236.179','0','1','1','images/moods/cry2.gif',''
)' at line 2

mysql error number: 1064

what do I do?

Joe Page 10-17-2002 08:32 PM

I'm using vB 2.2.8 and the last edit isn't there, please help (I'm referring to the postbit edit, the code which you have to edit is not there)

Dynamic One 11-10-2002 06:29 PM

Thanks m8. Nice job. Can sure use it :).

teenfront 11-11-2002 03:19 PM

great hack is it possible to make it so that although custom mood text is not entered the text from the drop down appears alongside the smilie?

cheers,
n

Crazy Pete 12-09-2002 06:49 PM

I get parse errors on the very first step installing this on v 2.2.9. You have:

Code:

//highlight words for search engine
And add above:

Code:

/////////__vBmood by Velocd__/////////



if($post[usermoodid]){

eval("\$postmood = \"".gettemplate("postbit_mood")."\";");_}



/////////__vBmood by Velocd__/////////

I do that, and get a parse error on line 315, which happens to be eval("\$postmood = \"".gettemplate("postbit_mood")."\";");_}. Not sure what to do now, so I had to uninstall it. Looks really nice, though. :(


All times are GMT. The time now is 08:02 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01098 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete