Twitter SMFHacks Facebook SMFHacks SMFHacks.com
** Home Forum Index Hacks Products Login Register Search
Welcome, Guest. Please login or register.
May 19, 2013, 06:02:43 pm

Login with username, password and session length
Members
Total Members: 10758
Latest: murdocklawless
Stats
Total Posts: 32349
Total Topics: 5474
Online Today: 60
Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Users: 0
Guests: 35
Total: 35
+ 
|-+ 
| |-+ 
| | |-+ 
| | | |-+ 
| | | | |-+ 
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: 1 ... 5 6 [7] Go Down Print
Author Topic: [Mod] Tagging System  (Read 72890 times)
dazzledark
Inline PM Customer
*****
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
Inline PM Customer
*****
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
Inline PM Customer
*****
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: 10987


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

Would be in Tags.php in the Sources folder
Logged
mmarak524
Inline PM Customer
*****
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: 10987


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
Inline PM Customer
*****
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 07:03:27 am]

[May 16, 2013, 10:13:46 pm]

[May 15, 2013, 11:32:14 pm]

[May 15, 2013, 11:31:24 pm]

[May 12, 2013, 09:10:43 am]

[May 10, 2013, 03:49:55 am]

[May 07, 2013, 07:12:40 pm]

[May 07, 2013, 02:37:14 pm]

[May 06, 2013, 10:29:56 pm]

[May 04, 2013, 03:22:01 pm]
Random Picture
Donate to SMFHacks.com
Help Support the SMFHacks.com mod making.
Powered by SMF 1.1.18 | SMF © 2013, Simple Machines
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 1.34 seconds with 21 queries.