Your Ad Here Your Ad Here
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Simple Poll Script

  1. #1
    ok i want to install a Simple Poll script but in the readme
    it says
    "Paste the contents into a tool that can execute SQL commands for your MySQL DB"

    What tool can execute SQL commands to your MySQL DB? :helpsmile:

    Klite Clan : <span style='color:purple'> [ThE_Def-EndERS]</span>
    [Clan Site]

  2. Internet, Programming and Graphics   -   #2
    any1 know

    Klite Clan : <span style='color:purple'> [ThE_Def-EndERS]</span>
    [Clan Site]

  3. Internet, Programming and Graphics   -   #3
    h1
    Guest
    Post the script or a link to it here.

  4. Internet, Programming and Graphics   -   #4

    Klite Clan : <span style='color:purple'> [ThE_Def-EndERS]</span>
    [Clan Site]

  5. Internet, Programming and Graphics   -   #5
    h1
    Guest
    The easiest way would be to install phpMyAdmin on your server and run the following queries:
    Code:
    DROP TABLE IF EXISTS `poll`;
    CREATE TABLE `poll` &#40;
     &nbsp;`id` int&#40;11&#41; NOT NULL auto_increment,
     &nbsp;`name` varchar&#40;50&#41; default NULL,
     &nbsp;`question` varchar&#40;255&#41; default NULL,
     &nbsp;`bgcolor` varchar&#40;20&#41; default NULL,
     &nbsp;`fontsize` varchar&#40;10&#41; default NULL,
     &nbsp;`font` varchar&#40;50&#41; default NULL,
     &nbsp;`fontcolor` varchar&#40;20&#41; default NULL,
     &nbsp;`orientation` varchar&#40;100&#41; default NULL,
     &nbsp;`tbgcolor` varchar&#40;20&#41; default NULL,
     &nbsp;`tfontsize` varchar&#40;10&#41; default NULL,
     &nbsp;`tfontcolor` varchar&#40;20&#41; default NULL,
     &nbsp;`tfont` varchar&#40;50&#41; default NULL,
     &nbsp;`votes` int&#40;11&#41; default &#39;0&#39;,
     &nbsp;PRIMARY KEY &nbsp;&#40;`id`&#41;
    &#41; TYPE=MyISAM COMMENT=&#39;Simple Poll&#39;;
    Code:
    DROP TABLE IF EXISTS `choices`;
    CREATE TABLE `choices` &#40;
     &nbsp;`id` int&#40;11&#41; NOT NULL auto_increment,
     &nbsp;`pollid` int&#40;11&#41; NOT NULL default &#39;0&#39;,
     &nbsp;`choice` varchar&#40;255&#41; default NULL,
     &nbsp;`barcolor` varchar&#40;20&#41; default NULL,
     &nbsp;`votes` int&#40;11&#41; default &#39;0&#39;,
     &nbsp;PRIMARY KEY &nbsp;&#40;`id`&#41;,
     &nbsp;KEY `pollid` &#40;`pollid`&#41;
    &#41; TYPE=MyISAM COMMENT=&#39;Simple Poll&#39;;
    Open up admin/config.inc and change the values to reflect your server and database.
    Code:
    &#60;?
    define&#40;hostname,&#34;localhost&#34;&#41;; &nbsp;// mysql server host name
    define&#40;dbname,&#34;FreePhpNet&#34;&#41;; &nbsp; // mysql database name
    define&#40;username,&#34;&#34;&#41;; // mysql user name
    define&#40;password,&#34;&#34;&#41;; // mysql password
    define&#40;templatedir,&#34;/home/public_html/simplepoll/templates/&#34;&#41;; // directory where templates are located &#40;must end foward slash&#41;
    define&#40;simplepollurl,&#34;/simplepoll/&#34;&#41;; // url to the script main directory &#40;must end foward slash&#41;
    ?&#62;
    (Apache servers only from now on) To limit access to your admin directory, create a file called .htaccess and put in the poll&#39;s directory:
    Code:
    AuthUserFile /home/public_html/simplepoll/.htpasswd
    AuthGroupFile /dev/null
    AuthName Simple Poll
    AuthType Basic
    require valid-user
    Then, create a file called .htpasswd with the contents in the following format:
    Code:
    username&#58;hash_of_password
    For example, if your username is "toco004" and your password is "foo," it would look like this:
    Code:
    toco004&#58;38KOjZwqQSySc
    If you wanted another person named "haxor41789" to access it with the password "bar," it would look like this:
    Code:
    toco004&#58;38KOjZwqQSySc
    haxor41789&#58;335Bm7iLPDgIs
    Here is a tool for creating .htpasswd usernames and passwords.

    Hope this helps.

  6. Internet, Programming and Graphics   -   #6
    thanks so much haxor41789

    Klite Clan : <span style='color:purple'> [ThE_Def-EndERS]</span>
    [Clan Site]

  7. Internet, Programming and Graphics   -   #7
    h1
    Guest
    NP.

  8. Internet, Programming and Graphics   -   #8
    how can i find my MySql username & password

    Klite Clan : <span style='color:purple'> [ThE_Def-EndERS]</span>
    [Clan Site]

  9. Internet, Programming and Graphics   -   #9
    h1
    Guest
    I can&#39;t tell you, you&#39;ll have to ask your host for that.

  10. Internet, Programming and Graphics   -   #10
    Mr. Blunt's Avatar n00b
    Join Date
    Jul 2003
    Location
    Central California
    Age
    28
    Posts
    1,200
    Originally posted by toco004@6 April 2004 - 19:55
    how can i find my MySql username & password
    First of all, does your host even provide you with MySQL?

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •