Query Script Help - Scripting Bits and Pieces

General assistance and guidelines for editing the server side of Soma.

Re: Query Script Help - Scripting Bits and Pieces

Postby Archaon » Fri Mar 20, 2009 6:08 pm

unvmeh wrote:there are some nasty people on these forums lol ...


us included mate
SQL 2005 is like a women. You tell it to do something, it whines at you for 2 hours then does something completly different.
Archaon
SD Four Star
SD Four Star
 
Posts: 210
Joined: Fri Aug 29, 2008 2:36 pm

Re: Query Script Help - Scripting Bits and Pieces

Postby unvmeh » Sat Mar 21, 2009 11:46 am

i would hope so buddy.
........./´¯/)
......../¯..//
......./..../ /
./´¯/'...'/´¯¯`·¸
/'/.../..../......./¨¯\
('(...´(..´......,~/'...')
.\.................\/..../
..\.......... _.·´/
...\..............(
....\.............\
.....\.UNVMEH.\
User avatar
unvmeh
SD Pro 5 Star
SD Pro 5 Star
 
Posts: 1438
Joined: Tue Apr 29, 2008 7:33 pm

Re: Query Script Help - Scripting Bits and Pieces

Postby Pete » Tue Oct 11, 2011 4:25 pm

Hello, really nice post.

UPDATE TB_INC SET
STR = STR * 40,
INT = INT * 40,
DEX = DEX * 40,
WIS = WIS * 40

And for the last one to work (update tb_inc set) you need to go into Design Table in the database using Enterprise Manage on the TB_INC table and make sure you change the str, int, dex and wis to "varchar" for the type, save it and then use that query to make stats gain faster. You will get an error if you do not.

Trying to do this bit, but cant get it working..sure im doing everything properly which varchar do i pick? (max) (50) etc?

heres my error message

Msg 206, Level 16, State 2, Line 1
Operand type clash: ntext is incompatible with int


Ive definately changed ntext to varchar(16)
Thank you
Pete
SD One Star
SD One Star
 
Posts: 28
Joined: Sun Sep 11, 2011 1:46 pm

Re: Query Script Help - Scripting Bits and Pieces

Postby Gokbrown » Tue Apr 08, 2014 3:32 am

hi guys

CREATE PROCEDURE CREATEACCOUNT
@id varchar(20),
@pass varchar(20)
AS

SELECT * FROM NGSCUSER WHERE strUserId = @id

if (@@rowcount = 0)
BEGIN
INSERT INTO NGSCUSER VALUES(@id, @pass, null, @id, 0, 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa',0, 0, null, 0, 'aaa',0, 0, 0,0)
END
GO

with this piece of script, were do i add the user and pass for the account that i want to add? it keeps coming up with errors every time i try to put it through, any help is greatly appreciated
Image
User avatar
Gokbrown
SD Two Star
SD Two Star
 
Posts: 57
Joined: Wed Jun 29, 2011 1:36 am

Re: Query Script Help - Scripting Bits and Pieces

Postby Gokbrown » Tue Apr 08, 2014 3:41 am

i think i worked out the username is the top bit but what would that make the password in this script.. null? or am i missing something?
Image
User avatar
Gokbrown
SD Two Star
SD Two Star
 
Posts: 57
Joined: Wed Jun 29, 2011 1:36 am

Previous

Return to Server Development

Who is online

Users browsing this forum: No registered users and 3 guests

cron