akapsycho
Last Activity: Oct 9 '07, 05:32 PM
Joined: Aug 18 '07
Location:
-
Alright, cool. Thanks man. -
I don't think phpmyadmin lets you specify INT without a length does it?Leave a comment:
-
Yes/No?
Sorry i just want to get this right.Leave a comment:
-
Alright, MySQL it is then. Thanks. If anyone else has any input, I'd be more than happy to hear it!Leave a comment:
-
Data type for IP Address converted using INET_ATON()
Is it INT(10)? I've done some reading and found out that INET_ATON() should make my MySQL queries fastest, but I'm not sure which data type to store it as.
As far as I can tell, the maximum value should be: 255×256^3 + 255×256^2 + 255×256^1 + 255 = 4278190080 + 16711680 + 65280 + 255 = 4,294,967,295
Which means that the best (fastest) data type would be INT(10) UNSIGNED. Am I right? -
Do you know what phpmyadmin sets up by default? I would have thought that having the increased load of queries would slow down the database and possibly affect the other queries that need to be run.Leave a comment:
-
MySQL or flat file for user logs
I'm already using MySQL for most of my site but I just need a simple, non-dynamic log of every user's page visits while logged in to my site. My main concerns are disk space, the potential impact on server speed and the speed of other MySQL requests and the increased load on the processor.
I haven't tried to do this either way but read a pretty comprehensive tutorial on a flat file log system. These logs could just be downloaded on... -
Cool, thanks a lot for this!Leave a comment:
-
Alright cool, I'll just stop messing with it then lol. Thanks again!Leave a comment:
-
Alright cool, I think I'll go for truncate. If I truncate it, it will recreate all of the fields for me right? It would be a pain to have to do that for 6 tables each time I clear the database. Thanks!Leave a comment:
-
How to reset AUTO_INCREMENT in MySQL
I've got an index field which stores id numbers which are created by auto_incrementi ng and assigning that value as the id. ive already emptied out the values a few times since I'm testing, but I can't seem to figure out how to reset a field set to auto_increment, so that the next time someone registers an account, their ID will be set to 1 and it will rise from then forward. -
No, mine looks slightly different. I can't find my Photoshop serial right now so I'm not going to install it just to upload the picture. I did figure out though that when I zoom in or out, it looks the same as the rest of the text, so maybe it just has something to do with my resolution. I'll just let it be, since nobody else seems to see anything wrong with it.Leave a comment:
-
Thanks again man, you'll definitely see me coming back for more help lol.Leave a comment:
-
It can't just be me.
check out the homepage without logging in: on the right it says "Don't have an account? Register here." The lowercase "e" in the word "Register" looks different than the lowercase "e" in the word "here".
Am I crazy?Leave a comment:
-
Thanks a lot pbmods. I've been pleasantly surprised by how constructive this forum is and I'll be sure to look around if I can find anyone who I can help. Thanks for everyone's help again!Leave a comment:
-
alright great, sounds cool. ive rethought the table and i think that im only really going to need 1 row with about a half dozen columns. i just need to store a single value that's going to be updated. in case anyone's interested, i'm going to try to make a cron jobs replacement since my host doesn't support them.
I'm going to use time() to initially store seconds since 1970 in my sql database, then each time a page is accessed, run...Leave a comment:
-
can you have a table without an index?
I'm just trying to make a small table to make up something as an alternative to cron jobs, which my host doesn't support. I have other indexed tables in the database, but this is a table where I expect something like maybe 10-20 rows and only 4-5 columns. Should that work without an index? -
ARGH got it...I was using $_SESSION['id'] instead of the target's id...man I feel dumb right now...thanks for all of your helpLeave a comment:
-
Another thing i've noticed is that when I add another function I made to retrieve data,
[code=php]echo getValueUSER("h ealth", "userdata", "$targetnam e");[/code] it gives me the correct value for health after the attack. that means it must be getting reset somewhere...Leave a comment:
-
Alright well it first gave me:
[code=mysql]
"UPDATE userdata SET health = 80 WHERE username = 'reallylongname hi'"[/code]
and then it told me that username was invalid, which it was, so i set that to user.
now it gives me:
[code=mysql]
"UPDATE userdata SET health = 40 WHERE user = 'reallylongname hi'"[/code]
without an error. Still doesn't update the entry...Leave a comment:
No activity results to display
Leave a comment: