a few small things

ok so here is a few stored procs i used on my server this quary if ran compleat creats the db i used GM_Stuff and inserts the main tabels i used along with a few stored procs such as 3day 2week ip bann unbann quarys faction change FULL account wipes indavidyal account wipe admin acount removel and wipe and admin creation.... all banment quarys are ran by charname so no need to search for accounts simply add the char name... posably tommarow or when i get a bit of free time i shale wright out the automatic UNBAN section of the login proc that will auto unban an account that has been baned for 3days or 2week.

fixed account swipe quary redownload and rerunn

Hello this error occurs:

Msg 137, Level 15, State 2, Procedure AccountSwipe, Line 233
Must declare the scalar variable "@UserID".

Quote:

Originally Posted by invincible.shaiya Hello this error occurs: Msg 137, Level 15, State 2, Procedure AccountSwipe, Line 233 Must declare the scalar variable "@UserID".

i fixed this error plzz redownload and rerunn the quary it may mostlikely throw a bunch of errors apon rerunning the quary as the db was created already and other things did execute sucesfuly befor the error acured so ignor the errors unless they arenot errors such as db exists stored proc exists tabels exist preatymuch any error stateing something alreadu exists is ok with this quary as it is simply stateing they executed sucesfly the first time it was ran.