Tables

[lemonadesoda]

HURRAY, we've got tables back again! It's been a long time... (since embedded HTML was disabled).

 

[jbunch07]

I looked it up.

Using this you can sort. 1, is the column number, ie the first column in this case. The added "d" sets it to descending, default is ascending.

Using this you can just add values at the bottom and it'll be sorted automatically. Sorting is case sensitive, so make sure everything is either lowercase or uppercase.


More info:
http://www.vbulletin.org/forum/showpost.php?p=900270&postcount=2

Ok, I'm having trouble making this work, can someone give me an example of how to use this?

Edit:
im trying to use the auto number feature by putting autonum=1 in the table header. like so

and that bit works it will auto number the table but my old numbers are still there, is there away to get rid of the old numbers without having to go delete them all?
Use this table for example.

Rank|Username|Card|Clocks|Score|Cpu
1.|JrRacinFan| Visiontek 2600Pro |600/405|P584| E1200 @ 2400Mhz
2.|Crackerjack| ATi 2900GT |700/850|P3068| Phenom 9850 @ 2500Mhz
3.|flashstar| ATi 2900XT |743/828|P3157| X2 3800+ @ 2500Mhz
4.|sfp1987| ATi 2900GT |776/1116|P3202| Phenom 9850 @ 3308Mhz
5.|Crackerjack| ATi 2900GT |800/1100|P3416| X2 5000+ @ 3125Mhz
6.|ShogoXT| ATi 2900XT |743/1000|P3463| E6600 @ 2700Mhz
7.|Edito| Nvidia 8800GTS(G80) | 513/792/1188|P3716| E6750 @ 3000Mhz
8.|Wiak| Club3D HD3870 |777/1126|P4009| Phenom 9850 @ 2500Mhz
9.|Candle_86| HD3870 |769/1125|P4010| X2 4200 @ 2500Mhz
10.|JrRacinFan| HIS 3870 | 850/1197|P4349| E1200 @ 2959Mhz

 

[AsRock]

I think raid controller should be added to it too as this can make a difference.

All though looks nice same it not being updated as well.

 

[Deleted member 3]

I think raid controller should be added to it too as this can make a difference.

All though looks nice same it not being updated as well.

That's up to the one that should be maintaining the thread

 

[Hayder_Master]

very cool idea dan, it is too easy to read , go for it

 

[jbunch07]

Anyone know how to solve my problem?

 

[Deleted member 3]

Autonumber is a separate column. Basically you have to remove your own column.

 

[jbunch07]

Autonumber is a separate column. Basically you have to remove your own column.

Grrr, I was hoping to avoid that. Well thanks again, I guess I have lot of deleting to do.

 

[Deleted member 3]

It's not that much work, I converted the HD table thing quite fast. I can't be arsed to update it though

 

[jbunch07]

Hmm so no word from "dark ego" then huh?

 

[Deleted member 3]

He said he wouldn't mind me taking it over. But I'm far too lazy to do that.

 

[jbunch07]

He said he wouldn't mind me taking it over. But I'm far too lazy to do that.

Ah I know the feeling, sometimes I have to force my self to update the 3dmark threads but with the new auto number functions it should be less tedious.

 

[mullered07]

ok i seen this and it looks perfect to revive my everest benchmark thread, (ive had a lot of family problems recently and havent been online much)

only thing is, do i need to close it with somthing? cause at the minute ive done this

Username|Read|Write|Copy|Latency
Mullered07|test|test|test|999|

and nothing is happening, am i missing somthing here, you will have to excuse me im not that savvy on html

 

[jbunch07]

ok i seen this and it looks perfect to revive my everest benchmark thread, (ive had a lot of family problems recently and havent been online much)

only thing is, do i need to close it with somthing? cause at the minute ive done this

Username|Read|Write|Copy|Latency
Mullered07|test|test|test|999|

and nothing is happening, am i missing somthing here, you will have to excuse me im not that savvy on html

put "

" at the end.

Username|Read|Write|Copy|Latency
Mullered07|test|test|test|999|

whoa, that weird. just quote that and you will see what i mean.

 

[mullered07]

thanks man, now um ..... lol how do i make it so you can click on a header and sort ?

nope still cant do it

Username|Read|Write|Copy|Latency
Mullered07|test|test|test|999|

 

[btarunr]

thanks man, now um ..... lol how do i make it so you can click on a header and sort ?

nope still cant do it

Username|Read|Write|Copy|Latency
Mullered07|test|test|test|999|

After each quick edit, reload the page.

 

[jbunch07]

you need to have more than one entry for it to sort.

 

[mullered07]

After each quick edit, reload the page.

lmao ok man

 

[jbunch07]

Ok need some help here again!

Ok so I have the auto number and the descending fromat to where its working in the 3d06 thread, no problems there. However when I use the same Table heading for the Vantage thread it does not work? I'm inclined to think its because the scores in the vantage thread start with a P and that why it wont list them in descending order.

Example: Vantage thread,

