[Done 1.5.1 > 1.5.4] Add More Smilies 2.1

[Rpg Cyco]

I have the Yesterday mod installed, and the Mute Users Mod.... Thats it.... I don't know how to enter anything manually into tables in phpMyAdmin

l8ter

Rpg Cyco

[Delinquently insane]

Works Fine For Me Havent Noticed The IM Bug Though  .. Rpgcyco Here Check This


1) open php my admin
2) go to perspective db your using
3) Look For A Window That Says Run Sql Queries Either Copy This:

Code Select Expand


CREATE TABLE {$db_prefix}smilies (id INT DEFAULT '0' NOT NULL AUTO_INCREMENT, code TEXT NOT NULL,url TEXT NOT NULL,PRIMARY KEY (id),UNIQUE (id)) TYPE = MYISAM COMMENT = 'Smilies Table';")

INSERT INTO {$db_prefix}settings (variable, value) VALUES ('vbsmiliesEnable', '1')


INSERT INTO {$db_prefix}settings (variable, value) VALUES ('orderEnable', '0')

INSERT INTO {$db_prefix}settings (variable, value) VALUES ('hdetach', '200')

INSERT INTO {$db_prefix}settings (variable, value) VALUES ('wdetach', '290')

And Paste It into The Window

4)) If You Havent Tried. Run The Smiliesdbmod.php from your browser

[Rpg Cyco]

Thanks! I owe you one! I'll try this soon! Oh and I did execute smiliesdbmod, but it seemed to only create the yabbse_smilies table

l8ter

Rpg Cyco

[Rpg Cyco]

When I run it I get this

Code Select Expand

SQL-query :  

")

INSERT INTO yabbse_settings (variable, value) VALUES ('vbsmiliesEnable', '1')

INSERT INTO yabbse_settings (variable, value) VALUES ('orderEnable', '0')

INSERT INTO yabbse_settings (variable, value) VALUES ('hdetach', '200')

INSERT INTO yabbse_settings (variable, value) VALUES ('wdetach', '290')

MySQL said:


You have an error in your SQL syntax near '")

INSERT INTO yabbse_settings (variable, value) VALUES ('vbsmiliesEnable', '' at line 1

Yes I did change the {$db_prefix} to the one I use, which is yabbse_ Anymore help

l8ter

Rpg Cyco

[Ironman]

I deleted my whole board this morning, installed YaBBSE new and installed that great Mod with BoardModSE.

And what happens? It all went correctly!  

So, I learned: On an empty, 'fresh', completely unmodified or in any way changed Board it's so easy to install. Very good!

Well, really a great Job. Thanx, Big P

This isn't a question or a bug, it's just a comment.
 

[jerek]

installed it on two boards, and it tests and installs with no errors, but then the option isn't there on the Admin page to Add More Smilies.

I got to the Installed Mods Settings page and this is what I see at the bottom. Just two checkboxes and two textboxes, no text.


Any ideas?  (Installing the .yp file through the YabbPak center, not BoardMod.)

seems like you're not using english.lng as your language file. check what the mod changed in it and add it manually in your language file and it should work.

[jerek]

I have in error in Post.php:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in c:\easyphp\www\yabb\Sources\Post.php on line 908



Fatal error: Call to undefined function: printpostbox() in c:\easyphp\www\yabb\Sources\Post.php on line 177


that's the line 908:

if($modSettings['vbsmiliesEnable'] == '1')

from sequence:

print <<<EOT
</td>
</tr>
<tr>
  EOT;
if($modSettings['vbsmiliesEnable'] == '1')
{
print <<<EOT
<td valign=top align="right"><font size=2><b>$txt[72]:</b></font><br><br><center><table border="0" cellpadding="0" width="18%">
  <tr>
    <td width="100%" colspan="3"><p align="center"><font size="2"><b>$asmtxt[10]</b></font></td>

i write manually 5 times !
all others functions works (admin etc...)

remove the space in front of EOT;

[Zorg]

 
a beginner's error ! lol
thx

[Delinquently insane]

Code Select Expand

")

INSERT INTO yabbse_settings (variable, value) VALUES ('vbsmiliesEnable', '1')

INSERT INTO yabbse_settings (variable, value) VALUES ('orderEnable', '0')

INSERT INTO yabbse_settings (variable, value) VALUES ('hdetach', '200')

INSERT INTO yabbse_settings (variable, value) VALUES ('wdetach', '290')

MySQL said:


You have an error in your SQL syntax near '")

INSERT INTO yabbse_settings (variable, value) VALUES ('vbsmiliesEnable', '' at line 1
 



Your Missing A Statement There It Should Be

CREATE TABLE {$db_prefix}smilies (id INT DEFAULT '0' NOT NULL AUTO_INCREMENT, code TEXT NOT NULL,url TEXT NOT NULL,PRIMARY KEY (id),UNIQUE (id)) TYPE = MYISAM COMMENT = 'Smilies Table';")

where you have ")  Hope That Helps  One More Thing If You Have Already Made The Table Remove The ")

[Tha Master]

Ive posted this before but does somebody now this:

 It seems there's a problem in my post.php
=>if i test the mod it says he dident found this:
function printPostBox($msg)
{
  global $txt,$enable_ubbc,$showyabbcbutt,$imagesdir,$ubbcjspath;

But it is in my script: see: http://forumekes.little-cherry.com/yabbse/Sources/Post.php

[GreyDog]

Have you removed the file to update it again...I cant seem to find it?  your links are dead..

[Ben_S]

doesnt seem to work when your modifying a post, gives an error on page...

[David]

Has the zip moved?  The link in the first post does not work.

[Rpg Cyco]

mcguire: Ok, thanks i'll try it when my host comes back online... Its been off all day!

David: Hhhhmm, I get 404 also, so I emailed you the mod

l8ter

Rpg Cyco

[David]

For the time being I have attached it.