Admincp den avatar ekleme

10-05-2006, 20:58:16

Admincp den avatar eklemek istediğimde.

Invalid SQL:
UPDATE user SET
	### Bitfield: user.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 16, options, options + 16),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 512, options - 512, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options - 4096, options),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 32768, options - 32768, options),
	usertitle = 'Üye',
	customtitle = 0,
	username = '',
	email = '',
	languageid = 2,
	homepage = '',
	birthday_search = '',
	birthday = '',
	showbirthday = 0,
	icq = '',
	aim = '',
	yahoo = '',
	msn = '',
	skype = '',
	parentemail = '',
	posts = 53,
	referrerid = 0,
	ipaddress = '81.2
	caninvite = 1,
	invites = 10,
	usergroupid = 2,
	reputationlevelid = 5,
	reputation = 20,
	pmpopup = 1,
	autosubscribe = -1,
	threadedmode = 0,
	showvbcode = 1,
	styleid = 0,
	timezoneoffset = '2',
	daysprune = 0,
	joindate = 1146337440,
	lastactivity = 1147279980,
	lastpost = 1147211280,
	membergroupids = '',
	vbp_receivespoints = 1,
	vbp_storeaccess = 1,
	vbbux = 100108.79,
	M-Bank = 0,
	vbp_nextbankinterest = 0,
	vbp_genericperm = 0,
	vbp_modperm = 0,
	vbp_adminperm = 0,
	vbp_nametextcolor = '',
	vbp_nameglowcolor = '',
	vbp_nameshadowcolor = '',
	vbp_titletextcolor = '',
	vbp_changealwaysitems = '',
	### Bitfield: user.vbp_displayflags ###
		vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
	### Bitfield: user.vbp_otherflags ###
		vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
	### Bitfield: user.vbp_immunity ###
		vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity)
WHERE userid = 7;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-Bank = 0,
	vbp_nextbankinterest = 0,
	vbp_genericperm = 0,
	vbp_modperm = 0,' at line 54
Error Number : 1064
Date         : Wednesday, May 10th 2006 @ 01:53:41 PM
Script       : http://
Referrer     : http://
IP Address   : 85.
Username     : ma
Classname    : vb_database

Bu hatayı alıyorum acaba hangı eklentıyı kurarken olmus olabılır bu yanı hangı kısımı ilgilendirir.

Not: Vbux ve bank ı trleştiriyorum acaba bunun etkisi olabilir mi?

10-05-2006, 21:59:59

#2

~~Efsane~~

Üyeliği durduruldu

Admincpden eklemek biraz saçma olur ekleme ordan hata vermesi normaldir herhangi bir hack den veya oynadığın kodlardan dolayı bu hatayı alıyosundur yada DB de sorun vardır bunu veriyodur.

10-05-2006, 22:57:26

#3