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)
-   -   Change the display order of smilies (https://vborg.vbsupport.ru/showthread.php?t=25888)

smx 06-06-2003 07:00 AM

gthell I installed it on VB3.0 .. got the same error ...


Replace:
PHP Code:

// ###################### Start do order #####################
if ($HTTP_POST_VARS['action']=="doorder") {
while (list(
$key,$val)=each <http://www.php.net/each>($order)) {
$DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'");
}

echo 
"<p>Order updated!</p>";
$action="modify";



With:
PHP Code:

// ###################### Start do order #####################
if ($HTTP_POST_VARS['action']=="doorder") {
while (list(
$key,$val)=each ($order)) {
$DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'");
}

echo 
"<p>Order updated!</p>";
$action="modify";



I also got an error on line 262, but this was due to spaces ...
Try removing all spaces between lines ! ;)

Linus 06-10-2003 02:17 AM

The order seems to be changed only in the Admin CP and when Users post replies/new threads. However when clicking on more smilies the order is not updated.

electrolov 06-21-2003 01:37 PM

Quote:

05-26-03 at 11:11 AM gthell said this in Post #150
Im running 2.30 and this is what i get. I checked 4+ times too.

PHP Code:

Parse errorparse errorunexpected '{' in /home/valider/public_html/forum/admin/smilie.php on line 269 

the code in smilie.php:
PHP Code:

if ($HTTP_POST_VARS['action']=="doorder") {

??while (list(
$key,$val)=each($order)) {

????
$DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'");

??} 

??echo 
"<p>Order updated!</p>";

??
$action="modify";


i tried everything that was posted b4 me and still get that error....please help :(

had same error line, i deleted space from start of line to code on lines 269, 270,273.

might help if u delete the "?"'s in yr code.

DeeperImage 07-03-2003 06:13 PM

I installed it on 2.3.0 and i got no errors, but it will not accept the order commands. I keep hitting update and everything and no changes. When i first installed it some of them worked but thats it.. What can i do?

JonUrban 07-16-2003 02:36 AM

I just installed this on 2.3.0. I got the sucess message, but I cannot see anywhere to assign the smile order? Does that mean I screwed it up, or is it operator malfunction?

Thanks

Oblivion Knight 07-16-2003 06:46 AM

Quote:

06-10-03 at 04:17 AM Linus said this in Post #152
The order seems to be changed only in the Admin CP and when Users post replies/new threads. However when clicking on more smilies the order is not updated.
This was answered in Post #96.. ;)

https://vborg.vbsupport.ru/showthrea...173#post251173

Host Directory 07-16-2003 10:22 PM

I am not sure what you mean Jon, i updated my forum from 2.2.9 to 2.3.0 and this hack works fine for me.

Was you upgrading your forum when you got the problem?

You can see this hack working at www.hostcompanies.com/forums (vb version 2.3.0)

JonUrban 07-17-2003 12:43 AM

Quote:

Today at 12:22 AM Host Directory said this in Post #157
I am not sure what you mean Jon, i updated my forum from 2.2.9 to 2.3.0 and this hack works fine for me.

Was you upgrading your forum when you got the problem?

You can see this hack working at www.hostcompanies.com/forums (vb version 2.3.0)

It worked. I just did not realize that I had to go into MySQL and modify the tables. I thought there might be a way to do it in the vBulliten Control Panel.

Anyway, I did it through MySQL, moved the ID numbers around, and all is well. Thanks to all for the help and the hack!

:-jon

DeeperImage 07-17-2003 02:59 AM

Quote:

Today at 09:43 PM JonUrban said this in Post #158
It worked. I just did not realize that I had to go into MySQL and modify the tables. I thought there might be a way to do it in the vBulliten Control Panel.

Anyway, I did it through MySQL, moved the ID numbers around, and all is well. Thanks to all for the help and the hack!

:-jon


Jon,
Would you be kind enough to tell us exactly what you did in there? thanks.

JonUrban 07-17-2003 03:11 AM

Quote:

Today at 04:59 AM DeeperImage said this in Post #159
Jon,
Would you be kind enough to tell us exactly what you did in there? thanks.

Sure! Bear in mind that I am a TOTAL ROOKIE at this, I have a slight amount of experience with Microsoft SQL, but I have never used any web based stuff at all.

I applied the hack using the second option and got the success message.

Then, I used phpMyAdmin (which is software provided by my web hosting company), selected 'database', then the 'forum' database. I was then presented with a list of tables in the database. I selected the "smilie" table, browsed it, and edited the following 2 fields until they were in the order I needed. "Smilieid" and "showid".

I renumbered the ones that I wanted to move (i.e. 12,13,14,15) to numbers out of my range, them renumbered the ones I wanted to make 12,13,14,15, and finally renumbered the temporary numbered ones back to the former numbers of the ones I moved.

This may be a round about, convaluted way to do this, but it worked!!

:-jon


All times are GMT. The time now is 05:23 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.01297 seconds
  • Memory Usage 1,759KB
  • 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
  • (4)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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