SMFHacks.com
** Home Forum Index Hacks Products Login Register Search
Welcome, Guest. Please login or register.
May 24, 2012, 07:25:49 am

Login with username, password and session length
Members
Total Members: 10071
Latest: cdavidson012
Stats
Total Posts: 28686
Total Topics: 4977
Online Today: 55
Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Users: 2
Guests: 51
Total: 53
+ 
|-+ 
| |-+ 
| | |-+ 
| | | |-+ 
| | | | |-+ 
0 Members and 3 Guests are viewing this topic. « previous next »
Pages: 1 ... 5 6 [7] Go Down Print
Author Topic: [Mod] Tagging System  (Read 67008 times)
dazzledark
Newbie
*
Offline Offline

Posts: 3


View Profile
« Reply #90 on: May 08, 2010, 03:50:53 pm »

http://www.meydangorusu.com/forum/index.php?action=tags

Invalid use of group function
Dosya: /vhosts/meydangorusu.com/http/forum/Sources/Tags.php
Satır: 106

how can i fix this_?

Hello,

i have same error, what can i do?

Thank you & nice WE

nico
bilgi@meydangorusu.com this is my msn addresse. add me, i will help you.
Logged
poorfool
Newbie
*
Offline Offline

Posts: 1


View Profile
« Reply #91 on: April 17, 2011, 06:47:32 am »

Hi,
I just installed it but there is no text on the posting page near the form because im not using english as default,
i dont need to translate it.. just how i can see the original english version on another language set?
the problem other that how is if i touch the source ill f*ck up somewhere when installing other mod or such,
any help?
Logged
mmarak524
Newbie
*
Offline Offline

Posts: 3


View Profile
« Reply #92 on: April 26, 2011, 12:52:07 pm »

I was wondering if you tell me how I can change the cloud to be sort by alpha?  I am not sure what part of the coding controls the displace on the tag link.

 
Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #93 on: April 26, 2011, 12:55:39 pm »

Would be in Tags.php in the Sources folder
Logged
mmarak524
Newbie
*
Offline Offline

Posts: 3


View Profile
« Reply #94 on: April 26, 2011, 01:27:12 pm »

Wow that was quick.   Grin


Okay I am looking through that, but I am new to php so I don't know all the language yet.   But from what little I have been able to learn, I would be looking at this section of the code right?

Code:
SELECT
t.tag AS tag, l.ID_TAG, COUNT(l.ID_TAG) AS quantity
FROM {db_prefix}tags as t, {db_prefix}tags_log as l WHERE t.ID_TAG = l.ID_TAG
  GROUP BY l.ID_TAG
  ORDER BY COUNT(l.ID_TAG) DESC, RAND() LIMIT " .  $modSettings['smftags_set_cloud_tags_to_show']);


would this then work to get it to go in alpha order?

Code:
SELECT
t.tag AS tag, l.ID_TAG, COUNT(l.ID_TAG) AS quantity
FROM {db_prefix}tags as t, {db_prefix}tags_log as l WHERE t.ID_TAG = l.ID_TAG
  GROUP BY l.ID_TAG
  ORDER BY l.ID_TAG DESC, RAND() LIMIT " .  $modSettings['smftags_set_cloud_tags_to_show']);


Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #95 on: April 26, 2011, 01:32:16 pm »

Change
  ORDER BY l.ID_TAG DESC
To
  ORDER BY t.tag ASC
Logged
mmarak524
Newbie
*
Offline Offline

Posts: 3


View Profile
« Reply #96 on: April 26, 2011, 01:35:38 pm »

yea! that worked.  You are so wonderful.  Thank you show much!
Logged
Pages: 1 ... 5 6 [7] Go Up Print 
« previous next »
Jump to:  

Recent
[Today at 04:11:41 am]

[Today at 12:16:16 am]

[May 21, 2012, 08:54:11 am]

[May 20, 2012, 11:06:52 am]

[May 20, 2012, 05:58:11 am]

[May 19, 2012, 06:16:58 pm]

[May 19, 2012, 05:42:37 pm]

[May 18, 2012, 03:08:38 pm]

[May 17, 2012, 06:07:46 pm]

[May 17, 2012, 02:22:07 pm]
Random Picture
Donate to SMFHacks.com
Help Support the SMFHacks.com mod making.
Powered by SMF 1.1.16 | SMF © 2006-2011, Simple Machines LLC
TinyPortal v0.9.7 © Bloc
SMF and SimpleMachines are registered trademarks of Simple Machines. SMFHacks.com is not affiliated with nor endorsed by Simple Machines.
Page created in 4.732 seconds with 20 queries.