[Phpmyadmin-devel] proposition for donation (hardware key)

[Sebastian Mendel]

Marc Delisle schrieb:
> Sebastian Mendel a écrit :
>> Marc Delisle schrieb:
>>> Sebastian Mendel a écrit :
>>>> Marc Delisle schrieb:
>>>>> Sebastian Mendel a écrit :
>>>>>> Marc Delisle schrieb:
>>>>>>> Hi,
>>>>>>>
>>>>>>> Because they did not get investment funds yet, here is what they 
>>>>>>> propose:
>>>>>>>
>>>>>>> They would give us 1$ for the first 1000 buyers of the hardware 
>>>>>>> key that  used the promotional code "PMA" to buy it. Also, they 
>>>>>>> would make a donation as soon as they get funds from an investor.
>>>>>>>
>>>>>>> The problem I have with this proposition, is that, I assume we 
>>>>>>> would have to do the publicity of this promotional code on our 
>>>>>>> web site, which is not permitted because we are hosted on sf.net
>>>>>>>
>>>>>>> Comments?
>>>>>>
>>>>>> why only the first 1.000?
>>>>>>
>>>>>> at least a lower amount could be granted for every one after the 
>>>>>> first 1.000
>>>>>>
>>>>>
>>>>> Here is, I think, the problem. I forgot to tell you that they plan 
>>>>> to sell the device for, say, 10$, but charge an annual activation 
>>>>> fee of 1$ per key.
>>>>>
>>>>> What they offered is the opportunity for the first 1000 buyers with 
>>>>> the promo code PMA to avoid the annual fees (obtain lifetime 
>>>>> activation), so I doubt they would give lifetime activation for 
>>>>> more than 1000 buyers. Remember that the promo code has to give 
>>>>> somethink to the buyer, not just to the PMA team.
>>>>
>>>> Why? isn't supporting the PMA team not enough for the buyer? ;-)
>>>>
>>>>
>>>>> Any counter-proposal? :) For me I think that it's ok like that.
>>>>
>>>> once added the link, they will profit from this link forever, you 
>>>> are not gonna purge any evidence of this link after first 1000 
>>>> buyers, or?
>>>
>>> I don't know...
>>>
>>> Here is a counter-proposal I could tell them: leave the promo code 
>>> PMA forever, but for 1001th buyer and more, give some discount to the 
>>> buyer and give us 0.50$, OK?
>>
>> i am not sure about the amount, it could also be less than 0,50$, or 
>> without discount to the buyer, this is up to you
> 
> I'll ask him about this.
> 
>>
>> it is just, once included the link in the release note it would get 
>> spreaded 10.000 time a day, added to the news it would be read ... ähm 
>> ... how are the stats of phpmyadmin.net?
> 
> These would be available on sf.net on our project's stats page?
> 
>>
>>
>> in fact: we gain NOTHING when adding their code to our sources, but 
>> they gain lot of attention! or?
> 
> Well, I think that it's some gain for phpMyAdmin to support a new 
> feature, even if this new feature takes the form of a hardware auth key.
> 
>>
>>
>> just to clarify: i am not against adding such code and placing links 
>> to commercial sites - if phpMyAdmin (team) gets adequate compensation
>>
>>
>> btw. would be nice if we track the clickrate by ourself, just for 
>> knowing how much people following such links, so place 
>> phpmyadmin.net/swekey instead of store.swekey.com into news and 
>> release notes ... if not already planned ... and to have the option 
>> (why ever) to disable this link
> 
> Good idea to use phpmyadmin.net/swekey. Any volunteer to program the 
> tracking? :)


/**
  * CREATE TABLE `test`.`swekey_logging` (
  * `id` SERIAL,
  * `time` DATETIME NOT NULL ,
  * `referer` VARCHAR(255) NOT NULL
  * ) ENGINE = MYISAM
  */
$sql = "
     INSERT INTO `swekey_logging`
     SET `referer` = '" . $mysqli->escape($_SERVER['referer']) . "',
         `time`    = NOW()";
$mysqli = mysqli_connect('...');
$mysqli->query($sql);

// or
$line = time() . ';' . $_SERVER['referer'] . "\n";
file_put_contents('swekey_log.txt', $line, FILE_APPEND);

header('Location: http://store.swekey.com/index.php?promo=pma');

// or page with extra info and link

-- 
Sebastian Mendel