Raised This Month: $51 Target: $400
 12% 

How to make this use SQL?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
jonnzus
Epic Member
Join Date: Oct 2010
Location: Finland
Old 04-06-2012 , 06:16   How to make this use SQL?
Reply With Quote #1

Hi, how to make this plugin to use SQL? I asked it in HS master topic 2 or 3 days later, but no one has anwered and I really need to know

It is just this
#if defined USING_SQL
to this
#defined USING_SQL
Attached Files
File Type: sma Get Plugin or Get Source (hs_master (2).sma - 517 views - 13.9 KB)
__________________
Quote:
367. Everyone's copyright will be broken. No exceptions.
jonnzus is offline
striker07
Veteran Member
Join Date: Mar 2012
Location: Solar System/Earth/Belgi
Old 04-06-2012 , 06:55   Re: How to make this use SQL?
Reply With Quote #2

on line 22 ====>
PHP Code:
// Uncomment for SQL version
//#define USING_SQL
// just uncomment it so it looks like this
#define USING_SQL 
then you will have to fill in your database pw and stuff

Last edited by striker07; 04-06-2012 at 06:56.
striker07 is offline
jonnzus
Epic Member
Join Date: Oct 2010
Location: Finland
Old 04-06-2012 , 09:42   Re: How to make this use SQL?
Reply With Quote #3

Quote:
Originally Posted by striker07 View Post
on line 22 ====>
PHP Code:
// Uncomment for SQL version
//#define USING_SQL
// just uncomment it so it looks like this
#define USING_SQL 
then you will have to fill in your database pw and stuff
Oh thank you Any idea why it doesnt still work well? :s
http://user430.web.gamehost.ee/Hs-Ma...master_sql.php
I cany still get player to there and hsmaster rank doesnt save well

in php file:

PHP Code:
//Data for MySQL access
$host "xxx";  //  MySQL database hostname
$user "user430";       //  login name
$dbank "user430";     //  database
$pw    "xxx";          //  password 
and in sma file:
PHP Code:
// Uncomment for SQL version
#define USING_SQL

   
register_cvar("amx_sql_host","xxx")      /* fill in your mysql access data */
   
register_cvar("amx_sql_user","user430")
   
register_cvar("amx_sql_pass","xxxl")
   
register_cvar("amx_sql_db","user430"
__________________
Quote:
367. Everyone's copyright will be broken. No exceptions.

Last edited by jonnzus; 04-06-2012 at 09:42.
jonnzus is offline
striker07
Veteran Member
Join Date: Mar 2012
Location: Solar System/Earth/Belgi
Old 04-06-2012 , 10:41   Re: How to make this use SQL?
Reply With Quote #4

i'm afraid i cant help you on that,
i never used mysql cous i dont fully know how it works and i have no expierence with php
striker07 is offline
jonnzus
Epic Member
Join Date: Oct 2010
Location: Finland
Old 04-10-2012 , 09:08   Re: How to make this use SQL?
Reply With Quote #5

Btw, there is that
Code:
   tableOLD = "hsmaster" /* table where the last week's ranking will be saved */
   table = "hsliste"   /* table where the ranking will be saved */
Does it make those tables automatically or have I use some what aldery exist?
__________________
Quote:
367. Everyone's copyright will be broken. No exceptions.
jonnzus is offline
vvg125
AMX Mod X Beta Tester
Join Date: Dec 2006
Location: Queens (Douglaston), New
Old 04-10-2012 , 11:37   Re: How to make this use SQL?
Reply With Quote #6

This is a bit of a long shot, but are you absolutely positive your information is correct? The plugin is scripted to create the tables if they don't exist, but make sure that your database actually exists and is named properly.
__________________
vvg125 is offline
Send a message via AIM to vvg125 Send a message via MSN to vvg125 Send a message via Yahoo to vvg125
jonnzus
Epic Member
Join Date: Oct 2010
Location: Finland
Old 04-10-2012 , 12:13   Re: How to make this use SQL?
Reply With Quote #7

Quote:
Originally Posted by vvg125 View Post
This is a bit of a long shot, but are you absolutely positive your information is correct? The plugin is scripted to create the tables if they don't exist, but make sure that your database actually exists and is named properly.
Db is exist, i have installed AMXBans there so i think i exist
__________________
Quote:
367. Everyone's copyright will be broken. No exceptions.
jonnzus is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 13:25.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode