Register for your free account! | Forgot your password?

You last visited: Today at 19:18

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[SQL] Fix CharQuest:Raise Error properly

Discussion on [SQL] Fix CharQuest:Raise Error properly within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
elite*gold: 19
Join Date: Jul 2013
Posts: 223
Received Thanks: 290
[SQL] Fix CharQuest:Raise Error properly

So there was a fix for this already... however if u already had chars created.. they would start bugging around cuz the first 4 slots would be resetted at every teleport. I made a quicky cursor to rebuild the table using proper data.

Code:
Declare @Charid INT
Declare charq cursor for
select distinct charid from _Char where CharID !=0 

open charq
fetch next from charq into @CharID
while @@FETCH_STATUS =0 
BEGIN

Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,1,5,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',8388691,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,2,1,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',8388691,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,385,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',0,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,386,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,387,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,388,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,389,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,397,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16777217,0)

fetch next from charq into @charid
END
close charq
deallocate charq
Royalblades is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
HI need 2 raise ur elo? im ur man!
09/26/2012 - League of Legends Trading - 0 Replies
so my account name is zeljin and i have over 2000 games played so im very experienced i play this game basicallly every time i have free time and the highest elo iv gotten so far is 1755. i am pretty good though the only reason why my elo is 1400 right now is because on weekends i get drunk and play for fun... but if u want ur elo raised i promise ill get ur account to the elo required, WITHOUT being drunk cuz its kinda like a job. but ya... im very experienced and if u choose me ill promise ur...
RAISE ELO (USA)
01/04/2012 - League of Legends Trading - 12 Replies
Two ways to do this. 1) You send $10 DEPOSIT, I log on your account and get you the 50 elo, and we can continue from there if you wish. 2) You give me your account, i'll change PW and get you the ELO. You pay me money and I give it back. xfire : 3 x i 4 USA ONLY
Quest:Raise Event Error
09/22/2011 - SRO Private Server - 5 Replies
Okey guys , its my last thread if this error fixed. Now , when im select char and click "start" loading screen crash for this error. http://i54.tinypic.com/24wrbcl.jpg
raise fps
03/21/2011 - Conquer Online 2 - 3 Replies
can someone please just make an edit so we can play conquer with say 60 fps? ive raped google and this site for something to do that and all ive found are broken/glitched hacks. im just requesting someone make an edit that does nothing else but make your maximum fps 60.
raise hp?
04/12/2010 - Aion - 1 Replies
is there a hack that make u get higher hp? and is this possible http://img338.imageshack.us/img338/473/65737699.pn g



All times are GMT +1. The time now is 19:18.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.