![]() |
Seems this mod needs some work doing to make it easier and more compatiable and maybe someone who speaks english to help out too!
|
yeah some customization would make this the perfect mod :) also the links to the mp3's should be our domain not the modder's domain.
|
I had download this updated XLM file got this error:
Database error in vBulletin 3.5.4: Invalid SQL: ### INSERT QUERY GENERATED BY fetch_query_sql() ### INSERT INTO plugin (`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`) VALUES ('1', '5', 'vBmusic Count Song, Album, Singer, List US IN singer, Threads, Posts, Total Onlines, Registed', 'global_start', '\r\n // Song Count Copyright by TuNguyen vi3t4lov3@yahoo.com\r\n$song_count_sql = $db->query_read(\"\r\n SELECT\r\n COUNT(id) as count\r\n FROM \" . TABLE_PREFIX . \"music_song LIMIT 1\");\r\n\r\n$song_count_sql_row = $db->fetch_array($song_count_sql);\r\n$vBmsongs = $song_count_sql_row[\'count\'];\r\n\r\n// Album Count Copyright by TuNguyen vi3t4lov3@yahoo.com\r\n$album_count_sql = $db->query_read(\"\r\n SELECT\r\n COUNT(id) as count\r\n FROM \" . TABLE_PREFIX . \"music_album LIMIT 1\");\r\n\r\n$album_count_sql_row = $db->fetch_array($album_count_sql);\r\n$vBmalbums = $album_count_sql_row[\'count\'];\r\n\r\n// Album Artist Copyright by TuNguyen vi3t4lov3@yahoo.com\r\n$artist_count_sql = $db->query_read(\"\r\n SELECT\r\n COUNT(id) as count\r\n FROM \" . TABLE_PREFIX . \"music_artist LIMIT 1\");\r\n\r\n$artist_count_sql_row = $db->fetch_array($artist_count_sql);\r\n$vBmartists = $artist_count_sql_row[\'count\'];\r\n // Users Registered Today\r\n\r\n $now = TIMENOW - intval($vboptions[\'hourdif\']); \r\n $cutoff = mktime(0, 0, 0, date(\'m\', $now), date(\'d\', $now), date(\'Y\', $now)); \r\n //$cutoff = $now - 86400 ; // Uncomment this line if you want a rolling 24 hours display \r\n $todaysregs = $db->query(\"SELECT userid, joindate, options, username, opentag, closetag, posts \r\n FROM \" . TABLE_PREFIX . \"user as user \r\n LEFT JOIN \" . TABLE_PREFIX . \"usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid) \r\n WHERE joindate > \" .$cutoff. \" ORDER BY username\" ); \r\n\r\n unset ($regtoday); \r\n $vBmregtoday = 0; \r\n while ($today = $db->fetch_array($todaysregs)) \r\n { \r\n $today[visible] = 1 ;\r\n $vBmregtoday += 1;\r\n //$useroptions = convert_bits_to_array($today[\'options\'] , $vbulletin->bf_misc_useroptions);\r\n if ($today[options] & $vbulletin->bf_misc_useroptions[\'invisible\']) \r\n {\r\n $today[visible] = 0 ;\r\n if (($permissions[\'genericpermissions\'] & $vbulletin->bf_ugp_genericpermissions[\'canseehidden\']) OR $today[\'userid\'] == $vbulletin->userinfo[\'userid\']) \r\n { \r\n $today[visible] = 2 ; \r\n } \r\n } \r\n if ($today[visible]) \r\n { \r\n $regtoday .= \"<a href=\'member.php?u=$today[userid]\'>\"; \r\n if ($today[visible] == 2) \r\n { \r\n $regtoday .= \"$today[opentag]$today[username] ($today[posts] $vbphrase[posts])$today[closetag]</a>*, \"; \r\n } \r\n else \r\n { \r\n $regtoday .= \"$today[opentag]$today[username] ($today[posts] $vbphrase[posts])$today[closetag]</a>, \"; \r\n } \r\n } \r\n } \r\n if ($regtoday) \r\n { \r\n $regtoday = substr($regtoday, 0, strlen($regtoday)-2); \r\n } \r\n else\r\n {\r\n $regtoday = \"There have been no new registrations today.\";\r\n }\r\n\r\n// End Users Registered Today\r\n// forum stats start number of threads, posts\r\n$numbersmembers = $db->query_first(\"SELECT COUNT(*) AS users,MAX(userid) AS max FROM \" . TABLE_PREFIX . \"user\"); \r\n$vBmmembers = number_format($numbersmembers[\'users\']); \r\n$counter = $db->query_first(\"SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM \" . TABLE_PREFIX . \"post\"); \r\n$vBmposts=number_format($counter[\'posts\']); \r\n$countthreads = $db->query_first(\"SELECT COUNT(*) AS threads FROM \" . TABLE_PREFIX . \"thread\"); \r\n$vBmthreads=number_format($countthreads[\'threads\']); \r\n// forum stats end \r\n\r\n// total online start \r\n$datecut = TIMENOW - $vbulletin->options[\'cookietimeout\']; \r\n$headerguests=$db->query_first(\"SELECT COUNT(*) AS count FROM \" . TABLE_PREFIX . \"session WHERE userid=0 AND lastactivity>$datecut\"); \r\n$headerusers=$db->query_first(\"SELECT COUNT(DISTINCT(userid)) AS count FROM \" . TABLE_PREFIX . \"session WHERE \" . TABLE_PREFIX . \"session.userid>0 AND \" . TABLE_PREFIX . \"session.lastactivity>$datecut\"); \r\n$headerguests=$headerguests[count]; \r\n$headerusers=$headerusers[count]; \r\n$vBmonline=$headerguests+$headerusers; \r\n// total online end \r\n\r\n// get newest member name and userid start \r\n$getnewestmember=$db->query_first(\"SELECT userid, username FROM \" . TABLE_PREFIX . \"user WHERE userid=$numbersmembers[max]\"); \r\n$newusername = $getnewestmember[\'username\']; \r\n$newuserid = $getnewestmember[\'userid\']; \r\n// get newest member name and userid end\r\n ', 'vBmusic'); MySQL Error : Unknown column 'executionorder' in 'field list' Quote:
|
So I guess you guys did not read the prior pages, and the one I typed in bold RED LETTERS!!!!
https://vborg.vbsupport.ru/showthrea...=164297&page=7 Have fun trying to uninstall this jacked up program. I still have not been able to remove it!!!!! LMAO!!!!! |
Well i can download it in the first time.. Lol... the file appears to be corrupted. can you upload it again or something
xai. |
Quote:
Here is a stupid question Ill ask you... WHY HAVE YOU NOT READ THE PRIOR WARNING! Do you not think that most of us who have install it, have major experience in things like that and WE DO NOT SUPPORT IT!!!!! So not to be mean but you have to do research before installing anything!!!! :confused: |
working after 7 hrs of editing :S
but is there any way to stop some groups from publishing new songs ? update : solved |
the script itself is working it jus needs to be updated and added new features
|
can this one be upgraded for upcoming vb 3.7?
|
this mod has massive potential, it needs to be refined. please fix the bugs and i'll be sure to include it on my website. great job
|
All times are GMT. The time now is 10:13 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|