| blackops7799 |
10-29-2006 01:44 |
Re: Not adding people to the SQL
Quote:
Originally Posted by slmclarengt
(Post 396613)
From reading this code, my conclusion is that you are telling the computer the user is NOT in the database , then you get their info. then check the SQL database for their info., then if they DON'T exist, I guess it adds them. A description for what this SHOULD do would be helpful.
Also, make sure your database actually exists and the computer is connecting to it. (Check your logs and/or add debug messages to your code).
Slmclarengt
|
Yes, that is exactly ehat im trying to do. I know its connecting to the database because if i make the code like this
Code:
public client_putinserver(id)
{
moanon[id] = 0
if(dbc == SQL_FAILED)
{
return PLUGIN_HANDLED;
}
new indatabase = 0
new query[256], authid[32], model[33];
get_user_authid(id,authid,31);
get_user_info(id,"model",model,32);
format(query,255, "SELECT level,xp,JobID FROM users WHERE steamid='%s'", authid);
result = dbi_query(dbc,"%s",query);
if(dbi_nextrow(result) > 0)
{
level[id] = dbi_field(result,1);
xp[id] = dbi_field(result,2);
JobID3[id] = dbi_field(result,3);
indatabase = 1;
}
dbi_free_result(result);
if(indatabase == 0)
{
format(query,255,"INSERT INTO users (steamid,level,xp) VALUES('%s', '1', '0')",authid);
dbi_query(dbc,"%s",query);
insertmoney(id)
return PLUGIN_HANDLED
}
return PLUGIN_HANDLED;
}
public insertmoney(id) {
new indatabase = 0
new query[256], authid[32], model[33];
get_user_authid(id,authid,31);
get_user_info(id,"model",model,32);
format(query,255, "SELECT money FROM money WHERE steamid='%s'", authid);
result = dbi_query(dbc,"%s",query);
if(dbi_nextrow(result) > 0)
{
indatabase = 1;
}
dbi_free_result(result);
if(indatabase == 0)
{
format(query,255,"INSERT INTO money (steamid,money) VALUES('%s', '500')",authid)
dbi_query(dbc,"%s",query);
insertpowerup(id)
return PLUGIN_HANDLED
}
return PLUGIN_HANDLED;
}
public insertpowerup(id) {
new indatabase = 0
new query[256], authid[32], model[33];
get_user_authid(id,authid,31);
get_user_info(id,"model",model,32);
format(query,255, "SELECT regen,vampire,armor,ammoregen FROM powerup WHERE steamid='%s'", authid);
result = dbi_query(dbc,"%s",query);
if(dbi_nextrow(result) > 0)
{
indatabase = 1;
}
dbi_free_result(result);
if(indatabase == 0)
{
format(query,255,"INSERT INTO powerup (steamid,regen,vampire,armor,ammoregen) VALUES('%s', '0', '0', '0', '0')",authid)
dbi_query(dbc,"%s",query);
return PLUGIN_HANDLED
}
return PLUGIN_HANDLED;
}
it works fine... So ill just keep it like this for now.
|