Username|Card|Clocks|Score|Cpu
HeavyH20| eVGA GTX260 triSLI |735/1200/1510| P31077 | QX9650 @ 4800.3Mhz
HeavyH20| eVGA GTX260 triSLI |700/1100/1509| P26173 | QX6850 @ 4000Mhz
fitseries3| 4870 X2 Xfire + physx |750/900| P24731 | Q6600 @ 4014Mhz
r1rhyder| Ati 4870 X2 Xfire |750/900| P24512 | QX9650 @ 4950mhz
EnergyFX| GTX280 SLI |742/1330/1484| P23278 | E8500 @ 4025mhz
r1rhyder| ATi 4870 X2 Xfire |750/900| P22592 | QX9650 @ 4000Mhz
phanbuey| GTX 260 SLI |730/1229/1460| P21153 | E8500 @ 4037Mhz
CyberDruid| ATi 4870 X2 Xfire |780/900| P21100 | QX9650 @ 4270Mhz
generallee5686| GTX260 SLI |740/1280/1575| P20906 | QX9450 @ 3600Mhz
fitseries3| 4870 X2 + 4850 + physx |750/900| P20496 | Q6600 @ 3978Mhz

Not working

3D06 thread:

Username|Card|Clocks|Score|Cpu
fitseries3|Ati HD4870X2 + HD4870|772/900|26193|QX9650 @ 4550.1mhz - 455FSB
giorgos th.|ATi / HD2900XT X-Fire|850/990|25407|QX9650 @ 5460Mhz - 452FSB
CyberDruid|Ati HD4870X2 Xfire|780/900|25291|QX9650 @ 4270.4mhz - 427FSB
HeavyH20|eVGA GTX260 TriSLI|740/1200|24961|QX9650 @ 4887.4Mhz - 391FSB
giorgos th.|ATi HD3870X2|878/1098|24842|QX9650 @ 5429.5Mhz - 417.7FSB
fitseries3|ATi HD4870X2|772/900|24686|QX9650 @ 4550.1Mhz - 455FSB
fitseries3|Ati HD4870X2 Xfire|750/900|24268|E8600 @ 4700.01mhz- 470FSB
giorgos th.|eVga 9800GX2|750/1130|24032|E8600 @ 5250.0Mhz - 525FSB
Dark2099|Visiontek HD4850 X-Fire|700/1163|23468|QX9650 @ 4515.5Mhz - 430FSB
Dark2099|Visiontek HD4870 + 2 4850s TriFire|700/1148|23426|Q9550 @ 2446.9Mhz - 500FSB

Working just fine!

Any ideas Dan? W1zz? Anyone?

 

[Deleted member 3]

Username|Card|Clocks|Score|Cpu
HeavyH20| eVGA GTX260 triSLI |735/1200/1510|21077| QX9650 @ 4800.3Mhz
HeavyH20| eVGA GTX260 triSLI |700/1100/1509|26173| QX6850 @ 4000Mhz
fitseries3| 4870 X2 Xfire + physx |750/900|24731| Q6600 @ 4014Mhz
r1rhyder| Ati 4870 X2 Xfire |750/900|24512| QX9650 @ 4950mhz Q6600 @ 3978Mhz

Works fine, remove the P. You can't mix the various scores anyway, so they're all P, X or whatever.
Also, move the verification url to another column. Sorting on the URL is a bad idea.

 

[lemonadesoda]

Try writing the scores as 23278P rather than P23278 to see if there is a bug in the sort algorithm.

^^Dan beat me to it, but still try with the "P" at the end.

PS. It might also be sorting on your LINK, not on the data. Make sure you set up the data and link correctly.

 

[btarunr]

Jon, look at the values in the score column, those aren't numbers, you're adding a "P", the value changes from a quantity, to a string.

okay double beaten. whetever they said. I suggest instead of writing scores as P12345, X1234, create a new column for mentioning if it's P (performance) or X (eXtreme), and keep the scores as pure quantities.

 

[lemonadesoda]

TEST

Numeric|Alpha|AlphaNumeric|NumericAlpha|
23.229|apple.|a#|#a||
23.231|apple |a |# |(spaces added after)|
23.231| apple | a | # |(spaces added before)|
23.23|apple|a12|3a||
23.00|banana|a11|3b||
1|aapple|a1|2a||
2|APPLE|b3|2b||
3|Apple|b22|22a||
0|Apples|-b22|22A||
-11|ZOMG|b2200|23a||

Alphanumeric sorting works. And if I click on your table, I can also sort by "Pxxxxx". The only problem is that you might need to add a precending 0 at the front of numbers <10000 so that the length of all scores is the same, otherwise P500 >P4999.

So if it works manually, then it should work with the autosort feature, unless there is a BUG. Either programatically, or in your table setup.

 

[jbunch07]

Great ok thanks guys that's what I was thinking! Ill just remove the P from the scores, I was thinking about adding other tables for X as well anyway.

But why should I remove the verification link Dan?

 

[btarunr]

TEST

Numeric|Alpha|AlphaNumeric|NumericAlpha|
23.23|apple|a12|3a||
23.00|banana|a11|3b||
1|aapple|a1|2a||
2|APPLE|b3|2b||
3|Apple|b22|22a||
0|Apples|-b22|22A||
-11|ZOMG|b2200|23a||

nice example, see, alphanumeric failed to sort (well), while numalpha did, wanna know why?

In ASCII, the digits 0~9 come before characters A~Z. So when you're making it sort alph-num, you're placing characters from the ASCII that are after the digits, before them. I hope I'm clear.