SirChick

Why does the clothes have to have php freak mentioned on it just have unique designs made using fractals made in php or sumin

This is aimed at precisely that =/ Their integrity doesn't go up.. it stays put... but won't go down... again nothing to gain by posting a dumb question to keep integrity where it already was lol this is why its sitll not abuseable in that sense either.

Um .. youve again missed the whole idea.. by saying rep your thinking the karma system again totally wrong idea again. There is no benefit to the person who approved or who made the topic.. so to ask for approval... is pointless.

Where can it be abused then ?

Comparing this to the Karma feature suggests there is a misunderstanding along the line as theres no comparison there not similiar at all..the failure of the karma feature is because its a poor idea anyway. If some one approves the answer... some one can equally decline the answer when a better answer has been made..If your worried people will use phpfreaks as a google for PHP etc then don't edit the search feature for it... I still see no way this can be abused its not possible to abuse it to the point it becomes a useless feature, other than people approving answers that are not good answers for fun of it, but any one can remove that approval include the OP, if they feel the answer was useless or a better reply has occured so they can approve a different answer. Plus if the topic is solved helpers don't need to view it again and the integrity is not lost so what ever is approved in there is irrelevant. Sure some one might post better answers to the initial approved, but most people will check that if they have common sense which is needed to be a coder If they don't then they only loose out but some one else who needs to search for answers will read the extra replies for help. Its hard to really explain all this without being able to visualise how it cannot be abused but i think my better option is to code a dummy forum with it in place for you to fiddle (this will take a while to sort)

Heres a screen mock up of what is seen for the approves for example and what i seen for the OP who has not yet topic solved... i think its easy to see that it cannot be missed... [attachment deleted by admin]

Good points raised, but the one key point is where people are volunteering (for free) to help users who have questions. It would be nice to have something to help make it easier for them. Which would be the topic solved option as then your not clicking threads to check if its been answered or not, equally on other extra help this would lower un-needed page loads on php freaks server, hopefully reducing the amount of work the server has to do and keeps the site fast. Though the server thing is just a bonus and not as important Agree the Topic Solved is hard to find, but thats because its not exactly easy to spot anyway unless you've been on here a while. So it could be moved to a different part of the thread for making it easier to find. As for a approval etc it shouldn't be too difficult to spot if its under the username and post count on the left hand side. The manual is always good to use but not 100% always! If that were the case there would be no need for PHPfreaks in the first place..such as a logical error no manual can tell you where you made the logical mistake and when such a problem occurs usually a human response is much better to help spot the mistake of whom has more experience, which is where PHPfreaks is handy.

Cheers for that! Thanks for the help guys!

Well its irrelevant to how many helpful replies there are, there can be 100 good given responses, as long as theres one approved answer that people have rated....of which the users know has answered the question, but the user decides not to topic solved.. then the integrity goes down. So its not integrity subtract total approvals in each thread. Heres a good understanding: So say a user made 3 threads 2 with approved answers unsolved, and 3 solved. Integrity subtract (total threads with at least 1 approved answer or more that has not been topic solved) Which in the above case is a subtraction total of 2... say you start off with 50 integrity and now you have 48 unless you click solved then it goes back up to 50. And you can go into the negative like karma features do. It can't be abused because its up to the thread started to click topic solved at end of the day...once they do, their integrity is back Karma systems are rubbish as every one gives negative for fun sake.. where as rather than it being decided by users choice, its your own choice to make it negative, by not clicking topic solved. Additionally a simple list of topics with approved answers "unsolved" by the user could be avaiable to them as quick access to solve them if they had forgotten to and could not find the thread anymore. Users over 500 posts can decide if a reply is helpful and approve. And equally users over 500 posts can remove that approval, if they disagree that it answered the question. It could have some thing on the side column in the forums where the username shows etc: (with a scroll bar) the approval logs: Username approves this answer (now a topic solved should be set or integrity is lowered) Username2 does not agree (either OP or some other member who has a better result) - (now integrity is not effected as its there is no approved answers yet) In this case it wouldn't matter how " many " quality replies there are, as long as theres at least one. Then it lies on the OP to either Topic Solved or decline the approved answer to spare their integrity (for example some new error occured from the answer provided, etc, at which point the user who posted that answer could be alerted (if they have alerts on to take another look at the thread if they wish to continue helping that user) Equally a user cannot approve their own message answer. They can only approve others, but they can remove an approval of their post if they spotted their own mistake Unlimited amount of users can approve the same answer once,...but to worry about integrity, as long as theres one thats all that is needed. Which ties into my next idea related: Additionally with this... the total number of approvals to an answer.. could help with the PHP search feature.. by having topics with higher number of approval responses based on what is asked will come out on top, improving likely hood of finding topics with already well answered questions to the issue the user is searching on. Yes with people messing about is always possible, but as its stored on the side column, they can fiddle then not be disallowed in support areas and loose the amazing FREE and very quick help phpfreaks provide.. 10,000 high intergrity coders on a forum beats 50,000 not so high integrity coders hands down. It might be extra effort on peoples part but for that effort they are only helping themselves on faster replies from users giving their time to help for free, and if they are a helper themself they are helping themself too to see which threads need answers. p.s i have used this idea on my own forum for a different thing...not quite so in depth as this idea (wish i had now) so ill probably add more to my current script. And 95% of the time people don't abuse it. Obviously the 5% do but then they loose the support because we don't let them view it.

Just a simple one really In support forums, i think people who post a helpful reply that solves some one's issue, some other obser can click that post as "Helpful Response". Then to rank users by integrity or some other word, you can then do total number of threads made by a user oh whom had a helpful response but didnt click "topic solved". The more helpful responses in threads to topic solved the lower your rank goes... so simple is, to keep a good integrity is click topic solved when some one has helped you... And of course people are more likely to help people with high integrity, additionally if you have super high integrity over a certain level your post could stand out more in the support. All to increase the ease of use for people helping people out.... i hate going into a topic 2 pages long when its been solved but no one ticked the topic solved so i wasted my time reading the tread. Thoughts?

Well if theres only one row in the table and it returns 2 means your 2nd out of one entry which is illogical in rank aspects..so if i removed the plus 1 ? Wouldn't that make the positions correct ?

bump

Hmm with only one row in the database it retuns "2" which is not making sense for me... This is the table: name | Rank | ID Dave | 1000 | 14 <?php function position($Field,$ID){ $Get = mysql_query("SELECT COUNT(t1.$Field) + 1 AS position FROM listings t1 LEFT OUTER JOIN listings t2 ON t1.$Field < t2.$Field WHERE t1.ID = '$ID'") Or die(mysql_error()); $row = mysql_fetch_assoc($Get); Echo $row['position']; } //query to get ID etc etc //row fetch assoc $ID = $row['ID']; Echo position('Rank',$ID).'<br>'; ?> The returned result is : 2 But theres only one row in the table ?

Im confused on why there is a + 1 and the left outer join when there is only one table in this situation ?

Hey i am wondering if some thing like the below is possible and how it is achieved, as im having difficults of trying to find an efficient way to do this. Imagine a table of names and numbers in order: What im trying to do is make a query to sort them firstly in order by the numbers ( I can do this by ORDER BY DESC simple enough) once this is done the names should be in place: With this sorted, im trying to return from the query only the position they came out the list.. so for example if i queried for Sarah it would reply with "3" or Dave it would reply "1". What can i do to achieve this in MYSQL?