some fixes
I made some fixes with the search engine, but it's not quite done yet. I'm putting in some limits so you can't make searches that are too long. also, turns out I already uploaded all the rest of the games that I was going to upload, so I didn't have to upload anymore. next I just have to get the old videos.
posted by cheesycarrion
search engine
I was bored so I made a search engine. I didn't mean to make it users-only, but it didn't work if you weren't logged in, so if you want to try it out, get a new account by typing register in the command prompt.
(you can use it by going to the games or videos section and using the text box on the right.)
posted by cheesycarrion
duplicate games and mysql stuff
I noticed that there were some strange things happening when I inserted all those games from the old site. I noticed that a lot of them showed the file size, even though I didn't insert the file size when I was adding them, which was strange, and some already had a lot of views. what it ended up being was that a lot of those games I already had in cc09 so there were duplicates, but since they had the same title, they it just chose the first record to get the data from when viewing the file. I tested a few, like chess, for example, and noticed that when searching for all entries where title='chess' found more than one result. I then searched google to find out how to show all duplicate entries, and altered one of the queries I found to display the the ids of both entries (I'm talking about id number, not the title which also happens to be labeled "id" when viewing a game or video.) I also want to stop just to mention that phpmyadmin is a fucking phenomenal tool for mysql. anyway, then since I was displaying ids from different entires in the same row, I couldn't just delete them yet so I made it only display the higher id (the newer one,) and phpmyadmin was smart enough to realize that each row it was displaying was from only one row out of the database, and gave tools like delete, rename, edit. so then I checked them all and clicked delete, but since the id column was prefixed with 't1' meaning the first entry of the two duplicates, (and I don't know what this prefix thing is called since I don't know that much about mysql) it tried to do the delete query with that prefix before "id." obviously this didn't work, but I wouldn't expect phpmyadmin to be smart enough to figure that type of thing out. the cool thing was it previews the query to you when you confirm to delete, so I just copy pasted the query and edited out the "t1." prefix and it worked like a charm.
posted by cheesycarrion
more games again
here are those 33 games I promised
- sea of fire
- potion panic
- territory war
- raiden x
- dad n me
- thing thing 2
- toast of war
- drunk homerun
- double wires
- champion
- bullet bill
- portal
- squishy tetris
- spot the difference
- bloons player pack 1
- bloons player pack 2
- the last stand
- feudalism
- interactive buddy
- throw me
- chat noir
- race game
- bloons tower defense 2
- classroom 3
- orbitron
- ragdoll invaders
- indestruc2tank
- invasion tactical defense
- tetris 3D
- road blocks
- matrix rampage
- dirt bike 1
- chess
- avalanchee jump
ok, now there are only a few more games to insert, then for the videos.
posted by cheesycarrion
31 yesterday, 32 today, 33 tomorrow
ok so here are 32 more games. I'll add 33 tomorrow probably, since that seems to be the pattern.
- mini putt
- donkey kong
- lunar command
- mario rampage
- space invaders
- virtual cop
- monkey lander
- wpnFire
- escape the room
- defend your castle
- gravoor 4
- snake
- pacman
- 3D frogger
- red
- black 2
- ambush
- stick rpg demo
- bowling
- fly plane
- kick ups
- retronoid
- van TT
- bull's eye
- bowman 2
- missile game
- 3D pong
- radical racer
- the thule trail
- nanaca crash
- qwerty warriors
- qwerty warriors 2
posted by cheesycarrion
bringing back some old games
I didn't realize how many games there were from cc08 and cc07 especially that I didn't ever get around to bringing to the new site, so I uploaded a bunch, and this isn't even all of it, so here's less than half of those games (and yes, I will add the rest (probably tomorrow.)):
I put in a random image to liven up the page.
- endless zombie rampage
- escalade
- jet speed
- more mindless violence
- desktop tower defense 1.02
- desktop tower defense 1.21
- ellipsis
- onslaught
- indestructotank
- world defense
- more bloons
- snake shooter
- gravity
- 3D ping pong
- flametry wars
- gateway 2
- sphere
- contra
- mini putt 3
- monolith mario
- naked melee
- ragdoll avalanche
- the maze
- adrenaline
- drunk driver
- pacxon
- boyscout slayer 2
- gold miner
- 100 men
- max dirt bike
- stick smasher
- ice racer
- flow
- battlegrounds 2
- bloody day
- line game
- fireball racing
- kitten cannon
- line flier
there are also a bunch of old forgotten videos that I'll bring to the new site too, so get ready.
posted by cheesycarrion
adding games and stuff again
n
check out that google logo. that was one of google's first logo designs. pretty ghetto..
here are the top 5 most recently uploaded games:
posted by cheesycarrion
scripts page
edit 2: sonny 2
edit: ok, I fixed the problem with videos and games being only 600px wide. they are now the full 800px when using the detach (default) theme.
ok, so I didn't really add anything, but I put a bunch of links to stuff on the scripts page, so you might want to check it out because there's probably stuff you didn't know about. I've been working mostly on back end things like moderator controls (which for moderators can be seen on the scripts page too) and fixing forum glitches and stuff. I also now have a script that auto-generates my icon stylesheet and a control panel for adding and removing icons from my icons folder, but that doesn't really change the site at all either.
posted by cheesycarrion
link back
put this code in your myspace/facebook profiles or website or whatever to link to cc:
<a href="
http://www.hugeurl.com/?MDNkZDNiZDgwYjNkYjYwZTIyZWFlOTc3MjI2
NzU3OGEmMTQmVm0wd2QyUXlVWGxWV0d4V1YwZDRXRmxVU205V01WbDNXa2M1
VjFac2JETlhhMk0xWVd4S2MxZHFRbFZXYkhCUVZqQmFZV015U2tWVWJHaG9U
VlZ3VlZadGNFZFpWMDE1VTJ0V1ZXSkhhRzlVVjNOM1pVWmFjVkZ0UmxSTmF6
RTFWVEowVjFaWFNraGhSemxWVm0xb1JGWldXbUZrUjFaSFYyMTRVMkpIZHpG
V2EyUXdZekpHYzFOdVVtaFNlbXhXVm1wT1QwMHhjRlpYYlVaclVqQTFSMXBG
V2xOVWJGcFZWbXR3VjJKVVJYZFpWRVpyVTBaT2NscEhjRlJTVlhCWlZrWldZ
V1F4VGtkVmJGWlRZbFZhY1ZadGRHRk5SbFowWlVaT1ZXSlZXVEpWYkZKSFZq
RmFSbUl6WkZkaGExcG9WakJhVDJOdFNrZFRiV3hUVFcxb1dsWXhaRFJpTWts
M1RVaG9XR0pIVWxsWmJGWmhZMnhXYzFWclpGaGlSM1F6VjJ0U1UxWnJNWEpq
Uld4aFUwaENTRlpxU2tabFZsWlpXa1p3VjFKV2NIbFdWRUpoVkRKT2MyTkZh
R3BTYkVwVVZteG9RMWRzV25KWGJHUm9UVlpXTlZaWE5VOWhiRXAwVld4c1dt
SkdXbWhaTVZwelkyeGtkRkp0ZUZkaVZrbzFWbXBKTVdFeFdYZE5WVlpUWVRG
d1YxbHJXa3RTUmxweFVWaG9hMVpzV2pGV01uaGhZVWRGZUdOR2JGaGhNVnBv
VmtSS1QyUkdUbkphUmxKcFZqTm9XVlpYY0U5aU1XUkhWMjVTVGxOSFVuTlZh
a0p6VGtaVmVXUkhkR2hXYXpWSFZqSjRVMWR0U2toaFJsSlhUVlp3V0ZreFdr
dGpiVkpIVld4a2FWSnRPVE5XTW5oWFlqSkZlRmRZWkU1V1ZscFVXVlJHZDFk
R2JISmFSemxxWWtad2VGVXlkR0ZpUmxwelYyeHdXR0V4Y0hKWlZXUkdaVWRP
UjJGR2FHbFNia0p2Vm10U1MxUXlVa2RUYmtwb1VqSm9WRmxZY0ZkbGJHUlla
VWM1YVUxWFVraFdNalZUVkd4T1NHRkdRbFppVkVVd1ZtcEdVMVp0UmtoUFZt
aFRUVWhDU2xac1pEUmpNV1IwVTJ0b2FGSnNTbGhVVlZwM1ZrWmFjVkp0ZEd0
U2EzQXdXbFZhYTJGWFJYZGpSV3hYWWxoQ1MxcFZWWGhTTVdSellVWlNhRTFz
U25oV1YzUlhXVlpaZUZkdVJsVmlWR3h6V1d0YWQyVkdWWGxrUjNSb1lsVndW
MVp0Y0dGWGJGcFhZMGhLV2xaWFVrZGFWV1JQVWpKR1IyRkhiRk5pYTBwMlZt
MTBVMU14VVhsVmEyUlZZbXR3YUZWdGVFdGpSbHB4VkcwNVYxWnNjRWhYVkU1
dllWVXhXRlZ1Y0ZkTlYyaDJWakJrUzFkV1ZuSlBWbHBwVmtWVmQxWnFRbUZa
Vm1SSVZXdG9hMUp0YUZSWmJGcExVMnhrVjFadFJtcE5WMUl3VlRKMGIyRkdT
bk5UYkdoVlZteHdNMVl3V25KbFJtUnlaRWR3YVZacmNFbFdiR1EwWVRKR1dG
SllaR3BTVjNoWVdXeG9RMVJHVW5KYVJWcHNWbXR3ZVZkcldtOWhWMFkyVm01
b1YxWkZTblpWVkVaelZqSktSMkZIY0d4aE1YQjRWMWQwWVdReVZrZFdibEpP
VmxkU1YxUlhkSGRXTVd4eVZXMUdXRkl3VmpSWk1GSlBWMnhhV0ZWclpHRldN
MmhJV1RJeFMxSXlSa2RoUmxKVFZsaENTMVp0TVRCVk1VMTRWbGhvV0ZkSGFH
aFZNRnBoVm14c2NsZHJkR3BTYkhCNFZrY3dOVll4V25OalJXaFhWak5SZDFs
V1ZYaFhSbFp6WVVaa1RsWXlhREpXTVZwaFV6RktjMVJ1VWxCV2JGcFlWRlJH
UzA1c1draGtSMFpYVFdzeE5WVnRkRzlWUmxwMFZXNUNWMkpIYUVSVk1uaGhZ
ekZ3UlZWdGNFNVdNVWwzVmxSS01HSXlSa2RUYms1VVlrZG9WbFpzV25kTk1W
cHlWMjFHYWxacmNERlhhMXBQVkd4YWNtTkVWbGRTTTJob1ZrUktSMVl4Y0Va
YVJrNW9Za2hDV1ZkWGVGTlNhekZIVjJ4V1UySklRbk5WYlRGVFYyeGtjbFpV
UmxkTlZuQjZXVEJhVjFkR1dYcFZia3BYVmtWYWVsWnFSbGRqTVdSellVZHNh
VlpyY0RWV01XUXdXVmROZDAxSWFHRlRSWEJZV1ZkMFMxWXhVbFpWYTJSWVZt
eHdXVmt3Vm10V01ERkZVbXBHV2xaWGFFeFdha3BIWTJ4a2NtVkdaR2hoTTBK
UlZsUkNWazVXV1hoalJXaG9VakpvVDFVd1ZrdE5iRnAwVFZSQ1ZrMVZNVFJX
YkdodlYwWmtTR0ZHYUZwaVdHaG9WbXBHYzJNeVJrWlViR1JUWWxob05WWnRN
REZoTVZsNFYyNU9hbEpGU21oV2JHUk9UVlphV0dNemFGaFNiRm94V1RCYWEx
UnRSbk5YYkZaWFlUSlJNRlpFUms5VFJrcHlXa1pLYVZKdVFuZFdha0poVXpB
MWMxZHJaRlpoTWxKWFZGWmFkMDFHVm5Sa1J6bFdVbXh3TUZaWE5VTldiVVp5
VjJ0NFZrMXVhSEpXYWtaaFpFWktjMWRyTlZkaVdHTjRWbXhrTkdJeVRYaFhi
azVZWVRGd1ZWbHJaRzlYUm14WVkzcEdhMkpIZUZkV01qRkhZV3hhY21OSWNG
aGhNWEIyVm1wS1MyTnNUbkppUm1SWFlsWkZkMVl4V21GWGJWWkhWRzVLV0dK
Rk5WaFZiRnBXVGxFOVBRPT0=" target="_top">cheesycarrion</a>
posted by cheesycarrion
updates
I have a bunch of stuff to do to the site but I can't do it until I get a new ethernet cable because a capybara chomped apart my old one and now I can only use my laptop (because it's wireless.) anyway, there are a lot of things I want to do, so I'll list some of them here:
- modifications to stylesheet
--- glitched space under forms in browsers other than firefox
--- make sidebar more like a floating window thing
--- rounded edge at bottom of page (inverted version of the top right under the tabs)
--- rounded breadcrumb edges
- modifications to layout / html
--- breadcrumb in main sections (possibly)
--- breadcrumb included at bottom of forum.php?op=view_thread so you can go back to the forum after reading all posts without having to move up to the top left corner.
--- comments page for user profiles
--- add news article button for moderators on homepage / script.php?id=news_view
--- something cool on the homepage because it's pretty bland right now
- make games/videos wider when using detach stylesheet
- automatically make comments page when moderator uploading new content
- new features:
--- register page
- add ALL games and videos from cc08 and cc07!!! (I just noticed that cc08 didn't even have all the cc07 games and videos, and cc09 doesn't have all the ones from cc08, and there are some really good ones back there (as proven by the site statistics that show that the most visited page is media.php?page=games from cc07.
posted by cheesycarrion
Jump to page
1 2 3 4 previous page next page
© copyright 2008 - 2010 www.cheesycarrion.com, www.arbitrarycitizen.com