vb.org Archive - Major Additions - Forum Tournaments & Ladders

Database error in vBulletin 3.7.4:



Invalid SQL:

UPDATE vbtmnt_ladder_players SET loses = loses + 1, wstreak = 0, lstreak = lstreak + 1, latime =1240008668, rank = 987.5, uod = -1, totalpoints = totalpoints + 10, longeststreak = 0 WHERE lid = 1 AND userid = 1;



MySQL Error   : Unknown column 'uod' in 'field list'

Error Number  : 1054

Request Date  : Friday, April 17th 2009 @ 05:51:08 PM

Error Date    : Friday, April 17th 2009 @ 05:51:08 PM

Script        : http://www.darkmlg.com/foro/competitions.php?do=laddersubmitscore&id=3

Referrer      : http://www.darkmlg.com/foro/competitions.php?do=laddersubmitscore&id=3

IP Address    : xxx.xxx.xxx.xxx

Username      : XxBOSSMASTERxX

Classname     : vB_Database

MySQL Version : 5.0.77-community

bananalive

04-18-2009 11:48 AM

Quote:

Originally Posted by XxBOSSMASTERxX (Post 1793584)

Database error help. with v2.7.8

Code:

Database error in vBulletin 3.7.4:



Invalid SQL:

UPDATE vbtmnt_ladder_players SET loses = loses + 1, wstreak = 0, lstreak = lstreak + 1, latime =1240008668, rank = 987.5, uod = -1, totalpoints = totalpoints + 10, longeststreak = 0 WHERE lid = 1 AND userid = 1;



MySQL Error   : Unknown column 'uod' in 'field list'

Error Number  : 1054

Request Date  : Friday, April 17th 2009 @ 05:51:08 PM

Error Date    : Friday, April 17th 2009 @ 05:51:08 PM

Script        : http://www.darkmlg.com/foro/competitions.php?do=laddersubmitscore&id=3

Referrer      : http://www.darkmlg.com/foro/competitions.php?do=laddersubmitscore&id=3

IP Address    : xxx.xxx.xxx.xxx

Username      : XxBOSSMASTERxX

Classname     : vB_Database

MySQL Version : 5.0.77-community

Run query

[sql]ALTER TABLE vbtmnt_ladder_players ADD uod INT(10) NOT NULL [/sql]

gakousei

04-18-2009 05:40 PM

Sorry to post it again but I had no reply.

I would like to add a profile's field into the player's statistics in the tmnt_ladder_cmpt template.

After I added , user.* into the php code, what am I suppose to add into the template ?

Could you give me an exemple with "field1" ?

i tried with $cmpt[field1] then with $profile[field1] etc...

I don't really know how to add the field into the template.

Help would be greatly appreciate.

bananalive

04-19-2009 07:29 PM

Quote:

Originally Posted by gakousei (Post 1794038)

change line 311

PHP Code:


		
			
" . (!$team ? "LEFT JOIN " . TABLE_PREFIX . "user AS user ON (players.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid) " : "") . "

to:

PHP Code:


		
			
" . (!$team ? "LEFT JOIN " . TABLE_PREFIX . "user AS user ON (players.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid) " : "") . "

line 309 starts

PHP Code:


		
			
$cmpts = $db->query_read("SELECT

to:

PHP Code:


		
			
$cmpts = $db->query_read("SELECT userfield.field1,

droid101

04-19-2009 09:26 PM

One minor nitpick: when you click someone's name in a ladder to view their stats, it says "Longest Winning Streak" and lists their longest streak, whether it is wins or losses.

Should change that to "Longest Streak" or change it so that it only lists their longest winning streak rather than their longest winning or losing streak (which ever one is longer, obviously).

Gamelobby

04-19-2009 10:50 PM

^^Good point.^^

So is this 2.8.1 going to be out of BETA pretty soon.?
I cant wait to update it, but i have a few things running i dont want to take any chances or screw up. :)

droid101

04-20-2009 02:48 AM

One other thing that would be nice: the ability for Admins to add users to a Ladder.

Right now, as an admin, I can add anyone to a tournament, but I can't add people to ladders.

Spiritvn

04-20-2009 11:38 AM

Can a team member have a way to out team by himself? And a way for the leader can invite s1 to the team (not add immediately)?

anyway, Nice job, installed.

All times are GMT. The time now is 09:25 AM.

Page 169 of 213

169

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02971 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 (2)bbcode_code_printable (4)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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
Messages: