Comfy Café #2

:bean

 

I broke its login trying to do something I dnt remember:wtf1. I had expected me and filoo and coup will play risk and other DN skype group ppl would be able to host DN there. They lost interest so I did not bother to fix it.
did you make that random gets happen?

 

I had solved it writing simple trigger that embeds a random value into the post. if you are familiar with MySQL triggers that is easy. No need to make another table or attribute store it as it gets stored with post itself. Making a DB would take lot of efforts but you could give other features with it I guess linking all the random rolls user gotten with the userid.

 

They may never play risk considering much people were not interested so it gets all waste or just **** up badly for nothing. :geg I am not sure if it would be wise to safe thing to tweak with DB schema of site big like this.
If you want to it is database thing , it is independent of forum software. I Just had to find which table in the db stores user's post and add before insert to append random roll.

Show Spoiler Hide Spoiler

PHP:


         -- mysql trigger to add random number for esotalk
         -- `et_post` is table where post is stored on esotalk
         -- the content attribute has the users posts
         -- the random number get concatanated with that content at the end
         -- since it will be always at the end at the server side the user cant cheat by adding his own
         DELIMITER  $$
         CREATE  TRIGGER addroll
         BEFORE INSERT ON et_post
         FOR EACH ROW
        BEGIN
                DECLARE randNum INT;
                SET randNum = FLOOR(111111+RAND()*(111111-999999));
                SET NEW.content=CONCAT(NEW.content, ' yourrollis:', randNum);
                -- there needs to be newline added after content
        END; $$
        DELIMITER ;



 

No PHP. You can make the DB itself do the stuff. But nvm if you dont know about triggers. It's syntax is weird and changes from one version of SQL to other. sydie

 

So where's Dannie?

 

@Dannie will come when he gets tired of NB. urr/

 

Yes I came just because so

 

Have you checked out the Arcade here ?