AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Off-Topic (https://forums.alliedmods.net/forumdisplay.php?f=15)
-   -   How to make this use SQL? (https://forums.alliedmods.net/showthread.php?t=182082)

jonnzus 04-06-2012 06:16

How to make this use SQL?
 
1 Attachment(s)
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

striker07 04-06-2012 06:55

Re: How to make this use SQL?
 
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

jonnzus 04-06-2012 09:42

Re: How to make this use SQL?
 
Quote:

Originally Posted by striker07 (Post 1682827)
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"


striker07 04-06-2012 10:41

Re: How to make this use SQL?
 
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

jonnzus 04-10-2012 09:08

Re: How to make this use SQL?
 
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?

vvg125 04-10-2012 11:37

Re: How to make this use SQL?
 
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.

jonnzus 04-10-2012 12:13

Re: How to make this use SQL?
 
Quote:

Originally Posted by vvg125 (Post 1686109)
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:D


All times are GMT -4. The time now is 20:16.

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