Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
BEGIN
DECLARE intLineCount INT DEFAULT 0;
DECLARE intDummyCount INT DEFAULT 0;
DECLARE intDoLine INT DEFAULT 0;
DECLARE intWest INT DEFAULT 0;
DECLARE intNorth INT DEFAULT 0;
SELECT COUNT(*)
INTO intLineCount
FROM object_data;
SELECT COUNT(*)
INTO intDummyCount
FROM object_data
WHERE Classname = 'dummy';
WHILE (intLineCount > intDummyCount) DO
SET intDoLine = intLineCount - 1;
SELECT ObjectUID, Worldspace
INTO @rsObjectUID, @rsWorldspace
FROM object_data
LIMIT intDoLine, 1;
SELECT REPLACE(@rsWorldspace, '[', '') INTO @rsWorldspace;
SELECT REPLACE(@rsWorldspace, ']', '') INTO @rsWorldspace;
SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1), ',', '') INTO @West;
SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 3), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3 -1)) + 1), ',', '') INTO @North;
SELECT INSTR(@West, '-') INTO intWest;
SELECT INSTR(@North, '-') INTO intNorth;
IF (intNorth = 0) THEN
IF (@North = NULL) THEN
SET @North = '';
SELECT CONVERT(@North, DECIMAL(16,8)) INTO intNorth;
END IF;
IF (@North != NULL) THEN
SELECT CONVERT(@North, DECIMAL(16,8)) INTO intNorth;
END IF;
END IF;
IF (intWest > 0 OR intNorth > 15360) THEN
DELETE FROM object_data
WHERE ObjectUID = @rsObjectUID;
END IF;
SET intLineCount = intLineCount - 1;
END WHILE;
END
I got this error:
![]()
Can anybody help me?
View attachment 113
I have a screen, and it freezes like this. It stay like this for a while. Can someone help me?
It smells like MySQL, like game server can't connect to mysql server...View attachment 113
I have a screen, and it freezes like this. It stay like this for a while. Can someone help me?