FFXIAH Linkshell Ni

Language: JP EN DE FR
2010-09-08
New Items
users online
Forum » Everything Else » Undead » FFXIAH Linkshell Ni
FFXIAH Linkshell Ni
First Page 2 3 ... 1360 1361 1362 ... 18550 18551 18552
 Fenrir.Scragg
Administrator
Offline
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:14
Link | Quote | Reply
 
sorry for the spam
 Fenrir.Scragg
Administrator
Offline
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:23
Link | Quote | Reply
 
.
 Fenrir.Scragg
Administrator
Offline
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:26
Link | Quote | Reply
 
.
 Fenrir.Scragg
Administrator
Offline
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:29
Link | Quote | Reply
 
.
 Fenrir.Scragg
Administrator
Offline
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:49:38
Link | Quote | Reply
 
yay!
 Carbuncle.Sevourn
Offline
Server: Carbuncle
Game: FFXI
user: Sevourn
Posts: 9481
By Carbuncle.Sevourn 2009-09-20 00:50:05
Link | Quote | Reply
 
nice...
 Fenrir.Scragg
Administrator
Offline
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 00:50:10
Link | Quote | Reply
 
ghost page should be gone
 Carbuncle.Sevourn
Offline
Server: Carbuncle
Game: FFXI
user: Sevourn
Posts: 9481
By Carbuncle.Sevourn 2009-09-20 00:50:32
Link | Quote | Reply
 
i don't see one anymore
 Bahamut.Rydiya
Offline
Server: Bahamut
Game: FFXI
user: Rydiya
Posts: 7063
By Bahamut.Rydiya 2009-09-20 00:52:23
Link | Quote | Reply
 
._. no one got my reference.
I'm sad now.
 Bahamut.Rumaha
Offline
Server: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 00:53:06
Link | Quote | Reply
 
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
Server: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 00:53:50
Link | Quote | Reply
 
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
Server: Midgardsormr
Game: FFXI
user: Sect
Posts: 3723
By Midgardsormr.Sectumsempra 2009-09-20 00:54:26
Link | Quote | Reply
 
I feel like we just lost a part of ourselves. o.o;
 Bahamut.Rumaha
Offline
Server: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 00:55:29
Link | Quote | Reply
 
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
Server: Fenrir
Game: FFXI
user: Scragg
Posts: 2579
By Fenrir.Scragg 2009-09-20 01:00:56
Link | Quote | Reply
 
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
Server: Ramuh
Game: FFXI
user: dasva
Posts: 40469
By Ramuh.Dasva 2009-09-20 01:02:32
Link | Quote | Reply
 
Scragg said:
I'm gonna top doggy's post count pretty soon ;-)

No me
 Bahamut.Rumaha
Offline
Server: Bahamut
Game: FFXI
user: Rumaha
Posts: 10000
By Bahamut.Rumaha 2009-09-20 01:03:32
Link | Quote | Reply
 
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
Server: Ramuh
Game: FFXI
user: dasva
Posts: 40469
By Ramuh.Dasva 2009-09-20 01:04:17
Link | Quote | Reply
 
And nap time
 
Offline
Posts:
By 2009-09-20 01:13:01
 Undelete | Edit  | Link | Quote | Reply
 
Post deleted by User.
 Bahamut.Rydiya
Offline
Server: Bahamut
Game: FFXI
user: Rydiya
Posts: 7063
By Bahamut.Rydiya 2009-09-20 01:25:19
Link | Quote | Reply
 
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 | Quote | Reply
 
Post deleted by User.
 Asura.Luelle
Offline
Server: Asura
Game: FFXI
user: Luelle
Posts: 4164
By Asura.Luelle 2009-09-20 01:33:23
Link | Quote | Reply
 
I just learned something interesting about Zekky....
 
Offline
Posts:
By 2009-09-20 01:33:47
 Undelete | Edit  | Link | Quote | Reply
 
Post deleted by User.
 Asura.Zekky
Offline
Server: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:34:10
Link | Quote | Reply
 
You'll find out soon. Posting a SS.
 Asura.Zekky
Offline
Server: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:36:08
Link | Quote | Reply
 
User submitted image
 
Offline
Posts:
By 2009-09-20 01:36:18
 Undelete | Edit  | Link | Quote | Reply
 
Post deleted by User.
 
Offline
Posts:
By 2009-09-20 01:37:36
 Undelete | Edit  | Link | Quote | Reply
 
Post deleted by User.
 Bahamut.Rydiya
Offline
Server: Bahamut
Game: FFXI
user: Rydiya
Posts: 7063
By Bahamut.Rydiya 2009-09-20 01:38:15
Link | Quote | Reply
 
Luelle said:
I just learned something interesting about Zekky....

Damnit. I wish I could move to Asura now!
 Asura.Zekky
Offline
Server: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:38:30
Link | Quote | Reply
 
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
Server: Asura
Game: FFXI
user: Zekky
Posts: 3787
By Asura.Zekky 2009-09-20 01:40:19
Link | Quote | Reply
 
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 | Quote | Reply
 
Post deleted by User.
First Page 2 3 ... 1360 1361 1362 ... 18550 18551 18552
Log in to post.