Im working on ways to save more information for a link; eg:
I have set a new field "HitIn" for a link.
Now i have modiefied the rate.cgi to set Votes, Rates AND HitsIn. The build.cgi must be modified too in build_update_counters. A new Tag for Links.html shows the HitsIn. No problem so far and i have the goal reached that every rating makes a hit in.
Now i copied the rate.cgi to hitin.cgi and make a new table HitIn_Track for that. Why: If someone calls now the hitit.cgi, it does the same than the rate.cgi, but dont update Rates or Votes, but only HitIn. Step1: Add an entree to HitIn_Track; then to table Build_Update. The next time i build i got the HitIn to the table link. All fine so far, too.
But now my problem:
the table Rate_Track shows with phpMyAdmin:
lndx Yes LinkID
lndx Yes IP
cndx No Created
My new table HitIn_Track shows:
LinkID Ja LinkID
IP Ja IP
Created Nein Created
But this means, that an ID cant hit two times, cause the field is unique! So it must be something with the lndx or cndx; but there seems really no way to set my fields to that names. What is that? How could i get this to work?
If i kill these (or dont klick at unique, index ...) it runs, but i think Alex would think something if he had done this like it is.
Hope some SQL-people are around, too.
Robert
I have set a new field "HitIn" for a link.
Now i have modiefied the rate.cgi to set Votes, Rates AND HitsIn. The build.cgi must be modified too in build_update_counters. A new Tag for Links.html shows the HitsIn. No problem so far and i have the goal reached that every rating makes a hit in.
Now i copied the rate.cgi to hitin.cgi and make a new table HitIn_Track for that. Why: If someone calls now the hitit.cgi, it does the same than the rate.cgi, but dont update Rates or Votes, but only HitIn. Step1: Add an entree to HitIn_Track; then to table Build_Update. The next time i build i got the HitIn to the table link. All fine so far, too.
But now my problem:
the table Rate_Track shows with phpMyAdmin:
lndx Yes LinkID
lndx Yes IP
cndx No Created
My new table HitIn_Track shows:
LinkID Ja LinkID
IP Ja IP
Created Nein Created
But this means, that an ID cant hit two times, cause the field is unique! So it must be something with the lndx or cndx; but there seems really no way to set my fields to that names. What is that? How could i get this to work?
If i kill these (or dont klick at unique, index ...) it runs, but i think Alex would think something if he had done this like it is.
Hope some SQL-people are around, too.
Robert