FFXIAH Linkshell Ni

言語: JP EN DE FR
2010-06-21
New Items
users online
フォーラム » Everything Else » Undead » FFXIAH Linkshell Ni
FFXIAH Linkshell Ni
First Page 2 3 ... 1360 1361 1362 ... 18550 18551 18552
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:14  
sorry for the spam
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:23  
.
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:26  
.
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:29  
.
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:38  
yay!
 Carbuncle.Sevourn
Offline
サーバ: Carbuncle
Game: FFXI
user: Sevourn
Posts: 9481
By Carbuncle.Sevourn 2009-09-20 00:50:05  
nice...
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:50:10  
ghost page should be gone
 Carbuncle.Sevourn
Offline
サーバ: Carbuncle
Game: FFXI
user: Sevourn
Posts: 9481
By Carbuncle.Sevourn 2009-09-20 00:50:32  
i don't see one anymore
 Bahamut.Rydiya
Offline
サーバ: Bahamut
Game: FFXI
user: Rydiya
Posts: 7063
By Bahamut.Rydiya 2009-09-20 00:52:23  
._. no one got my reference.
I'm sad now.
 Bahamut.Rumaha
Offline
サーバ: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 00:53:06  
Scragg said:
Rumaha said:
Maybe deleting posts messed up the counter?

Edit**

The unheard of quadruple post GET!


It was likely from a database lock in the past or a webserver crash that corrupted the counter.


Indeed, and lol you were totally talking to yourself for a page xD, It happens when we like ~5 posts to new page and I don't see one :O Cool ty
 Bahamut.Rumaha
Offline
サーバ: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 00:53:50  
Scragg said:
I'm gonna top doggy's post count pretty soon ;-)


If no one caught this, lmfao. Scragg has good sense of humor lol.
 Midgardsormr.Sectumsempra
Offline
サーバ: Midgardsormr
Game: FFXI
user: Sect
Posts: 3723
By Midgardsormr.Sectumsempra 2009-09-20 00:54:26  
I feel like we just lost a part of ourselves. o.o;
 Bahamut.Rumaha
Offline
サーバ: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 00:55:29  
Sectumsempra said:
I feel like we just lost a part of ourselves. o.o;


Lol, I guess so, and gdi I have so many item sets I wish i had a way to organize them or a site that has something of the sort. ; ;
 Fenrir.Scragg
Administrator
Offline
サーバ: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 01:00:56  
so the reason the old FFXIAH LS forum keep screwing up is because the sql statement to select a topic page wasn't scalable. Meaning when the post count got very high for a topic, the amount of time to load this topic got longer. Even just a couple seconds to load can screw up stuff especially since I'm not doing any transactions etc.

The query was something like...

SELECT * FROM posts WHERE topic=x ORDER BY date_posted ASC LIMIT $page*30,30

if $page was like 1000, it would be reading 30,000 rows for nothing.

so I changed it to read a index based on the post number in a topic

so I do something like: "WHERE post_num > 30000 AND post_num < 30030"

It's super fast and scalable... as long as the numbers stay correct.
 Ramuh.Dasva
Offline
サーバ: Ramuh
Game: FFXI
user: dasva
Posts: 40469
By Ramuh.Dasva 2009-09-20 01:02:32  
Scragg said:
I'm gonna top doggy's post count pretty soon ;-)

No me
 Bahamut.Rumaha
Offline
サーバ: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 01:03:32  
Scragg said:
so the reason the old FFXIAH LS forum keep screwing up is because the sql statement to select a topic page wasn't scalable. Meaning when the post count got very high for a topic, the amount of time to load this topic got longer. Even just a couple seconds to load can screw up stuff especially since I'm not doing any transactions etc.

The query was something like...

SELECT * FROM posts WHERE topic=x ORDER BY date_posted ASC LIMIT $page*30,30

if $page was like 1000, it would be reading 30,000 rows for nothing.

so I changed it to read a index based on the post number in a topic

so I do something like: "WHERE post_num > 30000 AND post_num < 30030"

It's super fast and scalable... as long as the numbers stay correct.


Oh, that's cool, though I know almost nothing of sql and xml and scripting for websites and such, I can understand the point lol.
 Ramuh.Dasva
Offline
サーバ: Ramuh
Game: FFXI
user: dasva
Posts: 40469
By Ramuh.Dasva 2009-09-20 01:04:17  
And nap time
 
Offline
Posts:
By 2009-09-20 01:13:01
 Undelete | Edit  | Link | 引用 | 返事
 
Post deleted by User.
 Bahamut.Rydiya
Offline
サーバ: Bahamut
Game: FFXI
user: Rydiya
Posts: 7063
By Bahamut.Rydiya 2009-09-20 01:25:19  
Bartimaeus said:
Definately a good fix. Ghost page was a pain on my iTouch.. slow internet + trying to click tiny links to further back pages = fail.

lol.. iTouch.
 
Offline
Posts:
By 2009-09-20 01:28:17
 Undelete | Edit  | Link | 引用 | 返事
 
Post deleted by User.
 Asura.Luelle
Offline
サーバ: Asura
Game: FFXI
user: Luelle
Posts: 4164
By Asura.Luelle 2009-09-20 01:33:23  
I just learned something interesting about Zekky....
 
Offline
Posts:
By 2009-09-20 01:33:47
 Undelete | Edit  | Link | 引用 | 返事
 
Post deleted by User.
 Asura.Zekky
Offline
サーバ: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:34:10  
You'll find out soon. Posting a SS.
 Asura.Zekky
Offline
サーバ: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:36:08  
User submitted image
 
Offline
Posts:
By 2009-09-20 01:36:18
 Undelete | Edit  | Link | 引用 | 返事
 
Post deleted by User.
 
Offline
Posts:
By 2009-09-20 01:37:36
 Undelete | Edit  | Link | 引用 | 返事
 
Post deleted by User.
 Bahamut.Rydiya
Offline
サーバ: Bahamut
Game: FFXI
user: Rydiya
Posts: 7063
By Bahamut.Rydiya 2009-09-20 01:38:15  
Luelle said:
I just learned something interesting about Zekky....

Damnit. I wish I could move to Asura now!
 Asura.Zekky
Offline
サーバ: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:38:30  
I have no idea why "***" came to mind instead of "farming"... I mean... sure. Same length in characters. Starts with an F... but... I don't know. Lack of sleep, eh?
 Asura.Zekky
Offline
サーバ: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:40:19  
Rydiya said:
Luelle said:
I just learned something interesting about Zekky....

Damnit. I wish I could move to Asura now!

We'd have fun!
 
Offline
Posts:
By 2009-09-20 01:41:07
 Undelete | Edit  | Link | 引用 | 返事
 
Post deleted by User.
First Page 2 3 ... 1360 1361 1362 ... 18550 18551 18552
Log in to post.